Aged Cash Requirements Report — Printing

The Aged Cash Requirements report highlights the cash amounts that will be 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 the report in detailed form, listing all outstanding documents for each vendor, or summary form, printing one line for each vendor number, including the overdue and current balances and the balances in each aging period.

For information on the contents of this report, see Aged Cash Requirements Report — Features.

When to print

Print the Aged Cash Requirements report when you need a listing of the amounts owed and when they are due, to assist you with cash-flow management, short-term planning, and budgeting.

To print the report

1. Choose the Aged Cash Requirements icon from the A/P Transaction Reports folder.
2. Select from the following:

   Age By.  You can age outstanding documents or balances by their due dates or document dates.

   Age As Of. Specify the date on which to report the payables. The program uses this date to assign transactions to aging periods. For example, if you print the report aged by due date, the program assigns each transaction to an aging period by calculating the number of days between its due date and the Age As Of date.

   Cutoff By.  The report includes only transactions that have a document date that is on or before the cutoff date you specify.

   There are three methods for selecting a cutoff date:

   • Document Date

     Select this option to include documents based on their document date (regardless of the fiscal period to which you assigned them). Enter a date in the Cutoff Date field. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.

   • Posting Date

     Select this option to include documents based on their posting date. Enter a date in the Cutoff Date field. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.

   • Year/Period

     Use this method if you want to include all transactions up to the end of a fiscal period. Make your selections in the Year and Period fields.

   Print Transactions In.  Indicate whether to print a summary or detailed report, and whether to print the detailed version of the report with transactions ordered by document date (Detail by Date) or by document number (Detail by Document).

   Sort Transactions by Transaction Type. Select this check box if you want sort transactions by document type for each vendor on the report.

   Use Aging Periods.  The aging periods entered in the Options form appear, but you can assign different periods for individual reports, if you want. The aging periods are used to group transactions by the future dates at which they will become due, rather than by the amount of time they are overdue. All overdue amounts appear in the Overdue column on the report.

   Select Vendors By. Specify up to four criteria to select the vendor accounts to list on the report.

   For the first selection criterion, choose from:

   • Vendor Number
   • Vendor Group
   • Short Name

   For the remaining three selection criteria choose from the above, and:

   • Account Set
   • Vendor Balance
   • Vendor Equivalent Balance (multicurrency ledgers only)
   • Vendor Name
   • Currency Code (multicurrency ledgers only)
   • Start Date
   • Vendor optional fields, if any

   If you do not specify selection criteria, the report includes all vendor records.

   Sort Vendors By.  Specify up to four orders by which to sort records for the report.

   You can choose from:

   • Vendor Group
   • Account Set
   • Vendor Balance
   • Vendor Equivalent Balance (multicurrency ledgers only)
   • Vendor Name
   • Short Name
   • Currency Code (multicurrency ledgers only)
   • Start Date
   • An vendor optional field

   If you specify Vendor Group, Account Set, or a vendor optional field as the sorting criteria in a single currency ledger, or Account Set in a multicurrency ledger, an additional subtotal line appears at the bottom of your report.

   If you do not specify sorting criteria, the report orders the records by vendor number.

   If you want to include subtotals (for a single currency company) or subtotals by currency (for a multicurrency company), select Vendor Group or Account Set as the primary sort order.

   Show Group Title. If you want to include a title for each sorted group, select the Title check box for each group of records you are sorting by.

   Show Group Subtotal.  If you want to include subtotals for each sorted group, select the Show Group Subtotal option for the groups of records you are sorting by.

   [Include] Contact/Phone/Credit.  Choose this option if you want to list the vendor's contact person and phone number and your credit limit for the vendor.

   [Include] Space For Comments. Select this option to leave blank space at the end of each vendor record for your notes.

   [Include] Vendors/Transactions on Hold.  Choose this option to include vendors that you have placed on hold in the Vendors form, and transactions that you have placed on hold in the Control Payments folder.

   [Include] All Available Discounts.  Select this option if you want the program to calculate amounts owing by taking advantage of all available discounts.

   Select Transaction Types.  Select the types of transactions to include on the report. You can include any or all of the transaction types listed. Note that, If you clear the Adjustments check box, adjustments can still appear as Applied Details on the documents that payment was applied to. Select the Adjustments check box and adjustments can appear both as Applied Details and Regular Documents.

   [Show] Applied Details.  Select this option to include all the documents such as payments and credit notes that were applied to each reported invoice. If you do not select this option, the report shows only the balance owing for each outstanding document.

   [Show] Fully Paid Transactions.  Select this option to list documents that are fully paid, but not yet cleared from Accounts Payable.

   [Show] Aged Retainage.  Select this option to include retainage documents with taxes on the report. This check box is disabled if Document Date is selected as the Report Type.

   Print Amounts In.  Use this option to select the currency for the report. You can list transaction amounts in the vendor currency or the functional currency.

   If you list transactions in the functional currency, and you have performed a revaluation, the report shows the new functional amounts.

3. Click Print.

   If printing to a printer, Accounts Payable displays the print destination form to let you confirm your printer selection and change the number of copies to print. Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

   If printing to a file, Accounts Payable displays the name of the file, so you can change it or cancel printing.

   If printing to the screen (preview), Accounts Payable displays the report. If you want, you can then export it to a file or send it to the printer.

   If printing to an e-mail, Accounts Payable displays an e-mail message form for you to fill in, and inserts the report as an attachment when you choose Send.

   If printing to a schedule, Accounts Payable displays the Schedule Report form.

Related Topics