Page Comparison

...

On this page, users can see the list of previous reconciliation requests with the archives that have been previously imported (see the below example):

...

which are divided by Payment Processor.

...

How the Reconciliate section works

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 Added

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 Added

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

   Image Added

6. Click on the Upload files button
   

   Image Added

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 Added

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 Added

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 Added

   - The status New Receipt: a new transaction will be recorded in the DB (point 4 - Reconciliation Flow)
   - The status No change: the system will just ignore this transaction (point 5 - Reconciliation Flow)
   - The status User Input: the user can then add the order number, on the Order column and CRM will match the order transaction with the file transaction (point 6 - Reconciliation Flow)

   Image Added

   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 Added

   However, please note that this feature won’t update the status of the order, when an order transaction has been reconciled.

5. 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 Added

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

   Image Added