How do I analyze a credit card statement?
By the Karchu Editorial Team · Last updated
Short answer
To analyze a credit card statement, extract the transactions into a table and split them into five groups: purchases, refunds, payments to the card, fees and interest. Only purchases count as spending. Then normalise the merchant descriptors so the same shop groups together, assign categories, and total by category and merchant. Finally compare those totals against previous statements, and check separately for recurring subscriptions, foreign transaction charges and duplicate charges. The comparison, not the single statement, is where the useful findings are.
How it works
A card statement looks like a bank statement and behaves differently. The balance is a debt rather than a holding, the period does not follow the calendar, and the credit column mixes four kinds of event that mean four different things.
So the first real step is classification. Purchases are spending. Refunds reduce spending. Payments to the card are transfers and are not spending at all. Interest and fees are the cost of the card itself, and belong in their own bucket rather than diluted across categories. Get this split wrong and every total after it is wrong.
Next comes the descriptor problem. Card lines carry processor text, not shop names, so the same merchant can appear under several strings within one statement. Normalising that text is what makes grouping by merchant meaningful, and grouping by merchant is what makes subscriptions and price rises visible.
Only then is it worth totalling. Category totals, merchant totals, fee totals, and the same figures for the previous two or three periods next to them. Differences are the output of the exercise.
Examples
A statement shows 4,120 of debits and 1,900 of credits. The credits turn out to be a 1,800 payment to the card and a 100 refund. Spending for the period is 4,120 minus 100, not 2,220.
Twelve lines across the year read as three different strings for the same streaming service. Normalised, they group into one merchant at 14.99 a month for eight months and 17.99 for four, which is a price increase nobody noticed.
A holiday produces 22 converted purchase lines and 22 small fee lines. The purchases were budgeted. The fees, totalled, come to more than a day of the trip.
Benefits
You get a spending figure that is actually spending, a clear view of what the card itself costs in interest and fees, a list of every subscription with its annual cost, and an early sighting of charges you did not authorise.
For a business card, the same analysis produces categorised expenses ready for the books, with receipts attachable per line.
Common mistakes
Treating every credit as a refund, which understates spending and flatters the month.
Counting the card payment as an expense alongside the purchases it settled, which double counts everything.
Comparing a statement period against a calendar month budget and concluding that spending changed when only the window did.
Importing two consecutive statements whose periods overlap, so every transaction in the overlapping days is counted twice.
Ignoring interest and fees because they are small individually. Totalled over a year they are frequently the largest single merchant on the statement.
Frequently asked questions
Why does the statement period not match the calendar month?
Card statement periods run from a closing date, not from the first of the month, so a period typically spans parts of two calendar months. If you compare a card statement against a calendar month budget you will be comparing different windows. Either align everything to statement periods or extract the transactions and re-bucket them by date.
Are payments to the card counted as spending?
No. A payment to the card is a transfer from your bank account, and the spending already happened when the purchase was made. Counting both the purchase and the payment double counts the money. Bank and card statements analysed together must have these transfers recognised and excluded.
Why do merchant names look nothing like the shop?
The description is a payment descriptor set by the merchant's payment processor. It often contains a legal entity name, a store number and a city rather than the brand you interacted with. Grouping spending requires normalising that text first, otherwise one merchant looks like a dozen.
How do I find the true cost of using the card abroad?
Foreign purchases usually appear as a converted amount with a separate foreign transaction fee, sometimes on another line. Total those fee lines for the trip and add any difference between the network rate and the rate applied. Looking only at the converted amounts hides the cost entirely.
What should I check for on every statement?
New payees, charges well above your history with a merchant, duplicate amounts within a few days, subscriptions that increased in price, interest you did not expect, and the total of fees. Five minutes on those covers most of what a statement can tell you.
How Karchu helps
Karchu reads card statements as PDF or CSV, including scanned ones, classifies purchases, refunds, payments, fees and interest, and normalises merchant descriptors so grouping works. Categories come from rules you can read and edit.
It detects recurring charges and price increases, separates foreign transaction costs, recognises transfers between your own accounts so a card payment is not counted twice, and skips transactions already imported when two statements overlap, telling you how many were skipped so you can inspect them.
No bank credentials. Statement files only.
Sources
Related reading
Guides
- Docs: statement analysis
Transactions, reconciliation, duplicates, categorization and reports.
- Docs: duplicate detection
Signals used, overlapping statement periods, and inspecting skipped rows.
- Docs: categorization
The six layer order and why an explicit rule always wins.
Features
- Bank statement analyzer
Upload a statement and get categorized transactions in minutes.
- Credit card statement analyzer
Purchases, refunds, payments, fees and interest separated properly.
- Financial statement analysis
Income, spending and category totals across every account.
Comparisons
- Karchu vs Excel
What a spreadsheet costs you in time.
- Karchu vs QuickBooks
Analyzer against a full accounting suite.
- Karchu vs Xero
Where a statement analyzer fits alongside Xero.
Use cases
- Karchu for freelancers
Separate business from personal without a spreadsheet.
- Karchu for accountants
Client statements in, categorized ledgers out.
- Karchu for bookkeepers
Month-end close without manual data entry.