cancel
Showing results for 
Search instead for 
Did you mean: 
AlcaeusF
Moderator

Balance sheet class analysis

Hello @pauch,

 

Thanks for posting in the Community. I'm here to provide information about reclassifying accounts.

 

Assigning classes to transactions only allow you to track account balances by department, business office, separate properties, etc. You can change or merge them since this information only helps track your company expenses.

 

Here's how you can merge them:

  1. Click the List tab at the top menu bar.
  2. Select Class List.
  3. Right-click class you want to merge.
  4. Edit the name (it should be the same to the name you want to be merged).
  5. Click OK.
  6. Click Yes.

I also recommend seeking an accountant's advice about when is the best time to reclassify classes in your company file.

 

Please don't hesitate to reach out you need further assistance. The Community will be around to help.

 

FL_Guru
Level 3

Balance sheet class analysis

Not just charities would find it useful!

kzuber
Level 1

Balance sheet class analysis

Hello, we are using QB Accountant, and we have the same issue in Balance Sheet by Class.  Then, how can we prepare Balance Sheet by Class?  Do we need to prepare it manually after downloading Transaction  Detail by Account to Excel?   We have 5 classes per each location/bank account.  Please help as soon as possible.  Thank you very much, and best regards,  KZ

Anonymous
Not applicable

Balance sheet class analysis

Hello kzuber,

 

Thanks for posting here in the Community.

 

As discussed in the previous conversation, being able to choose a class for balance sheet accounts isn't available in QuickBooks. These general transactions in the balance sheet accounts (example: loan liability account) will show under the Unclassified column in the Balance Sheet by Class report.

 

Please send us feedback about it by clicking on the Help menu and select Send Feedback Online.

 

In the meantime, you can export this report to Excel. Then, customize it from there to show the amounts in the correct class column. Here's how to pull up the report: 

  1. Click on Reports.
  2. Select Company & Financial.
  3. Choose Balance Sheet by Class.
  4. Click on Excel.

Do you need to prepare this after downloading the Transactions Detail by Account? It would depend. You can print both reports if you need them. 

 

If you have any questions, please let us know. Thanks! 

ekileen
Level 3

Balance sheet class analysis

Can you tell me where to find the Balance Sheet by Class report? I'm using Quickbooks Desktop Pro and can't find it.

Or is there a way to create it?

 

I have submitted this as a suggestion to Intuit. Profit & Loss is not the only report where classes come into play.

FritzF
Moderator

Balance sheet class analysis

Thanks for joining this conversation, @ekileen.

 

Allow me to chime in for a moment and share some information about the report that you'd like to pull up in QuickBooks Desktop (QBDT) Pro.

 

I appreciate you sending feedback to our Product Developers. At this time, the Balance Sheet by Class report is unavailable in QBDT Pro. You can pull up the Balance Sheet Detail report instead as a workaround. This will show a class column.

 

Here's how:

 

1. Go to Reports menu at the top.

2. Pick Company & Financial and Balance Sheet Detail in the drop-down.

 

47.PNG

 

Just in case, check out this article for future reference: Customize company and financial reports.

 

This should answer your concern for today. Please let me know how it goes or if I can be of additional assistance. I'm always here if you have any follow-up questions. Take care and have a good one!

Anonymous
Not applicable

Balance sheet class analysis

Would you care to share your post again? I tried to click the link but it didn’t work. 

Angelyn_T
QuickBooks Team

Balance sheet class analysis

Hello there, @Anonymous.

 

I'm here to help share additional information about running reports in QuickBooks Desktop (QBDT).

 

For me to help give you the right amount of information, may I ask if you're also trying to run the Balance Sheet by Class report in QBDT Pro?

 

As mentioned by my colleague FritzF, in the meantime, the Balance Sheet by Class report is unavailable in QBDT Pro. However, you may pull up the Balance Sheet Detail report and add the Class column.c7 pro and es.PNG

 

To add the Class column:

 

  1. Click on Customize Report on the report's page.
  2. Look for Class under the Display column.
  3. Put a check-mark on Class.
  4. Click OK.c7 report.PNG

You can also read this article to learn more about reports in QBDT: Understand reports.

 

Please let me know if you're referring to something else and if you have any other concerns about reports in QBDT. I'm always here to help you!

Gary999
Level 2

Balance sheet class analysis

Hello QBTeach,

When you say you attach diagrams, was that writing to the person directly? I do not see how to view them.  Thank you.

shannaswood
Level 1

Balance sheet class analysis

I use the class codes, I have 9 locations, when I run a BS, all the checking accounts show up but when I run one class, my bank accounts do not show up?

 

Please advise

rsturgis
Level 2

Balance sheet class analysis

I'm managing a Non-profit client who has multiple "Funds" (basically cost centers for BS and P&L which must be recorded separately per governing documents); but the CLASSES function in QB Online DOES NOT DO THIS!! It will track the operating activity, great. But when you need to run a Balance Sheet and there is a column that says "NOT SPECIFIED" which contains the BS piece of every transaction for all 8 Funds there is no other solution than exporting to excel and going line by line to create my BS manually.  I don't care about bills, bill payment, invoice, checks, deposits and every other window... How did the dev's at Intuit not communicate with actual accountants on this?? I cannot run a Balance Sheet for a client in QB; and trying to explain to them why is laughable. I told them to leave QB and never go back... I really hope someone at QB is looking into this issue. I'm trying Departments now but like everything else it's clunky and not made to get accountants the information they need, but rather more user friendly for clients. But hey, the buttons look super cool!! 

rsturgis
Level 2

Balance sheet class analysis

I've been managing a Non-profit client who has multiple "Funds" for 5-6 years now and this issue alone adds about 100 extra hours to the audit (basically cost centers per governing documents and Assets must = L+E in each one). In QB Online the CLASSES function DOES NOT DO THIS. It will track the operating activity- great. But when you need to run a Balance Sheet and there is a column that says "NOT SPECIFIED" which contains the BS piece of every transaction for all 8 Funds there is no other solution than exporting to excel and going line by line to create my BS manually.  I don't care about bills, bill payment, invoice, checks, deposits and every other window... How did the dev's at Intuit not communicate with actual accountants on this?? I cannot run a Balance Sheet for a client in QB; and trying to explain to them why is laughable. I told them to leave QB and never go back... I really hope someone at QB is looking into this issue. I'm trying Departments this year, but like everything else it's clunky and not made to get accountants the information they need, but rather more user friendly for clients. But hey, the buttons look super cool!! 

Jen_D
Moderator

Balance sheet class analysis

Hello there, rsturgis.

 

I can see that you have posted the same topic twice. Here is the link to which one of my colleagues has provided an answer for you: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-can-i-add-different-bran...

 

To have a streamlined conversation, I recommend using that thread for your replies moving forward.

 

Thanks for visiting us today. Come back any time or mention me on your posts if you have other concerns with Quickbooks.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us