Knowledge base topic · 9 entries
Payment Reconciliation
Reconcile payment states, settlement batches, reserves, refunds and crypto exceptions with practical examples, evidence records and approval checks.
Published Updated
Browse the entries in this topic
Understand the topic
Payment reconciliation connects several records that describe different things. A processor can confirm an authorization before money is captured. A settlement report can include a refund from an earlier day. A bank credit can combine hundreds of payments and deduct fees or reserves. Meanwhile, a client or partner ledger records an obligation to a particular person. Treating these records as interchangeable produces attractive dashboards with unexplained balances. This collection helps operations teams establish what happened, what can be booked and what still needs an owner.
Start by naming the flow. A challenge purchase, a trading deposit, a supplier payment and a customer withdrawal do not share one accounting purpose simply because they use the same processor. Record the legal entity, merchant account, transaction currency, settlement currency and internal account involved. Then connect stable identifiers across systems. Keep an original payment reference when a later refund, dispute or adjustment creates a new reference. A timestamp helps investigate the sequence, but it does not replace a transaction identifier.
The examples here use fictional amounts and declared assumptions. Their purpose is to make reconciliation logic inspectable. A reserve example declares its withholding rate and release lag; it does not quote a provider's commercial terms. A foreign-exchange example states the direction of its rate; it does not supply a current market price. Where an external platform's behavior matters, the entry names the provider and links to the relevant documentation. Other providers can use different status names, expiry rules, fee treatment and report signs.
Read the status reference before building a booking rule. Use the three-way reconciliation guide when a provider total, bank amount and internal liability disagree. Reserve and settlement-fee pages explain why a short bank payment is not automatically a missing customer deposit. Refund pages keep the original transaction and each subsequent adjustment visible. The payout matrix focuses on who can authorize an instruction and what happens when its details change. None of these records makes a payment legally or commercially permissible by itself.
Crypto examples add a network layer. An asset ticker alone does not identify a network or token contract, and an observed transfer does not by itself establish final credit. The confirmation-policy page separates chain evidence from an operator's credit decision. The mismatch sheet separates an invoice shortfall from a network fee, overpayment and unmatched transfer. It does not prescribe a universal confirmation count, custody arrangement or automatic return of funds.
Close a reconciliation only when the remaining difference is explained by evidence or recorded as an owned exception. Preserve the source report, its generation time, the transformation rules and the person who approved an adjustment. Reopening a case after a later reversal should add a traceable correction rather than silently changing history. The result is a reproducible account of money movement that another operator can inspect, including where uncertainty remains and which external response is still required.
Published by FxTrusts, a supplier of brokerage and prop firm technology. Prepared with AI-assisted research and drafting; reviewed against the cited public sources. Examples are illustrative. Product links describe our services.
Continue with the broader guides
Connect this reference to platform selection and the wider operating workflow.
References and implementation tasks
- Checklist
Crypto Deposit Confirmations: Network and Credit Policy
Record network, asset, transaction and finality evidence before crediting a crypto deposit, using explicit policy decisions and exception controls.
- Implementation guide
Crypto Underpayments and Overpayments: A Reconciliation Sheet
Compare invoiced and received crypto amounts, network fees and asset identity, then record a controlled resolution without assuming automatic credit.
- Implementation guide
Partial Refunds: Original Amount, Fees and Remaining Balance
Reconcile multiple partial refunds against one captured payment, retaining unique references, pending amounts, fees and the remaining refundable balance.
- Reference
Payment Statuses: Pending, Authorized, Settled and Failed
Distinguish pending, authorized, captured and settled payments, then map provider events to internal booking decisions and exception evidence.
- Checklist
Payout Approval Matrix: Roles, Limits and Exceptions
Define payout roles, thresholds, change controls and exception ownership with an illustrative maker/checker matrix and auditable decision records.
- Reference
Refund vs Chargeback: Ledger and Evidence Differences
Compare refund and chargeback initiators, references, fees and evidence, then preserve separate ledger states for requests, outcomes and reversals.
- Implementation guide
Rolling Reserves: Settlement and Release Calculations
Calculate reserve withholding, scheduled releases and outstanding balances across settlement periods using explicit contract assumptions and records.
- Implementation guide
Settlement FX and Fees: Explain the Net Bank Amount
Explain a net bank settlement by separating transaction currency, conversion, processing fees, reserves and adjustments in a reproducible worksheet.
- Implementation guide
Three-Way Payment Reconciliation for Brokers
Match provider transactions, bank settlements and internal ledger entries, explaining fees, reserves and timing differences before closing exceptions.
