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.

Shopify Payments Payouts VAT Config Multi-Currency Merit Aktiva Xero A2X Monthly Close
Gross Revenue Recognition
5th Monthly Close Target
1–3d Payout Delay
50+ Currencies Supported
€40K VAT Registration
2% Shopify Txn Fee

5 Key Takeaways From This Page

Record gross sales — not payout amounts — as revenue
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.
Payout timing creates a timing gap you must manage
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 calculates — it does not file
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.
Multi-currency orders require conversion at transaction date
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.
Integration eliminates 80% of manual reconciliation work
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

1
Order Placed
2
Payment Captured
3
Payout Queued
4
Payout Released
5
Bank Receipt
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
If you use both Shopify Payments and PayPal, you need two separate reconciliations
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

1
Export Payouts Report
2
Export Transactions
3
Download Bank Statement
4
Match Payouts to Bank
5
Reconcile Totals
Monthly Payout Reconciliation — Worked Example
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
VAT collected through Shopify is a liability — quarantine it immediately
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

JE-1: Monthly Revenue and VAT Recognition
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
JE-2: Shopify Platform Fees as Cost of Revenue
DR COGS — Platform Fees: €403.20
DR Operating Expense — Software: €79.00
CR Cash — Shopify Payments: €527.20
JE-3: Shopify Payout Received in Bank Account
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
1
Customer Provides VAT Number
2
Validate the VAT Number
3
Apply Tax Exemption
4
Invoice Note Added
5
Report as Zero-Rated on KMD

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
Multi-Currency Sale — GBP Order (£250 @ 1.1680 = €292.00)
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
1
Pull Shopify Data
2
Categorise
3
Monthly Summary
4
Post to Xero/QBO
5
Reconcile

Section 7 — Shopify-Specific Accounting Challenges

Gift cards, discount codes, abandoned checkout revenue, and other Shopify mechanics that create non-standard entries

Gift Card Sale (€50 gift card sold)
DR Cash — Shopify Payments: €50.00
CR Deferred Revenue (Gift Cards): €50.00
Gift Card Redemption (€50 card redeemed on €60 order)
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 Capital Advances — Not Revenue
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

Day 1
Export Reports
Day 1
Export Bank
Day 2
Reconcile Payouts
Day 2
Post JEs 1-3
Day 3
COGS + FX
Day 4
Prepare KMD
By 20th
Pay KMD
Quarter end
OSS Return

Frequently Asked Questions

Neither in isolation — and this is exactly the reconciliation challenge. Shopify’s Finance reports show gross order values including VAT and before fees are deducted. Your bank account shows net payouts after fees, which arrive 1–3 days after the transactions they relate to. For accounting, you start with Shopify’s gross order data (to capture full revenue, all VAT, and all fees separately), then reconcile to the bank payout to confirm the cash position. The correct accounting figures come from reconciling both sources against each other — not from either one alone.

VAT is always calculated in EUR for Estonian and OSS purposes, regardless of the currency the customer paid in. If a German customer pays in USD, you convert the order value to EUR at the transaction-date rate, then apply the German 19% VAT rate to the EUR-converted amount. In Shopify, if multi-currency is enabled, the tax is calculated on the store’s base currency equivalent — ensure your store’s base currency is set to EUR, which automatically handles this conversion. In your accounting records, post both the USD amount received and the EUR equivalent, and document the exchange rate used.

The €3,200 in EU VAT collected by Shopify represents your OSS liability for that quarter. In your OSS return, you declare each EU country’s net sales and the applicable VAT — the country breakdown comes from Shopify’s Sales by Country report (or your tax app’s country-level report). The sum of all EU B2C VAT across all countries should equal the €3,200 from Shopify’s tax summary. If there is a discrepancy, investigate before filing — it could indicate that domestic Estonian sales were incorrectly included in the EU total, or that some B2B sales had VAT applied when they should have been zero-rated under reverse charge.

Shopify’s standard order confirmation email is not a valid VAT invoice under Estonian or EU requirements — it lacks several required fields (your VAT number, the buyer’s VAT number for B2B, the explicit VAT rate and amount on separate lines). You can configure a custom invoice template through Settings → Notifications → Edit, or use a Shopify app specifically designed for EU VAT-compliant invoicing (Invoice Falcon, Order Printer Pro, and Sufio are commonly used). For B2B customers requiring reverse-charge invoices, the invoice must include their VAT number and the reverse-charge note. This is a compliance requirement — not optional.

A chargeback has two accounting effects: the revenue from the original order is reversed (credit note against the original sale), and the chargeback fee charged by Shopify is an additional cost. Journal entry: DR Revenue (original net sale), DR VAT Payable (original VAT amount), DR Chargeback Fee Expense (Shopify’s dispute fee, typically €15), CR Cash — Shopify Payments (total deducted from payout). If you win the chargeback dispute and Shopify reverses it, you make the opposite entry to restore the original revenue and cancel the fee. Track chargebacks as a separate KPI — a chargeback rate above 1% is a signal of product or fulfilment issues.

Running a Shopify store from Estonia? Let’s set up your accounting correctly.

Book a free 30-minute consultation. We connect your Shopify Payments to your accounting software, configure EU VAT rates, and deliver clean monthly financials with every payout reconciled.

companyforbusiness.ee →