Until now, to match settlements with payables on DATEV, Financial accountants had to match them based on the gross amount and the description of transactions, which was very painful. Our new Bank journal feature is now available for Spendesk DATEV users! 😊
Go to Settings>Accounting and set up your Spendesk bank account and your Wallet funding account.
Go to Spendesk > Bookkeep > Export, select the period needed and download your CSV bank journal.
Go to DATEV > Kanzlei Rechnungswesen and upload your CSV bank journal via the Stapelverarbeitung module.
Exporting payments with unprepared payables
It is possible to include those payments whose corresponding payables have not yet been prepared in your bank journal by checking the corresponding checkbox. By default such payments are not included in the bank journal.
Another type of payment not included on the bank journal is payments made outside Spendesk (via an external bank).
What about settlements that have already been exported?
It is possible to include settlements that have already been exported by checking the corresponding checkbox.
What about FX fees?
FX fees will be exported in the bank journal, but we won’t export FX fees via API to DATEV Unternehmen Online ➡️ the impact is that financial accountants / tax advisors will have to manually create the payable line related to the FX fees in DATEV Kanzlei Rechnungswesen.
Retaining leading zeros when editing CSV files
When importing CSV files into programs like MS Excel leading zeros of dates are lost. This is because MS Excel interprets imported data as numbers and drops leading zeros. When importing a date like "010922", MS Excel assumes it is a number and displays it as "10922", which cannot be accepted by DATEV.
In order to avoid this side effect it is important to manually change the column type to "text" during the import process in MS Excel.
Do this for every column that should retain leading zeros, typically dates and account numbers:
You can find additional information in the DATEV Help Center (in German).