Walkthrough: Make cash flow forecasts using financial reports

This walkthrough describes how you can use the financial reports feature to make cash flow forecasts. Financial reports perform calculations that cannot be done directly in the chart of cash flow accounts. In the financial reports, you can set up subtotals for cash flow receipts and disbursements. These subtotals can be included in new totals that can then be used to make cash flow forecasts.

About this walkthrough

This walkthrough describes the following tasks:

  • Setting up a new cash flow financial report name.
  • Setting up financial report lines.
  • Setting up a new column definition.
  • Assigning a column definition to a financial report.
  • Viewing and printing the cash flow forecast.

Prerequisites

To complete this walkthrough, you will need:

  • Business Central
  • A cash flow worksheet with registered lines

Roles

This walkthrough demonstrates tasks that are performed by the following user role:

  • Controller

Story

Ken is a controller at CRONUS who makes monthly cash flow forecasts. Ken includes finance, sales, purchase, and fixed assets in the forecasts, and presents to CFO Sara for business insight.

Set up a new financial report name

The financial report name is the name you give the cash flow forecast that includes a series of defined lines and a column definition.

Set up a new financial report name

  1. Select Search (Alt+Q) in the upper-right corner, enter Financial Reports, and then choose the related link.
  2. On the Financial Reports page, choose New to create a new cash flow financial report name.
  3. In the Name field, enter Forecast.
  4. In the Description field, enter Cash Flow Forecast.
  5. Leave the Row Definition and Column Definition fields blank.

Set up row definition lines

After a financial report name is set up, Ken defines each line in the cash flow financial report. Ken defines lines to be shown in reports in addition to lines that are only for calculation purposes.

Set up row definition lines

  1. On the Financial Reports page, select the new Forecast financial report you created, then choose the Edit Row Definition action.

  2. On the Row Definition page, enter each line as shown in the following table.

    Tip


    Use the Insert CF Accounts function to quickly mark, in the cash flow accounts chart, the cash flow accounts you want and copy them to row definition lines.

    Row No.DescriptionTotaling TypeTotalingRow TypeAmount TypeShow
    R10ReceivablesCash Flow Entry Accounts10Net ChangeNet AmountYes
    R10Open sales ordersCash Flow Entry Accounts20Net ChangeNet AmountYes
    R10RentalsCash Flow Entry Accounts30Net ChangeNet AmountYes
    R10Financial assetsCash Flow Entry Accounts40Net ChangeNet AmountYes
    R10Fixed assets disposalCash Flow Entry Accounts50Net ChangeNet AmountYes
    R10Private investmentsCash Flow Entry Accounts60Net ChangeNet AmountYes
    R10Miscellaneous receiptsCash Flow Entry Accounts70Net ChangeNet AmountYes
    R10Open service ordersCash Flow Entry Accounts80Net ChangeNet AmountYes
    R20Total cash receiptsFormulaR10Net ChangeNet AmountYes
    R30PayablesCash Flow Entry Accounts1010Net ChangeNet AmountYes
    R30Open purchase ordersCash Flow Entry Accounts1020Net ChangeNet AmountYes
    R30Personnel costsCash Flow Entry Accounts1030Net ChangeNet AmountYes
    R30Running costsCash Flow Entry Accounts1040Net ChangeNet AmountYes
    R30Finance costsCash Flow Entry Accounts1050Net ChangeNet AmountYes
    R30InvestmentsCash Flow Entry Accounts1070Net ChangeNet AmountYes
    R30Private consumptionsCash Flow Entry Accounts1090Net ChangeNet AmountYes
    R30VAT dueCash Flow Entry Accounts1100Net ChangeNet AmountYes
    R30Other expensesCash Flow Entry Accounts1110Net ChangeNet AmountYes
    R40Total cash disbursementsFormulaR30Net ChangeNet AmountYes
    R50SurplusFormulaR20+R40Net ChangeNet AmountYes
    R60Cash flow fundsCash Flow Entry Accounts2100Net ChangeNet AmountYes
    R70Total cash flowFormulaR50+R60Net ChangeNet AmountYes

    Note

    The row number R10 is used to capture the account totals for receivables. The row number R20 is used to calculate the sum of all cash receipts. The row number R30 is used to capture the account totals for payables. The row number R40 is used to calculate the sum of all cash disbursements. The row number R50 is used to capture the sum of cash surplus. The row number R60 is used to capture the liquid funds. The row number R70 is used to calculate the forecasted cash flow.

Set up a new column definition

Before printing the cash flow forecast, Ken needs to create the column definition for the numerical information. In the columns, Ken defines the information needed to use from the lines.

  • The first column has the number C10 with the title Amount and contains the net change.
  • The second column has the number C20 with the title Balance at Date and contains the transactions for the period.
  • The third column has the number C30 with the title Entire Year and contains the net change in the balances for the entire fiscal year.
  • Finally, Ken assigns the column definition as the default option for the Forecast financial report.

Set up a new column definition

  1. On the Financial Reports page, select the new Forecast financial report name you created. On the Home tab, in the Process group, choose Edit Column Definition.

  2. Create a new column definition with the name Cash Flow.

  3. Choose the OK button.

  4. Enter each line exactly as shown in the following table.

    Column No.Column HeaderColumn TypeLedger Entry TypeAmount TypeShow
    C10AmountNet ChangeEntriesNet AmountAlways
    C20Amount Until DateBalance at DateEntriesNet AmountAlways
    C30Entire Fiscal YearEntire Fiscal YearEntriesNet AmountAlways

Assig the column definition to the financial report name

Ken is now ready to assign the column definition to the financial report name.

Assign the column definition to the financial report name

  1. In the Financial Reports page, select the Forecast financial report, then choose the Edit Column Definition action.
  2. In the Name field, choose the column definition Cash Flow to assign as the default column definition.

View and print the cash flow forecast

  1. On the Financial Reports page, choose the Forecast financial report Financial analytics overview to view the cash flow forecast.
  2. On the Financial Report page, you can select an amount and then view the cash flow forecast entries that make up the amount. In addition, you can view the formula used to calculate that amount. You can also filter the amounts by date and dimension.
  3. Choose the Print action to print the cash flow forecast.

Prepare financial reporting
Analyzing Cash Flow in Your Company
Financial analytics overview
Work with Business Central

Find free e-learning modules for Business Central here