Smart DATEV Importer
DATEV in. Clean journal out.
Smart DATEV Importer reads DATEV posting batch exports (Buchungsstapel) into a Business Central general journal — and tells you exactly which setup is missing for every line, before anything gets posted.
The problem
Your tax advisor or payroll provider works in DATEV. Your books live in Business Central. Every month a DATEV export arrives, and getting it into Business Central means Excel templates, retyping, or a journal that refuses to post.
And when it refuses, Business Central reports one error at a time. "VAT Posting Setup does not exist." Fix it, try again. Next error. Fix it, try again. At month-end, that loop costs hours.
The solution
Smart DATEV Importer checks the whole file before it imports anything. You get one clear list of everything that's missing: which account, which VAT combination, which dimension value, and on which line. Each finding links straight to the setup page where you fix it. Fix everything once, validate again, import.
How it works
- 1
Upload
Select the DATEV posting batch export file.
- 2
Map once
Link DATEV accounts to your G/L accounts, customers and vendors; DATEV tax keys to VAT posting groups; cost centers (KOST1/KOST2) to dimensions. Mappings are saved for next month.
- 3
Validate
See every missing or invalid setup per journal line, grouped by type, in plain language.
- 4
Import & review
Lines land in a standard general journal batch. You review and post with standard Business Central — nothing posts automatically.
Key features
- Reads the DATEV format natively: header record, debit/credit indicator, decimal comma, DATEV date format and character encoding handled for you.
- Line-by-line diagnostics: every problem is named, located and explained ("Line 47: no VAT Posting Setup for DOMESTIC / VAT19").
- A summary of everything missing, grouped by setup type, so you fix ten causes instead of chasing two hundred errors.
- One click from each finding to the right setup page.
- Reusable mappings for accounts, tax keys and cost centers.
- Review before posting: imports into a normal general journal, so your existing controls and approvals still apply.
- Works in every Business Central localization (W1), including a US or UK parent company consolidating a German subsidiary.
- Traceability: each journal line references the source file and line number.
- Fully documented, with a setup guide and a reference for every validation message.
Screenshots
Who it's for
- German subsidiaries of international groups running Business Central
- Companies whose tax advisor (Steuerberater) keeps the books or payroll in DATEV
- Monthly payroll journals exported from DATEV payroll
- Migrations from DATEV to Business Central (opening balances and history)
FAQ
Be first to try Smart DATEV Importer.
We'll send one email when it's live on Microsoft AppSource. No newsletter.