Cashflow Calculation - Variance

You can manually update the forecast amounts on the cashflow worksheet. The only restriction that Proliance enforces is that the total amount after editing must be the same as the total amount before editing. The variance is the difference between the two totals.

Proliance calculates the variance as follows:

Sum of cost periods per cost account line item – Total sum of cost periods per cost account line item

When you recalculate the worksheet, Proliance ensures that all line items balance, with no variance. If you introduce a variance by editing the forecast amounts afterwards, you must either correct the values to return the variance to zero, or you must recalculate the worksheet before you can save the cashflow document.

ClosedExample

On the cashflow worksheet, the Total Amt for Line Item A is 10,000. A user edits a forecast value in a cost period so that the total of all cost periods now equals 12,000. This causes 2,000 to display in the Variance column.  

If the user then edits the cost period amounts to make the total of all the cost periods equal to 8,000, the Variance now becomes -2,000.