Paid invoice appearing twice in P&L

It occurs to me that the problem may not with me designating the deposit as Sales, but rather with Quickbooks seeing the invoice as "Accounts Receivable" even though it has been paid.

If QB sees it as paid, why does it still categorize it as A/R?

Thank you for contacting us, missionstudios.

Let's fix the double invoices on your Profit and Loss report. You can match those deposits to your invoices to prevent duplicate income. This creates one payment record on your register.

On the other hand, you will see Split when transactions have multiple categories on your Banking page. To resolve this, you have to undo the added transactions and match them. Let me show you how:

1. Click Banking.
2. Select the bank to work with.
3. Choose the In QuickBooks tab.
4. Look for the transaction and click Undo.

These transactions will go back on the For Review tab. Here's how to match deposits to your invoices:

1. Under the For Review tab, click the transaction.
2. Choose the Find Match radio-button (see screenshot).
3. On the Match Transaction window, select the invoice transaction by putting a check mark.
4. Click Save.

For additional information, please refer to these articles:

• How to add and match downloaded banking transactions

• Why are my income and expense transactions missing from my Profit and Loss report?

On the other hand, you will see Split when transactions have multiple categories on your Banking page.

Let me know if you need additional information about those duplicate entries. I'm always right here to help ensure you only have one invoice record on the Profit and Loss report.

I'm having the same issue when customers pay with credit card. I send invoice, customer pays, quickbooks automatically receives payment. When trying to find match for the banking transaction, the invoice it belongs to does not appear, I'm assuming because it's closed.... So, I now have a banking transactions just hanging out until I can figure out what to do with them. 

Thanks for joining in this conversation, @codymeansy. It could be that that the Auto apply credit is turned on. 

Let's go to your Settings and turn it off so it won't affect your invoice. 

Here's how:

1. From the Settings menu, select Account and Settings.
2. Choose Advanced, then click the pencil icon under Automation.
3. Unmark Automatically apply credits option then hit Save once done.

Once done, let's open and unlink the payment for that specific invoice. Here's how:

1. Go to the Sales menu then select Invoices.
2. Choose the specific invoice with mark as paid and deposited.
3. Click payment made below the PAID payment status.
4. Uncheck that invoice to unlink to the payment.
5. Hit Save and Close once done.

For future reference, follow the steps to match your bank transaction with the one you've entered in QuickBooks in this help article: Match with an existing transaction. 

Visit us here again at any time if you have additional concerns. I'd be delighted to attend your next posts. 

I am having the same problem, but I am dealing with large invoices that apply to multiple customers.

I manually split the incoming payments among the correct customers. When you do that, however, Quickbooks does NOT allow you to match the payment to the invoice - and vice versa (if I Match I cannot also Split).

So, my process is:

- Split the payments to the correct customers

- Then I have to go to 'Invoices' and mark them as paid.

Could that be the reason why they are still showing as A/R? Also, how do you correct the problem without going back and Matching?

Good to see you here in the Community, @Wolverine2. 

You've got me here today to share some information about the matching transactions in QuickBooks Online. 

If you categorize the bank transaction to Accounts Receivable, the customer's balance will be negative or there is a credit available. Once the customer pays the invoice, you must link the available credit to the invoice and zero the total amount to close the invoice. 

To answer your first question "Could that be the reason why they are still showing as A/R?", no. It will still show as Accounts Receivable because in that reporting period there's an A/R transaction regardless if paid or not. 

You can change the Accounting method in the report to a Cash basis. For your reference, you can also check out this article for more information: Change the accounting method.

Make sure to check the reporting period is correct. You can also add the Debit and Credit columns to have an idea about the Profit & Loss movement. 

For your second question "How do you correct the problem without going back and Matching?", if you still getting incorrect data after changing the Report period and Accounting method, you need to UNDO the added bank transactions. After that, you can Find a Match to the invoice. 

Once you split the bank transaction and you did not affect A/R, it will cause a duplicate in your register. To fix this, you need to UNDO the bank transaction again. 

Here's more information about adding and matching transactions in QuickBooks Online: Download, match, and categorize your bank transactions in QuickBooks Online.

If you require more information about matching spit payments and Profit and Loss reports in QuickBooks Online, please let me know. I'm here to help. 

Hi, 

What do I do when the bank register is showing one deposit for Intuit payments but the profit and loss is showing double payments? One for the invoice and one for the Intuit payment when it comes through?

Good day, TC80. Let's get this sorted out.

As referenced by my peers above, you can undo the Intuit payment and match it to your invoice payment or  exclude duplicate transactions. Here's how to undo a transaction:

1. From the Banking page, go to the Categorized tab.
2. Find the Intuit payment from there and click Undo.
   
3. Hit OK.
   

Once done, you can match the payments by following the steps in this article: Categorize and match online bank transactions in QuickBooks Online.

Additionally, I recommend customizing your profit and loss report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

Should you need additional help, please let me know. I want to make sure your financial report is accurate. Have a good one!

I have followed all suggested steps above and it is still showing twice on my P&L report. It is showing my profit $2153.64 more than my business actually made. Is there any other way to correct this? Again I have done everything stated above. I have matched it multiple times and it still shows up twice. I even tried deleting the invoice, unmatching the payment, and creating a new invoice to apply the quickbooks deposit to and it still shows up twice in my P&L. Please help

Undoing and rematching doesn't remove the duplicate transactions from the P&L. Did anyone ever find another solution to this? I have some invoice payment amounts showing twice or even three times.

We appreciate you joining the thread, @mwwolfmn.

Reading your post, it looks like you've already received payment for the invoice and then made a bank deposit. In cases like this, please know that this process causes the income to appear twice and reflect in your Profit and Loss report. To avoid posting it twice, you'll want to review the payment made to the invoice Deposit to field, and check if it's posted to Undeposited Funds. If this is the case, you'll want to edit the bank deposit made and delete the item you've added in the Add funds to this deposit field. Once done, choose the amount in the Select the payments included in this deposit section to match the invoice total.

However, if you've selected the correct bank account when reviewing the invoice payment made, you'll want to delete the bank deposit instead to get rid of the duplicate posting. We'll input the steps to get you going:

1. Access your QuickBooks Online company.
2. On the left navigational bar, go to the Transaction tab and select Chart of accounts.
3. Locate the account, and then click View register.
4. Locate the bank deposit and then click on it.
5. Select Delete.
   
   If you're unsure of what to delete, you may run the Transaction List by Customers to review the invoices and see and get rid of those unwanted transactions. These are the steps:

1. Access your QuickBooks Online company.
2. Go to the Reports tab, and then in the Search bar, type Transaction List by Customers. 
3. Choose the correct reporting period and click the Run report button.

In addition, we've got these articles to help you add more details to your report and keep your current settings for future use:

• Customize reports in QuickBooks Online.
• Memorize reports in QuickBooks Online.

The Community team is always ready to get back to you anytime. Please don't hesitate to leave a comment below or post here. We've got your back.