“How’s business?” If your honest answer is “I think okay?” — keep reading.

You know your revenue. Maybe. But the numbers that actually decide whether you make payroll live somewhere between your bank app, a stack of unpaid invoices, and your gut.

• You find out an invoice is 60 days late when you happen to notice
• You couldn’t say your DSO — or what’s normal for your business — if asked
• Money feels tight but you can’t point to why
• Your “AR system” is memory, sticky notes, and hoping they pay

You don’t need accounting software with 400 features. You need the handful of numbers that matter, updated automatically, in one place you’ll actually look at.

Two tools. One sheet. Total clarity.

KPI Cards

Six auto-calculating scorecards that answer “how’s business?” in one glance — each with a built-in target so you know what good looks like:

• DSO (Days Sales Outstanding) — how fast your money really moves, against the under-45-day target
• Collection Rate — the share of billings you actually collect, against the 95% target
• Total Outstanding — what you’re owed right now
• Overdue Accounts (30+ days) — who needs follow-up
• 90+ Day Balance — your high-risk receivables
• Collected This Month — cash actually received

AR Tracker

Enter each invoice once. The tracker does the rest:

• Days past due, balance, and aging bucket calculate automatically — colour-coded so 90+ day invoices stand out in red
• Log payments as they arrive and balances update instantly
• Built-in summary: total invoiced, total collected, % collected, overdue count, and DSO
• A rolling working list of the invoices you’re actually chasing — not an archive

Up and running before your coffee is cold

1. Enter your open invoices

Customer, amount, due date. If you can type it, you can track it.

2. Watch the cards light up

Every KPI calculates instantly. No formulas to write — yellow cells are yours, everything else is automatic.

3. Check it weekly

Five minutes: log payments, add new invoices, see exactly who to chase. That’s the whole system.

The “Find the Money” Guarantee

Enter your invoices, and if the tracker doesn’t surface at least $470 in overdue money you should be collecting right now — 10x what you paid — email us within 30 days for a full refund. Keep the file.

Questions, answered

Do I need Excel?

It works in Microsoft Excel (2016 or newer) and imports cleanly into Google Sheets. No plugins, no macros.

I already use QuickBooks. Why this?

QuickBooks records what happened. This shows you — in one glance — whether you’re healthy and who to call today. Most owners export their open invoices from QuickBooks and paste them in once.

I’m not a spreadsheet person.

You never touch a formula. Yellow cells are where you type; everything else calculates itself. The quick-start guide takes about 10 minutes.

What kind of business is this for?

Any business that invoices customers and waits to get paid — landscaping, HVAC, plumbing, cleaning, contracting, agencies, consultants. If you send invoices, this works.

How is this different from the AR & Collections Toolkit?

This is the starter kit: your KPIs plus invoice tracking. The Toolkit goes further into collections workflow and cash forecasting. Start here, upgrade when you’re ready.

Refunds?

30 days, no hoops. See the guarantee above.