Skip to main content
  • Personal
  • Business
  • Foundation
    Close
  • Select Region

      Select your region below to see curated info.

    • Global
    • India
    • MENA
  • mySHRM Login
  • MySHRM
    • Dashboard
    • Account
    • Logout
SHRM
  • Membership
    • Membership

      As a SHRM Member®, you’ll pave the path of your success with invaluable resources, world-class educational opportunities and premier events.

      Membership Tiers
      • Professional
      • Student
      • Global
      • Executive
      • Business
      Membership Benefits
  • Learning
    • Certification

      Validate your skills with the gold standard in HR

      • Choosing Your Certification
      • SHRM-CP
      • SHRM-SCP
      • How to Get Certified
      • Prepare for the Exam
      • Recertification
      Education Programs

      Expert-led training for real workplace change

      • eLearning
      • Essentials of HR
      • Seminars
      Specialty Credentials

      Go deep in your niche. Stand out in your field.

      • AI + HI Specialty Credential
      • People Manager Qualification (PMQ)
      Executive Voices

      Bring our experts to your stage.

  • Attend
    • Events

      Demonstrate your ability to apply HR principles to real-life situations.

      • SHRM26 Annual Conference & Expo
      • The AI+HI Project 2027
      • Talent 2027
      • Linkage Institute 2026
      • BLUEPRINT 2026
      State Conferences

      Attend a SHRM state event to network with other HR professionals and learn more about the future of work.

      Seminars

      Stand out from among your HR peers with the skills obtained from a SHRM Seminar.

      Webinars

      Learn live and on demand. Earn PDCs and gain immediate insights into the latest HR trends.

  • Resources
    • Resources

      Stay up to date with news and leverage our vast library of resources.

      • Flagships
      • HR Research
      • Legal & Compliance
      • Latest News & Trends
      • Tools & Guides
      • Webinars
      HR Topics
      • AI in the Workplace
      • Civility at Work
      • Compensation & Benefits
      • Inclusion & Diversity
      • Talent Acquisition
      • HR Technology
      • Workplace Violence Prevention
      Educational Programs

      Designed and delivered by HR experts to empower you with the knowledge and tools you need to drive lasting change in the workplace.

  • Community
    • Find a SHRM Chapter

      Easily find a local professional or student chapter in your area.

      • SHRM Northern California
      SHRM Connect

      Post polls, get crowdsourced answers to your questions and network with other HR professionals online.

      Membership Councils

      Learn about SHRM's five regional councils and the Membership Advisory Council (MAC).

      Volunteers

      Learn about volunteer opportunities with SHRM.

  • Shop
    • SHRM Store

      Shop for HR certifications, credentials, learning, events, merchandise and more.

      Workplace Essentials
      • SHRM Memberships
      • SHRM Certification
      • Specialty Credentials
      • HR Tools & Tech
      Education
      • Seminars
      • eLearning
      • Books
      Merchandise
      • Accessories
      • Apparel
      • Office & Home
Become a Member
Renew
Rejoin Now
Renew
Ask an HR Advisor
Close
  • Personal
  • Business
  • Foundation
  • Membership
    back
    Membership
    • Membership

      As a SHRM Member®, you’ll pave the path of your success with invaluable resources, world-class educational opportunities and premier events.

      Membership Tiers
      • Professional
      • Student
      • Global
      • Executive
      • Business
      Membership Benefits
  • Learning
    back
    Learning
    • Certification

      Validate your skills with the gold standard in HR

      • Choosing Your Certification
      • SHRM-CP
      • SHRM-SCP
      • How to Get Certified
      • Prepare for the Exam
      • Recertification
      Education Programs

      Expert-led training for real workplace change

      • eLearning
      • Essentials of HR
      • Seminars
      Specialty Credentials

      Go deep in your niche. Stand out in your field.

      • AI + HI Specialty Credential
      • People Manager Qualification (PMQ)
      Executive Voices

      Bring our experts to your stage.

  • Attend
    back
    Attend
    • Events

      Demonstrate your ability to apply HR principles to real-life situations.

      • SHRM26 Annual Conference & Expo
      • The AI+HI Project 2027
      • Talent 2027
      • Linkage Institute 2026
      • BLUEPRINT 2026
      State Conferences

      Attend a SHRM state event to network with other HR professionals and learn more about the future of work.

      Seminars

      Stand out from among your HR peers with the skills obtained from a SHRM Seminar.

      Webinars

      Learn live and on demand. Earn PDCs and gain immediate insights into the latest HR trends.

  • Resources
    back
    Resources
    • Resources

      Stay up to date with news and leverage our vast library of resources.

      • Flagships
      • HR Research
      • Legal & Compliance
      • Latest News & Trends
      • Tools & Guides
      • Webinars
      HR Topics
      • AI in the Workplace
      • Civility at Work
      • Compensation & Benefits
      • Inclusion & Diversity
      • Talent Acquisition
      • HR Technology
      • Workplace Violence Prevention
      Educational Programs

      Designed and delivered by HR experts to empower you with the knowledge and tools you need to drive lasting change in the workplace.

  • Community
    back
    Community
    • Find a SHRM Chapter

      Easily find a local professional or student chapter in your area.

      • SHRM Northern California
      SHRM Connect

      Post polls, get crowdsourced answers to your questions and network with other HR professionals online.

      Membership Councils

      Learn about SHRM's five regional councils and the Membership Advisory Council (MAC).

      Volunteers

      Learn about volunteer opportunities with SHRM.

  • Shop
    back
    Shop
    • SHRM Store

      Shop for HR certifications, credentials, learning, events, merchandise and more.

      Workplace Essentials
      • SHRM Memberships
      • SHRM Certification
      • Specialty Credentials
      • HR Tools & Tech
      Education
      • Seminars
      • eLearning
      • Books
      Merchandise
      • Accessories
      • Apparel
      • Office & Home
Become a Member
Renew
Rejoin Now
Renew
Ask an HR Advisor
  • Select Region

      Select your region below to see curated info.

    • Global
    • India
    • MENA
SHRM
mySHRM Login
  • MySHRM
    • Dashboard
    • Account
    • Logout
Close

  1. Topics & Tools
  2. Employment Law & Compliance
  3. How to Manually Track Immigration Requirements
Share
  • Linked In
  • Facebook
  • Twitter
  • Email

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus convallis sem tellus, vitae egestas felis vestibule ut.


Error message details.

Copy button
Reuse Permissions

Request permission to republish or redistribute SHRM content and materials.


Learn More
News

How to Manually Track Immigration Requirements

And how to recognize when a company may have outgrown this approach

January 13, 2023 | Allen Smith, J.D.

A woman sitting at a table with a laptop and papers.


​Manually tracking immigration requirements with paper, Excel and Outlook reminders is common among small employers. Here is an overview of how to manually track immigration requirements, along with signs that a company may have outgrown this approach.

Manual-Tracking How-To's

Small employers will typically maintain one or more spreadsheets that track key expiration dates for employees on work visas as well as any pending or future immigration matters, said John Fay, an immigration attorney and director of product strategy at Equifax Workforce Solutions in Phoenix, which specializes in cloud-based I-9, E-Verify and immigration case management solutions. Outlook reminders supplement the lists, particularly for important filing deadlines and status expiration dates.

For example, an employer may keep a spreadsheet of all employees with temporary work authorization—either employer-sponsored, such as H-1B, L-1 and TN visas or those with "open market" employment, such as individuals on employment authorization documents. "Within those sheets, they'll monitor I-94 expiration dates, I-797 petition expirations, visa max-out dates for H's and L's, and any time-sensitive requirements for future green card sponsorships," Fay said. "Each one of these may also be monitored through an Outlook reminder."

For I-9 reverification purposes, HR should set reminders six to seven months in advance and then have follow-up reminders monthly to ensure there is plenty of time and warning to the employee to obtain necessary work authorization renewals to complete reverification, said Sujata Ajmera, an attorney with Clark Hill in Austin, Texas. "Another thing we recommend employers track are termination dates so they can ensure they meet the I-9 document retention requirements."

Separately, organizations will also have a list of all immigration cases that are in progress, such as visa extensions, change-of-status petitions and permanent residency applications. Within those lists, employers may track the current stage of a case—for example, questionnaires completed and petitions being prepared or filed with the U.S. Citizenship and Immigration Services—or any future steps needed from a corporate perspective.

For example, Fay said that in the H-1B context, employers must perform a variety of record keeping and notification activities in connection with the required labor condition application that is filed with the U.S. Department of Labor. "Green card applications involve even more tracking for the HR team, particularly those that go through the complete labor certification process—Permanent Employment Certification or PERM—that entails a variety of recruiting and advertising tasks in order to test the labor market," Fay said.

Often, the employer's outside counsel prepares and shares these lists. The outside counsel typically is involved in preparing applications, particularly for small organizations that do not have the resources or knowledge to navigate the "Byzantine U.S. immigration system," Fay added. "Nevertheless, employers need to monitor these lists and take action when required in order to avoid potential immigration heartache."

Manual-Tracking Risks

If the volume of foreign nationals increases, employers may need a team of HR and recruiters to manage all the required application steps and monitoring of expiration dates, Fay said. "While it's great to have help, HR then runs into the problem of making sure that everyone on the team can access and update the spreadsheet or receive the Outlook reminders," he said. "Inevitably, somebody will make a change to the master spreadsheet, e-mail it to someone else and then run into versioning issues with multiple copies floating around."

Companies also should be concerned about the potential security risks of maintaining manual immigration tracking records, particularly when they have personally identifiable information (PII) or sensitive case details, Fay noted. "It's not uncommon for HR to use record identifiers in their spreadsheets to avoid duplicates, but often these identifiers fall into a PII classification and thus present a security risk for the business," he said.

An incorrect date or entry in a spreadsheet can easily occur. Making a mistake on an immigration process due to missed deadlines can negatively impact the business, particularly when a valued foreign national worker has to leave the company. "HR must also be mindful of immigration enforcement risks" that result from faulty immigration tracking, he said.

Alternatives

"Companies [that] are starting to feel these burdens will likely want to evaluate alternatives as soon as possible," Fay said.

"Many employers do not realize these compliance failures until a new HR manager is brought on board," Ajmera said. An annual self-audit can identify gaps. "This will help employers better understand when they have reached the point where more sophisticated I-9 processes may be required."

Many employers that grow beyond their spreadsheets and Outlook calendar capabilities switch to an integrated human resource information system software that handles the I-9 process as a part of new employee onboarding.

"When an employer has more than 20 to 25 foreign national employees who require immigration sponsorship, using a more sophisticated system can help to prevent issues, such as missed deadlines or a mix-up between individual expiration dates," said Yova Borovska, an attorney with Buchanan, Ingersoll & Rooney in Tampa, Fla.

With manual tracking, turnover in a role responsible for I-9s may cause lapses. A cloud-based or centralized system to track key dates can help ensure that all employer representatives involved in the I-9 process have access to data on key expiration dates, said Claudia Martorell, an attorney with Ogletree Deakins in San Diego.

"As soon as an employer can afford digital I-9 software that also tracks expiration dates, it is worth it," said Greg Berk, an attorney with Sheppard Mullin in Costa, Mesa, Calif. Employers should "talk to their payroll providers and see if they offer an ICE [Immigration and Customs Enforcement] compliant digital I-9 software package. If not, then reach out to other vendors."

Merely scanning I-9s as PDFs is not ICE compliant, Berk explained. "The software must have a built-in audit trail to track who touched the digital I-9, when and what was done."

ESG, Ethics & Compliance
Recruiting
Sourcing

Was this resource helpful?

Leave Feedback

SHRM-CP Promo Image
Validate your HR expertise

Earning your SHRM-CP credential makes you a recognized expert and leader in the HR field.

Get Certified


Related Content

(opens in a new tab)
News
How One Company Uses Digital Tools to Boost Employee Well-Being

Learn how Marsh McLennan successfully boosts staff well-being with digital tools, improving productivity and work satisfaction for more than 20,000 employees.

(opens in a new tab)
News
A 4-Day Workweek? AI-Fueled Efficiencies Could Make It Happen

The proliferation of artificial intelligence in the workplace, and the ensuing expected increase in productivity and efficiency, could help usher in the four-day workweek, some experts predict.

(opens in a new tab)
News
Rising Demand for Workforce AI Skills Leads to Calls for Upskilling

As artificial intelligence technology continues to develop, the demand for workers with the ability to work alongside and manage AI systems will increase. This means that workers who are not able to adapt and learn these new skills will be left behind in the job market.

Workplace Compliance Newsletter

Keep abreast of employment law and compliance developments and their wide-reaching impacts.

Success title

Success caption

Manage Subscriptions
Our Brands

SHRM Foundation Logo
SHRM Executive Network Logo
CEO Circle Logo
SHRM Business Logo
SHRM Linkage Logo
SHRM Labs
Overview

  • About SHRM
  • Careers at SHRM
  • Press Room
  • Contact SHRM
  • Post an HR Job
SHRM Named to Newsweek's 2026 America's Top Online Learning Provider List
Advocacy

  • SHRM Advocacy
  • Federal Policies
  • State Affairs
  • Global Policy
  • Take Action
  • SHRM E2 Initiative
Brand Partnership

  • Partnership Opportunities
  • Advertise with Us
  • Exhibit & Sponsorship
  • Recertification Providers
  • Book a Speaker
Member Resources

  • Ask an HR Advisor
  • SHRM Newsletters
  • SHRM Flagships
  • Topics & Tools
  • Find an HR Job
  • Vendor Directory

© 2026 SHRM. All Rights Reserved
SHRM provides content as a service to its readers and members. It does not offer legal advice, and cannot guarantee the accuracy or suitability of its content for a particular purpose. Disclaimer

Follow Us

  • LinkedIn
  • Facebook
  • Twitter
  • Instagram
  • YouTube
Feedback

  1. Your Privacy Choices

  2. Terms of Use

  3. Accessibility

  4. Privacy Policy

Join SHRM for Exclusive Access to Professional Content

SHRM Members enjoy unlimited access to articles and exclusive professional content resources.

Already a member? Login
Free Article

Login to unlock unlimited access or join SHRM today to get unlimited access to articles and member-exclusive resources.

Already a member? Login
Limit Reached

You've reached the limit of 1 free article this month. Join to access unlimited articles and member-only resources.

Already a member? Login
Free Article

Login to unlock unlimited access or join SHRM today to get unlimited access articles and member-exclusive resources.

Already a member? Login
Limit Reached

You've reached the limit of 1 free article this month. Join the Executive Network and enjoy unlimited content.

Already a member? Login
Unlock Your Career with SHRM Membership

Please enjoy this free resource! Join SHRM for unlimited access to exclusive articles and tools.

Already a member? Login
Join SHRM for Exclusive Access to Professional Premium Content

SHRM Members enjoy unlimited access to articles and exclusive professional premium resources.

Already a member? Login
Join SHRM for Exclusive Access to Student Content

SHRM Members enjoy unlimited access to articles and exclusive member resources.

Already a member? Login
Join SHRM for Exclusive Access to Executive Network Content

SHRM member enjoys unlimited access to articles and exclusive executive member resources.

Already a member? Login

Your membership is almost expired! Renew today for unlimited access to member content.

Renew now

Your membership has expired. Renew today for unlimited access to member content.

Renew Now

Your Executive Network membership is nearing its expiration. Renew now to maintain access.

Renew Now

Your membership has expired. Renew your Executive Network benefits today.

Renew Now