If your studio runs on Glofox and collects through Ezypay, your bank feed shows one deposit per settlement. Xero needs to know what that deposit was: memberships, trials, add-ons, merchandise, passes, challenges. Ezypay's report says how much was paid, but often not what kind of income it was. Glofox knows that. Reconciling properly means putting the two together every week.
Done by hand, that is a slow, fiddly job. Someone opens the settlement, looks members up in Glofox, works out which line each payment belongs on, adds the fees back, and keys an invoice that hopefully equals what landed in the bank. Most studios end up lumping everything into one "memberships" line, which makes the books balance but tells you nothing.
This article explains how we automate the classification and the Xero posting for studios that use Glofox, Ezypay and Xero, and what a person still checks. It goes with our guide to automating Ezypay settlements into Xero, which covers the weekly run as a whole.
How it works
- Three inputs. The Ezypay settlement report (PDF and CSV), a snapshot of your Glofox members export, and the Glofox transactions report.
- Amounts come from Ezypay. The CSV holds what was actually settled, including add-on payments, which appear as separate rows. Those are the numbers that will match the bank.
- The type of income comes from Glofox. Each payment is matched to the member, and the member's plan name says whether it is a weekly, fortnightly or monthly membership. Add-ons such as recovery sessions are identified from the member's add-on details. Trials, session packs and other one-off charges are picked up from the transactions report.
- Each line goes to its own income account. Memberships, trial offers, add-ons, merchandise, concession passes, challenge income and so on each map to the Xero account you already use for them.
- Memberships are the balancing line. Everything that can be classified is; whatever is left is treated as membership income. The lines therefore always add up to the settlement, and the split can't drift away from the money.
- One invoice per settlement, with its payment. The process creates an approved invoice to Ezypay with one line per income account. Ezypay's processing fees go on as a negative line to your fees account. The payment is dated to the settlement date. Because the invoice total is the net payout, it matches the bank feed line exactly, and reconciling is one click.
The AI (Anthropic's Claude) reads the reports and does the matching. Small scripts do the sums and talk to the Xero API. You end up with normal Xero invoices against your normal accounts.
What to watch out for
Billing frequency isn't always in the payment. Older or renamed membership types can look identical in the settlement whether the member pays weekly or fortnightly. The member's current plan in Glofox is the reliable source, so take a fresh members export each week.
Members with more than one payment. A member can have a membership payment and an add-on payment in the same settlement. Comparing each amount with that member's membership and add-on prices tells you which is which.
New charge types. Sooner or later a payment turns up that doesn't fit any line. The safe behaviour is to stop and ask which account it belongs to, then remember the answer. The unsafe behaviour is to quietly drop it into memberships.
Net, not gross. If the invoice is raised for the gross amount and the fees are entered somewhere else, the bank line won't match and someone has to fix it by hand. Putting the fees on the invoice as a negative line keeps the total equal to the deposit. Check the GST treatment of fees with your accountant.
Post each settlement once. Check before posting that the settlement hasn't already been posted, especially if you run more than one studio.
What still needs a person
- Choosing the settlement and the invoice date.
- Deciding which account a new charge type belongs to.
- Looking at the split before it is posted to Xero.
- Anything unusual, such as a refund or an adjustment from Ezypay.
Real example
We run this every week for two franchise fitness studios in Auckland that are related companies of ours. We built these automations for our own businesses first. Each studio has its own Xero organisation. Each settlement is classified from the Glofox reports into the studio's income accounts and posted as one invoice with its payment, so it matches the bank feed. The owner picks the dates and approves the posting.
Want this for your business?
We build automations like this at a fixed price, from NZ$1,000 + GST. The same approach works with other membership and payment systems; what matters is which reports and exports they give you, and we check that with you first.
Book a free 30-minute automation audit
FAQ
Do I need to change my Xero chart of accounts? No. Each income type is mapped to an account you already have. If you want a new split, such as add-ons separate from memberships, you add the account in Xero and the mapping is updated once.
What if a payment can't be classified? New charge types stop the run and ask. Anything else that can't be matched to a specific type stays in memberships, so the total still matches the bank.
Does it work if each studio is a separate company? Yes. Each studio is its own run against its own Xero organisation and its own Ezypay settlement.
Does it replace my bookkeeper? No. It does the matching and keying. Your bookkeeper still reviews the split, handles anything unusual and closes the period.