Project Cash Flows Using the Cashflow Macro

Note: To use the Cash Flow Projection macro, you must have Microsoft Excel on your computer.

Overview

The Cashflow macro ages receivable and payable transactions according to aging periods and for the cash accounts you specify. It then produces a multi-worksheet Excel workbook with cash flow projections that include account balances and the cash available at the end of the specified cutoff period. If you require additional information about your receivables or payables balances, you can drill down to the transactions.

Also, using the pivot tables created by the macro, you can sort, include additional levels of detail, and subtotal the transactions using up to nine different options.

You can also graph the aged transactions so that you can easily determine which customers or vendors you need to review. (You should remove the total from the graph, as it is the sum of all transactions).

To run the Cash Flow Projection macro:

  1. On the Sage 300 Desktop, click Macro > Run.

    The Run Macro screen appears.

  2. From the Files Of Type list, select VBA Macro.
  3. Select CashFlow.avb, and then click Open.
  4. In the dialog box that appears, select the cash accounts for which you want to create a cash flow projection, select aging and other criteria, as needed, and then click OK.