Fragen Sie Claude zu Forderungen, Liquidität pro Bankkonto und Budgetabweichungen in Ihren Xero-Organisationen, mit Zahlen aus Daten, die Dataddo aktuell hält.
Weniger Tokens, bessere Antworten.
Geringere KI-Kosten für dieselbe Arbeit
Präzisere, zuverlässigere Antworten
Nur Lesezugriff
Nutzt die Xero-Daten, die Sie bereits synchronisieren
Wie viel Geld ist im September auf jedem Bankkonto eingegangen und abgeflossen?
ClaudeAntwort · Xero
Der September schloss mit einem Nettozufluss von 9.350 $: 89.600 $ Cash Received gegenüber 80.250 $ Cash Spent. Der Großteil von beidem lief über den Business Account.
Bank Account
Cash Received
Cash Spent
Closing Balance
Business AccountReports - Bank summary
84.200 $
71.650 $
52.900 $
Business SavingsReports - Bank summary
5.400 $
0 $
40.000 $
Company Credit CardReports - Bank summary
0 $
8.600 $
-3.150 $
Aus dem Bericht Bank summary für einen Zeitraum von Date Start bis Date Stop übernommen, nicht durch Aufsummieren von Bank Transactions nachgebaut.
Quelle
Xero · Stand Mo 06:40 UTC
Zeitraum
1.-30. Sep. 2026
Fragen Sie Claude zu Ihren Xero-Daten...
Beispielantwort · fiktives Konto und fiktive Zahlen
Xero in Claude
Fragen, die Claude aus Ihren Xero-Daten beantwortet
Xero ist eine Cloud-Buchhaltungssoftware für kleine und mittlere Unternehmen. Dataddo extrahiert Rechnungen, Zahlungen und Banktransaktionen sowie Xero-Berichte wie Aged Receivables, Bank summary, Profit and Loss und Budget summary.
Budgetabweichung für das Board-Paket
Fragen Sie Claude
Vergleiche Profit and Loss Value nach Item für Q3 mit Reports - Budget summary nach Account für Juli bis September. Wo liegen wir am weitesten über Budget?
Die FP&A-Leitung fragt Claude nach den Monaten und Konten mit der größten Abweichung vom Budget, prüft diese Zeilen und entwirft den Abweichungskommentar, bevor er ins Board-Paket geht.
Abschluss-Checkliste aus der Saldenliste
Fragen Sie Claude
Rufe mit dem dataddo-Server Trial Balance Debit, Credit, YTD Debit und YTD Credit nach Account Code ab und schreibe close/checklist.md.
Im Abschluss-Repository bittet ein Finance Engineer Claude Code, Konten mit unerwarteten Bewegungen zu markieren, und committet eine Markdown-Checkliste, die das Team vor der Freigabe abarbeitet.
Liquidität über alle Organisationen
Fragen Sie Claude
Zeige die Closing Balance aus Reports - Bank summary pro Xero Tenant Id und Bank Account für letzte Woche, mit einer Konzernsumme.
Ein Konzern-Controller mit mehreren Xero-Organisationen fragt Claude einmal, und die wöchentliche Liquiditätsposition deckt jede Einheit ab statt einer Datei pro Organisation.
Data to AI™ ist während der privaten Vorabversion kostenlos. Wir nehmen Teams in Wellen auf und entwickeln das Produkt mit ihrem Feedback weiter. Zum Launch wird es so abgerechnet wie die KI-Assistenten, die Ihr Team bereits nutzt. Sie brauchen individuelle Verträge oder Mengenpreise? Sprechen Sie mit uns über Enterprise.
Data to AITM
Stellen Sie Claude, ChatGPT und anderen KI-Tools governte Geschäftsdaten über MCP bereit.
Private Vorabversion
Kostenlos in der Vorabversion
Unternehmen
Stellen Sie Dataddo flexibel in jeder Cloud- oder Hybridumgebung bereit.
Jeder Xero-Bericht ist ein eigener Export, und Budget summary führt Monate als Spalten, die jemand umbauen muss, bevor Claude sie mit Ist-Werten vergleichen kann.
Profit and Loss und Reports - Budget summary kommen als Datensätze an, die Claude nach Feld abfragt, mit January bis December als benannten Spalten.
Abweichungen ohne Umbauen
Mehrere Organisationen
Konzerne wiederholen jeden Export pro Xero-Organisation und führen die Dateien zusammen, wobei oft verloren geht, welche Zeile aus welcher Einheit stammt.
Die Multi-Account-Extraktion zieht dieselben Datensätze aus jeder Organisation, und jede Zeile behält ihre Xero Tenant Id, damit Claude aufteilen oder summieren kann.
Konzernsicht in einer Antwort
Arbeiten im Repository
Abschlussskripte lesen CSV-Dateien, die jemand lokal gespeichert hat, und die Checkliste ist veraltet, sobald neue Buchungen in Xero erfasst werden.
Claude Code fragt Trial Balance und Journal Lines über den dataddo-Server ab, wobei Ihre Zugangsdaten im Schlüsselbund des Systems bleiben.
Abschlussdateien aus aktuellen Daten
Frühere Zeiträume
Fragen zum Vorjahr liefern nichts Brauchbares, weil die hochgeladene Datei nur das laufende Quartal abdeckte.
Datensätze mit Datumsbereich wie Invoices lesen ein gleitendes Fenster neu, und eine einmalige vollständige Neusynchronisierung lädt frühere Zeiträume, die Claude abfragen kann.
Frühere Zeiträume abfragbar
Token-Verbrauch
Claude verbraucht Tokens, um rohe Xero-Spalten zu erkunden, Zeilen zu sichten und neu anzusetzen, bis die Daten verstanden sind.
Felddefinitionen und Beziehungen werden vorab geliefert, sodass das Modell die Erkundung überspringt und direkt antwortet.
Weniger Tokens pro Antwort
Antwortqualität
Anfällig für falsche Joins, erfundene Felder und schwer überprüfbare Zahlen.
Antworten auf Basis definierter Felder. Im Dataddo-Benchmark wurden 78,5 % der Fragen korrekt beantwortet, gegenüber 65,5 % mit einfachen CSV-Dateien.
Bessere Antworten
Datensätze
Xero-Datensätze, die Sie in Claude nutzen können
Die Xero-Datensätze, die Finance- und RevOps-Teams am häufigsten nutzen, mit ihren echten Feldnamen. Claude fragt sie über die semantische Schicht von Dataddo beim Namen ab.
Liste kuratierter Datasets
Account IDXero identifierAccountID
string
CodeCustomer defined alpha numeric account codeCode
string
NameName of accountName
string
TypeAccount TypeType
string
Tax TypeTax TypeTaxType
string
Enable Payments To AccountDescribes whether account can have payments applied to itEnablePaymentsToAccount
float
Bank Account NumberBank account number. (Viewable only by Account Type BANK)BankAccountNumber
string
Bank Account TypeWhether it iss 'Bank account','Credit card account' or'Paypal account'. (Viewable only by Account Type BANK)BankAccountType
string
Currency CodeThree-lettered ISO code. (Viewable only by Account Type BANK)CurrencyCode
string
Reporting CodeShown if setReportingCode
string
Reporting Code NameShown if setReportingCodeName
string
Account StatusWhether the account is 'Active' or 'Archived'Status
string
DescriptionDescription of the Account. Valid for all types of accounts except bank accountsDescription
string
The Xero tenant ID to which the account belongsXeroTenantID
string
Report IDReport identifierReportID
string
ReportNameReport nameReportName
string
Balance Sheet ItemBalance Sheet ItemItem
string
Opening BalanceOpening BalanceOpeningBalance
float
Closing BalanceClosing BalanceClosingBalance
float
Date StartDate period startDateStart
datetime
DateStopDate period stopDateStop
datetime
The Xero tenant ID to which the balance sheet belongsXeroTenantID
string
Report IDReport identifierReportID
string
ReportNameReport nameReportName
string
Date StartDate period startDateStart
datetime
DateStopDate period stopDateStop
datetime
Opening BalanceOpening BalanceOpeningBalance
float
Closing BalanceClosing BalanceClosingBalance
float
The Xero tenant ID to which the report belongsXeroTenantID
string
Xero Tenant IdentifierXeroTenantID
string
Contact NameFull name of contact/organisationContactName
empfindlichstring
Xero identifierContactID
string
DateDate of transaction - YYYY-MM-DDDate
datetime
StatusWhether the transaction is 'Authorised' or 'Deleted'Status
string
Line Amount TypesEither Exclusive, Inclusive, or NoTaxLineAmountTypes
string
Line Item DescriptionThe description of the line itemLineItemDescription
string
Line Item Unit AmountUnit amount. By default, the amount is rounded to two decimal placesLineItemUnitAmount
string
Line Item Tax TypeUsed as an override if the default Tax Code for the selected AccountCode is not correctLineItemTaxType
string
Line Item Tax AmountThe tax amount for the line item. If the LineAmountTypes is set to Exclusive, this is the tax on the line amount. If Inclusive, this is the tax on the line amount less the tax amountLineItemTaxAmount
float
Line Item Line AmountThe total of the line including discountLineItemLineAmount
float
Line Item Account CodeAccount codeLineItemAccountCode
string
Line Item QuantityLineItem QuantityLineItemQuantity
float
Line Item IDLineItem IdentifierLineItemID
string
Sub TotalTotal of bank transaction excluding taxesSubTotal
float
TotalTotal of bank transaction tax inclusiveTotal
float
Total TaxTotal tax on bank transactionTotalTax
float
Currency CodeThe currency that bank transaction has been raised inCurrencyCode
string
Bank Transaction IDXero generated unique identifier for bank transactionBankTransactionID
string
Bank Account Account IDBankAccount identifierBankAccountAccountID
string
Bank Account CodeBankAccount code (this value may not always be present for a bank account)BankAccountCode
string
Bank Account NameName of the bank accountBankAccountName
string
TypeBank transaction typeType
string
ReferenceReference for the transactionReference
string
Is ReconciledIt shows if transaction is reconciledIsReconciled
float
Line Item TrackingLineItem TrackingLineItemTracking
string
The Xero Tenant ID for the accountXeroTenantID
string
Bank Transfer IDThe identifier of the Bank TransferBankTransferID
string
DateThe date of the Transfer YYYY-MM-DDDate
datetime
Created DateUTC timestamp of creation date of bank transferCreatedDate
datetime
From Bank Account IDThe ID of the source Bank AccountFromBankAccountId
string
From Bank Account NameThe Name of the source Bank AccountFromBankAccountName
string
To Bank Account IDThe ID of the destination Bank AccountToBankAccountId
string
To Bank Account NameThe Nameof the destination Bank AccountToBankAccountName
string
AmountThe amount being transferredAmount
float
The Bank Transaction ID for the source accountFromBankTransactionID
string
The Bank Transaction ID for the destination accountToBankTransactionID
string
The Xero Tenant ID for the accountXeroTenantID
string
ID of the account used to make the paymentAccountID
string
ReferenceOptional references for the batch payment transactionReference
string
Batch Payment IDThe Xero generated unique identifier for the bank transactionBatchPaymentID
string
DateDate the payment is being made (YYYY-MM-DD)Date
datetime
The ID of the Invoice the payment was made againstInvoiceID
string
Has ErrorsIt shows whether there are errors in the paymentHasErrors
float
Is DiscountedBoolean that tells you whether the payment is discountedIsDiscounted
boolean
The Xero generated unique identifier for the paymentPaymentID
string
Payment ReferenceThe information to appear on the supplier's bank account and bank statementPaymentReference
string
Payment AmountThe amount being paidPaymentAmount
float
TypePAYBATCH for bill payments or RECBATCH for sales invoice payments Type
string
StatusAUTHORISED or DELETEDStatus
string
Total AmountThe total of the payments that make up the batchTotalAmount
float
Is ReconciledBooelan that tells you if the batch payment has been reconciledIsReconciled
float
The Xero Tenant ID for the accountXeroTenantID
string
Contact IDXero identifierContactID
string
Contact StatusCurrent status of a contactContactStatus
string
Account NumberA user defined account numberAccountNumber
string
NameFull name of contact/organisationName
empfindlichstring
First NameFirst name of contact personFirstName
empfindlichstring
Last NameLast name of contact personLastName
empfindlichstring
Email AddressEmail address of contact personEmailAddress
empfindlichstring
Skype User NameSkype user name of contactSkypeUserName
string
Bank Account DetailsBank account number of contactBankAccountDetails
string
Tax NumberTax number of contact - this is also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global)TaxNumber
string
Accounts Receivable Tax TypeDefault tax type used for contact on AR invoicesAccountsReceivableTaxType
string
Accounts Payable Tax TypeDefault tax type used for contact on AP invoicesAccountsPayableTaxType
string
The Xero Tenant ID for the accountXeroTenantID
string
Unique contact identifer related to the credit noteContactID
string
Contact NameContact name related to the credit noteContactName
empfindlichstring
DateThe date the credit note is issued YYYY-MM-DDDate
datetime
StatusEither SUBMITTED, AUTHORISED or PAIDStatus
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
Sub TotalThe subtotal of the credit note excluding taxesSubTotal
float
TotalThe total of the credit Note(subtotal + total tax)Total
float
Total TaxThe total tax on the credit noteTotalTax
float
Currency CodeCurrency used for the credit NoteCurrencyCode
string
TypeCredit note type. Either 'ACCPAYCREDIT' or 'ACCRECCREDIT'Type
ReferenceACCREC only - additional reference numberReference
string
StatusEither DRAFT, SUBMITTED or AUTHORISEDStatus
string
Sub TotalTotal of invoice excluding taxesSubTotal
float
TotalTotal of Invoice tax inclusiveTotal
float
Total TaxTotal tax on invoiceTotalTax
float
TypeEither ACCPAY (supplier invoice) or ACCREC (customer invoice)Type
string
The Xero Tenant ID for the accountXeroTenantID
string
Item IDXero generated identifier for an itemItemID
string
CodeUser defined item codeCode
string
DescriptionThe sales description of the itemDescription
string
Purchase DescriptionThe purchase description of the itemPurchaseDescription
string
Updated DateLast modified date in UTC formatUpdatedDate
datetime
Purchase Details Unit PriceUnit Price of the itemPurchaseDetailsUnitPrice
float
Purchase Details Account CodeDefault account code to be used for purchasePurchaseDetailsAccountCode
string
Purchase Details Tax TypeUsed as an override if the default Tax Code for the selected AccountCode is not correctPurchaseDetailsTaxType
string
Sales Details Unit PriceUnit Price of the itemSalesDetailsUnitPrice
float
Sales Details Account CodeDefault account code to be used for saleSalesDetailsAccountCode
string
Sales Details Tax TypeUsed as an override if the default Tax Code for the selected AccountCode is not correctSalesDetailsTaxType
string
NameThe name of the itemName
string
Is Tracked As InventoryTrue for items that are tracked as inventory. An item will be tracked as inventory if the InventoryAssetAccountCode and COGSAccountCode are set.IsTrackedAsInventory
float
Is SoldBoolean value. When IsSold is true the item will be available on sales transactions in the Xero UI.IsSold
float
Is PurchasedBoolean value. When IsPurchased is true the item is available for purchase transactions in the Xero UI.IsPurchased
float
The Xero Tenant ID for the accountXeroTenantID
string
Account CodeCustomer defined alpha numeric account codeAccountCode
string
Xero identifierAccountID
string
Account NameName of accountAccountName
string
Account TypeType of account (e.g., BANK, ASSET, LIABILITY, etc.)AccountType
string
Gross AmountGross amount of journal lineGrossAmount
Journal DateDate the journal was postedJournalDate
datetime
Net AmountNet amount of journal lineNetAmount
float
Tax AmountTotal tax on a journal lineTaxAmount
float
Source IDThe identifier for the source transactionSourceID
string
Source TypeThe journal source typeSourceType
string
Tax NameName of the tax rateTaxName
string
Tax TypeThe type of the tax (certain parts of the world have different types)TaxType
string
ReferenceAn optional description for the paymentReference
string
Tracking Categories NameThe name of the tracking category associated with the journal entry in XeroTrackingCategories_Name
string
Tracking Categories OptionThe option selected within the tracking category for the journal entry in XeroTrackingCategories_Option
string
Tracking Categories IDThe unique identifier of the tracking category associated with the journal entry in XeroTrackingCategories_ID
string
Tracking Categories option IDThe unique identifier of the option selected within the tracking category for the journal entry in XeroTrackingCategories_optionID
string
Identifier for the Xero tenant associated with the dataXeroTenantID
string
Journal IDUnique identifier for each journal entry in XeroJournalID
string
Journal NumberAutomatically generated journal number by XeroJournalNumber
float
Journal DateDate when the journal was posted in XeroJournalDate
datetime
Created DateDate when the journal was created in Xero (UTC format)CreatedDate
datetime
The Xero Tenant ID for the accountXeroTenantID
string
Account CodeCustomer defined alpha numeric account codeAccountCode
string
Xero identifierAccountID
string
Account NameName of accountAccountName
string
Account TypeType of the accountAccountType
string
Gross AmountGross amount of journal lineGrossAmount
Journal DateDate the journal was postedJournalDate
datetime
Net AmountNet amount of journal lineNetAmount
float
Tax AmountTotal tax on a journal lineTaxAmount
float
Tax NameName of the tax applied to the journal lineTaxName
string
Tax TypeType of tax applied to the journal lineTaxType
string
Tracking Category IDThe identifier for the tracking category associated with the journal lineTrackingCategoryID
string
Tracking Option IDThe identifier for the tracking option associated with the journal lineTrackingOptionID
string
Tracking Category NameThe name of the tracking category associated with the journal lineTrackingCategoryName
string
Tracking OptionThe tracking option associated with the journal lineTrackingOption
string
Source IDThe identifier for the source transactionSourceID
string
Source TypeThe journal source typeSourceType
string
ReferenceAn optional description for the paymentReference
string
The Xero Tenant ID for the accountXeroTenantID
string
Linked Transaction IDThe Xero generated identifier for a linked transactionLinkedTransactionID
string
Source Transaction IDThe identifier of the source transaction (the purchase component of a billable expense)SourceTransactionID
string
Source Line Item IDThe line item identifier from the source transactionSourceLineItemID
string
The identifier for the contact on the target transactionContactID
string
Target Transaction IDThe identifier of the target transactionTargetTransactionID
string
Target Line Item IDThe line item identifier from the target transactionTargetLineItemID
string
StatusThe status of the linked transactionStatus
string
TypeThis will always be BILLABLEEXPENSE. More types may be added in future.Type
string
Updated Date UTCThe last modified date in UTC formatUpdatedDate
datetime
Source Transaction Type CodeACCPAY if the linked transaction was created from an invoice and SPEND if it was created from a bank transactionSourceTransactionTypeCode
string
Manual Journal IDID of the manual journalManualJournalID
string
The Xero Tenant ID for the accountXeroTenantID
string
DateDate journal was posted - YYYY-MM-DDDate
datetime
StatusEither DRAFT, POSTED, DELETED or VOIDEDStatus
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
Updated DateLast modified date UTC formatUpdatedDate
datetime
NarrationDescription of journal being postedNarration
string
Has AttachmentsBoolean to indicate if a manual journal has an attachmentHasAttachments
float
NameDisplay name of organisation shown in XeroName
string
Organisation IDThe Xero generated unique identifier for the organisationOrganisationID
string
XeroTenantID
string
XeroTenantID
string
Xero identifierContactID
string
Contact NameFull name of contact/organisationContactName
empfindlichstring
DateThe date the overpayment was made YYYY-MM-DDDate
datetime
StatusEither AUTHORISED, PAID or VOIDEDStatus
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
Sub TotalThe subtotal of the overpayment excluding taxesSubTotal
float
TotalThe total of the overpayment (subtotal + total tax)Total
float
Total TaxThe total tax on the overpaymentTotalTax
float
Updated DateUTC timestamp of last update to the overpaymentUpdatedDate
string
Currency CodeCurrency used for the overpaymentCurrencyCode
string
AmountAmount of the paymentAmount
float
Bank AmountBank amountBankAmount
float
TypeEither RECEIVE-OVERPAYMENT or SPEND-OVERPAYMENTType
Xero generated unique identifier for invoiceInvoiceID
string
Invoice Contact NameFull name of contact/organisation for invoiceInvoiceContactName
string
Invoice Currency CodeThe currency that invoice has been raised inInvoiceCurrencyCode
string
Invoice Is DiscountedWhether the invoice is discountedInvoiceIsDiscounted
float
Invoice TypeEither ACCPAY (supplier invoice) or ACCREC (customer invoice)InvoiceType
string
Payment TypePayment type (eg. ACCRECPAYMENT,ARCREDITPAYMENT)PaymentType
string
ReferenceAn optional description for the paymentReference
string
StatusEither AUTHORISED or DELETEDStatus
string
Updated DateDate the payment was updatedUpdatedDate
datetime
XeroTenantID
string
Xero identifierContactID
string
Contact NameFull name of contact/organisationContactName
empfindlichstring
DateThe date the prepayment is created YYYY-MM-DDDate
datetime
StatusEither AUTHORISED, PAID or VOIDEDStatus
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
Sub TotalThe subtotal of the prepayment excluding taxesSubTotal
float
TotalThe total of the prepayment (subtotal + total tax)Total
float
Total TaxThe total tax on the prepaymentTotalTax
float
Updated DateUTC timestamp of last update to the prepaymentUpdatedDate
datetime
Fully Paid On DateUTC timestamp when the prepayment was fully paidFullyPaidOnDate
datetime
Currency CodeCurrency used for the prepaymentCurrencyCode
string
TypeEither RECEIVE-PREPAYMENT or SPEND-PREPAYMENTType
string
Unique credit note identifier related to the prepaymentCreditNoteID
string
Credit Note NumberNumber of the credit note related to the prepaymentCreditNoteNumber
string
Currency RateThe currency rate for a multicurrency prepaymentCurrencyRate
float
Remaining CreditThe remaining credit balance on the prepaymentRemainingCredit
float
Has AttachmentsBoolean to indicate if a prepayment has an attachmentHasAttachments
float
The Xero Tenant ID for the accountXeroTenantID
string
Report IDUnique identifier of the related reportReportID
string
Report NameName of the related reportReportName
string
ItemProfit and loss itemItem
string
ValueValue of the profit or lossValue
float
Date StartDate period startDateStart
datetime
Date StopDate period stopDateStop
datetime
Report DateThe date of the report in UTC formatReportDate
datetime
Report NameThe name of the reportReportName
string
Report TitlesThe titles of the report, which may include multiple linesReportTitles
string
Updated Date UTCThe last modified date of the report in UTC formatUpdatedDate
datetime
Account NameThe name of the account associated with the rowAccountName
string
Row LabelThe label of the row, which may include account names or other identifiersRowLabel
string
Row ValueThe value associated with the row, typically a financial amountRowValue
float
Account IDThe identifier for the account, which may be used to link to other datasetsAccountID
string
Date StartThe start date of the reporting period, formatted as Y-m-d H:i:sDateStart
datetime
Date StopThe end date of the reporting period, formatted as Y-m-d H:i:sDateStop
datetime
The Xero Tenant ID for the account, used to identify the specific tenant in XeroXeroTenantID
string
Tracking Category IDThe identifier for the tracking category associated with the reportTrackingCategoryID
string
Tracking Category NameThe name of the tracking category associated with the reportTrackingCategoryName
string
XeroTenantID
string
Identifier of the projectProjectID
string
Identifier of the contact this project was created forContactID
string
NameName of the projectName
string
Currency CodeA project's currency code in ISO-4217 format. Will be set to the organisation's default currency, until a time where Projects supports multi-currency projectsCurrencyCode
string
Minutes LoggedA total of minutes logged against all tasks on the ProjectMinutesLogged
float
Total Task Amount CurrencyTotalTaskAmountCurrency
string
Total Task Amount ValueA summation of the total actuals amount of each project taskTotalTaskAmountValue
float
Total Expense Amount CurrencyA summation of the total actuals amount of each project expenseTotalExpenseAmountCurrency
string
Total Expense Amount ValueA summation of the total actuals amount of each project expenseTotalExpenseAmountValue
float
Minutes To Be InvoicedMinutes which have not been invoiced across all chargeable tasks in the projectMinutesToBeInvoiced
float
Task Amount To Be Invoiced CurrencyA summation of amountToBeInvoiced of each task in the projectTaskAmountToBeInvoicedCurrency
string
Task Amount To Be Invoiced ValueA summation of amountToBeInvoiced of each task in the projectTaskAmountToBeInvoicedValue
float
Task Amount Invoiced CurrencyA summation of amountInvoiced of each task in the projectTaskAmountInvoicedCurrency
string
Task Amount Invoiced ValueA summation of amountInvoiced of each task in the projectTaskAmountInvoicedValue
float
Expense Amount To Be Invoiced CurrencyA summation of 'total' of each expense which is not invoiced in the projectExpenseAmountToBeInvoicedCurrency
string
Expense Amount To Be Invoiced ValueA summation of 'total' of each expense which is not invoiced in the projectExpenseAmountToBeInvoicedValue
float
Expense Amount Invoiced CurrencyA summation of 'total' of each expense which is invoiced in the projectExpenseAmountInvoicedCurrency
string
Expense Amount Invoiced ValueA summation of 'total' of each expense which is invoiced in the projectExpenseAmountInvoicedValue
float
Project Amount Invoiced CurrencyA summation of project amount invoices that is invoiced in the projectProjectAmountInvoicedCurrency
string
Project Amount Invoiced ValueA summation of project amount invoices that is invoiced in the projectProjectAmountInvoicedValue
float
Deposit CurrencyDeposit for the projectDepositCurrency
string
Deposit ValueDeposit for the projectDepositValue
float
Deposit Applied CurrencyDeposit amounts which have been applied to invoice/s as creditDepositAppliedCurrency
string
Deposit Applied ValueDeposit amounts which have been applied to invoice/s as creditDepositAppliedValue
float
Credit Note Amount CurrencyA summation of credit notes in the projectCreditNoteAmountCurrency
string
Credit Note Amount ValueA summation of credit notes in the projectCreditNoteAmountValue
float
Total Invoiced CurrencyA summation of the values taskAmountInvoiced, expenseAmountInvoiced, projectAmountInvoiced, deposit, depositApplied and creditNoteAmountTotalInvoicedCurrency
string
Total Invoiced ValueA summation of the values taskAmountInvoiced, expenseAmountInvoiced, projectAmountInvoiced, deposit, depositApplied and creditNoteAmountTotalInvoicedValue
float
Total To Be Invoiced CurrencyA summation of the values values taskAmountToBeInvoiced and expenseAmountToBeInvoicedTotalToBeInvoicedCurrency
string
Total To Be Invoiced ValueA summation of the values values taskAmountToBeInvoiced and expenseAmountToBeInvoicedTotalToBeInvoicedValue
float
StatusStatus of the projectStatus
string
Etimate CurrencyEstimate for the projectEstimateCurrency
string
Etimate ValueEstimate for the projectEstimateValue
float
Total Task Amount CurrencyA summation of the total actuals amount of each project taskTotalTaskAmountCurrency
string
The Xero Tenant ID for the accountXeroTenantID
string
Purchase Order IDUnique identifier of the purchase orderPurchaseOrderID
string
Purchase Order NumberUnique alpha numeric code identifying purchase orderPurchaseOrderNumber
string
DateDate purchase order was issued - YYYY-MM-DDDate
datetime
Delivery DateDate the goods are to be delivered - YYYY-MM-DDDeliveryDate
datetime
Attention ToThe person that the delivery is going toAttentionTo
empfindlichstring
TelephoneThe phone number for the person accepting the deliveryTelephone
empfindlichstring
ReferenceAdditional reference numberReference
string
Currency CodeThe currency that purchase order has been raised inCurrencyCode
string
Currency RateThe currency rate for a multicurrency purchase orderCurrencyRate
float
StatusEither DRAFT, SUBMITTED, AUTHORISED, BILLED or DELETEDStatus
string
Is DiscountedWhether the order is discountedIsDiscounted
float
Contact NameFull name of contact/organisationContactName
empfindlichstring
Xero identifierContactID
string
Sub TotalTotal of purchase order excluding taxesSubTotal
float
TotalTotal of Purchase Order tax inclusiveTotal
float
Total TaxTotal tax on purchase orderTotalTax
float
TypeType of the purchase order (eg. PURCHASEORDER)Type
string
Quote IDXero generated unique identifier for a quoteQuoteID
string
Quote NumberUnique alpha numeric code identifying a quoteQuoteNumber
string
ReferenceAdditional reference numberReference
string
TermsThe terms of the quoteTerms
string
Contact IDXero identifierContactID
string
Contact NameFull name of contact/organisationContactName
empfindlichstring
Contact Email AddressEmail address of contact personContactEmailAddress
empfindlichstring
Contact First NameFirst name of contact personContactFirstName
empfindlichstring
Contact Last NameLast name of contact personContactLastName
empfindlichstring
DateDate quote was issued - YYYY-MM-DDDate
datetime
StatusActual quote statusStatus
string
Currency RateThe currency rate for a multicurrency quoteCurrencyRate
float
Currency CodeThe currency that quote has been raised inCurrencyCode
string
Sub TotalTotal of quote excluding taxesSubTotal
float
Total TaxTotal tax on quoteTotalTax
float
TotalTotal of Quote tax inclusiveTotal
float
Total DiscountTotal of discounts applied on the quote line itemsTotalDiscount
float
TitleThe title of the quoteTitle
string
SummaryThe summary of the quoteSummary
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
XeroTenantID
string
The Xero Tenant ID for the accountXeroTenantID
string
Quote IDXero generated unique identifier for a quoteQuoteID
string
Quote NumberUnique alpha numeric code identifying a quoteQuoteNumber
string
ReferenceAdditional reference numberReference
string
TermsThe terms of the quoteTerms
string
Xero identifierContactID
string
Contact NameFull name of contact/organisationContactName
empfindlichstring
Contact Email AddressEmail address of contact personContactEmailAddress
empfindlichstring
Contact First NameFirst name of contact personContactFirstName
empfindlichstring
Contact Last NameLast name of contact personContactLastName
empfindlichstring
DateDate quote was issued - YYYY-MM-DDDate
datetime
StatusActual status of the quoteStatus
string
Currency RateThe currency rate for a multicurrency quoteCurrencyRate
float
Currency CodeThe currency that quote has been raised inCurrencyCode
string
Sub TotalTotal of quote excluding taxesSubTotal
float
Total TaxTotal tax on quoteTotalTax
float
TotalTotal of Quote tax inclusiveTotal
float
Total DiscountTotal of discounts applied on the quote line itemsTotalDiscount
float
TitleThe title of the quoteTitle
float
SummaryThe summary of the quoteSummary
string
Line Amount TypesEither Exclusive, Inclusive or NoTaxLineAmountTypes
string
Line Item IDThe Xero generated identifier for a LineItemLineItemID
string
Line Item Account CodeCustomer defined alpha numeric account code LineItemAccountCode
string
Line Item DescriptionThe description of the line itemLineItemDescription
string
Line Item Unit AmountLineitem unit amountLineItemUnitAmount
float
Line Item Discount RatePercentage discount being applied to a line itemLineItemDiscountRate
float
Line Item Line AmountThe line amount reflects the discounted price if a DiscountRate has been usedLineItemLineAmount
float
Line Item Item CodeUser defined item codeLineItemItemCode
string
Line Item QuantityLineItem QuantityLineItemQuantity
float
Line Item Tax AmountThe tax amount is auto calculated as a percentage of the line amount based on the tax rateLineItemTaxAmount
float
Line Item Tax TypeUsed as an override if the default Tax Code for the selected AccountCode is not correctLineItemTaxType
string
Report IDXero identifier for the reportReportID
string
Report NameName of the reportReportName
string
ContactContact name associated with the reportContact
string
DateDate of the invoice or transactionDate
string
Invoice NumberUnique identifier for the invoiceInvoiceNumber
string
Due DateDue date for the payment of the invoiceDueDate
string
DescriptionDescription of the invoice or transactionDescription
string
TotalTotal amount of the invoice or transactionTotal
float
PaidAmount that has been paid towards the invoicePaid
float
CreditedAmount that has been credited towards the invoiceCredited
float
DueAmount that is still due for the invoiceDue
string
Date StartStart date for the report data rangeDateStart
datetime
Date StopEnd date for the report data rangeDateStop
datetime
The Xero tenant ID to which the report belongsXeroTenantID
string
Report IDXero identifierReportID
string
Report NameName of the reportReportName
string
Bank AccountName of the bank accountBankAccount
string
Opening BalanceOpening balance of the bank account at the start of the periodOpeningBalance
float
Cash ReceivedTotal cash received during the periodCashReceived
float
Cash SpentTotal cash spent during the periodCashSpent
float
Closing BalanceClosing balance of the bank account at the end of the periodClosingBalance
float
Date StartStart date of the report periodDateStart
datetime
Date StopEnd date of the report periodDateStop
datetime
The Xero tenant ID to which the report belongsXeroTenantID
string
Report IDThe identifier of the ReportReportID
string
Report NameThe name of the ReportReportName
string
AccountThe name of the accountAccount
string
JanuaryBudget for JanuaryJanuary
float
FebruaryBudget for FebruaryFebruary
float
MarchBudget for MarchMarch
float
AprilBudget for AprilApril
float
MayBudget for MayMay
float
JuneBudget for JuneJune
float
JulyBudget for JulyJuly
float
AugustBudget for AugustAugust
float
SeptemberBudget for SeptemberSeptember
float
OctoberBudget for OctoberOctober
float
NovemberBudget for NovemberNovember
float
DecemberBudget for DecemberDecember
float
The Xero Tenant ID for the accountXeroTenantID
string
YearThe year of the budgetYear
integer
Tenant IDXero identifier for the tenantTenantID
string
Tenant NameDisplay name of the tenant shown in XeroTenantName
string
Tenant TypeXero Tenant TypeTenantType
string
Created DateCreatedDate
datetime
Xero Tenant IdXeroTenantID
string
Tracking Category IDThe Xero identifier for a tracking categoryTrackingCategoryID
string
The Xero Tenant ID for the accountXeroTenantID
string
NameThe name of the tracking categoryName
string
StatusThe status of a tracking categoryStatus
string
Report IDReport identifierReportID
string
ReportNameReport nameReportName
string
The Xero Tenant ID for the accountXeroTenantID
string
Date StartDate period startDateStart
datetime
Date StopDate period stopDateStop
datetime
Account NameAccount NameAccountName
string
Account CodeAccount CodeAccountCode
string
DebitDebitDebit
float
CreditCreditCredit
float
YTD DebitYTD DebitYTDDebit
float
YTD CreditYTD CreditYTDCredit
float
Fehlt ein Dataset, eine Kennzahl oder ein Attribut?
Sag uns, was fehlt, und wir fügen es dem Connector hinzu.
Läuft nach Ihrem Zeitplan, zum Beispiel täglich. Datensätze mit Datumsbereich wie Invoices und Profit and Loss lesen ein gleitendes Fenster neu, ältere Historie erfordert daher eine einmalige vollständige Neusynchronisierung. Contacts und Accounts laden alle aktuellen Einträge.
Mehr richtige Antworten. Halb so viele selbstsichere Fehler.
Wir haben 43 vorab registrierte Fragen zu drei echten Datensätzen gestellt - Google Search Console, HubSpot-Deals und Google Ads - und dieselben Zeilen auf vier Arten an dasselbe Modell geliefert. Nur die Datenschicht hat sich geändert.
78,5 %
der Fragen richtig beantwortet - der beste der vier getesteten Bereitstellungswege
2x
weniger selbstsicher falsche Antworten - 14,0 % der Durchläufe gegenüber 24,0 % und 26,3 %
2,8x
mehr richtige Antworten bei unübersichtlichen CRM-Daten - besser bei 8 Fragen, bei keiner schlechter
Richtig beantwortetAlle 43 Fragen - höher ist besser
Dataddo Data to AI™78,5 %
Generischer SQL-Konnektor71,5 %
CSV-Dateien + Dokumentation69,0 %
CSV-Dateien65,5 %
Falsch, aber als Tatsache dargestelltAnteil der Durchläufe - niedriger ist besser
Dataddo Data to AI™14,0 %
CSV-Dateien + Dokumentation24,0 %
Generischer SQL-Konnektor26,3 %
CSV-Dateien33,3 %
Dasselbe Modell, dieselben Prompts und dieselben Zeilen in jeder Bedingung; 759 bewertete Durchläufe, Referenzantworten vor dem ersten Durchlauf festgelegt. Allein bei Google Search Console schnitten dokumentierte CSV-Dateien genauso gut ab wie Data to AI™ - der Vorteil entsteht bei unübersichtlicheren Daten wie HubSpot-Deals.
Richten Sie in Dataddo eine Xero-Quelle mit Datensätzen wie Invoices, Reports - Aged Receivables Summary und Reports - Bank summary ein und verbinden Sie sie mit einem Claude-Ziel oder AI Model. Fügen Sie dann in Claude den benutzerdefinierten Konnektor Dataddo Data Access mit https://headless.dataddo.com/mcp-data hinzu oder führen Sie in Claude Code claude mcp add aus.
Kann Claude über mehrere Xero-Organisationen hinweg antworten?
Ja. Aktivieren Sie die Multi-Account-Extraktion in der Xero-Quelle. Jede Zeile behält ihre Xero Tenant Id, sodass Claude Zahlen nach Organisation aufteilen oder summieren kann.
Erhält Claude Xero-Berichte oder nur Rohtransaktionen?
Beides. Berichte wie Aged Receivables Summary, Bank summary, Budget summary, Profit and Loss und Trial Balance sind eigene Datensätze, neben Invoices, Payments und Journal Lines.
Warum fehlen in Claude ältere Xero-Daten?
Datensätze mit Datumsbereich wie Invoices lesen bei jedem Lauf ein gleitendes Fenster. Laden Sie frühere Zeiträume mit einer vollständigen Neusynchronisierung, dann kann Claude sie wie aktuelle Daten abfragen.
Kann ich Xero aus Claude Code abfragen?
Ja. Führen Sie claude mcp add --transport http dataddo mit der Data Access-URL aus, melden Sie sich über /mcp an und fragen Sie zu Xero-Entitäten direkt aus Ihrem Terminal, während Sie in einem Repository arbeiten.
Kann Claude in Xero Rechnungen erstellen oder Eingangsrechnungen freigeben?
Nein. Claude liest nur Daten, die Dataddo bereits extrahiert hat, nach Entitäts- und Feldnamen. Dataddo nimmt nie SQL vom Modell an, und nichts wird nach Xero zurückgeschrieben.
Braucht jeder Claude-Nutzer ein eigenes Dataddo-Login?
Bei Team und Enterprise fügt ein Owner den Konnektor einmal hinzu, und jedes Mitglied meldet sich mit seinem eigenen Dataddo-Konto an. Bei Pro und Max fügen Sie ihn selbst hinzu.