Reconciliation Report

Processor Reconciliation is the process of verifying that the electronic payment and refund transactions processed in retailcloud match the transactions reported by the payment processor. It ensures retailers that all financial transactions are correctly reported and accounted for.

Getting Started

Login to Console

Navigate to Financial → Reconciliation Report

To initiate the reconciliation process, start by uploading the transaction file received from your payment processor. 

Step 1: Import Reconciliation File

1. Navigate to the 'Upload File' button under the 'Reconciled' tab.
2. Upload Your File: Attach the transaction file received from your processor by simply dragging & drop or uploading your CSV file directly from your computer. This file contains payment records that need to be matched with the corresponding transactions in the retailcloud system.
3. Click Continue when done.
4. Column Mapping: Once the file is loaded the column headers from the file will be displayed below the heading ColumnName. In the case of the column header from the file exactly matching the Console field name this will be automatically mapped and this is displayed in the Map to Field.
5. You can map and make sure all of the column field data you're importing has been matched to its equivalent setting on Console. Your file will be mapped automatically by the system if you haven't modified the file.
6. Click Continue
7. Import will be Initiated → Click Finish.
8. You will receive an email when the system completes the import.

Step 2: Reconcile

Once the file import is finished, click on the 'Reconcile' button to begin the reconciliation process. This will initiate the reconciliation. The system will automatically match the payment records from the processor with the corresponding retailcloud transactions. By comparing the AuthCode and Amount, the system identifies and links the appropriate records.

Once the matching process is complete, the reconciled transactions will be displayed in the "Reconciled" tab. This tab provides an organized view of the successfully matched payment records.

During the reconciliation process, the system also searches for failed attempts in the retailcloud system. These failed records indicate unsuccessful transactions and may require further investigation.

To view the reconciliation details, click on the ECR Transaction ID.

Step 3: Manual Mapping

In case of unmatched records, the system offers the ability to manually map the unmatched processor records to the corresponding retailcloud records and vice versa. This is done by clicking on the "Assign" button, allowing users to establish the connection between the records by listing all the unmatched records in a pop-up and the ability to choose the corresponding retailcloud record or processor record.

Clicking on the assign button for an unmatched processor record, a pop-up with all the unmatched retailcloud records will be opened choosing a record from the pop-up and clicking the 'Save' button the transaction marked as Reconciled. 

Step 4: Hiding unmatched record

If there are unmatched records that are not relevant to the reconciliation process or require further investigation, users can click on the "Hide" button to remove them from the view temporarily.

Step 5: Reset Manual Mapping

In situations where manual mapping needs to be reset, the system provides an option to undo the manual assignments. By choosing a date range, manually mapped unmatched records can be reverted back to the unmatched records view.

By utilizing the Reconciliation Report feature, users can streamline the reconciliation process, identify and address discrepancies, and ensure the accuracy of transaction records. This feature empowers users to efficiently manage their financial data and maintain a clear overview of the reconciliation status.

Search Bar

The search bar effectively scans through the entire filtered dataset, delivering relevant results regardless of the data's page placement. This functionality provides users with comprehensive search results, seamlessly transitioning to subsequent pages if no results are found on the current page.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more