On the import page of the Cash & Card module, you can import new bank and/or card transactions. Additionally, you will find an overview of all previously imported files. Hovering your mouse over a row will display the corresponding account numbers. By clicking on a row, you can download a PDF with the imported transactions. You can access this menu under Cash & Cards / Import.
This menu is not applicable to organizations that only work with
Spend Cloud Cards or bunq cards.
Import Bank Transactions
By clicking the 'Import Bank Transactions' button, you can import the file containing transactions for your bank accounts. You need to export an MT940 file from your online banking application, or for Rabobank users, a CAMT file can also be used. Then, you import this file into Spend Cloud. After the transactions are imported, you have the option to review them. Spend Cloud calculates the expected balance in the bank based on your last import. The imported file also provides a balance starting from the first transaction in the file. A comparison is made to check if they match. If you import a file containing transactions for a day that has already been imported or skipped, these won't match. Spend Cloud will display these entries in red and show the deviation. You now have the chance to abort the import and identify the cause.
Import Card Transactions
By clicking the 'Import Card Transactions' button, you can import the file containing transactions for your card accounts. First, you need to export a file of transactions from your card management application. Then, import this file into Spend Cloud. After the transactions are imported, you have the option to review them. If you import a file twice, you will receive an error message and those entries will be displayed in red.
Reverting an import
If a period has not been closed or exported yet, you can revert the import. You can do this by clicking on the rotating arrow at the end of a row. All transactions from this import will be removed from the records. This can be used if an import has been accidentally duplicated or if there were missing transactions, for example. However, it's better to prevent this in the initial verification. Reverting will undo the entire import.