Introduction
Feature Summary: CourtPay includes two financial reports. Payout Reconciliation ties each bank deposit to the transactions inside it, and Balance Summary shows how your CourtPay balance changed over a period.
Use Cases:
Matching deposits on your bank statement
Month-end closing and bookkeeping
Navigation
Select the CourtPay tab, then select Reports.
Select Payout reconciliation or Balance summary.
Click Date range and choose the dates for the report:
Select a preset: Month to date, Quarter to date, Previous month, or Previous quarter.
Or enter a Start and End date, or select them on the calendar.
Confirm the Timezone is correct for your club. Report dates follow this time zone, so a payment made in the evening can appear on the next day if it's set incorrectly. To change it, click Timezone and select your club's time zone.
Click Apply.
At a Glance
Payout Reconciliation starts from your bank deposits and works backward; Balance Summary starts from your CourtPay balance and tracks every change to it, like a bank statement.
| Payout Reconciliation | Balance Summary |
Answers | "What's inside this deposit?" | "Where did my money go this month?" |
Tracks | Each payout and the payments, refunds, fees and disputes it settled | Your starting balance, all activity, payouts sent, and ending balance |
Organized by | Payout, using each payout's expected arrival date | Date of each transaction |
Also shows | Activity not yet paid out, and any failed payouts | Totals by type of activity for the period |
Best for | Matching deposits on your bank statement | Month-end closing and bookkeeping |
When to Use Which
If your question starts with a deposit, use Payout Reconciliation; if it starts with a date range, use Balance Summary.
Your Question | Use |
Which payments make up the deposit I got on Tuesday? | Payout Reconciliation |
Why is this deposit smaller than I expected? | Payout Reconciliation |
Which payments haven't been deposited yet? | Payout Reconciliation (Ending balance reconciliation section) |
Did a payout fail, and was it retried? | Payout Reconciliation (Failed payouts section) |
What did we collect, refund and pay in fees last month? | Balance Summary |
What should our books show for CourtPay at month end? | Balance Summary |
How much money is sitting in our CourtPay balance? | Balance Summary |
Many bookkeepers use both: Payout Reconciliation to match each bank deposit, and Balance Summary to close the month.
Reading the Payout Reconciliation Report
The report groups every payout in your date range by its expected arrival date, then breaks each one into the payments, refunds, fees and disputes it contains.
The sections, top to bottom:
Balance summary. Your starting and ending balance for the date range, with a high-level total of activity.
Payout reconciliation. Every payout expected to arrive in the date range, with its contents totaled by category: payments, refunds, fees and so on.
Failed payouts. Payouts your bank returned. This section only appears when a payout failed in the date range.
Ending balance reconciliation. Activity that hadn't been paid out yet as of the end date. This is where a "missing" payment usually turns up.
Summary or Itemized. Each section downloads two ways. Summary gives the category totals you see on screen; Itemized lists every individual transaction behind them.
Key columns in the Itemized download:
Column | What It Tells You |
automatic_payout_id | The payout this transaction was part of. Filter on it to isolate one deposit. |
automatic_payout_effective_at | When that payout was expected to arrive in your bank. |
created | When the transaction happened. |
available_on | When the transaction's funds became available to pay out. |
reporting_category | The type of transaction, such as charge, refund, dispute or fee (see Transaction categories). |
gross | The full transaction amount before fees. |
fee | Processing fees for the transaction. |
net | Gross minus fees: what the transaction added to or took from your deposit. |
description | A short label for the transaction. |
The net column is the one that matters for matching. Add up net for every row with the same payout ID, and the total equals that deposit.
Reading the Balance Summary Report
The report reads like a bank statement: what you started with, what came in and went out, what was paid to your bank, and what was left.
The sections, top to bottom:
Balance summary. Four lines that always add up: starting balance, balance change from activity, total payouts, and ending balance.
Balance change from activity. The activity line broken out by category, such as payments, refunds, fees and disputes, with a count and total for each.
Payouts. The payouts sent from your balance to your bank during the period.
Example. A month on the summary might look like this:
Line | Amount |
Starting balance | $1,200 |
Balance change from activity | +$11,850 |
Total payouts | −$11,890 |
Ending balance | $1,160 |
The activity line is everything except payouts: payments minus refunds, fees and disputes. The ending balance is money you've earned that hasn't reached your bank yet; it goes out in upcoming payouts.
Dates. Payments, refunds and fees are dated when they happen. Payouts are dated when they leave your balance, which is why a sale on the 31st can be in this month's activity but next month's payouts.
Summary or Itemized. As with Payout Reconciliation, the Itemized download lists every transaction, using the same core columns: created, reporting_category, gross, fee and net.
Download a Report
Each section of a report has its own Download button.
Click Download next to the section you want, such as Payout reconciliation or Ending balance reconciliation.
In the Download report window, select a Report format:
Under Columns, select Default, All, or Custom. With Custom, select the columns you want from the list.
Click Download.
The file downloads as a CSV, which you can open in Excel or Google Sheets.
Note: The Balance summary section doesn't offer a Report format. Its download includes only the totals shown on screen.
Tip: To match a bank deposit, download the Itemized format from the Payout reconciliation section. Its default columns include automatic_payout_id. To get a trace_id for your bank, select All or add Trace Id under Custom.
Transaction Categories
Both reports label each line with a category in the reporting_category column; most months you'll only see the first four.
Category | What It Means | Effect on Your Balance |
charge | A successful member payment, by card or bank | Adds |
refund | Money you returned to a member | Takes away |
fee | Processing and other fees | Takes away |
payout | Money sent from your balance to your bank | Takes away |
dispute | A member disputed a charge, so the amount was withdrawn | Takes away |
dispute_reversal | You won a dispute, so the amount came back | Adds |
refund_failure | A refund couldn't be completed, so the money came back | Adds |
payout_reversal | A payout failed or was canceled, so the money came back | Adds |
other_adjustment | Any other correction to your balance | Either |
If you see a payout_reversal, check the Failed payouts section of Payout Reconciliation and confirm your bank details are correct.
Example: Tracing One Deposit
Say a $2,418.60 deposit lands in your bank on Tuesday and you want to know what's in it.
Open Payout Reconciliation and set a date range that covers a few days around Tuesday. The report uses the payout's expected arrival date, not the day your bank posted it.
Find the $2,418.60 payout in the Payout reconciliation section. Its summary shows:
Category | Count | Gross | Fee | Net |
charge | 38 | $2,600.00 | −$84.40 | $2,515.60 |
refund | 2 | −$97.00 | $0.00 | −$97.00 |
Total | 40 | $2,503.00 | −$84.40 | $2,418.60 |
Download the Itemized version and filter automatic_payout_id to this payout. You'll see all 40 transactions, and their net column adds up to $2,418.60.
The two refunds may be for sales from weeks ago. Refunds come out of the payout current when you issue them, not the one that held the original sale.
Tips and Common Questions
I can't find a payout in the report. Widen the date range by a few days. Payout Reconciliation files each payout under its expected arrival date, which can differ from the day your bank shows it.
A payment isn't in any payout. Look in the Ending balance reconciliation section. Payments that haven't finished settling wait there until a future payout.
A transaction shows the wrong day. Check the report's time zone. Dates follow the time zone you select, or UTC if none is set, so an evening payment can appear on the next day.
Today's activity isn't showing yet. Report data isn't instant; a day's complete activity appears by noon the following day. A payout can even reach your bank before its reconciliation data is ready.
My bank says it never received a payout. In the Itemized download, add the trace_id column. Give that number to your bank so it can locate the transfer.
My monthly sales don't match my deposits. That's expected; fees, refunds and timing move the totals. Reconcile one payout at a time, and see the Payouts & Deposits Guide for why.









