What Your Inventory Is Worth
Where to find it: From the Dashboard, click Inventory on the left, then open Calculate Inventory Total. (Can't find it? Type "inventory total" in the search box at the top right.) The same tool also lives under Reports.
Every cigar, box, and accessory sitting on your shelves is money. The Calculate Inventory Total screen adds it all up for you and answers three simple questions:
- How much did I pay for everything I have right now? (your cost)
- How much will it ring up to if I sell it all? (your retail value)
- How much profit is sitting in the store? (the difference)
Think of it as a snapshot of your stock's worth as of this moment. It does not count your shelves for you — that's a different screen (see Taking Inventory). This one takes the quantities TORO already has on record and puts a dollar figure on them.
The Fastest Way to Get a Number
You do not need to set anything up. When the screen opens, TORO has already loaded every product type and every brand for you. So the quickest path is:
- Open Calculate Inventory Total.
- Click the big Calculate button on the right.
- Wait a few seconds while a progress bar fills.
That's it. The totals for your whole store appear on the right-hand side. Everything else on this screen is just there to help you narrow the number down when you want to — for example, "what's my Padron stock worth?" We'll cover that below.
One rule to remember: there must be at least one product type and at least one brand in the lists before you click Calculate. Since TORO fills both lists for you automatically, this only becomes a problem if you clicked Remove All. If you did, just click Reset to put everything back.
Reading the Results
After you click Calculate, a stack of large numbers appears on the right. Here is what each one means, in plain English:
Item Count — how many individual units are included in the total (sticks, boxes, accessories — every countable piece).
Wholesale Cost — the total you paid for all of it. This is your money tied up in stock. If someone asks "how much cash is sitting on my shelves?", this is the answer.
Wholesale Value — what that same stock would cost to buy today at current wholesale prices. Usually very close to Wholesale Cost; they only drift apart if a vendor changed their prices after you bought.
Retail Value — what everything would ring up to if you sold every last unit at the shelf price. This is always the biggest number.
Profit $ — the money you'd make: Retail Value minus your cost. This is the number most owners care about most.
Profit % (markup) — how many times over your cost you're selling. Buy for $5, sell for $10, that's 100%. This one can show a
*for some items — that's normal, and it's explained at the bottom of this article.Profit Margin — of each sale dollar, how much is profit. It never goes above 100%. (Margin and markup measure the same profit two different ways — both are correct.)
Special Taxes Total — the excise/tobacco taxes already baked into your costs, added up separately so you can see them.
The Item List
Below the totals is a table listing every item that went into the calculation, one row per item. Each row shows the same ideas as the big totals, but for that single product:
| Column | What it tells you |
|---|---|
| Product Type / Brand / Item Name | Which item the row is |
| QOH | Quantity On Hand — how many you have |
| Cost Per Item / Cost Total | What one costs you, and the cost of all of them |
| Special Tax Per Item / Total | Tobacco/excise tax portion |
| Retail Per Item / Total | Shelf price for one, and for all of them |
| Profit $ / Profit % / Profit Margin | The profit for that item, three ways |
To dig into any single product, click its row to highlight it, then click View Item at the bottom to open its full details.
Narrowing the Number Down
Most days you'll just want the whole-store total. But when you want to answer a more specific question — "what's my inventory worth in just the accessories category?" or "how much Arturo Fuente do I have?" — use the filter panels across the top. Change what you want, then click Calculate again to see the new total.
Which items to calculate?
The three round buttons (pick one) decide which items count:
- Active Items Only (the default — leave it here) — only the items you actually sell. This is the honest, useful number for almost everyone.
- Any Item With Pricing — includes items you've marked inactive, as long as they have a price.
- All (not recommended) — everything, even oddball entries with no pricing. The label says it plainly: not recommended. It can produce misleading totals.
Just below those are two checkboxes, both turned on by default, and you should usually leave them on:
- Ignore Items with Zero Inventory — skips anything you have none of. No point valuing an empty shelf.
- Ignore Items with Negative Inventory — skips items showing a negative count (a sign of a miscount). Including them would drag your totals the wrong way.
Which product types to include?
This box lists your categories (cigars, accessories, and so on) — all of them, to start. To value just part of the store, use the small buttons beside the list:
- Add — put a category back on the list.
- Remove — take the highlighted category off.
- Remove All — clear the list (you'll then add back only what you want).
- Reset — start over with every category loaded again.
Good to know: whenever you change the product types, TORO automatically refreshes the brands list to match. That's expected — it's keeping the two lists in sync.
Which brands to include?
Same idea, one level finer — the actual brands. Add gives you two choices:
- Add by Brand — pick specific brands from a list.
- Add Brands by Company — pick a manufacturer and pull in all of their brands at once.
Use Remove, Remove All, and Reset just like the product-type box.
Item Tag Filter (optional)
If you use tags to label items, the last panel lets you fine-tune even further:
- Include Only Items With This Tag — the total will contain only tagged items.
- Exclude Any Items With This Tag — the total will leave out tagged items.
Use the + and - buttons under each list to add or remove a tag. (If you don't use tags, ignore this panel entirely.) One thing TORO won't allow: putting the same tag in both the include and exclude lists — it'll ask you to fix that first.
Saving or Sharing the Report
Click Export at the bottom to turn the current results into a tidy report — with your store name, the date and time, all the totals, and the full item list. TORO will offer to email it or print it, so you can file it away, hand it to your accountant, or keep a paper record of what the store was worth on a given day.
About the * in the Profit % Column
You may notice a small * in the Profit % column for a few items, with every other number for that item looking normal. That is not an error. It simply means the item has a $0 cost, so a markup percentage can't be calculated (you can't measure "how many times over cost" when there's no cost). The button labeled What does * mean? opens a full explanation.
In short: it's TORO's honest way of saying "markup doesn't apply here" instead of printing a wild, meaningless number. The rest of that item's figures are still correct. Full details: Why Profit % Sometimes Shows a *.
A Few Tips
- Run it before tax time or a valuation. Export the report and you've got a dated record of exactly what your inventory was worth.
- Watch the Profit $ number over time. If it climbs, you're stocking up; if it drops, you're selling down. Both are fine — just know which is happening.
- Chase down the
*items. A starred item is usually one where you forgot to enter what you paid. Fix the cost and your totals get more accurate. - Leave the defaults alone unless you have a reason. Active Items Only, ignore-zero, and ignore-negative are the settings that give the truest number for most shops.