September 2023 Report.xlsx

	B	C	D	E	F	G	I	J	L	M
1	September Report - Main Account #1145341						September Report - Raffle Account 1024264
2	Date	Description				Amount	Date	Description		Amount
3	Deposits			Receipt	Number		Deposits		Number
4		No Deposits in September					Sep 4/2023	Final raffle ticket sales 4x20	4	$80.00
5
6
7
8
9
10							Total			$80.00
11
12							Funds Out (Cheques cashed)
13							Sep 1/2023	Monthly Fee		$3.75
14							Sep 14/2023	Sep Ticket Winner #041: R. Graf	66	$100.00
15	Total					$0.00
16
17	Funds Out (Cheques cashed)
18	Sep 21/2023	OLA CWL - Jarvis Park Flowers			16	$127.96				$103.75
19	Sep 28/2023	Padre Night Tickets Council #10519		GP-001	18	$195.00
20							Cheques Written (But not cashed yet.)
21
22
23						$322.96
24							Total			$0.00
25	Outstanding Cheques Written (But not cashed yet.)
26	Sep 24/2023	K of C Council Account - Statement		GP-004	19	$153.25	Account Balance
27	Sep 24/2023	Corn Roast supplies Gerald P.		GP-003	20	$265.74		As of Sept 30th, 2023		$2,812.29
28	Sep 24/2023	Corn Roast supplies Pat G.		GP-002	21	$77.65	Notes:		Start	$2,836.04
29	Sep 29/2023	Altar Server Event - Laura S.		GP-005	23	$138.65			Dep/Chq	-$23.75
30	Total					$635.29			Total 1	$2,812.29
31							Less outstanding cheques		Total 2	$2,812.29
32	Account Balance
33		As of Sept 30th, 2023				$6,095.85
34	Notes:				Start	$6,418.81
35					Dep/Cheq	-$322.96
36					Total 1	$6,095.85
37	Less outstanding cheques				Total 2	$5,460.56
38
39	Bank Reconciliation Form
40	For Pay period:		Aug 15 to Sept 15 2023			Amount
41	Note: RBC Technical Issue - Unable to extract Aug statement
42		Bank Statement Opening Balance				$6,418.81
43		Less Cheques				$0.00
44	Total					$6,418.81
45		Plus Deposits				$0.00
46	Balance					$6,418.81
47		Bank Statement Ending Balance				$6,418.81
48	Difference	(Should be zero)				$0.00
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