Summary

The Aging Report will display a list of customer accounts with their invoices grouped by age in the following categories: Balance Forward, Available Credits, Under 30 days, 30-60 days, 60-90 days, 90-120 days and over 120 days.

Step by Step

1     Open the Aging Report window (AR> Reports> Aging Report).

2     Configure the report. 

• Select the billing cycles you would like to include in the report in the Cycle section.
  • You must select at least one cycle or your report will be blank.
• The Report Type drop-down field is used to determine the amount of detail included in the report.
  • The Summary report will display the customer number, customer last name, account number, balance forward, invoices filtered by age and report totals of all number columns. The report will also include a note in the header about whether or not the Include uncommitted payments toggle was checked.
  • The Detail report will display everything included in the Summary report as well as the invoice number, post date, initial balance, and invoice description for each line item in the report.
• Enter the date you want to age from in the Aging Date field. The Aging date will determine the age of the transactions.
• Select which transactions you would like to include in the report in the Minimum Age and Maximum Age fields.
  • This will filter the report to only include the age of transactions selected. The age of the transaction is determined by the date entered in the Aging Date field and the Age From date type selected.
  • If you filter the report by transaction age, the Balance Forward column in the report will only include the transactions of the age specified.
• Select which date you would like to age the transactions by in the Age From drop-down menu.
  • The transaction date and due date are both entered in the Generate Invoices window (AR>Generate Invoices) when creating invoices.
• Select the order you would like the report to print in the Sort By drop-down menu.
• Enter a value in the Minimum Balance field if you want to filter the report by a minimum amount. The report will only include customers with a balance forward greater or equal to the amount entered in this field.
• Check any combination of the Include Zero Balance Accounts, Include Negative Balance Accounts, Include Previous Penalties in Past Due Amount and Include Uncommitted Payments toggles to include those details in your report.

3     Print the report.

• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.