Connect Xero to Pigment and plan from actuals
Bring Xero general ledger journals and invoices into Pigment through a native connector, so budgets, forecasts, and entity reporting start from the numbers in your books. Built for Finance leaders and consolidation teams who want planning and reporting tied to Xero actuals without manual exports.

Xero
Import Xero General Ledger journals and invoices into Pigment to plan and report from your accounting actuals
Category
Integration method
Best for
Financial planning · Budget vs actuals · Multi-entity reporting
What can you do with Xero and Pigment?
- Run budget vs actual variance analysis. Load the latest Xero journals into a Transaction List and explain variances against the plan from one dataset, with each figure tracing back to a Xero journal.
- Refresh actuals after month-end close. Import only journals modified since your last load, so the reforecast reflects the closed month without reloading history.
- Assemble group actuals across entities. Import journals from each Xero organization into one Pigment Application to prepare entity-level figures for consolidation review.
- Review billing next to the ledger. Import Xero invoices alongside journals so Finance leaders see invoice activity where they plan cash.
How the Xero integration works
A Pigment Workspace Admin sets up the connection by signing in to Xero, selecting the organization to connect, and allowing access. They name the connection and choose which Applications can use it. Each Xero organization needs its own connection. On the target Block, such as a Transaction List, users then open Import Data, choose Integration, pick the Xero connection, and select journals or invoices.
Key capabilities
- Pick the data each model needs. Choose general Ledger journals or invoices for each import, depending on whether you need actuals or billing activity.
- Load an exact range of journals. Set starting and ending Journal IDs to import a defined block you can match to Xero's Journal Report.
- Skip records you've already loaded. Apply the Modified since filter to journals or invoices to bring in only what changed and stay within Xero’s daily API limits.
- Restrict access to approved Applications. Only a Workspace Admin configures the connector, and each connection’s Application Access list sets which Applications can import from it.
- Connect with your Xero login. A Workspace Admin signs in to Xero and allows access for each organization, and Pigment uses that authorization for imports.
Frequently Asked Questions
What Xero data can I import into Pigment?
You can import 2 types of data: general Ledger journals through the Xero Journals API and invoices through the Xero Invoices API. Journals support Starting at Journal ID, Ending at Journal ID, and Modified since filters. Invoices support Modified since, and all filters are optional, so leaving them blank loads all journal or invoice data.
Can I connect more than one Xero organization?
Yes. Xero is multi-tenant, so one Xero account can access several organizations, and you create one Pigment connection per organization. Pigment recommends including the tenant name in each connection's name so teams can tell entities apart.
Can finance stakeholders see Xero actuals without a Xero login?
Yes. A Workspace Admin authorizes Xero once when creating the connection, and the imported data lives in a Pigment Block. Stakeholders then work with those actuals in Pigment, based on their Pigment access rights.
Does Pigment change any data in Xero?
No. The connector imports journals and invoices into Pigment and doesn’t write anything back to Xero.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis