Home / Cash-Flow Forecast

Excel + Google Sheets workbook

See a cash crunch thirteen weeks ahead.

The 13-Week Rolling Cash-Flow Forecast gives a small business a clear, week-by-week view of its cash, with time to plan around the tight weeks.

Instant digital download on Payhip and Etsy.

Forecast Dashboard: opening cash $15,000, week-13 cash $4,015, lowest projected cash $2,160 in week 9, WATCH week 8, and the 13-week cash chart

What you get

A forecast that does the arithmetic and points to the week to watch.

You enter the money you expect to collect and spend. The workbook calculates each week's opening and closing cash, names the first week cash would dip below your safety buffer (WATCH), and compares your plan with what actually happened.

  • A standard Excel workbook (.xlsx) with plain formulas that imports into Google Sheets
  • Seven tabs: Start Here, Settings, Recurring, One-time, Forecast, Actuals and Dashboard
  • A rolling 13-week window from the start date you choose
  • Safety buffer, lowest-cash week, WATCH flag, runway and forecast-versus-actual variance
  • A currency setting: $, €, £ or any symbol you type
  • A Dashboard chart of forecast cash, your buffer and recorded actuals
  • A fictional sample business, Maple Street Coffee Co., already filled in
  • A one-page Quick Start PDF

Watch it work

The week-8 squeeze, named before it arrives.

Maple Street Coffee Co. is fictional. In week 8, an espresso-machine rebuild and a quarterly sales-tax remittance land together. WATCH names week 8, and the lowest projected close follows in week 9 when rent comes due. Then you replace each sample line with your own figures.

Dashboard with callouts: WATCH week 8, lowest cash $2,160 in week 9, week-13 cash $4,015, latest actuals plus $160

Inside the workbook

Every tab has one clear job.

How to use it

Five steps from download to your first forecast.

Formula cells are locked to protect the math. To unlock a sheet, use Review > Unprotect Sheet and leave the password blank.

Who it's for

Owner-operators, shop and cafe owners, and small-business teams who want a short-horizon cash view in a familiar spreadsheet.

  1. Make your own copy. In Excel, use File > Save As. In Google Sheets, use File > Import > Upload > Replace spreadsheet, then File > Make a copy.
  2. Fill in Settings: currency, week-1 start date, opening cash and your safety buffer.
  3. Enter Recurring items (Weekly, Biweekly or Monthly) and One-time items with a week number from 1 to 13.
  4. Type amounts as positive numbers. Direction (Inflow or Outflow) sets the sign.
  5. Read Forecast and Dashboard, and fill in Actuals as each week closes.

Details

File details

FormatExcel workbook (.xlsx) with plain formulas; imports into Google Sheets
IncludesWorkbook plus a one-page Quick Start PDF
Horizon13 rolling weeks from your chosen start date
CurrencyAny symbol you choose
DeliveryInstant digital download from Payhip or Etsy
Price$39 USD on Payhip and Etsy

Planning template notice

This workbook is an educational planning and organizing template. Check every figure against your own records, and make financial, tax, legal and accounting decisions with a professional you engage. Your results depend on the numbers you enter.

How it was made

Level Kept designed this workbook and built it with code. An AI assistant helped write that code and drafted the copy and instructions, which we reviewed and edited. Every formula was specified in advance and checked against a separate, independent calculation: 103 baseline checks and 4 stress tests. Every preview image is rendered from the real workbook.

Buy the forecast

Get the 13-Week Cash-Flow Forecast today.

Instant digital download, $39, from our Payhip store or our Etsy shop.

  • Excel workbook plus a one-page Quick Start PDF
  • Instant download after checkout on Payhip or Etsy
  • Questions? Email hello@levelkept.com