Download File Format

Your downloaded QuickBooks® Report displays information about the transaction and the merchandise sold or returned. The information included in the report is composed of two categories: transaction and itemized order information. These categories of information are arranged into two-tiered columns. The first tier, or row, at the top of the report includes the transaction column headers and are listed next to the header !TRNS. The second tier includes the itemized order column headers and are listed next to the header !SPL. Each transaction in the report is separated by a row labeled ENDTRNS.

Transaction Information

QUICKBOOKS FIELD	VALUE
TRNSID	Transaction ID in the Merchant Interface
TRNSTYPE	QuickBooks transaction type
DATE	Settlement date of the batch for the transaction
ACCNT	QuickBooks account associated with the transaction type
NAME	Customer name or customer ID associated with the transaction
AMOUNT	Transaction settlement dollar amount
DOCNUM	Transaction invoice number
MEMO	Transaction description
CLASS	QuickBooks class
PAYMETH	Transaction payment method Visa, MasterCard, Discover, American Express, Diners Club, JCB, EnRoute, eCheck.Net
PONUM	Transaction purchase order number
ADDR1	Customer first and last name
ADDR2	Customer bill to address
ADDR3	Customer bill to city
ADDR4	Customer bill to state/province and ZIP code
ADDR5	Customer bill to country
SADDR1	Customer first and last name
SADDR2	Customer ship to address
SADDR3	Customer ship to city
SADDR4	Customer ship to state/province and ZIP code
SADDR5	Customer ship to country
TOPRINT	Print the transaction Y = Yes N = No

Itemized Order Information

The itemized order information is categorized by four default values; service/product, duty, shipping and handling, and sales tax. These values, and any other values sent during the transaction, are arranged into line items for each transaction and are enumerated. If an itemized order value was not applied to the transaction, it will not be included in the report.

For some of the itemized order field values, the information included will either be the information sent during the transaction or the value set up as a default on the QuickBooks Download Report Settings page. Values for which defaults can be established are marked by an asterisk (*).

The fields that are included in the download report for each of the itemized order categories are marked with an X.

QUICKBOOKS FIELD	SERVICE/ PRODUCT	DUTY	SHIPPING AND HANDLING	SALES TAX
SPLID Line number of the item	X	X	X	X
TRNSTYPE QuickBooks transaction type	X	X	X	X
DATE Settlement date of the batch for the transaction recorded in the Merchant Interface	X	X	X	X
ACCNT* QuickBooks account associated with the transaction, product and/or service, sales tax, freight/shipping, or duty	X	X	X	X
NAME* Sales tax name (when sales tax is applicable)				X
AMOUNT Dollar amount of the line item	X	X	X	X
DOCNUM Transaction invoice number in the Merchant Interface	X	X	X	X
MEMO Description of the line item	X	X	X	X
INVITEM* Name of the line item	X	X	X	X
PRICE Individual merchandise unit price OR sales tax rate	X			X
QNTY Quantity of the merchandise purchased or returned in the transaction	X
TAXABLE Indicates if the line item is subject to tax: Y = Yes N = No	X	X	X	X
EXTRA Autostax				X

Sample Data

Note: Due to available space, this example does not show all of the column values described in this document.

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO	CLASS
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO	INVITEM
TRNS	23456	INVOICE	3/3/06	Accounts Receivable	Joe Q	16.08	TRY87		Front desk
SPL	1	INVOICE	3/3/06	Sales		-14.95	TRY87		Sales1
SPL	2	INVOICE	3/3/06	Duty		-0.15	TRY87		Duty1
SPL	3	INVOICE	3/3/06	S&H		-0.3	TRY87		S&H1
SPL	4	INVOICE	3/3/06	Sales Tax Payable	Local	-0.68	TRY87		Local
ENTRNS
TRNS	78901	CREDIT MEMO	3/9/06	Accounts Receivable	Joe Q	-8.79	WNF26		Front desk
SPL	1	CREDIT MEMO	3/9/06	Sales		8.59	WNF26		Sales1
SPL	2	CREDIT MEMO	3/9/06	Sales Tax Payable	Local	0.2	WNF26		Local
ENDTRNS