Thred

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.

Book a demo

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?

The three flows of an online store and their source
FlowSourceWhat you post
SalesStore platform (Shopify, WooCommerce), marketplaces (Amazon, bol)Revenue per channel, VAT per country, discounts, shipping, returns
CashPayment providers (Stripe, PayPal, Mollie, Shopify Payments)Clearing account per provider, fees, chargebacks, payouts
PurchasesSuppliers, purchase invoices, importsInventory, 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?

  1. Revenue per country and rate from the store platform. As a daily total, with the order report attached.
  2. Payments per provider to the clearing account. The Stripe share to the Stripe clearing account, the PayPal share to PayPal, and so on.
  3. 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.
  4. Returns. As a credit note in the period of the return, with the VAT of the original sale.
  5. 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?

Key monthly numbers for an online store
NumberHow to calculate itWhy it matters
Gross marginRevenue less cost of goods soldShows whether your products make money
Contribution marginGross margin less shipping, payment fees and marketingShows whether an order still earns after all variable costs
Return rateReturns divided by revenueHigh returns hit both margin and stock
Payment fees as a share of revenueProvider fees divided by revenueDiffers sharply by payment method
Inventory daysInventory divided by daily cost of goods soldHow 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

  1. KVK, VAT rules for e-commerce in the EU (Dutch)
  2. Stripe, Payout reconciliation report
  3. Mollie, Settlement Report
  4. PayPal, Reports (developer documentation)
  5. Thred, method behind the 99.5% figure (36,963 work units, measured 19 September 2026)
  6. Thred Ledger, Thred's own ledger with bank, Stripe, Shopify, PayPal and Mollie data

Read next

Where Thred comes in

Thred Ledger

Thred’s own general ledger, built for agents. Every transaction is booked as it happens, under your rules, and traceable back to its source.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo