Partners in Technology Logo
 MAS90 - Print Controls
 MAS 90/200 - Sel. Screens
 MAS90 - Est Cash Flow
 MAS90 - Material Req.
 MAS90 - Cond. Trend Report
 MAS90 - Removing Old Forms
 MAS90 User Preference Settings
104 E. Roosevelt Rd., Wheaton, IL 60187
email: info@partners-in-tech.com
phone: 630-462-7190
Home   |   Sage Products   |   Visual Shop   |   IT Services   |   Success stories   |   Tool Tips   |   Contact Us   |   Blog

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.

MAS90 Bank Recon

Next, consider your projection options. First choose your payable discount options; do you want to consider them or not?

MAS90 Cash Flow

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.

MAS90 Bank Recon

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.

MAS90 Bank Reconciliation

Click OK and select the Receipts button. Enter anticipated cash receipts that are not reflected in your open receivables.

 MAS90 Bank Reconciliation

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

Sage Software support image
Testimonials & Case Study

"Partners In Technology came out to our office, analyzed our business, and presented a very clear solution to our challenges using Sage MAS 90 as the backbone."

[read more...]

***

<< May 2013 >>
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Saturday, May 18, 2013
Labor Day
Click here to learn more>>
Free Webcast Sage MAS Intelligence
Click here to learn more>>