Reports and payroll
Absence by person and department, everyone’s allowance, and the payroll export with the two files Sage 50 Payroll imports.
Reports, in the menu under your initials, has Time off's reports. Administrators and Owners see everyone; a manager sees the people they approve. Each report downloads as a CSV for a spreadsheet.
Absence
Absence shows approved leave between two dates you choose, a row per person and a column per leave type anyone had, in working days. Part-time days off and bank holidays aren't counted, as on the wallchart. Sickness shows its days and how many spells. Narrow it to a department with Department. The dates are in the page's address, so you can bookmark a report you run often.
Allowances
Allowances shows each person's allowance for the leave year that includes today: what they have, what they have taken so far, what is booked ahead, what is pending, and what remains.
The payroll export
Payroll export is for whoever runs payroll (Administrators and Owners). It covers one pay period: the calendar month, or up to a cut-off day each month if your payroll runs that way. Use the arrows to move between periods, then Export this period. Each export is kept with its files, so you can download them again and show what payroll was sent; exporting the same period again unchanged gives the same files.
An export has three files:
- Absence (CSV): a row per person per kind of absence, in days and hours, with sickness spells, anyone who started in the period, and anyone who left with the holiday they still had to take.
- Sage 50: payments and Sage 50: deductions: the files Sage 50 Payroll imports. Paid leave goes as hours against a payment, unpaid leave as hours against a deduction, each by the reference you gave it in Sage.
To load them into Sage 50 Payroll, choose File › Advanced Data Import, then Employee Payments (Hours and Rates) for the payments file and Employee Deductions (Hours and Rates) for the deductions file. Save the column map the first time and load it after. Sage can't import absences, so enter sickness in its absence diary from the absence file; Sage works out SSP from there.
Setting it up
- Settings → Time off → Payroll: the pay period, and for each leave type what it sends to Sage (a payment, a deduction, or nothing) and its reference in Sage. Sickness sends nothing by default.
- Each person's payroll reference: on their page under People, Edit, then Payroll reference under Leave. It must match Sage's Employee Reference exactly ("0054" isn't "54"). Anyone with time to send but no reference is left out of the Sage files, and the export page names them.