CSKE Town Accounting FY2027 reporting queries Started: 2026-08-10T15:37:55Z Database: cske_dev User: cske_owner Output: /Users/sherie/Downloads/CSKE-Town-Accounting-FY2027-Reporting-Queries-Output.txt Pager usage is off. Null display is "[NULL]". Border style is 2. Timing is on. BEGIN Time: 0.705 ms CSKE FY2027 TOWN ACCOUNTING REPORTING QUERIES Source: latest report in cske.v_town_acct_expense_control_detail Note: source-sign actual expenditures are negative; spent_positive reverses the sign. ====================================================================== (1) ALL DEPARTMENTS: BUDGET AND EXPENSE TOTALS ====================================================================== +-----------------+------------------------+---------------+-----------------+-----------------+------------------------------------+---------------------------------+----------------+--------------------+---------------+ | department_code | department_name | account_count | original_budget | adjusted_budget | current_month_expended_source_sign | ytd_actual_expended_source_sign | spent_positive | unexpended_balance | percent_spent | +-----------------+------------------------+---------------+-----------------+-----------------+------------------------------------+---------------------------------+----------------+--------------------+---------------+ | 122 | SELECT BOARD | 16 | 961131.00 | 961131.00 | 0.00 | 0.00 | 0.00 | 961131.00 | 0.00 | | 123 | BOS-TECHNOLOGY FUND | 1 | 15000.00 | 15000.00 | 0.00 | 0.00 | 0.00 | 15000.00 | 0.00 | | 131 | FINANCE COMMITTEE | 1 | 250000.00 | 250000.00 | 0.00 | 0.00 | 0.00 | 250000.00 | 0.00 | | 135 | ACCOUNTING | 9 | 310929.00 | 310929.00 | 0.00 | 0.00 | 0.00 | 310929.00 | 0.00 | | 141 | ASSESSORS | 14 | 289151.00 | 289151.00 | 0.00 | 0.00 | 0.00 | 289151.00 | 0.00 | | 145 | TREAS/COLL | 14 | 423007.00 | 423007.00 | -370.00 | -370.00 | 370.00 | 422637.00 | 0.09 | | 151 | LEGAL | 1 | 165000.00 | 165000.00 | 0.00 | 0.00 | 0.00 | 165000.00 | 0.00 | | 155 | INFORMATION TECHNOLOGY | 14 | 707252.00 | 707252.00 | 0.00 | 0.00 | 0.00 | 707252.00 | 0.00 | | 161 | TOWN CLERK | 10 | 183075.00 | 183075.00 | -125.00 | -125.00 | 125.00 | 182950.00 | 0.07 | | 162 | TOWN MEETING ELECTIONS | 8 | 55521.00 | 55521.00 | -2400.00 | -2400.00 | 2400.00 | 53121.00 | 4.32 | | 163 | REGISTRARS | 5 | 18980.00 | 18980.00 | 0.00 | 0.00 | 0.00 | 18980.00 | 0.00 | | 171 | CONSERVATION | 6 | 24737.00 | 24737.00 | -577.00 | -577.00 | 577.00 | 24160.00 | 2.33 | | 175 | PLANNING | 12 | 144396.00 | 144396.00 | 0.00 | 0.00 | 0.00 | 144396.00 | 0.00 | | 191 | FACILITIES | 13 | 1058940.00 | 1058940.00 | 0.00 | 0.00 | 0.00 | 1058940.00 | 0.00 | | 192 | TOWN PROPERTIES | 5 | 252700.00 | 252700.00 | 0.00 | 0.00 | 0.00 | 252700.00 | 0.00 | | 193 | INSURANCE | 5 | 1010000.00 | 1010000.00 | -7110.41 | -7110.41 | 7110.41 | 1002889.59 | 0.70 | | 194 | GROUP INSURANCE | 2 | 2058768.00 | 2058768.00 | -186317.98 | -186317.98 | 186317.98 | 1872450.02 | 9.05 | | 196 | TOWN REPORT | 1 | 2000.00 | 2000.00 | 0.00 | 0.00 | 0.00 | 2000.00 | 0.00 | | 197 | SURETY BONDS | 1 | 2000.00 | 2000.00 | 0.00 | 0.00 | 0.00 | 2000.00 | 0.00 | | 198 | PENSIONS | 1 | 3597616.00 | 3597616.00 | -3597616.00 | -3597616.00 | 3597616.00 | 0.00 | 100.00 | | 199 | TOWN HALL | 7 | 53750.00 | 53750.00 | 0.00 | 0.00 | 0.00 | 53750.00 | 0.00 | | 210 | POLICE | 31 | 3200908.00 | 3200908.00 | -17786.12 | -17786.12 | 17786.12 | 3183121.88 | 0.56 | | 220 | FIRE | 34 | 5385733.00 | 5385733.00 | -1108.04 | -1108.04 | 1108.04 | 5384624.96 | 0.02 | | 226 | DISPATCH | 15 | 352685.00 | 352685.00 | 0.00 | 0.00 | 0.00 | 352685.00 | 0.00 | | 240 | INSPECTORS | 12 | 197616.00 | 197616.00 | 0.00 | 0.00 | 0.00 | 197616.00 | 0.00 | | 244 | WTS & MEASURE | 6 | 11616.00 | 11616.00 | 0.00 | 0.00 | 0.00 | 11616.00 | 0.00 | | 291 | CIVIL DEFENSE | 2 | 12100.00 | 12100.00 | 0.00 | 0.00 | 0.00 | 12100.00 | 0.00 | | 292 | ANIMAL INSPECTOR | 9 | 42144.00 | 42144.00 | 0.00 | 0.00 | 0.00 | 42144.00 | 0.00 | | 294 | TREE WARDEN | 6 | 146327.00 | 146327.00 | 0.00 | 0.00 | 0.00 | 146327.00 | 0.00 | | 296 | INSECT CONTROL | 4 | 7150.00 | 7150.00 | 0.00 | 0.00 | 0.00 | 7150.00 | 0.00 | | 300 | HWRSD ASSESSMENT | 10 | 32170910.00 | 32170910.00 | -3957756.89 | -3957756.89 | 3957756.89 | 28213153.11 | 12.30 | | 301 | HWRSD DEBT | 1 | 1432613.00 | 1432613.00 | 0.00 | 0.00 | 0.00 | 1432613.00 | 0.00 | | 410 | ENGINEERING | 12 | 484133.00 | 484133.00 | -606.25 | -606.25 | 606.25 | 483526.75 | 0.13 | | 420 | HIGHWAY | 21 | 3402036.00 | 3402036.00 | 0.00 | 0.00 | 0.00 | 3402036.00 | 0.00 | | 430 | SOLID WASTE | 24 | 385210.00 | 385210.00 | -32535.64 | -32535.64 | 32535.64 | 352674.36 | 8.45 | | 440 | WASTE WATER | 26 | 1256263.00 | 1256263.00 | -349727.22 | -349727.22 | 349727.22 | 906535.78 | 27.84 | | 450 | WATER | 28 | 2385400.00 | 2385400.00 | -183252.67 | -183252.67 | 183252.67 | 2202147.33 | 7.68 | | 491 | CEMETERY | 10 | 73247.00 | 73247.00 | 0.00 | 0.00 | 0.00 | 73247.00 | 0.00 | | 512 | BOARD of HEALTH | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 0.00 | 30000.00 | 0.00 | | 541 | COA | 16 | 348099.00 | 348099.00 | -1098.90 | -1098.90 | 1098.90 | 347000.10 | 0.32 | | 543 | VETERANS | 10 | 185079.00 | 185079.00 | -3437.40 | -3437.40 | 3437.40 | 181641.60 | 1.86 | | 610 | LIBRARY | 20 | 897635.00 | 897635.00 | -27268.00 | -27268.00 | 27268.00 | 870367.00 | 3.04 | | 630 | RECREATION | 14 | 770426.00 | 770426.00 | 1185.00 | 1185.00 | -1185.00 | 771611.00 | -0.15 | | 690 | PUBLIC ACCESS | 6 | 214650.00 | 214650.00 | -1814.92 | -1814.92 | 1814.92 | 212835.08 | 0.85 | | 691 | HISTORICAL | 2 | 10200.00 | 10200.00 | 0.00 | 0.00 | 0.00 | 10200.00 | 0.00 | | 710 | LONG TERM DEBT | 3 | 1010001.00 | 1010001.00 | 0.00 | 0.00 | 0.00 | 1010001.00 | 0.00 | | 750 | INT TEMPORY DEBT | 2 | 11000.00 | 11000.00 | 0.00 | 0.00 | 0.00 | 11000.00 | 0.00 | | 751 | LONG TERM DEBT INT | 2 | 365228.00 | 365228.00 | 0.00 | 0.00 | 0.00 | 365228.00 | 0.00 | +-----------------+------------------------+---------------+-----------------+-----------------+------------------------------------+---------------------------------+----------------+--------------------+---------------+ (48 rows) Time: 34.234 ms ====================================================================== (2) EACH FUND TOTAL, FOLLOWED BY EVERY DEPARTMENT WHERE IT IS USED ====================================================================== +-----------+------------------------+----------------+-----------------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | fund_code | fund_name | row_type | department_code | department_name | account_count | original_budget | adjusted_budget | ytd_actual_expended_source_sign | spent_positive | unexpended_balance | +-----------+------------------------+----------------+-----------------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | 01 | GENERAL FUND | FUND TOTAL | [NULL] | [NULL] | 357 | 57018471.00 | 57018471.00 | -7800561.05 | 7800561.05 | 49217909.95 | | 01 | GENERAL FUND | DEPARTMENT USE | 122 | SELECT BOARD | 16 | 961131.00 | 961131.00 | 0.00 | 0.00 | 961131.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 123 | BOS-TECHNOLOGY FUND | 1 | 15000.00 | 15000.00 | 0.00 | 0.00 | 15000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 131 | FINANCE COMMITTEE | 1 | 250000.00 | 250000.00 | 0.00 | 0.00 | 250000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 135 | ACCOUNTING | 9 | 310929.00 | 310929.00 | 0.00 | 0.00 | 310929.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 141 | ASSESSORS | 14 | 289151.00 | 289151.00 | 0.00 | 0.00 | 289151.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 145 | TREAS/COLL | 14 | 423007.00 | 423007.00 | -370.00 | 370.00 | 422637.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 151 | LEGAL | 1 | 165000.00 | 165000.00 | 0.00 | 0.00 | 165000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 155 | INFORMATION TECHNOLOGY | 14 | 707252.00 | 707252.00 | 0.00 | 0.00 | 707252.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 161 | TOWN CLERK | 10 | 183075.00 | 183075.00 | -125.00 | 125.00 | 182950.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 162 | TOWN MEETING ELECTIONS | 8 | 55521.00 | 55521.00 | -2400.00 | 2400.00 | 53121.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 163 | REGISTRARS | 5 | 18980.00 | 18980.00 | 0.00 | 0.00 | 18980.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 171 | CONSERVATION | 5 | 18737.00 | 18737.00 | -577.00 | 577.00 | 18160.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 175 | PLANNING | 12 | 144396.00 | 144396.00 | 0.00 | 0.00 | 144396.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 191 | FACILITIES | 11 | 618940.00 | 618940.00 | 0.00 | 0.00 | 618940.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 192 | TOWN PROPERTIES | 5 | 252700.00 | 252700.00 | 0.00 | 0.00 | 252700.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 193 | INSURANCE | 5 | 1010000.00 | 1010000.00 | -7110.41 | 7110.41 | 1002889.59 | | 01 | GENERAL FUND | DEPARTMENT USE | 194 | GROUP INSURANCE | 2 | 2058768.00 | 2058768.00 | -186317.98 | 186317.98 | 1872450.02 | | 01 | GENERAL FUND | DEPARTMENT USE | 196 | TOWN REPORT | 1 | 2000.00 | 2000.00 | 0.00 | 0.00 | 2000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 197 | SURETY BONDS | 1 | 2000.00 | 2000.00 | 0.00 | 0.00 | 2000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 198 | PENSIONS | 1 | 3597616.00 | 3597616.00 | -3597616.00 | 3597616.00 | 0.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 199 | TOWN HALL | 7 | 53750.00 | 53750.00 | 0.00 | 0.00 | 53750.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 210 | POLICE | 30 | 3165908.00 | 3165908.00 | -17786.12 | 17786.12 | 3148121.88 | | 01 | GENERAL FUND | DEPARTMENT USE | 220 | FIRE | 28 | 3036113.00 | 3036113.00 | -375.00 | 375.00 | 3035738.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 226 | DISPATCH | 15 | 352685.00 | 352685.00 | 0.00 | 0.00 | 352685.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 240 | INSPECTORS | 12 | 197616.00 | 197616.00 | 0.00 | 0.00 | 197616.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 244 | WTS & MEASURE | 6 | 11616.00 | 11616.00 | 0.00 | 0.00 | 11616.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 291 | CIVIL DEFENSE | 2 | 12100.00 | 12100.00 | 0.00 | 0.00 | 12100.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 292 | ANIMAL INSPECTOR | 9 | 42144.00 | 42144.00 | 0.00 | 0.00 | 42144.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 294 | TREE WARDEN | 6 | 146327.00 | 146327.00 | 0.00 | 0.00 | 146327.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 296 | INSECT CONTROL | 4 | 7150.00 | 7150.00 | 0.00 | 0.00 | 7150.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 300 | HWRSD ASSESSMENT | 1 | 31662062.00 | 31662062.00 | -3957756.89 | 3957756.89 | 27704305.11 | | 01 | GENERAL FUND | DEPARTMENT USE | 301 | HWRSD DEBT | 1 | 1432613.00 | 1432613.00 | 0.00 | 0.00 | 1432613.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 410 | ENGINEERING | 12 | 484133.00 | 484133.00 | -606.25 | 606.25 | 483526.75 | | 01 | GENERAL FUND | DEPARTMENT USE | 420 | HIGHWAY | 17 | 1939036.00 | 1939036.00 | 0.00 | 0.00 | 1939036.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 491 | CEMETERY | 5 | 33247.00 | 33247.00 | 0.00 | 0.00 | 33247.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 512 | BOARD of HEALTH | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 30000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 541 | COA | 13 | 268099.00 | 268099.00 | 0.00 | 0.00 | 268099.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 543 | VETERANS | 10 | 185079.00 | 185079.00 | -3437.40 | 3437.40 | 181641.60 | | 01 | GENERAL FUND | DEPARTMENT USE | 610 | LIBRARY | 19 | 867635.00 | 867635.00 | -27268.00 | 27268.00 | 840367.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 630 | RECREATION | 11 | 588426.00 | 588426.00 | 1185.00 | -1185.00 | 589611.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 690 | PUBLIC ACCESS | 4 | 32000.00 | 32000.00 | 0.00 | 0.00 | 32000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 691 | HISTORICAL | 1 | 300.00 | 300.00 | 0.00 | 0.00 | 300.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 710 | LONG TERM DEBT | 3 | 1010001.00 | 1010001.00 | 0.00 | 0.00 | 1010001.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 750 | INT TEMPORY DEBT | 2 | 11000.00 | 11000.00 | 0.00 | 0.00 | 11000.00 | | 01 | GENERAL FUND | DEPARTMENT USE | 751 | LONG TERM DEBT INT | 2 | 365228.00 | 365228.00 | 0.00 | 0.00 | 365228.00 | | 03 | SPECIAL ARTICLES | FUND TOTAL | [NULL] | [NULL] | 18 | 3078348.00 | 3078348.00 | 0.00 | 0.00 | 3078348.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 210 | POLICE | 1 | 35000.00 | 35000.00 | 0.00 | 0.00 | 35000.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 220 | FIRE | 2 | 970000.00 | 970000.00 | 0.00 | 0.00 | 970000.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 300 | HWRSD ASSESSMENT | 8 | 458848.00 | 458848.00 | 0.00 | 0.00 | 458848.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 420 | HIGHWAY | 4 | 1463000.00 | 1463000.00 | 0.00 | 0.00 | 1463000.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 610 | LIBRARY | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 30000.00 | | 03 | SPECIAL ARTICLES | DEPARTMENT USE | 630 | RECREATION | 2 | 121500.00 | 121500.00 | 0.00 | 0.00 | 121500.00 | | 14 | REVOLVING-SNAP | FUND TOTAL | [NULL] | [NULL] | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 30000.00 | | 14 | REVOLVING-SNAP | DEPARTMENT USE | 541 | COA | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 30000.00 | | 16 | REVOLVING-CEMETERY | FUND TOTAL | [NULL] | [NULL] | 4 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | 16 | REVOLVING-CEMETERY | DEPARTMENT USE | 491 | CEMETERY | 4 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | 17 | REVOLVING-COA | FUND TOTAL | [NULL] | [NULL] | 2 | 50000.00 | 50000.00 | -1098.90 | 1098.90 | 48901.10 | | 17 | REVOLVING-COA | DEPARTMENT USE | 541 | COA | 2 | 50000.00 | 50000.00 | -1098.90 | 1098.90 | 48901.10 | | 18 | REVOLVING-LANDFILL | FUND TOTAL | [NULL] | [NULL] | 1 | 5000.00 | 5000.00 | 0.00 | 0.00 | 5000.00 | | 18 | REVOLVING-LANDFILL | DEPARTMENT USE | 430 | SOLID WASTE | 1 | 5000.00 | 5000.00 | 0.00 | 0.00 | 5000.00 | | 19 | REVOLVING-COMM GARDENS | FUND TOTAL | [NULL] | [NULL] | 1 | 6000.00 | 6000.00 | 0.00 | 0.00 | 6000.00 | | 19 | REVOLVING-COMM GARDENS | DEPARTMENT USE | 171 | CONSERVATION | 1 | 6000.00 | 6000.00 | 0.00 | 0.00 | 6000.00 | | 20 | RRA-AMBULANCE | FUND TOTAL | [NULL] | [NULL] | 4 | 1379620.00 | 1379620.00 | -733.04 | 733.04 | 1378886.96 | | 20 | RRA-AMBULANCE | DEPARTMENT USE | 220 | FIRE | 4 | 1379620.00 | 1379620.00 | -733.04 | 733.04 | 1378886.96 | | 21 | RRA-PUBLIC ACCESS | FUND TOTAL | [NULL] | [NULL] | 2 | 182650.00 | 182650.00 | -1814.92 | 1814.92 | 180835.08 | | 21 | RRA-PUBLIC ACCESS | DEPARTMENT USE | 690 | PUBLIC ACCESS | 2 | 182650.00 | 182650.00 | -1814.92 | 1814.92 | 180835.08 | | 22 | RRA-CEMETERY | FUND TOTAL | [NULL] | [NULL] | 1 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | 22 | RRA-CEMETERY | DEPARTMENT USE | 491 | CEMETERY | 1 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | 23 | COMMUNITY PRESERVATION | FUND TOTAL | [NULL] | [NULL] | 5 | 560400.00 | 560400.00 | 0.00 | 0.00 | 560400.00 | | 23 | COMMUNITY PRESERVATION | DEPARTMENT USE | 191 | FACILITIES | 2 | 440000.00 | 440000.00 | 0.00 | 0.00 | 440000.00 | | 23 | COMMUNITY PRESERVATION | DEPARTMENT USE | 300 | HWRSD ASSESSMENT | 1 | 50000.00 | 50000.00 | 0.00 | 0.00 | 50000.00 | | 23 | COMMUNITY PRESERVATION | DEPARTMENT USE | 630 | RECREATION | 1 | 60500.00 | 60500.00 | 0.00 | 0.00 | 60500.00 | | 23 | COMMUNITY PRESERVATION | DEPARTMENT USE | 691 | HISTORICAL | 1 | 9900.00 | 9900.00 | 0.00 | 0.00 | 9900.00 | | 60 | ENTERPRISE-WASTE WATER | FUND TOTAL | [NULL] | [NULL] | 26 | 1256263.00 | 1256263.00 | -349727.22 | 349727.22 | 906535.78 | | 60 | ENTERPRISE-WASTE WATER | DEPARTMENT USE | 440 | WASTE WATER | 26 | 1256263.00 | 1256263.00 | -349727.22 | 349727.22 | 906535.78 | | 61 | ENTERPRISE-WATER | FUND TOTAL | [NULL] | [NULL] | 28 | 2385400.00 | 2385400.00 | -183252.67 | 183252.67 | 2202147.33 | | 61 | ENTERPRISE-WATER | DEPARTMENT USE | 450 | WATER | 28 | 2385400.00 | 2385400.00 | -183252.67 | 183252.67 | 2202147.33 | | 66 | ENTERPRISE-SOLID WASTE | FUND TOTAL | [NULL] | [NULL] | 23 | 380210.00 | 380210.00 | -32535.64 | 32535.64 | 347674.36 | | 66 | ENTERPRISE-SOLID WASTE | DEPARTMENT USE | 430 | SOLID WASTE | 23 | 380210.00 | 380210.00 | -32535.64 | 32535.64 | 347674.36 | +-----------+------------------------+----------------+-----------------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ (80 rows) Time: 19.174 ms ====================================================================== (3) FUND TOTALS ONLY: BUDGET AND EXPENSE TOTALS ====================================================================== +-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+---------------+ | fund_code | fund_name | account_count | original_budget | adjusted_budget | ytd_actual_expended_source_sign | spent_positive | unexpended_balance | percent_spent | +-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+---------------+ | 01 | GENERAL FUND | 357 | 57018471.00 | 57018471.00 | -7800561.05 | 7800561.05 | 49217909.95 | 13.68 | | 03 | SPECIAL ARTICLES | 18 | 3078348.00 | 3078348.00 | 0.00 | 0.00 | 3078348.00 | 0.00 | | 14 | REVOLVING-SNAP | 1 | 30000.00 | 30000.00 | 0.00 | 0.00 | 30000.00 | 0.00 | | 16 | REVOLVING-CEMETERY | 4 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | 0.00 | | 17 | REVOLVING-COA | 2 | 50000.00 | 50000.00 | -1098.90 | 1098.90 | 48901.10 | 2.20 | | 18 | REVOLVING-LANDFILL | 1 | 5000.00 | 5000.00 | 0.00 | 0.00 | 5000.00 | 0.00 | | 19 | REVOLVING-COMM GARDENS | 1 | 6000.00 | 6000.00 | 0.00 | 0.00 | 6000.00 | 0.00 | | 20 | RRA-AMBULANCE | 4 | 1379620.00 | 1379620.00 | -733.04 | 733.04 | 1378886.96 | 0.05 | | 21 | RRA-PUBLIC ACCESS | 2 | 182650.00 | 182650.00 | -1814.92 | 1814.92 | 180835.08 | 0.99 | | 22 | RRA-CEMETERY | 1 | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | 0.00 | | 23 | COMMUNITY PRESERVATION | 5 | 560400.00 | 560400.00 | 0.00 | 0.00 | 560400.00 | 0.00 | | 60 | ENTERPRISE-WASTE WATER | 26 | 1256263.00 | 1256263.00 | -349727.22 | 349727.22 | 906535.78 | 27.84 | | 61 | ENTERPRISE-WATER | 28 | 2385400.00 | 2385400.00 | -183252.67 | 183252.67 | 2202147.33 | 7.68 | | 66 | ENTERPRISE-SOLID WASTE | 23 | 380210.00 | 380210.00 | -32535.64 | 32535.64 | 347674.36 | 8.56 | +-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+---------------+ (14 rows) Time: 9.792 ms ====================================================================== (4A) REQUESTED AREAS: SUMMARY BY AREA AND FUND ====================================================================== +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | requested_area | match_basis | fund_code | fund_name | account_count | original_budget | adjusted_budget | ytd_actual_expended_source_sign | spent_positive | unexpended_balance | +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 14 | 707252.00 | 707252.00 | 0.00 | 0.00 | 707252.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 01 | GENERAL FUND | 4 | 32000.00 | 32000.00 | 0.00 | 0.00 | 32000.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 21 | RRA-PUBLIC ACCESS | 2 | 182650.00 | 182650.00 | -1814.92 | 1814.92 | 180835.08 | | Memorial School | Exact MEMORIAL match in source account description | 01 | GENERAL FUND | 1 | 60000.00 | 60000.00 | 0.00 | 0.00 | 60000.00 | | Memorial School | Exact MEMORIAL match in source account description | 23 | COMMUNITY PRESERVATION | 2 | 440000.00 | 440000.00 | 0.00 | 0.00 | 440000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 7 | 53750.00 | 53750.00 | 0.00 | 0.00 | 53750.00 | +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+---------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ (6 rows) Time: 10.030 ms ====================================================================== (4B) REQUESTED AREAS: ACCOUNT-LEVEL BUDGETS, FUNDS, AND EXPENSES ====================================================================== +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+-----------------+------------------------+--------------------+------------------------------------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | requested_area | match_basis | fund_code | fund_name | department_code | department_name | account_code | account_description | original_budget | adjusted_budget | ytd_actual_expended_source_sign | spent_positive | unexpended_balance | +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+-----------------+------------------------+--------------------+------------------------------------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5110-000000 | IT-REGULAR SALARIES | 300945.00 | 300945.00 | 0.00 | 0.00 | 300945.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5148-000000 | IT - LONGEVITY/INCENTIVE | 3500.00 | 3500.00 | 0.00 | 0.00 | 3500.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5210-000000 | IT-ELECTRICITY | 10000.00 | 10000.00 | 0.00 | 0.00 | 10000.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5215-000000 | IT-HEATING FUEL | 3100.00 | 3100.00 | 0.00 | 0.00 | 3100.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5245-000000 | IT-EQUIPMENT MAINT. CONTRACT | 205900.00 | 205900.00 | 0.00 | 0.00 | 205900.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5246-000000 | IT-SERVICE HOST FEES | 48943.00 | 48943.00 | 0.00 | 0.00 | 48943.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5247-000000 | IT-GIS SYSTEM/MAINTENANCE | 21516.00 | 21516.00 | 0.00 | 0.00 | 21516.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5248-000000 | IT-EQUIPMENT/MATERIALS | 60000.00 | 60000.00 | 0.00 | 0.00 | 60000.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5310-000000 | IT-CONTRACT SERVICES | 14448.00 | 14448.00 | 0.00 | 0.00 | 14448.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5340-000000 | IT-TELECOMMUNICATIONS | 25600.00 | 25600.00 | 0.00 | 0.00 | 25600.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5580-000000 | IT-OTHER SUPPLIES | 9000.00 | 9000.00 | 0.00 | 0.00 | 9000.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5705-000000 | IT-TRAVEL/AUTO ALLOWANCE | 150.00 | 150.00 | 0.00 | 0.00 | 150.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5730-000000 | IT-DUES/MEMBERSHIPS | 2000.00 | 2000.00 | 0.00 | 0.00 | 2000.00 | | Current IT Department | Source department 155 INFORMATION TECHNOLOGY | 01 | GENERAL FUND | 155 | INFORMATION TECHNOLOGY | 01-155-5735-000000 | IT-TRAINING/CONFERENCES | 2150.00 | 2150.00 | 0.00 | 0.00 | 2150.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 01 | GENERAL FUND | 690 | PUBLIC ACCESS | 01-690-5110-000000 | PUBACC-REGULAR SALARIES | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 01 | GENERAL FUND | 690 | PUBLIC ACCESS | 01-690-5148-000000 | PUBACC-LONGEVITY/INCENTIVE | 1000.00 | 1000.00 | 0.00 | 0.00 | 1000.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 01 | GENERAL FUND | 690 | PUBLIC ACCESS | 01-690-5300-000000 | PUBACC-PROF SERVICES | 5000.00 | 5000.00 | 0.00 | 0.00 | 5000.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 01 | GENERAL FUND | 690 | PUBLIC ACCESS | 01-690-5850-000000 | PUBACC-VEHICLE/DEPT EQUIP | 6000.00 | 6000.00 | 0.00 | 0.00 | 6000.00 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 21 | RRA-PUBLIC ACCESS | 690 | PUBLIC ACCESS | 21-690-5110-210100 | PUBACC-APPROPRIATED-SALARIES | 102475.00 | 102475.00 | -1814.92 | 1814.92 | 100660.08 | | Little Red Schoolhouse / Public Access | User-context mapping to source department 690 PUBLIC ACCESS | 21 | RRA-PUBLIC ACCESS | 690 | PUBLIC ACCESS | 21-690-5200-210200 | PUBACC-APPROPRIATED-EXPENSES | 80175.00 | 80175.00 | 0.00 | 0.00 | 80175.00 | | Memorial School | Exact MEMORIAL match in source account description | 01 | GENERAL FUND | 191 | FACILITIES | 01-191-5244-000000 | FAC-MEMORIAL SCHOOL MAINTENANCE | 60000.00 | 60000.00 | 0.00 | 0.00 | 60000.00 | | Memorial School | Exact MEMORIAL match in source account description | 23 | COMMUNITY PRESERVATION | 191 | FACILITIES | 23-191-5580-191271 | FY27 (H) Memorial Sch Heating Upgrades & | 100000.00 | 100000.00 | 0.00 | 0.00 | 100000.00 | | Memorial School | Exact MEMORIAL match in source account description | 23 | COMMUNITY PRESERVATION | 191 | FACILITIES | 23-191-5580-191272 | FY27 (UFB) Memorial Sch Heating Upgrade | 340000.00 | 340000.00 | 0.00 | 0.00 | 340000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5210-000000 | TOWNHALL-ELECTRICITY | 20000.00 | 20000.00 | 0.00 | 0.00 | 20000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5215-000000 | TOWNHALL-HEATING FUEL | 15000.00 | 15000.00 | 0.00 | 0.00 | 15000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5241-000000 | TOWNHALL-EQUIPMENT REPAIRS/SERVI | 1000.00 | 1000.00 | 0.00 | 0.00 | 1000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5271-000000 | TOWNHALL-EQUIPMENT RENTAL | 7000.00 | 7000.00 | 0.00 | 0.00 | 7000.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5340-000000 | TOWNHALL-TELECOMMUNICATIONS | 6500.00 | 6500.00 | 0.00 | 0.00 | 6500.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5420-000000 | TOWNHALL-OFFICE SUPPLIES | 3250.00 | 3250.00 | 0.00 | 0.00 | 3250.00 | | Town Hall | Source department 199 TOWN HALL | 01 | GENERAL FUND | 199 | TOWN HALL | 01-199-5580-000000 | TOWNHALL-OTHER SUPPLIES | 1000.00 | 1000.00 | 0.00 | 0.00 | 1000.00 | +----------------------------------------+-------------------------------------------------------------+-----------+------------------------+-----------------+------------------------+--------------------+------------------------------------------+-----------------+-----------------+---------------------------------+----------------+--------------------+ (30 rows) Time: 6.833 ms ROLLBACK Time: 0.145 ms READ-ONLY REPORTING QUERIES COMPLETE OVERALL PASS: read-only reporting queries completed. Finished: 2026-08-10T15:38:03Z Share this file: /Users/sherie/Downloads/CSKE-Town-Accounting-FY2027-Reporting-Queries-Output.txt