A fictional gift shop ends the month with its $6,000 reserve intact. Two weeks earlier, its balance falls to $1,000.
The owner wants to keep a $6,000 cash reserve. The normal forecast stays above it, with a low point of $9,000.
Week one brings in $7,000 and takes out $16,000. The cash balance falls to $3,000 before the busier sales weeks arrive.
The shop receives $8,000 and pays $10,000. It has $1,000 left, which is $5,000 below its chosen reserve.
If the supplier moves $4,000 from week one to week four and receipts stay on schedule, the lowest balance rises to $5,000.
Even a Friday balance above the reserve can hide a Wednesday shortage. Check payroll, supplier due dates and card settlement dates.
Use the free Excel template linked in the guide. Enter your next three supplier payments and check your lowest expected cash balance.
READ THE GUIDE AND GET THE TEMPLATE ↓