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

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

What if I make a big deposit at once. How will I know which transaction went with which deposit?

Also!

Is there a way to clear the payments without doubling the deposit later on in the banking section?

Mark_R
Moderator

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hi there, @Trucker41718.

 

Allow me to provide information on your concerns and help you from there.

 

When you make a deposit to your transactions at once, you'll have to select each payment you want to be included. That said, you'll know which transactions went deposited.

 

On the other hand, you can match the downloaded deposit on your Banking page to the recorded payment. This way, it won't duplicate. Here's how:

 

  1. Click Banking/Transactions from the left menu, then select Banking.
  2. Click the deposit and select Find match.
  3. Filter the Date range that includes the date when the invoice payment was created.
  4. Check the Payment, and then click Save.

 

Once you're ready to reconcile your account, you can check out this article for more guidance: Reconcile an account in QuickBooks Online. Reconciling accounts ensure your transactions in QuickBooks match your bank statements.

 

Should you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you, @Trucker41718.

 

rifraf
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

This only seems to help if you have one deposit per invoice. What if you bulk deposited checks for a month?

CharleneMaeF
QuickBooks Team

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thanks for joining us on this thread, rifraf.

 

I know how important it is to ensure your record is accurate. I'm here to help you with that.

 

In QuickBooks Online, we can match bank transactions to multiple recorded entries. You can use the Find match option to link these transactions.

 

Below are the steps to complete this process:

 

  1. Go to Banking and click the payment or Deposit.
  2. Click the Find math option.
  3. Filter the Dates to show all the outstanding transactions.
  4. Select the open invoices and hit Save.

 

You can also check out this article for more details: Categorize and Match Online Bank Transactions in QuickBooks Online.

 

Additionally, I've included an article that'll help you learn how to use rules to automatically categorize transactions from your bank. This speeds up the review process: Set up Bank Rules.

 

I'd love to help if you have additional questions about managing QuickBooks transactions. Keep safe always!

cassandra-johnst
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I tried this but I can't find an Undo function anywhere.  My deposit is also showing as undeposited funds and the invoices are in A/R but the check is deposited obviously and the invoices are match to them and paid.  Why can't it just be easy?  This is obvious stuff.  If I bill something, then I'm paid for it, I deposit the money and mark the invoice paid.  Now I'm facing being taxed on money I literally didn't make because it's showing twice and won't go away.

 

Rose-A
Moderator

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hey there, cassandra-johnst. I'd be pleased to help you find the Undo option in QuickBooks Online.

 

All transactions that were categorized can be found through the Categorized tab on the Banking page. You'll find the UNDO option under the Action column. See the sample screenshot below.
 

 

However, if you haven't categorized the transactions yet, you can exclude them from the banking page. You can get more details about the excluding process in this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Additionally, you can always visit our Banking Help Articles in QuickBooks Online for your reference. This will provide you links to help you with your bank-related issues as well as steps in reconciling your statements. Doing so will help you ensure the accuracy of your financial records.

 

Keep in touch if you have other questions in mind about QuickBooks. I'll make sure to get back to you as quickly as I can. Have a nice day!

BeesDB
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I'm having the same problem but differently. I already know how to match payments with invoices and sometimes the wrong payments are matched with the wrong invoice dates. However, i am a full year behind matching each invoice and what i want is to not worry about matching any payments with invoices at all. I want to be able to utilize recurring invoices but not have to match them with income payments. Just have invoices completely disregarded in my income bracket. I've been here for several hours matching banking transactions and the worst part is matching Remote Online Deposits (Checks deposited through mobile device) with invoices. This requires me to open my bank account statements, click the image to see who the check came from, go back to QuickBooks, find the match with the same date and click confirm. This process I feel is pointless and time consuming. Income is income, I shouldn't need to match income with the invoice in order for my income to not appear doubled. Thank you in advanced

BeesDB
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I'm having the same problem but differently. I already know how to match payments with invoices and sometimes the wrong payments are matched with the wrong invoice dates. However, i am a full year behind matching each invoice and what i want is to not worry about matching any payments with invoices at all. I want to be able to utilize recurring invoices but not have to match them with income payments. Just have invoices completely disregarded in my income bracket. I've been here for several hours matching banking transactions and the worst part is matching Remote Online Deposits (Checks deposited through mobile device) with invoices. This requires me to open my bank account statements, click the image to see who the check came from, go back to QuickBooks, find the match with the same date and click confirm. This process I feel is pointless and time consuming. Income is income, I shouldn't need to match income with the invoice in order for my income to not appear doubled. Thank you in advanced

MadelynC
Moderator

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thanks for sharing your thoughts with us, @BeesDB. I’m here to provide information so you can easily manage your sales transactions in QuickBooks.


I recognize how connecting each invoice to their payments would be time-consuming. And it'd be convenient to disregard invoice transactions from your income bracket. However, it's a primary part of the customer workflow to ensure records are intact and accurate.


You may consider using bank rules to automatically categorize transactions from your bank. Let me show how:

 

  1. Go to your Banking menu, then select Rules.
  2. Click the New rule button.
  3. Enter a name in the What do you want to call this rule? field.
  4. Select whether it's Money in or Money out, and then choose an account.

  5. Set the rule conditions.
  6. Press Save after.


You can use this reference for complete instructions: Set up bank rules to categorize online banking transactions in QuickBooks Online.


You can also set up QuickBooks Payments, so you don’t need to manually link your invoices and payments. Once set up, QuickBooks automatically categorizes each processed payment on your chart of accounts.

 

I’m adding this article to ensure the amounts match your actual bank and credit card statements: Learn the reconcile workflow in QuickBooks. It includes steps to fix balance issues and ways to modify completed reconciliations.


Don’t hesitate to add a comment if you have any other questions or concerns about managing your sales transactions. We're always here to help. Keep safe!

vallomedia
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hello - I am having this same issue but these steps are outdated. What are the new steps to take? Right now I am showing duplicate transactions counting toward my income classified as "Services" whereas my total income is closer to what is recorded as "Income". Please advise 

katherinejoyceO
QuickBooks Team

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thanks for updating us here with your concern, @vallomedia. In your case, you'll want to undo your categorized transactions that made the duplicates. Then, exclude them. I'll show you how to do it:

 

  1. On the Banking page, go to the Reviewed tab, then locate the duplicate items.
  2. Select the UNDO option under the Action column.
  3. Go to the For Review tab.
  4. Tick the boxes for the transactions you want to exclude.
  5. A black box will appear at the top of all transactions showing how many are selected, then select Exclude.

 

All excluded items will now go to the Excluded tab. You can go to that tab should you need to permanently remove these transactions from QuickBooks, then select the tick box to the left of the Date column to tick all transactions. Then, select Delete.

 

For future reference, you can also visit this link to learn more about finding duplicate transaction numbers in QuickBooks Online.

 

Feel free to visit again if you need anything else about managing your duplicated transactions. I’d be right there to help you further.

vallomedia
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thanks for your reply. I went to the banking tab as you suggested and all I see is an ad for QB Banking that says:

 

"Banking designed with you in mind". Kindly see the screenshot below:

Screen Shot 2022-11-13 at 7.47.05 AM.png

 

Which of these menu tabs should I be going to?

 

Screen Shot 2022-11-13 at 7.48.32 AM.png

 

I am unfamiliar with this new navigation that was thrust upon me in QB Online. Note I transitioned from QB Self Employed in July and that's when all my data got screwed up. Is there a tech support line that can walk me through fixing this issue and setting up tracking properly so it no longer happens? 

 

 

Carneil_C
QuickBooks Team

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thanks for your prompt response, @vallomedia.

 

Beforehand, I appreciate you for using QuickBooks Online as part of your business. I've come to help you sort out this issue with your banking transactions.

 

The first thing we can do is ensure that you've chosen the right company when logging in to QBO. If you subscribe to more than one company, here's how you can switch between them quickly:

 

  1. Go to Settings.
  2. Under Profile, select Switch Company.
  3. From the list, select the company you want to switch to.

    image.png

 

Otherwise, we can switch between user views  to verify. Here’s how you can change your view with just a few clicks: 

  1. Log in to your QuickBooks Online.
  2. Go to Settings.
  3. From the lower right part, click Switch to Business view or Switch to Accountant view.
 

image.png

You'll want to visit this article to learn more information about these views: Switch between Business and Accountant view in QuickBooks Online.

 

Moreover, if you need more help figuring out how to use QBO, click on this link: Getting Started in QuickBooks Online.

 

You can post anytime if you have questions about managing your QBO account. Please know the Community has your back.

vallomedia
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Thank you. I was able to switch to Accountant view and follow some of those previous steps. Unfortunately I do not see any duplicate transactions here and there would be too many to manually identify anyway. The problem I am having is that Services are somehow counting toward Income. Yet these are classified as A/R so I am not sure why that is and how to correct it (see attached screenshot) 

LieraMarie_A
QuickBooks Team

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hi there, @vallomedia.

 

I'd love to give some insights about what goes on behind the scenes in QuickBooks.

 

To clarify, did you create invoices for your services? Invoices are used to record sales and get paid in the future. The money that your customers owe to you is referred to as Accounts Receivable in your Chart of Accounts. In the accrual accounting method, you record income the time you provide goods or render service. Thus, you debit A/R and credit Income.

 

You can verify the account associated with your services by following these steps:

 

  1. Go to the Gear icon and select Product and Services.
  2. Find the service item.
  3. Under the Action column, click Edit.
  4. Check the linked income account.
  5. You may change it to a more specific revenue account.
  6. Click Save and close when ready.

 

Later, when your customer pays, you enter a payment against that invoice. It decreases A/R and increases the account you put the payment into (Example: Cash on Hand, Cash on Bank). 

 

Here's how to record invoice payments:

 

  1. Click on the + New button and then Receive payment.
  2. From the Customer dropdown, pick the name of the customer.
  3. From the Payment method dropdown, choose the payment method.
  4. From the Deposit to dropdown, select the account you put the payment into.
  5. In the Outstanding Transactions section, select the checkbox for the invoice you're recording the payment for.
  6. Enter the Reference no. and Memo if needed.
  7. Select Save and close.

 

Moreover, if your customer gives immediate payment, you use Sales Receipt instead. The following articles help you understand more about the difference of each forms in QuickBooks Online. 

 

 

I recommend seeking guidance from your accountant. This way, you can properly enter your transactions. You may visit our ProAdvisor website to run a search if you don't have one.

 

The Community is always here if you have further concerns about your records in QBO. We'll be happy to lend a helping hand. Have a good one!

Dangit1
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I need an updated fix to this issue, please -- the response is from 2020 and this is not helping my issue.

I've got two invoice payments that were combined when received, but the bank download is showing two separate deposits.  When I try to click FIND MATCH, it isn't finding anything at all for those amounts.  How do I get this fixed?  Income is doubled on the QBO bank register.

GlinetteC
Moderator

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I can help you fix this, Dangit1.

 

Linking multiple bank downloads to one existing transaction in QuickBooks isn't an option.

 

You can delete the payment you've received and recreate it separately. This way, you can easily match the deposits from your bank register.

 

Here are the steps on how you can delete the invoice payment.

 

  1. From the Sales tab, select Customers.
  2. Select the customer's name.
  3. On the Transaction List tab, select the invoice payment.
  4. Click More and then Delete.

For additional reference, you can check this article: How to void or delete an invoice or other transactions.

 

If you need help customizing sales forms, you can use this resource for reference and guide: Customize invoices, estimates, and sales receipts in QBO.

 

You can always get back to the Community if you have follow-up questions. We're ready to help you out.

JKilcomons1
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hello - I think I have a similar problem, I'd like to describe what's happening and would love any insight.

We create an invoice in QB online.

The customer clicks and pays.

The invoices shows as "paid" from the deposit.

On the banking tab, I thought I would match the item to the deposit but nothing shows up for it when I say "match"

I noticed it's showing as income on the P&L under "Accounts receivables" so I assumed it was fine, and then excluded the item in banking since it was already on the P&L as income.

I thought I solved the problem... but then when I did the recon, the recon is off an is looking for an income entry for that item.  If I create an entry from the income, it would duplicate it on the P&L.

What is the best way to handle this all?!

Thanks so much.

dallas13
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

I seem to have the same issue where the suggested fix to delete the manually added deposits is not possible.

I have cross referenced my deposits to the bank account as payments with invoices and they are all verified; so why does the Income double count my payments and invoices?

 

This is increasing my income making it invalid; I can't file taxes with this so it's urgent; QB please assist!

 

dallas13
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

>I've been here for several hours matching banking transactions and the worst part is matching Remote Online Deposits (Checks deposited through mobile device) with invoices.

I have the same complaint; when I deposit a mobile cheque, I select the invoice then record the payment; but it seems like QB doubles the amount by counting the manual payment and the bank deposit from online sync.

I thought I matched these transactions but maybe it's not reducing the A/R account?

QB help!! We can't file taxes with your system!!

Carneil_C
QuickBooks Team

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Hello there, @dallas13.

 

I can imagine the hurdle you've been through when trying to sort out this issue. I'm here to route you in the right direction to help you fix this query with your QuickBooks Online showing doubled income.

 

But before I route you to the support team, let's check that the Income Account you used for your product and service is accurate. We can verify if you're using an income or bank account. This might be why it doubles the amount of your payments and invoices.

 

To do so, I'll be glad to guide you on how:

 

  1. Go to Sales from the left menu.
  2. Choose Product and Services and choose the product and service.
  3. Click Edit and double-check the Income Account box.

 

If the account used is the accurate income account, I recommend reaching out to our Customer Support Team. They can check into your account safely and help you resolve this matter. You can open this article to see their operating hours and the steps to contact them: QuickBooks Online Support.

 

For further assistance with your invoices or any transactions in QBO, you can always hit the Reply button below, and I'm more than willing to help. Take care always. 

dallas13
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

This looks promising but I'm not sure which Income Account to select; should it be the A/R or the Sales account?

It seems to me that the A/R is correct because that is where I see the duplicate entries.

dallas13
Level 2

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

If I changed the Product>Income Account;

and also checked the box for "Also update this account in historical transactions";

and selected a Sale tax rate;

Will this change all my past invoices to the selected "Tax Rate"?

This would be a bloody disaster.

JJ0119
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

If you want to fix it with a journal because the double up of invoices and payments cluttering your undeposited funds and your accounts receivables happened in 2015-2020.  please.

All Truck Fleet
Level 1

Quickbooks is showing that I make double my income, because it's counting the invoices as payments as well as the actual deposits. How do I remove the invoices??

Why does QB do this now? I didn't before the updates. In the past, I didn't need to enter every transaction, separate, delete, etc. So WHY is this the way QB is operating now?

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

Need to get in touch?

Contact us