Statement Processing Guide - Lakshmi Personal Finance Assistant
Overview
Comprehensive guide for extracting, parsing, and processing Indian bank and credit card statements. Focus on accurate transaction categorization, reconciliation, and anomaly detection.
SBI Statement Processing
PDF Format Structure
State Bank of India statements typically follow this structure:
- Header: Account holder name, account number (last 4 digits shown: xxxxXXXX)
- Statement period: From Date to Date
- Opening Balance: Balance at statement start
- Transaction Table: Columns for Date, Description, Withdrawal, Deposit, Balance
- Closing Balance: Final balance at period end
Key Fields to Extract
- Date: Transaction date (DD-MM-YYYY)
- Description: Merchant name, transaction type
- Withdrawal: Amount debited from account
- Deposit: Amount credited to account
- Balance: Running balance after transaction
- Cheque Number: If applicable (for check payments)
Common SBI Transaction Types
- Self Transfer: Transfers between own SBI accounts
- Third Party Transfer: NEFT/RTGS/IMPS to other accounts
- Card Debit: Credit card bill payment
- Cash Withdrawal: ATM withdrawal (may show "Withdrawal")
- Direct Debit: Standing instructions, auto-debits
- Deposits: Check deposits, cash deposits
Other Major Indian Bank Formats
HDFC Bank
- Clean tabular format with Value Date and Transaction Date
- Clear NEFT/RTGS indicators
- Mobile app transactions often labeled "Mobile Banking"
- Credit card number ending visible in transaction
ICICI Bank
- Date, Transaction details, Amount, Balance columns
- Clear "Dr" (Debit) and "Cr" (Credit) notation
- Mobile app: "M-Banking" prefix
- Insurance/Bill payments clearly marked
Axis Bank
- Transaction date, Value date separation
- Merchant Name and Merchant Location columns
- Online transfer codes (IBANKS, ONLINE)
- Card transactions: Card number last 4 digits shown
Kotak Bank
- Detailed description with reference number
- Clear categorization of transaction type
- Mobile banking transactions clearly marked
- International transactions shown in INR and foreign currency
Credit Card Statement Parsing
Key Information to Extract
- Statement Date: Billing cycle period
- Card Details: Card type (Visa, Mastercard, RuPay), last 4 digits
- Opening Balance: Amount due from previous statement
- Current Charges: All transactions in billing period
- Minimum Due: Minimum payment required
- Total Due: Full amount due
- Due Date: Payment deadline (usually 25th of next month)
Credit Card Transaction Details
- Transaction Date and Posted Date (may differ)
- Merchant Name and Category (often pre-categorized)
- Amount in Rupees
- Foreign currency transactions (if any)
- Reference/Transaction ID
Card Transaction Categories (Pre-assigned)
Many cards automatically categorize:
- Food & Dining
- Travel & Transport
- Shopping
- Entertainment
- Bills & Utilities
- Cash Advance
- Other
UPI Transaction Identification
Common UPI App Formats
- Google Pay (GPay): Shows beneficiary name, UPI ID or phone
- PhonePe: Clear merchant name and reference ID
- Paytm: Shows as "Paytm Wallet" or direct merchant
- BHIM: Government UPI app, shows IFSC codes
- WhatsApp Pay: Increasing usage for P2P
Bank Statement UPI Display
When UPI shows in bank statement:
- Appears as debit entry
- Description: Beneficiary name/merchant name
- Reference number: UPI Transaction ID (16-digit)
- Amount: Exact value transferred
Identification Rules
Identify UPI from bank statement if:
- Description contains "@okaxis", "@okhdfcbank", etc.
- Amount is exact (no extra charges)
- Merchant name identifiable (Zomato, Amazon Pay, etc.)
- Reference number format matches UPI ID
Transaction Categorization from Merchant Names
Merchant-Based Automatic Categorization
Food & Dining
- Swiggy, Zomato, UberEats → Food/Eating Out
- Starbucks, Café names → Food/Chai-Coffee
- Restaurants (by name recognition) → Food/Restaurants
- BigBasket, Blinkit, Instamart → Food/Groceries
Transport
- Ola, Uber, Rapido → Transport/Ride-sharing
- Indian Railways → Transport/Public Transport
- IOCL, BPCL, Shell → Transport/Fuel
- DailyHunt Commute → Transport (if applicable)
Shopping
- Amazon, Flipkart, Myntra → Shopping/Online
- Nykaa, Uniqlo → Shopping/Apparel or Personal Items
- Best Buy India, Croma → Shopping/Electronics
Bills & Utilities
- TATA Power, BESCOM, KSEB → Bills/Electricity
- Water Board, Municipal Corporation → Bills/Water
- Airtel, Vodafone, Jio → Bills/Mobile-Internet
- Insurance companies → Bills/Insurance
Entertainment
- BookMyShow, Amazon Prime Video → Entertainment
- Netflix, Disney+, Hotstar → Entertainment/Streaming
- Audible, Kindle → Entertainment/Books
Health
- Pharmacy names (Apollo, Fortis) → Health/Medicines
- Doctor consultation apps → Health/Doctor Consultation
- PathLabs, Diagnostic centers → Health/Medical Tests
- OYO Health, Apollo 24/7 → Health/Doctor
Education
- Udemy, Coursera, Great Learning → Education/Courses
- Unacademy, Byju's → Education/Coaching
- Flipkart Books → Education/Books
Investments
- HDFC Securities, ICICI Direct → Investments/Stocks
- AMC names (Blackrock, HDFC Mutual) → Investments/Mutual Funds
- NSE, BSE → Investments/Stocks
Bank Statement Reconciliation
Monthly Reconciliation Process
-
Extract Opening Balance from statement
-
List All Transactions chronologically
-
Compare with Manual Log
- Match dates, amounts, and descriptions
- Mark matched entries
- Flag unmatched entries
-
Check Discrepancies
- Transactions in statement but not logged: Add to log
- Transactions in log but not in statement: Verify if pending
- Amount differences: Check for split expenses or rounding
-
Verify Closing Balance
- Opening + Deposits - Withdrawals = Expected Closing
- Compare with actual statement closing
- Should match exactly (within paisa)
Reconciliation Checklist
- Opening balance matches last month's closing
- All deposits accounted for
- All withdrawals accounted for
- Closing balance calculated correctly
- No duplicate transactions
- All pending transactions identified
Handling Duplicate Transactions
Duplicate Identification
Duplicates occur when:
- Same amount, merchant, date appears twice
- Authorization hold and actual debit both recorded
- System processing error on bank's side
Duplicate Resolution
-
Hold vs Debit: If hold amount + actual debit visible
- Keep actual debit transaction
- Remove authorization hold
- Calculate net as single transaction
-
True Duplicates: Identical entries
- Contact bank for reversal
- Document reference number and date
- Wait for correction
-
Similar but Different:
- Check time of transaction
- Verify merchant name exactly
- Confirm amounts match precisely
Flagging Suspicious/Unknown Transactions
Red Flag Categories
Unauthorized Transactions
- Transaction description doesn't match any merchant
- Amount unusually large
- Merchant name misspelled or suspicious
- Unrecognized beneficiary name
- Late night transaction to unknown account
Potential Fraud Indicators
- Multiple transactions to same unknown account
- Rapid succession of transactions
- Round amount numbers (suggests manual entry)
- Foreign transactions if no travel
- Cash withdrawal immediately followed by transfer
Action Items for Suspicious Transactions
- Note transaction reference number
- Log date, amount, merchant name
- Check if recent: < 3 days = still disputable
- Initiate dispute with bank if unauthorized
- File complaint for fraud if multiple unauthorized
- Update bank on account security concerns
Statement Import Best Practices
- Format Consistency: Standardize date format to DD-MM-YYYY
- Merchant Name Cleaning: Remove extra characters, spaces
- Amount Format: Numbers only, no commas or currency symbols
- Categorization Consistency: Apply rules uniformly across months
- Documentation: Keep original PDFs for reference
- Backup: Store digital copies in secure location
- Privacy: Never share account numbers or full details
Monthly Processing Workflow
- Download latest bank statement PDF
- Extract transactions in spreadsheet
- Categorize each transaction using merchant rules
- Identify and flag suspicious entries
- Reconcile with manual expense log
- Verify opening and closing balances
- Check for duplicates and anomalies
- Generate monthly report
- Archive original statement
- Note any outstanding transactions