Your downloaded QuickBooks® Report for Payment transactions displays information about the transactions and the payment received. The information included in the report is composed of two categories: transaction and payment. 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 payment column headers and are listed next to the header !SPL. Each transaction in the report is separated by a row labeled ENDTRNS.
For some of the 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 information categories are marked with an “X.”
QUICKBOOKS FIELD |
TRANSACTION |
PAYMENT |
---|---|---|
TRNSID Transaction ID in the Merchant Interface. |
X |
|
SPLID Line number of the payment: 1 |
|
X |
TRNSTYPE QuickBooks transaction type: PAYMENT |
X |
X |
DATE Settlement date of the batch for the transaction. |
X |
X |
ACCNT* QuickBooks account associated with the transaction. |
X |
X |
NAME* Customer name or customer ID associated with the transaction. |
X |
|
AMOUNT Transaction and payment settlement dollar amount. |
X |
X |
DOCNUM Transaction invoice number. |
X |
X |
MEMO Transaction description. |
X |
X |
PAYMETH Transaction payment method. Visa, MasterCard, Discover, American Express, Diners Club, JCB, EnRoute, eCheck.Net |
X |
|
All other fields showing in the report are default QuickBooks fields and will not be populated in a Payment report. To view the definitions for these fields, please refer to the Download File Format topic.
Sample Data
!TRNS |
TRNSID |
TRNSTYPE |
DATE |
ACCNT |
NAME |
AMOUNT |
DOCNUM |
MEMO |
CLASS |
PAYMETH |
!SPL |
SPLID |
TRNSTYPE |
DATE |
ACCNT |
NAME |
AMOUNT |
DOCNUM |
MEMO |
INVITEM |
PRICE |
TRNS |
23456 |
PAYMENT |
3/3/06 |
Undeposited Funds |
Joe Q |
25.00 |
CEW09 |
|
|
Visa |
SPL |
1 |
PAYMENT |
3/3/06 |
Accounts Receivable |
|
-25.00 |
CEW09 |
|
|
|
ENDTRNS |
||||||||||
TRNS |
78910 |
PAYMENT |
4/17/06 |
Undeposited Funds |
Joe Q |
10.00 |
LDB91 |
Paid in full |
|
Visa |
SPL |
1 |
PAYMENT |
4/17/06 |
Accounts Receivable |
|
-10.00 |
LDB91 |
Paid in full |
|
|
ENDTRNS |