Home › Merge Guides › Etsy + TikTok Shop › Germany
Merge Etsy and TikTok Shop Sales Data for Tax Prep in Germany
At tax time you need total revenue by channel without hand-fixing each export's columns first. In Germany, that also means accounting for Mehrwertsteuer (VAT): VAT rates and EU distance-selling thresholds mean revenue often needs to be split by destination country, not just totalled.
Why Etsy and TikTok Shop exports don't line up
- Etsy: Sale Date, usually already in your local timezone; Item Total, Shipping, and Etsy fees as separate columns, before tax; a numeric Order ID shared by every item in the same order.
- TikTok Shop: an order creation time stamped in UTC; order amount, platform commission, and affiliate commission split into separate columns; a long numeric Order ID.
Neither export is built with Mehrwertsteuer (VAT) in mind, so getting from "two raw files" to "Germany-ready numbers" means normalizing dates/totals first, then applying your own Mehrwertsteuer (VAT) treatment on top of the merged total — not per platform separately.
How to merge them
- Set your target columns once in CSV Experts (Date, Channel, Order ID, Total, and a Currency column if you sell in more than EUR).
- Map the Etsy export, then the TikTok Shop export — each file shape is remembered after the first time.
- Export the merged sheet and apply your Mehrwertsteuer (VAT) treatment to the combined total.
FAQ
Does this upload my sales data anywhere?
No. Everything runs in your browser using JavaScript — your files are never sent to a server.
Does it work for more than two channels?
Yes. Add as many source files as you want; each distinct file layout is mapped once and remembered.