QuickBooks Online: Fixing Reconciliation Discrepancies

Subscribe to all my ADVANCED training for $50/m: hectorgarcia.com/subscribe
To setup a 30-day free trial of QuickBooks Online and then a 30% off for 12 months:
www.quickbooksoffer.com/?cid=i...
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)
E-mail Hector your questions [e-mail]
To setup a 30-day free trial of QuickBooks Online and then a 30% off for 12 months:
www.quickbooksoffer.com/?cid=i...

[@HectorGarciaCPA]

QuickBooks Online 30-day free trial + 30% off link: quickbooks.intuit.com/partners/irp/?cid=irp-4337#pricing

[@HarmonyandHope7]

Hi, in Bank Register, I have multiple deposits listed as Split with different dates from last year. It’s automatically clicked and the option to clear them in bulk is not available. So I click on the company name for the transaction it opens Receive payment and then when I click on Clear payment and save & close it says somethings not right

[@HarmonyandHope7]

Also how do I fix undeposited funds, I have a lot of transactions stored there and it shouldnt be

[@redvelvetreveluvbaby1524]

Hi Sir, can i ask for your assistance in QB as a newbie?

[@HectorGarciaCPA]

@@redvelvetreveluvbaby1524 if i can answer your questions posted here, I will

[@Nelly-he6hp]

Good afternoon Hector I have a question. I’m about to reconcile my bank statement, the beginning balance in my account matches my statement but as I went to reconcile its showing a difference. How do I correct this?

[@howtobuypackaging]

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

[@HectorGarciaCPA]

Doing my best, thanks

[@heradio1000]

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.

[@HectorGarciaCPA]

Glad to help

[@user-mk3mq4rf7v]

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.

[@HectorGarciaCPA]

Perfect

[@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 :)

[@HectorGarciaCPA]

:)

[@jorgefraga5045]

This is a great video Hector as always.

[@HectorGarciaCPA]

Thanks

[@staceycontreras4504]

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

[@gleidismazo9250]

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

[@HectorGarciaCPA]

Awesome

[@nicoledossous9500]

Extremely helpful! Thank you!!!

[@samanthalegassick7965]

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!

[@edgarjmoralesjr]

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

[@dulcegarcia2113]

You're the BEST!!! THANK YOU!!

[@user-kt6ei8tl3q]

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

[@HectorGarciaCPA]

You are welcome

[@TriunfaconAmanfi]

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

[@HectorGarciaCPA]

:)

[@thels6049]

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

[@HectorGarciaCPA]

:)

[@michaelodetomi5501]

This is super helpful, Thank you

[@HectorGarciaCPA]

Glad you like it

[@allisonkirchhofercpa3060]

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

[@EvelynTavernier]

Would love a video on repairing the QuickBooks Screen turning black issue where the boxes turn black or fully white making it unable to make a selection.

[@jesusvalencia4139]

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

[@joanneenriquez1767]

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!

[@allisonkirchhofercpa3060]

Having the same issue. How did you remedy this?

[@CrystalNouveauC]

The main reconciliation discrepancy I'm having is with paypal Bank deposits and transfers showing up twice on my QB bank statement. Would you know why that is?

[@janeh5949]

does "Amount" column mean what is currently in the register--so probably the wrong amount.?

[@Jenniferfvbb]

how do you contact us if we have a big problem in reconciling issues and need help?

[@robertbaysic1320]

My QuickBooks didn't extract bcoz of files saying that " invalid character in the given encoding line. How can I fixed this problem please help me

[@khawajadanishaltaf1847]

Thank you so much Hector for your videos. 1. I have some transactions that show up in the bank register but not in Categorized tab in banking. 2. I also have some transactions that show up in Categorized tab but not in bank register. Have you ever come across anything like this. Please advise.

[@HectorGarciaCPA]

No, never seen that

[@khawajadanishaltaf1847]

@@HectorGarciaCPA you always reply to all the queries Hector. Thank you so much.

[@IncrediPaulAZ]

You forgot duplicate entries. I've even had duplicate entries created when a bank changes it's process and QuickBooks recognizes a transaction a new transaction. Granted that one's generally easy to fix because you just delete or exclude the duplicates. Still it can cause lots of problems from what I've experienced.

[@HectorGarciaCPA]

duplicate entries will not mess up your reconciliation. I cover handling duplicates in my banking course

[@chrissymoltimer3554]

Hey Hector for my reconciliation discrepancy report 3 transaction where delete but when I look at my bank register those 3 transactions are still there do have to still recreate those 3 transactions and then reconcile or just reconcile with the right beginning balance since the 3 transactions are still in my bank register

[@HectorGarciaCPA]

If they are deleted, you have to recreate them to reconcile

[@megumi012]

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?

[@HectorGarciaCPA]

You need to re-add it, and re-reconcile The latest period with that one transaction

[@marichrisbanal1104]

Hi, what to do if the bank recon is okay but the balance sheet balance is not the same as the bank statement? Thanks

[@HectorGarciaCPA]

There might be transactions that have not been reconciled that are affecting the balance

[@adityabajaj14]

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

[@HectorGarciaCPA]

Everyday…

[@frankelima4648]

how do you subtract the processing fee out of the deposited amount? I know there is a way to go in and deduct the fee from the amount but I can not remember

[@HectorGarciaCPA]

In the deposit screen, all the way at the bottom you can add it as a negative amount

[@CecilleTabuena_godissogood]

Hello Hector. May I ask what to do with Deleted transaction which still appears at the top of the Reconciliation Report? I happened to unmatched the transaction since it was erroneously recorded as Transfer instead of Expense and matched it again the correct way. Then, I deleted this "Transfer Transaction" which was left unreconciled. I was able to reconcile the whole transaction though, there was this "Reconciliation Change Report" at the top of it. Can I apply the technique you showed here just to be able to remove it from the final report? Btw, Thank you so much! This video helps and I learned a lot! #NewSubscriberHere

[@HectorGarciaCPA]

Have to recreate them and reconcile then

[@CecilleTabuena_godissogood]

@@HectorGarciaCPA Thank you so much! I will do it the way you showed it here. 👍😊 Have a great day always and God Bless you more! 🙏☝😇

[@maseygunner]

I have some issues and wanted your advice. Trying to learn all I can from your videos, but running into some issues. 1. we have an old bank account not been in use since 2017 however when we look at the report the account balance keeps going up in number and I do not know how to get rid of it. when tax time comes it looks like we have a profit when we do not. 2. Bank balance that shows in QuickBooks IS NOT THE BALANCE THAT WE ACTUALLY HAVE IN THE ACCOUNT? 3. DO you have a video on what to look for if you have matched your bank statement to the reconcile page but the balance is off but everything matches up. What else can I look for that may be wrong.

[@HectorGarciaCPA]

Outstanding transactions such as uncashed checks should be the only things that male that difference off. Anything else needs to be adjusted and cleaned up either through deleting (current tax year stuff) or journal entry (previous tax year)

[@audreannacastaneda2380]

How about when an online transfer is coming from wrong account? Change the account under edit?

[@HectorGarciaCPA]

Yea

[@Stvv875]

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

[@HectorGarciaCPA]

Audit log only… wont be in the register because if was deleted

[@rosiehurtado5627]

Hi Hector, have I need to delete a transaction that was entered as a transfer instead of expense in 2022(have not filed taxes yet) and this online version will not let me edit transaction type in any way) which is throwing off my balance sheet. If I deleted these from bank register and re enter them the correct way, you say I have to reconcile again, will it be contained to that months reconciliation in 2022?

[@HectorGarciaCPA]

Maybe.. is not 100% clear without looking at them, as i dont know how these transactions were entered

[@rumblersgear3369]

I was reconciling today bank A. Everything went fine- noticed a lot of transfers in and out to bank B. Got to bank B and reconciled, but during reconciliation decided to open up all the duplicate transactions between A and B and put zeros on them. Got done reconciling bank B and bank A had a major discrepancy errors. (everything I put zeros on, I had to put the amounts back on it). So bank A is now normal and bank B is off by the amount I fixed. I'm literally just ping ponging the errors back and forth. If I go into bank B discrepancy report and put zeros there , it sends the problem straight back to bank A. At this point, I want to rip my hair out.

[@HectorGarciaCPA]

You need a pro to help you organize and clean it up, so you can know how to do it right moving forward

[@maseygunner]

@@HectorGarciaCPA How do you go about finding a pro to clean up. I hired a CPA who charged us almost 2 grand and made a mess out of it.

[@HectorGarciaCPA]

@@maseygunner we are experts that that 954-414-1524, Schedule a diagnosis call.

[@msamyo944]

So my beginning bank balance is off by -$26.22 therefore when i go to reconcile my beginning balance is incorrect. I have looked everywhere to find the discrepancy, I have spoken to my accountant and was informed I can write it off. How do I do that.

[@HectorGarciaCPA]

Make a journal entry for the amount, you can use Bank Service Fees or something like that to write it off

[@valarieyarbrough2264]

If I reconciled a month and closed it but I need to add another transaction to that month to balance to what my bank statement is can I do that?

[@janeh5949]

you can "unreconcile" in QBO. Add your transaction, then re-reconcile

[@ahsanbaig3994]

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

[@HectorGarciaCPA]

Dec 2021

[@allistoninteriorsltd5097]

Im trying to fix a deleted reconciled transaction that was previously under the wrong subscontractor, can I recreate the expense and list it under the appropriate subcontractor and keep the same dollar amount? Will it correct my reconciliation or it has to be the exact thing I deleted?

[@HectorGarciaCPA]

You might need to UNDO de reconciliations

[@Francellahernz]

How do I fix it when I deleted a transaction in purpose because it was a duplicate and was not in the bank statement. So I can't adde it again, I need it to remain deleted?

[@HectorGarciaCPA]

Add it manually

[@mystuff9098]

What if there are no transactions on help to fix discrepancy. Credit card open balance is off.

[@HectorGarciaCPA]

You need to manually unreconcile all the transactions

[@matthewnovik5892]

Great but how do non accountants UNDO a reconciliation? Thanks

[@HectorGarciaCPA]

I have a video on that.

[@jeimyhernandezsandoval3274]

Hi Hector, I’m doing the reconciliation I have a different amount in a check but Quickbooks already sent the W2, what can I do, I’m able to change it?

[@HectorGarciaCPA]

Don’t change, add a journal entry

[@details_matter_construction]

What if I want to change the description category of a reconciled item? to make my reports more detailed. will that screw up my reconciliation?

[@HectorGarciaCPA]

No, memos or descriptions wont mess things up

[@nolabannerton5747]

I keep getting the we can help you fix it message! I have gone into the disc report and then into COA and manually changed the amount then the R and finally voided the trans and nothing!! HELP! Lol. One 95.00 trans x 4 = 380.00 disc amount so its linked to that somehow.

[@HectorGarciaCPA]

cant follow, sorry

[@janeh5949]

please help... My lawyer client wants to invoice his customer and on that invoice, somehow put/include that a vendor bill was paid in relation to this customer matter. How would his customer see that we had to pay a vendor cost associated with the matter? thanks for any help.

[@HectorGarciaCPA]

You would need to make the expense “billable” and then include it in an invoice

[@janeh5949]

@@HectorGarciaCPA thanks Hector!!

[@jamesflynn3336]

Sign

[@carmenmarrero6107]

Ay i had to undo a reconcile but now it changed the beginning balance, ayudame.

[@HectorGarciaCPA]

You need to force reconcile the ending of the last reported period like 12/31/2022 to make sure it matches so you have a starting point

[@bellaiba2009]

I would like to know how to fix bank deposits through the bank because some of my check deposits are not matching and its doubleling the money in my account and same with Zelle payments ?

[@HectorGarciaCPA]

Its hard to answer via a YT comment without properly diagnosing it, sorry

[@bellaiba2009]

@@HectorGarciaCPA how can I contact you because I really need to get this fixed before tax season.

[@ShaymaBellydance]

Is there a way to reset the reconciliation. I have deleted transactions that were reconciled but I dont wanna bring them back. Can I Clean and start over the reconciliation? I reconciled but then I found your video about credit cards and decided to do it correct into the undeposited funds. Then I deleted and upload again the bank statement and now I think I have everything by duplicate and it doesn't allow me to reconcile.

[@HectorGarciaCPA]

You need to UNDO it… there is no “reset”

[@ShaymaBellydance]

@@HectorGarciaCPA thank u hector. Your content is a gem! I wish I had watched all of them before I do stuff. But I actually come back here to solve my problems :(

[@ShaymaBellydance]

The problem is I upload the bank statement to reconcile first time and then reconciled. Then I added a second time, I categorized everything better and I realized transactions were duplicated I deleted both of those transactions (the reconciled one and the not reconciled one) and I added the statement a third time. I though that it will kind of reset itself. I tried to reconcile and it went nuts :)

[@62floripondia]

I have three deposits on my bank statement but they're not in QB, how do I add them?

[@HectorGarciaCPA]

Manually using the create deposit button

[@jamesflynn3336]

of

[@debbiewells7603]

Hector, I have payment/deposits going into as a deposit and an expense because I think they are being categorized wrong, how do I fix that?

[@HectorGarciaCPA]

Go back to each one and fix it

[@debbiewells7603]

@@HectorGarciaCPA even after it's been reconciled?

[@HectorGarciaCPA]

@@debbiewells7603 as long as you dont delete, change dollar amounts, or bank account of a non-reconciled transaction…

[@829debbi]

I mistakenly recategorized a review item after I reconciled a checking account; reconciliation report shows it being deleted by the register shows it's still there but with a "C" now instead of the "R". How do I fix this?

[@HectorGarciaCPA]

You have to go to Reconcile and reconcile the transaction in there

[@829debbi]

Hector, thank you for your help. Your videos are well-done, easy to follow and a phenomenal resource for me. Best regards, Debbi

[@Shalom2479]

How do you reconcile if there was a few deletions?

[@BoonDoggleBliss]

What if you fix your reconciliation but your Balance Sheet is off?

[@HectorGarciaCPA]

Thats a loaded question its hard to answer

[@77Tadams]

Wow. I have had so so many problems with this! I feel like banging my head into a wall. I use a bookkeeper when I can’t get them to reconcile! She is making a lot of money off me! This is one weak point with my learning curve. I just started QuickBooks online a year and a half ago. Never knew what reconciling is. Of course a bookkeeper isn’t going to tell you how to do it…😮😮😮😮😮

[@HectorGarciaCPA]

For the same reasons that Doctors don’t teach you how to do your own surgeries. We tend to believe that what we (bookkeepers) do is what makes us special

[@77Tadams]

@@HectorGarciaCPA oh I am not upset at her at all! It makes me want to learn more! The way you flip through it and make it seem easy is years of learning! And she should make money off me! For the reason that she has been doing it for years! Much respect! Your videos are awesome. You are an excellent teacher. I will be watching this particular one a dozen more times. This made me feel less stupid for sure! Like I too can get this!

[@HectorGarciaCPA]

@@77Tadams :)

[@wendymahon9242]

how do you fix duplicate bills

[@HectorGarciaCPA]

Delete them

[@Avital4414]

The biggest problem I have is with the beginning balance being wrong.

[@HectorGarciaCPA]

Yeap, you might need to undo the reconciliations

[@ahefner33]

Same here!

[@ahefner33]

@@HectorGarciaCPA How would someone do this? Without hiring a CPA. We know the problem but we can't changed the beginning balance.

[@Avital4414]

@@ahefner33 you can enter a journal entry to deal with the problem if there’s no other alternative

[@HectorGarciaCPA]

@@ahefner33 an accountant (or someone with accounting access) needs to undo the reconciliation

[@iobtax]

Thats hillarious, end users find a way to screw things up. Oh yeah, did you not see the warning? Oh that is what that was.

[@HectorGarciaCPA]

Yeap, thats our world

[@yang-pe1kj]

The video is unclear

[@TheSendakite]

lol

[@HectorGarciaCPA]

:)

[@kenneth6847]

Too fast

[@HectorGarciaCPA]

:(

[@mruiz4588]

[@HectorGarciaCPA]

:)