Cash Flow Forecasts Using Account Schedules perform calculations that cannot be done directly in the chart of cash flow accounts. In the account schedules, you can structure the subtotals for cash flow receipts and disbursements. These subtotals can be included in new totals that can then be used in making cash flow forecasts.
This article describes the following tasks:
- Setting up a new cash flow account schedule name.
- Setting up account schedule lines and a new column layout.
- Assigning a column layout to an account schedule.
- Viewing and printing the cash flow forecast.
Cash Flow Forecasts Using Account Schedules Prerequisites
To complete this walk-through, you will need:
- Microsoft Dynamics Business Central installed.
- The cash flow worksheet lines are registered.
1. Setting Up a New Account Schedule Name in Cash Flow Forecasts Using Account Schedules
An account schedule consists of a cash flow account schedule name with a series of lines and a column layout.
To Set up a New Account Schedule Name
- Choose the search icon, enter Account Schedules, and then choose the related link.
- On the Account Schedule Names page, choose the New to create a new cash flow account schedule name.
- Inside the Name field, enter the Forecast.
- In the Description field, enter Cash Flow Forecast.
- Leave the Default Column Layout and Analysis View Name fields blank.
2. Setting Up Account Schedule Lines
After an account schedule name is set up, each line that appears in the cash flow account schedule is defined. Lines that can be shown in reports in addition to the lines that are only for calculation purposes is defined.
To Set up Account Schedule Lines
- On the Account Schedule Names page, click the new Forecast account schedule name that you have created. In the Home tab, in the Process group, choose Edit Account Schedule.
- On the Account Schedule page, enter each line exactly as shown in the following table.
|Row No.|Description|Totaling Type|Totaling|Row Type|Amount Type|Show|
|——-|———–|————-|——–|——–|— ——|—-| |C10|Amount|Net Change|Entries|Net Amount|Always|
|C20|Amount until Date|Balance at Date|Entries|Net Amount|Always|
|C30|Entire Fiscal Year|Entire Fiscal Year|Entries|Net Amount|Always|
- Choose the OK button.
3. Assigning the Column Layout to the Account Schedule Name
Ken is now ready to assign the column layout to the account schedule name.
To Assign the Column Layout to the Account Schedule Name
- On the Account Schedule Names page, select Forecast in the Name field.
- In the Default Column Layout field, choose the column layout Cash Flow to assign as the default column layout.
To View and Print the Cash Flow Forecast
- On the Account Schedule Names page, choose the Overview action to view the cash flow forecast.
- On the Account Schedule Overview page, you can choose an amount and then view the cash flow forecast entries that make up the amount. In addition, you can view the formula that is used to calculate the amount. You can also filter the amounts by date and dimension.
- Choose the Print action to print the cash flow forecast.
A cash flow forecast is the most important business tool for every business. The forecast will tell you if your business will have sufficient cash to run the business or pay to expand it. It will also tell you when more cash is going out of the business, than in. For more information on Cash Flow Forecasts Using Account Schedules, please contact us.