All Hours lets you export payroll data to a CSV file that you import directly into your payroll software. You set up the export once to match the requirements of your payroll software, and then download it in a few clicks for each payroll run.
Setting up the export
Go to Settings › Payroll › Settings. On the Payroll settings page, set the options below and confirm them with Save.
1. Export type
Default – suitable for most payroll software.
Grad ERP – adapted for import into Grad ERP.
2. User payroll ID field
Your payroll software identifies employees by codes that must match the codes in All Hours. Select the field in All Hours that holds the code: Id or one of the custom fields (Custom Field 1, 2, 3 …). Use a custom field if you already use the Id field for something else.
You enter the code in the user’s profile on the General tab, in the Custom Fields section. To enter codes for many users at once, import them from a CSV file (Adding, importing and updating users).
3. Format
Show user per line – each employee is on a separate line and the payment types are in columns.
Show counter per line – each payment type of each employee is on a separate line (employee code, payment type code and value).
The same employee is highlighted in both examples. Show counter per line:
Show user per line:
4. Delimiter option
Select comma (,) or semicolon (;), depending on the requirements of the software you import the file into.
5. Payroll data
Here you define the payment types included in the export. Each line links a payroll ID to an All Hours counter that tracks, for example, attendance, vacation, sick leave or overtime. The payroll ID must match the payment type code in your payroll software.
Click Add new line.
Enter the Payroll Id, for example 0596.
Under Counter value, select the counter that fills this value, for example Physical presence.
Click Save.
Repeat this for every payment type you want to export. To change the order of the lines, drag a line to the desired position. If the counter you need does not exist yet, create it first (Creating daily counters).
6. Length of values
Some payroll software requires values to always have the same number of digits. If you set the length to 3, a value of 0 is exported as 000, a value of 1 as 001 and a value of 555 as 555. The length does not affect decimal places: when decimals are selected, All Hours always exports two decimal places.
7. Export duration as
You can export durations with two decimal places, using a decimal point or comma. If you do not need decimals, export hours without minutes, hours and minutes in HH:MM format, or the value in minutes.
8. Export days as
Counters that count instances or days with instances have whole numbers instead of hours and minutes. You can set these values to be exported in the same decimal format as durations.
Downloading the export
Go to Reports › Payroll List Export.
Click View in the upper right corner. A preview opens with the values for all configured payment types. The preview shows employee names in addition to the codes, but the names are not included in the CSV file.
Click Download in the upper right corner and import the file into your payroll software.