Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Trades and Projects 13-Week Cash Flow Forecast

A 13-week cash flow forecast for a trades business: cash in and out by week, your closing balance and the weeks below your cushion. XLSX with a blank copy.

ForSmall business

Dashboard tab: Lowest balance $5,940, Weeks below cushion 2, Cash at week 13 $9,970, Next 4 weeks net -$7,160; line chart of Closing balance by week ($); column chart of Cash in vs cash out by...Forecast tab: columns Weekly cash, Wk 1 · 23 Mar, Wk 2 · 30 Mar, Wk 3 · 6 Apr, Wk 4 · 13 Apr, Wk 5 · 20 Apr, Wk 6 · 27 Apr; 8 sample rows.Actuals tab: columns Line, Wk 1 · 23 Mar, Wk 2 · 30 Mar, Wk 3 · 6 Apr, Wk 4 · 13 Apr, Wk 5 · 20 Apr, Wk 6 · 27 Apr; 11 sample rows.Settings tab: Currency symbol, Symbol position, Start month, Year and more.

DashboardPreviews of the Dashboard, Forecast, Actuals and Settings tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
5 tabs · 3 charts
Version
1.0 · Updated 7 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • trades-and-projects-13-week-cash-flow-forecast.xlsxXLSX · 35 KB
  • trades-and-projects-13-week-cash-flow-forecast-blank.xlsxXLSX · 34 KB
  • trades-and-projects-13-week-cash-flow-forecast.csvCSV · 834 B
  • LICENSE.txtadded to every download

About this item

A 13-week cash flow forecast for a trades business. It has 5 tabs: Start Here, Dashboard, Forecast, Actuals, Settings. Type your opening balance, the cushion you want to keep and what you expect to come in and go out each week. Once a week is over, type what actually happened on Actuals and it replaces the forecast for that week. The Dashboard with 3 charts shows the lowest balance ahead and the week it lands ($5,940 in the sample data), how many weeks fall below your cushion, cash at week 13 and the net for the next four weeks. Cash in has one line for each project, with deposits and milestone payments. You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab