Retail Cash Flow Template

Start with the Weekly Cash Flow sheet. Download the file, open it in Excel or Google Sheets, and enter your current bank balance in the starting cash cell. Fill in expected inflows for the next 13 weeks: projected weekly in-store and online sales by channel, any confirmed wholesale orders, and other expected income. Use the last 4-6 weeks of POS reports as your baseline — most store owners complete the inflow side in about 20 minutes. Then fill in outflows: upcoming inventory orders, your payroll schedule, and monthly fixed costs like rent and utilities. The credit card settlement row adjusts daily sales for the typical 1-3 day processing lag so your ending balance reflects cash that's actually in your account.

Retail stores fail financially for a specific reason that doesn't show up on a P&L: the inventory-to-cash gap. A store buys stock in advance, receives it weeks later, puts it on the floor, waits for customers to buy it, and then — after credit card processing — collects the cash 1-3 days after the sale. Meanwhile, the supplier invoice is due net 30 or net 60 from receipt. The entire cycle, from placing an order to collecting cash from the customer, can span 60-120 days. A store running 40-60% gross margins looks healthy on paper right up until the moment it can't fund payroll because three large vendor invoices hit in the same week as a slow sales stretch.

Key Performance Indicators