DPL.GROUP
ES The Arsenal Write to us
DPL Asesores › E-commerce and Shopify › Shopify accounting
Shopify Partner · E-commerce taxation

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.

🛍️ Shopify Partner🇪🇸 Accounting and taxes in Spain🇪🇺 OSS & IOSS🤝 VAT and EPR in Europe, organised from one place⚖️ Lawyers and tax advisers

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

MistakeWhat it causesHow to do it right
Booking what reaches the bankUndeducted fees and VAT that doesn't reconcileGross sale to income and fee to expense
Still charging Spanish VAT after passing €10,000Wrongly charged VAT and surchargesOSS registration and the customer's country VAT
Refunding without a credit noteInflated sales and VATA credit note for every refund
Holding stock in another country without registering thereUndeclared sales in that countryA VAT number there before moving the goods
Importing small consignments without IOSSThe customer pays VAT and fees on delivery, and returns the parcelIOSS and VAT charged at checkout
Shipping to Germany or France without a packaging registrationMarketplace blocks and penaltiesEPR in each country
Booking US sales tax as incomeInflated profit and unpaid taxA liability to each state and a state return

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.

Content reviewed by lawyers and tax advisers · Updated October 2026.