In my profit and loss report, Quickbooks is double counting my income. It shows Invoice and Payment of the invoice (direct deposit into my checking account) as income.

Thanks for visiting the Community, english_august.

We’ll have to undo the added transactions and match them. This process ensures the income on your Profit and Loss Report will show the correct amount.

Here’s how:

1. Go to the Banking menu on the left panel to select Banking.
2. From the list, choose the account you’re working on.
3. Navigate to the Categorized tab and tick the boxes for the payments.
4. Then, press the Undo button and then hit Continue.

The entries will now show in the For Review column. From there, mark the box for the payment and choose to Find Match. For detailed instructions, follow the steps in this article: Categorize and match online bank transactions.

I’m adding some resources to help you in the future. These articles contain information about customizing financial reports and steps on how to fix when income is missing on the Profit and Loss Report.

• Customize reports in QuickBooks Online
• Why are my income and expense transactions missing from my Profit and Loss report?

You can always get back to me if you have any other concerns about QuickBooks. All you have to do is leave a comment below and mention my name. I’m here ready to answer them for you. Have a good one.

Thank you. The steps that you stated above fixed my current P&L. Will I need to do this every time I invoice and a customer and their payment comes through?

I'm glad the steps shared by my colleague above helps fix your Profit and Loss reports discrepancy, @english_august.

With regards to going through the steps again when recording invoices and payments, not at all. QuickBooks automatically looks and tries to match your downloaded transactions. This keeps your record accurate and avoids any duplicates. 

All you have to do is to categorize it to the correct account. However, if you find any discrepancy with your P&L reports, you'll want to perform the steps again to correct them. For more details about this process, you can read through this article: Categorize and match online bank transactions. 

Additionally, I'm adding these resources for your future reference. These guide you through the steps on how to link a deposit to an invoice and reconcile your accounts flawlessly:

• How to link a deposit to an invoice
• Reconcile an account in QuickBooks Online

Keep me posted if you other questions about categorizing your transactions. I'll be around to back you up. Stay safe and have a great week ahead!

Hi Dealia,

Thank you for getting help with finding your invoice as a match. Normally, it should still show up as available for matching, provided that you didn't change anything in it. Let's check to see what happened.

First, let's check the invoice to see if it was automatically linked to other transactions, was deleted, or voided. Basically, we want to find out if the invoice still exists. 

If the invoice is still there, we can do the manual method to find it as a matching entry. To do this, you'll want to click the downloaded transaction, choose the Find match radio button, and find the invoice in the list on the next page. Make sure the date range covers the date of the invoice. We do this if the date of the matching transaction is too far from the date of the downloaded transaction, making it undetectable in the For review section.

If you really can't find the invoice, we can proceed to the browser troubleshooting steps to find out if this behavior is caused by random browser issues.

To start, you'll want to sign in to QuickBooks using a private browser. This step disables its extensions and stops the cache from saving your browsing history.

• Google Chrome: Ctrl + Shift + N
• MS Edge and Firefox: Ctrl + Shift + P
• Safari: Command + Shift + N

If your invoice shows up, you can go back to your regular browser and clear its cache. If not, please try other browsers to see if we get the same thing.

After fixing the transactions, you can reconcile your account.

Please feel free to share an update, so we can help you further if there's still a need to. We're always available for you, even on weekends!

None of these steps are fixing the P&L statement for me. It just moves the deposits elsewhere. 

Thanks for joining us on this thread, @shellyvm.

We appreciate your effort in following the steps provided by my colleague above.  If none of them worked out for you, I suggest getting in touch with our QuickBooks Support to have this investigated. Unlike in this public forum, they have the tools required to perform any escalations in the system whenever necessary on your behalf.

Please be reminded that our Support Team is available from 6:00 AM until 6:00 PM on weekdays, and 6:00 AM till 3:00 PM PT on Saturdays. Here's how to contact us:

        1. Click the Help (?) icon.

         2. Choose Contact Us.

        3. Enter a brief description of your situation in the What can we help you with? area, then click Let's talk.

        4. You'll be presented with a few options for connecting with Intuit. Select Get a call.

Feel free to browse these articles. They contain information about customizing financial reports and steps on fixing missing income on the Profit and Loss Report:

• Customize reports in QuickBooks Online
• Why are my income and expense transactions missing from my Profit and Loss report?

You can always drop your reply below if you have further questions. Let me know and I'll gladly help you out. 

I am having the same problem, but none of these fixes or any I've found work, and here's why:

The transactions do not show up to be categorized. They were not categorized, they just show up in the bank register, and I can see there are the same entries being counted twice. But there is no option to undo them.

Overall, the issue is that only certain entries are available to categorize or match, and so I am basically just stuck. I was on chat with support for four hours yesterday and was essentially told, we can't help/we don't know why your transactions don't show up with the ability to categorize them.

I hear your sentiments, and I appreciate you trying all the possible troubleshooting steps to fix the issue. Let me share additional information to sort things out.

It's possible that you're using a certain asset or bank account for some of the product or service item for your invoices instead posting it to an income account. This can cause a double entry and will automatically show up on your bank register. That said, you'll want to review the account you're using for the products and services on your invoices.

Here's how:
 

1. Go to the Gear icon.
2. Select Product and services.
3. Choose the an item and click Edit below the Action column.
4. From the Income account, ensure that you're using an income account not a bank or an asset account.
5. Then select Save and close.
    

Additionally, when you're matching transactions, deposit can be matched with a certain invoices, bank deposits or payments created in QuickBooks. If you've created a transactions in QuickBooks, this should match the transactions from your For Review tab.

However if everything is done and still get the same concern, I recommend you reaching out with our Technical Support Team one more time, so they can investigate further about the issue. You can also ask for a screen-sharing session with the support to check into your account set up. 

I've also added the following article for more details:
 

• Link a bank deposit to an invoice in QuickBooks Online
• Categorize and match online bank transactions in QuickBooks Online

Once everything is settled and you're ready to reconcile your account, please see this article for more guidance: Reconcile an account in QuickBooks Online.

Ping a me a reply if you need more help in categorizing your transactions or  managing invoices in QuickBooks. I'll be around. Have a good one!

QB - we have switched banks since last year and no longer have record of the banking transactions.  However, our sales and services is showing the same amount, doubling our income for 2022 on the tax summary sheet.  Is there another way to fix this issue?

Hi, lazybaconbbq.

Yes, there's a way to fix why the income shows double on the tax summary sheet.

We'll have to delete the transactions that cause the duplicates manually. To do so, you can go to the Bank Register page or click the amount on the tax summary report. Before doing so, you'll need to have your bank statement ready as your reference in verifying if the entries are valid duplicates.

If you want to delete the entries on the Bank Register page, you can follow these steps:

1. From the Accounting tab, select Chart of accounts.
2. Locate the account that has the duplicates.
3. Under ACTION, click View register.
4. Select the duplicate transaction.
5. Click Delete.
6. Select Yes.

Do the same steps for the other transactions.

Once everything's good, you can reconcile the account so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

Feel free to post anytime you have concerns about the reconciliation process.

We use QuickBooks for our Church accounting. I'm working on using the Donor receipts to create a End of Year donation for all our church members who gave throughout the year. 

Currently we accept donations through the Square app and through Paypal on the church's website. Both of those apps are scheduled to transfer fund the next business day into the church bank account. So these donations are captured on the Bank Account as a Deposit, and one lump some for the previous day. 

I saw a tab under Banking that said apps and saw that Square was an app able to be connected to my Quickbooks account. I answered a few questions, created a sub account or category call "In service giving" and connected our Square account with QuickBooks.  This created automatic Donor receipts for the corresponding Donors based on their names. However I soon realized this money was showing up as a Deposit and also as "In Service Giving" money, so the income was duplicated. 

Any ideas on how I can connect the account but not have it report twice as income. Can I match the Square Transactions to a Bank Deposit?

~ A concerned Bookkeeper whose already 6 months behind. 

Any help or suggestions are greatly appreciated. 

Hello there,

Square brings all recorded sales to QuickBooks, including the bank deposit and transaction fees charged by Square. You'll want to determine the destination of the income deposited from Square.

If you have a Square Bank account, you can initiate a bank transfer from Square to your Business account to align with the deposits.

Alternatively, if you are utilizing Undeposited Funds, you can generate a bank deposit in QuickBooks and choose the relevant sales payments for matching. Allow me to demonstrate the steps:

1. Click on the +New button.
2. Select Bank deposit.
3. Choose the specified payments.
4. Click on Save and close.

You can visit these articles for future reference:

• Categorize and match online bank transactions in QuickBooks Online.
• Reconcile an account in QuickBooks Online.

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

Hi.  I'm having this same issue where *some* (not all) of my income transactions are showing up as both service and sales, making my P/L report inaccurate.  I don't have an "Accounting" tab in quickbooks online as is referenced in this solution.  Can you provide a more current solution for quickbooks online users?  My bank is correct, the issue is just with reporting in quickbooks.

I appreciate you giving details of your concern here in this thread, @ashifflett.

It could be that your QuickBooks Online (QBO) is set as a Business view, which is why the Accounting tab isn't showing. If it's indeed the case, you can go to the Bookkeeping tab to visit your Chart of Accounts. Let me guide you through the steps how:
 

1. In your QBO account, go to the Bookkeeping tab, then select Chart of accounts.
   
   
    
2. Locate the account that has duplicate transactions.
3. Under Action, select View register.
4. Select the duplicate entries, then click on Delete.
5. Once ready, click on Yes.

Moreover, I'll also share these steps on how to switch your QuickBooks to Accountant view:
 

1. In your QBO account, click on the Gear icon.
2. Select Switch to Accountant view.
   
   

Additionally, I'll also share this article that can serve as your reference if you want to get the most out of your financial reports in QBO: Customize reports in QuickBooks Online.

I'm looking forward to getting this sorted out. Feel free to leave a reply if you have additional QuickBooks-related queries. The Community team always has your back. Have a good one.

Thanks.  I was able to switch to accountant view.  Unfortunately, this still didn't solve my problem.  I can't locate the account with the duplicates, so I still cannot get it to stop double counting services and sales.  My P/L doesn't reflect what I see anywhere else in QB.  QB knows my sales.  Invoices are correct.  It's just the profit and loss report that is still wrong.

Thanks for coming back to us, ashifflett. I can help resolve issues with your Profit and Loss report in QuickBooks Online (QBO).

We can open the transactions within your profit and loss report to identify any duplicates. It's also possible that it didn't match correctly why there's double income.

However, if you manually created a deposit in QBO and your banking is connected we can delete it and then undo the one from your banking.

Here’s how:

1. Go to the Accounting menu and click Chart of Accounts.
2. Locate and click the View register of your bank.
3. Click the manually created Deposit and select Delete.
4. Hit OK to confirm.

Undo the added Deposit from the Banking page:

1. From the Banking menu, click the bank where the deposit came from.
2. Select the Reviewed tab, and look for the deposit.
3. Click Undo under the ACTION column.

After deleting or resetting the deposits, we’ll match the invoice that was already paid to the cleared deposit from the Banking page.

1. Still from the Banking page, select the bank and look for the deposit in For Review.
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 done, try to run the Profit &Loss report again to check the total.

Additionally, if you use the receive payment or bank deposit feature to record the payment, I suggest excluding the transaction on your banking feeds. Doing this will remove the entry that keeps showing up, and prevent duplicate entries on your sales.

Keep me posted if there's anything else you need. I'm always around here in the Community forum to help.