QantivE-commerce accounting

Own store

Shopify accounting: from payout to revenue

On Shopify you control the storefront but not the money. Between the order and the transfer sit a payment provider, a delay, a set of fees and a series of events that undo the sale.

Own storeUpdated 13 October 20263 min read

The hard part is reconciliation

A Shopify store rarely collects through one channel. Shopify Payments, Stripe, PayPal, sometimes a buy-now-pay-later provider or a bank transfer: each pays on its own cycle, keeps its own fees and produces its own reports. Three practical consequences.

  • Every provider needs its own dedicated cash account. Without that there is no reconciliation and discrepancies accumulate unidentified.
  • The lag between order and payout creates cash in transit at closing, which belongs on the balance sheet.
  • Fees are withheld before payout. They are an expense, not a reduction of revenue, and have to be recorded as one.

The events that undo a sale

These separate roughly-right books from correct ones. Each has its own period, and none of them nets cleanly against the original sale.

Post-sale events and expected treatment
EventWhat happensThe trap
RefundAll or part of the price goes back, the fees often do notNetting it off the current month's revenue
ChargebackThe customer disputes, the amount is clawed back, a penalty is addedConfusing the clawback with the penalty
Gift cardCash in with no sale: a liability to the customerBooking it as revenue on purchase
Pre-orderCash in before deliveryRecognising the sale on receipt
Shipping chargedAncillary income with its own VAT treatmentFolding it into the product price
Sale in a currencyConverted by the provider, at its rate and with its spreadTaking the credited amount as the sale amount

VAT from the first foreign sale

A Shopify store sells internationally by default: one foreign customer is enough. From then on the applicable VAT regime depends on where the customer is, and the European threshold is often crossed before anyone has planned for it — the detail is in the EU VAT, OSS and IOSS guide.

The store's tax configuration has to reflect that regime. When it does not, the gap surfaces at closing, on sales already collected at a rate that was not the right one.

On Shopify a VAT error is invisible. Nothing blocks and nothing warns: the store applies the settings it was given, right up until the audit.

Further reading