How to Reconcile Payment Gateway Settlements with Sales

Use separate records for sales, payments, settlements and bank movements. An order reference helps connect them, but do not assume an order, an invoice and a successful payment are the same event.

• ✓Sales and customer receipt records showing invoice or order references, payment allocations and amounts.
• ✓Gateway transaction export showing payment identifiers, order references, amounts, statuses and transaction times.
• ✓Settlement report showing batch identifiers, included transactions, deductions, adjustments and payout references.
• ✓Refund and dispute records, including links to the original payment and any later reversal.
• ✓Bank statement covering the reconciliation period and subsequent receipts needed to trace outstanding payouts.
• ✓Previous month's closing schedule of unsettled collections and unresolved exceptions.

Keep the original exports and note their filters, time zone and download time. Check which event each date represents: payment completion, batch creation or bank credit. Read the gateway's report definitions before combining files.

Start with individual payments. Use the gateway payment identifier as the main matching reference where your sales system stores it. Otherwise, build a cross-reference through the order identifier and confirm the amount and payment status.

1. Identify which gateway status confirms a completed collection under that provider's definitions.
2. Match each completed payment to its sales record, customer advance or other supported receipt allocation.
3. For partial payments or multiple payments against one invoice, retain every payment identifier and reconcile their combined allocation.
4. Check in both directions: gateway collections without a sales allocation, and sales marked paid without a matching gateway collection.
5. Record unmatched items individually. Do not match solely because two amounts happen to be equal.

Next, group matched payments by the settlement batch assigned in the gateway report. Build a bridge from the batch's gross collections to its expected payout. Include only deductions and additions supported by that batch's details.

Use this working calculation: gross collections included in the batch, less documented deductions, plus documented credits, equals expected payout. Read each adjustment's description and sign before including it. Do not assume every negative entry is a fee.

Match the expected payout to the bank using its payout reference and amount. If one batch has several bank credits, or a credit covers several batches, retain the report that explains the grouping. A matching monthly total alone does not prove the individual payouts are correct.

Carry the verified bank entries into your monthly bank reconciliation routine. The related guide on bank reconciliation for a small business explains the wider bank check; this gateway schedule supplies the detail behind these particular receipts.

Illustrative example only: a shop has matched Rs 1,25,000 of completed collections to sales and receipt records. Its settlement report lists the following movements. The amounts are invented to demonstrate the calculation and imply no standard fee or settlement policy.

This batch balances, but the sales check remains separate. Confirm that the original collections are allocated correctly and that each deduction has been recorded once. A correct net receipt does not establish that every underlying entry is correct.

• Fees: compare the deducted amount with the supporting fee record and your agreed terms. Check whether it was already booked elsewhere before posting it.
• Refunds: link the refund identifier to the original payment and customer adjustment. Distinguish a refund request from evidence of a completed refund.
• Chargebacks: retain the dispute reference, debit amount, current status and response owner. Track any later credit separately against the same dispute.
• Other adjustments: require an explanation for holds, releases, reversals or corrections appearing in your reports. Keep their references through later settlements.

Do not deduct an item twice because it appears in both a transaction export and a settlement report. Use its identifier to establish whether the reports describe the same movement.

This guide excludes GST treatment of sales, fees, refunds and credit notes. Confirm those questions with your chartered accountant and current official CBIC guidance. The reconciliation checks the movement and its evidence; it does not decide tax eligibility or reporting.

Separate collections awaiting settlement from payouts reported as sent but not yet credited by the bank. For each outstanding item, record its amount, payment or batch identifier, current status and expected next event, using the provider's actual terms.

Prepare a roll-forward: opening unsettled balance, plus collections, less supported deductions, plus supported credits, less bank receipts, equals closing unsettled balance. Explain that closing figure with individual pending items. Keep unexplained differences separate.

Check subsequent bank receipts against the carried-forward items. Do not change a sale's date merely to make it agree with a bank credit. Use the related month-end close checklist to place this review alongside the other monthly finance checks.

Use one row per unresolved difference. Include the amount, currency, payment or batch reference, date first identified, owner, next review date, evidence and closure reason. The examples below show useful exception categories.

Keep resolved rows with their evidence. At each monthly close, review older open items first and distinguish documented timing differences from items requiring investigation.

• Treating the net bank receipt as the sales total without explaining deductions.
• Comparing totals without matching individual payments and batches.
• Forcing a difference into fees without supporting evidence.
• Combining several gateways or currencies before reconciling each separately.
• Closing an exception because support replied, before checking the actual correction.

This worksheet needs adapting where another party collects and settles the money, or where cash and direct bank transfers share the sales register. Identify the actual collection route first, then reconcile its records separately.