by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks 2011 – New Balance Sheet by Class Report – Part 1

Print Friendly, PDF & Email

The Balance Sheet by Class Report was first introduced with QuickBooks 2011, however, it is also available in QuickBooks 2012, 2013, and 2014; has specific requirements for handling many or our normal day-to-day transactions.  This will enable QuickBooks users to perform divisional accounting with QuickBooks, which was previously impossible or required significant duplication of effort.

QuickBooks 2011While this report has been one that has been requested by many QuickBooks users and the accounting professionals who support them, it is not without limitations and drawbacks, making this a report that will be able to be used by some companies and in some instances but not all.

QuickBooks calculates the class allocations for the report each time you run the report. Because of this, you must enter transactions in a very specific way. Follow these guidelines to ensure an accurate report. If you enter transactions differently, the report can produce unexpected results.

General Guidelines for Using the Balance Sheet by Class Report:

Verify/enable class tracking: From the QuickBooks Edit menu -> choose Preferences -> select Accounting -> and click on the Company Preferences tab.  Here you will want to make sure that the Use class tracking and Prompt to assign classes are checked – turned on.

enable class tracking in QuickBooks

Right click on the image to enlarge it

Set up/modify your Class List: From the Lists menu -> choose Classes, this displays a list of your current classes.

  • If you are new to QuickBooks this list might be empty and you will need to create your list of classes.
  • If you have been using QuickBooks for a long time there may be entries in the List window.

Be aware that transactions will have to be entered in a very specific manner and there are many data entry transactions that are not supported by the Balance Sheet by Class Report; which still cause additional data manipulation and work, for example:

  • Each transaction can only have a single class.

If you enter one class on every transaction, you’ll avoid most unexpected results.
There are a few transactions where you can’t enter a class. In these cases, QuickBooks assigns the class based on the “original” transaction in the work flow.
Important: although you can enter multiple classes on certain transaction, it is NOT recommended that you do so.  If you do enter multiple classes you will see unexpected results in the report.

  • Use standard work flows in QuickBooks

When entering transactions, use the windows and order suggested on the QuickBooks Home Page.  For example, standard workflows in QuickBooks include:

  • Enter Bills -> Pay Bills
  • Create Estimates -> Create Invoices -> Receive Payments -> Record Deposits
  • Enter Time -> Pay Employees -> Pay Liabilities -> Process Payroll Forms
quickbooks workflows

Right click on the image to enlarge it.

The biggest hurdle to using the Balance Sheet by Class Report is knowing which transactions are unsupported and learn how to solve the problems they produce.

View this video by Intuit demonstrating the Balance Sheet by Class Report in action.

Over the next few articles we’ll be discussing each of these unsupported transactions and how to work with them.

how to complete a certified payroll reportRequest our FREE 142-page “What’s New in QuickBooks 2011? eBook, by completing a simple request form.

This eBook will provide you with with all the information I’ve posted here in our blog, plus MORE!

Once you’ve completed our simple request form, you’ll have instant access to this 142-page .pdf eBook, designed to be duplex printed and put in a binder for future reference.

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker