One QuickBooks or Xero journal per Stripe payout, with your CourtReserve revenue categories and fees split out
Drop in a CourtReserve transaction export. The page builds one journal per day, or per Stripe payout if you add the payout file: each revenue category on its own line, convenience fees as their own income, card fees as an expense. Then it writes the import file for QuickBooks Online or Xero. Everything runs in your browser; the file is never uploaded.
or use your own files below
1. Your files
2. Tell the page which column is which
CourtReserve exports differ by report and club, so the page guesses from the headers and you correct it. Every choice re-runs the journal below.
3. Accounts
Names must match your chart of accounts. In Xero the account code is required in the file; in QuickBooks the name is used.
| Line | Account name | Xero code |
|---|
QuickBooks: use Parent:Sub for subaccounts, and turn account numbers off before importing.
4. The journals
Import the first file into a test company before your real books. These files are drafts for you or your bookkeeper to review.
What it does that the free parts do not
CourtReserve's Sales Summary export is organised by revenue category, and Intuit's Stripe connector posts card fees and matches each payout to its sales. The gap between them is a manual step: the connector lands sales under one "Stripe Sales" item, so a club re-splits each payout into its own categories by hand. This page does that split for one export, free.
Monthly plan: not on sale yet
Planned US$19 a month per location: your column choices and account names saved, and one file per month-end run. It is in development. Nothing is charged here and this page takes no email address; the button only tells us that someone would pay. We cannot contact you.
I'd pay US$19 a month for this (not on sale, nothing charged, no email taken)
What it does not do
It does not log in to CourtReserve, QuickBooks, Xero or Stripe, and it posts nothing for you. The column names of real CourtReserve exports were not available when this was built, which is why you choose the columns. The QuickBooks and Xero column layouts are built from each product's help pages and the Xero set is from memory, not checked against Xero's downloadable template; import the first file into a test company.
Sample files
CourtReserve sample CSV and Stripe sample CSV: invented club, members and ids, not real exports.