The ZipPay payouts are generated as per the data fetched from Shopify.
The expected deposit amount that A2X allocates to the clearing account per ZipPay payout is the gross amount - which means that the ZipPay fees are not deducted. Why? Simply because the ZipPay fees don't pass through your Shopify account, which is what A2X is connected to.

This guide will explain how to confirm that the A2X payouts balance back to your monthly ZipPay detailed statement, as well as how to allocate your ZipPay fees on a monthly basis.

1/ In A2X - sort your payouts list by a payment gateway

For reasons of clarity, we have listed below the A2X ZipPay payouts in the month of December, that we will cover in this article:

Please Note: The account in our example is set up to generate ZipPay payouts on a daily basis. However, you can also set A2X to generate either weekly or even better, monthly payout entries for your other payment processors such as PayPal, ZipPay, Sezzle, Stripe, etc.

2/ In ZipPay - download a monthly report of account activity for a given period

ZipPay has a reporting functionality that allows you to create CSV disbursement reports for up to 3 months.

a.  In your ZipPay merchant portal click on the Reporting tab

b.  Select the date range, then click Create Report.

c.  A new link will appear below the date arranged to ask you to download the report once it's been generated.

The following information is provided in the CSV download. We have highlighted the column titles relevant to this guide:

Disbursement Date
Order Date & Time
Merchant Order Reference
Transaction Date & Time
Zip Transaction Receipt
Merchant Transaction Reference
​Transaction Amount
Merchant Fee excl Tax
​Merchant Fee Tax Merchant Fee incl Tax
Transaction Fee excl Tax
​Transaction Fee Tax Transaction Fee incl Tax
​Net Disbursement Amount
Channel
Location
Name
Location Id
Device
Reference Code 

We requested the December report as (partly) shown below and excluded/greyed out the unnecessary text detail for simplicity purposes. You will note we have added a border around a single day in the ZipPay report - the total in this selection matches the payout total in A2X for the same day.

We have summarised the ZipPay report daily and added just the necessary items to a pivot table (date, transaction amount, merchant fee including tax, transaction fee including tax, and net disbursement amount) to easily compare the totals. 

3/ Compare and balance the A2X payout amounts to the ZipPay Statement data

And summarised to include the total of the fees:

This is the flow of events:

Please Note: On the odd occasion, the difference in the Gateway Clearing account may also be caused by a carry-over balance for a transaction that hasn't cleared yet.

If we put the above flow of events into numbers:

In QuickBooks Online, the monthly entry for ZipPay fees for December 2019 would look similar to this:

In Xero, the monthly entry for ZipPay fees for December 2019 would look similar to this:

The end result is that the Gateway Clearing account is reconciled back to $0.00.
As mentioned above, there may be a balance that will carry forward into the next month on the odd occasion due to timing.

We’re here and available via chat to help with any questions you have.

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE