Individual salary slips

[meamuka]

Hi there! I'm new in my current job and my boss asked me if I could generate a monthly slip for each employee containing their salary infos [details below].

1. I have a spreadsheet containing:
a) employees name, their ID, their bank ID;
b) I have the dates on top of each column; if they were present that day I typed 1, if not I left it empty;
c) I have separate rows showing taxes, contributions, gross and net wages for each employee.

2. I have to make a slip in one excel sheet that contains the following:
a) company name, info etc [the easy part for me];
b) employees info [name, ID, bank ID];
c) a calendar form highlighting days of presence;
d) salary info showing gross wage, taxes, contributions and net wage.

 

[AliGW]

Welcome to Mr Excel!

Could you provide some sample data in your next post showing the layout of your data? If I were doing this, I would do all of the necessary calculations in Excel and then run a mail merge to Word.

 

[oldbrewer]

1. I have a spreadsheet containing:

a) employees name, their ID, their bank ID;

b) I have the dates on top of each column; if they were present that day I typed 1, if not I left it empty;

c) I have separate rows showing taxes, contributions, gross and net wages for each employee.

2. I have to make a slip in one excel sheet that contains the following:

a) company name, info etc [the easy part for me];

b) employees info [name, ID, bank ID];

c) a calendar form highlighting days of presence;

d) salary info showing gross wage, taxes, contributions and net wage.

name

id

bankid

daily rate

days worked

gross pay

tax rate

tax deducted

NET PAY

01/07/2016

02/07/2016

03/07/2016

04/07/2016

05/07/2016

06/07/2016

07/07/2016

08/07/2016

09/07/2016

10/07/2016

11/07/2016

12/07/2016

13/07/2016

14/07/2016

15/07/2016

16/07/2016

17/07/2016

18/07/2016

19/07/2016

20/07/2016

21/07/2016

22/07/2016

23/07/2016

24/07/2016

25/07/2016

26/07/2016

27/07/2016

28/07/2016

29/07/2016

30/07/2016

31/07/2016

fred

12345

bnk12

160

23

3680

25%

920.00

2760.00

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

PAY ADVICE

MONTH OF

Jul-16

ACME WINDOWS

PRESENT

01/07/2016

02/07/2016

03/07/2016

04/07/2016

05/07/2016

06/07/2016

07/07/2016

FRED

12345

BNK12

SHOWN

08/07/2016

09/07/2016

10/07/2016

11/07/2016

12/07/2016

13/07/2016

14/07/2016

GREEN

15/07/2016

16/07/2016

17/07/2016

18/07/2016

19/07/2016

20/07/2016

21/07/2016

22/07/2016

23/07/2016

24/07/2016

25/07/2016

26/07/2016

27/07/2016

28/07/2016

USE CONDITIONAL FORMATTING

29/07/2016

30/07/2016

31/07/2016

GROSS WAGE

3680

TAX DED.

920

NET WAGE

2760

ADD CONTRIBUTIONS COLUMNS AS NEEDED

<colgroup><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col span="2"><col><col span="24"><col></colgroup><tbody>
</tbody>

 

[meamuka]

Thanks for the reply!
Here's how my data look like [I've included just a sample and excluded certain things for simplicity].

 

[meamuka]

https://s4.postimg.io/3nkyxd9yl/Untitled.jpg

 

[oldbrewer]

THE detail of the layout is not critical just copy the relevant cells

 

[meamuka]

Yes! Thanks a lot guys!