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.

 

   

                                                                                                                    PurchaseFastCode

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

http://realtimme.cloudapp.net/basic/index.html?Import_Payroll_Details.htm