banner_ad

Generate payslip

Excel for Finance 3933 views 4 replies

I want to develop an Payslip/salary slip for my company employess in the following ways:

1) pay slip generation (Excel) and

2) conver to PDF automatically(if possible) (or i can do manually and split each and every page)

3) PDF should be protected/secured with there pan num/DOB or any password that should not be the same to each and every employees it a one time password.

Replies (4)

hi

 

except last step, you can do so by VBA

 

 

is it fine?

 

To generate Pay Slip in Excel, please visit my blog site : 

https://getmis.weebly.com/mis-blog/new-post

Ensure that you have installed Excel2007 or higer version. The pay slip format considered in this file can be customised as per your requirement. Please leave a comment in my blog for any clarification.

Import attendance data from excel to Tally using udi-Magic Software.

  1. Start Tally ERP and Open a Company.
  2. Start udi-Magic software
  3. Select the option Excel to Tally > Import data into Tally
  4. Click the Browse button and select Standard Excel template provided with udi-Magic converter
  5. Click the Start button

Download link : https://www.rtslink.com/downloads

For more information refer : https://www.udimagic.com

As an employer, your payslip needs to be designed in consultation with your HR, your CA or your accounts person. Otherwise, you can have a look at some of the following samples of Salary Slip formats and pick the one you think you need. They’re in Excel, Word, and PDF formats.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
11 May 2026
AUDIT INTERN

M/S K.K.KHANNA AND COMPANY

Noida

CA Foundation

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details