PawnCounter for California shops that file CAPSS
SupportedCalifornia DOJ reporting XML. Every California pawn shop files it.
What PawnCounter adds
Every California pawnbroker already produces a CAPSS XML file. PawnCounter reads it as the tickets side of your shop: what you took in, by category, and what you lent or paid.
Add a sales or inventory export from your POS for the other side, and the free Profit X-Ray shows aged stock, markdowns and margin by category and buyer. PawnCounter does not file anything with the Department of Justice; it only reads a copy.
- A markdown list: items priced above what the same thing actually sold for in your shop, with a price that sold.
- A sell-off list: aged stock ranked by the cash it has tied up.
- Margin, sell-through and days to sale by category, brand and the buyer who wrote the ticket.
- Redemption and forfeiture by category, where your files carry loans.
What to send
- Tickets: your CAPSS XML data file.
- Sales and inventory: a sales or inventory export from your POS.
How to find it
California pawnbrokers report every transaction to the Department of Justice through CAPSS, as an XML data file. Your POS writes that file for you; look for its CAPSS or police-reporting export.
Send the XML file as it is. There is no need to open or edit it.
Like other police exports, CAPSS carries what you acquired, not your resale prices, so include a sales or inventory file as well.
Files and privacy
We accept .csv, .xml, .dbf or .txt, up to 50 MB per file.
Your files may include customer names, ID numbers, dates of birth, addresses and phone numbers. Those fields are hashed before any analysis — we analyze items and dollars, never people. See the Privacy Policy.
PawnCounter only reads a copy of an export. It does not change anything in CAPSS (California) and does not file police reports for you.
Need a hand?
Not sure which file is which? Email support@pawncounter.com — we'll find it with you.
A small Export Helper that finds these files on your PC for you is coming soon.
Further reading: how to price pawn shop inventory and what to do with aged inventory.