Import Cash & Card entries

Import Cash & Card entries

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.


    • Related Articles

    • Cash and bank links

      This article applies if your organization does not have a link with the bank bunq or is you do not use Spend Cloud Cards. It is possible to create links in Spend Cloud between bank books and cash books. By linking one or more cash books to a bank ...

    • Configuration settings for Cash & Card

      In the menu section Configuration Settings / Cash & Card, you will find settings that apply to the Cash & Card module. Also, read this article for more information on configuration settings. Make sure you understand what each setting does before ...

    • How does the Cash & Card module within the Spend Cloud work?

      Expenses made with cash, card transactions, and online payments are often small-scale and occasional expenditures that occur outside the scope of a Purchasing Department. Cash expenses are recorded in the cashbook, while card expenses are already ...

    • Coding entries

      All transactions made with your Spend Cloud card or bunq card are immediately displayed in Spend Cloud. You can find these transactions in the book linked to your card. You can view the transaction book on your computer in the Cash & Card / Entries ...

    • booking a cash difference

      Some organizations deal with cash transactions. The cash is recorded in the Spend Cloud system in a cash book or a combined card book. Based on the income and expenses you enter, Spend Cloud keeps track of how much cash you have on hand. Many ...