SB Enterprise Help Center

AR Aging Report

Updated on

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 accountsInclude negative balance accountsInclude previous penalties in past due amount and Include uncommitted payments toggles to include those details in your report.

 

3     Print the report.

  • Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
    • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
    • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
    • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
    • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).
Previous Article AR Activity Statement Report
Next Article AR Balance by Date Report
Still Need Help? Contact Us