by Sunburst Software Solutions, Inc.
Archives by Month

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

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. it gives users the option of selecting “Classes” (fund, location, profit center, or other category) as their column/class grouping.

Over the last several days, I’ve been discussing and sharing some information about how we all will need to change our data entry procedures in order to utilize the New Balance Sheet by Class Report available in QuickBooks 2011.

QuickBooks 2011In previous articles:

  • 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
  • QuickBooks 2011 – New Balance Sheet by Class Report – Part 2, we discussed how accounting professionals and end users would need to change their procedures when creating journal entries so that they were balanced
  • QuickBooks 2011 – New Balance Sheet by Class Report – Part 3, we discussed how users and accounting professionals would no longer be able to assign multiple classes to a single paycheck.
  • QuickBooks 2011 – New Balance Sheet by Class Report – Part 4, we discussed how you would need to classify Payroll Liability Payments in order for them to be appropriately recognized on the final report.

In this article, we’ll discuss how Sales Tax Liability Payments must be handled.

When you create an invoice, the sales tax that you owe will be accurately displayed on the Balance Sheet by Class report under the appropriate class heading.

Sales Tax Liability report

Right click on the image to enlarge it.

However, when you create the Sales Tax Liability check, the amount will appear in the Unclassified column of the Balance Sheet by Class Report in both cash and accrual based reports.

Paid sales tax liability

Right click on the image to enlarge it.

The reason that your Sales Tax liability payment is not accurately allocated is because there is not a Class column available in the Sales Tax check form.

sales tax liability check

Right click on the image to enlarge it.

The resolution in the QuickBooks Help file provides pretty clear instructions on how you, as the QuickBooks user or accounting professional, can manually allocate classes to the payment AFTER you create the Liability Check, through the use of a Journal Entry.  However, you must follow the instructions carefully in order for your Balance Sheet by Class report to be accurate.

In order to resolve this problem, you will need to create a journal entry to move the sales tax payment amount from unclassified to the correct class.  In order to accomplish this, you’ll need to:

Create a special “Clearing” Bank account in your Chart of Accounts, if you currently do not have one.

clearing bank account

Right click on the image to enlarge it.

Run a Balance Sheet by Class report as of the date that you will be paying the Sales Tax through, (1/31/2010) to determine the amount of Sales Tax that you owe for each class ($108.00 liability for the Installation class).

how much sales tax do i owe?

Right click on the image to enlarge it.

Make a journal entry to move the payment from the unclassified column to the appropriate class, using the Clearing Account.

create a journal entry

Right click on the image to enlarge it.

The Clearing Account should ALWAYS have a zero balance.

clearing accoung

Right click on the image to enlarge it.

While this work around will provide an accurate Balance Sheet by Class Report, procedures will need to be changed, documented, and followed carefully.  Business owners will need to inform the accounting professionals that they work with of these new procedures.

How will this procedure impact you, as a business owner or accounting professional?

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.

One Response to QuickBooks 2011 – New Balance Sheet by Class Report – Part 5

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