Skip to main content
Getly

Google Sheets Templates

13-Week Cash Flow Forecast Kit — Rolling Projection Spreadsheet + Lender Summary (Excel/Google Sheets)

$24.00

Product Description

A 13-week cash flow forecast is the projection lenders ask for before extending credit: cash in minus cash out, week by week, ending balance every week. This kit builds that view from your own numbers. No macros; works in Excel 2007+ and Google Sheets. Cashflow13.xlsx has five tabs. Setup holds opening cash, the week-1 date, and your minimum cash line. A/R Aging turns each open invoice into an expected collection: bucket by age (current to 90+ days), a rate per bucket (90% current down to 5% past-90, all editable), and the week the money lands. Forecast runs 13 live week columns: collections flow in from the aging tab, you type bills and variable spending, and ending cash chains week to week. Any week that ends below your minimum turns red. Actual logs what really happened and computes variance per category and week. Lender-Summary prints one page: runway in weeks, weeks below minimum, lowest cash point, top 3 deficit drivers, and a line chart of ending cash. It is forward-looking planning, not historical bookkeeping: it answers "will I run out?", the question your books can't. The 10-page PDF guide covers the 15-minute fill-in order, calibrating collection rates from your own invoice history, why lenders standardize on 13 weeks, and five cash-crunch patterns to catch early.

What you get

1 file · 31.15 KB

  • cashflow-13wk.zipZIP · 31.15 KB
Secure CheckoutInstant DownloadMoney-back Guarantee
PublishedSep 16, 2026
File size31.15 KB
File formatZIP
Versionv1.0

Tags

cash flow forecast13 week projectionrolling cash flowsmall business spreadsheetexcel cash flow templategoogle sheets templateaccounts receivable agingweekly cash budgetworking capitalcash runwaylender summaryinvoice tracker
M
Matchbook Labs

Frequently asked questions

Do I get access instantly?

Yes. This is a digital product — you can download it right after checkout, straight from your library.

Can I use it for commercial projects?

Licence terms are set by the seller. Check the product description before you buy — it states any limits on personal, commercial or client use.

What's your refund policy?

You're covered by a 30-day money-back guarantee. If something isn't right, request a refund from your order and the Getly team reviews it.

What file formats and sizes will I get?

You'll download 1 file — ZIP — 31.15 KB in total.

Do I get free updates?

Yes — when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.

Price

$24.00