cancel
Showing results for 
Search instead for 
Did you mean: 
Chris4242
Level 1

QBO balance higher than bank balance

I recently took over managing QB for a landscape company. The previous person caused a lot of duplicate payments, I think. I believe they would go into the invoice and mark it paid and would not link it to a specific bank deposit with various checks for multiple invoices. How do I go back and fix these issues if the company already reconciled each month to date. Looks like we are double dipping on the money paid. 

Solved
Best answer 3 weeks ago

Best Answers
Rea_M
Moderator

QBO balance higher than bank balance

Yes, you need to create a bank deposit entry, Chris4242. I'll guide you on how to do this so you can manage your bank transactions accordingly.

 

When receiving payment for an invoice that goes to your undeposited funds, you'll have to make a bank deposit to match it to the bank feed. Here's how:

 

  1. Select + New and choose Bank Deposit.
  2. From the Account dropdown, choose the account you want to put the money into.
  3. Click the checkbox for the payment to deposit.
  4. Select Save and close.

 

Afterward, go to the Bank transactions menu to categorize and match your bank feed deposit to the existing entry.

 

Additionally, we recommend regularly reconciling your accounts (monthly) to effectively track your business revenue and keep your financial data updated.

 

If you have other concerns about bank deposits and reconciling accounts in QBO, don't hesitate to ask, as I'm always here to assist you in any way possible.

View solution in original post

3 Comments 3
ChristieAnn
QuickBooks Team

QBO balance higher than bank balance

Welcome to the QuickBooks Community, Chris4242.

 

To fix those duplicate payments and to manage your sales transactions, you'll need first to unreconcile the entries from the date when the payment was recorded up to the recent one. Let me provide steps to complete this process and ensure you can organize your invoices and payments efficiently.

 

Beforehand, yes, you're correct that linking to a specific bank deposit with various checks for multiple invoices isn't necessary. This method can usually cause double income, especially if those payments are already added to QuickBooks from your online banking.

 

To resolve your issue, you can start following the steps below on how to unreconcile the entries.

 

  1. Click the Gear icon ⚙ and choose Chart of accounts.
  2. Find the account that has the reconciled entries. Then, select View register.
  3. Find the transaction. If the entry is reconciled, you’ll see an “R” in the checkmark ✔ column.
  4. Pick the transaction to expand the view.
  5. From the checkmark ✔ column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
  6. Click Save.
  7. Close the account register.

 

However, if you're using a QuickBooks Online Accountant version, you can refer to this article on how to undo the entire reconciliation in easy methods: Undo a client’s reconciliation in QuickBooks Online Accountant.

 

Once done, you can delete the manually entered bank deposit to remove the duplicate data on your end. Then, undo the added payments by going to the Bank transactions section.

 

Here's how:

 

  1. Choose the specific bank account by clicking the blue tile.
  2. Click the Categorized button.
  3. Select the Undo link under the Action column.

 

After that, you can use the Find Match tool and turn on Suggested Matches to see options that might match. This allows you to match the deposit payment to multiple invoices. Please follow these instructions:

 

  1. From the Bank transactions menu, select Bank transactions and go to the For review tab.
  2. Click the transaction and select Find match. If you can't find the match, click Find other matches.
  3. Turn on the Suggested Matches button. Then, look for the match transactions and check their boxes. 
  4. Click Save.

 

Then, you can now see that your invoices are already mark as paid in your QuickBooks.

 

In case you need different guidelines that will help you perform or fix any reconciliation issues that you might encounter in QBO, you can refer to this article: Learn the reconcile workflow in QuickBooks.

 

Keep us posted if you have additional information or clarification about managing your invoice and payments, or reconcilation in QBO. I'm always here to assist you, Chris4242. Have a good day.

Chris4242
Level 1

QBO balance higher than bank balance

Thank you so much. One more question. Do I need to create a bank deposit entry when I have my bank account linked? We go from invoice, to receive payment (invoices go to undeposited funds), then I use the bank feed entry to match the bank feed deposit to the invoices. Is that correct?

Rea_M
Moderator

QBO balance higher than bank balance

Yes, you need to create a bank deposit entry, Chris4242. I'll guide you on how to do this so you can manage your bank transactions accordingly.

 

When receiving payment for an invoice that goes to your undeposited funds, you'll have to make a bank deposit to match it to the bank feed. Here's how:

 

  1. Select + New and choose Bank Deposit.
  2. From the Account dropdown, choose the account you want to put the money into.
  3. Click the checkbox for the payment to deposit.
  4. Select Save and close.

 

Afterward, go to the Bank transactions menu to categorize and match your bank feed deposit to the existing entry.

 

Additionally, we recommend regularly reconciling your accounts (monthly) to effectively track your business revenue and keep your financial data updated.

 

If you have other concerns about bank deposits and reconciling accounts in QBO, don't hesitate to ask, as I'm always here to assist you in any way possible.

Need to get in touch?

Contact us