Using Basic CSV Timesheets

Aside from the pre-formatted Pay Group Excel and ESS / Direct Access timesheets, clients have the ability to import basic CSV format timesheets.

A timesheet file does not need to be generated, as the format is set within DataPay, so we can use an empty CSV file (e.g. from Excel)

Only three columns are used in this basic timesheet, and they must be in the correct order.

Employee Code   |   Component Code   |   Primary Input

For Example:

Primary input is the main piece of information a component uses. For a Payment this is the number or hours. For a generic allowance this would be a dollar value, however for a rateable allowance (e.g. Mileage) it would be the number of occurrences.

The first line of the timesheet file will not be imported regardless of whether it is occupied or not. You can enter column headings to make entering the data easier if you wish, however if you enter an employee into this row they will not be imported.

Any line with an employee code starting with “E” will also be skipped.

To import the timesheet, navigate to the Pay Run screen, right click on the target pay run and select Import Timesheet.

Change the timesheet file type to “CSV Basic – No Costing”, and then proceed with the import wizard as normal.

Note: The file name must start with the company code  e.g. '1234_bonus timesheet.csv'  If the company code is not present then the import will fail.