Xero
Xero
SourceUse Dataddo's Xero connector to explore any data available via the official API of Xero. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.
DATA FIELDS
Explore Data You Can Extract from Xero
Data Category
- All Attributes (535)
- Accounts (14)
- Balance Sheet (8)
- Balance Sheet Monthly (7)
- Bank Transactions (26)
- Bank Transfers (11)
- Batch payments (15)
- Contacts (13)
- Credit notes (15)
- Employees (5)
- History invoices (9)
- History payments (9)
- Invoice Line Items (34)
- Invoice Payments (26)
- Invoices (18)
- Items (16)
- Journal Lines (21)
- Journals (5)
- Journals with Tracking (21)
- Linked Transactions (11)
- Manual journals (8)
- Organizations (3)
- Overpayments (18)
- Payments (18)
- Prepayments (18)
- Profit and Loss (7)
- Profit and Loss by Tracking Category (13)
- Projects (35)
- Purchase orders (18)
- Quotes (21)
- Quotes Line Items (31)
- Reports - Aged Receivables Summary (14)
- Reports - Bank summary (10)
- Reports - Budget summary (17)
- Tenants (5)
- Tracking categories (4)
- Trial Balance (11)
Need fields you don't see?
Let us know and we'll add them to the connector. Just send a request here..
Available Attributes (535)
| Attribute |
|---|
AccountID Account ID |
Code Code |
Name Name |
Type Type |
TaxType Tax Type |
EnablePaymentsToAccount Enable Payments To Account |
BankAccountNumber Bank Account Number |
BankAccountType Bank Account Type |
CurrencyCode Currency Code |
ReportingCode Reporting Code |
ReportingCodeName Reporting Code Name |
Status Account Status |
Description Description |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName ReportName |
Item Balance Sheet Item |
OpeningBalance Opening Balance |
ClosingBalance Closing Balance |
DateStart Date Start |
DateStop DateStop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName ReportName |
DateStart Date Start |
DateStop DateStop |
OpeningBalance Opening Balance |
ClosingBalance Closing Balance |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
ContactName sensitive Contact Name |
ContactID Contact ID |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
LineItemDescription Line Item Description |
LineItemUnitAmount Line Item Unit Amount |
LineItemTaxType Line Item Tax Type |
LineItemTaxAmount Line Item Tax Amount |
LineItemLineAmount Line Item Line Amount |
LineItemAccountCode Line Item Account Code |
LineItemQuantity Line Item Quantity |
LineItemID Line Item ID |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
CurrencyCode Currency Code |
BankTransactionID Bank Transaction ID |
BankAccountAccountID Bank Account Account ID |
BankAccountCode Bank Account Code |
BankAccountName Bank Account Name |
Type Type |
Reference Reference |
IsReconciled Is Reconciled |
LineItemTracking Line Item Tracking |
XeroTenantID Xero Tenant Id |
BankTransferID Bank Transfer ID |
Date Date |
CreatedDate Created Date |
FromBankAccountId From Bank Account ID |
FromBankAccountName From Bank Account Name |
ToBankAccountId To Bank Account ID |
ToBankAccountName To Bank Account Name |
Amount Amount |
FromBankTransactionID From Bank Transaction ID |
ToBankTransactionID To Bank Transaction ID |
XeroTenantID Xero Tenant Id |
AccountID Account ID |
Reference Reference |
BatchPaymentID Batch Payment ID |
Date Date |
InvoiceID Invoice ID |
HasErrors Has Errors |
IsDiscounted Is Discounted |
PaymentID Payment ID |
PaymentReference Payment Reference |
PaymentAmount Payment Amount |
Type Type |
Status Status |
TotalAmount Total Amount |
IsReconciled Is Reconciled |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactStatus Contact Status |
AccountNumber Account Number |
Name sensitive Name |
FirstName sensitive First Name |
LastName sensitive Last Name |
EmailAddress sensitive Email Address |
SkypeUserName Skype User Name |
BankAccountDetails Bank Account Details |
TaxNumber Tax Number |
AccountsReceivableTaxType Accounts Receivable Tax Type |
AccountsPayableTaxType Accounts Payable Tax Type |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName sensitive Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
CurrencyCode Currency Code |
Type Type |
CreditNoteID Credit Note ID |
CreditNoteNumber Credit Note Number |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
XeroTenantID Xero Tenant Id |
EmployeeID Employee ID |
Status Status |
FirstName sensitive First Name |
LastName sensitive Last Name |
XeroTenantID Xero Tenant Id |
Id Id |
Status Status |
ProviderName Provider Name |
Changes Changes |
Date Date |
User User |
Details Details |
InvoiceID Invoice ID |
Id Id |
XeroTenantID Xero Tenant Id |
Status Status |
ProviderName Provider Name |
Date Date |
Changes Changes |
User User |
Details Details |
PaymentID Payment ID |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName sensitive Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
UpdatedDate Updated Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
LineItemDescription Line Item - Description |
LineItemQuantity Line Item - Quantity |
LineItemUnitAmount Line Item - Unit Amount |
LineItemItemCode Line Item - Item Code |
LineItemAccountCode Line Item - Account Code |
LineItemID Line Item - ID |
LineItemTaxType Line Item - Tax Type |
LineItemTaxAmount Line Item - Tax Amount |
LineItemLineAmount Line Item - Line Amount |
LineItemDiscountRate Line Item - Discount Rate |
LineItemDiscountAmount Line Item - Discount Amount |
LineItemTrackingName Line Item - Tracking - Name |
LineItemTrackingOption Line Item - Tracking - Option |
LineItemTrackingCategoryID Line Item - Tracking - CategoryID |
XeroTenantID Xero Tenant Id |
LineAmountTypes Line Amount Types |
XeroTenantID Xero Tenant Id |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName sensitive Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
PaymentAmount Payment - Amount |
PaymentBatchPaymentID Payment - Batch Payment ID |
PaymentCurrencyRate Payment - Currency Rate |
PaymentDate Payment - Date |
PaymentHasAccount Payment - Has Account |
PaymentHasValidationErrors Payment - Has Validation Errors |
PaymentID Payment - ID |
PaymentReference Payment - Reference |
InvoiceID Invoice ID |
XeroTenantID Xero Tenant Id |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName sensitive Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
XeroTenantID Xero Tenant Id |
ItemID Item ID |
Code Code |
Description Description |
PurchaseDescription Purchase Description |
UpdatedDate Updated Date |
PurchaseDetailsUnitPrice Purchase Details Unit Price |
PurchaseDetailsAccountCode Purchase Details Account Code |
PurchaseDetailsTaxType Purchase Details Tax Type |
SalesDetailsUnitPrice Sales Details Unit Price |
SalesDetailsAccountCode Sales Details Account Code |
SalesDetailsTaxType Sales Details Tax Type |
Name Name |
IsTrackedAsInventory Is Tracked As Inventory |
IsSold Is Sold |
IsPurchased Is Purchased |
XeroTenantID Xero Tenant Id |
AccountCode Account Code |
AccountID Account ID |
AccountName Account Name |
AccountType Account Type |
GrossAmount Gross Amount |
JournalLineID Journal Line ID |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
NetAmount Net Amount |
TaxAmount Tax Amount |
SourceID Source ID |
SourceType Source Type |
TaxName Tax Name |
TaxType Tax Type |
Reference Reference |
TrackingCategories_Name Tracking Categories Name |
TrackingCategories_Option Tracking Categories Option |
TrackingCategories_ID Tracking Categories ID |
TrackingCategories_optionID Tracking Categories option ID |
XeroTenantID Xero Tenant Id |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
CreatedDate Created Date |
XeroTenantID Xero Tenant Id |
AccountCode Account Code |
AccountID Account ID |
AccountName Account Name |
AccountType Account Type |
GrossAmount Gross Amount |
JournalLineID Journal Line ID |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
NetAmount Net Amount |
TaxAmount Tax Amount |
TaxName Tax Name |
TaxType Tax Type |
TrackingCategoryID Tracking Category ID |
TrackingOptionID Tracking Option ID |
TrackingCategoryName Tracking Category Name |
TrackingOption Tracking Option |
SourceID Source ID |
SourceType Source Type |
Reference Reference |
XeroTenantID Xero Tenant Id |
LinkedTransactionID Linked Transaction ID |
SourceTransactionID Source Transaction ID |
SourceLineItemID Source Line Item ID |
ContactID Contact ID |
TargetTransactionID Target Transaction ID |
TargetLineItemID Target Line Item ID |
Status Status |
Type Type |
UpdatedDate Updated Date UTC |
SourceTransactionTypeCode Source Transaction Type Code |
ManualJournalID Manual Journal ID |
XeroTenantID Xero Tenant Id |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
UpdatedDate Updated Date |
Narration Narration |
HasAttachments Has Attachments |
Name Name |
OrganisationID Organisation ID |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName sensitive Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
UpdatedDate Updated Date |
CurrencyCode Currency Code |
Amount Amount |
BankAmount Bank Amount |
Type Type |
OverpaymentID Overpayment ID |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
HasAttachments Has Attachments |
PaymentID Payment ID |
XeroTenantID Xero Tenant Id |
AccountID Account ID |
AccountCode Account Code |
Amount Amount |
BankAmount Bank Amount |
CurrencyRate Currency Rate |
Date Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
InvoiceContactName Invoice Contact Name |
InvoiceCurrencyCode Invoice Currency Code |
InvoiceIsDiscounted Invoice Is Discounted |
InvoiceType Invoice Type |
PaymentType Payment Type |
Reference Reference |
Status Status |
UpdatedDate Updated Date |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName sensitive Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
UpdatedDate Updated Date |
FullyPaidOnDate Fully Paid On Date |
CurrencyCode Currency Code |
Type Type |
CreditNoteID Credit Note ID |
CreditNoteNumber Credit Note Number |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
HasAttachments Has Attachments |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
Item Item |
Value Value |
DateStart Date Start |
DateStop Date Stop |
ReportDate Report Date |
ReportName Report Name |
ReportTitles Report Titles |
UpdatedDate Updated Date UTC |
AccountName Account Name |
RowLabel Row Label |
RowValue Row Value |
AccountID Account ID |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
TrackingCategoryID Tracking Category ID |
TrackingCategoryName Tracking Category Name |
XeroTenantID Xero Tenant Id |
ProjectID Project Id |
ContactID Contact Id |
Name Name |
CurrencyCode Currency Code |
MinutesLogged Minutes Logged |
TotalTaskAmountCurrency Total Task Amount Currency |
TotalTaskAmountValue Total Task Amount Value |
TotalExpenseAmountCurrency Total Expense Amount Currency |
TotalExpenseAmountValue Total Expense Amount Value |
MinutesToBeInvoiced Minutes To Be Invoiced |
TaskAmountToBeInvoicedCurrency Task Amount To Be Invoiced Currency |
TaskAmountToBeInvoicedValue Task Amount To Be Invoiced Value |
TaskAmountInvoicedCurrency Task Amount Invoiced Currency |
TaskAmountInvoicedValue Task Amount Invoiced Value |
ExpenseAmountToBeInvoicedCurrency Expense Amount To Be Invoiced Currency |
ExpenseAmountToBeInvoicedValue Expense Amount To Be Invoiced Value |
ExpenseAmountInvoicedCurrency Expense Amount Invoiced Currency |
ExpenseAmountInvoicedValue Expense Amount Invoiced Value |
ProjectAmountInvoicedCurrency Project Amount Invoiced Currency |
ProjectAmountInvoicedValue Project Amount Invoiced Value |
DepositCurrency Deposit Currency |
DepositValue Deposit Value |
DepositAppliedCurrency Deposit Applied Currency |
DepositAppliedValue Deposit Applied Value |
CreditNoteAmountCurrency Credit Note Amount Currency |
CreditNoteAmountValue Credit Note Amount Value |
TotalInvoicedCurrency Total Invoiced Currency |
TotalInvoicedValue Total Invoiced Value |
TotalToBeInvoicedCurrency Total To Be Invoiced Currency |
TotalToBeInvoicedValue Total To Be Invoiced Value |
Status Status |
EstimateCurrency Etimate Currency |
EstimateValue Etimate Value |
TotalTaskAmountCurrency Total Task Amount Currency |
XeroTenantID Xero Tenant Id |
PurchaseOrderID Purchase Order ID |
PurchaseOrderNumber Purchase Order Number |
Date Date |
DeliveryDate Delivery Date |
AttentionTo sensitive Attention To |
Telephone sensitive Telephone |
Reference Reference |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Status Status |
IsDiscounted Is Discounted |
ContactName sensitive Contact Name |
ContactID Contact ID |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
QuoteID Quote ID |
QuoteNumber Quote Number |
Reference Reference |
Terms Terms |
ContactID Contact ID |
ContactName sensitive Contact Name |
ContactEmailAddress sensitive Contact Email Address |
ContactFirstName sensitive Contact First Name |
ContactLastName sensitive Contact Last Name |
Date Date |
Status Status |
CurrencyRate Currency Rate |
CurrencyCode Currency Code |
SubTotal Sub Total |
TotalTax Total Tax |
Total Total |
TotalDiscount Total Discount |
Title Title |
Summary Summary |
LineAmountTypes Line Amount Types |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
QuoteID Quote ID |
QuoteNumber Quote Number |
Reference Reference |
Terms Terms |
ContactID Contact ID |
ContactName sensitive Contact Name |
ContactEmailAddress sensitive Contact Email Address |
ContactFirstName sensitive Contact First Name |
ContactLastName sensitive Contact Last Name |
Date Date |
Status Status |
CurrencyRate Currency Rate |
CurrencyCode Currency Code |
SubTotal Sub Total |
TotalTax Total Tax |
Total Total |
TotalDiscount Total Discount |
Title Title |
Summary Summary |
LineAmountTypes Line Amount Types |
LineItemID Line Item ID |
LineItemAccountCode Line Item Account Code |
LineItemDescription Line Item Description |
LineItemUnitAmount Line Item Unit Amount |
LineItemDiscountRate Line Item Discount Rate |
LineItemLineAmount Line Item Line Amount |
LineItemItemCode Line Item Item Code |
LineItemQuantity Line Item Quantity |
LineItemTaxAmount Line Item Tax Amount |
LineItemTaxType Line Item Tax Type |
ReportID Report ID |
ReportName Report Name |
Contact Contact |
Date Date |
InvoiceNumber Invoice Number |
DueDate Due Date |
Description Description |
Total Total |
Paid Paid |
Credited Credited |
Due Due |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
BankAccount Bank Account |
OpeningBalance Opening Balance |
CashReceived Cash Received |
CashSpent Cash Spent |
ClosingBalance Closing Balance |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
Account Account |
January January |
February February |
March March |
April April |
May May |
June June |
July July |
August August |
September September |
October October |
November November |
December December |
XeroTenantID Xero Tenant Id |
Year Year |
TenantID Tenant ID |
TenantName Tenant Name |
TenantType Tenant Type |
CreatedDate Created Date |
XeroTenantID Xero Tenant Id |
TrackingCategoryID Tracking Category ID |
XeroTenantID Xero Tenant Id |
Name Name |
Status Status |
ReportID Report ID |
ReportName ReportName |
XeroTenantID Xero Tenant Id |
DateStart Date Start |
DateStop Date Stop |
AccountName Account Name |
AccountCode Account Code |
Debit Debit |
Credit Credit |
YTDDebit YTD Debit |
YTDCredit YTD Credit |
Pricing
See all Dataddo plans
Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.
View pricing
One Platform to Connect All Your Data
See All Platform Benefits
Why Dataddo?
One Ingestion Layer for SaaS, Databases, and Files
Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.
Built for Cloud and On-Premise Environments
Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.
Full API Control - No UI Required
Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.
Managed Ingestion Operations. We Own the Reliability.
Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.
Full Visibility Into Every Data Flow
Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.
The Data Foundation Your AI Needs
Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.
Case Studies
See What Other Organizations Have Achieved with Dataddo
70%
less
engineering work,
more time analyzing data
37.5%
reduction
of infrastructure bill
on average
3
man-weeks
saved during initial phase
of migration
How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo
Entertainment
How FoodChéri Syncs MongoDB to BigQuery for Quicker Insights, with Less Engineering
Food & Beverage
How Sensire Accelerated Migration of a Proprietary On-Premise Data Infrastructure to the Cloud with Dataddo
Healthcare
Testimonials
Our Customers Love Us
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”
Andrew Hart
Chief Operations Officer
Sat 7
“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo opens up gates and takes away the hurdles of working with data.”
Laurent Partouche
CPO
FoodChéri & Seazon
“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”
Natheer Maloon
Technology Solutions Manager
Boldr
“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”
Greg Senior
Business Operations Manager
Farm Focus
“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”
