Getting started

Why imported totals don't match my bank statement's totals

Imported totals not matching your bank statement? Skipped rows, reviewed-out rows, other-period charges and refunds are common causes. Here is a tie-out.

Editorial illustration for Why imported totals don't match my bank statement's totals

When imported totals do not match your bank statement, the difference almost always comes down to a handful of rows rather than a calculation error. Rows may have been skipped in reading, left out during review, dated outside the period, or treated as credits when you expected them as negative spending.

Compare the same things first

Before hunting for causes, make sure you are comparing like with like. A statement's printed totals usually cover its own period only, and they may include or exclude things your tracker treats differently. Check the dates on both sides and the account selected, then compare debits with debits and credits with credits.

Why might the debit total be lower in the tracker?

  • Rows were skipped when the file was read, for example lines broken by a page boundary.
  • Rows were removed in the review step because they looked like junk, but were real.
  • A charge posted to the bank after your file period ended and so sits in the next file.
  • The file covered a slightly shorter range than the printed total.

Why might the debit total be higher?

  • A total or footer row was imported as if it were a transaction, which doubles the figure.
  • Overlapping files brought some rows in twice.
  • A reversed or refunded payment was kept as a debit while its credit was treated separately.

Why do credits look off?

Refunds are the usual culprit. If a shop refunds ₹1,200, your statement shows a credit. In a tracker that credit offsets spending, but it also raises the credits total. So a bank's credit total includes salary, refunds, interest and transfers received, while you may be thinking only about salary. Reconcile the list, not just the sum.

A four-line tie-out

Say your statement for the month prints opening balance ₹30,000, total credits ₹85,000, total debits ₹64,500 and closing balance ₹50,500. First check the statement itself: 30,000 + 85,000 - 64,500 = 50,500, which matches.

Now your tracker shows credits of ₹85,000 and debits of ₹62,300. The credits agree, so look at debits. The gap is 64,500 - 62,300 = ₹2,200. Scan your statement for debits that add to ₹2,200: perhaps two rows of ₹1,100 and ₹1,100, or one rent-split transfer. Find those in the review list or import history, and you have your answer.

LineStatementTrackerDifference
Credits₹85,000₹85,000₹0
Debits₹64,500₹62,300₹2,200
Rows to find2 or more-Look in skipped or reviewed-out rows

What should I do next?

  1. Check that the date range and account match the statement.
  2. Compare debits and credits separately, not the net.
  3. Sort the tracker's list by amount and match it to the statement line by line for the largest items first.
  4. If a row is missing, add it by hand or re-import that file after checking the review step.
  5. If a row is extra, delete it and confirm the total again.

SpendixAI shows import history and lets you review rows before saving, which are the two places to look. Once the totals agree, the month is safe to build a budget on.

What if I left rows out on purpose?

A printed total covers every line on the statement, including entries you may have deliberately skipped, such as a transfer between two of your own accounts. List each deliberate exception before you start, so the tie-out accounts for it. If the difference left after that is still unexplained, it is a genuine gap, and the amount is your clue. Say the gap is ₹2,200 and you find a ₹2,000 row and a ₹200 row. Two rows, one explanation: both were left out in review. Write down which rows you removed and why, so next month's check is quicker.

If a difference remains after all this, keep the statement and the tracker side by side and ask your bank about any entry you cannot identify. Do not edit amounts to force a match.

SPENDIXAI JOURNAL

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

Explore your reports