How to Fix Bank Reconciliation Discrepancies
Vložit
- čas přidán 24. 07. 2024
- 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: • How to fix Bank Reconc...
Ready to learn more areas of QuickBooks? Join us on our next workshop to learn how to design QuickBooks for your specific business... ➡️ CandusKampfer.com/workshop
Receive our QB tips straight to your inbox each week visit: ➡️ CandusKampfer.com/tips
Timestamps:
0:00 - How to Fix Bank Reconciliation Discrepancies
0:31 - QuickBooks Desktop Users: How to fix Bank Reconciliation Discrepancies, Beginning balance is off in QuickBooks
0:47 - Inside QuickBooks Online Reconciliation
1:08 - Bank Register Transaction
2:35 - Reconciliation Discrepancy Report
3:37 - Adding Details in the Reconciliation Screen
4:28 - Finding Transactions and finishing Reconciliation in QuickBooks Online
5:55 - Customizing QuickBooks Workshop
canduskampfer.com/workshop
6:04 - Cleaning Up QuickBooks Workshop
canduskampfer.com/cleanup
I’d love to connect with you 🤗
Instagram: / candus.kampfer
Facebook: / canduskampfer
CandusKampfer.com: canduskampfer.com/
TikTok: / canduskampfer
Pinterest: / canduskampfer
#CandusKampfer - Zábava
Thank you! thank you! thank you! I tried to fix my reconciliation by watching a Quickbooks tutorial and it was so much more involved. You made it so simple and so much easier to complete!
Hi Margo,
Thanks for reaching out.
I'm so happy to hear that our tutorial helped you 🥰
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Awesome video. I just found your channel and love your content! And yes, a video on how to unreconcile would be awesome. Keep up the great work!
Aw, thank you so much! We love hearing this. 🙏🏻
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Sam ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
Once again you save the day Candus! Thanks
Hi,
Thanks for reaching out.
I'm so glad you found our tutorial video helpful! 😊
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. You can learn more here: ConfidencewithQuickBooks.com
Have a great day,
Samantha, Team Candus
Thank you Candus! I want to hug you for this information
Oh my gosh, thank you so much! We love hearing this. 🙏🏻
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Sam - Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
Thank you! I will be using this!
Hi Jacqueline,
Glad it helped you.
Have an amazing day!
Daniel ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Thank you!! This information is very helpful..
Hi Teresa,
Thanks for reaching out.
I'm so glad you found our video helpful!
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. You can learn more here: ConfidencewithQuickBooks.com
Have a great day,
Samantha, Team Candus
Thank you loads! I was able to sort this issue of bank reconciliation discrepancies 😅
Hi,
I'm so glad to hear that you found this video helpful!
Have a great day,
Samantha, Team Candus
so easy used this method😅 thank you so much dear❤
OMG. I wish I had known this years ago!
Oh my gosh, thank you so much! We love hearing this. 🙏🏻
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Sam ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Pinterest: pinterest.com/canduskampfer/
Thank you!
Hi,
Thanks for reaching out.
I'm so happy you found our video helpful 😊
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Thank you
Hi Sheryl,
Thanks for reaching out.
I'm so happy you found our video helpful!
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Thank you!!! Gracias!!!
Hi,
I'm so glad you found our video helpful!
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Sam - Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
You're amazing!!
Hi,
Aw thank you so much 🥰
I'm so glad you enjoyed our video!
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
THANK YOU FOR SAVE MY LIFE!!!! 💞
Hi Angelica,
Thanks for reaching out.
I'm so glad you found our video helpful 🥰
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Good info
Thank you!
If you haven't already joined our weekly QB Tips & Tricks, click here to join and we'll send you our tips straight to your inbox: canduskampfer.com/weeklytips
Have an amazing day!
Sam ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
Thanks for the clear clarification. May i take the opening balance of last reconciliation for migration purpose
Hi,
Thanks for reaching out.
We have some videos on our blog that I think you’ll find helpful: canduskampfer.com/?s=opening+balance
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Thank you for this tip! I have spent a ton of time un-reconciling and re-reconciling so this may save me in the future! Can I do this same thing if the deleted reconciled charge was from a few months back?
Thank you for watching our videos 😊
I will add your question to the list Candus uses to create new QuickBooks tips each month.
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
Ednalyn ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Pinterest: pinterest.com/canduskampfer/
Would also like to see a video on doing this for deleted items.
Awesome video! What should I do if the visa receipt is a different total than the visa statement?
Receipt $192.94
Statement $191.68
Hi,
Thank you for watching our video.
I'm so glad you enjoyed it!
If you're interested in more in-depth training on what to do if the visa receipt is a different total than the visa statement, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Hello Candus,
Just came across your videos. Question- would recommend reconciling the Chart of Accounts first or the monthly Rec?
Hi Heather,
Thanks for reaching out.
I'd start with reconciling your bank account from the beginning.
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Do you have a video of unreconcile. I accidentally deleted a few transactions because I thought they were duplicates.
Hi,
Thank you for watching our video.
If you're interested in more in-depth training on how to unreconcile, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Candus - Help. So what do I do if I've reconciled wrong from the start and my beginning balance is off?
Hi Julie,
Thank you for watching our video.
If you're interested in more in-depth training on how how to reconcile and make sure your beginning balance is entered properly, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Question: How come I can not see my bank linked account? It says it linked but it doesn't show in QB Bank Transactions
Hi Steven,
Thank you for reaching out.
I found this article from Intuit that I think you'll find helpful: quickbooks.intuit.com/learn-support/en-uk/banking/why-is-my-bank-not-linking-i-have-linked-it-and-its-not-showing/00/1221926#:~:text=You're%20having%20issues%20finding,not%20a%20participating%20financial%20institution.
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
New, started in Sept. was going ok the, Have several problems, deletion of items, duplicate transactions. Large negative register balance!! I need help!!
Hi,
We offer a program called QuickBooks Simplified where we focus on how to clean up your mistakes in QuickBooks and advance your skills. To learn more, I recommend attending our Cleaning up workshop. You can register to save your seat here: CandusKampfer.com/cleanup
Have a great day,
Samantha, Team Candus
Do you need an actual copy of your bank statement when doing the books or can you just trust the QBO sync?
Hi,
Thanks for reaching out.
It's usually recommended to have an actual copy of your bank statement.
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
we just migrated from desktop version to online and seems all our reconciliations are off. this might stop us from continuing with online and just start at beginning of our fiscal year (in 6 months) and enter the ending balances from prior fiscal year end.
Hi Susan,
Thank you for watching our video.
If you're interested in more in-depth training on how to clean up your reconciliations, I recommend checking out our QuickBooks Simplified program. To learn more you can attend our Cleaning up workshop. Save your seat here: CandusKampfer.com/cleanup
Have a great day,
Samantha, Team Candus
Hello, I need to change the DATE of a reconciliation...I accidently typed in the year as 2023 and it should be 2024, and I finalized the reconciliation before I noticed. Please help!
Hi Carolyn,
Thank you for watching our video.
If you're interested in more in-depth training on how to change the date of your reconciliation, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Hi Candus, I can't seem to find any videos that address specifically "If a transaction was reconciled in the register....". I only see video for transactions that are "Unreconciled, or Deleted" Any advice on this specific type of discrepancy? I viewed the history and all the accounts involved and I don't see how to fix this .. I even tried re-reconciling that transaction in the registry to see if it will update QBO but that does not work... I'm at a lost...
Hi Shay,
Thank you for watching our video.
If you're interested in more in-depth training on what to do if your transaction was reconciled in the register, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
I used my business card or business checking account for personal expense . How can I record it in qb
Thank you for watching our videos 😊
I will add your question to the list Candus uses to create new QuickBooks tips each month.
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
Ednalyn ~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer
Pinterest: pinterest.com/canduskampfer/
My accountant reconciled in the middle of a month and idk how to make the beginning match my bank statement.
Hi,
Thanks for reaching out.
I'm sorry we're just now responding to your comment!
To better understand how to reconcile a mid-month, check out these videos on our blog: canduskampfer.com/quickbooks-online-how-to-reconcile-a-bank-account-that-has-never-been-reconciled/
and: canduskampfer.com/how-to-enter-opening-balance-in-quickbooks-online/
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
Hi!
How do I add missing transactions during reconciliation?
Hi,
If the transactions aren't already entered, and you don't see them in your bank feeds you'll need to manually enter them.
If you'd like to get additional support with your QuickBooks, I recommend checking out our Confidence with QuickBooks program: ConfidencewithQuickBooks.com
Have a great day,
Samantha, Team Candus
Could I use the same process to fix it if it was Reconciled in the register?
Hi Tracy,
Thank you for reaching out.
If you'd like to learn more about how to fix your reconciliations in the register, you can check out our QuickBooks Simplified community. This is where we cover how to fix your mistakes in QB. You can join the waitlist for our next open enrollment here: QuickBooksSimplified.com
Have a great day!
- Samantha, Team Candus
@@CandusKampfer Thank you! I think that is the one I just finished. I also signed up for your course!
This was amazing . I am working on someone elses work
Hi,
Thanks for reaching out.
I'm so glad you enjoyed our tutorial video!
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend
checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here:
CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
What about if the discrepancy says 'amount was changed'?
It will all depend if your beginning balance is off and if the transaction is marked as reconciled in your register.
I cannot see the desktop version link
Hi Emerald,
Thanks for reaching out.
Here's the link to the Desktop version of this video: canduskampfer.com/fix-bank-reconciliation-discrepancies-quickbooks/
If you’d like to learn more about how to optimize QuickBooks for your business, I recommend checking out our Confidence with QuickBooks program. To learn more you can attend our Customizing QuickBooks workshop. Save your seat here: CandusKampfer.com/workshop
Have a great day,
Samantha, Team Candus
The beginning balance is way off
I’m lost .
Hi @kevywilliams3304,
I am sorry that you are feeling lost.
The best possible way for you to receive support from Candus is to register for and attend her workshop.
Here is the link to register to attend: canduskampfer.com/workshop
Have a great day!
~ Team Candus
P.S. We’d love to connect with you! Find us on ↓
Instagram: instagram.com/candus.kampfer
Facebook: facebook.com/CandusKampfer
TikTok: www.tiktok.com/@canduskampfer