Automated Transaction Ingestion
Automated Transaction Ingestion
The Automated Transaction Ingestion engine is the heartbeat of Credit Card Co-Pilot. It eliminates the friction of manual bookkeeping by automatically syncing your spending data from your digital footprint. By transforming raw bank alerts into structured financial insights, the system ensures your milestone tracking and reward recommendations are always based on your actual spending behavior.
Seamless Multi-Channel Syncing
Credit Card Co-Pilot leverages specialized connectors to capture transactions the moment they happen. The system is designed to work silently in the background, pulling data from the two most common sources of financial notifications:
- Gmail Connector: Using secure OAuth authentication, the app scans your primary inbox for transaction alerts from major banks. It identifies patterns in HTML and plain-text emails to extract merchant names, amounts, and currency.
- SMS Connector: On mobile devices, the app can process incoming transactional SMS alerts. This provides near-instant updates for point-of-sale (POS) swipes and UPI payments, ensuring your "Current Spend" metrics are updated in real-time.
Intelligent Parsing & Normalization
Raw data from bank alerts is often messy and cryptic (e.g., MDR*AMZN_MKTP_BLR instead of "Amazon"). Our ingestion engine performs several layers of processing to ensure your data is readable and actionable:
- Extraction: Pulls the core transaction details—Amount, Merchant, and Currency—from the raw payload.
- Merchant Mapping: Uses a normalization matrix to turn bank-specific merchant strings into recognizable labels.
- Channel Detection: Automatically determines if a transaction was "Online," "POS" (Offline), or "UPI," which is critical for calculating accurate reward rates.
- Categorization: Assigns spend categories (e.g., Dining, Travel, Groceries) to match your credit card's accelerated reward rules.
The Parser Review Dashboard
To maintain the highest level of data integrity, Credit Card Co-Pilot provides a Parser Review interface. While the system is highly automated, it intelligently flags transactions that require human confirmation.
Ingestion Statuses
Each synced event is assigned a status to help you manage your data:
- Parsed: Successfully processed and included in your spending analytics.
- Ambiguous: The system identified a transaction but is unsure about the merchant or the category. These appear in your "Review" queue.
- Failed: The raw alert was recognized, but critical data (like the amount) could not be extracted.
Manual Overrides & Feedback
The Review Dashboard allows you to act as the "Co-Pilot" for the AI. You can:
- Edit Merchant Labels: Correct or simplify merchant names.
- Adjust Amounts: Fix parsing errors if a bank alert format changes.
- Refine Categories: Manually change the transaction channel to ensure you get the right reward recommendations in the future.
Value to the User
- Zero-Effort Tracking: Stop wondering if you've hit your monthly milestone. The app calculates it for you by watching your alerts.
- Precision Recommendations: By knowing where you actually spend (e.g., 40% on Dining), the app can prioritize cards in your wallet that offer the highest multipliers for those specific habits.
- Historical Insights: Build a long-term view of your credit card utility, helping you decide which cards to keep, upgrade, or cancel based on real ROI.
Privacy & Security
Transaction ingestion is handled with a "privacy-first" approach.
- Local Processing: Much of the parsing logic happens directly on your device.
- Consent-Driven: Connectors like Gmail and SMS require explicit user permission and can be disconnected at any time through the Ingestion Settings.
- No Sensitive Data: The system focuses strictly on transaction alerts; it does not access personal emails, passwords, or full bank statements.