Skip to main content

CourtPay: Reports - Payout Reconciliation and Balance Summary

Match Each Bank Deposit to Its Transactions and Track How Your CourtPay Balance Changes

Written by Mari Bern

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

  1. Select the CourtPay tab, then select Reports.

  2. Select Payout reconciliation or Balance summary.

  3. 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.

  4. 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.

  5. 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.

  1. Click Download next to the section you want, such as Payout reconciliation or Ending balance reconciliation.
    ​

  2. In the Download report window, select a Report format:

    • Summary - The category totals you see on screen.

    • Itemized - Every individual transaction behind those totals.
      ​

  3. Under Columns, select Default, All, or Custom. With Custom, select the columns you want from the list.

  4. 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.

  1. 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.

  2. 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.

Did this answer your question?