Skip to main content

Payouts report

Use the Payouts report to match each bank deposit from Stripe or SportsPay to the payments, refunds, fees, and disputes that make it up. A payout is one transfer to your bank account. It is not a single customer payment.

Managers with permission to view financial reports can open this report. Use it when your bank statement shows a deposit and you need to know which orders it covers.

Open the report​

Go to Reports > Financial > Payouts.

Payouts report showing Stripe and SportsPay payouts recorded since the start of the season.

The report lists the newest payout first and shows 12 per page. When you first open it, From is the first day of your current season and To is empty, so you see every payout from the season start onward.

To change the list, set From and To, then select Apply. Both dates are included, and they filter on the Created date. Clear From to see older payouts. If nothing matches, the report says No payouts matching search.

Payouts come from Stripe or SportsPay and are shown as the provider reports them. A Stripe payout that was recorded without matching Curling IO payments, such as a manual payout, can still appear, and its detail then shows no matched payments. Payments you record by hand, such as cash or cheques, never appear here. See Payments for those.

Read the list​

  • External ID is the identifier your payment provider gives the payout. For SportsPay this is the deposit number. Select it to open the payout. If the provider gave no identifier, Curling IO shows its own number, such as #42.
  • Status is the status the provider reported, such as paid or in_transit. Curling IO shows it as the provider words it.
  • Created is the date the provider created the payout. For SportsPay it is the deposit date.
  • Arrived on is the date Curling IO recorded for the payout. For Stripe, Curling IO records it only once the payout's status is paid. For SportsPay it is the deposit date. A dash means Curling IO has no date recorded yet, not that the provider gave no estimate. Check your bank statement before treating a payout as received.
  • Amount is the amount the provider reports, which can be negative when money leaves your bank. It is after fees, refunds, disputes, and any adjustments the provider made. Provider adjustments can be positive, so the amount isn't always smaller than the payments it covers. The amount and status don't prove the money has arrived.

Dates use your club's time zone.

Reconcile a payout​

Select an External ID to open the payout. The breadcrumb ends with that External ID.

Example payout detail showing readable status and source labels, a separate reconcile date, and the reconciliation table.

This screenshot uses local sample data. It shows an unreconciled payout, not a real bank transfer.

The top of the page shows the External ID, Source (Stripe or SportsPay), Status, Amount, Currency, Created, and Arrived on. The detail page shows Paid or In transit instead of paid or in_transit; French labels are Payé and En transit. Other provider statuses retain their reported value.

Reconciled on (Rapproché le in French) is the date Curling IO matched the payout to its transactions. A dash means that hasn't happened yet. The Reconciliation heading below refers to the table, not that date.

The Reconciliation table adds up what is in the payout:

  • Payments is the net of every payment in the payout. For Stripe, that is the amount charged minus the fees shown for it. For SportsPay, it is the gross amount, with the estimated fees shown separately.
  • Refunds is the money taken back out for refunds, shown as a negative.
  • Adjustments is everything else the provider included, such as dispute fees and corrections.
  • Explained net is those three added together.
  • Payout amount is the amount the provider reports for the payout.
  • Unreconciled difference is the payout amount minus the explained net. It can be positive or negative.

When every transaction has been matched, Unreconciled difference is $0.00. A payout that Curling IO hasn't reconciled yet shows empty sections and a difference equal to the full payout amount. See When payouts appear below, then check again later. If the difference stays other than zero for a payout that has arrived, after the related payments and refunds have settled, contact support with the External ID. Don't change an order to make the numbers match.

Below the table, three sections list the evidence:

  • Payments lists each order with the customer's email, the provider's charge ID, the Amount, the Fees, and the Net. Select the order to open it. See Orders.
  • Refunds lists each refunded order with the provider's refund ID and the Reason. Refunds are negative. See Refunds.
  • Adjustments lists provider activity that isn't a payment or a refund, with its Type, Description, Amount, Fees, and Net. Dispute fees appear here. See Disputes.

Select Back to return to the list.

When payouts appear​

Curling IO records Stripe payouts as Stripe reports them. It matches the payments and refunds when Stripe marks the payout paid or finishes its own reconciliation. SportsPay deposits are fetched overnight, so a deposit from today usually appears tomorrow. A payout that shows no transactions yet is normally waiting on one of these steps.

Curling IO stores each provider item once, so a repeated notification from the provider doesn't count anything twice.

Download the results​

Select Download next to the date fields to get payouts.csv for the payouts in the date range. Select Download on a payout to get a CSV for that one payout, named after the ID shown for that payout.

These files use the same layout as the Payouts report in earlier versions of Curling IO, so existing spreadsheets keep working. They are more detailed than the screen:

  • The file has one row per payment, followed by one row per order item with the participant's name, amounts, discounts, and each tax your club charges.
  • Refunds and adjustments follow in their own sections.
  • Dates include the time, in your club's time zone.
  • The all-payouts file includes a Payout Processor column to tell payouts apart. It doesn't have a Source column.
  • In the all-payouts file, the Refunds section's Payout ID contains the refund's own SportsPay reference or Stripe refund ID, not the parent payout's ID.
  • In the Adjustments section, Payout ID contains the adjustment's Stripe ID. It is blank for SportsPay adjustments.
  • To identify which refunds or adjustments belong to one payout, download that payout's CSV. Its Refunds and Adjustments sections omit the Payout ID column because every row already belongs to that payout.

To compare a deposit with your bank statement, use the payout page. To check your accounting records line by line, use the CSV.