Money basics

Closing balance vs opening balance: how statements chain together

Opening balance vs closing balance on a bank statement: how three monthly statements chain together, and how a gap exposes a missing import.

Editorial illustration for Closing balance vs opening balance: how statements chain together

The opening balance is the amount in the account at the start of a statement period, and the closing balance is the amount at the end. The closing balance of one statement should be the opening balance of the next. When it is not, something is missing in between, such as a month you never imported or a row that failed to save.

How do three statements chain together?

Here are three consecutive monthly statements with hypothetical numbers. Each closing figure is the opening balance plus credits minus debits.

MonthOpeningCreditsDebitsClosing
January₹24,000₹50,000₹46,500₹27,500
February₹27,500₹50,000₹52,300₹25,200
March₹25,200₹50,000₹44,700₹30,500

Check each line. January: 24,000 + 50,000 = 74,000, minus 46,500 is 27,500. February: 27,500 + 50,000 = 77,500, minus 52,300 is 25,200. March: 25,200 + 50,000 = 75,200, minus 44,700 is 30,500. The February closing of ₹25,200 is the March opening, which is exactly how the chain should look.

How does a gap reveal a missing import?

Suppose you imported January and March but forgot February. Your tracker would carry on from the January closing of ₹27,500 and add March's net movement of +₹5,300 (credits 50,000 minus debits 44,700). That gives ₹32,800. The real March closing is ₹30,500. The difference is ₹2,300.

That gap equals February's net movement: 50,000 credits minus 52,300 debits is minus ₹2,300. A gap that matches one month's net is the sign of a missing period. A gap that matches a single transaction usually means one row is missing or was counted twice.

  • Gap equals a whole month's net: a statement was never imported.
  • Gap equals one amount you recognise: one row failed or was skipped.
  • Gap is exactly double an amount: the same row may have been imported twice.
  • Gap is a small odd amount: look at charges, round-offs or a reversed entry.

Why does the statement balance not match my tracker?

Start by confirming the period. Two statements may overlap by a day or have a different cut-off date, so compare like with like. Then check the account: if you track two accounts, make sure the rows are filed under the right one. Finally compare totals, not just balances. Add up the credits and debits in your tracker for the period and compare each with the statement's totals, if the statement prints them.

When you import into SpendixAI, you pick the account first and each transaction keeps it, and the import history shows the status of each upload and flags a possible duplicate. If an import failed, you receive an Import failed notification, which is your cue to check that period.

For the very first statement you import there is no earlier closing balance to test against, so write down its opening balance as your starting point. Every later month can then be checked against the one before. Small credits such as interest paid into the account are easy to overlook when you scan only the large rows, so include them when you add up credits.

What is different on a credit card?

The same chain applies, but the closing balance is what you owe, not what you hold. A card's closing balance also includes fees and interest the issuer added. If your tracker total for the month is lower than the statement's closing movement, a charge line may be missing, such as a late fee or a finance charge. Compare the statement's charges section against your imported rows.

A monthly reconciliation routine

  1. Open the new statement and note its opening and closing balances.
  2. Confirm the opening balance equals last month's closing balance.
  3. Import the statement and review the rows before saving.
  4. Compare your tracker's total credits and debits with the statement's.
  5. If they differ, locate the difference using the pattern list above.
  6. Only then move on to categorising.

Layouts differ between banks and parsing is not perfect for every layout, so reviewing rows before saving is part of the routine, not a formality.

SPENDIXAI JOURNAL

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

Explore your reports