Skip to content

Pawn Shop Inventory: A List, a Ticket Log and a Hold Date

A pawn shop inventory template: stock by kind with what the shop has in it, a row for every ticket with its serial number, and the date each item can be sold.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 7 min read

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.

Questions people also ask

How do pawn shops keep track of inventory?

By the item, not the kind. Each item has a ticket with its description, serial number, what was lent or paid, and the date it can be sold. A list by kind sits on top of that for the overview.

How long does a pawn shop have to hold an item before selling it?

That's set by State and local law, and it can differ by kind of item. This example's shop holds outright purchases for 30 days. Ask your licensing office for your own rule.

What should a pawn shop inventory record include?

The date in, how it came in, the ticket number, the serial number or a full description, what was paid or lent, the date it can be sold, and where it is in the shop.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.