Home
Forms Library
I 9 retention calculator excel

I 9 retention calculator excel 2025

i 9 retention calculator excel Preview on Page 1

Show details

4.7 out of 5

59 votes

The document outlines the retention requirements for Form I-9, Employment Eligibility Verification, as mandated by the Department of Homeland Security. It specifies that employers must keep a completed Form I-9 for each employee on payroll and retain it for a designated period after employment ends. The retention period is calculated based on the employee's start date and termination date. Employers are advised not to mail Form I-9 to DHS and must take corrective actions if an employee's form is missing. Legal advice should be sought for specific situations.

Here's how it works

01. Edit your i 9 retention calculator excel online

Type text, add images, blackout confidential details, add comments, highlights and more.

02. Sign it in a few clicks

Draw your signature, type it, upload its image, or use your mobile device as a signature pad.

03. Share your form with others

Send free i 9 retention calculator via email, link, or fax. You can also download it, export it or print it out.

The best way to edit I 9 retention calculator excel in PDF format online

Ease of Setup

DocHub User Ratings on G2

Ease of Use

DocHub User Ratings on G2

Handling paperwork with our extensive and intuitive PDF editor is simple. Follow the instructions below to complete I 9 retention calculator excel online easily and quickly:

Sign in to your account. Sign up with your email and password or create a free account to test the service before upgrading the subscription.
Import a form. Drag and drop the file from your device or add it from other services, like Google Drive, OneDrive, Dropbox, or an external link.
Edit I 9 retention calculator excel. Effortlessly add and highlight text, insert pictures, checkmarks, and icons, drop new fillable areas, and rearrange or remove pages from your paperwork.
Get the I 9 retention calculator excel accomplished. Download your adjusted document, export it to the cloud, print it from the editor, or share it with others through a Shareable link or as an email attachment.

Benefit from DocHub, one of the most easy-to-use editors to rapidly manage your documentation online!

be ready to get more

Complete this form in 5 minutes or less

Get form

Got questions?

We have answers to the most popular questions from our customers. If you can't find an answer to your question, please contact us.

What is the formula for I-9 retention?

To calculate how long to keep a former employees Form I-9: If they worked for less than two years, retain their form for three years after the date you entered in the First Day of Employment field. If they worked for more than two years, retain their form for one year after the date they stop working for you.

How long do I-9 forms need to be retained?

You must complete a new Form I-9 when a hire takes place, unless you are rehiring an employee within three years of the date the employees previous Form I-9 was completed.

How do I calculate retention rate in Excel?

For example, if the number of customers at the start of the period is in cell A1, the number of customers at the end of the period is in cell B1, and the number of new customers acquired during the period is in cell C1, then the formula would be: =(B1-C1)/A1*100.

Should you keep copies of I-9 documents?

You are still responsible for completing and retaining Form I-9. You must retain copies and present them with Forms I-9 in case of an inspection by DHS, the Department of Labor or the Department of Justice.