Tax and GST

Side hustle VAT records for an online seller selling across Europe

Side hustle VAT records for a Europe-based online reseller: log buyer country, order number, net, VAT and gross in euros, and reconcile with payouts.

Editorial illustration for Side hustle VAT records for an online seller selling across Europe

If you sell online to buyers in more than one European country, your VAT records need one extra column that a local seller never thinks about: where the buyer is. Log the order number, buyer country, net price, VAT charged and gross for every sale, then compare with platform payouts. What applies to you depends on your country and your sales, so check with the tax authority or an adviser; this is only the record-keeping.

Why the buyer's country is worth a column

Two orders for the same €30 item can carry different VAT treatment depending on where the buyer lives and how you sell. You do not need to know the rules to record the fact. If the country is in the row, an adviser can apply the correct treatment afterwards, even for months you have already closed.

What each row should hold

  • Order number from the platform or your own numbering.
  • Date of sale and date of shipping.
  • Buyer country.
  • Net price, VAT charged, gross price, in euros.
  • Platform fee and payment fee, as separate rows or columns.
  • Payout reference, so you can tie sales to money received.

A small example with invented orders

OrderCountryNetVATGross
1001Home country€25.00€5.25€30.25
1002Neighbour country€25.00€4.75€29.75
1003Home country€60.00€12.60€72.60
TotalMixed€110.00€22.60€132.60

Rates in this table are made up to show different VAT lines. Check: 25 plus 25 plus 60 gives €110 net; 5.25 plus 4.75 plus 12.60 gives €22.60; and 110 plus 22.60 is €132.60. Because the platform may deduct its fee before paying you, the payout will be lower than gross, and that is why you also record fees.

How do I match platform payouts to orders?

Download the payout report, which usually lists orders and fees, and tick each order against your register. Any order that is in your register but missing from payouts is a held or refunded sale. Add a refund row with a negative net and VAT amount, dated on the refund, rather than deleting the original.

What should I do about returns?

Log a return as its own row linked to the original order number. A €25 net item returned gives net minus €25 and VAT minus the matching amount. If only part of the order was refunded, calculate both pieces yourself and note it.

It also helps to keep a short notes column for oddities: a lost parcel, a buyer who asked for a corrected invoice, a customs form that was requested. Those notes are what make an old row understandable to someone else, or to you in a year.

What if I sell through two platforms and my own site?

Keep one register, not three, with a column for the channel. The temptation is to keep each platform's own report as the record, but reports use different layouts and can disappear when an account is closed. Copy the essential columns into your own sheet every month and keep the original export beside it as a backup. Then a change in one platform never leaves a hole in your history.

A simple monthly close

  1. Add every order from the platform export.
  2. Add refunds and returns.
  3. Add platform and payment fees.
  4. Check that net minus fees equals what reached your bank, after allowing for pending payouts.
  5. Save the export and the register for that month.

SpendixAI has GST and ITC-style category flags but is built around India and INR, so it is not designed for euro sales or European VAT.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports