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.

Set up the Vendor Payment Schedule with your regular supplier obligations. List each vendor, their typical invoice size, and payment terms. This usually takes 15-20 minutes if you have your accounts payable aging report handy. Then use the Inventory Purchase Planner for any upcoming stock orders: enter the order amount, expected delivery date, and supplier payment terms. The planner calculates when the cash actually leaves your account versus when you expect to sell through the merchandise and collect payment. Pay particular attention to the weeks where multiple vendor invoices, rent, and payroll all fall in the same 7-day window — those are the pressure points to plan around.

Review the full projection weekly. Update last week's actuals, roll the 13-week window forward, and check whether your ending cash balance stays above your minimum comfort level — for most independent retailers, that's at least 4-6 weeks of operating expenses to absorb a slow stretch. The Dashboard makes this review fast: a 60-second look tells you whether your cash runway is healthy or whether you need to act. For holiday season planning, run the Inventory Purchase Planner in August or September, before you place orders, to confirm you have enough cash to fund the pre-buy and still cover payroll and rent through October. Catching a shortfall in August gives you time to arrange a line of credit; catching it in October does not.

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.

The cash dynamics that matter most in retail are different from what shows up in a budget or income statement. Seasonal inventory pre-buys are the biggest single cash event most retailers face each year — buying Q4 holiday merchandise in September or October requires a large outlay of cash 6-10 weeks before the revenue it generates starts flowing in. Returns in January reduce cash receipts just as the holiday inventory invoices come due. The holiday season may account for 20-30% of annual revenue, but the cash timing means that a store needs its strongest cash position entering Q4, not exiting it. A cash flow view makes this visible; gross margin calculations alone do not.

The right approach is to run a 13-week rolling cash flow projection and update it weekly. Plug in your expected sales based on recent POS data, enter your confirmed and expected inventory orders, and look at where your ending cash balance gets thin. If you're planning a major reorder or seasonal pre-buy, run it through the Inventory Purchase Planner first to see the cash impact before you commit. Retailers who use cash flow projections consistently say it changes how they negotiate with vendors — knowing your payment schedule lets you push for net 60 terms on large orders during your pre-buy season, or time early payment discounts strategically when cash is strong. The numbers only give you leverage if you can see them in advance.