{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["New Invoice","Invoices"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":33,"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":"New Invoice","index":0,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[19,2,19,3],[39,0,40,0],[43,1,43,2],[47,0,48,3],[10,6,11,6],[10,7,11,7],[12,6,13,6],[12,7,13,7],[14,0,18,0],[15,4,15,5],[16,4,16,5],[0,0,4,3],[1,9,3,10],[4,6,7,7],[5,0,6,3],[8,6,9,6],[8,7,9,7]]}
["dc Tax, LLC \n9301 Ocoee St, #64\nChattanooga, TN 37363"]
[null,null,null,null,null,null,null,null,null,"Outstanding Invoices:"]
[]
[]
[null,null,null,null,null,null,"Payments Received"]
["tax relief for individuals & small business"]
[]
[]
[null,null,null,null,null,null,"Date:","2023-06-24"]
[]
[null,null,null,null,null,null,"Client:","Scott Brannon"]
[]
[null,null,null,null,null,null,"Client ID:",20230624103307]
[]
[null,null,null,null,null,null,"Amount:",500]
[null,null,null,null,"Invoice Client ID",null,"Applied to:",202306260903]
[null,null,null,null,null,null,"Payment Ref:","Check #1007, Truist Bank"]
[]
[]
[null,null,"INVOICE"]
[]
[]
[null,null,"Invoice #"]
[null,null,"Invoice Date"]
[null,null,"Invoice Due"]
[]
[]
[]
["Description","Qty","Rate","Total"]
[null,null,null,{"$f":"IF(NOT(AND(ISBLANK(B30),ISBLANK(C30))),B30*C30,\"\")","v":""}]
[null,null,null,{"$f":"IF(NOT(AND(ISBLANK(B31),ISBLANK(C31))),B31*C31,\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
[]
[null,null,"Sub-Total",{"$f":"IF(SUM(D30:D35)>0,SUM(D30:D35),\"\")","v":""}]
[]
["You can also pay securely, online through Stripe.  \nJust scan the QR code below.",null,"Other"]
[]
[null,null,"Tax"]
[]
[null,"Invoice Total",null,{"$f":"IF(SUM(D38:D43)>0,SUM(D38:D43),\"\")","v":""}]
[]
[]
[]
["Thank you for your business and may God bless you."]

{"sheet":"Invoices","index":1,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,10,0,11],[1,9,2,9],[1,10,2,11],[7,1,7,6],[7,8,7,12],[7,14,7,19]]}
[null,null,null,null,null,null,null,null,null,"# of Invoices","Accounts Receivable:"]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNT(I10:I100005)","v":18},{"$f":"SUM(Invoices!$M$10:$M$27)","v":5768.5},null,null,null,null,{"$f":"LEFT(D24,8)&MID(D24,9,1)+MID(D24,10,1)+MID(D24,11,1)+MID(D24,12,1)+MID(D24,13,1)+MID(D24,14,1)","v":"2023062414"}]
[]
[]
[]
[]
[]
[null,"Invoices",null,null,null,null,null,null,"Invoice Summary",null,null,null,null,null,"Payments"]
[null,"Invoice","Invoiced To","Invoiced To Record ID","Invoice Date","Invoice Due","Invoice Total",null,"Number","Name","Amount","Payments","Balance",null,"Invoice","Invoiced To","Invoiced To Record ID","Payment Date","Payment Reference","Payment Amount","Applied to Invoice"]
[null,202341754,"Lamberts Flooring Inc",459,"2023-04-17","2023-05-17",80,null,{"$f":"_xlfn.UNIQUE(TableInvoiceDetail[Invoice],FALSE)","v":202341754},{"$f":"IF(I10=\"\",\"\",_xlfn.XLOOKUP(I10,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I10,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":80},{"$f":"SUMIF(TablePaymentDetail[Invoice],I10,TablePaymentDetail[Applied to Invoice])","v":80},{"$f":"_xlfn.XLOOKUP(I10,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I10,TablePaymentDetail[Applied to Invoice])","v":0},null,202331643,"Lamberts Flooring Inc",459,"2023-04-12","Check #7436",256.5,256.5]
[null,202331642,"Lamberts Flooring Inc",459,"2023-03-16","2023-04-15",162,null,202331642,{"$f":"IF(I11=\"\",\"\",_xlfn.XLOOKUP(I11,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I11,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":162},{"$f":"SUMIF(TablePaymentDetail[Invoice],I11,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I11,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I11,TablePaymentDetail[Applied to Invoice])","v":162},null,202341754,"Lamberts Flooring Inc",459,"2023-05-31","Check # 7501 (CBBC)",80,80]
[null,202331643,"Lamberts Flooring Inc",459,"2023-03-16","2023-04-15",256.5,null,202331643,{"$f":"IF(I12=\"\",\"\",_xlfn.XLOOKUP(I12,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I12,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":256.5},{"$f":"SUMIF(TablePaymentDetail[Invoice],I12,TablePaymentDetail[Applied to Invoice])","v":256.5},{"$f":"_xlfn.XLOOKUP(I12,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I12,TablePaymentDetail[Applied to Invoice])","v":0},null,202341751,"Lamberts Southern Pies Inc",460,"2023-05-31","Check # 2854 (CBBC)",80,80]
[null,202331641,"Lamberts Flooring Inc",459,"2023-03-16","2023-04-15",414,null,202331641,{"$f":"IF(I13=\"\",\"\",_xlfn.XLOOKUP(I13,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I13,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":414},{"$f":"SUMIF(TablePaymentDetail[Invoice],I13,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I13,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I13,TablePaymentDetail[Applied to Invoice])","v":414},null,202306260903,"Scott Brannon",20230624103307,"Scott Brannon","Check #1007, Truist Bank",500]
[null,202331639,"Lamberts Flooring Inc",459,"2023-03-16","2023-04-15",445,null,202331639,{"$f":"IF(I14=\"\",\"\",_xlfn.XLOOKUP(I14,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I14,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":445},{"$f":"SUMIF(TablePaymentDetail[Invoice],I14,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I14,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I14,TablePaymentDetail[Applied to Invoice])","v":445}]
[null,202331648,"Lamberts Southern Pies Inc",460,"2023-03-16","2023-04-15",314,null,202331648,{"$f":"IF(I15=\"\",\"\",_xlfn.XLOOKUP(I15,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I15,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":314},{"$f":"SUMIF(TablePaymentDetail[Invoice],I15,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I15,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I15,TablePaymentDetail[Applied to Invoice])","v":314}]
[null,202331647,"Lamberts Southern Pies Inc",460,"2023-03-16","2023-04-15",256.5,null,202331647,{"$f":"IF(I16=\"\",\"\",_xlfn.XLOOKUP(I16,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I16,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":256.5},{"$f":"SUMIF(TablePaymentDetail[Invoice],I16,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I16,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I16,TablePaymentDetail[Applied to Invoice])","v":256.5}]
[null,202331646,"Lamberts Southern Pies Inc",460,"2023-03-16","2023-04-15",162,null,202331646,{"$f":"IF(I17=\"\",\"\",_xlfn.XLOOKUP(I17,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I17,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":162},{"$f":"SUMIF(TablePaymentDetail[Invoice],I17,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I17,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I17,TablePaymentDetail[Applied to Invoice])","v":162}]
[null,202341751,"Lamberts Southern Pies Inc",460,"2023-04-17","2023-05-17",80,null,202341751,{"$f":"IF(I18=\"\",\"\",_xlfn.XLOOKUP(I18,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I18,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":80},{"$f":"SUMIF(TablePaymentDetail[Invoice],I18,TablePaymentDetail[Applied to Invoice])","v":80},{"$f":"_xlfn.XLOOKUP(I18,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I18,TablePaymentDetail[Applied to Invoice])","v":0}]
[null,202331644,"Lamberts Southern Pies Inc",460,"2023-03-16","2023-04-15",345,null,202331644,{"$f":"IF(I19=\"\",\"\",_xlfn.XLOOKUP(I19,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I19,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":345},{"$f":"SUMIF(TablePaymentDetail[Invoice],I19,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I19,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I19,TablePaymentDetail[Applied to Invoice])","v":345}]
[null,202305231659,"Larson Consulting",461,"2023-05-23","2023-06-22",495,null,202305231659,{"$f":"IF(I20=\"\",\"\",_xlfn.XLOOKUP(I20,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Larson Consulting"},{"$f":"_xlfn.XLOOKUP(I20,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":495},{"$f":"SUMIF(TablePaymentDetail[Invoice],I20,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I20,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I20,TablePaymentDetail[Applied to Invoice])","v":495}]
[null,202305241104,"Lamberts Flooring Inc",459,"2023-05-24","2023-06-23",45,null,202305241104,{"$f":"IF(I21=\"\",\"\",_xlfn.XLOOKUP(I21,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I21,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":45},{"$f":"SUMIF(TablePaymentDetail[Invoice],I21,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I21,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I21,TablePaymentDetail[Applied to Invoice])","v":45}]
[null,202305241109,"Lamberts Southern Pies Inc",460,"2023-05-24","2023-06-23",45,null,202305241109,{"$f":"IF(I22=\"\",\"\",_xlfn.XLOOKUP(I22,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I22,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":45},{"$f":"SUMIF(TablePaymentDetail[Invoice],I22,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I22,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I22,TablePaymentDetail[Applied to Invoice])","v":45}]
[null,202305241629,"Larson Consulting",461,"2023-05-24","2023-06-23",495,null,202305241629,{"$f":"IF(I23=\"\",\"\",_xlfn.XLOOKUP(I23,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Larson Consulting"},{"$f":"_xlfn.XLOOKUP(I23,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":495},{"$f":"SUMIF(TablePaymentDetail[Invoice],I23,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I23,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I23,TablePaymentDetail[Applied to Invoice])","v":495}]
[null,202306260903,"Scott Brannon",20230624103307,"2023-06-26","2023-07-26",1000,null,202306260903,{"$f":"IF(I24=\"\",\"\",_xlfn.XLOOKUP(I24,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Scott Brannon"},{"$f":"_xlfn.XLOOKUP(I24,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":1000},{"$f":"SUMIF(TablePaymentDetail[Invoice],I24,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I24,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I24,TablePaymentDetail[Applied to Invoice])","v":1000}]
[null,202307040752,"Lamberts Flooring Inc",459,"2023-07-04","2023-08-03",45,null,202307040752,{"$f":"IF(I25=\"\",\"\",_xlfn.XLOOKUP(I25,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Flooring Inc"},{"$f":"_xlfn.XLOOKUP(I25,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":45},{"$f":"SUMIF(TablePaymentDetail[Invoice],I25,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I25,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I25,TablePaymentDetail[Applied to Invoice])","v":45}]
[null,202307040755,"Lamberts Southern Pies Inc",460,"2023-07-04","2023-08-03",45,null,202307040755,{"$f":"IF(I26=\"\",\"\",_xlfn.XLOOKUP(I26,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Lamberts Southern Pies Inc"},{"$f":"_xlfn.XLOOKUP(I26,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":45},{"$f":"SUMIF(TablePaymentDetail[Invoice],I26,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I26,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I26,TablePaymentDetail[Applied to Invoice])","v":45}]
[null,202307211135,"Curtis L Greene",20230623141751,"2023-07-21","2023-08-20",1500,null,202307211135,{"$f":"IF(I27=\"\",\"\",_xlfn.XLOOKUP(I27,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoiced To]))","v":"Curtis L Greene"},{"$f":"_xlfn.XLOOKUP(I27,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])","v":1500},{"$f":"SUMIF(TablePaymentDetail[Invoice],I27,TablePaymentDetail[Applied to Invoice])","v":0},{"$f":"_xlfn.XLOOKUP(I27,TableInvoiceDetail[Invoice],TableInvoiceDetail[Invoice Total])-SUMIF(TablePaymentDetail[Invoice],I27,TablePaymentDetail[Applied to Invoice])","v":1500}]