Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello,
Back in the middle of 2018 I canceled my QB Payroll in favor of Square Payroll, which I like and feel is a better value. However in manually entering my payroll data, my Payroll Liability is showing up on the balance sheet and continues to grow over time.
I've looked online at YouTube, this QB forums, etc. - no solutions. I need to know how to:
1) Make a general ledger entry to zero the old liability account data off the Balance Sheet.
2) Have a method for adjusting this out each quarter (or annually) moving forward.
Any help is appreciated, thanks!
Hello there, @JWinTX. I have a method for you to adjust and zero out your old liability account data in QuickBooks Desktop (QBDT).
You'll need to enter your historical tax payments made during the current or previous years without affecting your accounts in QuickBooks. This will determine your future tax deposits and help show the appropriate amount of your payroll liability account on the balance sheet.
To do this, you can use the backdoor process or enter your historical payments outside the Payroll Setup window. Here's how:
Moving forward, you can use this method to adjust your payroll liability in QBDT. If you wish to know the other way to enter your historical tax payments, please refer to this article: Enter historical tax payments in Desktop payroll.
Also, you may want to check out this article as your reference in case you want to set up and use different reports to get a better understanding of your cash flow in QBDT: Track your cash flow in QuickBooks Desktop.
Let me know if there's anything else you need or concerns about manually entering payroll data in QBDT. I'm always ready to help. Take care, and I wish you continued success, @JWinTX.
Hello and thank you for your help!
I think this has partially solved my problem. Previously when using QB Payroll, there wasn't a Balance Sheet entry for Payroll Taxes Employee Portion. This was a Liability Account I created after watching a YouTube video for how to handle payroll taxes in QB when manually entering data from Square Payroll.
By using the method you suggested, I now have an entry for Payroll Taxes Employee Portion (a positive value which is growing) but also an entry showing for Payroll Liabilities Other (a negative number which is also growing). Yet the net result is that they effectively cancel each other out on the bottom line of total current liabilities. On accounts affected, I did select "Affect Liability Accounts But Not Bank Accounts". Unless there is another solution for this, having these two (growing) entries that zero each other out is something I can live with.
There is probably a MUCH better way to structure the accounts so I can manually enter payroll and not create this issue. Open to any other thoughts you have...
Thank you,
JWinTX
You're always welcome, @JWinTX.
I appreciate you for letting us know the result after following recommended steps on how to enter historical tax payments in QuickBooks Desktop. I suggest consulting with your accountant for further guidance on how to properly structure the accounts. If you don't have one, not to worry! I can help you run a search.
Here's how:
Furthermore, you can check out our awesome guide on how to fix incorrect payroll liability balances. It also provides some common reasons why it happens.
Feel free to visit the Community again if you need help with QuickBooks. We're always here to help. Have a great day ahead.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here