Import your DATEV export into Layerz | German ledger to model

Why import DATEV

If your Steuerberater keeps your books, they keep them in DATEV. That export is the most complete record of your German entity's actuals. But like any ledger, it is a raw file, not a model you can plan on.

Layerz maps your DATEV accounts to a structured P&L and balance sheet, lands them as actuals, and lets you reforecast and export without rebuilding a spreadsheet each month.

The normalised CSV looks like this:

date,account,label,amount
2024-03-06,4400,Umsatzerlöse Kunde A,1234.56
2024-03-15,6300,Wareneingang Material,-450.00

What you get

A structured German P&L and balance sheet mapped from your DATEV accounts.
Actuals vs plan on one reusable structure.
Reforecast on real numbers, month after month.
Audit-ready Excel. Export any time. Never paywalled.

Honest limits

Raw EXTF is not yet a drop-in. Today DATEV imports through a normalised CSV (converter step above). Native EXTF detection inside the parser is on the roadmap.
SKR03 mapping template is coming. SKR04 is supported now. Importing an SKR03 file against SKR04 mis-routes accounts, so match the chart your books use.
It is a file import, not a live sync.

We are actively working toward native DATEV support. If DATEV is your workflow, get in touch and we will help you land your first import.

How to import DATEV

Get your DATEV export

Get your DATEV export from your accounting or Steuerberater (the EXTF Buchungsstapel).

Normalise to CSV

Today, convert it to a simple normalised CSV with four columns (date, account, label, amount). This merges the DATEV Umsatz and Soll/Haben sign flag into one signed amount and parses the German date and decimal-comma formatting.

Import the CSV

Import the CSV in the Layerz web app, or hand it to Claude via the MCP plugin.

Apply the SKR04 template

Apply the SKR04 mapping template (SKR03 coming) to route accounts to the right P&L and balance-sheet lines.

Land the actuals branch

Land it as an actuals branch.

DATEV files use the German chart of accounts. SKR04 (Abschlussgliederung) is supported today; SKR03 (Prozessgliederung) mapping is on the roadmap. The same account number means different things across SKR03 and SKR04, so import against the chart your books actually use.

FAQ

Can I import a raw DATEV EXTF file directly?

Not yet. Today you normalise it to a simple CSV first (see the steps). Native EXTF parsing is on the roadmap.

SKR03 or SKR04, which do I pick?

The one your books use. They are different charts and the same account number maps differently, so the choice is not cosmetic. SKR04 is supported now; SKR03 is coming.

Can Claude help with the DATEV import?

Yes. With the Layerz MCP plugin, Claude can take the normalised CSV, map the accounts and branch the actuals for you.

Is it free?

Yes. Importing a file and exporting Excel are on the free plan.