Timesheets & payroll
Payroll export & integrations
Preview a pay-ready batch of approved hours and download it as a CSV that drops into Xero, Sage, BrightPay or QuickBooks — WagePilot hands clean hours and never runs the pay run itself.
WagePilot is not a payroll bureau — on purpose. It takes a clean, approved week and hands the hours to the payroll you already run. On this screen you pick a pay period, preview exactly what’s payable, and download a pay-ready CSV arranged for your software. You keep your payroll setup and your accountant; WagePilot just hands over accurate, approved hours.
Payroll export
Prepare a pay-ready batch of approved hours for your payroll software.
Period
Live auto-sync is coming soon. For now, prepare a pay-ready batch below (preview & download as CSV): exactly the figures your payroll needs, including holiday pay for leave taken and the 12.07% rolled-up line.
Summary for this period
Download a batch for your payroll software
Choose the pay period
The Period dropdown drives every figure on the page. Presets anchor to today and your organisation’s pay cycle:
- This pay period · Last pay period
- This week · Last week
- This month · Last month
- Week to last Friday · Last 7 days · Last 30 days
- Custom range… — reveals From and To date fields for any window.
Preview the summary first
A Summary for this period table sits above the providers — one row per person with hours, overtime, holiday pay, the 12.07% rolled-up line, tips, SSP and gross, plus a totals row. It’s the same read-off breakdown as the Timesheets ‘Payroll summary’ tab, and it counts approved hours only. Print / PDF gives you a clean sheet to key from by hand.
Prepare a provider batch
- 1
Pick your provider
Each of Xero, Sage, BrightPay and QuickBooks has a card. Tap Prepare batch.
- 2
Check the preview
A modal shows every person’s hours, overtime, gross and any tips, holiday pay, rolled-up 12.07% and SSP — with a totals row. Most columns only appear when there’s something to show — the 12.07% rolled-up column is always present.
- 3
Download the CSV
Download CSV arranges the figures into that provider’s own column layout (ordinary vs overtime hours, holiday and tronc split out) and saves a file named for the provider and period.
- 4
Import to payroll
Map the columns in your payroll’s import step and run pay as normal.
Providers
- Xero
- Ordinary and overtime hours as separate lines, ready to map onto your Xero pay items.
- Sage
- Pay-ready timesheets for Sage Payroll.
- BrightPay
- Approved hours arranged for BrightPay.
- QuickBooks
- Hours arranged for QuickBooks payroll.
What’s in the batch
Pay elements, split out
- Ordinary hours
- Approved paid hours at the normal rate.
- Overtime hours
- Reconciled weekly overtime, kept on its own line.
- Holiday pay
- Pay for leave actually taken in the period.
- Hol. 12.07%
- The rolled-up holiday uplift for irregular-hours / part-year staff, itemised separately.
- SSP
- Statutory Sick Pay, worked out from the sick leave you have recorded: paid from day one, for each of their working days that falls in the period, at the statutory weekly rate in force on the day (the lower of the flat rate or 80% of their normal weekly earnings), and stopped at 28 weeks per period of sickness.
- Tips (tronc)
- Tronc / tips, split out from wages.
- Gross & Total to pay
- Gross wages, and a true ‘total to pay’ whenever tips, holiday pay, rolled-up or SSP make it differ from gross.
Recent batches
A Recent batches card lists the last ten batches you prepared — provider, number of employees, the period, when it ran and the total gross — so you have a record of every export.