QuickBooks
QuickBooks is Intuit Inc's set of software solutions designed to manage payroll, inventory, sales, and other needs of a small business. The software's features include marketing tools, merchant services, product and supplies, training solutions.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT, BUDGET, BUNDLE, CLASS, CUSTOMER, DEPARTMENT, EMPLOYEE, ITEM, PAYMENT_METHOD, TAX_CODE, TAX_RATE, TERM, and VENDOR tables through the active column. BILL, BILL_PAYMENT, CREDIT_MEMO, DEPOSIT, ESTIMATE, INVOICE, JOURNAL_ENTRY, PAYMENT, PURCHASE, PURCHASE_ORDER, REFUND_RECEIPT, SALES_RECEIPT, TIME_ACTIVITY, TRANSFER, VENDOR_CREDIT through the _fivetran_deleted column. |
| History mode | ||
| Custom data | check | CREDIT_MEMO, ESTIMATE, INVOICE, PURCHASE_ORDER, REFUND_RECEIPT, and SALES_RECEIPT tables |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step QuickBooks setup guide to connect QuickBooks with your destination using Fivetran connectors.
Schema information
This schema applies to all QuickBooks connections.
To zoom, open the ERD in a new window.Deleted rows
QuickBooks API does not support permanently removing objects. Instead there is an "ACTIVE" column in the following tables, which is used for marking deleted/inactive records. It is not available for all tables as their corresponding endpoint does not support Active IN (true, false) queries.
- ACCOUNT
- BUDGET
- CLASS
- CUSTOMER
- DEPARTMENT
- EMPLOYEE
- ITEM
- PAYMENT_METHOD
- TAX_CODE
- TAX_RATE
- TERM
- VENDOR
Syncing empty tables and columns
Fivetran can sync empty tables and columns for your QuickBooks connector.
We create a table in the destination even if we can't retrieve the source table data from QuickBooks. For more information, see our Features documentation.
Limitations
We cannot sync data from sandbox companies in QuickBooks.