Aged receivables
What each customer owes on unpaid invoices, split by how far past the due date it is, with totals and a statement for each customer.
Aged receivables shows who owes you money on invoices, and how long it's been owing. Use it to see which customers to chase first.
What's on the page
There's one row for each customer with something still owing on an invoiced sales or work order. The biggest Total owing is at the top.
- Customer: who owes it. You can search by name.
- Current: owing on invoices that aren't due yet, or have no due date.
- 1–30 days, 31–60 days, 61–90 days and Over 90 days: owing on invoices that far past their due date.
- Total owing: everything the customer owes on invoices.
The bottom row adds up each column across all customers. You can sort by any column.
What's owing is the order's total less the payments recorded against it, so part-payments are taken off. Paid and cancelled orders aren't included. If nothing is owing, the page says Nothing is owing.
Statements
Statement on a row makes a statement for that customer. It shows what they owe now. Choose:
- Activity: every invoice, payment and credit between the From and To dates (the start of the month two months ago to today, to start with), with a running balance.
- Open items: only the unpaid invoices, by how overdue they are.
Email it to is filled in with the customer's email. Change it to send it somewhere else, or leave it blank to download the PDF instead. Then click Send or download.
Good to know
- The ages are worked out from each invoice's due date and today's date in your workspace's time zone.
- Credit a customer holds isn't taken off what they owe here. It's used up automatically on their next invoices.
- You need to be able to see account entries (the View any permission on the Transaction tab of a permission set) to open this page.