Cash Flow Forecasting with Payment Float
- Payment float means your cash is always 2-3 business days behind your sales - you cannot spend Tuesday's revenue until Thursday or Friday
- Model three scenarios every week: normal operations, refund spike, and chargeback hold - the one you skip is the one that hits you
- A simple weekly forecasting habit (15 minutes) prevents more business failures than any fraud tool - cash flow kills more SMBs than fraud does
- Your forecast formula: expected weekly cash = projected sales x (1 - reserve%) - refunds - chargebacks - fees, shifted by your payout delay
Before building your forecast, understand:
- Payout strategy - settlement timing, batch cutoffs, and reserve mechanics
- Holds and reserves - why money gets trapped and how to release it
- Settlement timing - when authorization becomes actual cash
- Reconciliation - matching what you expect with what you receive
On this page
You already know how payouts work. Settlement timing, batch cutoffs, reserves - that page covers the mechanics. This page answers the next question: "OK, now how do I actually plan around that?"
Here is the uncomfortable truth. Cash flow kills more small businesses than fraud does. Not because the money isn't coming - it is - but because it arrives on the wrong day. You sold $40K last week, but payroll is due today and 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 value on Day 0, but the cash doesn't land until Day 2 or 3. Meanwhile, your obligations - suppliers, payroll, rent - don't wait.
The core problem: Revenue flows in continuously but obligations hit on fixed dates. A $100K month sounds great until you realize $15K is in reserve, $8K in refunds hasn't settled, and payroll hits 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)
That means sales from Week 1 produce cash in Week 1 plus your delay. If you're on T+2 with a Friday batch cutoff, Monday through Thursday sales arrive Wednesday through Saturday. Friday sales don't land until the following Tuesday.
Input Variables
Every number in the formula comes from somewhere you already have access to. Here is 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 is 83.6% of gross sales. If you planned your expenses around the full $20K, you're short every single week.
Three Scenarios to Model
Every week, run your numbers through three scenarios. This takes five minutes once you have a template.
Scenario 1: Normal Operations
Use your trailing 4-week averages for sales, refunds, and chargebacks. This is 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 (January returns on holiday sales, for example). Refunds can spike to 8-15% of weekly volume for 2-4 weeks.
Model this: Replace your normal refund rate with 10%. For the $20K/week store above, that turns $600 in refunds into $2,000 - reducing your weekly cash by $1,400.
Why it matters: Refunds hit your account as debits. If your bank balance is thin, a refund spike can overdraft your deposit account before you even notice.
Scenario 3: Chargeback Hold
Your chargeback rate crosses 0.9%, your processor flags the account, and suddenly your reserve jumps from 10% to 25% - or payouts pause entirely during review.
Model this: Replace your reserve percentage with 25%, and add a 5-day payout delay. For the $20K/week store, that turns $2,000 in reserves into $5,000, and delays all cash by an extra week.
Why it matters: This is the scenario that bankrupts businesses. Not because the money is gone - it comes back eventually - but because payroll and rent don't wait for your processor's risk team to finish their review. See holds and reserves for how to respond when this happens.
| 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, pay the supplier on Day 30, but don't sell the product until Day 45-60. Card revenue arrives Day 47-63. That is a 30-60 day gap between cash out and cash in.
What helps: Negotiate net-60 supplier terms, use purchase order financing for large orders, and keep 2-3 weeks of operating expenses in reserve. Track your inventory turnover ratio alongside your cash forecast.
SaaS / Subscription Businesses
The gap: Minimal day-to-day gap since recurring revenue is predictable. But annual plan refunds are the hidden risk - one enterprise customer canceling a $12K annual subscription creates an immediate $12K hole in your monthly forecast.
What helps: Model your annual plan exposure separately. If 30% of revenue is annual plans, keep a refund buffer equal to your largest single-plan refund x 3. Watch for friendly fraud on annual renewals.
Service Businesses
The gap: You pay staff on the 1st and 15th. Clients pay invoices on net-30 (if you're lucky). Card payments help close this gap, but many service businesses still invoice - meaning the real delay is 30-45 days, not 2-3.
What helps: Move as much billing to card-on-file as possible. For invoice clients, offer a 2% discount for payment within 10 days. Your forecast should track both card revenue (fast) and invoice revenue (slow) separately.
Seasonal Businesses
The gap: Revenue concentrates in 3-4 months, but expenses spread across 12. You need to build a cash reserve during peak season that survives 6-8 months of low or zero revenue.
What helps: During peak months, set aside 30-40% of net revenue into a separate operating reserve account (not your processor's reserve - your own). Model your off-season burn rate and work backward to determine the minimum peak-season reserve target.
When Cash Gets Trapped
Sometimes the gap isn't about timing - it is about your money being actively held. These situations require immediate action, not just planning.
Reserve increases: Your processor raises your rolling reserve from 5% to 15% after a chargeback spike. On $80K/month, that is an extra $8,000/month locked up. See holds and reserves.
Payout holds: Full stop on deposits. Usually triggered by a sudden volume spike, chargeback threshold breach, or risk review. Could last 3-30 days. You need a cash buffer that covers this window.
Chargeback cascades: One product issue triggers 50 chargebacks in a week. Each chargeback deducts from your next payout. If the total exceeds your payout, your processor debits your bank account. See chargeback metrics for thresholds.
Processor account review: Your processor decides to review your account - maybe you hit a volume milestone, maybe your MCC code is under scrutiny. Payouts slow or stop during review.
Keep a minimum of 2 weeks of fixed operating expenses (payroll + rent + critical subscriptions) in a separate bank account that is not connected to your processor. This is your survival fund for payout disruptions.
Simple Weekly Forecast Process
This takes 15 minutes once you have done it twice. Do it every Monday morning.
Step 1 - Record last week's actuals (3 minutes) Log actual deposits received, refunds processed, chargebacks received, and fees deducted. Compare to what you forecasted. If you were off by more than 10%, figure out why.
Step 2 - Project this week's sales (3 minutes) Use your trailing 4-week average, adjusted for anything you know about this week (promotion running, seasonal shift, new product launch). Don't overcomplicate this - 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 determine which days cash actually arrives.
Step 4 - Check against obligations (4 minutes) Map your expected daily cash arrivals against your upcoming expenses: payroll dates, supplier payments, subscriptions, rent. Flag any day where outflows exceed your projected balance.
Step 5 - Run the stress scenario (3 minutes) Pick whichever of the three scenarios feels most likely this week and re-run the numbers. If even the stress scenario leaves you solvent, you are fine. If not, you need to move money or delay a payment now, not Friday.
Tools That Help
You don't need expensive software. Start simple and add tools only 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 |
Our recommendation for businesses under $500K/month: A spreadsheet with your formula, updated weekly. When you outgrow that - meaning you miss a forecast by 20%+ two weeks in a row because you couldn't track all the variables - move to Float or a similar dedicated tool. See scaling milestones for when to upgrade your tooling at each volume tier.
Next Steps
Depending on where you are, your next move is different:
- Just getting started with cash flow planning? Go back to payout strategy and make sure you know your exact payout timing, batch cutoff, and reserve terms. You can't forecast what you can't measure.
- Already forecasting but worried about disruptions? Read holds and reserves to understand exactly what triggers a hold and how to get your money released faster.
- Growing fast and outgrowing manual processes? Check scaling milestones for the specific volume thresholds where investing in better tooling pays for itself.
Related Pages
- Payout Strategy - settlement timing mechanics, batch cutoffs, and reserve structures
- Holds and Reserves - types of holds, how to respond, and how to get funds released
- Settlement Timing - when authorizations become actual settled funds
- Reconciliation - matching expected deposits to actual bank arrivals
- Accounting Integration - connecting your processor data to your books
- Reading Your Processor Statement - understanding fees and calculating your effective rate
- Scaling Milestones - what tools and processes to add at each volume tier
- Chargeback Metrics - monitoring the thresholds that trigger reserves and holds