Bulk Increment Salary Calculator
Upload your employee list with increment details and download revised salary structures for all employees instantly
Step 1 — Download Input Template
Download the Excel template, fill in employee increment details, then upload it below.
calc_basis accepts: monthly_ctc, monthly_gross, monthly_net
increment_type accepts one of three options:
• percentage — e.g. 10% hike on current CTC/Gross/Net
• fixed_amount — e.g. ₹5000 increase on current CTC/Gross/Net
• new_target — directly provide the new CTC/Gross/Net value
increment_value — the hike % (for percentage), the ₹ increase (for fixed_amount), or the new total ₹ amount (for new_target)
current_amount — current CTC / Gross / Net in ₹ (required for percentage and fixed_amount; ignored for new_target)
gender accepts: male, female, other (default: male)
location_city must match exactly with city names in our database
old_basic is the employee's previous basic salary in ₹ — new basic will not be allowed to go below this value (leave blank or 0 to skip)
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
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).
The template has all required columns pre-labelled. Fill one row per employee. Each employee can have a different increment type:
- percentage — e.g. 10% hike on their current CTC
- fixed_amount — e.g. ₹5,000 increase in current Gross
- new_target — directly set the revised CTC/Gross/Net
Use old_basic to enforce an increment floor — the new basic will never be set below the previous one.
Upload the filled Excel. A preview shows your data and flags any missing or invalid values before processing. The final target_amount is computed automatically from your increment inputs.
Click calculate. Each row is processed through the salary engine and a fully formatted result Excel with both old and new salary breakdowns is downloaded automatically.