Invoice & Payment Tracker
ResultSee what's paid, due soon and overdue, how much is still to collect, and which follow-up email to send today.
A tracker that flags every invoice as paid, due soon or overdue, counts days overdue, suggests the right follow-up email, and summarises what's still to collect. Built for a fictional consulting business.
- Microsoft Excel
- Google Sheets
- Gmail
Sample project. This tracker uses a fictional consulting business, Brightline Consulting, and fictional clients. All names, emails, invoice numbers and amounts are made up.
The task
Small businesses lose money when invoices slip through the cracks: no one notices an invoice is overdue until weeks later, and follow-ups go out late, too harshly, or not at all.
What I built
- Invoices sheet: every invoice with its client, dates, payment terms and amount; the status (Paid, Due soon, Overdue or Open) and the days overdue are calculated automatically
- Next action: each invoice gets a suggested next step, from a friendly reminder before the due date to a polite or firm follow-up, and a note to the owner after 30 days overdue
- Cash Flow Summary: totals by status, the amount still to collect, the share of unpaid money that is overdue, the oldest overdue invoice, and a "To do today" list
- Follow-up email templates: a friendly reminder, a polite and a firm follow-up, an escalation note for the owner, and a thank-you for paid invoices
- How it works page: the payment terms and reminder settings, the daily routine, and a colour key
The result
At a glance, the owner can see $6,400 still to collect, with 4 invoices overdue and the oldest 50 days late, and exactly which follow-ups to send today. The tracker suggests the next step; a person always reads the invoice and the client history before sending anything.
As your VA, I can set up a tracker like this for your invoices, send the follow-ups, and keep it updated every day.
The work
Full size1 of 5
Cash Flow Summary: what's still to collect, what's overdue, and today's follow-ups
Full size2 of 5
Invoices sheet: automatic status, days overdue, and the suggested next action for every invoice
Full size3 of 5
Follow-up email templates, from a friendly reminder to a firm follow-up
- JAMALUL_Sample_Invoice_Payment_Tracker.pdfOpen PDF
4 of 5
Full sample tracker (PDF version, 5 pages)
- JAMALUL_Sample_Invoice_Payment_Tracker.xlsxDownload spreadsheet
5 of 5
The Excel file itself, to open and try