Have you ever reconciled one month ✅ and then the next month your “beginning balance is off”… 🤷🏻♀️
Why does this happen? When you “reconcile”, QB is matching your bank statement to what you entered into QuickBooks. If you edit, change or delete a transaction after you reconcile, it changes it and can mess up your previous reconciliation.
It’s common to think you need to “unreconcile” to fix the issue. I prefer to adjust a current reconciliation to keep from opening a can of worms 🤓
If you’re looking for the Desktop version of this video click here
Steps to fixing bank reconciliation discrepancies in QuickBooks Online:
- Go to “Accounting”
- Chart of Accounts
- **You might have deleted a transaction or R is clicked Off in the trasaction
- Click “We can help you fix it”
- You will see the Reconciliation Discrepancy Report
- Check what was the last Statement date
- **Grab your Statement
- Add Ending Balance and Ending Date
- Find transactions and checkmark
- Make sure the difference is Zero
- Click “Finish Now”
Share in the comments below if this helped you and if you had any ah-ha’s 💡
Have you been using QuickBooks for a while, but when you pull a report you just don’t understand what it’s saying?
Does the idea of going to see your tax professional sound a little stressful and maybe cause you to feel like you want to pull your hair out?
I would love for you to join me on my customizing QuickBooks workshop.
I’ll be sharing:
- The most efficient way to track your Income and Expenses.
- How to create accurate reports in order to view how your business is actually doing and stop second-guessing yourself.
- Where to get the data you need to make the best decisions to grow your business.
And the #1 SECRET to feeling confident at your next tax appointment.
I’m excited to see you on the workshop!
Click here to save your seat → Join My Free Workshop!
🙋🏻♀️ I’d love to connect with you on Instagram or Facebook
Subscribe for more QuickBooks tips on YouTube
#CandusKampfer
I need a video on how to change the beginning balance on a bank account, so I can process the reconciliation correctly, using QBO?
Hi Sherri,
You are in luck 😊 We have a video for beginning balances here: https://canduskampfer.com/how-to-enter-opening-balance-in-quickbooks-online/
Have a great day!
Candus
I am going through a similar issue where Quickbooks is showing a reconciliation adjustment of $24K. I deleted it and now I don’t know how to add it back on or really how to fix it so that there is not such a large discrepancy.
Emily,
It depends if you were able to reconcile in the past and then removed transactions or if you used a “adjustment” to make it work in the first place.
The reason it matter is because if you had errors and you made it work with an “adjustment” and then deleted the adjustment. You’ll need to go back and figure out why the reconciliation was off in the first place.
Meaning I never recommend add an adjustment in QB cause it ends of being an issue later.
If that’s not what happened let me know more about the issue 🙂
Candus
I would really interested in a video on unreconciling
Loretta,
Thank you it’s on our list for future tips 🙂
Candus
i just ran into this problem this week and then received your email!! wow!! Now, i hope i can find the one i must have deleted.
Hi Dottie,
I am so glad that this was timely for you 😁
Have a great day! – Daniel/Team Candus