Macro Magic: Cash Flow Projection in Sage 300 (Accpac)

Jul 18 2013

Sage 300 has several sample macros that can be used out of the box – in a flash! One of them is the Cash Flow Projection. The Cash Flow Projection macro generates an entire workbook that extracts data from GL, AR and AP.

In this post, we’ll review how you can set up the Cash Flow Projection in Sage 300 ERP.

The first worksheet displays the summary of Cash Received (expected from AR), Cash Required (due for payment from AP), and the Bank/Cash account balances (from GL)

sage300 cash flow-1

The second sheet is a pivot table (created from the fourth sheet: Aged Cash Received Data) that lists/summarizes all expected cash receipts for all due receivables.

sage300 cash flow-2

The third worksheet (created from the fifth sheet: Aged Cash Requirements Data) lists/summarizes all projected disbursements for all due payables, based on invoices due to vendors. This list may include all available discounts.

sage300 cash flow-3

Both Aged Cash Received and Aged Cash Requirements may be displayed in Summary or Detailed format.

Normally, to come up with all this information, you would have to generate 2-3 reports. With the built-in macro, this can be generated in a flash!


1. From the Macro menu, select Run.

sage300 cash flow-4

2. A list of Standard Macros will show up – this is defaulted to Sage 300 Macro folder. Select Cashflow.avb.

sage300 cash flow-5

3. Provide the required parameters and click OK.

sage300 cash flow-6

Now you are all set! Call us at Mantralogix if you would like to learn more about Sage 300, Cash Flow Projections, or out of the box Macros. We’re here to help!

Recent posts