ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To download a copy of this sheet, navigate to "File>Download" to save a copy to your electronic device in the file format you choose (we recommend .xlsx for Microsoft Excel users). Alternatively, you can also choose "File>Make a Copy" to save a copy of this sheet to your Google Acccount for use. You do not have to have a Gmail account to create a Google Account.
2
Use the instructions located in the sections below to navigate using your Finance Tracking Spreadsheet. You may also find a Glossary of category terms and definitions on the 4th tab of this sheet to help you in categorizing your line items.
3
4
Instructions for Details Tab - Your Check Register
5
6
1. Complete the green highlighted section at the top with your General Service Unit Info.
7
8
2. Entering starting balance in Row E6 (highlighted in green). Enter the balance you ended with on your previous year's financial report.
9
10
3. Entering your Income and Expenses
11
a. Beginning with row 7 and utilizing subsequent rows for each line item, you would enter the date, Amount, details and Category of transaction from the bank.
12
Example of an income:If you made a deposit to open the account, you would put the date on Row 7 Column A,  the amount of the deposit (as a positive number); "Details" would be the reason you are making a deposit, such as "Disbanded Troop funds from TroopXXXXX."  Then in Column D, there is a drop down option to select the category of the item.  For disbandment, we suggest "Income-Disbanded Troop Funds Collected." You will see the sheet defaults to recognizing uncategorized items as expenses and subtracts them; however, once you add the income category, the sheet will recognize the figure needs added and will add it to the running total.
13
Example of an expense:Enter the date of the purchase in column A.  In column B, enter the amount (no negative symbols are needed).  Use column C to briefly describe what was purchased, such as "Food for Leader Appreciation."  Finally, in column D,  choose the category that best fits the expense, such as "Expense- Leader Appreciation and Recognition."
14
15
4. Each month or quarterly, it is recommended for service units to reconcile their spreadsheet with their bank statements, or making sure the amounts from the statement and your spreadsheet match.
16
a. Look at Column E and the last transaction entered to see the amount listed verses the bank statement. The amounts should match.
17
18
Instructions for Summary Tab - Report to GSofSI
19
1. Service Unit Financial Report to GSofSI
20
a. In June, you will have to use Council's system to submit your Service Unit Financial Report. Currently, a form on our website is utilized.
21
b. The summary tab is populated with the Detail Tab information. Make sure the ending balance (Summary tab's Column B, Row 39) equals the detail tab balance on the last line entered. 
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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