The URL can be used to link to this page

Home My WebLink About305848 12/12/16 a, s` CITY OF CARMEL, INDIANA VENDOR: 071300 CHECK AMOUNT: $****10,815.00' ONE CIVIC SQUARE C L COONROD & COMPANY CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE#225 CHECK NUMBER: 305848 M,roN INDIANAPOLIS IN 46240 CHECK DATE: 12/12/16 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1701 4340300 34522 0916C 9,904.00 CAFR AND AUDIT 1701 4340300 34522 1016A 911.00 CAFR AND AUDIT « O 0 ► 10 2 o n > 2 E0 � ` 0 � . k k o K O 0 2 E m O § -n � 0 k� ` t w\ n • D/ � I q / ? m ¥ 2 k \ » z o 0 [k . � • . ' § 0 / r LD a- m r ¢ � 2 K % ® ¢ m . n ^ . \ 2 q O @ CD ■ ] 0 ■ 9 ■ m y � $ g CD 00 !LD ] CD / o o C 0. 2) ID a (D 5 CL k J o ■ § § 7 � CL @ K3 INVOICE 1016a P.O.33612 Hon.Christine Pauley Clerk-Treasurer,City of Carmel Attn: Christine Pauley 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 November 22,2016 Professional services from September 29 through October 20,2016,in connection with: CAFR-record grant receivable found outside the 60 day measurement period,needed 900 to explain deficit fund balance,emailing of officials to gain statistical information to include in the CAFR,Grant Fund follow up,incorporate new information on Grant receivable to cover deficit fund balance:disclosure,receivable,unavailable revenue, CRC lessor disclosure. Out of pocket expense- 11 Total amount of this invoice. 911 P Previous balance. �� 38��9� Payment received. (15,269) Total amount due. $ Payable upon receipt. Call(317)844-4605 with questions. C.L. Coonrod &Company- User Summary Date Start:9/29/20161 Date End:10/31/2016 1 Clients:Carmel Clerk Treasurer I Services Provideds: I Users: I Account Managers:All Dab Clint S.,W-N.Wd.d Dewllrtbn Ram/ bbartiar/ BiII.bWT-/ am 4mt/ U.11 Nk. QwMim Cart Ni.. Sell Price Ben Roeger 10/07/2016 Carmel Clerk Treasurer CAFR/GAAP statements Grant Fund follow up $220.00 hl 0.35 0.35 $77.00 10/10/2016 Carmel Clerk Treasurer CAFR/GAAP statements Civic lease $220.00 hl 0.85 0.85 $187.00 Total Labor For Ben Roeger 1.20 1.20 $264.00 Total Expense For Ben Roeger $0.00 $0.00 Total For Ben Roeger $264.00 Curtis Coonrod 09/30/2016 Camlel Clerk Treasurer CAFR/GAAP statements meeting with auditors $11.00 Be 1.00 $11.00 $11.00 10/05/2016 Carmel Clerk Treasurer CAFR/GAAP statements Record grant receiveable found outside $240.00 hi 2.00 2.00 $480.00 the 60 day measurement period,needed to explain deficit fund balance 10/07/2016 Carmel Clerk Treasurer CAFR/GAAP statements Incorporate new information on Grant $240.00 hl 0.25 0.25 $60.00 receivable to cover deficit fund balance: disclosure,receivable unavailable revenue Total Labor For Curtis Coonrod 2.25 2.25 $540.00 Total Expense For Curtis Coonrod $11.00 $11.00 Total For Curtis Coonrod $551.00 Erin Hibler 10/07/2016 Carmel Clerk Treasurer CAFR/GAAP statements emailing of officials to gain statistical $80.00 hr 1.20 1.20 $96.00 information to include in the CAFR Total Labor For Erin Hibler 1.20 1.20 $96.00 Total Expense For Erin Hibler $0.00 $0.00 Total For Erin Hibler $96.00 Grand Total Labor 4.65 4.65 $900.00 Grand Total Expenses $11.00 $11.00 Grand Total $911.00 Total Times for All Currencies: 4.65 4.65 INVOICE 0916c P.O.33612 Hon.Christine Pauley Clerk-Treasurer,City of Carmel Attn:Christine Pauley One Civic Square Cannel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 October 28,2016 Professional services from August 22 through September 28,2016,in connection with: CAFR-support auditors work paper,auditors support,audit follow up items,GAAP 9,904 presentation items,debt accounts figure,supporting entries for TIF cash and investment in capital asset,cash balances,RDA cash account reclassifications,debt classification, provide explanations for disclosures on cash;claims;CIP;and utilities,respond to auditors regarding reconciliation of capital assets and debt notes for the Utilities to the financial statements,explain risk footnote to auditors;assist auditors with proof of cash, explain ambulance receivables,respond to questions regarding RDA cash reconciliations,respond to questions regarding CRC trust cash accounts,explain treatment of cash restricted fro debt service reserves in governmental funds and on statement of net position,respond to questions regarding RDA cash,a new capital lease fund,and other matters;explain reconciliation of TIF revenue,explain treatment of RDF,explain treatment of certain bonds on which the city not liable,not to be included in statements;further explanations of RDA cash balances,review list of audit issues provided by auditors,prepare for meeting with auditors,review auditors'questions and calculations on utility debt,add additional detail in the notes and financial statements to make clear that the numbers reconcile,standardize formatting throughout report; provide clarification for items discussed in meeting,assist with auditor's questions regarding utility accounting issues,special revenues on combining statements. Out of pocket expense- - Total amount of this invoice. E9,904 Previous balance. ' S 45,380 I� I Payment received. l2` (309111) Total amount due. $ 25,173 Payable upon receipt. Call(317)844-4605 with questions. C.L. Coonrod & Company- Client Summary Date Start:8/22/2016 1 Date End:9/28/2016 1 Clients:Carmel Clerk Treasurer I Services Provided: I Users: I Account Mans! Date Services Provided Description Activity Bate/ Labor Time/ Billable Time/ Bill Amt/ Unit Price Quantity Cost Price Sell Price Carmel Clerk Treasurer Ben Roeger 08/31/2016 CAFR/GAAP support auditors work paper Support auditors $220.00 hr 2.05 2.05 $451.00 statements 09/01/2016 CAFR/GAAP auditors support Support auditors $220.00 hr 0.25 0.25 $55.00 statements 09/09/2016 CAFR/GAAP auditor work paper items Support auditors $220.00 hr 3.40 3.40 $748.00 statements 09/12/2016 CAFR/GAAP audit follow up items Support auditors $220.00 hr 0.10 0.10 $22.00 statements 09/12/2016 CAFR/GAAP CAFR GAAP Follow up items $220.00 hr 1.50 1.50 $330.00 statements 09/13/2016 CAFR/GAAP GAAP presentation items Support auditors $220.00 hr 2.40 2.40 $528.00 statements 09/1$/2016 CAFRIGAAP debt accounts figure Support auditors $220.00 hr 0.80 0.80 $176.00 statements -... 09/14/2016 CAFR/GAAP Supporting entries for TIF cash and Support auditors $220.00 hr 2.00 2.00 $440.00 statements investment in capital asset 09/15/2016 CAFR/GAAP audit follow up items Support auditors $220.00 hr 1.00 1.00 $220.00 statements 09/16/2016 CAFR/GAAP GAAP numbers Support auditors $220.00 hr 0.75 0.75 $165.00 statements 09/16/2016 CAFR/GAAP follow up on account matters Support auditors $220.00 hr 0.25 0.25 $55.00 statements 09/21/2016 CAFR/GAAP audit follow up items Support auditors $220.00 hr 3.65 3.65 $803.00 statements 09/26/2016 CAFR/GAAP Cash balances Support auditors $220.00 hr 0.35 0.35 $77.00 statements 09/26/2016 CAFR/GAAP figure follow up Support auditors $220.00 hr 0.80 0.80 $176.00 statements 09/27/2016 CAFR/GAAP RDA cash account reclassifications Support auditors $220.00 hr 0.95 0,95 $209M statements 09/27/2016 CAFR/GAAP audit follow up items Support auditors $220.00 hr 0.15 0.15 $33.00 statements 09/27/2016 CAFR/GAAP Debt classification Support auditors $220.00 hr 0.65 '- 0.65 $143:00 statements 09/27/2016 CAFR/GAAP audit follow up items $220.00 hr 0.30 0.30 $66.00 statements 09/28/2016 CAFR/GAAP audit follow up items $220.00 hr 0.25 0.25 $55.00 statements Total Labor For Ben Roeger 21.60 21.60 $4,752.00 Curtis Coonrod 08/2212016 CAFRIGAAP Provide explanations for disclosures Support auditors $240.00 hr 0.50 0.50 $120.00 statements on cash,claims,CIP,and utilities 08/23/2016 CAFR/GAAP Respond to auditors regarding Support auditors $240.00 hr 0.37 0.37 $89.00 statements reconciliation of capital assets and debt notes for the Utilities to the financial statements.commitments 08/24/2016 CAFR/GAAP Explain risk footnote to auditors; Support auditors $240.00 hr 0.28 0.28 $68;00 statements assist auditors with proof of cash 08/26/2016 CAFR/GAAP explain ambulance receivables; Support auditors $240.00 hr 0.62 0.62 $149.00 statements explain storm water receivables 08/29/2016 CAFR/GAAP respond to questions to RDA Cash Support auditors $240.00 hr 0.13 0.13 $32.00 statements reconciliations 08/31/2016 CAFR/GAAP respond to questions re RDA cash Support auditors $240.00 hr 0.61 0.61 $147.00 statements 09/01/2016 CAFR/GAAP Respond to questions re CRC trust Support auditors $240.00 hr 1.42 1.42 $342.00 statements cash accounts 09/02/2016 CAFR/GAAP Explain CRC cash Support auditors $240.00 hr 0.28 0.28 $67.20 statements 09/13/2016 CAFR/GAAP Explain treatment of cash restricted Support auditors $240.00 hr 0.45 0.45 $108.00 statements for debt service reserves in governmental funds and on statement 09/14/2016 CAFR/GAAP respond to questions regarding RDA Support auditors $240.00 hr 2.35 2.35 $564.00 statements cash,a new capital lease fund;and other matters.Explain reconciliation of TIF revenue,explain treatment of Rainy Day Fund 09/15/2016 CAFR/GAAP Explain treatment of certain bonds on Support auditors $240.00 hr 0.30 0.30 $72.00 statements which the city not liable,not to be included in statements;further explanations of RDA cash balances 09/21/2016 CAFR/GAAP Review list of audit issues provided by Support auditors $240.00 hr 3.00 3.00 $720.00 statements auditors,prepare for meeting with auditors Total Labor For Curtis Coonrod 10.31 10.31 $2,478.20 Carmel INDIANA RETAIL TAX EXEMPT PAGE CERTIFICATE NO.003120155 002 0 r` PURCHASE ORDER NUMBER ` FEDERAL EXCISE TAX EXEMPT 2ySZ.L -_41� 35-60000972 ONE CIVIC SQUARE THIS NUMBER MUST APPEAR CV INDICES,A/P CARMEL,INDIANA 46032-2584 VOUCHER, DELIVERY MEMO, PACKING SLIPS, )RM APPROVED BY STATE BOARD OF ACCOUNTS FOR CITY OF CARMEL-1997 SHIPPING LABELS AND ANY CORRESPO ENCE. CHASE ORDER DATE DATE REQUIRED REQUISITION NO. VENDOR NO. DESCRIPTION /� -•aT-•/b d 7/ 3oo CG GoaNRno NDOR 34?So p/t/pn/rX' So TN 02#22S SHIP TO GNe C/vic Sa •e.c6 y6'd3 Z RMAMON BLANKET CONTRACT PAYMENTTERMS FREIGHT QUANTITY UNIT OF MEASURE DESCRIPTION UNIT PRICE EXTENSION - /701 Y3 Y 0 3o o (w&a "wt) "a ••s 0., v0000••• id Invoice To: ; /f)/ J/5. °� Cg)O DEPARTMENT ACCOUNT PROJECT PROJECT ACCOUNT v��T AIVIOUIV 1 PAYMENT • A/P VOUCHER CANNOT BE APPROVED FOR PAYMENT UNLESS THE P.O. NUMBER IS MADE A PART OF THE VOUCHER AND EVERY INVOICE AND VOUCHER HAS THE PROPER SWORN AFFIDAVIT ATTACHED. SHIPPING INSTRUCTIONS • I HEREBY CERTIFY TH T ERE IS AN UNOBLIGATED BALANCE IN THIS APPROPRIAT FICIENT TO PAY FOR THE ABOVE ORDER. HIP REPAID. '.O.D.SHIPMENTS CANNOT BE ACCEPTED. ORDERED BY URCHASE ORDER NUMBER MUST APPEAR ON ALL //� HIPPING LABELS. TITLE `-� -IIS ORDER ISSUED IN COMPLIANCE WITH CHAPTER 99,ACTS 1945 77 VD ACTS AMENDATORY THEREOF AND SUPPLEMENT THERETO. CLERK-TREASURER CUMENT CONTROL NO. 3 4 5 2