The system currency is the euro
The export requires the shop's system currency to be the euro. If it is not, every run stops and says so - before a file is created whose amounts are wrong.
Five fields for a foreign currency.
| Field | Content |
|---|---|
| Fields 1 and 3 | Amount and currency code: the invoice amount in its currency, for example CHF |
| Field 4 | Rate: the rate Shopware stored with the order, with six decimal places |
| Fields 5 and 6 | Base amount and base currency code: the same amount in euros |
If the invoice is in euros, fields 3 to 6 stay empty.
Rates below 1
A rate like 0.830000 is allowed: DATEV's import specification only forbids zero (Doc. 1003221), and DATEV's own sample file writes exactly such rates. An order in a foreign currency without a valid rate stops.
A conversion DATEV cannot read does not go out.
Rate too large or zero
Field 4 takes at most four integer places; after the decimal point the export rounds to six places. If one euro costs 10,000 units of the currency or more, or the rate rounds to zero, the run stops.
Incomplete conversion
Currency, rate and base amount belong together. If one of them is missing, the run stops.
No three-letter code
The currency code has to consist of three letters like the ISO code; a custom currency with a different abbreviation stops.
The batch's control total and the evaluation work with the euro amount of every line.
What gets asked about it.
Which exchange rate is used?
The one Shopware stored with the order - not the rate on the day of the export. That way the booking matches the invoice the customer received. Payment and refund are converted at this rate too, so the debtor balances in euros; the export does not book an exchange difference.
Do cost centre rules work in a foreign currency?
Yes. The rules match by tenant, sales channel, payment method, delivery country and tax rate - always the tax rate, never the exchange rate.
The other tax cases
OSS
An account per destination country or a collective account with a tax key; plus the delivery threshold.
Cash-basis taxation
Booked on the real payment date, with payments and refunds; OSS and EU business customers on the invoice date.
Small businesses
Revenue under § 19 UStG without tax and without a tax key.
EU business customers
Intra-community supply and reverse charge to companies with a VAT ID.
Outside the EU
Tax-free export, taxed deliveries outside the EU and the special case of Northern Ireland.
Credit notes and cancellations
General reversal or side switch, credit note, cancellation and the real refund.