Gateway transactions represent the expected sales or refund amounts in or out of a given payment gateway,
With A2X for Shopify there are two types of payout gateways:
- Shopify Payments - these payouts match directly to the bank deposits arriving from Shopify in your accounting system. This makes for easy reconciliation and for the reconciliation step is actually a good balancing check in itself.
- Other payment gateways - these payouts are accounted for in a clearing account which will clear based on payments received from the gateway. We can check these against the finance data directly in Shopify which is explained in detail below.
If we take the following Paypal payout as an example:
We can review this payout in A2X and see the following transaction detail:
We can also verify this payout information by viewing it directly in Shopify.
1/ Go to Analytics:
2/ Click 'Reports':
3/ Select the 'Finances Summary'
4/ Change the date range to the period you are wanting to verify. In our example it is the 1st to the 30th of April:
The payments will be broken down into their respective gateways. You will see below the total of our $63.99 PayPal payout is listed there:
If we click that amount we get to see the payment by type. This will show the individual orders that make up that particular payout:
In our example, because it is a single order, we can then click the order number to review the detail:
We can use this detail to balance back to the A2X entry.
(Product Sales Excluding Tax - Online Store) + (Tax - Online Store) = $54.99
(Shipping - Online Store) + (ShippingTax - Online Store) = $9.00
(Tax - Online Store) + (ShippingTax - Online Store) = $8.35
The above amounts all balance back to the Shopify order detail.