Cash Flow Is Your Primary Business Risk
For a solopreneur, cash flow is not a financial planning concept — it's an existential risk. You have no corporate treasury to draw on. One slow-paying client can create a crisis.
Invoice tracking that gives you clear, current visibility into what's owed and when it's due is the minimum data system a solopreneur needs to manage this risk.
The Invoice Tracking Spreadsheet
One sheet. The columns that matter:
| Invoice # | Client | Issue Date | Due Date | Amount | Status | Days Outstanding | Notes | |---|---|---|---|---|---|---|---| | INV-047 | Acme Inc | 2026-05-01 | 2026-05-31 | $3,500 | Unpaid | 30 | Sent reminder 5/28 | | INV-048 | Beta LLC | 2026-05-15 | 2026-06-14 | $1,200 | Paid | — | Paid 5/22 |
Status values: Draft, Sent, Unpaid, Partial, Paid, Disputed, Written Off Days Outstanding formula (for Unpaid invoices): =TODAY()-C2 (where C2 is issue date)
Sort by Status to see all unpaid invoices. Sort by Due Date to see what's coming due this week. Filter by Days Outstanding > 30 to build your collection list.
Upload your spreadsheet and get an instant quality report — free with Sohovi — try Sohovi free.
The Rules That Keep It Accurate
Rule 1: Enter an invoice the day you send it Not when you remember to. The day it goes out. An invoice not in your tracker isn't being tracked.
Rule 2: Update status the day you receive payment When a payment arrives, open the tracker and change the status to Paid. Don't batch this for end-of-week. Late status updates mean you forget whether you've been paid.
Rule 3: Add a note every time you take a collection action Sent a reminder? Note it. Made a call? Note it. Got a commitment ("I'll pay Friday")? Note it with a date. These notes protect you in disputes and keep your follow-up actions visible.
Rule 4: Review the tracker every Monday Three minutes. Check: anything due this week? Anything overdue without a recent action? Any Partial payments that need a follow-up on the balance?
The Cash Flow View
Add a second tab: a simple cash flow projection.
| Month | Expected Cash In | Source | |---|---|---| | June 2026 | $4,700 | INV-047 ($3,500) + INV-049 ($1,200) | | July 2026 | $2,800 | INV-050 (pending send) |
This view — updated weekly from your invoice tracker — tells you whether you have a cash flow problem emerging in 30–60 days. That's enough time to act (accelerate collections, land a new client, arrange a bridge) rather than react.
