Exporting Pay Period Data
Plantrunner lets you export timesheet data from a pay period for use in your payroll system. Three export formats are available.
Export formats
Payroll Summary
A high-level summary aggregated by employee. Best for getting a quick overview of hours.
Includes:
- Employee name
- Approved hours
- Pending hours
- Rejected hours
- Total hours
- Timesheet entry count
Time Detail
Line-by-line detail of every timesheet entry. Best for detailed record-keeping.
Includes:
- Employee name
- Date
- Hours
- Status (pending, approved, rejected)
- Customer
- Location
- Notes
QuickBooks Time Activities
A format compatible with QuickBooks time import.
Includes:
- Name
- Date
- Customer
- Hours
- Notes
- Billable flag
info
The QuickBooks export only includes approved timesheets. Pending and rejected entries are excluded.
Exporting a pay period
- Navigate to Pay Periods
- Find the period you want to export
- Click Export
- Select the export format
- A CSV file is downloaded
Best practices
- Approve entries before exporting -- Review and approve/reject all pending timesheets before exporting to ensure your payroll data is finalized
- Close the period -- Closing a pay period prevents further edits, locking in the data before export
- Keep exports -- Save exported CSVs as records alongside your payroll documentation
Workflow
A typical payroll processing workflow:
- Pay period ends
- Admin reviews and approves/rejects all pending timesheets
- Admin closes the pay period
- Admin exports the CSV (choose format based on your payroll system)
- Import the CSV into your payroll system
- Mark the pay period as Paid after processing