Invoices & collections
Past-Due Invoice Tracker for a Small Plumbing Business
An overdue-invoice tracker is an action queue. Give every unresolved balance a responsible person, a current explanation, and a next action date. Keep it separate from the accounting aging report, which measures balances at a particular date.
In this guide
Use one row per invoice action record
Start with the invoice reference, billing customer, due date, and verified remaining balance. Add the most recent contact, the customer's response, and the next action. Do not duplicate the invoice every time someone sends a reminder.
An accounting aging report answers how old a balance is. This tracker answers who is doing what about it. Both are useful, but mixing them can create misleading totals when one invoice appears on several communication rows.
Copy the tracker columns
invoice_id,customer_id,due_date,verified_balance,balance_checked_on,last_contact_date,response_status,promised_payment_date,next_action,next_action_date,owner,evidence_reference
INV-EXAMPLE,CUST-EXAMPLE,2026-09-10,300,2026-09-29,2026-09-28,invoice_copy_requested,,send_verified_copy,2026-09-29,office_owner,job_reference
The example is fictional. Replace it before using the tracker with your own records. Store customer contact details in the appropriate protected system rather than creating unnecessary copies across shared files.
Choose statuses that explain the blocker
Use a small set of action states such as no response, invoice copy requested, payment reported, disputed, wrong billing contact, and agreed payment date. “Overdue” alone does not explain what the office should do.
Keep “payment reported” distinct from “payment verified.” A customer's statement should trigger a check, not an automatic change to paid. The same applies to a payment screenshot whose relationship to the invoice has not been confirmed.
| Status | Recommended owner action |
|---|---|
| Invoice copy requested | Verify recipient and send current invoice |
| Payment reported | Locate transaction evidence and allocation |
| Disputed | Assign a review owner and pause routine reminders |
| Wrong contact | Confirm who is responsible for billing |
| Promised date | Review after the actual agreed date |
Reconcile before totaling the queue
Suppose three fictional invoices show balances of $300, $180, and $520. The queue total is $1,000 only if those balances have been checked for the same reporting point and each invoice appears once.
If the $180 payment was received but not yet allocated, do not quietly remove the row or call it definitively unpaid. Flag the allocation review. After verification, update the balance and retain the resolution reference.
Use the accounting system's approved balance report as the financial control. This operational tracker should not replace the ledger or introduce its own unsupported write-offs.
Give every action a date and an owner
“Follow up soon” is not a usable next action. “Confirm the purchase order with the billing contact on Thursday” is. For a one-person business, naming yourself still makes the commitment visible.
Review the queue at a chosen cadence and after relevant customer replies. Focus first on actions due, missing evidence, and broken promises that require review—not merely the largest number in the balance column.
Close rows without erasing the history
When an invoice is resolved, record the outcome: paid and verified, corrected, credited under the approved process, or another documented resolution. Archive the completed row rather than deleting all evidence of the issue.
If the same blocker repeatedly appears, fix the earlier workflow. For example, required billing references belong in intake and invoice preparation. A tracker is most valuable when it reduces repeat administrative mistakes, not when it becomes a permanent list of unexplained balances.
Sources and editorial notes
Product and documentation references checked September 29, 2026. GoPlumber publishes this guide about its own product category. Examples and templates are original illustrative material, not customer case studies or market benchmarks. Confirm current vendor terms before acting.