Fund Balance Report Reflecting Year-to-Date Receipts and Expenditures, including Prior-Year Obligations and Encumbrances
for the period ended June 30, 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 | 923,135 | 2,671,351 | 1,055,496 | 1,615,855 | 44,000 | 1,571,855 | (132,361) | (14,762) |
| 608 | Sewer Improve/Equip Replace | 313,748 | 214,012 | 527,760 | 200,000 | 727,760 | 234,695 | 493,065 | 92,654 | 400,411 | (34,695) | 86,663 |
| Total | 1,900,365 | 375,611 | 2,275,976 | 1,123,135 | 3,399,111 | 1,290,191 | 2,108,920 | 136,654 | 1,972,266 | (167,056) | 71,901 |
Current Revenue as Compared to Annual Estimates
for the period ended June 30, 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 | 923,135 | 49 | (960,065) | - | - | - | 1,883,200 | 923,135 | 49 |
| 608 | Sewer Improve/Equip Replace | - | - | - | - | 200,000 | 200,000 | 100 | 200,000 | 200,000 | 100 |
| Total | 1,883,200 | 923,135 | 49 | (960,065) | 200,000 | 200,000 | - | 2,083,200 | 1,123,135 | 54 |
Current Disbursements, including Encumbrances, as Compared to Annual Estimates
for the period ended June 30, 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 | 855,496 | 36 | 44,000 | 899,496 | 38 | 200,000 | 200,000 | 100 | 2,615,226 | 1,099,496 | 42 |
| 608 | Sewer Improve/Equip Replace | 409,012 | 234,695 | 57 | 92,654 | 327,349 | 80 | - | - | - | 409,012 | 327,349 | 80 |
| Total | 2,783,352 (1) | 1,090,191 | 39 | 136,654 | 1,226,845 | 44 | 200,000 | 200,000 | - | 3,024,238 | 1,426,845 | 47 |