Your Inventory Spreadsheet Can’t Quote: Moving to Quote-Ready Inventory
LEDGER · July 29, 2026
This post is about why spreadsheets break for coin and bullion inventory, what quote-ready inventory looks like instead, and how to move without a weekend-long data project.
Why spreadsheets fail at the counter
Spreadsheets are excellent for analysis. They are poor operating systems, because inventory in a coin shop is not a list. It is a set of items that are constantly moving between states.
They are always out of date
A spreadsheet is only as current as the last person who typed into it. A sale at 10:15, a buy at 10:40, and a package that left at noon are not in it until someone catches up. The counter is quoting from the past.
They do not know where things are
“Vault” is not a location. A shop with a safe, a showcase, a show box, a shipping shelf, and a box waiting for grading needs to know which one. When location lives in a notes column, the walk to the back becomes a search.
They cannot hold a state
An item can be available, held for a customer, invoiced but unpaid, packed to ship, or listed online. A spreadsheet can only show that with colors and comments, which means two employees can read the same row two different ways.
They have no price, only a cost
Most inventory sheets track what the shop paid. The counter needs what the shop will pay and charge today. That number depends on spot, and spot is not in the spreadsheet unless someone pastes it in.
They multiply
Once the main sheet gets slow, people make copies: one for the show, one for eBay, one for the accountant. Within a month there are four versions and no agreement on which is right.
What quote-ready inventory means
Quote-ready inventory is inventory that can answer a customer question without anyone leaving the counter. In bullionOS, inventory exposes SKU, metal, quantity, buy price, sell price, vault status, scanning, and photo lookup in one table. Before every customer quote, the desk sees live SKU, metal, quantity, vault location, buy price, and sell price.
That combination is the whole difference. The spreadsheet tells you what you own. Quote-ready inventory tells you what you can sell, where it is, and what it costs the customer right now.
Designing your inventory before you move it
Do not migrate a messy spreadsheet as-is. Moving the mess into new software just gives the mess a nicer screen. Spend a few hours on structure first.
Decide what deserves its own SKU
Common bullion products, such as a one-ounce coin of a given type or a ten-ounce bar from a given refiner, usually work well as SKUs with a quantity. Certified coins, unique pieces, and higher-value numismatic items often deserve item-level records. Write down the rule so staff do not invent their own.
Name your locations
List every physical place inventory can sit: each safe, each showcase, each drawer, the shipping shelf, the receiving area, and any off-site storage. Give each a short, unambiguous name. If a location cannot be named, it should not hold inventory.
Capture metal and purity properly
Metal, fine weight, and purity are what make live pricing possible. A row that says “silver bar” with no weight cannot be priced from spot. Fill these fields first for the products you quote most.
Set buy and sell pricing
For each SKU, decide how you price it relative to spot on both sides. This is where the sticky notes on the register finally go away.
A migration plan that does not stop the shop
- Count what you quote most. Start with a physical count of high-volume bullion. Do not trust the spreadsheet quantity; it is the thing you are replacing.
- Load those SKUs with locations and pricing. This first slice covers most counter quotes.
- Freeze the spreadsheet for those items. Once a product lives in the new system, stop updating it in the old one. Two sources of truth are worse than one imperfect one.
- Add the next category each week. Certified coins, then scrap categories, then slower-moving collector material.
- Archive the spreadsheet. Save a dated copy for reference and stop editing it.
For the counting side of the process, our guide to cycle counts and physical inventory covers how to resolve variances as you go.
What changes once inventory is connected
The benefit of quote-ready inventory is not only at the counter. Because it is connected to the rest of the dealer workflow, the same record carries forward.
Quotes become invoices
When a customer accepts, the items and price move onto an invoice. Quantity changes once, at the moment of the sale, instead of at the end of the week.
Shipping and receiving update stock
Shipping connects carrier status, invoice records, delivery exceptions, and vault receiving, so physical movement stays accountable. An inbound package becomes inventory when it is received, not when someone remembers to add a row.
Exposure stays visible
With metal and weight recorded, exposure at spot can show current holdings, unrealized P/L, and spot sensitivity. That view is almost impossible to keep honest in a spreadsheet.
Online listings stop competing with the counter
When marketplace selling runs through an eBay workflow inside the same dealer system as your inventory, the counter and the listing stop living in separate spreadsheets.
Keep the spreadsheet for what it is good at
Retiring the inventory spreadsheet does not mean giving up spreadsheets. They are still useful for ad hoc analysis, planning a show buy, or modeling a pricing change. The rule is simple: spreadsheets can read from your inventory, but they should not be your inventory.
For a single source of truth for stock and locations, see bullionOS coin inventory software.
Bring your spreadsheet to a demo
Show us the sheet your shop actually runs on, tabs and colors included, and we will walk through how it maps to quote-ready inventory in bullionOS. Book a complimentary demo.