Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended October 31, 2023
WATER FUNDS
| # | Fund Name |
Beginning Unencumbered Balance |
Encumbrances | Beginning Cash Balance |
Y-T-D Total Receipts |
Available Funds |
Y-T-D Total Disbursements |
Ending Cash Balance |
Encumbrances | Ending Unencumbered Balance |
Change in Cash Balance |
Change in Unencumbered Balance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 602 | Waterworks | 897,792 | 53,863 | 951,655 | 1,023,743 | 1,975,398 | 1,106,517 | 868,881 | 205,853 | 663,028 | (82,774) | (234,764) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 249,422 | 412,434 | 38,267 | 374,167 | (44,052) | (17,987) |
| Total | 1,289,946 | 118,195 | 1,408,141 | 1,229,113 | 2,637,254 | 1,355,939 | 1,281,315 | 244,120 | 1,037,195 | (126,826) | (252,751) | |
Current Revenue as Compared to Annual Estimates
for the period ended October 31, 2023
| # | Fund Name |
Budgeted Outside Receipts |
YTD Outside Receipts |
% of Budget |
Net Difference ($) |
Budgeted Transfer Receipts |
YTD Transfer Receipts |
% of Budget |
Budgeted Total Receipts |
YTD Total Receipts |
% of Budget |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 602 | Waterworks | 1,134,600 | 1,023,743 | 90 | (110,857) | - | - | - | 1,134,600 | 1,023,743 | 90 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 1,029,113 | 91 | (105,487) | 200,000 | 200,000 | - | 1,334,600 | 1,229,113 | 92 | |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended October 31, 2023
| # | Fund Name |
Budgeted Outside Disbursements |
YTD Outside Disbursements |
% of Budget |
Encumbrances | YTD Outside Disbursements & Encumbrances |
% of Budget |
Budgeted Transfer Disbursements |
YTD Transfer Disbursements |
% of Budget |
Budgeted Total Disbursements |
YTD Total Disb., Enc. & Tfrs |
% of Budget |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 602 | Waterworks | 1,371,113 | 906,517 | 66 | 205,853 | 1,112,370 | 81 | 200,000 | 200,000 | 100 | 1,657,869 | 1,312,370 | 79 |
| 603 | Water Improve/Equip Replace | 543,832 | 249,422 | 46 | 38,267 | 287,689 | 53 | - | - | - | 543,832 | 287,689 | 53 |
| Total | 1,914,945 (1) | 1,155,939 | 60 | 244,120 | 1,400,059 | 73 | 200,000 | 200,000 | - | 2,201,701 | 1,600,059 | 73 | |