Ecommerce accounting fails when payout reports, order data and VAT evidence drift apart. Etsy combines orders, listing fees, transaction fees, payment fees and refunds in a way that can hide true sales. This guide covers Etsy payment account reconciliation for UK sellers that need clean software-ready records.

For wider context, use Integrations . If the topic affects a filing deadline, software choice or tax treatment, confirm the live position before acting. The workflow below is designed to keep the evidence in one place so the owner, bookkeeper and accountant can all review the same record.

Official point to verify

GOV.UK guidance explains that online marketplaces can be liable for VAT on certain goods sold to UK customers, so sellers need to separate marketplace VAT evidence from their own VAT decisions. Check the current wording in GOV.UK online marketplace VAT guidance before making a binding filing, software or tax decision.

What to control

AreaControlWhy it matters
Payment accountDownload the detailed Etsy payment reportSummary deposits are not enough
Fee typesSeparate listing, transaction and payment feesCosts need clear categories
VAT evidenceReview Etsy tax and VAT information by saleMarketplace treatment can vary
Bank matchAgree deposits to the payment account balanceOld differences should clear

Review routine

Reconcile by settlement, not just by bank receipt. Match orders, refunds, fees, reserves, currency differences and VAT evidence to the payout report, then post the net bank movement only after the gross entries make sense.

A useful review note should answer three questions: what source evidence was used, what judgement was applied, and who approved the treatment. Keep that note beside the transaction or period report rather than in a separate inbox.

Common mistakes

  • Posting deposits as turnover
  • Treating all Etsy fees as one unexplained charge
  • Not checking marketplace tax columns

The best prevention is a short, repeated checklist. If a control is too complicated to run every month or quarter, it will probably fail when the deadline is close.

How ReAI helps

ReAI can keep marketplace data, bank imports and review notes together, making it easier to explain each payout and pass the file to an accountant without separate spreadsheets. For hands-on help with setup, see Accounting Assistance for Small Businesses .

Summary

Treat Etsy payments fees VAT reconciliation as a recurring accounting control, not a one-off admin task. Put the source data, review owner, exception list and submission evidence in the same system before the deadline arrives. That makes compliance work easier to check and much less dependent on memory.