How to Track Unpaid Invoices and Follow Up Without Losing Customers
Track overdue invoices with a free Google Sheets tracker, automatically calculated balances, example reminders and dispute-handling guidance.
In this guide
A customer invoice is overdue, but the office manager cannot tell whether anyone has followed up. The owner remembers a phone call, somebody else sent an email, and the account record still shows the original balance even though the customer paid part of it. That is a tracking problem worth fixing before another reminder goes out.
Use a single invoice register with a confirmed outstanding amount, current owner, dispute status and next-contact date. Keep the authoritative invoice and payment records in your accounting system, then use a tracker to make collection work visible. Open the Google Sheets tracker with blank and completed example tabs.
Start with an accurate list of what is actually unpaid
The accompanying invoice tracker resource page explains its columns and checks. For the effect of late collections on payroll and bills, use the weekly cash-flow management guide.
Export your accounts receivable or unpaid-invoice list from the accounting system. For each invoice, confirm the issue date, agreed due date, amount billed, payments that have cleared, approved credits and the remaining balance. Keep a customer account reference instead of full private contact details in a shared tracker.
Do not treat an invoice as overdue just because it remains unpaid. The actual due date may still be ahead, or the invoice may be disputed for a legitimate reason. An invoice with a partial payment requires a different message from an invoice that has not been acknowledged. If payment was made but cannot be matched to the invoice, reconcile it with the bank and accounting records before demanding it again.
The Google Sheet calculates each outstanding balance as original invoice amount minus confirmed payments and approved credits. Enter 0 explicitly when no payment or credit has been recorded. An empty payment or credit input triggers VERIFY PAYMENTS in the check column, even if the displayed balance is calculated. Excessive or invalid amounts display CHECK INPUTS. Compare all numbers with the accounting ledger before contacting a customer.
Give each invoice one current owner and next action
A small team may have the office coordinator follow up on routine overdue amounts while the owner resolves disputed scopes and unusual terms. The tracker should say who is responsible for the next contact, what has been verified and when the next decision is due. A note saying “chase payment” is incomplete unless someone has accepted the job and knows which invoice to discuss.
In a fictional service business, invoice INV-104 was issued for $1,850. The customer paid $600, leaving $1,250 due. The coordinator checks whether that payment cleared and sends a note about the remaining balance with the invoice reference, without accusing the customer of failing to pay anything.
Another invoice, INV-107, has no payment because the customer disputes an extra labor charge. The worked example uses a fictional November 1, 2026 snapshot date so its labels remain consistent even when the real calendar advances. In your copied blank template, the due-date check uses today’s date. The owner reviews the signed work scope and change approval before any collection escalation. The tracker keeps it marked Disputed and specifies the review date rather than treating it as an ordinary reminder.
Review overdue invoices in a short weekly routine
Once a week, sort the list by due date and status. Check the largest overdue amounts and the cases whose follow-up date has passed. Look for invoices where a promised payment date is no longer credible and the next action needs to change.
| Invoice situation | What to verify | Next action |
|---|---|---|
| Not yet due | Invoice was delivered and terms are correct | Make sure payment details are clear; wait for due date unless an agreed pre-due reminder applies |
| Overdue, no known dispute | Due date and cleared balance | Send a factual, courteous reminder with invoice reference and payment method |
| Partially paid | Cleared amount and remaining balance | Acknowledge payment and ask about the balance |
| Disputed | Contract, change record and customer’s objection | Route to authorized decision-maker; communicate investigation timeline |
| Paid | Deposit matched to invoice | Close the collection task and reconcile the ledger |
Set a next-contact date appropriate to your terms, the customer’s history, and the actual business calendar. The goal is to keep accurate commitments and protect the customer relationship. Copying a rigid “three reminders then collections” schedule from an unrelated business may create unnecessary conflict.
Use a reminder sequence that acknowledges what you know
Shortly after a due date, ordinary overdue balance:
Subject: Invoice [number] follow-up
Hi [name], I’m checking on invoice [number] for [amount], which was due on [date]. Our records still show [outstanding amount] unpaid as of [verified date]. Could you confirm when payment is expected, or let us know if a document is missing? I’ve included the invoice and payment details. Thanks, [name].
After the customer makes a partial payment:
Subject: Remaining balance on invoice [number]
Hi [name], thank you for the [amount] payment received on [date]. We have applied it to invoice [number] and show [remaining balance] outstanding. Please let us know the expected timing for the balance or if our figures differ from yours. Thanks, [name].
When a customer disputes the bill:
Subject: Reviewing your invoice question
Hi [name], I understand the question about [specific charge]. We’re checking the original quote and any approved changes before responding. [Manager] will update you by [realistic date/time]. Thank you for giving us the details.
Never say you sent a reminder, contacted collections or received a payment unless that actually happened. Keep a record of the message and the customer’s answer in the authorized system. If the customer asks for documentation, supply the appropriate invoice and change record through the agreed channel.
Decide when a more formal response is justified
Escalation may be appropriate when a confirmed overdue balance remains unresolved, the customer repeatedly misses agreed dates, or the amount threatens cash flow. Before the business considers external collection, a payment plan, disputed late fees or legal action, review the contract, applicable law, costs and customer relationship. Authorization limits for staff do not override legal rights.
Do not add a late fee, interest or penalty that your agreement or applicable law does not permit. The Consumer Financial Protection Bureau explains that the federal Fair Debt Collection Practices Act covers certain consumer debts and does not cover business debts. It also generally does not govern collection by the original creditor. Other federal and state rules can still affect your collection practices. For complex cases, seek qualified advice rather than using a template as legal authority.
If the business’s own paperwork is holding up payment, fix it quickly. Customers sometimes cannot approve an invoice because the purchase-order number or signed completion form is missing. A useful next step may be supplying that evidence, not sending a sharper reminder.
Close the loop and prevent the same delay next month
When the balance clears, match the money to the invoice, record the payment date and stop further reminders. If an invoice is written off or adjusted, keep the approval and accounting record rather than marking it “paid.” Review recurring delay reasons: invoices sent late, disputed change orders, missing customer approvals, or unclear payment instructions.
Choose one operational fix, such as making the supervisor’s sign-off a prerequisite for invoice release. The work handoff checklist can help you set the evidence, owner, and acceptance check. Then see whether next month’s invoices reach customers with complete records. This makes collections less dependent on repeated follow-up messages.
Use the free Google Sheets invoice tracker
The unpaid-invoice tracker contains a blank template and a worked fictional example of paid, partly paid, not-yet-due and disputed invoices. The sheet includes an owner, last contact, next follow-up, agreed action and evidence reference. Column H calculates the remaining balance; column P checks the amount and manually selected status against the due date; column Q highlights whether a verified invoice is past due, disputed or paid. Enter a real date and confirm both payment and credit amounts, including explicit zero values. This tracker does not send reminders, determine contractual fees or replace the ledger.
For the cash effect of delayed customer payments, see How to Manage Cash Flow in a Small Business. Its weekly cash check focuses on when the amount can realistically be collected and whether delayed funds create a problem before payroll or another required payment.