Overview
The Aged Receivables report details all outstanding invoice balances and aging information on those receivable balances. This provides insight into how much money can be received to your organization and how long the balances have been outstanding.
Accessing the Aged Receivables Report
The report can be accessed in Reports > Billing Reports in the Sales category.
Report Configuration Options
Basic settings
Filters
Period ending | The Period ending date filters the report to only display invoices created before that date. |
Currency | Allows the selection of a specific currency for which to run the report. Only invoices of the selected currency will be displayed. This option will only be displayed if multiple currencies are set up in the system and the Accounts Receivables system account has been designated for that currency. |
Layout options
Report on | The selection in this field dictates how the aging is calculated. Aging can be calculated from the Payment due date or the invoice created date. |
Period groups |
Aging output on the report is determined by which Period groups are selected when the report is run. 1, 2 & 3+ Months 7, 14 & 21+ Days The current column remains. The latter three columns use the Period group selection. This changes the aging categories to see which due amounts fall in those time spans. |
Advanced Settings
Filters
Debtor | The Debtor field is used to define a specific party who has been billed. Only invoices created for the selected contact will be displayed. |
Layout options
Show participant |
The Show participant option provides a selection of all participant types in your system. For instance: If the Attorney participant type is selected, a column with the name of the attorney on the matter related to the invoice will display on the report. |
|
Group by |
By default, the report is grouped by the Customer/Client who is the billable party on the invoice. Using the Group by option, the report can also show invoices grouped by the Responsible lawyer, Matter Type, Overdue period, Matter, or the Show participant option participant type. Customer/Client Responsible lawyer Matter Type Overdue period Matter Show Participant |
|
Order by |
The Order by option determines the order the invoices are displayed in their Group by groups. Invoice Date Payment Due Date Customer/Client Name Responsible lawyer The "Show Participant" |
|
Trust account balances |
|
|
Unallocated payments | ![]() |
|
General Retainer |
|
Note: The General retainer, trust, and unallocated payment balances are negative figures to offset the due amount. These balances are subtracted to show that a portion of the due funds can be paid by monies that have already been received. |
The options shown in the image above dictate whether Trust account balance, Unallocated payments, and/or General retainers are displayed for each matter on the report.
Output settings
The output section provides options for how the report is produced.
On screen (HTML)
This option displays the report results on your current screen.
This option launches a print dialog from a PDF version of the report. To download as PDF, select Save as PDF in the Print > Destination dropdown on the print dialog screen.
Note: Print dialog will vary based on your browser. |
MS Excel
This option downloads an xlsx, MS Excel, file to your computer. This is a great option to perform further calculations in a spreadsheet format.
Save XLSX file to a matter
Selecting this option will launch a screen to select a matter and a destination folder.
The report will be saved to the selected matter and folder, and it will be accessible in the matter’s documents screen.