The Aged Balances insight gives you a snapshot of a client's aged debtors and creditors at a point in time. It covers aged receivables, aged payables, average days to collect, overpayments, and draft invoices.
To access it, go to a client's account and select Insights in the left navigation, then select Aged balances.
Who can use this insight
The Aged Balances insight is available to practices with the Data Health & Insights add-on, on Practice Essentials and Practice Advanced plans.
Reporting Date and Invoice Age
Two controls at the top of the page determine what data the insight shows.
Reporting Date — the point in time you want to evaluate the client's debtors and creditors at, based on invoice dates.
Invoice Age — filters invoices by how old they are relative to the Reporting Date. Only invoices older than the selected threshold are included. Options are: Reporting Date, One Month, Two Months, Three Months, Six Months, and Twelve Months.
The five checks
Aged Balances surfaces five checks. Each shows a summary count and total on the right. Select a check to expand it and see transaction-level detail.
Aged Receivables
Aged Receivables shows invoices where money is owed to the client, and the invoice is older than the selected Invoice Age threshold. The summary on the right shows the total amount owed.
Select the check to expand it and see a transaction table with the following columns: Type, Contact, Reference, Currency, Date, Due Date, Amount Due, Amount Paid, Amount Credited, and Status. For Xero clients, a View in Xero link is available in the Link column to open each record directly in Xero.
Aged Payables
Aged Payables shows invoices where the client owes money to a supplier and the invoice is older than the selected Invoice Age threshold. The summary on the right shows the total amount due.
Select the check to expand it and see a transaction table with the same columns as Aged Receivables, including a View in Xero link for Xero clients.
Average Days to Collect
Average Days to Collect gives an indication of how long it takes the client's debtors to pay. It's calculated using the total receivables amount owed at the Reporting Date divided by the 12-month rolling gross revenue up to the Reporting Date.
Select the check to expand it. Below the days figure, Dext shows an impact calculator: enter a number of days to see the cash flow impact of reducing the average days to collect by that amount.
Overpayments
Overpayments shows all overpayments that still have remaining credit at the Reporting Date. Dext checks allocation dates to confirm they fall within the reporting period. Results are split into two categories:
Suppliers — overpayments with remaining credit owed to suppliers.
Customers — overpayments with remaining credit owed by customers.
Each category shows the number of overpayments and the remaining credit total.
Draft Invoices
Draft Invoices shows invoices with a status of Draft or Submitted (Awaiting Approval) where the invoice date falls before the end of the reporting period. These should be reviewed and finalised before the period is closed.
Select the check to expand it. The transaction table can be filtered by type (Bill, Sale, or All) and by status (Draft, Submitted, or All). The table shows Type, Contact, Reference, Currency, Date, Due Date, Amount Due, Amount Paid, Amount Credited, and Status for each invoice. For Xero clients, a View in Xero link is available to open each record directly in Xero.
Syncing and recalculating data
To update the Aged Balances insight, use the two buttons at the top of the page:
Sync — pulls any new data or changes from Xero or QuickBooks Online into Dext.
Recalculate — recalculates the insight based on the latest data pulled into Dext.
If you've made changes in your accounting software, select Sync first, then Recalculate to see the updated figures.