by Sunburst Software Solutions, Inc.
Archives by Month

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

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

QuickBooks 2011Over 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 Balance Sheet by Class Report available in QuickBooks 2011; little did I realize when I started delving into the specifics of this report, that making it work would be so complex.

Previous QuickBooks 2011 – New Balance Sheet by Class Report  articles include:

  • 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
  • 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
  • Part 3, we discussed how users and accounting professionals would no longer be able to assign multiple classes to a single paycheck.
  • 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.
  • Part 5, we discussed how you need to classify Sales Tax Liability Payments using a Journal Entry AFTER you actually make the payment.
  • Part 6, we discussed the effect of handling customer prepayments when using the Receive Payments window.
  • Part 7 – we talk about invoices with multiple classes and how offering customer discounts in the Receive Payments window would cause discrepancies between the Profit & Loss by Class and the Balance Sheet by Class reports.

In this article, we’ll talk about how entering a single Vendor bill with multiple classes and taking advantage of vendor discounts in the Pay Bills window causes discrepancies between the Profit & Loss by Class and the Balance Sheet by Class reports and how to correct this.

Many business owners make it a policy to take advantage of any early payment discounts offered by their vendors; after all in this tough economy every penny counts!  However, paying and taking an early payment discount for a vendor bill that has multiple classes causes a difference in net income between the Balance Sheet by Class and the Profit & Loss by Class reports.

Vendor bill assigned to multiple=

Entering the bill itself doesn’t cause an issue on either report and is recorded correctly on both.

Profit & Loss by Class

Right click on the image to enlarge it.

Balance Sheet by Class

Right click on the image to enlarge it.

Paying the bill and actually taking the discount in the Pay Bills window causes the problem because the discount can only be assigned to a single class.

you can only assign a single class to a vendor discount

Right click on the image to enlarge it.

The solution to this discrepancy is to enter a bill for each class, even if the vendor sends you a single bill.

enter a single vendor bill for each class

Right click on the image to enlarge it.

That way when you pay each bill individually and take the discount, you can assign the discount to the appropriate class.

take the discount for each bill for correct class assignment

Right click on the image to enlarge it.

You can then pay the invoices using a single bill payment check IF you select each individual bill and apply the discount with the appropriate class assigned to it.

create a single bill payment check

Right click on the image to enlarge it.

When handled in this fashion, the Profit & Loss by Class accurately reflects your expense and the amount of the discount taken for each class.

vendor discount displays on profit & loss by class report

Right click on the image to enlarge it.

While Net Income is accurately reflected and classed on both the Profit & Loss by Class and the Balance Sheet by Class reports.

accurate reporting of net income

Right click on the image to enlarge it.

Accounts Payable personnel who work for business owner’s who make it a practice to take advantage of vendor early payment discounts will need to put in place new procedures and protocols that include the requirement of entering vendor bills that are internally assigned to different classes individually.  This will cause additional data entry time.

Additional procedures will include a method of tracking class that is assigned to each bill so that the same class can be assigned to the discount.

One way to track this is to enter the Class in the Memo field of each bill and then starting with a standard Unpaid Bills Detail report (Reports menu -> Vendors & Payables -> Unpaid Bills Detail) OR a Vendor Balance Detail (Reports menu -> Vendors & Payables -> Vendor Balance Detail).  Once either of these reports are displayed, click the Modify Report button and on the Display tab in the Columns section choose (check) Memo, Terms, and Class so that you have record of this information.

NOTE:  You must enter the Class information in the Memo field for each bill, because even though both of these reports offer to display Class information, the class information that is entered in the Bills windows does not flow through into these reports.  Personally, I feel this is a bug in Intuit’s code and will report it as such.

customize vendor reports to include class information

Right click on the image to enlarge it.

Once you are satisfied with the information being displayed in these reports, Memorize them so that you do not have to customize them each time you use them.

As with the other special requirements required to ensure the accuracy of the Balance Sheet by Class report, make sure that you inform your tax preparer so that any year end journal entries they make do not negatively effect the accuracy of this 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