Accounts Receivable: Modeling Customer Payment Timing

Understanding Accounts Receivable

Accounts receivable (A/R) is money your customers owe you. When you sell a product or service on credit, you record revenue on the income statement but don't receive cash immediately. Instead, you create an accounts receivable on the balance sheet. A/R is an asset because it represents a legitimate claim on customer cash. However, it's not cash yet, which is why cash flow can suffer even if revenue looks strong. Understanding the timing of A/R collection is essential for cash flow planning. If customers pay quickly (net-15), your cash flow is healthy. If customers take months to pay, you're effectively financing their operations with your working capital.

Days Sales Outstanding (DSO): Measuring Collection Efficiency

Days sales outstanding (DSO) measures how many days, on average, it takes to collect payment from customers. The formula is: (Accounts Receivable / Revenue) × Number of Days. For example, if A/R is $150,000 and monthly revenue is $100,000, DSO = ($150,000 / $100,000) × 30 = 45 days. This means you're waiting, on average, 45 days to collect from customers. If your stated terms are net-30, a DSO of 45 days suggests customers are paying about 15 days late. Tracking DSO monthly is critical. If DSO is increasing month-over-month (e.g., from 35 days to 50 days), your collections are slipping. This could indicate: customers are struggling financially, your collections process is weak, or you're attracting lower-quality customers. Each scenario requires investigation and action.

Collection Timing and Customer Types

Collection timing varies dramatically by customer type. E-commerce customers (direct consumers) often pay immediately via credit card—DSO is nearly zero. Enterprise customers typically pay on net-30, net-45, or net-60 terms (sometimes longer), creating significant A/R. SaaS companies with monthly subscriptions see payment timing similar to their billing cycle: monthly billing, then collection. Startup-to-startup B2B transactions often have unfavorable collection timing: the selling startup offers net-60 or net-90 to win business, extending DSO significantly. When forecasting A/R, segment by customer type and use realistic payment terms for each segment. A portfolio of enterprise customers naturally has higher A/R than a consumer-focused business.

Modeling A/R in Financial Forecasts

To model A/R, calculate your expected DSO based on customer mix and stated terms, then apply it to projected revenue. For example, if you expect monthly revenue of $100,000 and DSO of 45 days, your A/R will be approximately $150,000 (45 days ÷ 30 days × $100,000). As revenue grows, A/R grows proportionally (assuming DSO remains constant). However, DSO often improves as you grow: larger companies have more sophisticated collections processes, and some customers offer discounts for early payment (which you might accept). Conversely, DSO can deteriorate if your customer mix shifts toward slower-paying enterprise customers. Update your DSO assumption quarterly based on actual results and adjust your cash flow forecasts accordingly. A 10-day increase in DSO across a $1 million monthly revenue base ties up an additional $333,000 in working capital.

Bad Debt and Allowances for Doubtful Accounts

Not all receivables are collected. Some customers default. You should estimate your expected bad debt rate (based on historical data or industry benchmarks) and record an allowance for doubtful accounts on the balance sheet. This is a contra-asset (reduces A/R) that reduces the net amount you expect to actually collect. For example, if A/R is $200,000 but you estimate 5% bad debt, you record an allowance of $10,000, resulting in net A/R of $190,000 on the balance sheet. On the income statement, the bad debt provision (estimated losses) is recorded as a non-operating expense. As actual bad debts occur (a customer never pays), you write off the receivable against the allowance. For early-stage startups, bad debt rates vary widely: direct consumer businesses might have near-zero bad debt (credit card transactions are guaranteed), while B2B startups might face 2-10% bad debt depending on customer creditworthiness.

The Collection Process and Aging Analysis

To manage A/R effectively, maintain an aging analysis showing receivables broken into buckets: current (not yet due), 30+ days past due, 60+ days past due, and 90+ days past due. This analysis reveals which customers are paying on time and which are delinquent. Undoubtedly, invoices 90+ days past due are red flags—they're high-risk bad debts and should be pursued aggressively. A typical collection process is: invoice, reminder at 15 days if unpaid, follow-up at 30 days, escalation to management at 45 days, and collections or small claims action at 60+ days. Many startups are too nice with collections, continuing to do business with customers who pay late or don't pay at all. Set clear collection expectations upfront, enforce them consistently, and don't hesitate to escalate or stop serving customers who chronically fail to pay.

Early Payment Incentives and Discounts

Some companies offer discounts for early payment (e.g., 2% off if paid within 10 days instead of 30). From the customer's perspective, this is attractive. From your perspective, the cost of accelerating payment is the discount you offer. If you're paying 2% to accelerate cash by 20 days, that's expensive. However, if you're desperate for cash or forecasting a cash crunch, early payment discounts can be justified. Additionally, some customers demand early payment discounts as a matter of course (they negotiate aggressively). Consider your cash position: if you're well-capitalized, don't offer discounts; if you're cash-constrained, the discount might be worth the accelerated cash flow.

Working Capital Financing and A/R Factoring

If A/R is growing faster than you can fund it, consider A/R factoring. In factoring, a third party purchases your receivables at a discount (e.g., you sell $100,000 A/R for $95,000 immediately). This immediately converts A/R to cash, though at a cost. Factoring costs typically run 2-5% of receivables, depending on customer creditworthiness and how quickly you factor. It's expensive but useful for startups facing working capital constraints. Additionally, some venture lenders offer A/R-based lines of credit: they lend a percentage (typically 70-80%) of A/R. This provides liquidity without selling the receivables outright. If A/R growth is outpacing your ability to self-fund it, explore these options before they become critical.

Payment Terms and Customer Segmentation

Different customer segments warrant different payment terms. Large enterprise customers expect net-60 or net-90 terms. Smaller businesses or individuals might require upfront payment or credit card billing. Your financial model should reflect these differences: calculate Days Sales Outstanding (DSO) separately for each customer segment. You might discover that enterprise customers have 15% lower profit margins due to longer payment terms, even if the gross profit is higher.

This insight informs product strategy and pricing. Some founders deliberately focus on customer segments with favorable payment characteristics (upfront payment, short collection cycles) to improve working capital and reduce financing needs.

Customer Creditworthiness and Default Risk

As you extend credit, assess customer creditworthiness carefully. Tools like credit scoring, background checks, and references help. For B2B sales to large, established companies, the risk is low; they will not default because it would damage their credit rating. For small businesses or international customers, the risk is higher.

Some founders require personal guarantees from small business owners, collateral for larger deals, or letters of credit for international sales. Insurance products like receivables insurance or export credit insurance can transfer default risk. The cost of these protections must be weighed against the risk. Sometimes the prudent approach is declining business that does not meet your credit standards.

Revenue Quality and Cash Realization

Not all revenue is created equal. Revenue from long-term contracts with established customers is high quality. Revenue from one-time transactions with new, uncertain customers is lower quality. Evaluate revenue quality by analyzing customer retention, contract renewal rates, and customer concentration. If 50% of your revenue comes from one customer, your revenue quality is lower than if your revenue is diversified.

Also evaluate cash realization—what percentage of revenue becomes actual cash? If you recognize $100,000 in revenue but collect only $70,000 due to discounts or returns, your cash realization is 70%. This metric matters for forecasting cash flow. Many SaaS companies have high revenue quality (low churn, high retention) and high cash realization (upfront subscription payments), making them attractive to investors.

Key Takeaways

• Accounts receivable is money customers owe; it's an asset but not yet cash
• Days sales outstanding (DSO) measures collection efficiency; track it monthly and investigate if it increases
• Collection timing varies by customer type: consumers pay instantly, enterprises pay 30-90 days later
• Record a bad debt allowance equal to your expected non-collection rate
• Aging analysis reveals delinquent accounts and helps prioritize collection efforts
• Manage A/R aggressively: set clear payment terms, follow up consistently, and don't hesitate to escalate

Automation and Efficiency in Collections

As your business grows, manual collection efforts don't scale. Implement accounting software with automated reminders for overdue invoices. Systems like QuickBooks, Stripe, or NetSuite can automatically send payment reminders on your behalf. Many SaaS companies implement automated dunning management—systematic retry logic for failed payment attempts—which recovers significant revenue that would otherwise be lost.

For B2B businesses, consider integrating with your customers' payment systems. Electronic Data Interchange (EDI) and automated clearing house (ACH) payments reduce friction and accelerate collection. Some customers expect to be invoiced and paid through EDI; accommodating these expectations strengthens relationships and improves payment timing. The investment in collections infrastructure pays off through reduced DSO and improved cash flow.

Frequently Asked Questions

What's a healthy DSO for a startup?

It depends on your business model and customer type. Consumer-facing businesses with credit card payment have near-zero DSO. B2B SaaS with monthly billing might have 30-45 day DSO. Enterprise B2B with net-60 or net-90 terms might have 60-90+ day DSO. The key is consistency and improvement: if DSO is stable and matches your stated terms, you're managing collections well. If DSO is increasing, investigate why.

Should I always extend payment terms to win customers?

No. Extending payment terms from net-30 to net-60 to win a customer increases your working capital needs significantly. Calculate the cost: if you're desperate for revenue and extending terms is the only way to close the deal, it might be worth it temporarily. However, don't make it a habit. Once you establish a market position, push back on payment term demands and hold firm.

How should I handle customers who pay late?

Address it directly and immediately. Contact the customer, understand the issue (is it a dispute, processing delay, financial hardship?), and establish a resolution. If it's habitual lateness, consider refusing to do additional business until they catch up. If it's a large customer and the relationship is valuable, you might offer extended terms explicitly rather than continuing to tolerate late payment.

Is A/R factoring a good option for startups?

A/R factoring is useful if you're facing a working capital crunch and don't have alternative financing. However, it's expensive (2-5% of receivables), so use it sparingly. A better long-term approach is to negotiate terms with customers upfront, offer discounts for early payment if you're cash-constrained, or raise capital to fund working capital growth.