CHAPTER 21 TOTAL COMPENSATION- Mark Calc On for each compensation category you want to include in
your calculations. - Repeat Steps 4, 5 and 6 until you’ve added entries for all the
compensation categories you want to include in the compensation
summary. - To remove a compensation category, select the line and choose the
remove button. - If you marked D, proceed with Importing payroll data from a spreadsheet
on page 157 or Importing payroll data from a word processing document on
page 158.
Otherwise, proceed with Creating a total compensation/ benefits summary
report on page 160.Importing payroll data from a spreadsheet
Payroll information can be imported if the import files are comma-
delimited and formatted as described in the following procedure.To import payroll data from a spreadsheet:
- Enter the following information in your spreadsheet:
Line 1 TITLELINE, (with no punctuation) in the first column; then a
header with the name of each type of compensation, such as Bonus 1Q,
Bonus 2Q, in the next columns.Lines 2 and continuing for as many as you need Employee
ID number, followed by the corresponding dollar amounts. Dollar
amounts must be in the 0.00 format, with no dollar signs or commas, as
in 1200.00.EXAMPLE:- Save the file with a .csv extension.
TITLELINE Header1 Header2 Header3
CS1100 200.00 500.00 500.00
EN1001 200.00 1100.00 500.00
PROD1600 100.00 1500.00 500.00