● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Cash Flow Spreadsheet Template
Cash Flow Spreadsheet Template hero image showing the forecast workbook
BOOKKEEPING & BUSINESS FINANCE

Cash Flow Spreadsheet Template

The nastiest moment in a small business is not a bad month, it is the surprise: a quiet week and two bills landing together. This cash flow spreadsheet template shows you a shortfall weeks before it arrives, while there is still time to chase an invoice, move a bill or steady the ship.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know what next month looks like before it arrives

Setup takes four entries. On the Start Here tab you type your opening balance, currency, start date and the low-balance level you want warning about, once. The workbook answers immediately with your outlook: the projected balance after 13 weeks, your lowest balance, the 12-month balance and expected profit. From then on the Dashboard keeps watch, showing weeks of expenses your balance covers, average monthly income and outgoings, and the overdue amount still waiting to be chased.

The two forecasts work as a pair. The 13-Week Forecast moves week by week through the near future, money in, money out, net cash flow and a projected balance that carries forward, with a LOW flag on any week that drops to your alert level. The 12-Month Forecast does the same job across a full year, so seasonal dips and big annual bills stop being surprises and become dates you have already planned around.

Reality gets checked against the plan. The Daily Cash Flow Log records money in and out as it happens, with a running balance on every row, and the Income and Expenses tab compares category budgets against actuals pulled from that log. Forecast vs Actual then shows, month by month, whether you beat the plan or missed it. Add the Scenario Planner's best, base and worst cases, and a Bills and Invoices tab that counts days overdue for you, and the workbook covers the cash story.

Inside the workbook: 10 tabs

What you receive

  • Google Sheets Access PDF with a one-click copy link, click it and the workbook is yours
  • BLANK Excel workbook, your clean fresh start
  • EXAMPLE Excel workbook filled with demo data from a small online shop
  • Quick Start Guide PDF with the setup steps on one page
  • Four separate files by instant download, no ZIP to unpack

Good to know

  • Works in Microsoft Excel and Google Sheets
  • Works in any currency, set yours once in setup
  • Beginner friendly, no formulas to write yourself
  • A planning tool only, not financial advice
  • Questions after purchase? Message us any time on Etsy

Questions about this template

The things buyers ask us most.

Do I need to be good with spreadsheets?

No. The workbook is beginner friendly and there are no formulas for you to write. You type your opening balance and a few setup details, fill in what you expect in and out, and the balances, flags and summaries calculate themselves. The Quick Start Guide walks through setup in both Excel and Google Sheets.

How does the LOW flag help me?

During setup you choose a low-balance alert level, the point below which cash gets uncomfortable for your business. The forecasts then flag any week or month that drops to that level with a clear LOW marker. Seeing the flag weeks ahead gives you time to chase payments, delay a purchase or arrange cover before the tight week arrives.

Can I compare my forecast with what really happened?

Yes, that is the Forecast vs Actual tab's whole job. Each month you type what really came in and went out beside the forecast figures, and the sheet shows the variance and variance percent. Over a few months those comparisons teach you where your estimates run optimistic, which makes the next forecast noticeably more honest.

What currency does it use?

Whichever one your business uses. You set your currency once on the Start Here and Setup tab, alongside your opening balance and start date, and it applies across the workbook. The forecasts, dashboard and profit and loss views all work from the numbers you enter, so the template fits businesses in any country.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Business Emergency Fund Tracker

Turn essential business costs into a clear fund target and build months of cover step by step.

$7.50 $3.00
View on Etsy
Small Business Vendor Tracker

Suppliers, purchase orders, deliveries and payments tracked in one workbook.

$7.50 $3.00
View on Etsy
Accounts Payable Tracker

Track vendor bills and due dates, with a pay run check against the cash you actually have.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00