April 2017

VILLAGE OF SAN LEANNA GENERAL FUND REPORT 4-1-2017 -- 4-30-2017 REVENUES: ACCOUNT 101 102 103 104 105 106 107 108 109 ...

0 downloads 113 Views 513KB Size
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