--- title: "Connect Pigment with Xero" slug: "connect-xero" description: "Learn how to connect Xero with Pigment to import General Ledger data efficiently using filtering options for optimized performance." tags: ["General Ledger", "Importing Exporting Data", "Pigment Connector", "Xero Integration"] updated: 2026-01-09T13:26:34Z published: 2026-01-09T13:26:34Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # Connect Pigment with Xero ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(20).png) This article explains how to connect Xero with Pigment to retrieve Xero’s General Ledger data into a Pigment Block. As with all other native Pigment integrations, you’ll first need to configure a Connection in the Integration library page. Once configured, this connection can be used by any Application that is authorized as a data source. These authorized Apps are defined during the ‘Import Data’ configuration step. Now, let’s see how to configure and use this native integration! > [!WARNING] > **⚠️****Important** > > You need to be a [Pigment Workspace Admin](https://community.gopigment.com/getting-started-86/how-to-add-users-and-modify-account-types-in-pigment-286) to be allowed to configure the connector. ## Setting up the Xero Connector Within Pigment, navigate to the Integration page from your Workspace homepage, and click on **+ Add** on the Xero integration. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/6637019f-3680-46b9-b1f5-28b87f784ca1.png) The Xero connector uses the OAuth authentication system. Click **Set up a Connection** and then **Connect**. | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/7a66cdb3-fa99-4d6c-969a-faa9958493d8.png) | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/8bcdc633-a745-490f-91f6-df155fb3f245.png) | | --- | --- | | **Select the Organization** you want to connect with Pigment. Then click on **Allow access.** | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/7096b5d9-d9fb-435b-9c15-247976733ad8.png) | | --- | --- | | Next, fill the following fields: - **Name**: give a name to your connection (recommendation: add the tenant name in it) - **Application Access**: List the applications which will be allowed to use this connection - **Tenant:**select you the tenant want to connect with. | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/12257641-89d8-4c90-a294-7ac628574fa8.png) | | --- | --- | > ℹ️ **Note** > > Xero is a multi-tenant system, one account can have access to multiple organizations/tenants. If you want to connect with multiple tenants, you will need to configure one Pigment connection for each individual organization/tenant. ## Loading Xero’s data into Pigment Once the Xero Connection is configured, open an Application that the connection is available on and open the “Import Data” interface for the object you want to import data into. For example, if you were importing data into a Transaction List, you would open up the List and then select **Import and Download**and then**Import**. Instead of “Upload file”, select the Integration option. From here, select your Xero Connection. > [!NOTE] > ℹ️ **Note** > > If you do not see the connection, navigate back to the Integrations page, and verify that the Application is on the Application Access list. | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/9963c7a8-2572-48f7-b582-6c4fc651a857.png) | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/e3977ea9-7d3b-470e-b537-c52e07bb3c14.png) | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/15e1e94d-e01b-4490-b3f0-f97ef2762a33.png) | | --- | --- | --- | The connection enables loading two types of data from Xero: - **Journal/General Ledger** data from [Xero Journal API](https://developer.xero.com/documentation/api/accounting/journals#get-journals). For this data type you have several filtering options: - *Starting at Journal ID*: only retrieve Journals with an ID equal or higher than the provided one - *Ending at Journal ID*: only retrieve Journals with an ID equal or lower then the provided one - *Modified since*: only retrieve Journals which have been modified on or after the provided date - **Invoices** from [Xero Invoices API](https://developer.xero.com/documentation/api/accounting/invoices#get-invoices). For this data type there is a single filtering option: - *Modified since*: only retrieve Invoices which have been modified on or after the provided date All filters are optional: if you don’t specify any filter, by default Pigment will load all journal or invoice data. If you provide a only *some* filters, Pigment will take these into account and not filter based on the other options. Filtering is useful to limit the data loaded which can lead to performance improvements and overall more efficient and scalable imports. Xero has [fairly low limits](https://developer.xero.com/documentation/guides/oauth2/limits/) for daily API usage, so adding filtering can help you stay within Xero’s quota. Now you can just click on **Set up import** and continue through the standard import flow. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/45ccaa51-349d-4076-a10c-b1516ae1a6be.png) ### How do I find the Journal ID? Use the following steps from Xero to find the Journal ID. Run the report 1. In the **Accounting** menu, select **Reports**. 2. Find and open the **Journal Report**. You can use the search field in the top right corner. 3. Select a **Date range** or click the arrow next to the date to choose a set reporting period, for example: **This** **month** or **This quarter**. 4. Select any other options you want the report to show. 5. Click **Update**. Customize your report Use the settings and filters at the top of the report to customize it. - Choose which **Columns** appear on your report, such as **Account Code**, **Description** and **Journal ID**. - **Order by** either Journal date or Journal ID: - Journal date – the date on the transaction. For example, the payment date on a spend money transaction or the invoice date on an approved invoice. Transactions appear from oldest to newest. - Journal ID – the system ID assigned to the transaction. Transactions appear from newest to oldest based on when they were entered/posted in Xero.