Important: This reference is provided as a guide and may not reflect every field imported for your specific configuration. Certain import sections, such as User Defined Fields, Price Lists, and Discount matrices, may not be fully represented here. As the integration is updated over time, this document may become out of date. If you notice any missing fields, inaccuracies, or discrepancies between this document and the data in your system, please raise this with our support team so that we can review and update this article accordingly.

Sales Ledgers (Customers)

CRM Field (Friendly Name)	QuickBooks Source	Description
Sales Ledger ID	`Customer.Id`	Unique identifier linking the CRM account to the QuickBooks customer
Name	`Customer.CompanyName` (falls back to `DisplayName`)	Primary name of the customer account
Currency Code	`Customer.CurrencyRef.value`	Records which currency the customer trades in
Display Description	`Customer.DisplayName`	Human-readable display label for the account
Tax Code	`Customer.DefaultTaxCodeRef.value` (or "Tax Exempt" if not taxable)	Determines the default tax treatment for invoices
Balance	`Customer.Balance` (×100)	Outstanding balance on the customer account
Closed	`Customer.Active` (inverted)	Indicates whether the account is inactive/closed
VAT Registration Code	`Customer.PrimaryTaxIdentifier`	Tax registration number for compliance purposes
Email	`Customer.PrimaryEmailAddr.Address`	Primary email address for communications
Telephone	`Customer.PrimaryPhone.FreeFormNumber`	Primary phone number
Website	`Customer.WebAddr.URI`	Customer's website URL
Fax	`Customer.Fax.FreeFormNumber`	Fax number
Invoice To	`Customer.ParentRef.name`	Parent company name used for invoice routing
Address Line 1	`Customer.BillAddr.Line1`	First line of billing address
Address Line 2	`Customer.BillAddr.Line2`	Second line of billing address
Address Line 3	`Customer.BillAddr.City`	Billing city
Address Line 4	`Customer.BillAddr.CountrySubDivisionCode`	Billing county/state/region
Address Line 5	(empty)	Reserved address line for consistency
Country	`Customer.BillAddr.Country`	Billing country
Postcode	`Customer.BillAddr.PostalCode`	Billing postal/ZIP code
Is B2C	Derived from `CompanyName`, `GivenName`, `FamilyName`	Classifies the account as business-to-consumer or business-to-business

Purchase Ledgers (Suppliers)

CRM Field (Friendly Name)	QuickBooks Source	Description
Purchase Ledger ID	`Vendor.Id`	Unique identifier linking the CRM supplier to QuickBooks
Name	`Vendor.DisplayName`	Supplier name
Display Description	`Vendor.DisplayName`	Human-readable label for the supplier
Currency Code	`Vendor.CurrencyRef.value`	Currency the supplier trades in
Balance	`Vendor.Balance`	Outstanding balance with the supplier
Closed	`Vendor.Active` (inverted)	Whether the supplier account is inactive
Email	`Vendor.PrimaryEmailAddr.Address`	Primary email for supplier communications
Telephone	`Vendor.PrimaryPhone.FreeFormNumber`	Primary phone number
Fax	`Vendor.Fax.FreeFormNumber`	Fax number
Address Line 1	`Vendor.BillAddr.Line1`	First line of billing address
Address Line 2	`Vendor.BillAddr.Line2`	Second line of billing address
Address Line 3	`Vendor.BillAddr.City`	Billing city
Address Line 4	`Vendor.BillAddr.CountrySubDivisionCode`	Billing county/state/region
Address Line 5	(empty)	Reserved address line for consistency
Country	`Vendor.BillAddr.Country`	Billing country
Postcode	`Vendor.BillAddr.PostalCode`	Billing postal/ZIP code

Product Items

CRM Field (Friendly Name)	QuickBooks Source	Description
Product Item ID	`Item.Id`	Unique product identifier
Description	`Item.Name`	Product name
Category ID	`Item.ParentRef.value` (defaults to "MAIN")	Assigns the product to a category
Stocked	`Item.TrackQtyOnHand`	Whether physical stock is tracked
SKU	`Item.Sku`	Stock keeping unit / product code
Sales Analysis	`Item.IncomeAccountRef.value`	Income account used for sales reporting
Purchase Analysis	`Item.ExpenseAccountRef.value`	Expense account used for purchase reporting
Selling Price	`Item.UnitPrice` (×10000)	Standard unit selling price
Sell Decimals	Fixed: `4`	Decimal precision for the selling price
Cost Price	`Item.PurchaseCost` (×10000)	Standard purchase/cost price
Cost Decimals	Fixed: `4`	Decimal precision for cost
Quantity Decimal	Fixed: `4`	Decimal precision for quantities
Obsolete	`Item.Active` (inverted)	Whether the product is discontinued
Alternate Reference 1	`Item.PrefVendorRef.value`	Preferred vendor/supplier reference
Unit Description	Fixed: `"Each"`	Unit of measure label
Taxable	`Item.Taxable`	Whether the product is subject to tax
Extended Description	`Item.Description`	Detailed product description
VAT Code	`Item.SalesTaxCodeRef.value`	Applicable tax code for the product

Stock by Warehouse

Stored alongside product items during the same import step. Quickbooks does not provide a Warehouse entity for us to extract warehouse information. The stock by warehouse import is therefor forced to save everything into a 'Main warehouse'

CRM Field (Friendly Name)	QuickBooks Source	Description
Product Item ID	`Item.Id`	Links stock record to its product
Warehouse Code	Fixed: `"MAIN"`	Default warehouse (QuickBooks has no warehouse concept)
Physical Stock	`Item.QtyOnHand` (×10000)	Current physical stock quantity
Free Stock	`Item.QtyOnHand` (×10000)	Available/free stock quantity
On Order	Fixed: `0`	Not available from QuickBooks

Product Categories

CRM Field (Friendly Name)	QuickBooks Source	Description
Category ID	`Item.Id`	Unique category identifier
Description	`Item.Name`	Category name
Parent Category	`Item.ParentRef.value`	Links to parent category for hierarchical structure

A default "MAIN" category is also created on the first page if it doesn't already exist.

Foreign Currencies

Only availablie if multi-currency is enabled.

CRM Field (Friendly Name)	QuickBooks Source	Description
Currency Code	`CompanyCurrency.Code`	ISO currency code
Description	`CompanyCurrency.Name`	Currency display name
Decimals	Fixed: `2`	Decimal precision for this currency
Currency Rate	Calculated from external exchange rates	Conversion rate relative to the home currency
Multiply	Fixed: `0`	Rate calculation direction flag
Obsolete	Fixed: `0`	Currency is active by default
Home Currency	Derived: `1` if code matches home currency	Identifies which record is the home currency
Rounding Method	Fixed: `1`	How fractional amounts are rounded
Sequence	Fixed: `0`	Display ordering
ISO Code	`CompanyCurrency.Code`	ISO code (duplicated for compatibility)

VAT and Tax Rates

CRM Field (Friendly Name)	QuickBooks Source	Description
Tax Code	`TaxCode.Id`	Unique tax code identifier
Rate 1	`TaxRate.RateValue`	The tax percentage rate
Calculation Method	Fixed: `1`	How the tax is calculated
Description	`TaxCode.Name`	Human-readable tax code name
Country Type	Generated: `H`, `U`, `R`, `N`	Applied across all CRM country classifications
Transaction Type	`S` (Sales) or `P` (Purchase)	Whether the rate applies to sales or purchase transactions

A fixed "Tax Exempt" record (rate 0) is also injected for both sales and purchase rate lists.

Warehouses

This is a fixed default record.

CRM Field (Friendly Name)	QuickBooks Source	Description
Code	Fixed: `"MAIN"`	Default warehouse code (QuickBooks has no warehouse entity)
Description	Fixed: `"Main"`	Default warehouse name

Sales Order Headers

CRM Field (Friendly Name)	QuickBooks Source	Description
Order Number	`Invoice.DocNumber`	The invoice/estimate document number
Base Gross Value	`Invoice.HomeTotalAmt` (or `TotalAmt`)	Total value in the base/home currency
Base Net Value	Calculated: `HomeTotalAmt − BaseTaxValue`	Net value in base currency
Base Tax Value	Calculated: `TotalTax × ExchangeRate`	Tax amount in base currency
Sales Ledger ID	`Invoice.CustomerRef.value`	Links the order to the customer account
Gross Value	`Invoice.TotalAmt`	Total transaction value in transaction currency
Net Value	Calculated: `TotalAmt − TotalTax`	Net value before tax
Order Date	`Invoice.TxnDate`	Date of the transaction
Tax Value	`Invoice.TxnTaxDetail.TotalTax`	Total tax on the document
Accounts ID	`Invoice.Id`	QuickBooks internal record ID
Currency Code	`Invoice.CurrencyRef.value`	Transaction currency
Status Flag	`Invoice.StatusFlag` (default `"A"`)	Document status (Estimates: `"A"` if Accepted, `"D"` otherwise)
Analysis	`Invoice.ClassRef.name`	QuickBooks Class for reporting/analysis

Sales Transaction Lines

CRM Field (Friendly Name)	QuickBooks Source	Description
Document ID	`Invoice.Id`	Links the line to its parent document
Line Number	`Line.LineNum`	Line ordering within the document
Invoice Number	`Invoice.DocNumber`	Document number for the invoice
Order Number	`Invoice.DocNumber`	Document number (mirrored for order tracking)
Product Item ID	`Line.SalesItemLineDetail.ItemRef.value`	Product on this line
Product Description	`Line.Description`	Description of the line item
Price	`Line.SalesItemLineDetail.UnitPrice` (×10000)	Unit selling price
Sell Decimals	Fixed: `4`	Price decimal precision
Order Quantity	`Line.SalesItemLineDetail.Qty` (×10000)	Quantity ordered
Invoice Quantity	`Line.SalesItemLineDetail.Qty` (×10000, invoices only)	Quantity invoiced (0 for estimates)
Line Value	`Line.Amount` (×100)	Net value of the line
Invoice Date	`Invoice.TxnDate`	Date of the transaction
Due Date	`Invoice.DueDate`	Payment due date
Account	`Invoice.CustomerRef.value`	Customer account reference
Ledger	`Invoice.CustomerRef.value`	Customer ledger reference
Obsolete	Fixed: `0`	Line is active
Paid Flag	`"P"` if `Balance = 0`, else `"0"`	Whether the invoice is fully paid
Transaction Type	`Invoice.TransactionType` (default `"I"` for invoices, `"O"` for estimates)	Distinguishes invoices from orders
Gross Value	Calculated: `LineValue + tax`	Line value including tax
Currency Decimals	Fixed: `2`	Currency decimal precision
Currency Code	`Invoice.CurrencyRef.value`	Transaction currency
Base Value	`LineValue × exchangeRate`	Net line value in base currency
Base Gross Value	`GrossValue × exchangeRate`	Gross line value in base currency
Base Currency Decimals	Fixed: `2`	Base currency decimal precision
Quantity Type	Fixed: `"D"`	Quantity type indicator
Quantity Decimals	Fixed: `4`	Quantity decimal precision
Customer Reference	`Invoice.CustomField` where `Name = "Your Reference"`	Customer's own PO or reference number
Quantity Delivered	`Line.SalesItemLineDetail.Qty` (×10000)	Quantity delivered
Warehouse Code	Fixed: `"MAIN"`	Default warehouse
Order Date	`Invoice.TxnDate`	Date of the order
Accounts ID	`Invoice.Id`	QuickBooks internal ID
Status Flag	`Invoice.StatusFlag`	Line status
Analysis 1	`Line.SalesItemLineDetail.ClassRef.name` (falls back to `Invoice.ClassRef.name`)	Class-based analysis/reporting

Sales Ledger Contacts

CRM Field (Friendly Name)	QuickBooks Source	Description
Title	`Customer.Title`	Contact's title/salutation
Forename	`Customer.GivenName`	Contact's first name
Surname	`Customer.FamilyName`	Contact's last name
Mobile Phone Number	`Customer.Mobile.FreeFormNumber`	Mobile phone number
Email	`Customer.PrimaryEmailAddr.Address` (first address if comma-separated)	Primary contact email
Role Code	From system configuration	Assigns a default role to the contact

Any additional comma-separated email addresses are stored as separate Additional Email records linked to the contact.

Purchase Ledger Contacts

CRM Field (Friendly Name)	QuickBooks Source	Description
Title	`Vendor.Title`	Contact's title/salutation
Forename	`Vendor.GivenName`	Contact's first name
Surname	`Vendor.FamilyName`	Contact's last name
Mobile Phone Number	`Vendor.Mobile.FreeFormNumber`	Mobile phone number
Email	`Vendor.PrimaryEmailAddr.Address` (first address if comma-separated)	Primary contact email
Role Code	From system configuration	Assigns a default role to the contact

Any additional comma-separated email addresses are stored as separate Additional Email records linked to the contact.

Full integration capabilities of Exchequer

Full integration capabilities for Pegasus Opera

Full integration capabilities for Access Dimensions

Full integration capabilities for Factory Master

Full integration capabilities for Access Financials

Full integration capabilites for Intuit Quickbooks