Automatic Salary slip Generator using Excel

This query is : Resolved

BINU.M.S

BINU.M.S (Querist)
Follow

09 July 2008 Hi

I am using Excel for preparing Salary Statements.I want to know how excel
can be used to prepare payslips automatically.Can any one tell me the process/function which is used to convert
salary statement into salary slips.I am expecting a positive response from you.

Thanks In advance
BINU.M.S

CA RAMESH KUMAR AHUJA

CA RAMESH KUMAR AHUJA (Expert)
Follow

09 July 2008 Standarddize ur formats of Statement and the Pay Slip. Use Mail Merge whereby the desired data may be picked from the Salary Statement by linking the fields.

BINU.M.S

BINU.M.S (Querist)
Follow

09 July 2008 Hi

Thanks for your valuable reply.I will check it out

Any Experts Who have other ideas about this
subject Please share it...

Regards
BINU.M.S

Upgrade to CAclubindia Pro. Subscribe Now!

Rupert

Rupert (Expert)
Follow

10 July 2008 Also available are free templates used in Excel from Microsoft on & Salaries & Payrolls - You can also make use of them along with mail merge.
www.office.microsoft.com/en-us/templates/default.aspx

BINU.M.S

BINU.M.S (Querist)
Follow

10 July 2008 Thanks,that Template from Microsoft is
very useful(ie,payroll calculator).

BINU.M.S

BINU.M.S (Querist)
Follow

10 July 2008 Thanks to all experts who spend their valuable
time answering my query.