Mapping Visas and Expiries

building a continuity dashboard

If your migrant workforce is still being tracked with sticky notes, a whiteboard and a shared sense of panic, it is time for an upgrade.

A continuity dashboard is simply a clear, living picture of who is on what visa, when those visas and accreditations expire, and what happens next. Done well, it keeps you compliant, avoids nasty surprises, and gives migrant staff confidence that you are planning with them, not guessing around them.

Why mapping visas is now non-negotiable

Immigration New Zealand expects accredited employers to be able to prove they are monitoring visas and acting early. In post-accreditation checks they specifically ask for documentation of visa-status checks, visa-expiry dates, and records showing that you remind AEWV workers ahead of expiry.

At the same time, tools like VisaView let employers confirm a worker’s visa type, conditions and expiry date online, with each enquiry saved as evidence that you checked. In other words, INZ has given you both the obligation and the system to meet it.

Layer on the AEWV condition that new work visas must provide at least 30 hours’ work per week, with accreditation at risk if you do not deliver, plus increasing pressure on employers to keep robust immigration records and mapping visas stops being a “nice admin thing” and becomes core risk management.

In my view, the dashboard is simply the cleanest way to pull all of that together.

What your continuity dashboard needs to track

You do not need a fancy HRIS to start. A well-designed spreadsheet or simple database will do the job, as long as it is accurate and actively used.

For each migrant worker, your dashboard should hold at least –

• Core identity – full name, employee ID, role, site/location, manager.
• Visa details – visa type (AEWV, partnership, student, etc), visa number, issuing country.
• Key dates – visa start date, visa expiry date, and where relevant, maximum continuous stay end date for AEWV.
• Conditions – minimum hours (for AEWV, normally 30+), any sector or location restrictions, and the specific employer named on the visa.
• Pathway flags – “has residence pathway?”, “in Green List / priority role?”, “study to residence plan?”
• Risk window – traffic-light status (for example, green = >12 months to expiry, amber = 6–12 months, red = <6 months).
• Next action – e.g. “explore residence,” “renew AEWV,” “role change – needs advice,” “no further pathway – succession plan.”

On top of the individual rows, you want some at-a-glance metrics at the top –

• Number of visas expiring in the next 6, 12 and 18 months.
• Critical roles (by team or site) with visas expiring inside 12 months.
• Staff who are nearing the end of their AEWV maximum continuous stay.

That is your continuity radar. If you open the dashboard and see three key supervisors in red for the next six months, you know you have work to do.

Step 1 – Get the data right (even if it is painful)

The first job is a one-off clean-up –

1. List every non-NZ-citizen employee you have.
2. For each one, run a VisaView enquiry to confirm their current visa type, conditions and expiry date, rather than relying on what you think is true.
3. Enter those details into your dashboard and save the VisaView confirmation (PDF or screenshot) to the employee’s file.

In my opinion, this is where many employers stumble. They assume HR has it “somewhere,” or that staff will “tell us if there’s a problem.” That mindset is exactly what post-accreditation checks and Labour Inspectorate campaigns are designed to challenge.

Step 2 – Design the dashboard so humans will actually use it

A technically perfect spreadsheet that no one opens is useless. Aim for simple and visual –

• Keep all migrant workers on one main sheet; avoid dozens of tabs.
• Use conditional formatting to colour the “days to expiry” column red/amber/green.
• Freeze key columns (name, role, visa type, expiry) so they are always visible.
• Create filters by site, manager and visa type so leaders can quickly see “their” team.

If you like, you can add a second sheet with pivot tables or charts – for example, a bar chart showing how many visas expire per quarter over the next two years. That helps you see whether you have a nasty cluster of expiries you need to smooth out.

Step 3 – Build reminders and accountability around it

INZ’s own guidance for post-accreditation checks notes that they expect to see records showing you remind AEWV workers about their visa expiry date and documents demonstrating how you ensure they do not breach hours or other conditions. So your dashboard needs a heartbeat, not just pretty colours.

Practical options –

• Add “reminder dates” (for example 12, 6 and 3 months before expiry) as columns and use them to trigger calendar tasks in Outlook or your task manager.
• Allocate each row to a named owner (HR lead or line manager) who is responsible for the conversation with that employee.
• After each conversation, note the outcome in a short comment – for example, “Discussed residence options; employee keen; referred to adviser,” or “No long-term pathway; succession planning needed.”

That note becomes evidence that you are not only tracking dates, but also acting on them.

Step 4 – Connect the dashboard to real continuity decisions

Mapping visas is only half the story. The continuity value comes when you use the dashboard to steer decisions about –

• Recruitment – If several people on the same visa type all hit maximum stay around the same period, you may need to stagger future AEWV hires or prioritise residents and citizens for certain roles.
• Role design – If a worker is stuck on a visa with no realistic residence pathway, you may decide to redesign their role or invest in training so they can move into a pathway-eligible position.
• Succession planning – Where there is no pathway and no realistic renewal, the dashboard should trigger a succession conversation early, not two weeks before the person flies out.
• Pastoral care – People sitting in “amber” for long periods may be quietly stressed. Using the dashboard to check in with them proactively is both humane and smart retention.

In my view, this is also where your “continuity check-up” product lives – you are essentially offering to build and interpret this dashboard for clients, then turn the insights into a 12–24 month plan.

Step 5 – Keep one eye on policy change and system issues

Finally, treat the dashboard as a living tool in a moving environment. Policy changes – like the expansion of the skilled occupation list under the new National Occupation List from 3 November 2025 – can open new pathways for people who previously looked stuck. System issues, such as recent technical problems affecting AEWV records during business sales or restructures, are a reminder that you should not rely solely on INZ’s systems to know who is legally employed where.

When something changes, use the dashboard to ask, “Which of our people might this help or hurt?” Then update their risk status and next actions accordingly.

You do not need to become a data scientist to build a continuity dashboard. You just need to know who is on what, when it ends, and what your next move is. Get that clear, and your migrant workforce stops being a source of nasty surprises and becomes a planned, stable part of your long-term business story.

The Last Word Remember, Immigration Law is as simple or as complex as Employment Law. However you view it, the best advice is always to have a very well qualified support system to keep you out of trouble, keep your valuable workers exactly where you want and need them and new recruits arriving without drama. Neazor Brady have been providing such sure-footed support for decades now and are willing and able to support all your immigration needs.