HomeMy WebLinkAboutE-09 Staff Report - Treasurers Report of Receipts, Disbursements and Fund BalancesCONSENT ITEM
E-9
TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL
VIA: SERGIO GONZALEZ, CITY MANAGER
FROM: ART VASQUEZ, CITY TREASURER
TALIKA M. JOHNSON, DIRECTOR OF FINANCE
DATE: JUNE 18, 2018
SUBJECT: CITY TREASURER’S ACCOUNTING OF ALL RECEIPTS, DISBURSEMENTS AND
FUND BALANCES FOR THE MONTHS OF JULY 2017 THROUGH FEBRUARY
2018
BACKGROUND:
California Government Code Section 41004 requires the City Treasurer to submit to the City Clerk and
the City’s legislative body a written report and accounting of all receipts, disbursements and fund
balances monthly. The recommended action requests the City Council receive and file the attached
reports for the periods of July 2017 through February 2018.
RECOMMENDATION:
Staff recommends the City Council take the following actions:
1)Receive, review, and file the City Treasurer’s Reports of Receipts, Disbursements and Fund
Balances for the months of July 2017 through February 2018.
ANALYSIS:
The City Treasurer and Finance Department currently reports to the City Council statements of citywide
cash and investments and summaries of disbursements made via the accounts payable process on a
monthly basis. While these reports will continue to be presented to the Council, California Government
Code Section 41004 requires at least once each month, the city treasurer submit to the city clerk a
written report and accounting of all receipts, disbursements, and fund balances and that the city treasurer
file a copy with the legislative body. Therefore, the City Treasurer’s future monthly Statement of Cash
and Investment Balances report to Council will be expanded to include Accounting of all Receipts,
APPROVED
CITY COUNCIL
6/18/2018
Accounting of Receipts, Disbursements, and Fund Balances
June 18, 2018
Page 2
Disbursements, and Fund Balances in a format that complies with the government code and prepared by
Finance Staff.
In order to comply with the requirements of Government Code Section 41004, Finance Staff has
prepared monthly statements containing cash balance details and summaries along with fund balance
summaries. The attached statements provide a snapshot of the General Ledger cash and fund balances at
the end of each month. Due to the timing of inflows and outflows of revenues and disbursements, cash
and fund balances may vary dramatically from month-to-month. Thus, the reported balances at each
month end may not reflect the audited financial status of each Fund at year-end closing.
FISCAL IMPACT:
There is no fiscal impact associated with the recommended action.
Prepared by: Reviewed and Approved:
Talika M. Johnson Sergio Gonzalez
Director of Finance City Manager
Attachments:
1) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – July 2017
2) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – August 2017
3)City Treasurer’s Report of Receipts, Disbursements and Fund Balances – September 2017
4) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – October 2017
5) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – November 2017
6)City Treasurer’s Report of Receipts, Disbursements and Fund Balances – December 2017
7) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – January 2018
8) City Treasurer’s Report of Receipts, Disbursements and Fund Balances – February 2018
City of Azusa
Cash Balances
For the Month ended July 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution Fund $1,630,496.68 $4,320.90 $0.00 $1,634,817.58
10 General Fund 11,773,824.99 2,203,359.43 4,698,038.74 9,279,145.68
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $13,409,355.92 $2,207,680.33 $4,698,038.74 $10,918,997.51
03 Measure R-LA County $709,790.60 $51,683.91 $108,830.32 $652,644.19
04 Measure M 0.00 0.00 0.00 0.00
07 Rosedale Traffic Mitigation 508,022.66 1,345.99 0.00 509,368.65
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax 89,838.93 3,872.66 187,908.18 (94,196.59)
13 Utility Mitigation 939,082.64 23,746.00 0.00 962,828.64
14 Highway 39 1,533,421.49 4,062.94 0.00 1,537,484.43
15 Proposition A 1,597,086.91 69,852.03 75,945.21 1,590,993.73
16 LACMTA (0.33)0.00 0.00 (0.33)
17 Proposition C 1,590,577.51 61,579.08 57,077.55 1,595,079.04
18 Community Development Block Grant (0.31)24,792.00 36,514.39 (11,722.70)
21 Senior Nutrition 42,836.60 20,479.66 24,762.31 38,553.95
24 Public Benefit Program 1,007,583.91 89,553.73 118,873.53 978,264.11
26 Supplemental Law Enforcement 323,968.57 0.00 0.00 323,968.57
27 Air Quality Improvement 130,663.56 741.45 5,813.30 125,591.71
28 Grants and Seizures 2,604,007.32 57,198.09 82,371.01 2,578,834.40
29 Fire Safety 238,294.47 408,795.00 799,532.53 (152,443.06)
37 Monrovia Nursery 435,656.32 12,355.81 67,414.20 380,597.93
39 AB939 Fee 404,234.78 15,513.47 31,792.14 387,956.11
41 Employee Benefits (489,235.60)89,792.00 7,037.70 (406,481.30)
TOTAL SPECIAL REVENUE FUNDS $11,665,830.44 $935,363.82 $1,603,872.37 $10,997,321.89
19 Park In-lieu $54,946.58 $698.37 $1,281.54 $54,363.41
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 181,673.71 505.53 0.00 182,179.24
TOTAL CAPITAL PROJECTS FUNDS $955,786.09 $1,203.90 $1,281.54 $955,708.45
Attachment 1
City of Azusa
Cash Balances
For the Month ended July 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority $8,615.55 $29,601.00 $321,950.78 ($283,734.23)
TOTAL DEBT SERVICE FUND $8,615.55 $29,601.00 $321,950.78 ($283,734.23)
32 Water Fund $27,099,458.27 $2,970,685.63 $922,814.56 $29,147,329.34
33 Electric Fund 12,611,582.53 3,743,168.60 3,345,742.11 13,009,009.02
34 Sewer Fund 3,838,843.13 256,615.89 189,054.55 3,906,404.47
36 Refuse Fund 233,493.12 359,395.93 74,088.78 518,800.27
TOTAL ENTERPRISE FUNDS $43,783,377.05 $7,329,866.05 $4,531,700.00 $46,581,543.10
31 Consumer Services $1,331,829.85 $117,328.18 $778,460.17 $670,697.86
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance 1,581,040.12 125,296.21 3,338,353.95 (1,632,017.62)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 18,980.37 1,529.93 0.00 20,510.30
48 IT Service Fund 232,356.83 480.00 272,812.07 (39,975.24)
TOTAL INTERNAL SERVICE FUNDS $3,169,115.90 $244,634.32 $4,389,626.19 ($975,875.97)
50 Special Deposits $8,918,340.17 $125,948.13 $42,332.81 $9,001,955.49
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $8,918,590.17 $125,948.13 $42,332.81 $9,002,205.49
80 Cap Proj/MRG ($1,077.46)$0.00 $0.00 ($1,077.46)
81 LowMod 20%/Sp Rev 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 LowMod SR/TAB2008 (298,408.68)0.00 0.00 (298,408.68)
87 Cap Proj/MRG 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)2,463,098.93 2,463,098.93 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 4,886,480.32 4,592.44 2,463,098.93 2,427,973.83
87 CP/MRG/CBD-Successor Agency (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 CP/MRG/WE-Successor Agency (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 DS/MRG/TAB03-Successor Ag (214,275.74)0.00 0.00 (214,275.74)
87 DS/MRG/TAB08B-Successor Ag 215,165.15 0.00 0.00 215,165.15
87 CP/MRG/Rch CT- Successor A 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Succ Agency Rec OB Retrmn 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $3,561,790.83 $2,467,691.37 $4,926,197.86 $1,103,284.34
City of Azusa
Cash Balance-Summary
For the Month ended July 31, 2017
GENERAL FUND $10,918,997.51
SPECIAL REVENUE FUNDS 10,997,321.89
CAPITAL PROJECTS FUNDS 955,708.45
DEBT SERVICE FUND (283,734.23)
ENTERPRISE FUNDS 46,581,543.10
INTERNAL SERVICE FUNDS (975,875.97)
AGENCY FUNDS 9,002,205.49
PRIVATE PURPOSE TRUST FUND 1,103,284.34
TOTAL $78,299,450.58
City of Azusa
Fund Balance-Summary
For the Month ended July 31, 2017
Fund Description Balance
06 Rosedale Contribution Fund $5,213,918.68
10 General fund 15,784,062.00
TOTAL GENERAL FUND $20,997,980.68
03 Measure R-LA County $3,976,891.26
04 Measure M 0.00
07 Rosedale Traffic Mitigation 509,368.65
08 CDBG 0.41
12 State Gasoline Tax (159,891.95)
13 Utility Mitigation 962,628.64
14 Highway 39 1,537,484.43
15 Proposition A 1,561,737.83
16 LACMTA (27.33)
17 Proposition C 1,504,680.83
18 Community Development Block Gran (181,683.09)
21 Senior Nutrition 16,871.55
24 Public Benefit Program 905,634.40
26 Supplemental Law Enforcement 44,055.60
27 Air Quality Improvement 141,259.58
28 Grants and Seizures 1,162,451.64
29 Fire Safety (152,443.53)
37 Monrovia Nursery 348,510.34
39 AB939 Fee 382,005.46
41 Employee Benefits (412,123.65)
TOTAL SPECIAL REVENUE FUNDS 12,147,411.07
19 Park In-lieu $48,713.41
22 Capital Projects (540.90)
49 Public Works Endowment 178,179.18
TOTAL CAPITAL PROJECTS FUNDS 226,351.69
71 Debt Services/2003 CIP COPS $199,588.35
TOTAL DEBT SERVICE FUND 199,588.35
City of Azusa
Fund Balance-Summary
For the Month ended July 31, 2017
Fund Description Balance
32 Water $55,723,628.21
33 Electric 44,125,815.79
34 Sewer 10,130,491.30
36 Refuse 478,425.89
TOTAL ENTERPRISE FUNDS 110,458,361.19
31 Consumer Services ($3,882,553.23)
42 Self Insurance (5,081,315.12)
43 Central Services $31,030.69
46 Equip. Replace. Fund 289,784.25
48 IT Services Fund (2,214,292.98)
TOTAL INTERNAL SERVICE FUNDS ($10,857,346.39)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (56,756,409.34)
88 SUCC AGENCY REC OB RETR 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND (20,858,984.73)
TOTAL $112,313,361.86
City of Azusa
Cash Balances
For the Month ended August 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution Fund $1,634,817.58 $0.00 $0.00 $1,634,817.58
10 General Fund 9,279,145.68 3,706,048.37 3,617,561.60 9,367,632.45
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $10,918,997.51 $3,706,048.37 $3,617,561.60 $11,007,484.28
03 Measure R-LA County $652,644.19 $50,025.75 $163,515.35 $539,154.59
04 Measure M 0.00 0.00 0.00 0.00
07 Rosedale Traffic Mitigation 509,368.65 0.00 0.00 509,368.65
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (94,196.59)185,158.51 138,497.99 (47,536.07)
13 Utility Mitigation 962,828.64 23,746.00 200.00 986,374.64
14 Highway 39 1,537,484.43 0.00 0.00 1,537,484.43
15 Proposition A 1,590,993.73 107,883.85 80,180.28 1,618,697.30
16 LACMTA (0.33)0.00 0.00 (0.33)
17 Proposition C 1,595,079.04 74,592.76 60,671.41 1,609,000.39
18 Community Development Block Grant (11,722.70)675.65 19,026.40 (30,073.45)
21 Senior Nutrition 38,553.95 35,214.40 39,895.90 33,872.45
24 Public Benefit Program 978,264.11 100,883.80 93,550.23 985,597.68
26 Supplemental Law Enforcement 323,968.57 0.00 962.96 323,005.61
27 Air Quality Improvement 125,591.71 16,440.33 3,226.76 138,805.28
28 Grants and Seizures 2,578,834.40 108,279.85 49,093.56 2,638,020.69
29 Fire Safety (152,443.06)408,795.00 408,421.59 (152,069.65)
37 Monrovia Nursery 380,597.93 3,486.71 52,263.60 331,821.04
39 AB939 Fee 387,956.11 16,804.86 43,955.17 360,805.80
41 Employee Benefits (406,481.30)89,792.00 14,549.40 (331,238.70)
TOTAL SPECIAL REVENUE FUNDS $10,997,321.89 $1,221,779.47 $1,168,010.60 $11,051,090.76
19 Park In-lieu $54,363.41 $11,250.00 $0.00 $65,613.41
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 182,179.24 0.00 1.07 182,178.17
TOTAL CAPITAL PROJECTS FUNDS $955,708.45 $11,250.00 $1.07 $966,957.38
Attachment 2
City of Azusa
Cash Balances
For the Month ended August 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($283,734.23)$29,601.00 $1,850.00 ($255,983.23)
TOTAL DEBT SERVICE FUND ($283,734.23)$29,601.00 $1,850.00 ($255,983.23)
32 Water Fund $29,147,329.34 $1,957,115.41 $816,886.67 $30,287,558.08
33 Electric Fund 13,009,009.02 4,695,518.19 3,824,242.57 13,880,284.64
34 Sewer Fund 3,906,404.47 264,244.75 576,831.97 3,593,817.25
36 Refuse Fund 518,800.27 381,629.71 657,331.96 243,098.02
TOTAL ENTERPRISE FUNDS $46,581,543.10 $7,298,508.06 $5,875,293.17 $48,004,757.99
31 Consumer Services $670,697.86 $30,630.21 $469,043.54 $232,284.53
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (1,632,017.62)87,157.81 461,711.33 (2,006,571.14)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,510.30 0.00 0.00 20,510.30
48 IT Service Fund (39,975.24)960.00 217,254.14 (256,269.38)
TOTAL INTERNAL SERVICE FUNDS ($975,875.97)$118,748.02 $1,148,009.01 ($2,005,136.96)
50 Claim on Cash $9,001,955.49 $116,996.00 $2,223,760.01 $6,895,191.48
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $9,002,205.49 $116,996.00 $2,223,760.01 $6,895,441.48
80 Cap Proj/MRG ($1,077.46)$0.00 $0.00 ($1,077.46)
81 LowMod 20%/Sp Rev 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 LowMod SR/TAB2008 (298,408.68)0.00 0.00 (298,408.68)
87 Cap Proj/MRG 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)5,371.30 5,371.30 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)559,842.62 559,842.62 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 2,427,973.83 6,417.52 565,213.92 1,869,177.43
87 CP/MRG/CBD-Successor Agency (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 CP/MRG/WE-Successor Agency (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 DS/MRG/TAB03-Successor Ag (214,275.74)0.00 0.00 (214,275.74)
87 DS/MRG/TAB08B-Successor Ag 215,165.15 0.00 0.00 215,165.15
87 CP/MRG/Rch CT- Successor A 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Succ Agency Rec OB Retrmn 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $1,103,284.34 $571,631.44 $1,130,427.84 $544,487.94
City of Azusa
Cash Balance-Summary
For the Month ended August 31, 2017
GENERAL FUND $11,007,484.28
SPECIAL REVENUE FUNDS 11,051,090.76
CAPITAL PROJECTS FUNDS 966,957.38
DEBT SERVICE FUND (255,983.23)
ENTERPRISE FUNDS 48,004,757.99
INTERNAL SERVICE FUNDS (2,005,136.96)
AGENCY FUNDS 6,895,441.48
PRIVATE PURPOSE TRUST FUND 544,487.94
TOTAL $76,209,099.64
City of Azusa
Fund Balance-Summary
For the Month ended August 31, 2017
Fund Description Balance
06 Rosedale Contribution fund $5,213,732.68
10 General fund 15,128,283.00
TOTAL GENERAL FUND $20,342,015.68
03 Measure R-LA County $3,866,823.26
04 Measure M 0.00
07 Rosedale Traffic Mitigation 509,368.65
08 CDBG 0.41
12 State Gasoline Tax (94,377.95)
13 Utility Mitigation 984,726.64
14 Highway 39 1,537,484.43
15 Proposition A 1,593,649.83
16 LACMTA (27.33)
17 Proposition C 1,538,295.83
18 Community Development Block Gran (14,653.09)
21 Senior Nutrition 28,433.55
24 Public Benefit Program 893,857.40
26 Supplemental Law Enforcement 43,092.60
27 Air Quality Improvement 138,430.58
28 Grants and Seizures 1,144,533.60
29 Fire Safety (152,070.53)
37 Monrovia Nursery 287,984.34
39 AB939 Fee 340,576.46
41 Employee Benefits (329,843.65)
TOTAL SPECIAL REVENUE FUNDS 12,316,285.03
19 Park In-lieu $59,938.41
22 Capital Projects (540.90)
49 Public Works Endowment 173,788.18
TOTAL CAPITAL PROJECTS FUNDS 233,185.69
71 Debt Services/2003 CIP COPS $229,189.35
TOTAL DEBT SERVICE FUND 229,189.35
City of Azusa
Fund Balance-Summary
For the Month ended August 31, 2017
Fund Description Balance
32 Water $56,981,331.21
33 Electric 45,321,952.79
34 Sewer 11,466,277.30
36 Sewer Maintence (1,250,240.00)
Refuse 489,785.89
TOTAL ENTERPRISE FUNDS 113,009,107.19
31 Consumer Services ($4,213,606.23)
42 Self Insurance (5,485,010.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,784.25
48 IT Services Fund (2,320,237.98)
TOTAL INTERNAL SERVICE FUNDS (11,698,039.39)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (57,370,319.34)
88 SUCC AGENCY REC OB RETR 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND (21,472,894.73)
TOTAL $112,958,848.82
City of Azusa
Cash Balances
For the Month ended September 30, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $1,634,817.58 $5,392.38 $185.57 $1,640,024.39
10 General Fund 9,367,632.45 2,147,424.05 2,983,491.31 8,531,565.19
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $11,007,484.28 $2,152,816.43 $2,983,676.88 $10,176,623.83
03 Measure R-LA County $539,154.59 $96,991.08 $89,015.68 $547,129.99
04 Measure M 0.00 37,949.60 0.00 37,949.60
07 Rosedale Traffic Mitigation 509,368.65 1,679.23 0.00 511,047.88
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (47,536.07)4,363.58 114,827.01 (157,999.50)
13 Utility Mitigation 986,374.64 23,746.00 2,295.00 1,007,825.64
14 Highway 39 1,537,484.43 5,069.93 0.00 1,542,554.36
15 Proposition A 1,618,697.30 130,872.10 56,819.16 1,692,750.24
16 LACMTA (0.33)0.00 0.00 (0.33)
17 Proposition C 1,609,000.39 147,694.60 156,965.48 1,599,729.51
18 Community Development Block Grant (30,073.45)104,181.00 15,832.99 58,274.56
21 Senior Nutrition 33,872.45 18,313.80 12,049.03 40,137.22
24 Public Benefit Program 985,597.68 105,395.28 98,597.87 992,395.09
26 Supplemental Law Enforcement 323,005.61 40,213.78 962.96 362,256.43
27 Air Quality Improvement 138,805.28 770.82 3,048.63 136,527.47
28 Grants and Seizures 2,638,020.69 71,021.13 88,594.76 2,620,447.06
29 Fire Safety (152,069.65)408,795.00 0.00 256,725.35
37 Monrovia Nursery 331,821.04 1,220.36 63,227.01 269,814.39
39 AB939 Fee 360,805.80 16,740.58 23,496.97 354,049.41
41 Employee Benefits (331,238.70)89,792.00 0.00 (241,446.70)
TOTAL SPECIAL REVENUE FUNDS $11,051,090.76 $1,304,809.87 $725,732.55 $11,630,168.08
19 Park In-lieu $65,613.41 $17,313.31 $25.13 $82,901.59
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 182,178.17 597.78 4,391.06 178,384.89
TOTAL CAPITAL PROJECTS FUNDS $966,957.38 $17,911.09 $4,416.19 $980,452.28
Attachment 3
City of Azusa
Cash Balances
For the Month ended September 30, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($255,983.23)$29,601.00 $0.00 ($226,382.23)
TOTAL DEBT SERVICE FUND ($255,983.23)$29,601.00 $0.00 ($226,382.23)
32 Water Fund $30,287,558.08 $1,895,165.50 $2,587,455.45 $29,595,268.13
33 Electric Fund 13,880,284.64 3,806,909.22 3,170,911.14 14,516,282.72
34 Sewer Fund 3,593,817.25 255,237.16 118,204.91 3,730,849.50
36 Refuse Fund 243,098.02 342,521.17 72,100.99 513,518.20
TOTAL ENTERPRISE FUNDS $48,004,757.99 $6,299,833.05 $5,948,672.49 $48,355,918.55
31 Consumer Services $232,284.53 $143,504.31 $410,501.30 ($34,712.46)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (2,006,571.14)115,389.10 118,905.09 (2,010,087.13)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,510.30 64.49 0.00 20,574.79
48 IT Service Fund (256,269.38)240.00 136,225.95 (392,255.33)
TOTAL INTERNAL SERVICE FUNDS ($2,005,136.96)$259,197.90 $665,632.34 ($2,411,571.40)
50 Claim on Cash $6,895,191.48 $104,633.30 $20,859.10 $6,978,965.68
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $6,895,441.48 $104,633.30 $20,859.10 $6,979,215.68
80 Claim on Cash ($1,077.46)$0.00 $0.00 ($1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)15,394.63 15,394.63 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 1,869,177.43 0.00 15,394.63 1,853,782.80
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $544,487.94 $15,394.63 $30,789.26 $529,093.31
City of Azusa
Cash Balance-Summary
For the Month ended September 30, 2017
GENERAL FUND $10,176,623.83
SPECIAL REVENUE FUNDS 11,630,168.08
CAPITAL PROJECTS FUNDS 980,452.28
DEBT SERVICE FUND (226,382.23)
ENTERPRISE FUNDS 48,355,918.55
INTERNAL SERVICE FUNDS (2,411,571.40)
AGENCY FUNDS 6,979,215.68
PRIVATE PURPOSE TRUST FUND 529,093.31
TOTAL $76,013,518.10
City of Azusa
Fund Balance-Summary
For the Month ended September 30, 2017
Fund Description Balance
06 Rosedale Contribution Fund $5,199,704.68
10 General fund 14,508,733.00
TOTAL GENERAL FUND $19,708,437.68
03 Measure R-LA County $3,324,486.26
04 Measure M 37,950.00
07 Rosedale Traffic Mitigation 511,047.65
08 CDBG 0.41
12 State Gasoline Tax (241,969.95)
13 Utility Mitigation 961,690.64
14 Highway 39 1,542,554.43
15 Proposition A 1,663,530.83
16 LACMTA (27.33)
17 Proposition C 1,589,408.83
18 Community Development Block Gran (32,675.09)
21 Senior Nutrition 23,918.55
24 Public Benefit Program 938,890.40
26 Supplemental Law Enforcement 75,643.60
27 Air Quality Improvement 136,157.58
28 Grants and Seizures 1,153,341.85
29 Fire Safety (140,317.35)
37 Monrovia Nursery 234,257.49
39 AB939 Fee 350,546.11
41 Employee Benefits (247,252.65)
TOTAL SPECIAL REVENUE FUNDS 11,881,182.26
19 Quimby-Park Maint $77,251.59
22 CIP/Park Planning (540.90)
49 Public Works Endowment 174,385.96
TOTAL CAPITAL PROJECTS FUNDS 251,096.65
71 Debt Services/2003 CIP COPS $259,017.32
TOTAL DEBT SERVICE FUND 259,017.32
City of Azusa
Fund Balance-Summary
For the Month ended September 30, 2017
Fund Description Balance
32 Water $55,047,242.21
33 Electric 46,443,110.79
34 Sewer 11,466,277.30
36 Sewer Maintence (1,076,980.00)
Refuse 184,102.89
TOTAL ENTERPRISE FUNDS 112,063,753.19
31 Consumer Services ($4,406,138.23)
42 Self Insurance (5,555,318.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,848.25
48 IT Services Fund (2,445,406.98)
TOTAL INTERNAL SERVICE FUNDS (12,085,984.39)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (58,376,349.75)
88 SUCC AGENCY REC OB RETR 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND (22,478,925.14)
TOTAL $109,598,577.57
City of Azusa
Cash Balances
For the Month ended October 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $1,640,024.39 $0.00 $55,000.00 $1,585,024.39
10 General Fund 8,531,565.19 3,031,975.75 2,719,226.11 8,844,314.83
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $10,176,623.83 $3,031,975.75 $2,774,226.11 $10,434,373.47
03 Measure R-LA County $547,129.99 $38,052.56 $169,918.64 $415,263.91
04 Measure M 37,949.60 37,764.82 0.00 75,714.42
07 Rosedale Traffic Mitigation 511,047.88 0.00 0.00 511,047.88
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (157,999.50)200,604.46 138,798.30 (96,193.34)
13 Utility Mitigation 1,007,825.64 23,746.00 43,217.61 988,354.03
14 Highway 39 1,542,554.36 0.00 0.00 1,542,554.36
15 Proposition A 1,692,750.24 66,447.49 63,943.35 1,695,254.38
16 LACMTA (0.33)0.00 0.00 (0.33)
17 Proposition C 1,599,729.51 109,740.43 85,512.85 1,623,957.09
18 Community Development Block Grant 58,274.56 302.54 162,022.28 (103,445.18)
21 Senior Nutrition 40,137.22 52,481.00 34,801.99 57,816.23
24 Public Benefit Program 992,395.09 84,390.36 87,407.98 989,377.47
26 Supplemental Law Enforcement 362,256.43 0.00 7,662.96 354,593.47
27 Air Quality Improvement 136,527.47 336.75 2,944.51 133,919.71
28 Grants and Seizures 2,620,447.06 118,109.33 93,323.55 2,645,232.84
29 Fire Safety 256,725.35 408,795.00 788,760.77 (123,240.42)
37 Monrovia Nursery 269,814.39 0.00 73,780.80 196,033.59
39 AB939 Fee 354,049.41 17,215.63 11,687.50 359,577.54
41 Employee Benefits (241,446.70)89,792.00 15,577.66 (167,232.36)
TOTAL SPECIAL REVENUE FUNDS $11,630,168.08 $1,247,778.37 $1,779,360.75 $11,098,585.70
19 Park In-lieu $82,901.59 $5,400.00 $5,943.61 $82,357.98
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 178,384.89 0.00 0.00 178,384.89
TOTAL CAPITAL PROJECTS FUNDS $980,452.28 $5,400.00 $5,943.61 $979,908.67
Attachment 4
City of Azusa
Cash Balances
For the Month ended October 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($226,382.23)$29,601.00 $0.00 ($196,781.23)
TOTAL DEBT SERVICE FUND ($226,382.23)$29,601.00 $0.00 ($196,781.23)
32 Water Fund $29,595,268.13 $1,896,625.15 $822,600.28 $30,669,293.00
33 Electric Fund 14,516,282.72 3,876,813.45 2,324,334.37 16,068,761.80
34 Sewer Fund 3,730,849.50 270,956.10 132,576.04 3,869,229.56
36 Refuse Fund 513,518.20 395,579.87 688,048.00 221,050.07
TOTAL ENTERPRISE FUNDS $48,355,918.55 $6,439,974.57 $3,967,558.69 $50,828,334.43
31 Consumer Services ($34,712.46)$20,454.56 $484,718.70 ($498,976.60)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (2,010,087.13)90,442.11 105,931.38 (2,025,576.40)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,574.79 0.00 0.00 20,574.79
48 IT Service Fund (392,255.33)1,491.59 108,521.40 (499,285.14)
TOTAL INTERNAL SERVICE FUNDS ($2,411,571.40)$112,388.26 $699,171.48 ($2,998,354.62)
50 Claim on Cash $6,978,965.68 $25,717.97 $89,567.80 $6,915,115.85
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $6,979,215.68 $25,717.97 $89,567.80 $6,915,365.85
80 Claim on Cash ($1,077.46)$0.00 $0.00 ($1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)0.00 0.00 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 1,853,782.80 1,046.22 325,543.53 1,529,285.49
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $529,093.31 $1,046.22 $325,543.53 $204,596.00
City of Azusa
Cash Balance-Summary
For the Month ended October 31, 2017
GENERAL FUND $10,434,373.47
SPECIAL REVENUE FUNDS 11,098,585.70
CAPITAL PROJECTS FUNDS 979,908.67
DEBT SERVICE FUND (196,781.23)
ENTERPRISE FUNDS 50,828,334.43
INTERNAL SERVICE FUNDS (2,998,354.62)
AGENCY FUNDS 6,915,365.85
PRIVATE PURPOSE TRUST FUND 204,596.00
TOTAL $77,266,028.27
City of Azusa
Fund Balance-Summary
For the Month ended October 31, 2017
Fund Description Balance
06 Rosedale Contribution Fund $5,199,704.68
10 General fund 14,490,531.00
TOTAL GENERAL FUND $19,690,235.68
03 Measure R-LA County $3,291,065.26
04 Measure M 75,715.00
07 Rosedale Traffic Mitigation 511,047.65
08 CDBG 0.41
12 State Gasoline Tax (209,422.95)
13 Utility Mitigation 985,436.64
14 Highway 39 1,542,554.43
15 Proposition A 1,676,394.83
16 LACMTA (27.33)
17 Proposition C 1,586,302.83
18 Community Development Block Gran (47,842.09)
21 Senior Nutrition 52,136.55
24 Public Benefit Program 965,418.40
26 Supplemental Law Enforcement 74,678.60
27 Air Quality Improvement 133,549.58
28 Grants and Seizures 1,212,112.85
29 Fire Safety (123,240.35)
37 Monrovia Nursery 166,721.49
39 AB939 Fee 357,714.11
41 Employee Benefits (165,837.65)
TOTAL SPECIAL REVENUE FUNDS 12,084,478.26
19 Quimby-Park Maint $82,357.46
22 CIP/Park Planning (540.90)
49 Public Works Endowment 174,385.96
TOTAL CAPITAL PROJECTS FUNDS 256,202.52
71 Debt Services/2003 CIP COPS $288,618.32
TOTAL DEBT SERVICE FUND 288,618.32
City of Azusa
Fund Balance-Summary
For the Month ended October 31, 2017
Fund Description Balance
32 Water $56,232,903.21
33 Electric 47,167,225.79
34 Sewer 11,466,277.30
36 Sewer Maintence (925,127.00)
Refuse 498,273.89
TOTAL ENTERPRISE FUNDS 114,439,553.19
31 Consumer Services ($4,722,526.23)
42 Self Insurance (5,526,131.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,848.25
48 IT Services Fund (2,542,679.98)
TOTAL INTERNAL SERVICE FUNDS (12,470,458.39)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (58,704,576.75)
88 SUCC AGENCY REC OB RETR 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND (22,807,152.14)
TOTAL $111,481,477.44
City of Azusa
Cash Balances
For the Month ended November 30, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $1,585,024.39 $0.00 $19,419.60 $1,565,604.79
10 General Fund 8,844,314.83 2,367,802.31 3,131,116.73 8,081,000.41
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $10,434,373.47 $2,367,802.31 $3,150,536.33 $9,651,639.45
03 Measure R-LA County $415,263.91 $50,783.15 $668,892.58 ($202,845.52)
04 Measure M 75,714.42 50,353.04 0.00 126,067.46
07 Rosedale Traffic Mitigation 511,047.88 0.00 0.00 511,047.88
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (96,193.34)99,668.20 184,125.02 (180,650.16)
13 Utility Mitigation 988,354.03 23,746.00 1,215.00 1,010,885.03
14 Highway 39 1,542,554.36 0.00 0.00 1,542,554.36
15 Proposition A 1,695,254.38 85,737.32 47,028.80 1,733,962.90
16 LACMTA (0.33)129.40 0.00 129.07
17 Proposition C 1,623,957.09 165,987.76 59,945.75 1,729,999.10
18 Community Development Block Grant (103,445.18)722.00 57,743.79 (160,466.97)
21 Senior Nutrition 57,816.23 36,214.44 12,492.06 81,538.61
24 Public Benefit Program 989,377.47 78,525.13 51,304.17 1,016,598.43
26 Supplemental Law Enforcement 354,593.47 20,295.74 965.17 373,924.04
27 Air Quality Improvement 133,919.71 336.75 2,149.36 132,107.10
28 Grants and Seizures 2,645,232.84 21,981.03 41,557.41 2,625,656.46
29 Fire Safety (123,240.42)408,795.00 0.00 285,554.58
37 Monrovia Nursery 196,033.59 5,203.17 64,584.81 136,651.95
39 AB939 Fee 359,577.54 17,727.92 8,248.12 369,057.34
41 Employee Benefits (167,232.36)89,792.00 7,788.83 (85,229.19)
TOTAL SPECIAL REVENUE FUNDS $11,098,585.70 $1,155,998.05 $1,208,040.87 $11,046,542.88
19 Park In-lieu $82,357.98 $4,500.00 $0.00 $86,857.98
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 178,384.89 0.00 0.00 178,384.89
TOTAL CAPITAL PROJECTS FUNDS $979,908.67 $4,500.00 $0.00 $984,408.67
Attachment 5
City of Azusa
Cash Balances
For the Month ended November 30, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($196,781.23)$29,601.00 $0.00 ($167,180.23)
TOTAL DEBT SERVICE FUND ($196,781.23)$29,601.00 $0.00 ($167,180.23)
32 Water Fund $30,669,293.00 $1,903,439.34 $843,382.45 $31,729,349.89
33 Electric Fund 16,068,761.80 3,446,004.28 2,862,493.26 16,652,272.82
34 Sewer Fund 3,869,229.56 279,307.91 118,408.82 4,030,128.65
36 Refuse Fund 221,050.07 408,476.00 386,657.76 242,868.31
TOTAL ENTERPRISE FUNDS $50,828,334.43 $6,037,227.53 $4,210,942.29 $52,654,619.67
31 Consumer Services ($498,976.60)$206,777.77 $326,496.23 ($618,695.06)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (2,025,576.40)190,618.12 232,701.84 (2,067,660.12)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,574.79 0.00 0.00 20,574.79
48 IT Service Fund (499,285.14)0.00 102,040.11 (601,325.25)
TOTAL INTERNAL SERVICE FUNDS ($2,998,354.62)$397,395.89 $661,238.18 ($3,262,196.91)
50 Claim on Cash $6,915,115.85 $175,642.25 $41,087.64 $7,049,670.46
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $6,915,365.85 $175,642.25 $41,087.64 $7,049,920.46
80 Claim on Cash ($1,077.46)$0.00 $0.00 ($1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)0.00 0.00 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 1,529,285.49 2,092.44 13,605.64 1,517,772.29
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $204,596.00 $2,092.44 $13,605.64 $193,082.80
City of Azusa
Cash Balance-Summary
For the Month ended November 30, 2017
GENERAL FUND $9,651,639.45
SPECIAL REVENUE FUNDS 11,046,542.88
CAPITAL PROJECTS FUNDS 984,408.67
DEBT SERVICE FUND (167,180.23)
ENTERPRISE FUNDS 52,654,619.67
INTERNAL SERVICE FUNDS (3,262,196.91)
AGENCY FUNDS 7,049,920.46
PRIVATE PURPOSE TRUST FUND 193,082.80
TOTAL $78,150,836.79
City of Azusa
Fund Balance-Summary
For the Month ended November 30, 2017
Fund Balance
06 Rosedale Contribution Fund $4,621,016.68
10 General fund 13,697,612.00
TOTAL GENERAL FUND $18,318,628.68
03 Measure R-LA County $3,318,324.26
04 Measure M 126,068.00
07 Rosedale Traffic Mitigation 511,047.65
08 CDBG 0.41
12 State Gasoline Tax (245,914.95)
13 Utility Mitigation 1,007,067.64
14 Highway 39 1,542,554.43
15 Proposition A 1,706,789.83
16 LACMTA 101.67
17 Proposition C 1,702,685.83
18 Community Development Block Gran (83,582.09)
21 Senior Nutrition 65,560.55
24 Public Benefit Program 995,048.40
26 Supplemental Law Enforcement 94,009.60
27 Air Quality Improvement 131,736.58
28 Grants and Seizures 1,206,538.34
29 Fire Safety (532,033.35)
37 Monrovia Nursery 109,646.82
39 AB939 Fee 364,553.11
41 Employee Benefits (83,834.65)
TOTAL SPECIAL REVENUE FUNDS 11,936,368.08
19 Quimby-Park Maint $86,857.46
22 CIP/Park Planning (540.90)
49 Public Works Endowment 174,385.96
TOTAL CAPITAL PROJECTS FUNDS 260,702.52
71 Debt Services/2003 CIP COPS $317,469.32
TOTAL DEBT SERVICE FUND 317,469.32
City of Azusa
Fund Balance-Summary
For the Month ended November 30, 2017
Fund Balance
32 Water $57,220,189.21
33 Electric 47,634,376.79
34 Sewer Maintence 10,664,920.30
36 Refuse 502,951.89
TOTAL ENTERPRISE FUNDS 116,022,438.19
31 Consumer Services ($4,920,702.23)
42 Self Insurance (5,675,307.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,848.25
48 IT Services Fund (2,659,960.98)
TOTAL INTERNAL SERVICE FUNDS (12,935,091.39)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (58,709,729.75)
88 SUCC AGENCY REC OB RETR 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND (22,812,305.14)
Total $111,108,210.26
City of Azusa
Cash Balances
For the Month ended December 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $1,565,604.79 $5,234.29 $578,688.43 $992,150.65
10 General Fund 8,081,000.41 1,889,880.40 4,786,282.41 5,184,598.40
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $9,651,639.45 $1,895,114.69 $5,364,970.84 $6,181,783.30
03 Measure R-LA County ($202,845.52)$58,123.58 $12,444.69 ($157,166.63)
04 Measure M 126,067.46 72,460.06 0.00 198,527.52
07 Rosedale Traffic Mitigation 511,047.88 1,764.54 0.00 512,812.42
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (180,650.16)3,014.00 142,068.73 (319,704.89)
13 Utility Mitigation 1,010,885.03 23,746.00 0.00 1,034,631.03
14 Highway 39 1,542,554.36 5,324.58 0.00 1,547,878.94
15 Proposition A 1,733,962.90 102,325.98 55,278.98 1,781,009.90
16 LACMTA 129.07 0.00 0.00 129.07
17 Proposition C 1,729,999.10 90,773.90 34,082.79 1,786,690.21
18 Community Development Block Grant (159,842.69)216,645.61 48,740.96 8,061.96
21 Senior Nutrition 81,538.61 35,197.89 23,727.82 93,008.68
24 Public Benefit Program 1,016,598.43 72,402.48 38,743.38 1,050,257.53
26 Supplemental Law Enforcement 373,924.04 1,067.37 965.17 374,026.24
27 Air Quality Improvement 132,107.10 16,939.59 2,149.36 146,897.33
28 Grants and Seizures 2,625,656.46 27,743.74 25,986.56 2,627,413.64
29 Fire Safety 285,554.58 408,795.00 408,794.00 285,555.58
37 Monrovia Nursery 136,651.95 632.04 56,480.45 80,803.54
39 AB939 Fee 369,057.34 16,605.94 10,001.77 375,661.51
41 Employee Benefits (85,229.19)89,792.00 7,773.83 (3,211.02)
TOTAL SPECIAL REVENUE FUNDS $11,047,167.16 $1,243,354.30 $867,238.49 $11,423,282.97
19 Park In-lieu $86,857.98 $294.09 $0.00 $87,152.07
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 178,384.89 613.98 0.00 178,998.87
TOTAL CAPITAL PROJECTS FUNDS $984,408.67 $908.07 $0.00 $985,316.74
Attachment 6
City of Azusa
Cash Balances
For the Month ended December 31, 2017
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($167,180.23)$29,601.00 $750.00 ($138,329.23)
TOTAL DEBT SERVICE FUND ($167,180.23)$29,601.00 $750.00 ($138,329.23)
32 Water Fund $31,729,349.89 $1,612,529.28 $3,080,981.71 $30,260,897.46
33 Electric Fund 16,652,272.82 2,426,815.49 2,920,018.95 16,159,069.36
34 Sewer Fund 4,030,128.65 251,585.76 289,141.46 3,992,572.95
36 Refuse Fund 242,868.31 368,932.80 384,951.95 226,849.16
TOTAL ENTERPRISE FUNDS $52,654,619.67 $4,659,863.33 $6,675,094.07 $50,639,388.93
31 Consumer Services ($618,695.06)$341,814.63 $458,182.76 ($735,063.19)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (2,067,660.12)1,978,402.95 69,131.91 (158,389.08)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,574.79 69.65 0.00 20,644.44
48 IT Service Fund (601,325.25)842,551.00 112,904.20 128,321.55
TOTAL INTERNAL SERVICE FUNDS ($3,262,196.91)$3,162,838.23 $640,218.87 ($739,577.55)
50 Claim on Cash $7,049,670.46 $3,537.01 $25,861.70 $7,027,345.77
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $7,049,920.46 $3,537.01 $25,861.70 $7,027,595.77
80 Claim on Cash ($1,077.46)$0.00 $0.00 ($1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)0.00 0.00 (24,033,111.75)
87 Successor Agency-Wells Fargo Checking 1,517,772.29 0.00 0.00 1,517,772.29
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 20,604,297.60 0.00 0.00 20,604,297.60
TOTAL PRIVATE PURPOSE TRUST FUND $193,082.80 $0.00 $0.00 $193,082.80
City of Azusa
Cash Balances
For the Month ended January 31, 2018
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $992,150.65 $0.00 $0.00 $992,150.65
10 General Fund 5,184,598.40 6,642,401.47 4,027,597.21 7,799,402.66
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $6,181,783.30 $6,642,401.47 $4,027,597.21 $8,796,587.56
03 Measure R-LA County ($157,166.63)$40,944.10 $25,442.52 ($141,665.05)
04 Measure M 198,527.52 42,576.13 0.00 241,103.65
07 Rosedale Traffic Mitigation 512,812.42 0.00 0.00 512,812.42
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (319,704.89)154,884.08 175,692.17 (340,512.98)
13 Utility Mitigation 1,034,631.03 23,746.00 900.00 1,057,477.03
14 Highway 39 1,547,878.94 0.00 0.00 1,547,878.94
15 Proposition A 1,781,009.90 72,940.71 58,147.54 1,795,803.07
16 LACMTA 129.07 0.00 0.00 129.07
17 Proposition C 1,786,690.21 62,966.83 51,292.37 1,798,364.67
18 Community Development Block Grant 8,061.96 20,599.00 49,018.83 (20,357.87)
21 Senior Nutrition 93,008.68 18,633.54 35,423.07 76,219.15
24 Public Benefit Program 1,050,257.53 70,784.72 45,418.70 1,075,623.55
26 Supplemental Law Enforcement 374,026.24 23,073.38 965.17 396,134.45
27 Air Quality Improvement 146,897.33 336.75 2,149.36 145,084.72
28 Grants and Seizures 2,627,413.64 27,954.15 53,444.88 2,601,922.91
29 Fire Safety 285,555.58 408,795.00 817,588.00 (123,237.42)
37 Monrovia Nursery 80,803.54 64,763.97 62,141.43 83,426.08
39 AB939 Fee 375,661.51 16,542.86 39,779.72 352,424.65
41 Employee Benefits (3,211.02)89,792.00 7,773.83 78,807.15
TOTAL SPECIAL REVENUE FUNDS $11,423,282.97 $1,139,333.22 $1,425,177.59 $11,137,438.60
19 Park In-lieu $87,152.07 $5,250.00 $4,785.15 $87,616.92
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 178,998.87 0.00 0.00 178,998.87
TOTAL CAPITAL PROJECTS FUNDS $985,316.74 $5,250.00 $4,785.15 $985,781.59
Attachment 7
City of Azusa
Cash Balances
For the Month ended January 31, 2018
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority ($138,329.23)$29,601.00 $32,507.22 ($141,235.45)
TOTAL DEBT SERVICE FUND ($138,329.23)$29,601.00 $32,507.22 ($141,235.45)
32 Water Fund $30,260,897.46 $1,744,185.93 $829,233.11 $31,175,850.28
33 Electric Fund 16,159,069.36 2,442,029.37 2,156,081.50 16,445,017.23
34 Sewer Fund 3,992,572.95 301,330.31 266,115.94 4,027,787.32
36 Refuse Fund 226,849.16 460,602.98 389,176.80 298,275.34
TOTAL ENTERPRISE FUNDS $50,639,388.93 $4,948,148.59 $3,640,607.35 $51,946,930.17
31 Consumer Services ($735,063.19)$34,731.89 $441,576.85 ($1,141,908.15)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (158,389.08)76,610.68 291,341.25 (373,119.65)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,644.44 0.00 0.00 20,644.44
48 IT Service Fund 128,321.55 240.00 98,530.08 30,031.47
TOTAL INTERNAL SERVICE FUNDS ($739,577.55)$111,582.57 $831,448.18 ($1,459,443.16)
50 Claim on Cash $7,027,345.77 $542,347.03 $239,097.75 $7,330,595.05
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $7,027,595.77 $542,347.03 $239,097.75 $7,330,845.05
80 Claim on Cash ($1,077.46)$0.00 $0.00 ($1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (24,033,111.75)1,109,953.46 2,525,383.46 (25,448,541.75)
87 Successor Agency-Wells Fargo Checking 1,517,772.29 1,416,672.73 1,109,953.46 1,824,491.56
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 20,604,297.60 1,415,430.00 0.00 22,019,727.60
TOTAL PRIVATE PURPOSE TRUST FUND $193,082.80 $3,942,056.19 $3,635,336.92 $499,802.07
City of Azusa
Cash Position-Summary
For the Month ended January 31, 2018
GENERAL FUND $8,796,587.56
SPECIAL REVENUE FUNDS 11,137,438.60
CAPITAL PROJECTS FUNDS 985,781.59
DEBT SERVICE FUND (141,235.45)
ENTERPRISE FUNDS 51,946,930.17
INTERNAL SERVICE FUNDS (1,459,443.16)
AGENCY FUNDS 7,330,845.05
PRIVATE PURPOSE TRUST FUND 499,802.07
TOTAL UNRESTRICTED CASH $79,096,706.43
City of Azusa
Fund Balances-Summary
For the Month ended January 31, 2018
Fund Description Balance
06 Rosedale Contribution Fund $4,626,251.68
10 General fund 13,007,547.00
TOTAL GENERAL FUND $17,633,798.68
03 Measure R-LA County $3,371,577.26
04 Measure M 241,103.65
07 Rosedale Traffic Mitigation 512,812.65
08 CDBG 0.41
12 State Gasoline Tax (387,548.95)
13 Utility Mitigation 918,218.51
14 Highway 39 1,547,879.43
15 Proposition A 1,763,025.83
16 LACMTA 101.67
17 Proposition C 1,759,290.83
18 Community Development Block Gran (65,191.16)
21 Senior Nutrition 76,670.55
24 Public Benefit Program 1,034,171.40
26 Supplemental Law Enforcement 117,184.48
27 Air Quality Improvement 145,101.58
28 Grants and Seizures 1,156,369.41
29 Fire Safety (123,237.42)
37 Monrovia Nursery 61,426.29
39 AB939 Fee 351,262.69
41 Employee Benefits 80,202.10
TOTAL SPECIAL REVENUE FUNDS 12,560,421.21
19 Quimby-Park Maint $87,605.58
22 CIP/Park Planning (540.90)
49 Public Works Endowment 174,999.94
TOTAL CAPITAL PROJECTS FUNDS 262,064.62
71 Debt Services/2003 CIP COPS $375,746.53
TOTAL DEBT SERVICE FUND 375,746.53
City of Azusa
Fund Balances-Summary
For the Month ended January 31, 2018
Fund Description Balance
32 Water $57,498,146.21
33 Electric 47,078,909.79
34 Sewer 10,655,037.62
36 Refuse 507,414.83
TOTAL ENTERPRISE FUNDS 115,739,508.45
31 Consumer Services ($5,392,484.23)
42 Self Insurance (3,954,509.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,918.76
48 IT Services Fund (2,043,014.98)
TOTAL INTERNAL SERVICE FUNDS (11,069,058.88)
80 Cap Proj/MRG ($1,077.46)
81 LowMod Housing 15,294,204.47
87 Successor Agency (58,933,837.13)
88 SUCC AGENCY REC OB RETR 22,019,727.60
TOTAL PRIVATE PURPOSE TRUST FUND (21,620,982.52)
TOTAL $113,881,498.09
City of Azusa
Cash Balances
For the Month ended February 28, 2018
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
06 Rosedale Contribution fund $992,150.65 $0.00 $0.00 $992,150.65
10 General Fund 7,799,402.66 3,753,173.81 2,860,051.13 8,692,525.34
10 Petty Cash/Clerk 500.00 0.00 0.00 500.00
10 City Clerk- Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Library 400.00 0.00 0.00 400.00
10 Library-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/Public Works 400.00 0.00 0.00 400.00
10 Petty Cash/Human Resources 500.00 0.00 0.00 500.00
10 Petty Cash/Police 500.00 0.00 0.00 500.00
10 PD Cash on hand 200.00 0.00 0.00 200.00
10 Petty Cash/Police 200.00 0.00 0.00 200.00
10 Recreation-Cash on Hand 100.00 0.00 0.00 100.00
10 Petty Cash/ Senior Center 200.00 0.00 0.00 200.00
10 Petty Cash/Finance 400.00 0.00 0.00 400.00
10 West Wing-Cash on Hand 400.00 0.00 0.00 400.00
10 PW-Graffiti Reward Cash Out 1,000.00 0.00 0.00 1,000.00
10 Change Fund/Library 34.25 0.00 0.00 34.25
TOTAL GENERAL FUND $8,796,587.56 $3,753,173.81 $2,860,051.13 $9,689,710.24
03 Measure R-LA County (141,665.05)54,656.27 91,699.09 (178,707.87)
04 Measure M 241,103.65 56,768.15 0.00 297,871.80
07 Rosedale Traffic Mitigation 512,812.42 0.00 0.00 512,812.42
08 CDBG 0.41 0.00 0.00 0.41
12 State Gasoline Tax (340,512.98)82,348.08 102,268.11 (360,433.01)
13 Utility Mitigation 1,057,477.03 23,746.00 153,466.84 927,756.19
14 Highway 39 1,547,878.94 0.00 0.00 1,547,878.94
15 Proposition A 1,795,803.07 90,168.55 55,843.82 1,830,127.80
16 LACMTA 129.07 0.00 0.00 129.07
17 Proposition C 1,798,364.67 80,527.79 151,105.12 1,727,787.34
18 Community Development Block Grant (20,357.87)89,542.00 33,711.42 35,472.71
21 Senior Nutrition 76,219.15 34,498.95 11,822.92 98,895.18
24 Public Benefit Program 1,075,623.55 64,769.01 69,530.06 1,070,862.50
26 Supplemental Law Enforcement 396,134.45 9,557.09 1,930.34 403,761.20
27 Air Quality Improvement 145,084.72 309.40 2,149.36 143,244.76
28 Grants and Seizures 2,601,922.91 42,188.04 73,966.72 2,570,144.23
29 Fire Safety (123,237.42)408,795.00 408,347.43 (122,789.85)
37 Monrovia Nursery 83,426.08 75,426.06 44,651.80 114,200.34
39 AB939 Fee 352,424.65 17,378.30 6,426.68 363,376.27
41 Employee Benefits 78,807.15 89,792.00 7,773.83 160,825.32
TOTAL SPECIAL REVENUE FUNDS $11,137,438.60 $1,220,470.69 $1,214,693.54 $11,143,215.75
19 Park In-lieu $87,616.92 $150.00 $0.00 $87,766.92
22 Capital Projects 719,165.80 0.00 0.00 719,165.80
49 Public Works Endowment 178,998.87 0.00 0.00 178,998.87
TOTAL CAPITAL PROJECTS FUNDS $985,781.59 $150.00 $0.00 $985,931.59
Attachment 8
City of Azusa
Cash Balances
For the Month ended February 28, 2018
Beginning Total Total Ending
Fund Description Balance Debits Credits Balance
71 Public Financing Authority (141,235.45)29,601.00 0.00 (111,634.45)
TOTAL DEBT SERVICE FUND (141,235.45)29,601.00 0.00 (111,634.45)
32 Water Fund $31,175,850.28 $1,524,962.82 $875,420.62 $31,825,392.48
33 Electric Fund 16,445,017.23 2,114,712.84 1,649,291.65 16,910,438.42
34 Sewer Fund 4,027,787.32 212,337.40 142,588.87 4,097,535.85
36 Refuse Fund 298,275.34 334,127.15 386,198.24 246,204.25
TOTAL ENTERPRISE FUNDS $51,946,930.17 $4,186,140.21 $3,053,499.38 $53,079,571.00
31 Consumer Services (1,141,908.15)104,455.25 343,188.49 (1,380,641.39)
31 Petty Cash/Light & Water 1,000.00 0.00 0.00 1,000.00
31 Cash on Hand/ Light & Water 600.00 0.00 0.00 600.00
42 Self Insurance (373,119.65)107,394.38 174,318.23 (440,043.50)
43 Central Services 3,308.73 0.00 0.00 3,308.73
46 Equipment Replacement Fund 20,644.44 0.00 0.00 20,644.44
48 IT Service Fund 30,031.47 0.00 115,588.50 (85,557.03)
TOTAL INTERNAL SERVICE FUNDS (1,459,443.16)211,849.63 633,095.22 (1,880,688.75)
50 Claim on Cash $7,330,595.05 $670,436.35 $353,659.90 $7,647,371.50
50 Petty Cash/Employee Fund 250.00 0.00 0.00 250.00
TOTAL AGENCY FUNDS $7,330,845.05 $670,436.35 $353,659.90 $7,647,621.50
80 Claim on Cash (1,077.46)0.00 0.00 (1,077.46)
81 Claim on Cash 1,865,651.79 0.00 0.00 1,865,651.79
81 Claim on Cash-RDA 904,376.81 0.00 0.00 904,376.81
81 Claim on Cash (298,408.68)0.00 0.00 (298,408.68)
87 Claim on Cash 5,377,313.19 0.00 0.00 5,377,313.19
87 Claim on Cash-RDA (3,610,658.24)0.00 0.00 (3,610,658.24)
87 Claim on Cash-Successor Agency (25,448,541.75)2,546.03 2,546.03 (25,448,541.75)
87 Successor Agency-Wells Fargo Checking 1,824,491.56 0.00 2,546.03 1,821,945.53
87 Claim on Cash (3,623,225.38)0.00 0.00 (3,623,225.38)
87 Claim on Cash-RDA 736,049.38 0.00 0.00 736,049.38
87 Claim on Cash (1,286,384.25)0.00 0.00 (1,286,384.25)
87 Claim on Cash-RDA 1,955,548.92 0.00 0.00 1,955,548.92
87 Claim on Cash (214,275.74)0.00 0.00 (214,275.74)
87 Claim on Cash 215,165.15 0.00 0.00 215,165.15
87 Claim on Cash 69,366.04 0.00 0.00 69,366.04
87 Claim on Cash-RDA 14,683.13 0.00 0.00 14,683.13
88 Claim on Cash-Successor Agency 22,019,727.60 0.00 0.00 22,019,727.60
TOTAL PRIVATE PURPOSE TRUST FUND $499,802.07 $2,546.03 $5,092.06 $497,256.04
City of Azusa
Cash Position-Summary
For the Month ended February 28, 2018
GENERAL FUND $9,689,710.24
SPECIAL REVENUE FUNDS 11,143,215.75
CAPITAL PROJECTS FUNDS 985,931.59
DEBT SERVICE FUND (111,634.45)
ENTERPRISE FUNDS 53,079,571.00
INTERNAL SERVICE FUNDS (1,880,688.75)
AGENCY FUNDS 7,647,621.50
PRIVATE PURPOSE TRUST FUND 497,256.04
TOTAL UNRESTRICTED CASH $81,050,982.92
City of Azusa
Fund Balances-Summary
For the Month ended February 28, 2018
Fund Description Balance
06 Rosedale Contribution Fund $4,626,251.68
10 General fund 12,930,228.00
TOTAL GENERAL FUND $17,556,479.68
03 Measure R-LA County $3,353,398.26
04 Measure M 297,871.80
07 Rosedale Traffic Mitigation 512,812.65
08 CDBG 0.41
12 State Gasoline Tax (409,539.95)
13 Utility Mitigation 913,998.45
14 Highway 39 1,547,879.43
15 Proposition A 1,795,589.83
16 LACMTA 102.07
17 Proposition C 1,712,948.83
18 Community Development Block Gran (55,773.27)
21 Senior Nutrition 88,757.55
24 Public Benefit Program 1,062,656.24
26 Supplemental Law Enforcement 124,811.23
27 Air Quality Improvement 143,261.58
28 Grants and Seizures 1,169,045.87
29 Fire Safety (122,789.85)
37 Monrovia Nursery 89,841.77
39 AB939 Fee 360,720.76
41 Employee Benefits 162,220.27
TOTAL SPECIAL REVENUE FUNDS 12,747,813.93
19 Quimby-Park Maint $87,755.58
22 CIP/Park Planning (540.90)
49 Public Works Endowment 174,999.94
TOTAL CAPITAL PROJECTS FUNDS 262,214.62
71 Debt Services/2003 CIP COPS $405,347.53
TOTAL DEBT SERVICE FUND 405,347.53
City of Azusa
Fund Balances-Summary
For the Month ended February 28, 2018
Fund Description Balance
32 Water $58,227,634.21
33 Electric 47,823,658.79
34 Sewer 10,727,314.62
36 Refuse 509,191.77
TOTAL ENTERPRISE FUNDS 117,287,799.39
31 Consumer Services ($5,706,944.23)
42 Self Insurance (4,042,825.12)
43 Central Services 31,030.69
46 Equip. Replace. Fund 289,918.76
48 IT Services Fund (2,140,450.98)
TOTAL INTERNAL SERVICE FUNDS (11,569,270.88)
80 Cap Proj/MRG $0.00
81 LowMod Housing 15,293,127.01
87 Successor Agency (58,936,542.14)
88 SUCC AGENCY REC OB RETR 22,019,727.60
TOTAL PRIVATE PURPOSE TRUST FUND (21,623,687.53)
TOTAL $115,066,696.74