GiveSmart Donor CRM Transaction Import Template 3-31-2023.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	donor_id	GIFT_DATE	GIFT_AMOUNT	SOLICIT_NAME	GL_NAME	TY_DATE	THANK_YOU_METHOD	NOTES	CAMPAIGN_NAME	TRANSACTION_ID	FAIR_MARKET_VALUE	TAX DEDUCTIBLE_AMOUNT
2	20	2/1/2020	100	Spring Appeal	Unrestricted	2/1/2020	LETTER_ONLY	Unlimited Notes- typically add a note that this record was added from an import file.	Annual Campaign	12345678901234	0	100
3	20	2/1/2021	1500	Spring Appeal	Unrestricted	2/1/2021	LETTER_ONLY	Unlimited Notes- typically add a note that this record was added from an import file.	Annual Campaign	12345678901234	0	1500
4	20	10/1/2021	37.5	Membership	Unrestricted	10/1/2021	LETTER_ONLY	Unlimited Notes- typically add a note that this record was added from an import file.	Annual Campaign	12345678901234	37.5	37.5
5	21	2/1/2020	2000	Spring Appeal	Unrestricted	2/1/2020	LETTER_ONLY	Unlimited Notes- typically add a note that this record was added from an import file.	Annual Campaign	12345678901234	500	1500
6	22	11/1/2020	1500	Fall Appeal	Restricted-Scholarship	11/1/2020	LETTER_ONLY	Unlimited Notes- typically add a note that this record was added from an import file.	Scholarship Campaign	12345678901234	250	1250