Thred
All posts

Reconciling Shopify sales to cash: orders, payment providers, payouts and refunds

Shopify orders, payment providers and bank payouts are three different records. How to tie them together so revenue, VAT and cash agree, with a worked example.

David van Duijn6 min read

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo
On this page

Reconciling Shopify sales to cash means proving that every order became money in your bank, minus the fees, refunds and chargebacks in between. You do it in three steps. Book orders as revenue, settle each order against the payment provider that collected it, and match each provider's payout to the bank.

If you own or run finance for a growing webshop, this is probably the reconciliation that never quite closes. Shopify says you sold €42,000 last month. The bank received €38,600. Somewhere in between are fees, refunds, PayPal, a gift card or two and orders that were paid by bank transfer a week late. This article shows a structure that makes the gap explainable, line by line.

Why don't Shopify sales match the money in the bank?

Because Shopify sales, payment provider balances and your bank account are three different records, and each one runs on its own clock.

  • An order is the sale. It carries the products, shipping, discounts and the VAT, on the date the customer checked out.
  • A payment is how the order was paid. One order can be paid through Shopify Payments, another through PayPal, a third by bank transfer.
  • A payout is the provider sending you money, usually days later and always net of its fees and of any refunds or chargebacks it processed in the meantime.

Most reconciliation problems come from booking the wrong one as revenue. If you book bank payouts as sales, you lose fees, refunds and VAT accuracy in one move. If you book orders and payouts both as sales, you double your revenue. The fix is to give each record its own place in the ledger.

What does the account structure look like?

You need very little.

  • Revenue accounts for product sales and shipping, split by VAT rate, such as 21% and 9% in the Netherlands or 20% and 5% in the UK.
  • VAT payable.
  • A clearing account per payment provider, for example "Shopify Payments clearing" and "PayPal clearing".
  • A receivable for orders that are not yet paid, such as bank transfer or invoice orders.
  • Cost accounts for payment fees and for chargebacks.

A clearing account mirrors the provider's balance. Orders paid through that provider go in, fees, refunds and payouts go out. When it agrees with the provider's own balance, that provider is reconciled.

How does it work in a worked example?

Take one illustrative trading day. The numbers are made up but add up exactly, and all products are at 21% VAT.

  • Orders for the day total €3,025.00 including VAT, which is €2,500.00 net plus €525.00 VAT.
  • Customers paid €2,420.00 of that through Shopify Payments and €605.00 through PayPal.

Step 1. Book the orders

Book the day's orders as one summary entry, or per order if your volumes allow it. Credit revenue €2,500.00 and VAT payable €525.00. Debit Shopify Payments clearing €2,420.00 and PayPal clearing €605.00. Total debits and credits are both €3,025.00.

Revenue and VAT are now right, on the day the sale happened, regardless of when the money arrives.

Step 2. Book the Shopify payout

Two days later, Shopify Payments pays out. The payout covers this day's €2,420.00 in payments, minus €45.98 in processing fees and minus a €121.00 refund issued that week on an earlier order. The bank receives €2,420.00 − €45.98 − €121.00 = €2,253.02.

  • Debit payment fees €45.98, credit Shopify Payments clearing €45.98.
  • Debit revenue €100.00 and VAT payable €21.00, credit Shopify Payments clearing €121.00. The refund reverses part of an earlier sale.
  • Debit bank €2,253.02, credit Shopify Payments clearing €2,253.02.

Shopify's payout documentation describes how funds move from your Shopify Payments balance to your bank account, and the payout detail in your admin lists the transactions behind each one.

Step 3. Book the PayPal side

PayPal takes €21.48 in fees, leaving €583.52 in your PayPal balance. Debit payment fees €21.48 and credit PayPal clearing €21.48. When you withdraw the balance to your bank, debit bank and credit PayPal clearing for the amount transferred. If you leave it in PayPal, the clearing account simply shows €583.52, which is what PayPal shows too.

How should you handle refunds in Shopify?

Refunds are where most webshop books quietly drift. Shopify's guide on refunding and cancelling orders covers the options: full or partial refunds, with or without shipping, back to the original payment method.

For the books, three rules are enough.

  • Book the refund against revenue and VAT, not as a cost. A refund reverses a sale.
  • Book it through the clearing account of the provider that paid it back. A refund issued through Shopify Payments leaves the Shopify Payments balance, so it shows up as a deduction on a later payout.
  • Keep the link to the original order. If the refund is for a product at 9% VAT, the VAT correction is 9%, not 21%.

Cancelled orders that were never paid do not need a refund entry. Reverse the order itself, or exclude cancelled orders from your sales summary, so the receivable does not stay open.

What about chargebacks?

A chargeback is a refund you did not choose. Shopify explains that for Shopify Payments the disputed amount is deducted from your balance and a chargeback fee is charged. Whether the fee comes back when you win depends on your country or region, according to Shopify's chargeback guide.

Book the disputed amount from the clearing account to a balance sheet account for open disputes. Book the fee as a cost. If you win, move the amount back to the clearing account. If you lose, take it to the profit and loss, and ask your accountant how they want the VAT handled.

What about bank transfers, gift cards and marketplaces?

These are the edges that make a clean structure worth having.

  • Bank transfer orders go to receivables, not to a clearing account. When the customer pays, match the bank line to the order number and close the receivable. Orders that stay open become a collections task.
  • A sold gift card is a liability until it is redeemed, not revenue. The VAT treatment of vouchers depends on how they can be used, so set this up once with your accountant.
  • A Shopify Payments balance in another currency is its own clearing account. Convert at the rate on the payout, and book the difference as an exchange result.

How do you know it is reconciled?

Run four checks every week, not just at month-end.

  1. Total orders in Shopify for the period equal total revenue plus VAT booked from Shopify, after refunds.
  2. Each clearing account equals the provider's own balance on the same date.
  3. Every payout in the bank is matched to one payout in the provider.
  4. Receivables from unpaid orders are all younger than your payment term, or someone is chasing them.

The first check catches missed or doubled orders. The second catches missed fees and refunds. The third catches payouts booked to the wrong place. The fourth catches cash you are still owed.

If all four pass, revenue, VAT and cash agree, and you can stop explaining the gap to your accountant every quarter.

What changes when an agent does the reconciliation?

The manual version of this is a weekly ritual of exports from Shopify, Shopify Payments and PayPal, a lookup sheet and a bank statement. An agent can run the same four checks continuously.

  • Orders are read from Shopify as they are placed and booked as revenue and VAT per rate, including shipping and discounts.
  • Each payout is matched to the orders, fees and refunds behind it, per provider and per currency.
  • Refunds are linked to the original order, so the VAT correction uses the right rate.
  • A bank transfer order that is still unpaid after the payment term becomes a follow-up, not a surprise at quarter-end.

What is left for the finance team is judgement: a chargeback to contest, a customer to call, a gift card policy to agree.

Where does automation help?

Shopify and the payment providers already hold all the data this needs, which makes it a natural fit for agents. Thred Layer connects to Shopify, Stripe, Mollie and PayPal alongside the ledger you already use, such as Exact Online. Orders are booked as sales, payouts are matched to the transactions behind them, and fees and refunds are posted under your rules. Only the exceptions, like a chargeback or a bank transfer that does not match an order, land in your inbox.

For a founder, that is the difference between knowing last month's margin in the second week of the next month and knowing it today. For a finance lead, it is one less reconciliation that depends on exports. Read more about how this works for growing businesses.

Want to see your Shopify sales tied to cash automatically? Book a demo.

Frequently asked questions

Why is my Shopify payout lower than my sales?

Payouts are net amounts. Shopify Payments deducts processing fees, refunds and chargebacks before sending money to your bank, and orders paid through other providers such as PayPal arrive separately.

Should I book Shopify payouts as revenue?

No. Book revenue from the orders, on the date of the sale, and treat the payout as a transfer from the payment provider to your bank. Booking payouts as revenue loses fees and refunds and makes VAT inaccurate.

Do I need a separate clearing account for each payment provider?

Yes. Each provider has its own balance, fees and payout schedule. A clearing account per provider, and per currency, lets you compare your books to each provider's balance directly.

How do I book a refund issued in Shopify?

Reverse revenue and VAT at the rate of the original product, and credit the clearing account of the provider that paid the refund. The refund then shows up as a deduction on that provider's next payout.

How should Shopify gift cards be booked?

A sold gift card is a liability until it is redeemed, not revenue. The VAT treatment of vouchers depends on how they can be used, so agree the setup with your accountant.

Sources

  1. Shopify Help Center: Shopify Payments payouts
  2. Shopify Help Center: Refunding and cancelling orders
  3. Shopify Help Center: Chargebacks
  4. Shopify Help Center: Viewing payouts

Read next

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Keep reading

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo