If your church keeps its books in Xero, you do not have to type gifts and bills in twice. Churchease offers two ways to get them into Xero. The Xero connection sends every settled gift and every paid expense to Xero automatically each night. The Export for Xero file is a CSV you download and import yourself, and it works on any plan with no connection.
What each option can and cannot do
| Xero connection | Export for Xero (CSV) | |
|---|---|---|
| Plan | Church Accounting (Growth plan) | Any plan with Fund Report |
| How | Nightly, automatic, plus a Sync now button | You download a file and import it in Xero |
| Gifts | Settled gifts become Received bank transactions | Settled gifts are positive lines |
| Expenses | Expenses marked Paid become Spent bank transactions | Approved expenses are negative lines |
| Voided gifts | Removed from Xero on the next sync | Left out of the file |
| Account codes | Your chosen default income and expense accounts | A blank Account Code column you fill in Xero |
| What it changes in Churchease | Nothing | Nothing |
Things neither option does, so you are not surprised:
- Nothing comes back from Xero. Invoices, bills or bank lines created in Xero do not appear in Churchease.
- No invoices or bills. Everything arrives as a bank transaction on one bank account, ready to reconcile against your bank feed. If you need bills with due dates, keep raising them in Xero.
- No tax. Lines are sent with no tax type. Gifts are not taxable; if an expense needs GST or VAT, edit the line in Xero.
- No fund tracking in Xero. Each fund's name is in the line description, not a Xero tracking category.
- Pending bank gifts wait. A gift paid by bank transfer that has not settled is not sent until it settles.
- Unpaid expenses wait. An expense that is approved but not yet marked Paid is not sent until it is.
- Reconciled lines cannot be removed. If you void a gift in Churchease after its line was reconciled in Xero, Xero refuses the removal. The card tells you, and you remove or reverse the line in Xero by hand.
Who this is for
The treasurer or bookkeeper: a Super Admin, an Admin, or anyone with the Church Accounting role.
Before you start
For the connection:
- The Growth plan, or Church Accounting on your plan.
- Your Xero login, with permission to connect apps to the organisation.
- Decide which Xero bank account gifts are deposited to and expenses are paid from, and which income and expense accounts to use by default.
For the CSV: nothing. Open Fund Report.
Option 1: Connect Xero
- Go to Communications, then Integrations.
- On the Xero card press Connect to Xero. Sign in to Xero, choose your organisation and press Allow access. You come back to Integrations.
- Press Set up on the Xero card and choose:
- Bank account in Xero: the account your giving lands in and expenses leave from.
- Income account for gifts and Expense account: the accounts lines are coded to.
- Send records dated from: nothing older than this day is sent. It defaults to the first of this month, so connecting never floods Xero with history you already have.
- Press Save.
- Press Sync now to send what is already in Churchease, or wait for the nightly run at 3:45 am Eastern time.
Option 2: Export for Xero
- Go to Church Accounting, then Fund Report.
- Set the Start Date and End Date and press Run Report.
- Press Export for Xero. A CSV downloads and a line under the buttons tells you how many lines it holds.
- In Xero go to Accounting, Bank accounts, open the account, Manage account, Import a statement.
- Upload the file. When Xero asks you to match columns, use Date, Amount, Payee, Description and Reference, and choose the date format DD/MM/YYYY.
You'll know it worked when…
Connection:
- The Xero card reads Connected to your organisation name, shows the bank account and the Sending from date.
- After a sync, Last sync shows the time and how many gifts and expenses were sent, and how many voided gifts were removed.
- In Xero, Accounting, Bank accounts, your account, Account transactions lists each gift as Received with the giver's name, and each paid expense as Spent with the vendor's name, on the right dates.
CSV:
- Xero accepts the file with no row errors and the statement lines appear ready to reconcile.
If something goes wrong
- "Xero is not switched on for this Churchease environment yet." Churchease has not finished its Xero setup. Contact support; use Export for Xero meanwhile.
- "Xero sync is part of Church Accounting on the Growth plan." Your plan does not include Church Accounting. Export for Xero still works from Fund Report.
- "The Xero sign-in took too long." You have ten minutes from pressing Connect. Press Connect to Xero again.
- "No Xero organisation was shared." On Xero's screen, choose an organisation before pressing Allow access.
- Last sync says some records were rejected. The card shows Xero's reason for the first one. Common causes: the chosen bank account was archived in Xero, or an account code no longer exists. Fix it in Xero or press Set up to choose different accounts, then Sync now. Rejected records are retried on every sync.
- A voided gift is still in Xero. Its line was already reconciled. Unreconcile or reverse it in Xero; Churchease cannot remove a reconciled line.
- A gift is missing in Xero. Check that it is dated on or after the Sending from date, that it has settled, and that it is not voided.
- Disconnecting. Press Disconnect and confirm. Churchease stops sending. Everything already in Xero stays there.
Related articles
- Reading the Fund Report
- Voiding a gift and the audit trail
- Marking an expense as paid