● 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›Small Business Cash Flow Spreadsheet
Small Business Cash Flow Spreadsheet main view of the forecast workbook
BOOKKEEPING & BUSINESS FINANCE

Small Business Cash Flow Spreadsheet

The balance looks fine today; the scary question is what it looks like in six weeks when rent, payroll and tax land together. This cash flow spreadsheet forecasts your next 13 weeks, so a tight week shows up on screen first.

$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

See the tight week while there is still time to fix it

A budget tells you what already happened. This template answers a different question: will the business be okay in week nine? You log the money coming in and the money going out, including payments that are expected and bills that are due but not yet paid. From those two logs it builds a week by week forecast for the next 13 weeks and a full 12 month outlook behind it.

The Weekly Forecast shows opening balance, money in, money out, net and closing balance for every week. You set a low balance level on the Settings tab, and any week that closes under it is flagged in red, which turns a vague worry into a date you can act on. There is still time to chase a payment, move a bill or trim a cost when the warning arrives weeks early.

The Dashboard is the Monday morning read: your balance today, what is coming in and going out over the next 30 days, your projected balance, and the lowest week ahead with the date it lands. The Annual Summary totals your categories for the year and names your best and worst months. It is made for freelancers, sole traders and small teams, with no accounting software and no subscription.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the template into your own Google Drive
  • BLANK Excel workbook, your fresh start with the settings ready to fill in
  • EXAMPLE Excel workbook filled with a sample studio's numbers across five months
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Google Sheets with a free Google account
  • Also runs in Excel 2021 or Microsoft 365
  • No bank connection, you log entries yourself in seconds
  • Any currency works, because amounts are plain numbers you type
  • Works on computer, tablet and phone

Questions about this template

The things buyers ask us most.

How is this different from a budget planner?

A budget compares what you planned to spend with what you spent. This template forecasts your actual bank balance, week by week, from the payments and bills you have logged, including the ones that have not happened yet. It answers whether you will be okay in week nine, not whether you overspent back in March.

My income is irregular. Will the forecast still work?

Yes, and irregular income is exactly who it was built for. Log expected payments with the dates you honestly expect them, even the uncertain ones, and the Weekly Forecast shows the shape of the next 13 weeks. When a date moves, change the date in the log and the whole forecast moves with it.

Does it connect to my bank account?

No, and that is deliberate. You log each payment and bill yourself in about ten seconds, so your numbers stay private, stay yours, and never break because a bank feed stopped working. The Cash In and Cash Out logs hold both money that has landed and money that is still expected or due.

What does the low balance flag mean?

You set an alert level on the Settings tab, for example 500 in your currency. On the Weekly Forecast, any week whose closing balance falls under that level is highlighted and flagged. It is an early warning, not an error: it gives you weeks of notice to bring a payment forward or push a bill back.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Cash Flow Spreadsheet Template

A 13-week and 12-month forecast that flags tight weeks before they can hurt.

$7.50 $3.00
View on Etsy
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
View on Etsy · $3.00