A/P Aged Cash Requirements Report Screen
Open Accounts Payable > A/P Transaction Reports > Aged Cash Requirements.
Overview
The Aged Cash Requirements report highlights the cash amounts required to meet obligations as they become due, including the amount needed to pay invoices that are overdue, current, and due in each of four future periods you define.
Use the report for cash flow analysis and projections.
You can print a detailed report or a summary report:
- The detailed report lists all outstanding documents for each vendor.
- The summary report prints one line for each vendor number, including the overdue and current balance in the vendor's account, and the balance that will come due in each of four periods.
When to Print
Print the Aged Cash Requirements report when you need to see the amounts owed and when they are due to help you with cash‐flow management, short‐term planning, and budgeting.
Information Printed on This Report
- The Due Date/Applied Number/Applied Type column lists the due date for documents at the left, and the document number and type of applied details at the right.
-
The Current column contains documents that are not yet due.
Credit notes, debit notes, and prepayments appear in this column if you select As Current for the Age Credit Notes And Debit Notes and Age Prepayments options on the A/P Options screen.
- The vendor contact and phone number, and your company's credit limit with the vendor are listed if you select the Contact/ Phone/Credit option.
-
Subtotals (for a single currency company) or subtotals by currency (for a multicurrency company), if you select Vendor Group or Account Set as the primary sort order.
Subtotals appear on both the summary and the detail report.
- Extra space appears between each vendor record if you select the Space For Comments option.
- Miscellaneous payments appear as "MC" in the Document Type or Applied Type fields.
-
Reports aged by due date have an option to display aged retainage for each vendor. (This option is not available for reports aged by document date.)