| Audit Information | | | | | | | | | | | |
| Audit Title | Fixed Assets | | | | | | | | | | |
| Audit Number | 1074 | | | | | | | | | | |
| Audit Period | Fiscal Year Ending 11-30-2008 | | | | | | | | | | |
| Data Source | Audit Step | Audit Objective | Cmd | Table | Where | Column | ColString | Parameter 1 | Parameter 2 | Scheme | Chart Title |
| c:\test\data\EWP.xls | 1 | Provide a total of fully depreciated assets still in use | stat | fa$ | cost = ad | cost | | | | fall | Fully depreciated assets still in use |
| c:\test\data\EWP.xls | 2 | Total the file for cost | stat | fa$ | | cost | | | | spring | Fixed Asset Costs |
| c:\test\data\EWP.xls | 3 | Obtain total accumulated depreciation | stat | fa$ | | ad | | | | summer | |
| c:\test\data\EWP.xls | 4 | Total the file for net book value | stat | fa$ | | (cost - ad) | | | | winter | Fixed Assets - net book value |
| c:\test\data\EWP.xls | 5 | Recalculate straight line depreciation figures by dividing cost by useful life | calc | fa$ | | | | round((cost /life),2) as [Estimated Depreciation] | | | |
| c:\test\data\EWP.xls | 6 | Obtain all acquisitions within the specified date range | daterange | fa$ | | acqdate | | 11/14/2006 | 11/20/2006 | | |
| c:\test\data\EWP.xls | 7 | Stratify asset costs | stratify | fa$ | | cost | | 0 100 200 500 1000 2000 5000 9000 | | pink | Stratified asset costs |
| c:\test\data\EWP.xls | 8 | Test Benford's law | benford | fa$ | | cost | | | | orange | Benford's Law applied to asset costs |
| c:\test\data\EWP.xls | 9 | Obtain total costs for assets acquired during the 2006 fiscal year | stat | fa$ | acqdate between #12-1-2006# and #11-30-2007# | cost | | | | yellow | Asset acquisitions |
| c:\test\data\EWP.xls | 10 | Prepare a schedule of assets acquired during the current fiscal year | extractwhere | faz$ | acqdate between #12-1-2006# and #11-30-2007# | cost | | | | | |
| c:\test\data\EWP.xls | 11 | Prepare a schedule of the ten largest asset costs, in descending order | topn | fa$ | | cost | | 10 | | | |
| c:\test\data\EWP.xls | 12 | Prepare a schedule of the five assets with the least cost, in ascending order | bottomn | fa$ | | cost | | 5 | | | |
| c:\test\data\EWP.xls | 13 | Identify items with a large Net Book Value (over $6,000) | extractwhere | fa$ | (cost - ad) > 6000 | | | | | | |
| c:\test\data\EWP.xls | 14 | Prepare a schedule where the net book value is zero or negative | extractwhere | fa$ | (cost - ad) <= 0 | | | | | | |
| c:\test\data\EWP.xls | 15 | Test for dates outside the audit period (cutoff test). | extractwhere | fa$ | acqdate > #12-1-2008# | | | | | | |
| Data Source | Audit Step | Audit Objective | Cmd | Table | Where | Column | ColString | Parameter 1 | Parameter 2 | Scheme | Chart Title |
| c:\test\data\EWP.xls | 16 | Total fixed asset costs for amounts acquired outside the audit period (cutoff test). | stat | fa$ | acqdate between #11-30-2007# and #12-5-2007# | cost | | | | blue | |
| c:\test\data\EWP.xls | 17 | Prepare a schedule of inter-company asset transfers (identified using location = DSR) | extractwhere | fa$ | location = 'DSR' | | | | | | |
| c:\test\data\EWP.xls | 18 | Extract items with zero or negative cost | extractwhere | fa$ | cost < 0 | | | | | | |
| c:\test\data\EWP.xls | 19 | Prepare a schedule of assets where depreciation exceeds cost | extractwhere | fa$ | ad > cost | | | | | | |
| c:\test\data\EWP.xls | 20 | Prepare a schedule of assets with useful lives or depreciation rates beyond set norms | extractwhere | fa$ | cost > 8000 and life < 6 | | | | | | |
| c:\test\data\EWP.xls | 21 | Prepare a schedule of assets with useful lives exceeding 40 years | extractwhere | fa$ | life > 40 | | | | | | |
| c:\test\data\EWP.xls | 22 | Identify fully depreciated items and assets with a book value less than salvage. | extractwhere | fa$ | (cost - ad) < salvage | | | | | | |
| c:\test\data\EWP.xls | 23 | Obtain a round number summary report for asset costs | rnReport | fa$ | | cost | | | | green | |
| c:\test\data\EWP.xls | 24 | Prepare a schedule of assets installed or acquired on a holiday | holiday | fa$ | | acqdate | | mdy | US | fall | Assets acquired on holidays |
| c:\test\data\EWP.xls | 25 | Prepare a schedule of assets installed or acquired on a weekend (Saturday or Sunday) | wd | fa$ | acqdate > #11-30-2006# | acqdate | | 1000001 | mdy | fall | Asset acquisitions by day of week |
| c:\test\data\EWP.xls | 26 | Check for same location, life, different tag number tag number | ssd | fa$ | | | location, life,cost | | 3 | | |
| c:\test\data\EWP.xls | 27 | Perform Benford's law testing on cost amounts | benford | fa$ | | cost | | F1 | | summer | Asset Cost amounts - Benford's law |
| c:\test\data\EWP.xls | 28 | Test for duplicate tag numbers | duplicates | fa$ | | tagno | location, tagno | | 2 | | |
| c:\test\data\EWP.xls | 29 | Check for numeric sequence gaps in tag numbers | gap | fa$ | | | tagno | | 1 | | |
| c:\test\data\EWP.xls | 30 | Summarize asset costs by location and useful life and review to determine that the amounts are reasonable | summary | fa$ | | cost | location, life | | 2 | | |
| c:\test\data\EWP.xls | 31 | Prepare a schedule of all acquisitions made between 11-2-2005 and 11-17-2005 | daterange | fa$ | | acqdate | | 11-2-2005 | 11-17-2005 | | |
| c:\test\data\EWP.xls | 32 | Check for asset acquisitions indicated as installed on a federal holiday | holiday | fa$ | acqdate > #11-30-2006# | acqdate | | mdy | US | fall | Assets installed on a federal holiday |
| c:\test\data\EWP.xls | 33 | Obtain a summary report of asset acquisitions made on a federal holiday | holidayreport | fa$ | | acqdate | | mdy | US | spring | |
| c:\test\data\EWP.xls | 34 | Identify any assets at location codes which start with AB | fuzzymatch | fa$ | | location | | AB? | | | |
| c:\test\data\EWP.xls | 35 | Prepare a schedule of assets installed within two days of 11-3-2006 | datenear | fa$ | | acqdate | | 11/3/2006 | 2 | | |
| Data Source | Audit Step | Audit Objective | Cmd | Table | Where | Column | ColString | Parameter 1 | Parameter 2 | Scheme | Chart Title |
| c:\test\data\EWP.xls | 36 | Check for round numbers in acquisition cost | rn | fa$ | | cost | | 0111111 | | | |
| c:\test\data\EWP.xls | 37 | Check for same asset tag number, same location, same cost | duplicates | fa$ | | | tagno, location, cost | | 2 | | |
| c:\test\data\EWP.xls | 38 | Test for transactions made between 3 and 6 a.m. | extractwhere | fa$ | hour(adate) between 3 and 5 | | | | | | |
| c:\test\data\EWP.xls | 39 | Compute estimated depreciation for assets with a cost amount > 5000 | calc | fa$ | cost > 5000 | | | round((cost /life),2) as [Estimated Depreciation] | | | Calculated amounts |
| c:\test\data\EWP.xls | 40 | Age acquisitions for the current fiscal year | age | fa$ | acqdate between #1-1-2007# and #12-31-2007# | | [acqdate],[cost] | 6/30/2007 | mdy | Fall | Ageing of Asset Acquisitions |
| c:\test\data\EWP.xls | 41 | Obtain total accumulated depreciation | stat | fax$ | | ad | | | | summer | |
| c:\test\data\EWP.xls | 42 | Stratify asset costs | stratify | fax$ | | costx | | 0 100 200 500 1000 2000 5000 9000 | | pink | Stratified asset costs |
| c:\test\data\EWP.xls | 43 | Recalculate straight line depreciation figures by dividing cost by useful life | calc | fa$ | | | | round((costx /life),2) as [Estimated Depreciation] | | | |
| c:\test\data\EWP.xls | 44 | Test Benford's law | benford | faz$ | | cost | | | | orange | Benford's Law applied to asset costs |
