Nothing should reach 40 days overdue by accident

A Google Sheets tracker for landscaping, cleaning and handyman businesses. Log client, job, amount and due date once, and what is paid, open and overdue tracks itself.

$19 Buy on Gumroad

Eight sample invoices, every status visible: paid, open, overdue, and one partial payment. Status is a formula driven by today's date.

Before and after

If you track who owes what in your head, on paper, or in a spreadsheet that flags nothing on its own, an overdue invoice stays quiet until it has turned into bad debt.

Now

Chasing payment starts when cash gets tight.
Partial payments are remembered, not recorded.
Two people phone the same client about the same invoice.
Total outstanding is a guess.

With this sheet

Status flips to overdue by itself the day after the due date.
Balance due recalculates the moment a part payment lands.
One row per invoice, one place to look.
Total invoiced, collected and outstanding, always current.

What is inside

Invoice Tracker tab: one row per invoice: client, job, invoice date, due date, amount billed and amount paid. Balance due, status and days overdue are live formulas driven by today's date.
Invoice Summary block: total invoiced, total collected, total outstanding, and how many invoices are overdue right now.
Instructions tab: a six step quickstart, done in under five minutes.
Eight sample invoices: paid, open, overdue and one partial payment, so every status is visible before you touch a cell.

Who it is for

Owner-operators and office managers at 2 to 20 person service businesses: landscaping, cleaning and handyman firms chasing unpaid invoices from memory or a paper stack.

Questions

Do I need Google Sheets or Excel?

Google Sheets, free with any Google account, is the primary format. The formulas also work in Excel.

Does status update itself?

Yes. It is a formula driven by today's date and the balance due, not something you set by hand.

Can I track partial payments?

Yes. Enter whatever was actually paid, and balance due and status recalculate to match.

Is this a one-time purchase?

Yes. A single purchase, yours to keep, for unlimited invoices.