How to Create Automated Pay Slip in Excel and Save PDF Copy

Рет қаралды 43,456

Күн бұрын

How to Create Automated Pay Slip in Excel and Save PDF Copy
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/4aXyOdV
Managing employee payroll and generating accurate pay slips are crucial tasks for any organization. Excel is a powerful tool that can be used to streamline this process by creating automated pay slips. In this video tutorial, i will guide you through the steps to create an automated pay slip in Excel and save it as a PDF copy. By following these instructions, you can efficiently generate salary slips for your employees, ensuring accuracy and convenience. Also if you use this pay slip generator you won't be needing any online pay slip software.
Step 1: Set up the Excel Spreadsheet
To begin creating an automated pay slip in Excel, open a new spreadsheet and format it to suit your requirements. Create appropriate columns such as employee name, employee ID, designation, basic salary, allowances, deductions, and net salary. You can also include additional columns specific to your organization's needs.
Step 2: Enter Employee Information
Enter the necessary employee details into the respective columns. You may choose to import this data from another source or manually enter it. Make sure to maintain consistent formatting throughout the spreadsheet.
Step 3: Calculate Gross Salary
In the next step, calculate the gross salary by adding up the basic salary and any additional allowances. Use Excel formulas to perform the calculations. For example, to calculate the gross salary for an employee, you can use the formula "=SUM(B2:D2)" (assuming basic salary is in column B, and allowances are in columns C and D). Apply this formula to the entire column as required.
Step 4: Calculate Deductions and Net Salary
Similar to Step 3, calculate deductions such as taxes, insurance, or any other applicable deductions. Subtract the deductions from the gross salary to obtain the net salary. Again, use Excel formulas to automate these calculations and apply them to the appropriate columns.
Step 5: Format the Pay Slip
Now that the calculations are complete, format the pay slip to make it visually appealing and professional. Use fonts, colours, and borders to highlight important information. You can also insert your company logo or any other branding elements to customize the pay slip.
Step 6: Automation
In this part we are going to fill all the data in your payslip format from our data sheet and we can use vlookup function to do this. If you need to learn Vlookup you can check this tutorial: • How to Use VLOOKUP Fun...
Once we get all the data, we need to write vba code. For your convenience I’m adding the vba code here:
/ 86226946
Once you have the code you need to create a button to run the code. Here are some ways to create button to run vba code in excel:
How To Create a Button to Run VBA Code: • How To Create a Button...
How to Create Floating Buttons In Excel to Run VBA: • How to Create Floating...
How To Create A Custom Button On Quick Access Toolbar To Run VBA: • How To Create A Custom...
Now you can click on the button and your pay slip will be created and saved automatically in your pre-selected folder and it will be named as employee id.
Creating automated pay slips in Excel streamlines the payroll process and ensures accuracy in salary calculations. By following the steps outlined in this video tutorial, you can efficiently generate pay slips for your employees, saving time and reducing the risk of errors. With the ability to save pay slips as PDF copies, you can easily distribute them to employees in a secure and professional manner. Embrace the power of Excel and simplify your payroll management with automated pay slips.
#payslip #salarysheet #excel
Thanks for watching.
-------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Playlists:
Excel Tutorial for Beginners: goo.gl/UDrDcA
Intermediate Excel Tutorial: tinyurl.com/59a837py
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Text Case Conversion Techniques: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
ChatGPT Excel Mastermind: tinyurl.com/46kn7tmd
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
Website: msexceltutorial.com/

Пікірлер: 57

@Excel10tutorial 5 ай бұрын

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/4aXyOdV

@nsubugakenneth7390 11 ай бұрын

I'm really beginning to love this channel

@Excel10tutorial 11 ай бұрын

You just made my day. Thanks a million.

@rayzor07 9 ай бұрын

I like this and it gives me more ideas to develop it further as it has a couple of limitations. I don't know VBA, but I can probably learn. Thanks for this!

@Excel10tutorial 9 ай бұрын

Go for it!

@yasminefakhr8668 11 күн бұрын

Many thaaaaank

@mohammedgammash 18 күн бұрын

Could y please advice me if i would to autoprint.

@IkramKhan-lo3bw 4 ай бұрын

Sir tried it multiple times but it gives me an error like: Run time Error ' -2147024773 (8007007b)': Document not saved. END. DEBUG Plz guide.

@VinodKumar-3 3 ай бұрын

Very good tutorial. However, if we have data for multiple months in Data sheel, what changes are needed for this to work?

@sudhakarc7501 10 ай бұрын

Very Nice Presentation

@Excel10tutorial 10 ай бұрын

Thanks a lot. Please subscribe and be with us.

@billvanoudtshoorn5962 8 ай бұрын

Love this! Made my own and it works just fine. It would be good if it did the monthly salaries and collected the YTD and Annual figures. As it is, you would have to do a separate workbook for each month and collate the figures from there? Do you have an easier solution?

@Excel10tutorial 7 ай бұрын

Send me your workbooks with instructions. I'll see what i can do for you.

@bollinaaruna5794 28 күн бұрын

Hi, This video has been very useful. I am able to convert to PDF now only issue how to send this pdf files into employees email id . hope I will see soon a video

@jayaashokkumar2779 5 ай бұрын

Tq a lot sir I have done successfully 🎉 Tq Tq Tq sir

@Excel10tutorial 5 ай бұрын

All the best

@nguyenucanh9694 4 ай бұрын

Hello. I want the pdf file to have a password added. Do you have any ideas to help me? Thank u so much !!!

@gicygeorge5596 9 ай бұрын

Thank you so much. The same is possible with JavaScript for Google sheet? If poosible for Google shhet, please explain.

@Excel10tutorial 3 ай бұрын

Sorry, I don't have anything on google sheet

@user-dr9dn4yz7e 5 ай бұрын

Hi! Thank you for this! If this is created in Excel / WPS Office, can it be opened with Google Sheets and not have any errors?

@Excel10tutorial 5 ай бұрын

It will work only on excel desktop as it has vba.

@kasturiranganp 24 күн бұрын

Excellent video! Can you also do a tutorial on how to automate to send emails?

@Excel10tutorial 23 күн бұрын

Yes, soon

@eliaskasongo4789 7 ай бұрын

This was really useful, Thanks! I need a full HR worksheet, can we work something out?

@Excel10tutorial 7 ай бұрын

Sure thing!

@eliaskasongo4789 7 ай бұрын

What is you email?@@Excel10tutorial

@Shadow-0808 Жыл бұрын

Needed this exactly some months ago😂

@Excel10tutorial Жыл бұрын

Better late than never 😜

@PathologicalResearcher 10 күн бұрын

Are you using office 365? My dropdown cant be automated

@bhavna2208 3 ай бұрын

Hello. I am on mac and I am using the free version of WPS office, how can I add the developer tab? Thank you

@Excel10tutorial 3 ай бұрын

You can add developer tab on Microsoft Excel.

@fhussainmomin268 7 ай бұрын

Sir...how to print ..15 slip in one A4 page ...

@kumareshs1103 5 ай бұрын

Sir very clear explained and i need another one video is this pdf employee individual email id auto send how is ,please make video sir ,its very useful sir,thank you sir,kindly email send video need sir

@Excel10tutorial 5 ай бұрын

Will upload soon

@udarkhan274 6 ай бұрын

I need practice but i havnt data of employees income to make pay slip . So how can i practice ?

@Excel10tutorial 6 ай бұрын

Check online for practice data

@user-lw2hk4sh6r 10 ай бұрын

Thanks for this tutorial. But pls show also hoe to delete as well..

@Excel10tutorial 10 ай бұрын

What do you want to delete?

@BaliwagTransit-nh6zs Ай бұрын

I did the same output using excel and word mail merge

@Excel10tutorial Ай бұрын

Awesome

@ariannel.javier335 Ай бұрын

I keep getting a run time error - Document not saved. How do I fix this?

@Excel10tutorial Ай бұрын

Save the workbook before doing this.

@Rachanabhandarigadiya 10 ай бұрын

Sheet1.Range("B11").Value = Sheet2.Cells(i, "A") when running the macro code suggested above line is appearing in yellow.

@ffbynum 10 ай бұрын

Check the name of the sheet reference. That can create an error message. See the sheet names in the VB code

@mwaledex 5 ай бұрын

did manage to debug or resolve the line?

@santhoshrajpn3910 4 ай бұрын

Not working Run time error 424

@Anisha-rp4rb 25 күн бұрын

Mujhe banwana hai.. koi bana sakta hai please??

@itsmethaphy6322 3 ай бұрын

if you connect your computer to a printer, will it print the pdfs directly?

@Excel10tutorial 3 ай бұрын

This will not print automatically. For printing we need to do things a little bit differently.

@itsmethaphy6322 3 ай бұрын

@@Excel10tutorial like using the command 'printout'. I mean, The second statement we write 'sheet1.exportasfixedformat' instead we write 'sheet1.printout'?

@itsmethaphy6322 3 ай бұрын

@@Excel10tutorial short video for that will be appreciated