Page Comparison

...

Where the Reconciliate section is located?

1. Log in to CRM, go to the left side menu

...

2. Click on Payments

3. Then click on Reconciliate

...

1. .

What’s on the Reconciliate page

...

Each reconciliation has a specific id, displayed on the left side of each row. By clicking on the ID, the user is redirected to the reconciliation page and can check and edit transaction per each transaction (see the below example):

...

1. Importing the transaction file to CRM

1. Get the Excel file with the transactions. Please be aware that the file should have the following columns:

   Image Modified

2. Go to the Reconciliate page

3. Click on the + Create new button and the user is redirected to the Import Reconciliation Excel page

4. Users need to pick the payment provider
   

   Image Modified

5. Then the user can select the file from his/her PC or just drag and drop it to the page
   

   Image Modified

6. Click on the Upload files button
   

   Image Modified

2. Checking and matching the payment provider transactions

Please refer to the below image for the Transaction Reconciliation Flow and the transaction statuses with which CRM will flag them

...

1. Therefore, once the file is imported into CRM, the user needs to click on the Reconciliate ID and go to the specific reconciliation page. All transactions of the file will be initially displayed with the status processing (point 1 - Reconciliation Flow)

   Image Modified

2. CRM automatically tries to match the Transaction Ids of the file with what is already available in the database. If there is a transaction id that corresponds to a transaction recorded in the database, the specific transaction will be marked as reconciliated (point 2 - Reconciliation Flow)

3. In case, CRM is unable to match the transaction id with what is available in its database - the transaction will be set as Pending Action (point 3 - Reconciliation Flow)

   Image Modified

4. When the transaction is in the status of Pending Action, the user needs to actively choose one of the other three statuses: New Receipt, No change, and User Input. To update the status, just double-click on the status field and pick one of the 3 options available from the drop-down menu

   Image Modified

   ...

   1. 1. The status New Receipt: a new transaction will be recorded in the DB (point 4 - Reconciliation Flow)

   ...

   1. 1. The status No change: the system will just ignore this transaction (point 5 - Reconciliation Flow)

   ...

   1. 1. The status User Input: the user can then add the order number,

   ...

   1. 1. to the Order column and CRM will match the order transaction with the file transaction (point 6 - Reconciliation Flow)

         Image Modified

         If an order transaction has been reconciled, on the order page in the Payment History section, the user should be able to see a second transaction with the correct value of the payment (see the below example):

         Image Modified

         However, please note that this feature won’t update the status of the order

   ...

   1. 1. when an order transaction has been reconciled.

   2. Once the user has updated the transaction with one of the above statuses, he/she needs to click on the Save Changes button on the left side of each transaction row

      Image Modified

   3. When all transactions have been updated, the status of the reconciliation will be updated as Reconciliated

      Image Modified

   Note
   Kindly note that once all changes have been saved and the transactions updated, the transaction cannot be edited any longer.