How to track invoices without accounting software

You don't need a $30/month subscription to know who owes you money. A register, some formulas and red/green flags do the job until you genuinely outgrow them.

Accounting software costs $30+ every month, forever, and most small businesses use about 10% of it. Here's what that missing 90% of businesses actually need instead — and the spreadsheet pattern that delivers it.

Who actually needs QuickBooks

Not a criticism of QuickBooks — it's good software. The question is whether you're its customer.

If you have employees running payroll, inventory across locations, or an accountant asking for Xero/QuickBooks files, yes: buy the software.

If you're a contractor, freelancer, consultant, agency of one-to-five, or any business that sends invoices and wants to know who hasn't paid — you need about four things:

1. A list of every invoice you've sent, and its status

2. Automatic math: tax, totals, due dates

3. A way to see, at a glance, who owes you what and how late

4. A printable, professional invoice

That's it. That list is fully deliverable in one Excel file with no monthly fee. Here's the pattern.

The register: one row per invoice

The entire system is a table where each row is one invoice:

You enter: issue date, client, description, subtotal. The spreadsheet computes everything else:

• Tax: =subtotal × tax_rate (tax rate set once, in Settings)
• Total: =subtotal + tax
• Due date: =issue_date + terms_days (your terms, set once)
• Balance: =total − amount_paid
• Invoice number: ="INV-" & TEXT(row_number, "000") — auto-numbering, no gaps, no duplicates

Set the status as the invoice moves (Draft → Sent → Part-Paid → Paid → Cancelled) and the sheet does two visual tricks worth the price of admission alone:

• Paid rows turn green. One glance = what's settled.
• Past-due rows with money still open turn red. Not "past due by the due date field" — the formula checks the due date against today and whether a balance remains, so paid invoices never nag you.

The aging report: your most powerful awkward conversation

The second sheet is where money actually gets collected. An aging report buckets every open invoice by how late it is:

• 1–30 days late — gentle reminder territory
• 31–60 days late — firmer follow-up
• 61–90 days late — direct conversation, payment plan territory
• 90+ days late — formal demand / collections decision

The formula is one SUMPRODUCT checking three things at once: is the due date before today, is it inside this bucket, and is money still open. The result is a number every business owner should be able to answer instantly: how much money is out there, and how overdue?

The buckets aren't just information — they're an action plan. Each bucket maps to one specific, pre-decided escalation step, which removes the emotional friction of chasing money. You're not "deciding whether to follow up"; you're executing step two of four on invoices in bucket two.

The escalation ladder (steal these scripts)

• Due date day: "Hi [name], invoice INV-014 for [amount] was due today — all fine here, just flagging it in case it slipped the calendar. Happy to resend anything."
• Day 14: "Following up on INV-014 ([amount], due [date]). If it's scheduled, could you share the payment date? If something's wrong with the invoice itself, tell me and I'll fix it today."
• Day 30: "I need to get INV-014 ([amount], 30 days past due) onto my own payables list honestly — can we set a specific payment date this week, or split it into two payments?"
• Day 45+: formal written request, state the amount, dates, and next step (collections/small claims in your jurisdiction). Calm, factual, zero adjectives.

One line in each: factual, unemotional, escalating. The spreadsheet tells you which line to send; you send it.

The printable invoice

A register that can't produce a client-facing invoice isn't finished. The trick is a print sheet driven by one dropdown: pick the invoice number, and every field — your business header, the client's details, description, subtotal, tax, total, due date, payment instructions — fills in via lookup formulas. Set the print area once. Now "send the invoice" is: pick number → print to PDF → attach.

When you've outgrown the spreadsheet

Honest thresholds, from running this pattern at scale:

• Revenue past ~$8–10k/month, or invoices per month past ~50 — the manual entry starts costing real time
• You hire employees — payroll is genuinely software territory
• You carry inventory across SKUs — same
• Your accountant asks for software files — their hour is worth more than the subscription

Until then, the spreadsheet is faster to use, trivially customizable, and costs $19 once instead of $360 a year.

The shortcut

The whole pattern — register, auto-math, red/green flags, aging dashboard, printable invoice sheet, 200-invoice capacity — is the Small Business Invoice & Payment Tracker ($19, instant download).

If you want the invoice register plus expense tracking, quote calculator, cashflow forecast and the dashboard all linked in one file, that's the Small Business Command Center ($49) on the same page.

And if you just want to see whether spreadsheet bookkeeping fits you before paying anything, there's a free 12-month cashflow forecaster there too.

This is bookkeeping assistance, not accounting or tax advice. Works in Excel and Google Sheets.