Viewing Sales by Brand and Item
"What did we actually sell this month?" is the question this report answers. It takes every sale in a date range and adds it up three ways: by product type (cigars, accessories, drinks and so on), by brand, and by individual item. For each one you see how many you sold, what they cost you, what they brought in, and the profit in between.
Use it when you're deciding what to reorder, which brands are earning their shelf space, or which items haven't moved at all.
Finding It
- From the main screen, tap Dashboard
- Click the Reporting tab on the left, then click the Items button across the top of the report area
- Click the View Sales card (Can't find it? Type "view sales" in the search box at the top right.)
The same report is also on the Sales button of the Reporting tab, as View Sales (Detail). Both cards open exactly the same window, so use whichever you come across first.
The window that opens is titled Sales by Product Type, Item and Brand.
There's a third way in: in View Sales by Product Type (also on the Reporting tab's Sales button), pick a product type and click View Sales for Selected Product Type. This opens the same report already set to that product type and to the dates you were looking at.
Choosing What to Look At
Everything you need sits across the top of the window. Change any of it and the report reloads on its own.
Start and End — the date range. It opens on the first day of the current month through right now. Click Adjust next to either date to change it. If the start ends up after the end, TORO tells you "Start Date must be before End Date." and doesn't reload.
Product Type Filter — narrows the report to one product type. All Product Types shows everything.
Company Filter — narrows the report to the brands you buy from one vendor company. ALL COMPANIES shows everything. This relies on your brands being linked to their vendor, so a brand that isn't linked won't show up under any company.
Rank by Field — Number Sold (the starting choice), Cost, Retail or Profit. This sets the order items are ranked in on the By Item tab.
Sales to Retrieve — Retail (your counter sales), Wholesale (wholesale invoices) or Both. It starts on Both, so if you run a wholesale side and only want your shop's own sales, switch it to Retail.
Show QOH — adds your current quantity on hand to the By Item tab. More on that below.
Show Active Only — leaves out sales of items you've since made inactive.
The Three Tabs
The report opens on By Product Type. Click By Brand or By Item to see the same sales broken down another way. On every tab, the first row is the Total for everything shown.
By Product Type
One row per product type, with the most detail of the three tabs:
- Items Sold Count — how many you sold. Cigars are counted one by one, so a box of 20 counts as 20.
- Cost, Retail and Profit — what those items cost you, what they sold for, and the difference.
- Profit Margin — profit as a share of the selling price.
- Profit Percentage — profit as a share of the cost (your markup).
- Average Cost, Average Retail, Average Profit — the same figures worked out per single item sold.
- Burn Rate For Period — how many you sold per day, on average, across the date range.
The yellow tip on this tab says it too: double-click a product type and TORO jumps to the By Item tab, filtered to that type.
One thing that surprises people: the Product Type Filter doesn't shrink this tab. It still lists every product type so you keep the big picture, and the filter applies to the By Brand and By Item tabs. The Company Filter and the other choices do apply here.
By Brand
One row per brand: Brand Name, Items Sold Count, Cost, Retail and Profit. This is the quickest way to see which brands carry your humidor.
By Item
One row per item: Item Active, Item Ranking, Brand Name, Item Name, Items Sold Count, Cost, Retail and Profit. Item Ranking is the item's place in the order you picked under Rank by Field, so with Number Sold chosen, ranking 1 is your best seller by count.
You can click any column heading to sort by it.
How the Numbers Are Worked Out
- Retail is what the items actually sold for, after any discounts and before sales tax.
- Cost, for your counter sales, uses each item's cost as it is set in TORO right now — not what it cost on the day you sold it. If a cost has changed since, older date ranges are worked out at the new cost. For wholesale sales, the cost recorded on the wholesale invoice is used.
- Profit is simply Retail minus Cost.
- Profit Margin and Profit Percentage count an item's special tax (such as an OTP tax) as part of what it cost you. The Profit column does not.
- Gift card sales are left out entirely, since they aren't merchandise.
- If you see NaN or ∞% in a percentage column, there was nothing to divide by — usually a row with no cost or no retail at all, such as a free item. It isn't an error in your data.
Items That Didn't Sell
Along the bottom is a wide button that reads View [number] Active Items with No Sales. It counts your active items that don't appear on the By Item tab for this date range — the stock that's just sitting there.
Click it, answer Yes to "Load [number] Items with No Sales?", and TORO opens a list of those items.
The count follows the Product Type Filter, but it checks every vendor's items against what's on the By Item tab. So with a company picked, every other vendor's items are counted as having no sales, even ones that sold. Sales to Retrieve works the same way: on Retail or Wholesale, an item that only sold the other way is counted too. For a true list of items that didn't sell, set Company Filter to ALL COMPANIES and Sales to Retrieve to Both.
Setting a Target Quantity on Hand
Tick Show QOH and the By Item tab gains three columns:
- QOH — what you have on hand right now
- Target QOH — the quantity you'd like to keep on hand for that item, if you've set one
- Overstocked — your quantity on hand minus the target. A positive number means you're over the target, a negative one means you're under it. It's blank for items with no target.
With Show QOH ticked you can also select several items at once, and a Set Target QOH button appears under the list. Select the items, click it, and type the quantity when TORO asks "What is the target QOH?". Clear Target QOH, next to it, removes the target from the selected items after asking you to confirm. If you click either button with nothing selected, TORO tells you "Must select at least one row."
Both buttons change the items themselves, not just this report, and they don't touch your actual inventory counts. There's no undo: clearing a target doesn't bring back the old number, so you'd set it again by hand. After either change TORO asks whether to reload the table so you can see the new targets.
Exporting the Report
Right-click any row in any of the three tabs and choose Export table as CSV... to open it in a spreadsheet, or Export table as HTML... for a page you can print or email. Whatever tab you right-clicked is what gets exported, with your current filters applied.
On the By Item tab the same right-click menu also offers View Item Details for that item, which is handy when something in the list needs a closer look.
Common Questions
Why doesn't this match my daily report? This report only counts merchandise: it leaves out gift cards, and it shows what items sold for before sales tax. With Sales to Retrieve on Both it also includes your wholesale invoices. Switch to Retail if you only want your counter sales.
My profit looks wrong for last year. For counter sales the cost comes from each item's cost as it stands today. If your costs went up since then, the report shows last year's sales at this year's cost.
I picked a product type but the first tab didn't change. That's by design. The Product Type Filter narrows the By Brand and By Item tabs; By Product Type always shows every type.
A brand is missing when I filter by company. The company filter only finds brands that are linked to that vendor. Link the brand and it will show up.