Can I use Contra vouchers for credit card payments?

Contra vouchers in Tally are intended for transfers between cash and bank accounts. If your credit card ledger is set up under the 'Bank OD A/c' group, Tally will allow you to record bill payments using a Contra voucher (F4).

How do I claim GST Input Tax Credit (ITC) on credit card purchases?

To claim GST, record the transaction as a Purchase Voucher (F9) or Journal Voucher (F7) instead of a simple payment. Debit the expense ledger and CGST/SGST, and credit the Credit Card ledger.

What is the cost of TrulyInvoice's automation engine?

TrulyInvoice offers flat pricing of plans starting at ₹399/month for 1,000 pages, supporting credit card and bank statement sync actions to your Tally company files.

Is it better to create a credit card ledger under Bank OD or Current Liabilities?

Creating it under the 'Bank OD A/c' group is recommended because it enables Tally's native bank reconciliation features for checking transactions against the bank records.

Import Credit Card Statements in Tally Prime: Step SOP

Credit Card BRS SOP

Quick Answer: How Do I Import Credit Card Statements into Tally Prime?

To import credit card statements into Tally Prime, create a credit card ledger grouped under "Bank OD/OCC" (or Current Liabilities), download the monthly statement in Excel/CSV, map transaction dates, merchant descriptions, and expense heads, and import via automated XML or Excel connector.

Ledger Group: Group credit card ledger under Bank OD/OCC for proper reconciliation
Transaction Modes: Purchases recorded as Journal (F7) / Payment (F5); repayments as Contra (F4)
Expense Mapping: Auto-categorize recurring merchant charges (Uber, AWS, Office supplies)
Zero Manual Entry: Use automated OCR/Excel import to push hundreds of line items in seconds

In modern business operations, corporate credit cards are widely used for recurring SaaS subscriptions, software licenses, travel, Google and Meta ad campaigns, and miscellaneous office expenses. While convenient, credit cards present a bookkeeping challenge: a single monthly statement can contain dozens of small transactions that must be recorded.

Manually typing credit card statements into TallyPrime takes hours and increases the risk of accounting errors. This guide details how to configure credit card ledgers, apply correct accounting entries, structure PDF files for import, and automate the process.

Step 1: Configuring the Credit Card Ledger in TallyPrime

Before importing transactions, you must configure the credit card ledger correctly in Tally. Since a credit card balance represents money owed to the bank, it is classified as a liability.

Path to Create Ledger: Go to Gateway of Tally > Create > Ledger.

Ledger Name: Name the ledger clearly (for example, HDFC Visa Corporate Credit Card).
Group Under: Select Bank OD A/c or Loans (Liability). Selecting Bank OD A/c is recommended because it enables Tally's built-in Bank Reconciliation features, allowing you to check transactions against the statement.
Set Bank Details: Provide the card limit details under the Bank account configuration if you want to track limits inside Tally.

Step 2: Accounting Treatment for Credit Card Transactions

Credit card transactions typically fall into three categories: business purchases, bank fees, and card balance payments. Use this accounting matrix to record them:

Transaction Type	Debit Ledger	Credit Ledger	Recommended Voucher Type
Business Purchase (e.g. SaaS Subscription)	Software Subscription Expense	Corporate Credit Card A/c	Payment (F5) or Journal (F7)
Annual Card Fee / Interest Charges	Bank Charges Expense	Corporate Credit Card A/c	Payment (F5)
Paying Card Bill from Current Account	Corporate Credit Card A/c	Current Bank Account	Contra (F4) or Payment (F5)

Step 3: Handling GST Input Tax Credit (ITC)

To claim Input Tax Credit (ITC) for business purchases paid via credit card, you must record the transaction as a Purchase Voucher (F9) or Journal Voucher (F7) rather than a simple Payment.

For example, when recording a Google Ads payment:

Debit Advertising Expenses (Taxable Value).
Debit CGST / SGST / IGST (Tax amount).
Credit Corporate Credit Card A/c (Total amount).

Using a Journal or Purchase voucher ensures that GST components are tracked for reconciliation in your GSTR-2B filing.

Step 4: Structuring Excel Statements for Tally Import

To import a credit card statement using Excel, you must format the sheet to align with TallyPrime's transaction mapping template. Clean the sheet by following these layout guidelines:

Date Column: Standardize the format to DD-MM-YYYY or YYYYMMDD.
Description Column: Clean transaction descriptions to help Tally identify expense categories (for example, mapping "ADOBE*SYSTEMS" to software expenses).
Amount Columns: Ensure withdrawals (purchases) and deposits (bill payments) are split into separate columns. Remove currency symbols and commas.

Automating Credit Card Statements with TrulyInvoice

Manual formatting is a repetitive chore. Credit card statements do not conform to standard bank formats, which often causes typical spreadsheet converters to fail.

TrulyInvoice provides a template-independent AI parser designed to handle varying credit card statement layouts:

Multi-Format Recognition: The OCR parser identifies statement tables from Visa, Mastercard, and American Express formats across banks like HDFC, ICICI, and Axis Bank.
Description to Ledger Mapping: If a narration contains keywords like "Google Cloud" or "Adobe", TrulyInvoice matches them to your corresponding software expense ledgers.
Secure Local Sync: Connects to TallyPrime over a secure Port 9000 connector, syncing transactions directly to your books.
Flat Pricing: Offers flat pricing of **plans starting at ₹399/month** for 1,000 pages, avoiding credit limits and per-page fees.