1 month free trial. Every feature, your whole team, no card needed
ClockinBeeSign in
Pay and payroll

Export hours and time off to payroll

Download approved hours, overtime and time off in the layout your payroll system imports.

ClockinBee does not run payroll. It prepares what your payroll system needs, in the file layout it imports, so nothing is retyped.

Set up once

  1. Open Export to payroll.
  2. Type the name in Find your system, for example Sage, and open it. Choose Show all systems (the button shows how many) to browse.
  3. Choose Add, then under Settings enter the pay codes or account codes exactly as they are in your payroll system.
  4. Choose Save settings.

Each pay period

  1. Open Export to payroll. It opens on your last finished pay period: use Previous, Current and Next to change it.
  2. Check the totals. If time is still waiting, choose Go to approvals first.
  3. Under Your payroll systems, choose Download. Some systems also have Send now.
  4. Import the file into your payroll system as usual.

What is in the file

  • Regular, overtime, Sunday and public holiday hours for each person.
  • Time off days by type.
  • Employee numbers, so your payroll system matches the right people.
  • Pay rates, only if the person exporting can see pay.

Only approved time is included unless you tick Include time not approved yet under Change dates, or include time not approved yet. Once a file is sent, the weeks in it show as Exported (sent to payroll or accounting). Every download is listed under Recent activity.

Tip. Run one sample import in your payroll system before your first real pay run.

Where to find it

Export to payroll

Who has it: People with the Reports and exports permission. If it is not in your menu, your role does not include it.

Open Export to payroll Opens the app. You may be asked to sign in first.

If something goes wrong

Nothing to export for this period.
No approved time or time off falls in these dates. Approve the timesheets or choose Change the dates.
My payroll system rejects the file.
Check the pay codes under Settings match exactly, and that everyone has an Employee number on their page in Team (Add it in Team).
My system is not listed.
Search for Excel / Google Sheets for a plain file any system can read, and contact us with the import template you need.
There is no Download button.
Downloading files needs the Reports and exports permission.

Related articles

Still stuck?

Tell us what you were trying to do and a person will reply.

Contact support
Export hours and time off to payroll · ClockinBee