The same filing produces three receivables turnover ratios

Four point four. Five point two. Four point one.

All three are accounts receivable turnover ratios for Microsoft in fiscal 2026. All use the same $331.839bn revenue numerator. The first divides it by the average of opening and closing current receivables. The second averages five quarter-end current balances. The third adds long-term receivables to the opening and closing current balances.

The formula did not change. The disclosed input did.

That is the problem hidden inside a ratio usually presented to two decimal places. The conventional numerator is net credit sales, a subtotal that public companies rarely report. The conventional denominator is average accounts receivable, yet a filing may offer current and long-term balances, customer and vendor balances, card-settlement amounts, rebates, contract assets and an allowance that can be added back or left net.

The result can still be useful. It is not automatically comparable, and it is rarely exact. A filing-based calculation needs a definition before it deserves a decimal.

What is the accounts receivable turnover ratio?

Accounts receivable turnover divides credit sales for a period by average trade receivables. The result estimates how many times the receivable balance turned over. A companion days figure divides the period's days by that result. Public filings usually supply close substitutes for both inputs, not the exact pair.

The conventional expression is compact:

Accounts receivable turnover = net credit sales / average accounts receivable

The usual two-point denominator is equally compact:

Average accounts receivable = (opening receivables + closing receivables) / 2

Neither line is a required GAAP statement. The SEC's Regulation S-X balance-sheet rule requires receivable categories and a separately presented allowance. Its income-statement rule requires categories of sales and revenue. The rules do not require a turnover ratio, a days-sales-outstanding figure or a subtotal called net credit sales.

That absence matters more than the arithmetic. Net sales means gross sales less discounts, returns and allowances under Rule 5-03. It does not mean sales made on credit. A cash sale can be inside net sales. A service contract invoiced before performance can put a receivable on the balance sheet before all of its revenue appears. Revenue recognized before billing can create a contract asset instead of a trade receivable.

Dividing 365 by turnover produces a familiar collection-days proxy. It does not convert an imprecise input into a measured collection period. The day count is another choice: Home Depot's fiscal 2025 covered 52 weeks, while the common shortcut still uses 365.

Why does a public filing rarely contain the exact numerator?

Regulation S-X asks companies to separate product sales, service revenue and other revenue when the categories are material. It does not ask them to divide those amounts between immediate payment and customer credit. Total revenue, net sales and product revenue are therefore proxies for net credit sales, with different errors.

Walmart shows the first fork. Its fiscal 2026 annual report reports $706.413bn of net sales, $6.750bn of membership and other income, and $713.163bn of total revenue. Using total revenue instead of net sales raises a customer-receivable turnover estimate from 151.92 to 153.37. That is a 1.0 percent change before confronting the larger issue: the filing does not say how much of the $706.413bn was sold on credit extended by Walmart.

Payment by a consumer's credit card does not settle that question. The retailer can receive cash from a card network while the consumer owes the issuing bank. Home Depot's filing treats amounts awaiting settlement from financial institutions as card receivables, a separate category from credit extended directly to customers. Both arose from sales. They describe different credit relationships.

The numerator problem is smaller for some business-to-business companies, but it does not disappear. Grainger's 2025 annual report says its accounts receivable arise primarily from sales on credit to customers. That wording makes $17.942bn of net sales a closer proxy than a retailer's sales total. “Primarily” still does not mean every sale.

An analyst therefore has three honest choices. Obtain net credit sales from company disclosure, state that total or net sales is being used as a proxy, or decline to calculate. Calling the proxy an exact ratio is a fourth choice, but it is not an honest one.

Which receivables belong in the denominator?

The denominator should match the credit sales in the numerator. Trade balances from customers belong. Vendor rebates, income-tax refunds and real-estate receivables do not arise from those sales. Card-settlement receivables and long-term billed amounts require an explicit scope decision. The balance-sheet caption alone may combine all of them.

Rule 5-02 identifies the categories. It calls for amounts due from trade customers, related parties, certain employees and promoters, and others to be stated separately, subject to the rule's presentation provisions. It also requires the allowance for doubtful accounts and notes receivable to be set out separately in the balance sheet or notes.

Home Depot supplies the useful example because its 2025 filing dissects the $5.597bn receivables line. At the fiscal year end it contained $1.021bn due from financial institutions for card settlement, $1.421bn of vendor rebates, $2.588bn of credit extended directly to customers, and $567m of other receivables. The prior-year figures were $1.019bn, $1.404bn, $1.896bn and $584m.

Using all receivables produces an average denominator of $5.250bn. Dividing $164.683bn of net sales by it gives 31.37 turns, or 11.6 days using the 365-day shortcut. Using only customer receivables produces a $2.242bn average and 73.45 turns, or 5.0 days.

That gap is not rounding. It is a 134 percent increase in the ratio caused by removing three categories from the denominator. The customer-only version better matches directly extended customer credit. It still uses all net sales in the numerator, including transactions paid without that credit.

The broad version answers a different question: how large is sales relative to the whole receivables caption? It does not isolate collection of customer accounts. Both calculations can be reproduced from the filing. Only the label tells the reader which one was performed.

What do Walmart's two receivable totals reveal?

Walmart reports $11.172bn of consolidated net receivables for January 2026, then identifies $4.9bn due from transactions with customers. The broader figure also includes supplier, government and real-estate amounts. Net sales divided by those two-point averages produces 66.81 turns on the broad balance and 151.92 on the customer balance.

The prior-year comparison is $9.975bn of consolidated receivables and $4.4bn of customer receivables. That makes the two-point averages $10.5735bn and $4.650bn. One published note therefore supports estimates separated by 85.11 turns.

The smaller number is not a pure trade-receivable balance in the textbook sense. Walmart says the customer category includes pharmacy insurance companies, advertisers, and banks for card, debit-card and electronic-transfer transactions that take more than seven days to process. It joins direct commercial claims with settlement balances from payment channels.

The broader number is less suitable. It adds supplier marketing and incentive programs, amounts due from governments for income taxes, and real-estate transactions. None has a matching place in the $706.413bn net-sales numerator.

This is also an XBRL warning. The SEC's Companyfacts API makes standardized facts downloadable, and Walmart's customer receivable figure is available under the standard accounts-receivable tag. The consolidated balance sheet carries the larger “Receivables, net” caption. An automated ratio can select either number without making the accounting judgment visible.

The data format is doing its job. It provides the filed fact and its context. The mistake comes later, when a calculation assumes that a standardized tag and a broad balance-sheet caption are interchangeable.

How much does the averaging method change the ratio?

A two-point average sees only the first and last day. A five-point average also sees the three quarter ends. When receivables are seasonal or billing clusters at year end, the extra observations can move the denominator sharply. Microsoft, Home Depot and Grainger show effects ranging from 3.5 percent to 17.7 percent.

The figures below are calculations from each company's annual report and quarter-end facts in the SEC's official Companyfacts files. “Days” means 365 divided by the displayed ratio. It is a conversion of the estimate, not a separately reported company measure.

Company and method	Revenue proxy	Average receivables	Turnover	Days proxy
Microsoft, current receivables, two points	$331.839bn	$75.391bn	4.40	82.9
Microsoft, current receivables, five points	$331.839bn	$64.050bn	5.18	70.5
Microsoft, current plus long-term, two points	$331.839bn	$80.741bn	4.11	88.8
Home Depot, all receivables, two points	$164.683bn	$5.250bn	31.37	11.6
Home Depot, all receivables, five points	$164.683bn	$5.806bn	28.37	12.9
Grainger, net receivables, two points	$17.942bn	$2.281bn	7.87	46.4
Grainger, net receivables, five points	$17.942bn	$2.362bn	7.60	48.1

Microsoft's 2026 filing reports current net receivables of $69.905bn at the start of the year and $80.876bn at the end. The three intervening quarter ends were $52.894bn, $56.535bn and $60.041bn. The two-point average is $75.3905bn because it gives half the weight to the unusually high closing balance. The five-point average is $64.0502bn.

That difference moves turnover from 4.40 to 5.18, a rise of 17.7 percent. The days proxy falls by 12.5 days. No sale or collection changed. The observation schedule did.

Home Depot moves the other way. Its opening, quarterly and closing total receivable balances were $4.903bn, $5.886bn, $5.878bn, $6.765bn and $5.597bn. The five-point average exceeds the endpoint average, so turnover falls from 31.37 to 28.37. Grainger's result falls from 7.87 to 7.60.

A five-point average is not automatically true. Quarter ends can also be unrepresentative, and an unweighted average does not account for the slightly different number of days between reporting dates. It is more informative because it exposes whether two endpoints were carrying the result.

Do current, long-term, gross and net receivables change the answer?

Yes, although the size depends on the filing. Adding Microsoft's disclosed long-term receivables lowers its two-point ratio from 4.40 to 4.11. Adding back Grainger's allowance lowers 7.87 to 7.76. Current versus long-term scope matters more in the first case than net versus gross presentation in the second.

Microsoft reported $5.5bn of long-term net accounts receivable at June 2026 and $5.2bn a year earlier. Those balances sit inside other long-term assets, outside the current accounts-receivable caption. Adding them creates an average total net receivable balance of $80.7405bn and a ratio of 4.11, with an 88.8-day proxy.

Excluding them can be defensible if the question is current working-capital velocity. Including them can be defensible if the question is turnover of all billed customer amounts. The filing says its invoicing practices include subscriptions billed at the beginning of a term and multi-year on-premises licenses invoiced annually with revenue recognized up front. Current classification and revenue timing are part of the business model, not clerical details.

Net versus gross asks a different question. Grainger reports $32m allowances at both the 2025 and 2024 year ends. Its net two-point average is $2.2805bn and produces 7.87 turns. Adding the allowances back gives a $2.3125bn gross average and 7.76 turns, a difference of 1.4 percent.

Microsoft's current allowance was $1.040bn at June 2026 and $944m a year earlier. The balance sheet presents receivables net of those amounts. A collection-efficiency measure often uses net receivables because that is the asset expected to be collected. A billing measure may prefer gross contractual claims. Neither choice repairs the missing credit-sales numerator.

Can accounts receivable turnover ratios be compared across companies?

Only after the definitions and businesses are aligned. A retailer's card settlements, a software company's annual invoices and an industrial distributor's trade credit do not represent the same collection process. A larger ratio can reflect immediate payment channels, a narrower denominator or a revenue proxy, rather than better credit control.

Walmart's 151.92 customer-receivable estimate and Grainger's 7.87 net-receivable estimate look comparable because both divide sales by customer-related balances. They are not. Walmart's customer category includes bank settlement, pharmacy-insurance and advertising amounts. Grainger says its balance arises primarily from credit sales to customers. Walmart does not disclose the sales made on Walmart-extended credit that would match its customer balance.

Home Depot makes the distinction visible within one company. Card receivables are claims on financial institutions for transactions already made by shoppers. Customer receivables are credit extended directly to certain customers. A ratio that combines them measures the speed of two different payment systems.

Industry comparison can still help when a consistent data vendor applies a declared method to similar companies. The method needs to survive contact with the notes. If one company reports contract assets inside the selected balance and another reports them separately, a standardized calculation can manufacture a difference that belongs to presentation.

Trend comparison within one company is usually stronger. Even there, acquisitions, changed payment terms, receivable sales, new card arrangements and a shift between annual and monthly billing can break continuity. Home Depot's customer receivables rose from $1.896bn to $2.588bn in a year that included acquired businesses. The change is real. A conclusion about collection speed requires more than the ratio.

How should a filing-based turnover ratio be labeled?

State the numerator, the receivable scope, whether balances are gross or net, and how many dates enter the average. Call sales a proxy when credit sales are unavailable. Give the fiscal period. Present no more precision than the inputs support. A reader should be able to reproduce the result from linked filings.

A complete label can fit in one sentence: “Fiscal 2026 estimated receivables turnover equals total revenue divided by the average of opening and closing current net trade receivables.” That sentence makes five choices visible. It also makes disagreement productive, because a reader can replace one choice and see what moves.

For automated work, keep the filed context with the value. The SEC's Companyfacts records include the form, accession, filing date, fiscal period, start or end date and XBRL frame. Selecting the latest value by date alone can capture a comparative number repeated in a later filing. Selecting a tag by name alone can miss a custom broader caption. Both errors produce tidy ratios.

Round last. The calculations above retain the reported millions through division and display two decimals only at the end. Two decimals do not imply that Microsoft disclosed 4.40 or that Walmart disclosed 151.92. They show the result of the stated method.

The filing remains the evidence. The ratio is an interpretation of it.

What else should readers know about receivables turnover?

The ratio is a compact estimate, not a verdict on collections. Higher can mean faster payment, more cash sales, tighter credit or a denominator that excludes relevant balances. Lower can reflect annual billing, longer contractual terms or a broader receivable scope. The filing notes decide which interpretation remains plausible.

Is a higher accounts receivable turnover ratio always better?

No. A higher result can accompany fast collection, but it can also come from fewer credit sales, restrictive terms, sold receivables or a narrow denominator. It needs the company's payment model and credit disclosures beside it.

Is accounts receivable turnover a GAAP measure?

No required financial statement presents it. Regulation S-X requires underlying revenue and receivable disclosures, while the analyst chooses the ratio's inputs. Companies may publish their own collection measures, but those definitions should be read rather than assumed.

Why do calculations often use 365 days?

It is a convention for translating annual turnover into a days proxy. A 52-week retailer can have a 364-day fiscal year, and leap years have 366 days. The selected day count should match the stated method.

Can XBRL calculate the ratio automatically?

XBRL can supply tagged revenue and receivable facts. It cannot decide whether a customer tag includes card settlement, whether long-term balances belong, or whether total sales approximate credit sales. Those are accounting judgments that require the filing context.