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.

   
   

   Concept	Explanation
   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
   Delayed
   Active
   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
   .