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. |