Sporty is a Xero connected App!
If your organisation uses Xero accounting software you are able to integrate online payments received through Sport$Pay or SchoolPay with your instance of Xero.
Integrating with Xero makes the following possible:
- Creation of contacts in Xero. When a person registers with your organisation online, a customer account (“Contact”) is automatically created for that person in Xero.
- Creation of draft invoices. When a person pays you via Sport$Pay or SchoolPay online, they can select items to pay for (such as subs or products) and a draft invoice is automatically created in Xero.
There is a one off set up fee of $95 + GST to have Xero integration enabled and a monthly fee of $10 + GST. (Please note: if you are rugby organisation in the greater Auckland area the Xero fee is waived until 2020).
To enable Xero integration please complete the application form here http://www.sporty.co.nz/viewform/50467
Tips for bookkeepers - reconciling bulk payments in Xero:
Once your Xero connection is enabled, you'll see that each online payment automatically raises a draft invoice for you Xero. You can then simply approve these draft invoices in Xero.
Since the pay-outs to you are made into your account weekly in bulk, each pay-out amount is likely to relate to more than one of your invoices. So there is not a one-for-one match in Xero that allows you to reconcile individual invoices against individual payments. Xero provides a recommendation for how to handle bulk pay-out and still make reconciliation easy. See: https://central.xero.com/s/article/Reconcile-payments-received-from-online-sales#Processmerchantfees
Essentially, Xero recommends that you create a separate current asset account for these transactions that acts as a clearing account. So go to your Chart of Accounts in Xero and add an account to Current Assets called say 'Debitsuccess clearing account'. Note that this account should be set to 'No GST' since GST (if any) will have already been recorded on income through each invoice that will be created.
From then on, you'll simply credit the bulk receipt of funds from your weekly pay-out from Sport$Pay/SchoolPay to this Debitsuccess clearing account, and debit the individual invoices from this same account to reconcile each one when you know its been paid. These debits and credits cancel each other out, with the exception of the processing fees.
So when the pay-out amount appears on your bank reconciliation in Xero, code it to this clearing account (you can set up a bank rule to do this for you). For each invoice that you know was paid online, go to the invoice and use the 'Receive a payment' area at the bottom of the invoice to show the full amount as paid, coding it to the same Debitsuccess clearing account.
In this way you are able to reconcile each individual invoice as soon as you're satisfied it has been paid without needing be concerned that each invoice total will be slightly higher than the amount you actually receive (since the amount you receive already has the processing fees deducted).
To handle the merchant fees, you simply take the fees total from your Debitsuccess pay-out report and create a manual journal that credits your clearing account and debits the total to an expense account for fees. Note that the merchant fees from Debitsuccess attract GST, so don't use your normal 'Bank fees' expense account since it will probably be set to 'No GST'. You can simply create a new expense account in Xero called say 'Merchant fees' and set its tax to be '15% GST on expenses'. You only need to do this once.
So, your journal entry would then look like this:
If you need help accounting for online revenue or merchant fees in Xero, please seek assistance from your accountant or directly from Xero.com.