MAS90 Tool Tip:
Estimated Cash Flow Analysis Report
There is a handy report in the Bank Reconciliation Module that is often overlooked. It is the Estimated Cash Flow Analysis Report. This tool allows you to choose from average due days vs actual due dates on your payables and receivables. Let’s explore how to setup this report.
Go to the Bank Reconciliation Module. Select the Reports Menu and the Estimated Cash Flow Analysis Report. (my examples are from version 4.30, older versions will look a little different).
There are several options when running this report. The first is to define reporting periods. You will see that there are four periods that you can setup. (Tip…Start with period 4 and work your way backwards) Choose whatever time frame you want.
Next, consider your projection options. First choose your payable discount options; do you want to consider them or not?
Next, determine how you want to project your payables and receivables. You can select based on the invoice due date OR from the AVERAGE due date. Average due date is calculated using the invoice date from AP and the average days for payment on the vendor file (see the statistics tab in vendor maintenance). The same is true for accounts receivable. The average days due date is calculated based on the invoice date compared to the average number of days for payment (see the statistic tab in customer maintenance).
Choose if you want open purchase orders included in your report.
At the top of the select screens are two important buttons; Receipts and Disburse. These buttons allow you to enter cash receipts and disbursements that are not reflected in your payables or receivables. An example would be payroll or loan payments or draws.
Click on Disburse button. Enter any payments you expect that are not in your open payables into the four periods.
Click OK and select the Receipts button. Enter anticipated cash receipts that are not reflected in your open receivables.
Click OK to exit.
Select which bank codes you would like to consider and you are ready to run your report.
Review your report. Each selection you made is clearly reflected.
Hope this helps you get more out of your software!
Call Partners In Technology for MAS90 support at 630-462-7190