Preparing accounting data imports: a DATEV, CSV, and XLSX checklist
Prepare DATEV, CSV, and XLSX accounting imports by defining the scope, mapping fields, checking totals, and validating a test run.
Quick answer
Prepare DATEV, CSV, and XLSX accounting imports by defining the scope, mapping fields, checking totals, and validating a test run.
Key takeaways
- A DATEV posting batch has a defined structure, but client identifiers, fiscal year, account length, reference fields, and tax keys still need to match the destination.
- Before anything is written, review detected columns, account and tax mappings, invalid rows, and possible duplicates.
- Compare record counts, period totals, material account balances, and open items with the source system.
Define the accounting cutover before choosing a file
An import starts with scope, not upload. Decide which period moves, which data is final in the old system, and when the new system becomes authoritative. Also distinguish master data, open items, opening balances, postings, and documents. A small representative test batch is safer than moving the entire archive at once.
DATEV, CSV, and XLSX need different checks
A DATEV posting batch has a defined structure, but client identifiers, fiscal year, account length, reference fields, and tax keys still need to match the destination. CSV and XLSX are more flexible, so delimiters, decimal symbols, date formats, and debit/credit semantics must be explicit. Remove decorative headings, empty rows, and manual subtotal lines from data tables.
Treat preview as part of the import
Before anything is written, review detected columns, account and tax mappings, invalid rows, and possible duplicates. A useful summary shows record count, period, total value, debit total, and credit total. Fix recurring mapping issues in the import profile rather than editing thousands of rows individually.
Reconcile the result
Compare record counts, period totals, material account balances, and open items with the source system. Include credits, reversals, partial payments, and foreign currency in the sample when relevant. Record the source file, mapping, execution time, and reconciliation result before declaring the cutover complete.
Sources and further information
Related workflows in accuno
These product pages show how accuno supports the workflows described in this guide.
Sources and further information
Editorial note
Prepared by the accuno Editorial Team and reviewed against the listed primary sources and the implemented product scope.
These articles provide general guidance and do not replace legal, tax, or business advice. Confirm your specific situation with a qualified professional.