Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances

for the period ended April 30, 2024

WATER FUNDS

On narrow screens, each table row is shown as a labeled card so all columns remain available.

# 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 760,907 84,374 845,281 462,201 1,307,482 555,402 752,080 379,112 372,968 (93,201) (387,939)
603 Water Improve/Equip Replace 135,248 270,582 405,830 175,000 580,830 8,667 572,163 313,360 258,803 166,333 123,555
Total 896,155 354,956 1,251,111 637,201 1,888,312 564,069 1,324,243 692,472 631,771 73,132 (264,384)

Current Revenue as Compared to Annual Estimates

for the period ended April 30, 2024

On narrow screens, each table row is shown as a labeled card so all columns remain available.

# 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,739,400 462,201 27 (1,277,199) - - - 1,739,400 462,201 27
603 Water Improve/Equip Replace - - - - 525,000 175,000 33 525,000 175,000 33
Total 1,739,400 462,201 27 (1,277,199) 525,000 175,000 - 2,264,400 637,201 28

Current Disbursements, including Encumbrances, as Compared to Annual Estimates

for the period ended April 30, 2024

On narrow screens, each table row is shown as a labeled card so all columns remain available.

# 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,493,450 380,402 25 379,112 759,514 51 525,000 175,000 33 2,111,522 934,514 44
603 Water Improve/Equip Replace 901,582 8,667 1 313,360 322,027 36 - - - 901,582 322,027 36
Total 2,395,032 (1) 389,069 16 692,472 1,081,541 45 525,000 175,000 - 3,013,104 1,256,541 42
(1) Prior years encumbrances closed (money not spent) as of April 30, 2024: $ 184
CHART W1