Javascript Menu by Deluxe-Menu.com

DescriptionValue
Prepared By IMAN Auditor
Date 04-10-2009
Reviewed By G. Audit Supervisor
Review Date 03-04-2009
Audit Step36
Audit ObjectiveCheck for round numbers in acquisition cost
Data Sourcec:\test\data\EWP.xls
Date Run04-18-09 22:31:07
Table/WorkSheetfa$
Columncost
Commandrn - Extract transactions with a round number
Parameters Used(none)
First Parameter0111111
Where(none)
Second Parameter(none)
SQL usedselect [cost], * from [fa$]
Processing statusNormal process - 4064 rows
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


costTagNoADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
250042191022.870737501477.13500204.5741463ABC7/10/2006A-3900977.137/10/2006 7:52:47 PM
730045492973.34801521904326.651460594.66960294ABC9/30/2004A-89002866.659/30/2004 6:52:15 PM
9000191513302700767018002669ABC1/23/2005A-220058701/23/2005 2:55:23 PM
530032232168.24987615903131.751060433.64997534ABC2/15/2006A-17002071.752/15/2006 5:57:25 AM
3003599121.542753890178.466024.308550775ABC9/11/2006A-500118.469/11/2006 3:11:51 PM
440041821791.79772713202608.2880358.359545410ABC5/15/2007A-65001728.25/15/2007 12:24:05 PM
880025603528.0610926405271.941760705.61221798ABC12/14/2004A-68003511.9412/14/2004 7:01:29 PM
11003549444.0855925330655.9122088.817118511ABC12/10/2006A-1400435.9112/10/2006 6:29:10 PM
7200493857602160144014401089.43ABC6/24/2005A6/5/2007150006/24/2005 7:40:58 PM
950035813855.31058728505644.691900771.062117310ABC5/30/2006A-107003744.695/30/2006 12:50:25 PM
980017113923.80927229405876.191960784.76185447ABC11/23/2006A-186003916.1911/23/2006 1:45:03 AM
470036031912.56889314102787.43940382.51377867XSF1/24/2006A-58001847.431/24/2006 8:52:00 PM
310034661264.5478479301835.45620252.90956949XSF8/1/2006A-64001215.458/1/2006 6:10:01 PM
620034352502.74874518603697.251240500.5497494DSR7/17/2006A-95002457.257/17/2006 8:11:31 AM
280036331134.4630798401665.54560226.89261598DSR3/21/2005A-36001105.543/21/2005 3:36:19 AM
740030992976.6251922204423.371480595.3250386ABC5/26/2006A-151002943.375/26/2006 3:29:53 PM
880019063583.999874264052161760716.79997496ABC2/12/2005A-1610034562/12/2005 7:12:24 AM
860029623506.46030725805093.541720701.29206157FGT5/11/2007A-154003373.545/11/2007 6:08:33 PM
960028243902.53236228805697.471920780.506472411FGT5/13/2005A-189003777.475/13/2005 12:09:59 PM
costTagNoADReplaceBookvalSalvageDeprLifeLocationAcqDateAccodeDispDateRepCostAcquisitionADATE
17004892684.10949775101015.89340136.82189955ABC7/4/2006A-1100675.897/4/2006 11:50:59 AM
450035381831.13587913502668.86900366.22717595AB2/16/2005A-30001768.862/16/2005 8:33:37 AM
910026933661.70260327305438.31820732.34052066GHF12/1/2006A-85003618.312/1/2006 7:03:49 AM
9600282050692880453119201013.84GHF3/24/2006A-220026113/24/2006 5:26:13 PM
9002123361.8731716270538.1318072.374634316ABC10/15/2005A-1300358.1310/15/2005 5:14:40 PM
410028701643.01912412302456.98820328.60382483ABC12/6/2004A-63001636.9812/6/2004 7:57:01 AM
520024952094.80879215603105.191040418.961758411ABC6/28/2006A-55002065.196/28/2006 7:34:54 PM
430012911733.89670412902566.1860346.779340712ABC12/16/2004A-66001706.112/16/2004 1:50:35 AM
860019853514.73920325805085.261720702.94784063JHT12/27/2006A-114003365.2612/27/2006 11:37:14 AM
850036573459.45842425505040.541700691.891684811ABC2/12/2007A-66003340.542/12/2007 3:26:25 AM
780019743167.5882623404632.411560633.5176525ABC4/9/2006I-169003072.414/9/2006 2:47:41 PM
910042723708.30463927305391.71820741.66092779ABC12/28/2004A-65003571.712/28/2004 12:03:57 AM
780033226240234015601560625.47846435ABC10/7/2004A-9500010/7/2004 8:08:37 AM
17003781694.57122945101005.43340138.91424598ABC3/2/2007A-2700665.433/2/2007 12:50:43 PM
940014133808.79678928205591.21880761.75935788ABC4/25/2007A-124003711.24/25/2007 6:26:07 AM
890020573568.42230526705331.581780713.6844618ABC10/4/2005A-125003551.5810/4/2005 4:01:14 AM
500034792034.156715002965.841000406.831343ABC5/29/2007A 71001965.845/29/2007 11:54:34 PM


Lead Work Sheet

Electronic Workpaper index