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!

18replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Is there a 2.22 transaction in the wrong way (inflow v outflow)?

    Like
  • 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 😝

    Like
      • monkeyhanger
      • No animals were harmed
      • monkeyhanger.1
      • 2 mths ago
      • 1
      • Reported - view

      Lucy Merchant The difference between -2.22 and + 2.22 is 4.44.

      Like 1
  • 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.

    Like 1
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      dakinemaui That's the thing; I had 20 uncleared transactions and these matched exactly with the pending transactions on my account (I triple checked), and totalled the same amount on each as well...

      Like
      • monkeyhanger
      • No animals were harmed
      • monkeyhanger.1
      • 2 mths ago
      • Reported - view

      Lucy Merchant how long have you been using YNAB?

      Like
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      monkeyhanger since April 2019

      Like
      • monkeyhanger
      • No animals were harmed
      • monkeyhanger.1
      • 2 mths ago
      • 1
      • Reported - view

      Lu Blue Cool, that means it's not one of the more obvious issues for new users then. Just wanted to rule that out.

      Like 1
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      Move Light Sound Life right clicked on the account and changed 'today's balance'?

      It said it would enter a reconciliation transaction and I clicked ok.

      Like
    • Lu Blue I didn't realize that was an alternate npathway for creating a reconciliation transaction - thanks! 

      The thing is... A reconciliation transaction does impact your cleared balance, by definition.  When you reconcile, you're comparing your cleared transactions at your bank to the cleared transactions in YNAB (making sure they individual transactions match up, like you do, editing in YNAB as necessary), then you compare the two cleared balance and press the Reconcile button to lock those transactions as correct. 

      Reconciliation has nothing to do with the working balance except indirectly. If the cleared balances are off, the working balance will be off as well (barring a coincidentally incorrect offsetting error), but if you said the cleared balances matched between your bank and YNAB, then a reconciliation adjustment would cause them to not match afterwards. 

      I hope that makes sense.

      Like 3
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      Move Light Sound Life it didn't though, using this method changed my working balance only; now my cleared balance and working balance match those on my account! 

      Like
    • Lu Blue That doesn't make sense, but I'm glad everything matches now!

      Like
  • 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).

    Like 2
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      dakinemaui Yep, that's what I did 🤷‍♀️ Undoubtedly missed something somewhere though, haha!

      Like
  • 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).

    Like
      • Lu Blue
      • lu_blue
      • 2 mths ago
      • Reported - view

      Ceeses My running balance rarely matches up because transactions hang as pending on my bank account for ages, so the date that I enter them in YNAB is never the date they show up on my statement (on my statement they are listed as the date they clear). 

       

      I definitely didn't have a hiding uncleared transaction this time, so I guess I will never know exactly what the issue was (maybe it was a coincidence that my cleared balance matched and actually there was something off, who knows - or it was linked to a previous reconciliation adjustment maybe).

      Thanks for the tips for the future!

      Like
      • Ceeses
      • Ceeses
      • 2 mths ago
      • 1
      • Reported - view

      Lu Blue You are right, you actually don't need the running balance in YNAB. But if your bank gives a running balance with the pending transactions, then the method works. Reconcile in YNAB, check the oldest pending transaction in the bank, clear the transaction in YNAB. Your new cleared balance should match the running balance at your bank. The order of the transactions in YNAB doesn't matter as you add them one by one to the cleared balance. Then you unclear once you are done.

      Like 1
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 18Replies
  • 118Views
  • 5 Following