For teams that run on Shiftbase
Shiftbase reports across locations, in one sheet
Shiftbase turns almost any data into a report you can export to Excel or CSV, one report at a time. Users who want their own figures across locations say they still pull the exports into a spreadsheet and combine them there.
How it goes today
- Run the timesheet report for last week and export it to Excel.
- Run the schedule report and the turnover report for the same week.
- Paste the exports into one spreadsheet, one tab per location.
- Add the week before by hand to see what changed.
How it can go
Your weekly numbers for each location, side by side, without the export.
Every Monday one sheet with a row per location and department: planned hours, worked hours, labour cost as Shiftbase calculates it, turnover and budget where you keep them in Shiftbase, and labour cost as a share of turnover. Next to it the week before and the same week last year. It goes to your inbox or a shared folder you choose.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Shiftbase key in the portal, never in the chat.
With Hypamoon, every Monday, make one sheet from Shiftbase with a row per location and department for last week: planned hours, worked hours, labour cost, turnover and budget where we enter them, and labour cost as a share of turnover. Put the week before and the same week last year next to it, and email it to me.
You create the Shiftbase API token yourself under Settings, App center, Public API. Shiftbase asks for the App Center Plus add-on on your subscription for this. It stays yours.
More for teams on Shiftbase
- I adjust the hours export by hand before it goes to payroll.
- I want to see who blocked off our busy days before I make the schedule.
- Our contracts run over two weeks, and I add up the hours myself.
- My people keep asking how many hours they still have to work this month.
- I want to know who changed what in the schedule since yesterday.
- Everything for Shiftbase