<
πŸ“Š

Bulk Salary Calculator

Upload your employee list and download a complete salary structure for all employees instantly

πŸ’‘ To create a new setting or edit existing ones, please use the Single Salary Calculator β†’.

Step 1 β€” Download Input Template

⬇️

Download the Excel template, fill in employee details, then upload it below.

Required columns in your file:
employee_id employee_name calc_basis target_amount location_city min_wages gender

calc_basis accepts: monthly_ctc, monthly_gross, monthly_net
gender accepts: male, female, other (default: male)
location_city must match exactly with city names in our database

Step 2 β€” Upload Filled File

⬆️
πŸ“

Drag & drop your Excel file here, or click to browse

Supports .xlsx and .xls files

Step 3 β€” Calculate & Download

⚑

How It Works

πŸ“–
1
Select a Salary Setting

Choose a salary policy (PF type, ESI, bonus rules, PT/LWF states etc.) that applies to all employees in this batch.

2
Download & Fill the Template

The template has all required columns pre-labelled. Fill one row per employee. Each employee can have a different calc_basis or target_amount.

3
Upload Your File

Upload the filled Excel. A preview shows your data and flags any missing or invalid values before processing.

4
Calculate & Download

Click calculate. Each row is processed using the same engine as the single calculator. A fully formatted result Excel is downloaded automatically.


Output Excel columns:
πŸ“₯ Input (echoed)
Employee IDNameBasisTargetLocation
πŸ’° Summary
Monthly CTCMonthly GrossTake-Home Net
πŸ“— Earnings
Basic SalaryHRAOther AllowancesStatutory Bonus
πŸ“• Deductions
PF (EE 12%)ESI (EE 0.75%)Prof. TaxLWF (EE)
πŸ“˜ Employer
PF (ER 12%)PF AdminEDLIESI (ER 3.25%)GratuityLWF (ER)