Business Central receivables ageing can show whether your collection efforts are improving cash flow. Yet invoices may keep slipping into older buckets, even while customers make payments.
Business Central receivables ageing should help you establish whether collection activity is improving the position, which customers need attention, and what changed between reporting dates. A total outstanding balance cannot answer those questions on its own.
brings these questions together in its . Its Power BI reports help finance teams review customer balances, overdue invoices and payment trends, with historical ageing for comparisons between reporting dates.
In our guide to 20 Business Central financial ratios, we explored days sales outstanding and cash conversion. This article takes the next step: investigating the customer balances behind those indicators and deciding what to do about them.
Business Central receivables ageing at month end
Start with three questions. How much is overdue? Where is the risk concentrated? Is the position improving on a consistent basis?
Total receivables include invoices still within agreed payment terms. Overdue receivables identify commitments that have reached or passed the relevant due-date boundary. Mixing the two can make a growing business look like it has a collections problem when recent sales explain much of the increase. ACCA’s explanation of describes how sales volumes, credit terms and collection processes affect the balance.
The opposite can happen too. A stable total can hide a worsening profile if older unpaid invoices remain while newer balances are collected quickly. Look at the distribution and the customers behind it, rather than judging progress from the total alone.
Why today’s open invoices cannot explain last month end
Imagine a £10,000 invoice that was unpaid on 30 September. The customer settled it on 10 October. By the end of October it is no longer an open invoice, but it still belongs in the September month-end position.
If you filter only today’s open invoices by an earlier date, that settled invoice disappears from the comparison. The report may understate what was owed at the time.
Illustrative example: a later payment changes today’s balance, not what was owed at the earlier reporting date.
Historical analysis needs a report that reconstructs the balance at the selected date. The Receivables Aging (Back Dating) report in Accounts Receivable Insights provides that view, including invoices that have since been settled.
Keep the distinction clear when setting up the review. A current view supports today’s collection work. A historical view supports a fair comparison with a previous reporting date.
How to compare Business Central receivables ageing
Choose the right date for Business Central receivables ageing
Due-date ageing is normally the useful starting point for collection priorities. Document date measures the age of the document, which can be a different question. An invoice raised 45 days ago on 60-day terms is not automatically overdue.
Keep the reporting date, bucket lengths and treatment of invoices due on that date consistent. Changing those choices between reviews makes it harder to tell whether customers changed their behaviour or the report changed its rules.
Make reconciliation reproducible
Record the company, currency, inclusion basis and refresh date alongside the figures. Check payments, credits and applications when a customer balance looks unexpected. Avoid adding amounts in different transaction currencies without a common reporting basis.
Agree which ledger totals and reporting settings the team will use for reconciliation, then retain those choices for the next review.
Investigate overdue receivables in Business Central
Once the comparison is sound, investigate customers whose older balances are increasing. Microsoft partner Catapult’s guide to covers ageing settings, overdue-balance investigation and reconciliation to the general ledger. A single material account may deserve attention even when the overall company result appears acceptable.
Ask what explains each movement. Was there a payment, a credit, a new invoice, a dispute or an application issue? A lower balance is useful information, but the reason determines whether the collection process improved.
Then review the relevant invoices with the account owner. Confirm the reference, due date, outstanding amount and latest customer commitment. That preparation makes the next conversation specific and reduces unnecessary chasing.
What this looks like in practice at Manuchar
illustrates the value of trusted reporting and a route to supporting transactions. The South African group uses Business Central Insights across five entities and 25 users. Its published results include faster issue investigation and around three hours saved per user each day across reporting and analysis.
Those are outcomes from the wider Business Central Insights implementation. The relevance to receivables is the working discipline: spend less time assembling and debating figures, and more time investigating the entries and agreeing the next action.
Manuchar reports these results across its wider Business Central Insights implementation, rather than from the receivables ageing report alone.
Using Business Central receivables ageing for collections
A useful meeting ends with a short list of actions that people can complete before the next review.
- Prioritise material overdue balances and customers moving into older buckets.
- Confirm whether each issue needs customer contact, dispute resolution, a ledger correction or an internal decision.
- Assign an owner and a follow-up date in the existing collection process.
- Revisit commitments alongside the updated balances at the next meeting.
Review results with commercial context. A customer with a disputed delivery needs a different response from one waiting for a copy invoice. Reporting helps identify the issue; the team still needs to resolve it.
Historical Business Central receivables ageing in Power BI
The explains how to select an as-of date and review the balance through Power BI reports. The report can reproduce earlier balances even where invoices have since been settled.
For a ledger reconciliation, retain the Posting Date inclusion basis and match the comparison settings. The ageing basis controls the buckets; inclusion controls which entries qualify. Treat those as separate decisions.
A practical next step
Choose a previous month end and a handful of familiar customers. Reproduce the balances, investigate later payments and confirm that the comparison is consistent. Then use that trusted view to review the next collection priorities.
Explore the historical receivables ageing tutorial through the link above, or to review the approach with your team.
Business Central receivables ageing: frequently asked questions
Does a falling receivables balance prove collections improved?
No. Credits, changes in sales activity or report selections may also affect it. Check the movements and the older debt profile before drawing a conclusion.
Can I recreate last month end from today’s unpaid invoices?
Not reliably. Invoices that were outstanding then may have been paid since. Use a historical report that reconstructs the balance at the selected date.
Should we use document date or due date?
Use due date when assessing payment timeliness. Document date is useful for invoice-age analysis. Agree the purpose and apply the same basis to each comparison.