Export straight into Sage 50
Map FlowRota shifts, overtime, roles, leave and absence to your Sage 50 payment codes, then generate a payroll-ready CSV using either FlowRota's calculated rates or rates already configured in Sage.
Turn rota data into clear reports and payroll-ready exports Custom CSV reports, Sage 50 mappings and workforce reporting
Generate a detailed view of employee hours, pay, overtime, TOIL, leave, absence and lateness for the teams and dates you choose — then turn that data into the payroll file your business actually needs.
Move from individual employee figures to team and location spend, build custom CSV reports with the fields and mappings your accounts team requires, or generate a Sage 50-ready export with configurable pay codes and rate handling.
included for £1 per user per month
See the numbers behind the rota without piecing them together by hand
FlowRota brings scheduled work and the records around it into a single reporting view. Each employee row can show money, hours, TOIL, leave, absence and lateness for the period selected. When the figures are ready, managers can export the standard report, build a custom payroll CSV from scratch or generate a Sage 50-ready file using their saved mappings.
One reporting area for the questions managers ask every month
Instead of exporting several disconnected lists, managers can move from the employee’s hours to the costs and exceptions that explain them.
Build custom payroll exports
Create CSV reports around the exact format your payroll or accounts team needs. Choose the data to include, arrange the fields and build reusable exports around your existing process.
Prepare payroll with less re-keying
Review pay values, tips, overtime and the hours behind them, then export them in the structure your payroll process expects.
Understand worked time
Separate total worked hours from regular, overtime, day and night hours.
Track TOIL movement
See time off in lieu earned and used during the selected period.
Explain leave costs
Break leave into paid, contracted, overtime and unpaid categories.
Spot attendance patterns
Review absence periods, shift absence, late starts and their paid or unpaid durations.
Compare where money is spent
Switch from employee-level figures to workforce spend by team or location.
Generate the report for the people and dates that matter
A useful report should answer a focused question.
FlowRota lets the manager narrow the dataset before generating it.
Filter first, then review the result
Select one or more teams, choose the employees to include and set the start and end dates. Month and year navigation makes it easier to move between reporting periods before using Generate.
Report controls- Select one or several teams
- Choose the employees included in the report
- Set a custom start and end date
- Move between months and years
- Regenerate after changing the filters
- Run a company-wide report or focus on one team
- Investigate a single employee without removing wider data
- Use the same view for weekly, monthly or custom periods
Understand pay totals and the hours that created them
The Hours & pay report keeps headline money values beside detailed time categories, helping managers investigate a result without jumping between separate screens.
Pay values
Start with the amounts most useful during a payroll review.
Available columns- Net pay
- Tips
- Overtime pay
- Costs shown beneath applicable hour totals
Benefit: Compare the overall value with the hours and pay categories that contribute to it.
Regular and overtime hours
Separate the employee’s ordinary worked time from additional paid overtime.
Available columns- Total hours from leave and shifts
- Total worked hours
- Total regular hours paid
- Regular 1x rate worked
- Total overtime hours paid
- Overtime 1.5x rate worked
Benefit: Make it easier to trace the difference between total time, regular hours and overtime.
Day, night and TOIL activity
See when paid hours were worked and how banked time changed during the reporting period.
Available columns- Paid day hours
- Night hours
- TOIL earned
- TOIL used
Benefit: Review less common pay and time categories without losing the employee-level context.
| Report group | Examples included | Management question |
|---|---|---|
| Money | Net pay, tips and overtime pay. | “What value is recorded for this employee and period?” |
| Worked time | Total worked, regular, overtime, day and night hours. | “Which types of hours created the total?” |
| Banked time | TOIL earned and TOIL used. | “How has the employee’s time-off balance moved?” |
Move from individual pay to team and location spend
Employee rows explain personal totals. The Team spend and Location spend tabs give managers a broader view of where workforce cost sits across the operation.
Team spend
Group workforce spend around the teams used to organise the rota.
Useful for- Comparing labour spend between teams
- Reviewing the cost of a department or operating area
- Investigating changes between reporting periods
- Giving team-level figures more context
Benefit: See which parts of the business are driving workforce cost.
Location spend
Organise spend around the places where employees are scheduled to work.
Useful for- Comparing sites or operating locations
- Understanding where paid work took place
- Supporting location-level cost discussions
- Reviewing multi-site staffing decisions
Benefit: Give multi-location managers a quicker route from rota activity to spend.
Three views, one reporting area.
Move between Hours & pay, Team spend and Location spend without
rebuilding the selected period.
Explain time away from work as clearly as time worked
Leave, absence and lateness can all affect hours and cost. Their own report columns make those differences visible instead of hiding them inside a single total.
Leave reporting
Separate the main leave categories recorded during the selected period.
Available columns- Total leave
- Paid leave total
- Contracted leave
- Overtime leave
- Unpaid leave total
Benefit: Understand how much time away was paid, unpaid or linked to a specific allowance category.
Absence and lateness reporting
Review both the amount of absence and the records that created the total.
Available columns- Total, paid and unpaid absence
- Absence periods and shift absence
- Late starts and total late duration
- Paid and unpaid late duration
- Absence quantity
Benefit: Find attendance patterns and check whether the recorded time was paid or unpaid.
Export straight into the payroll process you already use
FlowRota does not force every business into the same spreadsheet. Use the standard CSV, build a custom report around your own payroll format, or create a Sage 50-ready file with the mappings your accounts team has already defined.
Build the export around your payroll format
Create a custom report from scratch instead of rearranging a fixed spreadsheet after every payroll run. Choose the FlowRota data you need and map it into the fields and column structure your payroll, accountant or finance process expects.
- Choose the fields included in the export
- Build the CSV around your required column structure
- Map FlowRota data to the payroll fields you actually use
- Include the hours, pay, overtime, leave and absence data you need
- Avoid rebuilding the same payroll spreadsheet by hand
Generate a Sage 50-ready CSV with your mappings applied
Map FlowRota pay categories to the payment references used in your Sage 50 Payroll account. FlowRota can then produce a payroll-ready CSV with employee references, payment references, hours and rates already structured for your Sage import process.
- Map regular shift rates to Sage payment references
- Map overtime, roles, leave and absence separately
- Use employee references from your existing payroll records
- Choose whether FlowRota supplies the calculated rate or Sage applies its configured rate
- Keep payroll mappings consistent from one export to the next
Go from approved rota data to an import-ready file
Select the employees and reporting period, review the figures and choose the export format that matches the job. The result can be a detailed FlowRota report, a custom CSV built around your own accounting workflow, or a Sage 50 payroll export with your saved mappings applied.
Export workflow- Choose the teams, employees and date range
- Generate and review the current payroll data
- Select a standard, custom or Sage 50 export
- Apply the relevant field, pay-code and rate mappings
- Download the CSV for your payroll or finance process
- Reduce repetitive payroll data entry
- Keep exported values tied to the same FlowRota reporting period
- Fit FlowRota around your existing payroll process rather than rebuilding it
Get payroll-ready data without rebuilding another spreadsheet
Reporting becomes more useful when the totals remain connected to the scheduling, leave and attendance records that produced them — and the export already fits the payroll process waiting at the other end.
Faster payroll preparation
Review employee hours, pay categories and exceptions, then export them directly into a mapped payroll format.
Clearer cost conversations
Compare employee figures with spend organised by team or location.
Better exception checking
Bring overtime, TOIL, leave, absence and lateness into the same period review.
Less duplicated admin
Generate from FlowRota records and reuse mapped export formats instead of rebuilding payroll spreadsheets from scratch.
Follow the data back to the FlowRota features behind it
Reports are strongest when overtime, leave and attendance are recorded consistently. These pages explain the workflows that feed the wider workforce picture.
Frequently asked questions about FlowRota reports
What data is available in FlowRota reports?
FlowRota reports bring together employee pay values, worked hours, overtime, TOIL, leave, absence and lateness, alongside team and location spend views.
Can reports be filtered by team, employee and date?
Yes. Managers can select teams and employees, choose a date range and generate the report for the period they need.
Can FlowRota separate regular, overtime, day and night hours?
Yes. The hours and pay report includes regular and overtime hours, worked-rate columns, and separate day and night hour columns.
Does the report include pay, tips and overtime pay?
Yes. Employee rows can include net pay, tips and overtime pay alongside the hours and costs recorded for the selected period.
Can managers report on TOIL?
Yes. The report shows TOIL earned and TOIL used, helping managers understand changes to each employee’s banked time.
What leave data appears in the report?
Leave columns include total leave, paid leave, contracted leave, overtime leave and unpaid leave for the selected period.
What absence and lateness data can managers see?
Managers can review total, paid and unpaid absence, absence periods, shift absence, late starts, total late duration, paid and unpaid late duration, and absence quantity.
Can FlowRota show team and location spend?
Yes. Separate report views organise workforce spend by team and by location, alongside the employee-level hours and pay view.
Can a FlowRota report be exported?
Yes. Managers can export the standard generated report, build a custom CSV around the fields and structure their payroll process needs, or generate a Sage 50-ready CSV using their configured mappings.
Can I build a custom payroll report in FlowRota?
Yes. Custom CSV reports can be built around the data your payroll or accounts team needs. Choose the fields to include and map FlowRota data into the column structure your existing process expects.
Does FlowRota export to Sage 50 Payroll?
Yes. FlowRota can generate a Sage 50-ready CSV using employee references and mapped payment references. Shifts, overtime, roles, leave and absence can be mapped separately, and each mapping can use FlowRota’s calculated rate or the rate configured in Sage.
How much does FlowRota cost?
FlowRota costs £1 per user per month after a 30-day free trial. No credit card is required to start the trial. Visit the pricing page for full details.
Turn your rota data into payroll-ready reports
Build the schedule, record the exceptions and generate the payroll data your business needs — from detailed workforce reports to custom CSV layouts and Sage 50-ready exports. The trial is free for 30 days, no credit card is required, and continued access costs just £1 per user per month.
Start your free trial