How to Forecast Cash Flow When Half Your Revenue Is on Credit Terms

The Cash Flow Forecasting Problem for Credit-Heavy Businesses

Revenue on paper and cash in the bank are two different things. Every B2B finance team knows this, but too many cash flow forecasts treat them as though they're the same.

When 50%, 70%, or 90% of your revenue is sold on net 30, 60, or 90-day terms, your cash flow forecast isn't really a revenue forecast - it's a collections forecast. The question isn't "how much will we sell?" It's "how much of what we sold will actually convert to cash, and when?"

This distinction matters enormously. A company booking $2 million per month in revenue on net 60 terms has roughly $4 million in outstanding receivables at any given time. If the actual collection timeline drifts from 60 to 75 days on average, that's an additional $1 million locked up in AR. Miss that in your forecast, and you're planning with cash you don't have.

This guide covers how to build a cash flow forecasting model that accounts for the realities of B2B credit: payment delays, partial payments, bad debt, seasonal patterns, and buyer-level variability.

Why Standard Cash Flow Forecasts Fail for B2B

Most cash flow forecasting templates assume relatively predictable cash inflows. They work well for subscription businesses with recurring charges or retail operations with point-of-sale payments. They break down for B2B credit-based businesses for several reasons.

Payment Timing Is Uncertain

Even with net 30 terms, not every buyer pays on day 30. Some pay on day 22 (especially if you offer early payment discounts). Many pay on day 35-45. Some stretch to day 60 or beyond. A forecast that assumes all invoices convert to cash at exactly net 30 will be wrong every single month.

Buyer Risk Creates Variability

Not all receivables are equally collectible. A $200,000 invoice to a Fortune 500 buyer with a 10-year payment history is essentially guaranteed cash. A $200,000 invoice to a fast-growing startup you onboarded six months ago carries meaningful default risk. Your forecast needs to weight these differently.

Concentration Risk Amplifies Errors

If one buyer represents 20% of your revenue and that buyer delays payment by two weeks, your entire cash flow forecast is off by a significant margin. B2B companies typically have more concentrated customer bases than B2C, which means individual buyer behavior can swing your cash position materially.

Seasonal and Cyclical Patterns

Many B2B industries have distinct payment seasonality. Construction slows collections in winter. Retail buyers delay payments after holiday inventory build-ups. Agricultural supply chains follow growing seasons. A flat forecast that ignores these patterns will alternate between overly optimistic and overly pessimistic.

Building a Credit-Adjusted Cash Flow Model

Here's how to construct a cash flow forecast that actually works for B2B credit businesses. The approach uses historical payment data to predict future cash conversion, adjusted for buyer risk.

Step 1: Analyze Your Historical Payment Patterns

Start with your accounts receivable data from the past 12-24 months. For every invoice, capture:

• Invoice date
• Due date (stated terms)
• Actual payment date
• Amount invoiced vs. amount collected (to capture partial payments and deductions)
• Buyer name/segment

From this data, calculate your actual payment distribution. What percentage of invoices are paid within terms? What percentage are 1-15 days late? 16-30 days late? 30+ days late? What's your average collection period vs. your stated terms?

This distribution becomes the foundation of your forecast. If your historical data shows that 35% of invoices are paid within terms, 40% are paid 1-15 days late, 15% are paid 16-30 days late, and 10% are paid 30+ days late, apply those same percentages to your projected invoicing.

Step 2: Segment by Buyer Risk Tier

A single payment distribution applied uniformly is better than nothing, but it hides important variability. Segment your buyer base into tiers:

• Tier 1 (Low Risk): Large, established companies with strong payment history. Based on your buyer risk assessment, these buyers have high credit scores and consistent on-time payment.
• Tier 2 (Medium Risk): Mid-market companies with generally good but occasionally inconsistent payment behavior.
• Tier 3 (High Risk): Smaller or newer buyers, those in stressed industries, or accounts with a history of late payments and red flags.

Calculate separate payment distributions for each tier. Your Tier 1 buyers might show 70% within terms and 0% bad debt. Your Tier 3 buyers might show 20% within terms and 5% eventual write-off. Apply the appropriate distribution to each buyer's projected invoices.

Step 3: Build the Rolling Forecast

With your segmented payment distributions, build a 13-week rolling cash flow forecast (the standard for treasury management). For each week:

Cash Inflows: - Take your invoicing plan (expected invoices by buyer and amount) - Apply the buyer-tier-specific payment distribution to each invoice - Sum the expected collections for that week across all outstanding invoices

Cash Outflows: - Payroll, rent, vendor payments, loan servicing, and other fixed obligations - Variable costs tied to production/fulfillment - Tax payments, insurance, and other periodic expenses

Net Cash Position: - Starting cash + inflows - outflows = ending cash - Track the minimum cash balance across the 13-week horizon - that's your pinch point

Step 4: Add a Bad Debt Haircut

Your forecast should include a provision for invoices that will never be collected. Base this on your historical write-off rate, adjusted for current portfolio quality.

If your trailing 12-month bad debt rate is 1.5% of invoiced revenue, apply at least that percentage as a reduction to your forecasted collections. If your current buyer portfolio is riskier than average (more Tier 3 exposure, elevated DSO trends), increase the haircut.

This is conservative forecasting, and it's essential. The companies that run into cash crises are almost always the ones whose forecasts assumed 100% collection.

Step 5: Model Scenarios

No forecast is a guarantee. Build three scenarios:

• Base case: Uses your historical payment distributions and current bad debt rates
• Optimistic case: Assumes a modest improvement in collection timing (e.g., 5% more invoices paid within terms) and lower bad debt
• Pessimistic case: Assumes a deterioration - slower payments across the board, one major buyer defaulting, or a seasonal slowdown hitting harder than expected

The pessimistic case is your stress test. If your cash position goes negative in the pessimistic scenario within the 13-week window, you need to take action now: accelerate collections, arrange a credit facility, or reduce commitments.

Practical Tools and Techniques

The AR Aging Schedule as a Forecasting Input

Your AR aging report isn't just a collections tool - it's a forecasting input. Each aging bucket tells you something about expected cash timing:

• Current (not yet due): These invoices will likely convert to cash within 1-2x your stated terms. Apply your tier-specific distribution.
• 1-30 days past due: High probability of collection, but add 2-3 weeks to your expected timing.
• 31-60 days past due: Collection probability is declining. Apply a 10-20% haircut to these amounts in your forecast.
• 60+ days past due: Apply a 30-50%+ haircut. These are uncertain, and forecasting them at full value is wishful thinking.

Tracking DSO Trends for Forecast Accuracy

Your days sales outstanding is a lagging indicator, but the trend is a leading signal. If your DSO has been climbing for three consecutive months - say from 42 to 45 to 49 - your forecast needs to reflect continued deterioration, not a reversion to 42.

Plot DSO monthly. If it's trending upward, adjust your payment distributions to shift more volume into later buckets. Investigate the root cause: is it a few large buyers slowing down, or a broad shift across the portfolio?

Customer Concentration Sensitivity Analysis

Identify your top 5-10 buyers by AR balance. For each, model the cash flow impact if they:

• Delay payment by 15 days beyond their typical pattern
• Request extended terms (net 30 to net 60)
• Default entirely

If any single buyer default would put you in a negative cash position, you have a concentration risk problem that needs to be addressed - either through credit limits, credit insurance, or customer diversification.

Common Forecasting Mistakes to Avoid

Mistake 1: Using Revenue Projections as Cash Projections

This is the cardinal sin. Revenue recognized is not cash received. If you sell $500,000 on net 60 terms on July 1, that cash isn't arriving until September at the earliest. Your July cash flow should reflect zero from that sale.

Mistake 2: Ignoring Partial Payments and Deductions

In B2B, buyers frequently pay less than the invoiced amount - deducting for damages, returns, pricing disputes, or unauthorized early payment discounts. If your historical data shows that buyers deduct an average of 2-3% from invoiced amounts, build that leakage into your forecast.

Mistake 3: Forecasting New Customers Like Existing Ones

A new buyer with no payment history is an unknown quantity. Don't apply your portfolio-average payment distribution to new accounts. Use your Tier 3 (conservative) distribution until they establish a track record. This prevents new customer growth from creating a false sense of cash security.

Mistake 4: Not Updating the Forecast Frequently Enough

A cash flow forecast built in January and not updated until April is worse than no forecast at all, because it creates false confidence. Update weekly. Every Monday, roll the 13-week forecast forward, plug in actual collections from last week, and adjust projections based on new information.

Mistake 5: Excluding Contingencies

Your forecast should include a cash buffer for unexpected events: a major buyer disputing a large invoice, a supply chain disruption requiring prepayment to a new vendor, or a regulatory change affecting your collections timeline. A 10-15% buffer on your minimum cash balance is prudent.

Connecting Forecasting to Credit Decisions

Your cash flow forecast should inform your credit policies, and vice versa. If your forecast shows a cash pinch in eight weeks, that's not the time to extend net 90 terms to a new buyer. Conversely, if your cash position is strong and forecast shows continued strength, you might offer more favorable terms to win strategic accounts.

Specifically, use forecast outputs to drive credit limit decisions and credit policy adjustments. Tighten terms when the forecast shows stress. Extend them when it shows strength. This dynamic approach to credit management - informed by real-time forecasting - is far superior to static annual policy reviews.

Key Takeaways

Cash flow forecasting for B2B credit businesses requires moving beyond simple revenue projections. Analyze your historical payment patterns, segment by buyer risk, build a rolling 13-week forecast with bad debt provisions, and model multiple scenarios. Update weekly, track DSO trends as a leading indicator, and stress-test against your top customer concentrations.

The companies that forecast accurately don't have better crystal balls - they have better data about their buyers' payment behavior and the discipline to use it. When half your revenue sits in accounts receivable at any given time, the quality of your collections forecast is the quality of your financial planning.