I need to understand how to resolve existence of accounts showing up as unclassified in the balance sheet by class report. The church began using QB desktop in 2015 at which point all the previous reporting was somehow imported into the database. In 2015 a second major classification was created but multiple classes were created and used. This year, in order to streamline the reporting, classes, with their multiple sub classes, were combined resulting into there being only two. Through the method of running reports and identifying unclassified accounts transactions every transaction has had the class set as either "100" or "500".
The resultant Balance Sheet by Class report, with a single chart of accounts categorized in sections for each of the two "classes", yields 4 columns, Class 100, Class 500, Unclassified, and Total. There are accounts which show up as unclassified but when I search the transactions with filter date "All" I find transactions with the correct classes, the correct bank and account and no indication of why QB records it as unclassified. Any help is appreciated.
Thanks for posting your concern here in the Community. I've got some details about the Unclassified column on the report.
It's possible that you have bill payments, transfers, checks, or payroll transactions that involve class fields. They will reflect as "Unclassified". You should open each transaction and classify them.
I've attached some screenshots below for your reference.
Then, close the Transactions by Account window and refresh the Balance Sheet by class report for the changes to take effect.
For more in-depth information about classes, you can refer to this article: Filter, sort or total reports by Class.
Please know that all sales tax payments will automatically reflect as Unclassified in QuickBooks Desktop.
This should point you in the right direction. If you have further questions about the report, you can always leave a message below. I'll get them answered for you. Take care.
A brief follow on to my earlier comment concerning the apparent inability to generate a Balance Sheet by Class without having a column of Unclassified balances and transactions. Resulting from this I am not able to obtain a balanced balance sheet. Each of my classes have values in the Unbalanced Classes line for each of my two classes, and the column of Unclassified.
Ultimately I want to be able to balance the Unrestricted Net Assets generated by QB in end of year closeout and move the temporarily restricted (in this case everything in my class 500) portion into Temporarily restricted net assets. With these unclassifieds I can not move forward.
Thanks for getting back, Lou_E.
After reviewing each transaction with its correct class and the same thing happens, we can verify and rebuild data issues. It's possible that there's a damaged file that caused the discrepancies on the reports. The process will help us identify the cause and how to fix it.
If the column is still showing up after performing the troubleshooting steps, I suggest reaching out to our phone support agents to report this concern. Here's how:
Let me know how it goes. I'll be around to assist you!
Catherine_B (QuickBooks Team) posted a new reply in Reports and accounting on 04-17-2019 09:56 PM:
Thank you QuickBooks Team for your response. My delay in responding has been due to my continuing to dig deeper into the transactions that occurred prior to the adoption of QuickBooks accounting software. As said earlier, transactions from pre-QuickBooks were imported, and the issues were coming from those transactions not having classification applied. By using the Balance Sheet By Class to highlight the unclassified amounts I was able to year by year apply the classification to the Invoices, Bills, checks, Donations, transfers, etc., to each. That method, an extension of what I had done earlier got me to a core, early set of transactions which do not contain a place for Class to be included in their format.
General Ledger reporting for the period shows, in Accounts Receivable, what appears to be a type of Invoice, termed "Stmt Charge" against which "Payments" are matched to indicated fulfillment. Attempts to "drill down" to the format of the "Stmt Charge" are unsuccessful, leaving only the A/R register contents. So, neither the "Stmt Charge" nor the Payment have a place for Class to be entered. What I am left with is a $31,520 block of unclassified funds in a bank sub-account we no longer use (which in the mean time has been transferred to our current records, so no actual funds are involved) but which still shows up as unclassified and still throws the actual classes balances off. The attached file is a screen shot reflecting current status.
I have a couple of other items / mistakes showing up in later years but these will have different solutions.
Hello again, Lou_E,
I appreciate you getting back to us and providing detailed information.
Upon pulling up the Balance Sheet by Class report, it will show the balance sheet of each aspect of your business you track by class in QuickBooks. By default, it filters all transactions to show in the report which is the reason payments and statement charges show.
In the Transactions by Account report, payments can't be assigned by class. To have it not be showing in the report, then you can customize the report by Transaction Types to Sales Receipts and Invoices.
Here's what you'll need to do:
That's it! If you have further questions, please feel free to reach back out. I'm always here to answer it for you. Have a great day!
Thank you for your response.
I have used that method as described. In my case the transaction names are "Stmt Charge" instead of Invoice. The resultant "Stmt Charge" transactions do not have a place to define "Class".
I have given it some thought and think the only viable work around is to create parallel transactions of Invoice and Payment and to modify the originals contain a note regarding the initial value and reason for modification and to have "0" in their values, maintaining integrity of the transactions but providing the ability to capture the values in a classification.
I have been discussing the problem with the support group, but at this writing am not being provided a solution, but I think my work around is likely the best course.