Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello
I am trying to create a summary report that shows me the total amount paid to each vendor for only a certain selection of customers. I've tried filtering by customer both a 1099 report and an Expenses By Vendor report, but it doesn't work correctly. I assume because both vendors and customers are "Names"?
My ultimate goal is to see how much I have paid to each vendor, separated by the state of the customer. However there's no place to assign a state to a customer, so I've been trying to just manually select the customers which are in VA (for example). I've also tried adding a 'Virginia' Customer Type and filtering by that, but it also does not work, it just makes blank reports.
Again, to be clear: I want a report with Vendors as rows and Customer State as columns, OR a report with Vendors as rows and just a Total column and then I've filtered by my own custom selection of customers. Is this possible?
Sorry if this doesn't make sense, I'm not really familiar with QB or the terminology yet.
Solved! Go to Solution.
I'm glad you reached out to us today, JABu.
Enabling the Class feature lets your track transactions by location or any other meaningful breakdown of your business. You can utilize the Class Tracking functionality to organize your customer/state.
Then, go to the List menu and choose Class Lists to set up and add classes(states) in QuickBooks.
Once done, you already have the designated Class field when creating transactions. Use that field when assigning customer/state on the vendor transactions.
Lastly, let's run and customize the Custom Transaction Detail report. This allows you to add the class column:
That's it. Let me know the results or if you have other report questions. I'm just a post away.
I'm glad you reached out to us today, JABu.
Enabling the Class feature lets your track transactions by location or any other meaningful breakdown of your business. You can utilize the Class Tracking functionality to organize your customer/state.
Then, go to the List menu and choose Class Lists to set up and add classes(states) in QuickBooks.
Once done, you already have the designated Class field when creating transactions. Use that field when assigning customer/state on the vendor transactions.
Lastly, let's run and customize the Custom Transaction Detail report. This allows you to add the class column:
That's it. Let me know the results or if you have other report questions. I'm just a post away.
Hello there, JABu.
Adding a Class to previous transactions in bulk isn't available. You'll need to manually add it to each of the transactions.
Regarding your second question, the class field will be automatically filled in if you've assigned a class to the specific customer or vendor. This way, you don't have to manually enter it for each transaction moving forward.
Here are the steps:
I'd be right here anytime in case you have further questions. Have a good one!
Hello again, @JABu.
The reporting feature in QuickBooks is dependent on the information entered on the fields. A report is a set of instructions that the program uses to display data from your company file.
I understand that going through your transactions will consume too much of your time.
Another suggestion is to export the report to Excel. From there, you can create instructions/rules that will detect and assign a class to old transactions. If you need further help, you can also reach out to their Customer Care Team.
For future reference, I'm adding the Customize reports in QuickBooks Desktop article.
That should do it, @JABu. Let me know how it goes or if there's anything else I can help about reports. I'm just a comment away. Take care always!
Hello there, JABu.
It's great to hear that you're finally able to run your preferred report in QuickBooks Desktop. I appreciate you for sharing the steps you've taken to get this done. This will benefit other users who may want to achieve the same thing.
In behalf of my colleagues, I'd like to provide these great resources that you can use for future reference:
Know that you're always welcome to come an visit us again if you have other concerns. I'd be more than happy to help.
Hi Joyce
I know it's been a bit, but I'm finally trying to get our Class system set up correctly to have them pre-filled when I assign a Customer to a transaction. However, the Additional Info section under a Customer doesn't let me pick a Class. When I go to Preferences > Accounting > Company > Class, it doesn't have the option to "Assign classes to...". The only listed option is "Prompt to assign classes". This is in QB Desktop Contractor 2020.
Hello again, JABu.
A data integrity issue could be the reason why you're missing the Assign classes option. In this case, let's run the Verify Rebuild Data tool that helps identify and repairs data issues within your company file. Here's what you'll need to do:
For more details about the Verify/Rebuild process, check this article: Verify and Rebuild Data in QuickBooks Desktop.
Once done, try to set up class tracking again, and check to see if everything is working now.
You'll also want to visit this link for more troubleshooting steps: Fix data damage on your QuickBooks Desktop company file.
Please let me know how things go on your end. I want to ensure this gets resolve for you. Take care.
There were no data integrity issues detected, so nothing has changed and the issue persists.
Hello again, @JABu. Thanks for keeping us updated.
If you're using QuickBooks Desktop Pro or Premier version, the Assign classes to option is unavailable. It is only available on the Enterprise version.
To have this feature, you may wish to consider upgrading your QuickBooks Desktop version. See this link for more information: Upgrade to newer versions of QuickBooks Desktop Pro Plus, Premier Plus, or Enterprise.
To learn more about how the Class tracking feature works, take a look at this article: Set up and use class tracking in QuickBooks Desktop.
If you have additional questions, let me know by adding a comment below. I'm always here to help. Have a good one!
So does that mean there's no way for me to quickly/automatically assign a Class to every transaction involving a given Customer then?
So does that mean there is no way for me to quickly/automatically assign a Class to every transaction for a given Customer then?
Thanks for getting back here, @JABu.
As per my colleague, MirriamM discussed above, the option Assign classes to is only available for the QuickBooks Desktop Enterprise version. Since you're using QB Desktop Contractor 2020, you can only see the Prompt to assign classes option under the Class field. That being said, setting up a default class for a customer is unavailable.
However, you can manually select the correct class for your customer's transactions. Just simply click the Class dropdown arrow. Here's how:
For your reference, please see this article: Set up and use class tracking in QuickBooks Desktop.
In case you'll need to run a report that will show classes, check out this link for the detailed steps: Filter, sort, or total reports by Class.
Don't hesitate to post again here if you need further assistance in adding classes to your customer's transactions. I'm always here to help. Keep safe.
So the answer is no, then. I knew all that already. If there's no way to pre-fill Class then it's not worth the effort of manually setting it for every single transaction as I enter it. I guess I'll stick to the whole rigmarole of manually filtering reports and exporting to Excel for the infrequent times I need to filter data like this.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.