Back to Blog
Cash, Financing & Exit

Order to Cash for Ecommerce: Why Sales Never Match the Bank

The order to cash process for a brand on Shopify, Amazon and wholesale: one order followed to the bank, where money goes missing, and what to check each month.

Oz Merchant14 min read

A shopping bag, a parcel, a delivery slip, an envelope and a stack of coins laid in a row on a pale table, joined by one orange ribbon.

The store's sales report says it sold $48,000 last week. The payouts for those same orders come to $44,190 in the bank. Neither number is wrong, and neither one is revenue. (The figures are one week at a fictional kitchenware brand, used throughout.) Sales, deposits and revenue are three different numbers, and every dollar between them should have a name: a fee, a refund, tax owed to the state, money a channel is holding, or a deduction to dispute.

Order to cash (O2C) is everything between a customer's order and the money landing in your bank, and every place it can shrink on the way. A consumer brand runs two versions at once: the direct one, through checkout, a processor or marketplace and a payout, and the wholesale one, through a purchase order, an invoice, payment terms and the deductions a buyer takes off the payment.

The order to cash process, step by step

Finance teams also call this the order to cash cycle. The same seven steps apply to both sides of the business; what happens at each one differs. On the direct side the customer pays at checkout, so the question is less "will they pay" and more "how much of it reaches the bank, and when."

StepDirect (Shopify, Amazon, eBay)Wholesale
1. OrderThe customer checks outThe buyer sends a purchase order
2. Payment or credit approvalThe card is approved at checkout and screened for fraudThe brand sets terms and a credit limit for the account
3. FulfillmentThe order ships from the brand's warehouse, a 3PL or Amazon's networkThe full order ships to the buyer's warehouse, under the buyer's shipping rules
4. InvoiceNo invoice; the order record is the invoiceAn invoice goes out at the agreed price and terms
5. CollectionThe processor or marketplace pays out, less fees and refundsThe buyer pays on terms, often late, often less
6. Cash applicationEach payout is matched to the orders, fees and refunds inside itEach payment is matched to the invoices it covers and any deductions
7. ReconciliationPayouts are tied to the bank; refunds, disputes and holds are trackedReceivables are aged by buyer; deductions are resolved

One Shopify order, from checkout to the bank

The kitchenware brand's enameled cookware set sells for $120 on its Shopify store, and each set has a landed cost of $36.

On October 30, a customer checks out with a 10 percent discount code.

LineAmount
Cookware set at full price$120.00
Discount code (10%)−$12.00
Shipping charged to the customer$8.00
Sales tax (7% on the set, in this example)$7.56
Charged to the customer's card$123.56
Payment processing fee (example)−$3.88
Paid out to the brand's bank$119.68

Three dates matter.

October 30, checkout. The customer has paid and you have shipped nothing, so none of this is a sale yet. If the month closed today, Shopify would owe you $119.68 after its $3.88 fee, you would owe the customer $116 of goods and shipping, and the $7.56 of tax would belong to the state.

November 2, shipment. A sale counts when the order ships, or when it arrives if your terms say the customer owns it on delivery; this store's terms say shipment. So November gets $116 of revenue: $108 for the set after the discount and $8 for shipping. The $7.56 of tax is never revenue. The set leaves inventory at $36 and becomes cost of goods sold, leaving $80 of gross profit before the fee and the shipping label.

November 4, payout. Shopify Payments pays out on a daily, weekly or monthly schedule the store chooses, so the cash lands a few days after the sale. The $3.88 fee is a selling expense, not a smaller sale, so revenue stays at $116.

One order touched two months. Booking revenue from bank deposits gets this one's month right by luck, though not the amount: the $119.68 deposit includes the state's tax and is net of the fee. Move the shipment to October 31 and the same habit puts October's sale in November. At the end of a holiday week, that is thousands of orders in the wrong month.

Why the payout never equals the sales figure

Now the whole week, starting from the $48,000 on the sales report.

LineAmount
Gross product sales$48,000
Discounts−$4,800
Shipping charged to customers$2,400
Sales tax collected$2,900
Charged to customers$48,500
Processing fees (example)−$1,455
Refunds issued on earlier orders−$2,600
One disputed order, plus the chargeback fee (example)−$255
Paid out to the bank$44,190

Each line lands somewhere different:

  • Net sales are $43,000: gross sales less discounts, plus shipping charged, less refunds (with refunds counted as they are paid; see the accountant's note below).
  • Sales tax of $2,900 is owed to the states, a liability until it is filed and paid.
  • Fees of $1,470 (the $1,455 in processing fees and the $15 chargeback fee) are an expense.
  • The disputed $240 is still in question. When a customer files a chargeback, Shopify withdraws the disputed amount and the chargeback fee immediately and returns both if you win. Until then it is money in dispute, and the $15 fee is an expense either way.

Check the sum: $43,000 of net sales, plus $2,900 of tax collected, less $1,470 of fees, less the $240 in dispute, is $44,190. That is the deposit, and every dollar of the gap has a name.

Refunds also need a forward look. If one order in ten comes back, December's sales are overstated until January's refunds land. Set aside the returns still to come on each month's orders, in the month you sell, so the holiday month does not look better than it was.

For your accountant:

  • Expected returns come off the month's sales and are held as refunds owed.
  • With that reserve in place, refunds on earlier orders are charged to it, not taken off sales a second time.
  • The cost of units expected back in sellable condition comes off cost of goods sold and is held as stock to be returned.
  • At month end, count a chargeback as owed only for the share you expect to win, based on your own record; the rest comes off sales like a refund.
  • If you routinely replace parcels lost in the mail, confirm shipment is still the right date for the sale.

One more line can appear without warning. Shopify can place a reserve, a temporary hold on part or all of a store's transactions to cover future refunds and chargebacks. Reserved money is still yours, a balance Shopify owes you, but you cannot spend it until it is released, so plan cash without it. The guide to Shopify bookkeeping covers the accounts behind these lines.

Order to cash on Amazon and eBay

Marketplaces follow the same steps with a longer wait between delivery and cash.

Amazon holds the cash from each sale until after the customer has received the order. Referral fees, fulfillment fees, refunds and advertising charges come out of the seller's balance before anything is paid out, and Amazon can hold back part of the balance as a reserve. A seller can request a transfer of the available balance rather than wait for the next scheduled payout, but money Amazon is still holding stays held.

The rules are the same as on Shopify. A sale counts at the price the customer paid, after any coupon you funded, when it ships or is delivered; each fee is an expense; and the balance Amazon holds is money it owes you. Sales tax Amazon collects and pays to the states is neither your revenue nor your liability. Settlement periods rarely line up with calendar months, so a month's sales and its deposits will not match. The guide to Amazon FBA accounting works through a settlement that spans two months.

eBay takes its selling fees out of each sale before it pays out and collects sales tax on most orders itself, so an eBay payout is also a net figure. The eBay bookkeeping guide covers how that payout breaks into sales, fees and tax.

Order to cash for wholesale: purchase order to payment

Wholesale is the textbook version of order to cash, and the one where the most cash goes quiet.

On September 15, a regional chain of kitchen stores sends the kitchenware brand a purchase order for 400 cookware sets at $60 each, half the store price, on net 30 terms. The order is worth $24,000. At $36 a set, the goods cost $14,400, a 40 percent gross margin, against 70 percent on its own store before fees.

The purchase order. Before accepting it, check the price, the quantity, whether the stock is there to fill it without starving its own store (the weeks of supply guide does that sum), the ship window and the buyer's vendor guide, the document that sets labeling, shipping rules and the penalties for missing them. A purchase order is a promise to buy, not a sale yet.

Shipment and invoice, October 1. The brand ships inside the window and invoices the same day, so the 30 days start now rather than at month end. Under these terms the buyer owns the goods once they leave the warehouse (some chains take ownership only at their dock, so check the vendor guide). The sale is booked less the deductions already expected. The 1% damage allowance is written into the vendor agreement, so $240 comes off on day one: $23,760 of revenue, a $24,000 accounts receivable balance with $240 held against it, and $14,400 of cost of goods sold.

The delivery and the due date. The carrier's delivery confirmation shows the truck reached the buyer's dock a day after the window, so the brand knows in October that a penalty is coming, and the $480 comes off October's sales then, taking the order to $23,280. October 31, the due date, comes and goes. Nobody calls.

Payment, November 17. The buyer pays $22,680, 47 days after the invoice. The remittance lists three deductions:

DeductionAmount
Shortage claim, 10 sets$600
Late-delivery penalty under the vendor guide (2%)$480
Damage allowance (1%)$240
Total deducted$1,320

Many store buyers call these chargebacks. They are not card chargebacks; they come off your invoice, not out of a payout. And the explanation is not always on the remittance: some buyers post deductions in an online portal, where the claim waits until someone logs in.

What you see. The $22,680 goes against the invoice, and the $1,320 stays on the buyer's account as an open deduction while you check each claim. Any part you expect to lose comes off sales; only the part you expect to win back stays as money owed.

Resolution. The allowance and the penalty already came off the sale in October, so they change nothing now. The shortage is the one to fight: the brand's carton count and the carrier's proof of delivery show all 400 sets arrived, so it disputes the claim, keeps the $600 as money owed, and the buyer credits it on its next payment. Had it been real, the 10 sets would have come off the sale and their cost gone back into stock, or been written off as a loss if they were gone.

The order invoiced at $24,000 ends at $23,280 of net sales and $23,280 of cash, $22,680 of it after 47 days and the last $600 weeks later. Against the $9,600 of gross profit the invoice promised, the brand keeps $8,880, and the margin falls from 40 percent to 38.1 percent.

Two lessons sit in that arithmetic. A deduction nobody disputes is a price cut the brand gave by default. And booking every deduction as an expense misplaces most of them, since valid penalties and allowances belong in net sales, and hides which buyer is costing you margin. Here the buyer claimed 5.5 percent of the invoice and kept 3 percent. When a buyer's agreement or track record makes deductions likely, estimate them when the sale is booked, take them off that sale, and adjust as claims settle.

Watch for two more. Some buyers take an early-payment discount after paying late, and some deduct marketing or markdown allowances nobody signed. Both are worth disputing.

Where money goes missing in the order to cash cycle

Most of the gap between sales and cash is legitimate. The part nobody follows up tends to sit in seven places:

  1. Fees and refunds hidden inside the deposit. Recording payouts as revenue hides the cost of selling and understates the top line, and a refund on an earlier order comes out of a later payout, so a week of heavy returns looks like a weak sales week. No cash is lost, but nobody can see what the channel costs.
  2. A second processor nobody sweeps. Some gateways, PayPal among them, can hold money in their own balance rather than send it to the bank. If no one transfers it and ties it out, the sales show on the report and never show in the bank.
  3. Held balances and reserves treated as gone. Money a channel is holding is a receivable. Written off by mistake, it disappears while it is still owed.
  4. Chargebacks left unanswered. A chargeback is won with evidence, and one left unanswered gives the bank nothing to weigh against the customer's claim. Each one carries a fee on top.
  5. Deductions never disputed. Shortage and compliance claims can be wrong, and many vendor guides set a deadline to dispute, after which the buyer will not reopen the claim.
  6. Invoices sent late or not chased. An invoice that goes out at month end instead of on the ship date gives the buyer weeks of extra credit, and a past-due invoice nobody follows up drifts further.
  7. Failed payouts. A payout the bank rejects goes out again only once the bank details are fixed. Until someone notices, the cash is in neither place.

What to check every month

Whoever reconciles payouts and invoices does the work, whatever accounting software they use. The CEO's part is to ask these questions each month and get a straight answer:

  1. Does every payout tie to a deposit in the bank? Each deposit should break into sales, discounts, shipping, tax, fees and refunds.
  2. Is any channel holding money we have not counted? Payouts on their way, settlement periods still open and any reserve held should each be listed, with the date each is due.
  3. Are sales landing in the month they shipped? Orders paid but not shipped are not sales yet, and orders shipped but not paid out are.
  4. Have we set aside this month's expected returns, rather than waiting for the refunds?
  5. Is the tax we collected the tax we filed, state by state, for the orders where we collect it ourselves?
  6. Are open card chargebacks answered before each deadline?
  7. Which buyers are paying late or short, and what are we disputing? Check each buyer's vendor guide for its dispute deadline and dispute inside that window. Anything that cannot be disputed needs a decision: chase it or accept it. An accepted deduction comes off sales, not bad debt; bad debt is for a buyer that cannot pay.

How long is your order to cash cycle?

The order to cash cycle time is the number of days from order to cash in the bank. Measure it by channel, because a blended number hides the slow one. In the examples above, the Shopify order took five days from checkout to the bank. The wholesale order took 63 days from purchase order to payment, 47 of them after the invoice, and the disputed $600 took longer still.

The days after the invoice are your days sales outstanding, and each day has a dollar value. A brand that ships $100,000 a month to wholesale accounts and collects in 47 days has about $155,000 out with its buyers at any time. Collecting in 35 days brings that down to about $115,000, freeing roughly $40,000. The list of inventory KPIs shows where the rest of a brand's cash sits, and the cash conversion cycle puts those days together with inventory and supplier terms. Either way, the test is the one from the top of this page: every dollar between the sales report and the bank should have a name.

FAQ

Is a Shopify payout the same as revenue?

No. A Shopify payout is what is left after processing fees, refunds and any chargebacks come out, and it includes sales tax that belongs to the state. Revenue is the sale itself, which counts when the order ships, or when it arrives if the customer owns it on delivery. Fees are recorded as an expense and refunds reduce revenue, so the payout is a cash figure, not a sales figure.

How should a wholesale deduction be recorded?

A wholesale deduction stays on the buyer's account while it is checked, but the books do not wait for it. Deductions the brand expects to accept, like an agreed allowance or an earned penalty, come off sales in the month of the sale, or the month the brand learns of them. Only the part it expects to recover stays as money owed. A payment for a real service the buyer provides, such as co-op advertising with proof it ran, can be an expense up to what that service is worth.

See the whole platform

Reading it is one thing. Running it is another.

Book a demo for an overview of the whole platform.

Margin Matters

The ecommerce news, read for your margin

Twice a month: the changes that touch your P&L, the money behind each one, and one move to make. Three minutes, then back to work.

Twice a month. Unsubscribe anytime.