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.
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.
- QuickBooks 2011 – New Balance Sheet by Class Report – Part 5, we discussed how you need to classify Sales Tax Liability Payments using a Journal Entry AFTER you actually make the payment.
In this article, we’ll discuss how you must handle Customer Prepayment when you record them using the Receive Payments option.
As a business owner who frequently receives customer prepayments on upcoming work, if you receive the prepayment from the customer using the Receive Payments window and selecting the option to Leave the credit to be used later, the prepayment amount will appear in the report in the “Unclassified” column.
Right click on the image to enlarge it.
The prepayment displays in the Unclassified column on the Balance Sheet by Class because you cannot enter a class in the Receive Payments window, and QuickBooks doesn’t have a prior transaction in the work flow to reference class information, because there isn’t any prior transactions in the work flow – such as an invoice, which could be used to obtain the class.
Right click on the image to enlarge it.
Unlike many of the other special requirements we’ve discussed, 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 date; because the invoice will have a class assigned to it.
Because this problem is self-correcting in the long run, many business owners may decide to not bother to correct the prepayments.
 |
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 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 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 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 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 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 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 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 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 ...QuickBooks Tip – An Audit Trail for Accounts Receivable
An "audit trail" for Accounts Receivable in QuickBooks is only one of the many complexities faced by government construction contractors. Learn various ways to get this ...QuickBooks Tip-Handling Employee Reimbursements for Expenses
Handling employee reimbursements for business related expenses, including mileage, should not be run through payroll in QuickBooks...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 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 ...QuickBooks for Contractors Tip – Basics of Progress Invoicing
Progress Invoicing is a standard feature of QuickBooks® Pro, Premier, and Enterprise editions; each of these versions also offer several options for invoicing as well. I...
3 Responses to QuickBooks 2011 – New Balance Sheet by Class Report – Part 6
Leave a Reply
Pingback: QuickBooks 2011 - New Balance Sheet by Class Report - Part 8 | QuickBooks for Contractors blog
Hi Penny
Thanks for stopping by and taking the time to leave a comment
I’m glad to hear that this series of articles have been helpful and even though I have been exploring this report, I still haven’t really figured out how it will impact the contractors that I deal with! I have several contractors who I think this report would really help out – the problem is that getting everything to balance is just so complex.
Thank you for this entire series of articles. I haven’t yet explored the implications of the Balance Sheet by Class. It’s a great feature, but I haven’t quite figured out how it applies to my current clients and this really helps.