Running a childcare center requires two separate software universes: your Childcare Management System (CMS) (which handles child enrollments, attendance, daily bookings, and CCS claims) and your Accounting Software (which manages bank feeds, expenses, and payroll).
Syncing these two systems is critical. If done poorly, you face endless manual double-entry, missing gap fees, and reconciliation chaos. Here is a guide on how to cleanly integrate platforms like OWNA, Xplor, Kangarootime, or QikKids with Xero.
1. The Right Sync Philosophy: Daily Summaries vs. Individual Invoices
A common mistake is syncing every single parent invoice (which can be hundreds per week) directly into Xero as individual invoices. This bloats your Xero database, slows down search queries, and makes bank reconciliation a nightmare.
Recommended Approach: Daily Sales Summary
Instead, configure your CMS integration to push a Daily or Weekly Sales Summary to Xero:
- Sales Income: The total gross fees charged (pre-CCS).
- CCS Subsidy Portion: The amount paid directly by the government.
- Parent Co-payment (Gap Fees): The amount debited from parents.
- Cleared Funds Account: Match the daily summary ledger with the bank feed payouts from your payment gateway (e.g., DebitSuccess, Ezidebit).
2. Reconciling CCS Receipts in Xero
Services Australia deposits Child Care Subsidy (CCS) payments directly into your bank account as bulk sums, often daily or weekly.
- Reconciliation Rules: Do not code these deposits directly to a standard "Revenue" account. Instead, map them to a CCS Clearing Liability Account.
- Clearing Balance: The CMS sync should post a journal entry moving the matching amount from the Clearing Account to Fee Revenue once the session reports are approved. This ensures your balance sheet accurately tracks what CCS funding is still pending or disputed.
3. Integration Setup Checklist
Before clicking "Connect" in your CMS dashboard, ensure you have set up the following in Xero:
- Childcare-Specific Chart of Accounts: Separate your revenue codes (e.g., Fee Revenue - Under 3s, Fee Revenue - Over 3s, OSHC Fee Revenue).
- Payment Clearing Accounts: Create asset/liability accounts for payment gateways (e.g., Ezidebit Clearing) to handle timing differences between parent debits and actual bank deposits.
- Tracking Categories: If you operate multiple centers under one Xero file, set up Tracking Categories to easily run separate Profit & Loss statements for each location.
Need Expert Integration Setup?
Integrating a CMS with Xero requires a deep understanding of clearing accounts, timing differences, and GST rules (childcare fees are GST-free in Australia).
If you want your integration configured correctly the first time, our partner team at Childcare Bookkeeper specializes in Xero setups for CMS platforms like OWNA, Xplor, Kangarootime, and QikKids. Let them handle the setup so your data flows seamlessly. Contact them at childcarebookkeeper.com.au.