Our company is about to start using Quickbooks to keep track of some inventory and item sales. One of the things we need to do is run reports on certain types of item sales. These reports include sales of items from certain Manufacturers, and sales of items of a particular "type". For example, we want to run a quarterly report of items we sold that we come from manufacturers A, B, C, D, and E. We also need to run reports based on what type of item we sold. Items could by Type V, W, X, Y, or Z. (like Vacuums, Washing Machines, Xerox printers, Yogurt Makers, and Zebra Feed). Each of the manufacturers produces all 5 types of items, just different brands.
We will need to run a report of what items we sold in a quarter that are produced by manufacturer A, and who each item was sold to so we can send a dividend check to them. I'll also need a sales report of all the Vacuums we sold in a quarter so we can see how that department is doing. How do I set up all these items properly so that I can run these reports? I looked into Categories and Sub-Categories, but I couldn't find a way to generate Sales Reports by Category with Quickbooks Online. Can anyone help me out?