Small Business Cash Flow: How to Track It in a Simple Spreadsheet
Cash flow tracking means recording every payment that comes into and goes out of your business, and comparing the two. A basic spreadsheet with columns for date, description, money in, money out, and a running balance is all you need to start. The goal is to see your real cash position on any given day — not just what your invoices say you are owed.
Why cash flow kills profitable businesses
It sounds contradictory, but many small businesses that fail are actually profitable on paper. The problem is timing. You invoice a client in April, they pay in June, but your supplier bill, rent, and software subscriptions are due in May. On your profit-and-loss statement you made money. In your bank account you have nothing to pay with.
This gap between profit and cash is the single most common financial shock for freelancers, consultants, and small-business owners. Tracking cash flow does not prevent the gap — but it shows you it is coming weeks in advance, so you can act on it.
What is cash flow and how is it different from profit?
Cash flow is the movement of actual money into and out of your business bank account. Profit is revenue minus costs on paper, which may include money you have not yet received (outstanding invoices) or costs you have not yet paid (upcoming bills).
| Cash flow | Profit | |
|---|---|---|
| What it measures | Money actually received and paid | Revenue minus expenses on paper |
| Timing | When cash changes hands | When the transaction is recorded |
| Accounts for unpaid invoices | No — only received cash | Yes |
| Accounts for upcoming bills | Only when paid | Sometimes |
| Best for | Day-to-day survival decisions | Assessing business performance |
A business needs both. Profit tells you whether the model is working. Cash flow tells you whether you can make payroll next week.
What should a cash flow spreadsheet include?
A practical cash flow spreadsheet for a small business should include, at minimum: the date of each transaction, a brief description, the amount received (money in), the amount paid (money out), and a running balance that updates automatically after each row.
More advanced versions add a category column (so you can see where money is going), a projected column alongside the actual column, and a summary section that shows weekly or monthly totals. The SheetReady Cash Flow & Profit Dashboard and 13-Week Cash Flow Forecast both use this structure.
How to set up a basic cash flow spreadsheet
Step 1 — Create five columns
Open Google Sheets or Excel. Label the columns:
- A: Date
- B: Description
- C: Money In
- D: Money Out
- E: Running Balance
Step 2 — Enter your opening balance
In row 2, put today's date, "Opening balance" in the description, your current bank balance in column C, and that same figure in column E.
Step 3 — Record transactions as they happen
For every payment you receive, enter it in column C. For every payment you make, enter it in column D. The running balance in column E uses a simple formula: =E2+C3-D3 (previous balance plus money in minus money out). Copy that formula down for every subsequent row.
Step 4 — Review once a week
At the end of each week, check that your running balance matches your bank statement. Any mismatch signals a transaction you missed. This weekly reconciliation takes five minutes and keeps your data reliable.
Step 5 — Spot shortfalls before they hit
Once you have a few weeks of data, you can start adding projected rows for future known outflows — rent due on the 1st, a supplier invoice due on the 15th, and so on. When the projected balance dips negative, you know to act: chase an outstanding invoice, delay a discretionary purchase, or arrange a short-term credit facility.
What is a 13-week cash flow forecast and who needs it?
A 13-week cash flow forecast is a rolling, week-by-week projection of all expected cash inflows and outflows for the next quarter. It is the standard tool used by accountants, lenders, and finance managers to manage business liquidity.
The 13-week window is long enough to show seasonal dips or invoice timing problems, but short enough that the numbers stay credible. It is particularly useful for:
- Businesses with irregular invoice payment terms (30, 60, or 90 days)
- Seasonal businesses that have high-cash and low-cash periods
- Any business that has taken on debt and needs to manage repayments
- Freelancers and consultants with lumpy, project-based income
If you want the structure pre-built, you can download the 13-week forecast ($24) — it comes with weekly in/out columns, a rolling closing balance, and a low-cash alert that highlights any week where the projected balance drops below a threshold you set.
Simple cash flow tracker vs. full dashboard — which do you need?
| Simple tracker (DIY) | Cash Flow & Profit Dashboard | 13-Week Forecast | |
|---|---|---|---|
| Best for | Sole traders, brand new businesses | Businesses with multiple income streams | Businesses with longer payment cycles |
| Tracks actuals | Yes | Yes | Primarily projections |
| Shows profit view | No | Yes (separate P&L tab) | No |
| Forecasting | No | Limited | Yes — 13 weeks ahead |
| Setup time | 15–20 min | 5 min | 5 min |
| Price | Free (your time) | $24 (SheetReady) | $24 (SheetReady) |
For a freelancer or very small business just getting started, the DIY tracker above is a completely reasonable first step. When your business has multiple clients, recurring expenses, and payment terms that stretch beyond two weeks, a structured dashboard saves meaningful time and surfaces problems earlier.
How often should I update my cash flow spreadsheet?
Update your cash flow record at least once a week. The best businesses update it daily — but for most small-business owners, a weekly session of ten to fifteen minutes is enough to keep the data useful and catch problems before they become emergencies.
Pick a consistent day (Friday afternoon works well for many owners — it closes out the week before the weekend). Pull your bank transactions for the week, enter any you missed, and scan the running balance column. If anything looks off, you have the weekend to think before Monday.
What are the most common cash flow mistakes small businesses make?
Tracking invoiced revenue, not received cash. An invoice is not money. Until the payment clears your account, it does not belong in your cash flow record — only in your accounts receivable.
Skipping the weekly review. A cash flow spreadsheet you update monthly is usually too late. Problems that are visible three weeks ahead often require only a phone call to fix. Problems discovered the day before payday require panic.
Ignoring seasonal patterns. Most businesses have months that are consistently slow and months that are consistently busy. Once you have six months of data, patterns appear. Knowing that March is always slow lets you hold more cash in February.
No low-cash alert. Decide on a minimum comfortable bank balance — perhaps one month of fixed costs — and treat any balance below that number as a signal to act, not a number to ignore. The Investopedia guide to cash flow is a useful primer if you want the underlying definitions.
Take control of your cash flow
Start with the free structure above, or get a ready-built file that handles the formulas for you. The Cash Flow & Profit Dashboard gives you a full business view — income, expenses, profit, and cash. For businesses that need to plan weeks ahead, the 13-Week Cash Flow Forecast shows every potential shortfall before it arrives. Both work in Google Sheets and Excel.
Frequently asked questions about cash flow tracking
Can I use one spreadsheet for both cash flow and profit tracking?
Yes, and many small businesses do. The SheetReady Cash Flow & Profit Dashboard has separate tabs for cash flow and a profit-and-loss summary in the same file, so you can see both views without switching tools.
My business is very small — do I really need a cash flow tracker?
If you send invoices or have any gap between earning money and receiving it, yes. Even a solo freelancer with two clients can hit a timing crunch that a tracker would have flagged two weeks earlier.
What is the difference between a cash flow statement and a forecast?
A cash flow statement records what actually happened — money that came in and went out. A forecast projects what is expected to happen in the coming weeks or months. Both are useful; the statement tells you where you have been, the forecast tells you where you are heading.
I have clients who pay on 60-day terms. How do I handle that in a spreadsheet?
Create a separate "Expected receipts" column for money you are owed but have not yet received. When the payment clears, move it to your actual "Money in" column. This way you can see both your real cash position and what is on its way.
How does cash flow tracking help at tax time?
When every transaction is already categorised and dated in your spreadsheet, producing a summary for your accountant — or for a tax return — is a matter of filtering by date range, not hunting through a year of bank statements.