Quickbooks Pre-mapped Data Warehouse Tables

Pre-mapped ETL+ tables available for Quickbooks as of 03/2021. This list applies to Quickbooks Online. We don’t know (yet) if it also applies to Quickbooks Desktop and Enterprise.

Source	Table Name

Source	Table Name
Quickbooks	Accounts
Quickbooks	BillLineItems
Quickbooks	BillPaymentLineItems
Quickbooks	CreditMemoLineItems
Quickbooks	CreditMemos
Quickbooks	Customers
Quickbooks	DepositLineItems
Quickbooks	Deposits
Quickbooks	InvoiceLineItems
Quickbooks	Invoices
Quickbooks	Items
Quickbooks	JournalEntries
Quickbooks	JournalEntryLineItems
Quickbooks	PaymentLineItems
Quickbooks	PurchaseLineItems
Quickbooks	PurchaseOrderLineItems
Quickbooks	RefundReceiptLineItems
Quickbooks	SalesReceiptLineItems
Quickbooks	SalesReceipts
Quickbooks	Transfers
Quickbooks	VendorCreditLineItems

In this section