Skip to main content

Xero V2 Integration

Sync TidyHQ deposits to your general ledger in Xero.

Note: This app has limited places available!

The Xero integration allows TidyHQ to serve as a sub-ledger to Xero's general ledger.

Before you start: a matching bank account in Xero

You'll need at least one account in your Xero Chart of Accounts that is both:

  • Account type Bank (not any other account type), and

  • In the same currency as your TidyHQ account

Set this up in Xero first - the bank account dropdown during Configuration below will only show accounts meeting both criteria. If nothing appears in that dropdown, this is almost always why.

When payouts from Stripe reach your organisation's bank account, they'll be apportioned across Xero Accounts according to which TidyHQ Categories their payments belonged to.

Initial Setup

1. Go to Apps > Xero V2 > Add App:

2. Once the app has been added, click on Authorise Xero to proceed with connecting your Xero account:


Configuration

Click on the Configuration tab to choose a Xero bank account, to enable automatic sync, choose any Roles to notify, and finally to map Xero Accounts to TidyHQ Categories.

To select a bank account you'll need to have one appropriately set up already in Xero, as noted above - type "Bank" and matching currency.

By default, all Income Categories are mapped to the Xero account Sales - 200 and all Expense Categories are mapped to the Xero account Cost of Goods Sold - 310.

Once you're set, click Update Account Mapping to finalise your selections.


Syncing Transactions

Once you have completed the initial setup, we'll automatically sync Stripe payouts to Xero if configured.

In the Activity tab, click on Details for any Stripe Payout to view a breakdown:

You can also post "Direct Payments" from TidyHQ to Xero. ("Direct Payments" are those which were made with a bank transfer or paid in cash.)

Choose a date range of payments to sync, select one, more or all of the results, and click "Post to Xero" to proceed.

Previously-posted direct payments are also shown.


Reconciliation

Synced Stripe payouts will come through to Xero in a batch, aggregated by category. Each Direct Payment will come through as its own line item.

You can then reconcile items in Xero as normal.

Did this answer your question?