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 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 Parts 1 – 8 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.
- Part 8 – we talked 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.
In this article, we’ll talk about using Multiple Currencies and it’s effect on the Balance Sheet by Class Report.
I’ll be honest here and say that I’m not familiar at all with using Multiple Currencies in QuickBooks; nor do I have any customers/clients who use the Multicurrency feature. The only thing that I do know about Multicurrency in QuickBooks is that once you turn it on —- you can’t turn it off; and that was enough for me!
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 use multicurrency in QuickBooks.
Apparently, when you have enabled Multiple Currencies in QuickBooks, any transaction that you enter create unbalanced balanced clases because of how QuickBooks actually calculates the balanced for the report and the Balance Sheet by Class report shows exchange rate gains and losses in the Unclassified column of the report.
 |
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 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 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 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 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 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 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 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 2011 New & Improved Purchase Order Reporting
Intuit has finally fixed the Purchase Order Reporting to ACCURATELY display open balances, without a lot of additional manipulation by the user. My overall opinion is th...QuickBooks 2011 – New Sales by Ship To Address Report
Retailers could modify this report and filter it by specific item to see which item is popular in which Cities and States. This information could then be used to determi...QuickBooks 2011 Available Beginning September 27, 2010
The news we have all been waiting for - QuickBooks 2011 announced. According to a press release from Inuit, QuickBooks 2011 will be available to purchase beginning on ...Payroll Tip – Report for hours worked before creating paychecks
This payroll tip discusses how to create reports for hours worked before creating paychecks-ensure employees are paid correctly & your job costing is accurate....FREE QuickBooks 2011 Contest – Enter to Win
FREE QuickBooks 2011 Contest - Enter to Win. Ruth Perryman, Michelle Long, Laura Madeira & Bonnie Nagayama have teamed up with Intuit to offer FREE QuickBooks software....QuickBooks Tip – Merging Duplicate Items and/or Accounts
It is a common occurrence over time, especially if you have had numerous bookkeepers; to discover that you have duplicate items in your QuickBooks Item List or accounts i...
3 Responses to QuickBooks 2011 – New Balance Sheet by Class Report – Part 9
Leave a Reply
Pingback: QuickBooks 2011 - New Balance Sheet by Class Report - Part 10 | QuickBooks for Contractors blog
Thanks Mike, glad you like all these articles! I always review the new stuff in QuickBooks every year, our customers expect me to know everything
, but this is the first year that I’ve blogged about new features & functions extensively.
I agree, it’s not quite ready for prime time. But a lot of people are going to see that it’s available and want it; perhaps even mistakenly thinking that there aren’t any limitations.
I know that even if I wanted a Balance Sheet by Class for our business that I wouldn’t want to undertake all the steps involved.
Nancy, all these articles and research you have done are great. Usually, I have to do my own research and experimentation to figure it all out. Thanks for doing it for me!
I think the bottom line here is that the Balance Sheet by Class is not really ready for implementation, except in the simplest of scenarios. None of my clients would waste the time and money it would take to pay an accountant to enter all the journal entries required to get the report in balance. And frankly, I would be surprised if many accountants would even get it right without hours of work.
If a company just wants to see some of their fixed assets by class, great. Otherwise the complications with payroll, discounts, pre-payments (vendors & customers) liability checks, sales tax, etc etc, make the feature way more trouble than it is worth.
Just my opinion! Hope they improve it soon. In the meantime, I’m not telling my clients about it, because none of them have a scenario simple enough for it to be effective.