<
βš–οΈ

Bulk Minimum Wages Salary Restructuring Calculator

Upload your employee list with current salary details and download restructured salary structures ensuring minimum wages compliance for all employees instantly

βœ” 100% Free  β€’  βœ” Free Instant Access  β€’  βœ” Processed in your browser β€” data never leaves your device

πŸ’‘ To create a new setting or edit existing ones, please use the Single Salary Calculator β†’. Settings with ✨ have custom allowances (Pro feature).

Step 1 β€” Download Input Template

⬇️

Download the Excel template, fill in employee current salary details and restructuring method, then upload it below.

Required columns in your file:
employee_id employee_name gender location_city min_wages current_basic current_hra current_other_allowances gross

gender accepts: male, female, other (default: male)
location_city must match exactly with city names in our database
min_wages β€” applicable monthly minimum wages in β‚Ή for this employee
current_basic, current_hra, current_other_allowances β€” existing salary components in β‚Ή
gross β€” current monthly gross salary in β‚Ή; this is used directly as the restructuring target
current_basic acts as the floor β€” the restructured basic will never be set below the employee's existing basic

Step 2 β€” Upload Filled File

⬆️
πŸ“

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

Supports .xlsx and .xls files

Step 3 β€” Restructure & 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. Settings with ✨ have custom allowances (Pro feature).

2
Download & Fill the Template

The template has all required columns pre-labelled. Fill one row per employee with their current salary components. The gross column is used directly as the restructuring target β€” the salary engine will recompute a compliant structure around it.

The current_basic acts as the floor β€” the restructured basic will never be set below the employee's existing basic.

3
Upload Your File

Upload the filled Excel. A preview shows your data and flags any missing or invalid values before processing. The gross column is taken as-is as the target for restructuring.

4
Restructure & Download

Click restructure. Each row is processed through the salary engine β€” minimum wages compliance is enforced β€” and a fully formatted result Excel with both old and new salary breakdowns is downloaded automatically.


Output Excel columns:
πŸ“₯ Input (echoed)
Employee IDNameGender LocationMin Wages (β‚Ή) Old Basic (β‚Ή)Old HRA (β‚Ή) Old Other Allowances (β‚Ή)Old Gross (β‚Ή)
πŸ’° Summary
Monthly CTCMonthly GrossTake-Home Net
πŸ“— New 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)
✨ Pro Meta
Is Pro CalcMandatory HRA ActiveMandatory HRA StateCustom Allowance Count