Cleared balance reconciled, but working balance is not correct?
TL;DR: the cleared balance in YNAB matches my cleared account balance in my bank account, but the 'working balance' in YNAB does not match my bank account's working balance. Why and how to fix?
Apologies if this has already been answered - I've searched but can't find a question which seems to match my situation.
After a couple of days of not tracking (sometimes life gets in the way!), I've been through and entered in all the missing transactions for the past few days, and then checked through since the beginning of the month line by line, paying particular attention to the uncleared transactions. The uncleared transactions in YNAB exactly match the uncleared transactions in my bank account.
I reconciled, and clicked 'yes' as the cleared balance in YNAB matches my cleared account balance in my actual account ('account balance' in my bank's language). But, the 'working balance' does not match my account's working balance - it's $4.44 higher than my actual account's stated working balance ('available balance' in my bank's language).
How can I fix this? I've been using YNAB consistently for over a year and my cleared and working balances always match those listed on my account - hence why I think there's something wrong here and it's not just a time lag or something, because surely I'd have encountered it before if so?
I've tried adding in a manual reconciliation transaction of $4.44, to make the working balances match - but then it throws off the cleared balance, and when I reconcile and let YNAB correct that, it throws off the working balance again, etc. etc. 😩
Thank you in advance for any ideas!
Thanks for your reply! I don't have a $2.22 amount in inflow or outflow... but out of interest, how would that make the $4.44 difference?
+ Update: I've actually now fixed the problem (found a solution through much online searching!) - by manually adjusting my account balance in the sidebar, which allowed me to adjust the working balance without impacting the cleared balance. I didn't know that feature existed 🤷♀️
So I seemed to have wriggled out of it, although I still don't know what threw it off in the first place! I've spent hours comparing my statement and YNAB line by line 😝
Lucy Merchant said:
I've spent hours comparing my statement and YNAB line by line
How many uncleared transactions do you have? I just wonder if you were looking in the right place.
For future reference, if the cleared balance in YNAB matches that of the bank, the discrepancy must exist in one of the uncleared transactions in YNAB, which should be relatively few.
There will be a different, missing, or extra UNCLEARED transaction in YNAB. These should be compared to the PENDING transactions at the bank.
Note that a seemingly extra transaction in YNAB that you entered (and is real) just means YNAB is more up to date than the bank and is not an error. This is always the case when I write a paper check to someone or have recorded a transfer from another bank.
Lucy Merchant said:
manually adjusting my account balance in the sidebar, which allowed me to adjust the working balance without impacting the cleared balance.
This is concerning. How on earth did you do that?
Lucy Merchant said:
I had 20 uncleared transactions and these matched exactly with the pending transactions on my account
I wonder if you matched in the wrong direction? You would have needed to go line-by-line down your bank's list of pending transactions, looking for matches in YNAB. Otherwise, you cannot detect a missing transaction in YNAB.
As an aside, I've found flags useful for scenarios like this (flag the matches in YNAB as I systematically go down the bank's list). Guarantees YNAB has everything the bank knows about, and anything not flagged is even more pending than the bank knows about (which isn't an error).
Other tips to help find a discrepancy between working balance and pending transactions:
- reconcile first so you lock your cleared transactions. Since you said the cleared balance in YNAB and bank are the same, it should be 2 clicks.
- sort via cleared/uncleared in YNAB (click the top "c" of the column). So if you have a very old uncleared transaction that was forgotten, it will come back up to the top. I'm guessing that's your issue.
- if your bank shows your running balance (although it's less likely with pending I think), make sure to also add the running balance in YNAB. Then look at your bank statement, find the first pending at bank, find it in YNAB then either flag the transaction as checked or clear it. Once you are done, just unclear everything (it works because you reconciled first so you had no cleared transactions when you started).