The NPA Pawn Industry Financial and Operating Performance Benchmark Survey can be as much of a handful to complete as it is a mouthful to say, but we can’t stress enough how beneficial completing it can be for the future of your business. There’s not a consultant in the world who wouldn’t charge tens of thousands of dollars for the data the NPA and Industry Insights provides to you just for spending an hour or two completing the survey.

PawnMaster’s reporting tools make finding the information you need a straightforward process. Before you get started, check under “Report Categories” for “ADVANCED STATISTICS”. If you don’t see it, please call PawnMaster support to set up a time to update your reporting tools.

Getting Started

PawnMaster reporting can help you fill out your NPA Benchmarking Survey in three different areas: Sales and Inventory, Pawn Transactions, and Pawn Detail.

Please note: for the “Pawn Balance: $” column under Pawn Transactions and the “Ending Inventory Balance” column under Sales and Inventory, you will need to access your manually archived monthly reports. If you don’t have saved reports for any particular month, leave those lines blank and continue to fill out the rest of the survey to the best of your ability.

If you do not do so already, PawnMaster recommends running and saving current balance reports every month.

In the sections below, we’ve listed the category, report, and line items where you can find data you need using some of our new Advanced Statistics reports. However, if you’re familiar with PawnMaster reporting, or you’d like to get started before you have access to the new reports, you can find all of the information you need for the Sales and Inventory and Pawn Transactions sections in either the ACCOUNTING > Analysis Report, or the ACCOUNTING > Management Dashboard Report. The Pawn Detail section requires Advanced Statistics reports.

Sales and Inventory

“2. Enter your sales and inventory by month for 2019:”

# of Sales Transactions

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “2 – Sales Statistics Breakdown” report
  3. Your number of sales transactions is listed as “Number of Sales”

Sales $

  1. Choose the “ACCOUNTING” report category
  2. Choose the “2 – Management Dashboard Report” report
  3. Your total sales dollars are listed as “Total Sales (Net)”

Cost of Goods Sold (COGS)

  1. Choose the “ACCOUNTING” report category
  2. Choose the “2 – Management Dashboard Report” report
  3. Your COGS is listed as “Less Cost of Goods Sold”

Ending Inventory Balance (see note above, this column requires a report to have been saved in the month indicated by the survey row)

  1. Choose the “ACCOUNTING” report category
  2. Choose the “2 – Management Dashboard Report” report
  3. Under “All Inventory (as of printing)” you’ll find your ending inventory balance listed as “Inv”

Pawn Transactions

“1. Report your pawn transactions for each month in 2019 and your 2018 total:”

Pawn Balance: #

  1. Choose the “PAWNS” report category
  2. Choose the “1 – Items in Pawn” report
  3. Your pawn balance number is listed as “Number of Pawns”

Pawn Balance: $ (see note above, this column requires a report to have been saved in the month indicated by the survey row)

  1. Choose the “PAWNS” report category
  2. Choose the “1 – Items in Pawn” report
  3. Your pawn balance dollars are listed as “Total Pawn Amount”

Written: #

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “1 – Pawn Statistics Breakdown” report
  3. Your pawns written number is listed as “Number of Pawns”

Written: $

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “1 – Pawn Statistics Breakdown” report
  3. Your pawns written dollars are listed as “Total Pawn Amount”

Buys: #

  1. Choose the “ACCOUNTING” report category
  2. Choose the “1 – Analysis Report” report
  3. Your number of buys is listed as “BUYS Quantity”

Buys: $

  1. Choose the “ACCOUNTING” report category
  2. Choose the “1 – Analysis Report” report
  3. Your total spent on buys is listed as “BUYS Amount” (note: change the sign for the survey, as this number will be negative in the report)

Forfeitures: #

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “3 – Pawns Disposition by Number of Payments” report
  3. Your number of forfeitures is listed as “Number of Tickets for Forfeits”

Forfeitures: $

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “3 – Pawns Disposition by Number of Payments” report
  3. Your total forfeiture dollars are listed as “Sum of Principle for Forfeits”

Redeems: #

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “3 – Pawns Disposition by Number of Payments” report
  3. Your number of redemptions is listed as “Number of Tickets for Redemptions”

Redeems: $

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “3 – Pawns Disposition by Number of Payments” report
  3. Your total redemptions dollars are listed as “Sum of Principle for Redemptions”

Pawn Revenue

  1. Choose the “ACCOUNTING” report category
  2. Choose the “2 – Management Dashboard Report” report
  3. To calculate your total pawn revenue, add together the following line items: Charges on Redemptions + Charges on Renewals + Late Charges + Late Ticket Charges

Pawn Detail

This section requires the use of reports found in the “ADVANCED STATISTICS” report category. As noted above, please call PawnMaster Support if you do not see it listed in your “Report Categories” section.

“1. Enter your pawns written by customer demographic type for 2019:”

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “1 – Pawn Statistics Breakdown” report
  3. Choose the “Customer Age & Gender” option

“2. Enter your pawns written by transaction size for 2019:”

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “1 – Pawn Statistics Breakdown” report
  3. Choose the “Transaction Amount” option

“1. For pawns redeemed in 2019: what is the average length of days from the day loan was created to redemption?”

  1. Choose the “ADVANCED STATISTICS” report category
  2. Choose the “3 – Pawns Disposition by Number of Payments” report
  3. Record your average days for redemptions in the survey box