QuickBooks Online: Fixing Reconciliation Discrepancies

To setup a 30-day free trial of QuickBooks Online and then a 30% off for 12 months:

Table of contents:
00:00 How to mess up your reconciliations
06:06 Amount Changed
07:23 Changed Source Account
08:53 Unreconciled in Register
10:14 Deleted Transactions

Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (price starts at $500)

To setup a 30-day free trial of QuickBooks Online and then a 30% off for 12 months:

[JocelynRaschk]

This guy is so helpful, not only showing how to fix it, but also showing how you can avoid making the same mistakes by showing what not to do :)

[heradio]

Hector, your videos are very well made, exactly to the point, and have been of immense help for me since I am an end-user (DIY) of QBO and had a royal mess in my reconciliations. Thank you so much.

[KarenWilliams-sp]

WOW! Thank you SO MUCH for your video! This is exactly what I needed to help me fix a major mess-up on reconciling with deleted transactions. Your explanation was so clear.

[samanthalegassick]

This was SO HELPFUL! I have never been able to figure out what on earth to do with deleted transactions, such a game changer. Thank you so much!

[staceycontreras]

You're funny, Hector! And you make learning QBOA fun!

[howtobuypackaging]

I think you're the only one who actually addresses this for the QB online - other vids were outdated! Thank you!

[jorgefraga]

This is a great video Hector as always.

[gleidismazo]

Thank You Hector!!! Awesome video. I have been learning a lot from you😊

[thels]

THANK YOU first video I came across that helped with a deleted transaction!

[allisonkirchhofercpa]

What about "Reconciled in Register" change type? Thank you!

[triunfa_conamanfi]

Thank you so much for all the information. You are awesome! God bless you! Eres el mejor explicando :)

[megumi]

I accidentally deleted the transaction from a year ago, since that transaction was already reconciled what I could possibly do to fix that discrepancy? should I undo all reconciliations until the transaction date that has been deleted?

[edgarjmoralesjr]

Thank you so much. You really help me a lot. 😀

[LissettePuente-fv]

Thank you so much for this video. You are the best!😊

[irena]

Hello Hector!
Thank you for such informative videos!
I have a discrepancy in bank reconciliation that goes back to June. One of the transactions was deleted (it was duplicate) after account was reconciled. Now the books balance is lower by that amount and bank balance is higher by that same amount. I'm not sure if it is appropriate to recreate the transaction in this situation (would this bring the expense total up?). Really confused with this. I would appreciate your advice! Thank you!

[adityabajaj]

"End user find a way to screw things up" (despite so many warnings)... That's me and that's why I am here. 😁

[joanneenriquez]

Hi Hector, how to fixed reconciliation discrepancy appeared as "Reconciled in Register"? I do a batch reclassed category of account, that I also included those that are reconciled. Now I messed up because it is appeared in the recon discrepancy report. Appreciate your help on this. Thank you!

[jesusvalencia]

how about duplicated deposits? how do you fix does! I already try the Journal entry but that didn't work.

[Stvv]

when i recreate a deleted transaction, i can not see that in the register, i am able to find it from audit log, but when i check the register, its not there, any idea what i may be doing wrong? thank you

[ahsanbaig]

HI, Hector or any one Please help Actually I Reconciled up to Dec-2021 but a expense of July-21 has been Deleted by me so Know when I try to fix it What month for ending Balance I should Select Dec or Jully-21