^
Login

Frequently Asked Questions

Authors
Category   API   Billing   Dashboard   Employee Access   Employee Management   Employee Settings   EOFY   Fingerprint Scanners   General   Glossary   Groups   HR   Jobs   Leave   Mobile App   Notification Config   Payroll   Payroll Deduction   Payroll Rules   Reports   Roster   Security   Settings   Skills Matrix   STP   Superannuation   Timesheet   VEVO   Xero

How to export timesheet data from Reports?

Author Dylan Wong@Microkeeper
Category Timesheet
Last Modified 28/05/2026

How to export timesheet data from Reports

Timesheet data can also be exported from the Reports page.

Navigate to Menu > Reports

Select the required reporting period, date range, pay cycles, and group.

Find Timesheet Export.

Select Export as... > CSV


Below is a breakdown of the Reports Timesheet Export CSV file

Column NameDescription
Employee NameThe employee's full name.
UsernameThe employee's Microkeeper username.
Payroll IDThe employee's payroll ID.
Employee IDThe employee's third-party employee ID, if applicable.
DateThe date of the timesheet entry.
Clock OnThe shift start time.
Clock OffThe shift end time.
Original OnThe original clock-on time before editing, if applicable.
Original OffThe original clock-off time before editing, if applicable.
Who Changed OnThe user who changed the clock-on time, if applicable.
Who Changed OffThe user who changed the clock-off time, if applicable.
Unpaid BreaksUnpaid break minutes calculated for the timesheet row.
Paid BreaksPaid break minutes calculated for the timesheet row.
HoursNet hours after unpaid breaks are deducted.
Job IDThe internal Microkeeper job ID linked to the timesheet entry.
3rd Party Job IDThe third-party job ID linked to the job, if applicable.
Job TitleThe title of the job linked to the timesheet entry.
Client IDThe client ID linked to the job, if applicable.
Client BusinessThe client business name linked to the job, if applicable.
Client ContactThe client contact name linked to the job, if applicable.
ApprovedThe approval status value recorded against the timesheet entry.
Who ApprovedThe user who approved the timesheet entry, if applicable.
Method OnThe clock-on method.
Longitude OnThe clock-on longitude, if GPS data is available.
Latitude OnThe clock-on latitude, if GPS data is available.
Accuracy OnThe clock-on GPS accuracy, if GPS data is available.
Method OffThe clock-off method.
Longitude OffThe clock-off longitude, if GPS data is available.
Latitude OffThe clock-off latitude, if GPS data is available.
Accuracy OffThe clock-off GPS accuracy, if GPS data is available.
NoteThe note or description recorded against the timesheet entry.


Note on breaks

The Reports Timesheet Export does not consolidate timesheet rows together for Break Rule application. This means that is two shifts are adjacent, such as 09:00-12:00 and 12:00-15:00, the Reports export will calculate Break Rules against each row separately rather than treating them as one joined shift. For timesheet data with consolidated shifts, please use the Timesheet page CSV export.

S2