Billing and payment
how do i import timesheets via csv?
Timesheets can be import via a CSV file. Follow these fields in the exact order mentioned (for any optional fields, leave as blank):
Employee (Required): This field can be populated using the employee's Username, Payroll ID, Employee ID, or Employee Name. Microkeeper will attempt to match the record using any of these identifiers.
Date (Required) : The date for the timesheet entry.
Start Time (Required) : The beginning time of the work period.
End Time (Required) : The concluding time of the work period.
Location (Optional): The workplace location.
Role (Optional) : The specific role of the employee for that timesheet entry.
Job (Optional) : This can be identified by the JobID, Third Party ID, or Job Title. Microkeeper will attempt to match the record using any of these identifiers.
Break (Optional) : This field requires the break duration in minutes. Microkeeper will search for a selectable break rule with the same duration and apply it.
Note (Optional) : Any additional information or context you want to provide for that particular timesheet entry.
To upload formatted csv file navigate to Menu > Rosters > Timesheets > click the Import CSV button and select your CSV file.
If you're re-uploading data within the same date range that was previously imported via CSV, please be aware that any existing data within that range will be destroyed and replaced with the new CSV data.