Import of bank transactions with camt
and MT940 files.

Tutorial: Import bank transactions and automatically assign payments to open orders.

Content 

  1. Where do I get the payment files?
  2. Uploading the files
  3. Import window explained
  4. Checking and adjusting the transactions
  5. Confirm transactions
  6. Import transactions
  7. Finding imported transactions
  8. How to book a partial amount
Screenshot import window

Importing bank statements saves a lot of time. There is no need for manual entry, the accounting software learns with each import and assigns movements automatically. You confirm and check the proposals and then import everything with one click.

1. Where do I get the payment files?

Camt053/ camt054 or MT940 can be obtained from your financial institution via online banking. Sometimes an option must first be activated before the files are available.

Tip: we recommend importing just one month first instead of a longer period. CashCtrl already learns the allocations from the first import and automatically suggests them during the next import.

Screenshot of the Add dropdown menu for the booking import

2. Uploading the files

In the journal, select Add Import bookings. Then select the file or drag and drop it into the window and specify the destination account.

Optionally, check "Force sequence number". This will generate sequence numbers even if the software recognizes a reference. Confirm with Next.

Screenshot of the import of a camt file into CashCtrl

3. Import window explained

The bookings are opened in a new import tab. This tab remains open even after logout. This way, the import can be interrupted and continued later. The listed transactions are not yet imported into the accounting, this happens later with the confirmation.

CashCtrl marks recognized bookings and information in green. With each new file and assignment, the software can better assign and automatically recognize customers, notes or regularities.

For example, if a customer transfers without giving the invoice number, CashCtrl can still assign the transfer with the date, name, etc.

Screenshot of the import window when importing Camt files

4. Checking and adjusting the transactions

By clicking on processing the edit dialog opens. On the left side there is the raw data as it is contained in the bank file. On the right side are the information that will be imported into CashCtrl. At the bottom left you can see how many transactions are contained in the file.

It is best to try out which procedure is the most suitable. It is recommended to use the description field as a starting point. It serves as a search field for all information like business partner, order, invoice number etc.. Auto-complete will then fill in debits and credits directly and only the business partner(s) will need to be adjusted.

Screenshot of the processing of a booking with raw data on the left and recognized fields on the right

5. Confirm transactions

If a booking is confirmed, it is highlighted in green. This can only be done manually, so the final control is up to the user. It is possible to select several lines and confirm them as a whole. CashCtrl then automatically jumps to the next line and on to the end of the list.

After correctly assigning the entry, the balance is no longer displayed in red, but in black. However, it is possible that there are still red numbers in the import window. This is because in the Camt file the entries are not always sorted by date. It is simply important that the balance matches with the last entry.

Important note: The balance in the example (right column in the screenshots) is always red, because it is a demo-camt file.

Screenshot of the processed bookings before performing the import

6. Import transactions

Once all bookings have been confirmed, they can be imported with fa-arrow-right import confirmed bookings. Only now will the bookings be imported into the system. If no more entries are available, the import tab is closed.

It is also possible to import only single entries from a document. In this case, the tab remains open and the entries already imported are grayed out.

It is not possible to import the same transaction twice. The transactions in the Camt file have a unique ID which CashCtrl stores invisibly. This way it recognizes if a transaction has already been imported once.

Screenshot section of the Import button

7. Finding imported transactions

In the journal, imported entries are marked with a blue dot. Payments for a document are displayed with an invoice icon and a dot. This makes imported bookings easier to identify.

A file with payment transactions can be imported only once. If a file is imported a second time, CashCtrl recognizes this and displays the bookings accordingly grayed out and crossed out.

Screenshot of the journal with the first column where you can see which entries have been imported

Booking a partial amount

I) Input partial amount A

If a transfer consists of several invoices, it can be split. For this purpose, the first partial amount is entered as for a single transfer. CashCtrl immediately displays the remaining amount below.

 

Important:
Do not set a tax rate when assigning a CashCtrl order in the "Order" field. The tax rate will then be automatically set during the debtor booking.

Screenshot of an imported booking with the booking of a partial amount

II) Input partial amount B

The remaining amount is already entered in the following booking. In addition, it is displayed that now 0.00 CHF are still open. The amount can also consist of more than just two individual entries.

 

Important:
Do not set a tax rate when assigning a CashCtrl order in the "Order" field. The tax rate will then be automatically set during the debtor booking.

Screenshot of an imported booking with the booking of the remaining amount