QuickBooks Tip-Creating a Functional Payroll Liabilities Section

A QuickBooks Payroll Tip for creating a more functional Payroll Liabilities section on your Chart of Accounts.

QuickBooks, by default, provides a limited Payroll Chart of Accounts containing only two accounts – Payroll Liabilities and Payroll Expenses.  When you run a Balance Sheet or a Profit & Loss Report (or look at your Chart of Accounts listing) you only see the totals with no details and have to run further reports to find the individual amounts that make up the totals.  I find this to be problematic.

This article will show you how to add sub-accounts to the standard Payroll Liabilities account so that you can quickly and easily “see” the individual amounts for each payroll liability and how to edit your existing payroll items to accurately point to these new accounts.  A little extra work up front will provide you with a very function Payroll Liabilities section on your Chart of Accounts.

Step 1 – Determine the required Payroll Liability Sub-Accounts

Open your Payroll Items List {Lists menu -> Payroll Items} and scroll to the bottom, and pay close attention to the items that are currently pointing to or assigned to Payroll Liabilities.

Right click on the image to enlarge it

NOTE: You may want to customize the columns that are displayed in this list.  To do so, right-click the Liability Account heading -> choose customize columns -> from the available columns list click on Expense Account -> the Add button -> Liability Account -> the Add button -> Payable To -> and the Add button.  Click Ok.  This will provide you a more detailed and functional Payroll Item List to work with, as shown in the screenshot above.

From this list, we will determine what we need to add to our Chart of Accounts to make it more functional.  We will be adding sub-accounts for:

• Federal Unemployment {FUTA}
• Federal Withholding {FWH}
• Medicare {M-CARE}
• Social Security {FICA}
• State Withholding {STWH}
• State Disability {SDI}
• State Unemployment {SUI}
• Employee Training Tax (ESD}

Step 2 – Create Payroll Liability Sub-Accounts

Once you have the list of items that we will be adding as sub-accounts to the main Payroll Liabilities account; go to your Chart of Accounts {Lists menu -> Chart of Accounts}.

• Click the Account button {at the lower left corner of this window} -> choose New -> click the radio button next to Other Account Types and from the drop down menu choose Other Current Liability -> click the Continue button

Right click on the image to elarge it.

• In the Account Name, type in Federal Unemployment -> click the box next to Subaccount of and then from the drop down menu choose Payroll Liabilities.  Add other details as required or necessary.

Right click on the image to enlarge it

• Click the Save & New button to create the other items from your list.

NOTE:  Create a single account for Social Security and Medicare.

Step 3 – Edit existing payroll items mapping them to the new accounts

Going back to your Payroll Item List, edit each item assigning them to the newly created sub-accounts.

• Click on the Federal Unemployment payroll item -> click the Payroll Item button -> choose Edit -> click the Next button -> from the Liability Account drop down menu -> choose Federal Unemployment

Right click on the image to enlarge it

• Click the Next button until you get to the last window then select Finish.

NOTE: You may receive an Update transactions with new account window, here you can choose to update all existing transactions OR update transactions starting on a specific date.  My personal preference would be to update all existing transactions – you may want to consult your accountant about this.

Right click on the image to enlarge it.

When you have finished mapping the items to your new sub-accounts; simply opening and viewing your Chart of Accounts will provide you with a detailed account of each of your payroll liabilities, as well as the grand total.

On Wednesday, we’ll provide instructions for making the Payroll Expenses section of your Chart of Accounts provide more information on Profit & Loss Reports.