Total wages doubled. Quickbooks is totally my paid wages twice as an Expense and as a DD Check. How do I eliminate one of them from the report and total wages?

Hi matlucas,

Here are a few possible reasons why your total wages shows doubled in a report:

• Payroll transactions from the banking page are added instead of matching them. 
• An Expense transaction was created.

For payroll transactions that were added from the banking section, you can undo them.

Here's how:

1. On the left panel, click Banking.
2. Click the In QuickBooks tab, and find the payroll transactions.
3. Put a check mark on payroll transactions and click the Undo button.

Once done, go to the For Review tab. Then, select each payroll transaction and choose Find Match to see if there's a match. If not, then you can exclude them. Please see article: How To Exclude Expenses from Downloaded Bank Transactions.

If an expense transaction was created, you can delete them by following these steps:

1. On the left panel, click Expenses.
2. Choose Expenses, then click the Filter drop-down list.
3. Select Expense from the Type drop-down menu.
4. Choose the Status, Date, and Payee.
5. Click Apply.
6. Click the expense to open, and click More located at the bottom.
7. Select Delete, and click Yes to confirm.

Then, try running the report again to check if your total wages are accurate.

Please let us know if you have any additional questions about QuickBooks. Thanks.

Thank you for the help with this- I was able to exclude them. Now, my banking (in quickbooks) is different. How do I fix that?

Good morning, @eComm. 

Thanks for joining in on this thread. I hope your week is going well so far. 

When you exclude transactions from your "Banking" page, it will change the bank balance/QuickBooks balance. Excluding those transactions means that you're deleting them. If you're referring to fixing your balance, then I recommend consulting with your accountant. They'll be able to give you the best accounting advice for your business. If you don't have one, no worries. Check out this link to find one near you. 

If you're referring to something else in your QuickBooks Online (QBO) account, then please provide me with some screenshots or additional insight into this issue. 

Please let me know if you need any more help. I want to make sure all of your concerns are addressed. I value you and the success of your business. I'll always be around to help. Have a great day! 

I am having the same issue.  When the payroll is generated it is booking the expense.  Then an ACH is created and it shows up on the banking side.  You have to confirm this so the balance matches and now it is booked twice in QB.  

Thanks for posting here, @CS2699,

We want to make sure you're able to match your transactions in QuickBooks Online. To avoid duplicate posting in the register, you need to match the payroll entry towards the bank statement.

Using the add option will create another entry in the register which will cause discrepancies in the bank balance. 

See this screenshot as an example of a match:

If the match is not detected in the Banking page, you can click the transaction and use the Find other matches option to reveal other related entries. To get more information on how to handle bank entries in QBO, see this link: Categorize and match online bank transactions in QuickBooks Online

Another option if those entries are added transactions from the bank, you can undo and exclude them. To do that, follow the steps below:

1. Go to Banking menu, then tap the Categorized tab.
2. Find the transaction and select the Undo link under the action column.
3. Go to the For Review tab.
4. Mark the box next to each transaction you want to exclude.
5. Select Exclude from the pop-up at the top.
   

Excluded transactions are then moved to the Excluded tab, and won’t be added to QuickBooks or be downloaded again. To permanently delete duplicate entries, put a check mark on them, then hit Delete.

If it was already added in the register, you can manually delete them. The following link will guide you how to remove entries in QBO: Void or delete transactions in QuickBooks Online

If you have further questions about the process, please feel free to post them here or mention my name. I'll be here to help you manage your QBO transactions. Have a nice day!

No matches can be found and my system does not show find other matches.  Would it be best just to call QB's at this time?

Thank you for reaching back out, CS2699. I agree with you that it would be best to reach out to our QuickBooks Support Team to investigate the matter further. Our team has the tools to do screen sharing and, if necessary, escalate the case in a secured environment. Here's how to connect with us:

1. Sign in to your QuickBooks Online company.
2. Go to Help ( ? ) and click Contact Us.
3. Enter your concern, then select Let's talk.
4. Choose a way to connect with us:
   • Start a chat with a support expert.
   • Get a callback from the next available expert.
5. Enter your contact information and select Confirm my call if you choose to speak with a representative.

Please let me know how everything goes. If there is anything else I can do to help, don't hesitate to comment below. Until then, I hope you enjoy the rest of your day.

My payroll is duplicating as well-transaction match and then another transaction is downloaded as a check. 

This was recorded properly as a paycheck and then a second transaction above has been created for each direct deposit. 

I know how to get rid of/exclude the duplicate. I need to know why this is suddenly happening AND HAVE IT NOT HAPPEN. That is a software issue and I don't want to have to exclude these transactions every time I run payroll. If you cannot address, I will have to move payroll to a more user friendly option. 

I've come to share details on when duplication of downloaded transactions happens in QuickBooks Online (QBO), @SharonH3. This way, you're able to manage them (i.e., payroll) accordingly.

QuickBooks solely depends on the data sent by your financial institution. You're already doing a great job in reviewing and matching your online banking transactions to the existing entries in QBO. Your bank may have experienced some issues in the past that's already been resolved that's why you've received duplicate ones.

You're correct. You need to exclude the duplicate transactions to get rid of them in QBO. This way, you can keep your financial data accurate and updated. To learn more about this, you can refer to this article: Categorize online bank transactions in QuickBooks Online.

Also, I'd recommend reconciling your accounts every month. This is to effectively monitor your income and expenses and detect any possible errors appropriately. For the step-by-step guide, you can check out this article: Reconcile an account in QuickBooks Online.

Let me know if you have other banking concerns or inquiries about managing transactions in QBO. You can drop a comment below, and I'll gladly help. Take care, and wishing you continued success.

Why do the intuit customer service folks insist on giving other advice when they can't answer a question. You have blamed it on the bank-I guess you consider it resolved. 

When I go into my chart of accounts I see a report for payroll expenses, payroll expenses wages, payroll expenses taxes. The payroll wages shows the gross pay, payroll expenses shows the net pay. I feel that the net payroll expenses should be deleted from my QuickBooks am I correct?

Thank you for joining the thread, @dabrahn. Let me share with you some insights about default accounts in QuickBooks Online (QBO).

Default accounts are accounts that can’t be deleted within chart of accounts (COA) in QuickBooks Online. Let’s find out which QuickBooks Online default can’t be deleted.

Here are the list accounts that can’t be deleted as they are created automatically. You also unable to use them for any other purposes:

• Undeposited Funds
• Opening Balance Equity
• Retained Earnings
• Inventory/Stock Assets and Cost of Goods Sold/Cost of Sales
• Reconcile/Reconciliation Discrepancies
• Unapplied Cash Payment Income
• Sales of Product Income
• (Sales tax agency name) Payable

To avoid having issues with your accounts in QBO, I suggest consulting your accountant. In that way, they will be able to decide with you what to do with other accounts in your company.

In addition, I added the following article for more details: learn more about COA and how you can manage your default and special accounts in QuickBooks Online.

• Learn about the chart of accounts in QuickBooks Online.
• Manage default and special accounts in your chart of accounts.
• Delete an account on your chart of accounts in QuickBooks Online.

Let me know if you need further assistance with your chart of accounts. I’m just one post away from assisting you. Have a great day!