What is Days Sales Outstanding (DSO)? Tracking Receivables in Analytics
Quick Answer
Days Sales Outstanding (DSO) = (Total Accounts Receivable ÷ Total Credit Sales) × Number of Days. For example: ₹50 lakh outstanding receivables ÷ ₹200 lakh monthly credit sales × 30 days = DSO of 7.5 days. In practice, DSO tells you how many days on average it takes customers to pay — if your credit terms are 30 days and DSO is 45, customers are paying 15 days late on average.
DSO is one of the most important financial metrics for Indian businesses — especially in a credit-heavy economy where 60–90 day payment terms are common and collections efficiency directly impacts cash flow.
DSO Formula
DSO = (Accounts Receivable ÷ Total Credit Sales) × Number of Days
Example (monthly):
- Accounts Receivable outstanding: ₹1.2 Crore
- Monthly credit sales: ₹80 lakhs
- DSO = (₹1.2Cr ÷ ₹80L) × 30 = 45 days
This means on average, customers take 45 days to pay after invoice date.
Simple trailing DSO formula (commonly used):
DSO = Accounts Receivable ÷ (Annual Revenue ÷ 365)
Interpreting DSO
DSO equals credit terms: Customers are paying on time on average. (DSO = 30 days on 30-day terms = acceptable)
DSO exceeds credit terms: Customers are paying late on average. (DSO = 45 days on 30-day terms = 15 days late on average — common in India)
DSO significantly exceeds credit terms: Collections process needs attention. Risk of bad debt increasing.
DSO declining: Collections improving — less working capital tied up in receivables.
DSO rising: Collections deteriorating — more working capital required, higher bad debt risk.
Indian Business Context for DSO
Normal DSO ranges for India:
- Manufacturing to distributors: 30–60 days typical
- B2B services: 30–45 days
- Government-linked projects: 90–180 days (notoriously slow-paying)
- FMCG to modern trade: 45–90 days
Indian businesses typically run higher DSO than equivalent Western businesses due to: cultural acceptance of late payment, weaker enforcement of credit terms, and large customers using their size to extend payables at suppliers' expense.
Building a DSO Dashboard
Core DSO Metrics
- Company-level DSO (current month vs prior 3-month average)
- DSO trend over 12 months
- DSO by customer segment (large vs mid vs small customer)
- DSO by region/territory (some regions collect slower than others)
Receivables Aging Analysis
Most finance teams care as much about aging as overall DSO:
| Aging Bucket | Amount (₹) | % of Total |
|---|---|---|
| 0–30 days | ₹35L | 35% |
| 31–60 days | ₹28L | 28% |
| 61–90 days | ₹22L | 22% |
| 91–120 days | ₹10L | 10% |
| >120 days | ₹5L | 5% |
The 61–90 day and >90-day buckets are where collections need urgent attention.
Customer-Level DSO
Which customers consistently pay late? The top 10 late payers by value should be visible in the dashboard — enabling targeted collections conversations.
Connecting DSO to Tally
Tally's outstanding receivables report contains all the data needed for DSO calculation:
- Outstanding balance by customer (outstanding debtors report)
- Invoice dates (for aging calculation)
- Credit sale values (from sales invoices)
A BI tool with native Tally integration calculates DSO automatically from these reports, refreshing daily as Tally is updated.
See how to build financial dashboards for the full finance dashboard implementation guide.
Explore FireAI Workflows
Jump from the concept on this page into the product features and solution paths most relevant to it.
Tally Analytics
Everything about analytics for Tally Prime and Tally ERP, including dashboards, reporting, GST, and finance workflows.
Ready to Transform Your Business Data?
Experience the power of AI-powered business intelligence. Ask questions, get insights, make better decisions.
Frequently Asked Questions
A good DSO for Indian B2B businesses is close to or equal to your stated credit terms. If your credit terms are 30 days and DSO is 30–35 days, collections are performing well. If DSO is 50–60 days on 30-day terms, there's significant room for improvement. DSO above 90 days on 30-day terms signals a serious collections challenge. Compare your DSO to your own credit terms rather than industry averages, as terms vary widely.
Rising DSO directly reduces available cash. If you sell ₹1Cr/month and DSO rises from 30 to 45 days, you need an additional ₹50 lakhs in working capital to fund the same business volume. This either requires additional borrowing (increased interest cost) or reduces cash available for operations, inventory buying, or growth. For businesses with thin margins, a 15-day DSO increase can create meaningful cash pressure.
Proven DSO reduction strategies for Indian businesses: (1) regular collections calls — a dedicated collections call at 5 days before due date is more effective than chasing after overdue, (2) early payment discounts — offering 0.5–1% discount for payment within 10 days motivates early collection, (3) regular DSO reviews with the sales team (who own the customer relationship), (4) credit limit enforcement — customers who consistently exceed terms get credit holds until they clear, (5) automated invoice delivery and payment reminder emails at invoice date, 15 days, 30 days, and overdue.
Related Questions In This Topic
What is a Financial Dashboard? Metrics, Examples, and How to Build One
A financial dashboard displays key financial metrics — revenue, margin, cash flow, and expenses — in real time on a single screen. Learn what to include in a financial dashboard and how to build one from Tally or your accounting system.
How to Build Financial Dashboards: Metrics, Design, and Best Practices
Learn how to build effective financial dashboards by focusing on key financial metrics, designing CFO-friendly layouts, and implementing real-time financial monitoring. Discover which metrics to track, dashboard design principles, and best practices for financial analytics.
Analytics Tools for CFOs in India: Financial Intelligence for Finance Leaders
CFOs in Indian companies use analytics to improve cash flow visibility, automate financial reporting, identify margin leakage, and support strategic decision-making. Discover which analytics tools work best for Indian CFOs and finance leadership.
Why Finance Teams Should Use Analytics Dashboards: Benefits and Use Cases
Finance teams that use analytics dashboards close their books faster, improve cash flow visibility, catch errors earlier, and spend less time on manual reporting. Learn why dashboards are transforming financial management for Indian businesses.
Related Guides From Our Blog
How AI-Powered Analytics Can Transform India’s Arbitration Bottleneck?
AI-powered analytics can transform India's arbitration system by automating case classification, predicting timelines, and optimizing arbitrator allocation to cut delays.
Not Just What Changed But Why: The New Imperative in Modern Analytics
Fire AI instantly tells you not just what changed in your business, but why it changed turning data overload into confident, cause-driven decisions. No dashboards, no guesswork — just real-time answers in plain English for every leader.
How to Get Instant Insights from Complex Data (In Minutes, Not Days)
Fire AI eliminates days of manual data prep and delivers instant, accurate insights through plain-English questions and real-time processing. It transforms slow, siloed analytics into a competitive advantage helping businesses decide in minutes, not days, and directly drive revenue growth.