TToolWise Digital Shop on Etsy →
Small Business

How to Track Cash Flow in a Small Business

Looking for a tool?

Tracking cash flow means watching the timing of money moving in and out of your business — not just whether you're profitable, but whether you'll have cash in the account on the day a bill is due. Profitable businesses fail from cash-flow gaps all the time. Here's how to see the money coming and going, and never get blindsided. (This is an organizational guide, not financial advice.)

Profit and cash are not the same thing

Profit is income minus expenses over a period. Cash is what's in the account right now. They diverge because of timing: you finished a $5,000 job (profit booked) but the client pays in 45 days, while rent, materials, and your own pay are due this week. On paper you're up; in the bank you're short. That gap is what cash-flow tracking exists to reveal.

The three flows to watch

Build a simple cash-flow forecast

You don't need software — a forward-looking grid does it. List the next 8–13 weeks as columns. For each week, enter expected money in and known money out, then carry the balance forward:

WeekStarting cashInOutEnding cash
1$4,000$2,500$3,200$3,300
2$3,300$1,000$2,800$1,500
3$1,500$4,500$2,000$4,000

Ending cash is just =StartingCash+In-Out, carried into next week's start. The instant a projected ending balance goes negative, you've spotted a shortfall weeks before it happens — while you still have time to chase an invoice, delay a purchase, or arrange cover.

Revenue is vanity, profit is sanity, cash is reality. The forecast is how you keep all three in the same room.

Habits that keep cash healthy

  1. Invoice immediately and follow up. Your unpaid invoices are next week's cash — see how to invoice and chase late payers.
  2. Take deposits so big jobs fund their own materials instead of draining your balance.
  3. Keep a cash buffer — a few weeks of fixed costs turns a scary week into a boring one.
  4. Don't spend the tax money. A set-aside you dip into is a cash-flow crisis on a timer; see setting aside for quarterly taxes.

Watch it weekly, not yearly

Cash flow rewards frequency. A ten-minute Friday look at what's landing and what's leaving next week is worth more than a beautiful annual report, because cash problems are only cheap to fix early. Update the forecast, glance at what's owed to you, and act while you still have room.

Cash flow and profit are two different lenses on the same business — make sure the profit side is solid too with bookkeeping in Google Sheets.

Quick FAQ

What's the difference between cash flow and profit?

Profit is revenue minus expenses over a period; cash flow is the actual timing of money in and out of your account. A business can be profitable on paper and still run out of cash if customers pay late — which is why you track both.

How do I track cash flow in a small business?

Keep a simple running record of money in and money out by date, and watch your current balance plus what's owed to you and what you owe. The goal is to always know whether an upcoming bill is covered by cash you actually have, not cash you're waiting on.

How do I fix cash flow problems?

Speed up money in (shorter payment terms, deposits, chasing unpaid invoices) and smooth money out (spacing bills, keeping a small buffer). Most cash crunches are timing problems, not profit problems — a live view of paid-vs-owed is what lets you see them coming.

This guide is part of ToolWise's complete system for running your small business finances in Google Sheets — the hub that ties bookkeeping, invoicing, mileage, taxes, and pricing together with a free calculator for each.
Keep reading

More guides

Self-Employed

How Much Should You Set Aside for Self-Employed Taxes?

The short answer is 25–30% of your net income — here's how to land on your exact percentage and never get surprised in April.

6 min read
Self-Employed

Self-Employed Tax Deductions: The Complete Expenses List & Checklist

Every dollar of legitimate business expense you deduct is a dollar you don't pay tax on. Here's the full self-employed expenses list — and how to actually capture them.

9 min read
Self-Employed

How to Track Business Expenses for Taxes

The system that turns tax season from a lost weekend into a 10-minute export — track expenses as you go, sorted by category.

6 min read

Tools that do the work for you

Browse 250+ ready-made spreadsheets for money, home, life, and business — each with a free phone-friendly version.

Browse the catalog →