Credit Card EMI Conversion Accounting: Splitting Principal and Interest in Excel

Credit card EMI plans should not be flattened into a single vague transaction. This guide explains how principal, interest, fees and reversals should appear in converted Excel output for accurate bookkeeping and reconciliation.

Last updated 2026-06-12

EMI conversions are the second-hardest credit-card row to parse cleanly, behind FX. They look like ordinary purchases but they're loan repayments — and every accounting tool will treat them wrong unless principal and interest land in separate rows.

What an EMI Line Looks Like on the Statement

The first month carries the conversion entry (the full purchase amount moves into an "EMI" liability) and then every subsequent month carries two lines:

EMI principal — fixed monthly amount that retires part of the loan.
EMI interest — calculated on the reducing balance at the contracted rate.

Banks often print these together with a shared description like "EMI 03/12 BIG TV PURCHASE" — which is exactly why generic converters merge them.

Why the Split Matters for Bookkeeping

In double-entry accounting, an EMI payment is two transactions:

Reduce loan liability — debit "Loan from Bank (EMI)", credit "Bank/Card". This is the principal.
Recognise finance cost — debit "Interest Expense", credit "Bank/Card". This is the interest.

If the converter merges them, you can't post the journals correctly without manually re-splitting every row from the statement PDF — which defeats the point of automating the conversion.

The Correct Excel Layout

Date	Description	Debit	Category
2026-05-05	EMI 03/12 BIG TV PURCHASE - PRINCIPAL	6,250.00	EMI Principal
2026-05-05	EMI 03/12 BIG TV PURCHASE - INTEREST	812.50	EMI Interest

Two rows, two categories. Map "EMI Principal" to the loan liability ledger and "EMI Interest" to finance cost; the QuickBooks/Tally import does the rest.

How to Import This into Accounting Software

The standard CSV format (Date, Description, Debit, Credit, Balance) is fine for both QuickBooks and Tally; just map the Category column to the right ledger.

QuickBooks — set up a "Credit Card EMI" liability account, post principal there, interest to "Interest Expense". Full import flow in PDF bank statement to QuickBooks.
Tally — create a loan ledger under Loan Liabilities for each EMI, with interest posted to "Bank Interest Paid".
Xero — bank rule routes "EMI Principal" to the liability, "EMI Interest" to "Interest Expense".

Foreclosure Charges and EMI Reversal

When an EMI is pre-closed, the statement shows two more rows — a foreclosure fee (P&L finance cost) and the residual principal moving back as a regular debit. ClearlyLedger tags these as "EMI Foreclosure" so they don't get re-classified as new spend.

Convert with EMI rows pre-split

ClearlyLedger splits every EMI row into principal and interest with categories ready for QuickBooks, Xero or Tally.

Convert a Statement Now Read the credit-card guide