Receivables Report
How the Receivables report shows unpaid invoices, ageing buckets, customer balance concentration, and exportable debt snapshots.
The receivables report is the quickest way to see who owes money right now. Instead of looking at jobs or invoices one by one, it groups current unpaid invoice balances into an aged debtors view so you can spot how much is outstanding, how old it is, and which customers are carrying the biggest balances.
Business Filter
- Business: This report works on one business at a time. Change the business first if you need the debt snapshot for a different trading entity.
- Reset business filter: This removes the current override and puts the report back onto the default business in your reporting scope.
- No date range: There is no period filter here because the receivables report is a live snapshot as of today rather than a historical trend screen.
Aged Debtors Snapshot
- Total outstanding: The total unpaid balance currently sitting on open and sent invoices with money still due.
- Outstanding invoices: A count of invoices that still have a positive balance after payments and write-offs are taken off.
- Customers owing: How many customers make up that debt figure.
- Oldest invoice age: The oldest balance currently sitting unpaid in the selected business.
Below the headline totals, Work Planner breaks the debt into age buckets of 0 to 30 days, 31 to 60 days, 61 to 90 days, and 91+ days. That makes it easier to tell the difference between normal short-term debt and balances that need chasing.
Top Customer Balances and Side Signals
- Top customer balances: This panel shows the customers contributing the biggest balances. It also tells you how many invoices make up that debt, whether any are part-paid, and how old the oldest balance is for that customer.
- Average invoice age: Useful when you want a quick sense of whether the debt book is generally fresh or starting to drift older.
- Part-paid invoices: Counts invoices where some money has been received but a balance is still left to collect.
- Invoices using created date fallback: This appears when an invoice has no sent date, so Work Planner had to age it from the invoice creation date instead.
- Unallocated receipts: Completed payment rows that are not linked to an invoice. These do not reduce any ageing bucket until they are properly allocated.
- Write-offs recorded: A count and value of completed write-off rows for the selected business. These are shown as a side signal so you can see that debt has been removed elsewhere, even though those write-offs are not aged into the invoice buckets.
Outstanding Invoices Tab
The Outstanding Invoices tab lists every invoice still contributing to the receivables total. This is the screen to use when you need to move from the headline numbers into the individual debt rows behind them.
- Invoice: The invoice reference Work Planner is ageing.
- Customer: The customer name, with the customer reference underneath when one exists.
- Status: The report only includes invoices in Open or Sent status that still have money due.
- Invoice date: Work Planner uses the sent date where possible. If the invoice has never been marked as sent, the row is labelled Used created date so you can see the age is based on the fallback date instead.
- Age bucket and Age: These show where the balance currently falls in the debtor ladder and how many days old it is.
- Balance due: The remaining amount after paid amounts and write-offs have been deducted.
How Ageing Works
This report ages invoices from the invoice issue date, not from payment terms or due dates. In practice that means it is best used as an aged debtors review, not as a strict overdue report. Work Planner includes open and sent invoices with a current positive balance only. Fully paid, zero-balance, and over-credited invoices do not appear here.
Export Tab
The Export tab downloads the current receivables snapshot as CSV. Because the report is a live snapshot, the file reflects the debt picture at the moment you export it.
Related articles
- Reporting Overview: Start there if you want a wider finance picture before narrowing into debt only.
- Accounts Overview: Step back here when you want the broader accounts snapshot around the same business.
- Transactions List: Helpful when the debt picture suggests payments or finance rows may need checking.
- Customer Detail View: Useful when you need to jump from a debt signal back to the customer record itself.