cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
mkhalilpour
Level 2

Total wages doubled in Profit and Loss report

Hi There

 

I have run our payroll by QB Advanced Payroll and then paid the wages to my employees by BACS. After that, in QB Transactions, I categorised the wages expenses as Wages and Salaries. However, in Profit and Loss report, the wages expenses are duplicated. One expense is from my bank statement (QB Transactions) and a duplicate one that is created automatically by QA Advanced Payroll.

 

I wonder if someone can help me to fix the above problem?

Solved
Best answer June 01, 2022

Accepted Solutions
Ashleigh1
QuickBooks Team

Total wages doubled in Profit and Loss report

Hello Mo, So what you would have to do in order to be able to match the payroll expense up in the bank transactions is you would have to set the employees up as sub locations of the primary location>allocate those sub locations within each employee> go the payroll chart of accounts/default accounts and split the payment account, which you would have to have as your bank account, and that would separate the employees amounts  of pay in the journal and you'll be able to match them in the banking. If you have already ran the payroll, you would have to delete it and re-run it so the journals split.

View solution in original post

9 REPLIES 9
GlinetteC
Moderator

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.

mkhalilpour
Level 2

Total wages doubled in Profit and Loss report

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

Ashleigh1
QuickBooks Team

Total wages doubled in Profit and Loss report

Hello Mo, So what you would have to do in order to be able to match the payroll expense up in the bank transactions is you would have to set the employees up as sub locations of the primary location>allocate those sub locations within each employee> go the payroll chart of accounts/default accounts and split the payment account, which you would have to have as your bank account, and that would separate the employees amounts  of pay in the journal and you'll be able to match them in the banking. If you have already ran the payroll, you would have to delete it and re-run it so the journals split.

mkhalilpour
Level 2

Total wages doubled in Profit and Loss report

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

Mark_R
Moderator

Total wages doubled in Profit and Loss report

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.

mkhalilpour
Level 2

Total wages doubled in Profit and Loss report

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

mlamb3
Level 1

Total wages doubled in Profit and Loss report

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

JaeAnnC
QuickBooks Team

Total wages doubled in Profit and Loss report

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.

GT313
Level 1

Total wages doubled in Profit and Loss report

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. 

 

Need to get in touch?

Contact us