E-commerce bookkeeping: sales, payment providers, VAT and inventory, with agents
Manoj Tutika · Published 16 November 2026 · Last checked 16 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
What makes e-commerce bookkeeping different?
A consultancy sends twenty invoices a month and sees twenty payments in the bank. An online store has thousands of orders, paid through five methods, paid out by three providers in dozens of amounts, with returns, chargebacks, discount codes and sales to other EU countries. No single order appears in the bank as its own payment. The books still have to make those flows meet.
E-commerce bookkeeping is therefore about reconciliations. Does revenue in the store platform match revenue in the books? Does cash from the providers match the bank? Is VAT right per country? And does inventory hold up?
Which three flows must reconcile?
| Flow | Source | What you post |
|---|---|---|
| Sales | Store platform (Shopify, WooCommerce), marketplaces (Amazon, bol) | Revenue per channel, VAT per country, discounts, shipping, returns |
| Cash | Payment providers (Stripe, PayPal, Mollie, Shopify Payments) | Clearing account per provider, fees, chargebacks, payouts |
| Purchases | Suppliers, purchase invoices, imports | Inventory, cost of goods sold, import VAT |
Sales and cash meet on the clearing accounts. Sales and purchases meet in gross margin. If either reconciliation fails, your profit cannot be trusted.
How does VAT work for an online store?
For a business established in the EU selling to consumers in other EU countries, a threshold of €10,000 per calendar year applies, across all those countries together. Below it you charge your home country's VAT. Above it you charge the VAT of the customer's country and report it quarterly through the One Stop Shop. The threshold applies from the sale that crosses it, not from the next year. More detail is in OSS VAT for EU e-commerce.
Three further questions come up. Sales to businesses in other EU countries with a valid VAT number are usually zero-rated and go on the EC sales list. Sales outside the EU are exports. And on a marketplace, the marketplace itself accounts for the VAT in some cases. Check for each channel who pays the VAT over.
How do you book a day of store sales?
- Revenue per country and rate from the store platform. As a daily total, with the order report attached.
- Payments per provider to the clearing account. The Stripe share to the Stripe clearing account, the PayPal share to PayPal, and so on.
- Split payouts. Each payout into sales, fees, refunds and chargebacks, then reconcile it against the bank. How to do that for Stripe is in Stripe payouts in your books, and for Shopify in reconciling Shopify sales to cash.
- Returns. As a credit note in the period of the return, with the VAT of the original sale.
- Inventory. The cost of goods sold as an expense, from the stock system or through a periodic adjustment.
Which numbers should an online store see every month?
| Number | How to calculate it | Why it matters |
|---|---|---|
| Gross margin | Revenue less cost of goods sold | Shows whether your products make money |
| Contribution margin | Gross margin less shipping, payment fees and marketing | Shows whether an order still earns after all variable costs |
| Return rate | Returns divided by revenue | High returns hit both margin and stock |
| Payment fees as a share of revenue | Provider fees divided by revenue | Differs sharply by payment method |
| Inventory days | Inventory divided by daily cost of goods sold | How much cash is tied up in stock |
A store with €2.4 million revenue and 48% gross margin keeps a contribution margin of 15% after shipping of 9%, payment fees of 2% and marketing of 22%, about €360,000 a year. Two percentage points more returns costs more than €20,000 of gross margin at this revenue, before the extra shipping. Without reliable books, you see that only in the annual accounts.
Where does it go wrong?
- Posting net. The payout booked as revenue, with fees and returns missing.
- Revenue counted twice. The store connection and the bank connection both post revenue.
- OSS too late. The €10,000 threshold crossed without anyone noticing.
- Inventory not adjusted. Purchases expensed straight away, so margin swings month to month.
- Gift cards as revenue. They are revenue only when redeemed.
- Currency. Sales in dollars or pounds paid out in euros, with no exchange result posted.
What about marketplaces?
If you also sell on Amazon or bol, a fourth source appears. A marketplace pays out after commission, advertising, shipping and returns, and sends a settlement report per period. Treat each marketplace as its own channel, with its own revenue account and clearing account. Post sales gross, commission and other costs to expense accounts, and reconcile the payout against the clearing account. You then see per channel what a sale earns after all costs, and that difference is often larger than expected.
How often should you close the books?
Monthly at the least. Many stores close weekly in peak season, because a problem with a payment provider or a VAT setting found in week two of December costs far less than one found in February. A weekly check of the clearing accounts, the payouts and the return rate takes an hour once the connections are right, and catches almost every expensive error early.
What do Thred's agents do for an online store?
For smaller stores there is Thred Ledger, Thred's own ledger. Shopify, Stripe, PayPal and Mollie are already connected, as are bank accounts through our open banking partner and purchase invoices that arrive by email. Every order, payment and payout is posted automatically and traceable to its source. 99.5% of 36,963 work units, such as bank classifications, journal entries and reconciliation links, were completed without a human change (measured 19 September 2026).
On Exact Online the same team works in your own administration. The Connector collects orders and payouts. The Bookkeeper splits, posts and reconciles. The Accountant watches the OSS threshold and prepares the VAT return. The Analyst shows each month what margin did per channel and why.
Frequently asked questions
How do you set up bookkeeping for an online store?
Create a revenue account per sales channel, a clearing account per payment provider, an expense account for payment fees and VAT codes per country if you sell above the OSS threshold. Connect your store platform and payment providers to your books. Agree that revenue comes from the store platform and cash from the provider.
When do I need the EU One Stop Shop?
Once your distance sales to consumers in other EU countries exceed €10,000 in a calendar year, across all those countries together. From then on you charge the VAT of the customer's country and report it quarterly through OSS in your home country.
Why don't my sales match what arrives in the bank?
Payment providers pay out net, after fees, refunds and chargebacks, and usually a few days later. Some payments also go through other providers. Post sales gross to a clearing account and reconcile each payout against it.
How do I book marketplace sales from Amazon or bol?
Marketplaces pay out after commission, fees and returns. Post the sales gross, the commission as an expense and the payout through a clearing account per marketplace, using the marketplace's settlement report as the source. Check whether the marketplace itself accounts for VAT on some sales.
How do I account for inventory in an online store?
Purchases of stock go to the balance sheet, not straight to expenses. When goods sell, the cost of those goods becomes an expense. Without a stock system, use a periodic adjustment based on a count.
Which accounting software suits an online store?
Any package with good connections to your store platform and payment providers works, such as Xero, Exact Online or Moneybird. What matters more is that payouts are split and VAT by country is right. For smaller stores, Thred Ledger does this itself, with Shopify, Stripe, PayPal and Mollie already connected.
Sources
- KVK, VAT rules for e-commerce in the EU (Dutch)
- Stripe, Payout reconciliation report
- Mollie, Settlement Report
- PayPal, Reports (developer documentation)
- Thred, method behind the 99.5% figure (36,963 work units, measured 19 September 2026)
- Thred Ledger, Thred's own ledger with bank, Stripe, Shopify, PayPal and Mollie data
Read next
- Reconciling Shopify sales to cash: orders, payment providers, payouts and refunds
- The Dutch VAT return: what can be automated, and what stays with you
- OSS VAT for EU e-commerce: when it applies, the €10,000 threshold, and how to book it
- SaaS finance: revenue recognition, subscriptions, deferred revenue and agents
- Getting messy exports into your books: how to clean CSVs from banks, webshops and payroll reliably
Where Thred comes in
Thred’s own general ledger, built for agents. Every transaction is booked as it happens, under your rules, and traceable back to its source.
