Invoice Tracker

Company Information

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Invoice Tracker Summary

Track Start Date: {{track_start_date}}

Track End Date: {{track_end_date}}

Total Invoices Issued: {{total_invoices_issued}}

Total Amount Billed: {{total_amount_billed}}

Total Amount Outstanding: {{total_amount_outstanding}}

Invoice Details Log

This section is to log individual invoice details. Please ensure all fields are accurately completed for effective tracking.

**Invoice Entry:**

Invoice Number: {{invoice_number}}

Client Name: {{client_name}}

Client Contact Person: {{client_contact_person}}

Client Email: {{client_email}}

Client Phone: {{client_phone}}

Issue Date: {{issue_date}}

Due Date: {{due_date}}

Service/Product Description: {{service_product_description}}

Amount (Excl. VAT): {{amount_excl_vat}}

VAT Rate: {{vat_rate}}%

VAT Amount: {{vat_amount}}

Total Amount (Incl. VAT): {{total_amount_incl_vat}}

Payment Status: {{payment_status}} (e.g., Outstanding, Partially Paid, Paid)

Payment Date: {{payment_date}}

Payment Method: {{payment_method}}

Outstanding Balance: {{outstanding_balance}}

Notes/Remarks: {{notes_remarks}}

Payment Reminders Sent

Log all payment reminder communications.

Invoice Number: {{reminder_invoice_number}}

Reminder Date: {{reminder_date}}

Method of Communication: {{communication_method}} (e.g., Email, Phone Call, SMS)

Contact Person: {{reminder_contact_person}}

Response/Action Taken: {{response_action_taken}}

Next Follow-up Date: {{next_follow_up_date}}

Dispute Resolution Log

Record any invoice disputes or queries.

Invoice Number: {{dispute_invoice_number}}

Date of Dispute: {{date_of_dispute}}

Nature of Dispute: {{nature_of_dispute}}

Resolution Steps Taken: {{resolution_steps_taken}}

Resolution Outcome: {{resolution_outcome}}

Date of Resolution: {{date_of_resolution}}

Aged Debt Analysis

This section provides an overview of outstanding invoices categorized by age.

Current (0-30 days): {{current_debt}}

31-60 Days Overdue: {{31_60_days_debt}}

61-90 Days Overdue: {{61_90_days_debt}}

90+ Days Overdue: {{90_plus_days_debt}}

Action Plan for Aged Debt: {{action_plan_aged_debt}}

Reporting and Analysis

Summary of key financial metrics derived from this tracker.

Average Days to Payment: {{average_days_to_payment}}

Percentage of Overdue Invoices: {{percentage_overdue_invoices}}%

Client Payment Trends: {{client_payment_trends}}

Instructions for Use

1. Fill in your company information in the 'Company Information' section.

2. Log each new invoice issued under 'Invoice Details Log'.

3. Regularly update the 'Payment Status' and 'Payment Date' fields as payments are received.

4. Use 'Payment Reminders Sent' to document all client communication regarding outstanding invoices.

5. Document any client disputes or queries in the 'Dispute Resolution Log'.

6. Review 'Aged Debt Analysis' and 'Reporting and Analysis' regularly to identify trends and address outstanding payments promptly.

Signature

_________________________

{{authorised_signature}}

Name: {{authorised_name}}

Title: {{authorised_title}}

Date: {{signature_date}}