The Balance Sheet by Class Report is new in QuickBooks 2011 and 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 the limitations of the New Balance Sheet by Class Report available in QuickBooks 2011 which may make using this report unsuitable for some users.
In 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.
In this article, we’ll discuss another one of the limitations that I was disappointed in – that the report could not automatically allocate payroll liability payments to classes.
The Balance Sheet by Class report, when created in either cash or accrual basis, doesn’t automatically allocate payroll liability payment to classes; this causes amounts to show in the unclassified column on the report.
The resolution in the QuickBooks Help file provides pretty clear instruction on how you, as the QuickBooks user or accounting professional, can manually allocate classes to payroll liability checks when you create them. However, you must follow the instructions carefully in order for your Balance Sheet by Class report to be accurate.
If you assigned all of your employees to a single class (Labor), the task is not difficult. However, if you assigned different employees to different classes (Service and Contracts as we discussed in Payroll allocated to multiple classes), then the task becomes more detailed and difficult.
When you have assigned different classes to employees, BEFORE you actually create the payroll liability check, run the Balance Sheet by Class Report – dating it for the last day of the period for which you will be paying liabilities and print it out as you’ll be referring to the amounts that you owe for each class.
NOTE: While becoming familiar with this procedure I discovered that in order to EASILY determine the employee and employer dollar amounts for Social Security and Medicare by class; that you need to have separate accounts for them on your chart of accounts.
Right click on the image to enlarge it.
Next, you’ll go to the Payroll Center (Employees Menu -> Payroll Center OR from the Home Page click the Pay Liabilities icon).
In the Pay Scheduled Liabilities section, select the payroll liabilities that you want to pay.
Click View/Pay.
In the Liability Payment window, review the payment and add line items so that you have one line item per class for each class that you assigned employees to, and using the information from the Balance Sheet by Class report, enter the appropriate amounts for each liability for each individual class.
Right click on the image to enlarge it.
If you have only assigned a single class to all of your employees (Labor) in the Liability Payment window, in the Class column, select Labor for each line item.
Companies that use this report will have to implement strict procedures to ensure the accuracy of the final report and accounting professionals and QuickBooks trainers will need to be aware of these guidelines.
 |
Request 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. |
Related Posts
QuickBooks 2011 – New Balance Sheet by Class Report – Part 8
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 Profi...QuickBooks 2011 – New Balance Sheet by Class Report – Part 3
In this article, we'll discuss one of the limitations of the Balance Sheet by Class Report that I was most disappointed in - and that is being unable to assign multiple c...QuickBooks 2011 – New Balance Sheet by Class Report – Part 6
There is some good news about Receiving Customer Prepayments, and that is -- this problem corrects itself; when you create and apply an invoice to the payment at a later ...QuickBooks 2011 – New Balance Sheet by Class Report – Part 5
A Sales Tax Liability check, causes the amount of the payment to display in the Unclassified column of the Balance Sheet by Class Report - a Journal Entry is required to ...QuickBooks 2011 – New Balance Sheet by Class Report – Part 10
Currently there is a "bug" that effects the Profit & Loss by Class report when it displays the final vendor payments, which then also adversely affects the Balance Sheet ...QuickBooks 2011 – New Balance Sheet by Class Report – Part 11
Last installment of our 11-part series on the Balance Sheet by Class Report, we'll discuss how you cannot use the Funds Transfer window to transfer funds between classes ...QuickBooks 2011 – New Balance Sheet by Class Report – Part 9
The QuickBooks Help file says that the Balance Sheet by Class Report doesn't support multiple currencies, and that you shouldn't attempt to run or use this report if you ...QuickBooks 2011 – New Balance Sheet by Class Report – Part 2
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 re...QuickBooks 2011 – New Balance Sheet by Class Report – Part 1
A Balance Sheet by Class Report has been requested by many QuickBooks users and the accounting professionals, it is not without limitations and drawbacks, making this a r...QuickBooks Payroll Tip-Setting Up General Liability Insurance Tracking
QuickBooks Payroll, when properly set up, is capable of tracking and including the cost of your General Liability Insurance in job costing reports....QuickBooks Tip-Creating a Functional Payroll Liabilities Section
A QuickBooks Payroll Tip for creating a more functional Payroll Liabilities section on your Chart of Accounts in 3 Steps...How To Setup a Scheduled Payment for a Payroll Liability
Setting up Scheduled payments allows you to see all payroll related liability amounts that you owe for payroll taxes, health insurance, child support garnishments, etc. i...QuickBooks Creating a More Meaningful Payroll Expenses Section
QuickBooks, by default, offers a single account called Payroll Expenses in your Chart of Accounts and all of the pre-programmed Payroll Items for wages and taxes are assi...QuickBooks Payroll Tips – Getting Ready for W-2 Processing
A QuickBooks Payroll Subscription makes processing W-2's a piece of cake, however, there are still some things that you need to do to properly prepare for W-2 processing....QuickBooks 2011 – New Average Days to Pay Report
The Average Days to Pay report lists paid invoices and statement charges; grouped by customer and job, and the number of days that it took the customer to pay. I can see ...
2 Responses to QuickBooks 2011 – New Balance Sheet by Class Report – Part 4
Leave a Reply
Pingback: QuickBooks 2011 - New Balance Sheet by Class Report - Part 1 | QuickBooks for Contractors blog
Pingback: QuickBooks 2011 - New Balance Sheet by Class Report - Part 5 | QuickBooks for Contractors blog