Laserfiche WebLink
. <br />interoffice <br />MEMORANDUM <br />to: Billy Wasson, Ken Roudybush, Hitesh Parekh <br />from: Kier Hartwig <br />subject: Courthouse Square Expenditure Reconciliation <br />date: December 30, 1997 <br />• <br />The above report was completed this morning at l0am and E-mailed to Hitesh by Juris <br />Solovjovs. I am unsure how you thought this project was to be completed on 12/29/97. It was <br />our understanding that we would turn in the report by 12/31/97 to Hitesh. We have <br />approximated that it took 44 hours of staff time to complete this report using the following <br />Fiscal staff: Juris, Carl Pitts, Janet Bradley, Robin Barnes and Eazl Horton. <br />Our department received the request for the reconciliation on 12/18/97 at approximately <br />4pm. Juris visited Ken Kuhns and Company's office at 8:30am on 12/19/97 to get additional <br />backup from them to assist in reconciling the expenditures to their Accountant's Compilation <br />Report of 12/16/97. You will notice that Juris found an error in the Kuhn's report during his <br />detailed analysis, and this item is noted on the end of the Reconciliation report. <br />The following are some of the difficulties we encountered in completing this project. <br />Expenditures for Courtliouse Square were originally chazged to three different funds, 140, 170 <br />and 105. Almost all original chazges to the 140 and 170 funds were transferred to the 105 fund <br />through journal vouchers. There were approximately 90 of these journal vouchers and each one <br />required extensive research because back up data for all journal vouchers are stored at the <br />department level, not at fiscal. Juris spent three hours with Elyn Lyon on researching General <br />Services and Facilities Management journal vouchers. One of the Facilities Management JV's <br />took 2 hours to unravel to discover the check numbers used to pay the expenditures. <br />Suggestions on how to avoid this difficult reconciliation process would be to make sure <br />that all Courthouse Square expenditures (including Facilities Maintenance direct purchases, such <br />as permits, telephone equipment) are charged to the 105 fund and the correct project number so <br />that journal vouchers are not required. If there needs to be an adjustment, we would recommend <br />that complete detail including purchase order numbers, original check numbers and vendor <br />names be included with the journal voucher request. <br />Please let me know if you have any questions. <br />cc: Earl Horton <br />Juris Solovjovs <br />Carl Pitts <br />