Repeat Pawn Customers
Contracts that have been rolled over (renewed) three or more times, tracked month by month so repeated roll-overs are visible. The roll count is the number after the “/” in the contract reference (e.g. 4933/3 = rolled 3×). View the whole company, a region or a single store.
What to track
Monthly trend
By store, by month
New roll-overs report
Compares the two most recent batches loaded into Supabase and produces an Excel file with a separate tab for each roll-over level (New 3×, New 4×, New 5× and so on). A contract appears in the “New N×” tab if it reached that number of roll-overs in the latest batch (it was lower, or absent, in the previous batch). Covers all stores. Run it after each fresh upload.
Upload repeat-pawn file
Drop the latest repeat pawn customers export (.csv or Excel) here to load it into the portal.
The snapshot date (this batch) is read from the filename (e.g. …20260701 → 1 Jul 2026) — confirm or change it before saving.
Re-uploading a file for a date already held replaces that batch.