{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["InvoiceReport"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"InvoiceReport","index":0,"n_rows":117,"n_cols":103,"rows_kept":117,"cut":false,"hidden":false,"merged":[[0,2,2,2],[2,17,2,57],[0,60,2,60],[0,3,2,3]]}
[null,null,"Customers with balance over $1","Unpaid Invoices Over 30 Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice List"]
[]
[]
[null,null,"ClassRefListID","Customer Name","Ref Number","PO Number","Term","Open Balance","Due Date","Aging Days","ClassRefFullName","BillAddressAddr1","BillAddressAddr2","BillAddressAddr3","BillAddressAddr4","BillAddressAddr5","BillAddressCity","BillAddressState","BillAddressProvince","BillAddressCounty","BillAddressPostalCode","BillAddressCountry","BillAddressNote","BillAddressBlockAddr1","BillAddressBlockAddr2","BillAddressBlockAddr3","BillAddressBlockAddr4","BillAddressBlockAddr5","ShipAddressAddr1","ShipAddressAddr2","ShipAddressAddr3","ShipAddressAddr4","ShipAddressAddr5","ShipAddressCity","ShipAddressState","ShipAddressProvince","ShipAddressCounty","ShipAddressPostalCode","ShipAddressCountry","ShipAddressNote","ShipAddressBlockAddr1","ShipAddressBlockAddr2","ShipAddressBlockAddr3","ShipAddressBlockAddr4","ShipAddressBlockAddr5","TermsRefListID","TermsRefFullName","SalesRepRefListID","SalesRepRefFullName","ItemSalesTaxRefListID","ItemSalesTaxRefFullName","CurrencyRefListID","CurrencyRefFullName","TimeCreated","TimeModified","EditSequence","CustomerRefListID","CustomerRefFullName","ARAccountRefListID","ARAccountRefFullName","TemplateRefListID","TemplateRefFullName","TxnDate","RefNumber","IsPending","IsFinanceCharge","PONumber","Terms","DueDate","FOB","ShipDate","ShipMethodRefListID","ShipMethodRefFullName","Subtotal","SalesTaxPercentage","SalesTaxTotal","AppliedAmount","BalanceRemaining","ExchangeRate","BalanceRemainingInHomeCurrency","Memo","IsPaid","CustomerMsgRefListID","CustomerMsgRefFullName","IsToBePrinted","IsToBeEmailed","IsTaxIncluded","CustomerSalesTaxCodeRefListID","CustomerSalesTaxCodeRefFullName","CustomerTaxCodeRefListID","SuggestedDiscountAmount","SuggestedDiscountDate","CustomFieldOther","LinkToTxnID1","Tax1Total","Tax2Total","AmountIncludesVAT","TxnID","TxnNumber","CustomFieldBDay","CustomFieldContract","CustomFieldSpousesName","TxnDateMacro"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Prentice, Adelaide:Bay Window"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"975"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-05-27"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Adelaide Prentice","1800 Appleseed Court","","","","Bayshore","CA","CA","CA","94326","","","Adelaide Prentice","1800 Appleseed Court","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","12/16/2003 3:40:56 AM","12/15/2019 10:34:03 PM","1576429245","800000B8-1197707458","Prentice, Adelaide:Bay Window","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/28/2018 12:00:00 AM","975",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42517,"","11/28/2020 12:00:00 AM","","",413.5,7.5,18.45,-431.95,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2453-1071526256",417,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Melton, Johnny:Basement Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"978"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-05-29"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Johnny Melton, DDS","300 Main St, Suite 3","","","","Bayshore","CA","CA","CA","94326","","","Johnny Melton, DDS","300 Main St, Suite 3","Bayshore CA 94326","","","Johnny Melton, DDS","300 Main St, Suite 3","","","","Bayshore","CA","CA","CA","94326","","","Johnny Melton, DDS","300 Main St, Suite 3","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:44:14 AM","12/15/2019 10:34:01 PM","1576429387","800000B7-1197706241","Melton, Johnny:Basement Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/30/2018 12:00:00 AM","978",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42519,"","11/30/2020 12:00:00 AM","","",14330.5,7.75,158.13999999999999,-14488.64,0,"","","",true,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","469E-1071530054",1067,"7/7/57","","Susan","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:75 Sunset Rd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"985"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-05-30"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","75 Sunset Road","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","75 Sunset Road","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","8/4/1999 9:59:57 PM","12/15/2019 10:34:25 PM","1576429222","280000-933272658","Pretell Real Estate:75 Sunset Rd.","40000-933270541","Accounts Receivable","20001-1197739370","Intuit Product Invoice","12/1/2018 12:00:00 AM","985",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42520,"","12/1/2020 12:00:00 AM","","",11170.96,7.5,614.09,-11785.05,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","D7E-933784197",251,"","0297-02-PRET","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Smallson, Fran:Office remodeling"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"987"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-05-31"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Fran Smallson","5437 Euclid St","","","","Bayshore","CA","CA","CA","94326","","","Fran Smallson","5437 Euclid St","Bayshore CA 94326","","","Smallson Electric","5437 Euclid St","","","","Bayshore","CA","CA","CA","94326","","","Smallson Electric","5437 Euclid St","Bayshore CA 94326","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/16/2003 3:43:05 AM","12/15/2019 10:34:03 PM","1576429253","600000-1071508427","Smallson, Fran:Office remodeling","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/9/2018 12:00:00 AM","987",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42521,"","12/9/2020 12:00:00 AM","","",1665,7.75,0,-1665,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","26BB-1071526385",460,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Ecker Designs:Office Expansion"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"990"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":"A905-01"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-01"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Deanna Ecker","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","","Deanna Ecker","95 Amber St","Bayshore CA 94326","","","Ecker Designs","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","Attn: Deanna Ecker","Ecker Designs","95 Amber St","Bayshore CA 94326","Attn: Deanna Ecker","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","8/4/1999 11:06:28 PM","12/15/2019 10:34:01 PM","1576429229","800000B6-1197702033","Ecker Designs:Office Expansion","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","12/15/2018 12:00:00 AM","990",false,false,"A905-01",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42522,"","12/15/2020 12:00:00 AM","","",4690,7.75,67.81,-4757.8100000000004,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","F57-933788188",295,"10/25","","Joe","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Baker, Chris:Garage Repair"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"991"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-02"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Baker, Chris","415 W. Desert Bloom","","","","Bayshore","CA","CA","CA","94326","","","Baker, Chris","415 W. Desert Bloom","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 2:04:52 AM","12/15/2019 10:34:04 PM","1576429372","800000B9-1197733691","Baker, Chris:Garage Repair","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","12/15/2018 12:00:00 AM","991",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42523,"","12/15/2020 12:00:00 AM","","",1040,7.75,0,-1040,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4346-1071520492",1041,"","03-1234567","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:75 Sunset Rd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"992"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-03"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","75 Sunset Road","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","75 Sunset Road","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","12/16/2003 3:18:28 AM","12/15/2019 10:34:25 PM","1576429382","280000-933272658","Pretell Real Estate:75 Sunset Rd.","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/15/2018 12:00:00 AM","992",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42524,"","12/15/2020 12:00:00 AM","","",12412.18,7.5,614.09,-13026.27,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","44A8-1071524908",1059,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Ecker Designs:Office Expansion"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"993"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-04"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Deanna Ecker","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","","Deanna Ecker","95 Amber St","Bayshore CA 94326","","","Ecker Designs","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","Attn: Deanna Ecker","Ecker Designs","95 Amber St","Bayshore CA 94326","Attn: Deanna Ecker","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 3:21:47 AM","12/15/2019 10:34:01 PM","1576429383","800000B6-1197702033","Ecker Designs:Office Expansion","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/15/2018 12:00:00 AM","993",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42525,"","12/15/2020 12:00:00 AM","","",1397,7.75,71.3,-1468.3,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","44F3-1071525107",1060,"10/25","","Joe","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Castillo, Eloisa:Bay Window"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"994"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-05"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Eloisa Castillo","8321 S. Flower","","","","E. Bayshore","CA","CA","CA","94781","","","Eloisa Castillo","8321 S. Flower","E. Bayshore, CA  94781","","","Eloisa Castillo","8321 S. Flower","","","","E. Bayshore","CA","CA","CA","94781","","","Eloisa Castillo","8321 S. Flower","E. Bayshore, CA  94781","","","20000-933272658","Net 15","","","350000-1071521574","East Bayshore","","","12/15/2003 11:47:40 PM","12/15/2019 10:34:00 PM","1576429395","800000B5-1197701259","Castillo, Eloisa:Bay Window","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/23/2018 12:00:00 AM","994",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42526,"","12/23/2020 12:00:00 AM","","",361.08,0.3,0,-361.08,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4909-1071512260",1079,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Vasquez, Anabel:Basement Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1001"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-06"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Anabel Vasquez","5601 Legacy Parkway","","","","San Mateo","CA","CA","CA","09402","","","Anabel Vasquez","5601 Legacy Parkway","San Mateo, CA 09402","","","Anabel Vasquez","5601 Legacy Parkway","","","","San Mateo","CA","CA","CA","09402","","","Anabel Vasquez","5601 Legacy Parkway","San Mateo, CA 09402","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/15/2007 8:57:23 PM","12/15/2019 10:34:26 PM","1576429452","800000B3-1197778093","Vasquez, Anabel:Basement Remodel","40000-933270541","Accounts Receivable","130000-1071512842","Custom S.O. Invoice","1/28/2019 12:00:00 AM","1001",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42527,"","11/20/2020 12:00:00 AM","","",800,7.75,62,-862,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8AC9-1197732443",1421,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Vasquez, Anabel:Basement Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1002"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-07"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Anabel Vasquez","5601 Legacy Parkway","","","","San Mateo","CA","CA","CA","09402","","","Anabel Vasquez","5601 Legacy Parkway","San Mateo, CA 09402","","","Anabel Vasquez","5601 Legacy Parkway","","","","San Mateo","CA","CA","CA","09402","","","Anabel Vasquez","5601 Legacy Parkway","San Mateo, CA 09402","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/16/2007 10:14:09 AM","12/15/2019 10:34:26 PM","1576429448","800000B3-1197778093","Vasquez, Anabel:Basement Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","1/31/2019 12:00:00 AM","1002",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42528,"","1/29/2020 12:00:00 AM","","",23205.24,7.75,1404.32,-24609.56,0,"","","Basement Remodel",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","69F9-1197780249",1371,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Kanitz, Marion:Bay Window"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1003"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-08"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Marion Kanitz","3940 Cleveland Lane","","","","Bayshore","CA","CA","CA","94326","","","Marion Kanitz","3940 Cleveland Lane","Bayshore CA 94326","","","Marion Kanitz","3940 Cleveland Lane","","","","Bayshore","CA","CA","CA","94326","","","Marion Kanitz","3940 Cleveland Lane","Bayshore CA 94326","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/15/2007 9:36:48 PM","12/15/2019 10:34:24 PM","1576429454","800000BB-1197734773","Kanitz, Marion:Bay Window","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","2/18/2019 12:00:00 AM","1003",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42529,"","2/18/2019 12:00:00 AM","","",6195.2,7.75,83.6,-6278.8,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8B5C-1197734808",1428,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Bauman, Mark:Home Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1004"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-09"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Mark Bauman","910 S. Ivy","","","","Bayshore","CA","CA","CA","94326","","","Mark Bauman","910 S. Ivy","Bayshore, CA   94326","","","Mark Bauman","910 S. Ivy","","","","Bayshore","CA","CA","CA","94326","","","Mark Bauman","910 S. Ivy","Bayshore, CA 94326","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 9:55:44 AM","12/15/2019 10:34:28 PM","1576429467","780000-1071507712","Bauman, Mark:Home Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/28/2019 12:00:00 AM","1004",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42530,"","6/16/2020 12:00:00 AM","","",16500,7.75,0,-16500,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","9C44-1182054344",1485,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Jacobsen, Doug:Poolhouse"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1005"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-10"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Doug Jacobsen","6845 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Doug Jacobsen","6845 Ocean View","Bayshore, CA 94326","","","Doug Jacobsen","6845 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Doug Jacobsen","6845 Ocean View","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2007 9:38:07 PM","12/15/2019 10:34:24 PM","1576429455","210000-933272658","Jacobsen, Doug:Poolhouse","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","4/16/2019 12:00:00 AM","1005",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42531,"","4/16/2019 12:00:00 AM","","",7673.5,7.75,318.02,-7991.52,0,"","","",true,"80000-1071553460","Please sign this Change Order to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8BB7-1197734887",1429,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fisher, Jennifer:Home Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1006"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-11"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore,  CA  94326","","","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore, CA 94326","","","30000-933272658","Due on receipt","","","360000-1071521681","E. Bayshore/County","","","6/17/2007 10:04:59 AM","12/15/2019 10:34:29 PM","1576429468","830000-1071531184","Fisher, Jennifer:Home Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","5/14/2019 12:00:00 AM","1006",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42532,"","6/16/2020 12:00:00 AM","","",16500,8.0500000000000007,0,-16500,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","9C92-1182054899",1489,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Nelson, Wilma:Office Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1007"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-12"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Wilma E Nelson","300 Main St, Suite 5","","","","Bayshore","CA","CA","CA","94326","","","Wilma E Nelson","300 Main St, Suite 5","Bayshore CA 94326","","","Wilma E Nelson","300 Main St, Suite 5","","","","Bayshore","CA","CA","CA","94326","","","Wilma E Nelson","300 Main St, Suite 5","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","6/17/2007 10:11:34 AM","12/15/2019 10:34:30 PM","1576429469","650000-1071506078","Nelson, Wilma:Office Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/16/2019 12:00:00 AM","1007",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42533,"","6/16/2020 12:00:00 AM","","",11605,7.75,0,-11605,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","9CC8-1182055294",1493,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Ruff, Bryan:Sun Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1008"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-13"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Bryan Ruff","782 Skyline Dr","","","","East Bayshore","CA","CA","CA","94327","","","Bryan Ruff","782 Skyline Dr","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 12:00:46 AM","12/15/2019 10:31:09 PM","1576429267","5C0000-1071526575","Ruff, Bryan:Sun Room","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","7/20/2019 12:00:00 AM","1008",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42534,"","11/15/2019 12:00:00 AM","","",5354.56,8.0500000000000007,161.49,-5516.05,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2AC7-1071513046",496,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Prentice, Adelaide:Guest Villa"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1009"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-14"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Adelaide Prentice","1800 Appleseed Court","","","","Bayshore","CA","CA","CA","94326","","","Adelaide Prentice","1800 Appleseed Court","Bayshore CA 94326","","","Adelaide Prentice","1800 Appleseed Court","","","","Bayshore","CA","CA","CA","94326","","","Adelaide Prentice","1800 Appleseed Court","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","6/17/2007 10:29:23 AM","12/15/2019 10:34:31 PM","1576429470","570000-1071525616","Prentice, Adelaide:Guest Villa","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","8/20/2019 12:00:00 AM","1009",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42535,"","7/20/2019 12:00:00 AM","","",36575,7.5,0,-36575,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","9CFA-1182056363",1497,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Sauler, Lyn:Home Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1010"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-15"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Lyn Sauler","8394 Weatherby Lane","","","","Millbrae","CA","CA","CA","94030","","","Lyn Sauler","8394 Weatherby Lane","Millbrae, CA 94030","","","Lyn Sauler","8394 Weatherby Lane","","","","Millbrae","CA","CA","CA","94030","","","Lyn Sauler","8394 Weatherby Lane","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 10:58:20 AM","12/15/2019 10:34:37 PM","1576429472","800000C0-1182057856","Sauler, Lyn:Home Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","9/20/2019 12:00:00 AM","1010",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42536,"","6/17/2020 12:00:00 AM","","",16115,7.75,0,-16115,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D38-1182058100",1501,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Lamb, Brad:Room Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1011"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-16"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Brad Lamb","1921 Appleseed Lane","","","","Bayshore","CA","CA","CA","94326","","","Brad Lamb","1921 Appleseed Lane","Bayshore CA 94326","","","Brad Lamb","1921 Appleseed Lane","","","","Bayshore","CA","CA","CA","94326","","","Brad Lamb","1921 Appleseed Lane","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 2:47:47 AM","12/15/2019 10:31:12 PM","1576429269","470001-1071525403","Lamb, Brad:Room Addition","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","10/1/2019 12:00:00 AM","1011",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42537,"","10/1/2019 12:00:00 AM","","",10834.87,7.75,337.73,-11172.6,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2B55-1071523067",500,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Easley, Paula:Garage"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1012"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-17"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Paula Easley","140 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Paula Easley","140 Bay View","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","360000-1071521681","E. Bayshore/County","","","12/15/2003 11:15:51 PM","12/15/2019 10:30:35 PM","1576429234","5F0000-1071509601","Easley, Paula:Garage","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","10/9/2019 12:00:00 AM","1012",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42538,"","10/9/2019 12:00:00 AM","","",2360,8.0500000000000007,159.38999999999999,-2519.39,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","223A-1071510351",392,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Bolinski, Rafal:2nd story addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1013"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-18"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Rafal Bolinski","1421 Silverbell Ave","","","","East Bayshore","CA","CA","CA","94327","","","Rafal Bolinski","1421 Silverbell Ave","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/15/2003 11:34:04 PM","12/15/2019 10:31:03 PM","1576429261","590000-1071526363","Bolinski, Rafal:2nd story addition","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","10/14/2019 12:00:00 AM","1013",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42539,"","10/14/2019 12:00:00 AM","","",4976.95,7.75,102.53,-5079.4799999999996,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2919-1071511444",482,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Bolinski, Rafal:2nd story addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1014"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-19"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Rafal Bolinski","1421 Silverbell Ave","","","","East Bayshore","CA","CA","CA","94327","","","Rafal Bolinski","1421 Silverbell Ave","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/15/2003 11:36:30 PM","12/15/2019 10:31:04 PM","1576429263","590000-1071526363","Bolinski, Rafal:2nd story addition","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","11/26/2019 12:00:00 AM","1014",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42540,"","11/26/2019 12:00:00 AM","","",4976.95,7.75,102.53,-5079.4799999999996,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","29CC-1071511590",484,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Freeman, Kirby:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1015"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-20"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kirby Freeman","6856 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Kirby Freeman","6856 Ocean View","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 2:34:28 AM","12/15/2019 10:30:38 PM","1576429237","5D0000-1071526640","Freeman, Kirby:Remodel Bathroom","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","12/9/2019 12:00:00 AM","1015",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42541,"","12/9/2019 12:00:00 AM","","",1844.07,7.75,23.82,-1867.89,0,"","","",true,"60000-933272660","We appreciate your prompt payment.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","229C-1071522268",396,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Freeman, Kirby:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1016"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-21"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kirby Freeman","6856 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Kirby Freeman","6856 Ocean View","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 2:39:11 AM","12/15/2019 10:30:39 PM","1576429239","5D0000-1071526640","Freeman, Kirby:Remodel Bathroom","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","12/20/2019 12:00:00 AM","1016",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42542,"","12/20/2019 12:00:00 AM","","",1844.07,7.75,23.82,-1867.89,0,"","","",true,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","22FA-1071522551",398,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Freeman, Kirby:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1017"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-22"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kirby Freeman","6856 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Kirby Freeman","6856 Ocean View","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 2:41:13 AM","12/15/2019 10:30:41 PM","1576429240","5D0000-1071526640","Freeman, Kirby:Remodel Bathroom","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","12/27/2019 12:00:00 AM","1017",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42543,"","12/27/2019 12:00:00 AM","","",1899.86,7.75,24.54,-1924.4,0,"","","",true,"10000-933272660","All work is complete!",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2358-1071522673",400,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Bristol, Sonya:Repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1018"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-23"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Sonya Bristol","5920 N. Lighthouse","","","","Bayshore","CA","CA","CA","94326","","","Sonya Bristol","5920 N. Lighthouse","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/15/2003 9:59:03 PM","12/15/2019 10:32:27 PM","1576429346","910000-1071505273","Bristol, Sonya:Repairs","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","1/4/2020 12:00:00 AM","1018",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42544,"","1/4/2020 12:00:00 AM","","",93.84,7.75,1.85,-95.69,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3F45-1071505743",850,"","B03-123456789","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Yoo, Young-Kyu:Repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1019"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-24"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Young-Kyu Yoo","1967 Appleseed Lane","","","","Bayshore","CA","CA","CA","94326","","","Young-Kyu Yoo","1967 Appleseed Lane","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","30000-933272658","Due on receipt","","","2E0000-933272656","San Tomas","","","12/16/2003 1:11:24 AM","12/15/2019 10:34:26 PM","1576429273","660000-1071517190","Yoo, Young-Kyu:Repairs","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","1/7/2020 12:00:00 AM","1019",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42545,"","1/7/2020 12:00:00 AM","","",3915,7.75,0,-3915,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2E49-1071517284",515,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Larsen's Pet Shop:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1020"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-25"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Larsen's Pet Shop","Jeff Larsen","Winston St.","","","Millbrae","CA","CA","CA","94030","","","Larsen's Pet Shop","Jeff Larsen","Winston St.","Millbrae, CA 94030","","Larsen's Pet Shop","Jeff Larsen","Winston St.","","","Millbrae","CA","CA","CA","94030","","","Larsen's Pet Shop","Jeff Larsen","Winston St.","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:12:06 AM","12/15/2019 10:34:35 PM","1576429472","800000C2-1182058808","Larsen's Pet Shop:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","1/16/2020 12:00:00 AM","1020",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42546,"","1/16/2020 12:00:00 AM","","",13900,7.75,0,-13900,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D45-1182058926",1502,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Barley, Renee:Repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1021"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-26"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Renee Barley","4417 N. Sun Valley Rd","","","","Middlefield","CA","CA","CA","94471","","","Renee Barley","4417 N. Sun Valley Rd","Middlefield, CA  94471","","","","","","","","","","","","","","","","","","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/15/2003 10:09:15 PM","12/15/2019 10:34:22 PM","1576429347","930000-1071506202","Barley, Renee:Repairs","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","1/17/2020 12:00:00 AM","1021",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42547,"","1/17/2020 12:00:00 AM","","",3000,7.75,186,-3186,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3F5E-1071506355",853,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Balak, Mike:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1022"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-27"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Mike Balak","8753 S. Mountain View","","","","Bayshore","CA","CA","CA","94326","","","Mike Balak","8753 S. Mountain View","Bayshore, CA  94326","","","Mike Balak","8753 S. Mountain View","","","","Bayshore","CA","CA","CA","94326","","","Mike Balak","8753 S. Mountain View","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/15/2003 10:43:08 PM","12/15/2019 10:32:32 PM","1576429351","970000-1071508343","Balak, Mike:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","1/20/2020 12:00:00 AM","1022",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42548,"","1/20/2020 12:00:00 AM","","",1999,7.75,93,-2092,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3FE5-1071508388",868,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Rice, Linda:Repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1023"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-28"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Rice, Linda","6225 N. Laguna Vista","","","","Bayshore","CA","CA","CA","94326","","","Rice, Linda","6225 N. Laguna Vista","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 12:13:22 AM","12/15/2019 10:32:47 PM","1576429363","9D0000-1071513661","Rice, Linda:Repairs","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","1/30/2020 12:00:00 AM","1023",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42549,"","1/30/2020 12:00:00 AM","","",1830,7.75,38.36,-1868.36,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","40B1-1071513802",887,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Abercrombie, Kristy:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1024"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-29"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore CA 94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2007 9:12:41 PM","12/15/2019 10:34:21 PM","1576429453","170000-933272658","Abercrombie, Kristy:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","2/1/2020 12:00:00 AM","1024",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42550,"","2/1/2020 12:00:00 AM","","",4792,7.75,227.08,-5019.08,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8B12-1197733361",1422,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Davies, Aaron:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1025"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-06-30"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Aaron Davies","92104 Millford Way","","","","Millbrae","CA","CA","CA","94030","","","Aaron Davies","92104 Millford Way","Millbrae, CA 94030","","","Aaron Davies","92104 Millford Way","","","","Millbrae","CA","CA","CA","94030","","","Aaron Davies","92104 Millford Way","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:15:51 AM","12/15/2019 10:34:34 PM","1576429472","800000C4-1182059125","Davies, Aaron:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","2/16/2020 12:00:00 AM","1025",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42551,"","2/16/2020 12:00:00 AM","","",14560,7.75,0,-14560,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D53-1182059151",1503,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Wilks, Daniel:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1026"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 60"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-01"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Daniel Wilks","516 Hampshire Blvd","","","","East Bayshore","CA","CA","CA","94327","","","Daniel Wilks","516 Hampshire Blvd","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","60000-933272660","Net 60","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 3:00:05 AM","12/15/2019 10:31:16 PM","1576429273","670000-1071517519","Wilks, Daniel:Remodel Bathroom","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","2/17/2020 12:00:00 AM","1026",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 60"},42552,"","2/17/2020 12:00:00 AM","","",4306.75,8.0500000000000007,290.52999999999997,-4597.28,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2E61-1071523805",519,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Overfield, David:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1027"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-02"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","David Overfield","7762 N. Littener","","","","Bayshore","CA","CA","CA","94326","","","David Overfield","7762 N. Littener","Bayshore, CA  94326","","","David Overfield","7762 N. Littener","","","","Bayshore","CA","CA","CA","94326","","","David Overfield","7762 N. Littener","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 12:05:15 AM","12/15/2019 10:32:47 PM","1576429355","9B0000-1071513304","Overfield, David:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/13/2020 12:00:00 AM","1027",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42553,"","3/13/2020 12:00:00 AM","","",1999,7.75,93,-2092,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","40AA-1071513315",886,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Castillo, Eloisa:Utility Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1028"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-03"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Eloisa Castillo","8321 S. Flower","","","","E. Bayshore","CA","CA","CA","94781","","","Eloisa Castillo","8321 S. Flower","E. Bayshore, CA  94781","","","Eloisa Castillo","8321 S. Flower","","","","E. Bayshore","CA","CA","CA","94781","","","Eloisa Castillo","8321 S. Flower","E. Bayshore, CA  94781","","","20000-933272658","Net 15","","","350000-1071521574","East Bayshore","","","12/15/2003 11:56:01 PM","12/15/2019 10:34:23 PM","1576429329","7A0000-1071512142","Castillo, Eloisa:Utility Room","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/14/2020 12:00:00 AM","1028",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42554,"","3/14/2020 12:00:00 AM","","",4577.3,0.3,12.51,-4589.8100000000004,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3C24-1071512761",769,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Carr's Pie Shop:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1029"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-04"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Carr's Pie Shop","Steve Carr","19348 Festing Lane","","","Millbrae","CA","CA","CA","94030","","","Carr's Pie Shop","Steve Carr","19348 Festing Lane","Millbrae, CA 94030","","Carr's Pie Shop","Steve Carr","19348 Festing Lane","","","Millbrae","CA","CA","CA","94030","","","Carr's Pie Shop","Steve Carr","19348 Festing Lane","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:19:21 AM","12/15/2019 10:34:36 PM","1576429473","800000D4-1182062138","Carr's Pie Shop:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/15/2020 12:00:00 AM","1029",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42555,"","3/15/2020 12:00:00 AM","","",14900,7.75,0,-14900,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D5A-1182059361",1504,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fisher, Jennifer:Garage Roof"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1030"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-05"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore,  CA  94326","","","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore, CA 94326","","","30000-933272658","Due on receipt","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 5:17:00 AM","12/15/2019 10:32:52 PM","1576429329","770000-1071531794","Fisher, Jennifer:Garage Roof","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/28/2020 12:00:00 AM","1030",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42556,"","3/28/2020 12:00:00 AM","","",3165,8.0500000000000007,0,-3165,0,"","","",true,"30000-933272660","Please remit to above address.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3B1D-1071532020",766,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Violette, Mike:Utility Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1031"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-06"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Mike Violette","143 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Mike Violette","143 Bay View","East Bayshore CA 94327","","","Mike Violette","143 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Mike Violette","143 Bay View","East Bayshore, CA 94327","","","10000-933272658","Net 30","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 12:32:46 AM","12/15/2019 10:32:12 PM","1576429331","6E0000-1071509585","Violette, Mike:Utility Room","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","3/28/2020 12:00:00 AM","1031",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42557,"","3/28/2020 12:00:00 AM","","",1099.95,8.0500000000000007,0,-1099.95,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3C97-1071514966",778,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Keenan, Bridget:Storage Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1032"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-07"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Bridget Keenan","213 Fern Lane","","","","East Bayshore","CA","CA","CA","94327","","","Bridget Keenan","213 Fern Lane","East Bayshore CA 94327","","","Bridget Keenan","213 Fern Lane","","","","East Bayshore","CA","CA","CA","94327","","","Bridget Keenan","213 Fern Lane","East Bayshore, CA 94327","","","10000-933272658","Net 30","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 4:03:35 AM","12/15/2019 10:32:14 PM","1576429333","7D0000-1071526869","Keenan, Bridget:Storage Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","4/7/2020 12:00:00 AM","1032",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42558,"","4/7/2020 12:00:00 AM","","",2446.2399999999998,8.0500000000000007,27.19,-2473.4299999999998,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3CDF-1071527615",785,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fisher, Jennifer:Garage Roof"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1033"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-08"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore,  CA  94326","","","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore, CA 94326","","","30000-933272658","Due on receipt","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 5:03:43 AM","12/15/2019 10:32:52 PM","1576429335","770000-1071531794","Fisher, Jennifer:Garage Roof","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","4/11/2020 12:00:00 AM","1033",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42559,"","4/11/2020 12:00:00 AM","","",1999,8.0500000000000007,96.6,-2095.6,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D52-1071531223",793,"","03-0123-5","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Ruff, Bryan:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1034"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-09"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Bryan Ruff","782 Skyline Dr","","","","East Bayshore","CA","CA","CA","94327","","","Bryan Ruff","782 Skyline Dr","East Bayshore CA 94327","","","Bryan Ruff","782 Skyline Dr","","","","East Bayshore","CA","CA","CA","94327","","","Bryan Ruff","782 Skyline Dr","East Bayshore, CA 94327","","","","","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 4:57:11 AM","12/15/2019 10:32:19 PM","1576429335","800000-1071530734","Ruff, Bryan:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","4/14/2020 12:00:00 AM","1034",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42560,"","4/14/2020 12:00:00 AM","","",1840,8.0500000000000007,55.55,-1895.55,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D42-1071530831",791,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Babcock's Music Shop:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1035"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-10"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Babcock's Music Shop","Kristie Babcock","10923 Samson Dr.","","","Millbrae","CA","CA","CA","94030","","","Babcock's Music Shop","Kristie Babcock","10923 Samson Dr.","Millbrae, CA 94030","","Babcock's Music Shop","Kristie Babcock","10923 Samson Dr.","","","Millbrae","CA","CA","CA","94030","","","Babcock's Music Shop","Kristie Babcock","10923 Samson Dr.","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:25:42 AM","12/15/2019 10:34:35 PM","1576429473","800000C7-1182059716","Babcock's Music Shop:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","4/14/2020 12:00:00 AM","1035",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42561,"","4/14/2020 12:00:00 AM","","",12530,7.75,0,-12530,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D61-1182059742",1505,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fisher, Jennifer:Garage Roof"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1036"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-11"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore,  CA  94326","","","","","","","","","","","","","","","","","","","","30000-933272658","Due on receipt","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 12:02:38 AM","12/15/2019 10:33:16 PM","1576429396","770000-1071531794","Fisher, Jennifer:Garage Roof","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","4/15/2020 12:00:00 AM","1036",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42562,"","7/11/2020 12:00:00 AM","","",1350,8.0500000000000007,108.68,-1458.68,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4949-1071513158",1084,"","03-0123-5","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fisher, Jennifer:Garage Roof"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1037"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-12"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Fisher","7882 N. Lantana Lane","","","","E. Bayshore","CA","CA","CA","94326","","","Jennifer Fisher","7882 N. Lantana Lane","E. Bayshore,  CA  94326","","","","","","","","","","","","","","","","","","","","30000-933272658","Due on receipt","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 12:03:57 AM","12/15/2019 10:33:16 PM","1576429396","770000-1071531794","Fisher, Jennifer:Garage Roof","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","4/15/2020 12:00:00 AM","1037",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42563,"","7/18/2020 12:00:00 AM","","",350,8.0500000000000007,0,-350,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","494F-1071513237",1085,"","03-0123-5","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Sage, Robert:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1038"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-13"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Robert Sage","92834 Verity Pkwy","","","","Millbrae","CA","CA","CA","94030","","","Robert Sage","92834 Verity Pkwy","Millbrae, CA 94030","","","Robert Sage","92834 Verity Pkwy","","","","Millbrae","CA","CA","CA","94030","","","Robert Sage","92834 Verity Pkwy","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:31:35 AM","12/15/2019 10:34:37 PM","1576429473","800000C9-1182060069","Sage, Robert:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","5/8/2020 12:00:00 AM","1038",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42564,"","5/8/2020 12:00:00 AM","","",17270,7.75,0,-17270,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D68-1182060095",1506,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Milner, Eloyse:Room addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1039"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-14"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Eloyse Milner","4242 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Eloyse Milner","4242 Cypress Hill Rd","Bayshore CA 94326","","","Eloyse Milner","4242 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Eloyse Milner","4242 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:35:15 AM","12/15/2019 10:31:55 PM","1576429314","6B0000-1071525677","Milner, Eloyse:Room addition","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","5/12/2020 12:00:00 AM","1039",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42565,"","5/12/2020 12:00:00 AM","","",4075.66,7.75,118.63,-4194.29,0,"","","",true,"10000-933272660","All work is complete!",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","39A9-1071529515",712,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Bristol, Sonya:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1040"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-15"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Sonya Bristol","5920 N. Lighthouse","","","","Bayshore","CA","CA","CA","94326","","","Sonya Bristol","5920 N. Lighthouse","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 5:30:41 AM","12/15/2019 10:32:17 PM","1576429336","8C0000-1071532703","Bristol, Sonya:Utility Shed","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","5/16/2020 12:00:00 AM","1040",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42566,"","5/16/2020 12:00:00 AM","","",1999,7.75,93,-2092,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D71-1071532841",797,"","B03-123456789","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Jimenez, Cristina:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1041"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-16"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Cristina Jimenez","6642 W. Skyline Dr","","","","Bayshore","CA","CA","CA","94326","","","Cristina Jimenez","6642 W. Skyline Dr","Bayshore, CA  94326","","","Cristina Jimenez","6642 W. Skyline Dr","","","","Bayshore","CA","CA","CA","94326","","","Cristina Jimenez","6642 W. Skyline Dr","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 5:22:53 AM","12/15/2019 10:32:19 PM","1576429336","8A0000-1071532366","Jimenez, Cristina:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","5/22/2020 12:00:00 AM","1041",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42567,"","5/22/2020 12:00:00 AM","","",1999,7.75,93,-2092,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D6A-1071532373",796,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Fomin, Slava:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1042"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-17"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Slava Fomin","3366 E. Maple","","","","Bayshore","CA","CA","CA","94326","","","Slava Fomin","3366 E. Maple","Bayshore,  CA  94326","","","Slava Fomin","3366 E. Maple","","","","Bayshore","CA","CA","CA","94326","","","Slava Fomin","3366 E. Maple","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 5:08:00 AM","12/15/2019 10:32:18 PM","1576429335","850000-1071531366","Fomin, Slava:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/4/2020 12:00:00 AM","1042",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42568,"","6/4/2020 12:00:00 AM","","",2499,7.75,89.13,-2588.13,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D5B-1071531480",794,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Abercrombie, Kristy:Family Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1043"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-18"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore CA 94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","6/7/2007 7:56:41 PM","12/15/2019 10:34:22 PM","1576429459","160000-933272658","Abercrombie, Kristy:Family Room","40000-933270541","Accounts Receivable","130000-1071512842","Custom S.O. Invoice","6/7/2020 12:00:00 AM","1043",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42569,"","6/7/2020 12:00:00 AM","","",1237,7.75,55.78,-1292.78,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","96A8-1181226401",1459,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Abercrombie, Kristy:Family Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1044"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-19"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore CA 94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","6/7/2007 7:59:26 PM","12/15/2019 10:34:20 PM","1576429460","160000-933272658","Abercrombie, Kristy:Family Room","40000-933270541","Accounts Receivable","130000-1071512842","Custom S.O. Invoice","6/7/2020 12:00:00 AM","1044",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42570,"","6/7/2020 12:00:00 AM","","",-37.200000000000003,7.75,37.200000000000003,0,0,"","","",true,"","",false,true,"","10000-999022286","Tax","10000-999022286","","","","","","","","96B3-1181226566",1460,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Duncan, Dave:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1045"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-20"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Duncan, Dave","3442 W. Charleston","","","","Bayshore","CA","CA","CA","94326","","","Duncan, Dave","3442 W. Charleston","Bayshore, CA  94326","","","Duncan, Dave","3442 W. Charleston","","","","Bayshore","CA","CA","CA","94326","","","Duncan, Dave","3442 W. Charleston","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 4:48:23 AM","12/15/2019 10:32:17 PM","1576429334","860000-1071531587","Duncan, Dave:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/9/2020 12:00:00 AM","1045",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42571,"","6/9/2020 12:00:00 AM","","",2400,7.75,69.75,-2469.75,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D24-1071530303",789,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Memeo, Jeanette:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1046"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 60"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-21"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Jeanette Memeo","8313 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Jeanette Memeo","8313 Orange Blossom Dr","Bayshore CA 94326","","","Jeanette Memeo","8313 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Jeanette Memeo","8313 Orange Blossom Dr","Bayshore, CA 94326","","","60000-933272660","Net 60","","","2E0000-933272656","San Tomas","","","12/16/2003 4:54:05 AM","12/15/2019 10:32:53 PM","1576429334","7F0000-1071530557","Memeo, Jeanette:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/9/2020 12:00:00 AM","1046",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 60"},42572,"","6/9/2020 12:00:00 AM","","",1999,7.75,93,-2092,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D32-1071530645",790,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Rahn, Jennifer:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1047"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-22"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Jennifer Rahn","1983 Woodland Rd.","","","","Millbrae","CA","CA","CA","94030","","","Jennifer Rahn","1983 Woodland Rd.","Millbrae, CA 94030","","","Jennifer Rahn","1983 Woodland Rd.","","","","Millbrae","CA","CA","CA","94030","","","Jennifer Rahn","1983 Woodland Rd.","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:35:52 AM","12/15/2019 10:34:36 PM","1576429473","800000CB-1182060323","Rahn, Jennifer:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/17/2020 12:00:00 AM","1047",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42573,"","6/17/2020 12:00:00 AM","","",20300,7.75,0,-20300,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D6F-1182060352",1507,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Craven, Pam:Duct Work"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1048"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-23"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Pam Craven","7105 N. Landon","","","","E. Bayshore","CA","CA","CA","94327","","","Pam Craven","7105 N. Landon","E. Bayshore,  CA 94327","","","Pam Craven","7105 N. Landon","","","","E. Bayshore","CA","CA","CA","94327","","","Pam Craven","7105 N. Landon","E. Bayshore, CA 94327","","","30000-933272658","Due on receipt","","","350000-1071521574","East Bayshore","","","12/16/2003 4:18:07 AM","12/15/2019 10:31:53 PM","1576429313","740000-1071526664","Craven, Pam:Duct Work","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/23/2020 12:00:00 AM","1048",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42574,"","6/23/2020 12:00:00 AM","","",625,0.3,0,-625,0,"","","",true,"10000-933272660","All work is complete!",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3981-1071528487",710,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Baker, Chris:Family Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1049"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-24"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Baker, Chris","415 W. Desert Bloom","","","","Bayshore","CA","CA","CA","94326","","","Baker, Chris","415 W. Desert Bloom","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2003 10:21:17 PM","12/15/2019 10:32:29 PM","1576429348","950000-1071506823","Baker, Chris:Family Room","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","6/23/2020 12:00:00 AM","1049",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42575,"","6/23/2020 12:00:00 AM","","",5989.85,7.75,182.39,-6172.24,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3F6B-1071507077",855,"","03-1234567","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Craven, Pam:Duct Work"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1050"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-25"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Pam Craven","7105 N. Landon","","","","E. Bayshore","CA","CA","CA","94327","","","Pam Craven","7105 N. Landon","E. Bayshore,  CA 94327","","","Pam Craven","7105 N. Landon","","","","E. Bayshore","CA","CA","CA","94327","","","Pam Craven","7105 N. Landon","E. Bayshore, CA 94327","","","30000-933272658","Due on receipt","","","350000-1071521574","East Bayshore","","","12/15/2007 9:40:26 PM","12/15/2019 10:34:23 PM","1576429456","740000-1071526664","Craven, Pam:Duct Work","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","6/30/2020 12:00:00 AM","1050",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42576,"","6/30/2020 12:00:00 AM","","",321.8,0.3,0,-321.8,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8C02-1197735026",1430,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Luke, Noelani:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1051"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"1% 10 Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-26"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Noelani Luke","913 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Noelani Luke","913 Bay View","East Bayshore CA 94327","","","Noelani Luke","913 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Noelani Luke","913 Bay View","East Bayshore, CA 94327","","","50000-933272659","1% 10 Net 30","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 1:43:44 AM","12/15/2019 10:31:38 PM","1576429258","580000-1071526281","Luke, Noelani:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","7/14/2020 12:00:00 AM","1051",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"1% 10 Net 30"},42577,"","7/24/2020 12:00:00 AM","","",10790.3,8.0500000000000007,691.5,-11481.8,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","107.9","7/24/2020 12:00:00 AM","","","","","","2758-1071519224",475,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Luke, Noelani:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1052"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"1% 10 Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-27"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Noelani Luke","913 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Noelani Luke","913 Bay View","East Bayshore CA 94327","","","Noelani Luke","913 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Noelani Luke","913 Bay View","East Bayshore, CA 94327","","","50000-933272659","1% 10 Net 30","","","360000-1071521681","E. Bayshore/County","","","12/16/2003 2:29:37 AM","12/15/2019 10:31:00 PM","1576429259","5E0000-1071526675","Luke, Noelani:Remodel Bathroom","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","7/14/2020 12:00:00 AM","1052",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"1% 10 Net 30"},42578,"","7/16/2020 12:00:00 AM","","",4552.6000000000004,8.0500000000000007,282.32,-4834.92,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","45.53","7/24/2020 12:00:00 AM","","","","","","277B-1071521977",478,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Samuels Art Supplies:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1053"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-28"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Samuels Art Supplies","Adam Samuels","P.O. Box 983094","","","Millbrae","CA","CA","CA","94030","","","Samuels Art Supplies","Adam Samuels","P.O. Box 983094","Millbrae, CA 94030","","Samuels Art Supplies","Adam Samuels","P.O. Box 983094","","","Millbrae","CA","CA","CA","94030","","","Samuels Art Supplies","Adam Samuels","P.O. Box 983094","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:42:39 AM","12/15/2019 10:34:38 PM","1576429473","800000CD-1182060748","Samuels Art Supplies:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","7/20/2020 12:00:00 AM","1053",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42579,"","7/20/2020 12:00:00 AM","","",13900,7.75,0,-13900,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D76-1182060759",1508,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Memeo, Jeanette:2nd story addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1054"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 60"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-29"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Jeanette Memeo","8313 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Jeanette Memeo","8313 Orange Blossom Dr","Bayshore CA 94326","","","Jeanette Memeo","8313 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Jeanette Memeo","8313 Orange Blossom Dr","Bayshore, CA 94326","","","60000-933272660","Net 60","","","2E0000-933272656","San Tomas","","","12/15/2003 11:54:32 PM","12/15/2019 10:32:53 PM","1576429283","690000-1071511449","Memeo, Jeanette:2nd story addition","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","8/13/2020 12:00:00 AM","1054",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 60"},42580,"","8/13/2020 12:00:00 AM","","",13973.45,7.75,565.09,-14538.54,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3239-1071512672",545,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Tony's Barber Shop:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1055"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-30"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Tony's Barber Shop","Tony Gaming","P.O. Box 42893","","","Millbrae","CA","CA","CA","94030","","","Tony's Barber Shop","Tony Gaming","P.O. Box 42893","Millbrae, CA 94030","","Tony's Barber Shop","Tony Gaming","P.O. Box 42893","","","Millbrae","CA","CA","CA","94030","","","Tony's Barber Shop","Tony Gaming","P.O. Box 42893","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:46:47 AM","12/15/2019 10:34:38 PM","1576429474","800000CF-1182060980","Tony's Barber Shop:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","8/20/2020 12:00:00 AM","1055",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42581,"","8/20/2020 12:00:00 AM","","",15870,7.75,0,-15870,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D7D-1182061007",1509,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Smith, Lee:Patio"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1056"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-07-31"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Lee M Smith","431 Hampshire Blvd","","","","East Bayshore","CA","CA","CA","94327","","","Lee M Smith","431 Hampshire Blvd","East Bayshore CA 94327","","","Smith Photography","910 Grapevine Ave","","","","East Bayshore","CA","CA","CA","94327","","","Smith Photography","910 Grapevine Ave","East Bayshore CA 94327","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2003 9:38:43 PM","12/15/2019 10:31:28 PM","1576429245","620000-1071526513","Smith, Lee:Patio","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","8/27/2020 12:00:00 AM","1056",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42582,"","9/1/2020 12:00:00 AM","","",7894.5,7.75,467.17,-8361.67,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2476-1071504523",423,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Nguyen, Tuan:Garage"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1057"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Due on receipt"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-01"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Tuan Nguyen","8292 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Tuan Nguyen","8292 Orange Blossom Dr","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","30000-933272658","Due on receipt","","","2E0000-933272656","San Tomas","","","12/15/2003 8:57:26 PM","12/15/2019 10:31:28 PM","1576429254","560000-1071525552","Nguyen, Tuan:Garage","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","9/4/2020 12:00:00 AM","1057",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Due on receipt"},42583,"","9/4/2020 12:00:00 AM","","",6819,7.75,0,-6819,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","26CD-1071502046",463,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Allard, Robert:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1058"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":14510},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-02"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Robert Allard","92834 Chandler St.","","","","Millbrae","CA","CA","CA","94030","","","Robert Allard","92834 Chandler St.","Millbrae, CA 94030","","","Robert Allard","92834 Chandler St.","","","","Millbrae","CA","CA","CA","94030","","","Robert Allard","92834 Chandler St.","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 11:53:38 AM","12/15/2019 10:34:34 PM","1576429474","800000D1-1182061396","Allard, Robert:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","9/12/2020 12:00:00 AM","1058",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42584,"","9/12/2020 12:00:00 AM","","",14510,7.75,0,0,14510,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D84-1182061418",1510,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Morgenthaler, Jenny:Room Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1059"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-03"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Jenny Morgenthaler","37105 E. Oasis Dr.","","","","Middlefield","CA","CA","CA","94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","Middlefield, CA 94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","","","","Middlefield","CA","CA","CA","94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","Middlefield, CA 94485","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 12:21:11 AM","12/15/2019 10:32:25 PM","1576429308","700000-1071512041","Morgenthaler, Jenny:Room Addition","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","9/15/2020 12:00:00 AM","1059",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42585,"","9/15/2020 12:00:00 AM","","",6094.64,7.75,39.53,-6134.17,0,"","","Project will begin within 2 weeks of acceptance",true,"10000-933272660","All work is complete!",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","382F-1071514271",674,"","0203-03R","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Dunn, Eric C.W.:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1060"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-04"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Dunn, Eric C.W.","97401 N. Liberty Ln","","","","Bayshore","CA","CA","CA","94326","","","Dunn, Eric C.W.","97401 N. Liberty Ln","Bayshore,  CA  94326","","","Dunn, Eric C.W.","97401 N. Liberty Ln","","","","Bayshore","CA","CA","CA","94326","","","Dunn, Eric C.W.","97401 N. Liberty Ln","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 5:02:18 AM","12/15/2019 10:32:18 PM","1576429335","820000-1071531106","Dunn, Eric C.W.:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","9/22/2020 12:00:00 AM","1060",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42586,"","9/22/2020 12:00:00 AM","","",2400,7.75,69.75,-2469.75,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D4B-1071531138",792,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Morgenthaler, Jenny:Room Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1061"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-05"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Jenny Morgenthaler","37105 E. Oasis Dr.","","","","Middlefield","CA","CA","CA","94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","Middlefield, CA 94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","","","","Middlefield","CA","CA","CA","94485","","","Jenny Morgenthaler","37105 E. Oasis Dr.","Middlefield, CA 94485","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2003 11:57:53 PM","12/15/2019 10:34:02 PM","1576429396","700000-1071512041","Morgenthaler, Jenny:Room Addition","40000-933270541","Accounts Receivable","130000-1071512842","Custom S.O. Invoice","9/25/2020 12:00:00 AM","1061",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42587,"","12/20/2020 12:00:00 AM","","",252,7.75,19.53,-271.52999999999997,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4917-1071512873",1082,"","0203-03R","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Johnson, Gordon:Utility Shed"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1062"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-06"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Gordon Johnson","7230 W. First Ave","","","","Bayshore","CA","CA","CA","94326","","","Gordon Johnson","7230 W. First Ave","Bayshore, CA  94326","","","Gordon Johnson","7230 W. First Ave","","","","Bayshore","CA","CA","CA","94326","","","Gordon Johnson","7230 W. First Ave","Bayshore, CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 5:15:30 AM","12/15/2019 10:32:19 PM","1576429336","880000-1071531882","Johnson, Gordon:Utility Shed","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","9/26/2020 12:00:00 AM","1062",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42588,"","9/26/2020 12:00:00 AM","","",2400,7.75,69.75,-2469.75,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","3D63-1071531930",795,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Burch, Jason:Room Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1063"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-07"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Jason Burch","5960 N. Wetmore","","","","Bayshore","CA","CA","CA","94326","","","Jason Burch","5960 N. Wetmore","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/15/2003 11:00:41 PM","12/15/2019 10:32:48 PM","1576429353","990000-1071509249","Burch, Jason:Room Addition","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","9/29/2020 12:00:00 AM","1063",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42589,"","9/29/2020 12:00:00 AM","","",5768.4,7.75,144.53,-5912.93,0,"","","",true,"30000-933272660","Please remit to above address.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4010-1071509441",876,"","0309-1256","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Smith, Lee:Patio"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 1"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-08"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Lee M Smith","431 Hampshire Blvd","","","","East Bayshore","CA","CA","CA","94327","","","Lee M Smith","431 Hampshire Blvd","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","","","","","12/15/2003 10:46:13 PM","12/15/2019 10:31:28 PM","1576429247","620000-1071526513","Smith, Lee:Patio","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","9/30/2020 12:00:00 AM","FC 1",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42590,"","8/29/2020 12:00:00 AM","","",5,0,0,-5,0,"","","Finance Charge",true,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","24B1-1071508573",430,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Nguyen, Tuan:Garage"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 2"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-09"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Tuan Nguyen","8292 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Tuan Nguyen","8292 Orange Blossom Dr","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","","","","","12/15/2003 9:03:28 PM","12/15/2019 10:31:28 PM","1576429255","560000-1071525552","Nguyen, Tuan:Garage","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","10/1/2020 12:00:00 AM","FC 2",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42591,"","9/17/2020 12:00:00 AM","","",35.65,0,0,-35.65,0,"","","Finance Charge",true,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","26F8-1071502408",465,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Teschner, Anton:Sun Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1064"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-10"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Anton Teschner","2424 Lisa Lane","","","","Bayshore","CA","CA","CA","94326","","","Anton Teschner","2424 Lisa Lane","Bayshore, CA 94326","","","","","","","","","","","","","","","","","","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","7/30/1999 4:12:29 AM","12/15/2019 10:30:25 PM","1576429194","2A0000-933272658","Teschner, Anton:Sun Room","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/5/2020 12:00:00 AM","1064",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42592,"","10/5/2020 12:00:00 AM","","",1960,7.75,0,-1960,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","48B-933288149",90,"","1197-03-LFAV","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1065"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":2239},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-11"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/30/1999 4:18:36 AM","12/15/2019 10:30:28 PM","1576429195","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/10/2020 12:00:00 AM","1065",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42593,"","10/10/2020 12:00:00 AM","","",3439,7.5,0,-1200,2239,"","","",false,"60000-933272660","We appreciate your prompt payment.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4A6-933288516",94,"","0997-02-PRET","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1066"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":700},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-12"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Brian Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/31/1999 1:10:12 AM","12/15/2019 10:30:06 PM","1576429206","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/15/2020 12:00:00 AM","1066",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42594,"","10/15/2020 12:00:00 AM","","",3100,7.5,0,-2400,700,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","74F-933363612",137,"","1197-02-PCAR","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Teichman, Tim:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1067"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 60"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-13"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Tim Teichman","2353 Lisa lane","","","","Bayshore","CA","CA","CA","94326","","","Tim Teichman","2353 Lisa lane","Bayshore CA 94326","","","Tim Teichman","2353 Lisa lane","","","","Bayshore","CA","CA","CA","94326","","","Tim Teichman","2353 Lisa lane","Bayshore, CA 94326","","","60000-933272660","Net 60","","","2E0000-933272656","San Tomas","","","12/15/2003 9:26:19 PM","12/15/2019 10:31:20 PM","1576429276","680000-1071498245","Teichman, Tim:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","10/15/2020 12:00:00 AM","1067",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 60"},42595,"","10/15/2020 12:00:00 AM","","",7257,7.75,507.78,-7764.78,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","2F39-1071503779",523,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Mackey's Nursery and Garden Supply:Greenhouse Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1068"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":13900},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-14"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Mackey's Nursery and Garden Supply","Mackey Mickey Hood","2947 Central Ave","","","Millbrae","CA","CA","CA","94030","","","Mackey's Nursery and Garden Supply","Mackey Mickey Hood","2947 Central Ave","Millbrae, CA 94030","","Mackey's Nursery and Garden Supply","John Mackey","2947 Central Ave","","","Millbrae","CA","CA","CA","94030","","","Mackey's Nursery and Garden Supply","John Mackey","2947 Central Ave","Millbrae, CA 94030","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/18/2007 10:14:41 AM","12/15/2019 10:34:51 PM","1576429491","800000D9-1197953027","Mackey's Nursery and Garden Supply:Greenhouse Addition","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","10/20/2020 12:00:00 AM","1068",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42596,"","10/20/2020 12:00:00 AM","","",13900,7.75,0,0,13900,"","","Greenhouse Addition",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","A289-1197953081",1692,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Jacobsen, Doug:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1069"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-15"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Doug Jacobsen","6845 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Doug Jacobsen","6845 Ocean View","Bayshore, CA 94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","7/30/1999 10:39:00 PM","12/15/2019 10:30:30 PM","1576429204","200000-933272658","Jacobsen, Doug:Kitchen","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/23/2020 12:00:00 AM","1069",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42597,"","10/23/2020 12:00:00 AM","","",3045,7.75,162.75,-3207.75,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","530-933354540",118,"","1097-01-DJAC","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1070"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-16"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/30/1999 10:58:20 PM","12/15/2019 10:30:07 PM","1576429205","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/26/2020 12:00:00 AM","1070",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42598,"","10/26/2020 12:00:00 AM","","",2320,7.5,0,-2320,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","595-933355700",126,"","0997-02-PRET","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1071"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-17"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/31/1999 12:40:58 AM","12/15/2019 10:30:10 PM","1576429206","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/30/2020 12:00:00 AM","1071",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42599,"","10/30/2020 12:00:00 AM","","",4750,7.5,198,-4948,0,"","","",true,"60000-933272660","We appreciate your prompt payment.",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","744-933361858",135,"","0997-02-PRET","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:2nd story addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1072"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-18"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Brian K. Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian K. Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","8/6/1999 11:02:35 PM","12/15/2019 10:30:31 PM","1576429231","1A0000-933272658","Cook, Brian:2nd story addition","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/30/2020 12:00:00 AM","1072",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42600,"","10/30/2020 12:00:00 AM","","",13021.2,7.5,1064.0999999999999,-14085.3,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","1136-933960755",302,"","1097-03-PCAR","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1073"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-19"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Brian Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","8/6/1999 11:20:03 PM","12/15/2019 10:30:31 PM","1576429231","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","10/30/2020 12:00:00 AM","1073",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42601,"","10/30/2020 12:00:00 AM","","",2580,7.5,0,-2580,0,"","","",true,"60000-933272660","We appreciate your prompt payment.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","1172-933961803",303,"","1197-02-PCAR","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Smith, Lee:Patio"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 3"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-20"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Lee M Smith","431 Hampshire Blvd","","","","East Bayshore","CA","CA","CA","94327","","","Lee M Smith","431 Hampshire Blvd","East Bayshore CA 94327","","","","","","","","","","","","","","","","","","","","","","","","","","","","12/15/2003 10:48:08 PM","12/15/2019 10:31:28 PM","1576429247","620000-1071526513","Smith, Lee:Patio","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","10/31/2020 12:00:00 AM","FC 3",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42602,"","10/22/2020 12:00:00 AM","","",18.73,0,0,-18.73,0,"","","Finance Charge",true,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","24CC-1071508688",432,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Nguyen, Tuan:Garage"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 4"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-21"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Tuan Nguyen","8292 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Tuan Nguyen","8292 Orange Blossom Dr","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","","","","","12/15/2003 9:03:51 PM","12/15/2019 10:31:28 PM","1576429255","560000-1071525552","Nguyen, Tuan:Garage","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","11/3/2020 12:00:00 AM","FC 4",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42603,"","10/1/2020 12:00:00 AM","","",43.89,0,0,-43.89,0,"","","Finance Charge",true,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","26FC-1071502431",466,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1074"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1072.5},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-22"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/31/1999 3:35:31 AM","12/15/2019 10:30:12 PM","1576429212","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/15/2020 12:00:00 AM","1074",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42604,"","11/15/2020 12:00:00 AM","","",1072.5,7.5,0,0,1072.5,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8B8-933372331",179,"","0997-02-PRET","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1075"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-23"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Brian K. Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian K. Cook","345 Cherry Lane","Middlefield CA 94482","","","Brian K. Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian K. Cook","345 Cherry Lane","Middlefield, CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","12/16/2003 3:24:06 AM","12/15/2019 10:33:04 PM","1576429384","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/15/2020 12:00:00 AM","1075",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42605,"","12/10/2020 12:00:00 AM","","",4175.5,7.5,49.91,-4225.41,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4525-1071525246",1061,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Vitton, David:Remodel Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1076"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":700},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-24"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","David Vitton","324 Spruce St.","","","","West Bear","CA","CA","CA","94533","","","David Vitton","324 Spruce St.","West Bear, CA 94533","","","David Vitton","324 Spruce St.","","","","West Bear","CA","CA","CA","94533","","","David Vitton","324 Spruce St.","West Bear, CA 94533","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","12/15/2007 10:24:38 PM","12/15/2019 10:34:17 PM","1576429457","800000AF-1197752681","Vitton, David:Remodel Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/15/2020 12:00:00 AM","1076",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42606,"","11/15/2020 12:00:00 AM","","",700,7.75,0,0,700,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","8CBD-1197737678",1437,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Hendro Riyadi:Remodel Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1077"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":4223},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-25"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Hendro Riyadi","Riyadi Enterprises","325 Perry Ave. N","","","Bayshore","CA","CA","CA","94326","","","Hendro Riyadi","Riyadi Enterprises","325 Perry Ave. N","Bayshore CA 94326","","Hendro Riyadi","Riyadi Enterprises","325 Perry Ave. N","","","Bayshore","CA","CA","CA","94326","","","Hendro Riyadi","Riyadi Enterprises","325 Perry Ave. N","Bayshore, CA 94326","","","","","","2E0000-933272656","San Tomas","","","12/16/2007 4:45:06 AM","12/15/2019 10:33:53 PM","1576429433","800000AE-1197752620","Hendro Riyadi:Remodel Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/18/2020 12:00:00 AM","1077",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42607,"","11/18/2020 12:00:00 AM","","",3975,7.75,248,0,4223,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","5B7A-1197760506",1249,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1078"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-26"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/31/1999 4:06:13 AM","12/15/2019 10:30:18 PM","1576429215","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/20/2020 12:00:00 AM","1078",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42608,"","11/20/2020 12:00:00 AM","","",15435,7.5,0,-15435,0,"","","",true,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","A6D-933374173",198,"","0997-02-PRET","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Melton, Johnny:Dental office"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1079"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":8618.64},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-27"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Johnny Melton, DDS","300 Main St, Suite 3","","","","Bayshore","CA","CA","CA","94326","","","Johnny Melton, DDS","300 Main St, Suite 3","Bayshore CA 94326","","","Johnny Melton, DDS","300 Main St, Suite 3","","","","Bayshore","CA","CA","CA","94326","","","Johnny Melton, DDS","300 Main St, Suite 3","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:42:12 AM","12/15/2019 10:33:08 PM","1576429387","230000-933272658","Melton, Johnny:Dental office","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/20/2020 12:00:00 AM","1079",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42609,"","11/20/2020 12:00:00 AM","","",12596,7.75,158.13999999999999,-4135.5,8618.64,"","","",false,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","464B-1071529932",1066,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1080"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1636.69},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-28"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Brian Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","7/31/1999 4:22:53 AM","12/15/2019 10:30:15 PM","1576429216","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","11/25/2020 12:00:00 AM","1080",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42610,"","11/25/2020 12:00:00 AM","","",1522.5,7.5,114.19,0,1636.69,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","B3C-933375173",210,"","1197-02-PCAR","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:2nd story addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1081"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":5418},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-29"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Brian K. Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian K. Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","8/4/1999 8:42:49 PM","12/15/2019 10:30:16 PM","1576429216","1A0000-933272658","Cook, Brian:2nd story addition","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/25/2020 12:00:00 AM","1081",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42611,"","11/25/2020 12:00:00 AM","","",5040,7.5,378,0,5418,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","BA8-933779569",212,"","1097-03-PCAR","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Jacobsen, Doug:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1082"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":2320},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-30"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Doug Jacobsen","6845 Ocean View","","","","Bayshore","CA","CA","CA","94326","","","Doug Jacobsen","6845 Ocean View","Bayshore, CA 94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","8/6/1999 11:31:26 PM","12/15/2019 10:30:31 PM","1576429231","200000-933272658","Jacobsen, Doug:Kitchen","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/25/2020 12:00:00 AM","1082",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42612,"","11/25/2020 12:00:00 AM","","",4725,7.75,0,-2405,2320,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","117B-933962486",304,"","1097-01-DJAC","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Burch, Jason:Room Addition"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1083"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1005},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-08-31"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Jason Burch","5960 N. Wetmore","","","","Bayshore","CA","CA","CA","94326","","","Jason Burch","5960 N. Wetmore","Bayshore, CA  94326","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 2:13:18 AM","12/15/2019 10:32:52 PM","1576429372","990000-1071509249","Burch, Jason:Room Addition","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/25/2020 12:00:00 AM","1083",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42613,"","11/25/2020 12:00:00 AM","","",1005,7.75,0,0,1005,"","","Follow Up Work for September Job",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","434C-1071520998",1042,"","0309-1256","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Abercrombie, Kristy:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1084"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-01"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore CA 94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:23:50 AM","12/15/2019 10:33:06 PM","1576429384","180000-933272658","Abercrombie, Kristy:Remodel Bathroom","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","11/25/2020 12:00:00 AM","1084",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42614,"","11/25/2020 12:00:00 AM","","",2887.5,7.75,223.78,-3111.28,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","45A0-1071528830",1063,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Teschner, Anton:Sun Room"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1085"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":565.95000000000005},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-02"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Anton Teschner","2424 Lisa Lane","","","","Bayshore","CA","CA","CA","94326","","","Anton Teschner","2424 Lisa Lane","Bayshore, CA 94326","","","","","","","","","","","","","","","","","","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","8/4/1999 9:23:37 PM","12/15/2019 10:30:29 PM","1576429221","2A0000-933272658","Teschner, Anton:Sun Room","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","11/28/2020 12:00:00 AM","1085",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42615,"","11/28/2020 12:00:00 AM","","",7920,7.75,385.95,-7740,565.95000000000005,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","CDA-933782017",240,"","1197-03-LFAV","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Ecker Designs:Office Repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1086"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1468.3},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-03"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Deanna Ecker","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","","Deanna Ecker","95 Amber St","Bayshore CA 94326","","","Deanna Ecker","95 Amber St","","","","Bayshore","CA","CA","CA","94326","","Attn: Deanna Ecker","Deanna Ecker","95 Amber St","Bayshore CA 94326","Attn: Deanna Ecker","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","8/4/1999 9:27:37 PM","12/15/2019 10:30:22 PM","1576429222","1E0000-933272658","Ecker Designs:Office Repairs","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","11/30/2020 12:00:00 AM","1086",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42616,"","11/30/2020 12:00:00 AM","","",1397,7.75,71.3,0,1468.3,"","","",false,"60000-933272660","We appreciate your prompt payment.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","CEC-933782257",243,"","1297-03-ECKE","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Roche, Diarmuid:Garage repairs"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1087"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-04"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Diarmuid Roche","3219 Lisa Lane","","","","Bayshore","CA","CA","CA","94326","","","Diarmuid Roche","3219 Lisa Lane","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 2:52:06 AM","12/15/2019 10:30:41 PM","1576429241","5A0000-1071526431","Roche, Diarmuid:Garage repairs","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","12/1/2020 12:00:00 AM","1087",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42617,"","12/1/2020 12:00:00 AM","","",440,7.75,0,-440,0,"","","",true,"20000-933272660","It's been a pleasure working with you!",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","23B6-1071523326",402,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Robson, Darci:Robson Clinic"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1088"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-05"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Dr. Darci Robson","300 Main St, Suite 2","","","","Bayshore","CA","CA","CA","94326","","","Dr. Darci Robson","300 Main St, Suite 2","Bayshore CA 94326","","","Dr. Darci Robson","300 Main St, Suite 2","","","","Bayshore","CA","CA","CA","94326","","","Dr. Darci Robson","300 Main St, Suite 2","Bayshore CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/16/2003 2:57:43 AM","12/15/2019 10:31:29 PM","1576429251","610000-1071519006","Robson, Darci:Robson Clinic","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","12/1/2020 12:00:00 AM","1088",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42618,"","12/1/2020 12:00:00 AM","","",445,7.75,0,-445,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","25DA-1071523663",452,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Nguyen, Tuan:Garage"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 5"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-06"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"New Construction","Tuan Nguyen","8292 Orange Blossom Dr","","","","Bayshore","CA","CA","CA","94326","","","Tuan Nguyen","8292 Orange Blossom Dr","Bayshore CA 94326","","","","","","","","","","","","","","","","","","","","","","","","","","","","12/15/2003 9:04:41 PM","12/15/2019 10:31:28 PM","1576429255","560000-1071525552","Nguyen, Tuan:Garage","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","12/1/2020 12:00:00 AM","FC 5",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42619,"","11/3/2020 12:00:00 AM","","",37.58,0,0,-37.58,0,"","","Finance Charge",true,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","2701-1071502481",467,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Violette, Mike:Workshop"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1089"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 60"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":4732.2299999999996},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-07"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Mike Violette","143 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Mike Violette","143 Bay View","East Bayshore CA 94327","","","Mike Violette","143 Bay View","","","","East Bayshore","CA","CA","CA","94327","","","Mike Violette","143 Bay View","East Bayshore, CA 94327","","","60000-933272660","Net 60","","","2E0000-933272656","San Tomas","","","12/16/2003 4:08:28 AM","12/15/2019 10:30:51 PM","1576429249","5B0000-1071526457","Violette, Mike:Workshop","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/5/2020 12:00:00 AM","1089",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 60"},42620,"","12/5/2020 12:00:00 AM","","",5702,7.75,30.23,-1000,4732.2299999999996,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","259C-1071527908",448,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Pretell Real Estate:155 Wilks Blvd."},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1090"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1715},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-08"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Pretell Real Estate","222 Middlefield  Ave","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","222 Middlefield  Ave","Middlefield  CA 94482","","","Pretell Real Estate","155 Wilks Blvd.","","","","Middlefield","CA","CA","CA","94482","","","Pretell Real Estate","155 Wilks Blvd.","Middlefield  CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","8/4/1999 11:38:42 PM","12/15/2019 10:30:30 PM","1576429230","270000-933272658","Pretell Real Estate:155 Wilks Blvd.","40000-933270541","Accounts Receivable","80000-933288086","Custom Invoice","12/10/2020 12:00:00 AM","1090",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42621,"","12/10/2020 12:00:00 AM","","",1715,7.5,0,0,1715,"","","",false,"50000-933272660","Thank you for your business.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","FAE-933790122",301,"","0997-02-PRET","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Abercrombie, Kristy:Remodel Bathroom"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1091"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-09"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore CA 94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","","","","Bayshore","CA","CA","CA","94326","","","Kristy Abercrombie","5647 Cypress Hill Rd","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:26:00 AM","12/15/2019 10:33:06 PM","1576429385","180000-933272658","Abercrombie, Kristy:Remodel Bathroom","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/10/2020 12:00:00 AM","1091",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42622,"","12/30/2020 12:00:00 AM","","",4522,7.75,0,-4522,0,"","","",true,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","45E6-1071528960",1064,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Campbell, Heather:Remodel"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1092"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 15"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":13900},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-10"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Heather Campbell","98342 Sharondale Rd.","","","","Millbrae","CA","CA","CA","94030","","","Heather Campbell","98342 Sharondale Rd.","Millbrae, CA 94030","","","Heather Campbell","98342 Sharondale Rd.","","","","Millbrae","CA","CA","CA","94030","","","Heather Campbell","98342 Sharondale Rd.","Millbrae, CA 94030","","","20000-933272658","Net 15","","","2E0000-933272656","San Tomas","","","6/17/2007 12:00:32 PM","12/15/2019 10:34:34 PM","1576429474","800000D3-1182061817","Campbell, Heather:Remodel","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/10/2020 12:00:00 AM","1092",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 15"},42623,"","12/10/2020 12:00:00 AM","","",13900,7.75,0,0,13900,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","9D8B-1182061832",1511,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"FC 6"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":5.95},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-11"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Brian Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian Cook","345 Cherry Lane","Middlefield CA 94482","","","","","","","","","","","","","","","","","","","","10000-933272658","Net 30","","","","","","","8/4/1999 10:44:52 PM","12/15/2019 10:30:27 PM","1576429227","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","B0000-933779648","Finance Charge","12/11/2020 12:00:00 AM","FC 6",false,true,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42624,"","12/11/2020 12:00:00 AM","","",5.95,0,0,0,5.95,"","","Finance Charge",false,"","",false,false,"","20000-999022286","Non","20000-999022286","","","","","","","","ED0-933786892",280,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Lew Plumbing - C:Storage Expansion"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1093"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":220},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-12"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Glen Lew","Lew Plumbing","221 Old Bayshore Rd","","","Bayshore","CA","CA","CA","94326","","","Glen Lew","Lew Plumbing","221 Old Bayshore Rd","Bayshore CA  94326","","Glen Lew","Lew Plumbing","221 Old Bayshore Rd","","","Bayshore","CA","CA","CA","94326","","","Glen Lew","Lew Plumbing","221 Old Bayshore Rd","Bayshore, CA 94326","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 3:20:15 AM","12/15/2019 10:31:43 PM","1576429303","800000AD-1197768243","Lew Plumbing - C:Storage Expansion","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/12/2020 12:00:00 AM","1093",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42625,"","12/12/2020 12:00:00 AM","","",220,7.75,0,0,220,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","36DA-1071525015",622,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Natiello, Ernesto:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1094"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-13"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore CA 94326","","","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:56:56 AM","12/15/2019 10:33:14 PM","1576429389","250000-933272658","Natiello, Ernesto:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/14/2020 12:00:00 AM","1094",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42626,"","12/14/2020 12:00:00 AM","","",1930.5,7.75,149.61000000000001,-2080.11,0,"","","",true,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4702-1071530816",1069,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Natiello, Ernesto:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1095"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-14"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore CA 94326","","","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 4:58:54 AM","12/15/2019 10:33:14 PM","1576429390","250000-933272658","Natiello, Ernesto:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/14/2020 12:00:00 AM","1095",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42627,"","12/14/2020 12:00:00 AM","","",8656.25,7.75,0,-8656.25,0,"","","",true,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4794-1071530934",1070,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Natiello, Ernesto:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1096"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":0},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-15"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":-1},"Remodel","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore CA 94326","","","Ernesto Natiello","376 Pine St, #5E","","","","Bayshore","CA","CA","CA","94326","","","Ernesto Natiello","376 Pine St, #5E","Bayshore, CA 94326","","","10000-933272658","Net 30","","","2E0000-933272656","San Tomas","","","12/16/2003 5:03:13 AM","12/15/2019 10:33:14 PM","1576429392","250000-933272658","Natiello, Ernesto:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/14/2020 12:00:00 AM","1096",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42628,"","12/14/2020 12:00:00 AM","","",2620.91,7.75,203.12,-2824.03,0,"","","",true,"40000-933272660","Please sign this estimate to indicate your approval.",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","4826-1071531193",1071,"","","","All"]
[null,null,"10000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Robson, Darci:Robson Clinic"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1097"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":12420.98},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-16"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"New Construction","Dr. Darci Robson","300 Main St, Suite 2","","","","Bayshore","CA","CA","CA","94326","","","Dr. Darci Robson","300 Main St, Suite 2","Bayshore CA 94326","","","Dr. Darci Robson","300 Main St, Suite 2","","","","Bayshore","CA","CA","CA","94326","","","Dr. Darci Robson","300 Main St, Suite 2","Bayshore CA 94326","","","","","","","2E0000-933272656","San Tomas","","","12/15/2003 8:01:52 PM","12/15/2019 10:31:26 PM","1576429286","610000-1071519006","Robson, Darci:Robson Clinic","40000-933270541","Accounts Receivable","70000-933287589","Progress Invoice","12/15/2020 12:00:00 AM","1097",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":""},42629,"","12/15/2020 12:00:00 AM","","",11917,7.75,503.98,0,12420.98,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","33B0-1071498712",560,"","","","All"]
[null,null,"40000-933272658",{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[CustomerRefFullName]]","v":"Cook, Brian:Kitchen"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[RefNumber]]","v":"1098"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[PONumber]]","v":""},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Terms]]","v":"Net 30"},{"$f":"Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[BalanceRemaining]]","v":1636.69},{"$f":" IFERROR( (DATEVALUE(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])),Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[DueDate]])","v":"2016-09-17"},{"$f":"IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Open Balance]]<=0,-1, IF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]]>TODAY(),0, DATEDIF(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[Due Date]],TODAY(),\"d\")))","v":0},"Remodel","Brian Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian Cook","345 Cherry Lane","Middlefield CA 94482","","","Brian K. Cook","345 Cherry Lane","","","","Middlefield","CA","CA","CA","94482","","","Brian K. Cook","345 Cherry Lane","Middlefield, CA 94482","","","10000-933272658","Net 30","","","2D0000-933272656","San Domingo","","","12/16/2003 3:12:37 AM","12/15/2019 10:33:01 PM","1576429381","1B0000-933272658","Cook, Brian:Kitchen","40000-933270541","Accounts Receivable","E0000-1071499861","Rock Castle Invoice","12/15/2020 12:00:00 AM","1098",false,false,"",{"$f":"(Table_QXL_QuickBooks_Data_Customer_Customer__1[[#This Row],[TermsRefFullName]])","v":"Net 30"},42630,"","12/15/2020 12:00:00 AM","","",1522.5,7.5,114.19,0,1636.69,"","","",false,"","",false,false,"","10000-999022286","Tax","10000-999022286","","","","","","","","445C-1071524557",1058,"","","","All"]