Shopify is a channel that allows a lot of customization. There are many apps available for sellers to accept payments, process refunds, change orders, and more.
This is useful as a seller, but it can cause accounting complications, especially if the app edits the order and changes the timeline of data. This can cause discrepancies between the data A2X fetches and what is then displayed in your Shopify Finance Summary.
Additionally, if you’re fetching a lot of data into A2X at a time, it’s hard to know if all data has been fetched or if any payouts may be missing.
To identify if there is a variance between the data in A2X and in Shopify, A2X has a Virtual Finances Summary Report, which replicates the data in the Shopify Finance Summary. The problem is, that if you do identify a variance between your A2X data and your Shopify data, it can be difficult to pinpoint what is causing the discrepancy.
That is why we’ve built the A2X Shopify Reconciliation Tool. This tool will identify any variances between your Shopify data and your A2X data. It will then list which specific orders are causing the variances and some possible reasons.
That’s where the A2X Shopify Reconciliation Tool comes in.
This tool compares your A2X data with your Shopify Finance Summary and pinpoints:
Which specific orders are causing discrepancies
Possible reasons for the variances
This article will provide a step-by-step guide on how the A2X reconciliation feature works.
How to use the Shopify Reconciliation Tool
1. Open the Finance report and choose what to reconcile
In your A2X for Shopify account, go to Reports > Finance Report.
In the top-right corner, use the Date Range selector to choose the period you want to reconcile. Then select the data you'd like to reconcile. This is where you will specify what data you want to compare. This can range from Net sales to a specific payment gateway. Once you have selected the data in the dropdown, you can then click 'Reconcile'.
2. Upload Your Shopify CSV File
A popup will prompt you to upload a .csv file. Click the blue link in the pop-up to go to your Shopify store and export the corresponding Finance Summary data.
In Shopify, click the "..." menu in the top-right corner, then choose Export.
Important: Do not rename or modify the CSV file after downloading. A2X needs the original file format to process the reconciliation.
Once you’ve downloaded the file:
Return to A2X
Choose the file
Click Submit
If you receive an error while submitting the file, it could be due to the file size. Read HERE to learn more.
3. Review the Reconciliation Status
After submission, A2X will begin comparing the data. You’ll be redirected to the Reconciliation page, where you can track progress. If your file is large, processing may take a few minutes. .
Once the report displays a green tick with the status: COMPLETE, this is the end of the reconciliation process between A2X and Shopify. The next portion of this article will explain how to deal with a comparison that has noticed variances.
Is your reconciliation report showing variances?
If variances are detected, a number will appear in the ‘Variances’ column. Click the blue arrow to view the full reconciliation report.
This report shows which orders are causing variances. Click any blue Order ID to view full order details in A2X.
The Order ID will take you to the order summary page. This will provide you with the transaction and order details to find out what is causing the variances that the reconciliation tool has found.
You can click on the top right 'View order on Shopify' button if you want to view the order within your Shopify store account:
When it comes to variances between summaries in A2X/Shopify, the aim of the tool is to find the actual orders that are causing it. By finding the actual orders, this will help our engineering team understand and fix the issue faster.
Common causes for variances are third-party apps, orders being voided, or missing data. If you've found an order that is causing a variance, please reach out to our Customer Success Team so they can investigate the order for you. The CS team will be able to look into the backend data of A2X, including a timeline of the order. Once they've investigated the order, they can suggest a way forward.
To learn more about each section within the Shopify Reconciliation tool, click HERE.