VILLAGE OF SAN LEANNA GENERAL FUND REPORT 4-1-2017 -- 4-30-2017 REVENUES: ACCOUNT
101 102 103 104 105 106 107 108 109
ACCOUNT NAME
PROPERTY TAXES FRANCHISE TAXES INTEREST BUILDING PERMITS CAPITAL METRO MISCELLANEOUS MUNICIPAL COURT PUBLIC SAFETY TRANSFER FROM RESERVE TOTALS:
CURRENT MONTH
YTD. BEG. YTD. END OF DIFFERENCE CURRENT MO CURRENT MO
$466.89 $61.28 $263.78 $440.00 $0.00 $0.00 $0.00 $0.00 $0.00
$135,807.91 $13,180.42 $924.30 $3,585.00 $56,159.00 $0.00 $0.00 $0.00 $0.00
$136,274.80 $13,241.70 $1,188.08 $4,025.00 $56,159.00 $0.00 $0.00 $0.00 $0.00
($6,274.80) $6,758.30 ($488.08) ($2,525.00) $55.00 $100.00 $0.00 $0.00 $15,501.00
$1,231.95
$209,656.63
$210,888.58
$13,126.42
BUDGET
$130,000.00 $20,000.00 $700.00 $1,500.00 $56,214.00 $100.00 $0.00 $0.00 $15,501.00 $0.00 $224,015.00
EXPENSES: ACCOUNT
ACCOUNT NAME
CURRENT MONTH
YTD. BEG. YTD. END OF DIFFERENCE CURRENT MO CURRENT MO
BUDGET
112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
ROAD MAINTENANCE CITY ADMINISTRATOR TML INSURANCE LEGAL TAXES MOW/TRIM/MAINTENANCE PUBLIC INFORMATION AUDIT SECURITY LIGHTS OFFICE EXPENSES ORG. MEMBERSHIP DUES APPRAISALS BUILDING INSPECTIONS MISCELLANEOUS ARBORIST ROAD IMPROVEMENTS COUNCIL EXPENSES PUBLIC AFFAIRS COMMUNITY CENTER ENGINEER FLOOD PREVENTION EMPLOYEE REIMBURSEMENT HEALTH DEPT. CONTRACT PUBLIC SAFETY ADVISOR SEVERANCE PACKAGE INFRASTRUCTURE REPAIRS TRANSFER TO WATER FUND
$0.00 $0.00 $526.00 $421.60 $623.03 $820.00 $0.00 $0.00 $274.66 $519.83 ($125.00) $0.00 $0.00 $12.00 $350.00 $0.00 $0.00 $0.00 $85.56 $0.00 $0.00 $111.34 $750.00 $0.00 $4,314.39 $0.00 $300.00 $0.00
$5,291.73 $11,189.96 $526.00 $364.00 $2,022.07 $4,279.98 $115.96 $0.00 $1,626.09 $3,093.83 $1,437.00 $344.82 $1,760.00 $238.09 $2,270.00 $5,576.85 $388.04 $309.44 $1,087.73 $0.00 $0.00 $282.57 $750.00 $240.84 $12,081.54 $4,820.41 $7,291.60 $0.00
$5,291.73 $11,189.96 $1,052.00 $785.60 $2,645.10 $5,099.98 $115.96 $0.00 $1,900.75 $3,613.66 $1,312.00 $344.82 $1,760.00 $250.09 $2,620.00 $5,576.85 $388.04 $309.44 $1,173.29 $0.00 $0.00 $393.91 $1,500.00 $240.84 $16,395.93 $4,820.41 $7,591.60 $0.00
$14,708.27 $18,810.04 $1,048.00 $714.40 $954.90 $18,900.02 $684.04 $4,500.00 $1,799.25 $886.34 ($312.00) $480.18 ($260.00) $249.91 $2,180.00 ($5,576.85) $211.96 $1,690.56 $2,666.71 $1,500.00 $20,000.00 $106.09 $0.00 $759.16 ($10,395.93) $28,929.59 $42,408.40 $0.00
$20,000.00 $30,000.00 $2,100.00 $1,500.00 $3,600.00 $24,000.00 $800.00 $4,500.00 $3,700.00 $4,500.00 $1,000.00 $825.00 $1,500.00 $500.00 $4,800.00 $0.00 $600.00 $2,000.00 $3,840.00 $1,500.00 $20,000.00 $500.00 $1,500.00 $1,000.00 $6,000.00 $33,750.00 $50,000.00 $0.00
TOTALS:
$8,983.41
$67,388.55
$76,371.96
$147,643.04
$224,015.00
VILLAGE OF SAN LEANNA WATER FUND REPORT 4-1-2017 -- 4-30-2017 REVENUES: ACCOUNT
201 202 203 204 205
ACCOUNT NAME
CURRENT MONTH
YTD. BEG. YTD. END OF DIFFERENCE CURRENT MO CURRENT MO
BUDGET
WATER BILLING WATER TAP FEES METER DEP/CONNECT FEES MISCELLANEOUS TRANSFER FROM RESERVE
$11,230.38 $0.00 $0.00 $0.00 $0.00
$59,140.05 $0.00 $500.00 $0.00 $0.00
$70,370.43 $0.00 $500.00 $0.00 $0.00
$54,629.57 $4,800.00 $500.00 $100.00 $22,498.50
$125,000.00 $4,800.00 $1,000.00 $100.00 $22,498.50
TOTALS:
$11,230.38
$59,640.05
$70,870.43
$82,528.07
$153,398.50
EXPENSES: ACCOUNT
210 211 212 213 214 215 216 217 218 219 220 221 222
ACCOUNT NAME
CURRENT MONTH
YTD. BEG. YTD. END OF DIFFERENCE CURRENT MO CURRENT MO
BUDGET
WATER OPERATOR DISTRICT FEES MAINTENANCE/REPAIR ELECTRICITY BOOKKEEPER BILLING SUPPLIES METER READER METER REFUNDS MISCELLANEOUS DEBT SERVICE CITY OF AUSTIN CONTRACT CITY OF AUSTIN WATER LOAN PREPAYMENT FUND
$1,923.00 $0.00 $55.00 $439.70 $0.00 $0.00 $100.00 ($200.00) $0.00 $0.00 $0.00 $99.84 $0.00
$11,538.00 $3,126.38 $3,068.19 $2,496.80 $3,817.13 $164.80 $592.35 $375.00 $0.00 $5,852.28 $2,500.00 $10,508.88 $0.00
$13,461.00 $3,126.38 $3,123.19 $2,936.50 $3,817.13 $164.80 $692.35 $175.00 $0.00 $5,852.28 $2,500.00 $10,608.72 $0.00
$9,615.00 $2,873.62 $26,876.81 $4,363.50 $6,182.87 $385.20 $507.65 $625.00 $100.00 $35,852.22 $0.00 $14,391.28 $5,168.00
$23,076.00 $6,000.00 $30,000.00 $7,300.00 $10,000.00 $550.00 $1,200.00 $800.00 $100.00 $41,704.50 $2,500.00 $25,000.00 $5,168.00
TOTALS:
$2,417.54
$44,039.81
$46,457.35
$106,941.15
$153,398.50
CHECKING ACCOUNT BALANCE: BEGINNING BALANCE TOTAL REVENUES TRANSFER-TEXPOOL TOTAL EXPENSES TRANSFER-TEXPOOL INTEREST RET-TEXPOOL
TEXPOOL BALANCE: $82,165.59 $12,462.33 $0.00 $11,400.95 $65,000.00 $263.78
$94,627.92 BEGINNING BALANCE DEPOSITS INTEREST TOTAL
$443,995.46 $65,000.00 $263.78 $509,259.24
$76,664.73 WITHDRAWALS
ENDING BALANCE
$17,963.19
CHECKBOOK BALANCE
$17,963.19 ENDING BALANCE
$0.00
$509,259.24
VILLAGE OF SAN LEANNA FINANCIAL REPORT 4-1-2017 -- 4-30-2017
FUND BALANCES
PREVIOUS MONTH BOND DEBT BALANCE
CURRENT MONTH
$405,000
$405,000
LOAN PAYMENT RESERVE
$45,000
$45,000
LOAN PREPAYMENT RESERVE (payable in August 2020) OPERATION/EMERGENCY RESERVE
$16,586
$16,586
$77,630
$77,630
$139,216
$139,216
RESTRICTED CAPITAL METRO
$14,040
$14,040
RESERVE FOR PROJECTS
$35,000
$35,000
$49,040
$49,040
$50,000
$50,000
CURRENT BUDGET RESERVE
$157,868
$158,930
TOTAL ALL RESERVED FUNDS
$396,124
$397,186
TOTAL TEXPOOL AND CHECKBOOK
$526,161
$527,222
LESS TOTAL RESERVED
$396,124
$397,186
UNALLOCATED AVAILABLE FUNDS
$130,037
$130,036
WATER FUND:
TOTAL WATER RESERVE ROAD FUND:
TOTAL ROAD RESERVE
GENERAL FUND CONTINGENCY