ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
VFW AUXILIARY LOCAL TREASURERS LEDGER AND REPORT TOOL
3
4
Per Section 919 of the Bylaws, the fiscal year of an Auxiliary shall be July 1 through
5
June 30 of each year.
6
7
Per Section 813A of the Bylaws, the Auxiliary Treasurer shall hold all funds and securities
8
belonging to the Auxiliary in a FDIC or equivalent Banking Institution in the name
9
of the Auxiliary.
10
11
Also per Section 813A of the Bylaws, money of the Auxiliary shall be maintained in one
12
checking account. However, if state law requires money such as Bingo or Gaming, to be
13
maintained in a separate checking account the Auxiliary may have two checking accounts.
14
15
16
This tool is made available for a Treasurer to account for all transactions in a single
17
checking account. If the Auxiliary has more than one checking account, then a second
18
spreadsheet would need to be maintained for the second checking account.
19
20
21
To utilize this tool, please follow these instructions:
22
23
A)
Click on the tab named "Fill Out Info About Aux First!" and enter information about
24
the Auxiliary in the boxes highlighted in yellow.
25
26
B)
Click on the tab named "July" and enter in the beginning fund balances from the prior
27
fiscal year. The total should match your check book balance as of June 30th of the prior
28
fiscal year.
29
30
C)
Enter all transaction for the checking account for the month of July in the appropriate
31
area of RECEIPTS (MONEY IN) and DISBURSEMENTS (MONEY OUT).
32
33
This tool will calculate all totals for the month and will have the ending balances
34
flow over to the next month as a beginning balances.
35
36
D)
Continue onto the other months and enter transactions as they occur.
37
38
E)
There are four quarterly reports that allow a Treasurer to audit themselves, so that
39
a Treasurer may locate errors prior to review by the Trustees.
40
Please note this is not a substitute for the Trustee audit!
41
42
F)
There is a final fiscal year report that will summarize the entire fiscal year.
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