Insurance certificate expiration tracking against move in and move out dates

An exhibitor's certificate was accepted in November. The policy expires on 31 January. The show opens on 28 January, so whoever checked it saw a date after show open and passed it.

Teardown runs to 2 February. For the last two days of that exhibitor's occupancy, including the part where a crew is dismantling a two storey stand, there is no coverage. Insurance certificate expiration tracking exists to catch exactly that case, and a check written against show open will never see it.

The two dates the policy has to bracket

Every ACORD 25 coverage row carries two dates, in columns headed POLICY EFF and POLICY EXP. Both matter, and most checks use neither correctly.

The test is whether the policy period contains your whole tenancy. That means the effective date falls on or before your first move-in day and the expiration date falls on or after your last move-out day. Show open and show close have nothing to do with it.

Shows that write their requirements carefully say so explicitly. NAMM's exhibitor insurance requirements for its 2027 show, published in 2026, require coverage for all show days plus move-in and move-out, 22 January to 2 February 2027 inclusive. That is a twelve day window around an exhibit hall that opens on 28 January. IAAPA's published requirements for its 2026 Expo ask for coverage starting on or before 12 November and running through 22 November 2026. The American Urological Association's 2025 requirements set the period as the first day of the exhibitor move-in period to the last day of the move-out period, without naming dates.

All three describe the same shape. The exhibit days sit inside a longer occupancy, and the occupancy is what needs insuring.

Why does a show open check pass a bad certificate?

Because the show open date is the one every person in the building knows by heart, and the last move-out day is buried in an operations schedule.

Ask five people at a show when it runs and you get the exhibit dates. Ask when the last exhibitor truck leaves and you get a pause. The check gets written against the date that is available in the room, and the resulting rule reads: expiry after show open. That rule is correct on most certificates and wrong on exactly the ones that matter, since the days between show close and final move-out outnumber the exhibit days on most shows, and an expiry date is correspondingly more likely to land there.

The gap is bigger than people expect. NAMM's twelve day window contains three exhibit days, so nine of those twelve days are build and teardown. Any certificate check that ignores them is ignoring three quarters of the period the show is asking exhibitors to insure.

Counting it properly

Take 268 accepted certificates on a show with move-in starting 22 January, exhibit days from 28 to 30 January, and move-out finishing 2 February.

Test one, expiry after show open, 28 January: 264 certificates pass, which is 98.5 per cent.

Test two, expiry on or after last move-out, 2 February: 251 pass, which is 93.7 per cent.

Test three, effective on or before first move-in, 22 January: 262 pass.

Test four, both ends together: 247 pass, which is 92.2 per cent.

Test three is the one teams leave out entirely, and it catches a different animal. Six certificates in this file had effective dates after 22 January, all of them from exhibitors who bought a short term show policy timed to the exhibit days. Those exhibitors were told the show ran from the 28th, so they insured from the 28th, and they arrive on the 22nd to build with no cover in place. The fix there is in your own communication rather than in the check.

The naive check reports 98.5 per cent and the correct one reports 92.2 per cent. Seventeen exhibitors sit in the gap, and those seventeen are the ones with crews in the hall on a day nobody insured. Six points of headline compliance is also enough to change how a risk report reads, which is worth knowing before you publish the compliance rate built on top of these checks.

The renewal boundary problem

Shows in the first quarter have a structural version of this problem that autumn shows do not.

Annual policies renew, and a large share of them renew at the turn of the calendar year or on a fixed anniversary the exhibitor set years ago. A show collecting certificates in October for a January edition will receive documents whose policy period ends on 31 December or in the first days of January. Those certificates are accurate and useless at the same time, because the policy they describe will have been replaced before anybody arrives at the venue.

This is why a deadline that sits months before the show has a cost as well as a benefit. NAMM's 13 November 2026 deadline for its 2027 show gives the operations team ten weeks of runway, and it also guarantees that a proportion of the certificates arriving are for policy periods that end before the coverage period even starts.

The answer is a second pass, and it should be a rule rather than a favour. Any certificate whose expiry falls before the last move-out day is accepted conditionally and flagged for replacement, with the replacement due once the new policy incepts. Exhibitors accept this readily when the reason is explained, because their broker already knows the renewal date and can diary it.

What should be re-checked, and how often?

Acceptance is a judgement about dates that have not happened yet, so it decays.

Run a sweep on a schedule, weekly is enough, that re-evaluates every accepted certificate on file against your tenancy dates and against today. Three states come out of it: still valid, expired since acceptance, and expiring before the last move-out day. The third group is the one that needs work, and its size tells you how much of your file is conditional.

The sweep should also catch certificates that were accepted before your dates were final. Move-out dates change. A hall handback pushed by a day makes a batch of previously compliant certificates non compliant, and no exhibitor did anything wrong. If your tenancy dates live in one place and the checks read them from there, that recalculation is automatic. If they were typed into a rule when somebody built the workflow, nobody will notice.

What the sweep sends matters as much as when it runs. A message saying your insurance has expired sends the exhibitor to a broker with no useful instruction. A message naming the policy number, the expiry date on file, and the two dates the replacement has to cover gets a correct document back on the first attempt, and it costs nothing extra to assemble because your system already holds all four values.

Storing the underlying dates rather than the verdict is the general principle here. A record saying insurance valid cannot be re-evaluated. A record holding the effective date and the expiration date can be tested against any question you think of later, which is the same argument that applies to the other five fields on the certificate.

Buffer days as the number to report

One metric captures this whole area, and it is easy to compute once the dates are stored.

Buffer days is the policy expiration date minus your last move-out day, per exhibitor, signed so that negative means uninsured. Report the distribution rather than the average, because the average is meaningless when the interesting values are all below zero.

On our 268 certificates the median buffer was 148 days, which sounds comfortable and describes exhibitors whose policies run to the middle of the following year. The tenth percentile was 4 days. The minimum was minus 33. The median tells you nothing useful and the bottom decile tells you everything, which is the general shape of most onboarding measurements.

Sort ascending, look at the first twenty rows, and that is your work list. It takes a spreadsheet formula and replaces an afternoon of opening PDFs.

Where this stops

A policy period that brackets your tenancy proves the policy existed on the day it was issued and was written to run through your dates. It does not prove the policy is still in force. Mid term cancellation, non payment of premium and a change of carrier all break the picture, and the current ACORD 25 cancellation wording promises only that notice will be delivered in accordance with the policy provisions.

The second limit is that dates are the easiest thing on a certificate to read and the easiest to over-trust. An exhibitor with perfect dates and a policy that excludes the activity they are running on the stand is worse off than one whose policy expires a day early, and no date check will ever say so. Where the limits and the alternatives sit is general liability limit checking.

The third is scope. Everything above applies to the exhibitor's own policy. Their appointed contractors carry separate policies with separate dates, and a show that tracks exhibitor expiry rigorously while ignoring contractor expiry has covered the party least likely to be swinging a hammer at seven in the morning.

Take your accepted certificates this week, put the expiration dates in one column and your last move-out day in another, and subtract. Count the rows below zero and the rows below ten. Those two counts are the whole of your exposure on this dimension, and they are the fastest thing on any onboarding checklist to compute.