E-commerce: connecting Shopify to your accounting in 2026

Quick answer. Connecting Shopify to your accounting is not about copying the amount transferred by Stripe. The net payout hides three distinct operations: the gross sale, the collected VAT and the platform fee. The right method records these three items separately, then reconciles the payout against the bank statement.

The first mistake of a merchant starting on Shopify is almost never a rate mistake. It is a scope mistake: taking the transfer received in the bank for the revenue. Yet between the order paid by the customer and the money credited to the account, Shopify and the payment processor have already taken their fees, deducted refunds and withheld VAT. Connecting Shopify to your accounting means, first of all, putting these flows back where they belong.

This guide explains, step by step, how to link Shopify, Stripe and marketplaces to an accounting tool, how to reconcile payouts, and how to split VAT by sales destination. It is intended for sellers who want accurate accounts without re-keying every order by hand.

When a customer pays 120 euros on your store, Stripe or Shopify Payments does not transfer 120 euros to you. The processor takes its fee, groups several orders into a single payout, and deducts any refunds of the period along the way. The amount reaching the bank is therefore a balance, not a receipt.

Booking that balance as revenue produces two chained errors. First, the revenue is understated by the amount of fees, which distorts the margin and the VAT base. Second, the fee expense disappears, even though it is deductible and carries its own deductible VAT when the provider is established in the Union.

The rule is simple to state: record the sale at its gross amount, the collected VAT separately, and the fee as a distinct expense. The net payout is only the result of these movements, not their starting point.

An online sale always breaks down into several flows that the accounts must isolate. Confusing them is the most common source of discrepancies at return time.

This table sets the sorting logic: three of these flows never appear in full on the bank statement, which shows only the net payout. That is exactly why reconciliation must start from the Shopify reports, not from the bank account.

Linking a store to an accounting tool follows a stable sequence, whether you handle ten orders or a thousand a month.

1. Map your revenue sources. List each channel that collects money (Shopify Payments, Stripe, PayPal, marketplaces). Each produces its own statement and payout, to be reconciled separately.
2. Export the period finance report. Pull the monthly Shopify report: gross sales, refunds, collected taxes and fees.
3. Record gross revenue, not the net payout. Book the sale excluding tax, the collected VAT separately, then the fee as an expense.
4. Reconcile the payout against the bank statement. Check that the transfer received matches sales less refunds and fees for the period.
5. Split VAT by destination. Separate French sales, intra-EU distance sales and exports.
6. Automate the recurring reconciliation. Connect Shopify and the processor to your accounting tool, then review monthly rather than re-keying.

Once the mechanism is in place, the monthly work boils down to a consistency check: the net payout must equal sales less refunds less fees.

Take a month where the store collects 100 orders for 12,000 euros including tax, of which 200 euros of refunds and 350 euros of payment fees.

The month's revenue is 9,833 euros excluding tax, not the 11,450 euros received in the bank. The 1,617-euro gap between the two is not missing income: it is the sum of collected VAT and fees, which the accounts must present separately. Over a year at this pace, the cumulative gap exceeds 19,000 euros, exactly what separates a true margin from a phantom one.

The amounts above illustrate the method and must be adjusted to your actual rates and volumes.

The accounting connection only makes sense if VAT is split by destination, because a store rarely sells to France alone. Three regimes coexist and must be tracked on separate accounts.

For sales to private customers located in another EU country, the rule is as follows: as long as the turnover of these intra-EU distance sales stays under 10,000 euros a year, French VAT applies. Above this 10,000-euro threshold, the VAT of the customer's country becomes due, and the OSS one-stop-shop lets you declare and pay it from France, without registering in each State.

Exports to a country outside the Union are exempt from French VAT, subject to proof of exit. French sales, finally, follow the usual domestic rates. A store that mixes these flows on a single collected-VAT account is setting up a headache at return time. For cross-border sellers, our article on reconciling marketplace flows in OSS and IOSS goes deeper into this point.

The real issue for a Shopify store is not the choice of accounting tool, but the discipline of reconciliation. A well-configured connector saves hours, but it does not fix a logic that is wrong from the start. If the accounting entry starts from the net payout, automation only reproduces the error faster.

Our recommendation fits in a monthly habit: close the month by reconciling three figures, total sales, total fees and the net payout, until they balance. It is that check, not the software, that guarantees faithful accounts.

A cosmetics seller had set up their accounts to record each Stripe transfer as a sale. At the first year-end, the margin came out abnormally low and the collected VAT inconsistent with the turnover. By going back through the Shopify reports month by month, we recovered the fees buried in the net and the VAT that had never been isolated. The real revenue was several thousand euros higher than declared, and the fees, previously invisible, opened a deductible expense. This kind of gap is often found among e-commerce-specific accounting mistakes.

The lesson is clear: it is not the volume that causes the problem, it is the starting point of the entry.

The most costly trap is not a wrong VAT rate, it is recording only the net payout. It mechanically erases fees and blurs the taxable base. A seller paying 4,200 euros of fees over the year and never booking them loses both a deductible expense and the visibility of their true margin.

The second trap is the period mismatch. A late-month payout may group sales straddling two months, even two financial years. Reconciliation must follow the date of sales, not the date of the transfer, on pain of distorting the year-end.

Two deadlines shape the year. On one hand, the rollout of electronic invoicing: from 1 September 2026, every business must be able to receive electronic invoices, issuance being then deployed in stages. On the other hand, the recodification of the VAT part of the general tax code on 1 September 2026, which changes article numbering without changing rates or territoriality rules.

For a store, the practical stake is to make the sales data and the VAT split reliable now, the foundation on which electronic invoicing will rest.

• The Stripe or Shopify Payments payout is a balance, not the revenue.
• Record separately the gross sale excluding tax, the collected VAT and the fee as an expense.
• Reconciliation starts from the Shopify reports, not the bank statement.
• Split VAT between France, intra-EU distance sales (OSS above 10,000 euros) and exports.
• Follow the date of sales, not the date of the transfer, to avoid distorting the year-end.
• Electronic invoicing and the VAT recodification of 1 September 2026 make data reliability even more important.