Cash Flow Forecasting with Payment Float
- Payment float puts your cash 2-3 business days behind your sales. You can't spend Tuesday's revenue until Thursday or Friday.
- Model three scenarios every week. Normal, refund spike, chargeback hold. The one you skip is the one that hits you.
- Fifteen minutes a week of forecasting saves more businesses than any fraud tool. Cash flow kills more SMBs than fraud does.
- Your formula: expected weekly cash = projected sales x (1 - reserve%) - refunds - chargebacks - fees, shifted by your payout delay.
Your money arrives days after you earn it. Forecasting is how you keep that gap from breaking you.
You already know how payouts work. Settlement timing, batch cutoffs, reserves. That page has the mechanics. This one answers the next question. How do you actually plan around it?
Cash flow kills more small businesses than fraud does. The money's coming, it just arrives on the wrong day. You sold $40K last week, and payroll is due today. Your processor hasn't deposited yet. That gap between earning money and having money is where businesses break.
The Cash Flow Gap
Every card sale creates a timing mismatch. You deliver on Day 0. The cash lands Day 2 or 3. Suppliers, payroll and rent don't wait for it.
The core problem: revenue flows in continuously. Obligations hit on fixed dates. A $100K month sounds great. Then $15K is in reserve, $8K in refunds hasn't settled, and payroll lands three days before your biggest weekly payout.
Building Your Forecast Model
Stop guessing. Use this formula:
Expected Weekly Cash = (Projected Sales x (1 - Reserve%)) - Refunds - Chargebacks - Fees
shifted forward by your payout delay (T+2 or T+3, where T+X = funds arrive X days after transaction)
Week 1 sales produce cash in Week 1 plus your delay. On T+2 with a Friday batch cutoff, Monday through Thursday sales arrive Wednesday through Saturday. Friday sales land the following Tuesday.
Input Variables
Every number comes from something you already have. Where to find each one:
| Variable | Where to Find It | Update Frequency |
|---|---|---|
| Projected weekly sales | POS/e-commerce dashboard, trailing 4-week average | Weekly |
| Reserve percentage | Processor agreement or merchant portal | Check monthly |
| Refund rate | Processor dashboard, returns report | Weekly |
| Chargeback volume | Processor dashboard, chargeback metrics | Weekly |
| Processing fees | Monthly statement, effective rate | Monthly |
| Payout delay (T+X) | Processor agreement, deposit history | Verify quarterly |
| Batch cutoff time | Processor docs or support | Set once |
| Upcoming fixed costs | Accounting software, bill calendar | Weekly |
Example: $80K/Month E-Commerce Store
- Weekly sales projection: $20,000
- Rolling reserve: 10% ($2,000 held)
- Refund rate: 3% ($600)
- Chargeback rate: 0.5% ($100)
- Processing fees: 2.9% ($580)
- Payout delay: T+2
Expected weekly cash arriving: $20,000 - $2,000 - $600 - $100 - $580 = $16,720
That's 83.6% of gross sales. Plan your expenses around the full $20K and you're short every single week.
Three Scenarios to Model
Run your numbers through three scenarios every week. Five minutes, once you have a template.
Scenario 1: Normal Operations
Use your trailing 4-week averages for sales, refunds and chargebacks. That's your baseline, the week where nothing unusual happens.
Assumption: sales within 10% of average, refund rate under 3%, chargebacks under 0.5%.
Scenario 2: Refund Spike
A product recall, a viral complaint, a seasonal return wave like January on holiday sales. Refunds can hit 8-15% of weekly volume for 2-4 weeks.
Model this: swap your normal refund rate for 10%. On the $20K/week store above, $600 in refunds becomes $2,000. Weekly cash drops $1,400.
Why it matters: refunds hit your account as debits. On a thin balance, a spike can overdraft your deposit account before you notice.
Scenario 3: Chargeback Hold
Your chargeback rate crosses 0.9%. The processor flags the account. Your reserve jumps from 10% to 25%. Or payouts pause entirely for the review.
Model this: set the reserve to 25% and add a 5-day payout delay. On the $20K/week store, $2,000 in reserves becomes $5,000. Every dollar arrives a week later.
Why it matters: this is the scenario that bankrupts businesses. The money isn't gone, it comes back eventually. Payroll and rent just don't wait for a risk team to finish reviewing. See holds and reserves for how to respond.
| Scenario | Weekly Cash | vs. Normal | Cash Gap Risk |
|---|---|---|---|
| Normal | $16,720 | Baseline | Low |
| Refund spike (10%) | $15,320 | -$1,400 | Medium |
| Reserve increase (25%) | $13,720 | -$3,000 | High |
| Payout pause (7 days) | $0 for first week | -$16,720 | Critical |
Cash Flow by Business Type
The timing mismatch looks different depending on what you sell.
E-Commerce / Inventory Businesses
The gap: you buy inventory on Day 0. You pay the supplier on Day 30. The product sells on Day 45-60 and the card revenue lands Day 47-63. That's a 30-60 day hole between cash out and cash in.
What helps: negotiate net-60 supplier terms. Use purchase order financing on large orders. Keep 2-3 weeks of operating expenses in reserve. Track inventory turnover next to your cash forecast.
SaaS / Subscription Businesses
The gap: small day to day, since recurring revenue is predictable. Annual plan refunds are the hidden risk. One enterprise customer cancelling a $12K annual subscription puts a $12K hole in the month.
What helps: model annual plan exposure separately. If 30% of revenue is annual plans, hold a buffer of your largest single-plan refund times three. Watch for friendly fraud on annual renewals.
Service Businesses
The gap: you pay staff on the 1st and 15th. Clients pay net-30, if you're lucky. Cards help, but most service businesses still invoice. So the real delay is 30-45 days, not 2-3.
What helps: move as much billing to card-on-file as you can. Offer invoice clients 2% off for paying inside 10 days. Track card revenue and invoice revenue separately, because one is fast and one is slow.
Seasonal Businesses
The gap: revenue lands in 3-4 months. Expenses spread across 12. Peak season has to fund 6-8 months of little or nothing.
What helps: set aside 30-40% of net revenue during peak, in your own reserve account. Not the processor's. Model your off-season burn rate and work backward to the minimum peak-season target.
When Cash Gets Trapped
Sometimes it isn't timing. Sometimes your money is being held. These need action, not planning.
Reserve increases: the processor raises your rolling reserve from 5% to 15% after a chargeback spike. On $80K a month that's another $8,000 locked up. See holds and reserves.
Payout holds: deposits stop dead. Usually a volume spike, a chargeback threshold breach or a risk review. It can run 3 to 30 days. Your buffer has to cover that window.
Chargeback cascades: one product issue triggers 50 chargebacks in a week. Each one comes off your next payout. If the total beats the payout, your processor debits your bank account. See chargeback metrics for thresholds.
Processor account review: they decide to look at your account. Maybe a volume milestone. Maybe your MCC code drew attention. Payouts slow or stop while they look.
Keep two weeks of fixed operating expenses in a separate bank account. Payroll, rent, the subscriptions you can't lose. Don't connect it to your processor. That's your survival fund when payouts stop.
Simple Weekly Forecast Process
It takes 15 minutes once you've done it twice. Monday morning.
Step 1 - Record last week's actuals (3 minutes) Log actual deposits, refunds, chargebacks and fees. Compare to your forecast. Off by more than 10%? Find out why.
Step 2 - Project this week's sales (3 minutes) Use your trailing 4-week average. Adjust for what you know about this week: a promotion, a seasonal shift, a launch. Don't overthink it. The average is usually close enough.
Step 3 - Apply the formula (2 minutes) Projected sales x (1 - reserve%) - expected refunds - expected chargebacks - fees = expected cash. Shift by your payout delay to see which days the cash actually lands.
Step 4 - Check against obligations (4 minutes) Map daily cash arrivals against what's due. Payroll, suppliers, subscriptions, rent. Flag any day where outflows beat your projected balance.
Step 5 - Run the stress scenario (3 minutes) Pick whichever scenario feels likeliest this week and re-run the numbers. Still solvent under stress? You're fine. If not, move money or delay a payment now. Not Friday.
Tools That Help
You don't need expensive software. Start simple and add a tool when manual tracking breaks down.
| Tool | Cost | Best For | Limitations |
|---|---|---|---|
| Spreadsheet (Google Sheets/Excel) | Free | Everyone starting out | Manual data entry, easy to forget |
| Float | $59+/month | Visual cash flow forecasting | Needs accounting software integration |
| Pulse | $29+/month | Simple scenario modeling | Limited integrations |
| Fathom | $39+/month | Reporting and forecasting combined | Overkill for small businesses |
| Processor dashboard | Free | Real-time deposit tracking | No forecasting, just actuals |
| Your accounting software | Varies | Cash flow reports built in | Forecasting features vary widely |
Under $500K a month: a spreadsheet with your formula, updated weekly. You'll know when you've outgrown it. Two weeks running where you miss the forecast by 20% because you couldn't track every variable. Then move to Float or something like it. See scaling milestones for the upgrade points at each volume tier.
Next Steps
Your next move depends on where you are:
- Just starting on cash flow planning? Go back to payout strategy. Know your exact payout timing, batch cutoff and reserve terms. You can't forecast what you can't measure.
- Forecasting already, but worried about disruptions? Read holds and reserves. It covers what triggers a hold and how to get money released faster.
- Outgrowing manual processes? Check scaling milestones for the volume thresholds where better tooling pays for itself.
Related Pages
- Payout Strategy - settlement timing, batch cutoffs and reserve structures
- Holds and Reserves - types of holds, how to respond, how to get funds released
- Settlement Timing - when an authorization becomes settled funds
- Reconciliation - matching expected deposits to actual arrivals
- Accounting Integration - connecting processor data to your books
- Reading Your Processor Statement - fees, and your effective rate
- Scaling Milestones - what to add at each volume tier
- Chargeback Metrics - the thresholds that trigger reserves and holds