Checking account won’t reconcile.

I have been using YNAB since Sept. Everything was fine until a couple of months ago my checking acount got messed up and I can't seem to fix it. I really don't want to start over.  Any help is appreciated. 

18replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • How long has it been since  you last reconciled correctly?

    Like
  • Superbone asks a great clarifying question here! 

    If it's been a while since you reconciled, it can sometimes be best to make a Reconciliation Balance Adjustment and move on. If your discrepancy is quite large, though, doing this will have a larger impact on your budget numbers, too. That said, any more details you can give us would be helpful in giving the best advice 😊

    In some cases, a Fresh Start can be helpful, but if you're happy with your budget and things aren't too far off from reality, going through the reconciliation process should get things back up to date. Let us know more about how things are looking and we'll help you get things back in line!

    Like
  • Your just going to have to look and do the reconciliation, make sure what is in YNAB matches your account balance. It does get somewhat annoying since YNAB doesn't have all the information that your bank probably does (internal transaction numbers). Open two browser windows or print off your statements and then I find that checking the boxes in YNAB do help as you go along. If you are going back all the way to september it might take some time though. 

    Like
  • Thanks for the feedback. I tried a reconciliation, but maybe I wasn't thorough enough. I tried the balance adjustment, but it just seemed to get worse. I started a Fresh start but that made me crazy. I think I'll tried the reconciliation again.

    Like
  • As far as how long since my last reconciliation, maybe end of December.

    Like
      • Superbone
      • YNAB convert since 2008
      • Superbone
      • 11 days ago
      • Reported - view

      Green Moose You will know when you've done an official YNAB reconcile (computer app only, top right button in your account) as there will be a green lock icon next to all reconciled transactions. Once you get this straightened out, do reconciliations frequently so that discrepancies are not so hard to track down.

      Like
  • Thanks, I will.

    Like 1
  • I'm back. I did the reconciliation with printed statements and then still needed to do the reconciliation thing. Everything was great for one day. The next day it didn't match again. Here are some  screenshots from today.

    Like
      • Bruce
      • Software Engineer
      • Bruce
      • 5 days ago
      • Reported - view

      Green Moose What is your process of reconciling?  When you compare your YNAB account with your printed statement, what are you checking against, and are you making sure that any "cleared" transactions that are past the date of your printed statement have been marked "not cleared"? 

      I don't know if your account is linked, or if you manually import, but when file import happens, or linked account brings in transactions, they are marked as cleared after you accept them.  So if you have any cleared transactions that are outside of the date range of your printed statement that you're comparing against, that will cause a discrepancy.

      Like
      • Green Moose
      • Green_Moose.12
      • 5 days ago
      • Reported - view

      Bruce I went back to the beginning of my account and used all of my statements. I printed them off and marked them off one at a time. I did find some discrepancies that I fixed. My most recent statement was from 2/16 so it was very current.

      Like
      • Green Moose
      • Green_Moose.12
      • 5 days ago
      • Reported - view

      Bruce Only things that were cleared were marked cleared.

      Like
    • Green Moose The screenshot of your bank account says "Available" Balance. At my bank the "Available" Balance includes pending items, which you shouldn't be including in the reconciliation process. Is the Current/Actual balance the same as the Available Balance?

      Like
    • Periwinkle Flute What nolesrule said but with more words!

      Like
    • nolesrule
    • Been waiting 5 years for the Stealing From the Future fix...
    • nolesrule
    • 5 days ago
    • Reported - view

    Usually when reconciling bounces around like this it means you aren't  comparing cleared balance against cleared balance.

    Like
  • At this point should I start over or go on. It really bothers me that the working balance is not even close to my bank balance. It used to match every day.

    Like
  • I meant cleared balance.

    Like
  • The key here is to make sure you're reconciling to the correct balance. It's often different from bank to bank. You should be able to see what's pending and what's not and what represents the cleared balance you need to reconcile to.

    Like
  • Thank you. I'm reconciling as I go along now. I had to make some adjustments, but it seems to be staying in sync. Hopefully I'm back on track. Thanks for your help.

    Like 2
Like Follow
  • 3 days agoLast active
  • 18Replies
  • 170Views
  • 7 Following