Reconciling Online Payments: Matching UPI, Net Banking, and Card settlements automatically.

Every online payment creates two records—one in your system, one in the bank. Matching them manually is tedious and error-prone. Here's how to automate reconciliation and close your books in minutes.

Think about what happens when a parent pays fees online. The money goes through a payment gateway—Razorpay, PhonePe, Paytm, or direct bank transfer. It appears in your bank statement, often with a cryptic description. Meanwhile, in your institute's records, there's a fee entry for that student. At month-end, someone has to match hundreds of these transactions to ensure every payment is accounted for and no money is missing.

Manual reconciliation is a nightmare. Transactions don't line up. Descriptions don't match. UPI payments show up differently than card payments. Bank statements and your records tell different stories. CodePex Campus automates this entire process. Upload your bank statement, and the system matches every transaction automatically. Here's how to go from hours of manual work to fully automated reconciliation.

📉 Why Manual Reconciliation Fails

Mismatched Data

Bank shows "UPI/123456789" — your system shows "Rahul Sharma fees". No obvious match.

Timing Differences

Payment on 31st appears in bank on 1st. Which month do you book it in?

Gateway Fees

Parent pays ₹10,000, but you receive ₹9,800 after gateway charges. Reconciling the difference is tedious.

🤖 CodePex Auto-Reconciliation: How It Works

A complete system that matches your bank statement with your fee records automatically:

🏦

Upload Bank Statement

→

🔍

AI Matching Engine

→

✅

Matched Transactions

→

📊

Reconciliation Report

📤 Step 1: Upload Bank Statement

Navigate to Finance → Reconciliation → Upload Statement. Supported formats:

📊

Excel (.xlsx)

📄

CSV

🏦

PDF (bank format)

🔄

API Direct

System auto-detects columns: date, description, amount, reference number.

🔍 Step 2: Intelligent Matching

CodePex matches bank transactions with fee records using multiple methods:

Matching Method	How It Works	Accuracy
Transaction ID	Matches UPI reference, Razorpay order ID, or bank reference number	99.9%
Amount + Date	Matches exact amount within ±1 day of transaction date	95%
Name Matching	Fuzzy matching on parent/student name from bank description	85%
Amount + UPI/VPA	Matches amount with UPI ID if available in records	98%

✅ Step 3: Review Auto-Matched Transactions

After matching, you see a clear reconciliation screen:

Bank Date	Description	Amount	Matched With	Student	Status	Confidence
15 Mar 2025	UPI/rahu*@okhdfc	₹15,000	Fee Receipt #F-2025-042	Rahul Sharma	Matched	High
15 Mar 2025	NEFT IN SBIN123456	₹22,500	Fee Receipt #F-2025-045	Priya Patel	Matched	High
16 Mar 2025	CARD-7865-PPAL	₹8,500	—	Unknown	Unmatched	Low

⚠️ Step 4: Resolve Exceptions

For transactions that don't auto-match, CodePex provides tools to resolve:

Possible Matches

System suggests potential matches based on amount, date, and partial name matching.

Manual Mapping

Admin can manually link bank transaction to a student or fee record.

Mark as Gateway Fees

Identify transactions that are payment gateway settlements (fees deducted).

Create Adjustment

For small differences (e.g., rounding), create an adjustment entry.

💰 Automatic Gateway Fee Reconciliation

Payment gateways deduct fees before settling. CodePex handles this automatically:

Example: Razorpay Settlement - 15 March 2025

─────────────────────────

Total Payments	₹1,24,500
Gateway Fees (2%)	₹2,490
GST on Fees (18%)	₹448
Net Settlement in Bank	₹1,21,562

─────────────────────────

System automatically:

✓ Matches gross payments to student accounts
✓ Records gateway fees as expense
✓ Reconciles net settlement with bank statement

📱 UPI Payment Matching

UPI payments are especially tricky—bank statements show only VPA, not student name. CodePex solves this:

Bank Entry	Amount	Matched Using	Result
UPI/rahul.sharma@okhdfc	₹15,000	VPA mapped in student profile	Auto-matched
UPI/9876543210@paytm	₹8,500	Mobile number in student record	Auto-matched
UPI/pay*456@okhdfc	₹22,000	Amount + date	Suggested match

📊 Reconciliation Summary

At a glance, see your reconciliation status:

Bank Statement

Total Credits: ₹4,82,500

Total Debits: ₹12,400

Closing Balance: ₹8,45,600

CodePex Records

Total Fees Collected: ₹4,85,000

Gateway Fees: ₹2,500

Net Difference: ₹0 ✅

⏱️ Daily Auto-Reconciliation

Set up daily automatic reconciliation:

• Connect your bank account via API (supported: HDFC, ICICI, SBI, Axis, Yes Bank)
• System fetches statement daily at 6:00 AM
• Auto-matches with previous day's transactions
• Sends reconciliation report to your email by 7:00 AM

📈 Real Results from CodePex Clients

3 days → 15 min

Monthly reconciliation time

For 800+ transactions

100%

Reconciliation accuracy

No more manual errors

₹0

Unreconciled differences

Every rupee accounted for

💬 Success Story

"Before CodePex, reconciliation was the most dreaded task of the month. Our accountant would spend 2-3 days matching bank statements with fee receipts, and there would always be discrepancies. UPI payments were the worst—the bank would just show a VPA, not a name. With CodePex, we now upload the bank statement and within minutes, 95% of transactions are matched automatically. The remaining 5% are easy to resolve with suggested matches. What used to take 3 days now takes 30 minutes. Our books are always accurate, and our accountant is actually happy during month-end."

— Finance Head, leading coaching chain with 6 branches

📋 Reconciliation Reports

✓ Reconciliation Summary — Overall matched/unmatched status
✓ Matched Transactions Report — All successfully matched items
✓ Unmatched Transactions — Items needing attention
✓ Gateway Fee Report — All payment gateway charges
✓ Daily Reconciliation Log — History of all reconciliations
✓ Bank Statement vs System — Side-by-side comparison
✓ Exception Report — Transactions that couldn't be matched

✅ Reconciliation Best Practices

Reconcile daily, not monthly — Small daily tasks beat a huge monthly headache.
Capture UPI IDs at admission — Ask parents for their UPI ID during registration for better matching.
Use consistent payment links — Generate payment links from CodePex so transactions have reference numbers.
Review gateway fee reports — Ensure you're not being overcharged by payment gateways.
Investigate unmatched items promptly — Old unmatched transactions are harder to resolve.

🇮🇳 India-Specific Payment Insights

Understanding Indian payment landscape:

• UPI accounts for 65% of online payments in coaching institutes (PhonePe, Google Pay, Paytm)
• Different banks show UPI descriptions differently—HDFC shows VPA, SBI shows mobile number
• Payment gateway fees range from 1.5% to 2.5% + GST depending on volume
• Weekend payments settle on Monday—timing differences need to be handled in reconciliation

Every rupee accounted for. Every transaction matched.

With CodePex Campus auto-reconciliation, you close your books with confidence—knowing that every online payment is perfectly matched to the right student.