Skip to main content
When you need to apply adjustments to many employees at once - such as a company-wide festival bonus or a batch of monthly reimbursements - upload a CSV file instead of creating each adjustment by hand.

​
When to Use Bulk Import

Bulk import works well when:
  • You have many adjustments to create at once.
  • They span multiple employees (for example, the whole team gets a bonus).
  • You already have the data from another system that can export CSV.
For just a few adjustments, creating them one at a time is usually quicker. See Adding Adjustments.

​
CSV Format

Your CSV file should include a header row, then one row per adjustment. The importer reads these columns by name (column order does not matter, and headers are matched case-insensitively): A single file can contain up to 1000 rows.

​
Notes on values

  • category must be exactly addition or deduction.
  • type is a free-text label. For consistency, match the type names used in the app (such as “Performance Bonus” or “Advance Repayment”), but the importer accepts any non-empty text.
  • amount must be a positive number greater than zero.
  • currency defaults to INR when left blank.

​
Sample CSV

​
Importing the File

1

Open the Payroll Adjustments page

Open the Payroll Adjustments page (/employer/pay/adjustments).
2

Click Import CSV

Click Import CSV in the top-right. The Import Adjustments from CSV dialog opens.
3

Choose your file

Choose your .csv file. The file is validated and processed as soon as it is selected.
4

Read the result

The dialog shows the result:
  • Import Successful - the number of adjustments created out of the total rows processed (for example, “5 adjustments created from 5 rows”). Because the import is all-or-nothing, this count equals the number of rows in the file.
  • Import Failed - a per-row error list (the row number followed by its messages) plus a summary line in the form “X valid, Y with errors out of Z total rows”.
5

Close the dialog

Click Close.
Imported adjustments are created as drafts and appear in the Payroll Adjustments list, where you can review them and let them flow into a payroll run.
The import is all-or-nothing. If any row fails validation, no adjustments are created from that file - fix every listed row and upload again. The “X valid, Y with errors” summary on a failed import is only a diagnostic count of which rows passed and which did not. It does not mean the valid rows were saved.

​
Common Validation Errors

If the import fails, the dialog lists the problem rows. Common causes:

​
Tips for a Clean Import

  • Test with a small file first - upload two or three rows to confirm the format before a large batch.
  • Double-check email addresses - “employee not found” is the most common error.
  • One adjustment per row - do not combine multiple adjustments into one summed row.
  • Keep notes simple - notes are stored as plain text; avoid extra commas or line breaks inside a cell.