Budgeting

First review after importing a year of statements: what to look at

What to look at first after importing a year of bank statements: check coverage and gaps, fix top merchants, read the twelve-month shape, then pick three questions.

Editorial illustration for First review after importing a year of statements: what to look at

After importing a year of statements, do not start with totals. First check that all twelve months really came in and that nothing is double-counted. Then fix the merchants that matter most, look at the shape of the year, and pick three questions to answer. That order protects you from drawing conclusions from incomplete data.

Step one: did every month arrive?

Count the months that have transactions for each account. A gap is easy to miss because the rest of the year still looks full. The strongest test is continuity of balances: each month's opening balance should equal the previous month's closing balance.

Say you import twelve months but only ten statements parsed. June closes at ₹38,200 and the next month that appears, September, opens at ₹21,900. July and August are missing, and during those two months the account fell by 38,200 − 21,900 = ₹16,300 net. Without that check, you might think the year was cheaper than it was.

What does a missing-month gap do to the numbers?

If the ten months you have add up to ₹5,80,000 of spending, the average is 5,80,000 ÷ 10 = ₹58,000 a month. A twelve-month year at that rate is closer to 58,000 × 12 = ₹6,96,000, which is ₹1,16,000 more than the figure you would have reported. And July and August may include festival or travel costs, so the true figure may be higher still. Treat annual totals as incomplete until the gap is filled.

CheckWhat to look forWhat to do
CoverageA month with no rowsDownload or upload that statement
ContinuityOpening balance not equal to last closingLook for a missing period
DuplicatesSame amount, same merchant, within two daysDelete or merge the copy
AccountsRows assigned to the wrong accountReassign before reviewing

Where do you check import problems in SpendixAI?

The import history shows the status of each upload, and an Import failed notification tells you when one did not go through. Possible duplicate imports are flagged, and the Possible duplicate charges report lists the same amount to the same merchant within two days. Before importing, choose the right account, because every transaction keeps its account. If you spend in more than one currency, set your base currency first, since it cannot be changed once transactions exist. A statement layout that does not parse perfectly can still be reviewed row by row before saving.

Step two: which merchants should you fix first?

  1. Sort by total spend and take the top ten merchants.
  2. Make sure each is in a sensible category.
  3. Merge names for the same shop that appear in different forms.
  4. Set rules for the recurring ones, so next month's items are categorised automatically.

Ten merchants will often cover a large share of what you spend, so a few minutes here improves the whole year. You do not need to fix every line.

Step three: what is the shape of the year?

View the twelve months as a line or a column chart, and look at the pattern before the numbers. Are there spikes in October or November? A dip in the months you travelled? A slow rise after a rent change? The shape tells you where to look. A flat year with one tall month points at a single event; a rising year points at habits and fixed costs.

Step four: what three questions will you answer?

Resist answering everything. Pick three, written as questions.

  • Which category grew the most from the first quarter to the last?
  • What do my fixed costs add up to each month, and how much is left?
  • Which single month surprised me, and why?

Answer them in a few lines each, and then decide one change. A year of data is a good start, but the habit of looking each month is what makes it useful.

Before you call it done

  • Twelve months present, or the gaps noted.
  • Duplicates cleared.
  • Top ten merchants in the right categories.
  • Three questions written and answered.
SPENDIXAI JOURNAL

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

Explore your reports