Visits from government agencies

Description	Value
Prepared By	IMAN Auditor
Date	04-03-2009
Reviewed By	G. Audit Supervisor
Review Date	02-14-2009
Audit Step	30
Audit Objective	Select all invoices approved by Mary between midnight and 8:00 a.m..
Data Source	c:\test\data\EWP.xls
Date Run	04-19-09 17:13:12
Table/WorkSheet	Trans$
Column	(none)
Command	extract - Extract data based upon criteria specified
Parameters Used	(none)
First Parameter	(none)
Where	hour([process time]) between 0 and 7 and approver = 'Mary'
Second Parameter	(none)
SQL used	select * from [Trans$] where hour([process time]) between 0 and 7 and approver = 'Mary'
Processing status	Normal process - 12 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments

Report Schedule

Customer Number	Invoice Date	Invoice Number	Invoice Amount	Due Date	Terms Percent	Process Time	ID	Customer Number1	Customer Name	ADDRESS	CITY	STATE	Zip Code	Setup Time	Last TranTime	Credit Limit	Approver	Terms Days
11294	11/5/2008	15716	3643.2	11/29/2008	0	11/4/2008 5:21:00 AM	285	11294	BETTER Vision Brewery, INC	C/O 71 MAST RD	cheeseboro	MO	11238	7/22/2004	1/5/2009 9:23:53 AM	5000	Mary	30
11309	10/24/2008	16558	3811.55	11/18/2008	0	10/22/2008 12:31:17 AM	300	11309	BITTENBENDER Automotive	940 N ELM Place	WILKES BARRE	AK	18701	9/16/2003	1/15/2009 10:50:28 AM	5000	Mary	30
11342	10/6/2008	18385	4177.09	11/1/2008	0	10/8/2008 7:57:09 AM	333	11342	BRANDYWINE Brewery	9 North LANE	HOCKESSIN	CO	19707	9/29/2004	1/28/2009 1:26:20 PM	85000	Mary	30
11225	12/10/2008	11902	2880.36	1/1/2009	0	12/9/2008 5:05:49 AM	216	11225	AUGUSTA FOOT CENTER	7520 North 29TH AVE	AUGUSTA	OH	30907	10/17/2007	2/6/2009 2:04:08 PM	5000	Mary	30
11276	11/12/2008	14729	3445.84	12/6/2008	0	11/7/2008 6:34:13 AM	267	11276	BELLEGLADES Services & DIAG CTR	5368 WHISPERING PINE CIRC	Princeton	PA	33132	5/1/2008	1/26/2009 12:34:29 PM	99000	Mary	30
11113	2/10/2009	5710	1641.95	2/28/2009	0	2/4/2009 3:09:03 AM	9	11113	PAERT RestaurantS, INC	4270 PAOMA AVE, #192	Princeton	NZ	33166	3/8/2006	2/4/2009 1:16:09 PM	5000	Mary	30
11756	2/20/2008	41271	8754.28	3/31/2008	0.06	2/14/2008 4:44:27 AM	747	11756	DURAMED, INC	3309 W KENNEDY place	THONOTASASSA	PA	33592	3/21/2005	3/3/2009 3:07:12 PM	5000	Mary	10
11751	2/21/2008	40975	8695.05	4/1/2008	0.06	2/20/2008 3:04:32 AM	742	11751	DUNN Translation, INC	2655 LEJUNE RD, PH-II	GREENWOOD	AK	38930	12/22/2005	3/25/2009 2:48:24 PM	80000	Mary	10
11855	12/27/2007	46748	9849.52	2/8/2008	0.07	12/24/2007 1:29:31 AM	846	11855	EYE UTTCHER OPTIUTL	2501 GRAND Place, N E	BOWLING GREEN	OH	42104	1/11/2007	3/26/2009 2:39:03 PM	59000	Mary	10
11798	1/28/2008	43568	9213.6	3/9/2008	0.06	1/24/2008 6:21:36 AM	789	11798	EL PASO ADDICTION & PSYCHIATRI	1680 MICHIGAN AVE, #800	SPRINGFIELD	UT	65801	8/9/2002	1/23/2009 9:55:37 AM	8000	Mary	10
11245	11/27/2008	13015	3103.05	12/20/2008	0	11/20/2008 6:48:36 AM	236	11245	BPAORAC, INC	14147 U S HWY ONE	DPALAS	NZ	75201	12/24/2003	1/29/2009 11:48:18 AM	5000	Mary	30
11766	2/15/2008	41819	8863.75	3/26/2008	0.06	2/8/2008 4:05:02 AM	757	11766	DYNAMIC WOMEN, LLC	1172 N E 196TH Place	CHEYENNE	UT	82009	3/29/2001	2/12/2009 12:01:53 PM	54000	Mary	10

Lead Work Sheet

Electronic Workpaper index