UniPhi allows phasing of costs across months. This can be done for Budgets, Contracts and Forecasts and is the starting point in developing a cash flow in UniPhi. UniPhi allows phasing to be done manually or automatically. To phase a budget, after ensuring the budget has been entered and saved, navigate to the Costs Module then select Manual Phasing from the sub-navigation menu.
Manual Phasing
There is a set of dropdown filters on the right hand side of the phasing screen.
Phase From = the selected month from which a 12 month period will be shown in order to phase.
Actuals to =
Cost Codes = the chart of account from which the budget and contract will be phased.
Depth = the chart of account level at which phasing will be done. Phasing can only be done at the lowest level. Also selectable is Contracts. The forecast can be hased against contracts, but not the budget.
Phase = All shows Budget and Actual/Forecast, or select either Act/Fcst or Budget to just view that information.
Unit = show the phasing as Currency or %
Currency = If your deployment is set up to handle multiple currencies, you can pick the relevant currency.
Tha ACT/Fcst lines and view show Actual costs for past months, where the month has been closed. For current and furture months Forecast data is shown. The closed onths with actual data are greyed out and cannot be edited. Firecast motnhs are white an dcan be edited. In the view below, actual costs are shown up to and including April 2020 and from May 2020 forecast data is show.
The buttons on this page have the following functions:
Copy Budget copies the phased budget data to the forecast. Note that if any of the data is in closed months, the budget values will nto overwrite the actuals values.
Re-baseline copies both phased actual and forecast data to the phased budget
This option appears when you check the selection boxes for the detail lines on the left of the screen. When used it will clear all phased data form the selected lines. In the Phase All view it clears budget and forecast data, but not actual data. In Phase Budget view it only clear phased budget data. In Phase Act/Fcst view it clears forecast data but not actual data.
Import allows you to paste budget and forecast data from Excel. See the section below on importing phasing for more informtion.
Save will save changes to the manual phasing data.
Input Manual Phasing
Phasing can be input directly in to the Manual Phasing view.
1. Filter for the project you wish to work on from the Projects filter
2. Go to the Costs module, then select Manual Phasing on the navigation bar
3. If not already shown, select the Cost Code you want to work in from the Cost Codes filter.
4. Select the month you want to start in in the Phase From data selector.
5. Select the other filters to show depth, phase view, unit and currency.
6. Enter the values in the cells as appropriate. In the example below, a budget of $1,000,000 has been phased manually across 12 months from May 2018.
7. Once the amounts have been entered, click Save.
Comments