Upload the raw system export. Two ready-to-use Excel files are produced automatically.
What does this tool do?
1
Strips the extra columns — the system export comes with columns after Amount (J) that are not needed for payroll. They are removed automatically.
2
Separates cleaners from non-cleaners — the tool checks the Cleaner Code column. Anyone whose code starts with "CL" is a cleaner. Anyone else (maintenance, admin, etc.) is moved to a separate tab in File 1 so they do not interfere with payroll calculations.
3
Calculates the pay for each job — adds columns K to P as live Excel formulas using the agreed pay rules. If you edit any data in the output file, the pay figures update automatically.
4
Produces two files at once. File 1 is all cleaners together (plus a separate tab for non-cleaners). File 2 is per-cleaner — choose which cleaners and which sheets to include before downloading.
Drop your raw system export here
or click to browse · .xlsx or .csv files
Pay calculation rules — columns K to P · amounts are editable and saved automatically
Col
Rule
K
Flags X if the same address on the same date has both a Regular Clean and a Checkout — catches potential double billing.
L
Base rate from the Tag column —
Small & Standard: ,
Large: ,
X Large: .
NRequired = nothing.
M
Checkout supplement — adds if the job type contains the word "Checkout".
N
Ensuite supplement — adds a further if it is a Checkout and the room type contains "Ensuite".
O
Original total — sum of L + M + N.
P
Final pay — uses column J if a specific amount was agreed, otherwise uses O.
Starting…
Processing complete
—
Total rows
—
Completed
—
Pending
—
Duplicates flagged
—
Cleaners
File 1
Full Processed Report
All cleaners together in one sheet with columns K–P as live Excel formulas. Column B green for Completed, red for Pending. Non-cleaners are separated into their own tab.
File 2
Individual Cleaner File
Select which cleaners and which sheets to include. Each cleaner has a job/pay tab and an adjustments template tab. You can generate a file for just one person if needed.
City Rooms · HR & Payroll
Staff Payroll Hub
Upload the four monthly payroll reports. The tool combines them into one Excel file — one summary sheet plus a full data tab for each report type.
🕐
Timesheets & Assignments
filename contains Timesheets
No file loaded
🤒
Sick Days
filename contains SickDays
No file loaded
🏖️
Holiday
filename contains Holiday
No file loaded
📅
Other Events
filename contains OtherEvents
No file loaded
Drop all four files here at once, or click to browse
You can also drop them one at a time — the tool detects each type automatically
Processing…
Combined report ready
Filter by department
Filter by person
City Rooms · Maintenance
Fixflo Dashboard
Upload the Fixflo All Issues CSV export. The dashboard analyses performance by agent with charts, tables, and preset views for manager, team, and director audiences.
Drop the Fixflo All Issues CSV here or click to browse
Each bar shows the total tickets assigned to that agent, split into four statuses: Closed (PM done), Awaiting Invoice (contractor side — not counted against PM), Reported (tenant submitted but PM not yet actioned), and Open (PM action required). Longer green = better.
Closure Rate % by Agent
Formula: (Closed + Awaiting Invoice) ÷ (Raised − Reported − Duplicates). The rate is never capped — a value above 100% means the agent closed more tickets than were raised in this period, i.e. they also reduced the backlog. The dashed line is the 90% team target. Green bar = at or above target, red = below.
Average Days to Close by Agent
Average number of days from ticket raised to ticket closed, broken down by priority. SLA targets: Emergency ≤ 1 day, Urgent ≤ 3 days, Non Urgent ≤ 10 days. Only closed tickets are included — open and pending tickets are shown in the open jobs table below instead.
Priority Breakdown by Agent
Total tickets per agent split by priority level: Emergency (priority 0), Urgent (priority 1–2), Non Urgent (priority 3–5). Useful for understanding each agent's workload composition and whether ticket volume is skewed towards high-priority issues.
Agent Performance Table
Open Issues by Priority & Agent
Avg Job Duration — Closed Jobs (days)
Avg Job Duration — Open Jobs (days since raised)
Team Overview
Issues Raised by Agent
Total number of tickets currently assigned to each agent in this dataset. This is a workload distribution view — it does not reflect performance on its own, but gives the team visibility of who is carrying the most volume.
Overall Status Breakdown
Proportion of all tickets across the whole team by status. Closed = resolved by PM. Open = PM still needs to act. Reported = tenant submitted, PM not yet progressed. Awaiting Invoice = job done, waiting on contractor paperwork — not a PM responsibility.
Closure Rate by Agent
Individual agent closure rates against the 90% team target (dashed line). Green = meeting or exceeding target. Red = below target and may need attention. Rate is capped at 100% for display; 100% can indicate backlog clearance from prior periods.
Priority Distribution — All Issues
Breakdown of all tickets in the dataset by priority level across the whole team. Gives a quick read on whether the current workload is dominated by routine maintenance (Non Urgent) or has an elevated number of high-priority issues requiring fast response.