The Importance of an Accounts Receivable System
If you send invoices via email and just wait to see bank deposits show up, you do not have a system — you have a hope. Without a structured approach, invoices get buried in inboxes, forgotten by both clients and yourself, and you have no clear picture of how much money your business is actually owed at any given moment.
Accounts receivable (AR) refers to all the money owed to your business for goods or services already delivered. Keeping your AR organized is not just good practice — it directly determines whether your business can pay its own bills on time.
Track Everything in One Place
Whether you use a spreadsheet or dedicated software, you need a single ledger that records: Invoice Number, Client Name, Invoice Date, Amount, Due Date, and Current Status (Sent, Viewed, Paid, Overdue). Reviewing this list weekly takes five minutes and can save you thousands.
Setting Up Your Invoice Tracking Spreadsheet
You don't need expensive software to get started. A simple spreadsheet with the following columns is enough to manage your receivables effectively when you're a solo freelancer or small business:
| Column | What to Enter |
|---|---|
| Invoice # | INV-001, INV-002... (sequential) |
| Client | Company or individual name |
| Issue Date | Date you sent the invoice |
| Due Date | Payment deadline |
| Amount | Total amount owed (with currency) |
| Status | Sent / Viewed / Paid / Overdue |
| Follow-up Date | When to send the next reminder |
| Notes | Any relevant payment discussions |
💡 Pro tip: Colour-code your "Status" column: green for Paid, yellow for Sent/Due Soon, and red for Overdue. A quick visual scan at the start of each week tells you exactly where your attention is needed.
Invoice Status Labels Explained
Using consistent status labels across all your invoices removes ambiguity. Here are the four standard statuses and what they mean:
Invoice delivered to the client. Payment has not yet been received.
Client has opened the invoice. Use this if your tool tracks email open rates.
Payment received and confirmed. Archive the invoice for tax records.
Past the due date with no payment. Immediately trigger your follow-up workflow.
The Follow-Up Timeline
When an invoice becomes past due, awkwardness frequently stops business owners from reaching out. Automate your thought process by adhering to a strict follow-up schedule. The key is to be professional, persistent, and never emotionally reactive.
1. The "Before It's Due" Reminder (3 Days Prior)
Keep it extremely friendly. This is just a helpful nudge, not a demand. Many clients genuinely appreciate budget reminders.
"Hi [Name], Hope you're having a great week! Just a quick, friendly reminder that invoice #1234 for $500 is due this Friday, [Date]. I've attached a copy for your convenience. Please don't hesitate to reach out if you have any questions!"
2. The "Overdue" Notice (1–3 Days Late)
Direct, but assume positive intent — they may have simply forgotten or the invoice went to spam.
"Hi [Name], I'm writing to follow up on invoice #1234 (attached) for $500, which was due on [Date]. Could you let me know if this has been processed or if you need an alternative payment method? I appreciate your prompt attention to this."
3. The "Second Notice" (7 Days Late)
More firm. Make it clear the delay is affecting your business and request an update.
"Hi [Name], Invoice #1234 for $500 is now 7 days past due. I need to request that payment be made by [Date + 5 days]. Please confirm receipt of this email and let me know when to expect payment. If there is an issue, I am happy to discuss payment arrangements."
4. The "Late Fee" Enforcement (14 Days Late)
Firm professional boundaries. Introduce the late fee as stated in your original payment terms.
"Hi [Name], Invoice #1234 is now two weeks past due. Per my payment terms, a late fee of 1.5% has been applied. The updated total is $507.50. Please find the revised invoice attached and remit payment by [Date] to avoid further penalties."
Protecting Yourself: Late Fees and Payment Terms
A late fee only works if it was agreed upon before the invoice was sent. The best way to protect yourself legally is to include your payment terms clearly in your initial contract or proposal, and repeat them on every invoice.
State your late fee rate explicitly: e.g., '1.5% per month (18% per annum) applied to balances unpaid after the due date'
Include payment terms on every invoice in the Notes section (e.g., 'Net 15 — Late fees apply after [date]')
Get client signatures on your initial contract or a written email confirmation before starting work
Keep all correspondence about payment in writing — emails and messages are legally admissible evidence
When They Still Don't Pay
If emails are going unanswered beyond 21 days, it's time to escalate. Pick up the phone. A two-minute phone call can resolve a payment dispute that dozens of emails could not — sometimes the email simply ended up in spam, or the accounts department changed personnel.
If the client is actively avoiding you, pause all ongoing work until the balance is cleared. As a last resort — typically 60–90 days past due — you have the following options:
Small Claims Court
For amounts under the local small claims limit (varies by country/state), this is a cost-effective route. Filing fees are low and you don't need a lawyer.
Debt Collection Agency
They will recover the debt for a commission (typically 20–40% of the amount owed). Good for amounts where legal action isn't worth your time.
Write It Off as a Bad Debt
In many countries, you can deduct an unpaid invoice as a business loss on your taxes. Consult your accountant — you may recover part of the loss at tax time.
Prevention: Getting Paid on Time from the Start
The best way to manage unpaid invoices is to reduce their occurrence in the first place. These practices dramatically improve your on-time payment rate:
Require a 30–50% deposit before beginning any project
Invoice immediately upon delivery — every day you wait is a day added to payment time
Offer multiple payment options (bank transfer, credit card, PayPal, etc.)
Use a professional PDF invoice with all required fields — unprofessional invoices get deprioritized
Include a direct payment link on the invoice itself
Set calendar alerts for every invoice due date and follow-up schedule
For repeat clients, consider a retainer or recurring billing arrangement
Simplify your invoicing
Create clear, professional invoices that include proper due dates, payment terms, and late fee clauses — all free.
Create Invoice