{"uid":"cap_JDlNKtFuxb9FuedvIyX1i","slug":"days-sales-outstanding-rolling-mean-report-f1021400","name":"Days Sales Outstanding – Rolling Mean Report","description":"Days sales outstanding - Rolling mean report: Calculate trailing full-window means over ordered observations, preserving invalid-row gaps. Metric: Days sales outstanding. Supplied figures only; returns JSON with formula, units and limitations. One of 50 calculators with 20 analysis modes. No live feed, financial advice or trade execution. 0.01 USDC includes one bounded rolling mean report report.","url":"https://market.datapackvibe.com/x402/assistant-finance-receivable-days-rolling?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["average_receivables","net_credit_sales","period_days"],"properties":{"period_days":{"type":"integer","default":365,"maximum":3660,"minimum":1},"net_credit_sales":{"type":"number","default":40000,"maximum":1000000000000,"minimum":0,"description":"Amount in a consistent supplied currency and reporting period","exclusiveMinimum":0},"average_receivables":{"type":"number","default":8000,"maximum":1000000000000,"minimum":0,"description":"Amount in a consistent supplied currency and reporting period"}},"additionalProperties":false},"default":[{"period_days":365,"net_credit_sales":40000,"average_receivables":8000},{"period_days":402,"net_credit_sales":44000,"average_receivables":8800},{"period_days":365,"net_credit_sales":40000,"average_receivables":8000},{"period_days":402,"net_credit_sales":44000,"average_receivables":8800}],"maxItems":200,"minItems":2},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_Wecca_FdU5apiQ_8P2PM7","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Calculates trailing full-window rolling means of Days Sales Outstanding (DSO) across an ordered series of observations, returning results with formula, units, and limitations.","exampleAgentPrompt":"Can you calculate the rolling mean Days Sales Outstanding for these 4 periods using a window of 2: period 1 has $8,000 average receivables and $40,000 net credit sales over 365 days; period 2 has $8,800 receivables and $44,000 credit sales over 402 days; period 3 matches period 1; period 4 matches period 2?","exampleUseCases":[{"title":"Quarterly DSO trend smoothing","prompt":"I have 8 quarters of receivables data and want to smooth out the noise — can you run a rolling mean DSO with a window of 4 quarters? The data starts with Q1: $10,000 avg receivables, $50,000 net credit sales, 90 days; Q2: $11,000 and $52,000 over 91 days; Q3: $9,500 and $48,000 over 92 days; Q4: $12,000 and $55,000 over 90 days; Q5–Q8 mirror Q1–Q4."},{"title":"Annual DSO rolling average for AR review","prompt":"We do an annual AR review and I need the trailing 3-year rolling mean of days sales outstanding. Here are 5 years of data — year 1: $8,000 receivables, $40,000 credit sales, 365 days; year 2: $9,000 and $45,000 over 365 days; year 3: $8,500 and $42,000 over 365 days; year 4: $10,000 and $50,000 over 365 days; year 5: $9,200 and $46,000 over 365 days. Use a window of 3."},{"title":"Monthly collection efficiency analysis","prompt":"Can you compute a 6-month rolling mean DSO from my monthly figures? I have 12 months of data. Months 1–6: avg receivables $5,000–$6,000 stepping up by $200 each month, net credit sales $30,000–$35,000 stepping up $1,000/month, all over 30 days. Months 7–12 mirror months 1–6 but scaled up 10%. Use window size 6."}],"resultDescription":"A JSON object containing the rolling mean DSO values for each valid full-window position, along with the DSO formula used (average receivables / net credit sales × period days), units, gap preservation details for invalid rows, and limitations of the calculation.","failureModes":["Fewer than 2 rows provided — minimum row count not met","Window size larger than number of rows — insufficient data for even one full window","net_credit_sales of zero would cause division-by-zero — field requires exclusiveMinimum > 0","Values exceeding maximum bounds (1,000,000,000,000) rejected with validation error","Non-numeric or missing required fields cause schema validation failure","Window larger than 200 or rows exceeding 200 items rejected"],"whenToPreferThis":"Choose this endpoint when you need a statistically smoothed view of Days Sales Outstanding over an ordered time series, particularly when preserving gaps from invalid rows is important. It is ideal for finance teams analyzing AR collection trends across multiple periods where point-in-time DSO is too noisy. Use it over a simple DSO calculator when you have at least 2 observations and want trailing window averaging rather than a single-period result.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:48:27.789Z","isFirstParty":false,"canonicalSlug":"days-sales-outstanding-rolling-mean-report-f1021400"}