Loading...
HomeMy WebLinkAboutJPBAgenda_2017_08_17AGENDA AND MEETING NOTICE JOINT POWERS BOARD CITY AND COUNTY OF BROOKINGS SECOND QUARTER MEETING Thursday, August 17th at 8:30 A.M. Brookings City & County Government Center 3rd Floor Executive Session Room 312 AGENDA 1) Call to order, determination of a quorum 2) Budget update 3) Building update a. Wireless Testing/Safety Week Update b. Frequency of Safety Drills 4) Other business a. Restroom(s) in Basement Next meeting date: November 16, 2017 User: Printed:08/10/2017 - 8:28AM KCatlin Detailed Trial Balance 01 to 08, 2017 General Ledger Period: Account Number Description Budget Beginning Balance Debit This Period Credit This Period Ending Balance 101 General Government REVENUE 101-420 City/County Administrative Bld 101-420-4-334-00 Grants 0.00 101-420-4-334-00 Totals: 0.00 0.00 0.00 0.00 0.00 101-420-4-441-08 52% County Reimbursement 176,000.00 AR Invoices 00022.01.2017 1/26/2017 AR 1 79 0.00 10,414.22 AR Invoices 00017.02.2017 2/23/2017 AR 2 84 0.00 11,401.10 AR Invoices 00016.03.2017 3/17/2017 AR 3 49 0.00 4,460.23 AR Adjustments 00014.03.2017 3/31/2017 AR 3 106 117.00 0.00 AR Invoices 00018.04.2017 4/24/2017 AR 4 69 0.00 10,306.47 AR Invoices 00021.05.2017 5/25/2017 AR 5 91 0.00 10,671.03 AR Invoices 00020.06.2017 6/28/2017 AR 6 100 0.00 12,300.77 AR Invoices 00019.07.2017 7/26/2017 AR 7 93 0.00 17,750.84 101-420-4-441-08 Totals:Var: 98,812.34 176,000.00 0.00 117.00 77,304.66 -77,187.66 101-420 REVENUE Totals: 176,000.00 117.00 77,304.66 0.00 -77,187.66 REVENUE Totals: 176,000.00 0.00 117.00 77,304.66 -77,187.66 EXPENSE 101-420 City/County Administrative Bld 101-420-5-101-20 Reimbursement for County Emp 8,000.00 BkCoTrea - Brookings County Finance Ck# 390171/25/2017 AP 1 67 125.94 0.00 BkCoTrea - Brookings County Finance Ck# 390171/25/2017 AP 1 67 499.68 0.00 BkCoTrea - Brookings County Finance Ck# 395584/12/2017 AP 4 40 3,732.01 0.00 BkCoTrea - Brookings County Finance Ck# 401807/12/2017 AP 7 31 3,275.30 0.00 BkCoTrea - Brookings County Finance Ck# 401807/12/2017 AP 7 31 37.34 0.00 BkCoTrea - Brookings County Finance Ck# 401807/12/2017 AP 7 31 28.43 0.00 101-420-5-101-20 Totals:Var: 301.30 8,000.00 0.00 7,698.70 0.00 7,698.70 GL - Detailed Trial Balance (08/10/2017 - 8:28 AM)Page 1 Account Number Description Budget Beginning Balance Debit This Period Credit This Period Ending Balance 101-420-5-421-00 Insurance 4,800.00 101-420-5-421-00 Totals:Var: 4,800.00 4,800.00 0.00 0.00 0.00 0.00 101-420-5-422-07 Contracted Services 103,500.00 JohnCont - JOHNSON CONTROLS Ck# 390411/25/2017 AP 1 67 1,579.90 0.00 Hillyard - Hillyard/Sioux Falls Ck# 391152/1/2017 AP 2 1 2,362.75 0.00 NessRyan - Ryan Ness Ck# 392402/22/2017 AP 2 67 2,050.00 0.00 CentBusP - Century Business Products Ck# 393333/8/2017 AP 3 23 300.00 0.00 CourPlum - COURTESY PLUMBING Ck# 393363/8/2017 AP 3 23 284.22 0.00 NessRyan - Ryan Ness Ck# 393603/8/2017 AP 3 23 225.00 0.00 SafeSecu - Safe-N-Secure Ck# 394213/22/2017 AP 3 62 359.40 0.00 NessRyan - Ryan Ness Ck# 395244/5/2017 AP 4 13 1,800.00 0.00 MikeCarp - Michael Hornback Ck# 395734/12/2017 AP 4 40 2,950.00 0.00 DAServic - Dustin Walraven Ck# 396884/26/2017 AP 4 87 3,000.00 0.00 EatoElec - Eaton Corporation Ck# 396424/26/2017 AP 4 87 2,139.00 0.00 NessRyan - Ryan Ness Ck# 397425/3/2017 AP 5 13 1,121.00 0.00 CourPlum - COURTESY PLUMBING Ck# 397785/10/2017 AP 5 30 86.70 0.00 JohnCont - JOHNSON CONTROLS Ck# 397905/10/2017 AP 5 30 480.00 0.00 SchiElev - Schindler Elevator Corporation Ck# 398085/10/2017 AP 5 30 1,439.52 0.00 BanKoeCo - Ban-Koe Systems Inc Ck# 398395/24/2017 AP 5 94 2,955.00 0.00 SafeSecu - Safe-N-Secure Ck# 399155/31/2017 AP 5 125 548.41 0.00 MidAlarm - Midwest Alarm Fire and Security SystemsCk# 399676/7/2017 AP 6 26 252.00 0.00 NessRyan - Ryan Ness Ck# 400386/21/2017 AP 6 76 1,101.00 0.00 JohnCont - JOHNSON CONTROLS Ck# 402047/12/2017 AP 7 31 21,253.74 0.00 NessRyan - Ryan Ness Ck# 402107/12/2017 AP 7 31 1,470.00 0.00 SafeSecu - Safe-N-Secure Ck# 402947/26/2017 AP 7 122 180.00 0.00 SafeSecu - Safe-N-Secure Ck# 402947/26/2017 AP 7 122 1,815.79 0.00 OtisElev - Otis Elevator Company Ck# 403418/2/2017 AP 8 13 4,800.00 0.00 101-420-5-422-07 Totals:Var: 48,946.57 103,500.00 0.00 54,553.43 0.00 54,553.43 101-420-5-425-05 Maintenance of Building 25,000.00 FastComp - Fastenal Company Ck# 391692/8/2017 AP 2 25 338.18 0.00 FastComp - Fastenal Company Ck# 392242/22/2017 AP 2 67 919.95 0.00 GrayEle2 - Graybar Electric Company Ck# 392923/1/2017 AP 3 1 205.68 0.00 101-420-5-425-05 Totals:Var: 23,536.19 25,000.00 0.00 1,463.81 0.00 1,463.81 101-420-5-426-03 Supplies 3,000.00 Walmart1 - WM SUPERCENTER #1538 Ck# 02/17/2017 AP 2 51 9.96 0.00 BkCoTrea - Brookings County Finance Ck# 395584/12/2017 AP 4 40 37.29 0.00 Amazon - Amazon Mktplace Pmts Ck# 06/14/2017 AP 6 56 29.32 0.00 OffiSyst - Office Peeps Ck# 06/14/2017 AP 6 56 62.49 0.00 GL - Detailed Trial Balance (08/10/2017 - 8:28 AM)Page 2 Account Number Description Budget Beginning Balance Debit This Period Credit This Period Ending Balance Walmart1 - WM SUPERCENTER #1538 Ck# 07/20/2017 AP 7 79 7.98 0.00 Walmart1 - WM SUPERCENTER #1538 Ck# 07/20/2017 AP 7 79 63.84 0.00 Walmart2 - WAL-MART #1538 Ck# 07/20/2017 AP 7 79 104.77 0.00 101-420-5-426-03 Totals:Var: 2,684.35 3,000.00 0.00 315.65 0.00 315.65 101-420-5-426-04 Cleaning Supplies 5,500.00 Hillyard - Hillyard/Sioux Falls Ck# 390361/25/2017 AP 1 67 812.04 0.00 DustServ - DUST-TEX SERVICE INC Ck# 03/20/2017 AP 3 54 110.21 0.00 Hillyard - Hillyard/Sioux Falls Ck# 395134/5/2017 AP 4 13 937.42 0.00 DustServ - DUST-TEX SERVICE INC Ck# 04/20/2017 AP 4 63 110.21 0.00 Hillyard - Hillyard/Sioux Falls Ck# 397325/3/2017 AP 5 13 24.74 0.00 Fremont - Fremont Industries Inc Ck# 06/14/2017 AP 6 56 1,757.24 0.00 Hillyard - Hillyard/Sioux Falls Ck# 401106/28/2017 AP 6 94 1,211.41 0.00 Hillyard - Hillyard/Sioux Falls Ck# 401106/28/2017 AP 6 94 46.12 0.00 101-420-5-426-04 Totals:Var: 490.61 5,500.00 0.00 5,009.39 0.00 5,009.39 101-420-5-428-01 Telephone 38,000.00 SwifComm - Swiftel Communications Ck# 392012/8/2017 AP 2 25 2,671.24 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 02/17/2017 AP 2 51 97.48 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 02/17/2017 AP 2 51 32.26 0.00 SwifComm - Swiftel Communications Ck# 393773/8/2017 AP 3 23 2,671.24 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 03/20/2017 AP 3 54 25.10 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 03/20/2017 AP 3 54 95.60 0.00 SwifComm - Swiftel Communications Ck# 395434/5/2017 AP 4 13 2,671.24 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 04/20/2017 AP 4 63 83.03 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 04/20/2017 AP 4 63 39.73 0.00 SwifComm - Swiftel Communications Ck# 398145/10/2017 AP 5 30 2,673.32 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 05/19/2017 AP 5 63 90.16 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 05/19/2017 AP 5 63 41.47 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 06/14/2017 AP 6 56 42.50 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 06/14/2017 AP 6 56 74.05 0.00 moved to correct account per Rose 6/30/2017 GL 6 151 2,606.10 0.00 SwifComm - Swiftel Communications Ck# 402227/12/2017 AP 7 31 2,520.10 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 07/20/2017 AP 7 79 42.16 0.00 CentLink - CENTURYLINK/SPEEDPAY Ck# 07/20/2017 AP 7 79 114.83 0.00 101-420-5-428-01 Totals:Var: 21,408.39 38,000.00 0.00 16,591.61 0.00 16,591.61 101-420-5-428-02 Electric & Water 65,000.00 BkUtilit - Brookings Municipal Utilities Ck# 391512/8/2017 AP 2 25 5,046.40 0.00 BkUtilit - Brookings Municipal Utilities Ck# 391512/8/2017 AP 2 25 7.00 0.00 BkUtilit - Brookings Municipal Utilities Ck# 393273/8/2017 AP 3 23 4,545.77 0.00 GL - Detailed Trial Balance (08/10/2017 - 8:28 AM)Page 3 Account Number Description Budget Beginning Balance Debit This Period Credit This Period Ending Balance BkUtilit - Brookings Municipal Utilities Ck# 393273/8/2017 AP 3 23 7.00 0.00 BkUtilit - Brookings Municipal Utilities Ck# 394884/5/2017 AP 4 13 4,887.35 0.00 BkUtilit - Brookings Municipal Utilities Ck# 394884/5/2017 AP 4 13 7.00 0.00 BkUtilit - Brookings Municipal Utilities Ck# 397705/10/2017 AP 5 30 4,609.33 0.00 BkUtilit - Brookings Municipal Utilities Ck# 397705/10/2017 AP 5 30 7.00 0.00 BkUtilit - Brookings Municipal Utilities Ck# 399406/7/2017 AP 6 26 4,087.99 0.00 BkUtilit - Brookings Municipal Utilities Ck# 399406/7/2017 AP 6 26 61.30 0.00 BkUtilit - Brookings Municipal Utilities Ck# 401817/12/2017 AP 7 31 5,704.98 0.00 BkUtilit - Brookings Municipal Utilities Ck# 401817/12/2017 AP 7 31 380.47 0.00 101-420-5-428-02 Totals:Var: 35,648.41 65,000.00 0.00 29,351.59 0.00 29,351.59 101-420-5-428-03 Heat 25,000.00 NWPS - NorthWestern Energy Ck# 390101/18/2017 AP 1 56 2,341.38 0.00 NWPS - NorthWestern Energy Ck# 392102/15/2017 AP 2 44 1,767.48 0.00 NWPS - NorthWestern Energy Ck# 392102/15/2017 AP 2 44 1,310.48 0.00 NWPS - NorthWestern Energy Ck# 393863/15/2017 AP 3 43 1,147.39 0.00 NWPS - NorthWestern Energy Ck# 393863/15/2017 AP 3 43 1,575.44 0.00 NWPS - NorthWestern Energy Ck# 393863/15/2017 AP 3 43 116.44 0.00 NWPS - NorthWestern Energy Ck# 395844/12/2017 AP 4 40 923.84 0.00 move to correct account per Gwen 4/21/2017 GL 4 82 0.00 1,310.48 move to correct account per Gwen 4/21/2017 GL 4 82 0.00 1,575.44 move to correct account per Gwen 4/21/2017 GL 4 82 0.00 116.44 NWPS - NorthWestern Energy Ck# 398215/17/2017 AP 5 55 575.77 0.00 NWPS - NorthWestern Energy Ck# 399946/14/2017 AP 6 48 452.08 0.00 NWPS - NorthWestern Energy Ck# 402337/19/2017 AP 7 71 307.03 0.00 101-420-5-428-03 Totals:Var: 17,485.03 25,000.00 0.00 10,517.33 3,002.36 7,514.97 101-420-5-428-05 Hauling Services 600.00 101-420-5-428-05 Totals:Var: 600.00 600.00 0.00 0.00 0.00 0.00 101-420-5-429-03 Cleaning Services 60,000.00 ISSFacil - ISS Facility Services Ck# 391182/1/2017 AP 2 1 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 392342/22/2017 AP 2 67 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 394653/29/2017 AP 3 92 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 396544/26/2017 AP 4 87 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 398665/24/2017 AP 5 94 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 401126/28/2017 AP 6 94 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 402727/26/2017 AP 7 122 4,150.00 0.00 ISSFacil - ISS Facility Services Ck# 402727/26/2017 AP 7 122 2,000.00 0.00 101-420-5-429-03 Totals:Var: 28,950.00 60,000.00 0.00 31,050.00 0.00 31,050.00 GL - Detailed Trial Balance (08/10/2017 - 8:28 AM)Page 4 Account Number Description Budget Beginning Balance Debit This Period Credit This Period Ending Balance 101-420-5-429-09 Miscellaneous 0.00 ConfTech - Conference Technologies Inc Ck# 04/20/2017 AP 4 63 824.26 0.00 101-420-5-429-09 Totals:Var: -824.26 0.00 0.00 824.26 0.00 824.26 101-420-5-911-00 Building 0.00 101-420-5-911-00 Totals: 0.00 0.00 0.00 0.00 0.00 101-420-5-920-00 Furniture & Equipment 0.00 101-420-5-920-00 Totals: 0.00 0.00 0.00 0.00 0.00 101-420 EXPENSE Totals: 338,400.00 157,375.77 3,002.36 0.00 154,373.41 EXPENSE Totals: 338,400.00 0.00 157,375.77 3,002.36 154,373.41 101 Totals:-162,400.00 80,307.02 157,492.77 0.00 77,185.75 Report Totals:-162,400.00 157,492.77 80,307.02 0.00 77,185.75 GL - Detailed Trial Balance (08/10/2017 - 8:28 AM)Page 5