Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended July 31, 2023
SANITARY SEWER 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 607 | Sanitary Sewer Disp. and Maint. | 1,586,617 | 161,599 | 1,748,216 | 1,100,896 | 2,849,112 | 1,308,942 | 1,540,170 | 33,979 | 1,506,191 | (208,046) | (80,426) |
| 608 | Sewer Improve/Equip Replace | 313,748 | 214,012 | 527,760 | 200,000 | 727,760 | 240,934 | 486,826 | 86,415 | 400,411 | (40,934) | 86,663 |
| Total | 1,900,365 | 375,611 | 2,275,976 | 1,300,896 | 3,576,872 | 1,549,876 | 2,026,996 | 120,394 | 1,906,602 | (248,980) | 6,237 |
Current Revenue as Compared to Annual Estimates
for the period ended July 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 607 | Sanitary Sewer Disp. and Maint. | 1,883,200 | 1,100,896 | 58 | (782,304) | - | - | - | 1,883,200 | 1,100,896 | 58 |
| 608 | Sewer Improve/Equip Replace | - | - | - | - | 200,000 | 200,000 | 100 | 200,000 | 200,000 | 100 |
| Total | 1,883,200 | 1,100,896 | 58 | (782,304) | 200,000 | 200,000 | - | 2,083,200 | 1,300,896 | 62 |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended July 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 607 | Sanitary Sewer Disp. and Maint. | 2,374,340 | 1,108,942 | 47 | 33,979 | 1,142,921 | 48 | 200,000 | 200,000 | 100 | 2,615,226 | 1,342,921 | 51 |
| 608 | Sewer Improve/Equip Replace | 409,012 | 240,934 | 59 | 86,415 | 327,349 | 80 | - | - | - | 409,012 | 327,349 | 80 |
| Total | 2,783,352 (1) | 1,349,876 | 48 | 120,394 | 1,470,270 | 53 | 200,000 | 200,000 | - | 3,024,238 | 1,670,270 | 55 |