Hi all,

Attaching Herewith The Salary Preparation Register with Automatic Payslip Generator for Small & Medium Scale Industry.

In The Format As soon as We prepare the salary summary by just inserting the attendance paid days of employees summary & Payslip Is Generated Automatically.

Procedure for Generating Summary: Step 1

Copy the Entire Sheet of Last Month By Right Clicking The Sheet and Creating a Copy Of it.

Dec ---Right Click --- Move or Copy ----Create a Copy -- ok

Change The Name of Month In New Worksheet Available.


Step 2

Enter The Days In the Month In Column U 5 as 30 or 31.


Step 3

Enter The Fresh Paid Days of The Employees For The month Concerned.

Step 4

Insert OT Hours


Step 5

Insert Advances & Arrears (If Any)

Salary Is Ready

For New Employees Simply Insert The Rows and Copy The Last Employee With new details.

It Also Prepares Amount Payable For ESIC & PF.


Procedures For Payslip Generation

Copy The Entire Payslip Sheet As Done In Summary.

Choose The First Payslip For Necessary Changes. Look in to Each Cell of It where u Find A formula VLOOKUP. Change The Month Name in The Formula As Ur New Month entered for Summary. This Is to Be Done For All The Cells Of First Payslip.

Simply Copy The Entire First Payslip with Changed Month & Paste it To No. Of Slips Required For The month. The No. Should Match With The No. Of Employees In the Summary.

Here are your Payslips Ready.

These Payslips Can also be utilized as Salary register as Option and space available for Employee Signature.

Please mind That Whatever Changes u Make in Salary Summary reflects to Payslip.

S.No. Is Very Important. If The Sl. No. Of Summary Sheet is Wrong The Payslips May reflect The wrong data so always Check the Sl. No. of employees in Summary Before getting a printout.

For Any further Query Pls. reverse Back On This Site or rahulindia1234@gmail.com


Thanks.