Report this item to Etsy

Price:£8.30

13 Week Cash Flow Forecast Spreadsheet, Excel Google Sheets, Small Business Cash Planner, Invoice and Runway Tracker (Digital Download)

You can only make an offer when buying a single item.

Highlights

  • Party decor for gatherings and celebrations
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

13-WEEK CASH FLOW FORECAST — EXCEL AND GOOGLE SHEETS

Profit and cash are not the same thing. A quarter can look fine on the profit and loss and still leave you unable to pay wages in week eleven. This forecast dates every payment on when your customers actually pay, not on the terms you printed, and tells you the week you run short while there is still time to do something about it.

WHAT MAKES IT DIFFERENT

Most cash flow templates assume an invoice on 30 day terms is paid on day 30. Yours are not. This one keeps a record of what each customer really does — 30 day terms, paid in 47 — and dates the money accordingly. In the worked example inside, that single habit is the difference between a comfortable quarter and going under the buffer for three weeks.

NINE TABS

Start Here — what to do, in five steps.
Setup — the Monday week one begins, what is in the bank, the buffer you never want to go under, payroll and tax dates.
Customers — the terms you give against the days they really take, and the gap between them.
Money In — every invoice, and the day the cash is actually likely to land.
Money Out — suppliers, wages, rent, VAT, corporation tax, each on the day it leaves. With one column that saves you: can this payment move?
Forecast — thirteen weeks. Opening, in, out, closing. Red below zero, amber below your buffer.
Scenarios — three levers: a one-off cost, everyone paying later, sales you never collect. The quarter re-runs itself underneath.
Chase List — the fifteen invoices worth a phone call, ranked by what they do to your bank, not by age. Each line shows what the low point becomes if that customer pays.
Dashboard — four numbers, three charts and one sentence.

THE WORKED EXAMPLE

A nine-person joinery firm, thirteen weeks, 61 invoices and 81 payments out. It collects $253,355 and pays out $246,258, finishes the quarter with $23,598 in the bank, and looks perfectly healthy. Its lowest point is $1,522, in week eleven. Push every customer payment back by one week — nothing else — and the same quarter finishes $4,780 overdrawn.

WHAT IS IN THE DOWNLOAD

Three files, instantly.
01 — the workbook, filled in with the worked example so you can see what good looks like.
02 — the same workbook, blank, ready for your figures.
00 — a plain-English guide: what to fill in, in what order, and how to read the answer.

1,001 formulas, nine tabs, three charts. No macros.

WHERE IT RUNS

Built as .xlsx. Opens in Excel 2016 and later on Windows and Mac. For Google Sheets use File, Import, Upload. Formulas, formats and charts carry over. Nothing to install, no add-on, no subscription.

HONEST LIMITS — PLEASE READ

- It does not connect to your bank or your accounting software. You type the figures in.
- It forecasts thirteen weeks, not a year. That is the point of it.
- It is a cash forecast, not a profit and loss.
- The example firm is invented. The arithmetic behind it is not.
- If you do not know how long your customers take to pay, look at ten paid invoices and count the days first. The forecast is only as honest as that one number.

HOW THIS SHOP WORKS

I never ask for shop access. No password, no manager invite, no app permissions. You buy a file, you download it, it is yours. If something in it does not work, message me and I will fix the file.

Instant download. Nothing is posted to you.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see programme terms

View shop registration details

Be the first to review this item

No reviews yet. See what customers say about other items from this shop.
Selçuk Karabüyük
ThePlainLedger ·

Türkiye

We calculate this number using a recency-weighted average of all ratings, with a rating's value decreasing by half each year to best reflect the current experience. 5.0
·
1 sale
·
2.5 years on Etsy
Message seller

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

13 Week Cash Flow Forecast

Cash Flow Forecast Template

Cash Flow Dashboard

Cash Flow Planner

Cashflow Statement

Cash Flow Template

Listed on 18 Aug, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates