Total wages doubled in Profit and Loss report

I can help you fix the duplicate wages showing on the Profit and Loss in QuickBooks, mkhalilpour.

Duplicate entries may be caused by these possible reasons:

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

You can exclude the duplicate from the Banking page. Let me guide you on how:

1. Go to the Banking menu, then select Banking.
2. Go to the For Review tab.
3. Mark the duplicate.
4. Select the Batch action drop-down menu, and then click Exclude selected.
5. The transaction moves to the Excluded tab.

Also, I added this article if you need help with reconciliation: Reconcile an account in QuickBooks Online.

You can always get back to the Community if you need help again in the future.

Hi GlinetteC

Thank you for the guidance. I know that the bank transactions can be excluded, but is there any way to match the payroll expenses with bank transactions? I tried to match the bank transactions, but the payroll expenses did not appear in the Match Transactions menu.

Thanks

Mo

Hi Ashleigh1

Thank you for the guidance. I have set up sub-locations for each employee. But I think I should wait until next month to run the New Payroll? The current Payroll (May) is already submitted to HMRC and cannot be deleted.

Thanks

Mo

Welcome back, Mo.

Allow me to clarify things and help you with your payroll concern.

If you don't need to change any data on your current payroll (May) that was already submitted to HMRC, you can run new payroll this month (June). This way, your allocated sub-location for each employee will reflect and be able to match the payroll expense to your bank transactions.

However, if you need changes on your submitted payroll, I recommend contacting our QuickBooks Support Team. One of our agents will help you make a correction on your payroll. To reach them, you can follow the steps below:

1. Sign in to your QuickBooks Online account.
2. Click the Help button.
3. In the QuickBooks Assistance chatbox, select Talk to a human and choose I still need a human.
4. Select Contact Us.

You may need some data about your payroll transactions. You can run several payroll reports to view useful information about your business and employees.

Our doors are always open to help you again if you have any other concerns or follow-up questions. Have a good one, Mo.

Hi Mark_R

Thank you for your message. I contacted Quickbooks support team through the Live Chat a number of times. However, it seems that nobody knows how to match bank transactions with Payroll account. Their only suggestion is to exclude the relative bank transactions.

I was hoping that someone in Quickbooks could help me with the above request that I believe is a basic requirement for book keeping.

Thanks

Mo

I have this exact same problem.  I see you were offered a couple of pieces of advise.  Did either of them work? 

Thanks for joining in on this conversation, @mlamb3. I'll be glad to guide you in removing the duplicate wages shown in your Profit and Loss report.

Since the duplicate comes from the bank feeds, we'll have to match it to the payroll expense to link them together. However, we're unable to do that directly. We'll need to set the employees as sub-locations first and split the costs. Here's how: 

1. Go to the Gear icon and select Chart of Accounts.
2. Locate the account for the transaction and click Account History under the Action column.
3. Select the transaction and click Edit. 
4. Enter the other accounts to add. Make sure that they add up to the total amount of the transaction.
5. Click Save. The transaction now appears Split in the account column.
   

Once done, match the payroll expense to the bank transaction. You may also refer to the instructions stated above by my colleague, Ashleigh1.

Moreover, each time you pay your employees, you'll need to submit an FPS to HMRC detailing all payments and deductions made to employees.

Feel free to reach out back to us whenever you have further questions about wages showing as duplicates in your Profit and Loss report. The Community is here to help anytime.

Hello,

I finally figured this out today and I just wanted to share.

You go to the gear icon then payroll settings

click on the pencil by accounting at the very bottom

then go to update transactions. 

I just updated all my transactions for the year and some how that fixed it. It almost seemed to easy to be true. I hope it works for yours, as well.