Incorrect Tiller Ending Balance in the Account Reconciliation Sheet

Google Sheets
1

My account ending balance is not matching my reconciled information. See screenshot. You’ll see that I am balancing fine, but the Tiller ending balance is not what it should be. I THINK I screwed up something when my bank when to a direct import. I have two logins for the bank. One is mine and one is my husbands. I think I selected the wrong account when I logged in as his and it pulled that account in twice? I since have changed it so only my login pulls in that account but I’m wondering if there is some residual issues from that. Or, if there is just something else that is off. I did go thru the process of trimming and repairing balance history and it’s still off. Any ideas?

account reconciliation
account reconciliation983×512 75.8 KB

2

Check your transactions for one or more that add up to $23.38 (the difference between your Tiller ending balance and the statement ending balance). It could be duplicates, it could be missing transactions, or it could be transactions with a date from the wrong statement. The transaction list in columns O-Q should exactly match the transactions on your statement. If not, the difference is the problem.

3

Sorry, i should have added that it has been like that for a few months. I’m wondering if it is from a couple months ago since this and last month’s statement are balancing. I will ho back and see if i can find a transaction that’s incorrect. Thanks!

1 Like
4

thanks @jpfieber for that suggestion! Let us know @mpresley410

5

I have gone back and reconciled the last 3 bank statements and I balance. When I put in my info in Column L to troubleshoot, it comes up as 0.00. So, I balance but the number in cell E6 is still red. Now, it is only $2.15 off, so I apparently fixed something when I was balancing. I think I will go back to the first of this year and reconcile each statement from back then and see if I can find that other 2.15. I like my numbers to be green, not red! haha. Thanks for your help. I think I am on the right track, I just have to hunt it down.

6

I found it!!! I had to go all the way back to May 2023! I put a manual transaction in with the wrong date. Thank you all!