Integrating Dashpivot Timesheets with Xero helps reduce manual data entry, improve payroll consistency, and streamline timesheet management. Using Flowsite, approved timesheet data from Dashpivot workflow templates can be automatically transferred into Xero Timesheets.
This guide explains how the integration works, supported configurations, limitations, and best practices for managing Xero timesheets effectively.
Benefits of integrating Dashpivot Timesheets with Xero
Automated payroll workflows – Transfer approved timesheet data directly into Xero.
Reduced manual entry – Minimise payroll administration and data entry errors.
Improved payroll consistency – Standardise employee timesheet processing across projects and teams.
Flexible timesheet structures – Support individual and team-based timesheets.
Support for earnings categories – Map ordinary hours, overtime, allowances, and additional earnings categories into Xero.
General Features and Limitations
Workflow Templates Only - The integration is only supported for Dashpivot Workflow Templates. Other form types are currently not supported.
Earnings Rates - Flowsite only shows earnings rates that are visible in the Xero Timesheets interface — not every rate in Xero Payroll Settings. For a pay item to appear in the Flowsite mapping, it must be set up correctly in Xero so it shows on a Xero timesheet. See Troubleshooting below if a rate exists in Xero but doesn’t appear in Flowsite.
Employee Names - Employee names in Dashpivot must exactly match employee names in Xero to avoid sync errors.
Example Error: Failed to fetch employees from XeroLeading and trailing spaces are ignored, but spelling and formatting must remain consistent.
Timesheet Tables - Only one timesheet table is supported per flow.
For workflows containing multiple tables:
Consolidate hours into one table, or
Create separate Flowsite flows per table
Form Revisions
If submitted timesheet data needs to be revised, the workflow approval column must be reverted and approved again.
This action creates a new Flowsite run.
Tracking Items
Tracking Items are optional but must be mapped within the same table as the timesheet data.
Supported Pay Cycles
Currently supported pay cycles include:
Weekly
Fortnightly
Monthly
Other pay cycles may result in Flowsite runs remaining in a pending status.
Note: Each employee in Xero may have different payroll calendars configured.
Multiple Timesheets in the Same Pay Period
If a timesheet already exists in Xero for the same pay period, the integration can either:
Overwrite the existing timesheet, or
Combine entries into the existing timesheet
Timesheet Types and Behaviour
The integration supports both individual and team-based timesheets across daily, weekly, fortnightly, and monthly frequencies.
Individual Timesheets
Individual timesheets are triggered when the form is signed.
Features include:
Daily and weekly entries can roll up into weekly, fortnightly, or monthly Xero timesheets.
Employee names can be mapped from:
The Created By field, or
A dropdown list field
For weekly timesheets, the date must be mapped within the same table as the timesheet data.
Team Timesheets
Team timesheets are also triggered when the form is signed.
Features include:
Daily and weekly entries are rolled up into employee-specific Xero timesheets.
Employee names must be mapped from a table column in the same table as the hours input.
Dropdown list fields are recommended to minimise spelling errors.
All employees included in the same team timesheet must share the same payroll calendar in Xero.
For weekly timesheets, the date must be mapped within the same table as the timesheet data.
Date Handling and Supported Formats
Dates are a critical part of the integration and support the following formats:
Plain Date Fields
Recommended for simplicity and reliability.
Template Configurations
Timezone-Aware Date Fields
Used when timezone-specific tracking is required.
Formula-Constructed Dates (for Tables)
Dates can also be created using formulas provided they follow ISO date formatting:
YYYY-MM-DDTHH:mm:ss.sssExample formula:
=TEXT([Reference cell], "YYYY-MM-DDTHH:mm:ss.sssZ")Hours Breakdown and Earnings Categories
Each Xero Earnings Category requires its own mapped table column within the same timesheet table.
Flowsite formulas can also be used to automatically calculate earnings category values where required.
Allowances are supported provided the table input is numeric.
Best Practices
Export employee names from Xero and upload them into a Dashpivot List to reduce matching errors.
Use plain date fields wherever possible.
Confirm overwrite settings before importing timesheets into Xero.
Ensure all employees in team timesheets use the same payroll calendar.
Keep all mapped timesheet fields within the same table structure.
Use dropdown lists for employee names and activity selections to improve consistency.
Troubleshooting
An earnings rate or allowance exists in Xero Payroll Settings but doesn’t appear in Flowsite
Flowsite only shows pay items that appear on a Xero timesheet. A pay item can exist in Xero Payroll Settings without being available on timesheets. Common reasons:
Type of Units mismatch — the pay item’s Type of Units must match the employee’s ordinary earnings rate (for example, Hours). If they don’t match, the rate won’t appear on the timesheet and won’t be mappable in Flowsite.
Fixed Amount rate type — allowance pay items set up with a Fixed Amount rate type can’t be entered on Xero timesheets. These won’t appear in Flowsite.
Bonuses and Commissions — these pay item types can’t be entered on Xero timesheets at all.
Allowance column is not numeric — allowances require a numeric table column in the timesheet table. A text or formula column won’t map correctly.
To fix it, check the pay item’s setup in Xero Payroll Settings and confirm the Type of Units and rate type meet Xero’s requirements. See Xero’s timesheet troubleshooting guide for Xero’s own documentation.
An earnings rate was recently added or changed in Xero but still doesn’t appear in Flowsite
Try disconnecting and reconnecting your Xero connection in Flowsite to force a refresh of the available pay items. If the issue persists, check the pay item’s setup in Xero Payroll Settings.
Employee name mismatch error
Employee names in Dashpivot must exactly match names in Xero. Leading and trailing spaces are ignored, but spelling and formatting must be consistent. Export employee names from Xero and upload them as a Dashpivot List to reduce errors.



