MSPBots WIKI : QuickBooks On-Premise Public Datasets
Here are the published or Alpha version QuickBooks On-Premise datasets that you can use to create the widgets and dashboards
In total, there are 20 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
Cash Flow Balance_QBD | dataset for Cash Flow Balance widget of Weekly Executive Report | Aug 06, 2021 | Dec 10, 2022 | ["list_id", "account_number", "name", "sub_level", "account_type", "balance", "total_balance"] |
QuickBooks On-Premise GL Accounts | This shows current information for all active accounts displayed in the chart of accounts for the Quickbooks setup. Date range: no specified date range | Sep 13, 2021 | Dec 10, 2022 | ["id", "name", "account_type", "account_number", "account_number_and_name", "parent_company", "balance", "total_balance", "cash_flow_classification", "account_created", "account_last_updated", "active", "subaccount"] |
QBD Profit and Loss Detail | Profit and Loss Detail Report for the previous year to today. | Sep 17, 2021 | Dec 10, 2022 | ["account", "account_name", "account_number", "amount", "amountdifference", "class", "clearedstatus", "date", "date_month", "month_and_year", "invoiced", "memo", "company", "originalamount", "refnumber", "runningbalance", "splitaccount", "txntype", "category", "account_type", "total_flag", "has_duplicate"] |
QuickBooks ON-PREMISE Journal - API | ODS Dataset which generated from QuickBooks ON-PREMISE Journal | Jan 06, 2022 | Jan 17, 2022 | ["id", "txn_id", "txn_date", "tenant_code", "ref_number", "txn_number", "time_created", "edit_sequence", "is_adjustment", "time_modified"] |
QuickBooks ON-PREMISE Profit And Loss Standard By Accrual - API | ODS Dataset which generated from QuickBooks ON-PREMISE Profit And Loss | Jan 06, 2022 | Jan 17, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "account_name", "data_value"] |
QuickBooks ON-PREMISE Balance Sheet - API | ODS Dataset which generated from QuickBooks ON-PREMISE Balance Sheet | Jan 06, 2022 | Jan 17, 2022 | ["tenant_code", "sync_time", "row_number", "time_period", "row_type", "account_name_full", "account_name", "accout_value"] |
QuickBooks ON-PREMISE Bills - API | ODS Dataset which generated from QuickBooks ON-PREMISE Bills | Jan 06, 2022 | Jan 17, 2022 | ["id", "txn_id", "is_paid", "due_date", "txn_date", "tenant_code", "amount_due", "txn_number", "vendor_id", "vendor_name", "open_amount", "created", "account_id", "account_name", "edit_sequence", "time_modified", "vendor_location"] |
QuickBooks ON-PREMISE Customer - API | ODS Dataset which generated from QuickBooks ON-PREMISE Customer | Jan 06, 2022 | Jan 17, 2022 | ["id", "tenant_code", "list_id", "phone", "name", "email", "full_name", "last_name", "first_name", "job_status", "salutation", "is_active", "sublevel", "sync_time"] |
QBD Invoices | qbd_invoices | Apr 21, 2022 | Dec 10, 2022 | ["id", "txn_id", "is_paid", "tenant_code", "due_date", "txn_date", "ship_date", "is_pending", "ref_number", "txn_number", "bill_address_city", "bill_address_addr1", "bill_address_addr2", "bill_address_state", "bill_address_postal_code", "customer_ref_list_id", "customer_ref_full_name", "template_ref_list_id", "template_ref_full_name", "time_created", "ar_account_ref_list_id", "ar_account_ref_full_name", "edit_sequence", "time_modified", "applied_amount", "sales_tax_total", "is_to_be_emailed", "is_to_be_printed", "is_finance_charge", "balance_remaining", "bill_address_block_addr1", "bill_address_block_addr2", "bill_address_block_addr3", "sales_tax_percentage", "subtotal", "terms_ref_list_id", "terms_ref_full_name", "sales_rep_ref_full_name", "po_number", "sync_date"] |
Profit and Loss Detail - QuickBooks On-Premise | Profit and Loss Detail | Apr 26, 2022 | May 23, 2023 | ["account", "amount", "amountdifference", "credit", "originalamount", "class", "clearedstatus", "date", "invoiced", "memo", "modifiedtime", "company", "openbalance", "renumber", "runningbalance", "splitaccount", "txntype", "row_type", "category", "ponumber", "nameaccountnumber", "account_name", "account_number", "account_type", "last_webconnector_update", "date_month"] |
QuickBook On-Premise Invoices | Information on invoices from your Quickbooks setup from the current and previous calendar years. | Jun 08, 2022 | Dec 10, 2022 | ["id", "transaction_number", "customer_ref_list_id", "customer", "ar_account", "account_location", "created", "last_updated", "transaction_date", "invoice_number", "is_pending", "is_financecharge", "po_number", "terms", "due_date", "days_due_status", "aging_status", "ship_date", "sales_rep", "subtotal", "sales_tax_total", "applied_amount", "balanceremaining", "aging", "ispaid", "due_in_x_days"] |
Quickbooks On Premise Bills | Information on bills within Quickbooks from the current and previous calendar years. | Aug 09, 2022 | Mar 12, 2023 | ["id", "transaction_number", "vendor_name", "vendor_location", "account_name", "bill_date", "due_date", "created", "last_updated", "days_due_status", "bill_amount", "bill_number", "company_open_amount", "aging", "is_paid", "last_webconnector_update"] |
QuickBooks On-Premise Profit and Loss Detail | Profit and Loss Detail Report for the previous year to the current day. | Oct 31, 2022 | May 12, 2023 | ["account", "amount", "amountdifference", "credit", "originalamount", "class", "clearedstatus", "date", "debit", "invoiced", "memo", "modifiedtime", "company", "openbalance", "paidstatus", "refnumber", "runningbalance", "splitaccount", "txntype", "row_type", "category", "ponumber", "nameaccountnumber", "account_name", "account_number", "account_type", "last_webconnector_update", "date_month"] |
QuickBooks On Premise Profit and Loss - Mapped | A dataset from the profit and loss data of QuickBooks On Premise integrated with the accounting mappings. | Nov 07, 2022 | Mar 09, 2023 | ["company", "date", "time_period", "year", "lead_year", "account_number", "account", "account_string", "split_account", "description", "account_type", "amount", "sli_account_group", "sli_account_category", "sli_account_subcategory", "account_child_subcategory"] |
QuickBooks ON-PREMISE Profit And Loss Detail By Cash - API | ODS Dataset which generated from QuickBooks ON-PREMISE Profit And Loss Detail By Cash | Dec 20, 2022 | Dec 20, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "sync_time", "report_basis", "account", "blank", "txn_type", "data_date", "ref_number", "name", "memo", "cleared_status", "split_account", "amount", "running_balance", "row_type", "data_class", "debit", "credit", "adjustment"] |
QuickBooks ON-PREMISE Profit And Loss Detail By Accrual - API | ODS Dataset which generated from QuickBooks ON-PREMISE Profit And Loss Detail By Accrual | Dec 20, 2022 | Dec 20, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "sync_time", "report_basis", "account", "blank", "txn_type", "data_date", "ref_number", "name", "memo", "cleared_status", "split_account", "amount", "running_balance", "row_type", "data_class", "debit", "credit", "adjustment"] |
QuickBooks On-Premise Balance Sheet | Get QuickBooks On-Premise Balance Sheet data | Dec 22, 2022 | Mar 09, 2023 | ["date", "time_period", "month", "year", "quarter", "account", "period_bal_beg", "month_bal_beg", "month_bal_end", "number_of_days"] |
QuickBooks ON-PREMISE Profit And Loss Standard By Cash - API | ODS Dataset which generated from QuickBooks ON-PREMISE Profit And Loss Standard By Cash | Dec 28, 2022 | Dec 28, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "account_name", "data_value"] |
QuickBooks On-Premise Profit and Loss Detail Update | Profit and Loss Detail Report for the previous year to the current day. | Apr 04, 2023 | May 05, 2023 | ["account", "amount", "amountdifference", "credit", "originalamount", "class", "clearedstatus", "date", "debit", "invoiced", "memo", "modifiedtime", "company", "openbalance", "paidstatus", "refnumber", "runningbalance", "splitaccount", "txntype", "row_type", "category", "ponumber", "nameaccountnumber", "account_name", "account_number", "account_type", "last_webconnector_update", "date_month"] |
QuickBooks ON-PREMISE Item - API | ODS Dataset which generated from QuickBooks ON-PREMISE Item | May 11, 2023 | May 11, 2023 | ["id", "tenant_code", "sync_time", "list_id", "time_created", "time_modified", "edit_sequence", "name", "full_name", "is_active", "sublevel", "sales_tax_code_ref", "sales_and_purchase", "tax_vendor_ref", "raw_type"] |