Exporting a DATEV posting batch (Premium)
How to assign categories to accounts with your tax advisor, create a DATEV file from a fiscal year’s ledger and test it in a test client.
FinancesPremiumChecked on 09.11.2026
Prerequisites
- Your club has Premium (feature “DATEV export”). Export as Excel, CSV and PDF stays free.
- You have “View finances” or “Manage finances” directly in the club.
- The fiscal year’s entries are recorded in the ledger (or the cash book).
- Your tax advisor knows the advisor number, the client number and the ledger accounts.
Who may do this?
Reading and exporting (including DATEV): “View finances” or “Manage finances”, directly in the club, not via the association. Everyone else does not see the page. Every export is logged (only year and row count, no amounts).
Step by step
Save the mapping table for your tax advisor
Open “Club life”, switch to “Leadership” and choose “Non-profit status” in “Money and funding”. Select the “Fiscal year” and the “Annual statement” tab. At “DATEV posting batch” click “Open”, then “Save table for the tax advisor”. You get a CSV file with the eight categories (income and expense per sphere), the SKR 42 sphere code (to be confirmed by the tax advisor) and the note “used in the year”.
Have the tax advisor fill in the accounts
Your tax advisor enters in the column “Account (tax advisor)” which ledger account each category belongs to. CLUP.life deliberately suggests no account numbers and does not post: the chart of accounts (for example SKR 42) is up to the tax advisor.
Enter the master data
Enter “Advisor number”, “Client number” and the “Length of ledger accounts” (default 4), plus the “Bank or cash account”. If you use the cash book you can add a separate “Cash box account (if different)” and “Bank account (if different)” for its entries. Accounts consist of digits only.
Enter the account for each category
Copy the accounts from your tax advisor into the fields “Income: …” and “Expense: …” of the four spheres (ideal sphere, asset management, purpose-related operation, commercial operation). Every category that occurs in the year needs an account; the column “used in the year” in the table shows which ones.
Create the file
Click “Create DATEV file”. The file “EXTF_Buchungsstapel_<year>.csv” is saved. It contains the year’s ledger entries: income as debit, expenses as credit, without tax-code key. From the cash book the receipt number (as document field 1) and cost center are included. Transfers to reserves and reversed entries are left out on purpose.
Check it in a test client
Have your tax advisor read the file into a test client first, before you book for real. The format was checked against DATEV’s public description, but the format version and column order from column 15 have not yet been compared with a test client. CLUP.life transmits nothing to DATEV or the tax office: the tax advisor imports the file.
You can find the feature here: /organisation/<verein>/vereinsleben/gemeinnuetzigkeit
Common errors and solutions
- “The ledger account is missing for some areas. Enter them or ask your tax advisor.”
- A category with entries in the year has no account. Look at the column “used in the year” in the table and enter the missing accounts.
- “The DATEV export is part of Premium. Export as Excel, CSV and PDF stays free.”
- The club does not have Premium. Meanwhile use the Excel, CSV or PDF export in the annual statement; it contains the same figures.
- An account field reports “Digits only”.
- Enter the account as a plain number, without dots, spaces or letters.
- An expected entry is missing from the file.
- Transfers to reserves are not a cash flow and reversed entries do not count: neither is in the batch.
- The tax advisor reports differences when importing.
- Send the tax advisor’s message to support. The format has not yet been compared in every detail with a test client.
Good to know
- The export is data preparation, not tax advice and not posting. Responsibility for accounts and assignment stays with the club and its tax advisor.
- The file uses Windows-1252 encoding, a semicolon as separator and a decimal comma.
- There is no totals column: everything is derived from the individual ledger entries, as with the income statement and the cash book.