Transaction Section for QuickBooks Desktop

Transaction Heading:

Line 1: “!TRNS” record containing transaction keyword headings

Line 3: “!ENDTRNS” record

Transaction Line:

QuickBooks Keyword eTapestry Source
TRNSTYPE QuickBooks® Transaction Type value selected on export launch page.
DATE If Transaction Grouping is set to Deposit Date or Deposit ID, Transaction Date is set to Deposit Date. Otherwise, the Transaction Date is set to Gift Date. If Deposit Date is missing, Transaction Date defaults to Gift Date.
NAME Transaction Name value selected on export launch page.
AMOUNT Journal Entry amount – see table below for sign based on Journal Entry Type
ACCNT TRNS account associated with Fund: determined by transaction type as described in table above. Since this is required, items must be grouped by TRNS account.
CLASS Appears on TRNS record only when exporting individual transactions.
MEMO Transaction Memo value selected on export launch page.

Distribution Line:

QuickBooks Keyword eTapestry Source
TRNSTYPE QuickBooks® Transaction Type value selected on export launch page.
If Transaction Grouping is set to Deposit Date or Deposit ID, Transaction Date is set to Deposit Date. Otherwise, the Transaction Date is set to Gift Date. If Deposit Date is missing, Transaction Date defaults to Gift Date.  
NAME Account name
AMOUNT Journal Entry amount – see table below for sign based on Journal Entry Type
ACCNT SPL account associated with Fund: determined by transaction type as described in table above.
CLASS

Class. Subclass1 and Subclass2 UDFs, concatenated as

Class:Subclass1:Subclass2.

MEMO Distribution Memo value selected on export launch page.
PAYMETH Depends on Gift Type – see table above.
DOCNUM When Gift Type = ‘Check”, Check Number. When Gift Type = ‘Credit/Debit Card’, credit/debit card type. Else blank
SPLID Required in header – value will be blank.