When your tracker and your bank show different balances, the difference is almost always one of three things: a wrong opening balance, a missing stretch of transactions, or pending items. Find the difference in dollars, then check those three in order. Most mismatches take a few minutes to explain.
What does the opening balance do?
A tracker starts counting from the day you first add transactions. If it starts at $0 but your bank account held $2,340.55 that day, every balance afterwards will be $2,340.55 too low. The opening balance is the one number that carries all the history you did not enter.
How do I find the opening balance?
- Choose the first date you want the tracker to cover, say the first of the month.
- Open the bank statement that includes that date.
- Read the balance at the end of the day before. That is your opening balance.
- Enter it as the account's starting figure, dated the day before your first transaction.
How do I check that nothing is missing?
Take the statement for the period and use this equation: opening plus credits minus debits equals closing. Then do the same sum with your tracker's totals. If both sides match, the data is complete.
| Check | Bank statement | Tracker |
|---|---|---|
| Opening balance | $2,340.55 | $2,340.55 |
| Credits | $3,100.00 | $3,100.00 |
| Debits | $2,687.90 | $2,462.90 |
| Closing balance | $2,752.65 | $2,977.65 |
Opening plus credits is 2,340.55 plus 3,100.00, which is $5,440.55. Minus the bank's debits of $2,687.90 gives $2,752.65. The tracker's debits are $225.00 lower, so its closing balance is $225.00 higher. The fault is in the debits, not the opening balance, so you look for a missing $225.00 of spending.
Do the sum separately for credits and for debits, not only for the closing figure. A closing balance can look right when two errors cancel each other: a missing $80.00 deposit and a missing $80.00 expense. Matching the credits total and the debits total separately catches that.
What if the gap is a single missing item?
Sort the statement by amount and look for a debit of exactly $225.00 or for two or three items that add up to it. In our example, say it was a $150.00 car repair and a $75.00 utility bill that you paid on the last day of the month. Add them and 150 plus 75 is $225.00. Enter both and the totals now match.
- Check for a duplicate entry as well: the same $75.00 entered twice makes the tracker's balance too low.
- Check for a transfer between your own accounts entered on only one side.
- Check for a refund entered as an expense instead of income.
What about pending items?
Some transactions show as pending for a day or two. If your tracker counted them and the bank's closing balance did not, the difference vanishes when they settle. Reconcile against a date at least a few days old to avoid chasing this.
Build a habit of reconciling on the same day each month, such as the fifth, using the previous month's closing balance. That keeps each check small. A reconciliation that covers one month takes minutes; one that covers a year can take an evening, and the errors in it multiply.
If you track several accounts, reconcile each one on its own. A transfer from checking to savings appears as a debit in one and a credit in the other, and it is easy to enter only one side.
Reconciliation checklist
- Opening balance read from the statement at the end of the previous day.
- Credits and debits totalled separately on both sides.
- Difference located in credits, debits or opening.
- Pending items excluded or noted.
- Matching date on every comparison.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

