icon, enter Cash Flow Forecast, and then choose the related link.If you want some help to decide what to do with your cash, have a look at the charts on the Accountant Role Center:
This topic describes where the data in the charts comes from and, if necessary, what to do to start using the charts.
The Cash Cycle and Income & Expense charts are ready to go, based on the Chart of Accounts and account schedules. The accounts are where the data comes from, and account schedules calculate the relationship between sales and receivables. Some accounts and account schedules are provided. You can use them as-is, change them, and add new ones. If you add G/L accounts to your chart of accounts, for example, by importing them from QuickBooks, you'll need to map to the accounts on the Account Schedules page for the following account schedule names:
| Account Schedule Name | Where it's used |
|---|---|
| I_CACYCLE | Cash Cycle |
| I_CASHFLOW | Cash Flow |
| I_INCEXP | Income & Expense |
| I_MINTRIAL | As an income statement if you don't use the chart of accounts |
Note It's a good idea to keep the calculations that are provided for the account schedule.
Enter accounts in the Totaling field for Total Revenue, Total Receivables, Total Payables, and Total Inventory. To map to a range of accounts, or more than one specific account, enter the account numbers separated by ".." or by a vertical bar, respectively. For example, 1111..4444 or 2222|3333|5555.
Tip Verify your mapping by choosing the Overview action.
The Cash Flow chart is based on the following:
To help you get going, some accounts and cash flow setups are provided. You can add, change, or remove them.
To set these up, search for cash flow accounts, choose the link, and then fill in the fields. Hover over a field to read a short description. Repeat these steps for cash flow setup.
The Cash Flow Forecast chart uses cash flow accounts, cash flow setups, and cash flow forecasts. Some are provided, however, you can set up your own by using an assisted setup guide. The guide helps you specify things like how often to update the forecast, the accounts to base it on, information about when you pay taxes, and whether to turn on Cortana Intelligence.
Cash flow forecasts can use Cortana Intelligence to include documents with a due date in the future. The result is a more comprehensive prediction. The connection to Cortana Intelligence is already set up for you. You just need to turn it on. When you sign in to Business Central , a notification displays in a blue bar, and provides a link to the default cash flow setup. The notification displays only once. If you close it, but decide to turn on Cortana Intelligence, you can use the assisted setup guide, or a manual process.
Alternatively, you can use your own predictive web service. For more information, see Create and use your own predictive web service for cash flow forecasts.
To use the assisted setup guide:
icon, enter Cash Flow Forecast, and then choose the related link.To use a manual process:
icon, enter Cash Flow Forecast, and then choose the related link.Consider the length of the periods that the service will use in its calculations. The more data you provide, the more accurate the predictions will be. Also, watch out for large variances in periods. They will also impact predictions. If Cortana Intelligence does not find enough data, or the data varies a lot, the service will not make a prediction.
You can also create your own predictive web service based on a public model named Forecasting model for Microsoft Business Central. This predictive model is available online in the Cortana Intelligence Gallery. To use the model, follow these steps:
icon, enter Cash Flow Setup, and then choose the related link. Analyzing Cash Flow in Your Company
Setting Up Finance
Working with Business Central
© 2019 Microsoft. All rights reserved.