(Do this only if you are comfortable with the process.)Ī neat solution would be to use Excel Macros (using VBA or VB) or to import the data from your worksheet into a database and then programe the printout as desired. Suggestion: To save pages, you can save the printout to a text file, open this saved file using an editor and replace the PAGE BREAK characters by couple of NEW-LINE CHARACTERS or by a simple continuous line (“-”) to act as separator between records. Do cycle through the records by clicking the NEXT button and satisfy yourself about the format before printing. Note that the print preview shows one record and column heading in each page. To do this pull the Top Margin indicator thread downwards and then pull the Bottom Margin indicator thread upwards. We will now set the margin to print only one record per page. Make a Salary Slip in Excel Automatic Salary Pay Slip in 5 Minutes Learn for Future 16.4K subscribers Subscribe 79K views 1 year ago MS Excel In this video you will learn about.
Now launch the FILE->PRINT PREVIEW option and click the button named MARGIN.
Press OK button after you have done it.Ģ. You can use any salary break calculator or prepare your own salary calculator in Excel (or) in any payroll software as per your company needs.A very quick (probably dirty too) solution is as follows:ġ. Use the FILE->PAGE SETUP option and click the SHEET tab and set "ROWS TO REPEAT AT TOP" as the column-heading of your EXCEL Worksheet. First decide how much gross salary you want to pay to the employee, based on the gross salary you can calculate salary breakup.Ģ. How to Calculate the CTC Details Before Entering in Annexureġ. Similarly during salary increments also companies will provide annexures along with the increment letters or salary revision letters. Based on that you can make a decision to join that job or not.Ĥ. If you observe the salary annexure provided along with the offer letter (or) appointment then you will know how much actual net salary are you going to get. When it comes to employees it is more important, most employees just focus on the CTC but they don’t concentrate on the net salary they get.ģ. It is important for both employees and employers, based on the salary annexure the employer will prepare the payslip.Ģ.
0 kommentar(er)
