Home › Merge Guides › Squarespace + BigCommerce › Germany

Merge Squarespace and BigCommerce 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 Squarespace and BigCommerce exports don't line up

Squarespace: a Date column in ISO-like format; Subtotal, Discount, Shipping, and Total as separate columns; an Order ID that's a short alphanumeric code.
BigCommerce: an Order Date column that includes a full timestamp; Subtotal and Grand Total both included, which are easy to mix up when mapping; a 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 Squarespace export, then the BigCommerce export — each file shape is remembered after the first time.
Export the merged sheet and apply your Mehrwertsteuer (VAT) treatment to the combined total.

Merge your files now →

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.

Other countries for Squarespace + BigCommerce

← Back to CSV Experts