Quick Search Results

    Not finding your answer?

    View More Results
    Top

    Tracking payroll expenses by class, department, or location

    Article ID: 1000540

    Overview

    You can track payroll expenses by department or location using classes.

    Expected Outcome

    You will be able to produce class tracking reports including payroll.

    Assumptions

    You have an active payroll subscription and would like to class your employees' pay.

    Details

    Why Use Class Tracking

    In QuickBooks, assigning classes allows you to classify your transactions. You can use QuickBooks classes to classify your income and expenses by department, business office or location, separate properties you own, or any other meaningful breakdown of the business you do. For example, if you have a restaurant with three locations, you might create an Uptown, a Midtown, and a Downtown class for tracking income and expenses by location. A farmer might create a class for each enterprise, e.g., "Corn," "Hogs," and "Soybeans." At the end of an accounting period, you can create separate reports for each restaurant location. Likewise, the farmer can create separate reports for each farm enterprise. The classes you create appear on your Class list. The "Use class tracking" preference in the Accounting Preferences window adds a Class field to windows where you enter invoices, checks, bills, credit card charges, or other transactions.

    Consider the following when setting up class tracking:

    • Set up classes on the basis of the type of reporting that you want to do, and consider how you want to see your business segmented on reports.
    • Set up a class such as "other" that you can use to deliberately classify transactions that do not fit into any specific class that you have defined.
    • Do not use classes for two different purposes. E.g., do not create classes for tracking office locations in addition to tracking partners.
    • Identify both income and expenses for each class you set up.
    • Consistently enter the class information on your forms and registers to be sure that this information is valid and useful.

    Set preferences for tracking payroll using classes.

    1. From the QuickBooks Edit menu, choose Preferences.
    2. Click the Accounting icon, and then click the Company Preferences tab.
    3. Select Use class tracking and click OK.
    4. If prompted, click Yes to save changes.
    5. In the Preferences window, click the Payroll & Employees icon.
    6. Be sure that Full payroll is selected in the QuickBooks Payroll Features section.
    7. Select Job Costing, Class and Item tracking for paycheck expenses.
    8. If you want to assign one class to an entire paycheck, select Entire paycheck.
    9. If you want to assign one class to each item on the paycheck, select Earnings item.
    10. Click OK.

    If you selected the Earnings Item payroll preference (so you can assign one class for each earnings item on a paycheck), the Preview Paycheck window will include a Class column. You can now assign a different class to each earnings item. If you selected the Entire paycheck payroll preference, your payroll expenses will be prorated by class on reports.

    To identify how payroll expenses are distributed to each class, use the formula:

    [Rate X # of hours]/ Total wages = percentage/rate of the proration for each Class

    Once you have chosen to report on payroll taxes by job and class, reports of expenses by job and class break down company-paid payroll expenses not only for salaries and hourly wages, but also for company-paid payroll taxes.

    Marking Track Expenses By Job will not add a class column to the payroll items listed under Other Payroll Items on a paycheck. Instead, in reports, these items are divided based on the division of the earnings items on the paycheck.

    Generate a Payroll Summary report broken down by class to show the company paid liabilities and the gross pay.

    1. From the QuickBooks Reports menu, choose Employees & Payroll Reports, and then choose Payroll Summary.
    2. Click Modify Report on the report button bar.
    3. From the Column drop-down list, select Class.
    4. Make any other changes to the report, and then click OK.

    2 comments

    Ben Eggertsen4/10/2013

    I am getting conflicting information from QuickBooks.

    We use QuickBooks payroll. I want to report payroll by department. I thought I could use class to accomplish this goal. I have been told that it is not possible for QuickBooks Online.

    Can QuickBooks Pro or Premier report payroll by department?

    It is mission critical for us that our accounting software can do this.

    Reply

    Peter5/24/2013

    12

    Hello Ben,

    QuickBooks Online Payroll (QBOP) does not provide full-fledged departmental reporting capabilities at this time. QBOP does allow you to assign employees to classes, and to generate a report that lists wages by class. However, this feature is primarily intended for workers' compensation reports. If you need complete departmental reporting, I'd recommend that you consider one of our desktop QuickBooks payroll products.

    Thank you for your interest in QBOP.

    Comments can not be added at this time.

    Top Answers

    Resources

    Most Used Forms

    Find and download individual and federal forms required for your business.

    Payroll Tax Support

    Stay in compliance, ensure you're up to date on all necessary tax agency information from Federal to State agency

    ViewMyPaycheck

    Give employees 24/7 access to payroll information they need.