Corporate Card Reconciliation: A Guide for India

If your finance team spends the first week of every month hunched over spreadsheets, matching corporate card transactions to expense claims line by line: you already know the problem. Corporate cards are great for Indian businesses. HDFC, ICICI, Axis, SBI, Kotak all offer solid programmes with spend controls, real-time alerts, and detailed transaction data. The card part works fine. It's everything after the swipe that breaks down.

The real challenge? Closing the loop between a card transaction and a properly documented, policy-compliant, GST-reconciled entry in your books. Companies with 50+ corporate cards typically burn 3-5 days every month just on reconciliation. This guide walks through a systematic approach to fix that: less processing time, more recovered GST credits, and books that are actually audit-ready.

Why Card Reconciliation Is So Painful in India

You're trying to match three separate data streams that don't speak the same language: the bank's card statement, employee expense claims, and your accounting entries. Each has its own timeline, format, and level of detail. Doing it manually is where everything falls apart.

The Three-Way Matching Problem

• Bank statement: Transaction date, merchant name (usually abbreviated beyond recognition), INR amount (or foreign currency for international transactions), and a reference number. That's it. No business purpose. No expense category. No GST breakup.
• Employee expense claim: Business purpose, category, receipt details, GST amount, approval status. But the claimed amount might not match the card statement exactly: thanks to currency conversion rounding, tips, or split billing.
• Accounting entry: Needs the right GL account, cost centre, GST treatment (ITC-eligible or blocked), and TDS applicability. Neither the card statement nor the expense claim alone gives you enough information. You need both, plus the finance team's judgment.

What Makes India Different

Indian card reconciliation has complications that don't exist in most other markets:

• GST invoices aren't optional: A card statement or payment confirmation won't work for ITC claims. Employees need a proper GST tax invoice (with the company's GSTIN) from every vendor.
• Statements come late: Indian bank corporate card statements typically land 3-7 days after the billing cycle closes. Your finance team is working blind during that gap.
• Mixed personal and business use: Some companies allow limited personal spending on corporate cards. That means extra steps to separate personal charges and ensure repayment.
• Forex headaches: International transactions show up in INR at the bank's conversion rate, which almost never matches the RBI reference rate or the original vendor bill. You have to account for the difference as forex gain/loss.
• Unreliable merchant codes: MCCs on Indian bank statements can help with auto-categorisation, but accuracy is hit-or-miss. A restaurant payment might show as "eating places" or "miscellaneous retail." Good luck automating around that.

"Card reconciliation is the last-mile problem of expense management. Companies automate approvals and digitise receipts, then spend days matching card transactions to claims in spreadsheets. The fix isn't a better spreadsheet: it's getting rid of the spreadsheet."

Start With a Good Card Policy

Reconciliation gets a lot easier when you've got a solid corporate card policy that prevents messy exceptions from happening in the first place.

What Your Card Policy Should Cover

1. Who gets a card: Define which roles qualify. Typically, employees who travel frequently (4+ trips per quarter) or make regular business purchases. Junior employees might get cards with lower limits.
2. Spending limits by grade: Set both per-transaction and monthly limits. Example: INR 25,000/transaction for managers, INR 75,000 for senior management, INR 2,00,000 for CXOs. Layer on category-specific caps too (hotels capped at INR 8,000/night, etc.).
3. 48-hour receipt rule: Every card transaction needs a receipt uploaded within 48 hours. This is the single most important rule for clean reconciliation. The longer employees wait, the worse the error rate gets.
4. Banned transactions: ATM cash withdrawals, personal purchases, crypto, gambling, and anything at merchants that have no business relevance.
5. Personal use repayment: If you allow limited personal use, spell out the repayment process. Personal charges must be flagged within 72 hours and repaid via salary deduction or direct payment within the same billing cycle.
6. GST invoice mandate: Employees must ask for a GST tax invoice (not just a payment receipt) for every card transaction. The invoice must carry the company's GSTIN. This one rule alone can boost your ITC recovery significantly.

The Reconciliation Process, Step by Step

A structured process beats the month-end scramble every time. Here's what the best Indian finance teams do.

Step 1: Import the Transaction Feed

Pull the card transaction feed from your bank. HDFC, ICICI, Axis, and Kotak all provide data in CSV, Excel, or API format. You'll get:

• Transaction date and posting date
• Merchant name and location
• Amount in INR (plus original currency for international transactions)
• Merchant category code (MCC)
• Last 4 digits of the card (identifies the cardholder)
• Reference/authorisation number

Step 2: Match Transactions to Expense Claims

Match each card transaction against what employees have submitted:

• Primary match: Last 4 digits + transaction date + exact amount (or within 2% for forex rounding).
• Secondary match: If primary fails, widen the date range by +/- 2 days (posting delays happen) and use approximate amount matching.
• Manual review queue: Anything that doesn't match (card transactions without claims and claims without card transactions) goes to a human.

Step 3: Validate Receipts and Invoices

For matched transactions, check the documentation:

• Does the receipt amount match the card transaction?
• Does the GST invoice have the company's GSTIN, supplier's GSTIN, HSN/SAC code, and tax breakup?
• Is the invoice date consistent with the transaction date? (1-2 day gaps are normal for hotels.)
• Does the expense category match the merchant type and invoice description?

Step 4: Process GST Input Credits

Pull GST details from validated invoices:

• Verify the supplier's GSTIN against the GSTN database.
• Confirm the expense category is ITC-eligible. Remember: food and beverages, health clubs, and motor vehicles (with limited exceptions) are blocked under Section 17(5) of the CGST Act.
• Cross-check against your GSTR-2B auto-populated data: has the supplier filed their GSTR-1 for this transaction?
• Flag any gap between the ITC amount on the invoice and what shows in GSTR-2B.

Step 5: Post to General Ledger

Get the reconciled transactions into your books:

• Debit the right expense account (travel, entertainment, supplies, etc.).
• Debit GST input credit for the ITC-eligible portion.
• Credit the corporate card liability account.
• Personal charges? Debit employee advance/receivable.
• Forex transactions? Book the exchange rate difference to forex gain/loss.

Step 6: Reconcile Against the Bank Statement

The final check:

• Does the opening balance match last month's closing balance?
• Is every transaction in the statement reflected in your books?
• Any orphan items? Those are usually transactions where the employee never submitted a claim. Chase them down.
• Process the card payment (typically NEFT to the bank) and record the payment entry.

When to Automate (Hint: Probably Now)

Manual reconciliation stops working somewhere around 20-30 corporate cards. After that, it's just not worth the person-hours.

What Good Automation Does

• Real-time card feeds: Transactions import automatically via API or secure file transfer. No more downloading CSVs from your bank portal.
• Smart transaction matching: Fuzzy matching on amounts, dates, and merchant names that accounts for the weird abbreviations and name variations on Indian bank statements.
• OCR receipt processing: Extracts amount, date, vendor, GSTIN, and GST breakup from receipt photos, then validates them against card transaction data.
• GSTIN verification: Real-time checks against the GSTN database, with alerts for invalid or cancelled registrations.
• Auto-categorisation: Uses merchant codes, vendor history, and receipt details to categorise expenses. Manual intervention becomes the exception, not the rule.
• Direct GL posting: Integration with Tally, Zoho Books, SAP, or other accounting systems. Journal entries get created without anyone typing them in.

Exceptions That Still Need a Human

Automation handles the volume. These scenarios still need judgment:

• Split transactions: One business dinner, two card swipes (hotel room and hotel restaurant billed separately). The system should let you link multiple transactions to a single business purpose.
• Refunds and chargebacks: Credits on the card statement need to be matched to the original transaction and the accounting entry reversed.
• Recurring subscriptions: SaaS charges (Zoom, AWS, Google Workspace) that hit monthly should be set up as recurring expected transactions with auto-matching rules.
• Forex conversion gaps: The INR amount on the statement won't match the foreign currency amount times the RBI reference rate. Someone needs to document and book the difference.

How OneFinOps Tackles Card Reconciliation

OneFinOps plugs corporate card reconciliation into your broader financial ops workflow: it's not a bolted-on feature. Your employees shouldn't wait 45 days to get reimbursed.

The platform pulls transactions directly from Indian corporate card providers and matches them against employee expense submissions using algorithms built for the quirks of Indian bank statement formats. Merchant name says "MAKEMYTRIPCOM GURUG"? It still matches to the MakeMyTrip booking your employee submitted.

GST compliance runs through every step. Receipt scanning extracts GSTIN and tax breakup. GSTR-2B cross-referencing happens automatically so you claim every credit you're entitled to. Reconciled entries post straight to your accounts payable and general ledger, no manual journal entries, no month-end data entry marathon.

For teams managing 50+ cards, the time savings pay for the tool. But the bigger win is accuracy: every transaction accounted for, every GST credit captured, every balance sheet entry ready for audit.

Card reconciliation doesn't have to be the monthly ordeal your finance team dreads. A clear card policy, a structured process, and the right automation turn it from a multi-day scramble into something that mostly runs itself. Look at your current process, find the highest-friction points, and automate those first. Your month-end close will feel very different.