Obtenha no Claude respostas sobre contas a receber, contas a pagar e desvio de orçamento a partir dos seus livros atuais do QuickBooks, com os dados de clientes mascarados antes que o modelo os veja.
Quais clientes nos devem mais, e qual é a idade da fatura em aberto mais antiga de cada um?
ClaudeResposta · QuickBooks
Northwind Supply tem o maior saldo em aberto, US$ 19.400, quase tanto quanto os dois clientes seguintes somados (US$ 22.460). A fatura em aberto mais antiga dele venceu em 14 jul.
Customer name
Open balance
Due date mais antiga
Northwind SupplyAR Aging Detail Report
US$ 19.400
14 jul 2026
Bluebird StudioAR Aging Detail Report
US$ 12.180
3 ago 2026
Harbor DentalAR Aging Detail Report
US$ 10.280
21 ago 2026
O Open balance vem do AR Aging Detail Report, que traz todos os dados atuais a cada execução, e não da soma do histórico de faturas.
fonte
QuickBooks · em seg 06:40 UTC
cobre
Itens em aberto em 28 set 2026
Pergunte ao Claude sobre seus dados de QuickBooks...
Resposta de exemplo · conta e números fictícios
QuickBooks no Claude
Perguntas que o Claude responde com seus dados de QuickBooks
O QuickBooks é um software de contabilidade para pequenas e médias empresas. A Dataddo extrai as transações e os relatórios padrão, de faturas e contas de fornecedores a aging de contas a receber e a pagar, fluxo de caixa e demonstração de resultados.
Preparação da cobrança em uma conversa
Pergunte ao Claude
Quais clientes no AR Aging Detail Report têm Open balance com mais de 60 dias após a Due date? Agrupe por Customer name, do maior para o menor.
Antes da reunião semanal de cobrança, o especialista em contas a receber recebe a lista de atrasos e depois pede os Payments por trás de cada nome, em vez de remontar a planilha de aging.
Orçado versus realizado
Pergunte ao Claude
Onde estamos acima do orçamento neste ano? Compare Budget Detail - Amount por conta com os totais de Account correspondentes em Profit and Loss V2.
No fechamento do mês, o controller alinha Budgets com o resumo de resultados em um único chat e depois detalha em Profit and Loss Detail as linhas que passaram do planejado.
Resumo de aging pelo Claude Code
Pergunte ao Claude
Consulte o AR Aging Detail Report pelo servidor dataddo e grave o Open balance vencido por Customer name em reports/ar-aging.md.
Um analista financeiro que mantém as notas de fechamento em um repositório deixa o Claude Code gerar a seção de aging com dados atuais, em vez de colar números à mão.
O Data to AI™ é gratuito durante o pré-lançamento privado. Integramos equipes em ondas e evoluímos o produto com o feedback delas. No lançamento, a cobrança será como a dos assistentes de IA que sua equipe já usa. Precisa de contratos personalizados ou preços por volume? Fale conosco sobre o Enterprise.
Data to AITM
Entregue dados de negócio governados ao Claude, ChatGPT e outras ferramentas de IA via MCP.
Pré-lançamento privado
Grátis durante o pré-lançamento
Enterprise
Implante o Dataddo com flexibilidade em qualquer ambiente de nuvem ou híbrido.
Personalizado
Temos um modelo de pagamento que funciona para você
O relatório de aging, a lista de faturas e os pagamentos são gerados e exportados separadamente e depois anexados a um chat do Claude como arquivos.
O Claude lê AR Aging Detail Report, Invoices e Payments pelo conector Dataddo Data Access, ativado no menu + de qualquer chat.
Nenhuma exportação para anexar
Nomes e contatos de clientes
Uma exportação do razão geral ou de clientes coloca o nome de cada cliente e fornecedor em um arquivo compartilhado com o modelo.
Exclua colunas ou aplique hash a elas ao criar a fonte, para que os nomes brutos nunca cheguem ao Claude, enquanto os valores com hash continuam cruzando entre datasets.
Dados pessoais ficam de fora
Históricos grandes de transações
Um histórico longo de faturas exportado de uma vez é fácil de cortar, e o Claude não tem como saber que o arquivo anexado está incompleto.
Carregue o histórico com um backfill de dados em lotes de até 1.000 linhas, o limite da API do QuickBooks, e o Claude consulta o fluxo inteiro.
Histórico completo para perguntar
Controle sobre cada ferramenta
Tudo o que é enviado a um chat fica totalmente visível, sem nenhuma etapa entre a pergunta e os dados.
O Claude mostra as permissões das ferramentas da Dataddo, e você escolhe se cada ferramenta roda livremente ou pede confirmação antes.
Você decide o que roda
Consumo de tokens
O Claude gasta tokens explorando colunas brutas de QuickBooks, amostrando linhas e tentando de novo até entender os dados.
Definições de campos e relações chegam prontas, então o modelo pula a exploração e vai direto à resposta.
Menos tokens por resposta
Qualidade das respostas
Sujeito a joins errados, campos inventados e números difíceis de conferir.
Respostas baseadas em campos definidos. No benchmark da Dataddo, 78,5% das perguntas foram respondidas corretamente, contra 65,5% com arquivos CSV simples.
Respostas melhores
Datasets
Datasets de QuickBooks que você pode usar no Claude
Os datasets de QuickBooks que equipes de finanças e RevOps mais usam, com os nomes reais dos campos. O Claude consulta cada um pelo nome por meio da camada semântica da Dataddo.
Lista de datasets curados
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Transaction datetx_date
datetime
Transaction typetxn_type
string
Document numberdoc_num
string
Vendorvend_name
confidencialstring
Due datedue_date
datetime
Past duepast_due
integer
Amountamount
float
Open balanceopen_balance
float
Categorycategory
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Transaction datetx_date
string
Transaction typetxn_type
string
Document numberdoc_num
string
Vendorvend_name
confidencialstring
Due datedue_date
datetime
Past duepast_due
integer
Amountamount
float
Open balanceopen_balance
float
Sectionsection
string
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Transaction datetx_date
datetime
Transaction typetxn_type
string
Document numberdoc_num
string
Customer namecust_name
confidencialstring
Locationlocation
string
Due datedue_date
datetime
Amountamount
float
Open balanceopen_balance
float
Categorycategory
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Transaction datetx_date
string
Transaction typetxn_type
string
Document numberdoc_num
string
Customer namecust_name
confidencialstring
Locationdept_name
string
Due datedue_date
datetime
Amountsubt_amount
float
Open balancesubt_open_balance
float
Sectionsection
string
Account Sub TypeThe account sub-type classificationAccountSubType
string
Account TypeA detailed account classification that specifies the use of this accountAccountType
string
ClassificationThe classification of an account.Classification
string
Account NumberUser-defined account numberAcctNum
string
ActiveWhether is the account active or notActive
integer
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Current BalanceSpecifies the balance amount for the current AccountCurrentBalance
float
Current Balance With Sub AccountsSpecifies the cumulative balance amount for the current Account and all its sub-accountsCurrentBalanceWithSubAccounts
float
Fully Qualified NameFully qualified name of the objectFullyQualifiedName
string
IDUnique identifier for this objectid
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
NameUser recognizable name for the AccountName
string
ParentThe ID for the referenced object as found in the Id field of the object payloadParent
string
Sub AccountSpecifies whether this object represents a parent (false) or subaccount (true)SubAccount
integer
Sync TokenVersion number of the objectSyncToken
string
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
account
string
totaltotal
float
Categorycategory
string
Sub-categorysubcategory
string
Sub-sub-categorysubsubcategory
string
Sub-sub-sub-categorysubsubsubcategory
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Accountaccount
string
Totaltotal
float
Sectionsection
string
Bank Account NameAn identifying name for the Bank AccountBankAccountName
string
Bank AccountThe ID for the Bank AccountBankAccount
float
Print StatusPrinting status of the invoicePrintStatus
string
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
The ID for the departmentDepartment
string
IDUnique identifier for this objectid
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Pay TypeThe payment typePayType
string
Private NoteUser entered, organization-private note about the transactionPrivateNote
string
Sync TokenVersion number of the objectSyncToken
string
Total AmountIndicates the total amount of the transactionTotalAmt
float
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Vendor NameAn identifying name for the vendorVendorName
confidencialstring
The ID for the vendorVendor
string
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
AP Account NameAn identifying name for the AP AccountAPAccountName
string
AP AccountThe ID for the AP AccountAPAccount
string
BalanceThe balance reflecting any payments made against the transactionBalance
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Department NameAn identifying name for the departmentDepartmentName
string
DepartmentThe ID for the departmentDepartment
string
Doc NumberReference number for the transactionDocNumber
string
Due DateDate when the payment of the transaction is dueDueDate
datetime
IDUnique identifier for this objectid
float
Transaction ID of the related transactionLinkedTxnId
string
Linked Transaction TypeTransaction type of the linked objectLinkedTxnType
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Private NoteUser entered, organization-private note about the transactionPrivateNote
string
Sync TokenVersion number of the objectSyncToken
string
Total AmountIndicates the total amount of the transactionTotalAmt
float
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Vendor NameAn identifying name for the vendorVendorName
confidencialstring
The ID for the vendorVendor
string
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Line IDLine_Id
string
Line NumLine_LineNum
integer
Line DescriptionLine_Description
string
Line AmountLine_Amount
float
Line Detail TypeLine_DetailType
string
Line Billable StatusLine_BillableStatus
string
Line AccountRef ValueLine_AccountRef_value
string
Line Tax Code RefLine_TaxCodeRef_value
string
Line Account Ref NameLine_AccountRef_name
string
ActiveWhether or not active inactive accounts may be hidden from most display purposes and may not be posted toActive
boolean
Budget Detail - Account Reference - ValueReference to the Account associated with this BudgetDetailBudgetDetail_AccountRef_value
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Budget Detail - Budget DateDate of the individual BudgetDetailBudgetDetail_BudgetDate
datetime
Create TimeTime the entity was created in the source domainCreateTime
datetime
Budget TypeBudget typesBudgetType
string
IDUnique identifier for this objectId
string
End DateBudget end dateEndDate
datetime
Budget Entry TypePeriod that this budget detail coversBudgetEntryType
string
Sync TokenVersion number of the objectSyncToken
string
Budget Detail - AmountAmount assigned to a BudgetDetailBudgetDetail_Amount
float
Budget Detail - Account Reference - NameReference to the Account associated with this BudgetDetailBudgetDetail_AccountRef_name
string
DomainThe source domaindomain
string
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Start DateBudget begin dateStartDate
datetime
NameUser recognizable name for the AccountName
string
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Date MacrodateMacro
string
Timetime
datetime
account
string
totaltotal
float
Categorycategory
string
Subcategorysubcategory
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Date Macrodate_macro
string
Timetime
datetime
account
string
totaltotal
float
Sectionsection
string
ActiveIf true, this entity is currently enabled for use by QuickBooksActive
integer
Fully Qualified NameFully qualified name of the entityFullyQualifiedName
string
NameUser recognizable name for the ClassName
string
Sub ClassSpecifies whether this object is a subclassSubClass
float
Sync TokenVersion number of the objectSyncToken
string
IDUnique identifier for this objectid
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Credit Memo IDid
string
Transaction Datetxn_date
datetime
Document Numberdoc_number
string
Customer Namecustomer_ref_name
string
Customer IDcustomer_ref_value
string
Billing Address IDbill_addr_id
string
Total Amounttotal_amt
float
Remaining Creditremaining_credit
float
Sync Tokensync_token
string
Sparsesparse
integer
Line IDline_id
string
Line Numberline_line_num
integer
Line Amountline_amount
float
Line Descriptionline_description
string
Line Detail Typeline_detail_type
string
Item Nameline_item_ref_name
string
Item IDline_item_ref_value
string
Item Account Nameline_item_account_ref_name
string
Item Account IDline_item_account_ref_value
string
Line Quantityline_qty
float
Line Unit Priceline_unit_price
float
ActiveIf true, this entity is currently enabled for use by QuickBooksActive
boolean
BalanceSpecifies the open balance amount or the amount unpaid by the customerBalance
float
Balance With JobsCumulative open balance amount for the Customer (or Job) and all its sub-jobsBalanceWithJobs
float
Bill Address - CityCity nameBillAddrCity
string
Bill Address - Country Sub Division CodeRegion within a countryBillAddrCountrySubDivisionCode
string
Bill Address - CountryCountry nameBillAddrCountry
string
Billing Address - IDUnique identifier of the QuickBooks object for the addressBillAddrId
string
Billing Address - Line 11st line of the addressBillAddrLine1
confidencialstring
Billing Address - Line 22nd line of the addressBillAddrLine2
confidencialstring
Billing Address - Postal CodePostal codeBillAddrPostalCode
confidencialstring
Billing With ParentIf true, this Customer object is billed with its parentBillWithParent
boolean
Company NameThe name of the company associated with the person or organizationCompanyName
string
Currency NameThe full name of the currencyCurrencyName
string
CurrencyThe three letter string representing the ISO 4217 code for the currencyCurrency
string
Display NameThe name of the person or organization as displayedDisplayName
confidencialstring
Fully Qualified NameFully qualified name of the customerFullyQualifiedName
confidencialstring
IDUnique identifier for this objectid
string
JobIf true, this is a Job or sub-customerJob
boolean
LevelSpecifies the level of the hierarchy in which the entity is located. Zero specifies the top level of the hierarchy; anything above will be level with respect to the parent. Constraints:up to 5 levelsLevel
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Parent Ref ValueA reference to a value of the customer object that is the immediate parent of the Sub-Customer/Job in the hierarchical Customer:Job listParentRefValue
string
Parent Ref NameA reference to a name of customer object that is the immediate parent of the Sub-Customer/Job in the hierarchical Customer:Job listParentRefName
Print On Check NameName of the person or organization as printed on a checkPrintOnCheckName
confidencialstring
SSNSocial security number (SSN) of the employeeSSN
confidencialstring
TitleTitle of the personTitle
string
Released DateRelease date of the employeeReleasedDate
datetime
Create TimeTime the employee was created in the source domainCreateTime
datetime
Last Updated TimeTime the employee was last updated in the source domainLastUpdatedTime
datetime
Sync TokenVersion number of the objectSyncToken
string
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Transaction datetx_date
datetime
Transaction typetxn_type
string
Document numberdoc_num
string
Namename
string
Memomemo
string
Account nameaccount_name
string
Splitsplit
string
Amountamount
float
Balancebalance
float
Categorycategory
string
Subcategorysubcategory
string
Subsubcategorysubsubcategory
string
Subsubsubcategorysubsubsubcategory
string
Subsubsubsubcategorysubsubsubsubcategory
string
Class Nameclass_name
string
account_id
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Transaction datetx_date
string
Transaction typetxn_type
string
Document numberdoc_num
string
Namename
string
Memomemo
string
Account nameaccount_name
string
Splitsplit_acc
string
Amountsubt_nat_amount
float
Balancerbal_nat_amount
float
Sectionsection
string
Class Nameklass_name
string
account_id
string
IDUnique identifier for this objectid
string
Allow Online ACH PaymentSpecifies if this invoice can be paid with online bank transfers and corresponds to the Free bank transfer online payment check box on the QuickBooks UIAllowOnlineACHPayment
integer
Allow Online Credit Card PaymentSpecifies if online credit card payments are allowed for this invoice and corresponds to the Cards online payment check box on the QuickBooks UIAllowOnlineCreditCardPayment
integer
Apply Tax After DiscountIf false or null, calculate the sales tax first, and then apply the discountApplyTaxAfterDiscount
integer
Customer MemoUser-entered message to the customer; this message is visible to end user on their transactions.CustomerMemo
string
BalanceThe balance reflecting any payments made against the transactionBalance
float
Billing Address - CityCity nameBillAddrCity
string
Billing Address - Country Sub Division CodeRegion within a countryBillAddrCountrySubDivisionCode
string
Billing Address - IDUnique identifier of the QuickBooks object for the address, used for modifying the addressBillAddrId
string
Billing Address - Address Line 1First line of the addressBillAddrLine1
confidencialstring
Billing Address - Address Line 2Second line of the addressBillAddrLine2
confidencialstring
Billing Address - Postal CodePostal codeBillAddrPostalCode
confidencialstring
Billing Address - EmailIdentifies the e-mail address where the invoice is sentBillEmail
confidencialstring
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Customer NameAn identifying name for the customerCustomerName
confidencialstring
The ID for the customerCustomerValue
float
Delivery TimeDelivery date and timeDeliveryTime
datetime
Delivery TypeType of the deliveryDeliveryType
string
Department NameAn identifying name for the departmentDepartmentName
string
The ID for the departmentDepartmentValue
string
Doc NumberReference number for the transactionDocNumber
string
Due DateDate when the payment of the transaction is dueDueDate
datetime
E-Invoice StatusStatus of the eletronic invoiceEInvoiceStatus
string
Email StatusEmail status of the invoiceEmailStatus
string
Created TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Print StatusPrinting status of the invoicePrintStatus
string
Sales TermThe ID for the sales termSalesTerm
string
Sync TokenVersion number of the objectSyncToken
string
Total AmountIndicates the total amount of the transactionTotalAmt
float
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Linked Transaction IDTransaction Id of the related transactionLinkedTxnId
string
Linked Transaction TypeTransaction type of the linked objectLinkedTxnType
string
Invoice IDinvoice_id
string
Transaction Dateinvoice_txn_date
datetime
Document Numberinvoice_doc_number
string
Customer Namecustomer_ref_name
confidencialstring
Customer IDcustomer_ref_value
string
Billing Address IDbill_addr_id
string
Total Amountinvoice_total_amt
float
Sparseinvoice_sparse
integer
Line IDline_id
string
Line Numberline_line_num
integer
Line Amountline_amount
float
Line Descriptionline_description
string
Line Detail Typeline_detail_type
string
Item Nameline_item_ref_name
string
Item IDline_item_ref_value
string
Item Account Nameline_item_account_ref_name
string
Item Account IDline_item_account_ref_value
string
Line Quantityline_qty
float
Line Unit Priceline_unit_price
float
IDUnique identifier for this objectid
string
NameName of the itemName
string
ActiveIf true, the object is currently enabled for use by QuickBooksActive
integer
Fully Qualified NameFully qualified name of the itemFullyQualifiedName
string
SKUStock keeping unit designator for the itemSku
string
Income Account NameAn identifying name for the income accountIncomeAccountName
string
The ID for the income accountIncomeAccountValue
string
LevelSpecifies the level of the hierarchy in which the entity is locatedLevel
integer
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Parent NameAn identifying name for the parentParentName
string
Parent IDThe ID for the parentParentValue
string
Purchase CostAmount paid when buying or ordering the item, as expressed in the home currencyPurchaseCost
float
Purchase Tax IncludedTrue if the purchase tax is included in the item amount, and therefore is not calculated for the transactionPurchaseTaxIncluded
integer
Sales Tax IncludedTrue if the sales tax is included in the item amount, and therefore is not calculated for the transactionSalesTaxIncluded
integer
Sub ItemIf true, this is a sub item. If false or null, this is a top-level item.SubItem
integer
Sync TokenVersion number of the objectSyncToken
string
TaxableIf true, transactions for this item are taxable. Applicable to US companies, only.Taxable
integer
Quantity On HandCurrent quantity of the Inventory items available for saleQtyOnHand
float
TypeClassification that specifies the use of this itemType
string
Unit PriceCorresponds to the Price/Rate column on the QuickBooks Online UI to specify either unit price, a discount, or a tax rate for itemUnitPrice
float
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
IDUnique identifier for this objectid
string
AdjustmentIndicates the total amount of the transactionAdjustment
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Doc NumberReference number for the transactionDocNumber
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Sync TokenVersion number of the objectSyncToken
string
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Line item - AmountThe amount of the line itemLine_Amount
float
Line item - DescriptionFree form text description of the line item that appears in the printed recordLine_Description
string
Line item - IDThe Id of the line itemLine_Id
string
Line item - Account NameAccount name related to the line itemLine_AccountName
string
Account ID related to the line itemLine_AccountID
string
Line item - Posting TypePosting type of the line itemLine_PostingType
string
Line item - Entity NameEntity name related to the line itemLine_EntityName
string
Line Entity ValueLine_EntityValue
string
Line item - Entity IDEntity ID related to the line itemLine_EntityID
string
Line item - Tax AmountTax amount of the line itemLine_TaxAmount
float
Line item - Tax Applicable OnOn what the tax is applicable onLine_TaxApplicableOn
string
Line item - Tax CodeTax code fo the taxLine_TaxCode
string
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
IDUnique identifier for this objectid
string
The ID for the customerCustomerID
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Customer NameAn identifying name for the customerCustomerName
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
Process PaymentWhether the payment is processedProcessPayment
integer
Sync TokenVersion number of the objectSyncToken
string
Total AmountIndicates the total amount of the transactionTotalAmt
float
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Unapplied AmountIndicates the amount that has not been applied to pay amounts owed for sales transactionsUnappliedAmt
float
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Itemitem
string
Valuevalue
string
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Transaction datetx_date
datetime
Transaction typetxn_type
string
Document numberdoc_num
string
Namename
string
Dept Namedept_name
string
Klass Nameklass_name
string
Memomemo
string
Splitsplit
string
Amountamount
float
Balancebalance
float
Categorycategory
string
Subcategorysubcategory
string
Subsubcategorysubsubcategory
string
Subsubsubcategorysubsubsubcategory
string
Subsubsubsubcategorysubsubsubsubcategory
string
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Accountaccount
string
Totaltotal
float
Sectionsection
string
IDUnique identifier for this objectid
string
Doc NumberReference number for the transactionDocNumber
string
Sync TokenVersion number of the objectSyncToken
string
Vendor NameAn identifying name for the vendorVendorName
string
The ID for the vendorVendorID
string
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Total AmountIndicates the total amount of the transactionTotalAmt
float
Ap Account NameAn identifying name for the ap accountAPAccountName
string
The id for the ap accountAPAccountID
string
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the iso 4217 code for the currencyCurrency
string
Department NameAn identifying name for the departmentDepartmentName
string
The id for the departmentDepartmentID
string
Email StatusEmail status of the purchase orderEmailStatus
string
Line AmountThe amount of the line itemLine_Amount
float
Line IdThe id of the line itemLine_Id
string
Line DescriptionFree form text description of the line item that appears in the printed recordLine_Description
string
Line Expense Item NameAn identifying name for the item expenseLine_Expense_ItemName
string
The id for the line item expenseLine_Expense_ItemID
string
Line Expense Customer NameAn identifying name for the customerLine_Expense_CustomerName
confidencialstring
Line Expense Customer IDThe id for the customerLine_Expense_CustomerID
string
Line Expense Billable StatusThe billable statusLine_Expense_BillableStatus
string
Line Expense Tax CodeCode of the used taxLine_Expense_TaxCode
string
Line Expense QuantityNumber of items for the lineLine_Expense_Qty
float
Line Expense Unit PriceUnit price of the subject item as referenced by itemrefLine_Expense_UnitPrice
float
PO StatusPurchase order statusPOStatus
string
Ship Address IdUnique identifier of the quickbooks object for the shipping addressShipAddrId
string
Shipping Address Line 11st line of the addressShipAddrLine1
confidencialstring
Shipping Address Line 22nd line of the addressShipAddrLine2
confidencialstring
Shipping Address Line 33rd line of the addressShipAddrLine3
confidencialstring
Vendor Address CityVendor's city nameVendorAddrCity
string
Vendor Address CountryVendor's country nameVendorAddrCountry
string
Vendor Address Country Subdivision CodeVendor's region of the related countryVendorAddrCountrySubDivisionCode
string
Vendor Address IdUnique identifier of the quickbooks object for the vendor's addressVendorAddrId
string
Vendor Address Line 1Vendor's 1st address lineVendorAddrLine1
confidencialstring
Vendor Address Postal CodeVendor's postal codeVendorAddrPostalCode
confidencialstring
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Linked Transaction IdTransaction id of the related transactionLinkedTxnId
string
Linked Transaction TypeTransaction type of the linked objectLinkedTxnType
string
IDUnique identifier for this objectid
string
ActiveIf true, the object is currently enabled for use by QuickBooksActive
integer
Account NameThe ID for the accountAccountName
string
An identifying name for the accountAccountID
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Doc NumberReference number for the transactionDocNumber
string
Entity NameAn identifying name for the entityEntityName
string
Entity IDThe ID for the entityEntityID
string
Entity TypeThe type of the entityEntityType
string
Global Tax CalculationMethod in which tax is appliedGlobalTaxCalculation
string
Line item - Account NameAn identifying name for the accountLine_AccountName
string
Line item - Account IDThe ID for the accountLine_AccountID
string
Line item - Billable StatusThe billable status of the expenseLine_BillableStatus
string
Line item - Tax CodeThe ID for the tax codeLine_TaxCode
string
Line item - AmountThe amount of the line itemLine_Amount
float
Line item - DescriptionFree form text description of the line item that appears in the printed recordLine_Description
string
Line item - IDThe Id of the line itemLine_Id
string
Payment TypeType can be Cash, Check, or CreditCardPaymentType
string
Sync TokenVersion number of the objectSyncToken
string
Total AmountIndicates the total amount of the transactionTotalAmt
float
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
IDUnique identifier for this objectid
string
ActiveIf true, this entity is currently enabled for use by QuickBooksActive
boolean
NameUser recognizable name for the tax codeName
string
DescriptionDescription of the tax codeDescription
string
TaxableIf true, transactions for this tax code are taxableTaxable
boolean
Sales Tax Rate ListList of tax rates that apply for sales transactions when this tax code represents a group of tax ratesSalesTaxRateList
json
Purchase Tax Rate ListList of tax rates that apply for purchase transactions when this tax code represents a group of tax ratesPurchaseTaxRateList
json
Sync TokenVersion number of the objectSyncToken
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
boolean
IDUnique identifier for this objectid
string
ActiveIf true, this entity is currently enabled for use by QuickBooksActive
integer
Due DaysNumber of days from delivery of goods or services until the payment is dueDueDays
integer
Discount DaysDiscount applies if paid within this number of daysDiscountDays
integer
Discount PercentDiscount percentage available against an amount if paid within the days specified by DiscountDaysDiscountPercent
float
NameUser recognizable name for the termName
string
Sync TokenVersion number of the objectSyncToken
string
TypeType of the Sales TermType
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
IDUnique identifier for this objectid
string
Billable StatusBillable status of the time recordedBillableStatus
string
Class NameAn identifying name for the classClassName
string
Class IDThe ID for the classClassId
string
Customer NameAn identifying name for the customerCustomerName
confidencialstring
The ID for the customerCustomerId
string
DescriptionDescription of work completed during time activityDescription
string
Employee NameAn identifying name for the employeeEmployeeName
confidencialstring
The ID for the employeeEmployeeId
float
Hourly RateHourly bill rate of the employee or vendor for this time activityHourlyRate
float
HoursHours and minutes workedHours
float
Item NameAn identifying name for the itemItemName
string
The ID for the itemItemId
float
MinutesMinutes workedMinutes
float
Name OfEnumeration of time activity types. Valid values: Vendor or Employee.NameOf
string
Sync TokenVersion number of the objectSyncToken
string
TaxableTrue if the time recorded is both billable and taxableTaxable
integer
Transaction DateThe date for the time activityTxnDate
datetime
Vendor NameAn identifying name for the vendorVendorName
confidencialstring
The ID for the vendorVendorId
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Report NamereportName
string
Currencycurrency
string
Start PeriodstartPeriod
datetime
End PeriodendPeriod
datetime
Transaction datedate
datetime
Transaction typetransaction_type
string
Document numberdoc_num
string
Postingposting
string
Namename
string
Storestore
string
Memomemo
string
Account nameaccount_name
string
Splitsplit
string
Amountamount
float
Report Namereport_name
string
Currencycurrency
string
Start Periodstart_period
datetime
End Periodend_period
datetime
Transaction datetx_date
datetime
Transaction typetxn_type
string
Document numberdoc_num
string
Postingis_no_post
string
Namename
string
Locationdept_name
string
Memomemo
string
Account nameaccount_name
string
Splitother_account
string
Amountsubt_nat_amount
float
Sectionsection
string
IDUnique identifier for this objectid
string
AmountIndicates the total amount of the transactionAmount
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
From Account NameAn identifying name for the account from which the transaction is madeFromAccountName
string
The ID for the account from which the transaction is madeFromAccountID
string
Private NoteUser entered, organization-private note about the transactionPrivateNote
string
Sync TokenVersion number of the objectSyncToken
string
To Account NameAn identifying name for the account to which the transfer is madeToAccountName
string
The ID for the account to which the transfer is madeToAccountID
string
Transaction DateThe date entered by the user when this transaction occurredTxnDate
datetime
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
boolean
IDUnique identifier for this objectid
float
ActiveIf true, this object is currently enabled for use by QuickBooksActive
integer
BalanceSpecifies the open balance amount or the amount unpaid by the customerBalance
float
Currency NameThe full name of the currencyCurrencyName
string
CurrencyA three letter string representing the ISO 4217 code for the currencyCurrency
string
Given NameGiven name or first name of a personGivenName
confidencialstring
Display NameThe name of the vendor as displayedDisplayName
confidencialstring
Family NameFamily name or the last name of the personFamilyName
confidencialstring
Print On Check NameName of the person or organization as printed on a checkPrintOnCheckName
confidencialstring
Sync TokenVersion number of the objectSyncToken
float
Vendor 1099This vendor is an independent contractor; someone who is given a 1099-MISC form at the end of the yearVendor1099
integer
Primary EmailPrimary email addressPrimaryEmail
confidencialstring
Bill Address - CityCity nameBillAddrCity
string
Bill Address - Line 11st line of the addressBillAddrLine1
confidencialstring
Bill Address - Postal CodePostal codeBillAddrPostalCode
confidencialstring
Bill Address - Country Sub Division CodeRegion of the countryBillAddrCountrySubDivisionCode
string
Bill Address - CountryCountry nameBillAddrCountry
string
Bill Address - IDUnique identifier of the QuickBooks object for the addressBillAddrId
string
Primary PhonePrimary phone numberPrimaryPhone
confidencialstring
Account NumberName or number of the account associated with this vendorAcctNum
string
Company NameThe name of the company associated with the person or organizationCompanyName
string
Web Address URIUniform Resource Identifier for the web siteWebAddrURI
string
Create TimeTime the entity was created in the source domainCreateTime
datetime
Last Updated TimeTime the entity was last updated in the source domainLastUpdatedTime
datetime
DomainThe source domaindomain
string
SparseTrue if the entity representation has a partial set of elementssparse
integer
Precisa de um dataset, métrica ou atributo que não vê?
Diga-nos o que falta e nós adicionaremos ao conector.
Executa no agendamento que você definir, por exemplo diariamente. A API do QuickBooks retorna até 1.000 linhas por lote, então históricos maiores são carregados em vários lotes com um backfill de dados.
Mais respostas certas. Metade dos erros confiantes.
Fizemos 43 perguntas pré-registradas sobre três conjuntos de dados reais - Google Search Console, negócios do HubSpot e Google Ads - e entregamos as mesmas linhas ao mesmo modelo de quatro formas. Só a camada de dados mudou.
78,5%
das perguntas respondidas corretamente - o melhor dos quatro métodos de entrega testados
2x
menos respostas erradas dadas com confiança - 14,0% das execuções contra 24,0% e 26,3%
2,8x
mais respostas corretas em dados de CRM bagunçados - melhor em 8 perguntas, pior em nenhuma
Respostas corretasTodas as 43 perguntas - maior é melhor
Dataddo Data to AI™78,5%
Conector SQL genérico71,5%
Arquivos CSV + documentação69,0%
Arquivos CSV65,5%
Erradas, mas apresentadas como fatoParcela das execuções - menor é melhor
Dataddo Data to AI™14,0%
Arquivos CSV + documentação24,0%
Conector SQL genérico26,3%
Arquivos CSV33,3%
Mesmo modelo, mesmos prompts e mesmas linhas em todas as condições; 759 execuções avaliadas, com o gabarito definido antes de qualquer execução. Só no Google Search Console, os arquivos CSV documentados tiveram o mesmo desempenho do Data to AI™ - a vantagem vem de dados mais complexos, como os negócios do HubSpot.
Crie uma fonte QuickBooks na Dataddo com datasets como Invoices, Payments e AR Aging Detail Report e vincule-a a um destino Claude ou a um AI Model. No Claude, adicione um conector personalizado com a URL https://headless.dataddo.com/mcp-data e faça login. No Claude Code, execute claude mcp add.
Como o Claude acessa os meus dados do QuickBooks?
A Dataddo extrai os dados do QuickBooks de forma agendada e os disponibiliza pelo servidor MCP Data Access. O Claude se conecta a esse servidor com o seu login da Dataddo, nunca diretamente ao QuickBooks, e lê apenas fluxos vinculados a um destino de IA ou a um AI Model.
O Claude pode alterar lançamentos no QuickBooks?
Não. O Claude apenas consulta dados que a Dataddo já extraiu, por nome de entidade e de campo, e a Dataddo nunca aceita SQL do modelo. Nada é gravado de volta nos seus livros, então faturas e pagamentos ficam como você os lançou.
Posso usar dados do QuickBooks no Claude Code?
Sim. Adicione o servidor com claude mcp add, faça login com /mcp ou claude mcp login dataddo, e o Claude Code poderá consultar as mesmas entidades do QuickBooks enquanto você trabalha em um repositório.
Como mantenho os nomes dos clientes fora do Claude?
Exclua as colunas ao criar a fonte QuickBooks ou aplique hash a elas. Valores com hash continuam cruzando entre datasets, então o Claude consegue associar faturas a pagamentos, mas os nomes brutos nunca chegam ao modelo.
O Claude vê todo o meu histórico do QuickBooks?
O Claude vê o que o fluxo vinculado contém. A API do QuickBooks retorna até 1.000 linhas por lote, então históricos longos de faturas são carregados em vários lotes com um backfill de dados antes de você perguntar sobre anos anteriores.
Qual plano do Claude eu preciso?
Qualquer plano. O Free permite um conector personalizado, usuários Pro e Max o adicionam por conta própria, e no Team e no Enterprise um Owner o adiciona uma vez, enquanto os membros fazem login com a própria conta Dataddo.