Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended June 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 | 541,158 | 1,492,813 | 743,208 | 749,605 | 271,023 | 478,582 | (202,050) | (419,210) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 142,313 | 519,543 | 28,211 | 491,332 | 63,057 | 99,178 |
| Total | 1,289,946 | 118,195 | 1,408,141 | 746,528 | 2,154,669 | 885,521 | 1,269,148 | 299,234 | 969,914 | (138,993) | (320,032) | |
Current Revenue as Compared to Annual Estimates
for the period ended June 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 | 541,158 | 48 | (593,442) | - | - | - | 1,134,600 | 541,158 | 48 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 546,528 | 48 | (588,072) | 200,000 | 200,000 | - | 1,334,600 | 746,528 | 56 | |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended June 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 | 543,208 | 40 | 271,023 | 814,231 | 59 | 200,000 | 200,000 | 100 | 1,657,869 | 1,014,231 | 61 |
| 603 | Water Improve/Equip Replace | 543,832 | 142,313 | 26 | 28,211 | 170,524 | 31 | - | - | - | 543,832 | 170,524 | 31 |
| Total | 1,914,945 (1) | 685,521 | 36 | 299,234 | 984,755 | 51 | 200,000 | 200,000 | - | 2,201,701 | 1,184,755 | 54 | |