For teams that run on Planday
Planday labour cost report for every department
Planday shows payroll cost against revenue per department on its revenue page. Planday's own help also notes that comparing across several sites is something many managers still do by hand, from exports of the schedule, timesheets and payroll report.
How it goes today
- Export the timesheet report for each department.
- Export the payroll report for the same week.
- Copy the revenue figures from the revenue page.
- Join them in a spreadsheet and work out the wage percentage per department.
How it can go
Wage cost against revenue for every department, side by side, each Monday.
Every Monday one spreadsheet with a row per department: scheduled hours, worked hours, wage cost as Planday calculates it and revenue for last week, wage cost as a share of revenue, and your budget next to it where you enter one. The week before and the same week last year sit alongside, and the sheet lands in your inbox and in a shared folder.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. Planday works with a sign-in instead of a key: you sign in to Planday once to give access, never in the chat.
With Hypamoon, every Monday, take from Planday for each of our departments the scheduled hours, worked hours, wage cost and revenue for last week. Put them in one spreadsheet with a row per department, add wage cost as a share of revenue and our budget where we have one, next to the week before and the same week last year. Email it to me and the area managers.
An administrator creates an API app of your own in Planday under Settings, Integrations, API access, and authorises it once. Planday's help lists open API access on the Plus and Pro plans. It stays yours.
More for teams on Planday
- I want to know how many people are already off before I approve more leave.
- I want to know what needs fixing in payroll before I export it.
- I want to copy a schedule from one department to another.
- I want to get back the shifts I deleted by mistake.
- I want to import employees with more fields than the bulk import takes.
- I want my own employee fields next to the hours in the export.
- I want to carry over leave balances without editing each account.
- I want to set availability for my team in one go.
- Everything for Planday