Balance the Aged Debtors to the Trial Balance Debtors and Ledger Balance
Updated Jul 10th, 2024
Who is this guide for?
Accounts Users and Accounts Supervisors
This guide will assist you with balancing your aged debtors figures to the relevant balances
The Trial Balance Debtors figure is the total debt owed to you by your clients. These debts can be either due (billed) or not due (unbilled disbursements).
The Trial Balance Debtors figure can be confirmed by running the Ledger/Matter Balance Listing report, and adding together the office and disbursements totals.
Aged debtors should equal the office total of the ledger balance report, other than where provisional bills and counsels fees posting types have been used.
Compare at current date
To run and compare the reports as at the current time:
- Run the Trial Balance Report – Reports > Financial Management > Trial Balance
- Run the Aged Debtors Report – Reports > Client Financial > Aged Debtors and ensure that Include Credit Bals? is ticked.
- Run the Ledger Balance Report – Reports > Client Financial > Ledger Balance and ensure that Exclude Future Postings is set to Yes:
Add the total Office and Disbursements figures from the Ledger Balance report together, this should match your debtors figure.
In the example above, 9819.67 + 568.74 = 10388.41. Compare this with the Debtors figure on the Trial Balance:
The Aged Debtors report lists all Client Ledgers that have a balance in the Office column. On this report the Disbursement column is not included in the figure as these are not due until they are billed, and credit office balances are not included by default as they are not debts.
If you use the following posting types, you will need to allow for these, since the Aged Debtors report will not include them:
- Legal Aid Counsel Fees
- Provisional Bills
Within the report there is a “MisAl” column, this displays ‘Yes’ when there is a problem with the allocations on the matter, meaning that the sum of the ageing columns does not match the Balance on the ledger. The ledger should be cleared and reallocated to rectify this.
All of the above postings have their own Journal figure on the Trial Balance report.
The figures on the Aged Debtors report can be corroborated by comparing the total Balance column:
with the total Office column from the Ledger Balance report:
If these two columns do not match, check your Trial Balance report for PRDEBTOR or CFDEBTOR journal rows. In the example below, because there are provisional bills (not yet delivered) and counsels fees (not yet paid) posted on the ledgers, the total of the three journals should be used to match to the Ledger Balance report office+disbursements figure:
Trial Balance Debtors totals: 10,400.91 + 1,500 + 890 = 12,790.91
Ledger balance office + disbursements columns: 11,319.67 + 1,471.24 = 12790.91
Aged Debtors balance column = 9,819.67 + PRDEBTOR 1,500 = 11,319.67 (Ledger Balance Office column total)
Compare at month end
To run and compare the reports as at a month end:
- Run the Period End Trial Balance and Period End Matter Balance reports: Reports > Financial Management > Period End. Check the year and period at the top and change accordingly. Click Toggle Selection to untick all the reports then tick Period End Trial Balance, and Period End Matter Balance, then click Run.
- Run the Aged Debtors Report – Reports > Client Financial > Aged Debtors and ensure that Include Credit Bals? and As At are ticked. In the box alongside As At, enter the period end date for the month you want to compare to the Trial Balance/Ledger Balance.
Add the total Office and Disbursements figures from the Period End Matter Balance report together, this should match your debtors figure.
In the example above, 9819.67 + 568.74 = 10388.41. Compare this with the Debtors figure on the Trial Balance:
The Aged Debtors report lists all Client Ledgers that have a balance in the Office column. On this report the Disbursement column is not included in the figure as these are not due until they are billed, and credit office balances are not included by default as they are not debts.
If you use the following posting types, you will need to allow for these, since the Aged Debtors report will not include them:
- Legal Aid Counsel Fees
- Provisional Bills
All of the above postings have their own Journal figure on the Trial Balance report.
The figures on the Aged Debtors report can be corroborated by comparing the total Balance column:
with the total Office column from the Period End Matter Balance report:
If these two columns do not match, check your Trial Balance report for PRDEBTOR or CFDEBTOR journal rows. In the example below, because there are provisional bills (not yet delivered) and counsels fees (not yet paid) posted on the ledgers, the total of the three journals should be used to match to the Period End Matter Balance report office+disbursements figure:
Trial Balance Debtors totals: 10,400.91 + 1,500 + 890 = 12,790.91
Period End Matter Balance office + disbursements columns: 11,319.67 + 1,471.24 = 12790.91
Aged Debtors balance column = 9,819.67 + PRDEBTOR 1,500 = 11,319.67 (Ledger Balance Office column total)