Convert Credit Card Statement PDF to Excel BRS Mapping Rules
Convert Credit Card Statement PDF to Excel BRS Mapping Rules
Learn how to convert credit card statement PDFs to Excel. Extract merchant names, transaction dates, and map business expenses.
Who is this for: Documentation
Corporate credit cards are widely used to manage travel, utilities, software subscriptions, and minor business expenses.
However, credit card statements use complex layouts that vary by issuer. Merged columns and billing interest summaries can complicate direct data entry. This guide details how to clean and convert credit card statements into Tally-ready PDF templates.
1. Typical Credit Card Statement Columns
A credit card statement includes these standard columns:
- Transaction Date: The date the purchase was made.
- Posting Date: The date the bank processed the transaction.
- Description / Merchant Details: The name and location of the merchant.
- Amount: The transaction value.
- Cr/Dr: Transaction type indicator (credits represent card payments).
2. Separating Card Payments from Purchases
Credit card statements use a single amount column with Cr/Dr indicators to identify payments vs. purchases:
To import these entries, separate purchases and payments into separate columns based on the Cr/Dr indicator before importing the file into Tally.
3. Credit Card BRS Mapping Output Schema
| Statement Original Column | Tally Target Column | Conversion Check |
|---|---|---|
| Transaction Date | Date | Ensure transaction date is used, not posting date |
| Description | Narration | Extract merchant name and location |
| Amount & Cr/Dr | Withdrawal / Deposit | Separate columns created based on Cr/Dr flags |
Convert Credit Card Statement PDFs Instantly
TrulyInvoice parses complex credit card statement PDFs, standardizes date formats, merges split rows, and exports clean PDF templates for Tally.
Founder & Chief Architect of TrulyInvoice