Undeposited Funds Option for QuickBooks Desktop

Column headings for transactions

Quickbooks Name	eTapestry Name
TRNSTYPE	Transaction Type
GENERAL JOURNAL	Gift, Pledge, Payment, Disbursement
ACCNT	General Ledger Number From Fund
AMOUNT	Amount of Transaction (Debits are +, Credits are -)

Column headings for distribution lines

Quickbooks Name	eTapestry Name
SPLID	Distribution Line Identification Number
TRNSTYPE	Transaction Type
DATE	Transaction Date in mm/dd/yyyy Format
ACCNT	Income or Expense Account
NAME	Account Name
AMOUNT	Distribution Amount
DOCNUM	Transaction Number
MEMO	Journal Note

Optional fields

Quickbooks Name	eTapestry Name
ADDR1	Account Address 1
ADDR2	Account Address 2
ADDR3	Account Address 3 - City
ADDR4	Account Address 4 - State
ADDR5	Account Address 5 - Postal Code
PAYMETH	Gift Type

Sample

SPLID	TRNSTYPE	DATE	ACCNT	AMOUNT	PAYMETH	DOCNUM	MEMO	NAME	ADDR1	ADDR2	ADDR3	ADDR4	ADDR5
blank	General Journal	6/17/2002	revenue#	-25.25	Cash	blank	journal_note	John Doe	1234 Fake St.	Apartment#	Made Up	IN	46060