> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.openfiskal.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Germany: How to set up the DATEV export for your tax firm

The DATEV export turns a month of Shopify POS sales, payments and cash movements into a DATEV posting batch (Buchungsstapel), a ZIP file your tax firm imports into DATEV. You set it up once with your tax firm, then create one export per month.

### Index

* [Before you start](#3-before-you-start)
* [Show your tax firm the example export](#3-show-your-tax-firm-the-example-export)
* [Fill in the setup](#3-fill-in-the-setup)
* [Create your monthly export](#3-create-your-monthly-export)
* [Before your tax firm imports the first month](#3-before-your-tax-firm-imports-the-first-month)

### Before you start

Everything happens on the “DATEV-Export” page of the OpenFiskal app. The menu item appears once one of your registers is at a location in Germany, or once your company details in OpenFiskal are German.

Setting up the export and downloading the example export are free. Creating your monthly exports requires [OpenFiskal Plus](https://www.openfiskal.com/pricing).

Most of the setup comes down to choices your tax firm makes, from the accounts to how returns and tips are booked, so forward them this guide and ask what they want you to enter.

### Show your tax firm the example export

The example export is a month of invented transactions, built like a real export, and you can download it before you’ve set anything up. On the “DATEV-Export” page, under “Export by month”, click “Download example export” and send the ZIP file to your tax firm, so they can see what they’ll receive.

### Fill in the setup

On the “DATEV-Export” page, click “Set up DATEV”. The setup has six sections, and the counter at the top goes up as you complete them. If a section still needs something, a warning at the top of it lists exactly what’s left.

Under every account field, OpenFiskal suggests an account number from your chart of accounts. Check the suggestions with your tax firm before you rely on them. Once the setup is complete, the button on the “DATEV-Export” page changes to “View setup”, which is where you make changes later.

**No accounts from your tax firm yet?** Click “Fill in placeholders” and confirm. OpenFiskal fills every account field with a common SKR03 account and adds placeholder consultant and client numbers, so you can create an export straight away. Any accounts you had already entered are replaced, but the previous setup stays in the history.

|| While placeholders are active, you’ll see a “Placeholders active” warning. Agree the setup with your tax firm and enter their consultant and client numbers before anything is imported into DATEV.

###### General settings

Start here: the chart of accounts you pick, SKR03 or SKR04, decides the account suggestions in every other section, and changing it later clears every account you’ve entered.

Enter the consultant and client number from your tax firm. Ask them how many digits their accounts have and set the “Ledger account length” to match, and change the start of the financial year if yours doesn’t begin on 1 January.

“Export mode” decides how detailed the batch is: “Per till closing (Z report)” summarises the postings for each till closing, split by till, payment account, revenue account and tax rate, while “Individual postings” exports every operation as its own posting. A change applies from the next export.

“Tax firm decisions” covers your legal form, the small business rule (§ 19 UStG), who tips belong to, the payment model and how a cancelled unpaid order is reversed. Each option is explained on screen, and your tax firm should choose. If they pick the “Clearing account” payment model, enter the clearing account below it. The receivables account takes whatever a customer leaves unpaid at the till.

Leave the “Export file” settings as they are unless your tax firm asks otherwise, since the defaults suit the DATEV import.

###### Till accounts

Give each register its own cash account. The DATEV setup calls registers tills and lists them by location, under their names in Shopify POS.

###### Revenue accounts

Enter one revenue account per VAT rate (19 %, 7 % and tax-free / 0 %), each with a cancellation account next to it. Below the table, choose whether returns are netted on the revenue account, as on the Z-report, or posted to a separate revenue reduction account per tax rate.

###### Payment accounts

The payment methods listed come from your till data, and each one needs an account except cash, which posts straight into the till’s cash account. Card payments go to a money-transit account (Geldtransitkonto) for each provider, so your tax firm can match every payout against your bank account. Exchanges don’t need an account either, because they post as a return plus a sale.

###### Special cases

Enter one account for gift cards and one for store credit, each covering sale, redemption and payout, plus an account for overpayments, which happen in rare cases when Shopify POS charges a card twice. Gift cards and store credit only become revenue when they’re redeemed.

###### Cash movements

Choose how cash put into or taken out of the drawer is booked:

* “Simple: all cash movements as cash in transit” posts every movement to one cash in transit account, whatever reason was recorded, and your tax firm clears it against the bank statement.
* “By reason” posts each reason recorded at the register to its own account, the safe included. You turn reasons on and define them in your Shopify admin, in the Point of Sale settings, and your staff then pick one in Shopify POS every time they add or remove cash. A note isn’t enough: a movement without a reason, or with a reason that has no account, goes to a collective account for your tax firm to sort out, and it can’t be reassigned afterwards.

### Create your monthly export

“Create export” becomes available once all six setup sections are done, or once you’ve filled in placeholders.

1. Open OpenFiskal in your Shopify admin and click “DATEV-Export”.
2. Under “Export by month”, choose the month.
3. Click “Create export”. It’s usually ready within a minute.
4. Download the ZIP file from the “Exports” list.
5. Send it to your tax firm, who imports it into DATEV.

Every export stays in the “Exports” list, together with the version of the setup it was built from, so you can download it again at any time.

### Before your tax firm imports the first month

The export contains each month’s cash movements but not the till’s cash balance. So the first time your tax firm imports a till, including any register you add later, they book its opening balance once: the cash counted when the month’s first session was opened, as shown on that month’s first Z-report. Send them that Z-report with the export. You’ll find it under “Z-Reports” in the OpenFiskal app, as described in [How to do your daily closing and get your Z-report](https://help.openfiskal.com/en/article/how-to-do-your-daily-closing-and-get-your-z-report-10bcghd/#3-find-your-z-reports).

||| From then on, DATEV carries the balance forward by itself, as long as every month is imported exactly once and without a gap.

What the export covers, and how it compares with Pathway, is in [All FAQs regarding the DATEV export](https://help.openfiskal.com/en/article/all-faqs-regarding-the-datev-export-1kyfmz/). If something still isn’t working, write to us at [hello@openfiskal.com](mailto:hello@openfiskal.com).