Quick Summary
A freelancer cash flow spreadsheet tracks invoiced revenue, collections timing, and operating expenses. 15-minute monthly reconciliation routine and Google Sheets template.
Quick answer. A freelancer cash flow spreadsheet tracks three things: invoices issued (revenue), payments received (cash), and operating expenses. The gap between revenue and cash is your accounts receivable. The gap between cash in and cash out is your operating cash flow. Our Cash Flow Forecast template covers this with a tab for each, plus a 12-month forward projection.
For a solo freelancer, cash flow is more important than profit. You can be profitable on paper and still go bankrupt if your invoices take 60 days to collect and your rent is due tomorrow. This post covers the 15-minute monthly reconciliation routine that keeps the picture honest.
Three things to track
1. Invoices issued. What you billed clients this month. This is revenue in accounting terms but not yet cash.
2. Payments received. What hit your bank account this month. May correspond to invoices from prior months. This is cash.
3. Operating expenses. What went out: software subscriptions, contractor payments, business insurance, taxes, etc.
The reconciliation is comparing these three streams against each other and against your bank balance.
The three sheets
Sheet 1: invoices issued
One row per invoice. Columns:
| Column | Example |
|---|---|
| Invoice date | 2026-04-15 |
| Invoice number | INV-2026-042 |
| Client | Acme Corp |
| Amount | 4,800 |
| Due date | 2026-05-15 |
| Status | Sent / Paid / Overdue |
| Payment date | (filled when paid) |
| Payment amount | (filled when paid) |
| Days to pay | =Payment date - Invoice date |
| Notes | Q2 retainer |
Filter by Status to see what’s outstanding. Sort by Days to pay to identify problem clients.
Sheet 2: payments received
One row per payment. Columns:
| Column | Example |
|---|---|
| Payment date | 2026-05-22 |
| Client | Acme Corp |
| Amount | 4,800 |
| Method | ACH / Check / Stripe / PayPal |
| Fees | 0 |
| Net received | =Amount - Fees |
| Invoice number | INV-2026-042 |
| Notes |
The Method and Fees columns matter. Stripe takes 2.9 percent plus 30 cents; ACH might take a few dollars; checks are free but slow. Knowing the cost per channel helps you choose how to invoice.
Sheet 3: operating expenses
One row per business expense. Columns:
| Column | Example |
|---|---|
| Date | 2026-05-08 |
| Category | Software |
| Vendor | Adobe Creative Cloud |
| Amount | 60 |
| Tax-deductible? | Yes |
| Notes | Annual subscription, prorated monthly |
Categories should align with Schedule C lines for tax purposes (advertising, supplies, software, professional fees, etc.). For the full self-employed deduction list, see 25 Self-Employed Tax Deductions for 2026.
The 15-minute monthly reconciliation
Once a month (the 1st works for most people), 15 minutes of attention.
Minute 1 to 5: invoices.
- Pull last month’s invoices issued from your invoicing tool (Stripe, Wave, Bonsai, etc.).
- Verify each is in the spreadsheet. Add any missing.
- Update Status for any that have been paid since last reconciliation.
Minute 6 to 10: payments.
- Open your business bank account.
- Filter to last month’s deposits.
- Verify each is in the spreadsheet. Add any missing. Match each to an invoice.
- Cross-check: total deposits in your bank should match total payments in the sheet.
Minute 11 to 15: expenses.
- Pull last month’s business credit card statement.
- Categorize each charge that isn’t already in the spreadsheet.
- Verify total expenses in the sheet matches the statement.
Output: the dashboard tab updates automatically with last month’s revenue (invoices), cash (payments), expenses, and net.
15 minutes a month, 3 hours a year, complete cash flow picture.
A worked example
Anya, freelance copywriter, May 2026.
Invoices issued:
- INV-091: Acme Corp, $3,200, sent May 3, due June 3
- INV-092: BrightSky, $1,800, sent May 10, due June 10
- INV-093: Acme Corp, $4,400, sent May 22, due June 22
- INV-094: Mednet, $2,200, sent May 28, due June 28
Total invoiced: $11,600.
Payments received:
- $3,400 from BrightSky (April invoice)
- $5,200 from Acme Corp (April invoice)
- $1,800 from Mednet (April invoice)
Total received: $10,400.
Operating expenses:
- Software: $185 (Adobe, Notion, ConvertKit)
- Bookkeeping: $120
- Health insurance premium: $480
- Self-employment tax (Q2 estimate): $1,650
- Solo 401(k) contribution: $2,500
- Office supplies: $40
- Internet (60 percent business): $54
Total expenses: $5,029.
Net cash flow for May: $10,400 - $5,029 = $5,371.
Bank balance increased $5,371 from May 1 to May 31 (or however close it matches; small variance is normal due to timing).
Accounts receivable: $11,600 (invoiced) minus $10,400 (received from prior months) = different concept; A/R is the sum of unpaid invoices regardless of when issued. Anya has $11,600 in unpaid invoices outstanding at end of May (assuming none of May’s were paid yet).
Where the spreadsheet helps that accounting software doesn’t
For a solo freelancer, full accounting software (QuickBooks Online, Xero, FreshBooks) is often overkill. The spreadsheet has advantages.
Lower cost. $29 once vs $30/month for QuickBooks. Over 5 years that’s $1,800 vs $29.
Custom views. Pivot the data however you want. Group by client, by month, by category. Accounting software has fixed reports.
Tax preparation. Schedule C categories pre-aligned. At year end, totals copy directly into tax software.
Cash flow projection. The 12-month forward projection (next section) is where spreadsheets shine. Accounting software shows what happened; spreadsheets project what will.
The 12-month forward projection
The most useful tab. Forecasts cash flow forward.
| Month | Recurring revenue | One-time revenue | Operating expenses | Tax estimates | Net cash flow | Cumulative |
|---|---|---|---|---|---|---|
| Jun 2026 | 5,200 | 3,800 | 4,200 | 0 | 4,800 | 4,800 |
| Jul 2026 | 5,200 | 1,500 | 4,200 | 0 | 2,500 | 7,300 |
| Aug 2026 | 5,200 | 2,000 | 4,400 | 0 | 2,800 | 10,100 |
| Sep 2026 | 5,200 | 4,500 | 4,200 | 1,650 | 3,850 | 13,950 |
| Oct 2026 | 5,200 | 3,000 | 4,400 | 0 | 3,800 | 17,750 |
| … |
Recurring revenue is monthly retainers or subscription clients. One-time revenue is project work. The forecast is realistic if you base it on signed engagements; aspirational if you’re projecting from new business pipeline.
The Cumulative column is the bank balance forecast. When it dips negative or below your minimum cash buffer, that’s where the forecast tells you to either accelerate billing, raise prices, or cut expenses.
This is the use case business cash flow software targets, but at 1 to 5 person scale, a spreadsheet handles it well.
Common mistakes
Treating invoiced revenue as cash. A $5,000 invoice is not $5,000 in your account until it’s paid. Confusing the two leads to spending money you haven’t received.
Ignoring payment timing patterns by client. Some clients pay net-30 reliably; some are net-60 in practice; some are net-90+. The forecast should account for actual payment behavior, not stated terms.
Forgetting quarterly taxes. A freelancer with $80K net income owes roughly $5,000 to $7,000 quarterly in federal taxes alone. Not budgeting for this is a common cash flow disaster.
Not separating personal and business. Mixing personal and business in one bank account makes reconciliation 10x harder. A separate business account is the single best $0 investment a freelancer can make.
Reconciling annually instead of monthly. Easy to fall behind. The 15-minute monthly habit is the difference between accurate quarterly tax estimates and a March surprise.
What our paid template adds
The Cash Flow Forecast template is $29 and includes:
- Pre-built Invoices, Payments, Expenses sheets with the columns above
- 12-month forward projection
- A/R aging report
- Per-client revenue breakdown
- Categorized expenses aligned to Schedule C
- Dashboard with key metrics: monthly net, A/R total, runway
- Excel and Google Sheets versions
If you’d rather build it from scratch, the structure above is reproducible in about 2 hours. Most freelancers find that monthly reconciliation discipline matters more than tool choice.
Get the template
- Cash Flow Forecast — 12-month small-business cash flow with runway and pipeline weighting.
- Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.
- Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.