Getting Started With FBA Buch
FBA Buch is the German term for the workbook system you use when running an FBA business through Germany or selling into the German market from within the EU. It covers purchase orders, inventory management, COGS tracking, VAT calculations, and the reconciliation work you need to hand to your Steuerberater at the end of the quarter. If you're running FBA from Germany, you can't really skip it. The tax authority expects it. The way most sellers actually work this isn't complicated, but it is manual and unglamorous. You open your workbook spreadsheet — whether it's your own build or a premade template — and you start by logging every purchase you make for inventory. Supplier name, invoice number, ASIN, quantity ordered, unit cost, shipping cost allocated per unit, and the date the goods actually arrived at the Amazon warehouse. Then you log outbound sales. Amazon sends you a settlement report roughly every 14 days. You match those line items back to your purchase records, calculate COGS per ASIN, and then run the VAT math on the margins. I built my own workbook in Google Sheets years ago because I couldn't find anything that handled partial refunds correctly. The one catch is that Amazon sometimes sends returns that you can't easily match to a specific FNSKU. I spent about three months dealing with mismatched return line items in my spreadsheet before I wrote a simple script that cross-referenced the seller ID against the buyer order ID and flagged anything that didn't reconcile within 48 hours. That script cut my reconciliation time from about four hours a week down to maybe forty minutes.
What Most People Get Wrong
The biggest mistake I see isn't the math. It's the timing. People wait until March or April to think about their quarterly VAT. By then they've got twelve weeks of Amazon settlement reports buried somewhere in their email and they're trying to remember which shipment went to which warehouse. Start the workbook on day one. Log purchases the same week you place the order. Match settlements to invoices within 48 hours of receiving the report. The difference between a clean quarter and a panicked scramble is usually just two weeks of consistent habit. Another thing nobody warns you about: storage fees. Your workbook needs a column for monthly FBA storage costs so your Steuerberater can see the full picture. Amazon's report shows them separately, but a lot of sellers forget to include them in their COGS summary. If you leave them out, your margin numbers are wrong and your VAT calculation will be off.
Where to Get a Workbook Template
There are several options depending on how much you want to spend. There's the Helium 10 FBA Buch Template, which is a decent starting point if you're doing under €50k in annual revenue. It handles COGS and basic VAT but doesn't account for reverse logistics or import duty calculations if you're sourcing from outside the EU. The Amazon Seller Buch Workbook from the German freelance tax scene is more thorough — it includes columns for incoming goods receipts (Wareneingang), shipping cost allocation, and a quarterly summary sheet that maps directly to your USt-IdNr. filing. It costs around €29 one-time. If you're comfortable with spreadsheets, I'd recommend building your own rather than buying someone else's. A custom workbook takes about six to eight hours to set up properly, but it will exactly match how you source and sell. That matters when you're reconciling during an audit. Third-party templates tend to assume a certain selling pattern and when yours doesn't match — and most sellers' patterns don't — you end up spending more time working around the template than you save.
Get the Full Details
When FBA Buch Doesn't Work
Let's be honest about the limitations. A spreadsheet-based workbook breaks down fast once you're moving more than 200 units per month across ten-plus SKUs. The manual matching becomes error-prone. At that scale, you should be looking at software like ScoreKeeper or Zoho Inventory with a Germany tax module. Those tools auto-import from Amazon and generate the kind of reports your Steuerberater actually wants to see. There's also the issue of digital goods and subscription products. FBA Buch assumes physical inventory movement. If you're selling anything non-physical through FBA — which is rare but happens — the whole workbook structure needs adjusting. You'll need to handle it separately and merge the numbers manually.
The Bottom Line
FBA Buch is not optional if you're registered for German VAT as an FBA seller. It's the bridge between what Amazon reports to you and what the Finanzamt expects. The simplest version works fine for small operations. The more serious you get, the more you'll outgrow a spreadsheet. Start with a basic workbook, keep it updated weekly, and don't wait until tax season to figure out what your margins actually look like. Your future self and your tax advisor will thank you.
