Printing the A/R Aged Retainage Report

Learn more

About Accounts Receivable Reports

A/R Aged Retainage Report

The Aged Retainage report lists outstanding retainage amounts in each aging period.

Note: The report does not include retainage that has been invoiced or applied to a debit note or a credit note.

In multicurrency ledgers, you can print the report in your functional currency or in the customer currencies used in posted transactions.

To print the A/R Aged Retainage report:

  1. Open Accounts Receivable > A/R Transaction Reports > Aged Retainage.
  2. On the A/R Aged Retainage Report screen, select the Report Type. More...
    • Future Retainage By Due Date. Shows outstanding retainage amounts that are due in future aging periods, beginning with the Age As Of date.
    • Aged Retainage By Due Date. Shows all outstanding retainage amounts that are due for each aging period, including Current.
    • Overdue Retainage By Due Date. Shows only outstanding retainage amounts that became overdue in each aging period.
  3. For Age As Of, specify the date to report the retainage. The program uses this date to assign retainage to an aging period by calculating the number of days between its due date and the Age As Of date.
  4. For Cutoff By, select the method for selecting a cutoff date or period for the transactions or balances to include in the report. More...
    • Document Date. Includes documents based on their document date (regardless of the fiscal period to which you assigned them). You then enter a date for Cutoff Date.
    • Posting Date. Includes documents based on their posting date. You then enter a date for Cutoff Date.
    • Year/Period. Includes all transactions up to the end of a fiscal period. You then enter the fiscal year and period for Year/Period.
  5. For Print Transactions In, select whether to print a summary version, a detailed version by document date, a detailed version by document number, or a detailed version by retainage due date.
  6. If you need to change the aging periods for this report, make changes in the To Aging Period (Days) column of the aging table. More...

    Initially, this table shows the aging periods set up on the Statement tab of the A/R Options screen.

    The program assigns retainage amounts to aging periods depending on the report type:

    • On the Future Retainage By Due Date report, outstanding retainage amounts are grouped according to the future dates they will become due.
    • On the Aged Retainage By Due Date report, all outstanding retainage amounts are grouped according to the dates they become due.
    • On the Overdue Retainage By Due Date report, overdue outstanding retainage amounts are grouped according to the dates they became due.
  7. Select the customers to include on the report. More...
    1. For Account Type, choose whether to include all types of customers, only Open Item customers, or only Balance Forward customers.
    2. In the Select Customers By table, you can choose up to four selection criteria to limit the customers included on the report.

      For the first selection, choose from Customer Number, National Account, Customer Group, Billing Cycle, and Short Name. For the remaining three selection criteria, you can also choose additional fields to limit the customers.

      You can then specify the range for each of the selection criteria that you choose.

      If you do not choose any selection criteria, the report includes all customers with the account type you select.

  8. Select the order to list customers on the report. More...
    1. In the Sort Customers By table, you can choose up to four sort orders. For the first selection, choose from National Account, Customer Group, Billing Cycle, Short Name, Account Set, and Territory. For the remaining three sort orders, you can also choose additional fields to sort the customers.

      If you do not select a sort order, the report sorts by customer number.

    2. For each sort order, you can also select the Title option (to include titles for each sorted group) and the Total option (to include subtotals for each sorted group).
  9. To include tax information on the report, select the Include Taxes option.
  10. If you use multicurrency accounting, use the Print Amounts In field to select whether to show transaction amounts in the customer 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.
  11. Click Print.

    The report appears in a new Sage 300 window. You can print the report or export it to a file.