Ledger Balance or Available Balance?

I need to reconcile my account because something isn't adding up even thought I add transactions right after a purchase. 

My bank lists a ledger balance and an available balance, which amount do I use when reconciling my account? 

11replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • You're going to want the ledger balance, which should be the transactions that have cleared your bank.

    Like
      • JoeDid
      • Remember: It is To Laugh
      • Purple_rain
      • 1 yr ago
      • 1
      • Reported - view

      Flyin'Brian Hmm. My bank calls the cleared balance the "Available balance." It's the amount arrived at by subtracting 'Pending Transactions' from 'Today's Beginning Balance.'

      In any case, you want the balance that represents the cleared transactions, not the beginning balance.

      Like 1
    • My bank calls the cleared balance, the "current" balance and then also shows me an "available" balance, adjusted for pending transactions. Not that it matters to us YNABbers who don't have to check our account balance to make spending decisions.

      Like
  • Okay, thank you. I've been through every purchase and inflow and nothing is missing so it doesn't make sense for the numbers to not match. 

    Like
    • Purple Mermaid Check that a transaction doesn't have transposed numbers or that a transaction hasn't been entered in the wrong account.

      Like 1
      • WordTenor
      • I'm the oldest and the wittiest.
      • WordTenor
      • 1 yr ago
      • 1
      • Reported - view

      And a quick check for transposed numbers is that if the difference is divisible by nine you have a transposed number in there somewhere. 

      Like 1
    • WordTenor I'm not sure what type of magic you just taught me, but thank you! :)

      Purple Mermaid In our Help Docs, you can follow step-by-step instructions on how to reconcile your accounts. Make sure to check out the video near the bottom!

      Here are a few things to add to the list of what could be throwing off your balance in YNAB:
      - missing transactions that need to be entered
      - an incorrect starting balance
      - transactions that are cleared at the bank that don't have the green "C" in YNAB
      - entering a transaction as outflow instead of an inflow

      Don't hesitate to ask if you still have questions!

      Like
    • Faness at YNAB I reconciled the account a few days ago, the numbers were finally matching. I decided I wouldn't add transactions on the spot anymore but instead, would wait until they cleared the bank account and YNAB asked for approval. Yet again, the numbers do not match!! My bank account says I have more than YNAB says I have and there aren't any missing transactions.  It's frustrating because I'm trying to be VERY diligent with the budget. 

      Like
    •  I have two checks that haven't cleared so I'm not sure if that's issue???

      Like
      • eloquentz
      • Numbers Wizard (Accountant), Acoustic Artist (Musician) and Jill of all Trades (Wife & Mother)
      • eloquentz
      • 1 yr ago
      • Reported - view

      Faness at YNAB Another trick of the divide by 9 thing.  If you divide by 9 and you get a single digit answer (e.g. 72/9 = 8), the error is between the last and 2nd last digit.  If the answer is a 2 digit answer (e.g. 108/9 = 12), the error is between the 2nd last digit and the 3rd last digit.

      Only so helpful because the error could literally be in ANY of your line items.  But a clue nonetheless.

       

      Also, if you are out by 3/6/9, it might also be keying a number slightly wrong on your keypad (which is upside down compared to the numbers on your phone).

      Like
    • Purple Mermaid That could very well be the issue! The great part about reconciling is that you know that at that point, your account balance and transaction history were correct. That means that the imbalance had to occur between when you last reconciled and today. If you have two checks pending, they won't import until after they clear. You can compare YNAB to your current Cleared bank account balance - if those two amounts match then you're still on the right track!

      eloquentz Thank you! I feel like a newborn mathmetician with all these new tricks! I can admit to being a person who has spent more time than should be spent on tracking down reconciliation issues in the past. ;)

      Like
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 11Replies
  • 1662Views
  • 6 Following