Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended November 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 | 1,121,622 | 2,073,277 | 1,226,760 | 846,517 | 139,527 | 706,990 | (105,138) | (190,802) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 255,948 | 405,908 | 32,026 | 373,882 | (50,578) | (18,272) |
| Total | 1,289,946 | 118,195 | 1,408,141 | 1,326,992 | 2,735,133 | 1,482,708 | 1,252,425 | 171,553 | 1,080,872 | (155,716) | (209,074) | |
Current Revenue as Compared to Annual Estimates
for the period ended November 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 | 1,121,622 | 99 | (12,978) | - | - | - | 1,134,600 | 1,121,622 | 99 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 1,126,992 | 99 | (7,608) | 200,000 | 200,000 | - | 1,334,600 | 1,326,992 | 99 | |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended November 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 | 1,026,760 | 75 | 139,527 | 1,166,287 | 85 | 200,000 | 200,000 | 100 | 1,657,869 | 1,366,287 | 82 |
| 603 | Water Improve/Equip Replace | 543,832 | 255,948 | 47 | 32,026 | 287,974 | 53 | - | - | - | 543,832 | 287,974 | 53 |
| Total | 1,914,945 (1) | 1,282,708 | 67 | 171,553 | 1,454,261 | 76 | 200,000 | 200,000 | - | 2,201,701 | 1,654,261 | 75 | |