How to Track Outstanding Receivables in Canada

Tracking outstanding receivables is crucial for maintaining steady cash flow and ensuring your business receives payments on time. To do this effectively, you need to keep an organized record of invoices, track due dates, update payment statuses promptly, and follow up on overdue payments regularly. This article covers why this is important for small business owners in Canada, detailed steps to track receivables, a worked example with Canadian figures, common mistakes and how to avoid them, and frequently asked questions.

Why this comes up / what goes wrong

Many small business owners in Canada struggle with tracking who owes them money and when payments are due. Without a clear process, invoices can be forgotten or payments delayed, leading to cash flow problems. Businesses often rely on spreadsheets, emails, or text messages to manage receivables, which increases the risk of errors and missed follow-ups. This can result in late payments, difficulty covering expenses, and wasted time chasing clients.

Step-by-step

1. Create a receivables ledger: Start with a spreadsheet or document listing every invoice you issue. Include these fields: invoice number, client name, invoice date, due date, amount, payment terms, and payment status.

1. Record invoices promptly: Enter each invoice into your ledger as soon as you send it. Double-check the due date and amount for accuracy.

1. Monitor due dates: Review your ledger regularly—at least weekly—to identify invoices due within the next 7 days.

1. Update payment status immediately: When a payment arrives, record the payment date and amount against the invoice. Mark it as paid or partially paid.

1. Follow up on overdue invoices: For invoices past due, send a polite reminder right away. Schedule follow-ups every 7-10 days if payment is still outstanding.

1. Reconcile your records: Weekly, compare your ledger to your bank deposits and accounting records to ensure all payments are accounted for.

1. Generate reports: Create weekly or monthly reports showing total outstanding amounts, aging by days overdue, and clients with the largest balances.

1. Use clear payment terms: State consistent payment terms (e.g., Net 30) on every invoice to set client expectations.

1. Keep communication records: Document all calls, emails, or messages related to payment follow-ups for future reference.

1. Review and improve: Periodically assess your receivables process to spot delays or bottlenecks and adjust accordingly.

To help manage communications and follow-ups more efficiently, consider tools like WhatsApp and SMS CRM or a built-in CRM dialer to streamline client contact.

Example (fictional figures)

A mortgage brokerage in Mississauga, Ontario, issued three invoices in March 2024:

Invoice No.	Client	Invoice Date	Due Date	Amount (C$)	Payment Status
101	Client A	2024-03-01	2024-03-31	12,000	Paid
102	Client B	2024-03-05	2024-04-04	8,500	Overdue
103	Client C	2024-03-10	2024-04-09	15,000	Partially Paid

Steps to track:

• Total invoiced = C$12,000 + C$8,500 + C$15,000 = C$35,500
• Payments received: Client A paid full C$12,000; Client C paid C$5,000
• Outstanding receivables = (Client B) C$8,500 + (Client C) C$10,000 (15,000 - 5,000) = C$18,500

Calculation:

C$12,000 + C$8,500 + C$15,000 = C$35,500 C$35,500 - C$12,000 (Client A full payment) = C$23,500 C$23,500 - C$5,000 (Client C partial payment) = C$18,500 outstanding

The brokerage should focus follow-up efforts on Client B and Client C to collect C$18,500.

Common mistakes

• Not updating payment status promptly: This causes inaccurate records and missed follow-ups. Prevent by recording payments immediately upon receipt.

• Ignoring overdue invoices: Leads to cash flow problems. Schedule regular reminders and follow-ups.

• Using inconsistent payment terms: Confuses clients and delays payments. Always include clear, consistent terms on invoices.

• Lack of communication records: Makes resolving disputes difficult. Keep detailed notes of all payment-related communications.

• Relying only on spreadsheets or emails: Increases errors and missed payments. Consider CRM tools designed for sales and receivables management, such as HelloGrowthCRM for Canada.

Frequently asked questions

How often should I review outstanding receivables? Review your receivables ledger at least once a week to catch due dates and overdue payments early. This helps maintain steady cash flow.

What is the best way to follow up on late payments? Start with a polite email or message on the due date, then follow up with phone calls every 7-10 days if payment is not received. Keep records of all communications.

Can I charge interest or fees on overdue invoices in Canada? Charging interest or late fees depends on your contract terms and provincial laws. Make sure these terms are clearly stated in your agreements. NEEDS EXPERT REVIEW

How do I handle partial payments? Record the amount received and update the outstanding balance accordingly. Communicate with the client to confirm when the remaining balance will be paid.

What tools can help me manage receivables more efficiently? CRM systems with integrated communication features like WhatsApp and SMS CRM and a built-in CRM dialer can automate follow-ups and keep your team coordinated.

Key takeaways

• Keep a detailed, up-to-date ledger of all invoices and payments.
• Monitor due dates and follow up promptly on overdue accounts.
• Use clear, consistent payment terms on every invoice.
• Record all payment communications for reference.
• Avoid relying solely on spreadsheets; consider CRM tools for better management.
• Regularly reconcile your records with bank deposits and accounting.

Start tracking your outstanding receivables today to improve cash flow and reduce payment delays. For a CRM that supports sales and communication workflows, start on the Free Forever plan (200 leads, no credit card).