Onboarding 50 Employees at Once: Bulk Setup in Leave Balance

Onboarding employees one at a time is manageable when you hire a few people a month. But when a growing team brings on 50 new employees at once — whether from a company merger, a seasonal hiring push, or a migration from another system — manual entry becomes a bottleneck that delays the team’s ability to use leave management from day one.

Leave Balance’s bulk onboarding process lets you import employees via CSV, assign policies in bulk, and trigger welcome notifications so every new team member can start using the system immediately. What would take days with manual entry takes minutes with bulk import.

Key Takeaways

• Bulk import up to 10,000 employees via CSV in a single upload
• Assign leave policies and approval workflows to groups during import
• Welcome notifications are sent automatically so employees can start using Leave Balance immediately

Why Bulk Onboarding Matters for Leave Management

When employees are not in the leave system, they cannot request leave through the portal. This creates one of two problems:

1. Informal processes take over. Employees email their manager or HR to request time off. These requests are not tracked, not auditable, and not visible to the rest of the team.
2. Employees wait. HR manually enters each employee into the system, and the queue grows. New hires wait days or weeks before they can use the self-service portal.

Both outcomes create friction during the most important period for a new employee: their first few weeks. Getting them into the leave system quickly means they can request leave from day one, check their entitlements without emailing HR, and understand the leave policy without searching through documents.

How to Bulk Onboard Employees

Step 1: Prepare Your Employee Data

Gather the employee data you need. The CSV import requires these fields:

Field	Required	Example
employee_id	Yes	EMP001
first_name	Yes	Sarah
last_name	Yes	Chen
email	Yes	sarah.chen@company.com
department	No	Engineering
manager_email	No	manager@company.com
policy_name	No	UK Annual Leave
start_date	No	2026-08-01

Step 2: Download the CSV Template

Navigate to Settings > Import > Employees and download the CSV template. The template includes column headers and sample data. Fill in your employee data using the template format.

Step 3: Validate the CSV

Before uploading, check for common issues:

• Duplicate emails. Each employee must have a unique email address. Duplicate emails cause the import to skip the second entry.
• Consistent policy names. If you are assigning policies during import, make sure the policy names in the CSV exactly match the policy names in Leave Balance. “UK Annual Leave” and “uk annual leave” are different.
• Correct date format. Use YYYY-MM-DD format for dates. 2026-08-01 is correct; 01/08/2026 is not.
• No blank rows. Empty rows between data rows cause validation errors.

Step 4: Upload the CSV

In Leave Balance, go to Settings > Import > Employees and drag your CSV file into the upload area.

Leave Balance will:

1. Parse the file and check for formatting errors
2. Validate each row against the database
3. Display a preview showing which rows are ready, which have warnings, and which have errors

Step 5: Review the Validation Report

The report shows three categories:

Status	Meaning	Action
Ready to import	Row passes all checks	No action needed
Warning	Minor issues (missing optional fields)	Review and proceed or fix
Error	Issues preventing import (duplicate email, invalid policy)	Fix and re-upload

Step 6: Assign Policies and Managers

If you did not assign policies in the CSV, you can assign them in bulk after import:

1. Select the employees to assign
2. Click “Assign Policy”
3. Choose the leave policy from the dropdown
4. Optionally assign managers for approval routing

Step 7: Import and Send Welcome Notifications

Click “Import” to commit the changes. Leave Balance processes the import and sends welcome notifications to each new employee. The notification includes:

• A link to sign in to Leave Balance
• A summary of their leave policy and entitlements
• A link to the getting started guide

Step 8: Verify the Import

After import, spot-check a few records:

1. Open an employee profile and confirm the details are correct
2. Check that the policy assignment is accurate
3. Verify the manager assignment is correct

Best Practices

• Import employees in batches of 500 or fewer. While the system supports up to 10,000 rows, smaller batches are easier to validate and troubleshoot.
• Set a start date for new employees. The start_date field lets you pre-load employees before they join. Their profiles become active on the start date.
• Send a welcome email alongside the system notification. The automatic notification is functional. A personal welcome email from the HR team adds warmth and encourages the employee to explore the portal.
• Create a “Getting Started” guide. Before bulk onboarding, prepare a short guide that walks new employees through the portal. Link to it in the welcome notification.
• Run the import during business hours. If something goes wrong, you want your HR team available to fix it. Avoid Friday afternoon imports.

FAQ

Can I import employees who already exist in Leave Balance?

The import matches by email address. If an employee already exists, the import updates their record with any new data in the CSV. It does not create a duplicate.

Can I assign different policies to different employees in one import?

Yes. Include the policy_name column in your CSV and set the correct policy for each employee. This is the most efficient way to assign policies during bulk import.

What if I do not know which policy to assign?

Import the employees without the policy_name column. After import, use the bulk assignment feature to assign policies to groups of employees.

Can I set up manager assignments during import?

Yes. Include the manager_email column in your CSV. Leave Balance matches the manager email to an existing employee and sets up the approval routing automatically.

What happens if the import fails partway through?

Leave Balance processes the entire file before committing. If any rows have errors, the entire import is held and you see the validation report. No data is imported until you confirm. If the import fails after commitment (e.g., due to a network error), Leave Balance retries automatically and notifies you of the outcome.