Invoices and QuickBooks
The Invoices and Stripe fees report lists every invoice your club issued in a period, from the member app and from the shop. Each invoice shows its payment method, tax, and the fee Stripe kept from the card payment behind it.
Find it under Club Admin → Reports → Invoices and Stripe fees.
Choosing what to export
At the top of the report, pick a Period (this month, last month, this year, last year) or set your own From and To dates. A period can be up to a year long. You can narrow the report further:
- Payment method: card, cash, bank transfer or other
- What was sold: reservations, wallet top-ups, memberships, subscriptions, shop, card surcharge or other
- Courts: only invoices for bookings on the courts you choose
Days follow your club's time zone, so an invoice issued at 00:30 is counted on the day it was issued at the club.
Both downloads use the period and filters you have chosen.
Download XLS
Download XLS gives you a workbook with four sheets:
| Sheet | What it holds |
|---|---|
| Invoices | One row per invoice: number, date, buyer, payment method, net, tax, total, Stripe fee, and its fiscalisation status |
| By day | Takings per day, split by payment method, with Stripe's fees |
| Summary | Totals by payment method, by tax rate and by what was sold |
| Lines | One row per invoice line, for reconciling item by item |
Export to QuickBooks Online
QuickBooks (CSV) downloads a journal file that QuickBooks Online can import. Each day becomes one journal entry, numbered SP- followed by the date (for example SP-2026-11-09). Every entry balances.
| Line in the entry | Debit or credit | Default account |
|---|---|---|
| Card payments | Debit | Stripe Clearing |
| Cash payments, bank transfers, other payments | Debit | Undeposited Funds |
| Reservations | Credit (net) | Court Bookings |
| Memberships | Credit (net) | Memberships |
| Subscriptions | Credit (net) | School Fees |
| Shop | Credit (net) | Shop Sales |
| Card surcharge | Credit (net) | Card Surcharges |
| Wallet top-ups | Credit (net) | Member Wallet Balances |
| Other sales | Credit (net) | Other Income |
| Tax collected | Credit | Sales Tax Collected |
| Stripe fees | Debit, and the same amount credited to the card account | Stripe Fees |
Payments are booked with tax included, sales without it, and the tax on its own line. Credit notes and refunds in the period reduce their day's amounts.
Member names and email addresses are not included in the file. Only daily totals go to QuickBooks. The invoice-by-invoice detail stays in SportyPlus and in the XLS download.
Set your account names
QuickBooks only imports an entry when every account in it already exists in your chart of accounts under exactly the same name. Before your first import:
- Click QuickBooks (CSV).
- For each line, type the name of the account it should go to in your QuickBooks. Leave a field empty to use the default shown in grey. For a sub-account, write
Parent:Sub-account, for exampleIncome:Court Bookings. - Under Dates in QuickBooks, pick the date order your QuickBooks uses. If you leave it empty, clubs in the United States get month first (MM/DD/YYYY) and everyone else gets day first (DD/MM/YYYY).
- Click Download CSV.
The account names you enter are remembered in your browser for this club, so you only set them once on each computer.
Import the file into QuickBooks
- In QuickBooks Online, go to Settings → Import data → Journal entries.
- Upload the CSV file and choose the same date format you picked in SportyPlus.
- Check that the columns are mapped to Journal No, Journal Date, Account Name, Debits, Credits and Description, then import.
A few things to know:
- Import a month at a time. QuickBooks may refuse very large files, and a month is usually around 300 lines.
- Don't import the same days twice. If QuickBooks warns about duplicate journal numbers, those days are already in your books.
- Card payments land in Stripe Clearing. When Stripe pays out to your bank, record a transfer from Stripe Clearing to your bank account. The clearing account then goes back to zero.
- Stripe fees appear once they are synced. The report shows a notice while fees for recent days are still being fetched. Export after it disappears, or the fees for those days will be missing.
- QuickBooks may not accept journal entries to its own sales tax account. If your company uses automated sales tax, enter a separate liability account for tax collected.