How-to: Reconcile bank accounts

Created by Erik Åkerlund, Modified on Mon, 20 Feb 2023 at 02:28 PM by Erik Åkerlund

Reconciliation of Bank accounts

Import bank account statment and reconcil with accounts in CRM

Step-by-step guide

This function will perform an automatic matching of payments sent by file to the bank, or Payments entered manually (in deal input form Bank Account transactions) with statement information received by file from banks. 

The form consists of two parts. The left side displays transactions in CRM Finance and the right side displays transactions imported from banks. 

Click on the Expand button to display comments for imported transactions. Transactions are reconciled by the following criteria's: Date, Currency, Amount and Account number.

Only unique transactions will be matched. If multiple matches are found none of the transactions will be reconciled 

  1. Go to Back office / Reconciliation of Bank Accounts
  2. Click on The Extended selections button to enter import file name. The name of the file from the Bank containing the account statement is specified.

    Reconciled Marked as REC means that a match between CRM and bank account statment has been done
    Non reconciled Marked as NON means that no matching has been done
    Imported Marked as IMP a NON that has been imported to the CRM system , for example commercial transaction or a cash pool sweep
    Bal Dif Marked as Dif
    Bal Adj  An adjustment of the bank account balance, used when you only import balanceces
    Bal Chk Marked as Chk , shows the imported Balance on the account



  3. Click on the Run button to perform the actual reconciliation.
  4. When the reconciliation procedure is finished the result can be seen on screen.
  5. Select transactions by an extended selection

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article