The URL can be used to link to this page

Home My WebLink About322325 02/27/2018 CITY OF CARMEL, INDIANA VENDOR: 071300 'i ONE CIVIC SQUARE C. L. COONROD& COMPANY CHECK AMOUNT: $****35,364.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 322325 SUITE 225 CHECK DATE: 02/27118 *ox INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150-013118 8,645.00 CAFR-RELATED ACCOUNTI 1160 4341999 101207 1150-16CAFR 840.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160-013118 25,879.00 PROFESSIONAL ACCOUNTI VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# 071300 IN SUM OF$ C. L. COONROD&COMPANY CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE An invoice or bill to be properly itemized must show:kind of service,where performed,dates service SUITE 225 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $9,485.00 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# Mayor's Office Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT.# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101207 1150-013118 43-419.99 $8,645.00 1 hereby certify that the attached invoice(s),or 2/9/18 1150-013118 $8,645.00 1160 101 1160 101 101207 1150- 43-419.99 $840.00 bill(s)is(are)true and correct and that the 2/9/18 1150- $840.00 013118:16CAFR materials or services itemized thereon for 013118:16CAFR 1160 101 1160 101 which charge is made were ordered and received except Monday, February 19,2018 oA� Kibbe, Sharon Executive Office Manager hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1150-013118 P.O.101207 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 February 9,2018 Professional services through January 31,2018,in connection with: 2017 CAFR: AR-income tax $ 717 AR-ambulance 788 AR-property tax 245 Bond premium,deferred rev 2,213 Budgetary statements 72 Compensated absences 368 Introductory section,CAFR prep 529 New bond issues 1,496 Statistical section 1,559 Trust cash 514 Subtotal 8,501 Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017 ($70,040). 8,501 Work outside scope- address out-of-balance conditions and certain unrecorded cash transactions on client trial balance 144 Total amount of this invoice. 8,645 Previous balance. 14,178 Payment received. - Total amount due. $ 22,823 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 9,2018 Professional services through January 31,2018,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. irforming Seryi Service Date Services Provided Hourly Rate Total Lilly 1/16/2018 AR-income tax 175 1.55 271 Lilly 1/25/2018 AR-income tax 175 2.55 446 AR-income tax Total 717 Lilly 1/25/2018 AR-property tax 175 1.40 245 AR-property tax Total 245 Lilly 1/26/2018 AR-ambulance 175 1.70 298 Lilly 1/30/2018 AR-ambulance 175 2.80 490 AR-ambulance Total 788 Lilly 01/26/2018 Bond premium,deferred rev 175 2.30 403 Lilly 01/17/2018 Bond premium,deferred rev 175 2.60 455 Coonrod 01/19/2018 Bond premium,deferred rev 240 0.65 156 Lilly 01/27/2018 Bond premium,deferred rev 175 6.85 1,199 Bond premium,deferred rev Total 2,213 Coonrod 1/16/2018 Budgetary statements 240 0.30 72 Budgetary statements Total 72 Lilly 1/16/2018 Compensated absences 175 2.10 368 Compensated absences Total 368 Lilly 1/25/2018 Introductory section,CAFR prep 175 2.75 481 Coonrod 1/25/2018 Introductory section,CAFR prep 240 0.20 48 Introductory section,CAFR prep Total 529 Lilly 1/23/2018 New bond issues 175 2.80 490 Lilly 1/26/2018 New bond issues 175 5.75 1,006 New bond issues Total 1,496 Lilly 1/23/2018 Statistical section 175 1.75 306 Lilly 1/24/2018 Statistical section 175 0.70 123 Lilly 1/26/2018 Statistical section 175 2.25 394 Lilly 1/29/2018 Statistical section 175 3.10 543 Lilly 1/30/2018 Statistical section 175 1.10 193 Statistical section Total 1,559 Coonrod 01/26/2018 Trust cash 240 0.40 96 Coonrod 01/17/2018 Trust cash 240 0.10 24 Lilly 01/27/2018 Trust cash 175 2.25 394 Trust cash Total 514 Coonrod 1/17/2018 Work Outside Scope 240 0.60 144 Work Outside Scope Total 144 Publishing&printing 0 Mileage 0 TOTAL Invoice amount 8,645 INVOICE 1150-013118:16CAFR P.O.101207 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 22i Indianapolis,Indiana 46240 February 9,2018 Professional services through January 31,2018,in connection with: 2016 CAFR: Within scope $ - Subtotal - Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter for 2016,dated January 17,2017($68,000). - Work outside scope-Respond to GFOA question re utility statements-draft response to GFOA.Research GFOA question on Utility statements,consult Utility accountants. 840 Total amount of this invoice. 840 Previous balance. 11,753 Payment received. (11,753) Total amount due. $ 840 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 9,2018 Professional services through January 31,2018, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. trforming Servi Service Date Services Provided Hourly Rate Total Coonrod 1/17/2018 Work Outside Scope 240 2.45 588 Coonrod 1/18/2018 Work Outside Scope 240 1.05 252 Work Outside Scope Total 840 Publishing&printing 0 Mileage 0 TOTAL invoice amount 840 VOUCHER NO. WARRANT NO. Prescribed by state Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# 071300. IN SUM OF$ CITY OF CARMEL C.L. COONROD&COMPANY 3850 PRIORITY WAY SOUTH DRIVE An.invoice or bill to be properly itemized must show:kind of service,where performed,dates service SUITE 225 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit;etc. INDIANAPOLIS, IN 46240 Payee $25,879.00 . Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101208 1160-013118 43-403.03 $25,879.00 1 hereby certify that the attached invoice(s),or 2/14/18 1160-013118 $25,879.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Monday, February 19,2018 Kibbe, Sharon Executive Office Manager hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1160-013118 P.O.101208 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 February 14,2018 Professional services through January 31,2018,in connection with: Accounting System: Follow-ups with SBOA regarding fund structure,setting up bond $ 1,392 trust accounts Annexation: Review fiscal plan after annexation,review revenue analysis,census 3,443 alternatives Annual Report: Annual report follow-up,consultation regarding RDA annual report 1,234 Appeal Review DLGF response,consider response to appeal request 600 Audit Respond to comments regarding audit findings 492 Bond/Lease Respond to questions regarding debt payment amounts 1,152 Budget Consultation F&B tax follow up,plan updates,shortfall appeal follow-up,archiving files, 5,410 1782 Notice response Budget Hearing Review Preliminary budget order,status of 1782 Notice and appeal 156 LOIT Analysis Review prospects for special distribution 108 Plan Review for 2018 year opening,update and review fiscal plan 7,944 Project Review DOR agreement,board meeting,month-end accounting items, 3,948 F&B tax,prepare DOR report,TIF follow-up Out of pocket expense. - Total amount of this invoice. 25,879 Previous balance. 42,480 Payment received. (42,480) Total amount due. $ 25,879 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 14,2018 Professional services through January 31,2018,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performing Service Service Date Services Provided Hourly Rate Total Coonrod 01/07/2018 Accounting System 240 2.55 612 Roeger 01/08/2018 Accounting System 220 0.60 132 Coonrod 01/09/2018 Accounting System 240 1.15 276 Coonrod 01/10/2018 Accounting System 240 1.10 264 Coonrod 01/11/2018 Accounting System 240 0.30 72 Coonrod 01/19/2018 Accounting System 240 0.15 36 Accounting System Total 1,392 Roeger 01/02/2018 Annexation 220 4.25 935 Roeger 01/03/2018 Annexation 220 1.90 418 Roeger 01/03/2018 Annexation 220 0.30 66 Coonrod 01/03/2018 Annexation 240 1.30 312 Coonrod 01/23/2018 Annexation 240 0.95 228 Roeger 01/24/2018 Annexation 220 4.25 935 Coonrod 01/24/2018 Annexation 240 0.25 60 Roeger 01/25/2018 Annexation 220 0.15 33 Coonrod 01/30/2018 Annexation 240 0.60 144 Coonrod 01/31/2018 Annexation 240 1.30 312 Annexation Total 3,443 Roeger 01/18/2018 Annual Report 220 5.50 1,210 Coonrod 01/22/2018 Annual Report 240 0.10 24 Annual Report Total 1,234 Coonrod 01/18/2018 Appeal 240 0.25 60 Coonrod 01/18/2018 Appeal 240 0.80 192 Coonrod 01/19/2018 Appeal 240 1.25 300 Coonrod 01/25/2018 Appeal 240 0.20 48 Appeal Total 600 Coonrod 01/08/2018 Audit 240 2.05 492 Audit Total 492 Coonrod 01/05/2018 Bond/Lease 240 0.60 144 Coonrod 01/05/2018 Bond/Lease 240 1.65 396 Coonrod 01/24/2018 Bond/Lease 240 2.55 612 Bond/Lease Total 1,152 Lilly 01/04/2018 Budget Consultation 175 1.75 306 Coonrod 01/10/2018 Budget Consultation 240 0.95 228 Roeger 01/11/2018 Budget Consultation 220 0.20 44 Lilly 01/11/2018 Budget Consultation 175 1.75 306 Roeger 01/15/2018 Budget Consultation 220 0.10 22 Roeger 01/16/2018 Budget Consultation 220 0.50 110 Coonrod 01/16/2018 Budget Consultation 240 0.25 60 Lilly 01/18/2018 Budget Consultation 175 1.75 306 Roeger 01/19/2018 Budget Consultation 220 4.00 880 Roeger 01/19/2018 Budget Consultation 220 1.10 242 Roeger 01/23/2018 Budget Consultation 220 1.95 429 Roeger 01/23/2018 Budget Consultation 220 1.65 363 Roeger 01/23/2018 Budget Consultation 220 2.85 627 Coonrod 01/23/2018 Budget Consultation 240 0.20 48 Roeger 01/25/2018 Budget Consultation 220 0.30 66 Lilly 01/25/2018 Budget Consultation 175 1.75 306 Roeger 01/30/2018 Budget Consultation 220 1.40 308 Roeger 01/30/2018 Budget Consultation 220 0.65 143 Roeger 01/31/2018 Budget Consultation 220 0.75 165 Roeger 01/31/2018 Budget Consultation 220 2.05 451 Budget Consultation Total 5,410 Coonrod 01/30/2018 Budget Hearing 240 0.30 72 Coonrod 01/30/2018 Budget Hearing 240 0.15 36 Coonrod 01/31/2018 Budget Hearing 240 0.20 48 Budget Hearing Total 156 Coonrod 01/25/2018 LOIT Analysis 240 0.45 108 LOIT Analysis Total 108 Roeger 01/03/2018 Plan 220 0.25 55 Coonrod 01/04/2018 Plan 240 0.55 132 Roeger 01/08/2018 Plan 220 2.25 495 Roeger 01/08/2018 Plan 220 1.00 220 Roeger 01/08/2018 Plan 220 1.35 297 Roeger 01/09/2018 Plan 220 0.20 44 Roeger 01/09/2018 Plan 220 3.05 671 Coonrod 01/09/2018 Plan 240 4.20 1,008 Coonrod 01/11/2018 Plan 240 1.60 384 Coonrod 01/12/2018 Plan 240 2.55 612 Roeger 01/15/2018 Plan 220 1.00 220 Roeger 01/16/2018 Plan 220 1.75 385 Roeger 01/17/2018 Plan 220 3.80 836 Coonrod 01/18/2018 Plan 240 0.95 228 Roeger 01/22/2018 Plan 220 0.65 143 Roeger 01/22/2018 Plan 220 1.55 341 Coonrod 01/22/2018 Plan 240 2.60 624 Coonrod 01/23/2018 Plan 240 0.65 156 Roeger 01/24/2018 Plan 220 2.40 528 Coonrod 01/24/2018 Plan 240 0.20 48 Roeger 01/25/2018 Plan 220 1.50 330 Roeger 01/25/2018 Plan 220 0.40 88 Roeger 01/31/2018 Plan 220 0.45 99 Roeger 01/02/2018 Project 220 3.00 660 Coonrod 01/02/2018 Project 240 0.30 72 Roeger 01/03/2018 Project 220 0.65 143 Roeger 01/05/2018 Project 220 0.55 121 Coonrod 01/05/2018 Project 240 0.30 72 Roeger 01/10/2018 Project 220 1.00 220 Coonrod 01/10/2018 Project 240 2.45 588 Coonrod 01/11/2018 Project 240 0.35 84 Coonrod 01/12/2018 Project 240 3.60 864 Coonrod 01/17/2018 Project 240 0.60 144 Bahler 01/17/2018 Project 100 8.50 850 Coonrod 01/23/2018 Project 240 0.15 36 Roeger 01/26/2018 Project 220 0.15 33 Coonrod 01/29/2018 Project 240 0.05 12 Coonrod 01/31/2018 Project 240 0.20 49 Project Total 3,948 Publishing&printing 0 Mileage 0 TOTAL invoice amount 25,879