Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Xero data to
Xero Connector Reference
54 metrics340 dimensions
The Xero connector exposes 394 fields (54 metrics, 340 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
profit_and_loss_timeframe Profit And Loss Timeframe
Return one Profit and Loss column per period of this size across the selected date range. Leave unset for a single total column.
Possible values (3)
MONTHQUARTERYEAR
profit_and_loss_periods Profit And Loss Periods
Number of comparison periods to return (1-11). Leave empty to span the selected date range automatically.
Xero Fields
Xero accounts fields
The accounts report of the Xero connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| accounts__accountid | TEXT | accounts.AccountID | accounts.AccountID |
| accounts__bankaccountnumber | TEXT | accounts.BankAccountNumber | accounts.BankAccountNumber |
| accounts__bankaccounttype | TEXT | accounts.BankAccountType | accounts.BankAccountType |
| accounts__class | TEXT | accounts.Class | accounts.Class |
| accounts__code | TEXT | accounts.Code | accounts.Code |
| accounts__currencycode | TEXT | accounts.CurrencyCode | accounts.CurrencyCode |
| accounts__description | TEXT | accounts.Description | accounts.Description |
| accounts__enablepaymentstoaccount | BOOLEAN | accounts.EnablePaymentsToAccount | accounts.EnablePaymentsToAccount |
| accounts__hasattachments | BOOLEAN | accounts.HasAttachments | accounts.HasAttachments |
| accounts__name | TEXT | accounts.Name | accounts.Name |
| accounts__reportingcode | TEXT | accounts.ReportingCode | accounts.ReportingCode |
| accounts__reportingcodename | TEXT | accounts.ReportingCodeName | accounts.ReportingCodeName |
| accounts__showinexpenseclaims | BOOLEAN | accounts.ShowInExpenseClaims | accounts.ShowInExpenseClaims |
| accounts__status | TEXT | accounts.Status | accounts.Status |
| accounts__systemaccount | TEXT | accounts.SystemAccount | accounts.SystemAccount |
| accounts__taxtype | TEXT | accounts.TaxType | accounts.TaxType |
| accounts__type | TEXT | accounts.Type | accounts.Type |
| accounts__updateddateutc | DATE | accounts.UpdatedDateUTC | accounts.UpdatedDateUTC |
Xero balance_sheet fields
The balance_sheet report of the Xero connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| balance_sheet__account | TEXT | balance_sheet.Account | Line label (account or summary name). |
| balance_sheet__accountid | TEXT | balance_sheet.AccountID | Xero account id for the line, when it maps to an account. |
| balance_sheet__amount | NUMERIC | balance_sheet.Amount | Amount reported for the line in the given period. |
| balance_sheet__period | TEXT | balance_sheet.Period | Label of the amount column this line belongs to. Xero's Balance Sheet also returns a prior-period comparison column, so each date becomes its own row - filter on this to pick the reporting date. |
| balance_sheet__reportdate | TEXT | balance_sheet.ReportDate | Report date as shown in Xero. |
| balance_sheet__reportname | TEXT | balance_sheet.ReportName | Name of the Xero report (e.g. Balance Sheet). |
| balance_sheet__rowtype | TEXT | balance_sheet.RowType | Row kind: Row for a line item, SummaryRow for a section total. |
| balance_sheet__section | TEXT | balance_sheet.Section | Report section the line sits under (e.g. Assets, Liabilities). |
Xero bank_transactions fields
The bank_transactions report of the Xero connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| bank_transactions__bankaccount | OBJECT | bank_transactions.BankAccount | bank_transactions.BankAccount |
| bank_transactions__banktransactionid | TEXT | bank_transactions.BankTransactionID | bank_transactions.BankTransactionID |
| bank_transactions__contact | OBJECT | bank_transactions.Contact | bank_transactions.Contact |
| bank_transactions__currencycode | TEXT | bank_transactions.CurrencyCode | bank_transactions.CurrencyCode |
| bank_transactions__currencyrate | NUMERIC | bank_transactions.CurrencyRate | bank_transactions.CurrencyRate |
| bank_transactions__date | DATE | bank_transactions.Date | bank_transactions.Date |
| bank_transactions__datestring | TEXT | bank_transactions.DateString | bank_transactions.DateString |
| bank_transactions__externallinkprovidername | TEXT | bank_transactions.ExternalLinkProviderName | bank_transactions.ExternalLinkProviderName |
| bank_transactions__hasattachments | BOOLEAN | bank_transactions.HasAttachments | bank_transactions.HasAttachments |
| bank_transactions__isreconciled | BOOLEAN | bank_transactions.IsReconciled | bank_transactions.IsReconciled |
| bank_transactions__lineamounttypes | TEXT | bank_transactions.LineAmountTypes | bank_transactions.LineAmountTypes |
| bank_transactions__lineitems | OBJECT | bank_transactions.LineItems | bank_transactions.LineItems |
| bank_transactions__overpaymentid | TEXT | bank_transactions.OverpaymentID | bank_transactions.OverpaymentID |
| bank_transactions__prepaymentid | TEXT | bank_transactions.PrepaymentID | bank_transactions.PrepaymentID |
| bank_transactions__reference | TEXT | bank_transactions.Reference | bank_transactions.Reference |
| bank_transactions__status | TEXT | bank_transactions.Status | bank_transactions.Status |
| bank_transactions__subtotal | NUMERIC | bank_transactions.SubTotal | bank_transactions.SubTotal |
| bank_transactions__total | NUMERIC | bank_transactions.Total | bank_transactions.Total |
| bank_transactions__totaltax | NUMERIC | bank_transactions.TotalTax | bank_transactions.TotalTax |
| bank_transactions__type | TEXT | bank_transactions.Type | bank_transactions.Type |
| bank_transactions__updateddateutc | DATE | bank_transactions.UpdatedDateUTC | bank_transactions.UpdatedDateUTC |
| bank_transactions__url | TEXT | bank_transactions.Url | bank_transactions.Url |
Xero bank_transfers fields
The bank_transfers report of the Xero connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| bank_transfers__amount | NUMERIC | bank_transfers.Amount | bank_transfers.Amount |
| bank_transfers__banktransferid | TEXT | bank_transfers.BankTransferID | bank_transfers.BankTransferID |
| bank_transfers__createddateutc | DATE | bank_transfers.CreatedDateUTC | bank_transfers.CreatedDateUTC |
| bank_transfers__createddateutcstring | TEXT | bank_transfers.CreatedDateUTCString | bank_transfers.CreatedDateUTCString |
| bank_transfers__currencyrate | NUMERIC | bank_transfers.CurrencyRate | bank_transfers.CurrencyRate |
| bank_transfers__date | DATE | bank_transfers.Date | bank_transfers.Date |
| bank_transfers__datestring | TEXT | bank_transfers.DateString | bank_transfers.DateString |
| bank_transfers__frombankaccount | OBJECT | bank_transfers.FromBankAccount | bank_transfers.FromBankAccount |
| bank_transfers__frombanktransactionid | TEXT | bank_transfers.FromBankTransactionID | bank_transfers.FromBankTransactionID |
| bank_transfers__hasattachments | BOOLEAN | bank_transfers.HasAttachments | bank_transfers.HasAttachments |
| bank_transfers__tobankaccount | OBJECT | bank_transfers.ToBankAccount | bank_transfers.ToBankAccount |
| bank_transfers__tobanktransactionid | TEXT | bank_transfers.ToBankTransactionID | bank_transfers.ToBankTransactionID |
Xero branding_themes fields
The branding_themes report of the Xero connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| branding_themes__brandingthemeid | TEXT | branding_themes.BrandingThemeID | branding_themes.BrandingThemeID |
| branding_themes__createddateutc | DATE | branding_themes.CreatedDateUTC | branding_themes.CreatedDateUTC |
| branding_themes__name | TEXT | branding_themes.Name | branding_themes.Name |
| branding_themes__sortorder | NUMERIC | branding_themes.SortOrder | branding_themes.SortOrder |
Xero contact_groups fields
The contact_groups report of the Xero connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contact_groups__contactgroupid | TEXT | contact_groups.ContactGroupID | contact_groups.ContactGroupID |
| contact_groups__hasvalidationerrors | BOOLEAN | contact_groups.HasValidationErrors | contact_groups.HasValidationErrors |
| contact_groups__name | TEXT | contact_groups.Name | contact_groups.Name |
| contact_groups__status | TEXT | contact_groups.Status | contact_groups.Status |
Xero contacts fields
The contacts report of the Xero connector includes 38 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contacts__accountnumber | TEXT | contacts.AccountNumber | contacts.AccountNumber |
| contacts__accountspayabletaxtype | TEXT | contacts.AccountsPayableTaxType | contacts.AccountsPayableTaxType |
| contacts__accountsreceivabletaxtype | TEXT | contacts.AccountsReceivableTaxType | contacts.AccountsReceivableTaxType |
| contacts__addresses | OBJECT | contacts.Addresses | contacts.Addresses |
| contacts__attachments | OBJECT | contacts.Attachments | contacts.Attachments |
| contacts__balances | OBJECT | contacts.Balances | contacts.Balances |
| contacts__bankaccountdetails | TEXT | contacts.BankAccountDetails | contacts.BankAccountDetails |
| contacts__batchpayments | OBJECT | contacts.BatchPayments | contacts.BatchPayments |
| contacts__brandingtheme | OBJECT | contacts.BrandingTheme | contacts.BrandingTheme |
| contacts__contactgroups | OBJECT | contacts.ContactGroups | contacts.ContactGroups |
| contacts__contactid | TEXT | contacts.ContactID | contacts.ContactID |
| contacts__contactnumber | TEXT | contacts.ContactNumber | contacts.ContactNumber |
| contacts__contactpersons | OBJECT | contacts.ContactPersons | contacts.ContactPersons |
| contacts__contactstatus | TEXT | contacts.ContactStatus | contacts.ContactStatus |
| contacts__defaultcurrency | TEXT | contacts.DefaultCurrency | contacts.DefaultCurrency |
| contacts__discount | NUMERIC | contacts.Discount | contacts.Discount |
| contacts__emailaddress | TEXT | contacts.EmailAddress | contacts.EmailAddress |
| contacts__firstname | TEXT | contacts.FirstName | contacts.FirstName |
| contacts__hasattachments | BOOLEAN | contacts.HasAttachments | contacts.HasAttachments |
| contacts__hasvalidationerrors | BOOLEAN | contacts.HasValidationErrors | contacts.HasValidationErrors |
| contacts__iscustomer | BOOLEAN | contacts.IsCustomer | contacts.IsCustomer |
| contacts__issupplier | BOOLEAN | contacts.IsSupplier | contacts.IsSupplier |
| contacts__lastname | TEXT | contacts.LastName | contacts.LastName |
| contacts__name | TEXT | contacts.Name | contacts.Name |
| contacts__paymentterms | OBJECT | contacts.PaymentTerms | contacts.PaymentTerms |
| contacts__phones | OBJECT | contacts.Phones | contacts.Phones |
| contacts__purchasesdefaultaccountcode | TEXT | contacts.PurchasesDefaultAccountCode | contacts.PurchasesDefaultAccountCode |
| contacts__purchasestrackingcategories | OBJECT | contacts.PurchasesTrackingCategories | contacts.PurchasesTrackingCategories |
| contacts__salesdefaultaccountcode | TEXT | contacts.SalesDefaultAccountCode | contacts.SalesDefaultAccountCode |
| contacts__salestrackingcategories | OBJECT | contacts.SalesTrackingCategories | contacts.SalesTrackingCategories |
| contacts__skypeusername | TEXT | contacts.SkypeUserName | contacts.SkypeUserName |
| contacts__taxnumber | TEXT | contacts.TaxNumber | contacts.TaxNumber |
| contacts__trackingcategoryname | TEXT | contacts.TrackingCategoryName | contacts.TrackingCategoryName |
| contacts__trackingcategoryoption | TEXT | contacts.TrackingCategoryOption | contacts.TrackingCategoryOption |
| contacts__updateddateutc | DATE | contacts.UpdatedDateUTC | contacts.UpdatedDateUTC |
| contacts__validationerrors | OBJECT | contacts.ValidationErrors | contacts.ValidationErrors |
| contacts__website | TEXT | contacts.Website | contacts.Website |
| contacts__xeronetworkkey | TEXT | contacts.XeroNetworkKey | contacts.XeroNetworkKey |
Xero credit_notes fields
The credit_notes report of the Xero connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| credit_notes__allocations | OBJECT | credit_notes.Allocations | credit_notes.Allocations |
| credit_notes__appliedamount | NUMERIC | credit_notes.AppliedAmount | credit_notes.AppliedAmount |
| credit_notes__brandingthemeid | TEXT | credit_notes.BrandingThemeID | credit_notes.BrandingThemeID |
| credit_notes__contact | OBJECT | credit_notes.Contact | credit_notes.Contact |
| credit_notes__creditnoteid | TEXT | credit_notes.CreditNoteID | credit_notes.CreditNoteID |
| credit_notes__creditnotenumber | TEXT | credit_notes.CreditNoteNumber | credit_notes.CreditNoteNumber |
| credit_notes__currencycode | TEXT | credit_notes.CurrencyCode | credit_notes.CurrencyCode |
| credit_notes__currencyrate | NUMERIC | credit_notes.CurrencyRate | credit_notes.CurrencyRate |
| credit_notes__date | DATE | credit_notes.Date | credit_notes.Date |
| credit_notes__datestring | TEXT | credit_notes.DateString | credit_notes.DateString |
| credit_notes__duedate | DATE | credit_notes.DueDate | credit_notes.DueDate |
| credit_notes__duedatestring | TEXT | credit_notes.DueDateString | credit_notes.DueDateString |
| credit_notes__fullypaidondate | DATE | credit_notes.FullyPaidOnDate | credit_notes.FullyPaidOnDate |
| credit_notes__hasattachments | BOOLEAN | credit_notes.HasAttachments | credit_notes.HasAttachments |
| credit_notes__id | TEXT | credit_notes.ID | credit_notes.ID |
| credit_notes__lineamounttypes | TEXT | credit_notes.LineAmountTypes | credit_notes.LineAmountTypes |
| credit_notes__lineitems | OBJECT | credit_notes.LineItems | credit_notes.LineItems |
| credit_notes__reference | TEXT | credit_notes.Reference | credit_notes.Reference |
| credit_notes__remainingcredit | NUMERIC | credit_notes.RemainingCredit | credit_notes.RemainingCredit |
| credit_notes__senttocontact | BOOLEAN | credit_notes.SentToContact | credit_notes.SentToContact |
| credit_notes__status | TEXT | credit_notes.Status | credit_notes.Status |
| credit_notes__subtotal | NUMERIC | credit_notes.SubTotal | credit_notes.SubTotal |
| credit_notes__total | NUMERIC | credit_notes.Total | credit_notes.Total |
| credit_notes__totaltax | NUMERIC | credit_notes.TotalTax | credit_notes.TotalTax |
| credit_notes__type | TEXT | credit_notes.Type | credit_notes.Type |
| credit_notes__updateddateutc | DATE | credit_notes.UpdatedDateUTC | credit_notes.UpdatedDateUTC |
Xero employees fields
The employees report of the Xero connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| employees__employeeid | TEXT | employees.EmployeeID | employees.EmployeeID |
| employees__externallink | TEXT | employees.ExternalLink | employees.ExternalLink |
| employees__firstname | TEXT | employees.FirstName | employees.FirstName |
| employees__lastname | TEXT | employees.LastName | employees.LastName |
| employees__status | TEXT | employees.Status | employees.Status |
| employees__updateddateutc | DATE | employees.UpdatedDateUTC | employees.UpdatedDateUTC |
Xero invoices fields
The invoices report of the Xero connector includes 37 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| invoices__amountcredited | NUMERIC | invoices.AmountCredited | invoices.AmountCredited |
| invoices__amountdue | NUMERIC | invoices.AmountDue | invoices.AmountDue |
| invoices__amountpaid | NUMERIC | invoices.AmountPaid | invoices.AmountPaid |
| invoices__brandingthemeid | TEXT | invoices.BrandingThemeID | invoices.BrandingThemeID |
| invoices__contact | OBJECT | invoices.Contact | invoices.Contact |
| invoices__creditnotes | OBJECT | invoices.CreditNotes | invoices.CreditNotes |
| invoices__currencycode | TEXT | invoices.CurrencyCode | invoices.CurrencyCode |
| invoices__currencyrate | NUMERIC | invoices.CurrencyRate | invoices.CurrencyRate |
| invoices__date | DATE | invoices.Date | invoices.Date |
| invoices__datestring | TEXT | invoices.DateString | invoices.DateString |
| invoices__duedate | DATE | invoices.DueDate | invoices.DueDate |
| invoices__duedatestring | TEXT | invoices.DueDateString | invoices.DueDateString |
| invoices__expectedpaymentdate | DATE | invoices.ExpectedPaymentDate | invoices.ExpectedPaymentDate |
| invoices__expectedpaymentdatestring | TEXT | invoices.ExpectedPaymentDateString | invoices.ExpectedPaymentDateString |
| invoices__fullypaidondate | DATE | invoices.FullyPaidOnDate | invoices.FullyPaidOnDate |
| invoices__hasattachments | BOOLEAN | invoices.HasAttachments | invoices.HasAttachments |
| invoices__haserrors | BOOLEAN | invoices.HasErrors | invoices.HasErrors |
| invoices__invoiceid | TEXT | invoices.InvoiceID | invoices.InvoiceID |
| invoices__invoicenumber | TEXT | invoices.InvoiceNumber | invoices.InvoiceNumber |
| invoices__isdiscounted | BOOLEAN | invoices.IsDiscounted | invoices.IsDiscounted |
| invoices__lineamounttypes | TEXT | invoices.LineAmountTypes | invoices.LineAmountTypes |
| invoices__lineitems | OBJECT | invoices.LineItems | invoices.LineItems |
| invoices__overpayments | OBJECT | invoices.Overpayments | invoices.Overpayments |
| invoices__payments | OBJECT | invoices.Payments | invoices.Payments |
| invoices__plannedpaymentdate | DATE | invoices.PlannedPaymentDate | invoices.PlannedPaymentDate |
| invoices__plannedpaymentdatestring | TEXT | invoices.PlannedPaymentDateString | invoices.PlannedPaymentDateString |
| invoices__prepayments | OBJECT | invoices.Prepayments | invoices.Prepayments |
| invoices__reference | TEXT | invoices.Reference | invoices.Reference |
| invoices__senttocontact | BOOLEAN | invoices.SentToContact | invoices.SentToContact |
| invoices__status | TEXT | invoices.Status | invoices.Status |
| invoices__subtotal | NUMERIC | invoices.SubTotal | invoices.SubTotal |
| invoices__total | NUMERIC | invoices.Total | invoices.Total |
| invoices__totaldiscount | NUMERIC | invoices.TotalDiscount | invoices.TotalDiscount |
| invoices__totaltax | NUMERIC | invoices.TotalTax | invoices.TotalTax |
| invoices__type | TEXT | invoices.Type | invoices.Type |
| invoices__updateddateutc | DATE | invoices.UpdatedDateUTC | invoices.UpdatedDateUTC |
| invoices__url | TEXT | invoices.Url | invoices.Url |
Xero items fields
The items report of the Xero connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| items__code | TEXT | items.Code | items.Code |
| items__description | TEXT | items.Description | items.Description |
| items__inventoryassetaccountcode | TEXT | items.InventoryAssetAccountCode | items.InventoryAssetAccountCode |
| items__ispurchased | BOOLEAN | items.IsPurchased | items.IsPurchased |
| items__issold | BOOLEAN | items.IsSold | items.IsSold |
| items__istrackedasinventory | BOOLEAN | items.IsTrackedAsInventory | items.IsTrackedAsInventory |
| items__itemid | TEXT | items.ItemID | items.ItemID |
| items__name | TEXT | items.Name | items.Name |
| items__purchasedescription | TEXT | items.PurchaseDescription | items.PurchaseDescription |
| items__purchasedetails | OBJECT | items.PurchaseDetails | items.PurchaseDetails |
| items__quantityonhand | NUMERIC | items.QuantityOnHand | items.QuantityOnHand |
| items__salesdetails | OBJECT | items.SalesDetails | items.SalesDetails |
| items__totalcostpool | NUMERIC | items.TotalCostPool | items.TotalCostPool |
| items__updateddateutc | DATE | items.UpdatedDateUTC | items.UpdatedDateUTC |
Xero manual_journals fields
The manual_journals report of the Xero connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| manual_journals__date | DATE | manual_journals.Date | manual_journals.Date |
| manual_journals__hasattachments | BOOLEAN | manual_journals.HasAttachments | manual_journals.HasAttachments |
| manual_journals__journallines | OBJECT | manual_journals.JournalLines | manual_journals.JournalLines |
| manual_journals__lineamounttypes | TEXT | manual_journals.LineAmountTypes | manual_journals.LineAmountTypes |
| manual_journals__manualjournalid | TEXT | manual_journals.ManualJournalID | manual_journals.ManualJournalID |
| manual_journals__narration | TEXT | manual_journals.Narration | manual_journals.Narration |
| manual_journals__showoncashbasisreports | BOOLEAN | manual_journals.ShowOnCashBasisReports | manual_journals.ShowOnCashBasisReports |
| manual_journals__status | TEXT | manual_journals.Status | manual_journals.Status |
| manual_journals__updateddateutc | DATE | manual_journals.UpdatedDateUTC | manual_journals.UpdatedDateUTC |
| manual_journals__url | TEXT | manual_journals.Url | manual_journals.Url |
Xero organisations fields
The organisations report of the Xero connector includes 30 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| organisations__addresses | OBJECT | organisations.Addresses | organisations.Addresses |
| organisations__apikey | TEXT | organisations.APIKey | organisations.APIKey |
| organisations__basecurrency | TEXT | organisations.BaseCurrency | organisations.BaseCurrency |
| organisations__countrycode | TEXT | organisations.CountryCode | organisations.CountryCode |
| organisations__createddateutc | DATE | organisations.CreatedDateUTC | organisations.CreatedDateUTC |
| organisations__defaultpurchasestax | TEXT | organisations.DefaultPurchasesTax | organisations.DefaultPurchasesTax |
| organisations__defaultsalestax | TEXT | organisations.DefaultSalesTax | organisations.DefaultSalesTax |
| organisations__endofyearlockdate | DATE | organisations.EndOfYearLockDate | organisations.EndOfYearLockDate |
| organisations__externallinks | OBJECT | organisations.ExternalLinks | organisations.ExternalLinks |
| organisations__financialyearendday | NUMERIC | organisations.FinancialYearEndDay | organisations.FinancialYearEndDay |
| organisations__financialyearendmonth | NUMERIC | organisations.FinancialYearEndMonth | organisations.FinancialYearEndMonth |
| organisations__isdemocompany | BOOLEAN | organisations.IsDemoCompany | organisations.IsDemoCompany |
| organisations__legalname | TEXT | organisations.LegalName | organisations.LegalName |
| organisations__lineofbusiness | TEXT | organisations.LineOfBusiness | organisations.LineOfBusiness |
| organisations__name | TEXT | organisations.Name | organisations.Name |
| organisations__organisationentitytype | TEXT | organisations.OrganisationEntityType | organisations.OrganisationEntityType |
| organisations__organisationid | TEXT | organisations.OrganisationID | organisations.OrganisationID |
| organisations__organisationstatus | TEXT | organisations.OrganisationStatus | organisations.OrganisationStatus |
| organisations__organisationtype | TEXT | organisations.OrganisationType | organisations.OrganisationType |
| organisations__paymentterms | OBJECT | organisations.PaymentTerms | organisations.PaymentTerms |
| organisations__paystax | BOOLEAN | organisations.PaysTax | organisations.PaysTax |
| organisations__periodlockdate | DATE | organisations.PeriodLockDate | organisations.PeriodLockDate |
| organisations__phones | OBJECT | organisations.Phones | organisations.Phones |
| organisations__registrationnumber | TEXT | organisations.RegistrationNumber | organisations.RegistrationNumber |
| organisations__salestaxbasis | TEXT | organisations.SalesTaxBasis | organisations.SalesTaxBasis |
| organisations__salestaxperiod | TEXT | organisations.SalesTaxPeriod | organisations.SalesTaxPeriod |
| organisations__shortcode | TEXT | organisations.ShortCode | organisations.ShortCode |
| organisations__taxnumber | TEXT | organisations.TaxNumber | organisations.TaxNumber |
| organisations__timezone | TEXT | organisations.Timezone | organisations.Timezone |
| organisations__version | TEXT | organisations.Version | organisations.Version |
Xero overpayments fields
The overpayments report of the Xero connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| overpayments__allocations | OBJECT | overpayments.Allocations | overpayments.Allocations |
| overpayments__appliedamount | NUMERIC | overpayments.AppliedAmount | overpayments.AppliedAmount |
| overpayments__contact | OBJECT | overpayments.Contact | overpayments.Contact |
| overpayments__currencycode | TEXT | overpayments.CurrencyCode | overpayments.CurrencyCode |
| overpayments__currencyrate | NUMERIC | overpayments.CurrencyRate | overpayments.CurrencyRate |
| overpayments__date | DATE | overpayments.Date | overpayments.Date |
| overpayments__datestring | TEXT | overpayments.DateString | overpayments.DateString |
| overpayments__hasattachments | BOOLEAN | overpayments.HasAttachments | overpayments.HasAttachments |
| overpayments__id | TEXT | overpayments.ID | overpayments.ID |
| overpayments__lineamounttypes | TEXT | overpayments.LineAmountTypes | overpayments.LineAmountTypes |
| overpayments__lineitems | OBJECT | overpayments.LineItems | overpayments.LineItems |
| overpayments__overpaymentid | TEXT | overpayments.OverpaymentID | overpayments.OverpaymentID |
| overpayments__payments | OBJECT | overpayments.Payments | overpayments.Payments |
| overpayments__reference | TEXT | overpayments.Reference | overpayments.Reference |
| overpayments__remainingcredit | NUMERIC | overpayments.RemainingCredit | overpayments.RemainingCredit |
| overpayments__status | TEXT | overpayments.Status | overpayments.Status |
| overpayments__subtotal | NUMERIC | overpayments.SubTotal | overpayments.SubTotal |
| overpayments__total | NUMERIC | overpayments.Total | overpayments.Total |
| overpayments__totaltax | NUMERIC | overpayments.TotalTax | overpayments.TotalTax |
| overpayments__type | TEXT | overpayments.Type | overpayments.Type |
| overpayments__updateddateutc | DATE | overpayments.UpdatedDateUTC | overpayments.UpdatedDateUTC |
Xero payments fields
The payments report of the Xero connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| payments__account | OBJECT | payments.Account | payments.Account |
| payments__amount | NUMERIC | payments.Amount | payments.Amount |
| payments__bankamount | NUMERIC | payments.BankAmount | payments.BankAmount |
| payments__batchpaymentid | TEXT | payments.BatchPaymentID | payments.BatchPaymentID |
| payments__creditnote | OBJECT | payments.CreditNote | payments.CreditNote |
| payments__currencyrate | NUMERIC | payments.CurrencyRate | payments.CurrencyRate |
| payments__date | DATE | payments.Date | payments.Date |
| payments__hasaccount | BOOLEAN | payments.HasAccount | payments.HasAccount |
| payments__hasvalidationerrors | BOOLEAN | payments.HasValidationErrors | payments.HasValidationErrors |
| payments__invoice | OBJECT | payments.Invoice | payments.Invoice |
| payments__isreconciled | BOOLEAN | payments.IsReconciled | payments.IsReconciled |
| payments__overpayment | OBJECT | payments.Overpayment | payments.Overpayment |
| payments__paymentid | TEXT | payments.PaymentID | payments.PaymentID |
| payments__paymenttype | TEXT | payments.PaymentType | payments.PaymentType |
| payments__prepayments | OBJECT | payments.Prepayments | payments.Prepayments |
| payments__reference | TEXT | payments.Reference | payments.Reference |
| payments__status | TEXT | payments.Status | payments.Status |
| payments__updateddateutc | DATE | payments.UpdatedDateUTC | payments.UpdatedDateUTC |
Xero prepayments fields
The prepayments report of the Xero connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| prepayments__allocations | OBJECT | prepayments.Allocations | prepayments.Allocations |
| prepayments__appliedamount | NUMERIC | prepayments.AppliedAmount | prepayments.AppliedAmount |
| prepayments__contact | OBJECT | prepayments.Contact | prepayments.Contact |
| prepayments__currencycode | TEXT | prepayments.CurrencyCode | prepayments.CurrencyCode |
| prepayments__currencyrate | NUMERIC | prepayments.CurrencyRate | prepayments.CurrencyRate |
| prepayments__date | DATE | prepayments.Date | prepayments.Date |
| prepayments__datestring | TEXT | prepayments.DateString | prepayments.DateString |
| prepayments__hasattachments | BOOLEAN | prepayments.HasAttachments | prepayments.HasAttachments |
| prepayments__id | TEXT | prepayments.ID | prepayments.ID |
| prepayments__lineamounttypes | TEXT | prepayments.LineAmountTypes | prepayments.LineAmountTypes |
| prepayments__lineitems | OBJECT | prepayments.LineItems | prepayments.LineItems |
| prepayments__payments | OBJECT | prepayments.Payments | prepayments.Payments |
| prepayments__prepaymentid | TEXT | prepayments.PrepaymentID | prepayments.PrepaymentID |
| prepayments__reference | TEXT | prepayments.Reference | prepayments.Reference |
| prepayments__remainingcredit | NUMERIC | prepayments.RemainingCredit | prepayments.RemainingCredit |
| prepayments__status | TEXT | prepayments.Status | prepayments.Status |
| prepayments__subtotal | NUMERIC | prepayments.SubTotal | prepayments.SubTotal |
| prepayments__total | NUMERIC | prepayments.Total | prepayments.Total |
| prepayments__totaltax | NUMERIC | prepayments.TotalTax | prepayments.TotalTax |
| prepayments__type | TEXT | prepayments.Type | prepayments.Type |
| prepayments__updateddateutc | DATE | prepayments.UpdatedDateUTC | prepayments.UpdatedDateUTC |
Xero profit_and_loss fields
The profit_and_loss report of the Xero connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| profit_and_loss__account | TEXT | profit_and_loss.Account | Line label (account or summary name). |
| profit_and_loss__accountid | TEXT | profit_and_loss.AccountID | Xero account id for the line, when it maps to an account. |
| profit_and_loss__amount | NUMERIC | profit_and_loss.Amount | Amount reported for the line in the given period. |
| profit_and_loss__period | TEXT | profit_and_loss.Period | Label of the amount column this line belongs to. |
| profit_and_loss__reportdate | TEXT | profit_and_loss.ReportDate | Report date as shown in Xero. |
| profit_and_loss__reportname | TEXT | profit_and_loss.ReportName | Name of the Xero report (e.g. Profit and Loss). |
| profit_and_loss__rowtype | TEXT | profit_and_loss.RowType | Row kind: Row for a line item, SummaryRow for a section total. |
| profit_and_loss__section | TEXT | profit_and_loss.Section | Report section the line sits under (e.g. Income, Expenses). |
Xero purchase_orders fields
The purchase_orders report of the Xero connector includes 30 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| purchase_orders__attentionto | TEXT | purchase_orders.AttentionTo | purchase_orders.AttentionTo |
| purchase_orders__brandingthemeid | TEXT | purchase_orders.BrandingThemeID | purchase_orders.BrandingThemeID |
| purchase_orders__contact | OBJECT | purchase_orders.Contact | purchase_orders.Contact |
| purchase_orders__currencycode | TEXT | purchase_orders.CurrencyCode | purchase_orders.CurrencyCode |
| purchase_orders__currencyrate | NUMERIC | purchase_orders.CurrencyRate | purchase_orders.CurrencyRate |
| purchase_orders__date | DATE | purchase_orders.Date | purchase_orders.Date |
| purchase_orders__datestring | TEXT | purchase_orders.DateString | purchase_orders.DateString |
| purchase_orders__deliveryaddress | TEXT | purchase_orders.DeliveryAddress | purchase_orders.DeliveryAddress |
| purchase_orders__deliverydate | DATE | purchase_orders.DeliveryDate | purchase_orders.DeliveryDate |
| purchase_orders__deliverydatestring | TEXT | purchase_orders.DeliveryDateString | purchase_orders.DeliveryDateString |
| purchase_orders__deliveryinstructions | TEXT | purchase_orders.DeliveryInstructions | purchase_orders.DeliveryInstructions |
| purchase_orders__expectedarrivaldate | DATE | purchase_orders.ExpectedArrivalDate | purchase_orders.ExpectedArrivalDate |
| purchase_orders__expectedarrivaldatestring | TEXT | purchase_orders.ExpectedArrivalDateString | purchase_orders.ExpectedArrivalDateString |
| purchase_orders__hasattachments | BOOLEAN | purchase_orders.HasAttachments | purchase_orders.HasAttachments |
| purchase_orders__haserrors | BOOLEAN | purchase_orders.HasErrors | purchase_orders.HasErrors |
| purchase_orders__isdiscounted | BOOLEAN | purchase_orders.IsDiscounted | purchase_orders.IsDiscounted |
| purchase_orders__lineamounttypes | TEXT | purchase_orders.LineAmountTypes | purchase_orders.LineAmountTypes |
| purchase_orders__lineitems | OBJECT | purchase_orders.LineItems | purchase_orders.LineItems |
| purchase_orders__purchaseorderid | TEXT | purchase_orders.PurchaseOrderID | purchase_orders.PurchaseOrderID |
| purchase_orders__purchaseordernumber | TEXT | purchase_orders.PurchaseOrderNumber | purchase_orders.PurchaseOrderNumber |
| purchase_orders__reference | TEXT | purchase_orders.Reference | purchase_orders.Reference |
| purchase_orders__senttocontact | BOOLEAN | purchase_orders.SentToContact | purchase_orders.SentToContact |
| purchase_orders__status | TEXT | purchase_orders.Status | purchase_orders.Status |
| purchase_orders__subtotal | NUMERIC | purchase_orders.SubTotal | purchase_orders.SubTotal |
| purchase_orders__telephone | TEXT | purchase_orders.Telephone | purchase_orders.Telephone |
| purchase_orders__total | NUMERIC | purchase_orders.Total | purchase_orders.Total |
| purchase_orders__totaldiscount | NUMERIC | purchase_orders.TotalDiscount | purchase_orders.TotalDiscount |
| purchase_orders__totaltax | NUMERIC | purchase_orders.TotalTax | purchase_orders.TotalTax |
| purchase_orders__type | TEXT | purchase_orders.Type | purchase_orders.Type |
| purchase_orders__updateddateutc | DATE | purchase_orders.UpdatedDateUTC | purchase_orders.UpdatedDateUTC |
Xero repeating_invoices fields
The repeating_invoices report of the Xero connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| repeating_invoices__brandingthemeid | TEXT | repeating_invoices.BrandingThemeID | repeating_invoices.BrandingThemeID |
| repeating_invoices__contact | OBJECT | repeating_invoices.Contact | repeating_invoices.Contact |
| repeating_invoices__currencycode | TEXT | repeating_invoices.CurrencyCode | repeating_invoices.CurrencyCode |
| repeating_invoices__hasattachments | BOOLEAN | repeating_invoices.HasAttachments | repeating_invoices.HasAttachments |
| repeating_invoices__id | TEXT | repeating_invoices.ID | repeating_invoices.ID |
| repeating_invoices__lineamounttypes | TEXT | repeating_invoices.LineAmountTypes | repeating_invoices.LineAmountTypes |
| repeating_invoices__lineitems | OBJECT | repeating_invoices.LineItems | repeating_invoices.LineItems |
| repeating_invoices__reference | TEXT | repeating_invoices.Reference | repeating_invoices.Reference |
| repeating_invoices__repeatinginvoiceid | TEXT | repeating_invoices.RepeatingInvoiceID | repeating_invoices.RepeatingInvoiceID |
| repeating_invoices__schedule | OBJECT | repeating_invoices.Schedule | repeating_invoices.Schedule |
| repeating_invoices__status | TEXT | repeating_invoices.Status | repeating_invoices.Status |
| repeating_invoices__subtotal | NUMERIC | repeating_invoices.SubTotal | repeating_invoices.SubTotal |
| repeating_invoices__total | NUMERIC | repeating_invoices.Total | repeating_invoices.Total |
| repeating_invoices__totaldiscount | NUMERIC | repeating_invoices.TotalDiscount | repeating_invoices.TotalDiscount |
| repeating_invoices__totaltax | NUMERIC | repeating_invoices.TotalTax | repeating_invoices.TotalTax |
| repeating_invoices__type | TEXT | repeating_invoices.Type | repeating_invoices.Type |
Xero tax_rates fields
The tax_rates report of the Xero connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| tax_rates__canapplytoassets | BOOLEAN | tax_rates.CanApplyToAssets | tax_rates.CanApplyToAssets |
| tax_rates__canapplytoequity | BOOLEAN | tax_rates.CanApplyToEquity | tax_rates.CanApplyToEquity |
| tax_rates__canapplytoexpenses | BOOLEAN | tax_rates.CanApplyToExpenses | tax_rates.CanApplyToExpenses |
| tax_rates__canapplytoliabilities | BOOLEAN | tax_rates.CanApplyToLiabilities | tax_rates.CanApplyToLiabilities |
| tax_rates__canapplytorevenue | BOOLEAN | tax_rates.CanApplyToRevenue | tax_rates.CanApplyToRevenue |
| tax_rates__displaytaxrate | NUMERIC | tax_rates.DisplayTaxRate | tax_rates.DisplayTaxRate |
| tax_rates__effectiverate | NUMERIC | tax_rates.EffectiveRate | tax_rates.EffectiveRate |
| tax_rates__name | TEXT | tax_rates.Name | tax_rates.Name |
| tax_rates__reporttaxtype | TEXT | tax_rates.ReportTaxType | tax_rates.ReportTaxType |
| tax_rates__status | TEXT | tax_rates.Status | tax_rates.Status |
| tax_rates__taxcomponents | OBJECT | tax_rates.TaxComponents | tax_rates.TaxComponents |
| tax_rates__taxtype | TEXT | tax_rates.TaxType | tax_rates.TaxType |
Xero tracking_categories fields
The tracking_categories report of the Xero connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| tracking_categories__name | TEXT | tracking_categories.Name | tracking_categories.Name |
| tracking_categories__option | TEXT | tracking_categories.Option | tracking_categories.Option |
| tracking_categories__options | OBJECT | tracking_categories.Options | tracking_categories.Options |
| tracking_categories__status | TEXT | tracking_categories.Status | tracking_categories.Status |
| tracking_categories__trackingcategoryid | TEXT | tracking_categories.TrackingCategoryID | tracking_categories.TrackingCategoryID |
| tracking_categories__trackingcategoryname | TEXT | tracking_categories.TrackingCategoryName | tracking_categories.TrackingCategoryName |
| tracking_categories__trackingoptionid | TEXT | tracking_categories.TrackingOptionID | tracking_categories.TrackingOptionID |
| tracking_categories__trackingoptionname | TEXT | tracking_categories.TrackingOptionName | tracking_categories.TrackingOptionName |
Xero users fields
The users report of the Xero connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| users__emailaddress | TEXT | users.EmailAddress | users.EmailAddress |
| users__firstname | TEXT | users.FirstName | users.FirstName |
| users__issubscriber | BOOLEAN | users.IsSubscriber | users.IsSubscriber |
| users__lastname | TEXT | users.LastName | users.LastName |
| users__organisationrole | TEXT | users.OrganisationRole | users.OrganisationRole |
| users__updateddateutc | DATE | users.UpdatedDateUTC | users.UpdatedDateUTC |
| users__userid | TEXT | users.UserID | users.UserID |
| users__validationerrors | OBJECT | users.ValidationErrors | users.ValidationErrors |
Xero other fields
The Xero connector has 23 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| currencies__code | TEXT | currencies.Code | currencies.Code | currencies |
| currencies__description | TEXT | currencies.Description | currencies.Description | currencies |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |