Skip to main content

Cash Flow Statement - Forecast

The Cash Flow Statement - Forecast workbook shows a full-year view of cash flow by combining actual posted data for completed periods with budget data for remaining periods. This projects how cash will move through the full fiscal year against the selected budget.

Selection page​

When you open the workbook, the Selection Page appears before the cash flow statement loads. Fiscal Year, Fiscal Period, and Budget are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.

  • Company: the company to report on.
  • Fiscal Year: the fiscal year the cash flow statement reports on. (required)
  • Fiscal Period: the period used as the cutoff between actual and forecast data. (required)
  • Budget: the budget used as the source for forecast amounts. (required)
  • Segment 02
  • Segment 03
  • Segment 04
  • Segment 05
  • Segment 06

Forecast report​

The report covers the same three sections as the standard cash flow statement: operating activities, investing activities, and financing activities. Each section has a subtotal row. The report is split into two parts: a summary block on the left showing full-year totals, and a monthly breakdown on the right showing each fiscal period individually.

Summary columns​

  • Full Year Actual: total posted cash flows for all completed periods in the fiscal year.
  • Full Year Actual + Forecast: actual amounts for completed periods combined with budget amounts for remaining periods. This is the projected full-year result.
  • Full Year Forecast: the full-year budget amount.
  • Variance: the difference between Full Year Actual + Forecast and Full Year Forecast, showing how the projected result compares to the original plan.

Monthly columns​

Each fiscal period in the year is shown as a separate column in YYYY-MM format. Completed periods are labeled Actual and show posted data. Remaining periods are labeled Forecast and show budget data. The cutoff between actual and forecast columns is determined by the Fiscal Period selected on the selection page.

At the bottom of the report, Net Decrease in Cash shows the net change across all three sections, Cash & Equivalent at Begin of Year shows the opening cash balance, and Cash & Equivalent at End of Year shows the projected closing balance.