What is DSO, and how do you calculate it in QuickBooks?

Days sales outstanding (DSO) is the average number of days it takes your business to collect payment after issuing an invoice. The formula is: DSO = (accounts receivable ÷ credit sales for the period) × number of days in the period. If you had $120,000 in open receivables at the end of a 30-day month in which you invoiced $150,000, your DSO is (120,000 ÷ 150,000) × 30 = 24 days. QuickBooks Online does not have a DSO report, but you can calculate it from two reports it does have: the A/R Aging Summary and the Profit and Loss.

This piece covers what DSO tells you, what it hides, how to pull the inputs from QuickBooks in about five minutes, and what a good number looks like for a B2B service business.

What does DSO actually tell you?

DSO tells you how your payment terms are working in practice, as opposed to on paper. If your invoices say net 30 and your DSO is 31, your clients pay on time. If your DSO is 52, your effective terms are net 52, whatever the invoice says, and you are financing three weeks of your clients' operations for free.

It is also the fastest way to put a dollar figure on slow collections. Every day of DSO is roughly one day of revenue tied up in receivables. A business invoicing $3M a year has about $8,200 of revenue per day; cutting DSO from 52 to 40 frees about $98,000 of cash without selling anything new.

How do you calculate DSO?

The standard formula:

DSO = (Accounts receivable ÷ Credit sales in the period) × Days in the period

• Accounts receivable is your total open (unpaid) invoice balance at the end of the period. Use the ending balance, not an average, unless your AR swings a lot month to month.
• Credit sales is everything you invoiced on terms during the period. Exclude cash sales and anything paid at the time of service; those never sit in AR.
• Days in the period is 30 or 31 for a month, 90 or 91 for a quarter, 365 for a year. Pick a period and stay consistent.

A worked example

A staffing agency closes March with $410,000 in open invoices. During March it invoiced $530,000, all on terms.

DSO = (410,000 ÷ 530,000) × 31 = 24 days. That is a healthy number for net-30 terms; most clients are paying a little early. Now the same agency in August: $610,000 open, $520,000 invoiced. DSO = (610,000 ÷ 520,000) × 31 = 36 days. Nothing dramatic happened, but the agency is now carrying an extra $200,000 of its clients' money and is six days past its own terms.

Monthly or trailing?

A single month's DSO is noisy: one big invoice on the 30th inflates AR without giving it time to be paid. For a business with lumpy invoicing, use a trailing three-month calculation: AR at the end of the quarter, divided by the quarter's credit sales, times 91. For tracking trends, monthly is fine as long as you compare like to like.

How do you calculate DSO in QuickBooks Online?

QuickBooks Online does not report DSO directly. It gives you both inputs, though, and the math is one division. Here is the five-minute version.

1. 1Pull your ending AR balance. Reports, then A/R Aging Summary. Set the report date to the last day of the period. The Total column at the bottom is your accounts receivable. (The Balance Sheet on the same date gives the same number under Accounts Receivable.)
2. 2Pull your credit sales for the period. Reports, then Profit and Loss, set to the period, on accrual basis. Total Income is your starting point. If you have meaningful cash sales (paid at time of service, never invoiced), subtract them; the Sales by Customer Detail report filtered by transaction type helps if you need the split.
3. 3Divide and multiply. AR ÷ credit sales × days in period. Write it down with the date.
4. 4Repeat monthly. One DSO number tells you where you are. Six of them tell you which direction you are going, which is the part that matters.

Two things to watch. First, run the P&L on accrual, not cash; on cash basis, income only appears when you are paid, which makes the denominator meaningless for this purpose. Second, if you use QuickBooks for both invoiced work and retail-style sales receipts, be deliberate about excluding the sales receipts, or your DSO will look better than it is.

What is a good DSO?

A good DSO is close to your stated terms. For a B2B service business on net 30, a DSO in the high 20s to high 30s is normal and healthy. In the 40s, a meaningful share of clients are paying late and it is worth looking at who. Above 60 on net-30 terms, your terms are not really your terms; the market has renegotiated them for you, and you should either change the terms to match reality or change the follow-up so reality matches the terms.

Industry matters. Staffing, freight, and government contracting routinely run higher because their clients' AP cycles are long. Agencies and IT services on retainer can run in the 20s. Compare yourself to your own trend first, and to your industry second.

What does DSO hide?

DSO is an average, and averages hide the problem you actually need to fix.

• It blends good payers with bad ones. Ten clients at 25 days and two at 110 gives you a DSO in the high 30s and no indication that two accounts are carrying the entire delay. Look at DSO by client, or at the aging report, to find them.
• It moves when sales move. A big invoicing month drops DSO even if nothing was collected faster; a slow month raises it. Track collection speed (days from invoice to payment, on paid invoices) alongside DSO to separate the two.
• It says nothing about disputes. An invoice that has been disputed for 90 days looks the same as one that was simply forgotten. Different problems, different fixes.

How do you bring DSO down?

Almost entirely through follow-up consistency. The clients who pay you late are usually not choosing to; your invoice is in a queue with everyone else's, and the vendor who follows up on a schedule gets paid ahead of the one who does not. A fixed sequence starting the day after the due date, escalating over 60 days, and stopping the moment payment lands is the single biggest lever most businesses have. We wrote the sequence up in detail, with templates, linked below.

If you would rather not run that by hand, Reeve does it for you: it connects to QuickBooks Online, follows up on every open invoice in your name, and reports DSO, aging by client, days late, and collection speed every week, reconciled to the dollar. The math above is how you check its work.