Xero Accounts Receivable Monthly Health Check: A Step-by-Step Checklist

Most Australian small business owners open Xero to create invoices and not much else. But Xero contains a goldmine of data about the health of your receivables — data that, when reviewed monthly, can prevent cash flow crises before they happen.

A monthly accounts receivable (AR) health check takes about 30 to 45 minutes. Done consistently, it will reduce your overdue balances, improve your days sales outstanding (DSO), and give you early warning of problem clients before they become bad debts. Here is exactly how to do it.

Why a Monthly Review Matters

The gap between invoicing and collection is where cash flow problems are born. A client who was 7 days overdue last month and is now 37 days overdue is on a trajectory that needs intervention. Without a regular review, these situations escalate quietly until they become serious.

Research consistently shows that the probability of collecting a debt drops sharply the longer it remains unpaid. An invoice that is 90 days overdue has roughly a 50% chance of never being collected. At 120 days, that figure worsens further. Monthly reviews ensure you catch problems in the early, recoverable stage.

Step 1: Run the Aged Receivables Summary Report

Start every monthly review here. In Xero:

1. Go to Reports in the main menu.
2. Under Receivables, click Aged Receivables Summary.
3. Set the report date to the last day of the month you are reviewing.
4. Click Update.

The report groups outstanding invoices into columns: Current, 1-30 days overdue, 31-60 days, 61-90 days, and 90+ days. Your goal is to keep as much of your receivables balance in the Current column as possible.

Export this report to PDF or CSV and save it with the month and year in the filename. Having a monthly archive lets you track trends over time — something the live Xero dashboard does not show you automatically.

What to look for in the Aged Receivables Summary

• Any clients in the 61-90 days column who were also in 31-60 days last month — they have been overdue and not engaging.
• Any new entries in the 90+ days column — these need immediate escalation.
• The total 90+ balance compared to last month. Is it growing, shrinking, or stable?
• Your single largest overdue debtor. Concentrated risk in one client is a red flag.

Step 2: Review the Aged Receivables Detail Report

Once you understand the summary picture, drill into the detail. Run the Aged Receivables Detail report for the same period. This shows you individual invoices, their due dates, and how many days overdue they are.

Focus on:

• Invoices over 30 days: Have payment reminders been sent? Check the invoice history in Xero by clicking the invoice and reviewing the activity log.
• Invoices over 60 days: Is there an active conversation with the client? A note in the contact record?
• Invoices over 90 days: Is this now a formal collection matter? Have you spoken with your accountant about whether a bad debt provision is needed?

Step 3: Calculate Your Days Sales Outstanding (DSO)

DSO tells you, on average, how many days it takes to collect payment after invoicing. It is one of the most useful single metrics for tracking AR health over time.

The formula is straightforward:

DSO = (Total Accounts Receivable ÷ Total Credit Sales) × Number of Days in Period

For a monthly review: use your end-of-month AR balance from the Aged Receivables Summary, your total invoiced revenue for the month from Xero's Profit and Loss report, and 30 as the number of days.

Track this number monthly in a simple spreadsheet. A rising DSO is an early warning signal; a falling DSO means your collection processes are improving.

Step 4: Review Your Xero Invoice Reminder Activity

Xero's built-in reminders are a good starting point, but they have limitations: they only send on a fixed schedule and cannot adapt to the tone or history of individual client relationships. During your monthly review, check:

• Are Xero reminders enabled and configured? Go to Settings → Invoice Settings → Reminders to confirm.
• For your largest overdue clients, have personalised follow-ups been made (phone, email, or through a tool like PaidMate)?
• Are there any clients who have asked to be excluded from reminders? Confirm this is documented in their contact record rather than as an informal arrangement that might be forgotten.

Step 5: Segment Your Debtors by Risk

Not all overdue invoices deserve equal attention. A quick monthly segmentation saves you time and focuses your energy where it matters most. Group your overdue debtors into three categories:

• Green (monitor): Occasionally late, good payment history overall, relatively small amounts. A single reminder or brief email is usually enough.
• Amber (active follow-up): Repeat late payers, growing balances, or clients who have stopped communicating. These need personal outreach this week.
• Red (escalate): 90+ days overdue, large balances, unresponsive, or signs of financial difficulty (changed contact details, bounced emails, news of trading difficulties). Consider formal demand letter, payment plan negotiation, or referral to a collection agency.

Write this segmentation into the notes field of each relevant contact in Xero, with today's date. Next month, you will have a record of what category they were in and whether the situation improved or worsened.

Step 6: Check for Unapplied Payments and Credits

One surprisingly common source of inflated AR balances is unreconciled payments and unapplied credit notes. Run a quick check:

1. In Xero, go to Business → Invoices.
2. Filter by status: look for any invoices with partial payments that have an outstanding balance you were not expecting.
3. Check your Credit Notes list: are there credit notes that have not been applied to outstanding invoices?
4. In your Bank Reconciliation, confirm there are no unreconciled deposits from clients that should be matched to invoices.

Tidying these up is often the fastest way to reduce your reported AR balance — and it ensures your Aged Receivables reports actually reflect reality.

Step 7: Set Your AR Goals for Next Month

End every monthly review with a short list of goals for the coming month. Keep it simple:

• Target DSO for next month's review: ___
• Total 90+ days balance to clear or reduce: ___
• Specific clients requiring personalised follow-up: ___
• Any process changes to implement (e.g., adjusting payment terms for a specific client, enabling automated reminders for a new client category): ___

Writing these down — even informally in a note attached to the exported report — turns a passive review into an active management tool.

The Monthly AR Health Check: Full Checklist

How PaidMate Supports Your Monthly AR Review

The most time-consuming part of a monthly AR review is the follow-up: drafting individual emails or making calls to clients in the Amber category. PaidMate automates this step while keeping your tone professional and relationship-preserving.

Instead of sending a generic Xero reminder, PaidMate sends personalised, conversational messages through your Xero account that feel like a real person wrote them — because the content is tailored to the invoice amount, the client relationship, and where they sit in the overdue cycle. The result is higher response rates and faster payment, without the awkwardness of chasing money manually.

When you run your monthly health check and find a cluster of Amber debtors, you can action the whole group through PaidMate in minutes rather than spending an afternoon on individual emails. It is the difference between a review that generates action and one that sits on your to-do list.

Final Thoughts

A monthly accounts receivable health check is one of the highest-leverage habits an Australian small business owner can build. It takes less than an hour, requires no specialist skills beyond knowing where to find reports in Xero, and pays for itself many times over in reduced bad debts and improved cash flow.

Set a calendar reminder for the first business day of each month. Block 45 minutes. Run through this checklist. Your future self — and your cash flow — will thank you.

PaidMate — Get paid without burning bridges. Intelligent payment reminders for Australian businesses, integrated with Xero. www.paidmate.com.au