When a workforce is split across departments (e.g. Drill, Blast, Maintenance), each department typically needs its own earnings rate in Xero. This guide explains how to structure your Dashpivot timesheets and Flowsite flows to route each department's hours to the correct earnings rate automatically.
How It Works
In Xero, tracking categories tag transactions for reporting but do not change which earnings rate the hours are posted to. To route hours to a specific earnings rate, the timesheet and flow must be set up per department.
Flowsite cannot conditionally route hours to different earnings rates based on a department value within a single timesheet. Each department requires its own:
Dashpivot timesheet template
Flowsite flow mapped to the correct earnings rates for that department
Setup
Step 1 — Create a timesheet template per department in Dashpivot
Create a separate Dashpivot workflow template for each department (e.g. Drill Timesheet, Blast Timesheet, Maintenance Timesheet). Employees submit the timesheet for their department only.
Step 2 — Set up earnings rates in Xero
Confirm that the correct earnings rates exist in Xero for each department and hour type (e.g. Ordinary - Drill, OT - Drill). Only earnings rates visible in the Xero Timesheets interface can be mapped in Flowsite.
Step 3 — Create a Flowsite flow per department
Create a separate Flowsite flow for each department's timesheet template. In each flow, map the hours columns to the earnings rates for that department only.
Step 4 — Tracking categories
If your organisation uses tracking categories to report payroll costs by department, keep them mapped in each flow. If department-level reporting is not needed, tracking category mapping can be removed.
Limitations
Conditional earnings rate routing is not supported. Flowsite cannot route hours to different earnings rates based on a department value within a single timesheet. A separate timesheet and flow per department is required.
One timesheet table per flow. All mapped columns must be in the same table within the timesheet template.
One flow per Xero tenant. If departments span multiple Xero tenants, a separate flow per tenant is also required.
Employee names must match exactly between Dashpivot and Xero. Use a dropdown list sourced from a Dashpivot List to reduce errors.
