TToolWise Digital Shop on Etsy →
Small Business

How to Track Cash Flow in a Small Business

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.

Keep reading

More guides

Small Business

Small Business Bookkeeping in Google Sheets: The Complete Setup Guide

Categories, formulas, and a profit dashboard — a bookkeeping system you'll actually keep up with, no accounting software required.

8 min read
Etsy Sellers

Etsy SEO in 2026: 7 Fixes That Actually Move Your Listings

Forget hacks — these are the seven mechanical fixes that decide whether Etsy shows your listing at all.

7 min read
Small Business

How to Keep a Mileage Log the IRS Will Accept

Miles are one of the biggest deductions solo businesses lose. Here's what a defensible log looks like and how to make keeping one effortless.

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.

Shop ToolWise Digital →