In an e-commerce company, the bank payout is only the final cash movement. Before that payout, the store may have recorded gross sales, discounts, returns, marketplace commissions, payment fees, VAT by customer country, shipping income, stock movements, and currency conversion. If those layers are not reconciled monthly, the owner can see cash in the bank while sales, VAT, and margin are all misstated.
Start with gross sales, not bank receipts
The first control is to separate gross turnover from payouts. A marketplace or payment provider often sends one net settlement after deducting fees, refunds, chargebacks, and reserves. Booking that settlement as revenue hides margin and makes VAT review unreliable.
- export gross order data from Shopify, Amazon, Etsy, WooCommerce, or the marketplace used by the company
- separate sales, refunds, discounts, shipping income, marketplace fees, and payment fees before posting
- match settlement reports to bank receipts and explain timing differences
- keep the report period clear when a payout covers orders from more than one month
This gives the accountant a defensible sales figure and gives the owner a cleaner view of margin by channel.
VAT, OSS, and customer country evidence
E-commerce VAT depends on what is sold, where the customer is located, whether the buyer is B2B or B2C, and whether OSS or IOSS is relevant. The accounting file should therefore include country evidence and the logic used by the store, not just the final VAT amount.
- review whether VAT rates are mapped by customer country and product type
- keep evidence for B2B VAT numbers, B2C country, refunds, and cancelled orders
- separate Estonian VAT returns from OSS/IOSS reporting where those schemes apply
- reconcile VAT reports from the store with accounting entries before filing deadlines
For fast-growing stores, I prefer a short monthly VAT review instead of a large correction exercise at year-end.
Stock, returns, and marketplace fees
Profit can look better than reality if stock and returns are not connected to accounting. A store that buys goods in advance needs a routine for purchase invoices, stock received, stock sold, damaged goods, write-offs, and returns in transit.
- connect purchase invoices to stock records and sales channels
- record returns separately instead of burying them in net sales
- classify marketplace commissions and payment fees consistently
- review foreign-currency gains and losses when sales or purchases are not in euros
The goal is not a complicated warehouse system for every small store. The goal is a monthly control that prevents sales growth from hiding margin leakage.
What the owner should review every month
A useful e-commerce month-end pack should be short. It should show whether sales, VAT, stock, and cash tell the same story. I would expect the owner to review these points before relying on the numbers:
- sales by channel, gross margin, returns, and main fee categories
- unreconciled payouts or payment provider balances
- VAT liabilities by return type and customer country where relevant
- stock movements, write-offs, and unusually old or negative stock positions
If the owner sees these four points each month, the accounting provider can resolve exceptions before they become tax or reporting problems.
When bookkeeping becomes advisory work
Routine bookkeeping can post documents and reconcile reports. Advisory work starts when the business model changes: new marketplace, new EU country exposure, imports from outside the EU, subscription bundles, dropshipping, or a shift from own store to platform sales.
- document the VAT treatment before launching a new country or sales channel
- check whether product bundles, digital goods, or mixed supplies need separate treatment
- agree how import documents and customs values will be stored
- review whether management reporting still explains cash, margin, and tax risk
These questions are cheaper to solve before the first month closes than after several months of mixed data.
A practical 30-day implementation plan
Treat the next month as a controlled clean-up cycle. Do not redesign everything at once; prove that the core reports can be reconciled and then add detail where the risk is real.
- week one: list all sales channels, payment providers, currencies, and VAT report sources
- week two: map gross sales, refunds, fees, payouts, and bank receipts for one month
- week three: reconcile VAT, stock, and payment provider balances before filing
- week four: review margin, unresolved differences, and the checklist for the next month
After one cycle, the owner should know whether the issue is missing data, unclear responsibility, or a service scope that is too narrow for the business model.
The most expensive e-commerce accounting problems usually start as small unreconciled differences between the store, payment provider, stock record, and VAT report.
Frequently asked questions
Should marketplace payouts be booked as sales?
No. A payout is usually net cash after fees, refunds, reserves, or timing differences. Accounting should start from gross sales and then reconcile the payout.
How often should an e-commerce company reconcile payment providers?
Monthly at minimum. High-volume stores may need weekly checks for unreconciled payouts, chargebacks, and reserves.
What documents should the owner send to the accountant?
Sales exports, marketplace settlement reports, payment provider statements, purchase invoices, stock reports, refund data, import documents, and explanations for unusual transactions. Related topic: Monthly Document Flow for an OÜ in Estonia.
Does every Estonian online store need OSS or IOSS?
No. It depends on sales model, customer countries, goods flow, and VAT status. Review the model before assuming that one VAT routine fits all sales. Related topic: What Really Drives Bookkeeping Fees in Estonia.
Official sources
Use these official pages to confirm VAT special-scheme and company filing rules before acting:
A good e-commerce accounting routine should explain cash, margin, VAT, and stock in the same month. If this topic is active in your company, compare it with our accounting services in Estonia or contact us before a small reconciliation gap becomes correction work.