Free Cash Flow Spreadsheet for Small Business (Google Sheets)

Most small business owners don’t run out of profit — they run out of cash. And they usually don’t see it coming until it’s already a problem.

A cash flow spreadsheet fixes that. It shows you exactly how much money is coming in, going out, and what your bank balance will look like in 30, 60, or 90 days. It takes about 20 minutes to set up and 10 minutes a week to maintain.

Why Cash Flow Beats Profit for Day-to-Day Operations

Your P&L might show you’re profitable. But if a big client is 60 days late and payroll is next Friday, profit doesn’t pay your team — cash does.

• P&L: Did we make money this period?
• Cash flow: Will we have money to pay our bills next week?

Both matter. For daily operations, cash flow is the one to watch.

What This Template Tracks

The spreadsheet has three sections:

1. Money In — sales, deposits, loans, any cash coming in
2. Money Out — fixed costs, variable costs, owner draws, loan payments
3. Running Balance — your real cash position at any point in time

The key column most business owners skip: projected vs. actual. Tracking what you expected vs. what happened tells you more about your business than any report.

What’s in the Template

Tab 1: Monthly Cash Flow

• Income rows by category (product sales, services, subscriptions)
• Expense rows by category (rent, payroll, COGS, marketing)
• Auto-calculated net cash flow per month
• Running balance row showing your projected account balance

Tab 2: 13-Week Forecast

• Weekly view of expected inflows and outflows
• Useful for spotting short-term cash crunches before they happen

How to Set It Up

Step 1: Copy the template File → Make a Copy. Rename it with your business name and the year.

Step 2: Enter your fixed monthly expenses Start with the things that never change: rent, insurance, subscriptions, loan payments. Enter these once in the Fixed Costs section and they’ll auto-populate for every month.

Step 3: Set your opening balance Enter your current bank balance as the starting point everything else calculates from.

Step 4: Enter projected income by month Use your best estimate. If you have 3+ months of history, average it. New business: use conservative targets.

Step 5: Update weekly Every Friday or Monday, log the previous week’s actual transactions. It takes less time than you think once it’s a habit.

Reading Your Cash Flow Statement

The three numbers that matter most:

Net Cash Flow — positive means you made money; negative means you spent more than came in. A single negative month isn’t a crisis. Three in a row is.

Runway — how many months you can operate at current burn with zero new revenue. Healthy: 3+ months. Dangerous: under 6 weeks.

Projected vs. Actual Gap — if you’re consistently over- or under-estimating, your projections need recalibrating, not your expenses.

Common Mistakes to Avoid

Only looking at profit, not cash timing You invoiced $8,000 in March. Your client pays Net 30. That cash isn’t in your account until April. If April expenses hit in March, you have a problem. Cash flow tracks timing; profit doesn’t.

Not separating owner draws from expenses Your salary is not the same as a business expense. Track it separately so you can see true operating costs vs. what you’re paying yourself.

Ignoring the 13th month Many businesses have annual expenses — insurance renewals, domain registrations, tax payments — that don’t appear monthly. Add a row for these so they don’t blindside you.

Missing the early warning signal Your running balance approaching zero is a warning, not a crisis — if you catch it early. Check it weekly, not quarterly.

When to Move Beyond a Spreadsheet

A spreadsheet is the right tool when you’re starting out, doing under $300K in revenue, or just need clarity fast. Consider upgrading to accounting software when:

• You have employees or contractors to pay
• You need to share financials with a bank or investors
• You’re spending more than 2 hours per week on manual data entry
• Tax prep is taking days because records are scattered

Wave is a good free first step. QuickBooks works well once you need more reporting depth.

Frequently Asked Questions

How often should I update my cash flow spreadsheet? Weekly is the sweet spot. Monthly is the minimum. Daily if you’re in a cash crunch.

What’s the difference between cash flow and profit? Profit is revenue minus expenses on paper. Cash flow is actual money moving in and out of your bank account. They diverge when you have unpaid invoices or prepaid expenses — which is constantly.

How is this different from a budget? A budget is what you plan to spend. A cash flow statement tracks what actually moved — real money, real dates. You need both.

Do I need a separate sheet for each bank account? Not necessarily. If you run all business transactions through one account, one sheet works fine. If you use multiple accounts, add a tab per account and a summary tab.

Can I use this for a service business? Yes — it works for any business that invoices clients or collects payment. The key is logging the date cash actually arrives, not the invoice date.

When should I move to accounting software? Once you’re doing $300K+ in revenue or have multiple bank accounts, Wave (free) or QuickBooks will save you significant time.

How far back should I enter data? Start from today. Entering historical data is a good exercise if you want to see patterns, but don’t let it become a reason to delay setting this up.