Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended September 30, 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 | 901,772 | 1,853,427 | 1,034,163 | 819,264 | 208,726 | 610,538 | (132,391) | (287,254) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 239,554 | 422,302 | 38,266 | 384,036 | (34,184) | (8,118) |
| Total | 1,289,946 | 118,195 | 1,408,141 | 1,107,142 | 2,515,283 | 1,273,717 | 1,241,566 | 246,992 | 994,574 | (166,575) | (295,372) |
Current Revenue as Compared to Annual Estimates
for the period ended September 30, 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 | 901,772 | 79 | (232,828) | - | - | - | 1,134,600 | 901,772 | 79 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 907,142 | 80 | (227,458) | 200,000 | 200,000 | - | 1,334,600 | 1,107,142 | 83 |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended September 30, 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 | 834,163 | 61 | 208,726 | 1,042,889 | 76 | 200,000 | 200,000 | 100 | 1,657,869 | 1,242,889 | 75 |
| 603 | Water Improve/Equip Replace | 543,832 | 239,554 | 44 | 38,266 | 277,820 | 51 | - | - | - | 543,832 | 277,820 | 51 |
| Total | 1,914,945 (1) | 1,073,717 | 56 | 246,992 | 1,320,709 | 69 | 200,000 | 200,000 | - | 2,201,701 | 1,520,709 | 69 |
(1) Prior years encumbrances closed (money not spent) as of September 30, 2023: $ 819
CHART W1