Xero Integration

​

Overview

The Xero integration allows you to connect your Xero accounting organisation to InvestSync, enabling automatic syncing of your chart of accounts and mapping of investments to Xero accounts for accurate accounting reconciliation.

​

Key Features

​

Getting Started

​

Prerequisites

Before connecting Xero, ensure you have:

• A Xero account with at least one organisation
• Admin or advisor access to the Xero organisation you want to connect
• An active InvestSync organisation

​

Connecting Xero

​

Chart of Accounts Sync

​

Automatic Sync

When you connect Xero, InvestSync can automatically sync your chart of accounts. This feature can be enabled or disabled in the integration settings.

​

Manual Sync

You can manually trigger a sync at any time:

1. Navigate to Settings > Integrations > Xero
2. In the Chart of Accounts section, click “Sync Now”
3. Wait for the sync to complete (this may take a few moments depending on the number of accounts)

​

Sync Details

The sync process retrieves and stores:

• Account Code: Xero account code
• Account Name: Full account name
• Account Type: Asset, Liability, Equity, Revenue, Expense, etc.
• Status: Active or Archived
• Description: Account description if available
• Bank Account Details: Bank account number and type (for bank accounts)
• Currency: Account currency code
• Tax Settings: Tax type and reporting codes
• Additional Metadata: Payment settings, expense claim settings, class, and more

​

Viewing Synced Accounts

To view your synced accounts:

1. Navigate to Settings > Integrations > Xero
2. The Chart of Accounts section shows:
   • Total number of accounts synced
   • Last sync timestamp
   • Auto-sync toggle status

​

Account Mapping

Account mapping allows you to link your InvestSync investments to specific Xero accounts for accounting purposes. This is essential for accurate financial reporting and reconciliation.

​

Mapping Types

InvestSync supports three types of account mappings:

• TAX: Maps investments to tax-related accounts (e.g., income tax payable)
• CAPITAL_GAINS: Maps investments to capital gains accounts
• UNREALISED_GAINS: Maps investments to unrealised gains accounts

​

AI-Powered Mapping Suggestions

InvestSync uses AI to suggest appropriate account mappings:

​

Manual Mapping

You can also create mappings manually:

1. Navigate to Settings > Integrations > Xero > Map Accounts
2. In the mapping table, select an investment
3. Choose the appropriate Xero account from the dropdown
4. Select the mapping type (TAX, CAPITAL_GAINS, or UNREALISED_GAINS)
5. Save the mapping

​

Filtering Mappings

The mapping interface allows you to filter by mapping type:

• All Mappings: View all investment-to-account mappings
• Tax Mappings: View only tax-related mappings
• Capital Gains Mappings: View only capital gains mappings
• Unrealised Gains Mappings: View only unrealised gains mappings

​

Account Configuration

In addition to investment mappings, you can configure default accounts for:

• Tax Account: Default account for tax-related entries
• Capital Gains Account: Default account for realised capital gains
• Unrealised Capital Gains Account: Default account for unrealised gains

These settings are found in the Configure Accounts step of the mapping wizard.

​

Integration Settings

​

Auto-Sync Chart of Accounts

Toggle this setting to automatically sync your chart of accounts when:

• The integration is first connected
• Accounts are updated in Xero (future feature)

​

Sync Status

The integration page displays:

• Connection Status: Active, Inactive, or Error
• Connected Organisation: Name of the connected Xero organisation
• Connected On: Date when the integration was established
• Last Synced: Timestamp of the most recent chart of accounts sync
• Accounts Synced: Total number of accounts in your chart of accounts

​

Managing the Integration

​

Viewing Connection Details

Navigate to Settings > Integrations > Xero to view:

• Connection status and badge
• Connected Xero organisation name
• Connection date and last sync time
• Data sync configuration status

​

Disconnecting Xero

To disconnect your Xero integration:

1. Navigate to Settings > Integrations > Xero
2. Click “Disconnect Xero” in the Actions panel
3. Confirm the disconnection in the dialog

​

Reconnecting

If you need to reconnect or switch to a different Xero organisation:

1. Disconnect the current integration (if connected)
2. Follow the connection steps above to connect a new organisation

​

Troubleshooting

​

Connection Issues

Problem: Cannot see any Xero organisations after authorisation Solution:

• Ensure you have access to at least one Xero organisation
• Check that you’re logged into the correct Xero account
• Try disconnecting and reconnecting

Problem: “Session expired” error Solution:

• The OAuth session may have timed out
• Disconnect and reconnect the integration
• Ensure cookies are enabled in your browser

​

Sync Issues

Problem: Chart of accounts sync fails Solution:

• Check that your Xero integration is still active
• Verify you have the necessary permissions in Xero
• Try disconnecting and reconnecting if the issue persists
• Contact support if the problem continues

Problem: Accounts not appearing after sync Solution:

• Check the sync status and last sync timestamp
• Try manually triggering a sync
• Verify that accounts exist in your Xero organisation
• Check that accounts are not archived in Xero

​

Mapping Issues

Problem: AI suggestions seem incorrect Solution:

• AI suggestions are based on name matching and account types
• Review and manually adjust any incorrect suggestions
• You can always create mappings manually if needed

Problem: Cannot find a specific Xero account in the dropdown Solution:

• Ensure the account exists in your synced chart of accounts
• Try syncing the chart of accounts again
• Check that the account is not archived in Xero

​

Security & Permissions

​

OAuth2 Authentication

InvestSync uses OAuth2 to securely connect to Xero:

• No passwords are stored
• Tokens are encrypted and stored securely
• Automatic token refresh ensures continuous access
• Tokens can be revoked at any time

​

Required Permissions

The integration requires the following Xero scopes:

• openid profile email: Basic user information
• accounting.transactions: Read and write access to transactions
• accounting.settings: Read access to settings and chart of accounts
• accounting.reports.read: Read access to reports
• offline_access: Allows token refresh without user interaction

​

Data Privacy

• All data synced from Xero is stored securely in InvestSync
• Data is encrypted in transit and at rest
• Only authorised users in your organisation can access the integration
• You can disconnect at any time to stop data syncing

​

Best Practices

​

Current Limitations

• Bank Transactions: Bank transaction syncing is planned but not yet available
• Invoices & Bills: Invoice and bill syncing is planned but not yet available
• Real-time Updates: Chart of accounts sync is manual or on-connect only (automatic updates coming soon)
• Multiple Organisations: Only one Xero organisation can be connected per InvestSync organisation at a time

​

Future Enhancements

Planned features for the Xero integration:

• Automatic bank transaction syncing
• Invoice and bill synchronisation
• Real-time chart of accounts updates
• Support for multiple Xero organisations per InvestSync organisation
• Automated journal entry creation
• Transaction reconciliation tools

​

Need Help?

If you encounter issues or have questions:

• Review the troubleshooting section above
• Check your Xero organisation permissions
• Contact support at [email protected]