ExcelBanter - Payslip

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Payslip (https://www.excelbanter.com/excel-discussion-misc-queries/94617-payslip.html)

si_ako

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!

--
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

Toppers

Payslip

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

si_ako

Payslip

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

Toppers

Payslip

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

si_ako

Payslip

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

Toppers

Payslip

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

si_ako

Payslip

Thanks a lot! here's my email address:

I'll wait for your email. thanks again!

--
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

si_ako

Payslip

si_ako

Payslip

si_ako

Payslip

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

my email address:

--
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

All times are GMT +1. The time now is 05:45 PM.