ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TRI-COUNTY INDEPENDENT LIVING INC1:22 PM
2
Profit & Loss03/30/2023
3
July 2021 through June 2022Accrual Basis
4
5
Jul '21 - Jun 22
Jul '20 - Jun 21
$ Change% Change
6
Income
7
4000 · Grants
8
4005 · CARES ACT Grant
20,762.18 36,793.78 (16,031.60)(43.57%)
9
4010 · AB204/AT (State) Grant
327,636.18 351,293.87 (23,657.69)(6.73%)
10
4013 · Cal Fresh Grant
497.63 0.00 497.63 100.0%
Grant is active again this FY
11
4015 · Title VIIC (Federal) Grant
81,267.45 71,046.53 10,220.92 14.39%
12
4016 · Title VIIB Grant
221,675.67 215,114.77 6,560.90 3.05%
13
4017 · VIIB SPIL Grant
0.00 6,208.45 (6,208.45)(100.0%)
Didn't receive this grant in FY 21-22
14
4019 · Transition Funds
7,898.24 4,715.18 3,183.06 67.51%
15
Total 4000 · Grants
659,737.35 685,172.58 (25,435.23)(3.71%)
16
4020 · TCIL General Fund
17
4022 · Grants - Non-Governmental
59,072.69 47,369.94 11,702.75 24.71%
18
4040 · Donations
4,455.22 2,853.39 1,601.83 56.14%
19
4045 · Donations In-Kind
0.00 12,802.00 (12,802.00)(100.0%)
20
4080 · Interest Income
41.64 38.97 2.67 6.85%
21
4670 · AT Expo
755.00 0.00 755.00 100.0%
22
4990 · Special Program Funds
740.40 1,300.12 (559.72)(43.05%)
23
4999 · Uncategorized Income
2,186.30 1,764.45 421.85 23.91%
Sick & Family Leave Credit from IRS for 3rd Qtr '32, State Fund Dividends
24
4120 · Program Income
1,987.25 0.00 1,987.25 100.0%
25
Total 4020 · TCIL General Fund
69,238.50 66,128.87 3,109.63 4.7%
26
Total Income
728,975.85 751,301.45 (22,325.60)(2.97%)
27
Gross Profit
728,975.85 751,301.45 (22,325.60)(2.97%)
28
Expense
29
1 · PERSONNEL
30
5000 · Payroll Expenses
31
5005 · Gross Payroll
32
5006 · Salaries & Wages 361,932.74 341,824.83 20,107.91 5.88%
33
5008 · PTO Exp - Fringe Benefit 35,650.34 42,343.90 (6,693.56)(15.81%)
34
5014 · SS - Fringe Benefit 26,507.23 26,303.66 203.57 0.77%
35
5016 · MCARE - Fringe Benefit 6,212.13 6,172.41 39.72 0.64%
36
5017 · SUI - Fringe Benefit 4,406.64 4,623.15 (216.51)(4.68%)
37
5018 · ETT - Fringe Benefit 115.90 92.97 22.93 24.66%
38
5020 · W/C Insurance - Fringe Benefit 6,182.11 6,061.67 120.44 1.99%
39
5021 · Health Insurance Stipend Wages
3,118.24 0.00 3,118.24 100.0%
40
5095 · Direct Deposit - Fringe Benefit 585.25 582.50 2.75 0.47%
41
Total 5005 · Gross Payroll
444,710.58 428,005.09 16,705.49 3.9%
42
5010 · Personnel Benefits
43
5030 · Health Insurance-Fringe Benefit
29,130.79 24,465.19 4,665.60 19.07%
44
5031 · Dental Insurance-Fringe Benefit
3,646.31 4,294.40 (648.09)(15.09%)
45
5010 · Personnel Benefits - Other(2,819.28)(2,897.78) 78.50 2.71%
46
Total 5010 · Personnel Benefits
29,957.82 25,861.81 4,096.01 15.84%
47
5000 · Payroll Expenses - Other
0.00 0.00 0.00 0.0%
48
Total 5000 · Payroll Expenses
474,668.40 453,866.90 20,801.50 4.58%
49
5040 · Indirect Costs
46,787.36 47,276.00 (488.64)(1.03%)
50
Total 1 · PERSONNEL
521,455.76 501,142.90 20,312.86 4.05%
51
2 · OPERATING
52
L 1&17 · RENT
53
6000 · Rent Expense
35,517.00 30,828.06 4,688.94 15.21%
New office in Del Norte County
54
Total L 1&17 · RENT
35,517.00 30,828.06 4,688.94 15.21%
55
L 2&18 · SUPPLIES MASTER ACCOUNT
56
6010 · Supplies
15,334.38 13,678.46 1,655.92 12.11%
57
6020 · Postage & Delivery Expense
1,004.02 925.12 78.90 8.53%
58
Total L 2&18 · SUPPLIES MASTER ACCOUNT
16,338.40 14,603.58 1,734.82 11.88%
59
L 3&19 · COMMUNICATIONS
60
6040 · Communications Expense
11,386.90 8,466.92 2,919.98 34.49%
New phone expenses for DN office
61
Total L 3&19 · COMMUNICATIONS
11,386.90 8,466.92 2,919.98 34.49%
62
L 4&20 · TRAVEL
63
6060 · Travel Expense
2,123.51 819.06 1,304.45 159.26%
Travel more active after covid
64
Total L 4&20 · TRAVEL
2,123.51 819.06 1,304.45 159.26%
65
L 6&21 · TRAINING AND CONFERENCES
66
6110 · Training and Conferences
3,110.02 2,088.00 1,022.02 48.95%
Attending more traingings since covid
67
Total L 6&21 · TRAINING AND CONFERENCES
3,110.02 2,088.00 1,022.02 48.95%
68
L 7&22 · INSURANCE
69
6070 · General Liability Insurance Exp
4,664.44 6,617.76 (1,953.32)(29.52%)
70
6080 · Directors & Officers Insurance
1,440.92 1,440.96 (0.04)(0.0%)
71
6085 · Auto Insurance Exp
6,235.86 3,624.92 2,610.94 72.03%
72
Total L 7&22 · INSURANCE
12,341.22 11,683.64 657.58 5.63%
73
L 8&23 · REPAIRS AND MAINTENANCE
74
6120 · Repairs and Maintenance Expense
223.57 155.36 68.21 43.9%
75
6125 · Vehicle Repairs & Maintenance
1,057.18 1,617.67 (560.49)(34.65%)
Don't have 2016 Honda DMV fees anymore
76
Total L 8&23 · REPAIRS AND MAINTENANCE
1,280.75 1,773.03 (492.28)(27.77%)
77
L 9&24 · UTILITIES
78
6130 · Utilities Expense
7,498.57 6,450.36 1,048.21 16.25%
Increase due to new Del Norte office
79
Total L 9&24 · UTILITIES
7,498.57 6,450.36 1,048.21 16.25%
80
L 10 · CONTRACTUAL
81
6140 · Accounting Expense
15,912.00 13,284.00 2,628.00 19.78%
82
6150 · Professional Services Expense
83
6151 · Alarm Expense 1,371.89 383.40 988.49 257.82%
New alarm systems & addition of DN office
84
6152 · Copier Expense 1,265.54 1,125.90 139.64 12.4%
85
6153 · Janitorial Expense 2,284.20 7,210.38 (4,926.18)(68.32%)
86
6154 · Other Professional Services 9,222.28 25,771.30 (16,549.02)(64.22%)
Purchased new alarm systems in previous FY, and also had contract with a personnel service for a temp employee
87
6155 · Computer Expense 1,313.90 598.02 715.88 119.71%
88
Total 6150 · Professional Services Expense
15,457.81 35,089.00 (19,631.19)(55.95%)
89
Total L 10 · CONTRACTUAL
31,369.81 48,373.00 (17,003.19)(35.15%)
90
L11 · RECRUITMENT
91
6170 · Recruitment
989.22 334.76 654.46 195.5%
More periods of vacant positions
92
Total L11 · RECRUITMENT
989.22 334.76 654.46 195.5%
93
L 12&25 · OUTREACH
94
6171 · Outreach Expense
2,135.06 6,946.73 (4,811.67)(69.27%)
DDAR program outreach
95
Total L 12&25 · OUTREACH
2,135.06 6,946.73 (4,811.67)(69.27%)
96
L 13&26 · FEES & DUES
97
6100 · Fees and Dues Expense
9,017.84 6,927.88 2,089.96 30.17%
98
Total L 13&26 · FEES & DUES
9,017.84 6,927.88 2,089.96 30.17%
99
L14 · MINOR EQUIPMENT
100
6160 · Minor Equipment
11,750.11 8,858.56 2,891.55 32.64%