Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
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
# 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
# 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
(1) Prior years encumbrances closed (money not spent) as of February 28, 2023: $ 376
CHART W1