Accounts Receivable Aging Report for Manufacturers: Get Paid Without Chasing Invoices by Hand

It is Friday afternoon. The parts shipped six weeks ago, the invoice went out the same day, and the money is still not in the bank. So you do what you do every Friday: export the invoice list, sort it by date, highlight the scary ones in red, and start writing the same awkward email for the fourth time. "Just following up on invoice 2026-00007..."

If that routine feels familiar, you are in good company. Only about half the value of B2B invoices in the US gets paid on time. Roughly 43 percent slips overdue, and around 5 percent is never collected at all. For small businesses the picture is getting worse, not better: nearly six in ten are now carrying invoices more than 30 days overdue, waiting on about $17,700 each on average.

An accounts receivable aging report is the classic tool for this problem, and manufacturers need it more than almost anyone. You buy material and pay wages months before you can even send the invoice, then wait out net 30 or net 60 terms on top. This post walks through how AR aging works, where the spreadsheet version breaks down, and how Qualis pairs the aging report with a collections worklist and automated, escalating payment reminders so the chasing happens even when nobody has time to chase.

What an accounts receivable aging report actually tells you

An aging report takes every unpaid invoice and answers one question: how long has this money been waiting?

Each open invoice lands in a bucket based on its due date:

• Current: not yet due. Healthy money.
• 1-30 days overdue: a nudge is enough for most of these.
• 31-60 days overdue: something is stuck. Time to pick up the phone.
• 61-90 days overdue: your invoice is now financing someone else's business.
• 90+ days overdue: every week here lowers the odds you ever see the money.

The buckets matter because time is the enemy. The longer an invoice sits unpaid, the lower the chance it is ever collected. That quiet 90+ column is where write-offs are born.

For a manufacturer, the stakes are higher than the averages suggest. Typical collection periods across industry benchmarks run around 45 to 60 days, against terms that usually say 30. That gap is real cash: material you already bought, hours you already paid for, sitting inside other companies' bank accounts. To bridge it, many suppliers end up borrowing, at interest, against money they have already earned.

One number worth knowing: your annual revenue divided by 365 is roughly what one day of DSO (days sales outstanding) is worth to you in cash. Shave a week off your collection time and you have found a meaningful line of credit that costs nothing.

Where the spreadsheet version quietly breaks

Most shops do have an aging report. It lives in a spreadsheet, exported from the accounting tool once a week, and it fails in three predictable ways.

It is stale by Monday. A payment lands, a credit note is issued, a new invoice goes out, and your carefully highlighted export no longer matches reality. Decisions get made on last week's numbers.

It treats every overdue dollar the same. A $250 invoice at 95 days and an $11,000 invoice at 40 days look like two red rows. One of them deserves a call this morning. The report does not say which.

Follow-up depends on memory. The first reminder goes out when someone remembers. The second one goes out never. In one study, roughly two thirds of businesses spent about 14 hours every week on the administration of collecting payments, and the output of all those hours is still inconsistent.

Here is the part that should sting: about a third of late payments are pure process friction on the customer's side. The invoice never reached the right inbox, it is sitting in an approval queue, or accounts payable simply lost track of it. Those customers are not refusing to pay. They are waiting, without knowing it, for a reminder you keep not sending.

How the AR aging report works in Qualis

In Qualis, AR aging is a live page, not an export. Open Invoicing, then Aging and the report is computed on the spot from every open invoice, in your base currency, even when you invoice some customers in other currencies.

At the top, four tiles give you the whole story in five seconds:

• Total AR: everything customers currently owe you.
• Overdue: the portion already past its due date.
• DSO: how many days, on average, it takes you to collect.
• CEI: the collections effectiveness index, a 0 to 100 score of how much collectable money you actually collected.

Below the tiles sits the aging matrix: one row per client, one column per bucket, with a totals row across the bottom. And every number is a door, not a dead end. Click any cell and Qualis opens the exact invoices behind it, already filtered to that client and that ageing window. There is no rebuilding the list in a spreadsheet to answer "OK, but which invoices are those?"

The collections worklist: chase the money, not the list

Under the matrix, Qualis keeps a collections worklist: the most valuable overdue invoices, biggest balance first, each with its client, due date and days overdue.

This is the difference between "work the aging report" and "work the right ten invoices". Fifteen minutes with this list every morning beats an afternoon with a spreadsheet every Friday, because effort lands where the money is.

Automated payment reminders: the dunning ladder

Now for the part that removes the Friday ritual entirely. Qualis includes dunning levels: an escalating ladder of automatic payment reminders that the system evaluates every day.

A typical ladder looks like this:

1. First reminder, 7 days overdue, friendly tone. "This may have slipped through, here is the invoice."
2. Second reminder, 15 days overdue, firmer tone.
3. Final notice, 30 days overdue, formal tone, with a full statement of account attached as a PDF.

Each level is a rule you control: how many days overdue it triggers, a minimum amount so small balances do not get formal notices, the tone of the message, and whether the statement of account rides along. Reminders go to the customer's billing contact in the customer's own document language.

The escalation logic is built to never spam:

• One reminder per level, ever. Qualis records which level each invoice has received. A reminder is never repeated, and a same-day re-run sends nothing twice.
• It jumps, it does not pile up. If an invoice is already 35 days overdue when you switch dunning on, the customer gets the final notice. Not three emails in one morning.
• Payments switch it off automatically. The daily sweep only looks at invoices with an open balance. The moment a payment is recorded, the invoice leaves the scan. Nobody gets dunned for an invoice they paid yesterday.

When a human should take over

Automation should know when to stop. On every invoice, a Collections & dunning card shows the last reminder sent and the next one due, and lets you set a collections status that gates the automation:

• Disputed: the customer contests the invoice. Reminders stop until it is cleared.
• Promise to pay: they committed to a date. Reminders pause until that date passes.
• Paused: a manual hold, for whatever reason, with a note.

You can also exclude specific clients from dunning entirely, for the strategic account your sales director prefers to call personally, and the whole system sits behind a master switch that is off until you decide you are ready. From the same card, you can download the customer's statement of account or email it on demand. Every time a reminder does go out, the invoice's owner gets a notification inside Qualis, so the follow-up call happens with full context.

What changes when the reminders are consistent

The polite fiction about collections is that it requires toughness. It mostly requires consistency, and consistency is exactly what a busy team cannot deliver by hand.

Remember that a third of late payments are process friction. A well-timed reminder with the invoice attached, followed by a statement of account, resolves those without a single phone call. The phone calls that remain are the ones that matter, and the worklist tells you which ones those are.

The results show up in the metric that counts. Roughly six in ten companies that automated their receivables saw DSO improve, and adopters of automated collections typically shorten DSO by 15 to 25 percent. On net 30 terms with a typical manufacturing collection cycle, that is a week or two of your own revenue coming back onto your side of the table, without financing costs and without hiring anyone.

And there is a quieter benefit: a record. Every reminder is stamped on the invoice, with its level and date. When the conversation with a customer turns serious, you are not reconstructing who emailed whom from a sent folder. The history is on the invoice.

From due date to paid: the full loop

Put together, collections in Qualis becomes a loop that runs itself:

1. An invoice is finalized and gets its due date.
2. The due date passes. The invoice appears in the aging report and, once it qualifies, in the collections worklist.
3. Each day, the dunning sweep checks every open invoice against your reminder ladder and sends exactly the level that applies, in the customer's language, with the statement attached when the rule says so.
4. Disputed or promised invoices wait. Excluded clients are skipped. Paid invoices drop out on their own.
5. A payment arrives and is recorded. The balance clears, the aging report updates, and the loop closes.

Your team's part of the loop shrinks to the worklist and the judgment calls. The remembering, the drafting, the "did we already send them something?", all of that belongs to the system.

Frequently Asked Questions

What is an accounts receivable aging report?

An accounts receivable aging report lists every unpaid customer invoice and groups it by how long the invoice has been outstanding, typically in buckets of current, 1-30, 31-60, 61-90 and 90+ days past due. It shows who owes you money, how much, and how overdue it is, which makes it the starting point of any collections process.

What is a dunning email?

A dunning email is an automated payment reminder sent to a customer whose invoice is overdue. Dunning usually works as an escalating sequence: a friendly note a few days after the due date, a firmer follow-up later, and a formal final notice, often with a statement of account attached. In Qualis, each step of that ladder is a configurable dunning level.

How often should I send payment reminders on overdue invoices?

A widely used cadence is a friendly reminder about a week after the due date, a firmer one around two weeks, and a final notice at 30 days with a statement of account. What matters most is consistency: reminders that always arrive on schedule outperform occasional intense chasing, which is why an automated ladder beats a manual routine.

Will automated payment reminders annoy my customers?

Not when they are spaced sensibly and escalate gradually. Most B2B customers treat a polite, well-timed reminder as normal professional practice, and a large share of late payments happen simply because the invoice got lost in the customer's process. Good automation also knows when to stay quiet: in Qualis, disputed invoices, promised payments and excluded clients are never dunned.

What is the difference between an invoice and a statement of account?

An invoice bills one specific sale and creates the obligation to pay. A statement of account summarizes everything currently open on the customer's account: each unpaid invoice, its age and its balance, subtotaled per currency. Statements are ideal for customers with several open invoices, which is why Qualis can attach one automatically to a final notice or email one on demand.

What is a good DSO for a small manufacturer?

Manufacturing DSO typically runs between 45 and 60 days, reflecting longer production cycles and larger order values than service businesses. The more useful comparison is against your own payment terms: if you sell on net 30 and your DSO sits near 60, roughly a month of revenue is trapped in receivables, and consistent reminders are usually the cheapest way to pull it back.

The bottom line

Late payment is not an occasional accident. It is the default state of B2B invoicing, and it hits manufacturers hardest because your costs land months before your cash does.

An accounts receivable aging report tells you where the money is stuck. A collections worklist tells you which calls are worth making today. An automated dunning ladder makes sure every other invoice still gets chased, politely, consistently, in the customer's language, without anyone spending Friday afternoon on it.

In Qualis, all three live on one page, wired directly to your invoices, with every reminder recorded where the whole team can see it. If deposits and progress billing are part of your world too, see how deposit invoices settle themselves on the final bill, and how Qualis locks the exchange rate to the document so foreign-currency receivables age at honest values.

Ready to see your own aging report compute itself? Book a demo of Qualis and bring your worst spreadsheet.