Free Word download β’ Edit online β’ Save & share with Drive β’ Export to PDF
A Collection Report is an operational finance document that consolidates the status of all outstanding receivables, overdue accounts, and recovery activity across a business for a defined reporting period. It goes beyond a simple aging snapshot by combining aging schedule data with a chronological activity log, disputed invoice tracking, payment arrangement records, escalation recommendations, and write-off proposals β all interpreted through a management commentary that tells the story behind the numbers. Finance teams use it to hold collection activity accountable, management uses it to make credit and escalation decisions, and auditors use it as evidence that reasonable recovery efforts were made before bad-debt expenses were recognized.
Without a structured collection report, overdue accounts age silently while individual collectors work from disconnected call logs, spreadsheet notes, and memory. The CFO has no consolidated view of DSO trends, write-off exposure, or whether escalation recommendations are being actioned. Disputes get lumped into aging totals, inflating the apparent overdue balance and distorting recovery metrics. A collection report closes these gaps by forcing a complete picture into a single document on a regular cadence β making it harder for high-risk accounts to fall through the cracks and easier to justify write-offs to auditors when recovery truly is exhausted. This template gives your team a consistent format to build that picture every reporting period, with every section they need already in place.
| If your situation is⦠| Use this template |
|---|---|
| Weekly snapshot of newly overdue accounts for a collections team | Weekly Collection Report |
| Month-end summary of all outstanding receivables for the CFO | Monthly Collection Report |
| Detailed aging schedule broken down by customer and invoice | Accounts Receivable Aging Report |
| Tracking a specific delinquent customer through escalation stages | Debt Collection Letter |
| Recording write-off decisions approved at period end | Bad Debt Write-Off Report |
| Presenting AR performance metrics to the board or investors | Financial Report |
| Summarizing collection outcomes after outsourcing to an agency | Collection Agency Status Report |
Why it matters: Disputed invoices cannot be collected through standard follow-up, so including them overstates the collectible overdue balance and distorts DSO calculations.
Fix: Create a separate disputes section in the report and exclude disputed balances from the aging schedule until each dispute is resolved.
Why it matters: A promise to pay is a commitment, not cash β counting it as recovered inflates the collection rate and gives management a falsely optimistic picture of actual cash inflow.
Fix: Track PTPs in a separate section with their promised dates. Move the balance to recovered only when the payment clears your bank account.
Why it matters: A DSO of 48 days or a collection rate of 72% means nothing in isolation β without a prior-period benchmark, management cannot tell whether performance is improving or deteriorating.
Fix: Include prior-period figures for every metric in the summary table, and add a brief commentary explaining any movement greater than 10%.
Why it matters: Unassigned recommendations sit in the report indefinitely β the account ages further while everyone assumes someone else is acting on it.
Fix: For every escalation or write-off recommendation, name the responsible person and state the date by which the action must be approved or executed.
Why it matters: Senior readers scan the first page and decide whether to read further β a summary buried on page 8 after detailed aging tables is routinely skipped.
Fix: Move the executive summary to page one, immediately after the report header, so the key findings and risks are visible before any data tables.
Why it matters: Incomplete activity logs make it impossible to demonstrate reasonable collection effort if an account proceeds to legal recovery or requires an audit-supported write-off.
Fix: Record every contact attempt β including unanswered calls, unopened emails, and bounced correspondence β with the date and method used.
Define the exact start and end dates for the report. Export your accounts receivable aging data from your accounting system for that period, including all open invoices, due dates, and customer details.
π‘ Run the aging report as of the last business day of the period β mid-period snapshots can misrepresent balances due to timing of payments processed.
Group all open invoices into the four standard buckets β 0β30, 31β60, 61β90, and 90+ days overdue β and total each bucket by dollar amount and invoice count.
π‘ If your system uses a different aging structure, standardize to these four buckets in the report for comparability with prior periods.
Sort overdue accounts by balance descending to build the top accounts detail section. Flag any accounts that have moved into a higher aging bucket since the last report.
π‘ Accounts that jump from 31β60 to 61β90 days in a single period are higher risk than long-standing 90+ day balances β annotate bucket migrations explicitly.
Record every contact attempt for each overdue account β date, method (call, email, letter), person reached, and outcome. Include promises to pay with the committed amount and date.
π‘ Use a consistent format for activity entries so any team member can pick up an account and understand its full history without asking the original collector.
Move any formally disputed invoice into the disputes section, note the reason for the dispute, and assign a resolution owner with a target date.
π‘ Remove disputed balances from your collection rate calculation β including unresolvable disputes inflates overdue totals and distorts team performance metrics.
For each account that has exhausted standard collection steps, write a one-line recommendation β credit hold, agency referral, or write-off β with the supporting rationale and a proposed action date.
π‘ Include the total dollar value of all write-off recommendations in the executive summary so the approving manager can assess the P&L impact before signing off.
Compute DSO, collection rate, and total recovered. Compare each metric to the prior reporting period and flag any metric that has moved more than 10% in either direction.
π‘ DSO = (Closing AR balance Γ· Revenue for the period) Γ Number of days in the period. Confirm this matches your accounting system's calculated figure before publishing.
Summarize the top three findings, the highest-risk accounts, the key metric movements, and what management action is needed. Place this section at the beginning of the document.
π‘ Limit the executive summary to half a page β if it runs longer, it is repeating detail already in the body rather than synthesizing it.
A collection report is an operational finance document that summarizes the status of outstanding receivables, overdue accounts, and recovery actions taken during a defined reporting period. It gives finance teams and management a consolidated view of how much money is owed, how long it has been outstanding, what steps have been taken to recover it, and what actions are recommended next.
Collection reports are typically prepared by accounts receivable staff, credit and collections specialists, or finance managers. In smaller businesses, the owner or bookkeeper prepares the report. Outsourced accounting firms often deliver standardized collection reports to multiple clients on a monthly or quarterly basis.
Most businesses prepare collection reports monthly, aligned with their accounting close cycle. High-volume businesses or those with tight cash flow may run weekly reports focused on newly overdue accounts. A quarterly summary is sufficient for businesses with low invoice volume and reliable payers. The frequency should match how actively the team works overdue accounts.
An accounts receivable aging report is a data output from your accounting system showing open invoices bucketed by days overdue β it is a static snapshot. A collection report uses that aging data as its foundation but adds collection activity logs, disputed account detail, escalation recommendations, write-off proposals, and management commentary. The aging report tells you what is owed; the collection report tells you what is being done about it.
The four most important metrics are Days Sales Outstanding (DSO), collection rate for the period, total amount recovered, and the change in 90-plus day balances versus the prior period. Secondary metrics include the number of accounts with active promises to pay, the dollar value of disputes under review, and the total value of write-off recommendations pending approval.
DSO is calculated by dividing the closing accounts receivable balance by total revenue for the period, then multiplying by the number of days in the period. For example, a closing AR of $120,000, monthly revenue of $200,000, and a 30-day period gives a DSO of 18 days. A rising DSO signals that customers are taking longer to pay, which can indicate credit policy issues or deteriorating customer financial health.
Accounts typically move to external collection or legal escalation after 90 or more days without a payment or credible payment arrangement. Write-off recommendations are appropriate when the debtor is insolvent, unresponsive after multiple documented attempts, or when the outstanding balance is below the cost of further pursuit. Both decisions should be documented in the collection report with supporting rationale to satisfy audit requirements.
A well-maintained collection report β with complete activity logs, dated contact records, and copies of demand correspondence β provides useful supporting documentation in a legal recovery claim. It demonstrates that reasonable efforts to recover the debt were made before litigation. However, collection reports are operational documents, not legal instruments; consult a legal professional before relying on one as the sole evidence in a claim.
Most accounting platforms β QuickBooks, Xero, Sage, and NetSuite β can export aging data that feeds into a collection report. The report itself is typically compiled in Word or Excel using a structured template, since it includes narrative commentary, activity logs, and recommendations that automated exports do not generate. Business in a Box's Word template gives you a formatted structure you can populate directly from your AR system exports.
An AR aging report is a data table exported from your accounting system showing open invoice balances bucketed by days overdue. A collection report uses that data as its starting point but adds activity logs, dispute tracking, escalation recommendations, and management narrative. Use the aging report for real-time balance visibility; use the collection report for period-end management review and audit documentation.
A debt collection letter is a formal written demand sent to a specific overdue customer. A collection report is an internal management document summarizing all overdue accounts across the business. The letter is customer-facing and action-triggering; the report is management-facing and performance-tracking. They serve complementary roles β the report identifies which accounts need a letter.
A financial report covers the full profit-and-loss, balance sheet, and cash flow position of the business. A collection report focuses exclusively on the receivables component β who owes money, how long it has been outstanding, and what is being done to recover it. Financial reports are prepared for board or investor audiences; collection reports are working documents for finance and operations teams.
A credit application is completed before extending credit to a customer, capturing financial references and terms agreed. A collection report comes into play after credit has been extended and invoices have gone unpaid. Together they form the bookends of the credit cycle: the application sets the terms; the collection report tracks whether those terms are being honored.
High invoice volumes and thin margins make DSO management critical; collection reports track dozens of customer accounts across multiple payment terms simultaneously.
Disputed invoices are common when deliverables are subjective; the disputes section of the collection report is essential for separating contested balances from genuinely overdue ones.
Insurance claim delays and patient billing complexity create large 60-plus day AR buckets that require specialized collection activity logging distinct from standard commercial collections.
Progress billing and retainage create multi-stage receivables; collection reports must track each billing milestone separately and flag retention balances approaching release dates.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Finance teams and small business owners preparing standard monthly or quarterly AR recovery reports | Free | 1β2 hours per reporting cycle once the template is set up |
| Template + professional review | Businesses preparing reports for board review, external auditors, or lender covenant compliance | $200β$600 for a controller or CPA review | Half a day |
| Custom drafted | Large businesses with complex multi-entity AR structures, regulated industries, or litigation-ready collection documentation | $1,000β$3,000 for a custom AR management system or outsourced collections firm setup | 1β3 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
