I appreciate the follow-up response, SyGy. Allow me to provide additional information to help ensure that Non-Specified columns to your Balance Sheet reports are accurately classified.
With the insights shared by my colleague above, the reporting behavior when running Balance Sheet by Class data is working as designed, depending on the details linked to each transaction and not from the headers. However, there are exemptions to this, for example, Accounts Receivable, and Accounts Payable. These accounts aren't sorted by class assigned to them, which is why they are tagged as Not Specified.
I'm sharing this reference for more detailed info on this scenario: Run a balance sheet by class or location in QuickBooks Online.
In addition to this, exporting the report to an Excel file enables you to modify the data the way you want it to be. You may consider this option as a workaround.
You'll also want to change the Class settings to One to each row in transactions to assign one class by line item. This gives you more in-depth reporting by class at the product and service level and will be visible when running the Balance Sheet report. However, you'll need to go back to the existing transactions and assign classes since the effect is not retroactive. To do this:
- In your QBO account, go to the Gear icon and select Accounts and Settings.
- Choose the Advanced tab and click on the Categories section.
- Under Assign classes in Track Classes, select One to each row in transactions. Then, click Save and Done.
Moreover, I'll include this guide to help you get the most out of your financial data: Customize reports in QuickBooks Online.
I'll always be around in this thread if there's anything else you need further assistance with when managing classes in your file. Feel free to let me know in the comments below. Keep safe and have a good one!
