How the e-VATAX conversion system works: Logic Bridge Key, Amazon Markets Logic, sales & expense ledgers, VAT treatment, routing tables and the EU VAT rates reference. For new trainees.
e-VATAX operates three in-house converters that transform raw Amazon reports into ready-to-import DATEV Buchungsstapel (format 125 / v700) files:
| Converter | Input | Output | Purpose |
|---|---|---|---|
| Settlement → DATEV | Amazon settlement .txt files (tab-delimited, per marketplace) | DATEV EXT / ASCII CSV | Books every money movement: sales, fees, refunds, payouts, reserves |
| VTR → DATEV | Amazon VAT Transaction Report (.csv/.txt) | DATEV EXT / ASCII CSV | Books revenue to the correct VAT ledger with BU-Schlüssel and EU-Land |
| Invoice PDFs → DATEV | Amazon invoice PDFs | DATEV EXT / ASCII CSV | Books Amazon fee invoices to the correct expense ledger |
Every conversion is driven by lookup tables stored in our database, editable in the admin panel (Admin → Lookup Tables). No account number is hardcoded — if Amazon introduces a new transaction type, we add one row to a table and re-run. The tables can be exported/imported as JSON backups to sync environments.
| Table | Rows | Used by | What it maps |
|---|---|---|---|
| Logic_Bridge_Key (LBK) | ~156 | Settlement Converter | transaction-type / amount-type / amount-description → routing key |
| Amazon Markets Logic (ML) | 14 | Settlement Converter | Marketplace → Debitor, Creditor, Transit and special accounts |
| VTR Routing Logic | 7+ | VTR Converter | Routing_Code → Konto, BU-Schlüssel, EU-Land type, S/H direction |
| Invoice Routing | 10 | Invoice Converter | Amazon invoice type → expense Konto + BU |
Every settlement row carries three identifying fields: transaction-type (Order, Refund, other-transaction…), amount-type (ItemPrice, ItemFees…) and amount-description (Principal, Tax, Commission…). The LBK table maps each combination to one routing key:
Order / ItemPrice / Principal → Debitor Order / ItemPrice / Tax → Debitor Order / ItemFees / Commission → Creditor Order / ItemFees / FBAPerUnitFulfillmentFee → Creditor other-transaction / FBA Inventory Reimbursement / WAREHOUSE_LOST → Adjustment_Reimbursement
Current distribution of our ~156 LBK rows by routing key (snapshot, June 2026):
| Routing Key | LBK rows | Meaning |
|---|---|---|
| Creditor | 72 | Amazon fees → marketplace Creditor account |
| Debitor | 30 | Sales revenue → marketplace Debitor account |
| Adjustment_Reimbursement | 24 | Reimbursements / adjustments → 4760 |
| Debt_Adjustment | 10 | Cross-marketplace debt transfers → 1592 (nets to zero) |
| WithheldTaxVAT | 7 | Marketplace Facilitator VAT → 1754 |
| non_invoiced_Amazon_Fee_without_VAT | 5 | Non-invoiced fees, no VAT → 4765 |
| non_invoiced_Amazon_Fee_with_VAT | 2 | Non-invoiced fees with Vorsteuer → 4766 + BU 9 |
| Shipping_Label_Buy_Fee | 2 | Shipping label purchases → marketplace Creditor |
| Reserve_Amount | 2 | Amazon reserve balance → 1591 |
| BANK-DEPOSIT | 1 | Settlement header row, positive payout → 1361 |
| LBK Key | SKR03 | SKR04 | What it represents |
|---|---|---|---|
| Debitor | 30005 (DE), 30006 (FR)… | 10005, 10006… | Sales revenue — customer receivable |
| Creditor | 80005 (DE), 80006 (FR)… | 70005, 70006… | Amazon fees — Amazon payable |
| TRANSIT | 1365 (DE, per marketplace) | 1465 | Always the Konto side for every booking |
| BANK-DEPOSIT | 1361 | 1461 | Bank payout — positive total-amount |
| BANK-CHARGE | 1730 | 1830 | Credit card charge — negative total-amount |
| Reserve_Amount | 1591 | 1691 | Amazon's reserve balance |
| Debt_Adjustment | 1592 | 1692 | Cross-marketplace debt transfers — always nets to zero |
| WithheldTaxVAT | 1754 | 1854 | Marketplace Facilitator VAT |
| Adjustment_Reimbursement | 4760 | 6760 | Reimbursements and adjustments |
| non_invoiced_Fee_without_VAT | 4765 | 6765 | Non-invoiced fees, no VAT |
| non_invoiced_Fee_with_VAT | 4766 + BU9 | 6766 + BU9 | Non-invoiced fees with VAT (Vorsteuer) |
| DPD_Hermes_DHL_Fee_with_VAT | 80100 + BU9 | 70100 + BU9 | Shipping label costs with VAT |
| UNMAPPED | 9998 | 9998 | Unknown — review needed |
The marketplace is detected from the settlement file name. The ML table then supplies every account for that marketplace. Current snapshot:
| Marketplace | Code | Debitor | Creditor | Transit |
|---|---|---|---|---|
| AMAZON.IT | IT | 30003 | 80003 | 1363 |
| AMAZON.ES | ES | 30004 | 80004 | 1364 |
| AMAZON.DE | DE | 30005 | 80005 | 1365 |
| AMAZON.FR | FR | 30006 | 80006 | 1366 |
| AMAZON.NL | NL | 30007 | 80007 | 1367 |
| AMAZON.COM.BE | BE | 30007 | 80007 | 1367 |
| AMAZON.SE | SE | 30008 | 80008 | 1368 |
| AMAZON.PL | PL | 30009 | 80009 | 1369 |
| AMAZON.IE | IE | 30010 | 80010 | 1590 |
| AMAZON.COM.TR | TR | 30011 | 80011 | 1590 |
| AMAZON.CO.UK | UK | 30012 | 80012 | 1368 |
| AMAZON.COM.CZ | CZ | 30013 | 80013 | 1369 |
| AMAZON.AE | AE | 30014 | 80014 | 1369 |
| NON-AMAZON DE | DE | 30005 | 80005 | 1365 |
Accounts shared by all marketplaces (same ML table, identical per row):
| Purpose | Account | Notes |
|---|---|---|
| Reserve Amount | 1591 | Amazon's security reserve hold-back |
| Withheld Tax VAT | 1754 | Marketplace Facilitator VAT |
| Bank Deposit | 1361 | Positive settlement payout |
| Bank Charge (credit card) | 1730 | Negative settlement — card charged |
| Commingling VAT | 1770 | Always cancels to zero |
| Adjustment / Reimbursement | 4760 | Lost/damaged inventory reimbursements |
| Debt Adjustment | 1592 | Cross-account transfers — nets to zero |
| Non-invoiced fee without VAT | 4765 | Storage, inbound transport, removals |
| Non-invoiced fee with VAT | 4766 | With Vorsteuer — BU 9 |
| UNMAPPED | 9998 | Review required — never deliver with 9998 rows |
Revenue is booked by the VTR converter, never by the settlement converter. Which sales ledger a transaction hits depends on departure country, arrival country, tax scheme and whether the buyer has a VAT number:
| Ledger (SKR03) | Name | VAT treatment | When used |
|---|---|---|---|
| 8400 | Erlöse 19% MwSt | 19% German VAT — automatic account | DE→DE domestic; EU warehouse→DE regular (BU 290) |
| 8300 | Erlöse 7% MwSt (Reduced Rate) | 7% German VAT — automatic account | DE domestic sales of reduced-rate products (food, books, certain takeaway items). For OSS sales of such products, always check the destination country's own reduced rates (see section 11) |
| 8320 | Erlöse EU OSS | Destination-country VAT via OSS — needs BU 240/241/285 | All B2C cross-border EU sales under UNION-OSS |
| 8125 | Steuerfreie ig Lieferung | 0% — reverse charge, buyer declares VAT | B2B sale to EU business with valid VAT ID (ZM reportable) |
| 8120 | Ausfuhr / Export | 0% — outside EU scope | Exports outside EU; UK/CH where Amazon collects (VOEC) |
Amazon fees split into invoiced (booked against the marketplace Creditor, cleared later by the invoice receipt) and non-invoiced (booked straight to expense). The Invoice Converter additionally routes invoice PDFs by document type:
| Ledger (SKR03) | Used for | BU |
|---|---|---|
| 80003–80014 | Marketplace Creditor — invoiced Amazon fees (Commission, FBA, storage, EPR) | — |
| 4760 | Non-invoiced fees without VAT; reimbursements; Merchant VAT invoices | 9 / 0 |
| 4765 | Non-invoiced Amazon fees without VAT (settlement path) | — |
| 4766 | Non-invoiced Amazon fees with Vorsteuer (settlement path) | 9 |
| 4761 | Fulfillment by Amazon tax invoices & credit notes; EPR Pay-On-Behalf | 9 |
| 4730 | Merchant Buy Shipping Label | 9 |
| 4600 | Product Ads (Amazon Advertising) VAT invoices & credit notes | 9 |
| Amazon Invoice Type | Konto | BU |
|---|---|---|
| Fulfillment by Amazon Tax Invoice | 4761 | 9 |
| Fulfillment by Amazon Tax Credit Note | 4761 | 9 |
| Merchant VAT Invoice | 4760 | 9 |
| Merchant VAT Credit Note | 4760 | 9 |
| Merchant Buy Shipping Label | 4730 | 9 |
| EPR Pay On Behalf Service Invoice | 4761 | 9 |
| AGL Merchant Self Billing Invoice | 4760 | 9 |
| Product Ads VAT Invoice | 4600 | 9 |
| Product Ads VAT Credit Note | 4600 | 9 |
| Merchant Consolidated B-XML VAT Invoice | 4760 | 0 |
The settlement converter processes every uploaded file through ten deterministic phases:
Load & parse: read every tab-delimited settlement file, detect marketplace from the file name, stack all files into one dataset.
Normalise & filter: trim whitespace, drop junk/empty rows, standardise column names.
Number conversion: parse German decimal commas ("5207,79") into numeric amounts — DATEV output later uses F2 format without thousand separators.
Bank row flag: the single header row with a filled total-amount becomes BANK-DEPOSIT (positive), BANK-CHARGE (negative) or no booking (zero).
LBK merge: join each row on transaction-type / amount-type / amount-description against the Logic_Bridge_Key table. No match → UNMAPPED.
MarketsLogic lookup: translate the routing key into the actual account number for this marketplace (Debitor 30005 for DE, 30006 for FR…).
DATEV text fields: build Buchungstext (ORDER-PRICE-302-xxx…), Belegfeld1 and Belegdatum per row.
Group & sum: aggregate rows per order-id and account pair (Principal + Tax become one booking); zero-sum groups (commingling, debt pairs) disappear.
S/H direction, amount formatting and final DATEV 125 column order. Export as DATEV EXT or ASCII CSV.
The VTR converter classifies every transaction into a Routing_Code using this exact decision order (from our production code):
1. COMMINGLING_SELL / COMMINGLING_BUY → own codes by DE/EU direction 2. Marketplace collects VAT (UK, CH) → MARKETPLACE_COLLECTS 3. EXPORT_OUTSIDE_EU = YES or scheme = CH_VOEC → EXPORT_OUTSIDE_EU 4. B2B (BUYER_VAT_NUMBER filled), DE → EU → DE_EU_B2B_RC 5. B2B, EU warehouse → other country → EU1_EU2_B2B_RC 6. DE → DE → DE_DOMESTIC 7. DE → EU, scheme UNION-OSS → DE_EU_OSS 8. DE → EU, scheme REGULAR → DE_EU_REGULAR 9. EU → DE, scheme UNION-OSS → EU1_DE_OSS 10. EU → DE (otherwise) → EU1_DE_REGULAR 11. EU1 → EU2, scheme UNION-OSS → EU1_EU2_OSS 12. EU1 → EU1 (local) → EU1_EU1_LOCAL TRANSACTION_TYPE = REFUND → same code + "_REFUND" (S/H flipped)
The Routing_Code is then looked up in the VTR Routing Logic table — current snapshot:
| Routing_Code | Konto | BU-Schlüssel | EU-Land Type | S/H |
|---|---|---|---|---|
| DE_DOMESTIC | 8400 | — | — | S |
| DE_EU_OSS | 8320 | 240 | Bestimmung (destination) | S |
| DE_EU_B2B_RC | 8125 | — | Bestimmung (full VAT ID) | S |
| EU1_DE_OSS | 8320 | 285 | — | S |
| EU1_EU2_OSS | 8320 | 241 | Bestimmung (destination) | S |
| DE_DOMESTIC_REFUND | 8400 | — | — | H |
| DE_EU_OSS_REFUND | 8320 | 240 | Bestimmung (destination) | H |
Amazon fee invoices arrive as PDFs. The converter extracts invoice type, number, date and gross amount from each PDF (pdfplumber), then routes it through the Invoice Routing table (section 6) to produce one DATEV booking per invoice against the marketplace Creditor or the mapped expense ledger. Unrecognised invoice types route to 9998 for review — add the new type to the Invoice Routing table and re-run.
| BU | Meaning | VAT effect in DATEV | Where we use it |
|---|---|---|---|
| — (blank) | Automatic account tax key | Account splits VAT itself (8400 → 19%) | DE domestic sales |
| 9 | Vorsteuer 19% (input VAT) | DATEV extracts 19% input VAT from gross | Fee invoices, shipping labels, ads invoices |
| 0 | No VAT | No VAT extracted | Consolidated B-XML invoices |
| 240 | OSS — departure DE | Routes to OSS declaration, destination-country rate | DE warehouse → EU customer |
| 241 | OSS — EU cross-border | Routes to OSS declaration | EU warehouse → other EU country (and local EU1=EU1) |
| 285 | OSS — back to Germany | Routes to OSS declaration | EU warehouse → DE customer |
| 290 | Regular — EU warehouse → DE | German 19% on 8400 | Non-OSS FBA configuration |
OSS bookings collect VAT at the destination country's standard rate (unless the product qualifies for a reduced rate). Snapshot as of 2026 — verify against the EU TEDB database before relying on it for a filing:
| Country | Standard | Reduced rates | Super-reduced |
|---|---|---|---|
| Austria (AT) | 20% | 10%, 13% | — |
| Belgium (BE) | 21% | 6%, 12% | — |
| Bulgaria (BG) | 20% | 9% | — |
| Croatia (HR) | 25% | 5%, 13% | — |
| Cyprus (CY) | 19% | 5%, 9% | 3% |
| Czech Republic (CZ) | 21% | 12% | — |
| Denmark (DK) | 25% | — | — |
| Estonia (EE) | 24% | 9%, 13% | — |
| Finland (FI) | 25.5% | 10%, 13.5% | — |
| France (FR) | 20% | 5.5%, 10% | 2.1% |
| Germany (DE) | 19% | 7% | — |
| Greece (GR) | 24% | 6%, 13% | — |
| Hungary (HU) | 27% | 5%, 18% | — |
| Ireland (IE) | 23% | 9%, 13.5% | 4.8% |
| Italy (IT) | 22% | 5%, 10% | 4% |
| Latvia (LV) | 21% | 5%, 12% | — |
| Lithuania (LT) | 21% | 5%, 12% | — |
| Luxembourg (LU) | 17% | 8%, 14% | 3% |
| Malta (MT) | 18% | 5%, 7% | — |
| Netherlands (NL) | 21% | 9% | — |
| Poland (PL) | 23% | 5%, 8% | — |
| Portugal (PT) | 23% | 6%, 13% | — |
| Romania (RO) | 21% | 11% | — |
| Slovakia (SK) | 23% | 5%, 19% | — |
| Slovenia (SI) | 22% | 5%, 9.5% | — |
| Spain (ES) | 21% | 10% | 4% |
| Sweden (SE) | 25% | 6%, 12% | — |
Collect the period's settlement files (per marketplace), VTR file and invoice PDFs from Amazon Seller Central.
Run the Settlement Converter (Admin → Settlement to DATEV). Check the stats panel: row counts, unmapped count, empty Gegenkonto warnings.
If unmapped rows exist: download the unmapped report, identify the new transaction combination, add it to the LBK table, re-run.
Run the VTR Converter. Verify OSS amounts per destination country look plausible against last period.
Run the Invoice Converter on the PDF batch. Any unknown invoice type → add to Invoice Routing table.
Download DATEV EXT exports and import into DATEV Unternehmen Online.
Accounting-level DATEV errors (REW codes, open Creditor balances, reconciliation) are covered in the PAN-EU Accounting Guide, section 12. The errors below originate inside our conversion tooling:
| Symptom | Cause | Fix |
|---|---|---|
| Konto 9998 rows in the output | New Amazon transaction combination not in the LBK table | Read the Zusatz 7/8/9 columns → add the row to the LBK table → re-run |
| EPR rows land on 9998 | Period date inside amount-type not stripped before the join | Verify fnStripPeriod is applied to both raw data and the LBK table |
| Gegenkonto null for all rows | Case mismatch in the LBK join ("Debitor" ≠ "DEBITOR") | Verify fnNorm() is applied to the Logic_Bridge_Key column on both sides |
| Triple amount on 1730 | "Payable to Amazon" and "Successful charge" also routed to BANK-CHARGE | Map them to Debt_Adjustment (1592) in the LBK table |
| Wrong S/H on the bank row | Bank_Type mapping inverted | BANK-DEPOSIT → H, BANK-CHARGE → S |
| VTR amounts ~19% too low | Umsatz built from TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL (net) | Use the Gross_Amount (VAT_INCL) field |
Talk to the team or book a session to walk through a live conversion end-to-end.