Free to read β’ Save or share with one click
A How To Review Debtors Accounts document is a structured operational guide that walks finance teams and business owners through the end-to-end process of examining outstanding customer balances, categorizing them by aging bracket, assessing collectability, and assigning concrete follow-up actions. It combines a step-by-step review methodology with a working template for recording aging data, credit risk ratings, collection contacts, doubtful debt provisions, and write-off recommendations β all in a single, sign-off-ready document. Unlike a system-generated aging report, this template captures the management decisions and action ownership that turn raw receivables data into recovered cash.
Without a structured debtors review process, overdue balances accumulate quietly while the business assumes customers are simply slow to pay. By the time a 30-day balance becomes a 90-day balance, the collection conversation is significantly harder and the likelihood of full recovery has dropped sharply. Businesses that skip formal reviews consistently report higher DSO, larger bad-debt write-offs, and cash-flow shortfalls that force emergency borrowing. A completed debtors review also provides the documented provisioning and collection history that auditors and lenders expect β presenting an undocumented receivables ledger to a bank during a covenant review or a line-of-credit application is a common and avoidable cause of financing delays. This template gives you the framework to run a consistent, defensible review every month in under three hours.
| If your situation is⦠| Use this template |
|---|---|
| Monthly internal review for a business with under 50 active debtors | How To Review Debtors Accounts |
| Generating a formal aging report for a board or lender | Accounts Receivable Aging Report |
| Sending a structured reminder to an overdue customer | Overdue Invoice Letter |
| Assessing whether to extend credit to a new customer | Credit Application Form |
| Writing off an uncollectable balance and documenting the decision | Bad Debt Write-Off Authorization |
| Escalating a balance to a collections agency or legal action | Demand Letter for Payment |
| Tracking cash collections against targets month over month | Cash Flow Forecast Template |
Why it matters: A Net 30 invoice issued 25 days ago is not yet overdue β aging from the issue date creates false urgency, wastes time chasing accounts that are current, and makes the overdue percentage appear higher than it is.
Fix: Configure your accounting system or aging template to calculate days overdue from the invoice due date. Verify the setting before each review cycle.
Why it matters: Disputed balances inflate the overdue total, distort DSO, and lead to collection calls on amounts the customer legitimately contests β damaging the relationship without recovering any cash.
Fix: Maintain a separate dispute register. Exclude disputed amounts from the standard aging analysis and track them independently until resolution.
Why it matters: A review that produces a list of required follow-ups with no named owner or due date reliably results in the same overdue balances appearing unchanged at the next review.
Fix: Assign a specific person's name and a deadline to every action raised. Review completion of prior-period actions as the first agenda item in each new cycle.
Why it matters: Unreconciled variances between the subsidiary ledger and control account mean the aging totals do not reflect the true receivables balance β leading to incorrect provisioning and misleading board reporting.
Fix: Make ledger reconciliation the mandatory first step of the review. Do not proceed to aging analysis until any variance is identified and documented, even if it cannot be resolved immediately.
Why it matters: A blanket 5% provision applied to all balances over 60 days misses concentration risk β one high-balance insolvent debtor can require a 100% provision while other 60-day balances are fully recoverable.
Fix: Apply aging-bracket percentages as a baseline but supplement with specific provisions for any debtor identified as High risk in the credit risk assessment section.
Why it matters: In most jurisdictions, a bad debt can only be claimed as a tax-deductible expense if the business can demonstrate it made genuine efforts to recover the amount. Undocumented write-offs also weaken audit defenses.
Fix: Record every collection contact in the follow-up log as it happens. Attach copies of demand letters or call notes to the write-off recommendation before submitting for authorization.
Enter the period-end date and confirm which entities, business units, or customer segments are included in this review cycle.
π‘ Run the review within three business days of month-end while the data is current and any payment receipts are fully posted.
Pull the total from the debtors subsidiary ledger and compare it to the accounts receivable control account in the general ledger. Investigate and document any variance before proceeding.
π‘ A common reconciling item is a payment received and posted to the bank but not yet applied to the customer's account β clear these before aging.
Export the aged receivables report from your accounting system and enter or paste the balances into the aging summary section. Confirm that aging is calculated from each invoice's due date, not its issue date.
π‘ Separate disputed invoices from clean overdue balances at this stage β mixing them distorts your true overdue exposure.
Review payment history, recent communications, and any known financial difficulties for each debtor. Assign a Low, Medium, or High risk rating and record the specific basis for your assessment.
π‘ Check trade credit reports or news sources for any publicly available information on high-balance debtors you have rated Medium or High.
Record all contact made since the last review β calls, emails, letters β with the date, outcome, and next planned action for each overdue account.
π‘ Log contacts within 24 hours of making them. Reconstructing a contact history from memory at review time is unreliable and creates gaps.
Apply your standard provisioning percentages to each aging bracket and add any specific provisions for individually identified high-risk debtors. Compare the result to the current ledger provision and calculate the required adjustment.
π‘ Document the provisioning percentages used and obtain management approval if the required adjustment exceeds a materiality threshold.
Flag balances that meet your write-off criteria, document the collection history supporting each recommendation, and summarize all actions with named owners and due dates.
π‘ Get written authorization for write-offs from the appropriate level of management before processing the journal entry β verbal approvals create audit problems.
Complete the metrics summary with current-period and prior-period comparisons, present to the responsible manager, and record their sign-off with the date of the next scheduled review.
π‘ Attach the completed review to your month-end close file so auditors and lenders can access the full documentation trail without requesting it separately.
A debtors accounts review is a structured process for examining all outstanding customer balances, categorizing them by how long they have been overdue, assessing the likelihood of collection, and deciding on the appropriate follow-up action for each account. It is typically performed monthly or quarterly as part of the financial close cycle and produces an updated aging report, a revised provision for doubtful debts, and a set of assigned collection actions.
Monthly reviews are standard practice for most businesses. Companies with high invoice volumes, tight cash flow, or short payment terms (Net 7 to Net 14) benefit from weekly reviews of overdue accounts. Quarterly reviews are acceptable only for businesses with very few debtors and consistently short payment cycles. The key is consistency β a regular cadence prevents balances from aging unnoticed into the 90-plus-day bracket.
DSO measures the average number of days between issuing an invoice and collecting the cash. It is calculated by dividing total accounts receivable by average daily revenue. A rising DSO signals that customers are paying more slowly, which directly reduces available cash flow. Most businesses target a DSO close to their stated payment terms β a Net 30 business with a DSO of 55 days is effectively funding its customers' operations for 25 days at no charge.
The standard four-bracket structure is: current (not yet due), 1β30 days overdue, 31β60 days overdue, 61β90 days overdue, and 90-plus days overdue. Some businesses add a 91β120-day bracket and a 120-plus bracket to give more granularity on seriously delinquent accounts. The brackets you use should match the ones in your accounting system so the review report and the system report stay consistent.
A balance should be written off when all reasonable collection efforts have been exhausted β typically after 12 months of non-payment with no credible repayment plan, or earlier if the debtor is confirmed insolvent, liquidated, or uncontactable. The write-off requires management authorization and a documented trail of collection attempts. Writing off does not legally extinguish the debt; you can still pursue it after write-off, and any subsequent recovery is recognized as income.
A provision for doubtful debts is an accounting reserve that reduces the net value of accounts receivable on the balance sheet to reflect expected non-collection. The most common calculation applies an escalating percentage to each aging bracket β for example, 2% on current balances, 10% on 31β60 days, 25% on 61β90 days, and 50% or more on 90-plus days β then adds specific provisions against any individually identified high-risk debtors, regardless of their aging bracket.
An aging report is a static output from your accounting system that lists balances by overdue bracket at a point in time. A debtors review is an active management process that uses the aging report as its starting point but also includes risk assessment, collection action planning, dispute tracking, provisioning decisions, and write-off recommendations. The aging report tells you where balances sit; the debtors review tells you what to do about them.
In most businesses, the accounts receivable manager or finance manager owns the process, with support from AR clerks who handle day-to-day collection calls and follow-ups. The CFO or financial controller should review and sign off on the final report, particularly the provisioning and write-off recommendations. In small businesses without dedicated finance staff, the owner or bookkeeper typically conducts the review, but the discipline of using a structured template remains equally important.
Yes. The key metrics summary section β covering total debtors, DSO, percentage overdue, and provision coverage β can be extracted and formatted directly into a board receivables update. For board reporting purposes, include a trend table showing the same metrics for the prior three periods so directors can see whether the receivables position is improving or deteriorating over time.
An aging report is a system-generated list of balances by overdue bracket β it is an input to the debtors review, not a substitute for it. The debtors review adds risk assessment, collection action tracking, provisioning decisions, and management sign-off. Use the aging report to populate the review; use the review to decide what to do about it.
A cash flow forecast projects future inflows and outflows across all categories of the business. A debtors review focuses specifically on existing receivable balances and their recoverability. The expected collections identified in a debtors review feed directly into the receipts section of a cash flow forecast β the two documents should be prepared in sequence.
An overdue invoice letter is a communication tool sent to a single debtor to request payment. The debtors review is a management reporting process that covers the entire receivables ledger and determines which debtors should receive letters, calls, or escalation to legal action. The review drives the letter; the letter does not replace the review.
A credit application form is completed before credit is extended to a new customer. The debtors review is conducted after credit has been extended and invoices issued. Together they form the front and back end of a complete credit management process β the credit application sets the limit, the review monitors whether the customer is staying within it and paying on time.
Project-based billing with milestone invoices makes disputed balances common; the review must separately track amounts withheld pending client sign-off from genuinely overdue balances.
High invoice volumes and tight margins mean even a small increase in DSO has a material cash-flow impact; reviews typically cover hundreds of accounts and require automated aging reports.
Retention amounts, progress claims, and contract disputes create a complex debtor ledger where standard aging brackets must be supplemented by contract-specific status tracking.
Receivables split between insurer claims and patient balances require separate aging and collection strategies, with insurer rejection codes tracked in the dispute register.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Finance managers, bookkeepers, and business owners running regular monthly or quarterly receivables reviews | Free | 1β3 hours per review cycle |
| Template + professional review | Businesses with high debtor concentration risk, material doubtful debt provisions, or lender covenant reporting requirements | $200β$600 for an accountant or financial controller review session | Half a day |
| Custom drafted | Enterprises with complex multi-entity receivables, regulated credit environments, or audit committee reporting obligations | $1,000β$3,000 for a customized AR management policy and review framework | 1β2 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
