by Sunburst Software Solutions, Inc.
Archives by Month

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

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.

In our previous article, QuickBooks 2011 – New Balance Sheet by Class Report – Part 1, we touched briefly on the fact 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.

The first limitation that we will discuss is Journal entries with “unbalanced” classes.  This limitation will affect CPA’s and other accounting professionals; and will require that they change the manner in which they create journal entries in client files – if they or their client chooses to use the Balance Sheet by Class Report.

An “unbalanced” journal entry occurs when you as the CPA or other accounting professional creates a journal entry that changes ONLY one side of the balance sheet for a specific class.  This creates an “unbalanced” balance sheet for the class.

For example,  your company purchased some computers, and you want to create a journal entry moving $500.00 worth of the computers from Class 2 to Class 1. You would normally create a journal entry as follows:

Computer & Office Equipment500.00Class 1
Computer & Office Equipment500.00Class 2
unbalanced journal entry

Right click on the image to enlarge it.

While the overall entry balances – meaning debits equals credits – from the “class” perspective the entry is NOT in balance because it increases assets in Class 1 while decreasing assets in Class 2.  When using classes in Journal entries Debits MUST equal credits for EACH class.

Procedure to “balance” the journal entry
You will need to make a journal entry where debits equal credits for each class.  This procedure will require accountants to perform additional data entry and change their journal entry procedures.

To do this, in your chart of accounts create an Other Expense type account called Other Expenses Clearing Account.  Once you have created the account you will then use it to balance the classes in the journal entry, like this:

Computer & Office Equipment500.00Class 1
Other Expenses Clearing Account500.00Class 1
Computer & Office Equipment500.00Class 2
Other Expenses Clearing Account500.00Class 2
balanced journal entry

Right click on the image to enlarge it.

Just remember, that the balance in the Other Expenses Clearing Account should ALWAYS be zero – debits and credits (or money in & money out amounts) are equal.

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

Our next article will discuss how to handle paychecks that are allocated to multiple classes.

NOTE: Most of the information contained in this article has been based on information found in the QuickBooks In-program help.  Intuit has done a very good job documenting the required procedures to successfully implement the Balance Sheet by Class Report.

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