Enter order-to-cash inputs
Example data table
Use these sample rows to understand how timestamp choices affect total cycle time and cash conversion speed.
| Order ID | Order Received | Credit Approved | Fulfillment Completed | Invoice Issued | Payment Received | Gross O2C Days |
|---|---|---|---|---|---|---|
| SO-1001 | 2026-03-01 09:00 | 2026-03-02 10:00 | 2026-03-06 16:00 | 2026-03-07 11:00 | 2026-03-21 15:00 | 20.25 |
| SO-1002 | 2026-03-05 08:30 | 2026-03-05 14:00 | 2026-03-09 13:00 | 2026-03-10 09:00 | 2026-03-24 17:00 | 19.35 |
| SO-1003 | 2026-03-08 10:00 | 2026-03-09 09:30 | 2026-03-14 18:00 | 2026-03-15 12:00 | 2026-03-31 11:00 | 22.04 |
Formula used
- Gross O2C Days = (Payment Received − Order Received) ÷ 24
- Approval Days = (Credit Approved − Order Received) ÷ 24
- Fulfillment Days = (Fulfillment Completed − Credit Approved) ÷ 24
- Invoice Lag Days = (Invoice Issued − Fulfillment Completed) ÷ 24
- Collection Days = (Payment Received − Invoice Issued) ÷ 24
- Adjusted O2C Days = Gross O2C Days − (Dispute Hold Days + Rework Days)
- Cash Realization Rate = Payment Received Amount ÷ Order Value × 100
- Delay Ratio = (Invoice Lag Days + Manual Delay Days) ÷ Gross O2C Days × 100
- Financing Cost of Delay = Order Value × Cost of Capital × Adjusted O2C Days ÷ Operating Days Per Year
- Terms Variance = Collection Days − Credit Terms Days
This model assumes all timestamps progress in sequence and that manual delay days represent non-value-added waiting outside the main process milestones.
How to use this calculator
- Enter the order reference, customer segment, and reporting currency.
- Add timestamps from order receipt through final cash receipt.
- Fill in order value, collected amount, delays, credit terms, and targets.
- Submit the form to generate cycle metrics, bottleneck stages, and benchmark gaps.
- Download the results as CSV or PDF for reviews, dashboards, or team discussions.
Frequently asked questions
1. What does order-to-cash time measure?
It measures the elapsed time between receiving a customer order and receiving the related payment. It helps sales, finance, and operations teams identify where revenue is slowing down.
2. Why is adjusted cycle time useful?
Adjusted cycle time removes manual dispute and rework delays. That helps you compare the core process against targets without letting exceptional events distort the operational baseline.
3. What does invoice lag mean?
Invoice lag is the time between fulfillment completion and invoice issuance. A high lag usually points to billing bottlenecks, documentation gaps, or approval queues that delay cash collection.
4. Can I use partial payments?
Yes. Enter the payment actually received. The cash realization rate will show how much of the order value has been converted into collected cash so far.
5. What is financing cost of delay?
It estimates the carrying cost of waiting for cash, using order value, cost of capital, and cycle time. It is helpful for quantifying the financial impact of slow collections.
6. How should I set the target cycle days?
Use your internal service level, contract commitment, or historical best performance. The target gap then shows whether the current order is ahead of schedule or behind it.
7. What does terms variance tell me?
Terms variance compares actual collection time against agreed credit terms. Positive values suggest late payment relative to terms, while negative values suggest early or faster-than-expected collection.
8. Can this calculator support benchmarking?
Yes. Use the baseline cycle field for past performance and the target field for desired performance. The calculator then highlights improvement or deterioration in clear percentage terms.