Skip to main content

​
Purpose

Cash Flow Management provides a rolling direct-method cash forecast comparable to the management workbook: opening cash, categorized inflows and outflows, net cash movement, ending cash, and forecast-versus-actual monitoring.

​
Setup

Before creating a forecast, configure the fiscal year and periods, office base currency, and Cash Flow Class/Sub-Class mappings. Each sub-class must have the correct inflow/outflow type and operating, investing, or financing group. The generator first uses mappings assigned to the selected office (plus any global mappings). If none exist, it uses the head-office mappings as a shared template.

​
Workflow

  1. Create a Cash Flow Forecast for a fiscal year, scenario, and revision.
  2. Enter opening cash and the minimum cash balance used by the liquidity warning.
  3. Select Generate/Refresh Lines to create one line for every fiscal period and cash-flow sub-class configured for the office.
  4. Enter forecast amounts as positive values. The line’s inflow/outflow mapping controls its cash-flow sign.
  5. Select Refresh Actuals to aggregate posted daily journal details from BatchDT. Opening Cash Flow Report also refreshes actuals automatically.
  6. Use Cash Flow Report to review period, group, class, category, forecast, actual, variance, and monitoring status.
  7. Submit, approve, and lock the forecast when the review is complete.
Approved or Active lease contracts can synchronize their contractual base-currency payments into the selected Draft forecast. The refresh replaces only the Lease Schedule Component, preserving manual and other forecast sources.

​
Dashboard measures

The forecast header shows forecast and actual cash inflow/outflow, net movement, ending cash, ending-balance variance, and liquidity status. A forecast ending below the minimum cash balance is highlighted for attention.

​
Reporting conventions

  • Forecast and actual line amounts are stored and displayed as positive magnitudes.
  • Net cash flow is inflow less outflow.
  • Outflow variance is favorable when actual spending is below forecast.
  • Inflow variance is favorable when actual receipts exceed forecast.
  • Actuals come directly from posted BatchHD/BatchDT journal data. The database matches office and posting date to the fiscal period, then matches journal type and debit/credit direction to the cash-flow sub-class.
  • Head-office fallback affects only the category mapping. Actual transactions always remain restricted to the office selected on the forecast.
  • Only journal details whose account is configured for cash receipts or cash payments (UseCRV or UseCPV) are included.

​
Monthly cash planning reports

  • Statement of Cash Flow summarizes actual posted cash/bank debits, credits, and net movement by office and calendar month.
  • Monthly Cash Flow Forecast summarizes posted open customer invoices as To Receive, posted open vendor bills as To Pay, and calculates Net Forecast = To Receive - To Pay.
  • The forecast defaults to twelve months. Overdue open documents are placed in the first selected month so immediate obligations and collections remain visible.
  • Amounts use the document exchange rate and are presented in base currency. Paid, settled, cancelled, and written-off documents are excluded.
  • Months without scheduled receipts or payments are shown with zero values.
  • The application installs or updates the required report procedures automatically during the database schema update.

​
Controls

  • Only Draft forecasts and their lines can be edited or deleted.
  • The fiscal period must belong to the selected fiscal year.
  • Only one line may exist per forecast, period, and cash-flow sub-class.
  • One active forecast version may exist for each fiscal year, scenario, and revision.
Last modified on August 25, 2026