{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["📊 Sales Register","🏢 Company Settings","📦 Product Master","👥 Client Master","🧾 Tax Invoice","📖 Instructions"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"📊 Sales Register","index":0,"n_rows":5,"n_cols":13,"rows_kept":5,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,2],[3,3,3,5],[3,6,3,8],[3,9,3,11]]}
["📊 SALES REGISTER & INVOICE HISTORY AUDIT LOG"]
["⚠️ NOTE: THIS SALES REGISTER IS AUTO-GENERATED & AUTO-UPDATED AUTOMATION LOG. NO MANUAL ENTRY IS REQUIRED."]
[]
["Total Invoices Issued: =COUNTA(B6:B1000)",null,null,"Total Taxable Sales: =SUM(H6:H1000)",null,null,"Total Tax Collected: =SUM(I6:K1000)",null,null,"Total Revenue (Incl. Tax): =SUM(L6:L1000)"]
["S.No.","Invoice No.","Date","Invoice Type","Client Name","Client GSTIN","Place of Supply","Taxable Value (₹)","CGST (₹)","SGST (₹)","IGST (₹)","Total Amount (₹)","Saved Timestamp"]

{"sheet":"🏢 Company Settings","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"merged":[[0,0,0,2]]}
["🏢 COMPANY / BUSINESS PROFILE & INVOICE SETTINGS"]
["Field Name","Setting / Value","Description / Usage"]
["Business / Firm Name","Smartious Institute of Accounts and Taxation","Appears as Seller Name on Invoice Header"]
["GSTIN","07AAAAA0000A1Z5","Seller GSTIN Number"]
["Address","123, Commercial Complex, Connaught Place, New Delhi - 110001","Seller Billing Address"]
["State","Delhi","Seller State Name"]
["State Code",7,"Seller 2-digit State Code (e.g. 07 for Delhi)"]
["Phone","+91 98765 43210","Seller Contact Number"]
["Email","info@capiyushgupta.com","Seller Official Email"]
["Website","https://capiyushgupta.com","Seller Website URL"]
["Bank Name","HDFC Bank Ltd","Bank Name for payment transfer"]
["Account Number",50200012345678,"Seller Bank Account Number"]
["IFSC Code","HDFC0001234","Bank Branch IFSC Code"]
["Branch Name","Connaught Place, New Delhi","Bank Branch Address"]
["UPI ID","capiyushgupta@upi","UPI Payment ID for QR / Direct Transfer"]
["Invoice Number Prefix","INV/25-26/","Prefix added before sequence number"]
["Next Invoice Sequence No",1,"Numerical counter auto-incremented by Save Macro"]
["Default Terms & Conditions","1. Goods/Services once supplied cannot be taken back.\n2. Subject to Delhi Jurisdiction.\n3. Interest @18% p.a. will be charged if payment is not made within due date.","Default footer terms"]

{"sheet":"📦 Product Master","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[0,0,0,5]]}
["📦 PRODUCT / SERVICE MASTER CATALOG"]
["S.No.","Product / Service Name","HSN / SAC Code","Unit","Unit Rate (₹)","GST Rate %"]
[1,"Accounting & Bookkeeping Consultancy Services",998222,"SAC",{"v":15000,"d":"₹15,000.00"},{"v":0.18,"d":"18%"}]
[2,"GST Return Filing & Compliance Retainer",998231,"SAC",{"v":5000,"d":"₹5,000.00"},{"v":0.18,"d":"18%"}]
[3,"Tally Prime Gold Software License",852380,"NOS",{"v":22500,"d":"₹22,500.00"},{"v":0.18,"d":"18%"}]
[4,"Office Stationery & Supplies Set",482010,"SET",{"v":1200,"d":"₹1,200.00"},{"v":0.12,"d":"12%"}]
[5,"Taxation Advisory & Audit Retainer",998221,"HRS",{"v":2500,"d":"₹2,500.00"},{"v":0.18,"d":"18%"}]

{"sheet":"👥 Client Master","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"merged":[[0,0,0,7]]}
["👥 CLIENT / CUSTOMER MASTER DATABASE"]
["S.No.","Client / Customer Name","GSTIN","Contact Person","Phone","Email","Billing Address","State & Code"]
[1,"ABC Enterprises Pvt Ltd","07AAACA1234B1Z2","Rajesh Kumar",9811122233,"rajesh@abcent.com","Plot 45, Okhla Phase 3, New Delhi - 110020","Delhi (07)"]
[2,"TechSolutions India Pvt Ltd","27BBBCT5678C1Z9","Amit Sharma",9822233344,"info@techsol.com","102, MG Road, Mumbai, Maharashtra - 400001","Maharashtra (27)"]
[3,"Sharma Traders","07CCCDS9012D1Z4","Vijay Sharma",9833344455,"vijay@sharmatraders.in","Shop 12, Karol Bagh, New Delhi - 110005","Delhi (07)"]

{"sheet":"🧾 Tax Invoice","index":4,"n_rows":45,"n_cols":14,"rows_kept":45,"merged":[[1,0,1,11],[3,0,3,11],[4,0,4,11],[6,1,6,2],[6,4,6,5],[6,7,6,8],[8,0,8,11],[10,0,10,4],[10,6,10,11],[11,0,11,4],[11,7,11,11],[12,0,12,4],[12,7,12,11],[13,0,13,4],[13,7,13,11],[14,0,14,4],[14,7,14,11],[15,0,15,4],[15,7,15,11],[17,0,17,11],[18,1,18,11],[19,1,19,4],[19,7,19,11],[20,1,20,11],[34,8,34,10],[35,8,35,10],[36,8,36,10],[37,8,37,10],[38,1,38,11],[40,0,40,4],[40,5,40,8],[40,9,40,11],[41,0,41,4],[41,5,44,8],[41,9,41,11],[42,0,42,4],[43,0,43,4],[44,0,44,4],[44,9,44,11]]}
[]
["CA Piyush Gupta | Smartious Institute of Accounts and Taxation"]
[]
["TAX INVOICE & BILLING GENERATOR (OFFLINE EXCEL TOOL)"]
["🎓 Become a Highly Paid Expert Accountant — Join Practical Course at capiyushgupta.com"]
[]
[null,"🌐 Visit Website (capiyushgupta.com)",null,null,"💬 Join WhatsApp Group",null,null,"📱 Download Android App"]
[]
["💡 INSTRUCTIONS: Select Client Name in cell B19 & Products in item table. Use the Action Buttons on the Right Sidebar to Save or Print PDF."]
[]
["SELLER / SUPPLIER DETAILS",{"$nulls":5},"INVOICE METADATA & CONTROL",{"$nulls":6},"⚡ QUICK INVOICE ACTIONS"]
[{"$f":"'🏢 Company Settings'!B3","v":"Smartious Institute of Accounts and Taxation"},{"$nulls":5},"Invoice Type:","TAX INVOICE"]
[{"$f":"\"GSTIN: \" & '🏢 Company Settings'!B4","v":"GSTIN: 07AAAAA0000A1Z5"},{"$nulls":5},"Invoice No.:",{"$f":"'🏢 Company Settings'!B16 & TEXT('🏢 Company Settings'!B17, \"000\")","v":"INV/25-26/001"}]
[{"$f":"'🏢 Company Settings'!B5","v":"123, Commercial Complex, Connaught Place, New Delhi - 110001"},{"$nulls":5},"Invoice Date:",{"$f":"TODAY()","v":"2026-08-09"}]
[{"$f":"\"State: \" & '🏢 Company Settings'!B6 & \" (Code: \" & '🏢 Company Settings'!B7 & \")\"","v":"State: Delhi (Code: 7)"},{"$nulls":5},"Due Date:",{"$f":"TODAY()+15","v":"2026-08-24"}]
[{"$f":"\"Phone: \" & '🏢 Company Settings'!B8 & \" | Email: \" & '🏢 Company Settings'!B9","v":"Phone: +91 98765 43210 | Email: info@capiyushgupta.com"},{"$nulls":5},"Supply Type:",{"$f":"IF(B19=\"\", \"INTRASTATE (CGST+SGST)\", IF(ISNUMBER(SEARCH(\"(\" & TEXT('🏢 Company Settings'!$B$7, \"00\") & \")\", VLOOKUP(B19, '👥 Client Master'!$B$3:$H$100, 7, FALSE))), \"INTRASTATE (CGST+SGST)\", \"INTERSTATE (IGST)\"))","v":"INTRASTATE (CGST+SGST)"}]
[]
["BUYER / CLIENT DETAILS (BILL TO)"]
["Select Client Name:","ABC Enterprises Pvt Ltd"]
["Client GSTIN:",{"$f":"IF(B19<>\"\", VLOOKUP(B19, '👥 Client Master'!$B$3:$H$100, 2, FALSE), \"\")","v":"07AAACA1234B1Z2"},{"$nulls":4},"Place of Supply:",{"$f":"IF(B19<>\"\", VLOOKUP(B19, '👥 Client Master'!$B$3:$H$100, 7, FALSE), \"\")","v":"Delhi (07)"}]
["Billing Address:",{"$f":"IF(B19<>\"\", VLOOKUP(B19, '👥 Client Master'!$B$3:$H$100, 6, FALSE), \"\")","v":"Plot 45, Okhla Phase 3, New Delhi - 110020"}]
[]
["S.No.","Description of Goods / Services","HSN/SAC","Qty","Unit","Rate (₹)","Taxable Value (₹)","GST %","CGST (₹)","SGST (₹)","IGST (₹)","Total (₹)"]
[{"$f":"IF(B24<>\"\", 1, \"\")","v":1},"Accounting & Bookkeeping Consultancy Services",{"$f":"IF(B24<>\"\", VLOOKUP(B24, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":998222},1,{"$f":"IF(B24<>\"\", VLOOKUP(B24, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":"SAC"},{"$f":"IF(B24<>\"\", VLOOKUP(B24, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":15000,"d":"₹15,000.00"}},{"$f":"IF(B24<>\"\", D24*F24, 0)","v":{"v":15000,"d":"₹15,000.00"}},{"$f":"IF(B24<>\"\", VLOOKUP(B24, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0.18,"d":"18%"}},{"$f":"IF(AND(B24<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G24*(H24/2), 0)","v":{"v":1350,"d":"₹1,350.00"}},{"$f":"IF(AND(B24<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G24*(H24/2), 0)","v":{"v":1350,"d":"₹1,350.00"}},{"$f":"IF(AND(B24<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G24*H24, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B24<>\"\", G24+I24+J24+K24, 0)","v":{"v":17700,"d":"₹17,700.00"}}]
[{"$f":"IF(B25<>\"\", 2, \"\")","v":2},"GST Return Filing & Compliance Retainer",{"$f":"IF(B25<>\"\", VLOOKUP(B25, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":998231},1,{"$f":"IF(B25<>\"\", VLOOKUP(B25, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":"SAC"},{"$f":"IF(B25<>\"\", VLOOKUP(B25, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":5000,"d":"₹5,000.00"}},{"$f":"IF(B25<>\"\", D25*F25, 0)","v":{"v":5000,"d":"₹5,000.00"}},{"$f":"IF(B25<>\"\", VLOOKUP(B25, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0.18,"d":"18%"}},{"$f":"IF(AND(B25<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G25*(H25/2), 0)","v":{"v":450,"d":"₹450.00"}},{"$f":"IF(AND(B25<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G25*(H25/2), 0)","v":{"v":450,"d":"₹450.00"}},{"$f":"IF(AND(B25<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G25*H25, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B25<>\"\", G25+I25+J25+K25, 0)","v":{"v":5900,"d":"₹5,900.00"}}]
[{"$f":"IF(B26<>\"\", 3, \"\")","v":""},null,{"$f":"IF(B26<>\"\", VLOOKUP(B26, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B26<>\"\", VLOOKUP(B26, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B26<>\"\", VLOOKUP(B26, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B26<>\"\", D26*F26, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B26<>\"\", VLOOKUP(B26, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B26<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G26*(H26/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B26<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G26*(H26/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B26<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G26*H26, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B26<>\"\", G26+I26+J26+K26, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B27<>\"\", 4, \"\")","v":""},null,{"$f":"IF(B27<>\"\", VLOOKUP(B27, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B27<>\"\", VLOOKUP(B27, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B27<>\"\", VLOOKUP(B27, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B27<>\"\", D27*F27, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B27<>\"\", VLOOKUP(B27, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B27<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G27*(H27/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B27<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G27*(H27/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B27<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G27*H27, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B27<>\"\", G27+I27+J27+K27, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B28<>\"\", 5, \"\")","v":""},null,{"$f":"IF(B28<>\"\", VLOOKUP(B28, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B28<>\"\", VLOOKUP(B28, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B28<>\"\", VLOOKUP(B28, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B28<>\"\", D28*F28, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B28<>\"\", VLOOKUP(B28, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B28<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G28*(H28/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B28<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G28*(H28/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B28<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G28*H28, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B28<>\"\", G28+I28+J28+K28, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B29<>\"\", 6, \"\")","v":""},null,{"$f":"IF(B29<>\"\", VLOOKUP(B29, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B29<>\"\", VLOOKUP(B29, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B29<>\"\", VLOOKUP(B29, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B29<>\"\", D29*F29, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B29<>\"\", VLOOKUP(B29, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B29<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G29*(H29/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B29<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G29*(H29/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B29<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G29*H29, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B29<>\"\", G29+I29+J29+K29, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B30<>\"\", 7, \"\")","v":""},null,{"$f":"IF(B30<>\"\", VLOOKUP(B30, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B30<>\"\", VLOOKUP(B30, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B30<>\"\", VLOOKUP(B30, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B30<>\"\", D30*F30, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B30<>\"\", VLOOKUP(B30, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B30<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G30*(H30/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B30<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G30*(H30/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B30<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G30*H30, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B30<>\"\", G30+I30+J30+K30, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B31<>\"\", 8, \"\")","v":""},null,{"$f":"IF(B31<>\"\", VLOOKUP(B31, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B31<>\"\", VLOOKUP(B31, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B31<>\"\", VLOOKUP(B31, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B31<>\"\", D31*F31, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B31<>\"\", VLOOKUP(B31, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B31<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G31*(H31/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B31<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G31*(H31/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B31<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G31*H31, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B31<>\"\", G31+I31+J31+K31, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B32<>\"\", 9, \"\")","v":""},null,{"$f":"IF(B32<>\"\", VLOOKUP(B32, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B32<>\"\", VLOOKUP(B32, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B32<>\"\", VLOOKUP(B32, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B32<>\"\", D32*F32, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B32<>\"\", VLOOKUP(B32, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B32<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G32*(H32/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B32<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G32*(H32/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B32<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G32*H32, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B32<>\"\", G32+I32+J32+K32, 0)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(B33<>\"\", 10, \"\")","v":""},null,{"$f":"IF(B33<>\"\", VLOOKUP(B33, '📦 Product Master'!$B$3:$F$100, 2, FALSE), \"\")","v":""},1,{"$f":"IF(B33<>\"\", VLOOKUP(B33, '📦 Product Master'!$B$3:$F$100, 3, FALSE), \"\")","v":""},{"$f":"IF(B33<>\"\", VLOOKUP(B33, '📦 Product Master'!$B$3:$F$100, 4, FALSE), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B33<>\"\", D33*F33, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B33<>\"\", VLOOKUP(B33, '📦 Product Master'!$B$3:$F$100, 5, FALSE), 0)","v":{"v":0,"d":"0%"}},{"$f":"IF(AND(B33<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G33*(H33/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B33<>\"\", ISNUMBER(SEARCH(\"INTRASTATE\", $H$16))), G33*(H33/2), 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(AND(B33<>\"\", ISNUMBER(SEARCH(\"INTERSTATE\", $H$16))), G33*H33, 0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(B33<>\"\", G33+I33+J33+K33, 0)","v":{"v":0,"d":"₹0.00"}}]
["TOTALS",{"$nulls":5},{"$f":"SUM(G24:G33)","v":{"v":20000,"d":"₹20,000.00"}},null,{"$f":"SUM(I24:I33)","v":{"v":1800,"d":"₹1,800.00"}},{"$f":"SUM(J24:J33)","v":{"v":1800,"d":"₹1,800.00"}},{"$f":"SUM(K24:K33)","v":{"v":0,"d":"₹0.00"}},{"$f":"SUM(L24:L33)","v":{"v":23600,"d":"₹23,600.00"}}]
[{"$nulls":8},"Subtotal Taxable Value:",null,null,{"$f":"G34","v":{"v":20000,"d":"₹20,000.00"}}]
[{"$nulls":8},"Total GST Amount:",null,null,{"$f":"SUM(I34:K34)","v":{"v":3600,"d":"₹3,600.00"}}]
[{"$nulls":8},"Round Off Amount:",null,null,{"$f":"ROUND(G34+SUM(I34:K34), 0) - (G34+SUM(I34:K34))","v":{"v":0,"d":"₹0.00"}}]
[{"$nulls":8},"GRAND TOTAL (₹):",null,null,{"$f":"ROUND(G34+SUM(I34:K34), 0)","v":{"v":23600,"d":"₹23,600.00"}}]
["Amount in Words:",{"$f":"SpellNumber(L38)","v":{"$error":"#NAME?"}}]
[]
["BANK & PAYMENT DETAILS",{"$nulls":4},"TERMS & CONDITIONS",{"$nulls":3},"FOR SELLER FIRM"]
[{"$f":"\"Bank Name: \" & '🏢 Company Settings'!B11","v":"Bank Name: HDFC Bank Ltd"},{"$nulls":4},{"$f":"'🏢 Company Settings'!B18","v":"1. Goods/Services once supplied cannot be taken back.\n2. Subject to Delhi Jurisdiction.\n3. Interest @18% p.a. will be charged if payment is not made within due date."},{"$nulls":3},{"$f":"\"For \" & '🏢 Company Settings'!B3","v":"For Smartious Institute of Accounts and Taxation"}]
[{"$f":"\"Account No.: \" & '🏢 Company Settings'!B12","v":"Account No.: 50200012345678"}]
[{"$f":"\"IFSC Code: \" & '🏢 Company Settings'!B13 & \" | Branch: \" & '🏢 Company Settings'!B14","v":"IFSC Code: HDFC0001234 | Branch: Connaught Place, New Delhi"}]
[{"$f":"\"UPI ID: \" & '🏢 Company Settings'!B15","v":"UPI ID: capiyushgupta@upi"},{"$nulls":8},"(Authorized Signatory)"]

{"sheet":"📖 Instructions","index":5,"n_rows":16,"n_cols":3,"rows_kept":16,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[12,0,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6]]}
["📖 USER GUIDE & VISUAL INSTRUCTION MANUAL"]
["OFFLINE GST INVOICE GENERATOR TOOL — CA PIYUSH GUPTA | SMARTIOUS INSTITUTE"]
[]
["🚀 QUICK START WORKFLOW & INSTRUCTIONS"]
["STEP 1: ONE-TIME COMPANY SETUP","🏢 Company Settings Sheet","Open 'Company Settings' sheet and enter your Firm Name, GSTIN, Address, Phone, Email, Bank Details, and Invoice Prefix once. These details will automatically populate every invoice."]
["STEP 2: CLIENT MASTER DATABASE","👥 Client Master Sheet","Add your regular customers in 'Client Master' with their GSTIN, Address, and State. In the invoice sheet, simply select the client name from the dropdown to auto-fill all details."]
["STEP 3: PRODUCT CATALOG MASTER","📦 Product Master Sheet","Maintain your goods and services in 'Product Master' with HSN/SAC codes, rates, and GST % (12%, 18%, etc.). Item details will auto-calculate when picked in the invoice table."]
["STEP 4: CREATE & PRINT TAX INVOICE","🧾 Tax Invoice Sheet","Select Client Name in cell B19 and items in the invoice table. Taxes (CGST, SGST, IGST), totals, and Indian Rupees amount-in-words populate dynamically."]
["STEP 5: ACTION BUTTONS (RIGHT SIDEBAR)","⚡ Right Action Sidebar","Use the buttons on the right side of the screen:\n  • 💾 Save & Archive Invoice: Logs sale to Sales Register & increments next invoice sequence.\n  • 🖨️ Export PDF / Print: Generates a clean 1-page PDF invoice and auto-archives sale.\n  • 🔄 Clear Form: Resets line items for the next invoice."]
["STEP 6: AUTOMATED SALES AUDIT LOG","📊 Sales Register Sheet","⚠️ NOTE: The Sales Register is auto-generated and auto-updated every time an invoice is saved or printed. No manual entry is required."]
[]
[]
["🔒 SECURITY & PROTECTION HIGHLIGHTS"]
["• Hidden & Protected Formulas","All calculation formulas (CGST, SGST, IGST, Lookups, SpellNumber) are hidden and locked to prevent accidental corruption or modification."]
["• Single-Page PDF Print Layout","PDF exports are configured to print cleanly on a single page, excluding promotional banners and macro sidebar buttons."]
["• Offline Operations","Operates 100% offline without requiring internet connection or website login."]