Payslip

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!

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" wrote:

>
> 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!
>
>
> --
> si_ako
> ------------------------------------------------------------------------
> si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
> View this thread: http://www.excelforum.com/showthread...hreadid=553027
>
>

Originally Posted by Toppers

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" wrote:

>
> 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!
>
>
> --
> si_ako
> ------------------------------------------------------------------------
> si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
> View this thread: http://www.excelforum.com/showthread...hreadid=553027
>
>

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

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" wrote:

>
> Toppers Wrote:
> > 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" wrote:
> >
> > >
> > > 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!
> > >
> > >
> > > --
> > > si_ako
> > >
> > ------------------------------------------------------------------------
> > > si_ako's Profile:
> > http://www.excelforum.com/member.php...o&userid=35078
> > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=553027
> > >
> > >
>
>
> thanks! how to do the two options? hope you can detail the procedures
> and formulas..many thanks!
>
>
> --
> si_ako
> ------------------------------------------------------------------------
> si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
> View this thread: http://www.excelforum.com/showthread...hreadid=553027
>
>

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

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

"si_ako" wrote:

>
> 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
>
>
> --
> si_ako
> ------------------------------------------------------------------------
> si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
> View this thread: http://www.excelforum.com/showthread...hreadid=553027
>
>

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

my email address: [email protected]