Debtor reports
Debtor reports give you a practice-wide view of what's owed and how collection is going.
Why it helps
Know your numbers. See exactly how much is owed and how old it is, at any date.
Spot gaps. Find invoices that nobody is chasing.
Show your team's work. See every reminder, note and promise in one place.
Share easily. Print, or download as CSV or PDF for partners or your accountant.
To open them: go to Bills & Payments → Bills and click Reports.
Who can do this: Owners, Admins and Finance Admins.
The reports
Report | Answers the question… |
|---|---|
Aged debtors | How much is owed, and how overdue is it? |
Open item listing | Which invoices are outstanding right now? |
Debtor movement | How did our debtors balance change over a period? |
Arranged and unarranged | How much overdue debt is covered by a payment plan or scheduled payment? |
Collection activity | What has the team done: reminders, notes, promises and disputes? |
Not being chased | Which invoices will the workflow never remind, and why? |
Aged debtors
Outstanding balances split into Current, 1–30 days, 31–60 days, 61–90 days and Over 90 days, as at the date you choose. In Group view, expand a row to see each client. In Client view, expand a row to see each invoice.
Open item listing
Every invoice still outstanding at the as-at date, with its due date, days overdue, collection status, and any arrangement (payment plan or scheduled payment).
Debtor movement
For the date range you choose: Opening balance + Billed − Payments − Cancelled ± Other = Closing balance. Other covers changes such as edited invoice totals.
Arranged and unarranged
Overdue debt only, split into:
Arranged: on an active payment plan or with a scheduled payment
Unarranged: nothing arranged
Note: A Promise to pay doesn't count as arranged.
Collection activity
A log of email and SMS reminders, notes, and the latest promise, broken promise, dispute or hold in the period. It shows who did each one and when. The report shows up to the latest 2,000 events.
Not being chased
Outstanding invoices that the reminder workflow will skip, with the reason:
the client's notifications are off, or
the invoice's branding theme doesn't have Send reminders ticked.
Check this report regularly to make sure nothing slips through.
Report options
Option | How it works |
|---|---|
As at | For Aged debtors, Open item listing, Arranged and unarranged, and Not being chased. Defaults to today. |
From / To | For Debtor movement and Collection activity. Defaults to the start of this month to today. |
Show report | Applies the dates you've chosen |
Practice / Group / Client | Choose how rows are grouped (Aged debtors, Debtor movement, and Arranged and unarranged) |
Search | Filter by client, group or invoice |
Print / Download CSV / Download PDF | Export the report as you see it |
Good to know: "As at" reports work out balances using payments made on or before that date. However, the status, assignee and arrangement columns show today's values.
Still need help?
Contact us