cancel
Showing results for 
Search instead for 
Did you mean: 
steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

 
10 Comments 10
Mich_S
QuickBooks Team

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Greetings, steven. I have some ideas to share regarding the information showing on your Profit and Loss (P&L) report in QuickBooks Online.

 

Before anything else, I want to ask where did you see the Net Pay amounts? This way, we can look into it further and guide you through what to do. 

 

The Payroll Expenses area of your P&L report should ideally only reflect the Gross Wage and Employer Paid Taxes. If you see the net figure in that particular field,I suggest clicking on the amount hyperlink to review the transactions associated with it.

 

Note: Below is only an example report. Nonetheless, you can use it as a reference in drilling down the net amount.

 

 

Finally, I recommend reaching out to your accountant in case there are any journal entries or other transactions that may need to be deleted or modified in order to rectify this issue. This will help ensure that your books are well-organized and maintained in proper order.

 

Once you're good with this, you can also explore this useful guide about fixing discrepancies on your account balances: Reconcile an account in QuickBooks Online.

 

Keep me posted if there's anything else I can help you with your payroll transactions or reports. I'll be right here to assist you. Take care!

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Hello! I'm seeing the net amounts in my Wages account, under Payroll Expenses, just as the screenshot shows. We have been using QB since June, and that's how it has been every payroll we've run. There are listing for the gross amounts, showing the employee's name and DD designation, and then the net amount paid is also listed (the bank feed for our linked checking account automatically feeds them into our QB).

 

So it looks like QB creates the payables for the gross amounts, and then QB imports the net amounts from the bank feed. And both remain in our Payroll Expenses > Wages account, effectively overstating payroll expenses by a huge amount.

 

Does that explanation make sense? Please let me know if there is a payroll setting that we can change? Or if there's a workaround for this scenario? Thank you!

Nicole_N
QuickBooks Team

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Thanks for your follow-up on this, Steven. I recognize the issue you're facing having an overstatement of payroll expenses in your wages account when running a P&L report in QuickBooks Online (QBO). Allow me to share some insights about the possible reasons for this and route you to the best support you need.

 

First off, please know that if the transaction that was downloaded from your bank already exists in QuickBooks, then instead of categorizing it, you may have the option to match, add, or view multiple matches to avoid duplicates.

 

Moreover, I suggest you double-check the setup of your employees if these are accurate and alter things that are needed. However, if there are things that really need to be corrected but you're unable to do so like deleting and recreating some paychecks, or if it already involves multiple paychecks, then it's best to reach out directly to our Payroll Support team. They have all the necessary tools to pull up your account securely and make corrections if needed.

 

Here's how you can reach out to them:

 

  1. Go to the Help icon in the top right-hand corner.
  2. Select Search, then press the Contact Us button.
  3. Enter your question in the box and hit Continue.
  4. Choose the best way you'll want to reach out to us.

 

Please consider checking our available hours to make sure we address your concern timely.

 

Don't hesitate to leave a reply if you have other QuickBooks concerns. The Community team is here to assist.

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Another part of this problem is that the gross pay transactions remain uncleared and unreconciled on my bank register. This list will continue to grow as time goes by. Not only that, but it overstates the amount spent from my bank account, so that now my checking account shows a negative $11,000+ balance on my banking screen as the balance in QB when the bank balance is much much higher than that.

 

I cannot simply void the paychecks to correct the balance and to be able to reconcile my account because then the payroll tax amounts would then be made incorrect.

 

Is there really no fix for this?

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Is there no fix for this still? The gross paycheck amounts are still on my P&L as well as the bank register, preventing me from properly reconciling the accounts without voiding the paychecks. But if I void them, then my payroll tax amounts will be made incorrect. Meanwhile, the bank balance on my banking screen is tens of thousands of dollars off. Is there really no way to correct this?

 

Our company just started using QB a few months ago. Will our books always be off? Will we always have to compensate for wrong numbers, or can Intuit fix this for us?

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

I hadn't mean to post twice. I didn't think that first one saved.

JamaicaA
QuickBooks Team

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Hi there, @steven-maus.

 

Thank you for choosing QuickBooks as your payroll tool. I understand the importance of recording paychecks as well as tracking them accurately. Allow me to share additional information to help correct the gross paycheck and net amounts on the Profit and loss report.

 

First, let's review your Accounting Preferences from the Payroll Settings. From there, you can choose the correct account to allocate the wages. This will help us verify the possibility of having the bank account associated resulting in an overstatement. I'll show you how:

 

  1. Go to the Gear icon and select Payroll Settings.
  2. Scroll down to the Accounting section and click the pencil icon.
  3. Make the necessary changes to which account you'd like to use for the wages.

1.png

 

2.png

3.png

 

To learn more about the different payroll account types you can use to track your payroll transactions, refer to this guide: Change your accounting preferences in QuickBooks Online Payroll.

 

I recognize the need for accurate accounting as the program is accounting software. Please know that books should not be off. Therefore, you don't always have to compensate for the wrong numbers. If you'd like to seek help from our representatives, contact our Support Team. They can pull up your account in a secure environment and investigate this matter further to provide appropriate solutions. To proceed, follow the steps below:

 

  1. Go to the Help icon and choose Search.
  2. Click the Contact Us button and enter your concern.
  3. Press Continue.

 qbo_support.png

 

Please note our operating hours so you can contact us timely. For other ways to reach us, refer to this article: Contact Payroll Support.

 

Do you need help paying and filing your taxes after correcting the duplicate payroll and net amounts? Read through this article: Pay and file payroll taxes and forms in Online Payroll.

 

I'm just a click away if you need further assistance reconciling accounts or handling payroll transactions. Let me know in the comment section below if anything else comes up. It's my pleasure to help you.

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Yep, I've done all of that. That had been a problem, but it has since been corrected. Now, the net and tax amounts are landing where they should on the P&L. However, now that that is happening, the gross amounts are a third entry that is still happening on the P&L.

steven-maus87-gm
Level 1

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

Is there any update on this issue? Also, now neither of my October payrolls have posted to the wages account on my P&L. The paychecks are recorded in the bank register and have been paid out via direct deposit. But I cannot for the life of me find them on the P&L. I can't go into the transactions themselves because it always re-routes me to the paycheck list rather than to the actual transactions. How can I view where certain direct deposit paychecks are categorized on the P&L?

Maybelle_S
QuickBooks Team

QuickBooks is recording both the gross paycheck amounts and the net amounts on my P&L. How do I fix this and prevent it from happening again?

I want to ensure this is taken care of, @steven.

 

Since the troubleshooting steps provided didn’t work for you, I recommend contacting our Technical Support Team. They will be able to investigate the leading cause of the issue and determine the correct solution in a secure setting.

 

  1. Click Help on the top right corner of the screen.
  2. Go to the Search tab, then click the Contact Us button.
  3. Enter a brief description of your concern.
  4. Proceed with Continue, then choose Chat or Callback.
    KlentB_0-1676517922094.png

 

Additionally, you can visit this article about running and customizing reports in QuickBooks Online (QBO): Run payroll reports.

 

If you have any other questions about payroll paychecks in QuickBooks, feel free to ask. I'm here to help. Take care.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us