Payslip

[si_ako]

is it possible to generate a payslip in excel?

or if i have a template of payslip in another sheet, then how can i
generate a payslip without linking each cell of a payroll report one by
one? since we have thousands of employees, it's really hard to link
them one by one. thanks a lot!

 

[Guest]

Maybe consider producing the payslip in WORD and doing a mail merge based on
the payroll data in your Excel spreadsheet.

If you do it in Excel, then you (probably) need to write VBA code to loop
through your Excel database and produce the payslips.

HTH

 

[si_ako]

Maybe consider producing the payslip in WORD and doing a mail merge
based on
the payroll data in your Excel spreadsheet.

If you do it in Excel, then you (probably) need to write VBA code to
loop
through your Excel database and produce the payslips.

HTH

thanks! how to do the two options? hope you can detail the procedures
and formulas..many thanks!

 

[Guest]

It is difficult to give the answer without detailed knowledge of the data and
format of the pay slip.

Can you post an example spreadsheet showing data and layout/format of payslip?

 

[si_ako]

thanks a lot *Toppers *, here's the example:

For the period June 1-15, 2006
Name RegularDay Basic Pay Adjust Late Overtime Deduction Net Pay
Mr. A 7 2,000 100
2,100

here's the payslip:

Company Name
For the period June 1 - 15, 2006
Name: Mr. A
Regular Day 7
Basic Pay 2,000
Adjustment 100
Total 2,100

Deduction -
Net Pay 2,100

 

[Guest]

If you give me an e-mail address I'll send some samples.

 

[si_ako]

Thanks a lot! here's my email address: (e-mail address removed)

I'll wait for your email. thanks again!

 

[si_ako]

Thanks a lot! here's my email address: (e-mail address removed)

I'll wait for your email. thanks again

 

[si_ako]

Thanks a lot! here's my email address: (e-mail address removed)

I'll wait for your email. thanks again

 

[si_ako]

hi *Toppers*, thanks a lot. i have received your email. i will check
them now.

my email address: (e-mail address removed)