Cash Flow Management can be used to keep a track of cash flow within Microsoft Dynamics GP and also to forecast cash flow based on one or more checkbook balances with or without work/adjustment transactions such as deposits, payments, or reconciliation adjustments that are not part of the checkbook balances.
Cash Flow Management can be used to complete the following tasks:
- Create an unlimited number of different cash flow forecasts
- Create scenarios without recording transactions
- Summarize daily inflows and outflows of cash in the Cash Flow Calendar
- View the summary of any given day's cash inflow and outflow
- Run summary or detailed reports on weekly and monthly cash flow
Cash Flow Management is installed automatically with Microsoft Dynamics GP and is licensed as a part of the starter pack, and so is available to all users.
Microsoft Dynamics GP Cash Flow Management supports the creation of unlimited cash flow forecasts, one of which can be defined as the default.
To create a default cash flow forecast which includes transactions against all checkbooks from all series, perform the following steps:
- Open the Cash Flow Forecast window in Dynamics GP by selecting Financial from the Navigation Pane on the left, and then clicking on Cash Flow Forecast in the area page under Setup | Financial.
- Enter
DEFAULTin the Forecast ID field. - Mark the Default checkbox.
- Enter
Default Cash Flow Forecastin the Description field. - Mark the All checkbox in the Include Checkbook ID(s) frame.
- Mark the Open and Work checkboxes for Receivables Management.
- Mark the Sales Order Processing Documents checkbox.
- Mark the Open and Work checkboxes for Payables Management.
- Mark the Purchase Order Processing Documents checkbox.
- To include "what if?" transactions mark the Cash Flow Transactions checkbox.
- Enter
13in the Weeks to Display field. - Click on Save, and close the Cash Flow Forecast window.
Now that a default cash flow forecast has been created, we can progress on to using the Cash Flow Management module.
Cash flow forecasts are how the cash inflows and outflows are tracked within Dynamics GP. Each cash flow forecast created can have different bank accounts and options such as the opening balance, defined to allow different forecasts to be used.