Export Profile Mapping Examples

The table below illustrates some recommended setup formats for Intuit® QuickBooks® account mapping by transaction type. Individual mappings may depend on your version of QuickBooks. Please refer to the QuickBooks documentation for additional information.

QuickBooks Transaction Description	QuickBooks Transaction Line and/or Distribution Line TRNSTYPE	QuickBooks Transaction Line - TRNS ACCNT	QuickBooks Distribution Line - SPL ACCNT
Bill	Bill	Accounts Payable	Expense Account
Bill Payment (Against A/P)	CHECK	Checking	Accounts Payable
Bill Refund (Bill Credit)	BILL REFUND	Accounts Payable	Expense Account
Cash	CASH SALE	Undeposited Funds	Income Account
Check	CHECK	Checking	Expense Account
Credit Card Payment	BILLCCARD	Credit Card	Accounts Payable
Credit Card Refund	CCARD REFUND	Credit Card	Expense Account
Credit Memo	CREDIT MEMO	Accounts Receivable	Income Account
Deposit	DEPOSIT	Checking	Income Account
Invoice	INVOICE	Accounts Receivable	Income Account
Item Receipt	ITEMRECEIPT	Accounts Payable	Inventory Account or Expense Account
Journal	GENERALJOURNAL	Account 1	Account 2
Purchase Order	PURCHORD	Purchase Orders	Inventory Asset
Receive Customer Payment	PAYMENT	Undeposited Funds	Accounts Receivable
Statement Charge	STMT CHG	Accounts Receivable	Income Account or Expense Account
Transfer	TRANSFER	Account A	Account B