QuickBooks
QuickBooks by Intuit is a premier accounting software tailored for small to medium-sized businesses. It offers both on-site and cloud versions, streamlining tasks like invoicing, bill payments, and payroll.
Supported Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | INVOICE,JOURNAL_ENTRY,PAYMENT,ACCOUNT |
| Custom data | True | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Loading diagram…
payment
payment
id
stringcustomer_ref_value
stringcustomer_ref_name
stringdeposit_to_account_ref_value
stringtotal_amt
doubleunapplied_amt
doubleprocess_payment
booleandomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datetxn_date
datecurrency_ref_value
stringcurrency_ref_name
string_weld_synced
datepayment_line
payment_id
stringamount
doubleindex
intpayment_line_linked_txn
payment_id
stringline_index
inttxn_id
stringtxn_type
stringtxn_line_id
stringcompany
company
id
stringdomain
stringlegal_addr_city
stringlegal_addr_country
stringlegal_addr_line_1
stringlegal_addr_postal_code
stringlegal_addr_country_sub_division_code
stringlegal_addr_id
stringsupported_languages
stringcompany_name
stringcountry
stringcompany_addr_city
stringcompany_addr_country
stringcompany_addr_line_1
stringcompany_addr_postal_code
stringcompany_addr_country_sub_division_code
stringcompany_addr_id
stringsparse
booleanweb_addr_uri
stringfiscal_year_start_month
stringcustomer_communication_addr_city
stringcustomer_communication_addr_country
stringcustomer_communication_addr_line_1
stringcustomer_communication_addr_postal_code
stringcustomer_communication_addr_country_sub_division_code
stringcustomer_communication_addr_id
stringprimary_phone_free_form_number
stringlegal_name
stringcompany_start_date
dateemail_address
stringmeta_data_create_time
datemeta_data_last_updated_time
date_weld_synced
datecompany_name_value
company_id
stringname
stringvalue
stringcredit_memo
credit_memo
id
stringremaining_credit
doubledomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datedoc_number
stringtxn_date
stringcurrency_ref_value
stringcurrency_ref_name
stringtxn_tax_detail_total_tax
doublecustomer_ref_value
stringcustomer_ref_name
stringcustomer_memo_value
stringbill_addr_id
stringbill_addr_line_1
stringbill_addr_line_2
stringbill_addr_line_3
stringbill_addr_line_4
stringbill_addr_lat
stringbill_addr_long
stringship_addr_id
stringship_addr_line_1
stringship_addr_city
stringship_addr_country_sub_division_code
stringship_addr_postal_code
stringship_addr_lat
stringship_addr_long
stringtotal_amt
doubleapply_tax_after_discount
booleanprint_status
stringemail_status
stringbill_email_address
stringbalance
double_weld_synced
datecredit_memo_custom_field
credit_memo_id
stringdefinition_id
stringname
stringtype
stringcredit_memo_sales_item_line
id
stringcredit_memo_id
stringitem_ref_name
stringitem_ref_value
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringitem_account_ref_name
stringitem_account_ref_value
stringtax_classification_ref_name
stringtax_classification_ref_value
stringmarkup_info_price_level_ref_name
stringmarkup_info_price_level_ref_value
stringmarkup_info_mark_up_income_account_ref_name
stringmarkup_info_mark_up_income_account_ref_value
stringtax_exclusive_amt
doublediscount_amt
doublemarkup_info_percent
doubleservice_date
datediscount_rate
doubleunit_price
doubleqty
doubleamount
doubleline_num
intdescription
stringcredit_memo_description_only_line
id
stringcredit_memo_id
stringtax_code_ref_name
stringtax_code_ref_value
stringservice_date
dateamount
doubleline_num
intdescription
stringcredit_memo_discount_line
id
stringcredit_memo_id
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringdiscount_account_ref_name
stringdiscount_account_ref_value
stringpercent_based
booleandiscount_percent
doubleamount
doubleline_num
intdescription
stringcredit_memo_sub_total_line
id
stringcredit_memo_id
stringitem_ref_name
stringitem_ref_value
stringamount
doubleline_num
intdescription
stringcredit_memo_group_line
id
stringcredit_memo_id
stringquantity
doublegroup_item_ref_name
stringgroup_item_ref_value
stringline_num
intdescription
stringcredit_memo_group_line_sales_item_line
id
stringcredit_memo_id
stringitem_ref_name
stringitem_ref_value
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringitem_account_ref_name
stringitem_account_ref_value
stringtax_classification_ref_name
stringtax_classification_ref_value
stringmarkup_info_price_level_ref_name
stringmarkup_info_price_level_ref_value
stringmarkup_info_mark_up_income_account_ref_name
stringmarkup_info_mark_up_income_account_ref_value
stringtax_exclusive_amt
doublediscount_amt
doublemarkup_info_percent
doubleservice_date
datediscount_rate
doubleunit_price
doubleqty
doubleamount
doubleline_num
intdescription
stringgroup_line_id
stringjournal_entry
journal_entry
id
stringadjustment
booleandomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datetxn_date
datecurrency_ref_value
stringcurrency_ref_name
stringprivate_note
stringtxn_tax_detail_txn_tax_code_ref_name
stringtxn_tax_detail_txn_tax_code_ref_value
stringtxn_tax_detail_total_tax
double_weld_synced
datejournal_entry_line
id
stringjournal_entry_id
stringdescription
stringamount
doubledetail_type
stringjournal_entry_line_detail_posting_type
stringjournal_entry_line_detail_account_ref_value
stringjournal_entry_line_detail_account_ref_name
stringjournal_entry_tax_line
journal_entry_id
stringdetail_type
stringamount
doubletax_line_detail_tax_rate_ref_value
stringtax_line_detail_tax_rate_ref_name
stringtax_line_detail_net_amount_taxable
doubletax_line_detail_percent_based
booleantax_line_detail_tax_inclusive_amount
doubletax_line_detail_override_delta_amount
doubletax_line_detail_tax_percent
doublebill_payment
bill_payment
id
stringvendor_ref_value
stringvendor_ref_name
stringpay_type
stringcredit_card_payment_cc_account_ref_value
stringcredit_card_payment_cc_account_ref_name
stringtotal_amt
doubledomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datedoc_number
stringtxn_date
stringcurrency_ref_value
stringcurrency_ref_name
string_weld_synced
datebill_payment_line
bill_payment_id
stringindex
intamount
doublebill_payment_line_linked_txn
bill_payment_id
stringbill_payment_line_index
inttxn_id
stringtxn_type
stringinvoice
invoice
id
stringtxn_date
datedomain
stringprint_status
stringsales_term_ref_value
stringtotal_amt
doubledue_date
dateapply_tax_after_discount
booleandoc_number
stringsparse
booleancustomer_memo_value
stringproject_ref_value
stringdeposit
doublebalance
doublecustomer_ref_name
stringcustomer_ref_value
stringtxn_tax_detail_txn_tax_code_ref_value
stringtxn_tax_detail_total_tax
doublesync_token
stringbill_email_address
stringship_addr_city
stringship_addr_line_1
stringship_addr_postal_code
stringship_addr_lat
stringship_addr_long
stringship_addr_country_sub_division_code
stringship_addr_id
stringemail_status
stringbill_addr_line_4
stringbill_addr_line_3
stringbill_addr_line_2
stringbill_addr_line_1
stringbill_addr_long
stringbill_addr_lat
stringbill_addr_id
stringmeta_data_create_time
datemeta_data_last_updated_time
date_weld_synced
dateinvoice_custom_field
invoice_id
stringdefinition_id
stringstring_value
stringtype
stringname
stringinvoice_line
id
stringinvoice_id
stringdescription
stringdetail_type
stringsales_item_line_detail_tax_code_ref_value
stringsales_item_line_detail_qty
doublesales_item_line_detail_unit_price
doublesales_item_line_detail_item_ref_name
stringsales_item_line_detail_item_ref_value
stringline_num
doubleamount
doubleinvoice_linked_txn
invoice_id
stringtxn_id
stringtxn_type
stringinvoice_txn_tax_detail_tax_line
invoice_id
stringindex
intamount
doubledetail_type
stringtax_line_detail_tax_rate_ref_value
stringtax_line_detail_percent_based
booleantax_line_detail_tax_percent
doubletax_line_detail_net_amount_taxable
doublebill
bill
id
stringdue_date
stringbalance
doubledomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datetxn_date
stringcurrency_ref_value
stringcurrency_ref_name
stringvendor_ref_value
stringvendor_ref_name
stringap_account_ref_value
stringap_account_ref_name
stringtotal_amt
double_weld_synced
datebill_account_based_expense_line
id
stringbill_id
stringaccount_ref_name
stringaccount_ref_value
stringcustomer_ref_name
stringcustomer_ref_value
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringmarkup_info_price_level_ref_name
stringmarkup_info_price_level_ref_value
stringmarkup_info_mark_up_income_account_ref_name
stringmarkup_info_mark_up_income_account_ref_value
stringtax_amount
doubletax_exclusive_amt
doublemarkup_info_percent
doublebillable_status
stringline_num
intdescription
stringbill_item_based_expense_line
id
stringbill_id
stringitem_ref_name
stringitem_ref_value
stringcustomer_ref_name
stringcustomer_ref_value
stringprice_level_ref_name
stringprice_level_ref_value
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringmarkup_info_price_level_ref_name
stringmarkup_info_price_level_ref_value
stringmarkup_info_mark_up_income_account_ref_name
stringmarkup_info_mark_up_income_account_ref_value
stringtax_exclusive_amt
doublemarkup_info_percent
doublebillable_status
stringqty
doubleunit_price
doubleamount
doubleline_num
intdescription
stringdeposit
deposit
id
stringdeposit_to_account_ref_value
stringdeposit_to_account_ref_name
stringcash_back_account_ref_value
stringcash_back_account_ref_name
stringcash_back_amount
doublecash_back_memo
stringtotal_amt
doubledomain
stringsparse
booleansync_token
stringmeta_data_create_time
datemeta_data_last_updated_time
datetxn_date
stringcurrency_ref_value
stringcurrency_ref_name
string_weld_synced
datedeposit_line
id
stringdeposit_id
stringaccount_ref_name
stringaccount_ref_value
stringpayment_method_ref_name
stringpayment_method_ref_value
stringclass_ref_name
stringclass_ref_value
stringtax_code_ref_name
stringtax_code_ref_value
stringentity_name
stringentity_value
stringproject_ref_name
stringproject_ref_value
stringcheck_num
stringtax_applicable_on
stringtxn_type
stringamount
doublecustom_field_definition_id
stringcustom_field_string_value
stringcustom_field_name
stringcustom_field_type
stringline_num
intdescription
stringindex
intdeposit_line_txn
deposit_id
stringdeposit_line_index
inttxn_id
stringtxn_type
stringtxn_line_id
stringbalance_sheet_report
account_id
stringdate
dateaccount
stringtotal
double_weld_synced
datetrial_balance_report
account_id
stringdate
dateaccount
stringcredit
doubledebit
double_weld_synced
dateaccount
id
stringfully_qualified_name
stringdomain
stringname
stringclassification
stringaccount_sub_type
stringcurrency_ref_name
stringcurrency_ref_value
stringcurrent_balance_with_sub_accounts
doublesparse
booleanmeta_data_create_time
datemeta_data_last_updated_time
dateaccount_type
stringcurrent_balance
doubleactive
booleansync_token
stringsub_account
boolean_weld_synced
dategeneral_ledger_report
account_id
stringtx_date
datetxn_type
stringtxn_type_id
stringdoc_num
stringname
stringname_id
stringmemo
stringsplit_acc
stringsplit_acc_id
stringsubt_nat_amount
stringrbal_nat_amount
stringaccount_name
string_weld_synced
dateTable
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Prerequisites
- An active QuickBooks account with workspace owner/admin permissions.
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to allow Weld to access your QuickBooks account using OAuth.
Step 2 - Approve and finalize
- Approve Weld to access your QuickBooks account.
- When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
Weld will take over from here and commence syncing data from your QuickBooks account.