QuickBooks for Sports Clubs: How to Get Bookings, Memberships and Card Fees Into Your Books

QuickBooks for sports clubs works best when the club's booking software adds up each day's sales and QuickBooks only gets the totals. A club that tries to re-type every court booking, membership fee and drink sale into QuickBooks either falls weeks behind or stops doing it.

This guide shows how to set it up: what goes into one daily journal entry, which accounts you need, and how the card payouts then reconcile against your bank feed.

The problem: hundreds of small sales, one bookkeeper

A busy club issues a lot of small invoices. A court for an hour, a share of a split booking, a tube of balls, a top-up of a member's prepaid credit, a monthly membership. Each one is correct in the booking system, but QuickBooks doesn't see any of them.

What usually goes wrong:

• Income gets booked in the wrong place. Every payment lands on one "Sales" line, so nobody can tell court revenue from memberships or the shop.
• Prepaid credit is counted as income too early. A member tops up $200 in March and plays until June. If the $200 is income in March, March looks great and June looks empty.
• Card fees disappear. The card processor pays out the takings minus its fees, so the bank deposit never matches the day's sales. The difference gets written off, or is left unexplained.
• Member data ends up in the books. Creating a QuickBooks customer for every player fills the books with personal data nobody needs there.

How clubs normally handle it

The most common approach is a spreadsheet export from the booking system. The bookkeeper then types totals into QuickBooks by hand once a week or once a month. It works, but it depends on one person, it is slow, and mistakes only come to light when the bank doesn't reconcile.

Some clubs connect their card processor straight to QuickBooks with a sync app. That gets card payments in, but it knows nothing about cash, bank transfers or what was actually sold. You get a deposit for $766.50 and still have to work out how much of it was courts and how much was memberships.

Recommended approach: one journal entry per day

Ask your booking software for the day's sales as one summary, then post it to QuickBooks as one journal entry. Each entry has the same lines every day:

Four things make this setup work:

1. A clearing account for card payments. The processor doesn't pay out each day's sales the same day. Book card takings into a clearing account. When the payout arrives in your bank, record a transfer from the clearing account to the bank. If everything matches, the clearing account goes back to zero. If it doesn't, the leftover balance tells you something is missing.
2. Prepaid credit is a liability. Money a member loads onto their club account is money you owe them until they use it. Book top-ups to a liability account. When members spend the credit on courts, that is the point where it becomes income. If your club gives refunds as credit back to the member's wallet, the same account absorbs those too.
3. Fees as their own line. Book the processor's fees as an expense in the same entry. That keeps the card line equal to what members paid, and the clearing account reconciles to the payout to the cent.
4. No customer per member. Daily totals are enough for the books. The invoice-level detail stays in the booking system, where you can look up any individual invoice if an accountant asks.

Example

A hypothetical club in Ontario with four padel courts, charging 13% HST, on one Saturday.

• Court bookings paid by card: $678.00 ($600.00 + $78.00 HST)
• Shop sales paid by card: $113.00 ($100.00 + $13.00 HST)
• Memberships paid by bank transfer: $339.00 ($300.00 + $39.00 HST)
• The card processor's fees on the day's card payments: $24.50

The day's journal entry, SP-2026-11-07:

On Tuesday the processor pays out $766.50. Record a transfer of $766.50 from Stripe Clearing to the bank account, and Saturday's clearing balance is zero. If the payout covered several days, the clearing balance still returns to zero once all of those days are posted.

Some players booking courts that day paid with wallet credit they had topped up earlier. Those bookings were paid for when the credit was spent, so they don't appear as card or cash payments here. In the books, using credit moves money from Member Wallet Balances to income. Ask your accountant whether to post that monthly or to recognise income when credit is loaded. This is the one decision in this setup that depends on your jurisdiction.

How SportyPlus can help

SportyPlus builds that daily journal for you. In the CMS, Reports → Invoices and Stripe fees lists every invoice your club issued in a period, from the member app and the shop. Each one shows its payment method, tax and the fee Stripe kept. QuickBooks (CSV) on the same page downloads a QuickBooks Online journal import file with one balanced entry per day, laid out exactly like the example above.

You type the names of your own QuickBooks accounts once, and the browser remembers them. Wallet top-ups go to a liability account by default. Dates follow your club's country, month first in the United States and day first elsewhere, and you can change the order. The file never contains member names or email addresses. In QuickBooks Online, import it under Settings → Import data → Journal entries.

The documentation page walks through the setup step by step. See also payments and invoicing and club reports.

Practical recommendations

• Create the accounts before the first import. QuickBooks imports a journal entry only if every account in it already exists, under exactly that name. You need at least a clearing account (bank or other current asset), a wallet liability account and a fees expense account.
• Import a month at a time, and don't import a day twice. Turn on QuickBooks' duplicate journal number warning so it catches repeats.
• Wait until card fees are in. Card fees reach your booking system a little after the payment. Export a period once its fees have synced, or the fee lines for the last few days will be missing.
• Watch the clearing account. It should only ever hold the last few days of card takings. A balance that keeps growing means a payout or a day was never posted.
• Use your own tax liability account if QuickBooks manages sales tax. QuickBooks Online's automated sales tax doesn't let you post journal entries to the tax account it manages.

Related questions

Should each player be a customer in QuickBooks? Usually not. Daily totals are what the books need, and they keep members' personal data out of your accounting system. If a club invoices companies or schools on credit terms, create those few customers by hand.

What about refunds? A refund or credit note reduces the day it was issued on. A card refund lowers that day's card line and income, and the clearing account follows when the processor deducts it from the next payout.

Does this work with Xero or another ledger? Most accounting tools can import journal entries, and the structure is the same. The column names differ, though, and the SportyPlus export is laid out for QuickBooks Online.

How do I handle card surcharges? If your club adds a surcharge for card payments, book it to its own income account. It then sits on the same side as the fees it is meant to cover, and you can see whether it does.

Related SportyPlus guides

• How to handle refunds for cancelled court bookings automatically
• Court booking management

Keep your books up to date without re-typing invoices: see payments and invoicing in SportyPlus.