Credit card statement converter

A card statement has two halves. The summary box at the top tells you where the account stands; the transaction list below tells you how it got there. Both are read. The transactions come out one per row — date, description, the category where the issuer prints one, and the amount — and the summary comes out as its own block in the Excel workbook, so the figures you would otherwise copy by hand are already there.

Interest and fees are easy to miss when they are a line or two on each statement. Converted, they are a filter away: the summary block of each statement gives the cycle's fees charged and interest charged, and the transaction rows show each annual fee, late fee or foreign transaction fee on its own line. Add up twelve statements and you have the true cost of carrying the card for a year — a figure worth knowing before a balance transfer or a renewal.

For a business, interest and card fees are usually deductible expenses; for a household, they are the clearest number in a budget review. Either way, they are now in a column instead of scattered across twelve PDFs.

Each card purchase is an expense once. The monthly payment that settles the card is not a second expense — it is money moving from the bank account to the card. Put bank and card statements in the same workbook and that payment appears on both sides: as money out of checking and as a payment on the card.

In a spreadsheet, filter by source file or exclude card payments from the bank side. In accounting software or Quicken, import the card into its own credit card account — the card .QBO and .QFX are written as credit card files for exactly this reason — and record the payment as a transfer.

Freelancers and small business owners often pay most business costs by card, which makes the card statements the best single record of the year's expenses. Convert all twelve, merge them, and the year's spending is in one sheet you can categorise: software, travel, equipment, advertising, meals. The interest and fees lines sit in the same sheet.

If the card mixes business and personal spending, add a column and mark each row — your tax preparer will ask for that split anyway. US sole proprietors can work from there towards Schedule C; see Schedule C from bank statements for how the categories map. Card interest on business borrowing belongs in the same review. Keep the PDF statements and the receipts behind the larger items: the converted sheet is the summary, they are the evidence.

The question comes up every renewal, and the answer is in the statements. Each converted statement records the rewards points earned where the issuer prints them, and the transaction rows show the annual fee and any other fees. A year merged gives you points earned, fees paid and interest charged side by side. Put a value on the points as your issuer redeems them and the comparison with the fee is one line of arithmetic. Do the same for two cards and you can see which one actually earns its place in your wallet, using a year of your own spending instead of the issuer's examples. If the fee is close to what the points are worth, the interest and late fees in the same sheet usually settle the question.

Older card statements, or ones received by post, convert from a scan or a photo. They are read with OCR and then checked against the summary like any digital statement, so a misread figure shows up as a statement that does not add up rather than as a wrong expense in your report. Scan flat, one statement per file, with the summary page included — it is what the check needs.

The identity behind every card statement is the same, but the layout is not. Some issuers list payments and purchases together by date; others split them into sections. Some print a category for every charge; most do not. Some put the summary on the first page, others at the end. Because the converter reads the statement rather than a template, the layout does not need to be known in advance.

What does differ by issuer is where you find the statements and what else the issuer lets you download. Our issuer pages cover that for American Express, Chase, Capital One, Citi and Discover, with details checked on each issuer's own site.

For many households the credit card, not the bank account, is where day-to-day spending happens: groceries, fuel, subscriptions, eating out. The bank statement then shows one large card payment a month and hides everything that matters for a budget inside it. The card statement is where the detail lives.

Convert three months of card statements and the picture is usually clear: sort by description to find every subscription, total by category where the issuer prints one or add your own, and compare month against month. Our guide to categorising transactions suggests a simple set of categories to start with. Because each statement is checked against its own summary, the totals you build match what the issuer billed — the budget starts from real numbers, not an estimate. Repeat it each quarter and the trend is there too.