306792 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.