Forecasting accounts receivable comes down to estimating how much money your customers will owe you at a future point in time, based on your expected sales and how long those customers typically take to pay. The most widely used method relies on a metric called Days Sales Outstanding (DSO), which measures the average number of days between making a sale on credit and collecting the cash. Once you know your DSO and have a sales forecast, the math is straightforward.
Why Your AR Forecast Matters
Accounts receivable is one of the largest assets on most companies’ balance sheets, and it directly affects how much cash you have available to cover payroll, inventory, and other obligations. If your AR grows faster than your revenue, it signals that customers are paying more slowly, which can create a cash crunch even when your income statement looks healthy. A reliable AR forecast lets you anticipate shortfalls weeks or months in advance, plan your borrowing needs, and set realistic expectations with investors or lenders.
Calculate Your Days Sales Outstanding
The foundation of any AR forecast is your DSO. The formula is:
DSO = (Accounts Receivable / Net Credit Sales) x Number of Days in the Period
If your AR balance is $150,000 at the end of a quarter and your credit sales for that quarter were $450,000, your DSO is ($150,000 / $450,000) x 90 = 30 days. That means, on average, you collect payment about 30 days after invoicing.
A DSO of 45 days or below is generally considered healthy, though this varies by industry. A wholesale distributor with net-30 terms will naturally run a lower DSO than a construction firm billing on 60-day contracts. What matters more than the absolute number is whether your DSO is stable, trending upward, or trending downward over the past several quarters.
Pull at least two years of quarterly data if you can. If DSO has been drifting higher, simply averaging it will understate your future AR. If it has been steady with only minor fluctuations, using the average is a reasonable shortcut.
Build Your Sales Forecast
Your AR projection is only as good as the revenue number feeding into it. Start by collecting historical sales data, then adjust for factors that could push future sales higher or lower:
- Seasonality: If your business peaks in Q4 and dips in Q1, your forecast should reflect that pattern rather than spreading revenue evenly across the year.
- Growth rate: Look at year-over-year revenue growth and decide whether the recent trend is sustainable. A company growing at 20% annually needs a different assumption than one on a flat trajectory.
- Pricing changes: A price increase you plan to implement in six months will inflate your credit sales figure even if volume stays flat.
- Customer churn: Losing a major account or adding a large new customer shifts the forecast significantly. Factor in any known contract changes.
- Market conditions: Supply chain disruptions, rising input costs, or a softening economy can slow orders and extend payment timelines simultaneously.
For a simple model, multiplying last year’s monthly sales by your expected growth rate works. For a more nuanced approach, build month-by-month estimates that incorporate seasonal patterns and known deals in your pipeline.
Apply the AR Forecast Formula
With your DSO and sales forecast in hand, the core calculation is:
Forecasted AR = DSO x (Forecasted Sales / Number of Days in the Period)
Suppose you expect $600,000 in credit sales next quarter (90 days) and your trailing DSO is 35 days. Your projected AR balance at the end of that quarter would be 35 x ($600,000 / 90) = $233,333. That means you’d have roughly $233,000 in outstanding invoices sitting on your balance sheet at quarter’s end.
If you’re building a monthly forecast, swap in 30 days as your period. For an annual model, use 365. The logic is the same: DSO tells you what fraction of a period’s sales remain uncollected, and you apply that fraction to the future period’s expected revenue.
Choosing the Right DSO Assumption
This is where judgment matters. You have a few options:
- Trailing average DSO: Average the last four to eight quarters. Best when DSO has been relatively stable.
- Trend-adjusted DSO: If DSO has been climbing by roughly two days per quarter, extend that trend forward. This produces a more conservative (higher AR) forecast.
- Target DSO: If you’re implementing new collection policies or tightening credit terms, you might use a lower DSO that reflects where you expect performance to land. Just be honest about whether those changes are likely to stick.
Adjust for Bad Debt
Not every dollar of AR will actually turn into cash. Some invoices go unpaid because customers go out of business, dispute charges, or simply refuse to pay. Your forecast should account for this by building in an allowance for doubtful accounts.
The simplest approach is the percentage-of-sales method. If your historical write-off rate has been around 2% of credit sales, multiply your forecasted sales by 0.02 to estimate bad debt expense. Subtract that from your gross AR forecast to arrive at a net realizable value, which is the amount you actually expect to collect.
A more granular approach is the aging method. This groups your outstanding invoices by how overdue they are (current, 1 to 30 days past due, 31 to 60 days, 61 to 90 days, and 90-plus days) and applies a progressively higher uncollectibility rate to each bucket. Invoices that are current might have a 1% default rate, while invoices over 90 days past due might default at 40% or more. If your aging profile is shifting, with more invoices landing in older buckets, this method catches deteriorating credit quality that a flat percentage would miss.
A Practical Example
Say you run a B2B services company. Here is how you might forecast AR for the next quarter:
- Step 1: You pull your last eight quarters of data and find your average DSO is 42 days, with no strong upward or downward trend.
- Step 2: Based on your pipeline and seasonal patterns, you forecast $900,000 in credit sales for the upcoming quarter (90 days).
- Step 3: You apply the formula: 42 x ($900,000 / 90) = $420,000 in gross accounts receivable.
- Step 4: Your historical bad debt rate is 1.5%, so you set aside $13,500 as an allowance for doubtful accounts, leaving a net realizable value of $406,500.
That $406,500 is what you’d plug into your balance sheet forecast, and the difference between your beginning AR balance and this ending AR figure feeds directly into your cash flow projection.
Refine the Forecast Over Time
The first version of any AR forecast is a rough estimate. It gets better as you track actual results against your projections and adjust. Each quarter, compare your predicted AR balance to the actual number. If you’re consistently overestimating collections (meaning AR ends up higher than forecast), your DSO assumption is probably too optimistic. If you’re underestimating, your customers may be paying faster than your historical data suggested.
Pay attention to customer concentration. If one client accounts for 30% of your revenue and their payment behavior changes, it can throw off an entire forecast built on company-wide averages. For businesses with a handful of dominant accounts, forecasting AR by customer segment rather than as a single pool produces more accurate results.
Using Software to Automate Forecasts
Spreadsheets work fine for smaller businesses with predictable payment patterns. But as transaction volume grows, manual forecasting becomes time-consuming and error-prone. Modern AR platforms from companies like Serrala and BlackLine use machine learning to predict when individual invoices will be paid, flag at-risk accounts before they become overdue, and automatically update forecasts as new data flows in.
These tools analyze patterns across thousands of invoices to score the likelihood of on-time payment for each one, which is far more precise than applying a single DSO figure to all customers. If your business processes hundreds of invoices per month or deals with customers whose payment behavior varies widely, automated predictive analytics can meaningfully improve forecast accuracy and free your finance team to focus on collections rather than calculations.