Accounts receivable aging report for commercial follow-up

What an AR aging report should show by customer

An accounts receivable aging report for commercial follow-up lists every unpaid invoice by customer, sorted into age bands counted from the due date, with the account owner, any dispute and the last contact shown alongside. Its job is to tell the salesperson or account manager which customer to call this week and why, not only to show finance the total overdue.

Finance usually builds aging reports for the balance sheet, where the question is whether receivables are recoverable. Commercial teams need a different cut of the same data, arranged around the relationships they manage.

Both versions must come from the same ledger. If sales receives a separately maintained list, it will soon disagree with finance's figures, and the weekly conversation turns into an argument about whose numbers are right instead of which customer to call.

Why collections stall when only finance reads the report

Finance can send reminders, but a reminder from finance usually lands with the customer's payables clerk, who cannot pay an invoice their own operations team has not approved. The salesperson knows the customer's project manager or procurement head, the person who can actually clear the blockage.

When the aging report stays inside finance, overdue invoices become finance's problem alone, and the sales team keeps offering new orders to a customer already well behind. Sharing the report with account owners puts overdue balances into the commercial conversation, including whether to extend further credit.

Columns that make the report usable outside finance

Sort by account owner, so each salesperson receives their own customers rather than the whole company's ledger.

• Customer name and the internal account owner responsible for the relationship
• Invoice number, invoice date and due date
• Outstanding amount per invoice, not only the customer total
• Age band from the due date, starting with current and moving through increasing overdue bands
• The customer's purchase order or project reference, which their staff will recognise
• Dispute flag with a short reason
• Date and outcome of the last collection contact
• Promised payment date, if the customer gave one

Separating disputed invoices from slow payers

A disputed invoice and a slow-paying customer call for different actions. Chasing a disputed invoice for payment irritates the customer and wastes time, because nothing moves until the dispute is resolved. Treating a slow payer as a dispute lets them delay indefinitely.

When a customer raises an issue, log it against the specific invoice with the reason and an internal owner, often in operations or project delivery. Disputed items can stay on the aging report but should appear as a separate group with their own follow-up. If the complaint is valid, the remedy is a credit note. If it is not, the owner sends the evidence and the invoice goes back into normal collection.

Unapplied receipts are a third category that distorts the report. A customer pays a round sum without saying which invoices it covers, and the money sits on account while the invoices keep ageing. Allocate receipts quickly, and when remittance details are missing, ask the account owner to get them from the customer. Otherwise the salesperson chases invoices the customer believes are already settled, which damages the relationship for no reason.

A weekly collections review with commercial heads

Hold a short weekly review chaired by the finance controller or credit manager, with commercial heads attending. Take the oldest balances first and the largest second. For each, the account owner gives the latest position and the next action with a date. Promises to pay are logged and checked the following week.

The meeting is also where credit holds are decided. If a customer is consistently beyond terms, the commercial head and finance agree together whether to pause new orders, so the decision is not left to a clerk blocking a delivery without warning.

Track whether promised dates were kept. A customer who breaks several promises needs escalation to a more senior contact on their side.

Send the report to account owners a day before the meeting, so updates are prepared rather than improvised in the room. Keep a running action log from week to week; an action that carries over three times without progress goes to the commercial director.

Getting aging data directly from invoicing records

The report is only useful if receipts show up as soon as they are recorded. BukuCloud produces AR aging reports from the invoices raised in it and the payments recorded against them, so the version finance shares with sales is the same data that supports the balance sheet. See bukucloud.com.

Frequently asked questions