Process transactions using 'Spreadsheet Input'.  Select what Employee Masterfile information to come through automatically and which transaction codes to process.  In the example below we selected employee code and first name to come through and two overtime codes for processing, as illustrated:

Once the data has been processed the information will be posted to the Payslip Input.  The spreadsheet format, above, can be used over and over again.

The steps required to setup and process a spreadsheet are as follows:

STEP 1 - Spreadsheet Formats

Create/ Name a spreadsheet format.  Press 'Insert' to add a new format.

STEP 2 - Spreadsheet Fields

When a spreadsheet format is created the employee code is automatically inserted onto the spreadsheet as the first 'Spreadsheet Field' or spreadsheet column heading.  This can be deleted if it is not required.

Press 'Insert' to add more columns to the spreadsheet.  Select whether the field/ column is to be 'Employee data' from the employee masterfile, or 'Transaction Data' being a transaction code to be processed.

STEP 3 - Spreadsheets

Process transactions.  This is done by pressing the 'Process' button.  The spreadsheet created will load.  Insert the data required, as illustrated above.  When all the data has been entered onto the spreadsheet this can be updated to the Payslip Input by pressing the 'Post' button.  Spreadsheet data can be changed at any time, even after being posted.  The changed data will be re-posted.