Debtors Listing Report

The Debtors Listing Report shows the outstanding debts owed to the practice at the time the report is run. It is a point-in-time report and reflects the current state of patient and third-party balances. Use it to follow up overdue accounts, monitor aged debt across the practice, and prepare statements for billed-to parties.

Navigate to Accounts > Debtors Listing, then select either Detailed or Summary. The Debtors Listing selector opens. Configure the report using the sections below, then run it.

The Debtors Listing can be produced in two views.

View	Use for
Detailed	Following up specific overdue invoices. Lists each outstanding invoice for each debtor.
Summary	Reporting total outstanding debt at a glance. Shows one line per debtor with the total amount owed in each ageing bracket.

Enter a number of days into the Include Debts Older Than field to limit the report to debts older than that age.

If a patient has any debt within the date range, all of that patient's debts will be listed - not only the ones older than the threshold. For example, with Include Debts Older Than set to 30 days, the report includes every debt for any patient who has at least one invoice overdue by more than 30 days.

Use the Billed To filter to limit the report to invoices addressed to specific parties (for example patients, Medicare, DVA, or a Health Fund). Multiple options can be selected, and each appears as a separate row in the report.
Limit the report to a single billing location or include all locations. To break down debtors by location within a single report, tick Separate Locations.
Limit the report to a single doctor, or include all doctors if needed.
The Display Bracket Interval sets the ageing bracket size, in days, used in the report columns. The default is 30 days.

For example, with Include Debts Older Than set to 30 days and Display Bracket Interval set to 30 days, the report groups debts into columns for 30-59 days, 60-89 days, 90-119 days, and so on.

Use the Extra Options section to control how the report is printed.
- Location on new page - starts each billing location on its own page.
- Order by debt age/amount - orders the printed items by debt age or amount.

Run the report

Open Accounts > Debtors Listing and select Detailed or Summary.
Enter a value in Include Debts Older Than if you want to limit the report by debt age.
Select the Billed To options to include.
Select a Location (or all locations), and tick Separate Locations if you want a per-location breakdown.
Select a Doctor (or all doctors).
Set the Display Bracket Interval.
Tick any required Extra Options.
Click Go to generate the report.

The Debtors Listing reports on outstanding invoices, reversals, bad debts, and refunds. It does not include receipts, credits, adjustments, or GST entries that are not tied to outstanding debt.

For end-of-month workflows, run the Debtors Listing alongside the Receipts Listing, Item and Fees Report, and Adjustments Summary. Together they make up the standard end-of-month invoicing and receipting set.