Turn essential business costs into a clear fund target and build months of cover step by step.
View on Etsy
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.
Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.
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.
The things buyers ask us most.
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.
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.
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.
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.
Three more workbooks from the same shelf.
Turn essential business costs into a clear fund target and build months of cover step by step.
View on EtsySuppliers, purchase orders, deliveries and payments tracked in one workbook.
View on EtsyTrack vendor bills and due dates, with a pay run check against the cash you actually have.
View on Etsy