Records
Records in Reveal Settlements is where teams verify the data behind insights and dashboards. It provides the underlying transaction and settlement line items so you can filter, inspect, and export records to validate a finding, go deeper on a payout or fee issue, or support operational workflows such as month-end close and audits.
Settlements Records lists settled transactions across your connected Gateway Accounts, with settlement amount, fees, settlement date, and Settlement ID so finance and accounting teams can confirm that expected revenue reached the bank. Open it when a summary on Reconciliation or Fees is not enough, or when you need line-level evidence after an insight from Transactions.
To open Records, select Settlements from the toggle at the top center of the dashboard, then select Records in the left navigation. If you have not connected a payment processor yet, start with Get started with Settlements.
Why use Records
Records shortens the path from a dashboard signal to line-level proof:
- Before you open Records, you usually spot a signal on Insights or a Settlements dashboard: unsettled aging or a mismatched batch on Reconciliation, blended-rate or outlier fees on Fees, or a performance finding you need to validate at transaction level.
- In Records, you filter to the same Gateway Account, settlement currency, Settlement ID, or date range, then inspect the individual charges, refunds, and fees that make up the payout or finding.
- After you leave Records, you can export the filtered set for accounting systems, share evidence with auditors, or confirm that a fee or settlement discrepancy is resolved.
The business outcome is faster, more accurate validation: less time assembling data, fewer mismatches between processor reports and bank deposits, and a clear audit trail from insight to transaction line item.
What the Records table shows
The Records table combines payment details with settlement details for each settled transaction. For Chargebee merchants, Gateway Account labels appear as Gateway Account (other merchants may see Provider).
| Column | Description |
|---|---|
| Amount | Transaction amount in the transaction currency. |
| Date | Transaction date and time. |
| Txn. type | Transaction type such as Payment (Charge), Refund, or Dispute. |
| Status | Current status of the transaction (for example, Success, Refunded, or Disputed). |
| ID at gateway | The transaction ID assigned by the payment processor. Non-Chargebee merchants may see this as Provider Txn. ID. |
| Method | Payment method used for the transaction. |
| Gateway Account | The connected payment processor account. Non-Chargebee merchants may see this as Provider. |
| Customer Country | Country associated with the customer. Non-Chargebee merchants may see this as Country. |
| Settlement amount | Amount settled for the transaction in the settlement currency. |
| Fees | Processing fees associated with the transaction. |
| Settlement date | Date the processor settled the transaction. |
| Settlement ID | Processor settlement (payout) identifier. Use this to match a bank deposit to the transactions included in that payout. |
Settlement-specific columns (Settlement amount, Fees, Settlement date, and Settlement ID) appear only on Settlements Records. They are what distinguish this view from Transactions Records, which focuses on authorization and decline analysis rather than payout validation.
Filter Records
Use the date selector and filters to narrow the table to the payout or segment you are validating. Filters available on Settlements Records include:
- Date range: Limit records to a transaction date window (for example, the period covered by a bank deposit).
- Transaction Currency: Focus on transactions charged in a specific currency.
- Settlement Currency: Focus on transactions settled in a specific currency when a Gateway Account settles in more than one currency.
- Type: Limit to Payments (Charges), Refunds, or other transaction types.
- Gateway Account: Restrict results to one connected processor account.
- Payment Method: Filter by method (for example, card or wallet).
- Amount, Fee Amount, and Settlement Amount: Find transactions within an amount range.
- Settlement ID: Jump to every transaction included in a specific processor payout.
- ID at gateway: Look up a single processor transaction ID.
Common workflows:
- From a settlement batch on Reconciliation, copy the Settlement ID and paste it into the Settlement ID filter to list every transaction in that payout.
- When fees look high on Fees, filter by Gateway Account and date range, then sort or scan the Fees column to find the line items driving the cost.
- When a bank deposit is short, filter by Settlement Currency and date range, then compare Settlement amount totals against the bank entry.
Export Records for accounting
Click Export to generate a download of the currently filtered Records set. Reveal creates an asynchronous export (shown as Records Exports) that finance teams can use for month-end close, audit packages, or import into accounting tools.
Exports use the same filters you applied on the page, so you can export only the Gateway Account, Settlement ID, or date range under review rather than the full history.
How Records fits in the Reveal workflow
Reveal is organized so teams move from signal to proof:
- Insights surfaces what matters first.
- Transactions explains payment performance and root cause.
- Settlements validates money and costs (reconciliation and fees).
- Records verifies the underlying transaction and settlement data so you can filter, inspect, and export evidence.
Within Settlements, the usual path is:
- Reconciliation surfaces what settled, what remains unsettled, and which settlement batches landed in your bank account.
- Fees surfaces cost trends and fee outliers across providers.
- Records verifies the line items so you can prove a mismatch, confirm a fee, or hand auditors a filtered export.
Use Records when you need line-level evidence. Stay on Insights, Transactions, Reconciliation, or Fees when a summary or recommendation is enough.
Take the next step
- Reveal overview: See how Insights, Transactions, Settlements, and Records work together.
- Reconciliation: Match settlement batches to bank deposits and monitor unsettled aging.
- Fees: Compare blended rates and investigate fee outliers.
- Get started with Settlements: Connect processors if Records is empty.
See also
Was this article helpful?