cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 1

My Quickbooks balance is much higher than my bank balance.

This is what my register looks like, multiple entries for one transaction, this is why I think my Quickbooks balance is so much higher than my bank balance. 


For one transaction with two entries: when I delete one of them it then takes away the payment applied on the invoice and makes there be an open balance for the invoice, when I try deleting the other entry it says something like "This was downloaded by your bank, are you sure you want to delete it". I am very confused! Any help would be much appreciated. I am new to Quickbooks. Thank you!

Solved
Best answer 10-15-2018

Best Answers
Highlighted
Level 6

My Quickbooks balance is much higher than my bank balance.

Using the bank feeds can be confusing.  If you recently connected the bank acct., it provides 90 days of transactions and imports the opening balance and reconciles that one transaction that will need to be deleted.

Also, with bank feeds, they are a useful tool.  Saves time in data entry.  However, for customers, you want to enter the invoice or sales receipt.  then if an invoice, enter the corresponding payment and deposit it. Then match the customer transaction.

I see it many times where users will download the bank feed as "income" and then also post the customer details, thereby doubling their income.

Best way to track the bank acct is to reconcile it monthly.

View solution in original post

21 Comments
Highlighted
Level 6

My Quickbooks balance is much higher than my bank balance.

Using the bank feeds can be confusing.  If you recently connected the bank acct., it provides 90 days of transactions and imports the opening balance and reconciles that one transaction that will need to be deleted.

Also, with bank feeds, they are a useful tool.  Saves time in data entry.  However, for customers, you want to enter the invoice or sales receipt.  then if an invoice, enter the corresponding payment and deposit it. Then match the customer transaction.

I see it many times where users will download the bank feed as "income" and then also post the customer details, thereby doubling their income.

Best way to track the bank acct is to reconcile it monthly.

View solution in original post

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

Thank you for clarifying this. I did this very thing. :( What is the best way to correc this? We run a business that has a lot of small transactions each day so we have several hundred entries that need to be (deleted, edited, ?). Moving forward, the reason I did this was because my dashboard said I had undeposited funds, so naturally i deposited them. Note: undeposited from QB's point of view, the actual funds had already been deposited.

Also, we are importing/reconciling transaction data from Square as well as our bank. It should be reconciled each day, which is a bit of work but gives the most up to date view of performance, but it also seemed to create the situation we're in. That and my goof on depositing funds.

Any help you can offer would be great. Thank you!
Ross
Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

I’m having the same issues but I can’t see an opening balance or anything that would reconcile the difference if deleted. 

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Pleased to hear from you @DDI.

 

Indeed, @lyndaartesani is correct! I’d be delighted to add more information on how you can manage your transactions in QuickBooks Online.

 

When you connect your bank account with QuickBooks, all of your transactions will be downloaded automatically into the system. It will stay under the “For Review“ tab.  Just click on the Add button from the action column to add the transaction to the QuickBooks register.

 

However, if you have manually added transactions such as invoices, sales receipt, income, checks and expenses you can match it with the downloaded ones. By matching your transactions, you can avoid getting duplicate ones.

 

Here’s how:

  1. Go to Banking.
  2. Select the Banking tab.
  3. Choose the specific transactions from the For Review tab.
  4. Double-click on the transaction to expand it.
  5. Click on Find match.
  6. In the Match transaction page, choose the specific transaction that exactly match with the deposit.
  7. Click Save.

In addition, you can also create a rule in QuickBooks Online. This rule will automatically categorized your downloaded transaction, match transactions, add a payeeselect a Class and a Territory.

 

Here’s how:

  1. Go to Banking.
  2. Choose  Bank Rules.
  3. Click the New rule button on the upper right-hand corner.
  4. Type in the specific description of the rule.
  5. Click Save.

For more detailed instructions, you may check out this video tutorial: Bank Rules.

 

Lastly, to remove duplicates from your QuickBooks register, you can undo the accepted transactions and exclude them.

 

  1. Click Banking.
  2. Choose In QuickBooks tab.
  3. Select Undo for each transaction you want to exclude.
  4. Return to the Banking page.
  5. Choose the transactions you want to exclude.
  6. Click on Batch actions.
  7. Select Exclude Selected.

On the other hand, to keep track on the changes made to your QuickBooks recorded data, you can generate your audit log report.

 

That should do it! This should fix any differences between your QuickBooks balance and bank balance.

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

I had undeposited funds that I changed over to being deposited into my checking account and now they are on the register twice. I had already reconciled before this, so the original transaction is reconciled, but I don't know how to get rid of the second transaction. It is no longer under the banking-"For review" tab. Also the second deposited transaction does not show up under the "In Quickbooks" tab. So I cannot undo. The only option I have is to delete the transaction in the register, but then the invoice is marked unpaid. Please help!

Highlighted
Moderator

My Quickbooks balance is much higher than my bank balance.

Hi, cj2018.

Welcome to the Community. I'd be happy to assist you with the transaction that is showing twice in your register.

 

In order to remove the duplicate, you can delete the transaction in your register and link the reconciled transaction to the open invoice.

 

You may find these articles helpful:

 

 

As always, you need additional help you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

Let me know if any questions may arise while working in QuickBooks Online.

Highlighted
Level 2

My Quickbooks balance is much higher than my bank balance.

I have a checking account that's a little under a year old.  I've downloaded all of the transactions from my bank, gone through and reconciled them all.  There are no outstanding transactions under "For Review", nor any under "Excluded".  My Bank Balance is much lower than the Quickbooks Balance.  When I print the "Reviewed" register to a CSV file and sum up all of the transactions, they match the Bank Balance - there is no indication of where the Quickbooks balance is coming from.

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Thank you for joining this thread, @JMGE.

 

I'd like to provide you with some details about the factors that causes the difference between QuickBooks balance and your bank balance.

 

These are the common reasons your balances may not match:

  • Outstanding transactions
    • To fix this, sort out your QuickBooks Online bank register by date and compare it with your bank statement.
  •  New transactions for a connected account
    Credit card (liability) account
    • Compare your credit card statement with the QuickBooks balance. Verify if the Balance column is showing a positive amount.
  • Duplicate transactions
    • The system automatically locate duplicate transactions and match them. However, there are times the system can’t locate any similarities on the transactions details. You can manually match the transactions.
  • Edited or deleted transactions
    • You can run the Audit log to verify the details of the edited or deleted transactions.

For additional insights, you may check out these articles:

Stay in touch with us if you have other questions about the bank balance reflected in QuickBooks Online. I'm always here to help.

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

I am having this same issue, but it's with the credit card. I have the main account and then the two cards we use on this account. The payment goes to the main account rather than to the individual cards.

 

How can I fix this?

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Good day, @stefpati.

 

I can see in here that this is a duplicate post with https://quickbooks.intuit.com/community/Banking/Credit-Card-bank-balance-and-Quickbooks-balance-are-...

 

Please refer to the responses provided by my colleague,

 

Don't hesitate to drop by here in the Community if you have other questions about the difference between your Credit Card bank balance and Quickbooks balance. I'm always here to help.

Highlighted
Level 2

My Quickbooks balance is much higher than my bank balance.

Yes, I read the 5 reasons that are posted everywhere why there would be a difference between the Quickbooks Balance and the Bank Balance.  I've gone through mine exhaustively.  They simply do not balance/reconcile.

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Thanks for the update, JMGE. 

 

Let's try to check your bank's register with your bank statement again. You might have added the bank transactions instead of matching them. This can cause duplicate transactions in the register. 

 

We can do a few actions that can fix duplicate ones. Here's how: 

  1. Undo the added transaction in the Review page.
  2. You can use the bank statements date range or period to filter the transaction in the Reviewed tab. Then, you can Undo them at once. 
  3. The transactions are back in the For Review tab. 
  4. Check in your bank statement to verify what transactions needs to be added or matched. 
  5. If these transactions are not necessary to be added in your register you'll want to exclude them. 

After these steps, view your register and start reconciling again. Make sure to enter the Ending balance and Ending date stated in your bank statement. 

 

Always know the Community is always here to help you. 

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

My question kinda plays off this one. 

 

I only reconcile with bank transactions to confirm I'm always 100%.  Where I run into trouble is, if I receive payment on invoice and match it to bank transaction, it does not show up as COGS sold.  If I record it as "income sales of product sold", can I still match it to the invoice so it doesn't double my quick books accrual? 

 

because my bank account balances are spot on, but my quickbook balances are definitely not.

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Hello @Dan35,

 

Let's check if you've added inventory items in your invoice, then let me help you from there.

 

Only the inventory item have the Cost of Goods Sold (COGS) that will show on the expense account. Let's make sure that the items on your invoice are set up as inventory items. Here's how:

 

Here's how you can check the items:

  1. On the left panel, hover your mouse on Sales, and choose Products and Services.
  2. Open the invoice and check the items listed.
  3. Check under the Type column to know if it's an inventory item.

If the products/services on your invoice are inventory items, your COGS will show on the reports when matching it to the invoice.

 

If it's not an inventory item, your COGS won't show on the reports since they aren't physical items sold to your customers.

 

Fill me in if you have other concerns about matching your transactions in QuickBooks. I'll be around to assist you. 

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

I do not have the option to create inventory and my research shows that I have to upgrade my subscription to do it. 

 

Is is there another way to have my QuickBooks balance match actual balances without upgrading?


 

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Thanks for getting back to the QuickBooks Community, Dan35.

 

My colleague provided you the exact information. QuickBooks will generate a Cost of Good Sold (COGS) once you've created an inventory item. This is the only option to match your QuickBooks actual balance.

 

If you're using QuickBooks Online Simple Start service, you may want to upgrade your subscription by following the steps in this article: How do I upgrade my QuickBooks Online subscription?.

 

You may also check this article to learn more about the QuickBooks Online Plans a& Pricing.

 

Feel me in if you have any other concerns. Have a good one. 

Highlighted
Level 2

My Quickbooks balance is much higher than my bank balance.

Do those of you on the Quickbooks Team actually read the whole thread before responding?  There have been 4 posts from your team stating the EXACT same thing.  Please provide a unique response otherwise it's not helpful.

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

Hi there, JMGE.

 

I've read the whole thread of this conversation and it seems like my colleagues provided you all the resolution on how to match your QuickBooks balance and bank balance.

 

If you've already performed the steps and the same thing happens, I encourage you to contact our QuickBooks Online Support Team. They have the tools to do a screen-share to view your account and investigate this further. 

 

Here's how you can contact our support:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (question mark icon) at the top right.
  3. Click Contact us to connect with a live support agent.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success. 

 

 

 

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

This is sort of my problem as well.

 

I send and invoice for $200.

I receive a check for $200.

I deposit the check using my mobile banking app.

I then go to CUSTOMER and INVOICE and receive the payment for $200.

    This shows up as a PAYMENT on the register

QBO downloads the bank information and has a $200 MOBILE DEPOSIT

     This shows up as a DEPOSIT

My register now shows $400 worth of deposits.

I delete the MOBILE DEPOSIT of $200 from my register.

When I log back into QBO, the MOBILE DEPOSIT is back, and my balance is off again.

 

Also, some of my payments show up as PAYMENTS and some show up as DEPOSITS (usually if it's a split payment). I have no idea why since I enter them the same way.

Highlighted
QuickBooks Team

My Quickbooks balance is much higher than my bank balance.

 

Hi @ MrMLGoodwin,

 

This will duplicate, once you create a deposit and you’ve received payment from the invoice.

 

When you deposit the amount, you’ll have to deposit it under the Accounts Receivable and named it received from the Customer. This will add credit to the customer’s balance and applied to the customer’s invoice.

 

Here's how to enter a deposit to Accounts Receivable:

  1. Click the Plus (+) icon, and then choose Bank Deposit.
  2. Click the Account drop-down arrow, and then choose the bank account.
  3. Under Add funds to this deposit, add the customer, and then choose an Accounts Receivable  under Account column.
  4. Once done, hit Save and close.

Once you receive the check and deposited the money, ensure to create one deposit only.

 

You can read this link for more information about recording a bank deposit in mobile: Add a bank deposit in QuickBooks Online mobile.

 

If you have any related concerns, feel free to leave a comment below. We’re here to help.

 

Highlighted
Level 1

My Quickbooks balance is much higher than my bank balance.

I think I did the samething.i was rushing to get some invoices in for payment that I mess it all up.Double invoice.i need to slow down and read what quickbooks has to say.after all they are the experts.     michael

Need to get in touch?

Contact us