Money tips

A 15-minute month-end close for three accounts and a card

A worked 15-minute month-end close for three bank accounts and one credit card: import, clear unknowns, match the card bill, compare to budget and note.

Editorial illustration for A 15-minute month-end close for three accounts and a card

You can close a month for three bank accounts and a credit card in about fifteen minutes by following a fixed order: import each statement, clear the unknown items, match the card bill so it is not counted twice, compare spending with your budget, and write a short note. The order matters, because the card step only makes sense once everything else is in.

What is the order of operations?

StepTimeTask
14 minutesImport statements for three accounts and the card
23 minutesClear unknown items
33 minutesMatch the card bill and mark transfers
43 minutesCompare spending with budget
52 minutesWrite a note for next month

Step one: how do you import four statements quickly?

Download each statement after the month has ended, for the full calendar month. Upload them one at a time, picking the right account before each import. SpendixAI asks you to choose the account first, keeps that account with every transaction, and shows an import history with a status for each upload. Review the rows before saving, and watch for any flagged as possible duplicates if a statement overlaps the previous one.

Step two: what do you do with unknown items?

Sort by category and look for anything marked unknown or uncategorised. Fix what you recognise; leave a few for the weekly check if you do not. Aim to finish with fewer than five unknowns so the totals are trustworthy.

Step three: how do you match the card bill?

The card bill is the trap. Your bank account shows one payment to the card company, while the card statement shows the individual purchases. If you count both, the same money is spent twice on paper. Count the card purchases as spending, and treat the bill payment as a transfer between your own accounts.

Here is a hypothetical month. The salary account paid rent and bills of ₹9,800 and moved ₹25,000 to the household account, ₹5,000 to the bills account, and paid the card bill of ₹18,650. The household account spent ₹21,300 on groceries, fuel and the like. The bills account spent ₹3,100. The card carried purchases of ₹18,650.

SourceCounted as spendingTreated as transfer
Salary account₹9,800₹25,000 + ₹5,000 + ₹18,650 = ₹48,650
Household account₹21,300None
Bills account₹3,100None
Credit card₹18,650None

Real spending is ₹9,800 + ₹21,300 + ₹3,100 + ₹18,650 = ₹52,850. If you forgot to set the transfers aside, you would add ₹48,650 and report ₹1,01,500, which is nearly double the truth.

Step four: how do you compare with the budget?

Say the month's budget was ₹55,000. Your real spending of ₹52,850 is ₹2,150 under. Now look at the categories rather than the total: which ones exceeded their limits and which had room? Pro includes budgets, bills and savings goals in SpendixAI, and the Report builder lets you filter and group by category when you want to dig into one line.

Step five: what should the note say?

Write two or three lines in your own words: what was different this month, any one-off items, and one thing to try next month. Example: Delivery was high during the guests' visit; the geyser repair of ₹4,200 was a one-off; cap delivery at ₹6,000.

A quick close checklist

  1. All four statements are imported for the whole month.
  2. Unknown items are fewer than five.
  3. Transfers and the card bill are set aside from spending.
  4. Totals are compared with the budget.
  5. The note is written and saved.
SPENDIXAI JOURNAL

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

Explore your reports