Ageing Debts Report – Nookal

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	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.

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.

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.

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.

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.
This report includes line items and payments that fall within the selected Date Range only. To ensure all past and current invoices and payments are factored in we recommend using "10 years" as the Date Range.

Related to