Connecting Your Xero Account

Learn how to connect your Xero accounting account to enable data exports with CountingKit.

Overview

Connecting your Xero account allows you to export valuable accounting data to Google Sheets for analysis, reporting, and business intelligence. This integration enables you to track invoices, contacts, payments, bank transactions, and financial reports automatically.

Prerequisites

Before connecting your Xero account, make sure you have:

  • An active Xero account (any subscription level)
  • Admin or advisor access to your Xero organization
  • Connected at least one Google Sheet (see Configuring Google Sheets)

Connecting Your Xero Account

Follow these steps to connect your Xero account:

  1. Navigate to Connections

    From your dashboard, go to the "Connections" section and select "Xero" or click the "Connect" button if you haven't connected any Xero accounts yet.

  2. Initiate the Connection

    Click the "Connect Xero Account" button to begin the authorization process.

  3. Select Your Xero Organization

    You'll be redirected to Xero to authorize the connection. If you have access to multiple Xero organizations, you'll be asked to select which organization you want to connect.

  4. Authorize the Integration

    Review the requested permissions and click "Allow access" to proceed. You may need to log in to your Xero account if you're not already logged in.

  5. Confirm Connection

    After authorization, you'll be redirected back to our platform where you'll see a confirmation that your Xero organization has been successfully connected.

Note

The connection process requires admin or advisor permissions for your Xero organization. If you don't have the necessary access, you'll need to ask an administrator to complete this process.

Understanding Xero Permissions

When connecting your Xero account, you'll be asked to grant specific permissions. Here's what each permission allows us to do:

Permission What it allows Why it's needed
Read accounting data Access your accounting transactions and records To export invoices, bills, payments, and bank transactions
Read contacts Access your customer and supplier information To export contact details and relationship data
Read reports Access your financial reports To export Profit & Loss, Balance Sheet, and other financial reports
Read organization data Access your organization information To identify which Xero organization the data belongs to

Important

We only request read-only access to your Xero data. Our integration cannot modify your accounting records, create transactions, or make any changes to your Xero organization.

Managing Your Xero Connection

After connecting your Xero account, you can manage your connection from the Xero Integration dashboard:

Viewing Connection Details

The Xero Integration dashboard shows important information about your connected organization:

  • Organization name and tenant ID
  • Connection status
  • Organization details (legal name, tax number, country)
  • Connection date
  • Authorized scopes (permissions)

Connecting Multiple Organizations

If you have access to multiple Xero organizations, you can connect each one separately:

  1. Navigate to the Xero Integration dashboard
  2. Click the "Connect Another Organization" button
  3. Follow the authorization process again
  4. Select the organization you want to connect

Each organization will appear as a separate connection, allowing you to export data from multiple Xero organizations.

Reconnecting Your Organization

If you encounter connection issues or need to refresh your authorization, you can reconnect your Xero organization:

  1. Navigate to the Xero Integration dashboard
  2. Click the "Reconnect Account" button
  3. Follow the authorization process again

Reconnecting is useful if you've changed permissions in Xero or if your connection is experiencing issues.

Disconnecting Your Organization

To disconnect your Xero organization from the integration:

  1. Navigate to the Xero Integration dashboard
  2. Click the "Disconnect Account" button
  3. Confirm the disconnection when prompted

Warning

Disconnecting your Xero organization will delete all connected Xero services and any configured exporters. This action cannot be undone.

Troubleshooting Connection Issues

Authorization Failures

If you encounter issues during the authorization process:

  • Verify you have admin or advisor access to your Xero organization
  • Check if your Xero account has any restrictions or security settings that might block third-party connections
  • Try clearing your browser cache and cookies
  • Ensure you're not blocking cookies or pop-ups from Xero domains

Token Expiration

Xero access tokens can expire. If your connection shows as expired:

  • Use the "Reconnect Account" option to refresh the token
  • Check if Xero has made any changes to their API or permissions that might affect the connection
  • Verify that your Xero subscription is active and in good standing

Missing Organizations

If some of your Xero organizations aren't appearing:

  • Verify you have admin or advisor access to those specific organizations
  • Check if the organizations are active and in good standing with Xero
  • Ensure you're logged into the correct Xero account that has access to those organizations

Next Steps

After successfully connecting your Xero account, you can:

  • Configure Xero data exports (see Configuring Xero Exports)
  • Set up automated export schedules
  • Create custom reports in Google Sheets using your Xero accounting data
  • Connect additional data sources for comprehensive reporting

Related Documentation

Stop Manual Data Entry. Sync your Xero and QuickBooks data to Sheets and Excel today, free plan available.