Excel Import Payroll

Top  Previous  Next

If you have more than 10 employees in the company payroll, you may consider preparing the details in excel and import into the payroll entry.


Below is an excel template of 2 employee's monthly salary itemised details  . Create the same header name in roll 1 from column A to M.
Click Download to get the payroll template.


Watch video : How to prepare all employee's salary detail in excel for monthly import purpose

Step 1 : Enter the details of each employee and keep this excel file for subsequent month's use.




Step 2 : Save it in your folder.



Step 3 : Select A/c Entry, Purchase Journal. Click on [Payroll] tab, [Import Payroll]



Step 4 : Select the relevant excel file . Click [Open]



Step 5 : Click [Save]



The 2 employee records are successfully imported.





Related Topics

Payroll introduction


Employee id





Watch all videos:

Realtimme Training Portal