Free templates · no sign-up

Cash-flow forecast templates for Excel and Google Sheets

Pick a horizon and an industry, and download a spreadsheet with the formulas already wired up. Drop in your numbers and read your cash flow, net position and running balance straight off the sheet.

1 · Horizon

2 · Industry

3 · Download

The 13-week cash-flow forecast template for online shops, driven by Shopify numbers.

Download Excel (.xlsx) Download for Google Sheets (.csv)

No email, no sign-up. 13 week columns, formulas included.

B8=B5*B6*(1-B7) (orders × AOV × (1 − refund rate))

	W1	W2	W3	W4	W5	W6	W7	W8	W9	W10	W11	W12	W13
Revenue
Orders	190	200	210	205	220	230	225	240	250	245	260	280	300
Avg order value (€)	€58	€58	€59	€59	€59	€60	€60	€60	€60	€61	€61	€61	€62
Refund rate	8%	8%	8%	7%	8%	8%	8%	7%	8%	8%	8%	7%	7%
Revenue (€)	€10,138	€10,672	€11,399	€11,248	€11,942	€12,696	€12,420	€13,392	€13,800	€13,749	€14,591	€15,884	€17,298
Cost of goods
Avg purchase cost / unit (€)	€14	€14	€14	€14	€14	€14	€14	€15	€15	€15	€15	€15	€15
COGS — restocking (€)	€2,660	€2,660	€2,800	€2,940	€2,870	€3,080	€3,220	€3,375	€3,600	€3,750	€3,675	€3,900	€4,200
Shipping & fulfilment
Shipping cost / order (€)	€5	€5	€5	€5	€5	€5	€5	€5	€5	€5	€5	€5	€5
Shipping (€)	€950	€1,000	€1,050	€1,025	€1,100	€1,150	€1,125	€1,200	€1,250	€1,225	€1,300	€1,400	€1,500
Payment fees
Blended fee rate	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%	3%
Payment fees (€)	€304	€320	€342	€337	€358	€381	€373	€402	€414	€412	€438	€477	€519
Advertising
Ad budget (€)	€1,200	€1,200	€1,400	€1,400	€1,500	€1,500	€1,600	€1,600	€1,500	€1,600	€1,800	€2,000	€2,200
Fixed costs
Rent (€)	€580	€580	€580	€580	€580	€580	€580	€580	€580	€580	€580	€580	€580
Salaries (€)	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770	€2,770
Software & subscriptions (€)	€185	€185	€185	€185	€185	€185	€185	€185	€185	€185	€185	€185	€185
Insurance & accounting (€)	€165	€165	€165	€165	€165	€165	€165	€165	€165	€165	€165	€165	€165
Fixed costs (€)	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700	€3,700
Summary
Total costs (€)	€8,814	€8,880	€9,292	€9,402	€9,528	€9,811	€10,018	€10,277	€10,464	€10,687	€10,913	€11,477	€12,119
Net cash flow (€)	€1,324	€1,792	€2,107	€1,846	€2,414	€2,885	€2,402	€3,115	€3,336	€3,062	€3,678	€4,407	€5,179
Cash at end (€)	€21,324	€23,116	€25,223	€27,069	€29,483	€32,368	€34,770	€37,885	€41,221	€44,283	€47,961	€52,368	€57,547

The 13-week cash-flow forecast sheet. Blue cells are yours to overwrite; grey cells are formulas.

Which one

Thirteen weeks or twelve months?

Most businesses end up running both: the weekly view to stay solvent, the monthly one to plan. If you only take one, take the one that matches the decision in front of you.

13-week cash-flow forecast

The rolling short-term view. Week by week across the next quarter — granular enough to catch the exact week you would run short.

Tight runway, where the exact week cash dips matters
Seasonal or inventory-heavy businesses timing restocks and supplier payments
A rolling view you refresh every Monday

12-month cash-flow forecast

The annual planning view. Month by month across the year — the horizon for budgets, hiring plans, runway and fundraising.

An annual budget or financial plan for the year ahead
Raising money — investors expect twelve months, often more
Hires, ad budgets and product lines planned months out

The full comparison — what each horizon answers, and why finance teams run both.

All Excel templates — margin, stock, projects, recurring revenue and the rest, each with its own guide.

What's inside

A model, not an empty grid

Revenue built from its drivers — orders and average order value, not one typed-in number
Variable costs that follow revenue: COGS, shipping and payment fees
Fixed costs on their own rows — rent, salaries, software, insurance
Net cash flow per period and a running cash balance, both already wired up

How to use it

Five minutes, three steps

1
Download and open it
Excel opens the .xlsx directly. For Google Sheets, take the .csv and use File → Import → Upload.
2
Overwrite the driver rows
Only the blue input rows need your numbers. Every grey row is a formula and recalculates itself.
3
Read the bottom two rows
Net cash flow says whether the period earns or burns. The running balance says what is left at the end of it.

Questions

What people ask about these templates

What is a 13-week cash-flow forecast?

A 13-week cash-flow forecast projects every euro of cash in and out, week by week, across the next quarter. It is a short-term liquidity tool: granular enough to catch the exact week you would run short, and short enough to stay accurate. It is usually run rolling — each week you drop the week just gone and add a new week at the end.

What is a 12-month cash-flow forecast?

A 12-month cash-flow forecast projects cash in and out month by month across the full year. It trades the week-level precision of the 13-week view for a longer line of sight, so you can see seasonality, your full-year cash position and when you reach profitability.

Do the templates work in Google Sheets?

Yes. Every template comes as .xlsx for Excel and as .csv for Google Sheets — File → Import → Upload keeps the rows and formulas intact.

Is there really no sign-up?

No email wall, no sign-up, no sales call. The files are static downloads on this page.

A spreadsheet is a snapshot. Foreqast keeps it current.

The template is a good start and a manual job forever after. Connect your accounting and shop data and the same forecast updates itself — day by day, twelve months out.

Get early access