The URL can be used to link to this page

Home My WebLink About306792 1/06/17 �` ��'"F. CITY OF CARMEL, INDIANA VENDOR: 071300 J C L COONROD &COMPANY CHECK AMOUNT: $''"'13,768.00` ONE CIVIC SQUARE 3850 PRIORITY WAY SOUTH DRIVE#225 CHECK NUMBER: 306792 „ � CARMEL, INDIANA 46032 INDIANAPOLIS IN 46240 CHECK DATE: 01/06/17 9MIl10N..-. DESCRIPTION DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER A MOUNT 00 ACCTG SERVICES FOR 20 1160 4340303 34499 1216 \ 0 « 0 , m 0 p q r O $ § 2 e 7 ƒ 2 q c n cr q // 0 z k U) O % § \ ® / ƒ 0 o m O 2 * O $ / ° C) E ƒ OD a 2 o / k / � / � 3 7 % & ® n � 7 O % 2 $ 40 E 7 2 > -n p i k G R | 00 § \ S ¥ % z > z k \ / ? § % k = 7 Ecr § m CD m » a ; o m CL x § 0 7 _ § § 7 CD m 2 f 2 § a. 2 ( CD ( CD SD Cr/ g § E CD $ / % 3 q CD t 0 � 0 \ ± § i § 7 $ « § - E CD \ 2. m / § I 2 § CD | ; # %(D m § � E K ƒ § § m \ 0. } AD \ 2) 2 / \ # � K � \ g 'o[ ca wCD � k § m ƒ k � C \ ) w ° D ( _ t< %E \ \ ( � e° C) ;; D �10 ID C) D §_0 } Q �E ° 7 \ \ / \ Q a \ j E \ 0 « ] ¢ E 5 C _ M m % / ƒ § $ / A g § & ƒ 2 � $ c m G 7 \ ] § k ^ 7 c ( ca k > CDƒ \ 0 PD 0 z ° \ INVOICE 1216 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 December 14,2016 Professional services from November 18 through November 30,2016,in connection with: Accounting System-respond to questions regarding audit committee 60 Budget Consultation-Salary items,preparation for Council meeting-questions 3,262 regarding financial statements-RDF resolution,preparation for and attend Council meeting follow up Rainy Day fund resolution questions,levy shortfall resolution follow up. CAFR/GAAP-CAFR follow up items,response to meeting items,respond to SBOA 8,961 Chief examiner-email mayor-consult council member-email council member regarding remaining issues-summarize audit issues in preparation for call to auditors,operating leases,TIF bonds and utility bonds subsequent events disclosure,preparation for meeting with auditors-auditor email regarding available COIT revenue-preparation work paper to explain COIT,CAFR notes preparation for meeting,email specifications to cap assets consultant,preparation and attendance at meeting,review draft cap assets report and respond as to additional items needed-lessor disclosure,meeting with auditors to review issues and schedule,follow up on auditor concerns about CAB's-other items discussed in meeting-work on utility CAB-phone call to GFOA regarding CAB in statement of net position-provide COIT receivable support and other requested items,make audit adjustments:adjust payroll fund ledger-reclassify capital leases-add newly identified trust cash account-phone call GFOA regarding presentation of CAB accrued interest- revise CAB presentation to conform to GFOA,review CAB entries,revise CAB entries for proprietary funds-reconcile internal service fund to statement of net position,fixed assets,update operating lease work paper,update notes for debt. Fiscal Plan-review debt schedules-review updates-council issues-conflict with state 1,187 regarding projection of income tax-compare plan COIT projection to SBOA,review plan related items,update for Council meeting. LOIT Analysis-SBOA vs Carmel estimates. 240 Out of pocket expense-mileage 58 Total amount of this invoice. 13,768 Previous balance. 14,925 Payment received. - Total amount due. $ 28,693 Payable upon receipt Call(317)8444605 with questions. CITY OF CARMEL December 14,2016 Professional services from November 18 through November 30,2016,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 Data Services Provided Hourly Rate Total Coonrod 11/29/2016 Accounting System 240 0.25 60 Accounting System Total 60 Lilly 11/3/2016 Budget Consultation 155 1.75 271 Lilly 11/10/2016 Budget Consultation 155 1.75 271 Lilly 11/17/2016 Budget Consultation 155 1.75 271 Lilly 11/21/2016 Budget Consultation 155 2.25 349 Roeger 11/21/2016 Budget Consultation 220 0.70 154 Coonrod 11/21/2016 Budget Consultation 240 3.45 828 Coonrod 11/21/2016 Budget Consultation 240 2.75 660 Roeger 11/22/2016 Budget Consultation 220 0.25 55 Roeger 11/22/2016 Budget Consultation 220 0.60 132 Lilly 11/24/2016 Budget Consultation 155 1.75 271 Budget Consultation Total 3,262 Roeger 11/21/2016 CAFR/GAAP 220 1.55 341 Roeger 11/21/2016 CAFR/GAAP 220 1.50 330 Lilly 11/22/2016 CAFR/GAAP 155 1.60 248 Coonrod 11/22/2016 CAFR/GAAP 240 3.35 804 Lilly 11/23/2016 CAFR/GAAP 155 2.10 326 Coonrod 11/23/2016 CAFR/GAAP 240 0.95 228 Coonrod 11/23/2016 CAFR/GAAP 240 2.95 708 Coonrod 11/25/2016 CAFR/GAAP 240 2.10 504 Hibler 11/25/2016 CAFR/GAAP 80 0.50 40 Roeger 11/28/2016 CAFR/GAAP 220 2.45 539 Roeger 11/28/2016 CAFR/GAAP 220 2.40 528 Lilly 11/28/2016 CAFR/GAAP 155 1.95 302 Lilly 11/28/2016 CAFR/GAAP 155 1.70 264 Coonrod 11/28/2016 CAFR/GAAP 240 1.55 372 Coonrod 11/28/2016 CAFR/GAAP 240 1.45 348 Coonrod 11/28/2016 CAFR/GAAP 240 1.80 432 Lilly 11/29/2016 CAFR/GAAP 155 3.65 566 Coonrod 11/29/2016 CAFR/GAAP 240 4.60 1,104 Lilly 11/30/2016 CAFR/GAAP 155 2.20 341 Coonrod 11/30/2016 CAFR/GAAP 240 2.65 636 CAFR/GAAP Total 8,961 Coonrod 11/18/2016 Plan 240 4.25 1,020 Roeger 11/21/2016 Plan 220 0.65 143 Coonrod 11/21/2016 Plan 240 0.10 24 Plan Total 1,187 Coonrod 11/21/2016 LOIT Analysis 240 1.00 240 LOIT Analysis Total 240 Meal 0 Mileage 58 TOTAL invoice amount 13,768 INVOICE 1216 P.0.�36?E3+ ?jt,`C ►q 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 December 14,2016 Professional services from November 18 through November 30,2016,in connection with: Accounting System-respond to questions regarding audit committee 60 Budget Consultation-Salary items,preparation for Council meeting-questions 3,262 regarding financial statements-RDF resolution,preparation for and attend Council meeting follow up Rainy Day fund resolution questions,levy shortfall resolution follow UP. CAFR/GAAP-CAFR follow up items,response to meeting items,respond to SBOA 8,961 Chief examiner-email mayor-consult council member-email council member regarding remaining issues-summarize audit issues in preparation for call to auditors,operating leases,TIF bonds and utility bonds subsequent events disclosure,preparation for meeting with auditors-auditor email regarding available COTE revenue-preparation work paper to explain COTT,CAFR notes preparation for meeting,email specifications to cap assets consultant,preparation and attendance at meeting,review draft cap assets report and respond as to additional items needed-lessor disclosure,meeting with auditors to review issues and schedule,follow up on auditor concerns about CAB's-other items discussed in meeting-work on utility CAB-phone call to GFOA regarding CAB in statement of net position-provide COTT receivable support and other requested items,make audit adjustments:adjust payroll fund ledger-reclassify capital leases-add newly identified trust cash account-phone call GFOA regarding presentation of CAB accrued interest- revise CAB presentation to conform to GFOA,review CAB entries,revise CAB entries for proprietary funds-reconcile internal service fund to statement of net position,fixed assets,update operating lease work paper,update notes for debt. Fiscal Plan-review debt schedules-review updates-council issues-conflict with state 1,187 regarding projection of income tax-compare plan COTT projection to SBOA,review plan related items,update for Council meeting. LOIT Analysis-SBOA vs Carmel estimates. 240 Out of pocket expense-mileage 58 Total amount of this invoice. 13,768 Previous balance. 14,925 Payment received. Total amount due. $ 28,693 Payable upon receipt Call(317)844-4605 with questions.