Our Xero integration allows you to sync transaction details and automatically create accounting records in Xero by assigning Xero GL (General Ledger) codes to transactions directly from your Mercury dashboard.
This integration only allows transaction information to be synced from Mercury to Xero. Any changes in Xero won’t sync back to Mercury.
Connecting to Xero from Mercury
- Go to Settings > Integrations and click Connect.
- Choose whether to sync historic transaction data or start from today’s transactions.
Once connected, Xero will appear as "Active" on your Integrations page. You can also disconnect the integration directly from your Integrations page at any time.
Applying Xero GL codes
Mercury customers who use Xero can categorize transactions and payments before they're reconciled in Xero. Once you connect to Xero, Mercury will automatically pull in your GL codes so you can apply them to transactions.
You can do this in a few different places:
- On your Transactions page, click open a Transaction to view the details and select from the GL code dropdown.
- If you’re creating a new payment manually or by uploading an invoice, select from the GL code dropdown as you’re setting up the payment details.
- If you want to add a category to an upcoming payment that was already scheduled, you can view the payment details on your Payments page and select from the GL code dropdown there.
- You sync incoming and outgoing transactions from your Accounting page.
- Once a transaction has been reviewed and the GL code selected, click the “Mark as ready” action icon.
- After marking any transactions that are ready, select “Sync to Xero” in the top right to sync the transactions to your Xero account.
- You can also update in bulk by utilizing the checkboxes on the left side of each transaction. Select the transaction(s) you want to action, then choose either “Mark as Ready” or “Edit GL Code” from the action bar that pops up at the bottom. For even quicker bulk actions, try holding the shift button and selecting a transaction to also select all the transactions above it.
Accounting record details
The type of accounting record created, the timing of the sync, and the data included will vary with each transaction type.
Frequently asked questions
Is the integration with Xero free to use?
Yes! Our Xero integration is free to use. Learn more about pricing.
What types of transactions can have GL codes applied to them?
Mercury users can categorize incoming and outgoing wires, ACH transfers, and checks. The only transaction types currently excluded are transfers, IO payments, and Treasury transactions.
Why can’t I categorize transfers, IO payments, and Treasury?
Transfers and IO payments are categorized automatically by our system and/or Xero. Treasury transactions are not yet available in the integration, but are coming soon.
If I create a recurring payment in Mercury, will the GL code apply to all future transactions?
Yes, the GL code you assign to the first payment will be automatically assigned to all future payments in the series.
If I make changes in Xero to a transaction, will those be reflected in my Mercury account?
No, the connection is a one-way sync. Transaction information is passed from Mercury to Xero, and any changes in Xero won’t pass back to Mercury.
Can I edit a GL code on the Transactions page?
Yes, you can edit a transaction’s GL code, notes, and attachments on the Transactions page.
What types of transactions are included in the bank feed sync?
Most incoming and outgoing transactions are included in the bank feed sync. The only transaction types currently excluded are Treasury transactions.