DSA Reconciliation Template

	A	B	C	D	E	F	G	H	I	J	L
1	2021 Account Ledger
2	Date	Deposit/ Refund / Credit	Debit Fee Withdrawal	Source Documentation	Vendor	Category	Merchant	Notes / memo	Date Realized	Reconciled?
3	1/4/2021		$300.00	Receipt: Confirmation GO82023 dated 1/3/2020	American Airlines	Conference Expense	Bank Account	YDSA Conference, Sarah King	1/2/20	1	This is a running document that you should update throughout the month/year as transactions are occurring. After each month has ended, you will compare your ledger with bank/third party merchant statements to see if everything lines up. That comparison (known as reconcilation) should happen in the Reconciliation Tab.
4	1/5/21		$45.00	Receipt dated 1/5/20, approval no 422720	Shell Gas	Miscellaneous Expense	Bank Account	Gas Reimbursement to S. Ng	1/5/20	1
5	2/16/21		$5.00	Confirmation Number 2030243632	PayPal	Bank Charges and Fees Expense	PayPal	E. Eckert Donation Fee	2/16/21	1
6	2/16/21		$5.00	Number 23238903	PayPal	Bank Charges and Fees Expense	PayPal	G. Gomez Donation Fee	2/16/21	1
7	2/6/21		$25.00	Donor Acknolwedgement email from Masa dated 2/14/21; Transaction 2389h135	Masa	Contribution - other org	Venmo	Mutual Aid Donation	2/6/21	1
8	2/28/21		$5.00	Bank Statement	Amalgamated Bank	Bank Charges and Fees Expense	Bank Account	Monthly Service Charge	2/28/21	1
9	2/6/21		$25.00	Donor acknolwedgement email from Mixteca dated 2/8/21; Transaction 23829b3262	Mixteca	Contribution - other org	Venmo	Mutual Aid Donation	2/6/21	1
10	2/22/21		$80.00	Donor acknoweldgement letter from M. Shah dated 2/24/21; ACH transfer confirmation # 2214632337283	United Services	Contribution - other org	Bank Account	Donation to United Services	2/22/21	1
11	2/4/2021	$600.00		Email from D. Martinez-Ocker dated 2/4/21	DSA National	Dues Share Revenue	Bank Account	2020 Q4 Dues Share	2/4/21	1
12	2/4/21	$200.00		Check 152 dated 1/31/21	Donor - S. Alvarez	General Donations Revenue	Bank Account	Donation	1/31/21	1
13	2/6/2021		$200.00	Receipt 29326 dated 2/6/21	Kroger	Miscellaneous Expense	Bank Account	Food for Immigration Rally	2/6/21	1
14	2/15/21		$15.00	Receipt 675 dated 2/15/21	Staples	Office Supplies Expense	Bank Account	10 cases of pens, 2 reams of paper	2/15/21	1
15	2/10/21		$25.00	Invoice 25025 dated 1/15/21	Printing Works	Printing Expense	Bank Account	Printing Works - Flyers for immigration rally	1/15/21	1
16	2/15/21		$75.00	Invoice 27306 dated 2/1/21	FedEx	Printing Expense	Bank Account	FedEx - Flyers for housing march	2/1/21	1
17	1/20/21		$75.00	Inv 1273 dated 1/20/21	Zoom	Telephone / Internet Expense	Bank Account	Monthly Zoom account, 1/21/21 - 2/21/21	1/20/21	1
18	2/6/21		$25.00	Invoice 2652 dated 2/4/21	Zoom	Telephone / Internet Expense	Bank Account	Zoom Account 2/1/21 - 2/28/21	2/6/21	1
19	2/25/21		$15.00	Invoice 260283 dated 2/25/21	OpaVote	Telephone / Internet Expense	Bank Account	Chapter Elections - 3/1/21 Meeting	3/1/21	1
20	1/31/21	$30.00		Transaction 27302833		Transfer	Bank Account	Transfer from Venmo to Bank Account	1/31/21	1
21	2/14/21	$205.00				Transfer	Bank Account	Transfer from Venmo to Bank Account	2/14/21	1
22	2/28/21	$600.00				Transfer	Bank Account	Transfer from PayPal to Bank Account	2/28/21	1
23	2/8/21		$25.00	Donor acknowledgement letter from Sunrise food pantry dated 2/10/21; Transaction 13t3s7d	Sunrise Food Pantry	Contribution - other org	Venmo	Contribution for Food Pantry	2/6/21	1
24	2/16/21	$150.00		Donation acknowledgment email sent to E. Eckert dated 2/20/21; ConfirmationNumber 2030243632	Donor - E. Eckert	General Donations Revenue	PayPal	General Donation	2/16/21	1
25	2/16/21	$100.00		Donation acknowledgment email sent to G. Gomez dated 2/20/21; Number 23238903	Donor - G. Gomez	General Donations Revenue	PayPal	G. Gomez Donation	2/16/21	1
26	2/20/21	$200.00		Donor acknowledgement email to J. Smith dated 2/20/21; ConfirmationNumber 230926832	Donor - J. Smith	General Donations Revenue	PayPal	General Donation	2/20/21	1
27	2/20/21	$160.00		Donor acknowledgement letter to Smile Organization dated 2/20/21; Confirmation Number 23201332	Smile Organization	General Donations Revenue	PayPal	Smile Organization Donation	2/20/21	1
28	2/7/21	$250.00		Donor acknowledgement email to Sisters United dated 2/20/21; Transaction 328962	Sisters United	General Donations Revenue	Venmo	Strike fund support	2/7/21	1
29	1/6/21	$10.00		Dues confirmation email sent 1/20/21; Transaction 49872398c82	Dues Member - M. Exchange	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - M. Exchange	1/6/21	1
30	1/10/21	$10.00		Dues confirmation email 1/20/21; Transaction 29325273	Dues Member - T. Mattel	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - Jan	1/10/21	1
31	1/10/21	$10.00		Dues confirmation email sent 1/20/21; Transaction 239341349872	Dues Member - A. Salas	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - Jan	1/10/21	1
32	2/6/21	$10.00		Dues payment confirmation email dated 2/20/21; Transaction 2dhsy35	Dues Member - M. Exchange	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - Feb	2/6/21	1
33	2/10/21	$10.00		Dues payment email sent 2/20/21; Transaction 3265987x	Dues Member - T. Mattel	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - Feb	2/7/21	1
34	2/10/21	$10.00		Dues payment email sent 2/20/21; Transaction 690237	Dues Member - A. Salas	Local Member Dues Revenue	Venmo	Monthly Local Dues Payment - Feb	2/7/21	1
35	1/31/21		$30.00	Transaction 27302833		Transfer	Venmo	Transfer from Venmo to Bank Account	1/31/21	1
36	2/28/21		$600.00			Transfer	PayPal	Transfer from PayPal to Bank Account	2/28/21	1
37	2/14/21		$205.00			Transfer	Venmo	Transfer from Venmo to Bank Account	2/14/21	1
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100