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 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.
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.
- 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.
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.
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.
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.
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).
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.
Right click on the image to enlarge it.
The Clearing Account should ALWAYS have a zero balance.
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?
 |
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 4
Another limitation of the Balance Sheet by Class report that I was disappointed in is that payroll liability payments to classes are not automatically allocated and must ...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 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 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 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 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 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 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 Tip-Chart of Accounts, Your CPA & Your Tax Return
Many companies fail to set up their charts of accounts correctly in QuickBooks. Over the years I have seen charts of accountants that look like a collage of accounts in ...QuickBooks Tip – The Chart of Accounts, What It Is & It’s Many Uses In Your Business
The Chart of Accounts in QuickBooks is the backbone for a company to track how much money it has, money it owes, money that is coming in, and money it is spending. The c...Payroll Tip: Union Benefits Calculated Against Hours NOT Wages
Union fringe benefits can be calculated in a number of ways; some are based on a percentage of gross wages while others are a fixed dollar amount per hours worked. Eithe...Working With Taxable & Non-taxable Items and Customers
QuickBooks can handle both taxable and non-taxable customers and sales using the same item list. Find out how by watching this YouTube video....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...QuickBooks Bookkeeping Tips – Why Do I Need to Keep “Books”?
The primary purpose of keeping books is to provide financial and management information in order for you to run your business, make sound business decisions, and to prepa...
One Response to QuickBooks 2011 – New Balance Sheet by Class Report – Part 5
Leave a Reply
Pingback: QuickBooks 2011 - New Balance Sheet by Class Report - Part 6 | QuickBooks for Contractors blog