Invoice & Payment Tracker Spreadsheet

You finished 47 jobs last month and still can't tell which clients owe you money — that's not a cash flow problem, it's a visibility problem.

It's Thursday afternoon. You've got three crews out on jobs, two invoices you *think* you sent last week, and a commercial client whose 30-day terms are up — but you can't remember if they paid or just said they would.

You open your phone. Check your texts. Scroll your email. Pull up the spreadsheet you've been patching together since you started. It's got jobs mixed in with expenses, a tab you stopped updating in March, and three different ways you've labeled "paid." You close the laptop. You'll deal with it tomorrow.

Sound familiar?

**CleanBooks Pro** was built for exactly this moment — for the owner-operator running 3 to 8 crews across a mix of weekly residential accounts, biweekly home cleanings, and commercial janitorial contracts who needs one clean, reliable place to see who owes what, when it's due, and how much came in this month. No accountant required. No subscriptions. No learning curve.

---

**WHAT'S INSIDE**

**📋 Client & Contract Register**
Every client — residential or commercial — lives in one organized roster. Weekly accounts, biweekly rotations, one-time deep cleans, recurring janitorial contracts. You'll see the service type, billing frequency, rate, and account status at a glance. Adding a new client takes 60 seconds.

**🧾 Invoice Log with Running Status**
Every invoice you generate gets logged with the client name, job date, invoice number, amount billed, due date, and payment status. The tracker updates automatically as you mark payments received. At any moment, you can see exactly who's current, who's overdue by 7 days, and who's been ignoring you for three weeks.

**💰 Payment Collection Tracker**
This is the collections muscle of CleanBooks Pro. Filter your outstanding invoices by client, by crew, by service type, or by how many days past due. Partial payments are tracked. Notes fields let you log "client said check is in the mail" without losing that detail in a text thread. You'll stop chasing ghosts because you'll know exactly who to call and what to say.

**📈 Monthly Revenue Summary**
One dashboard. Total invoiced, total collected, total outstanding — broken down by month. You'll finally be able to answer the question every cleaning business owner dreads: *"Was last month actually profitable?"* Spot your slowest billing months. See which service category — residential, commercial, or add-ons — is driving the most revenue. Make real decisions with real numbers.

**🔁 Recurring Job Scheduler**
Built for the reality of cleaning businesses: clients don't just show up once. Map out your weekly and biweekly accounts so you always know what's scheduled, what's been invoiced, and what still needs to go out. Never miss billing a recurring client because the job felt routine.

**➕ Service Add-On Tracker**
Deep clean upgrades. Move-out specials. Window washing add-ons. Those line items are where your margin lives — and they're the first thing to fall through the cracks in a messy spreadsheet. CleanBooks Pro has a dedicated section to log and invoice service add-ons separately, so none of that revenue disappears.

**📊 Cash Flow Tracker View**
See money coming in against your expected billing schedule. Know which weeks are going to be tight before they happen. This isn't just bookkeeping — it's forward visibility that helps you make payroll, plan crew schedules, and stop operating in reaction mode.

---

**WHO THIS IS FOR**

- Residential cleaning companies with regular weekly or biweekly accounts
- Commercial janitorial contractors billing on net-30 or net-15 terms
- Owner-operators managing multiple crews who need visibility without complexity
- Cleaning business owners ready to graduate from notes apps, scattered spreadsheets, and "I'll figure it out at tax time"

---

**WHY THIS WORKS BETTER THAN GENERIC TEMPLATES**

Generic invoice trackers are built for freelancers billing one client at a time. CleanBooks Pro was designed around the operational reality of a cleaning business: recurring schedules, multiple crews, a mix of contract types, and clients who sometimes pay late, partially, or not at all. The structure reflects how you actually work — so you'll actually use it.

---

**WHAT YOU GET**

✅ Full-featured Excel file (.xlsx) — compatible with Microsoft Excel and Google Sheets
✅ Pre-built formulas — no setup required, open and start entering data
✅ Clean, unlocked layout — customize colors, add your logo, rename tabs to fit your workflow
✅ Instant digital download — delivered to your Etsy account immediately after purchase
✅ Lifetime access — pay once, use it for as long as your business runs

**License:** Personal and single-business use only.

---

**HOW TO GET STARTED**

1. Purchase and download the file from your Etsy account
2. Open in Excel or upload to Google Drive to use in Google Sheets
3. Add your client list and current invoices
4. Start tracking — you'll have a clear picture of your collections within the hour

---

Questions before you buy? Send a message through Etsy — typical response time is under 24 hours.

**Stop guessing. Start knowing.** Your cleaning business runs on recurring revenue — CleanBooks Pro makes sure every dollar of it gets invoiced, tracked, and collected.

→ Add to cart and get your books under control today.

Perfect for: Owner-operator of a cleaning company running 3–8 crews with a mix of weekly/biweekly residential accounts and commercial janitorial contracts

Why now: Cleaning companies are scaling fast post-pandemic with tight labor margins, and most are still tracking invoices in notebooks or generic spreadsheets — missing overdue balances, losing add-on revenue, and undercharging on supplies; a purpose-built tracker pays for itself in the first recovered invoice

✓ Instant digital download
✓ Works with Microsoft Excel (Mac & PC) and Google Sheets
✓ No technical skills required
✓ Formulas and calculations already built in

📋 LICENSE: Personal and single-business use only. This template may not be resold, redistributed, or used to create derivative products for sale.