Collection Report

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Collection Report for the Period: {{start_date}} to {{end_date}}

Report Date: {{report_date}}

Prepared By: {{preparer_name}}

Summary of Overdue Accounts

Total Number of Overdue Accounts: {{total_overdue_accounts}}

Total Outstanding Amount: {{total_outstanding_amount}}

Average Days Past Due: {{average_days_past_due}}

Breakdown by Aging Categories

Current (0-30 days overdue): {{current_amount}}

31-60 Days Overdue: {{thirty_sixty_amount}}

61-90 Days Overdue: {{sixty_ninety_amount}}

91-120 Days Overdue: {{ninety_one_twenty_amount}}

Over 120 Days Overdue: {{over_one_twenty_amount}}

Key Overdue Accounts (Top 5 by Amount)

1. Customer Name: {{customer_name_1}}, Invoice Number: {{invoice_number_1}}, Amount: {{amount_1}}, Days Overdue: {{days_overdue_1}}

2. Customer Name: {{customer_name_2}}, Invoice Number: {{invoice_number_2}}, Amount: {{amount_2}}, Days Overdue: {{days_overdue_2}}

3. Customer Name: {{customer_name_3}}, Invoice Number: {{invoice_number_3}}, Amount: {{amount_3}}, Days Overdue: {{days_overdue_3}}

4. Customer Name: {{customer_name_4}}, Invoice Number: {{invoice_number_4}}, Amount: {{amount_4}}, Days Overdue: {{days_overdue_4}}

5. Customer Name: {{customer_name_5}}, Invoice Number: {{invoice_number_5}}, Amount: {{amount_5}}, Days Overdue: {{days_overdue_5}}

Collection Activities During the Period

Activities undertaken: {{collection_activities_summary}}

Number of calls made: {{num_calls}}

Number of emails sent: {{num_emails}}

Number of reminder letters sent: {{num_letters}}

Number of payment arrangements made: {{num_payment_arrangements}}

Difficult Accounts and Proposed Actions

Details of accounts requiring special attention: {{difficult_accounts_details}}

Proposed actions for these accounts: {{proposed_actions}}

Payments Received During the Period

Total payments received from overdue accounts: {{total_payments_received}}

Key payments received: {{key_payments_received_details}}

Recommendations and Next Steps

Recommendations for improving collection efficiency: {{recommendations}}

Specific actions to be taken in the next period: {{next_steps}}

Authorisation and Signature

Prepared by: ________________________ ({{preparer_printed_name}})

Date: ________________________

Authorised by: ________________________ ({{authorising_manager_name}})

Title: {{authorising_manager_title}}

Date: ________________________