CF_CSV2Query Example
Delimiter:
Tab
,(Comma)
|(Pipe)
.(Dot)
Other, please specify:
Text qualifier:
Column row:
(if equals 0, it will use column header list)
Column header:
Start data row:
CSV string:
!HDR PROD VER REL IIFVER DATE TIME ACCNTNT ACCNTNTSPLITTIME HDR QuickBooks Premier Version 10.0D Release R1P 1 2003-12-15 1071421454 N 0 !CUSTNAMEDICT INDEX LABEL CUSTOMER VENDOR EMPLOYEE !ENDCUSTNAMEDICT CUSTNAMEDICT 0 Contract # Y N N CUSTNAMEDICT 1 Discount Available N Y N CUSTNAMEDICT 2 B-Day Y N Y CUSTNAMEDICT 3 Date of last raise N N Y CUSTNAMEDICT 4 Spouse's Name Y N Y CUSTNAMEDICT 5 N N N CUSTNAMEDICT 6 N N N CUSTNAMEDICT 7 N N N CUSTNAMEDICT 8 N N N CUSTNAMEDICT 9 N N N CUSTNAMEDICT 10 N N N CUSTNAMEDICT 11 N N N CUSTNAMEDICT 12 N N N CUSTNAMEDICT 13 N N N CUSTNAMEDICT 14 N N N ENDCUSTNAMEDICT !CUST NAME REFNUM TIMESTAMP BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE SALESTAXCODE LIMIT RESALENUM REP TAXITEM NOTEPAD SALUTATION COMPANYNAME FIRSTNAME MIDINIT LASTNAME CUSTFLD1 CUSTFLD2 CUSTFLD3 CUSTFLD4 CUSTFLD5 CUSTFLD6 CUSTFLD7 CUSTFLD8 CUSTFLD9 CUSTFLD10 CUSTFLD11 CUSTFLD12 CUSTFLD13 CUSTFLD14 CUSTFLD15 JOBDESC JOBTYPE JOBSTATUS JOBSTART JOBPROJEND JOBEND HIDDEN DELCOUNT PRICELEVEL CUST "Abercrombie, Kristy" 21 933272658 Kristy Abercrombie 5647 Cypress Hill Rd Bayshore CA 94326 415-555-6579 kristy@samplename.com Kristy Abercrombie Steve Darcangelo Residential Net 30 Y Tax San Tomas "9/15/2003: Send Kristy estimate for den remodel.\n\n9/20/2003: Called Kristy to discuss job: Kristy is not interested at this time. Estimate was competitive, not using another firm.\n\n10/15/2003: Further discussion of bathroom remodel. I offered 10% discount on project if she would sign the contract now." Mrs. Kristy Abercrombie 1/1/65 fredahl@zzz.com Tim 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST "Abercrombie, Kristy:Family Room" 22 933272658 Kristy Abercrombie 5647 Cypress Hill Rd Bayshore CA 94326 415-555-6579 kristy@samplename.com Kristy Abercrombie Residential Net 30 N San Tomas Remodel 5 N 0 CUST "Abercrombie, Kristy:Kitchen" 23 933272658 Kristy Abercrombie 5647 Cypress Hill Rd Bayshore CA 94326 415-555-6579 kristy@samplename.com Kristy Abercrombie Residential Net 30 N San Tomas Repairs 1 N 0 CUST "Abercrombie, Kristy:Remodel Bathroom" 24 933272658 Kristy Abercrombie 5647 Cypress Hill Rd Bayshore CA 94326 415-555-6579 kristy@samplename.com Kristy Abercrombie Residential Net 30 N San Tomas Kristy Abercrombie 1097-02-KABE Remodel 4 1998-10-23 1998-11-10 1998-10-30 N 0 CUST "Baker, Chris" 148 1071506775 "Baker, Chris" 415 W. Desert Bloom "Bayshore, CA 94326" 415-555-2253 ChrisB@samplename.com Chris Baker Residential Net 30 Y Tax San Tomas Chris Baker 03-1234567 0 N 0 CUST "Baker, Chris:Family Room" 149 1071506823 "Baker, Chris" 415 W. Desert Bloom "Bayshore, CA 94326" 415-555-2253 ChrisB@samplename.com Chris Baker Residential Net 30 N San Tomas Chris Baker 03-1234567 4 N 0 CUST "Balak, Mike" 150 1071508305 Mike Balak 8753 S. Mountain View "Bayshore, CA 94326" 415-555-6636 mbalak@samplename.com Mike Balak Residential Net 30 Y Tax San Tomas Mike Balak 0 N 0 CUST "Balak, Mike:Utility Shed" 151 1071508343 Mike Balak 8753 S. Mountain View "Bayshore, CA 94326" 415-555-6636 mbalak@samplename.com Mike Balak Residential N San Tomas Mike Balak A1 Utility Building New Construction 4 N 0 CUST "Barley, Renee" 146 1071506140 Renee Barley 4417 N. Sun Valley Rd "Middlefield, CA 94471" 415-555-7262 renee@samplename.com Renee Barley Residential Net 15 Y Tax San Tomas Renee Barley 0 N 0 CUST "Barley, Renee:Repairs" 147 1071506202 Renee Barley 4417 N. Sun Valley Rd "Middlefield, CA 94471" 415-555-7262 renee@samplename.com Renee Barley Net 15 N San Tomas Renee Barley Re-wire familyroom electrical Repairs 4 2003-01-06 2003-12-17 2003-12-17 N 0 CUST "Bolinski, Rafal" 73 1071522962 Rafal Bolinski 1421 Silverbell Ave East Bayshore CA 94327 415-555-3262 r2b2@samplename.com Rafal Bolinski Residential Y Tax San Tomas Rafal Bolinski 0 N 0 CUST "Bolinski, Rafal:2nd story addition" 89 1071526363 Rafal Bolinski 1421 Silverbell Ave East Bayshore CA 94327 415-555-3262 r2b2@samplename.com Rafal Bolinski N San Tomas Rafal Bolinski Remodel 4 N 0 CUST "Bristol, Sonya" 139 1071532693 Sonya Bristol 5920 N. Lighthouse "Bayshore, CA 94326" 415-555-5239 sonyab@samplename.com Sonya Bristol Residential Net 30 Y Tax San Tomas Sonya Bristol 0 N 0 CUST "Bristol, Sonya:Utility Shed" 140 1071532703 Sonya Bristol 5920 N. Lighthouse "Bayshore, CA 94326" 415-555-5239 sonyab@samplename.com Sonya Bristol Residential N San Tomas Sonya Bristol B03-123456789 0 N 0 CUST "Bristol, Sonya:Repairs" 145 1071505273 Sonya Bristol 5920 N. Lighthouse "Bayshore, CA 94326" 415-555-5239 sonyab@samplename.com Sonya Bristol Residential N San Tomas Sonya Bristol B03-123456789 Repair toilet in master bath Repairs 4 N 0 CUST "Burch, Jason" 152 1071509186 Jason Burch 5960 N. Wetmore "Bayshore, CA 94326" 415-555-2351 mr-b@samplename.com Jason Burch Residential Net 30 Y Tax San Tomas Jason Burch 0 N 0 CUST "Burch, Jason:Room Addition" 153 1071509249 Jason Burch 5960 N. Wetmore "Bayshore, CA 94326" 415-555-2351 mr-b@samplename.com Jason Burch Net 30 N San Tomas Jason Burch 0309-1256 Bedroom Addition Remodel 4 N 0 CUST "Burney, Tony" 144 1071504455 "Burney, Tony" 910 S. Ivy "Bayshore, CA 94326" 415-555-8669 tonyb@samplename.com Tony Burney Residential Due on receipt Y Tax San Tomas Mr Tony Burney Repairs 0 N 0 CUST "Burney, Tony:Repairs" 120 1071507712 "Burney, Tony" 910 S. Ivy "Bayshore, CA 94326" 415-555-8669 tonyb@samplename.com Tony Burney Residential Due on receipt N San Tomas Mr Tony Burney Repair facia - north side of house Repairs 4 2003-12-20 2003-12-20 2003-12-20 N 0 CUST "Cook, Brian" 25 933272658 Brian K. Cook 345 Cherry Lane Middlefield CA 94482 415-555-2248 555-0220 bcook@samplename.com Brian or Carol Brian (work number) Residential Net 30 Y Tax San Domingo 10/15/2003: Called to talk about us doing some work in their upstairs.\n\n10/20/2003: Shook hands on doing some work on their second floor.\n\n11/17/2003: Carol called and didn't like the spackle job. Mr. Brian K. Cook bkcook@best.com 10/8/60 Carol 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST "Cook, Brian:2nd story addition" 26 933272658 Brian K. Cook 345 Cherry Lane Middlefield CA 94482 415-555-2248 555-0220 bcook@samplename.com Brian Brian (work number) Residential Net 30 N San Domingo 1097-03-PCAR Carol Remodel 3 1998-12-01 1998-12-15 N 0 CUST "Cook, Brian:Kitchen" 27 933272658 Brian Cook 345 Cherry Lane Middlefield CA 94482 415-555-2248 415-555-0220 bcook@samplename.com Brian Brian (work number) Residential Net 30 N San Domingo 1197-02-PCAR Repairs 3 1998-09-01 1998-09-10 1998-09-13 N 0 CUST "Cook, Brian:Kitchen:Change Order #1" 28 933272658 Brian K. Cook 345 Cherry Lane Middlefield CA 94482 415-555-2248 415-555-0220 bcook@samplename.com Brian Brian (work number) Residential Net 30 N San Domingo Mr. Phil Carpenter Change order #1 pcarpenter@best.com 10/8/60 Carol 4 1998-09-23 1998-09-23 1998-09-23 N 0 CUST "Craven, Pam" 115 1071526537 Pam Craven 7105 N. Landon "E. Bayshore, CA 94327" 415-555-7264 pamc@samplename.com Pam Craven Residential Due on receipt Y Tax East Bayshore Ms. Pam Craven 0 N 0 CUST "Craven, Pam:Duct Work" 116 1071526664 Pam Craven 7105 N. Landon "E. Bayshore, CA 94327" 415-555-7264 pamc@samplename.com Pam Craven Residential Due on receipt N East Bayshore Ms. Pam Craven 03-12345 Replace damaged dusct work and drywall Repairs 4 2003-06-09 2003-06-26 2003-06-23 N 0 CUST "Cuddihy, Matthew" 121 1071511999 Matthew Cuddihy 8321 S. Flower "E. Bayshore, CA 94781" 415-555-6188 mcuddihy@samplename.com Matthew Cuddihy Residential Net 15 Y Tax East Bayshore Matthew Cuddihy 0 N 0 CUST "Cuddihy, Matthew:Utility Room" 122 1071512142 Matthew Cuddihy 8321 S. Flower "E. Bayshore, CA 94781" 415-555-6188 mcuddihy@samplename.com Matthew Cuddihy Residential Net 15 N East Bayshore Matthew Cuddihy Utility Room build out Remodel 4 2003-03-03 2003-03-14 2003-03-13 N 0 CUST "Duncan, Dave" 126 1071530014 "Duncan, Dave" 3442 W. Charleston "Bayshore, CA 94326" 415-555-3823 DoubleD@samplename.com Dave Duncan Residential Net 30 Y Tax San Tomas Dave Duncan 0 N 0 CUST "Duncan, Dave:Utility Shed" 134 1071531587 "Duncan, Dave" 3442 W. Charleston "Bayshore, CA 94326" 415-555-3823 DoubleD@samplename.com Dave Duncan N San Tomas Dave Duncan 0 N 0 CUST "Dunn, Eric C.W." 129 1071531088 "Dunn, Eric C.W." 97401 N. Liberty Ln "Bayshore, CA 94326" 415-555-3866 edunn@samplename.com Eric C.W. Dunn Residential Net 30 Y Tax San Tomas Eric C.W. Dunn 0 N 0 CUST "Dunn, Eric C.W.:Utility Shed" 130 1071531106 "Dunn, Eric C.W." 97401 N. Liberty Ln "Bayshore, CA 94326" 415-555-3866 edunn@samplename.com Eric C.W. Dunn N San Tomas Eric C.W. Dunn 0 N 0 CUST "Easley, Paula" 79 1071523957 Paula Easley 140 Bay View East Bayshore CA 94327 415-555-7311 paula@samplename.com Paula Easley Residential Net 30 Y Tax E. Bayshore/County "7/15/2002: Estimate given to Paula \n\n8/09/2002: Paula called and gave go ahead on project\n\n8/19/2002: Began work on project, received partial payment" Mrs. Paula Easley 0 N 0 CUST "Easley, Paula:Garage" 95 1071509601 Paula Easley 140 Bay View East Bayshore CA 94327 415-555-7311 paula@samplename.com Paula Easley N San Tomas Mrs. Paula Easley Remodel 4 N 0 CUST Ecker Designs 29 933272658 Deanna Ecker 95 Amber St Bayshore CA 94326 Ecker Designs 95 Amber St Bayshore CA 94326 Attn: Deanna Ecker 415-555-6687 415-555-0011 decker@samplename.com Deanna Roger Kimble Commercial Net 30 Y Tax San Tomas 12/5/2003: Called for an estimate on repair work due to water damage. Heard about us through Joe Madsen.\n\n12/11/2003: Called to let me know that her neighbors complained when we started working before 7:00 AM.\n\n12/14/2003: Wants to know how much we can get done by Christmas. Ms. Ecker Designs Deanna Ecker 10/25 hayleyho@hiphop.com Joe 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST Ecker Designs:Office Repairs 30 933272658 Deanna Ecker 95 Amber St Bayshore CA 94326 Deanna Ecker 95 Amber St Bayshore CA 94326 Attn: Deanna Ecker 415-555-6687 decker@samplename.com Deanna Commercial Net 30 N San Tomas 1297-03-ECKE Repairs 3 1998-12-10 1998-12-30 N 0 CUST "Fisher, Jennifer" 118 1071531735 Jennifer Fisher 7882 N. Lantana Lane "E. Bayshore, CA 94326" 415-555-5366 jfischer@samplename.com Jennifer Fisher Residential Due on receipt Y Tax E. Bayshore/County Jennifer Fisher 03-0123-5 0 N 0 CUST "Fisher, Jennifer:Garage Roof" 119 1071531794 Jennifer Fisher 7882 N. Lantana Lane "E. Bayshore, CA 94326" 415-555-5366 jfischer@samplename.com Jennifer Fisher Residential Due on receipt N E. Bayshore/County Jennifer Fisher 03-0123-5 Remove and Replace Damaged Garage Roof Repairs 4 2003-03-17 2003-03-28 2003-03-28 N 0 CUST "Fisher, Jennifer:Utility Shed" 131 1071531184 Jennifer Fisher 7882 N. Lantana Lane "E. Bayshore, CA 94326" 415-555-5366 jfischer@samplename.com Jennifer Fisher Residential Due on receipt N E. Bayshore/County Jennifer Fisher 03-0123-5 0 N 0 CUST "Fomin, Slava" 132 1071531354 Slava Fomin 3366 E. Maple "Bayshore, CA 94326" 415-555-7528 sfomin@samplename.com Slava Fomin Residential Net 30 Y Tax San Tomas Slava Fomin 0 N 0 CUST "Fomin, Slava:Utility Shed" 133 1071531366 Slava Fomin 3366 E. Maple "Bayshore, CA 94326" 415-555-7528 sfomin@samplename.com Slava Fomin N San Tomas Slava Fomin 0 N 0 CUST "Freeman, Kirby" 83 1071524431 Kirby Freeman 6856 Ocean View Bayshore CA 94326 415-555-4532 415-555-7414 kfreeman@samplename.com Kirby Freeman Sonya Bristol Residential Net 30 Y Tax San Tomas "11/27/2002: Estimate mailed to Mr. Freeman.\n\n12/03/2002: Received signed estimate accepting estimate.\nCalled customer and set start date of project for 12/09.\n\n12/30/2002: Customer called to express thanks for fast, professional job. \n\n01/07/2003: Receive thank you letter and photos of before and after for our portfolio. Mr. Freeman will contact us when he is ready for the kitchen remodeling." Kirby Freeman 0 N 0 CUST "Freeman, Kirby:Remodel Bathroom" 93 1071526640 Kirby Freeman 6856 Ocean View Bayshore CA 94326 415-555-4532 415-555-7414 kfreeman@samplename.com Kirby Freeman Sonya Bristol Residential N San Tomas Kirby Freeman Remodel 4 2002-12-09 2003-01-06 2002-12-27 N 0 CUST "Freeman, Kirby:Repairs" 141 1071533021 Kirby Freeman 6856 Ocean View Bayshore CA 94326 415-555-4532 415-555-7414 kfreeman@samplename.com Kirby Freeman Sonya Bristol Residential N San Tomas Kirby Freeman 0 N 0 CUST "Jacobsen, Doug" 31 933272658 Doug Jacobsen 6845 Ocean View "Bayshore, CA 94326" 415-555-4411 jacobsen@samplename.com Doug or Linda Residential Net 30 Y Tax San Tomas "12/10/2003: Doug called to get a quote on building him a new poolhouse. I told him it would probably run at least $25,000.\n\n12/13/2003: Doug called about getting a more detailed estimate on the poolhouse and gave specifications for flooring and doors." Mr. Doug Jacobsen dj@aol.com 7-16-46 Linda 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST "Jacobsen, Doug:Kitchen" 32 933272658 Doug Jacobsen 6845 Ocean View "Bayshore, CA 94326" 415-555-4411 jacobsen@samplename.com Doug or Linda Residential Net 30 N San Tomas 1097-01-DJAC Remodel 3 1998-12-05 1998-12-20 N 0 CUST "Jacobsen, Doug:Poolhouse" 33 933272658 Doug Jacobsen 6845 Ocean View "Bayshore, CA 94326" 415-555-4411 jacobsen@samplename.com Doug or Linda Residential Net 30 N San Tomas Doug Jacobsen 1 N 0 CUST "Jimenez, Cristina" 137 1071532355 Cristina Jimenez 6642 W. Skyline Dr "Bayshore, CA 94326" 415-555-5747 crissy-j@samplename.com Cristina Jimenez Residential Net 30 Y Tax San Tomas Cristina Jimenez 0 N 0 CUST "Jimenez, Cristina:Utility Shed" 138 1071532366 Cristina Jimenez 6642 W. Skyline Dr "Bayshore, CA 94326" 415-555-5747 crissy-j@samplename.com Cristina Jimenez N San Tomas Cristina Jimenez 0 N 0 CUST "Johnson, Gordon" 135 1071531861 Gordon Johnson 7230 W. First Ave "Bayshore, CA 94326" 415-555-5766 gjohnson@samplename.com Gordon Johnson Residential Net 30 Y Tax San Tomas Gordon Johnson 0 N 0 CUST "Johnson, Gordon:Utility Shed" 136 1071531882 Gordon Johnson 7230 W. First Ave "Bayshore, CA 94326" 415-555-5766 gjohnson@samplename.com Gordon Johnson N San Tomas Gordon Johnson 0 N 0 CUST "Keenan, Bridget" 81 1071524118 Bridget Keenan 213 Fern Lane East Bayshore CA 94327 415-555-2133 bridget@samplename.com Bridget Keenan Ann Mei Chang Residential Net 30 Y Tax E. Bayshore/County Bridget Keenan 0 N 0 CUST "Keenan, Bridget:Storage Shed" 125 1071526869 Bridget Keenan 213 Fern Lane East Bayshore CA 94327 415-555-2133 bridget@samplename.com Bridget Keenan Ann Mei Chang Net 30 N E. Bayshore/County Bridget Keenan Construct 12'x10' starage shed New Construction 4 2003-04-02 2003-12-05 2003-12-05 N 0 CUST "Keenan, Bridget:Sun Room" 108 1071526075 Bridget Keenan 213 Fern Lane East Bayshore CA 94327 415-555-2133 bridget@samplename.com Bridget Keenan Ann Mei Chang N E. Bayshore/County Bridget Keenan 4 N 0 CUST "Lamb, Brad" 76 1071523181 Brad Lamb 1921 Appleseed Lane Bayshore CA 94326 415-555-8163 415-555-7633 bridget@samplename.com Brad Lamb Maureen Pacific Residential Net 30 Y Tax San Tomas Mr. Brad Lamb 0 N 0 CUST "Lamb, Brad:Room Addition" 71 1071525403 Brad Lamb 1921 Appleseed Lane Bayshore CA 94326 415-555-8163 415-555-7633 bridget@samplename.com Brad Lamb Maureen Pacific Net 30 N San Tomas Mr. Brad Lamb 4 N 1 CUST Lew Plumbing - C 109 1071524215 Lew Plumbing 221 Old Bayshore Rd Bayshore CA 94326 415-555-5483 glew@samplename.com Glen L. Lew Commercial Net 30 Y Tax San Tomas Lew Plumbing is a Vendor \nSee the Vendor list Lew Plumbing Glen L. Lew 0 N 0 CUST "Luke, Noelani" 67 1071522151 Noelani Luke 913 Bay View East Bayshore CA 94327 415-555-1169 noelanil@samplename.com Noelani Luke Residential Net 30 Y Tax E. Bayshore/County Noelani Luke 0 N 0 CUST "Luke, Noelani:Kitchen" 88 1071526281 Noelani Luke 913 Bay View East Bayshore CA 94327 415-555-1169 noelanil@samplename.com Noelani Luke 1% 10 Net 30 N San Tomas Noelani Luke Remodel 4 2003-07-14 2003-08-06 2003-08-15 N 0 CUST "Luke, Noelani:Remodel Bathroom" 94 1071526675 Noelani Luke 913 Bay View East Bayshore CA 94327 415-555-1169 noelanil@samplename.com Noelani Luke N San Tomas Noelani Luke Remodel 4 2003-07-14 2003-07-30 2003-08-05 N 0 CUST "Melton, Johnny" 34 933272658 "Johnny Melton, DDS" "300 Main St, Suite 3" Bayshore CA 94326 415-555-8900 415-555-6711 drmelton@samplename.com Dr. Melton Kat Commercial Net 30 Y Tax San Tomas 10/18/2003: Received call from Johnny. Dental office damaged in earthquake Needs to rebuild. \n\n10/29/2003: Johnny called to give verbal approval of work to be done rebuilding dental office. Dr. Floss 'N Go Dental Care Johnny Melton 7/7/57 Flossngo@brushit.com Susan 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST "Melton, Johnny:Dental office" 35 933272658 "Johnny Melton, DDS" "300 Main St, Suite 3" Bayshore CA 94326 415-555-8900 415-555-6711 drmelton@samplename.com Dr. Melton Kat Commercial Net 30 N San Tomas 1197-01-MELT Repairs 3 1998-11-27 1998-12-20 N 0 CUST "Memeo, Jeanette" 70 1071522480 Jeanette Memeo 8313 Orange Blossom Dr Bayshore CA 94326 415-555-6567 415-555-3891 jmemeo@samplename.com Jeanette Memeo Ed Ruder Residential Net 60 Y Tax San Tomas Jeanette Memeo 0 N 0 CUST "Memeo, Jeanette:2nd story addition" 105 1071511449 Jeanette Memeo 8313 Orange Blossom Dr Bayshore CA 94326 415-555-6567 415-555-3891 jmemeo@samplename.com Jeanette Memeo Ed Ruder Net 60 N San Tomas Jeanette Memeo 0 N 0 CUST "Memeo, Jeanette:Utility Shed" 127 1071530557 Jeanette Memeo 8313 Orange Blossom Dr Bayshore CA 94326 415-555-6567 415-555-3891 jmemeo@samplename.comm Jeanette Memeo Ed Ruder Net 60 N San Tomas Jeanette Memeo 0 N 0 CUST "Milner, Eloyse" 77 1071523242 Eloyse Milner 4242 Cypress Hill Rd Bayshore CA 94326 415-555-2187 elliem@samplename.com Eloyse Milner Jenny Morgenthaler Residential Net 30 Y Tax San Tomas Eloyse Milner 0 N 0 CUST "Milner, Eloyse:Room addition" 107 1071525677 Eloyse Milner 4242 Cypress Hill Rd Bayshore CA 94326 415-555-2187 elliem@samplename.com Eloyse Milner Net 30 N San Tomas Eloyse Milner A193567 Room Addition Remodel 4 2003-04-28 2003-05-09 2003-05-09 N 0 CUST "Morgenthaler, Jenny" 111 1071510646 Jenny Morgenthaler 37105 E. Oasis Dr. "Middlefield, CA 94485" Jenny Morgenthaler 37105 E. Oasis Dr. "Middlefield, CA 94485" 555-415-5366 jm@samplename.com Jenny Morgenthaler Residential Net 30 Y Tax San Tomas Jenny Morgenthaler 0 N 0 CUST "Morgenthaler, Jenny:Room Addition" 112 1071512041 Jenny Morgenthaler 37105 E. Oasis Dr. "Middlefield, CA 94485" Jenny Morgenthaler 37105 E. Oasis Dr. "Middlefield, CA 94485" 555-415-5366 jm@samplename.com Jenny Morgenthaler Residential Net 30 N San Tomas See Estimate (bid) dated 2/03/2003\n Jenny Morgenthaler 0203-03R Enclose car port for family room Remodel 4 2003-02-10 2003-03-07 2003-02-28 N 0 CUST "Natiello, Ernesto" 36 933272658 Ernesto M Natiello "376 Pine St, #5E" Bayshore CA 94326 415-555-9811 ernie@samplename.com Ernesto M Natiello Bert Residential Net 30 Y Tax San Tomas "11/10/2003: Ernie called, thinks the estimate is too high.\n\n11/12/2003: Met with Ernie to discuss estimate in detail. He agreed that the price is fair.\n\n11/29/2003: Ernie called and loves the work we did. Thankful that we finished in time for turkey dinner." Mr. Ernesto M Natiello Bertnernie@aol.com 2/14/?? kmena@zzz.com Cindy 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST "Natiello, Ernesto:Kitchen" 37 933272658 Ernesto Natiello "376 Pine St, #5E" Bayshore CA 94326 415-555-9811 ernie@samplename.com Ernesto Natiello Residential Net 30 N San Tomas 1097-04-JMAD Remodel 4 1998-11-05 1998-11-20 1998-11-22 N 0 CUST "Nelson, Wilma" 72 1071522707 Wilma E Nelson "300 Main St, Suite 5" Bayshore CA 94326 415-555-6134 415-555-6135 wilman@samplename.com Wilma E Nelson Commercial Net 30 Y Tax San Tomas 9/15/2003: Customer call to state she accepted the estimate and wants work to begin Jan 15. Nelson Printing Wilma E Nelson 0 N 0 CUST "Nelson, Wilma:Office Remodel" 101 1071506078 Wilma E Nelson "300 Main St, Suite 5" Bayshore CA 94326 415-555-6134 415-555-6135 wilman@samplename.com Wilma E Nelson N San Tomas Nelson Printing Wilma E Nelson Remodel 2 N 0 CUST "Nguyen, Tuan" 68 1071522211 Tuan Nguyen 8292 Orange Blossom Dr Bayshore CA 94326 415-555-2951 tuann@samplename.com Tuan Nguyen Residential Due on receipt Y Tax San Tomas 8/20/2003: Received signed estimate. Work to begin 8/25\n\n10/15/2003: Called customer for payment - hospitalized.\n\n11/07/2003: Customer called and stated would not have balance until after 12/06 first check after back to work. Agreed to not send to collections. Tuan Nguyen 0 N 0 CUST "Nguyen, Tuan:Garage" 86 1071525552 Tuan Nguyen 8292 Orange Blossom Dr Bayshore CA 94326 415-555-2951 tuann@samplename.com Tuan Nguyen N San Tomas Tuan Nguyen Remodel 4 N 0 CUST "Overfield, David" 154 1071513245 David Overfield 7762 N. Littener "Bayshore, CA 94326" 415-555-6837 davido@samplename.com David Overfield Residential Net 30 Y Tax San Tomas David Overfield 0 N 0 CUST "Overfield, David:Utility Shed" 155 1071513304 David Overfield 7762 N. Littener "Bayshore, CA 94326" 415-555-6837 davido@samplename.com David Overfield N San Tomas David Overfield A2 Storage Building New Construction 0 2003-03-10 2003-03-14 2003-03-13 N 0 CUST "Prentice, Adelaide" 66 1071522044 Adelaide Prentice 1800 Appleseed Court Bayshore CA 94326 415-555-1813 adelaide@samplename.com Adelaide Prentice Residential Net 30 Y Tax San Domingo Adelaide Prentice 0 N 0 CUST "Prentice, Adelaide:Hippodrome playhouse" 87 1071525616 Adelaide Prentice 1800 Appleseed Court Bayshore CA 94326 415-555-1813 adelaide@samplename.com Adelaide Prentice Net 15 N San Domingo Adelaide Prentice 0 N 0 CUST Pretell Real Estate 38 933272658 Pretell Real Estate 222 Middlefield Ave Middlefield CA 94482 Pretell Real Estate 75 Sunset Rd Middlefield CA 94482 415-555-2222 415-555-3333 erikap@samplename.com Erika Pretell Eduardo Commercial Net 30 Y Tax San Domingo 4/27/2003: Dixie Lee needs work done on her Wilks Blvd property.\n\n7/15/2003: Loved everything we did except the color of the grout.\n\n9/15/2003: Dixie Lee called about getting an estimate for 75 Sunset. \n\n10/1/2003: Dixie Lee called to give the go ahead pretell@best.com 10/1 0 1996-09-23 1996-09-23 1996-09-23 N 0 CUST Pretell Real Estate:155 Wilks Blvd. 39 933272658 Pretell Real Estate 222 Middlefield Ave Middlefield CA 94482 Pretell Real Estate 155 Wilks Blvd. Middlefield CA 94482 415-555-2222 415-555-3333 erikap@samplename.com Erika Pretell Eduardo Commercial Net 30 N San Domingo 0997-02-PRET 10/5 New Construction 3 1998-12-10 N 0 CUST Pretell Real Estate:75 Sunset Rd. 40 933272658 Pretell Real Estate 222 Middlefield Ave Middlefield CA 94482 Pretell Real Estate 75 Sunset Road Middlefield CA 94482 415-555-2222 415-555-3333 erikap@samplename.com Erika Pretell Eduardo Commercial Net 30 N San Domingo 0297-02-PRET New Construction 3 1998-01-02 1998-03-15 N 0 CUST Reyes Properties - C 142 1071533409 Reyes Properties P.O. Box 2836 Middlefield CA 94482 415-555-7900 creyes@samplename.com Celso Reyes Commercial Net 30 Y Tax San Domingo Celso Reyes 0 N 0 CUST Reyes Properties - C:Repairs 143 1071533421 Reyes Properties P.O. Box 2836 Middlefield CA 94482 415-555-7900 creyes@samplename.com Celso Reyes Commercial Net 30 N San Domingo Celso Reyes 0 N 0 CUST "Rice, Linda" 156 1071513612 "Rice, Linda" 6225 N. Laguna Vista "Bayshore, CA 94326" 415-555-7423 lrice@samplename.com Linda Rice Residential Net 30 Y Tax San Tomas Linda Rice 0 N 0 CUST "Rice, Linda:Repairs" 157 1071513661 "Rice, Linda" 6225 N. Laguna Vista "Bayshore, CA 94326" 415-555-7423 lrice@samplename.com Linda Rice Net 30 N San Tomas Linda Rice Repair Garage roof and facia Repairs 4 2003-12-17 N 0 CUST "Robson, Darci" 65 1071521960 Dr. Darci Robson "300 Main St, Suite 2" Bayshore CA 94326 415-555-3925 415-555-3926 drobson@samplename.com Darci Robson Commercial Net 30 Y Tax San Tomas 11/26/2003: Customer wants it done before the first of the year. Dr. Darci Robson 0 N 0 CUST "Robson, Darci:Robson Clinic" 97 1071519006 Dr. Darci Robson "300 Main St, Suite 2" Bayshore CA 94326 Dr. Darci Robson "300 Main St, Suite 2" Bayshore CA 94326 415-555-3925 415-555-3926 drobson@samplename.com Darci Robson N San Tomas Dr. Robson Clinic Darci Robson Remodel 3 N 0 CUST "Roche, Diarmuid" 82 1071524399 Diarmuid Roche 3219 Lisa Lane Bayshore CA 94326 415-555-7442 droche@samplename.com Diarmuid Roche Renee Barley Residential Due on receipt Y Tax San Tomas Mr. Diarmuid Roche 0 N 0 CUST "Roche, Diarmuid:Garage repairs" 90 1071526431 Diarmuid Roche 3219 Lisa Lane Bayshore CA 94326 415-555-7442 droche@samplename.com Diarmuid Roche Renee Barley N San Tomas Mr. Diarmuid Roche Repairs 4 N 0 CUST "Roche, Diarmuid:Room addition" 106 1071525654 droche@samplename.com N San Tomas 0 N 0 CUST "Ruff, Bryan" 84 1071524493 Bryan Ruff 782 Skyline Dr East Bayshore CA 94327 415-555-7787 bruff@samplename.com Bryan Ruff Residential Net 30 Y Tax E. Bayshore/County 07/09/2002: Saw truck while driving and called for an estimate.\nScheduled appt. for 7/12 to see what we can do.\n\n07/12/2002:Mr. Ruff wants to add sun room. Prepared the estimate and agreed to it on the spot with out other estimates. Mr. Bryan Ruff 0 N 0 CUST "Ruff, Bryan:Sun Room" 92 1071526575 Bryan Ruff 782 Skyline Dr East Bayshore CA 94327 415-555-7787 bruff@samplename.com Bryan Ruff N San Tomas Mr. Bryan Ruff Remodel 4 N 0 CUST "Ruff, Bryan:Utility Shed" 128 1071530734 Bryan Ruff 782 Skyline Dr East Bayshore CA 94327 415-555-7787 bruff@samplename.com Bryan Ruff N E. Bayshore/County Mr. Bryan Ruff 0 N 0 CUST "Smallson, Fran" 85 1071524534 Fran Smallson 5437 Euclid St Bayshore CA 94326 Smallson Electric 5437 Euclid St Bayshore CA 94326 415-555-8883 415-555-8885 frans@samplename.com Fran Smallson Alan Sun Commercial Net 30 Y Tax San Tomas Smallson Electric Fran Smallson 0 N 0 CUST "Smallson, Fran:Office remodeling" 96 1071508427 Fran Smallson 5437 Euclid St Bayshore CA 94326 Smallson Electric 5437 Euclid St Bayshore CA 94326 415-555-8883 415-555-8885 frans@samplename.com Fran Smallson Alan Sun Net 15 N San Tomas Smallson Electric Fran Smallson 3 N 0 CUST "Smith, Lee" 78 1071523876 Lee M Smith 431 Hampshire Blvd East Bayshore CA 94327 Smith Photography 910 Grapevine Ave East Bayshore CA 94327 415-555-3151 lsmith@samplename.com Lee M Smith Shannon Van Campen Commercial Net 30 Y Tax E. Bayshore/County 08/27/2003: Mr. Smith invoiced for patio at studio.\n\n08/29/2003: Shannon brought in down payment.\n\n11/03/2003: Mr. Smith called - appologies for delay in pament.\nStudio robbed. A payment will be coming shortly. \n\n11/11/2003: Shannon brought in payment. Will not charge further FC on outstanding balance. Smith Photography Lee M Smith 0 N 0 CUST "Smith, Lee:Patio" 98 1071526513 Lee M Smith 431 Hampshire Blvd East Bayshore CA 94327 Smith Photography 910 Grapevine Ave East Bayshore CA 94327 415-555-3151 lsmith@samplename.com Lee M Smith Shannon Van Campen Net 30 N San Tomas Smith Photography Lee M Smith 4 2003-09-02 N 0 CUST "Teichman, Tim" 69 1071522347 Tim Teichman 2353 Lisa lane Bayshore CA 94326 415-555-4153 tim@samplename.com Tim Teichman Jake Thomas Residential Net 60 Y Tax San Tomas Mr. Tim Teichman 0 N 0 CUST "Teichman, Tim:Kitchen" 104 1071498245 Tim Teichman 2353 Lisa lane Bayshore CA 94326 415-555-4153 tim@samplename.com Tim Teichman Jake Thomas Net 60 N San Tomas Mr. Tim Teichman 4 N 0 CUST "Teschner, Anton" 41 933272658 Anton Teschner 2424 Lisa Lane "Bayshore, CA 94326" 415-555-4567 antont@samplename.com Anton Teschner Jane Residential Net 15 Y Tax San Tomas 11/15/2003: Send to collections - \nAnton has refused to pay for services rendered Anton Teschner Atesh@best.com 1/11 Jane 0 N 0 CUST "Teschner, Anton:Sun Room" 42 933272658 Anton Teschner 2424 Lisa Lane "Bayshore, CA 94326" 415-555-4567 antont@samplename.com Jane Residential Net 15 N San Tomas 1197-03-LFAV Remodel 3 N 0 CUST "Violette, Mike" 80 1071524001 Mike Violette 143 Bay View East Bayshore CA 94327 415-555-4417 415-555-9191 mikev@samplename.com Mike Violette Residential Net 30 Y Tax E. Bayshore/County Mr. Mike Violette 0 N 0 CUST "Violette, Mike:Utility Room" 110 1071509585 Mike Violette 143 Bay View East Bayshore CA 94327 415-555-4417 415-555-9191 mikev@samplename.com Mike Violette Net 30 N E. Bayshore/County Lew Plumbing will subcontract Mr. Mike Violette Utility Room Build Out w/plumbing & fixtures Remodel 4 2003-02-03 2003-03-24 2003-03-22 N 0 CUST "Violette, Mike:Workshop" 91 1071526457 Mike Violette 143 Bay View East Bayshore CA 94327 415-555-4417 415-555-9191 mikev@samplename.com Mike Violette Net 60 N San Tomas Mike Violette New Construction 3 N 0 CUST "Wilks, Daniel" 75 1071523131 Daniel Wilks 516 Hampshire Blvd East Bayshore CA 94327 415-555-4287 dan@samplename.com Daniel Wilks Jeanette Deen Residential Net 60 Y Tax E. Bayshore/County 02/07/2003: Mr. Wilks called. Referred by Bryan Ruff. Wants to have the master bathroom remodeled. Set 02/17/2003 to start work.\n\n Daniel Wilks 0 N 0 CUST "Wilks, Daniel:Remodel Bathroom" 103 1071517519 Daniel Wilks 516 Hampshire Blvd East Bayshore CA 94327 415-555-4287 dan@samplename.com Daniel Wilks Jeanette Deen Net 60 N E. Bayshore/County Daniel Wilks 4 2003-02-17 N 0 CUST "Yoo, Young-Kyu" 74 1071523027 Young-Kyu Yoo 1967 Appleseed Lane Bayshore CA 94326 415-555-6174 young@samplename.com Young-Kyu Yoo Residential Net 30 Y Tax San Tomas Young-Kyu Yoo 0 N 0 CUST "Yoo, Young-Kyu:Repairs" 102 1071517190 Young-Kyu Yoo 1967 Appleseed Lane Bayshore CA 94326 415-555-6174 young@samplename.com Young-Kyu Yoo Due on receipt N San Tomas Young-Kyu Yoo 4 N 0