Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

This document describes the cash flow functionality. It first describes the settings associated with cash flow and then describes how a cash flow forecast can be generated and what options a cash flow forecast offers.

Settings

Chart of Cash Flow Accounts

In order for Cash Flow Worksheet to work properly, a Chart of Cash Flow Accounts must be adjusted.

...

Note

The standard cash flow suggests the financial account cash flows defined by the user for a given category.

This cannot be used if the cash flow extension by currency is used because the amount on the financial accounts are always converted to LCY. For this purpose, the user needs to set up the liquid funds without the financial accounts filter and just set Source Type = Liquid Funds.

Cash Flow Manual Expenses/Income

Not all income/expenses will be reflected in the system at the time the cash flow forecast is created. Use the Cash Flow Manual Expenses and Cash Flow Manual Revenues functionalities for anticipated income/expenses in the future. These can be set up to expect, for example, rent in a certain amount and certain currency every 15th of the month.

...

Note

Currency is not part of the standard cash flow. So, for example, the BC standard does not allow you to choose currency in manual receipts/expenditures and everything is entered in local currency (LCY).

Functionality description

Business Central uses the so-called Cash Flow Forecasts for cash flow planning. There can be several of these in the system. They can differ in currencies (if the Cash Flow by currency extension is installed) or they can be different with one plan being in the contractual payment terms and the other in the cash flow terms.

Create a Cash Flow Forecast

Cash flow forecast can be found through the search function. New cash flow forecast can be then created using the action +New, if there is no cash flow plan from the past that can be used.

...

The Cash Flow Forecast can look like this:

...

Creating cash flow forecast items

Once the cash flow forecast is set up as required, it is possible to let the system suggest the required entries. This can be done from the cash flow forecast card using Process → Cash Flow Workbook.

...

Note

After recording the cash flow forecast entries, the system deletes the existing entries recorded for the respective forecast and uploads the newly confirmed entries.

For this reason, it is necessary to have multiple cash flow forecasts if more than one user is working with the plans at the same time so that they do not overwrite the data in an undesirable way.

Cash flow analysis

Once the entries have been successfully recorded, the entries are logged into the cash flow plan statistics, which is available on the cash flow forecast card under the (info) icon.

...