The URL can be used to link to this page

Home My WebLink About219404 04/24/2013 CITY OF CARMEL, INDIANA VENDOR: 00351455 Page 1 of 1 s`i ONE CIVIC SQUARE LONDON WITTE GROUP LLC CHECK AMOUNT: $3,960.46 �a CARMEL, INDIANA 46032 ONE AMERICAN SQUARE 1776 N MERIDIAN STREET SUITE 500 CHECK NUMBER: 219404 INDIANAPOLIS IN 46202 CHECK DATE: 4/24/2013 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 902 4340300 25822 998 . 75 ACCOUNTING FEES 1701 4340300 25824 2, 880 . 46 ACCOUNTING FEES 601 5023990 25827 81 . 25 OTHER EXPENSES LWGWITTE GROUP Carmel Water Utility Client No: 1002.005 760 3rd Avenue SW Date: 0313112013 Suite 110 Invoice No: 25827 Carmel, IN 46032 For services rendered as detailed in the attached summary. $ 81.25 Current Amount Due $ 81.25 Certified Public Accountants 1776 N. Meridian Street, Suite 500 Indianapolis, Indiana 46202 Telephone 1 317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.com London Witte Group, LLC March 2013 Billing Detail Carmel Water Utility 1002.005 Hourly Employee Date Hours Rate Invoice Memo Higgins 3/8/2013 0.25 325.00 81.25 Prepare for an speak with John and Carol re: refunding opportunities associated with the 2008 Water Revenue Bonds and related matters. 0.25 81.25 Total Due This Invoice. Prescribed by State Board of Accounts City Form No.201 (Rev 1995) ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show, kind of service, where performed, dates of service rendered, by whom, rates per day, number of units, price per unit, etc. Payee 00351455 LONDON WITTE GROUP Purchase Order No. 111 Monument Circle, Ste 4700 Terms Indianapolis, IN 46204 Due Date 4/22/2013 Invoice Invoice Description Date Number (or note attached invoice(s) or bill(s)) Amount 4/22/2013 25827 $81.25 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 Date Officer VOUCHER # 131456 WARRANT # ALLOWED 00351455 IN SUM OF $ LONDON WITTE GROUP 111 Monument Circle, Ste 4700 Indianapolis, IN 46204 Carmel Water Utility ON ACCOUNT OF APPROPRIATION FOR Board members PO# INV# ACCT# AMOUNT Audit Trail Code 25827 01-6320-08 $81.25 Voucher Total $81.25 Cost distribution ledger classification if claim paid under vehicle highway fund LONDON LWGWITTE GROUP City of Carmel Client No: 715.001 Clerk-Treasurer Date: 0313112013 One Civic Square Invoice No: 25824 Third Floor Carmel, IN 46032 For services rendered as detailed in the attached summary. $ 2,880.46 Current Amount Due $ 2 880.46 i Certified Public Accountants 1776 N. Meridian Street, Suite 500 Indianapolis, Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.coin London Witte Group, LLC March 2013 Billing Detail 1 of 2 City of Carmel 715.001 Hourly Employee Date Hours Rate Invoice Memo Lee 3/6/2013 0.50 75.00 37.50 Had final former installment purchase contract disbursements signed. Met with Vicki Sponcil and Dolores Krohne with Village Financial RE: close-out of installment purchase contract accounts. Lee 3/6/2013 0.50 75.00 37.50 Prepared checks and letters for Clerk-Treasurer. Delivered checks and letters to Clerk-Treasurer. Higgins 3/6/2013 0.50 325.00 162.50 Return call (message) with Dave Bowers re: transition and related matters; follow-up with Mike Lee re: same. Lee 3/8/2013 0.50 75.00 37.50 Responded to emails RE: closing out of Regions. installment purchase account, W-9 needed to release checks and vendor payment inquiry. Lee 3/11/2013 0.50 75.00 37.50 Picked up checks from CRC and Pedcor to be deposited. Submitted Redevelopment Department claims and checks. Lee 3/12/2013 0.25 75.00 18.75 Emailed copy of CRC Regions account to Clerk- Treasurer. Mailed original to Clerk-Treasurer's office. Lee 3/13/2013 0.25 75.00 18.75 Reviewed reimbursement spreadsheet for XceIHR payments and sent email to Cindy Sheeks to clarify what was paid by the employer. Lee 3/14/2013 0.25 75.00 18.75 Delivered last installment purchase funds check to the Clerk-Treasurer. Lee 3/19/2013 0.25 75.00 18.75 Sent spreadsheet of energy consumption monthly payments for City buildings to Cindy Sheeks. Lee 3/19/2013 0.25 75.00 18.75 Responded to emails RE: credit of XceIHR payments and clarifications on deductions. Lee 3/21/2013 0.25 75.00 18.75 Delivered CRC financial information packets and claims to Clerk-Treasurer. Lee 3/21/2013 0.50 75.00 37.50 Prepared CRC packets for City Councilors and Clerk- Treasurer. Higgins 3/21/2013 0.25 325.00 81.25 Review and respond to email from the Clerk-Treasurer re: request for meeting. Higgins 3/25/2013 0.25 325.00 81.25 Email follow-up and schedule meeting with Diana and Cindy re: various City/CRC matters. Reynolds 3/27/2013 1.50 80.00 120.00 TIF Register- Reviewed the TIF Register to make sure the register was ready for the 2012 Audit. Higgins 3/27/2013 1.75 325.00 568.75 Prepare for and meet with Diana and Cindy at City Hall to review CRC transition matters. Lee 3/28/2013 4.25 75.00 318.75 Reviewed entire 2012 check register. Researched all outstanding checks for confirmation that they were voided. Corrected any errors or omissions. Made sure balances were correct. Checked debt service schedules lined-up with check reqister. Lee 3/28/2013 0.25 75.00 18.75 Gathered requested bank statements and vendor listing. Reynolds 3/28/2013 1.00 80.00 80.00 CRC - Met with Mike Lee to go over the items that he will need to prepare in order to prepare for the upcoming SBOA audit. Lucas 3/28/2013 - 0.46 Postage London Witte Group, LLC March 2013 Billing Detail 2 of 2 City of Carmel 715.001 Hourly Employee Date Hours Rate Invoice Memo Higgins 3/28/2013 0.25 325.00 81.25 Emails with Luci and Rick re: transition related items - transactional documents and related matters. Higgins 3/28/2013 1.00 325.00 325.00 Audit-follow-up with email from Lori Danford (SBOA) re: initial request for information audit related documents; meet with Bob Reynolds and Mike Lee re: same. Lee 3/29/2013 0.25 75.00 18.75 Uploaded Regions, Star and Harris bank statements requested for audit. Lee 3/29/2013 0.25 75.00 18.75 Began updating TIF register for audit. Lee 3/29/2013 1.00 75.00 75.00 Updated Harris Bank reconciliation for calendar year --Lee 3/29/2013 4.50 75.00 337.50- Thoroughly checked Regions debt service payments and tied all principal and interest payments back to schedules and explanations for variances. Checked Mercantile debt service payments and tied all principal and interest payments back to schedules. Backed out all Village Financial fees from debt service payments. Revised several other debt sections and formatting issues. Updated December check numbers. Checked several invoices for explanations. Updated 2012 check register and December bank reconciliation. Reynolds 3/29/2013 1.00 80.00 80.00 Audit- Met with Mike to go over questions about how debt related items should be shown in the Regions Ledger. Lee 3/29/2013 1.50 75.00 112.50 Updated Star Bank reconciliation for calendar year 2012. Lee 3/29/2013 0.25 75.00 18.75 Created list of debt obligations that were refunded with 2012 bond. Higgins 3/29/2013 0.25 325.00 81.25 Audit- Follow-up with Bob Reynolds re: audit related matters. 24.00 2,880.46 Total Due This Invoice. Prescribed by State Board of Accounts City Form No.201(Rev.1995) ACCOUNTS PAYABLE VOUCHER 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 Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 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 $ ON ACCOUNT OF APPROPRIATION FOR Board Members Po#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), or �j =9-ju- 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 20 Signature Cost distribution ledger classification if Title claim paid motor vehicle highway fund LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W. Main Street Date: 0313112013 Suite 220 Invoice No: 25822 Carmel, IN 46032 For services rendered as detailed in the attached summary. Operating $ 4,737.50 Non-Operating 998.7 Current Amount Due $ 5.736.25 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 March 2013 Billing Detail 1 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 03/01/2013 0.25 75.00 18.75 Responded to email RE: payments made to vendor in 2012 and over the course of CRC history. Talked with Matt Worthley RE: same issue. Lee 03/06/2013 0.25 75.00 18.75 Sent January Energy Center invoices and spreadsheet to Dave Bowers and Jim Higgins for review. Carney 03/20/2013 0.25 70.00 17.50 Printed monthly information from e-mails that Jim sent to me for meeting. Subtotal -Financial Advisory -Finance 0.75 55.00 Committee Lee 03/15/2013 6.00 75.00 450.00 Prepared monthly packets for commissioners. Prepared invoices and cover sheets for meeting. Updated the monthly forecast, expenditure/revenue analysis and summary of cash rights for packets. Subtotal - Financial Advisory -Financial 6.00 450.00 Dashboard Lee 03/01/2013 0.25 75.00 18.75 Reviewed and responded to emails RE: available excess funds from tax-exempt portion of 2012 bond, claims yet to be paid, Shapiro's check, Xcel breakout of expenses for CRC consultants. Lee 03/04/2013 0.25 75.00 18.75 Phone call with Vicki Sponcil RE: former installment purchase contract documents. Lee 03/04/2013 0.50 75.00 37.50 Responded to emails RE: installment purchase f contract payoff amounts, letter from Regions Bank I and remaining balance for former installment purchase contracts with Village Financial. Lee 03/05/2013 0.25 75.00 18.75 Phone call and emails with Ben Roeger RE: payment from 4CDC to CRC, outstanding vendor payments and line of credit letter. Lee 03/05/2013 0.25 75.00 18.75 Phone call RE: meeting with Clerk Treasurer and file transfers. Lee 03/05/2013 0.50 75.00 37.50 Reviewed and responded to emails RE: payoff amounts for Regions at bond closing, checks for vendor, Party Time assessed value, Shapiro's checks and City Council meeting. Lee 03/06/2013 0.25 75.00 18.75 Reviewed CRC emails for invoices and issues. Lee 03/06/2013 0.25 75.00 18.75 Phone conversations with Jim Higgins RE: 4CDC money, CRC contracts with vendors, files to go over to Clerk's office. London Witte Group, LLC March 2013 Billing Detail 2 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 03/06/2013 1.00 75.00 75.00 Discussions with Les Olds and Matt Worthley RE: energy center invoices, budget revisions, claims, contracts, installment purchase contract files, installment purchase contract account close-outs and files to be taken over to the Clerk-Treasurer. Lee 03/06/2013 0.75 75.00 56.25 Reviewed CRC invoices and made notes for issues. Lee 03/08/2013 1.50 75.00 112.50 Preparation for March 9th meeting. Lee 03/09/2013 2.00 75.00 150.00 Attended joint meeting between CRC, City Council and 4CDC on Saturday, March 9th. Lee 03/11/2013 0.25 75.00 18.75 Reviewed CRC emails for issues. Lee 03/11/2013 2.75 75.00 206.25 Reviewed Redevelopment Department invoices. Called vendors with issues. Researched for contracts needed to submit claims. Prepared claims for submission. Made copies of contracts and claims. Lee 03/14/2013 0.25 75.00 18.75 Reviewed CRC emails for invoices and issues. Contacted vendor for additional invoice. Lee 03/14/2013 2.00 75.00 150.00 Sorted through CRC and Redevelopment Department invoices and contacted vendors with issues. Researched any invoices with problem. Talked with Matt Worthley RE: any issues involving invoices. Lee 03/14/2013 2.50 75.00 187.50 Copied and scanned all invoices. Input invoices into cover sheets for CRC monthly meeting. Made cover sheets for specific vendors. Scanned any large invoices for CRC electronic commissioner packets. Lee 03/15/2013 2.50 75.00 187.50 Input all CRC invoices into computer database. Filled out claims forms for all CRC invoices. Created spreadsheet of contracts needed in order to submit all claims for next cycle. Lee 03/19/2013 0.25 75.00 18.75 Contacted vendor to request explanation for invoices. Higgins 03/20/2013 1.00 325.00 325.00 Prepare for Redevelopment Commission meeting. Higgins 03/20/2013 0.75 325.00 243.75 Prepare for and attend CRC monthly meeting. Lee 03/20/2013 2.25 75.00 168.75 Attended CRC executive session meeting and CRC public meeting for March. Higgins 03/20/2013 1.50 325.00 487.50 Attend CRC Executive Session. Lee 03/20/2013 1.75 75.00 131.25 Filled out claims forms for Carmel Redevelopment Department and Carmel Redevelopment Commission and had them signed. Lee 03/20/2013 1.50 75.00 112.50 Input invoices into CRC computer database. Lee 03/20/2013 0.50 75.00 37.50 Printed off documents and reviewed information in preparation for CRC monthly meeting. Lee 03/21/2013 2.25 75.00 168.75 Prepared claims for submission to Clerk-Treasurer. Prepared invoice to Club Canine for share of utilities. Searched for and compiled list of contracts needed to pay vendors. Lee 03/25/2013 0.25 75.00 18.75 Responded to email from Matt Worthley RE: vendor audit confirmation letter. London Witte Group, LLC March 2013 Billing Detail 3 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 03/26/2013 0.25 75.00 18.75 Responded to email from Matt Worthley RE: audit confirmation letter for CRC vendor. Lee 03/26/2013 0.75 75.00 56.25 Phone conversation with Matt Worthley and Dave Bowers RE: REI 2012 James Building operating report, Shapiro's operating expenses, Energy Center consumption payments and Travelers claim. Lee 03/28/2013 1.50 75.00 112.50 Reviewed CRC emails and discussed issues with CRC staff. Responded to vendor inquiries. Lee 03/28/2013 1.50 75.0,0 112.50 Reviewed new invoices and returned claims with CRC staff. Researched outstanding claims payment status. Looked into two vendor contract amounts to determine current and future payments. 34.00 3,362.50 Subtotal - Financial Advisory -General Higgins 03/04/2013 0.25 325.00 81.25 Meridian and Main -follow-up with Karl and Jenny re: request for Meridian and Main analysis and related items; follow-up with Mike Lee re: same. Higgins 03/08/2013 0.25 325.00 81.25 Meeting with Mike Lee to review schedules in anticipation of Saturday's planning session/ workshop - City County, CRC, 4CDC. 0.50 162.50 Subtotal - Financial Advisory-TIF Lee 03/06/2013 0.50 75.00 37.50 Worked on revising CRC 2013 Budget for March 9th meeting. Started gathering information for extra spreadsheet for March 9th meeting. I Lee 03/06/2013 0.75 75.00 56.25 Copied and scanned final disbursements for former installment purchase contracts. Transferred electronic copies to second folder. Go over what we have with Matt Worthley. Lee 03/07/2013 0.50 75.00 37.50 Worked on updating rent revenue numbers and creating budget talking points for Les Olds. Lee 03/08/2013 2.00 75.00 150.00 Researched City database for current CRC 902 fund balance. Researched 2013 TIF area net assessed value to find estimated 2013 collections. Revised CRC Budget for presentation purposes. Lee 03/21/2013 0.50 75.00 37.50 Attempted to contact REI for information on what Civi and other resident companies owe the CRC. Put together spreadsheet showing all outstanding payments owed to CRC as of March 21, 2013 and . mailed to commissioners and Mayor. Higgins 03/29/2013 0.25 325.00 81.25 Follow-up email from Megan re: cancellation of the 4/4 special meeting re: bid award. 4.50 400.00 Subtotal - Financial Advisory - Special Projects London Witte Group, LLC March 2013 Billing Detail 4 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 03/01/2013 0.50 75.00 37.50 Researched and produced 2012 expenditures for requested vendor. Lee 03/04/2013 0.50 75.00 37.50 Researched CRC database for Party Time Rental property taxes paid. Forwarded information on. Lee 03/12/2013 0.25 75.00 18.75 Communicated with vendor about status of payment and contacted Clerk's office to verify the check had been sent out and why it hadn't arrived. Lee 03/21/2013 0.50 75.00 37.50 Responded to several emails and phone calls RE: Energy Center consumption payments and amounts owed to CRC by resident companies in the James Building. Lee 03/28/2013 0.25 75.00 18.75 Delivered check to Clerk-Treasurer's office. Lee 03/29/2013 0.25 75.00 18.75 Created flow chart RE: office tenant rent revenues. 2.25 168.75 Subtotal - Financial Advisory-Other Higgins 03/09/2013 3.00 325.00 975.00 Prepare for and attend the called meeting of the City Council, Redevelopment Commission and the 4CDC at the Monon Center. 3.00 975.00 Subtotal - Financial Advisory-City Council Higgins 03/06/2013 0.50 325.00 162.50 Conversations with Mike Lee and Dave Bowers re; energy center payments and related matters. 0.50 162.50 Subtotal - Financial Advisory- Energy Center 51.50 5,736.25 Total Invoice Summary: 4,737.50 Operating 998.75 Non-Operating 5,736.25 Total 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. J Payee Lon oh V)h 6 r oup C Purchase Order No. 177 6 .N, &r,1 A 4 r Jul �e 500 Terms I nd��n oils 442.01, Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) s i Total I 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 o h 1r �►/ P (r DUb a ( IN SUM OF $ I'm /V �e ri�i h n A I 5uife S�0 �ndiQn�l�n�iS _ DV 86204- ON ACCOUNT OF APPROPRIATION FOR g0�/�-3�-0303 Board Members PO#or DEPT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s), Z 2 5 2 2, '4-�40301 qq ? 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 20 (3 atu re Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund