Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended February 28, 2023
for the period ended February 28, 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 | 162,342 | 1,113,997 | 413,937 | 700,060 | 350,893 | 349,167 | (251,595) | (548,625) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 38,723 | 623,133 | 25,609 | 597,524 | 166,647 | 205,370 |
| Total | 1,289,946 | 118,195 | 1,408,141 | 367,712 | 1,775,853 | 452,660 | 1,323,193 | 376,502 | 946,691 | (84,948) | (343,255) | |
Current Revenue as Compared to Annual Estimates
for the period ended February 28, 2023
for the period ended February 28, 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 | 162,342 | 14 | (972,258) | - | - | - | 1,134,600 | 162,342 | 14 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 167,712 | 15 | (966,888) | 200,000 | 200,000 | - | 1,334,600 | 367,712 | 28 | |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended February 28, 2023
for the period ended February 28, 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 | 213,937 | 16 | 350,893 | 564,830 | 41 | 200,000 | 200,000 | 100 | 1,657,869 | 764,830 | 46 |
| 603 | Water Improve/Equip Replace | 543,832 | 38,723 | 7 | 25,609 | 64,332 | 12 | - | - | - | 543,832 | 64,332 | 12 |
| Total | 1,914,945 (1) | 252,660 | 13 | 376,502 | 629,162 | 33 | 200,000 | 200,000 | - | 2,201,701 | 829,162 | 38 | |