Spreadsheets

Credit card statement PDF to Excel: pull out only the transactions

Convert a credit card statement PDF to Excel and keep only the transaction table: drop summary boxes, sign payments and refunds, and check the date range.

Editorial illustration for Credit card statement PDF to Excel: pull out only the transactions

A credit card statement PDF mixes a summary box, offers, reward points and the real transaction table, and a converter copies all of it. Keep only the table rows, mark credits as negative amounts so payments and refunds do not look like spending, and check every date falls inside the statement period.

Step one: cut everything that is not a transaction

After conversion, scroll the sheet and note where the transaction table starts and ends. Everything above (total dues, minimum due, credit limit boxes, payment due date, reward summary) and below (offers, important notices, fine print) can go. Copy the sheet first so you keep the raw conversion.

  1. Delete the rows above the table's own heading, keeping the heading.
  2. Delete the notices and promotional lines after the last transaction.
  3. If the heading repeats on each page, filter the first column for the heading word and delete those rows, keeping the first.
  4. Filter the Date column for blanks and look at what is left. Offer text and totals usually hide here.

How do I handle payments and refunds?

A card statement has two kinds of lines that point the opposite way to a purchase: your own bill payments, and merchant refunds or reversals. Many statements mark them with Cr after the amount or with a minus sign, but layouts differ, so check your own. If the amount column is text such as 1,250.00 or 5,000.00 Cr, this formula in D2 turns it into a signed number, positive for spending and negative for credits:

  • =VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(C2),"CR",""),",","")))*IF(ISNUMBER(SEARCH("CR",C2)),-1,1)

It strips the commas and the CR marker, converts what is left to a number, then multiplies by minus one when the marker was there. Fill it down and format the column with two decimals.

Next, separate the two kinds of credit. A label column tells them apart, for example in E2:

  • =IF(D2>=0,"Spend",IF(ISNUMBER(SEARCH("payment",B2)),"Card bill payment","Refund or reversal"))

Change the word payment to whatever your statement prints on bill payments. The point is that a bill payment is money moved from your bank account, not a refund and not income, so it must stay out of any spending total.

What should the spending total be?

Line typeHypothetical amountCounts as spending?
Purchases and online charges₹46,800Yes
Refund or reversal of a purchase₹2,300Reduces spending
Card bill payment₹30,000No
Fees and interest lines₹450Yes, label them separately

With those numbers, spending is 46,800 minus 2,300 plus 450, which is ₹44,950. Fees are real costs, so keep them visible instead of mixing them into merchants.

Did I keep the statement period?

Write the period's first and last dates from the statement header into two cells, say H1 and H2, as real dates. Then count the rows that fall outside it:

  • =COUNTIFS($A$2:$A$500,"<"&$H$1)+COUNTIFS($A$2:$A$500,">"&$H$2)

The answer should be 0. Anything else means a date was misread (day and month swapped is the usual cause) or a line from another statement page crept in. Dates that are still text will not be counted by COUNTIFS, so confirm with =COUNT($A$2:$A$500) that the number of dates equals the number of transactions.

Does the cleaned sheet agree with the statement?

  • Previous balance plus purchases and charges, minus payments and credits, should give the new total due printed on the statement.
  • The count of rows should match the number of transaction lines on the PDF.
  • Add a column for the card name or last four digits, so two cards pasted into one sheet can be told apart later.

SpendixAI lets you pick the account, such as a particular card, before you import, and each transaction keeps that account. You can upload a card statement PDF, CSV or Excel file and review the rows before saving. Odd layouts may still need a careful read.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports