Skip to main content

How to Route Timesheet Hours to Department-Specific Earnings Rates in Xero Using Flowsite

Learn how to set up Dashpivot timesheets and Flowsite flows so that each department's hours post to the correct earnings rate in Xero automatically.

Written by Nina Yang

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.

Did this answer your question?