Making a bulk payroll edits using excel

Objective: This articles guides admins on how to do a quick and easy bulk edit on the Cadana Admin web app by downloading the excel from the platform, making all the necessary edits and then, re-uploading the edited excel sheet onto your admin web app. The changes will reflect seamlessly as against making employee by employee edits. 

Here's how:

• On your dashboard, select the payroll tab at the left of your screen
• Select the drafted payroll you want to make edits on
• Select the Bulk Update button
• Select Template file to the query "How do you want to make this update?"
• Download the payroll excel file to your computer.
• Open the downloaded file and edit/update the allowances and deductions per the headings in the given columns.
• Save the edited payroll
• Upload the edited payroll file unto your dashboard by drag and drop or by uploading the file from computer.
•  You will immediately see a notification with confirmation: Success: Changes saved successfully
• Changes will reflect instantly.

Please note:

• Only payroll on draft (status) can be edited in this way.
• Do not add/remove any rows from the sheet.
• To add new allowances, add columns after the column named "ALLOWANCES >>>"
• By default all allowances are taxable. To mark an allowance as non-taxable, end the column name with an "*". E.g if you wanted the allowance for "Transport" to not be taxed, the column header should be "Transport*".
• To add new deductions, add columns after the column name "DEDUCTIONS >>>"