Pawn Shop Profit Tracker Excel for your products — products and pricing, a daily sales log, stock and inventory with low-stock flags, and a monthly P and L dashboard. Know what every product actually earns, what is…
About this template
Pawn Shop Profit Tracker Excel for your products — products and pricing, a daily sales log, stock and inventory with low-stock flags, and a monthly P and L dashboard. Know what every product actually earns, what is actually in stock — and whether the month actually made money. Built for pawn shop owners and resale lenders who need to know, product by product, what a unit really earns after cost — and how much cash is sitting on the shelf — without accounting software. If dead stock and shrinkage are quietly eating the month, this workbook shows both in plain numbers.
$39
Excel & Google Sheets template — instant download on Etsy
Products and Pricing — product, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit, for 12 products.
Daily Sales Log — date, product, quantity, unit price, unit cost, amount, cost of goods, and channel, for 19 sales in October 2026. Unit price and unit cost are pulled from sheet 1 by formula.
Stock and Inventory — opening stock, stock received, units sold by formula, shrinkage and write-offs, closing stock, reorder point, stock value, and a low-stock status flag by formula, for 12 products.
Monthly P and L — revenue, cost of goods, rent, staff, utilities, marketing, insurance, supplies and other expenses by month, Jan-Dec, with net profit and margin. Revenue and cost of goods are formulas from the Sales Log.
Dashboard — total revenue, units, transactions, average sale, cost of goods, gross profit and margin, expenses, net profit and margin, stock value, low-stock and out-of-stock counts, shrinkage cost, dead stock value, best and weakest products, revenue by product, costs by category, and units by product.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Pawn Shop Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Pawn Shop Profit Tracker track?
The Pawn Shop Profit Tracker tracks Products and Pricing; Daily Sales Log; Stock and Inventory; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 products; 183 units sold in 19 logged sales; total revenue 30,830; cost of goods 15,203; gross profit 15,627; gross margin 50.7 percent
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.