Use Insights timesheet reports when you need staff time in Excel for payroll, finance or offline analysis. This is separate from the personal timesheet under Time.
Export a timesheet report
Open Insights.
Under Timesheets, open Timesheet Summary, Detailed Timesheet or Single Staff Timesheet.
Set the date range (and any staff or team filters you need). For Single Staff Timesheet, pick one person.
Select Export Excel.
Your browser downloads an .xlsx file for the filtered period.
Which report to use
Timesheet Summary: totals by person across earning rates and credits for the period. Useful for a compact payroll-style overview.
Detailed Timesheet: line-level detail for all matching staff in the period. Use this when you need the breakdown behind the totals across people. Excel is limited to under 60 days.
Single Staff Timesheet: one person’s time on the page and in Excel for any date range, including multi-year history (for example training and development). Defaults to the current calendar year. Excel has a Summary sheet and a Time Entries sheet. See How to use the Single Staff Timesheet insight.
Single Staff vs Detailed
Who: Single Staff Timesheet is one person. Detailed Timesheet mixes all matching staff.
Date range: Single Staff Timesheet allows any period, including several years. Detailed Timesheet Excel only allows a range shorter than 60 days.
Default dates: Single Staff Timesheet opens on the current calendar year. Detailed Timesheet follows its usual short default window.
Filters: Both support date range, team, staff and exclude contractors. Single Staff Timesheet picks one staff member only.
Leave columns with the same name
Detailed Timesheet labels leave as Leave: plus the leave type name. If two leave type records share a name, the export adds the Drum leave type id in brackets so the columns stay distinct. For the usual case after a manual leave type plus Xero import, an administrator can often heal the duplicate with Settings → Leave Types → Sync Leave Types. See If Detailed Timesheet shows two columns for the same leave type.
Detailed Timesheet Excel limit
For Detailed Timesheet, the Excel export only allows a date range shorter than 60 days. If the range is 60 days or longer, Drum blocks the download and asks you to shorten the dates. Split a longer period into smaller exports, use Timesheet Summary when you only need totals, or use Single Staff Timesheet when you need one person’s line detail over a longer history.
Access
You need Insights Staff access for these reports. If Timesheets is missing from Insights, ask an administrator to check your permissions.
Payroll and Xero
Drum does not push weekly timesheets into Xero Payroll for most accounts. The practical path for a payroll file is this Excel export. Leave that arrives from Xero (when leave import is enabled) is a separate flow from timesheet push. See the Xero synchronisation reference.