How do I track sales by department or product category?
In QuickBooks Online, you have two main options for tracking sales by department or product category: classes and products/services items. Both work, but they serve slightly different purposes.
Classes let you tag any transaction with a department label. You create a class for each department you want to track (apparel, accessories, home goods, or whatever makes sense for your business) and assign it when recording sales. This approach works well when you want to see a full profit and loss statement filtered by department, including both revenue and the expenses associated with each area.
Products and services items work if you’re already entering line-item detail on invoices or sales receipts. QuickBooks lets you assign categories to group these items together. When you run sales reports, you can see totals by category without needing to use classes at all. This approach fits businesses that already track what they sell at the item level.
For retail shops using a point of sale system, the POS usually handles categorization automatically. Square, Shopify, Clover, and similar platforms sync sales into QuickBooks with product categories already tagged. The key is making sure your POS categories align with what you actually want to analyze in your financial reports. Misaligned categories mean extra cleanup work or reports that don’t tell you anything useful.
E-commerce businesses selling multiple product lines get real value from this breakdown. You can identify which product categories are growing, which have the best margins, and where your advertising dollars generate the most return. Without department-level tracking, you only see total revenue. That number tells you the business is making sales but not which parts of the business deserve more attention.
The setup matters more than the ongoing work. Get your classes or categories configured correctly from the start and make sure everyone entering transactions codes them consistently. If sales get dumped into generic buckets or left unassigned, the reports become useless.
Start simple. Pick the three to six major departments you actually want to analyze and stick with those. You can always add sub-categories later if you need more granularity. Too many categories from the start creates confusion and increases coding errors.
If your books already have months of uncategorized sales, a Scottsdale bookkeeper can often go back and recategorize historical transactions. It takes some effort but gives you comparison data so you can spot trends over time instead of starting from scratch.
The goal is making decisions based on what you see in the reports. Tracking by department only matters if you actually use the data to adjust inventory, pricing, or marketing. Otherwise it’s just extra work for numbers that sit in a report nobody reads.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I track inventory for my online store?
Connect your sales platforms to accounting software, track cost of goods sold accurately, and reconcile physical counts regularly. The challenge isn't the tracking itself but getting all systems to sync reliably.
Read answerHow do I prepare my retail store books for an audit?
Start with reconciled accounts, verified inventory records, and documentation for every transaction. Retail audits focus heavily on inventory valuation, cash handling, and sales tax compliance.
Read answerHow do I catch up on months of bookkeeping?
Gather all your statements, find the last month that reconciled correctly, and work forward from there. For each month, enter and categorize transactions, then reconcile every account before moving on. Chronological order matters because transactions often reference each other.
Read answerHow do I handle Arizona sales tax collection?
Register for a Transaction Privilege Tax license with the Arizona Department of Revenue, then collect at the combined state, county, and city rates based on where your business is located. Arizona uses an origin-based system, so your location determines which rates apply for most in-person sales.
Read answerHow often should I reconcile my e-commerce accounts?
Weekly reconciliation works best for most e-commerce businesses. The transaction volume and complexity of multiple platforms, payment processors, and fee structures make monthly reconciliation too risky. Problems are much harder to track down weeks after they happen.
Read answerHow do I account for Amazon reimbursements and lost inventory claims?
Record lost inventory as an adjustment reducing your inventory value and cost of goods sold impact. When Amazon reimburses you, record it as other income or offset it against the inventory loss depending on your preferred method.
Read answer