How to Automate NDIS Payroll Export to Xero — Eliminating Double Entry

📅 May 2026⏱ 6 min read👤 CareIQ Team

Many NDIS providers run two systems: rostering and care management in one tool, payroll in Xero. Every fortnight, someone manually re-enters timesheet data from one system into the other. This double-entry process is time-consuming, error-prone, and unnecessary. A direct integration eliminates it entirely.

The Double-Entry Problem

A typical manual payroll process for an NDIS provider looks like this:

Export timesheets from the rostering tool as a CSV or PDF
Open Xero
Manually create pay runs, entering hours and rates per employee
Apply the correct earnings rates for each shift type (ordinary, afternoon, Saturday, etc.)
Review and approve

Step 3 and 4 are where errors accumulate. Manually entering hours for 20 employees across multiple shift types and penalty rate categories takes hours and produces mistakes. A wrong rate here, a missed overtime there — the underpayment liability builds invisibly.

How the CareIQ to Xero Integration Works

Once connected, the integration exports approved timesheets from CareIQ directly into Xero as pay run data. The mapping works as follows:

Each timesheet line in CareIQ (ordinary hours, afternoon penalty, Saturday, Sunday, overtime first tier, overtime second tier) maps to a corresponding Xero earnings rate
Employee records are matched by name or employee ID
The pay run is created in Xero in draft — ready for review and approval without manual re-entry

The integration is one-directional: CareIQ pushes approved timesheets to Xero. Xero handles the payment processing, bank file generation, and superannuation calculations.

Setting Up Earnings Rate Mapping

Before the integration goes live, each CareIQ shift rate type must be mapped to a Xero earnings rate. This is a one-time setup:

Create earnings rates in Xero for each SCHADS rate type (ordinary, afternoon, night, Saturday, Sunday, public holiday, overtime 1.5x, overtime 2x)
In CareIQ's Xero settings, map each CareIQ rate type to the corresponding Xero earnings rate ID

Once mapped, every future payroll export uses these mappings automatically. No per-pay-run configuration required.

What Gets Exported and What Stays in CareIQ

Data	Exported to Xero	Stays in CareIQ
Timesheet hours by rate type	✓	✓ (source of truth)
Employee earnings	✓	✓
NDIS invoices and billing	Can export as invoices	✓ (source of truth)
Clock events and attendance	✗	✓
Clinical notes and incidents	✗	✓
Participant records	✗	✓

Super, Tax, and Leave — What Xero Handles

Xero handles superannuation calculations, tax withholding (PAYG), leave accruals, and STP (Single Touch Payroll) reporting to the ATO. CareIQ provides the hours and rate types — Xero applies the financial calculations on top.

This division of responsibility is intentional: CareIQ specialises in care management and SCHADS payroll complexity; Xero handles the financial and statutory compliance side of payroll.

Approve timesheets in CareIQ, pay in Xero — no double entry

CareIQ's Xero integration exports approved timesheets with itemised SCHADS rate lines directly into Xero pay runs. 2-month free trial, no setup fee.

Start Your 2-Month Free Trial