Start with the financial series and its reporting period
In TradingView Supercharts, open Indicators, metrics, and strategies, then Financials. Find Cash conversion cycle, Days inventory, Days sales outstanding and Days payable in Statistics. Record the symbol, selected financial period and values together. TradingView lists FQ and FY availability for these ratios; a missing quarterly series is not a zero-day cycle. Its help center also warns that chart financial data can differ from corporate reports.
- Record the fiscal start and end dates from the filing. A December calendar year, a 52-week fiscal year and a 53-week fiscal year have different day counts.
- For a quarterly calculation, use that quarter's sales and costs. If the report gives only six-month or nine-month cumulative flows, subtract the previous cumulative period to isolate the quarter.
- For a trailing-year calculation, sum four compatible quarterly flows and document the balance averaging method. Do not label a manual trailing-year ratio as TradingView's reported quarterly ratio.
- Keep the filing publication date separate from the period end. Today's restated history does not prove that the same figures were available on an earlier trading date.
Write down the formula convention before reconciling
TradingView documents average inventories for DIO, accounts receivable divided by revenue for DSO, and accounts payable divided by COGS for DPO. Its short DSO and DPO definitions do not specify an average. For an independent analysis, the formulas below use average balances throughout. Label that choice rather than assuming it will reproduce the displayed CCC exactly.
| Component | Average-balance analysis | Reconciliation check |
|---|
| DIO | Average inventory / COGS × period days | Use inventories at cost and the corresponding cost of goods sold. |
| DSO | Average trade receivables / net credit sales × period days | Revenue is a disclosed-data proxy when credit sales are unavailable. Cash sales reduce a revenue-based DSO. |
| DPO | Average trade payables / credit purchases × period days | COGS is a proxy for purchases. Do not substitute total current liabilities for trade payables. |
| CCC | DIO + DSO - DPO | Keep full precision until the final result. The answer can be fractional or negative. |
A complete 90-day example with opening and closing balances
This invented merchandise retailer covers January 1 through March 31, 2025, a 90-day quarter. All amounts are USD thousands. Opening balances are at December 31, 2024; closing balances are at March 31, 2025. There are no acquisitions, inventory write-downs, currency changes or manufacturing costs. Revenue is 900, of which 720 is net credit sales. COGS is 600. All inventory purchases are on credit, so purchases = 600 + 140 - 100 = 640. These are teaching inputs, not company results or captured TradingView values.
- DIO = 120 / 600 × 90 = 18.00 days.
- Revenue-based DSO = 90 / 900 × 90 = 9.00 days. Credit-sales DSO = 90 / 720 × 90 = 11.25 days.
- COGS-based DPO = 80 / 600 × 90 = 12.00 days. Purchase-based DPO = 80 / 640 × 90 = 11.25 days.
- Proxy CCC = 18 + 9 - 12 = 15.00 days. Credit-sales/purchases CCC = 18 + 11.25 - 11.25 = 18.00 days.
| Balance | Opening | Closing | Average: (opening + closing) / 2 |
|---|
| Inventory | 100 | 140 | 120 |
| Net trade receivables | 80 | 100 | 90 |
| Trade payables | 60 | 100 | 80 |
Explain a difference instead of forcing the numbers to match
The same quarter can produce different defensible ratios because the inputs answer different questions. Keep a reconciliation sheet with the source line, opening and closing dates, units, denominator and averaging choice. The final row below illustrates what happens if the receivable and payable balances in the published TradingView formulas are interpreted as closing balances; it is not a claim about every provider adjustment.
- The closing-balance row uses DSO = 100 / 900 × 90 and DPO = 100 / 600 × 90. Its two-day difference from the proxy calculation comes from the balance convention.
- Changing only the purchase denominator reduces DPO from 12.00 to 11.25 and increases CCC by 0.75 days. Changing only to credit sales increases DSO and CCC by 2.25 days.
- Multiplying these quarterly ratios by 365 instead of 90 incorrectly turns the 15-day proxy CCC into 60.83 days. Do not annualize the day multiplier without annualizing the flows.
- If matching periods and conventions still leave a difference, inspect restatements, consolidated scope, trade versus other receivables, and supplier-finance classifications. Preserve the unresolved difference.
| Method applied to the example | DIO | DSO | DPO | CCC |
|---|
| Average balances; revenue and COGS | 18.00 | 9.00 | 12.00 | 15.00 days |
| Average balances; credit sales and purchases | 18.00 | 11.25 | 11.25 | 18.00 days |
| Average inventory; closing AR/AP; revenue and COGS | 18.00 | 10.00 | 15.00 | 13.00 days |
Purchases and COGS are not interchangeable
For this simple retailer, opening inventory + purchases - COGS = closing inventory. That identity makes purchases exceed COGS by 40 during inventory accumulation. It cannot be applied unchanged to a manufacturer with labor and overhead in COGS, or to a business with inventory write-downs, acquisitions or foreign-exchange movements. Use disclosed credit purchases when available; otherwise name the COGS proxy and its limitation. ACCA explicitly distinguishes credit purchases from cost of sales in payables-day analysis.
- Match trade payables to the costs they actually finance. Supplier-finance balances, accrued payroll and taxes can change the apparent payment period if grouped into the numerator.
- Keep net trade receivables consistent with the sales measure. Factoring, allowances and non-trade balances can alter DSO without a corresponding change in customer payment terms.
- A zero sales, COGS or purchase denominator makes its ratio undefined. Missing balances also mean unavailable, not zero. Investigate negative denominators or balances before interpreting the result.
Read seasonality and business models before calling a cycle good
Two balance-sheet dates can miss a seasonal inventory peak between them. Compare the same fiscal quarter across years, inspect the separate components, and use monthly or quarterly balance observations when available. Keep the averaging method consistent across the comparison. A retailer preparing for holiday sales may hold more inventory before revenue arrives; the change needs an operating explanation before it becomes a warning.
| Observation | Useful follow-up | Limit on the conclusion |
|---|
| CCC rises because DIO rises | Check seasonal stocking, acquisitions, product launches and inventory reserves. | Higher days do not by themselves establish obsolete stock or weaker demand. |
| CCC falls because DPO rises | Check payment terms, overdue invoices, lost discounts and supplier-finance disclosures. | A longer payment delay can reflect bargaining power or financial stress. |
| CCC is negative | Confirm that supplier payment timing exceeds inventory and collection days. | It does not establish zero-cost funding, positive free cash flow or freedom from debt. |
| Two sectors have very different CCC | Compare similar inventory, billing and supplier arrangements first. | Banks, insurers and subscription businesses do not share a retailer's inventory cycle. No universal target applies. |
Take an auditable question to AI Finance Agent
Pineify AI Finance Agent has income-statement and balance-sheet tools with reporting periods, currency and filing dates. Use them to assemble the inputs, then check material classifications against the issuer's original report. A useful request is: "For this company and fiscal quarter, list opening and closing inventory, trade receivables and trade payables, plus quarter-only revenue and COGS. Show dates, units and source references. Calculate average-balance DIO, DSO, DPO and CCC, label unavailable credit-sales or purchase data, and explain any difference from these TradingView readings."
- Provide the company, exchange, fiscal period and observed TradingView values. The agent does not need access to your TradingView account for this comparison.
- Review the returned source lines and arithmetic. Missing purchase detail remains a limitation; an AI explanation cannot turn a proxy into reported data.
