Payouts Report
Tiers: All
Report Category: Payment Reports
Location: Reports page > Payment Reports > Payouts
Permission Required: View All Billing Reports
The Payouts report shows which online payments and refunds are linked to each payout (a batch of money your payment processor deposits to your bank). Use it to match your bank deposits with individual customer payments and refunds in your accounting system.
The report is organized into two views:
- Summary view - lists each payout, including its status, date, and totals.
- Detail view - lists the individual payments and refunds included in a payout.
Report rules
- Voided payments are included in the report but refunds associated with voided payments are not listed.
- Chargebacks are not included in the report because the payment processor removes disputed funds before sending the payout.
- If a payment had a successful dispute/chargeback, the original payment still appears, which can cause a mismatch between payout totals and listed transactions.
- The report includes payouts with a status of Paid or In Transit.
- Payments and refunds included in a payout must have a status of Paid, Refunded, or Partial Refund.
- Refunds included in a payout must have a status of Succeeded.
- Due to timing a refund may be a part of a different payout from the original payment. For example, Jane Doe makes a payment on 7/1 and then receives a partial refund on 7/6. As a result, her payment is in the 7/1 payout and her refund is in the 7/6 payout.
Report totals
The Payouts report displays the following summary totals:
- Payouts - the number of payouts.
- Instant - the number of instant payouts. Instant payouts are loans against soon-to-be-processed standard payouts. See the Instant Payouts article for more information on this type of loan.
- Gross - the overall amount of the payout(s) before fees are deducted.
- Fees - the total fees deducted from payments as well as fees applied to instant payouts.
- Net - the total net payout amount (Gross minus Fees). This is what's deposited to your bank account.
- Payments - the number of payments in the payout(s).
- Refunds - the number of refunds in the payout(s).
- Customers - the number of customers associated with the payments and refunds.
- Invoices - the number of customer invoices associated with the payments and refunds.
When to use this report
The Payouts report helps you reconcile your bank deposits against the individual payments and refunds that make them up. Common uses include:
- Bank Reconciliation
- Matching a bank deposit to the customer payments and refunds behind it.
- Verifying that a payout arrived for the expected amount.
- Accounting
- Comparing payout totals to what your accounting system shows.
- Tracking processing fees deducted from each payout.
Tips and tricks
- Date filter - the Date filter applies to the payout's estimated arrival date, not the date individual payments or refunds were issued. By default, the report shows payouts arriving during the current month.
- Drill down - click a Payout ID to open a window showing payment and refund details for that specific payout.
- Color coding - totals are color-coded: green for positive or paid amounts, amber/orange for negative amounts, and gray for neutral totals.
Filter options and report views
Filter options
Use the following filter options to customize report results.
| Filter option | Description |
|---|---|
| Date | Defaults to the first day of the current month. Filters by the payout's estimated arrival date. |
| Payout | Filters by payout ID. You can locate and select a payout ID by entering the partial ID such as the last four digits. |
| Customer | Filters by customer name. |
| Invoice | Filters by customer invoice number. |
Summary view
After you select your filter options, the Payout page displays the Summary view that includes grand totals and high-level payout details. To view more information on the payments and refunds in a payout, click the payout ID to open a detailed view.
| Column | Description |
|---|---|
| Payout ID | The payment processor's unique identifier for the payout. |
| Est. Arrival Date | The estimated date the payout arrived in your bank account. |
| Initiated Date | When the payout was created. |
| Status | The payout's status: Paid Out, Pending, In Transit, Canceled, or Failed. In Transit payouts do not include a clickable details link. |
| Method | Standard or Instant. Instant payouts are loans against soon-to-be-processed standard payouts. See the Instant Payouts article for more information on this type of loan. |
| Payments | The number of payments in the payout. |
| Refunds | The number of refunds in the payout. |
| Gross | The overall amount of the payout(s) before fees are deducted. |
| Fees | The total fees deducted from payments as well as fees applied to instant payouts. |
| Capital Deduction | If an owner has a Stripe Capital loan, this column displays loan repayment amounts. |
| Net | The net payout amount (Gross minus Fees). This is what's deposited to your bank account. |
Detail view
The Payments, Refunds, and Instant Payout window provides a detailed view of each payout.
| Field | Description |
|---|---|
| Est Arrival Date | The date the payout is estimated to arrive in your bank account. |
| Initiated Date | When the payout was created. |
| Status | The payout's status: Paid or In Transit. |
| Payment Gross | The payout batch total before fees. |
| Fees | The processing fees applied to the payout. |
| Capital Deductions | If the payout includes a Stripe Capital loan payment, this field lists the loan repayment amount. |
| Payment Net | The payout total minus fees (Payment Gross minus Fees and Capital Deductions). |
| Customer | The customer's name. |
| Date Issued | Date of the individual payment or refund. |
| Transaction Type | Payment (manual), Automatic Payment, or Refund. |
| Payment Status | Payment status. |
| Payment Method | Card, Bank, or Sunbit (payments collected via Skimmer's Consumer Financing solution). |
| Invoice Number | Customer invoice number. |
| Memo | Payment memo. |
| Payment Gross | The amount paid by, or refunded to, the customer before fees. |
| Payment Fee | The processing fees for the payment. |
| Payment Net | The payment amount after processing fees or the refund amount. |
| Reference | The unique ID for the payment or refund. This ID also appears in QuickBooks Online for reconciliation. |