QuickBooks, by default, offers a single account called Payroll Expenses in your Chart of Accounts and all of the pre-programmed Payroll Items for wages and taxes are assigned to that one single account. When a business owner runs a Profit & Loss Report, when QuickBooks is set up in this manner, the report doesn’t really provide him with any real idea of how much he paid in wages vs. taxes because it’s all just lumped together in a single amount.
I find this to be very frustrating because it means that you have to run additional reports and perform additional calculations in order to determine very basic information.
Previously, we covered creating a more functional Payroll Liabilities section on your Chart of Accounts, so that you could quickly and easily see not only the total of your payroll liabilities; but also the individual amounts that you owed for each specific payroll liability at a glance.
Today, we are going to discuss creating a more meaningful Payroll Expenses section, so that you can see how much you paid in wages vs. taxes; without having to run additional reports or perform additional calculations.
Before we begin to get to work, I will recommend that you contact your accountant or tax preparer before you start this process, they may want to help you to take this one step further – such as dividing wages and taxes between Cost of Goods Sold for your field workers and Payroll Expenses for your in-house office staff, which we are not going to cover in this post.
NOTE: Always make a backup of your QuickBooks file before making any changes to your file!
Step 1 – Determine What New Accounts to Create in Your Chart of Accounts
Start by looking at your current Payroll Item List {Lists menu –> Payroll Item List} to see how things are currently setup and to plan how you want to set up the Payroll Expenses section of your Chart of Accounts.
From this list, we can see that we have Salary and Hourly Wage items, bonuses, Worker’s Compensation, and taxes – perhaps we want our Payroll Expenses section to contain Sub-Items for:
- Salary
- Wages
- Bonuses
- Vacation
- Sick
- Taxes
- Federal Unemployment {FUTA}
- Medicare Company {M-CARE}
- Social Security Company {FICA}
- State Unemployment {SUI}
- Employee Training Tax
- Workers Compensation
Step 2 – Create New Sub-Accounts of Payroll Expenses
The first thing we want to do is add Sub-Accounts to our Payroll Expenses section for Salary, Wages, Bonuses, Vacation, Sick, Taxes & Workers Compensation. To do this:
- from the Lists menu –> choose Chart of Accounts –> click the Account button at the lower left corner –> choose New –> click into the radio button next to Expenses and then click the Continue button.
- In the Account Name field, type in Salary
- Click into the box in front of Sub-account of, to select it, and then from the drop down list choose Payroll Expenses. Click the Save & New button.
- Create sub-accounts for Wages, Bonuses, Vacation, Sick, Taxes & Workers Compensation.
Step 3 – Create Sub-Accounts for Taxes
Once you have the Sub-Account created for Taxes, next you create additional sub-accounts to track specific payroll taxes that your company pays; Federal Unemployment, Medicare, Social Security, State Unemployment, and Employee Training Tax. To do this:
- from the Lists menu –> choose Chart of Accounts –> click the Account button at the lower left corner –> choose New –> click into the radio button next to Expenses and then click the Continue button.
- In the Account Name field, type in Federal Unemployment
- Click into the box in front of Subaccount of, to select it, and then from the drop down list choose the Taxes subaccount below Payroll Expenses.
- Click the Save & New button
- Create accounts for Medicare, Social Security, State Unemployment, and Employee Training Tax.
- Click Save & Close when you finish creating the last account.
When you are finished, your Chart of Accounts Payroll Expenses section should look similar to the screenshot below:
Step 4 – Map Existing Payroll Items to the New Payroll Expense accounts
Go back to your Payroll Item List {Lists menu –> Payroll Items List} and beginning with the first item in the list, edit it {usually double-clicking on the item will open the Edit window}, click the Next button until you reach the Expense Account window and then from the dropdown menu, select the correct Payroll Expenses sub-account. For example, I chose to edit the Salary – Designer item and then chose the Salary sub-account of Payroll Expenses. See the screen shot below.
When you have finished, review the Expense Account column in the Payroll Item List to make sure that you have accurately assigned your payroll items to the proper sub-accounts. Do not skip this step!
Your more detailed Profit & Loss Payroll Expenses section
Now when you run a Profit & Loss Report, you can easily see the details that make up your total payroll expenses without having to drill down or run additional reports and perform additional calculations.
A note to accounting professionals. I realize that many of you don’t want to see all of the details that your clients may want and/or need to see when you run the same reports – don’t forget that QuickBooks provides a Collapse button at the top of the Profit & Loss as well as the Balance Sheet Report which allows you to see just the totals for the main or parent accounts in these reports.
We hope that you find this post – and other related posts; to be helpful.
Hello Larry
I’m going to be really honest with you, it can be done BUT it’s a lot of work not only to set up but to maintain if you want it to the penny.
Most people map the payroll wage items to the specific G/L accounts, set the tax items, etc. to track expenses by job and deal with the “close enough”.
If you’d like to discuss this further, give me a call at (888) 348-2877. I’m on the East Coast.
Hello Nancy,
We have four payroll g/l accounts-
1)- Officer;
2)- Admin;
3)- Operations;
4)- Hourly
The Hourly payroll is allocated to each customer’s construction job in QB. Items (1)- (3) are not allocated to the jobs. How should we set up the Payroll Item Listing to capture w/c, liability insurance, FUTA, SUTA and employer taxes attributable to the Hourly payroll and have the costs allocated to the customer’s construction jobs in QB? We also want the Payroll Item Listing to capture the w/c, liability insurance, FUTA, SUTA and employer taxes attributable to Items (1)- (3) but not allocate the cost to the jobs in QB.
We use QB Enterprise v15.0 Contractors Edition.
You’re welcome. Glad this post was helpful 🙂
Thank you1 I knew there was a better way…..
Angela
Unfortunately QuickBooks will only post the taxes to a single set of accounts – you can try a journal entry – but make sure that you make a backup before you try it.
We have two departments that we are using the classes function for so we can run profit & loss statements separately when needed. I have two separate payroll expense accounts created in the chart of accounts with specific payroll items setup for those. I have not determined how to split the tax expense for the company match on SS/Medicare between these payroll expense accounts. Is it possible to have the company match post transactions to different payroll expenses? Whenever payroll is done, the gross wages will report to the proper payroll expense account but the associated tax expense will all post to just one payroll expense account.
Hi Christopher – thanks for stopping buy – glad you found this article helpful!
I have been trying to figure this out forever…thanks!!!!!!!!!!
Hi Cami
Thanks so much for taking the time to leave a comment! I’m happy to hear that this post has helped you to become less frustrated over the information that was appearing in your P&L! Hope you drop by again, there are a lot more articles like this here.
Nancy
Thank you so much for this post! I only know basics in qb, but this was very detailed and it helped me so much. I was frustrated with my P&L, now it’s more helpful to me 🙂
I appreciate the time you put into this.
Thanks again,
Cami
John
Thanks for stopping by. I agree with you, some companies require a more robust method of tracking budgets and the ability to achieve robust forecasting. Your software looks quite interesting. I see it interfaces with Sage products; any plans for QuickBooks integration?
Quickbooks is a useful tool, however some companies need a solution that offers more. In order to grow, a company needs a budgeting system that has forecasting capabilities and is more streamlined across departments.