Reports

Find the data you need to strengthen and build your business.

Ageing Debts Report

Austin Written by Austin
... on a fabulous February day.


📖 In This Article

What can you use this Report for?
Filters and Options
What is displayed in the report?
Details
Expanded Details
Tips and Tricks


The Ageing Debts Report calculates outstanding account balances and displays them by the length of time unpaid.

What can you use this Report for?

Identify debts owed to you by Third-party payers or by private clients and compile a list with invoices details and balances.

Use it to track debtors and the expanded list can be used to send details of unpaid accounts to relevant Payers.

Filters and Options

Filters Description
Date * Filters Items invoiced date – regardless of the Invoice date.

* We highly recommend keeping the Date range as “10 Years” to generate accurate and current debtors data.

Location Invoice Location – regardless of the Payment location.
Providers Select a specific Provider to easily find unpaid items attributed to this Provider.
Show Expanded If ticked, each Invoice will be shown in a separate row, see Expanded Details table
Payers Select specific Payers to generate debt amount and send accounts.
Sort Sort the list by Clients to group all Invoices for each Client – regardless of the Payer or Payers to group all Invoices addressed to the Payer – regardless of the Clients.
Services Include all, exclude all or select specific Services to filter specific debt amount.
Classes Include all, exclude all or select specific Classes to filter specific debt amount.
Inventory Include all, exclude all or select specific Inventory items to filter specific debt amount.
Passes Include all, exclude all or select specific Passes to filter specific debt amount.
Others Include or exclude Other items in the unpaid amount.

What is displayed in the report?

  • Items, invoiced within the timeframe, matching the filters, that were still unpaid at the selected End Date.
  • Summary table displays the total unpaid amount in 30 days period up to over 90 days.

Details

Column Description
Type or Client* Third-party payer in debt (when sorted by type) or Clients with unpaid invoices in their Client Accounts (when sorted by Clients).
Invoices Number of invoices with outstanding balance.
0 – 30 Days

31 – 60 Days

61- 90 Days

>90 Days

Total outstanding amounts in date range by invoice date.
Amount Total outstanding amounts matching all filters and date range for the Third-Party payer or Client.

Expanded Details

Column Description
Invoice Date Date of the outstanding invoice
Client Client the invoice was generated for.
Type Private or Third-party payers the invoice is addressed to.
0 – 30 Days

31 – 60 Days

61- 90 Days

>90 Days

Total outstanding amounts in date range by invoice date.
Amount Invoice’s total outstanding amount.

Tips and Tricks

  • When not in expanded view, click on the row of the Third-party payer or the Client to expand a list of all the outstanding invoices with their details.
Help Centre

How can we help?

Chat with Us!
🍪 Cookies