How to use MYOB Business’s Unpaid invoices report for ageing
Key facts
Use the report as a list of balances to verify, then use the invoice details to decide what to chase.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Trace a customer total back to invoices
- Use today’s date for a live collections review. Check the customer filters and report options before comparing results with an earlier run. If you need a past month-end balance, verify the cut-off and reconcile the results against dated invoice and payment records.
- Find the customer and review how the outstanding amount is distributed across the ageing columns. Expand the results to see the invoice-level amounts. Use Expand all if you need the detail for every customer.
- Record the invoice references that make up the balance. In Sales > Invoices, open the relevant invoices and verify the due dates, current amounts due and any payments or credits added since the report was run.
- If you export the results for the team, keep the report date and filters with the file. Use the invoice references to assign follow-up and record any exceptions.
See sales reports guide.
Example of ranking two unpaid invoices
For example, a Sydney distributor sees A$3,200 outstanding for a trade customer. Expanding the report shows A$2,400 on INV-712 and A$800 on INV-748. In the invoice records, INV-712 is overdue and INV-748 is due next week. The credit controller follows up on A$2,400 and keeps A$800 on the list of upcoming receipts. If an A$500 payment has just arrived for INV-712, the controller verifies and applies it before sending a request for the remaining A$1,900.
Check unexplained differences before chasing
If an invoice is missing or ageing looks wrong, start with the report date, customer filter and the invoice’s issue and due dates. Then check whether bank receipts or credits have been allocated to the intended invoices. A report saved last week can still be useful for comparison, but recheck the live amount due before using it in a message.
If the invoice totals disagree with the linked receivables category, run Reporting > Exceptions dashboard and review Receivables reconciliation exceptions where available on your plan. MYOB lists a receipt entered as Receive money and a payment or credit dated before its invoice as possible causes. See MYOB’s guidance on reviewing receivables exceptions.


.webp)