cancel
Showing results for 
Search instead for 
Did you mean: 
dobeluvr
Level 3

balance discrelpancy

Bank balance (available funds) differs from QB balance on same date. QB shows several thousand less which makes bill paying hard.

I have a lot of unreconciled amounts from past years. Probably entry errors.

I would like QB balance to more closely match bank balance on same date.

Thank you

Solved
Best answer January 18, 2021

Best Answers
Rubielyn_J
QuickBooks Team

balance discrelpancy

It's my pleasure to clarify things out for you, @dobeluvr.

 

Your bank's balance may not match with QuickBooks due to several factors. Let's check to verify and fix them accordingly.

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

Please check this article to find out the recommended fix for the mentioned reasons: How to Fix Differences Between QuickBooks Balance and Bank Balance.

 

Once everything's okay, you can already reconcile your account.

 

I’m always here to assist you if you have other concerns. I’m just a post away. Stay safe always.

View solution in original post

5 Comments 5
Rubielyn_J
QuickBooks Team

balance discrelpancy

It's my pleasure to clarify things out for you, @dobeluvr.

 

Your bank's balance may not match with QuickBooks due to several factors. Let's check to verify and fix them accordingly.

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

Please check this article to find out the recommended fix for the mentioned reasons: How to Fix Differences Between QuickBooks Balance and Bank Balance.

 

Once everything's okay, you can already reconcile your account.

 

I’m always here to assist you if you have other concerns. I’m just a post away. Stay safe always.

dobeluvr
Level 3

balance discrelpancy

Thank you. I will review the document you provided. One thing I forgot to say is that my QB reconciles perfectly every month. Just that my ending balance is way off compared to same date on bank statement. I'll let you know how the recommended "fix" works out.

dobeluvr
Level 3

balance discrelpancy

I did consider those items and after adding up pending payments, etc. balance is still off by more than $1000. Is it safe to REMOVE "unreconciled" entries from past years through perhaps 2019? Or, are those not a factor? 

 

Thank you.

 

P.S. I feel like I should hire a QB Certified advisor to connect remotely and review my situation and perhaps help me move from QB Pro 2015 to Quicken since I no longer have a business use thus I only use QB Pro as my "checkbook." 

dobeluvr
Level 3

balance discrelpancy

I did consider those items and after adding up pending payments, etc. balance is still off by more than $1000. Is it safe to REMOVE "unreconciled" entries from past years through perhaps 2019? Or, are those not a factor? 

 

Thank you.

 

P.S. I feel like I should hire a QB Certified advisor to connect remotely and review my situation and perhaps help me move from QB Pro 2015 to Quicken since I no longer have a business use thus I only use QB Pro as my "checkbook." 

ZackE
Moderator

balance discrelpancy

Thanks for following up with the Community, dobeluvr.
 

If transactions aren't reconciled, deleting them won't change your reconciliation balance. It's often suggested to void a entry, instead of removing it entirely. Doing so keeps a record of the transaction data with a zero amount.
 

Since removing records can impact financial reporting, I'd recommend working with an accounting professional to confirm if you should delete/void your unreconciled entries.
 

If you're in need of one, there's an awesome tool on our website called Find an Accountant. Each ProAdvisor listed there is QuickBooks-certified and able to provide helpful insights to drive your business's success.
 

Here's how it works:

  1. Go to our Find an Accountant webpage.
  2. In the Find an expert in section, choose what you're looking for, then use your search field to enter a City or ZIP code.
  3. Click Search.
  4. Browse through the results and find one that works best for your business. You can access each ProAdvisor's profile to learn more information about them.

 

Once you've found an accounting professional, they can be reached through their Send a message form:

  1. Use your available text box to introduce yourself. Be sure to include details about the services you're looking for.
  2. Enter the appropriate info in the Your nameYour email, and Your phone number (optional) fields.
  3. Select Send message


You can also find many detailed resources about using QuickBooks in our help article archives.
 

I'll be here to assist if there's any additional questions. Have a wonderful day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us