|
|
2007 Monthly Reports
Finance Department
Cash Balance & Budget Reports
January
February March
April May
June July
October November
January
Cash Balance
|
January 31, 2007 |
|
|
|
|
|
|
|
|
|
|
FUND/ACCOUNT: |
Balance |
|
|
OTHER FUNDS: |
Balance |
|
General Fund |
$ 555,674.25 |
|
|
Tax Revolving Account |
$ 2,019.13 |
|
|
|
|
|
|
|
|
Payroll Account |
$ 107,273.29 |
|
|
City Service Revolving Account |
$ 1,050.90 |
|
|
|
|
|
|
|
|
Refuse Fund |
$ 17,164.11 |
|
|
Earned Income Tax Acct 2003 |
$ 79,899.01 |
|
|
|
|
|
|
|
|
Fringe Benefit Fund |
$ 24,711.79 |
|
|
Earned Income Tax Acct 2004 |
$ 120,260.48 |
|
|
|
|
|
|
|
|
Water Fund |
$ 97,672.35 |
|
|
Earned Income Tax Acct 2005 |
$ (11.37) |
|
|
|
|
|
|
|
|
Sewer Fund |
$ 460,996.10 |
|
|
Earned Income Tax Acct 2006 |
$ 3,128.75 |
|
|
|
|
|
|
|
|
Key 93 Account |
$ 251.99 |
|
|
POTW |
$ 4,960.46 |
|
|
|
|
|
|
|
|
Capital Fund |
$ 267,774.12 |
|
|
Sewer Project Phase I |
$ 11,871.87 |
|
|
|
|
|
|
|
|
Streets Fund |
$ 42,323.05 |
|
|
Sewer Project Phase II |
$ 28,979.40 |
|
|
|
|
|
|
|
|
Disbursement Revolving Acct |
$ 10,602.06 |
|
|
Walmart Escrow Acct |
$ 9,216.61 |
Budget Report
|
Budget for January 2007 |
|
|
|
GENERAL FUND |
|
|
|
Actual |
Budget |
Difference |
% Actual |
|
Revenue |
45,778.15 |
2,926,732.00 |
2,880,953.85 |
2% |
|
Expenses |
673,843.21 |
2,926,732.00 |
2,252,888.79 |
23% |
|
Balance |
(628,065.06) |
|
|
|
|
|
|
|
|
|
|
REFUSE FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
30,170.46 |
375,860.00 |
345,689.54 |
8% |
|
Expenses |
25,763.37 |
375,860.00 |
350,096.63 |
7% |
|
Balance |
4,407.09 |
|
|
|
|
|
|
|
|
|
|
FRINGE BENEFIT FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
531,267.01 |
1,407,233.00 |
875,965.99 |
38% |
|
Expenses |
546,352.01 |
1,407,233.00 |
860,880.99 |
39% |
|
Balance |
(15,085.00) |
|
|
|
|
|
|
|
|
|
|
WATER FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
79,599.22 |
956,269.00 |
876,669.78 |
8% |
|
Expenses |
79,721.05 |
956,269.00 |
876,547.95 |
8% |
|
Balance |
(121.83) |
|
|
|
|
|
|
|
|
|
|
SEWER FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
169,473.81 |
1,979,078.00 |
1,809,604.19 |
9% |
|
Expenses |
117,428.63 |
1,979,078.00 |
1,861,649.37 |
6% |
|
Balance |
52,045.18 |
|
|
|
|
|
|
|
|
|
|
CAPITAL FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
1,008.09 |
250,590.00 |
249,581.91 |
0% |
|
Expenses |
- |
250,590.00 |
250,590.00 |
0% |
|
Balance |
1,008.09 |
|
|
|
|
|
|
|
|
|
|
STREET FUND |
|
|
|
Actual |
Budget |
Difference |
|
|
Revenue |
41.40 |
171,950.00 |
171,908.60 |
0% |
|
Expenses |
11,167.34 |
|
