For teams that run on PlanMill
PlanMill reporting: project figures in one sheet
PlanMill has more than 200 standard reports, custom reports through its service desk, and a BI data connector that sends CSV files to your own file server after a workshop and a setup pack. A reviewer on G2 wished the reports were more flexible for detailed and general overviews.
How it goes today
- Run the project, hours and invoicing reports in PlanMill one by one.
- Export each report to its own spreadsheet.
- Paste them together and fix the project names that do not match.
- Do it again next week when someone asks for fresh numbers.
How it can go
Hours, billing and budget per project land in one sheet you keep using.
Every morning a sheet or dataset is filled from PlanMill with per project the reported and billable hours, the budget and forecast cost, the invoiced amount and the open work. Standard PlanMill reports you already use can be pulled in as well. Your own dashboard or spreadsheet reads from that one place, and you choose the columns. Figures follow PlanMill as of that morning.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. PlanMill first switches on access for your company when you ask them, which can take a few business days. After that you create the key yourself and paste it in the portal, never in the chat.
With Hypamoon, fill a sheet every morning from PlanMill with per project: reported and billable hours, budget and forecast cost, invoiced amount and open work. Add the PlanMill reports we pick. Keep the column names fixed so our own dashboard can read it.
PlanMill first switches on the API add-on for your company. After that a power user gives an API user the right role and registers a client under People, My Page, Registrations, which gives a client ID and secret. It stays yours.
More for teams on PlanMill
- Our accounting system is not on PlanMill's list, so invoices go over by hand or as a file.
- Hours, leave and overtime go to payroll as an export each month, because our payroll system has no PlanMill connector.
- Accepted expense claims we type into the accounting system by hand, and then set to paid in PlanMill.
- Each new employee we create by hand in PlanMill, with role, team, manager and capacity calendar.
- A deal we win in our CRM we create again in PlanMill as customer, project and sales order.
- Everything for PlanMill