Skip to main content

Excel Adjustment – Export/Import for One-Time Allowances and Deductions

Allowances and Deductions excel export and import in payroll

Myo Zaw Hein avatar
Written by Myo Zaw Hein
Updated over 2 months ago

Update One-Time Allowances or Deductions

  • Click the up arrow at top right > select Export Excel Format.

  • Download the file.

  • Edit:

    • Add/edit one-time amounts (e.g., commission, bonus) in regular columns.

      ⚠️Do not edit the amount in locked/logic columns.

      ⚠️You need to kill the formula if you are using formulas in excel

  • Save and return to the payroll group.

  • Click the up arrow > Import Excel Format.

  • Upload the updated Excel.

  • Once import is successful, click Regenerate Payroll > Confirm.

Did this answer your question?