Month-End AR Review Checklist: 20 Minutes Before You Close
Month-end close tells you what is in AR. It rarely tells you what to do about it.
Most teams run the aging report at month-end, confirm it ties to the balance sheet, and move on. That is the accounting job done. The collections job, deciding who needs attention next month and why, often never happens. A short, structured review fixes that without adding much to close.
Here is a 20-minute AR review to run before you close the month:
- Start with anything that crossed 30 days past due this month. These are the accounts still easiest to fix. Give each one a named owner and a dated next step. If you only have time for one part of this review, make it this one.
- Check last month's promised payment dates. Pull every "they said it would go out on the 20th" from your notes and confirm whether the money arrived. Any promise that was not kept is the first call of next month, because a missed promise is the clearest early warning you have.
- Clear unapplied payments and open credits. Unapplied cash makes the aging look worse than it is, and it confuses customers when they get a statement showing an invoice they already paid. Apply what you can, and list what you cannot so someone can chase the remittance detail.
- Pull disputes onto their own list. Disputed invoices need someone who can fix the underlying issue, not another reminder. Note who owns each dispute and when it will be resolved. If a dispute has been open more than a month, it needs escalation, not patience.
- Note who is new on the past-due list. A customer who is late for the first time is usually the easiest one to fix: a lost invoice, a new AP contact, a PO problem. Reach out early in the month while the issue is still small.
What to bring out of the review
- A short list of next month's priority accounts, each with an owner and a date.
- A list of unapplied payments and credits still to clean up.
- A dispute list with owners.
- One or two sentences for your CFO or owner on what changed this month, for example which large accounts slipped and which caught up.
Numbers worth glancing at
You do not need a dashboard for this, but two quick comparisons help. First, compare the 31 to 60 day bucket to last month: if it grew, more invoices are slipping past the easy-to-fix stage. Second, recompute DSO using the same window for AR and sales, for example a trailing 90 days. A DSO figure that mixes windows will drift for reasons that have nothing to do with collections.
Common mistakes
- Reviewing only the total. A flat total can hide a growing problem in the older buckets.
- Treating every past-due account the same. A first-time late payer and a chronic one need different conversations.
- Leaving decisions in the meeting. If an account does not leave the review with a dated next step, it will be in the same place next month.
- Skipping the review during busy months. Those are the months it matters most.
The aging report is the scoreboard. The review is where you decide the next play. Twenty minutes at month-end saves far more than that in the following weeks, because everyone starts the month knowing exactly which accounts they own.
Running the review in your accounting system
- QuickBooks Online: A/R Aging Detail for the buckets, the Collections Report for past-due invoices by customer, and the Undeposited Funds and unapplied payments views for cash that is not yet applied.
- NetSuite: the A/R Aging Summary and Detail reports, plus a saved search for unapplied payments and open credit memos.
- Xero: the Aged Receivables Detail report, plus a check for unallocated credit notes and overpayments.
- Sage: the aged receivables report and any unallocated receipts or credit notes.
- Microsoft Dynamics 365 Business Central: the Aged Accounts Receivable report, plus open customer ledger entries that are payments or credit memos not yet applied.
Nectivo.ai keeps live DSO and aging by bucket next to every account's notes and next-step date, so this review starts from a list that is already up to date. Nectivo.ai syncs directly with QuickBooks Online. Teams on NetSuite, Xero, Sage, Microsoft Dynamics or another accounting system can upload an AR aging report export as a CSV or Excel file and work from the same daily list.
Related: QuickBooks collections software · Free DSO calculator · Pricing