Reconciliation
The Reconciliation dashboard in Reveal Settlements traces funds from customer payment to bank deposit across every connected Gateway Account. Finance and accounting teams use it to confirm that captured volume is paid out, spot settlements that are delayed, and match provider settlement batches against entries on their bank statements.
To open it, select Settlements from the toggle at the top center of the dashboard. If you have not connected a payment processor yet, start with Get started with Settlements.
Reconciliation overview
The overview summarizes how money moves through your payment stack for the selected period and filters.
- Authorized, Captured, and Settled KPI cards report the total volume paid by customers, the volume transferred to your merchant account, and the volume paid out to your bank account. Toggle each card between Amount and Transactions.
- The Reconciliation trend chart plots Authorized Volume against Settled volume over time, so you can see how quickly funds reach your bank account.
- The Unsettled volume aging chart groups funds that have not yet settled by how long they have been outstanding.
- The Gateway account summary table compares total transactions, total volume, settled transactions, settled volume, and unsettled percentage for each connected Gateway Account.
Filter the dashboard by Gateway Account, transaction currency, settlement currency, and date range to focus on a specific segment of your payment flow.
Settlement summary
The Settlement summary groups settled amounts by Gateway Account and settlement currency, so you can see how each processor contributes to the total amount deposited in your bank account. When a Gateway Account settles in more than one currency, each currency appears as a separate row. All amounts render in the settlement currency.
| Column | Description |
|---|---|
| Gateway Account | The connected payment processor account. Non-Chargebee gateways are labeled Provider. |
| Settlement currency | The currency the processor settles funds in. A Gateway Account can settle in multiple currencies. |
| Total Captured | Total captured volume for the Gateway Account and settlement currency. |
| Net Refunds | Refunds deducted from the settled amount. |
| Net Chargeback | Chargebacks deducted from the settled amount. |
| Transaction Fees | Processing fees charged by the provider. |
| Platform Fees | Platform fees charged by the provider. |
| Net Settlement | Final amount deposited to your bank account, after refunds, chargebacks, and fees are deducted from captured volume. |
Settlement details
The Settlement details view breaks the summary down to individual settlement batches, so your finance team can reconcile a specific payout against the corresponding entry on your bank statement. Amounts render in the settlement currency.
| Column | Description |
|---|---|
| Gateway Account | The connected payment processor account for the batch. |
| Settlement Date | The date the batch was paid out. |
| Settlement ID | The provider's settlement batch reference, used to match the payout on your bank statement. |
| Total Captured, Net Refunds, Net Chargeback, Transaction Fees, Platform Fees, Net Settlement | The same measures as the Settlement summary, calculated for the individual batch. |
Filter and export
Both the Settlement summary and Settlement details support the same filters—Gateway Account, transaction currency, settlement currency, and date range—so you can isolate a provider, currency, or reporting period. Export the filtered data to feed your accounting and month-end close workflows.
Match settlements with bank entries
Use the Settlement details view to reconcile each payout against your bank statement:
- Filter to the Gateway Account, settlement currency, and date range you are reconciling.
- Match each batch to a bank deposit using the Settlement ID and Settlement Date.
- Confirm the Net Settlement amount equals the deposited amount. If it does not, use Net Refunds, Net Chargeback, Transaction Fees, and Platform Fees to account for the difference between captured volume and the deposit.
Was this article helpful?