Shopify accounting reconciled to the cent
Sales, fees, payment gateways, VAT in each country, imports and refunds, properly booked and without copying orders by hand.
In short
We look after your Shopify store's accounting and taxes: sales at their gross amount, fees as an expense, Shopify Payments, PayPal and Stripe payouts reconciled with the bank, VAT on your sales with OSS, IOSS or a local number, and returns with their credit note.
Shopify sales go into the accounts automatically, without copying them by hand, and every close is reconciled to the cent with the store, the bank and the returns.
What's included
Sales and invoices
Properly configured invoice series, an invoice for every order, credit notes for every refund and a system ready for Verifactu.
Payment gateways
Shopify Payments, PayPal, Stripe, Klarna and others: gross sale, fee as expense and payout reconciled with the bank.
International VAT
The €10,000 threshold, OSS and IOSS and local VAT numbers, each in its own account.
Imports
EORI, import VAT, duties and customs declarations booked properly, with the VAT recovered on Form 303.
Legal form
Sole trader or limited company: when it pays to switch and how to do it. Plus Spanish registration for foreign companies.
Automation
Shopify sales flow into the accounts on their own and every period is checked against the store, the bank and the returns.
The mistakes we see most in Shopify stores
| Mistake | What it causes | How to do it right |
|---|---|---|
| Booking what reaches the bank | Undeducted fees and VAT that doesn't reconcile | Gross sale to income and fee to expense |
| Still charging Spanish VAT after passing €10,000 | Wrongly charged VAT and surcharges | OSS registration and the customer's country VAT |
| Refunding without a credit note | Inflated sales and VAT | A credit note for every refund |
| Holding stock in another country without registering there | Undeclared sales in that country | A VAT number there before moving the goods |
| Importing small consignments without IOSS | The customer pays VAT and fees on delivery, and returns the parcel | IOSS and VAT charged at checkout |
| Shipping to Germany or France without a packaging registration | Marketplace blocks and penalties | EPR in each country |
| Booking US sales tax as income | Inflated profit and unpaid tax | A liability to each state and a state return |
Dig deeper on our blog: Shopify net payouts and fees · refunds and credit notes · IOSS and customs · dropshipping and VAT · multi-currency Stripe and PayPal.
Frequently asked questions
How do you connect Shopify to your accounting?
With a connector that reads the orders, refunds and payouts from Shopify Payments, PayPal and Stripe and turns them into journal entries: each sale at its gross amount, split by country and VAT rate, fees as an expense and each payout reconciled with the bank deposit. What does not work is entering by hand the total that reaches the bank: by then the sales are already net of fees and refunds.
How are Shopify Payments payouts booked?
At the gross amount of each sale, not at what reaches the bank. The sale goes to income for the total the customer pays and the Shopify fee is recorded separately as an expense. If you only book the net, you lose the deduction of the fees and the sales don't reconcile with the VAT declared.
How is a Shopify refund handled for accounting purposes?
With a credit note that cancels the original invoice in full or in part. A refund in Shopify without its credit note throws sales and VAT out of balance.
Do I have to invoice every Shopify order?
Yes. Every sale needs its invoice or simplified invoice, with consecutive numbering. Shopify can generate them, but the series and tax details have to be set up correctly from the start, and the invoicing system will have to comply with Verifactu: in October 2026 the Spanish Tax Agency announced its postponement to October 2028.
How do I book sales in several countries with different VAT?
Each country and each rate in its own account, with OSS VAT kept separate from the local VAT of the countries where you hold stock. The automation splits it from the Shopify reports.
And sales in the United States or in other currencies?
They are booked in euros at the exchange rate of each transaction, with Stripe or PayPal exchange differences recorded separately, and the sales tax collected as a liability to each state, not as income.
Do you also keep the accounts of my company if it is foreign and sells in Spain?
Yes. For businesses from outside Spain we look after Spanish VAT (registration on form 036, form 303 and form 349) and, if you have an establishment here, the full accounts. If your business is outside the EU and needs a fiscal representative in Spain, we will look at your case.
Tell us about your store
Write to us. You tell us your case once: we work out what you need and in which countries, put you in touch with a partner in our network for foreign VAT and EPR, and reconcile the figures with the Spanish side: your store's accounting, OSS and IOSS.
Opening your store or already selling? Consultancy before you open your store · Tax review of your running store.