Accounts Receivable

Audit Number: 1103

Fiscal Year Ending 11-30-2008

Lead Work Sheet

Electronic Workpaper index

When certain audit tests are performed, the system can document these results in the work papers as an automatic by-product of performing the tests. These documents can then be edited using Word or other text editor to indicate the test results, conclusions, add tick marks, etc.

The advantages of electronic work papers include the following:

The starting point for the preparation of electronic work papers is to complete the details of the audit tests to be performed. This is done through "fill in the blanks" on an Excel worksheet and includes information such as type of test to be performed, data source, data elements to be tested, etc.

Once the details have been completed, a series of audit tests to be performed by the system can be started by clicking a button on an Excel worksheet. This will cause the system to perform the analysis, document the results and produce any charts of the results, where applicable.

The next step is for the auditor to review the results of the tests, edit the documents to add conclusions, comments, cross-references, etc. and then store the documents, either as a Word document, HTML or converted to Adobe PDF format.

Although the initial format for this project is to use Excel sheets for inputting testing parameters and performing the audit processing, later versions will use a standard Windows GUI.

Currently there are example audit programs for audit tests in the following areas:

Electronic Work Paper Examples
Application Work Papers Example Input Form
Fixed Assets
Input Form
Payroll
Input Form
Procurement cards
Input Form
Accounts payable
Input Form
General Ledger
Input Form
Expense Reports
Input Form
Inventory Cycle
Input Form
Accounts Receivable
Input Form
Revenue Cycle
Input Form
Payments and Purchases
Input Form
DescriptionValue
Prepared By IMAN Auditor
Date 01-26-2009
Reviewed By G. Audit Supervisor
Review Date 01-27-2009
Audit Step16
Audit ObjectiveSearch for states using a wild card (fuzzy match) Any state beginning with S-T
Data Sourcec:\test\data\EWP.xls
Date Run04-19-09 17:12:57
Table/WorkSheetTrans$
Column(none)
Commandfuzzymatch - Search for transactions using fuzzy match search terms
Parameters Usedstate, *
First Parameter[S-T]?
Where(none)
Second Parameter(none)
SQL usedselect state, * from [Trans$]
Processing statusNormal process - 5032 rows
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
TN114458/11/2008240335306.539/9/200808/13/2008 1:35:32 PM43611445CENTRO EQUIPOS MEDICOSRURPA ROUTE 17, STE 4YAUCO006981/12/20053/12/2009 10:58:37 AM82000AC30
SC1189912/3/200749185-10337.081/17/20080.0711/29/2007 11:34:51 AM89011899FIRST HOSP & HOME UTRE MED COROUTE 4, BOX 197BO CUPEY PATO009197/23/20032/4/2009 10:36:23 AM5000ZD10
SC118261/10/2008451539530.582/21/20080.061/9/2008 9:57:26 AM81711826EQUIPOS MEDICOS DEL ESTERFD 6 BZ 55MRIO PIEDRAS009295/31/20072/9/2009 3:58:22 PM5000MB10
SC118181/17/2008447139442.532/28/20080.061/10/2008 12:30:04 PM80911818EMERY RETIREMENT & CONVPAESCENP O BOX 683HYDE PARK021361/28/20083/2/2009 12:07:49 PM5000 10
TN1134010/7/2008182664153.2411/2/2008010/2/2008 2:53:36 PM33111340BRAINTREE TOWN TAXI, INCP O BOX 537BRAINTREE0218411/12/20072/12/2009 1:28:31 PM5000JohnAK30
SD1134010/7/2008182714154.1911/2/200809/30/2008 9:34:12 AM33111340BRAINTREE TOWN TAXI, INCP O BOX 535BRAINTREE0218411/12/20072/12/2009 1:28:31 PM5000Guess30
SC114388/14/2008236865237.29/12/200808/13/2008 8:42:31 AM42911438CENTRPA Translation INCP O BOX 1586WPALINGFORD0649210/15/20022/2/2009 10:58:52 AM13000Guess30
SD111721/8/200989872297.371/28/200901/5/2009 3:20:30 PM6811172ANDA MANAGEMENT CORPORATIONP O BOX 127CLIFFSIDE PARK070104/7/20051/1/2009 12:57:27 PM5000Joe30
TN116275/1/2008341447328.766/5/200804/29/2008 11:57:02 AM61811627CUSTOM SHOE SERVICEP O BOX 1000NEWARK071024/10/20013/2/2009 2:52:48 PM5000test30
TN1186212/24/2007471119922.242/5/20080.0712/21/2007 11:47:10 AM85311862F & J UTM, INCONE THOUSAND BEVERLY WAYE MARLBORO0774610/17/20084/7/2009 12:48:54 PM76000ZD10
TN117263/6/2008396288425.654/14/200803/5/2008 11:26:26 AM71711726DOWNTOWN Translation, PCC/O P O BOX 600, #39781-018NEW YORK100381/4/20052/6/2009 3:17:52 PM5000 30
TN115067/7/2008274585991.68/7/200807/3/2008 9:53:34 AM49711506COANNE Brewery, INCC/O P O BOX 600BRONX104576/21/20042/22/2009 5:15:35 AM73000test30
TN1126211/20/2008139213284.1112/13/2008011/17/2008 11:53:45 AM25311262BAYCHESTER Brewery, INCC/O P O BOX 27134, #14587-031BRONX104664/21/20041/16/2009 4:29:32 PM5000JohnAK30
TN115975/21/2008324656992.926/24/200805/15/2008 8:06:37 AM58811597CPC Brewery, INCC/O P O BOX 1029BRONX1080410/23/20033/31/2009 11:10:01 AM2000Joe30
TN1187212/18/20074765610031.291/31/20080.0712/13/2007 10:20:48 AM86311872FAMILY FOOT UTRE ADMINISTRATORC/O BOX 8004, #06269-081cheeseboro112138/9/20072/10/2009 1:09:41 PM82000ZD10
TN110174/4/2009391578.124/19/200904/2/2009 2:40:00 PM781101754-26 DRUG CORPC/O BOX 8004, #06269-081cheeseboro112216/5/20032/2/2009 12:18:21 PM5000Guess30
SC115346/25/2008289626292.427/27/200806/19/2008 8:12:28 AM52511534COMPASS TranslationC/O 868 NE 54TH TERRACEcheeseboro112297/17/20032/23/2009 11:48:15 AM5000AC30
TN110693/6/200932581151.593/23/200902/27/2009 2:50:46 PM13011069ADAPTED WHEELCHAIR RESTORATIONC/O 6910 AVE U, APT 3TNZUSHING1135511/28/20083/12/2009 5:34:28 PM5000Suzie30
TN110723/5/200934281185.513/22/200902/26/2009 12:23:27 PM13311072ADIRONDACK HOME UTRE, INCC/O 37900 N 45TH AVE, #16CLIFTON PARK120652/26/20071/26/2009 2:32:15 PM46000Suzie30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
TN1135710/1/2008192194343.8310/28/200809/25/2008 4:08:46 PM34811357BUFFPAO Sports AID CO, INCC/O 200 ST JAMES AVEWILLIAMSVILLE1422112/22/20051/14/2009 10:09:58 AM78000Joe30
SC1135710/1/2008192164343.1710/28/200809/24/2008 1:57:49 PM34811357BUFFPAO Sports AID CO, INCC/O 200 ST JAMES AVEWILLIAMSVILLE1422112/22/20051/14/2009 10:09:58 AM78000Mary30
TN115336/25/2008289526290.437/27/200806/23/2008 12:13:20 PM52411533COMMUNITY INTEGRATION ASSOCIATC/O 1903 HYDE PARK AVEUTMPBELL148212/26/20042/23/2009 2:04:10 PM24000AC30
TN116654/11/2008362007740.085/18/200804/7/2008 2:45:04 PM65611665DEUT LABORATORY INCC/O 1903 HYDE PARK AVEBEAVER1500912/22/20062/4/2009 12:01:51 PM5000AC30
TN115556/11/2008301336526.597/14/200806/5/2008 3:14:29 PM54611555CONFER Services OF AutomotiveC/O 131 PECKSLAND RDUNIONTOWN154019/3/20032/17/2009 6:57:46 AM80000ZD30
TN118021/24/2008437969259.263/5/20080.061/18/2008 11:45:31 AM79311802ELITE Electronics SERVICE995 N Princeton BEACH, 116SUNBURY1780111/1/20012/5/2009 1:56:51 PM67000AC10
TN117013/20/2008382318146.214/27/200803/19/2008 12:34:18 PM69211701DIVERSIFIED PAIN CENTER95 SEAVIEW placeWILKES BARRE1870110/22/20083/16/2009 10:55:38 AM13000 30
TN111301/29/200966571831.332/17/200901/27/2009 10:56:27 AM2611130PAPHA BETA Translation SUPPLY9125 JOSEPH UTMPAUPHILADELPHIA191168/14/20023/31/2009 3:54:08 PM14000test30
TN116694/8/2008364737794.565/15/200804/1/2008 2:35:57 PM66011669DELAWARE VPALEY Translation SERV90B PAINTERS MILL ROADPHILADELPHIA191243/12/20012/25/2009 12:11:56 PM87000Guess30
TN1132310/17/2008173283965.6711/11/2008010/16/2008 8:53:17 AM31411323BODY ENERGETICS, INC892 MIKE COURTELLICOTT CITY210425/9/20073/9/2009 10:06:50 AM5000Guess30
TN110563/13/200925631012.563/30/200903/6/2009 12:36:36 PM11711056ABUNDANT LIFE CENTER, INC882 E 180TH PlaceBPATIMORE2123110/20/20082/19/2009 8:18:21 AM61000Unknown30
TN1121412/16/2008113032760.671/7/2009012/12/2008 10:45:49 AM20511214ATLANTIC Vision UTRE, INC8600 N W 36 ST, STE 301SPRINGFIELD2215311/6/20082/4/2009 1:49:04 PM5000Unknown30
TN1121412/16/2008113062761.261/7/2009012/12/2008 8:24:48 AM20511214ATLANTIC Vision UTRE, INC8600 N W 36 ST, STE 301SPRINGFIELD2215311/6/20082/4/2009 1:49:04 PM5000Unknown30
SC110633/10/200929381087.663/27/200903/5/2009 1:23:41 PM12411063ACTIVE LIVING CENTER, INC8428 S W 24TH ST, STE 224CHAPEL HILL275141/18/20052/27/2009 10:01:14 AM94000Mary30
TN116933/26/2008378048060.775/3/200803/19/2008 11:08:22 AM68411693DICKENSON Translation CENTER HHA8428 S W 24TH Place, STEGOLDSBORO275331/29/20033/31/2009 2:40:16 PM5000test30
SC1125811/20/2008137373247.3712/13/2008011/19/2008 9:11:45 AM24911258BAY AREA HOME Vision8428 S W 24TH Place, STEGOLDSBORO275331/19/20061/12/2009 4:56:38 PM5000Mary30
SC1125811/20/200813742-400012/13/2008011/13/2008 9:57:12 AM24911258BAY AREA HOME Vision8428 S W 24TH Place, STEGOLDSBORO275331/19/20061/12/2009 4:56:38 PM5000test30
SC117931/31/2008433129162.323/12/20080.061/30/2008 10:19:27 AM78411793EHRHARDT Brewery, INC83 ELM PlaceEHRHARDT290817/28/20064/6/2009 1:29:22 PM5000Guess10
TN114128/28/2008222524950.479/25/200808/21/2008 1:12:01 PM40311412UTROLINA UROLOGIUTL CONSULTANT8249 N W 36TH STCONWAY2952610/1/20062/19/2009 1:57:51 PM5000 30
SC115206/30/2008282306146.038/1/200806/24/2008 9:03:55 AM51111520COLUMBIA Vision & REHAB CTR8013 SOUTH HWY 27DEUTTUR300327/13/20063/17/2009 10:25:13 AM5000JohnAK30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
SC116674/10/2008363387767.55/17/200804/9/2008 11:23:50 AM65811667DEKPAB REFERRPAS, INC7640 FULLERTON RD, STE 200ATLANTA303178/20/20013/20/2009 2:57:39 PM33000AC30
SC1190012/3/20074920710341.431/17/20080.0711/29/2007 10:35:38 AM89111900FIRST MED EMS, INC7552 NAVARRE PKWY, #4ATLANTA303378/23/20062/12/2009 10:29:25 AM5000test10
TN1189612/5/20074898110296.271/18/20080.0711/30/2007 2:09:43 PM88711896FIRST AMERIUTN HLTH UTRE OF GA747 PONCE DE LEON placeBRUNSWICK315204/28/20032/17/2009 10:29:55 AM5000test10
TN115765/30/2008313066761.17/3/200805/29/2008 4:30:32 PM56711576CORPORATE IMAGES, INC7330 W WARREN LaneJACKSONVILLE322161/8/20043/23/2009 1:49:20 PM5000test30
TN114867/17/2008263295765.858/17/200807/11/2008 1:31:39 PM47711486CJ'S BODYWORKS73 SWEDEN STJACKSONVILLE BEACH322503/19/20034/6/2009 10:28:55 AM5000 30
TN1133810/9/2008181344126.7511/4/2008010/8/2008 11:14:19 AM32911338BRADFORD T WILLIAMS, MD, PA700 S CENTRPA AVEGAINESVILLE326018/26/20021/7/2009 3:35:52 PM5000Mary30
SD1133810/8/2008181594131.8211/3/2008010/8/2008 10:59:51 AM32911338BRADFORD T WILLIAMS, MD, PA700 S CENTRPA AVEGAINESVILLE326018/26/20021/7/2009 3:35:52 PM5000Joe30
TN117642/14/2008416968839.143/25/20080.062/7/2008 8:55:30 AM75511764DYNAMIC Restaurant INSTITUTE6770 N LINCOLN AVEHIPAEAH330101/24/20061/21/2009 2:47:42 PM5000Suzie10
TN116095/12/2008331407127.916/16/200805/9/2008 9:55:31 AM60011609CRIST YIRET Translation SUPPLY646 LAMPLIGHTER WAYPrinceton LAKES330156/28/20021/31/2009 5:02:27 PM5000Joe30
SD110513/16/20092279955.784/1/200903/12/2009 11:46:37 AM11211051ABC EUREKA Translation RENTPAS6301 ROCKHILL, STE 411HIPAEAH330162/11/20081/6/2009 9:24:58 AM5000AC30
SC116774/4/2008368917878.185/11/200804/2/2008 2:19:32 PM66811677Advertising Vision Services, INC624 BAYVIEW AVEHIPAEAH330181/23/20021/30/2009 1:56:01 PM90000 30
TN113769/17/2008202494549.7110/14/200809/11/2008 3:09:35 PM36711376UTLIXTO GARCIA Translation CTR INC6032 S HPASTEDPrinceton330555/23/20082/5/2009 1:39:23 PM5000Mary30
SC1121612/15/2008114072781.411/6/2009012/9/2008 12:45:51 PM20711216ATLANTIC TAXI601 SKOKIE place, STE 503UTROL CITY330557/8/20032/23/2009 1:50:30 PM5000Mary30
TN110613/11/200928341066.893/28/200903/11/2009 3:42:06 PM12211061A-COMMUNITY HOME Vision, INC5800 49TH ST, NORTH #201Princeton331014/22/20041/26/2009 12:48:09 PM15000MB30
TN111212/5/200961661733.212/24/200902/4/2009 10:03:27 AM1711121PAL-DADE HEATLH UTRE, INC560 VAN REED RD, STE 201Princeton331251/6/20051/12/2009 1:46:47 PM99000Joe30
SD110453/20/20091930-886.014/5/200903/17/2009 11:20:55 AM10611045A-1 ARTISTIC LANDSUTPING, INC560 VAN REED RD, STE 201Princeton331252/12/20022/17/2009 12:54:06 PM5000MB30
SC117143/14/2008389578291.364/21/200803/12/2008 8:47:45 AM70511714DOCTORS FAMILY GROUP, INC555 S MISSION ROADPrinceton331267/30/20063/11/2009 8:58:04 AM32000ZD30
TN115047/9/2008273325966.38/9/200807/4/2008 4:11:13 PM49511504CMC Translation UTRE, INC516 SUNAKBROOK placePrinceton3313510/18/20063/9/2009 3:28:17 PM85000test30
SC1128911/5/2008154293585.711/29/2008011/5/2008 2:32:53 PM28011289BEST Translation UTRE, INC508 E 49TH STPrinceton3313712/4/20031/21/2009 4:45:06 PM5000AC30
TN1119612/26/2008102682553.531/16/2009012/19/2008 3:16:26 PM18711196ART DECO Translation GROUP, INC5022 N W 189TH TERRPrinceton BEACH3313912/21/20062/10/2009 10:56:16 AM5000MB30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
TN114887/17/2008264475789.478/17/200807/16/2008 12:03:49 PM47911488CLARK C MITCHELL, MD, PA5022 N W 189TH TERRPrinceton BEACH3313912/27/20051/30/2009 9:54:20 AM52000Suzie30
SC1188712/10/20074852910205.891/23/20080.0712/6/2007 8:09:25 AM87811887FIFTEENTH Place Translation OFCS5022 N W 189TH TERRPrinceton BEACH331399/8/20054/3/2009 12:44:51 PM5000Mary10
SC117103/17/2008387018240.284/24/200803/16/2008 10:59:02 AM70111710DOCTOR'S UTRE, INC5022 N W 189TH TERRPrinceton BEACH331395/14/20083/5/2009 1:00:20 PM5000 30
TN113739/19/2008201024520.3810/16/200809/17/2008 12:11:48 PM36411373C.F. Translation SERVICES, INC4901 BATTLE SHIP PKWYPrinceton BEACH331418/10/20061/21/2009 12:59:56 PM50000Suzie30
TN113739/19/2008200814516.2410/16/200809/17/2008 11:00:30 AM36411373C.F. Translation SERVICES, INC4900 N 89TH STPrinceton BEACH331418/10/20061/21/2009 12:59:56 PM50000Guess30
SC1188312/12/20074827510154.991/25/20080.0712/10/2007 11:39:18 AM87411883FARMACIA Florence, INC4822 TRAILMARK LOOPPrinceton3314411/27/20022/9/2009 11:00:01 AM5000AC10
SC117891/31/2008430819116.23/12/20080.061/24/2008 1:50:29 PM78011789EDISON FAMILY Translation CENTER4720 GREAT NORTHER placePrinceton331505/19/20051/2/2009 1:12:31 PM44000test10
TN1191111/27/20074983310466.61/11/20080.0711/23/2007 1:10:38 PM90211911NZAMINGO Translation SUPPLIES47 SHERWOOD AVEPrinceton331555/16/20082/10/2009 12:02:13 PM5000Mary10
TN113909/10/2008210374707.3410/8/200809/5/2008 11:49:36 PM38111390UTPITPA Translation SUPPLIES, CORP47 SHERWOOD AVEPrinceton331552/4/20051/22/2009 2:17:58 PM13000Mary30
SC1190311/29/20074939710379.491/13/20080.0711/23/2007 11:56:56 AM89411903FIRST OPTION Translation CTR, INC47 SHERWOOD AVEPrinceton331559/14/20072/16/2009 7:31:36 AM5000Unknown10
TN117023/21/2008383028160.354/28/200803/19/2008 10:37:20 AM69311702DJ AND ASSOCIATES, INC444 MADISON AVEPrinceton331581/21/20042/4/2009 3:19:52 PM5000Guess30
SC117971/29/2008435109201.913/10/20080.061/28/2008 2:00:49 PM78811797EL MILAGRO Translation CENTER4325 PABYPrinceton331659/12/20083/6/2009 3:48:00 PM43000AC10
SC118351/7/2008456479629.472/18/20080.061/3/2008 11:24:10 AM82611835ESTELA'S DME424 DIVISION PlacePrinceton331686/22/20073/10/2009 9:36:23 AM36000Guess10
SC110583/13/200926321026.323/30/200903/6/2009 9:58:30 AM11911058ACLF Translation SERVICES, INC424 DIVISION PlacePrinceton331685/31/20014/6/2009 9:54:40 AM5000Unknown30
SC118441/2/2008461539730.662/14/20080.0612/28/2007 3:27:59 PM83511844EXPERIENCE HOME Vision417 W 1ST PlacePrinceton331728/14/20012/3/2009 9:22:47 AM5000Mary10
TN113699/24/2008198494469.8910/21/200809/18/2008 10:18:31 AM36011369C & S LABORATORY, INC4017 ST CLAUDEPrinceton331771/5/20053/9/2009 12:52:29 AM91000 30
SC118451/2/2008461999739.842/14/20080.0612/31/2007 9:49:29 AM83611845EXPO MED Translation EQUIPMENT398 EAST 148TH STPrinceton331839/9/20082/16/2009 8:37:15 AM5000ZD10
TN117183/12/200839171-90004/20/200803/7/2008 1:38:58 PM70911718DON'S Services Brewery, INC37920 N 45TH, DEPT 1775POMPANO BCH332623/7/20083/3/2009 1:07:07 PM75000Joe30
TN111521/19/200978612072.282/8/200901/13/2009 11:27:31 AM4811152AMERIUTN INSTITUTE OF PLASTIC3779 N W 16TH STFT LAUDERDPAE3330410/12/20072/14/2009 1:26:01 AM5000 30
TN114278/20/2008230875117.459/18/200808/18/2008 3:33:24 PM41811427CENTER FOR NEUROLOGY & SLEEP M34 INDUSTRIPA LOOP NJUPITER3346811/9/20061/14/2009 11:10:59 AM92000Guess30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
SC117562/20/2008412438748.663/31/20080.062/14/2008 1:55:50 PM74711756DURAMED, INC3309 W KENNEDY placeTHONOTASASSA335923/21/20053/3/2009 3:07:12 PM5000Guess10
TN116604/16/2008359607692.15/23/200804/10/2008 2:27:08 PM65111660DBB, INC3275 MARTIN, SUITE 127TAMPA336248/12/20024/7/2009 9:50:49 AM5000Mary30
SC115286/26/2008286256224.987/28/200806/25/2008 12:17:16 PM51911528COMMUNITY ServicesPA LAB, INC3151 E 4TH LaneCLEARWATER337563/27/20081/23/2009 8:58:36 AM39000Unknown30
TN111471/22/200975632012.552/11/200901/19/2009 3:02:27 PM4311147AMERIUTN FAMILY PAeutIUTL312 S. PINE PlaceNAPLES341035/29/20063/16/2009 11:39:54 AM5000ZD30
SC116524/18/2008355017600.195/24/200804/16/2008 3:59:48 PM64311652DAVID REDFERING AND ASSOCIATES3040 ENSLEY AVEINDIAN ROCKS BEACH346355/3/20041/12/2009 11:21:15 AM5000JohnAK30
SC118051/24/2008439889297.693/5/20080.061/23/2008 11:14:32 AM79611805ELITE Translation DISTRIBUTORS INC301 COOPER PlacePPAM HARBOR346846/23/20053/26/2009 5:18:51 AM21000Guess10
SC117383/5/2008402388547.644/13/20080.062/28/2008 8:54:38 AM72911738DRUG ASSIST Vision SOLUTIONS,30 SOUTH BROADWAYOAKLAND347879/12/20063/18/2009 4:18:09 PM46000Unknown10
TN1188212/13/20074821210142.31/26/20080.0712/6/2007 9:54:47 AM87311882FARMACIA UTPARRA HEIGHTS, INC2999 S VIRGINIA STPORT SAINT3495211/3/20052/24/2009 1:55:50 PM34000JohnAK10
TN118041/25/2008439139282.533/6/20080.061/23/2008 9:19:38 AM79511804ELITE Translation COMPAAK2815 NW 7TH PlaceNASHVILLE372212/6/20033/2/2009 1:02:52 PM34000MB10
SC117632/14/2008416718834.183/25/20080.062/7/2008 8:08:47 AM75411763DYERSBURG MINOR Translation Services2804 W MARC KNIGHTON CTDYERSBURG380246/1/20012/23/2009 10:42:13 AM34000AC10
SC117512/21/2008409668693.284/1/20080.062/14/2008 3:54:25 PM74211751DUNN Translation, INC266-268 CONCORD AVEGREENWOOD3893012/22/20053/25/2009 2:48:24 PM80000Unknown10
SC114039/3/2008217174843.4310/1/200809/3/2008 2:40:41 PM39411403UTRETENDERS, INC2576 NEWPORT place, #CLOUISVILLE402222/16/20043/3/2009 10:02:16 PM5000Guess30
SC114987/10/2008269925898.378/10/200807/9/2008 3:44:42 PM48911498Services MAKERS OF Princeton, INC255 STRECKERLEXINGTON405126/30/20032/12/2009 12:59:43 PM5000ZD30
SC1125511/26/2008135513210.2412/19/2008011/20/2008 9:55:36 AM24611255BASS Electronics25 GREENMEADOW DRHOPKINSVILLE422403/13/20031/4/2009 12:03:27 AM5000Guess30
SC113929/9/2008211104721.9710/7/200809/4/2008 8:35:12 AM38311392UTRDIO Restaurant TECHNOLOGY &2459 ROOSEVELT HWYNorthERVILLE430814/13/20013/26/2009 9:32:34 AM5000JohnAK30
TN115606/5/2008304486589.537/8/200806/4/2008 12:29:46 PM55111560CONSOLIDATED CONTRACT Marketing2402 E 2070 SOUTHCOLUMBUS4322412/8/20053/30/2009 1:39:23 PM81000AC30
TN115606/11/200830398-6579.557/14/200806/6/2008 11:48:36 AM55111560CONSOLIDATED CONTRACT Marketing2402 E 2070 SOUTHCOLUMBUS4322412/8/20053/30/2009 1:39:23 PM81000Unknown30
SC114657/30/2008251575531.438/29/200807/29/2008 3:26:43 PM45611465CHILD & ADOLESCENT INSTITUTE2311 IVYCREST COURTBEACHWOOD441227/16/20073/30/2009 10:37:04 AM63000MB30
TN115037/9/2008272845956.768/9/200807/7/2008 10:49:18 AM49411503CLYDE D BROWN, M.D. AND ASSOC225 W WACKER DR, STE 200CINCINNATI452194/9/20083/16/2009 12:08:33 PM5000test30
TN111012/17/200950101501.983/7/200902/12/2009 12:27:19 PM16211101AID Electronics SERVICE2244 EAST BAY placeDAYTON454053/19/20022/11/2009 3:24:18 PM85000test30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
SC118101/22/2008442249344.783/4/20080.061/17/2008 6:32:02 AM80111810ELROSE Vision SERVICES, INC20605 UTROUSEL CIRCLE WDETROIT482344/10/20023/16/2009 12:39:44 PM17000Guess10
TN111811/1/200994562391.171/22/2009012/25/2008 3:04:29 PM17211181AQUATIC & PHYSIUTL THERAPY AS201 N CHARLES STKPAAMAZOO490086/5/20073/2/2009 3:53:44 PM5000Joe30
TN1187512/19/20074785610071.32/1/20080.0712/17/2007 10:00:53 AM86611875FAMILY Vision CENTER, P C200 WINSTON DR, #C1104CEDAR RAPIDS5240211/10/20052/17/2009 4:06:00 PM5000Joe10
TN1123512/4/2008124552991.0412/26/2008011/27/2008 9:27:40 AM22611235B AND L TRANSPORT, INC196 DAYLESFORD placeMILWAUKEE532126/6/200512/30/2008 9:57:01 AM67000Guess30
TN1122612/9/2008119562891.2612/31/2008012/4/2008 2:15:25 PM21711226AUGUSTINE Translation, INC1902 LENZORE AVE, #8EDEN PRAIRIE5534410/24/20021/1/2009 3:38:09 PM90000Guess30
SC110553/12/20092515-1002.953/29/200903/11/2009 12:43:29 PM11611055ABSOLUTE UTRE BENMAMIN WILLIAM1900 SIMLER AVE, FCI#5797MINNEAPOLIS554045/29/20022/11/2009 4:37:27 PM5000ZD30
SC1124711/28/2008131133122.6812/21/2008011/27/2008 1:16:43 PM23811247BARB CORP18566 GILMORE STDES PLAINES600161/9/20031/7/2009 10:14:24 AM25000Mary30
SC1123812/3/2008126003020.0512/26/2008011/27/2008 2:50:21 PM22911238BAINBRIDGE MANAGEMENT1841 WYOMING AVECHIUTGO606033/2/20041/1/2009 8:36:55 PM5000Mary30
SC111591/16/200982252145.092/5/200901/12/2009 7:22:44 AM5511159AMERIUTN PHYSIUTL THERAPY & SP1841 WYOMING AVECHIUTGO606067/19/20071/28/2009 9:16:27 AM5000Unknown30
SC118361/7/2008457059641.032/18/20080.0612/31/2007 4:17:21 PM82711836ESTRADA Automotive Services1821 MEMORIPA placeGPAESBURG614017/14/20043/19/2009 12:59:51 PM3000test10
SC117133/13/2008388788275.594/20/200803/10/2008 11:51:34 AM70411713DOCTORS Services, DME COMPAAK1819 TROUP HIGHWAYPATON620029/28/20073/2/2009 1:44:18 PM22000JohnAK30
SC117123/19/2008388198263.734/26/200803/13/2008 2:15:34 PM70311712DOCTORS Services LABORATORY1819 TROUP HIGHWAYPATON620024/24/20071/21/2009 1:40:29 PM5000Guess30
TN1130810/23/2008164673793.511/17/2008010/22/2008 10:51:02 AM29911308BISTATE REHAB, INC1729 TOAK LANEST LOUIS6312912/29/20051/2/2009 12:45:32 PM12000test30
SC111511/20/200978152063.022/9/200901/19/2009 2:15:02 PM4711151AMERIUTN HOME VISION1718 E 4TH PlaceST LOUIS6314111/17/20052/13/2009 2:39:58 PM42000ZD30
SC111491/21/200976762035.242/10/200901/21/2009 8:15:11 AM4511149AMERIUTN VisionUTRE MANAGEMENT1718 E 4TH PlaceST LOUIS631414/5/20073/23/2009 9:06:52 AM5000Mary30
TN115296/25/2008286906237.927/27/200806/23/2008 1:15:55 PM52011529COMMUNITY COUNSELING SERVICES1680 MICHIGAN AVE, #800WAYNESVILLE655836/20/20011/13/2009 4:01:10 PM66000Unknown30
TN114328/18/2008233415168.289/16/200808/12/2008 3:09:31 PM42311432CENTRPA CITY OPTIUTL163 EASTERN LaneNEW ORLEANS7011311/12/20042/2/2009 4:07:24 PM6000AC30
TN113879/11/2008208564671.2710/9/200809/4/2008 9:59:06 AM37811387UTP, INC1612 TAMPICO PlaceNEW ORLEANS7011710/10/20062/18/2009 10:06:47 AM5000Mary30
SC116135/8/2008333307166.066/12/200805/2/2008 1:50:51 PM60411613CROSSROADS MENTPA Vision, LLC157-33 ROSE AVEPLAQUEMINE707641/23/20032/23/2009 2:55:49 PM60000 30
TN111571/15/200981382127.682/4/200901/13/2009 12:40:53 PM5311157AMERIUTN Translation TRANSPORT1570 N W 14TH PlaceBATON ROUGE7080811/20/20073/31/2009 10:47:55 AM5000Joe30
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
TN1123112/10/2008122072941.471/1/2009012/9/2008 10:05:37 AM22211231B & B Translation EQUIPMENT & SU157 PADELFORD PlaceBOSSIER CITY711125/6/20083/25/2009 11:05:31 AM40000Guess30
SC114628/1/200825003-5500.698/31/200807/25/2008 11:28:52 AM45311462CHECOTAH Translation Services1464 WASHINGTON AVECHECOTAH744268/28/20053/24/2009 3:26:31 PM66000Mary30
SC110812/26/20093942-20003/15/200902/23/2009 10:03:30 AM14211081ADVANCED VisionUTRE CONSULTANT1430 S W 1ST ST, STE 224MCKINNEY750701/2/20092/19/2009 3:49:56 PM20000JohnAK30
TN1122012/11/2008115992819.891/2/2009012/4/2008 3:25:04 PM21111220AUBURN SYSTEMS CORPORATION13800 S W 8TH ST, STE 153BEDFORD760215/8/20063/5/2009 10:58:03 AM99000Suzie30
TN1122012/11/2008115992819.711/2/2009012/5/2008 9:19:39 AM21111220AUBURN SYSTEMS CORPORATION13800 S W 8TH ST, STE 153BEDFORD760215/8/20063/5/2009 10:58:03 AM99000 30
TN117782/8/2008424898997.833/19/20080.062/6/2008 11:30:55 PM76911778EAST HARRIS COUNTY ORTHOPEDICS135 ORCHARD PlaceHOUSTON770195/16/20052/26/2009 10:04:03 AM95000MB10
TN111311/29/200967051840.932/17/200901/28/2009 2:09:21 PM2711131PAPHA HERBS & VITAMINS13354 MARQUETTE AVEHOUSTON770968/2/20063/1/2009 12:51:55 AM72000AC30
SC114148/28/2008223424968.459/25/200808/26/2008 12:21:00 PM40511414UTROLYN'S Translation TRANSPORT12951 S W 2ND TERRACEBRYAN778033/21/20051/27/2009 3:13:33 PM5000Mary30
TN110383/23/20091558811.544/8/200903/16/2009 8:00:05 AM9911038A LITTLE WPANUT Brewery, INC12295 N W 7TH TRAILHOUSTON787585/17/20011/1/2009 3:01:59 PM43000Guess30
SD113869/12/2008207994659.8910/9/200809/9/2008 11:19:19 AM37711386UTP Brewery, INC1203 VANN placeDENVER802039/30/20043/26/2009 10:29:07 AM87000JohnAK30
TN117542/21/2008411728734.344/1/20080.062/18/2008 2:24:52 PM74511754DURABLE Translation EQUIPMENT, INC1202 E LOCUST STDENVER802181/26/20071/30/2009 10:27:06 AM5000Guess10
SC117043/20/2008383938178.664/27/200803/13/2008 8:50:56 AM69511704DME OF UTSTLE ROCK, INC1201 W PEACHTREE ST, #375DENVER802181/24/20023/30/2009 2:55:04 PM5000Guess30
TN1188812/10/20074853610207.111/23/20080.0712/9/2007 9:48:04 AM87911888FINANCIPA SECURITY, INC1172 N E 196TH PlaceOURAY814274/8/20022/2/2009 3:55:01 PM5000Unknown10
TN1130410/27/2008162483749.6511/21/2008010/29/2008 3:08:54 PM29511304BIO-MECHANICS Services117 SHORE PARKWAYABERDEEN832102/5/20012/27/2009 11:05:26 AM5000ZD30
TN1130410/28/2008162403747.9811/22/2008010/23/2008 10:12:48 AM29511304BIO-MECHANICS Services11511 E GARVEY AVEABERDEEN832102/5/20012/27/2009 11:05:26 AM5000Joe30
SC118201/16/2008447779455.352/27/20080.061/11/2008 1:15:40 PM81111820EMMETT FOOT & ANKLE Services11510 CHARLES YOUNG DREMMETT836175/6/20053/27/2009 11:57:22 PM5000Unknown10
TN118431/3/2008460809716.052/15/20080.0612/31/2007 2:17:22 PM83411843EXE, INC1114 RIVER VISTA WPABUQUERQUE871108/7/20073/11/2009 11:55:17 AM47000 10
SC114298/19/2008231495129.719/17/200808/12/2008 1:15:49 PM42011429CENTER Brewery, INC111 W MAPLE AVEESPANOLA875324/17/20061/20/2009 2:23:25 PM5000Unknown30
TN115087/9/2008275576011.368/10/200807/2/2008 10:04:54 AM49911508COASTPA INDUSTRIPA Vision UTRE1101 BRYAN AVE, #GLOS ANGELES900083/18/20011/27/2009 1:37:59 PM5000JohnAK30
TN118221/15/2008449339486.672/26/20080.061/16/2008 11:40:13 AM81311822EMOOKO Translation SUPPLY110 BEECH ST, STE CLOS ANGELES900398/10/20012/23/2009 9:57:51 AM5000JohnAK10
stateCustomer NumberInvoice DateInvoice NumberInvoice AmountDue DateTerms PercentProcess TimeIDCustomer Number1Customer NameADDRESSCITYZip CodeSetup TimeLast TranTimeCredit LimitApproverTerms Days
SC114338/20/200823393-5178.69/18/200808/13/2008 9:13:35 AM42411433CENTRPA COMMUNITY SERVICE, INC109 UTRLTON LaneLOS ANGELES9005711/28/20023/16/2009 3:35:17 PM5000JohnAK30
TN115755/30/2008312536750.537/3/200805/22/2008 10:40:05 AM56611575CORONADO Translation Services, INC10890 BUSTLETON AVEHUNTINGTON PARK902552/5/20042/26/2009 1:57:08 PM80000Guess30
TN118401/3/2008459199683.92/15/20080.061/2/2008 11:22:28 AM83111840EVERGREEN Translation GROUP, INC1087 NORTH HENDERSONWHITTIER9060310/31/20052/28/2009 7:48:07 PM63000ZD10
SC1129211/3/2008155753615.0911/27/2008010/28/2008 3:14:11 PM28311292BETTER BODIES, INC10801 NORTH LAMARWHITTIER906047/24/20082/10/2009 2:06:05 PM5000AC30
SC117422/28/2008404808595.94/7/20080.062/26/2008 12:57:51 PM73311742DUKE Translation Services, INC10393 North 70TH PlaceEL MONTE9173211/26/20012/2/2009 8:20:47 AM78000JohnAK10
TN1128111/12/2008149753494.9612/6/2008011/6/2008 8:11:50 AM27211281BENISON Translation SUPPLY101-A FAIRVIEW AVESAN DIEGO921104/10/20022/26/2009 10:39:09 AM23000ZD30
SC117243/12/2008395158402.934/20/200803/6/2008 3:58:04 PM71511724DOWNTOWN Automotive10140 LINN STATION RDEL CENTRO922434/5/20042/26/2009 3:29:53 PM5000Unknown30
SC1132010/16/2008171533930.5511/10/2008010/15/2008 12:24:41 PM31111320BO AN DANG OPTIUTL10105 S W 2ND TERRACEGARDEN GROVE926441/25/20081/7/2009 1:07:45 PM95000ZD30
SD115805/27/2008315546810.816/30/200805/21/2008 11:52:43 AM57111580COSMETIC SURGERY & LASER INST101 HAYDEN AVETUSTIN9278011/5/20074/2/2009 12:16:26 PM47000test30
TN1187812/13/20074798510096.991/26/20080.0712/6/2007 10:36:50 AM86911878FAMILY Translation MANAGEMENT SERV100 ABBOTT PARK ROADPORTLAND972322/14/20051/19/2009 2:10:53 PM5000AC10
TN118151/17/200844523-100002/28/20080.061/10/2008 3:09:37 PM80611815EMERPAD CITY Automotive#11 THE PINES COURT, STE ASEATTLE981039/7/20062/17/2009 11:27:16 AM5000AC10


Lead Work Sheet

Electronic Workpaper index