Cards and UPI

Adding up a year of credit card statements into one summary

Add up a year of credit card statements into one summary: monthly totals, spending by category, fees and rewards, with a simple method for PDF-only records.

Editorial illustration for Adding up a year of credit card statements into one summary

To add up a year of credit card statements, take the new-charges total from each of the twelve statements, add them in a sheet, then split the year by category and pull out fees and rewards as their own lines. For a PDF-only record, you can do the whole thing by hand in about an hour with one extra column per statement.

Use the financial year, April to March, if the summary is for tax or accounts, and the calendar year if it is just for you. Pick one and stay with it.

Step one: monthly totals

From each statement, note the statement month and the total of new purchases, not the total due. The total due includes old balances and would count money twice. Here is a hypothetical year.

Statement monthNew charges (₹)Statement monthNew charges (₹)
April18,400October31,200
May21,250November24,500
June16,900December27,900
July19,800January15,800
August22,600February18,950
September17,350March20,350

Add the first column: 18,400 + 21,250 + 16,900 + 19,800 + 22,600 + 17,350 = ₹1,16,300. The second column: 31,200 + 24,500 + 27,900 + 15,800 + 18,950 + 20,350 = ₹1,38,700. The year is ₹2,55,000, and the monthly average is 255,000 divided by 12, which is ₹21,250. In a sheet with the twelve totals in B2 to B13, these formulas do it:

=SUM(B2:B13)

=AVERAGE(B2:B13)

Step two: split by category

This is where PDF-only records take time. For each statement, write a category beside every line, then total by category. In a sheet with one row per transaction, categories in column B and amounts in column C down to row 500, the total for one category is:

=SUMIFS($C$2:$C$500, $B$2:$B$500, "Dining")

Repeat for each category, then check that the category totals add up to the year's total. If they do not, some line has no category or a typo in its name, such as Dinning.

Step three: pull out fees, refunds and rewards

  • Fees and charges: annual fees, late fees, finance charges and the tax lines next to them, kept in one fees category.
  • Refunds: credits that reduce the year's spend; keep them in the category they came from.
  • Payments you made: leave these out, because they repay the bill and are not spending.
  • Rewards or cashback: note what you actually received from the statements or the card's rewards page, and do not estimate.

What does the summary tell me?

Three things. Which categories are the largest, which months spiked and why, and what the card cost you in fees against what it gave back in rewards. In the example above, October is far higher than the others; a quick look at that statement might show festival shopping or a large annual bill.

When a sheet stops being enough

Twelve statements, a few hundred lines, hand-typed categories: it is doable but tedious. SpendixAI takes card statements as PDF, CSV or Excel, lets you review rows before saving, and then offers an overview, a library of 25 ready-made reports and a Report builder you can filter and group, plus a CSV download. Each card keeps its own account, so the year's totals can be split by card.

Questions your summary should answer

  • Which three categories took the most money?
  • Which month was the highest, and what caused it?
  • What did the card cost in fees, and what did it return in rewards?
  • Which recurring charges ran all twelve months?

Before you file it away

  1. Check that the twelve monthly totals add up to the year.
  2. Check that the category totals add up to the same figure.
  3. Save the summary next to the twelve statements.
  4. Write one line on what you will change this year.
SPENDIXAI JOURNAL

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

Explore your reports