Employment Hero connector

Use your Employment Hero data for reporting, automation and AI.

Data Panda pulls your Employment Hero employees, contracts, pay runs, leave and onboarding tasks into the same warehouse as your finance, sales and operations data. From one place we turn it into dashboards, automations, AI workflows and custom apps that HR, finance and team leads use during the month, not only the morning of a board meeting.

Data Panda Reporting Automation AI Apps
Employment Hero logo
About Employment Hero

An Australian-built HR, payroll and benefits OS for SMBs, with the KeyPay engine under the payroll module.

Employment Hero was founded in 2014 in Sydney by Ben Thompson, an employment lawyer, and Dave Tong, the CTO. The platform set out to give small and mid-sized businesses a single tool covering hiring, the employee record, contracts, payroll, leave, performance, learning, benefits and employee self-service, instead of a six-vendor HR stack glued together with spreadsheets. The company now operates across Australia, New Zealand, the United Kingdom, Singapore and Malaysia, and reports more than 300,000 businesses on the platform.

The payroll story is worth a sentence on its own. In February 2022, Employment Hero acquired KeyPay, a workforce-management and payroll platform that Ben Thompson had seed-invested in back in 2012. KeyPay has been the payroll engine inside Employment Hero ever since, and a follow-on acquisition of Employment Innovations the same year added Australian-market HR and payroll services on top. For a typical customer the modules in daily use are onboarding tasks, employee records and contracts, pay runs and leave, performance reviews and the employee self-service mobile app. Pulled into a warehouse next to Xero, NetSuite, HubSpot and Jira, that data finally answers the questions an Employment Hero report alone cannot: payroll cost per legal entity reconciled to the GL, hiring lead time per office, or onboarding completion versus first-90-day attrition.

What your Employment Hero data is for

What you get once Employment Hero is connected.

HR and workforce reporting

Headcount, payroll cost, leave and onboarding on one page across every legal entity and country.

  • Headcount and FTE per entity, department and country, against the approved plan
  • Payroll cost per legal entity reconciled with the GL each month
  • Onboarding completion and first-90-day attrition per cohort and manager

Process automation

Turn Employment Hero joiner, mover and leaver events into the downstream work the rest of the stack expects.

  • Provision identity and SaaS access the day a new hire signs in Employment Hero
  • Push KeyPay pay-run output into the GL per legal entity
  • Free SaaS seats and revoke access the moment a leaver record posts

AI workflows

Put the people record, pay runs and onboarding history behind AI that reads the full workforce picture.

  • Attrition-risk scoring on first-year hires using onboarding-task and leave signals
  • Pay-run anomaly detection across entities, named down to the variance line
  • Natural-language Q&A across employees, contracts, leave and policy library

Custom apps on your data

Lightweight tools on Employment Hero data for managers and group HR who should not need a full seat to read their own team.

  • Manager workbench with team headcount, open roles, leave balance and contract end dates
  • Group-finance cockpit with payroll cost per entity and overtime variance per location
  • Onboarding tracker with the tasks that consistently slip in each office
Use cases

Use cases we deliver with Employment Hero data.

A list of concrete reports, automations and AI features we have built on Employment Hero data. Pick the one that matches your situation.

Headcount and FTE reportingHeadcount and FTE per entity, department and country, reconciled with finance.
Payroll cost per entityKeyPay pay-run output rolled up per legal entity and matched to the GL each month.
Onboarding completionTime to complete onboarding tasks per cohort, manager and office.
First-90-day attritionLeavers within ninety days of start, joined to onboarding-task completion and team.
Leave patternsApproved leave per team, mapped onto delivery and on-call calendars.
Contract end-date watchFixed-term contracts coming up for renewal, by team and manager.
Hiring lead timeTime from job opened to offer accepted, per role family and recruiter.
Performance review trackingProgress of review cycles against plan, per manager and department.
Overtime varianceOvertime hours and cost per location, with the weeks above plan named.
Open-role agingRoles open past their target start date, by team and hiring manager.
Manager span of controlTeam size and direct-report count per manager across the org.
Multi-entity headcountGroup-level headcount split per legal entity, with intercompany transfers tracked.
Real business questions

Answers you will finally get.

What is payroll really costing us per legal entity, reconciled with the GL?

KeyPay pay-run output rolled up per legal entity, line items mapped to the right GL accounts and reconciled to the ledger each month. Group finance sees variance against budget and against last month per entity, instead of waiting for the consolidated payroll number to drop in week two of close.

How many of our recent hires finished onboarding before they left?

Leavers within ninety days of start joined to their Employment Hero onboarding-task completion, by manager, office and role family. Patterns surface fast: a specific office where the IT-access task waits two weeks, a manager whose first-90-day attrition is double the rest of the country.

Can we plan capacity against the actual leave calendar across countries?

Approved leave per team from Employment Hero joined to project plans, on-call rotations and delivery milestones across every country you operate in. Operations sees the weeks where capacity drops below plan in Sydney or London or Singapore, rather than three calendars opened in three tabs the morning of the planning call.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Group payroll cost per legal entity reconciled to the GL, with variance per office and per pay run named. You see which entities are tracking above budget before the consolidated close, not after.

For sales leaders

Quota coverage against the actual staffed sales team in each region, with ramp dates per rep. You see when an Australian or UK territory falls below coverage because a hire is delayed, weeks before the pipeline shows it.

For operations

Approved leave, onboarding completion and contract-end dates in one delivery picture per office. The capacity plan stops being three Employment Hero screenshots stitched together the morning of the planning call.

Ideas

What you can automate with Employment Hero.

Pair with Xero

Post KeyPay pay runs into Xero per legal entity

Each KeyPay pay run inside Employment Hero rolls into the right Xero ledger per legal entity, with line items mapped to the GL accounts finance really uses. Group finance sees payroll cost per entity reconciled the same day the run closes, instead of waiting for a manual journal in week two of close.

Pair with QuickBooks Online

Reconcile payroll into QuickBooks Online

Pay-run output from Employment Hero feeds the right QuickBooks Online accounts per entity, with overtime, leave loading and benefits costs split out instead of buried in one journal. The monthly close runs against numbers finance can trace back to a specific run and a specific employee group.

Pair with Exact Online

Roll group payroll into Exact Online

For a Belgian-headquartered group with subsidiaries on Employment Hero in the UK or APAC, the warehouse rolls those local pay runs into Exact Online at group level per legal entity. Group controlling sees the consolidated payroll number per entity in the same Exact view as the rest of the ledger, without anyone copying figures by hand.

Pair with HubSpot

Align sales-rep ramp and quota coverage

New hires and leavers in Employment Hero keep the HubSpot quota-coverage view in sync with the actual staffed sales team across each country, including ramp dates per rep. Revenue leaders see when an Australian or UK territory slips below target coverage because a hire is delayed or a leaver has not been replaced, weeks before the pipeline report catches it.

Pair with monday.com

Net project capacity against approved leave

Approved leave per assignee in Employment Hero nets out the working days available in monday.com plans, so project leads schedule against real capacity instead of a flat forty-hour assumption. Milestones that collide with a leave-heavy week in one office surface while there is still room to rephase, rather than in a post-mortem on why a delivery slipped.

Pair with Slack

Automate the team-announce moments

New hires, anniversaries and approved leave in Employment Hero drive the right Slack messages into the right channels: a welcome post on day one, an out-of-office note on the team channel, and a manager ping when an open role is past its target start date. HR stops running a weekly announcement queue by hand.

Pair with HiBob

Run a group HRIS picture across Employment Hero and Bob

Belgian or EU-headquartered groups often run HiBob at the European entities and Employment Hero at the Australian or UK subsidiaries. The warehouse joins both into a single people record so group HR sees one headcount, one onboarding-completion view and one leave calendar, instead of opening Bob and Employment Hero side by side and reconciling on a spreadsheet.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Employment Hero data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Employment Hero to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Employment Hero connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Where does payroll data live, in Employment Hero or in KeyPay?

Since the 2022 acquisition, KeyPay is the payroll engine sitting under the Employment Hero payroll module. The pay-run, payslip, leave-loading and tax-calculation tables originate in KeyPay and surface inside Employment Hero. Our connector reads the unified surface, so you do not need a separate KeyPay extract to reconcile a pay run to the GL.

How do we report headcount and payroll cost per legal entity?

Each Employment Hero organisation maps to a legal entity in the warehouse, and the employee, contract and pay-run records carry the entity key. Group HR and finance see headcount, payroll cost and overtime per entity reconciled against the GL, instead of a spreadsheet that lists Australia and the UK on separate tabs.

Does the connector cover the UK and APAC regions, not just Australia?

Employment Hero operates across Australia, New Zealand, the United Kingdom, Singapore and Malaysia. The connector reads the same employee, contract, leave, pay-run and onboarding-task surface regardless of region, so a Belgian group with subsidiaries on Employment Hero across these markets gets one consolidated record in the warehouse.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Employment Hero setup and the systems around it. Together we pick the first thing worth building.