Guides & Resources
Payment Gateway Settlement vs Bank Statement Reconciliation: A Complete Guide for Finance Teams
Payment gateway settlement vs bank statement reconciliation is the process of comparing payment gateway settlement reports with bank statement credits to confirm whether gateway settlements were actually received in the bank.
For businesses collecting online payments through gateways such as PayU and PhonePe, the payment gateway report may show successful payments, refunds, fees, deductions, and net settlement values. The bank statement shows the final credit received in bank accounts such as ICICI Bank or Deutsche Bank.
This reconciliation helps finance teams answer:
- Are all PayU and PhonePe settlements received in the bank?
- Are all bank credits supported by payment gateway settlement reports?
- Do gateway net settlement amounts match bank credit amounts?
- Are settlement dates and bank value dates aligned?
- Are refunds, fees, and deductions handled correctly?
- Which settlements are missing, short-settled, duplicated, delayed, or pending review?
For finance teams, payment gateway settlement vs bank statement reconciliation supports cash control, revenue validation, settlement tracking, month-end close, and audit readiness.
What Is Payment Gateway Settlement vs Bank Statement Reconciliation?
Payment gateway settlement vs bank statement reconciliation compares two sides of financial data.
Side A: Payment Gateway Settlement Reports
This includes settlement data from gateways such as PayU and PhonePe. These reports usually show transaction-level or settlement-level values, including payment amount, refund amount, fees, taxes, deductions, net settlement, settlement reference, and settlement date.
Side B: Bank Statement
This includes bank credits received in accounts such as ICICI Bank or Deutsche Bank. These records usually contain credit amount, value date, narration, bank reference, and transaction description.
The goal is to confirm whether the net amount reported by the gateway has been credited to the bank correctly.
Matching is usually based on:
- Settlement reference
- Bank narration
- UTR or bank reference
- Net settlement amount
- Bank credit amount
- Settlement date
- Bank value date
- Gateway name
If the settlement reference and amount match with the bank credit, the transaction can usually be treated as matched. If the settlement exists but the bank credit is missing, it becomes a gateway-only exception. If the bank has a credit but there is no matching gateway settlement, it becomes a bank-only exception.
Why This Reconciliation Matters
Payment gateway settlement reconciliation is important because successful customer payments do not automatically mean cash has reached the bank. Gateways may settle funds after deducting refunds, charges, taxes, disputes, or adjustments.
Without reconciliation, finance teams may face issues such as:
- Gateway settlements missing from bank accounts
- Bank credits not mapped to the correct gateway
- Short settlements after deductions
- Refunds reducing settlement values
- Settlement credited to a different bank account
- Delayed settlement due to holidays or gateway cycles
- Duplicate settlement entries
- Unidentified bank credits
- Month-end cash reporting differences
- Audit queries due to missing bank support
A structured reconciliation process helps finance teams confirm whether payment gateway receivables have converted into actual bank receipts.
Reports Involved
Side A: PayU Settlement Report
The PayU settlement report represents settlement activity from PayU.
Common fields may include:
- Settlement date
- Transaction date
- Settlement reference
- Payment amount
- Refund amount
- Fee or deduction
- Net settlement amount
- UTR or bank reference
This report shows what PayU has settled or expects to settle.
Side A: PhonePe Settlement Report
The PhonePe settlement report represents settlement activity from PhonePe.
Common fields may include:
- Settlement date
- Transaction reference
- Payment amount
- Refund or reversal amount
- Charges or deductions
- Net settlement amount
- Settlement UTR or reference
This report shows what PhonePe has settled or reported for bank transfer.
Side B: ICICI Bank Statement
The ICICI Bank statement represents bank-side credits received in the ICICI account.
Common fields may include:
- Transaction date
- Value date
- Credit amount
- Bank narration
- UTR or reference number
This report confirms whether gateway settlement money was credited to the bank.
Side B: Deutsche Bank Statement
The Deutsche Bank statement represents bank-side credits received in the Deutsche Bank account.
Common fields may include:
- Transaction date
- Value date
- Credit amount
- Bank narration
- Bank reference number
This report confirms settlement receipts credited to the Deutsche Bank account.
How Matching Typically Works
Payment gateway settlement vs bank statement reconciliation usually works by comparing settlement references, bank references, amounts, and dates.
A typical matching process looks like this:
- PayU and PhonePe settlement reports are uploaded.
- ICICI Bank and Deutsche Bank statements are uploaded.
- Gateway settlement references, UTRs, or narration values are compared with bank statement references.
- Gateway net settlement amounts are compared with bank credit amounts.
- Gateway settlement dates are compared with bank transaction or value dates.
- Records are categorized as matched, partially matched, unmatched, or skipped.
For example:
- PayU shows a net settlement of ₹5,00,000 with a settlement reference.
- ICICI Bank shows a credit of ₹5,00,000 with the same or related reference in narration.
- The settlement is treated as matched.
If PhonePe shows a settlement of ₹3,00,000 but the bank credit is ₹2,95,000, it becomes an amount mismatch or short settlement exception.
If a settlement appears in the gateway report but not in the bank statement, it becomes a gateway-only exception.
If the bank statement shows a credit but no gateway settlement is found, it becomes a bank-only exception.
Why Multi-Gateway and Multi-Bank Matching Is Complex
This reconciliation becomes complex because there are multiple gateways and multiple bank accounts.
Challenges include:
- PayU and PhonePe using different settlement formats
- ICICI and Deutsche Bank using different bank narration formats
- Settlement references not appearing clearly in bank statements
- UTR values stored in different columns
- Gateway settlement dates differing from bank value dates
- One settlement being credited as multiple bank entries
- Multiple gateway settlements grouped into one bank credit
- Refunds and deductions reducing net settlement amounts
A good reconciliation process should allow each gateway and bank format to be mapped separately while producing one consolidated reconciliation output.
Common Exceptions in PG Settlement vs Bank Statement Reconciliation
1. Gateway Settlement Missing in Bank
This happens when PayU or PhonePe reports a settlement, but no matching bank credit is found.
Possible reasons include:
- Settlement is pending
- Settlement was credited after the selected period
- Wrong bank account was checked
- Bank statement is incomplete
- Settlement reference is missing in bank narration
- Gateway settlement failed or was held
This exception should be reviewed because the business may be expecting cash that has not yet reached the bank.
2. Bank Credit Missing in Gateway Report
This happens when the bank statement shows a credit, but no matching PayU or PhonePe settlement is found.
Possible reasons include:
- Bank credit belongs to another gateway
- Gateway report is incomplete
- Settlement reference is formatted differently
- Credit belongs to another business source
- Manual bank transfer was received
- Bank narration is unclear
This exception should be reviewed so finance teams can classify unidentified bank receipts correctly.
3. Amount Mismatch
Amount mismatches occur when the reference appears related but gateway net settlement and bank credit amount differ.
Possible causes include:
- Gateway fee deduction
- Refund adjustment
- Chargeback or dispute adjustment
- Tax deduction
- Partial settlement
- Bank charges
- Rounding difference
- Wrong amount field selected
Amount mismatches directly affect cash reporting and receivable tracking.
4. Short Settlement
Short settlement happens when the bank credit is lower than the expected gateway settlement amount.
Possible reasons include:
- Refunds adjusted before settlement
- Gateway charges deducted
- Penalty or dispute recovery
- Prior-period adjustment
- Settlement holdback
- Tax or processing fee deduction
Short settlements should be reviewed with gateway reports and deduction details.
5. Delayed Settlement
Delayed settlement happens when the gateway reports a settlement on one date, but the bank credit appears later.
Possible reasons include:
- Gateway settlement cycle
- Bank processing delay
- Weekend or holiday
- Cutoff timing
- Settlement batch delay
- Value date difference
A delayed settlement may not be an error, but it should be tracked clearly.
6. Duplicate Settlement or Bank Credit
Duplicates may appear in gateway reports or bank statements.
Examples include:
- Same settlement appearing twice in the gateway report
- Same bank credit repeated
- Duplicate file upload
- Same UTR mapped to multiple records
- Reprocessed settlement entries
Duplicates can overstate cash receipts if not identified.
7. Refund and Reversal Impact
Refunds and reversals may reduce net settlement values.
Common issues include:
- Refund deducted from current settlement
- Refund related to older transaction
- Refund visible in gateway but not in internal records
- Reversal adjusted before bank settlement
- Negative entries not handled correctly
Refund-related differences should be reviewed separately from normal payment settlements.
Why Manual Excel Reconciliation Is Difficult
Many finance teams reconcile PG settlements with bank statements manually in Excel.
The usual process includes:
- Downloading PayU and PhonePe settlement reports.
- Downloading ICICI and Deutsche Bank statements.
- Cleaning settlement references, UTRs, and bank narration.
- Separating gateway-wise settlements.
- Comparing gateway net settlement with bank credits.
- Reviewing missing, short-settled, and delayed entries.
- Preparing an exception report.
This becomes difficult when transaction volumes increase.
Common Excel challenges include:
- Different formats for each gateway and bank
- Settlement references hidden inside narration
- UTR values not standardized
- Bank credits grouped differently
- Refunds and deductions mixed with settlements
- Broken lookup formulas
- Duplicate entries missed
- Manual copy-paste errors
- No clear audit trail
A structured reconciliation workflow reduces these risks.
What a Good PG Settlement vs Bank Reconciliation Process Should Include
A reliable process should include:
- Complete PayU and PhonePe settlement reports
- Complete ICICI and Deutsche Bank statements
- Gateway-wise settlement mapping
- Bank account-wise credit mapping
- Matching using settlement reference, UTR, narration, amount, and date
- Net settlement vs bank credit comparison
- Short settlement reporting
- Delayed settlement reporting
- Gateway-only exception reporting
- Bank-only exception reporting
- Duplicate detection
- Audit-ready output
The output should clearly show which settlements reached the bank and which items need follow-up.
How Cointab Helps
Cointab can help finance teams automate payment gateway settlement vs bank statement reconciliation by comparing PayU and PhonePe settlement reports with ICICI and Deutsche Bank statements in a structured workflow.
Finance teams can map settlement references, UTRs, amount fields, narration fields, and dates once and reuse the setup for future periods.
Cointab helps teams:
- Upload PayU, PhonePe, ICICI Bank, and Deutsche Bank reports
- Match gateway settlements with bank credits
- Compare net settlement amounts with bank credit amounts
- Identify fully matched settlements
- Highlight amount mismatches and short settlements
- Show gateway-only and bank-only exceptions
- Review delayed settlements
- Review skipped or invalid records
- Download audit-ready Excel reports
- Reuse the workflow for recurring reconciliation
This reduces manual Excel work and gives finance teams clear visibility into settlement-to-bank differences.
Business Value
Payment gateway settlement vs bank statement reconciliation helps finance teams:
- Confirm gateway settlement receipts
- Improve cash visibility
- Track pending settlements
- Identify short settlements
- Detect unidentified bank credits
- Improve revenue and receivable accuracy
- Reduce month-end close effort
- Strengthen audit documentation
- Reduce manual reconciliation work
It also helps finance teams resolve gateway and bank-level differences faster.
Best Practices
Finance teams should follow these best practices:
- Reconcile gateway settlements with bank statements regularly
- Keep PayU and PhonePe settlement logic separate
- Map each bank account separately
- Use UTR and settlement references wherever available
- Compare net settlement amount with bank credit amount
- Track delayed settlements separately
- Review refund and deduction impact
- Check duplicate UTRs and bank credits
- Maintain period-wise reconciliation history
- Document manual corrections clearly
Conclusion
Payment gateway settlement vs bank statement reconciliation helps finance teams confirm whether PayU and PhonePe settlement amounts have actually been credited to ICICI Bank or Deutsche Bank accounts.
Because this reconciliation involves multiple gateways, multiple bank accounts, settlement references, UTRs, bank narrations, net settlement amounts, credit amounts, refunds, deductions, and date differences, manual reconciliation can become slow and error-prone.
With Cointab, finance teams can automate payment gateway settlement vs bank statement reconciliation, reduce manual Excel work, identify missing or short settlements faster, and generate audit-ready reports for review.
Start your 14-day free trial with Cointab and automate payment gateway settlement vs bank statement reconciliation without relying on manual Excel work. No credit card required.
Visit: https://www.cointab.net/
