Extract data from Xero

Start moving your Xero data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Xero connector in the Weld documentation

contact_contact_status

Explore available Xero data

Browse all the data tables available for the Xero connector, in our interactive ERD data viewer.

View the Xero Data Schema

Transform and model Xero data

Get clean data models from your Xero data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Xero

raw.xero.table1

raw.xero.table2

Get started with Xero SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Xero.

Journal Entries Report

This template generates a report on journal entries from Xero, breaking down the data by year and month. It gives you a count of all journal entries and a count of individual journal lines for each journal entry within the specified periods.

Monthly Invoice Summary Report

This template generates a monthly invoice summary report from Xero, organizing the data by year and month. It details various invoice metrics such as the total number and amount of invoices, total tax, total amount due and paid, amount credited, and the number of unique contacts involved.

Invoice Entries Report

This template generates a report on invoice entries from Xero, breaking down the data by year and month. It gives detailed information on each invoice entry including various attributes such as invoice ID, description, quantity, and so on.

Tracking Details Report

This template generates a report that brings together tracking details from journal and invoice records, outlining essential details including source type, source ID, and financial particulars such as net and gross amounts, tax details, and tracking categories.

Monthly Sales Report

This template creates a monthly sales report by analyzing invoice data. It breaks down sales numbers and revenue per product/service and item code on a monthly basis, offering a clear view of how different offerings perform over time.

View all Xero templates