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.
FX fees will not be exported automatically via the integration, this action needs to be performed manually.
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 export FX fees via the integration to DATEV UO: the impact is that financial accountants and tax advisors will have to manually create the payable line related to the FX fees in DATEV ReWe.
Spendesk cannot technically export payments to DATEV via API as this type of API access is provided to German banks only. As result, you have to manually import payments to DATEV using our CSV account statement.
Spendesk charges Foreign Exchange (FX) fees for payments that are made in foreign currency. You'll find these FX fees within our CSV account statement so that you can import them manually into DATEV.
Go to Settings > Company Wallet > Account statements.
Click on the download icon for the period that you want to export.
Select the format of the export (PDF, CSV, etc.)
Check your emails to download the document.
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.