Tracking business licenses by location
Open the tracker sorted by what runs out next, then read the list by location. A license that lapses at one site is a different problem from the same license lapsing at another: the local permit office, the lease, and the inspector's route all differ. Sorting by expiry first and location second puts the nearest deadline at the top while keeping each site's paperwork together.
Group the roster by site before the dates
Start with one row per employee per location, then add the license or card that person holds. A warehouse associate in Reno and the same job title in Tucson are separate records, even when the certificate name is identical. Attach the PDF or a phone photo of the card to each record so the evidence sits with the name, role, and site rather than in a shared folder nobody can search.
Read the late list as a location problem
The dashboard opens on what is already late, then this week, then the next 60 days; current cards stay out of the way. Treat the late section as a site-by-site count, not a personal failure. Three lapsed food handler cards at one kitchen point to a scheduling gap at that location, while one lapsed card at another points to a single missed email.
Illustrative comparison
A small chain runs two locations and reviews the same four records before and after grouping by site:
| Before: sorted by name only | After: sorted by expiry, then site |
|---|---|
| Sam Okafor, CPR/AED, expired 3 days ago, North shop | Sam Okafor, CPR/AED, expired 3 days ago, North shop |
| Kevin Tran, food handler card, expires in 7 days, North shop | Kevin Tran, food handler card, expires in 7 days, North shop |
| Dwayne Porter, forklift evaluation, expires in 24 days, South yard | Lena Fischer, OSHA 10, expires in 51 days, South yard |
| Lena Fischer, OSHA 10, expires in 51 days, South yard | Dwayne Porter, forklift evaluation, expires in 24 days, South yard |
The after view keeps both North shop items together at the top, so the manager sees one site needs two renewals this month and the South yard has room to schedule its evaluation later.
Hand the spreadsheet to the inspector
When an inspector or an insurance agent asks for proof, export the spreadsheet filtered to that location and the date range they named. Plain email reminders at 60, 30, and 7 days go to the person named on the record, and the export shows what was current on the day it was sent. If a site has no late items, say so in the email body rather than sending an empty file, so the recipient knows the location was checked and not skipped.
Related: Cert Expiry Tracker features.