Business OS
Finance & AccountingCredit & Collections

Collection Report

This Collection Report template is used by businesses to track and summarize their debt collection activities over a specific period. It helps in monitoring overdue accounts, assessing collection effectiveness, and guiding future collection strategies.

Updated 16d ago
collection reportdebt collectionaccounts receivablefinancial reportcredit controlSMESouthern Africa

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Report Details

**Report Title:** Collection Report

**Reporting Period:** From {{start_date}} to {{end_date}}

**Prepared By:** {{preparer_name}}

**Date of Report:** {{report_date}}

Executive Summary

This report provides an overview of collection activities and performance for the period of {{start_date}} to {{end_date}}. Key metrics and trends are highlighted to inform management decisions regarding accounts receivable and credit policy.

Accounts Receivable Aging Summary

**Total Accounts Receivable:** {{total_receivable_amount}}

**Current (0-30 Days Overdue):** {{current_amount}}

**31-60 Days Overdue:** {{31_60_amount}}

**61-90 Days Overdue:** {{61_90_amount}}

**91-120 Days Overdue:** {{91_120_amount}}

**Over 120 Days Overdue:** {{over_120_amount}}

Collection Activities Summary

**Number of Accounts Contacted:** {{num_accounts_contacted}}

**Total Collection Calls Made:** {{num_calls_made}}

**Total Collection Emails Sent:** {{num_emails_sent}}

**Total Collection Letters Sent:** {{num_letters_sent}}

**Number of Payment Arrangements Made:** {{num_payment_arrangements}}

**Number of Accounts escalated to legal:** {{num_legal_escalations}}

Collection Performance Metrics

**Total Amount Collected:** {{total_amount_collected}}

**Collection Effectiveness Ratio:** {{collection_effectiveness_ratio}}

**Average Days to Collect:** {{average_days_to_collect}}

**Number of Accounts Written Off:** {{num_accounts_written_off}}

**Total Amount Written Off:** {{amount_written_off}}

Significant Accounts and Notes

**Key Accounts with Outstanding Balances:**

- {{account_name_1}}: {{outstanding_amount_1}} ({{notes_1}})

- {{account_name_2}}: {{outstanding_amount_2}} ({{notes_2}})

**General Observations/Challenges during the Period:** {{general_observations}}

Recommendations and Future Actions

**Recommendations for improving collection efficiency:** {{recommendations}}

**Planned Actions for the next reporting period:** {{future_actions}}

Signature Block

_________________________

{{preparer_name}}

{{preparer_title}}

Date: {{signature_date}}

Related templates