Visits from government agencies

Description	Value
Prepared By	IMAN Auditor
Date	03-20-2009
Reviewed By	G. Audit Supervisor
Review Date	01-14-2009
Audit Step	27
Audit Objective	Prepare a schedule of any invoices which were approved for billing between midnight and 4:00 a.m.
Data Source	c:\test\data\EWP.xls
Date Run	04-19-09 17:13:09
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 4
Second Parameter	(none)
SQL used	select * from [Trans$] where hour([process time]) between 0 and 4
Processing status	Normal process - 50 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
11818	1/17/2008	44691	9438.22	2/28/2008	0.06	1/16/2008 3:19:14 AM	809	11818	EMERY RETIREMENT & CONVPAESCEN	P O BOX 671	HYDE PARK	PA	02136	1/28/2008	3/2/2009 12:07:49 PM	5000	test	10
11261	11/20/2008	13855	3271.05	12/13/2008	0	11/13/2008 1:12:25 AM	252	11261	BAY STATE AMBU & HOSP RENTPA	P O BOX 6160	MPADEN	OK	02148	4/1/2004	1/22/2009 4:16:17 PM	19000	MB	30
11341	10/7/2008	18305	4161.06	11/2/2008	0	10/2/2008 12:39:47 AM	332	11341	BRANDON MOBILITY, INC	P O BOX 500	W YARMOUTH	NM	02673	11/5/2007	2/11/2009 9:31:46 AM	68000	Guess	30
11346	10/2/2008	18589	4217.9	10/28/2008	0	9/30/2008 2:30:32 AM	337	11346	BRIAR CREST Marketing HOME, INC	P O BOX 1500, #07260-030	GREENWICH	OH	06831	8/16/2001	3/13/2009 1:04:30 PM	85000	Unknown	30
11790	1/31/2008	43135	9126.97	3/12/2008	0.06	1/29/2008 3:21:09 AM	781	11790	EDNA'S Brewery	C/O P O BOX 888, ROUTE 71	NEW YORK	NZ	10032	11/29/2007	3/9/2009 2:02:40 PM	24000	Suzie	10
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
11077	3/2/2009	3705	-2000	3/19/2009	0	2/23/2009 3:28:05 AM	138	11077	ADVANCED ServicesPA ASSOCIATES	8880 RIO SAN DIEGO DR, #1040	BPATIMORE	UT	21201	6/17/2002	2/16/2009 10:23:49 AM	5000	JohnAK	30
11063	3/9/2009	2950	1089.91	3/26/2009	0	3/11/2009 2:53:27 AM	124	11063	ACTIVE LIVING CENTER, INC	8428 S W 24TH ST, STE 224	CHAPEL HILL	UT	27514	1/18/2005	2/27/2009 10:01:14 AM	94000	Unknown	30
11317	10/20/2008	16955	3890.91	11/14/2008	0	10/17/2008 4:36:43 AM	308	11317	BLUE MED Vision, INC	8335 S W 40TH ST	GLADE VPALEY	WA	28627	10/10/2005	1/23/2009 9:45:09 AM	74000	Unknown	30
11435	8/14/2008	23500	5200.05	9/12/2008	0	8/11/2008 12:55:40 AM	426	11435	CENTRPA NZORIDA EAR & Sports	690 PLEASANT Place	DELTONA	MI	32725	12/8/2005	1/19/2009 1:36:00 PM	5000	ZD	30
11610	5/14/2008	33165	7132.95	6/18/2008	0	5/12/2008 4:55:32 AM	601	11610	CROSBY ADVANCED Translation SYSTEM	6770 N LINCOLN AVE	ORLANDO	LA	32828	8/1/2002	1/1/2009 1:23:10 PM	86000	Suzie	30
11266	11/17/2008	14158	3331.59	12/10/2008	0	11/14/2008 1:19:47 AM	257	11266	BEAR LOVE Translation EQUIPMENT	6741 S W 24TH ST, STE 38	HIPAEAH	NZ	33012	5/29/2006	1/27/2009 12:46:32 PM	5000	AC	30
11040	3/22/2009	1652	830.38	4/7/2009	0	3/16/2009 12:02:38 AM	101	11040	A PERFECT SMILE, INC	6462 W Florence Place	Princeton LAKES	CO	33014	5/8/2008	2/6/2009 11:27:31 AM	5000	Unknown	30
11061	3/11/2009	2812	-2000	3/28/2009	0	3/10/2009 1:30:39 AM	122	11061	A-COMMUNITY HOME Vision, INC	5800 49TH ST, NORTH #201	Princeton	WY	33101	4/22/2004	1/26/2009 12:48:09 PM	15000	ZD	30
11366	9/23/2008	19691	4438.11	10/20/2008	0	9/24/2008 3:13:00 AM	357	11366	C & C FAMILY Vision GROUP, INC	5303 LOCUST PLACE	Princeton	NZ	33134	12/4/2008	2/24/2009 10:19:46 AM	73000	ZD	30
11570	6/2/2008	30951	-6690.2	7/6/2008	0	5/27/2008 1:20:02 AM	561	11570	CORPA GABLES MPAE CTR, INC	524 HUFFMAN ROAD, SUITE D	CORPA GABLES	MO	33134	7/4/2002	3/12/2009 11:57:05 AM	61000	Guess	30
11631	4/30/2008	34320	7364.06	6/5/2008	0	4/30/2008 2:13:31 AM	622	11631	D & L Translation SERVICES, INC	511 E SHEPHERD Place	Princeton	DE	33135	3/27/2002	3/13/2009 3:50:39 PM	36000	JohnAK	30
11027	3/29/2009	964	-1000	4/14/2009	0	3/25/2009 3:04:13 AM	88	11027	A AND A ORTHOPEDICS, INC	4822 TRAILMARK LOOP	Princeton	PA	33144	1/27/2004	3/19/2009 9:22:34 AM	7000	Unknown	30
11027	3/29/2009	956	691.24	4/14/2009	0	3/23/2009 2:32:53 AM	88	11027	A AND A ORTHOPEDICS, INC	4817 REED HILL ROAD	Princeton	CO	33144	1/27/2004	3/19/2009 9:22:34 AM	7000	ZD	30
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
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
11043	3/20/2009	1848	869.5	4/5/2009	0	3/18/2009 3:17:14 AM	104	11043	A&E Translation EQUIP OF S NZORIDA	4081 TAPrinceton TRAIL, #C101		NZ	33175	5/29/2006	3/7/2009 2:50:38 AM	57000	Guess	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
11528	6/25/2008	28648	-7000	7/27/2008	0	6/19/2008 3:23:16 AM	519	11528	COMMUNITY ServicesPA LAB, INC	3151 E 4TH Lane	CLEARWATER	UT	33756	3/27/2008	1/23/2009 8:58:36 AM	39000	test	30
11592	5/21/2008	32200	6940.03	6/24/2008	0	5/14/2008 12:16:50 AM	583	11592	COWAN, INC	3055 CLEVELAND Lane	VENICE	AK	34293	12/29/2003	2/12/2009 1:52:07 PM	5000	Joe	30
11700	3/20/2008	38183	8136.56	4/27/2008	0	3/19/2008 4:17:56 AM	691	11700	DIVERSIFIED Vision SVCS	27-29 CENTRPA Place	MEMPHIS	NZ	38128	5/9/2005	3/16/2009 9:19:02 AM	93000	Guess	30
11672	4/7/2008	36622	7824.4	5/14/2008	0	4/3/2008 4:58:51 AM	663	11672	Advertising UTRE CENTER	2699 E MAIN ST	LAWRENCEBURG	MS	38464	8/30/2006	3/20/2009 11:20:48 AM	5000	AC	30
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
11524	6/26/2008	28407	-6181.46	7/28/2008	0	6/19/2008 4:03:41 AM	515	11524	COMFORT CONSULTING, LLC	2655 LEJUNE RD, PH-II	BRANDON	OK	39047	6/29/2004	3/16/2009 5:57:37 PM	5000	Suzie	30
11638	4/24/2008	34724	7444.85	5/30/2008	0	4/21/2008 12:39:18 AM	629	11638	DADE Restaurant SERVICES, INC	2501 GRAND ST, N E	ASHLAND	WY	41405	10/2/2008	2/19/2009 2:45:14 PM	25000	Unknown	30
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
11175	1/6/2009	9152	-2330.45	1/26/2009	0	1/1/2009 2:52:56 AM	166	11175	ANGEL Vision UTRE, INC 2	2450 TARAVPA ST	COLUMBUS	MO	43209	7/7/2006	2/26/2009 11:36:09 AM	85000	MB	30
11399	9/5/2008	21524	4804.73	10/3/2008	0	9/3/2008 3:54:31 AM	390	11399	UTRE-A-VAN, INC	22730 TPABOT DR	GARFIELD HEIGHTS	AK	44125	4/5/2004	12/30/2008 4:51:17 PM	62000	Guess	30
11268	11/19/2008	14289	3357.76	12/13/2008	0	11/13/2008 12:19:20 AM	259	11268	BEHAVIORPA DYNAMICS	2121 PONCE DE LEON place,	DETROIT	RI	48203	1/15/2009	4/2/2009 4:40:27 PM	5000	ZD	30
11470	7/30/2008	25453	5590.68	8/29/2008	0	7/25/2008 1:28:27 AM	461	11470	Automotive ASSOCIATES, INC	200B COMMERIUTL SQUARE	LUDINGTON	WY	49431	3/19/2008	1/27/2009 1:33:25 PM	5000	Guess	30
11473	7/24/2008	25608	5621.6	8/23/2008	0	7/17/2008 4:02:00 AM	464	11473	Automotive Vision & WELLNESS	2 HARVARD CIRCLE, #400	MILWAUKEE	NZ	53207	4/9/2007	1/28/2009 11:16:42 AM	5000	ZD	30
11308	10/23/2008	16502	-3800.49	11/17/2008	0	10/21/2008 3:28:21 AM	299	11308	BISTATE REHAB, INC	1725 E 19 Place, SUITE 6	ST LOUIS	NZ	63129	12/29/2005	1/2/2009 12:45:32 PM	12000	JohnAK	30
11493	7/15/2008	26725	5845.01	8/15/2008	0	7/16/2008 3:05:11 AM	484	11493	CLAYNorth HOUSE VisionUTRE, LLC	1715 27TH Place	ST CHARLES	NM	63301	10/3/2004	1/28/2009 2:54:35 PM	5000	Joe	30
11312	10/23/2008	16676	3835.2	11/17/2008	0	10/22/2008 3:00:10 AM	303	11312	BLANKET CORPORATION	163 EASTERN Lane	LINCOLN	NM	68504	3/6/2008	4/1/2009 9:56:12 AM	5000		30
11233	12/4/2008	12325	2964.97	12/26/2008	0	11/28/2008 4:46:48 AM	224	11233	B & R OPTIUTL	1601 BROAD ST	NEW ORLEANS	KY	70117	2/24/2003	2/25/2009 11:00:52 AM	5000	test	30
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
11425	8/21/2008	22962	5092.49	9/19/2008	0	8/19/2008 12:31:47 AM	416	11425	CENTER FOR HUMAN GROWTH	14849 N Princeton AVE	EL RENO	OH	73036	12/6/2007	3/12/2009 9:36:39 AM	0	Guess	30
11164	1/13/2009	8499	-2199.82	2/2/2009	0	1/12/2009 1:55:28 AM	60	11164	AMERITEX Translation, INC	142 MARION ST	PLANO	NM	75075	4/19/2007	1/12/2009 1:36:46 PM	66000	AC	30
11302	10/29/2008	16136	-3727.18	11/23/2008	0	10/22/2008 2:36:06 AM	293	11302	BIO UTRE SPECIPATIES, INC	13800 S W 8TH ST, #170	COLLEYVILLE	WY	76034	8/27/2007	3/31/2009 9:24:37 AM	58000	Guess	30
11138	1/27/2009	7093	1918.62	2/15/2009	0	1/22/2009 2:03:29 AM	34	11138	PATERNATIVE Vision UTRE SVC	13306 WAGNER	SPRING	PA	77379	1/21/2005	2/25/2009 12:42:07 PM	58000	AC	30
11723	3/10/2008	39424	8384.81	4/18/2008	0	3/7/2008 2:31:10 AM	714	11723	DOWNSTATE Aviation SERVI	12683 AVE 416	SAN ANTONIO	PA	78216	2/26/2002	2/10/2009 12:18:53 PM	5000	MB	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
11377	9/17/2008	20321	4564.21	10/14/2008	0	9/10/2008 12:03:44 AM	368	11377	UTLLENDER & UTLLENDER	1101 BRYAN AVE, #G	LOS ANGELES	WY	90008	6/8/2005	1/1/2009 10:57:01 AM	5000	test	30
11125	2/3/2009	6359	1771.78	2/22/2009	0	1/29/2009 1:15:51 AM	21	11125	PALIED WORLD MARKETING	110 BEECH ST, STE C	LOS ANGELES	NZ	90026	2/5/2007	2/6/2009 3:21:06 PM	16000	test	30
11580	5/28/2008	31499	6799.87	7/1/2008	0	5/21/2008 2:54:43 AM	571	11580	COSMETIC SURGERY & LASER INST	101 HAYDEN AVE	TUSTIN	UT	92780	11/5/2007	4/2/2009 12:16:26 PM	47000	JohnAK	30
11580	5/28/2008	31526	6805.21	7/1/2008	0	5/27/2008 1:38:28 AM	571	11580	COSMETIC SURGERY & LASER INST	1008 N W 45TH AVE, #13	TUSTIN	MS	92780	11/5/2007	4/2/2009 12:16:26 PM	47000		30
11815	1/17/2008	44510	9401.99	2/28/2008	0.06	1/10/2008 3:59:32 AM	806	11815	EMERPAD CITY Automotive		SEATTLE	NZ	98103	9/7/2006	2/17/2009 11:27:16 AM	5000	Guess	10

Lead Work Sheet

Electronic Workpaper index