Loading...
220242 05/21/2013 CITY CIF CARMEL, INDIANA VENDOR: 00351455 Page 1 of 1 ONE CIVIC SQUARE LONDON WITTE GROUP LLC CHECK AMOUNT: $11,788.75 { CARMEL, INDIANA 46032 ONE AMERICAN SQUARE 1776 N MERIDIAN STREET SUITE 500 CHECK NUMBER: 220242 INDIANAPOLIS IN 46202 CHECK DATE: 5/21/2013 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1701 4340300 25915 1, 543 . 75 ACCOUNTING FEES 1801 4340303 25917 3 , 353 . 75 OTHER ACCOUNTING FEES 902 4340300 25917 6, 891 . 25 ACCOUNTING FEES LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W. Main Street Date: 0413012013 Suite 220 Invoice No: 25917 Carmel, IN 46032 For services rendered as detailed in the attached summary. Operating $ 3,353.7 Non-Operating 6,891.25 Current Amount Due $ 10.245.00 Certified Public Accountants 1776 N.Meridian Street,Suite 500 Indianapolis,Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.com London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 1 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 04/01/2013 0.50 325.00 162.50 Follow-ups with Dave Bowers and distribution list folks re: availability to meet on April 4th to review various projects(unavailable);follow-ups with Mike Lee re: same. Higgins 04/04/2013 0.25 325.00 81.25 Follow-up with Dave Bowers and group re: reschedule afternoon meeting(Dave's conflict); review schedule; follow-up email re:alternative dates; adjust calendar for the revised date. Higgins 04/05/2013 2.25 325.00 731.25 Prepare for and attend a meeting at the CRC offices with staff, Dave Bowers,4CDC accountants and Mayor Brainard re: review of 2013 budget priorities and related matters. Carney 04/17/2013 0.25 70.00 17.50 Printed April CRC Meeting Packet for JPH. 3.25 992.50 Subtotal-Financial Advisory-Finance Committee Higgins 04/0112013 2.00 325.00 650.00 Follow-up with Mike Lee and Bob Reynolds re: items needed for the audit; review and request edits re: same; email initial documents to Lori Danford(SBOA). Lee 04/01/2013 3.25 75.00 243.75 Input January and February checks and wires into TIF register. Added wires from December as well. Updated each TIF area's register accordingly. Lee 04/03/2013 0.25 75.00 18.75 Updated CRC TIF register for January and February. Higgins 04/04/2013 0.25 325.00 81.25 Audit-follow-up with Mike Lee on status of response to SBOA Examiners Question. Lee 04/05/2013 5.25 75.00 393.75 Reconciled CRC's 2012 CTAR report uploaded to Gateway website with CRC's 2012 check register. Reviewed all expenditure and revenue line items on both reports. Found difference between both ending balances and reported that information to Jim Higgins. Higgins 04/10/2013 0.50 325.00 162.50 Follow-ups with Mike and Bob; email to Lori Danford with explanation of the CTAR reconciliation matter. Lee 04/15/2013 0.75 75.00 56.25 Updated CRC TIF register as of March 31st,2013 for audit purposes. Lee 04/18/2013 0.25 75.00 18.75 Researched CRC current debt obligations and sent email to auditor stating what the current obligations are post-refunding. Higgins 04/18/2013 0.25 325.00 81.25 Follow-ups with Lori Danford and Mike Lee re; audit questions re: debt. Higgins 04/22/2013 0.25 325.00 81.25 Follow-up with Lori Danford(SBOA) re: request for claims to review for audit;follow-up with Mike Lee re: same. Lee 04/22/2013 0.75 75.00 56.25 Searched for 2012 claims requested by auditor. Scanned and emailed requested claims. Higgins 04/26/2013 0.50 325.00 162.50 Review claims for audit as prepared by Mike Lee; forward to Lori Danford(SBOA). Lee 04/30/2013 0.50 75.00 37.50 Reviewed question from auditor RE: specific check and reasoning for difference in check amount and attached invoices. Invoice was later located and sent on to auditor. 14.75 2,043.75 Subtotal-Financial Advisory-Audit London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 2 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/10/2013 1.00 75.00 75.00 Looked for developer bond amortization schedules in order to update information in monthly packet. Verified the current outstanding is correct. Updated developer bond information in packet. Lee 04/11/2013 0.50 75.00 37.50 Updated revenue/expenditure analysis for April packet. Lee 04/11/2013 1.00 75.00 75.00 Updated portions of forecast for January, February and March. Reconciled all numbers with Clerk-Treasurer's expenditure audit trail and revenue audit trail. Inserted new line items that will appear on new budget. Lee 04/12/2013 0.25 75.00 18.75 Created sources of funds and 902 Fund revenue pages for packet. Lee 04/12/2013 0.25 75.00 18.75 Updated developer debt balances for packet. Lee 04/12/2013 0.50 75.00 37.50 Revised and reformatted expenditure/revenue analysis after revising forecast. Lee 04/12/2013 0.50 75.00 37.50 Reformatted packet for better viewing. Lee 04/12/2013 0.75 75.00 56.25 Updated summary page of accounts for packet. Lee 04/12/2013 3.25 75.00 243.75 Revised and reformatted forecast. Reviewed all expenditures and revenues to date from Clerk-Treasurer's audit trails. Updated beginning balance and added in items into January and February. Checked to make sure forecast flowed with revised budget. Lee 04/30/2013 0.25 75.00 18.75 Revised beginning balance for COIT 2006 bond principal to correct amount. 8.25 618.75 Subtotal-Financial Advisory-Financial Dashboard Lee 04/01/2013 0.25 75.00 18.75 Responded to emails RE: logistics for payment of vendor that was previously under an installment purchase contract. Lee 04/01/2013 0.25 75.00 18.75 Emailed Les Olds RE: what is needed for April 4th meeting at CRC offices. Lee 04/02/2013 0.25 75.00 18.75 Responded to several emails RE: Illinois Street Economic Development Area and invoices remaining for former installment purchase contract vendors. Lee 04/02/2013 0.25 75.00 18.75 Reviewed several incoming CRC invoices. Lee 04/03/2013 0.75 75.00 56.25 Reviewed new CRC and Redevelopment Department invoices for payment. Discussed advertising invoices with CRC staff. Lee 04/03/2013 1.00 75.00 75.00 Filled out claims forms for CRC and Redevelopment Department invoices. Lee 04/08/2013 0.25 75.00 18.75 Reviewed CRC emails for issues. Carney 04/10/2013 0.25 70.00 17.50 Printed Financial Information Packet for monthly meeting. Lee 04/11/2013 5.50 75.00 412.50 Reviewed CRC and Redevelopment Department invoices and made adjustments where necessary. Called vendors with inquiries when necessary. Copied all invoices for packet and for scanning. Entered all invoices into approval and informational spreadsheets for packet. Lee 04/12/2013 0.50 75.00 37.50 Updated check register for January, February and March. Higgins 04/17/2013 1.50 325.00 487.50 Attend Executive Session of the CRC. Lee 04/17/2013 2.00 75.00 150.00 Attended CRC executive session meeting and public meeting. Higgins 04/17/2013 2.50 325.00 812.50 Prepare for and attend CRC monthly meeting London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 3 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/17/2013 0.50 75.00 37.50 Created Action Item for Revised Budget. Printed off documents for meeting. Lee 04/17/2013 0.50 75.00 37.50 Reviewed financial documents for public meeting. Lee 04/18/2013 0.50 75.00 37.50 Filed March and April invoices away manually and electronically. Lee 04/19/2013 1.50 75.00 112.50 Reviewed all new invoices for CRC and Redevelopment Department for legitimacy. Scanned and input invoices into CRC computer database. Lee 04/19/2013 2.50 75.00 187.50 Filled out claims forms for CRC and Redevelopment Department invoices to be submitted to the Clerk-Treasurer's office. Lee 04/19/2013 0.50 75.00 37.50 Contacted several vendors RE: payment status of invoices and to request contracts and altering of invoices. Lee 04/22/2013 0.25 75.00 18.75 Discussed claims with Les Olds. Lee 04/22/2013 0.50 75.00 37.50 Prepared claims and contracts for submission to Clerk-Treasurer. Lee 04/22/2013 1.50 75.00 112.50 Input remaining invoices into CRC computer database. Lee 04/23/2013 0.25 75.00 18.75 Reviewed emails RE: Shapiro's property. Lee 04/24/2013 0.25 75.00 18.75 Responded to emails from Vicki Sponcil RE: vendor pay applications to be delivered to CRC. Lee 04/26/2013 0.25 75.00 18.75 Responded to emails from CRC staff RE: vendor payment inquiries and contracts. Lee 04/29/2013 0.25 75.00 18.75 Discussed which contracts are still need to be submitted to the Clerk-Treasurer's office. Lee 04/30/2013 0.25 75.00 18.75 Responded to vendor payment inquiries and logistics for check mailings. 24.75 2,855.00 Subtotal-Financial Advisory-General Lee 04/10/2013 1.00 75.00 75.00 Researched bank statements for Arts District Lofts and Shoppes bonds. Looked at developer agreement. Discussed scenarios with Bob Reynolds. Computed what is expected to be passed on to the developer from 2013 TIF collections. Lee 04/10/2013 1.25 75.00 93.75 Reviewed TIF analysis for Meridian and Main TIF area. Looked at developer agreement. Computed what is expected to be passed on to the developer from 2013 TIF collections. Lee 04/10/2013 1.25 75.00 93.75 Researched bank statements for Parkwood East and Parkwood West. Looked at developer agreement. Discussed scenarios with Bob Reynolds. Computed what is expected to be passed on to the developer from 2013 TIF collections. Lee 04/10/2013 1.50 75.00 112.50 Reviewed TIF billing report provided by Hamilton County Auditor. Extracted Carmel TIF amounts to see what can be anticipated for 2013 collections. Lee 04/22/2013 0.25 75.00 18.75 Contacted trustee for Taxable Economic Development Revenue Bonds, Series 2011 (Indiana Spine Group Project) RE: invoice. Higgins 04/22/2013 0.75 325.00 243.75 Meridian and Main-follow-ups with Sandy/Cindy and Mike Lee re: 2012 calculation correction and related matters. Higgins 04/23/2013 0.25 325.00 81.25 Follow-ups with Mike Lee re: Indiana Spine Group/Meridian and Main EDA. London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 4 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/23/2013 0.25 75.00 18.75 Sent email to Cindy Sheeks and Sandy Johnson RE: Huntington invoice for calculation error. Reynolds 04/24/2013 1.75 80.00 140.00 Reviewed the CRC TIF Ledger. The Ledger was not calculating correctly.Went through the formulas to find the error and updated. Lee 04/24/2013 4.25 75.00 318.75 Revised TIF Register through March 31 st, 2013. Organized TIF register for distribution. Reynolds 04/25/2013 0.50 80.00 40.00 TIF Ledger-Reviewed the updated TIF Ledger from Mike. Lee 04/25/2013 3.00 75.00 225.00 Revised TIF register for each individual TIF district from January 2012 through March 2013. Higgins 04/25/2013 0.25 325.00 81.25 Follow-up with Jamie Browning re: status of the correction of the 2012 payments for the Indiana Spine Group. Higgins 04/25/2013 0.25 325.00 81.25 Meridian and Main-follow-up with Cindy re: payment of the Meridian and Main correction. Follow-up with Mike Lee re: same for posting to the detailed TIF register. Lee 04/26/2013 0.25 75.00 18.75 Discussions with Ben Roeger and Andy Mouser RE: property taxes for Office Building and whether they were included in 2013 TIF projections. Lee 04/26/2013 0.50 75.00 37.50 Discussion with Lee Graham and research RE: Office Building property taxes and 2013 TIF collections. Lee 04/26/2013 0.50 75.00 37.50 Revised CRC TIF register. 17.75 1,717.50 Subtotal-Financial Advisory-TIF Lee 04/08/2013 1.00 75.00 75.00 Prepared revised 2013 budget for review by CRC commissioners. Lee 04/09/2013 0.25 75.00 18.75 Updated revised budget and sent on to Les Olds for changes. Lee 04/09/2013 0.50 75.00 37.50 Discussed budget revisions with Ben Roger, Les Olds and Matt Worthley. Updated budget and forecast accordingly. Lee 04/12/2013 1.50 75.00 112.50 Updated revised 2013 budget based on new invoices and updated 2013 forecast. Changed beginning balance to reflect real balance. Updated TIF revenue to reflect payment in April for 2012 back payment for Meridian and Main developer bond that was approved at February meeting. Lee 04/23/2013 0.25 75.00 18.75 Contacted Ben Roeger to clarify how much the 4CDC plans on forwarding to the CRC for net office rents and why. 3.50 262.50 Subtotal-Financial Advisory-Budgets Lee 04/05/2013 1.50 75.00 112.50 Attended meeting at CRC offices to review budget and priority for budget line items. Lee 04/05/2013 1.50 75.00 112.50 Prepared for meeting at CRC offices. Discussed construction budget with Les Olds. Made several revisions of CRC forecast to present at meeting. Lee 04/10/2013 0.25 75.00 18.75 Emailed Meridian and Main bond trustee RE: letter needed in order to make catch-up payment. London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 5 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 04/10/2013 1.00 80.00 80.00 Developer Bond-Went over developer bond payoff amounts with Mike Lee. Discussed both Parkwood Bonds and Merchants Square.Also discussed how to allocate the funds that will be owed to the Indiana Spine Group for the Meridian and Main TIF Collections. Lee 04/11/2013 0.25 75.00 18.75 Researched CRC payment records for Horning Roofing invoice that they claim was not paid. Records show it was paid. Lee 04111/2013 0.75 75.00 56.25 Researched CRC payables and receivables records for Shapiro's information requested by CRC staff. Higgins 04/24/2013 0.25 325.00 81.25 Retrieve message and return call to Jim Rush re: availability to meet with Pedcor representatives to discuss CRC matters. Lee 04/30/2013 0.25 75.00 18.75 Discussed PAC roof settlements summary with Jim Higgins. 5.75 498.75 Subtotal-Financial Advisory-Special Projects Lee 04/01/2013 2.00 75.00 150.00 Looked at several different scenarios for funding Illinois Street project. Read through North Illinois Street Economic Development Plan. Created forecast that shows amounts that could fund project with assumptions. Lee 04/01/2013 0.25 75.00 18.75 Looked up status of check for vendor and email Clerk's office for status of mailing check. Lee 04/02/2013 0.50 75.00 37.50 Searched for paid invoices report for specific vendor in CRC database and in Clerk-Treasurer files. Lee 04/03/2013 0.25 75.00 18.75 Called Wells Fargo RE: check received for reimbursement of a supposed double payment. Discussed check with Clerk-Treasurer's office. Lee 04/03/2013 0.25 75.00 18.75 Called Computer Ease software company for problems with accessing records. Lee 04/03/2013 0.50 75.00 37.50 Called several vendors RE: invoices, statements and outstanding amounts due or not due. Lee 04/03/2013 0.25 75.00 18.75 Delivered checks to Clerk-Treasurer for deposit. Lee 04/08/2013 0.25 75.00 18.75 Delivered claims to Clerk-Treasurer's office. Lee 04/08/2013 0.50 75.00 37.50 Prepared Redevelopment Department claims for submission. Lee 04/09/2013 0.25 75.00 18.75 Responded to emails RE: revising CRC budget for 2013. Lee 04/09/2013 0.25 75.00 18.75 Emailed reminders to Cindy Sheeks, City Hall, Police Department and Fire Department that monthly energy consumption payments will be transferred. Lee 04/11/2013 0.50 75.00 37.50 Reviewed expenditure audit trail to date for the Redevelopment Department. Based on given information, created spreadsheet reflecting current balances and percentages of budget remaining. Lee 04/11/2013 0.25 75.00 18.75 Researched for checks that should have been deposited on April 3rd in CRC's 902 fund. Emailed copies of checks to Clerk-Treasurer's office. Lee 04/11/2013 0.25 75.00 18.75 Delivered check to Clerk-Treasurer's office. Lee 04/12/2013 0.25 75.00 18.75 Reviewed emails RE: Shapiro's payments Lee 04/15/2013 0.25 75.00 18.75 Reviewed email from Les Olds RE: moving of records to Clerk-Treasurer. London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 6 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/15/2013 0.50 75.00 37.50 Reviewed and responded to emails RE: Computer Ease invoice and overpayment to Horning Roofing in 2011. Sent bank records information to Dave Burchard at Shiel Sexton RE: Horning Roofing overpayment. Lee 04/17/2013 1.00 75.00 75.00 Reviewed new CRC invoices. Looked into new construction pay applications. Sent email to Brandon Bogan RE: adjustments that need to be made to pay application for payments. Discussed payment of invoices and contracts with Les Olds and Matt Worthley. Lee 04/17/2013 1.50 75.00 112.50 Reviewed CRC property tax bills. Researched parcel numbers. Looked at transfer history to make sure the CRC is liable for each of the tax bills. Created spreadsheet listing all of this information and made comments for questions and concerns. Discussed spreadsheet with Jim Higgins. Lee 04/18/2013 0.25 75.00 18.75 Discussed CRC contracts with Les Olds and what is still needed for the Clerk-Treasurer's records. Lee 04/18/2013 0.25 75.00 18.75 Sent email to Ryan Wilmering RE: CRC property tax bills. Lee 04/19/2013 0.25 75.00 18.75 Created April invoice for Club Canine's portion of utility costs. Lee 04/22/2013 0.25 75.00 18.75 Delivered CRC and Redevelopment Department claims and checks to the Clerk-Treasurer's office. Lee 04/22/2013 0.25 75.00 18.75 Wrote claims for new invoices. Lee 04/22/2013 0.25 75.00 18.75 Contacted vendor RE: invoice and what was still needed in order to receive payment. Lee 04/23/2013 0.25 75.00 18.75 Had conversation with Vicki Sponcil RE: pay applications from vendors previously paid by installment purchase contracts. Lee 04/23/2013 0.25 75.00 18.75 Had conversation with someone from County Assessor's office RE: CRC property taxes. They agreed several of the parcels were classified wrong and sent out revised tax bills. Lee 04/23/2013 0.25 75.00 18.75 Responded to email from Matt Worthley RE: payment inquiry to vendor. Lee 04/23/2013 0.25 75.00 18.75 Communicated with 2012 Bond trustee RE: payment of invoice from bond proceeds and movement of remaining balance to sinking fund. Lee 04/23/2013 1.25 75.00 93.75 Reviewed changes on Hamilton County's website for CRC's property tax information. Reviewed transfer history reports for parcels in question. Put together questions and emailed them to county assessor. Lee 04/24/2013 0.25 75.00 18.75 Called vendor RE: contract that is needed in order to pay invoices through Clerk-Treasurer. Lee 04/24/2013 0.25 75.00 18.75 Scanned and emailed vendor invoice to Les Olds with instructions to pay it out of 2012 bond proceeds. Lee 04/24/2013 0.25 75.00 18.75 Emailed property tax bill for 4CDC as well as other 4CDC bills to Ben Roger. Lee 04/24/2013 0.50 75.00 37.50 Created claims for property tax bills. Scanned copies into CRC computer database. Lee 04/25/2013 0.25 75.00 18.75 Emailed vendor RE: inquiring about contract that is needed in order to pay invoices. Lee 04/26/2013 0.50 75.00 37.50 Reviewed all claims not submitted due to lack of contract on file. Put list together for CRC staff to assemble. Lee 04/29/2013 0.25 75.00 18.75 Checked CRC emails for issues and forwarded information on to CRC staff. London Witte Group, LLC April 2013 Billing Detail Carmel Redevelopment Commission 7 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/30/2013 1.00 75.00 75.00 Researched bank statements for Merchants Square bonds and updated redemption/defeasance analysis for the Commission. 16.75 1,256.25 Subtotal-Financial Advisory-Other 94.75 10,245.00 Total Invoice Summary: 3,353.75 Operating 6,891.25 Non-Operating 10,245.00 Total 0 I Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Forth No.201(Rev.1995) CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. Payee L�n��n V✓Ill P 612a Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 15917 oker&fit c t oa ih y)ee 3 - Zf Total 35 -75 1 hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I have audited same in accor- dance with IC 5-11-10-1.6. , 20 Clerk-Treasurer VOUCHER NO. WARRANT NO. II ALLOWED 20 �0/1d011 (' �Y Oaf IN SUM OF $ $ 3, 3 53,75 ON ACCOUNT OF APPROPRIATION FOR Board Members PO#or D PT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s), Igo q` 3QQ Q 3 5 15 or 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 5- p.-- 2013 Signature Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W Main Street Date: 0413012013 Suite 220 Invoice No: 25917 Carmel, IN 46032 For services rendered as detailed in the attached summary. Operating $ 3,353.75 Non-Operating g 891 Current Amount Due $__j 0245 00 Certified Public Accountants 1776 N.Meridian Street,Suite 500 Indianapolis,Indiana 46202 Telephone 1317-634-4747 Facsimile 317-632-2727 Web I LondonWitteGroup.com London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 1 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 04/01/2013 0.50 325.00 162.50 Follow-ups with Dave Bowers and distribution list folks re: availability to meet on April 4th to review various projects(unavailable); follow-ups with Mike Lee re: same. Higgins 04/04/2013 0.25 325.00 81.25 Follow-up with Dave Bowers and group re: reschedule afternoon meeting (Dave's conflict); review schedule;follow-up email re:alternative dates; adjust calendar for the revised date. Higgins 04/05/2013 2.25 325.00 731.25 Prepare for and attend a meeting at the CRC offices with staff, Dave Bowers,4CDC accountants and Mayor Brainard re: review of i 2013 budget priorities and related matters. Carney 04/17/2013 0.25 70.00 17.50 Printed April CRC Meeting Packet for JPH. 3.25 992.50 Subtotal-Financial Advisory-Finance Committee Higgins 04/01/2013 2.00 325.00 650.00 Follow-up with Mike Lee and Bob Reynolds re: items needed for the audit; review and request edits re: same; email initial documents to Lori Danford(SBOA). Lee 04/01/2013 3.25 75.00 243.75 Input January and February checks and wires into TIF register. Added wires from December as well. Updated each TIF area's register accordingly. Lee 04/03/2013 0.25 75.00 18.75 Updated CRC TIF register for January and February. Higgins 04/04/2013 0.25 325.00 81.25 Audit-follow-up with Mike Lee on status of response to SBOA Examiners Question. Lee 04/05/2013 5.25 75.00 393.75 Reconciled CRC's 2012 CTAR report uploaded to Gateway website with CRC's 2012 check register. Reviewed all expenditure and revenue line items on both reports. Found difference between both ending balances and reported that information to Jim Higgins. Higgins 04/10/2013 0.50 325.00 162.50 Follow-ups with Mike and Bob;email to Lori Danford with explanation of the CTAR reconciliation matter. Lee 04/15/2013 0.75 75.00 56.25 Updated CRC TIF register as of March 31st,2013 for audit purposes. Lee 04/18/2013 0.25 75.00 18.75 Researched CRC current debt obligations and sent email to auditor stating what the current obligations are post-refunding. Higgins 04/18/2013 0.25 325.00 81.25 Follow-ups with Lori Danford and Mike Lee re; audit questions re:debt. Higgins 04/22/2013 0.25 325.00 81.25 Follow-up with Lori Danford(SBOA)re: request for claims to review for audit;follow-up with Mike Lee re: same. Lee 04/22/2013 0.75 75.00 56.25 Searched for 2012 claims requested by auditor. Scanned and emailed requested claims. Higgins 04/26/2013 0.50 325.00 162.50 Review claims for audit as prepared by Mike Lee; forward to Lori Danford(SBOA). Lee 04/30/2013 0.50 75.00 37.50 Reviewed question from auditor RE: specific check and reasoning for difference in check amount and attached invoices. Invoice was later located and sent on to auditor. 14.75 2,043.75 Subtotal-Financial Advisory-Audit London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 2 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/10/2013 1.00 75.00 75.00 Looked for developer bond amortization schedules in order to update information in monthly packet. Verified the current outstanding is correct. Updated developer bond information in packet. Lee 04/11/2013 0.50 75.00 37.50 Updated revenue/expenditure analysis for April packet. Lee 04/11/2013 1.00 75.00 75.00 Updated portions of forecast for January, February and March. Reconciled all numbers with Clerk-Treasurer's expenditure audit trail and revenue audit trail. Inserted new line items that will appear on new budget. Lee 04/12/2013 0.25 75.00 18.75 Created sources of funds and 902 Fund revenue pages for packet. Lee 04/12/2013 0.25 75.00 18.75 Updated developer debt balances for packet. Lee 04/12/2013 0.50 75.00 37.50 Revised and reformatted expenditure/revenue analysis after revising forecast. Lee 04/12/2013 0.50 75.00 37.50 Reformatted packet for better viewing. Lee 04/12/2013 0.75 75.00 56.25 Updated summary page of accounts for packet. Lee 04/12/2013 3.25 75.00 243.75 Revised and reformatted forecast. Reviewed all expenditures and revenues to date from Clerk-Treasurer's audit trails. Updated beginning balance and added in items into January and February. Checked to make sure forecast flowed with revised budget. Lee 04/30/2013 0.25 75.00 18.75 Revised beginning balance for COIT 2006 bond principal to correct amount. 8.25 618.75 Subtotal-Financial Advisory-Financial Dashboard Lee 04/01/2013 0.25 75.00 18.75 Responded to emails RE: logistics for payment of vendor that was previously under an installment purchase contract. Lee 04101/2013 0.25 75.00 18.75 Emailed Les Olds RE: what is needed for April 4th meeting at CRC offices. Lee 04/02/2013 0.25 75.00 18.75 Responded to several emails RE: Illinois Street Economic Development Area and invoices remaining for former installment purchase contract vendors. Lee 04/02/2013 0.25 75.00 18.75 Reviewed several incoming CRC invoices. Lee 04/03/2013 0.75 75.00 56.25 Reviewed new CRC and Redevelopment Department invoices for payment. Discussed advertising invoices with CRC staff. Lee 04/03/2013 1.00 75.00 75.00 Filled out claims forms for CRC and Redevelopment Department invoices. Lee 04/08/2013 0.25 75.00 18.75 Reviewed CRC emails for issues. Carney 04/10/2013 0.25 70.00 17.50 Printed Financial Information Packet for monthly meeting. Lee 04/11/2013 5.50 75.00 412.50 Reviewed CRC and Redevelopment Department invoices and made adjustments where necessary. Called vendors with inquiries when necessary. Copied all invoices for packet and for scanning. Entered all invoices into approval and informational spreadsheets for packet. Lee 04/12/2013 0.50 75.00 37.50 Updated check register for January, February and March. Higgins 04/17/2013 1.50 325.00 487.50 Attend Executive Session of the CRC. Lee 04/17/2013 2.00 75.00 150.00 Attended CRC executive session meeting and public meeting. Higgins 04/17/2013 2.50 325.00 812.50 Prepare for and attend CRC monthly meeting London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 3 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/17/2013 0.50 75.00 37.50 Created Action Item for Revised Budget. Printed off documents for meeting. Lee 04/17/2013 0.50 75.00 37.50 Reviewed financial documents for public meeting. Lee 04/18/2013 0.50 75.00 37.50 Filed March and April invoices away manually and electronically. Lee 04/19/2013 1.50 75.00 112.50 Reviewed all new invoices for CRC and Redevelopment Department for legitimacy. Scanned and input invoices into CRC computer database. Lee 04/19/2013 2.50 75.00 187.50 Filled out claims forms for CRC and Redevelopment Department invoices to be submitted to the Clerk-Treasurer's office. Lee 04/19/2013 0.50 75.00 37.50 Contacted several vendors RE: payment status of invoices and to request contracts and altering of invoices. Lee 04/22/2013 0.25 75.00 18.75 Discussed claims with Les Olds. Lee 04/22/2013 0.50 75.00 37.50 Prepared claims and contracts for submission to Clerk-Treasurer. Lee 04/22/2013 1.50 75.00 112.50 Input remaining invoices into CRC computer database. Lee 04/23/2013 0.25 75.00 18.75 Reviewed emails RE: Shapiro's property. Lee 04/24/2013 0.25 75.00 18.75 Responded to emails from Vicki Sponcil RE: vendor pay applications to be delivered to CRC. Lee 04/26/2013 0.25 75.00 18.75 Responded to emails from CRC staff RE: vendor payment inquiries and contracts. Lee 04/29/2013 0.25 75.00 18.75 Discussed which contracts are still need to be submitted to the Clerk-Treasurer's office. Lee 04/30/2013 0.25 75.00 18.75 Responded to vendor payment inquiries and logistics for check mailings. 24.75 2,855.00 Subtotal-Financial Advisory-General Lee 04/10/2013 1.00 75.00 75.00 Researched bank statements for Arts District Lofts and Shoppes bonds. Looked at developer agreement. Discussed scenarios with Bob Reynolds. Computed what is expected to be passed on to the developer from 2013 TIF i collections. Lee 04/10/2013 1.25 75.00 93.75 Reviewed TIF analysis for Meridian and Main TIF area. Looked at developer agreement. Computed what is expected to be passed on to the developer from 2013 TIF collections. Lee 04/10/2013 1.25 75.00 93.75 Researched bank statements for Parkwood East and Parkwood West. Looked at developer agreement. Discussed scenarios with Bob Reynolds. Computed what is expected to be passed on to the developer from 2013 TIF collections. Lee 04/10/2013 1.50 75.00 112.50 Reviewed TIF billing report provided by Hamilton County Auditor. Extracted Carmel TIF amounts to see what can be anticipated for 2013 collections. Lee 04/22/2013 0.25 75.00 18.75 Contacted trustee for Taxable Economic Development Revenue Bonds, Series 2011 (Indiana Spine Group Project) RE: invoice. Higgins 04/22/2013 0.75 325.00 243.75 Meridian and Main-follow-ups with Sandy/Cindy and Mike Lee re:2012 calculation correction and related matters. Higgins 04/23/2013 0.25 325.00 81.25 Follow-ups with Mike Lee re: Indiana Spine Group/Meridian and Main EDA. London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 4 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/2312013 0.25 75.00 18.75 Sent email to Cindy Sheeks and Sandy Johnson RE: Huntington invoice for calculation error. Reynolds 04/24/2013 1.75 80.00 140.00 Reviewed the CRC TIF Ledger. The Ledger was not calculating correctly. Went through the formulas to find the error and updated. Lee 04/24/2013 4.25 75.00 318.75 Revised TIF Register through March 31 st, 2013. Organized TIF register for distribution. Reynolds 04/25/2013 0.50 80.00 40.00 TIF Ledger-Reviewed the updated TIF Ledger from Mike. Lee 04/25/2013 3.00 75.00 225.00 Revised TIF register for each individual TIF district from January 2012 through March 2013. Higgins 04/25/2013 0.25 325.00 81.25 Follow-up with Jamie Browning re: status of the correction of the 2012 payments for the Indiana Spine Group. Higgins 04/25/2013 0.25 325.00 81.25 Meridian and Main-follow-up with Cindy re: payment of the Meridian and Main correction. Follow-up with Mike Lee re: same for posting to the detailed TIF register. Lee 04/26/2013 0.25 75.00 18.75 Discussions with Ben Roeger and Andy Mouser RE: property taxes for Office Building and whether they were included in 2013 TIF projections. Lee 04/26/2013 0.50 75.00 37.50 Discussion with Lee Graham and research RE: Office Building property taxes and 2013 TIF collections. Lee 04/26/2013 0.50 75.00 37.50 Revised CRC TIF register. 17.75 1,717.50 Subtotal-Financial Advisory-TIF Lee 04/08/2013 1.00 75.00 75.00 Prepared revised 2013 budget for review by CRC commissioners. Lee 04/09/2013 0.25 75.00 18.75 Updated revised budget and sent on to Les Olds for changes. Lee 04/09/2013 0.50 75.00 37.50 Discussed budget revisions with Ben Roger, Les Olds and Matt Worthley. Updated budget and forecast accordingly. Lee 04/12/2013 1.50 75.00 112.50 Updated revised 2013 budget based on new invoices and updated 2013 forecast. Changed beginning balance to reflect real balance. Updated TIF revenue to reflect payment in April for 2012 back payment for Meridian and Main developer bond that was approved at February meeting. Lee 04/23/2013 0.25 75.00 18.75 Contacted Ben Roeger to clarify how much the 4CDC plans on forwarding to the CRC for net office rents and why. 3.50 262.50 Subtotal-Financial Advisory-Budgets Lee 04/05/2013 1.50 75.00 112.50 Attended meeting at CRC offices to review budget and priority for budget line items. Lee 04/05/2013 1.50 75.00 112.50 Prepared for meeting at CRC offices. Discussed construction budget with Les Olds. Made several revisions of CRC forecast to present at meeting. Lee 04/1012013 0.25 75.00 18.75 Emailed Meridian and Main bond trustee RE: letter needed in order to make catch-up payment. London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 5 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 04/10/2013 1.00 80.00 80.00 Developer Bond-Went over developer bond payoff amounts with Mike Lee. Discussed both Parkwood Bonds and Merchants Square.Also discussed how to allocate the funds that will be owed to the Indiana Spine Group for the Meridian and Main TIF Collections. Lee 04/11/2013 0.25 75.00 18.75 Researched CRC payment records for Horning Roofing invoice that they claim was not paid. Records show it was paid. Lee 04/11/2013 0.75 75.00 56.25 Researched CRC payables and receivables records for Shapiro's information requested by CRC staff. Higgins 04/24/2013 0.25 325.00 81.25 Retrieve message and return call to Jim Rush re: availability to meet with Pedcor representatives to discuss CRC matters. Lee 04/30/2013 0.25 75.00 18.75 Discussed PAC roof settlements summary with Jim Higgins. 5.75 498.75 Subtotal-Financial Advisory-Special Projects Lee 04/01/2013 2.00 75.00 150.00 Looked at several different scenarios for funding Illinois Street project. Read through North Illinois Street Economic Development Plan. Created forecast that shows amounts that could fund project with assumptions. Lee 04/01/2013 0.25 75.00 18.75 Looked up status of check for vendor and email Clerk's office for status of mailing check. Lee 04/02/2013 0.50 75.00 37.50 Searched for paid invoices report for specific vendor in CRC database and in Clerk-Treasurer files. Lee 04/03/2013 0.25 75.00 18.75 Called Wells Fargo RE: check received for reimbursement of a supposed double payment. Discussed check with Clerk-Treasurer's office. Lee 04/03/2013 0.25 75.00 18.75 Called Computer Ease software company for problems with accessing records. Lee 04/03/2013 0.50 75.00 37.50 Called several vendors RE: invoices, statements and outstanding amounts due or not due. Lee 04/03/2013 0.25 75.00 18.75 Delivered checks to Clerk-Treasurer for deposit. Lee 04/08/2013 0.25 75.00 18.75 Delivered claims to Clerk-Treasurer's office. Lee 04/08/2013 0.50 75.00 37.50 Prepared Redevelopment Department claims for submission. Lee 04/09/2013 0.25 75.00 18.75 Responded to emails RE: revising CRC budget for 2013. Lee 04/09/2013 0.25 75.00 18.75 Emailed reminders to Cindy Sheeks, City Hall, Police Department and Fire Department that monthly energy consumption payments will be transferred. Lee 04/11/2013 0.50 75.00 37.50 Reviewed expenditure audit trail to date for the Redevelopment Department. Based on given information, created spreadsheet reflecting current balances and percentages of budget remaining. Lee 04/11/2013 0.25 75.00 18.75 Researched for checks that should have been deposited on April 3rd in CRC's 902 fund. Emailed copies of checks to Clerk-Treasurer's office. Lee 04/11/2013 0.25 75.00 18.75 Delivered check to Clerk-Treasurer's office. Lee 04/1212013 0.25 75.00 18.75 Reviewed emails RE: Shapiro's payments Lee 04/15/2013 0.25 75.00 18.75 Reviewed email from Les Olds RE: moving of records to Clerk-Treasurer. London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 6 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/15/2013 0.50 75.00 37.50 Reviewed and responded to emails RE: Computer Ease invoice and overpayment to Horning Roofing in 2011. Sent bank records information to Dave Burchard at Shiel Sexton RE: Horning Roofing overpayment. Lee 04/17/2013 1.00 75.00 75.00 Reviewed new CRC invoices. Looked into new construction pay applications. Sent email to Brandon Bogan RE: adjustments that need to be made to pay application for payments. Discussed payment of invoices and contracts with Les Olds and Matt Worthley. Lee 04/17/2013 1.50 75.00 112.50 Reviewed CRC property tax bills. Researched parcel numbers. Looked at transfer history to make sure the CRC is liable for each of the tax bills. Created spreadsheet listing all of this information and made comments for questions and concerns. Discussed spreadsheet with Jim Higgins. Lee 04/18/2013 0.25 75.00 18.75 Discussed CRC contracts with Les Olds and what is still needed for the Clerk-Treasurer's records. Lee 04/18/2013 0.25 75.00 18.75 Sent email to Ryan Wilmering RE: CRC property tax bills. Lee 04/19/2013 0.25 75.00 18.75 Created April invoice for Club Canine's portion of utility costs. Lee 04/22/2013 0.25 75.00 18.75 Delivered CRC and Redevelopment Department claims and checks to the Clerk-Treasurer's office. Lee 04/22/2013 0.25 75.00 18.75 Wrote claims for new invoices. Lee 04/22/2013 0.25 75.00 18.75 Contacted vendor RE: invoice and what was still needed in order to receive payment. Lee 04/23/2013 0.25 75.00 18.75 Had conversation with Vicki Sponcil RE: pay applications from vendors previously paid by installment purchase contracts. Lee 04/23/2013 0.25 75.00 18.75 Had conversation with someone from County Assessor's office RE: CRC property taxes. They agreed several of the parcels were classified wrong and sent out revised tax bills. Lee 04/23/2013 0.25 75.00 18.75 Responded to email from Matt Worthley RE: payment inquiry to vendor. Lee 04/23/2013 0.25 75.00 18.75 Communicated with 2012 Bond trustee RE: payment of invoice from bond proceeds and movement of remaining balance to sinking fund. Lee 04/23/2013 1.25 75.00 93.75 Reviewed changes on Hamilton County's website for CRC's property tax information. Reviewed transfer history reports for parcels in question. Put together questions and emailed them to county assessor. Lee 04/24/2013 0.25 75.00 18.75 Called vendor RE: contract that is needed in order to pay invoices through Clerk-Treasurer. Lee 04/24/2013 0.25 75.00 18.75 Scanned and emailed vendor invoice to Les Olds with instructions to pay it out of 2012 bond proceeds. Lee 04/24/2013 0.25 75.00 18.75 Emailed property tax bill for 4CDC as well as other 4CDC bills to Ben Roger. Lee 04/24/2013 0.50 75.00 37.50 Created claims for property tax bills. Scanned copies into CRC computer database. Lee 04/25/2013 0.25 75.00 18.75 Emailed vendor RE: inquiring about contract that is needed in order to pay invoices. Lee 04/26/2013 0.50 75.00 37.50 Reviewed all claims not submitted due to lack of contract on file. Put list together for CRC staff to assemble. Lee 04/29/2013 0.25 75.00 18.75 Checked CRC emails for issues and forwarded information on to CRC staff. London Witte Group,LLC April 2013 Billing Detail Carmel Redevelopment Commission 7 of 7 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 04/30/2013 1.00 75.00 75.00 Researched bank statements for Merchants Square bonds and updated redemption/defeasance analysis for the Commission. 16.75 1,256.25 Subtotal-Financial Advisory-Other 94.75 10,245.00 Total Invoice Summary: 3,353.75 Operating 6,891.25 Non-Operating 10,245.00 Total 0 I Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.201(Rev.1995) CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. Payee LAO V-Se l rtct.P Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) �_3u-13 Q-51)7 Total o �.Z S 1 hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I have audited same in accor- dance with IC 5-11-10-1.6. , 20 Clerk-Treasurer VOUCHER NO. WARRANT NO. ALLOWED 20 Lf)ji�t)� �'Y )t�c 6roaP - IN SUM OF $ ON ACCOUNT OF APPROPRIATION FOR g02.1g3q6386 Board Members PO#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), or 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 .7-2-U— 2013 Zga7n! ature Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund LONDON LWGWITTE GROUP City of Carmel Client No: 715.001 Clerk-Treasurer Date: 0413012013 One Civic Square Invoice No: 25915 Third Floor Carmel, IN 46032 For services rendered as detailed in the attached summary. $ 1,543.75 Current Amount Due $ 1,543.75 Certified Public Accountants 1776 N. Meridian Street, Suite 500 Indianapolis, Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I London WitteGroup.com London Witte Group, LLC April 2013 Billing Detail City of Carmel 715.001 Hourly Employee Date Hours Rate Invoice Memo Lee 4/10/2013 0.50 75.00 37.50 Meeting with Jim Higgins RE: outstanding issues for Clerk-Treasurer. Lee 4/10/2013 0.50 75.00 37.50 Searched for line of credit and installment purchase contract close-out documents. Forwarded information to Clerk-Treasurer. Higgins 4/10/2013 0.75 325.00 243.75 Meetings with Mike Lee (before and after meeting with Diana and Cindy) to review open and outstanding items associated with the transition. Higgins 4/10/2013 1.75 325.00 568.75 Prepare for and meet with Diana and Cindy to review progress and open/outstanding items in the CRC transition. - ---- Lee 4/10/2013 0.25 75.00 18.75 Emailed Ben Roeger RE: Harris Bank and Lake City Bank 4CDC obligations that were paid off with 2012 Refunding Bond. Forwarded information to Clerk- Treasurer. Lee 4/15/2013 0.25 75.00 18.75 Emailed Ryan Wilmering for warranty deeds and settlement statements for proof that land sale contracts were paid off. Forwarded information to Clerk-Treasurer. Lee 4/18/2013 0.50 75.00 37.50 Scanned invoices and approval sheets for CDs. Made CDs and copies of CRC Financial Information Packets for City Councilors and Clerk-Treasurer. Lee 4/18/2013 0.25 75.00 18.75 Delivered CRC Financial Information Packets and CDs to Clerk-Treasurer's office. Lee 4/18/2013 0.25 75.00 18.75 Created spreadsheet containing all wiring instructions for CRC debt obligations and developer bonds. Lee 4/22/2013 0.25 75.00 18.75 Conversation with Clerk-Treasurer RE: payoff items still needed and 2011 CRC claims. Lee 4/24/2013 0.25 75.00 18.75 Delivered first half of 2011 CRC claims to Clerk- Treasurer's office. Lee 4/24/2013 3.00 75.00 225.00 Separated out first half of CRC 2011 claims. Alphabetized and boxed up claims to be delivered to Clerk- Treasurer's office. Lee 4/29/2013 2.50 75.00 187.50 Assembled second half of 2011 CRC claims for the Clerk- Treasurer. Lee 4/29/2013 0.25 75.00 18.75 Delivered second half of 2011 CRC claims to Clerk- Treasurer. Lee 4/29/2013 0.50 75.00 37.50 Discussions with bank representative, Ryan Wilmering and Heidi Amspaugh RE: Community Bank payoff statement. Lee 4/29/2013 0.25 75.00 18.75 Emailed two banks for payoff letters for Clerk-Treasurer files. Lee 4/30/2013 0.25 75.00 18.75 Reviewed payoff letters from Community Bank and United Fidelity Bank. Forwarded letters to Clerk-Treasurer. 12.25 1,543.75 Total Due This Invoice. Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.201(Rev.1995) CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. II 11 '1�.Payee W Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) S (5 Total I 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 Clerk-Treasurer VOUCHER NO. WARRANT NO. ALLOWED 20 IN SUM OF $ (Kjb(sl $ ON ACCOUNT OF APPROPRIATION FOR T � s Board Members PO#or INVOICE NO. ACCT#!TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), or 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 0 Signature Cost distribution ledger classification if Title claim paid motor vehicle highway fund