Open topic with left hand navigation

Updating Totals on the Cashflow Worksheet

When you choose to update the totals, Proliance updates the actual amounts and totals, but preserves the forecast amounts. This may result in variances for some lines in the worksheet if someone had manually changed the Total Invoice (Actual) amounts or changed the Estimate at Completion (EAC) value of a cost account. For more information about the EAC, see "Cost Account - Main". You will need to correct any variances in the worksheet before you can save the cashflow document.  

Updating the totals on the cashflow worksheet is one way to update the worksheet. The other way is to recalculate the entire worksheet. For more information, see "Recalculating the Cashflow Worksheet".

To update totals on the cashflow worksheet

  1. Open the Cashflow register.
  2. Select the cashflow document to recalculate.
  3. Click Worksheet .
  4. Click Edit.
  5. Click Update Total.
  6. Click OK to confirm.

    7. Proliance updates the Actual amounts, but leaves the Forecast amounts as is.

  7. Click Exit Edit Mode when done.

Tips:

  • If you want Proliance to correct any variances for you, simply recalculate the worksheet. Keep in mind that this will overwrite any changes that were manually made to the worksheet.
  • You will be able to save the worksheet as long as the variance is less than $1.00.