Our Shopify Reconciliation Tool is a valuable resource to help users ensure that all information as shown in the Shopify Finance report is correctly represented in A2X. There are a few situations however, where it will not be possible to use the Shopify Reconciliation Tool to compare the two sets of data, which are discussed below.
The A2X Shopify Virtual Finances Report has excluded payment gateways.
This is a preference setting that a user can set up to instruct A2X to ignore various payment gateways. If a gateway has been excluded, the Shopify reconciliation tool will incorrectly assume that A2X has generated a NIL value for these orders.
The Shopify store has a different base currency to the payout currency.
Some countries allow Shopify stores to nominate a different payout currency to the base store currency. This is common in Canada, for example where the store may sell in USD and be paid in CAD.
At this stage it is not possible to do a comparison of orders using more than one currency, given that the figures in the uploaded CSV file are the store base currency, and the amounts processed by A2X are in the payout currency.
The uploaded file is larger than 32MB in size
The tool can currently support uploaded files of up to 32MB. If the file is larger than this size, it will be necessary to reduce the date range comparison. Click here to read more about how to do this.
The order that is compared was created before A2X was connected
If an order is edited in Shopify after creation date, Shopify will present the financial adjustment in their Finance summary in the month of the adjustment. In normal circumstances, A2X correctly captures the financial adjustment in the same date range.
There are rare exceptions however, for Shopify orders that are created with dates prior to the A2X connection date and then edited after creation date. In these circumstances it is not possible for A2X to retrospectively calculate which adjustments were made after the order creation date, but before connection date.