Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended January 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 | 85,482 | 1,037,137 | 331,839 | 705,298 | 379,399 | 325,899 | (246,357) | (571,893) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 200,000 | 656,486 | 10,775 | 645,711 | 53,557 | 592,154 | 189,225 | 200,000 |
| Total | 1,289,946 | 118,195 | 1,408,141 | 285,482 | 1,693,623 | 342,614 | 1,351,009 | 432,956 | 918,053 | (57,132) | (371,893) |
Current Revenue as Compared to Annual Estimates
for the period ended January 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 | 85,482 | 8 | (1,049,118) | - | - | - | 1,134,600 | 85,482 | 8 |
| 603 | Water Improve/Equip Replace | - | - | - | - | 200,000 | 200,000 | 100 | 200,000 | 200,000 | 100 |
| Total | 1,134,600 | 85,482 | 8 | (1,049,118) | 200,000 | 200,000 | - | 1,334,600 | 285,482 | 21 |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended January 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 | 131,839 | 10 | 379,399 | 511,238 | 37 | 200,000 | 200,000 | 100 | 1,657,869 | 711,238 | 43 |
| 603 | Water Improve/Equip Replace | 543,832 | 10,775 | 2 | 53,557 | 64,332 | 12 | - | - | - | 543,832 | 64,332 | 12 |
| Total | 1,914,945 (1) | 142,614 | 7 | 432,956 | 575,570 | 30 | 200,000 | 200,000 | - | 2,201,701 | 775,570 | 35 |
(1) Prior years encumbrances closed (money not spent) as of January 31, 2023: $ 376
CHART W1