Revenue means little if cash stays locked in unpaid invoices.
For ecommerce sellers, slow collections create cash flow gaps that stall inventory purchases, delay vendor payments, and limit growth. The problem compounds when you lack visibility into which customers pay late and how long receivables actually take to convert.
QuickBooks accounts receivable reports track the data you need, but only if you know which metrics matter and how to act on them.
In this guide, you will learn the essential QuickBooks accounts receivable metrics to monitor, how to calculate them, and practical strategies to protect cash flow.
Accurate QuickBooks accounts receivable (AR) tracking is the starting point for healthy ecommerce cash flow. AR represents money owed to your business after you have delivered goods or services.
In QuickBooks, every AR transaction follows a clear workflow:
If customer records are duplicated, invoice dates are incorrect, or payments are not matched to invoices, your AR metrics will be misleading.
Now that you know how QuickBooks accounts receivable works, let us see why tracking these metrics matters for your business’s financial health.
Suggested read: Mastering the Cash Flow Statement for Ecommerce
Tracking AR metrics in QuickBooks is your early warning system for cash flow issues and customer risk. Without clear visibility, late payments and missed follow-ups can quickly lead to cash crunches and operational stress.
Common cash flow problems caused by poor AR tracking include:
For example, a wholesale distributor who ignored their AR aging report for several months found themselves short on payroll when a major customer delayed payment unexpectedly.
By the time the issue was discovered, the overdue balance had grown too large to recover quickly.
Risks of not tracking AR:
To avoid these pitfalls, you need to focus on the right AR metrics. Here are the five that matter most.
Suggested read: Keeping Ecommerce Cash Flow Positive
Tracking these five AR metrics gives you a clear, actionable picture of your receivables health in QuickBooks. Each metric reveals a different aspect of your collection process and cash flow.
Measures the average number of days it takes to collect payment after a sale. A lower DSO means faster cash conversion.
For most B2B companies, a DSO under 45 days is considered healthy.
Shows how many times you collect your average AR balance during a period. Higher turnover indicates more efficient collections.
A ratio above 8 is strong for most industries.
Suggested read: Fixing QuickBooks Accrual Accounting Errors: A Practical Guide
Calculates the average time it takes to collect receivables, using a different formula than DSO but providing similar insight. Most businesses aim for a period that matches or beats their payment terms.
Segments outstanding invoices by age (current, 30, 60, 90+ days). This breakdown highlights where collection risk is concentrated.
Shows what proportion of your invoices are past due. If more than 10-15% are overdue, it signals a need to review your collection process.
Knowing what to track is only the first step. Next, let us see how to calculate these metrics in QuickBooks.
Suggested read: Common Ecommerce Accounting Mistakes
With the right QuickBooks reports and a few simple calculations, you can track every key AR metric, manually or with automation.
Example: If AR is $100,000 and monthly sales are $300,000, DSO = ($100,000 ÷ $300,000) × 30 = 10 days
Example: $300,000 ÷ $100,000 = 3 (monthly), or 36 annually
Example: 365 ÷ 8 = 45.6 days
Suggested read: A Guide to Accounting Automation in 2026
Example: 45 overdue out of 150 total = 30% overdue
For businesses managing high invoice volumes or multiple channels, automated AR metric tracking tools like Webgility can sync QuickBooks data in real time. It also calculates these metrics automatically, reducing manual work and risk of error.
Once you have your AR metrics, the next step is understanding what those numbers actually mean for your business.
Suggested read: How to Use QuickBooks Aging Reports for AR Management
Now let us look at proven ways to improve your AR performance in QuickBooks.
Optimizing AR in QuickBooks requires a mix of strong process, smart use of features, and, when you scale, automation.
Best practices:
Manual AR tracking breaks down when invoices, payments, and refunds flow from multiple sales channels.
Webgility connects your ecommerce platforms, marketplaces, and POS systems directly to QuickBooks, syncing every transaction in real time.
For QuickBooks accounts receivable workflows, Webgility delivers:
Bases Loaded, a sporting goods retailer selling online and in-store, struggled to keep AR and inventory aligned as order volume grew.
After implementing Webgility, the team eliminated manual order posting entirely. They went from spending an average of four minutes to manually post each order to putting it on autopilot Webgility, freeing staff to focus on customer relationships and growth.
The result: monthly online orders increased by 21x and revenue grew by 1.8x.
Schedule a demo with Webgility today.
Most businesses review AR metrics monthly. If you handle high invoice volumes or sell on multiple channels, automated tools can provide real-time updates for better oversight.
Consolidate all sales and payment data into QuickBooks for a complete AR picture. Automation platforms like Webgility make this seamless and reduce manual work.
Yes. Automation tools can sync data, calculate AR metrics, and provide real-time dashboards, saving hours of manual calculation and reducing errors.
Check for unposted payments, duplicate invoices, or incorrect payment terms. Ensuring data quality in QuickBooks is the foundation of reliable AR metrics.