Skip to content
Hud Jamalul
Back to sample work

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.

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

  1. Invoice & Payment Tracker, file 1 Full size

    1 of 5

    Cash Flow Summary: what's still to collect, what's overdue, and today's follow-ups

  2. Invoice & Payment Tracker, file 2 Full size

    2 of 5

    Invoices sheet: automatic status, days overdue, and the suggested next action for every invoice

  3. Invoice & Payment Tracker, file 3 Full size

    3 of 5

    Follow-up email templates, from a friendly reminder to a firm follow-up

  4. JAMALUL_Sample_Invoice_Payment_Tracker.pdfOpen PDF

    4 of 5

    Full sample tracker (PDF version, 5 pages)

  5. JAMALUL_Sample_Invoice_Payment_Tracker.xlsxDownload spreadsheet

    5 of 5

    The Excel file itself, to open and try