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