ReconciliationWhy the two revenue figures differ
Each step is computed from the source tables, order by order, and the steps add up to the second figure.
| Step | Amount |
|---|
| Monthly revenue view: line value of delivered orders placed in 2025 | $15,072,148 |
| Line value of orders not marked delivered (shipped, invoiced, backordered, canceled) | +$691,381 |
| Line value of orders with no payment recorded | -$1,758,886 |
| Backordered orders: deposit paid, net of the full line value | -$15,390 |
| Billed orders paid by card: paid amount net of the line value | +$114,495 |
| Billed orders paid by ACH: paid amount net of the line value | -$47,019 |
| Payments on canceled orders that have no lines | +$35,888 |
| Revenue by payment method view: all payments on orders placed in 2025 | $14,092,618 |
The largest step is orders with no payment recorded: 1,084 orders, 755 of them delivered. 505 of those were placed in the 45 days before the extract, so they would be within terms if the terms are 45 days; the rest belong on the receivables aging. Every one of the 2,340 orders paid by card was paid about 3.0% above its line value, consistent with a card surcharge; 1,413 of 3,995 orders paid by ACH were paid about 2.0% below it, consistent with an early-payment discount. Both causes are for the receivables team to confirm. The data shows the pattern, not the policy behind it.