Skip to main content

Introduction to the Xero integration

Spend less time doing accounting work by automatically reconciling payments and transactions from Frello to Xero

Written by Jade Perkins

Our Xero integration allows you to push financial data from transactions and payments into Xero, resulting in easy and seamless account reconciliation.

Once set up, you can simply manage all transactions and payments in Frello as usual and let the synchronisation process take care of the rest.

Frello will automatically create invoices and payments in Xero on either a daily, weekly or monthly basis. All Frello transaction types can be mapped onto specific Xero accounts, including liabilities like deposits and account credit.

Read on to find out how the integration works, or dive straight into setting up your Xero integration.

How the integration works

The Frello Xero integration currently synchronises the following:

  • Paid transactions from Frello are pushed to Xero as paid invoices.

  • Corresponding payments recorded in or made through Frello are pushed to Xero as payments and mapped against the relevant clearing accounts.

The following diagram illustrates the flow of data:

  1. Automatic or manual transactions are created in Frello.

  2. Invoices for these transactions can be downloaded from Frello.

  3. Once a transaction is paid online by a member or marked as paid by an admin, payments are recorded for these transactions in Frello.

  4. Receipts for these payments can be downloaded from Frello.

  5. Transactions are synchronised to Xero, which creates paid invoices in Xero mapped against your nominated revenue or liability accounts.

  6. Payments for these invoices are recorded against your clearing accounts.

  7. Members pay either through Frello or using an alternative method.

  8. Once the money is in your bank, you can reconcile the payouts against the correct clearing accounts, or create a bank rule to automate this.

Still confused? Have a look at some common reconciliation examples.

What the Xero integration doesn’t do

Please be aware of the following limitations:

  • We don’t create separate customer accounts for each one of your members in Frello. To view a detailed financial summary of individual members or to view their individual invoices, you can use the Finance modules in Frello.

  • We don’t let you manage your Xero tax rates through Frello, and will use what you have already setup or fall back to the defaults of your country.

  • We don’t feed back information from Xero into Frello, so if you receive payments via bank transfer, you’ll still have to tick off the transaction as paid in Frello manually.

Keep an eye on this page, as we’re constantly improving our integrations and adding support for new workflows.

Next steps

Did this answer your question?