Skip to content

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

pocketshelf

Retail Shop 13-Week Cash Flow Forecast

A 13-week cash flow forecast for a retail shop: 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 $12,540, Weeks below cushion 0, Cash at week 13 $49,060, Next 4 weeks net $11,780; 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; 10 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
  • retail-shop-13-week-cash-flow-forecast.xlsxXLSX · 35 KB
  • retail-shop-13-week-cash-flow-forecast-blank.xlsxXLSX · 34 KB
  • retail-shop-13-week-cash-flow-forecast.csvCSV · 820 B
  • LICENSE.txtadded to every download

About this item

A 13-week cash flow forecast for a retail shop. 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 ($12,540 in the sample data), how many weeks fall below your cushion, cash at week 13 and the net for the next four weeks. The sample splits sales into card and cash and buys stock once a month. 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).

  • 13 week
  • Forecast
  • Small business
  • Retail shop
  • Spreadsheet
  • Cash flow

Reviews

No reviews yet.

You might also grab