13-Week Rolling Cash-Flow Forecast for Excel & Google Sheets
13-week rolling cash-flow forecast template for Excel and Google Sheets.
This workbook gives small-business owners a short-horizon, week-by-week view of cash. You enter regular and one-time money in and out. It calculates each week's opening and closing cash, flags the first week cash would dip below your safety buffer, and compares the plan with actuals as the weeks happen.
What's inside
- Standard Excel workbook (.xlsx) with plain formulas that imports into Google Sheets
- Seven tabs: Start Here, Settings, Recurring, One-time, Forecast, Actuals, Dashboard
- Rolling 13-week window from your start date
- Safety buffer, lowest-cash week, WATCH alert, runway and forecast-versus-actual variance
- Currency symbol setting
- Dashboard chart: forecast cash, buffer and recorded actuals
- Fictional sample (Maple Street Coffee Co.) with a planned squeeze in week 8
- One-page Quick Start PDF
The sample shows it working
Maple Street Coffee Co. is a fictional neighborhood cafe. In week 8, an espresso-machine rebuild and a quarterly sales-tax remittance land together. WATCH names week 8 as the first week cash would dip below a $5,000 buffer, and the lowest projected close follows in week 9 when rent comes due. Then you swap in your own numbers.
How it works
- Make a copy before you type (Excel: Save As; Google Sheets: File → Import → Upload → Replace spreadsheet, then Make a copy).
- Set currency, start date, opening cash and your safety buffer.
- Enter recurring items as Weekly, Biweekly or Monthly, and one-time items with a week number from 1 to 13.
- Type amounts as positive numbers and set Direction to Inflow or Outflow.
- Read the Forecast and Dashboard, and record Actuals as each week closes.
Formula cells are locked to protect the math. Review → Unprotect Sheet with a blank password unlocks any sheet.
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 the workbook: its tabs, formulas, checks and layout. An AI assistant helped write the code that builds the file and helped draft the setup notes and this description, and we reviewed and edited each one. Every formula was checked against a separate, independent calculation (103 baseline checks and 4 stress tests). The preview images are renders of the real workbook.
Instant digital download: the workbook and the Quick Start PDF. Questions? hello@levelkept.com
© Level Kept, a brand of Trilogy Performance Media LLC.