Getting started

Import a UK current-account statement into an expense tracker

Import a sterling current-account statement, keep direct debits and savings transfers straight, and check the balance before you save any rows.

Editorial illustration for Import a UK current-account statement into an expense tracker

To import a UK current-account statement into an expense tracker, download the most structured file your account offers, confirm the dates are read day-first, mark transfers to your own savings as transfers, and check that opening balance plus money in minus money out equals the closing balance. The example uses pounds with made-up numbers.

What is different about a current account?

A current account carries things a card does not: salary coming in, direct debits and standing orders going out, and transfers to your own savings. Each needs thought. Salary is income, direct debits are spending, and a move to savings is neither. Treating all outgoing rows as spending overstates your costs. we do not describe any bank's own pages; check how your statement labels each row.

Step by step

  1. Download the statement for whole calendar months, so totals match your budget months.
  2. Open it and confirm the date column reads day first, so 03/04 is 3 April.
  3. Check the amount signs: money out should be negative or in an out column.
  4. Import into the tracker, choosing the correct account first.
  5. Review each row before saving, then tag transfers and income.

A worked example in pounds

Say the account started the month at £1,120.50.

RowAmountCounts as
Salary in£2,450.00Income
Rent, standing order out£850.00Spending
Phone, direct debit out£32.99Spending
Supermarket card payment£61.40Spending
Transfer to savings£300.00Transfer

Closing balance: £1,120.50 + £2,450.00 = £3,570.50, minus £850.00 = £2,720.50, minus £32.99 = £2,687.51, minus £61.40 = £2,626.11, minus £300.00 = £2,326.11. Spending is £850.00 + £32.99 + £61.40 = £944.39. If you counted the savings transfer as spending, you would show £1,244.39 and think you were overspending by £300.

How do you stop repeated imports creating duplicates?

Download non-overlapping periods, or note the last date you imported. If a period overlaps, a good tool flags possible duplicates: SpendixAI, for example, flags possible duplicate imports and shows an import history with each file's status. Still check the rows yourself, particularly two similar amounts on the same day, which can be genuine.

Will a tracker built for India work?

SpendixAI is built around India and INR, and we will not claim it is available or priced for the UK. If you want to try it for a sterling account, remember that the base currency must be chosen before importing and cannot be changed afterwards. A spreadsheet with a transfers column may be the more cautious start.

What if the month has a bank holiday or a delayed payment?

Money sent on a Friday may arrive or leave on a Monday, so a payment you made in March can sit in April on the statement. Decide whether you record by the day you paid or the day the bank posted it, and stay consistent. For budgeting, the statement date is simpler and agrees with the closing balance, while your own notes follow the day you decided to spend. Note any mismatch in the description so a cross-check later does not send you hunting.

How do you record income that arrives in parts?

Not all income lands as one salary payment. A second job, a refund from a shop or a friend repaying you for a dinner each arrives as its own credit. Tag each one with a clear label: salary, side income, refund or repayment. If you do not, the month's income looks higher than your real earnings and the leftover looks better than it is. A repayment from a friend, for example, should reduce the dinner expense, not count as income.

Final checks

  • Import covers whole months.
  • Transfers are tagged and left out of spending.
  • The closing balance matches the statement.
  • Direct debits you did not recognise are investigated through your bank's official channel.
SPENDIXAI JOURNAL

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

Explore your reports