Open topic with left hand navigation

Cashflow - Worksheet

The Worksheet page of a cashflow document displays the effects of invoices and retainage for the cost periods and cost accounts specified on the Cashflow - Cost Accounts page. The cashflow worksheet displays the cost account line items, including Invoice (Actual and Forecast), Retainage (Actual, Forecast), and Retainage Release (Forecast). The Invoice (Actual) and Retainage (Actual) values are for display only and cannot be edited.

You can recalculate the worksheet only when the cashflow document is in the Draft or Pending states. The date and time of the last update is shown above the grid. All values shown on the worksheet are calculated in the workspace currency.

The cashflow document needs to be in edit mode before you can modify the columns or use any of the controls.

The following information is shown on this page:

• Advanced Code: The advanced code is displayed as per the advanced code selected in the Cost Account document. This field is not editable in the Cashflow document.
• Cost Account: Displays the title of the cost account. You can click this title to view detailed information about the cost account.

• Cashflow Item Type:Displays the item type of the cost account line item, which can be one of:
  • Invoice (Actual)
  • Invoice (Forecast)
  • Retainage (Actual)
  • Retainage (Forecast)
  • Retainage Release (Forecast)

  Note: Proliance displays the retainage item types only if retainage is included on the worksheet. To indicate the inclusion of retainage, select the "Include Retainage" check box in the Default Settings section of the Cashflow - Main page.

• Grouping Codes 1-10: Up to ten Grouping Codes are available based on the active codes in the Workspace Cost Settings document. All codes listed as active are display in the Cost Account grid. You can apply different codes in the Cashflow document, but you cannot edit the codes from this document.
• Period: One column is displayed for each workspace cost period defined for the workspace, even for those periods that have not been selected for a cost account. For more information, see "Creating a Workspace Period".
• Total Amt: The total for each item type for all the workspace cost periods. You cannot edit this total.
• Variance Amount: If you manually adjust the amount of any cost period for any cost account (forecast) line item, the variance column will display the difference between the actual amount and the total amount.

  You can save the worksheet only if the variance amount is less than $1.00.

  The Variance Amt column only appears while the cashflow document is in the edit mode.

  For more information, see "Cashflow Calculation - Variance".

The Grand Total row at the bottom of the grid displays the sum total of the amount in each column.

The following table summarizes the controls available for the cashflow worksheet while in edit mode.