Payments are not exported automatically via our native integration with DATEV UO. To export your payments you need to use our CSV bank journal to upload settlements in DATEV via the Batch Processing module and automatically offset open positions.
Important notes:
It is possible to include settlements that have already been exported by checking the corresponding checkbox on Spendesk.
Exporting payments with prepared payables
On Spendesk, go to Settings and set up your Spendesk bank account and your wallet funding account.
On Spendesk, go to Bookkeep > Export, select the period needed and download your CSV bank journal.
On DATEV, go to DATEV ReWe 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).
Exporting FX fees
FX fees will be exported in the bank journal, but we will not create an invoice for FX fees via the integration to DATEV UO.
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.
We created a dedicated video to import CSV files in MS Excel to preserve leading zeros.