Exporting a bank statement from an online bank

Exports - click on "CAMT XML" - and your file will be downloaded automatically on your computer. Make sure to remember the location, since this file will be used in the next steps for import to MetaKocka.



1. Bank - select bank statements

Select Statements


2. Bank statements

For each day when the bank statement is imported, a record is displayed.


 

Click on (+) to add a new statement.

Note: when the statement is added for the first time, also enter the:

- bank account

- initial balance of the bank account  početno stanje na računu za izvod koji uvozite

- number of statements that will be imported




3. Select a statement and import it

Select the statement and click on the "Import" button.

When data is imported, check the imported balance and if some payments are not linked with the document, select them by clicking on (+)



When all payments are linked, click on Save.


Linking payments on multiple different invoices


If the customer bank transfers the funds for multiple invoices (or offers, sales orders, purchase orders, etc.) together, the amount should be distributed. For example, the ''Mercator'' customer bank transferred 100 EUR for the invoices R1 (80 EUR) and R2 (20 EUR) as displayed in the picture below.





The following should be done:

  • add new transaction for which "Mercator" will be selected as the partner by clicking on "Add transaction"
  • the amount of 100 EUR should be distributed to both transactions.
  • for both transactions, select the correct document.

The final state is displayed in the picture below.