Finance / CSV

Credit Card Statement Analyzer

Summarize charges by category and merchant from a CSV statement.

No data sent or stored
Built for real, messy CSVs

Most people read a credit card statement for exactly one number: the balance due. Everything that explains that number, the dozens of charges that built it up, scrolls past unexamined. Yet that detail is where the useful story lives.

This tool reads a CSV statement and reorganizes it two ways, by category and by merchant, so the pattern behind the total becomes visible. It is an estimate built from your own data, processed on your device, meant to inform rather than to advise.

Loading tool…
Next step CSV to Excel Converter Turn one or more CSV files into a downloadable Excel workbook.

Your data never reaches us

Nifty Utilities has no backend server, database, user accounts, or endpoint capable of receiving your tool inputs. Files and entries are processed inside your browser. We cannot view, capture, or store them.

Spending by category

The analyzer assigns each charge to a category by matching keywords in the merchant description, then totals each category. Typical buckets include groceries, dining, transportation, utilities, subscriptions, shopping, and healthcare. Seeing the categories ranked by size tells you immediately where the money concentrates, and where a change would move the needle most. Because the assignment comes from text matching, it is approximate: a fuel station that also sells snacks, or a warehouse club spanning several categories, can land in a bucket you would have chosen differently. Read the breakdown as a map of proportions, not a precise ledger.

Spending by merchant

The merchant view normalizes descriptions so the same business groups together even when the statement prints it several ways, then totals what you spent at each one. This is often more revealing than the category view, because it surfaces the specific places that quietly add up. A single restaurant visited weekly, or one online retailer hit on impulse, can rival an entire category. Ranking merchants by total spend turns a vague sense of "I eat out too much" into a concrete, named figure you can actually react to.

Consider a clean export from a major issuer, where merchant names are tidy, versus a messier file where one store appears under three slightly different strings. Normalization is what lets both produce a single honest total per merchant rather than fragmenting the spend.

Total activity and the sanity check

The analyzer also reports total transaction volume for the period. Credits, returns, and payments arrive as negative amounts and are handled separately from purchases, so they do not inflate your spending totals. One practical use of the total is a sanity check: compare it against the statement balance before payments to confirm you uploaded the full period and nothing was truncated.

  • A single merchant whose weekly visits quietly rival a whole category.
  • Subscriptions scattered across the statement that add up once grouped.
  • Mixed-purpose stores that a keyword cannot categorize precisely.
  • Returns and credits that should reduce, not inflate, a category total.
  • A partial export that ends mid-period and understates the real picture.

How to use this tool

Download a CSV from your card issuer's website or app, then select it here. The analyzer reads the file in your browser, looking for date, description, and amount columns, including files that split debit and credit. Nothing is transmitted or stored; the analysis is computed locally and discarded when you reload or close the page. If you want proof, disconnect from the internet first, the summaries still generate, because no server is involved.

Frequently asked questions

What CSV format does it expect?

At minimum a date, a description or merchant name, and an amount column. Most major issuers offer a CSV or spreadsheet download from the account activity page. Files that use separate debit and credit columns instead of one signed amount are also supported.

Is it safe to upload my statement?

Your file is never uploaded. It is read by code running in your browser and never sent to a server, and nothing from it persists after you close the page. The processing is local in the same sense a desktop app would be local.

Why are some charges in the wrong category?

Categorization depends on keywords in the description, and statement descriptions are often abbreviated or coded. A store that sells across categories, or one with an opaque name, can be assigned imperfectly. Use the category view for proportions and the merchant view, which is more reliable, for specifics.

Does this tell me what I should do with my money?

No. It summarizes your own spending so you can draw your own conclusions. The figures are estimates derived from text matching, not financial advice, and they are best treated as a starting point for your own review.

Important

This tool provides estimates and general-purpose documents, not financial, tax, legal, or professional advice. Verify important results before relying on them.

Support

Problem with this tool or suggestions for improvement? Please email support@niftyutilities.com.