Skip to main content

Reporting Guide

Create, customize, and automate reports to keep stakeholders informed and support data-driven decisions.

Report Categories

Pre-Built Reports

Ready-to-use reports organized by category:

Labor Reports

ReportDescription
Hours SummaryTotal hours by employee for period
Overtime ReportOvertime hours and associated costs
Labor CostHours multiplied by pay rates
Hours by DepartmentBreakdown by team
Hours by LocationBreakdown by site

Attendance Reports

ReportDescription
Attendance SummaryPunctuality and presence overview
Late ArrivalsEmployees who clocked in late
Early DeparturesEmployees who left early
Absence ReportMissed shifts and no-shows
Attendance TrendsPatterns over time

Scheduling Reports

ReportDescription
Schedule SummaryPublished schedule overview
Coverage ReportStaffing vs. requirements
Open ShiftsUnfilled shifts
Schedule ChangesModifications made
Compliance ReportActual vs. scheduled

Time-Off Reports

ReportDescription
PTO BalancesCurrent balances by employee
Time-Off RequestsAll requests with status
Upcoming Time OffApproved future absences
PTO UsageHistorical time-off data
Accrual ReportPTO earned over period

Payroll Reports

ReportDescription
Payroll ExportHours formatted for payroll
Timesheet SummaryApproved timesheets
Pay Period ReportComplete period breakdown
Adjustments ReportManual time entries

Running Reports

Basic Report

  1. Go to Reports from sidebar
  2. Select report category
  3. Click desired report
  4. Choose date range
  5. Click Run Report
  6. View results

Filtered Reports

Add filters for targeted data:

  1. Select a report
  2. Click Add Filter
  3. Choose filter type:
    • Location
    • Department
    • Position
    • Employee
    • Status
  4. Select filter values
  5. Run report

Comparison Reports

Compare two periods:

  1. Select a report
  2. Enable Compare Periods
  3. Select primary date range
  4. Select comparison date range
  5. Run report
  6. View side-by-side with variance

Custom Reports

Creating Custom Reports

Build reports tailored to your needs:

  1. Go to Reports > Custom Reports
  2. Click + New Custom Report
  3. Name your report
  4. Select data source:
    • Time and Attendance
    • Scheduling
    • Employees
    • Time Off
  5. Choose fields to include
  6. Set default filters
  7. Choose visualization
  8. Save report

Field Selection

Available fields by data source:

Time and Attendance Fields

FieldDescription
Employee NameFull name
Employee IDUnique identifier
Clock In TimePunch-in timestamp
Clock Out TimePunch-out timestamp
Total HoursCalculated duration
Regular HoursNon-overtime hours
Overtime HoursOT hours
Break TimeTotal break duration
DepartmentEmployee's department
LocationWork location
PositionJob role

Scheduling Fields

FieldDescription
Shift DateScheduled date
Start TimeShift start
End TimeShift end
Scheduled HoursPlanned duration
Actual HoursHours worked
VarianceDifference
Shift StatusFilled, open, etc.
Assigned EmployeeWho's scheduled

Grouping and Sorting

Organize report data:

Group by:

  • Employee
  • Department
  • Location
  • Day/Week/Month
  • Position

Sort by:

  • Any selected field
  • Ascending or descending
  • Multiple sort levels

Calculated Fields

Add computed values:

  1. In custom report builder, click Add Calculated Field
  2. Name the field
  3. Define formula:
    • Sum
    • Average
    • Count
    • Difference
    • Percentage
  4. Add to report

Report Visualization

Choose how data displays:

TypeBest For
TableDetailed data
SummaryAggregated totals
Bar ChartComparisons
Line ChartTrends
Pie ChartDistribution

Scheduled Reports

Setting Up Schedules

Automate regular reports:

  1. Open any saved report
  2. Click Schedule
  3. Configure delivery:
SettingOptions
FrequencyDaily, Weekly, Monthly
DaySpecific day for weekly/monthly
TimeDelivery time
FormatPDF, CSV, Excel
RecipientsEmail addresses
  1. Save schedule

Frequency Options

FrequencyBest For
DailyOperational monitoring
WeeklyTeam reviews
Bi-weeklyPay period alignment
MonthlyManagement reporting

Managing Schedules

View and modify scheduled reports:

  1. Go to Reports > Scheduled
  2. See all active schedules
  3. Click to edit or delete
  4. View delivery history

Pause or Cancel

  1. Find scheduled report
  2. Click Pause to temporarily stop
  3. Click Delete to remove permanently

Exporting Reports

Export Formats

FormatUse Case
PDFSharing, printing, archiving
CSVImport to spreadsheets
ExcelAdvanced analysis

Export Steps

  1. Run your report
  2. Click Export
  3. Select format
  4. Choose scope:
    • Current page
    • All data
    • Summary only
  5. Download file

Batch Export

Export multiple reports at once:

  1. Go to Reports > Batch Export
  2. Select reports to include
  3. Choose date range (applies to all)
  4. Select format
  5. Generate package
  6. Download ZIP file

Sharing Reports

Share via Email

  1. Run report
  2. Click Share
  3. Enter email addresses
  4. Add message (optional)
  5. Choose to attach or link
  6. Send
  1. Save report
  2. Click Share > Get Link
  3. Set permissions:
    • View only
    • Can export
    • Can edit
  4. Copy link
  5. Distribute to recipients

Report Access

Control who sees reports:

Access LevelPermissions
PrivateOnly you
TeamYour team members
DepartmentYour department
OrganizationAll users

Payroll Integration

Payroll Export

Verify Before Exporting

Always confirm that all timesheets are approved before running a payroll export. Unapproved hours will not be included in the export, which could result in employees being underpaid.

Generate payroll-ready data:

  1. Go to Reports > Payroll
  2. Select Payroll Export
  3. Choose pay period
  4. Verify hours are approved
  5. Select export format:
    • Standard CSV
    • ADP format
    • Paychex format
    • QuickBooks format
    • Custom mapping
  6. Export

Export Mapping

Configure field mapping for your payroll system:

  1. Go to Settings > Integrations > Payroll
  2. Select your provider
  3. Map fields:
    • Employee ID → Payroll ID
    • Regular Hours → REG
    • Overtime Hours → OT
  4. Save mapping
  5. Use for all exports

Report Templates

Saving Templates

Save report configurations:

  1. Configure a report
  2. Click Save as Template
  3. Name template
  4. Set as personal or shared
  5. Use for future reports

Using Templates

  1. Go to Reports > Templates
  2. Select template
  3. Adjust date range if needed
  4. Run report

Compliance Reports

Retention Requirements

Compliance reports such as audit trails and time record changes should be exported and archived according to your organization's data retention policy. Many jurisdictions require keeping time records for 3 to 7 years.

Audit Trail

Track all system actions:

  1. Go to Reports > Audit
  2. Select date range
  3. Filter by:
    • User
    • Action type
    • Record type
  4. View complete audit log

Time Record Changes

Document all modifications:

  1. Go to Reports > Compliance > Time Changes
  2. See all manual edits
  3. Includes who, when, what changed
  4. Export for records

Tips

  • Run labor reports weekly for cost control
  • Schedule management summaries monthly
  • Export payroll reports same day each period
  • Save frequently-used reports as templates
  • Set up alerts for anomalies
  • Keep compliance reports for required retention period