Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended August 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 | 780,363 | 1,732,018 | 937,341 | 794,677 | 225,505 | 569,172 | (156,978) | (328,620) |
| 603 | Water Improve/Equip Replace | 392,154 | 64,332 | 456,486 | 205,370 | 661,856 | 220,825 | 441,031 | 45,583 | 395,448 | (15,455) | 3,294 |
| Total | 1,289,946 | 118,195 | 1,408,141 | 985,733 | 2,393,874 | 1,158,166 | 1,235,708 | 271,088 | 964,620 | (172,433) | (325,326) |
Current Revenue as Compared to Annual Estimates
for the period ended August 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 | 780,363 | 69 | (354,237) | - | - | - | 1,134,600 | 780,363 | 69 |
| 603 | Water Improve/Equip Replace | - | 5,370 | - | 5,370 | 200,000 | 200,000 | 100 | 200,000 | 205,370 | 103 |
| Total | 1,134,600 | 785,733 | 69 | (348,867) | 200,000 | 200,000 | - | 1,334,600 | 985,733 | 74 |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended August 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 | 737,341 | 54 | 225,505 | 962,846 | 70 | 200,000 | 200,000 | 100 | 1,657,869 | 1,162,846 | 70 |
| 603 | Water Improve/Equip Replace | 543,832 | 220,825 | 41 | 45,583 | 266,408 | 49 | - | - | - | 543,832 | 266,408 | 49 |
| Total | 1,914,945 (1) | 958,166 | 50 | 271,088 | 1,229,254 | 64 | 200,000 | 200,000 | - | 2,201,701 | 1,429,254 | 65 |
(1) Prior years encumbrances closed (money not spent) as of August 31, 2023:
$
819
CHART W1