A pawn shop's inventory isn't like other retail, because every item is one of a kind and has a history. A hardware store has forty identical drills. A pawn shop has fourteen drills, each bought or forfeited on a different day from a different person, at a different price, with its own serial number, and each with a date before which it can't be sold. So the inventory needs two things. A list by kind that says what's on the floor and what the shop has in it. And a ticket log, one row an item, with the ticket number, the serial number, what was paid or lent, and the date it becomes saleable. The second is the real inventory. Below is both for a made-up pawn shop, how they're used, and a file to download. Hold periods and police reporting are set by State and local law: ask your licensing office what applies to you.
The short version
- One row for every item in the ticket log: ticket, serial number, description, what it cost you.
- A date on every row: the day it can go out for sale.
- A list by kind for the overview: how many, where, and the money in them.
- Items in pawn, items on hold and items for sale are three different piles. Keep them apart.
- Describe each item so a stranger could pick it out: make, model, serial, marks.
- New accessories are ordinary stock with a reorder level.
- TaroStack keeps each item as a lot with its own cost, code and date. More below.
The list, by kind
Counted in mid November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Guitar, electric, used | each | 6 | 0 | $140.00 | $840.00 | OK |
| Cordless drill kit | each | 14 | 0 | $38.00 | $532.00 | OK |
| Miter saw | each | 3 | 0 | $85.00 | $255.00 | OK |
| Game console | each | 9 | 0 | $120.00 | $1,080.00 | OK |
| Laptop | each | 5 | 0 | $165.00 | $825.00 | OK |
| Gold ring, 14k | each | 22 | 0 | $210.00 | $4,620.00 | OK |
Ten rows in all, $9,496.10 at cost. The other four are watches, bicycles, and two new accessories, guitar strings and jewelry gift boxes, which are the only rows with a reorder level and the only two flagged to reorder.
Unit cost here is an average, what the shop has in a typical item of that kind. It's good enough to see that nearly half the money on the floor, $4,620, is in one tray of gold rings. It isn't good enough to price anything. For that you need the row for the item itself.
Nobody reorders a used guitar. Used goods have a reorder level of zero. What a pawn shop watches for them isn't a low count. It's a high one: fourteen drill kits is more than this shop sells in two months, and the next one offered should get a lower price or a no.
The ticket log
| Date in | Item | How it came in | Ticket and serial | What we paid or lent | Can be sold from | Note |
|---|---|---|---|---|---|---|
| Nov 2 | Guitar, electric, used | Bought outright | Ticket 20614, serial MX21507733 | $130 | Dec 2 | Sunburst, one ding on the lower bout |
| Aug 12 | Gold ring, 14k | Pawn, forfeited Nov 12 | Ticket 19877 | $180 | Nov 12 | 4.1 g, size 7 |
| Nov 9 | Cordless drill kit | Bought outright | Ticket 20650, serial 4471-B-20933 | $35 | Dec 9 | Two batteries, charger, case |
The date is the column that keeps a shop out of trouble. This shop holds anything it buys outright for 30 days before it goes on the floor. It sells a pawned item only after the loan and its grace period have run out and the item is forfeited. Those are this shop's rules, as its own license requires them. Yours are whatever your State and city say, and they may differ for jewelry, firearms and electronics. The guitar bought on November 2 goes on the wall on December 2 and not before. If a detective comes for it in the second week, it's in the back, with its ticket.
The serial number is the item. Two black game consoles are the same thing until one of them is on a stolen-property list. Write the serial from the item itself, not from the box, and photograph it.
Describe what a serial can't. Rings don't have serial numbers. The row has the karat, the weight, the size, any stones and any engraving.
What it cost is on the row. The loan forfeited, or the price paid: in the file it's written in the note. That's the number a selling price is set against, item by item.
Three piles
| Pile | What it is | Whose it is | Can it be sold |
|---|---|---|---|
| In pawn | Collateral for a live loan | The customer's | No |
| On hold | Bought or forfeited, inside its hold period | The shop's | Not yet |
| For sale | Past its date | The shop's | Yes |
Only the third is inventory in the retail sense, and only it belongs on the sales floor. The first isn't the shop's property at all, and it shouldn't appear in a stock value. This shop's mistake was one shelf in the back holding all three.
Counting
Count the case every day at open and close: jewelry is small, valuable and easy to lose one piece of. Count the floor monthly by section, against the ticket log, and look for two things: an item on the floor with no row, and a row with no item. The file's count sheet takes what the list said and what you found. A plan for what to count when is in cycle count form, and a general shop's list in store inventory sheet. How fast the money in stock comes back is in inventory turnover example, and pricing second-hand goods in how to price used items for resale.
Get the template
Download the pawn shop inventory template. The list by kind with values, a ticket log with the ticket and serial, the date each item can be sold and a flag for dates coming up, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A spreadsheet has no memory of who changed what. In a business where an inspector or the police can ask to see the record for one item on one day, a row that anyone can overwrite is a weak record. And the date column only works if someone reads it every morning: the sheet won't stop a clerk from selling the guitar on November 20.
How TaroStack does it
TaroStack keeps each item as its own lot, and every change to it as a record.
Each item comes in as a lot with its own code, its own cost and its date, and your own fields for the serial number, the description and the ticket.
Holds: stock on hold is kept out of what can be sold until you release it.
Every movement says who, when and why, and a correction is recorded as a correction, not an overwrite.
Stock value by month, on what each item actually cost.
Counting on a phone, with what a difference is worth shown before you post it.
| The question | Spreadsheet | In TaroStack |
|---|---|---|
| What did we pay for this one | Find the row | The lot's cost |
| Can it be sold yet | Read the date | On hold until released |
| Who changed the record | Unknown | On every movement |
| What's the floor worth | Averages | Stock value, from each item's cost |
TaroStack isn't pawn software: it doesn't write loan tickets, work out interest or send reports to the police. It connects to Square. Lots, holds and counts are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
