Shopify Accounting for Estonian Businesses
A complete accounting setup guide for Shopify store owners — chart of accounts configuration, Shopify Payments reconciliation, multi-currency handling, VAT configuration, integration with Estonian accounting software, and the monthly close process.
5 Key Takeaways From This Page
Shopify deposits net amounts after deducting processing fees and any refunds. Recording the bank deposit as revenue understates your top line and misrepresents your gross margin. Always start from the gross order value.
Shopify Payments typically settles 1–3 business days after the order. December sales may arrive in January. Your accounting must track the balance in transit so the month-end bank balance and the Shopify report always agree.
Shopify Tax (or third-party apps) determines the correct VAT rate at checkout and tracks your liability. But it does not file your KMD, OSS, or IOSS returns. That step is done through EMTA by you or your accountant.
If your Shopify store accepts GBP, USD, or SEK, each order must be converted to EUR at the rate on the date of the transaction — not the settlement date or a monthly average.
Connecting Shopify directly to your accounting software via A2X, Xero, or Merit Aktiva reduces the monthly reconciliation from a two-day manual process to a 30-minute review. Set it up once; benefit every month.
What does Shopify accounting involve for an Estonian OÜ? Monthly gross revenue recording from Shopify Finance reports, Shopify Payments reconciliation (gross orders → processing fees → refunds → payout → bank receipt), EU VAT configuration and reporting (Estonian KMD for domestic sales, OSS for EU B2C cross-border), multi-currency order handling, integration with accounting software for automated transaction import, and a month-end close that ties Shopify’s finance summary to the general ledger. This page covers each of those workstreams in full.
Section 1 — Shopify’s Financial Architecture
How Shopify structures money flow — from order to payout to your bank account
The Five Layers of Shopify Money Movement
| Feature | Shopify Payments | Third-Party Gateway |
|---|---|---|
| Integration | Built into Shopify — no separate account | Requires separate payment account |
| Transaction fees | Included in Shopify plan rate (0.5–2%) | Shopify charges extra 0.5–2% on top |
| Payout timing | 1–3 business days | Varies by gateway |
Never combine them into a single reconciliation — the fee structures, timing, and data formats are different.
Section 2 — Shopify Payments Reconciliation
Line-by-line: from gross orders to net payout to bank receipt — with a fully worked monthly example
The Shopify Payments Flow — Three Reports You Need
Gross customer payments: €22,400.00
Less fees: -€527.20
Expected bank payouts: €22,001.20
Actual bank receipts: €22,001.20
Difference: €0.00 — fully reconciled
The VAT collected appears in your Shopify Finance report. This money belongs to EMTA and your EU OSS obligations — not to your business. Never include VAT in your revenue figures.
Section 3 — Monthly Journal Entries for Shopify
The complete set of entries from order to payout to VAT payment
DR Cash — Shopify Payments: €22,400.00
CR Revenue — Shopify Store: €17,280.00
CR VAT Payable — Estonian KMD: €2,244.00
CR VAT Payable — OSS: €1,856.00
DR COGS — Platform Fees: €403.20
DR Operating Expense — Software: €79.00
CR Cash — Shopify Payments: €527.20
DR Cash — Estonian Bank: €22,001.20
CR Cash — Shopify Payments: €22,001.20
Section 4 — VAT Configuration in Shopify
Setting up tax rates, handling EU B2C correctly, and avoiding the most common configuration errors
Shopify’s Tax Options — Which One to Use
| Option | What It Does | Best For |
|---|---|---|
| Shopify Tax (built-in) | Calculates US sales tax automatically | US-focused stores |
| Manual tax rates | You set specific rates per country | Simple setups with a few countries |
| Third-party tax app | Automatic rate lookup; OSS integration | EU sellers with complex rate requirements |
Section 5 — Multi-Currency in Shopify
Enabling multiple currencies, how Shopify handles FX, and the accounting implications of each approach
How Shopify Multi-Currency Works
| Shopify Multi-Currency Approach | How FX is Handled | EUR Rate for Accounting |
|---|---|---|
| Auto-conversion at settlement | Shopify converts to EUR at their rate when payout is released | Shopify’s conversion rate on payout date |
| Multi-currency payouts | Shopify holds GBP, USD, EUR balances separately | Transaction date rate for each sale |
DR Cash — Shopify Payments (GBP balance): €292.00
CR Revenue — Shopify (GBP orders): €292.00
No VAT — UK outside EU VAT scope post-Brexit
Section 6 — Connecting Shopify to Your Accounting Software
Integration options — native connectors, A2X, and manual import — with setup guidance for Merit Aktiva and Xero
Why Integration Is Essential at Scale
| Accounting Software | Shopify Integration Method | Monthly Effort |
|---|---|---|
| Merit Aktiva | Manual import via CSV or bank feed | 3–5 hours/month |
| Xero | A2X connector (best option) | 30–60 min/month |
| QuickBooks | A2X connector or manual import | 30–60 min/month |
Section 7 — Shopify-Specific Accounting Challenges
Gift cards, discount codes, abandoned checkout revenue, and other Shopify mechanics that create non-standard entries
DR Cash — Shopify Payments: €50.00
CR Deferred Revenue (Gift Cards): €50.00
DR Deferred Revenue (Gift Cards): €50.00
DR Cash — Shopify Payments: €9.84
CR Revenue — Shopify: €49.18
CR VAT Payable — KMD: €10.82
Shopify offers merchant cash advances (Shopify Capital) to eligible stores. These are financing arrangements — the advance is a liability (loan), not income. Do not record as revenue.
Section 8 — Shopify Monthly Close Checklist
Every step from month-end to filed returns — in order