Import from sheet

Bring a whole company in from Excel — a salary register or a master sheet. The wizard maps your sheet's columns to Vetanika's sections, proposes a structure when you have none, and dry-runs before anything is written.

Steps

1. Upload the sheet and pick the header row. Column headers are auto-recognised (name, code, gender, DOJ, UAN, PAN, department, designation, gross…); fix any guess by hand.
2. Map — identity slots on the left, pay on the right. Three identity slots matter for reporting:
   • Department — text on the employee
   • Designation — text on the employee
   • Processing group — a shared slot: point it at the Department column (both from one column), at a separate "Group" column, or leave it to default to Department
3. Structure — fit employees on an existing structure, or let the wizard propose one from the sheet's components.
   • For a package structure (fixed heads), the Package heads ← sheet columns panel appears: pick the column for each head (Basic, HRA…). A blank cell keeps the structure's amount; the gross becomes the heads' sum.
4. Preview — one row per employee with notes ("no gender — defaults male", "sheet gross ≠ heads — heads win").
5. Dry run — every row must be clean before Import unlocks.
6. Import — employees, initial fitments and lifecycle events are created; new processing groups are created by name.

Register mode

A register sheet (earned figures, not contracted) is understood: earned components scale up to the full month by the same factor as the gross, so LOP rows import at their contract.

Values the wizard understands

• Gender: M, m, F, Female, Mr, Mrs, O… — any reasonable spelling; unreadable values are left blank, never guessed
• Dates in the common Indian formats
• Amounts with commas

Once payroll has run

An import batch can be reverted only while none of its employees has a processed month. After that, correct through Update from sheet or the employee's Salary history.