Excel workbook
13-Week Cash Flow Forecast: See Your Lowest Cash Week Before You Get There
List what you expect to collect and pay, and see your cash balance each week, the lowest point and when it happens.
$29 one time · example and blank copies · download link by email
Who it is for
Owners who run tight on cash, and bookkeepers who build a short-term cash forecast for a client or a lender.
Why it is different
- Customer payments are spread over the weeks they usually arrive, not counted all at once.
- Monthly and quarterly bills land in the week they fall due, so rent, insurance and estimated tax show up when they hit.
- A filled example for an invented small business and a blank copy with working formulas.
What is inside
- Start Here. Purpose, which cells to fill in and how the weeks are counted.
- Setup. Opening cash, start date, how customers pay over the following weeks, and your recurring bills, loan payments and taxes with their due days.
- Forecast. Thirteen weeks of cash in, cash out, closing cash and the lowest week.
- Scenarios. A stress case with slower collections, a payment delay and changed supplier payments.
- Actuals vs Forecast. Enter what really happened each week and see the difference and the running total.
- Checks. Missing inputs and a warning when cash goes below the minimum you set.
A look inside
Example data, real formulas
Get it
13-Week Cash Flow Forecast
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. A forecast is an estimate based on the numbers you enter. It does not predict actual cash. Cash due after week 13 is outside the forecast. Not financial, tax or legal advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Free starter
Try a free one-tab version first
A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others
Bundle
Business Planning Bundle
This product plus 3 more, in one download.
$79 instead of $106 separately
Bundle
Owner-Operator Trucking Bundle
This product plus 2 more, in one download.
$69 instead of $92 separately
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19