{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Home Page","PDF Template","BOS - PDF Template Main","BOS - PDF Template","PDF Template Main","Organisation Details","Static","Customer Master","Add Sales Invoice","Add Sales Bill of Supply","Add Sales CDN","All Sales CDN","All Sales Invoices","Add Advance Receipt","All Advance Receipts"],"not_rendered":{"charts":0,"images":55,"macros":1,"external_links":0,"defined_names":16,"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":"Home Page","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,1,43,12],[44,1,47,12],[38,1,38,4],[38,5,38,12],[39,1,39,4],[39,5,39,12],[40,1,40,4],[40,5,40,12],[37,1,37,4],[37,5,37,12],[29,1,29,7],[29,8,29,12],[30,1,30,7],[30,8,30,12],[31,1,31,7],[31,8,31,12],[32,1,32,7],[32,8,32,12],[35,1,35,12],[36,1,36,4],[36,5,36,12],[28,1,28,7],[28,8,28,12],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[25,1,25,7],[25,8,25,12],[26,1,26,7],[26,8,26,12],[27,1,27,7],[27,8,27,12],[21,2,21,6],[20,2,20,6],[14,2,14,6],[1,1,1,12],[4,9,4,12],[5,9,5,12],[11,1,11,6],[13,2,13,6],[6,9,6,12]]}
[]
[null,"Please enable macros to use this tool. Works best in Excel 2007, 2010, 2013 and 2016."]
[]
[]
[null,null,null,null,null,null,null,"Offline Tool ID",null,"Welcome to ClearTax GST Offline"]
[null,null,null,null,null,null,null,"VU94029",null,"Version - 4.1"]
[null,null,null,null,null,null,null,null,null,"India's easiest Excel based Invoicing Software"]
[]
[]
[]
[]
[null,"How to use ClearTax GST Offline?"]
[]
[null,null,"Step 1 - Add your organization details"]
[null,null,"Step 2 - Set up Item and Customer masters"]
[null,null,"Step 3 - Start creating:"]
[null,null,"Sales invoices"]
[null,null,"Bill of Supply"]
[null,null,"Import invoices"]
[null,null,"Sales Credit/ Debit notes"]
[null,null,"Advance Receipts"]
[null,null,"Step 4 - File GST Returns with invoice data"]
[]
[]
[]
[null,"Features",null,null,null,null,null,null,"Benefits"]
[null,"Invoice Creation",null,null,null,null,null,null,"GST-compliant Sales Invoice creation"]
[null,"Invoice Printing",null,null,null,null,null,null,"One-click invoice printing"]
[null,"Invoice Storage",null,null,null,null,null,null,"Auto-saving of all invoices in separate monthly folders "]
[null,"Reprinting of Old Invoices",null,null,null,null,null,null,"All the old invoices can be re-printed if needed"]
[null,"Validations to Reduce Errors",null,null,null,null,null,null,"Automatic highlighting in case of human errors"]
[null,"Explanation of Titles",null,null,null,null,null,null,"Explainer text for all headers and titles"]
[null,"Easy Navigation Links",null,null,null,null,null,null,"Navigation buttons in all sheets"]
[]
[]
[null,"An Easy Guide to Using ClearTax GST Offline"]
[null,"Step 1",null,null,null,"Fill the mandatory information in the sheet named Organisation Detail"]
[null,"Step 2",null,null,null,"For easy invoice creation input Items List in the sheet named Item Master"]
[null,"Step 3",null,null,null,"For recurring customers, import the contacts to the Customer Master. Alternatively, add New Customers to the Add Invoice sheet when generating invoices "]
[null,"Step 4",null,null,null,"Create, print and save invoices in just one click from the Add Invoice sheet"]
[null,"Step 5",null,null,null,"To reprint an old invoice, check the All Invoices sheet. These invoices will be saved in a separate folder, which will be created automatically"]
[]
[]
[null,"Filing Returns with ClearTax GST Software"]
[null,"After creating your invoices with ClearTax GST Offline, you can easily file your returns by using our online software - ClearTax GST. Filing all GST Returns on ClearTax GST Software is highly simplified for CAs and Businesses:\n\n1. Create invoices for all clients using the offline tool \n2. Upload all invoices to the ClearTax GST online platform for filing in one click\n3. The online software auto-populates the return forms using data from the uploaded invoices. Review the final invoices and file your returns"]

{"sheet":"PDF Template","index":1,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":true,"merged":[[51,1,51,12],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,5,28,5],[27,7,28,7],[27,12,28,12],[29,1,29,3],[30,1,30,12],[40,11,41,12],[43,11,43,12],[49,1,49,12],[25,12,26,12],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,5,24,5],[23,7,24,7],[23,12,24,12],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,5,26,5],[25,7,26,7],[21,12,22,12],[5,10,5,11],[16,11,16,12],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,5,20,5],[19,7,20,7],[19,12,20,12],[5,2,5,3],[5,5,6,7],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,5,22,5],[21,7,22,7],[0,5,0,7],[2,2,2,3],[2,7,2,8],[3,7,3,8],[4,7,4,8]]}
[null,null,null,null,null,"ORIGINAL COPY"]
[null,{"$f":"UPPER('Organisation Details'!B2)","v":"1"}]
[null,"GSTIN",{"$f":"'Organisation Details'!B3","v":0},null,null,null,null,"CDN Date",null,null,"Invoice Date"]
[null,"State",{"$f":"'Organisation Details'!B10","v":"Please Fill GSTIN"},null,null,null,null,"CDN Number",null,null,"Invoice Number"]
[null,"PAN",{"$f":"'Organisation Details'!B4","v":""},null,null,null,null,null,null,null,"Reference No"]
[null,{"$f":"IF('Organisation Details'!B14=\"\",\"\",\"CIN\")","v":""},{"$f":"IF('Organisation Details'!B14=\"\",\"\",'Organisation Details'!B14)","v":""},null,null,"TAX INVOICE",null,null,null,null,"Linked Advance Receipt"]
[]
[null,"Customer Name",null,null,null,"Customer Billing Address",null,null,null,null,"Customer Shipping Address"]
[]
[]
[null,"Customer GSTIN"]
[]
[]
[null,"Country of Supply",null,"India",null,null,null,null,null,"Place of Supply"]
[]
[null,"Type of Export",null,null,null,null,null,null,null,"Shipping Port Code"]
[null,"Shipping Billing No",null,null,null,null,null,null,null,"Shipping Bill Date"]
[]
[null,"S No.","Item Description","HSN/ SAC Code","Quantity","Price per Unit (₹)","Discount (₹)","Taxable Value (₹)","IGST (₹)","CGST (₹)","SGST (₹)","Cess (₹)","Total Value (₹)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Taxable Amount:"]
[]
[null,{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",\"Bank Name\")","v":""},{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",'Organisation Details'!$B$17)","v":""},null,null,null,null,null,null,null,null,"Total Tax:"]
[null,{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",\"Bank A/c No\")","v":""},{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",'Organisation Details'!$B$18)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",\"IFSC Code\")","v":""},{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",'Organisation Details'!$B$19)","v":""},null,null,null,null,null,null,null,null,"Invoice Total:"]
[]
[]
[]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",\"Note:\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"For \"&'Organisation Details'!B2","v":"For 1"}]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",'Organisation Details'!$B$21)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"(Authorised Signatory)"]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",\"Terms and Conditions\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",'Organisation Details'!$B$20)","v":""}]
[]
[]
[]
[null,{"$f":"IF('Organisation Details'!B8=\"\",'Organisation Details'!B7&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5,'Organisation Details'!B7&\", \"&'Organisation Details'!B8&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5)","v":", , Please Fill GSTIN. Ph: 123456"}]
[]
[null,{"$f":"IF('Organisation Details'!$B$15=\"\",\"\",'Organisation Details'!$B$15)","v":""}]

{"sheet":"BOS - PDF Template Main","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":true,"merged":[[2,6,3,6],[2,7,3,7],[5,2,5,4],[5,5,6,6],[0,5,0,6],[15,8,15,9],[16,1,17,1],[16,2,17,4],[16,5,17,5],[16,7,17,7],[16,8,16,9],[15,2,15,4],[20,10,21,10],[21,8,21,9],[16,10,17,10],[17,8,17,9],[18,1,19,1],[18,2,19,4],[18,5,19,5],[18,7,19,7],[18,8,18,9],[18,10,19,10],[19,8,19,9],[20,1,21,1],[20,2,21,4],[20,5,21,5],[20,7,21,7],[20,8,20,9],[24,10,25,10],[25,8,25,9],[22,1,23,1],[22,2,23,4],[22,5,23,5],[22,7,23,7],[22,8,22,9],[22,10,23,10],[23,8,23,9],[24,1,25,1],[24,2,25,4],[24,5,25,5],[24,7,25,7],[24,8,24,9],[36,9,36,10],[40,1,40,10],[42,5,42,6],[26,1,26,5],[26,8,26,9],[27,1,27,10],[30,2,30,3],[31,9,32,10],[35,9,35,10]]}
[]
[null,{"$f":"UPPER('Organisation Details'!B2)","v":"1"}]
[null,"GSTIN",{"$f":"'Organisation Details'!B3","v":0},null,null,null,"Linked Advance Receipt",null,"Invoice No"]
[null,"State",{"$f":"'Organisation Details'!B10","v":"Please Fill GSTIN"},null,null,null,null,null,"Invoice Date"]
[null,"PAN",{"$f":"'Organisation Details'!B4","v":""},null,null,null,null,null,"Reference No"]
[null,{"$f":"IF('Organisation Details'!B14=\"\",\"\",\"CIN\")","v":""},{"$f":"IF('Organisation Details'!B14=\"\",\"\",'Organisation Details'!B14)","v":""},null,null,"BILL OF SUPPLY"]
[]
[null,"Customer Name",null,null,null,"Customer Billing Address",null,null,"Customer Shipping Address"]
[]
[]
[null,"Customer GSTIN"]
[]
[]
[null,"Country of Supply",null,null,"India",null,null,"Place of Supply"]
[]
[null,"S No.","Item Description",null,null,"HSN/ SAC Code","Quantity","Price per Unit  (₹)","Discount (₹)",null,"Total Value (₹)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals"]
[]
[]
[null,{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",\"Bank Name\")","v":""},{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",'Organisation Details'!$B$17)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",\"Bank A/c No\")","v":""},{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",'Organisation Details'!$B$18)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",\"IFSC Code\")","v":""},{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",'Organisation Details'!$B$19)","v":""},null,null,null,null,null,null,{"$f":"\"For \"&'Organisation Details'!B2","v":"For 1"}]
[]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",\"Note:\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",'Organisation Details'!$B$21)","v":""}]
[null,null,null,null,null,null,null,null,null,"(Authorised Signatory)"]
[]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",\"Terms and Conditions\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",'Organisation Details'!$B$20)","v":""}]
[]
[null,{"$f":"IF('Organisation Details'!B8=\"\",'Organisation Details'!B7&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5,'Organisation Details'!B7&\", \"&'Organisation Details'!B8&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5)","v":", , Please Fill GSTIN. Ph: 123456"}]
[]
[null,null,null,null,null,{"$f":"IF('Organisation Details'!B15=\"\",\"\",'Organisation Details'!B15)","v":""}]

{"sheet":"BOS - PDF Template","index":3,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":true,"merged":[[36,9,36,10],[40,1,40,10],[42,5,42,6],[26,1,26,5],[26,8,26,9],[27,1,27,10],[30,2,30,3],[31,9,32,10],[35,9,35,10],[24,10,25,10],[25,8,25,9],[22,1,23,1],[22,2,23,4],[22,5,23,5],[22,7,23,7],[22,8,22,9],[22,10,23,10],[23,8,23,9],[24,1,25,1],[24,2,25,4],[24,5,25,5],[24,7,25,7],[24,8,24,9],[20,10,21,10],[21,8,21,9],[16,10,17,10],[17,8,17,9],[18,1,19,1],[18,2,19,4],[18,5,19,5],[18,7,19,7],[18,8,18,9],[18,10,19,10],[19,8,19,9],[20,1,21,1],[20,2,21,4],[20,5,21,5],[20,7,21,7],[20,8,20,9],[15,8,15,9],[16,1,17,1],[16,2,17,4],[16,5,17,5],[16,7,17,7],[16,8,16,9],[15,2,15,4],[0,5,0,6],[2,6,3,6],[2,7,3,7],[5,2,5,4],[5,5,6,6]]}
[]
[null,{"$f":"UPPER('Organisation Details'!B2)","v":"1"}]
[null,"GSTIN",{"$f":"'Organisation Details'!B3","v":0},null,null,null,"Linked Advance Receipt",null,"Invoice No"]
[null,"State",{"$f":"'Organisation Details'!B10","v":"Please Fill GSTIN"},null,null,null,null,null,"Invoice Date"]
[null,"PAN",{"$f":"'Organisation Details'!B4","v":""},null,null,null,null,null,"Reference No"]
[null,{"$f":"IF('Organisation Details'!B14=\"\",\"\",\"CIN\")","v":""},{"$f":"IF('Organisation Details'!B14=\"\",\"\",'Organisation Details'!B14)","v":""},null,null,"BILL OF SUPPLY"]
[]
[null,"Customer Name",null,null,null,"Customer Billing Address",null,null,"Customer Shipping Address"]
[]
[]
[null,"Customer GSTIN"]
[]
[]
[null,"Country of Supply",null,null,"India",null,null,"Place of Supply"]
[]
[null,"S No.","Item Description",null,null,"HSN/ SAC Code","Quantity","Price per Unit  (₹)","Discount (₹)",null,"Total Value (₹)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals"]
[]
[]
[null,{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",\"Bank Name\")","v":""},{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",'Organisation Details'!$B$17)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",\"Bank A/c No\")","v":""},{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",'Organisation Details'!$B$18)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",\"IFSC Code\")","v":""},{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",'Organisation Details'!$B$19)","v":""},null,null,null,null,null,null,{"$f":"\"For \"&'Organisation Details'!B2","v":"For 1"}]
[]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",\"Note:\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",'Organisation Details'!$B$21)","v":""}]
[null,null,null,null,null,null,null,null,null,"(Authorised Signatory)"]
[]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",\"Terms and Conditions\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",'Organisation Details'!$B$20)","v":""}]
[]
[null,{"$f":"IF('Organisation Details'!B8=\"\",'Organisation Details'!B7&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5,'Organisation Details'!B7&\", \"&'Organisation Details'!B8&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5)","v":", , Please Fill GSTIN. Ph: 123456"}]
[]
[null,null,null,null,null,{"$f":"IF('Organisation Details'!B15=\"\",\"\",'Organisation Details'!B15)","v":""}]

{"sheet":"PDF Template Main","index":4,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":true,"merged":[[16,11,16,12],[0,5,0,7],[5,2,5,3],[5,5,6,7],[2,2,2,3],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,10,5,11],[21,12,22,12],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,5,20,5],[19,7,20,7],[19,12,20,12],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,5,22,5],[21,7,22,7],[23,3,24,3],[23,5,24,5],[23,7,24,7],[23,12,24,12],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,5,26,5],[25,7,26,7],[25,12,26,12],[23,1,24,1],[23,2,24,2],[51,1,51,12],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,5,28,5],[27,7,28,7],[27,12,28,12],[29,1,29,3],[30,1,30,12],[40,11,41,12],[43,11,43,12],[49,1,49,12]]}
[null,null,null,null,null,"ORIGINAL COPY"]
[null,{"$f":"UPPER('Organisation Details'!B2)","v":"1"}]
[null,"GSTIN",{"$f":"'Organisation Details'!B3","v":0},null,null,null,null,"CDN Date",null,null,"Invoice Date"]
[null,"State",{"$f":"'Organisation Details'!B10","v":"Please Fill GSTIN"},null,null,null,null,"CDN Number",null,null,"Invoice Number"]
[null,"PAN",{"$f":"'Organisation Details'!B4","v":""},null,null,null,null,null,null,null,"Reference No"]
[null,{"$f":"IF('Organisation Details'!B14=\"\",\"\",\"CIN\")","v":""},{"$f":"IF('Organisation Details'!B14=\"\",\"\",'Organisation Details'!B14)","v":""},null,null,"TAX INVOICE",null,null,null,null,"Linked Advance Receipt"]
[]
[null,"Customer Name",null,null,null,"Customer Billing Address",null,null,null,null,"Customer Shipping Address"]
[]
[]
[null,"Customer GSTIN"]
[]
[]
[null,"Country of Supply",null,"India",null,null,null,null,null,"Place of Supply"]
[]
[null,"Type of Export",null,null,null,null,null,null,null,"Shipping Port Code"]
[null,"Shipping Billing No",null,null,null,null,null,null,null,"Shipping Bill Date"]
[]
[null,"S No.","Item Description","HSN/ SAC Code","Quantity","Price per Unit (₹)","Discount (₹)","Taxable Value (₹)","IGST (₹)","CGST (₹)","SGST (₹)","Cess (₹)","Total Value (₹)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Taxable Amount:"]
[]
[null,{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",\"Bank Name\")","v":""},{"$f":"IF('Organisation Details'!$B$17=\"\",\"\",'Organisation Details'!$B$17)","v":""},null,null,null,null,null,null,null,null,"Total Tax:"]
[null,{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",\"Bank A/c No\")","v":""},{"$f":"IF('Organisation Details'!$B$18=\"\",\"\",'Organisation Details'!$B$18)","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",\"IFSC Code\")","v":""},{"$f":"IF('Organisation Details'!$B$19=\"\",\"\",'Organisation Details'!$B$19)","v":""},null,null,null,null,null,null,null,null,"Invoice Total:"]
[]
[]
[]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",\"Note:\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"For \"&'Organisation Details'!B2","v":"For 1"}]
[null,{"$f":"IF('Organisation Details'!$B$21=\"\",\"\",'Organisation Details'!$B$21)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"(Authorised Signatory)"]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",\"Terms and Conditions\")","v":""}]
[null,{"$f":"IF('Organisation Details'!$B$20=\"\",\"\",'Organisation Details'!$B$20)","v":""}]
[]
[]
[]
[null,{"$f":"IF('Organisation Details'!B8=\"\",'Organisation Details'!B7&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5,'Organisation Details'!B7&\", \"&'Organisation Details'!B8&\", \"&'Organisation Details'!B9&\", \"&'Organisation Details'!B10&\". Ph: \"&'Organisation Details'!B5)","v":", , Please Fill GSTIN. Ph: 123456"}]
[]
[null,{"$f":"IF('Organisation Details'!$B$15=\"\",\"\",'Organisation Details'!$B$15)","v":""}]

{"sheet":"Organisation Details","index":5,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[10,0,10,1]]}
["MANDATORY ORGANISATION DETAILS"]
["Name of Tax Payer *",1]
["GSTIN of the Tax Payer *"]
["PAN (Autofilled)",{"$f":"MID(B3,3,10)","v":""}]
["Phone Number*",123456]
["Email*"]
["Address Line 1 *"]
["Address Line 2"]
["City *"]
["State(Autofilled) *",{"$f":"IFERROR(VLOOKUP(LEFT($B$3,2),Static!$C$1:$F$37,4,0),\"Please Fill GSTIN\")","v":"Please Fill GSTIN"}]
["OPTIONAL ORGANISATION DETAILS"]
["Contact Person"]
["Contact Designation"]
["CIN Number (If Exists)"]
["Note at the bottom of Invoice"]
["Round off totals"]
["Bank Name"]
["Bank A/c No"]
["IFSC Code"]
["Terms and Conditions"]
["Custom Notes"]

{"sheet":"Static","index":6,"n_rows":85,"n_cols":53,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["Select","State_Place_of_Supply (2 Character ISO state code)","2 digit code","Select  State",null,"State","Product Type",null,"Unit of Measurement","Explanation","Round Off","CDN TYPE",null,"Tax Rate",null,"Contact Type",null,null,null,"Export Type",null,null,null,"Adv Re Date","Adv Re No","Adv Re Tot","BOS Adv Date","BOS Adv No","BOS Adv Tot",null,"Only Save","Print","Invoice Count","BOS Count","CDN Count",null,"Open Count",null,"UID","Current Location","Prev UID",null,null,"Buffer",null,"GST Offline Tool - Download GST Excel Utility Template","ate",{"$f":"RIGHT('Home Page'!J6,3)","v":"4.1"},null,null,"First Open","Last Day",false]
["Andaman and Nicobar Islands","AN","35","Andaman and Nicobar Islands-35",null,"Andaman and Nicobar Islands","G",null,"BAG","BAG","Yes","Credit",null,0,null,"C",null,null,null,"Deemed",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,6,null,"VU94029","C:\\Users\\402102",null,null,null,"C:\\Users\\402102",null,null,null,null,null,null,"2019-02-05","2019-03-07"]
["Andhra Pradesh","AP","37","Andhra Pradesh-37",null,"Andhra Pradesh","S",null,"BGS","BAGS","No","Debit",null,2.5000000000000001E-3,null,"I",null,null,null,"Export under bond / LUT"]
["Arunachal Pradesh","AR","12","Arunachal Pradesh-12",null,"Arunachal Pradesh",null,null,"BLS","BAILS",null,null,null,0.03,null,null,null,null,null,"Export with IGST"]
["Assam","AS","18","Assam-18",null,"Assam",null,null,"BOT","BOTTLES",null,null,null,0.05,null,null,null,null,null,"SEZ with IGST payment"]
["Bihar","BR","10","Bihar-10",null,"Bihar",null,null,"BOU","BOU",null,null,null,0.12,null,null,null,null,null,"SEZ without IGST payment"]
["Chandigarh","CH","04","Chandigarh-04",null,"Chandigarh",null,null,"BOX","BOXES",null,null,null,0.18]
["Chhattisgarh","CT","22","Chhattisgarh-22",null,"Chhattisgarh",null,null,"BKL","BUCKLES",null,null,null,0.28000000000000003]
["Dadra and Nagar Haveli","DN","26","Dadra and Nagar Haveli-26",null,"Dadra and Nagar Haveli",null,null,"BLK","BULK",null,null,null,"Nil Rated"]
["Daman and Diu","DD","25","Daman and Diu-25",null,"Daman and Diu",null,null,"BUN","BUNCHES",null,null,null,"Exempt"]
["Delhi","DL","07","Delhi-07",null,"Delhi",null,null,"BDL","BUNDLES",null,null,null,"Non GST"]
["Goa","GA","30","Goa-30",null,"Goa",null,null,"CAN","CANS"]
["Gujarat","GJ","24","Gujarat-24",null,"Gujarat",null,null,"CTN","CARTONS"]
["Haryana","HR","06","Haryana-06",null,"Haryana",null,null,"CAS","CASES"]
["Himachal Pradesh","HP","02","Himachal Pradesh-02",null,"Himachal Pradesh",null,null,"CMS","CENTIMETER"]
["Jammu and Kashmir","JK","01","Jammu and Kashmir-01",null,"Jammu and Kashmir",null,null,"CHI","CHEST"]
["Jharkhand","JH","20","Jharkhand-20",null,"Jharkhand",null,null,"CLS","COILS"]
["Karnataka","KA","29","Karnataka-29",null,"Karnataka",null,null,"COL","COLLIES"]
["Kerala","KL","32","Kerala-32",null,"Kerala",null,null,"CRI","CRATES"]
["Lakshadweep","LD","31","Lakshadweep-31",null,"Lakshadweep",null,null,"CCM","CUBIC CENTIMETER"]
["Madhya Pradesh","MP","23","Madhya Pradesh-23",null,"Madhya Pradesh",null,null,"CIN","CUBIC INCHES"]
["Maharashtra","MH","27","Maharashtra-27",null,"Maharashtra",null,null,"CBM","CUBIC METER"]
["Manipur","MN","14","Manipur-14",null,"Manipur",null,null,"CQM","CUBIC METERS"]
["Meghalaya","ML","17","Meghalaya-17",null,"Meghalaya",null,null,"CYL","CYLINDER"]
["Mizoram","MZ","15","Mizoram-15",null,"Mizoram",null,null,"SDM","DECAMETER SQUARE"]
["Nagaland","NL","13","Nagaland-13",null,"Nagaland",null,null,"DAY","DAYS"]
["Orissa","OR","21","Orissa-21",null,"Orissa",null,null,"DOZ","DOZEN"]
["Puducherry","PY","34","Puducherry-34",null,"Puducherry",null,null,"DRM","DRUMS"]
["Punjab","PB","03","Punjab-03",null,"Punjab",null,null,"FTS","FEET"]
["Rajasthan","RJ","08","Rajasthan-08",null,"Rajasthan",null,null,"FLK","FLASKS"]
["Sikkim","SK","11","Sikkim-11",null,"Sikkim",null,null,"GMS","GRAMS"]
["Tamil Nadu","TN","33","Tamil Nadu-33",null,"Tamil Nadu",null,null,"TON","GREAT BRITAIN TON"]
["Telangana","TG","36","Telangana-36",null,"Telangana",null,null,"GGR","GREAT GROSS"]
["Tripura","TR","16","Tripura-16",null,"Tripura",null,null,"GRS","GROSS"]
["Uttar Pradesh","UP","09","Uttar Pradesh-09",null,"Uttar Pradesh",null,null,"GYD","GROSS YARDS"]
["Uttarakhand","UT","05","Uttarakhand-05",null,"Uttarakhand",null,null,"HBK","HABBUCK"]
["West Bengal","WB","19","West Bengal-19",null,"West Bengal",null,null,"HKS","HANKS"]
["Outside India",null,null,null,null,null,null,null,"HRS","HOURS"]
[null,null,null,null,null,null,null,null,"INC","INCHES"]
[null,null,null,null,null,null,null,null,"JTA","JOTTA"]
[null,null,null,null,null,null,null,null,"KGS","KILOGRAMS"]
[null,null,null,null,null,null,null,null,"KLR","KILOLITER"]
[null,null,null,null,null,null,null,null,"KME","KILOMETERS"]
[null,null,null,null,null,null,null,null,"LTR","LITERS"]
[null,null,null,null,null,null,null,null,"LOG","LOGS"]
[null,null,null,null,null,null,null,null,"LOT","LOTS"]
[null,null,null,null,null,null,null,null,"MTR","METER"]
[null,null,null,null,null,null,null,null,"MTS","METRIC TON"]
[null,null,null,null,null,null,null,null,"MGS","MILLIGRAMS"]
[null,null,null,null,null,null,null,null,"MLT","MILLILITRE"]
[null,null,null,null,null,null,null,null,"MMT","MILLIMETER"]
[null,null,null,null,null,null,null,null,"NONE","NOT CHOSEN"]
[null,null,null,null,null,null,null,null,"NOS","NUMBERS"]
[null,null,null,null,null,null,null,null,"ODD","ODDS"]
[null,null,null,null,null,null,null,null,"PAC","PACKS"]
[null,null,null,null,null,null,null,null,"PAI","PAILS"]
[null,null,null,null,null,null,null,null,"PRS","PAIRS"]
[null,null,null,null,null,null,null,null,"PLT","PALLETS"]
[null,null,null,null,null,null,null,null,"PCS","PIECES"]
[null,null,null,null,null,null,null,null,"LBS","POUNDS"]
[null,null,null,null,null,null,null,null,"QTL","QUINTAL"]
[null,null,null,null,null,null,null,null,"REL","REELS"]
[null,null,null,null,null,null,null,null,"ROL","ROLLS"]
[null,null,null,null,null,null,null,null,"SET","SETS"]
[null,null,null,null,null,null,null,null,"SHT","SHEETS"]
[null,null,null,null,null,null,null,null,"SLB","SLABS"]
[null,null,null,null,null,null,null,null,"SQF","SQUARE FEET"]
[null,null,null,null,null,null,null,null,"SQI","SQUARE INCHES"]
[null,null,null,null,null,null,null,null,"SQC","SQUARE CENTIMETERS"]
[null,null,null,null,null,null,null,null,"SQM","SQUARE METER"]
[null,null,null,null,null,null,null,null,"SQY","SQUARE YARDS"]
[null,null,null,null,null,null,null,null,"BLO","STEEL BLOCKS"]
[null,null,null,null,null,null,null,null,"TBL","TABLES"]
[null,null,null,null,null,null,null,null,"TBS","TABLETS"]
[null,null,null,null,null,null,null,null,"TGM","TEN GROSS"]
[null,null,null,null,null,null,null,null,"THD","THOUSANDS"]
[null,null,null,null,null,null,null,null,"TIN","TINS"]
[null,null,null,null,null,null,null,null,"TOL","TOLA"]
[null,null,null,null,null,null,null,null,"TRK","TRUNK"]
[null,null,null,null,null,null,null,null,"TUB","TUBES"]
[null,null,null,null,null,null,null,null,"UNT","UNITS"]
[null,null,null,null,null,null,null,null,"UGS","US GALLONS"]
[null,null,null,null,null,null,null,null,"VLS","Vials"]
[null,null,null,null,null,null,null,null,"CSK","WOODEN CASES"]
[null,null,null,null,null,null,null,null,"YDS","YARDS"]

{"sheet":"Customer Master","index":7,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Unique_ID","Contact_Type","Business_Name_Or_Individual_Name","GSTIN","Pan_Number","Contact_Person","Billing Address","Billing City","Billing State","Billing Pincode","Email_ID","Phone_Number","Shipping Address","Shipping City","Shipping State","Shipping Pincode"]
["UID","C","Name 123",null,{"$f":"MID(D2,3,10)","v":""},null,"Ad 1","Guwahati","Orissa",null,"test@test.com",null,"Ad 1","Guwahati","Orissa"]
["UI2","C","Title 123",null,1,null,"Ad 2","Visakhapatnam","Andhra Pradesh",null,"abc@xyz.com",null,"Ad 2","Visakhapatnam","Andhra Pradesh"]
[null,null,null,null,{"$f":"MID(D4,3,10)","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(LEFT(D4,2),Static!$C$1:$F$37,4,0),\"\")","v":""}]
[]
[]
[null,null,null,null,{"$f":"MID(D7,3,10)","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(LEFT(D7,2),Static!$C$1:$F$37,4,0),\"\")","v":""}]

{"sheet":"Add Sales Invoice","index":8,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,19,16,19],[15,11,15,13],[15,14,15,16],[15,17,15,18],[0,3,0,4],[0,0,0,1],[4,3,4,4],[15,10,16,10],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9]]}
["Step 1: Enter Summary details below",null,null,"Customize Self-Invoice"]
["Invoice Number *",{"$f":"E6  & E7","v":"INV1"},null,"Prefix","RCINV"]
["Invoice Date *",null,null,"Serial No",1]
["Return Filing Period"]
[null,null,null,"Customize Invoice"]
["Customer Name",null,null,"Prefix","INV"]
["Customer GSTIN",null,null,"Serial No",1]
["Place of Supply *"]
["Reference No"]
["Reverse Charge"]
["Linked Advance Receipt"]
["Is the Customer a Composition Dealer?"]
[]
[]
[]
["#","Item Description","Item Type","HSN/ SAC","Quantity","Unit","Per Unit Item Value","Discount %","Discount Value","Taxable Value","GST Rate","Tax Rates(%)",null,null,"Tax Value (Rs.)",null,null,"CESS",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,"CGST %","SGST %","IGST %","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*O18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*P18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*Q18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*S18)","v":0},null,{"$f":"J18+O18+P18+Q18+S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,996.8,null,null,null,null,null,{"$f":"J19+O19+P19+Q19+S19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR(T20=\"Not Selected\",T20=\"Ineligible\"),0,U20*O20)","v":0},{"$f":"IF(OR(T20=\"Not Selected\",T20=\"Ineligible\"),0,U20*P20)","v":0},{"$f":"IF(OR(T20=\"Not Selected\",T20=\"Ineligible\"),0,U20*Q20)","v":0},{"$f":"IF(OR(T20=\"Not Selected\",T20=\"Ineligible\"),0,U20*S20)","v":0},null,{"$f":"J20+O20+P20+Q20+S20","v":0}]
[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,"Grand Total"]
[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,{"$f":"SUM(AA18:AA20)","v":0}]

{"sheet":"Add Sales Bill of Supply","index":9,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,1],[3,6,3,7],[0,7,0,8],[6,2,6,3],[7,2,8,3],[6,4,6,5],[7,4,8,5]]}
["Step 1: Enter Summary details below",null,null,null,null,null,null,"Customize Bill of Supply"]
["Invoice Number*",{"$f":"I2  & I3","v":"BOS1"},null,null,null,null,null,"Prefix","BOS"]
["Date *",null,null,null,null,null,null,"Serial No.",1]
["Return Filing Period"]
[]
["Customer Name *"]
["Customer GSTIN",null,"Linked Advance Receipt"]
["Place of Supply *",null,"Is the customer Composition Dealer or UIN Registered?"]
["Reference No"]
[]
["#","Item Description","Item Type","HSN/ SAC","Quantity","Unit","Per Unit Item Value","Discount %","Discount Value","Total"]
[1,null,null,null,null,null,null,null,null,null,0.12,{"$f":"IF($B$12=$B$13,K12/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,K12/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,0,K12)","v":0},{"$f":"IF($B$12=$B$13,K12/2*J12,0)","v":0},{"$f":"IF($B$12=$B$13,K12/2*J12,0)","v":0},{"$f":"IF($B$12=$B$13,0,K12*J12)","v":0},0,{"$f":"E12*G12*R12","v":0},"Not Selected",1,{"$f":"IF(OR(T12=\"Not Selected\",T12=\"Ineligible\"),0,U12*O12)","v":0},{"$f":"IF(OR(T12=\"Not Selected\",T12=\"Ineligible\"),0,U12*P12)","v":0},{"$f":"IF(OR(T12=\"Not Selected\",T12=\"Ineligible\"),0,U12*Q12)","v":0},{"$f":"IF(OR(T12=\"Not Selected\",T12=\"Ineligible\"),0,U12*S12)","v":0},null,{"$f":"J12+O12+P12+Q12+S12","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.12,{"$f":"IF($B$12=$B$13,K13/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,K13/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,0,K13)","v":0},{"$f":"IF($B$12=$B$13,K13/2*J13,0)","v":0},{"$f":"IF($B$12=$B$13,K13/2*J13,0)","v":0},{"$f":"IF($B$12=$B$13,0,K13*J13)","v":0},0,{"$f":"E13*G13*R13","v":0},"Not Selected",1,{"$f":"IF(OR(T13=\"Not Selected\",T13=\"Ineligible\"),0,U13*O13)","v":0},{"$f":"IF(OR(T13=\"Not Selected\",T13=\"Ineligible\"),0,U13*P13)","v":0},{"$f":"IF(OR(T13=\"Not Selected\",T13=\"Ineligible\"),0,U13*Q13)","v":0},{"$f":"IF(OR(T13=\"Not Selected\",T13=\"Ineligible\"),0,U13*S13)","v":0},null,{"$f":"J13+O13+P13+Q13+S13","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.28000000000000003,{"$f":"IF($B$12=$B$13,K14/2,0)","v":0.14000000000000001},{"$f":"IF($B$12=$B$13,K14/2,0)","v":0.14000000000000001},{"$f":"IF($B$12=$B$13,0,K14)","v":0},{"$f":"IF($B$12=$B$13,K14/2*J14,0)","v":0},{"$f":"IF($B$12=$B$13,K14/2*J14,0)","v":0},{"$f":"IF($B$12=$B$13,0,K14*J14)","v":0},0,{"$f":"E14*G14*R14","v":0},"Not Selected",1,{"$f":"IF(OR(T14=\"Not Selected\",T14=\"Ineligible\"),0,U14*O14)","v":0},{"$f":"IF(OR(T14=\"Not Selected\",T14=\"Ineligible\"),0,U14*P14)","v":0},{"$f":"IF(OR(T14=\"Not Selected\",T14=\"Ineligible\"),0,U14*Q14)","v":0},{"$f":"IF(OR(T14=\"Not Selected\",T14=\"Ineligible\"),0,U14*S14)","v":0},null,{"$f":"J14+O14+P14+Q14+S14","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.28000000000000003,null,null,null,null,null,null,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0.12,{"$f":"IF($B$12=$B$13,K18/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,K18/2,0)","v":0.06},{"$f":"IF($B$12=$B$13,0,K18)","v":0},{"$f":"IF($B$12=$B$13,K18/2*J18,0)","v":0},{"$f":"IF($B$12=$B$13,K18/2*J18,0)","v":0},{"$f":"IF($B$12=$B$13,0,K18*J18)","v":0},0,{"$f":"E18*G18*R18","v":0},"Not Selected",0,{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*O18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*P18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*Q18)","v":0},{"$f":"IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*S18)","v":0},null,{"$f":"J18+O18+P18+Q18+S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,null,null,null,0,null,null,0,null,null,null,null,null,"Grand Total"]
[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,{"$f":"SUM(AA18:AA18)","v":0}]

{"sheet":"Add Sales CDN","index":10,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":true,"merged":[[10,2,11,3],[9,2,9,3],[0,0,0,1],[15,9,16,9],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,8,16,8],[4,3,4,4],[0,3,0,4],[15,6,16,6],[15,7,16,7],[10,4,11,4],[15,19,16,19],[15,10,16,10],[15,11,15,13],[15,14,15,16],[15,17,15,18]]}
["CDN Details",null,null,"Customize Self-Invoice"]
["CDN Number*",{"$f":"E6  & E7","v":"CN1"},null,"Prefix","RC-CDN"]
["CDN Date *",null,null,"Serial No",1]
["CDN Type *"]
["Return Filing Period",null,null,"Customize Invoice"]
["Related to pre GST Invoice?",null,null,"Prefix","CN"]
["Invoice Number *",null,null,"Serial No",1]
["Invoice Date *"]
[]
["Customer Name",null,"Is this note for BOS?"]
["Customer GSTIN",null,"Is the customer Composition Dealer?"]
["Place of Supply *"]
["Reference No"]
["Reverse Charge"]
[]
["Item Number","Item Description","Item Type","HSN/ SAC","Quantity","Unit","Per Unit Item Value","Discount %","Discount Value","Taxable Value","GST Rate","Tax Rates(%)",null,null,"Tax Value (Rs.)",null,null,"CESS",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,"CGST %","SGST %","IGST %","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount",null,null,null,null,null,null,"Grand Total"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1080,{"$f":"IFERROR(IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*O18),0)","v":0},{"$f":"IFERROR(IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*P18),0)","v":0},{"$f":"IFERROR(IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*Q18),0)","v":0},{"$f":"IFERROR(IF(OR(T18=\"Not Selected\",T18=\"Ineligible\"),0,U18*S18),0)","v":0},{"$f":"J18+O18+P18+Q18+S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J19+O19+P19+Q19+S19","v":0},{"$f":"IFERROR(IF(OR(T19=\"Not Selected\",T19=\"Ineligible\"),0,U19*O19),0)","v":0},{"$f":"IFERROR(IF(OR(T19=\"Not Selected\",T19=\"Ineligible\"),0,U19*P19),0)","v":0},{"$f":"IFERROR(IF(OR(T19=\"Not Selected\",T19=\"Ineligible\"),0,U19*Q19),0)","v":0},{"$f":"IFERROR(IF(OR(T19=\"Not Selected\",T19=\"Ineligible\"),0,U19*S19),0)","v":0},{"$f":"J19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J20+O20+P20+Q20+S20","v":0},null,null,null,null,"Grand Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,{"$f":"SUM(Z18:Z19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U18:U20)","v":1080}]

{"sheet":"All Sales CDN","index":11,"n_rows":1,"n_cols":52,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Mark as cancelled","Delete Invoice","Edit Invoice","Print Invoice","Invoice Type","Credit/Debit Note Number","Credit/Debit Note Date","Credit(C)/Debit(D) Note Type","Invoice Number","Linked Invoice Date","Customer Name","Customer GSTIN","State Place of Supply","Reference Number","Item Number","Item Description","Is the item a GOOD (G) or SERVICE (S)","HSN or SAC code","Item Quantity","Item Unit of Measurement","Item Rate","Discount %","Total Item Discount Amount","Item Taxable Value","GST Rate","CGST Rate","SGST Rate","IGST Rate","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount","Totals","Total Transaction Value","Type of Export","Shipping Port Code - Export","Shipping Bill Number - Export","Shipping Bill Date -Export","Is this note for Bill of Supply?","Is Reverse Charge Applicable?","Is this a Nil Rated/Exempt/NonGST item?","Customer Address","Customer City","Reason for raising Credit/Debit Note","Is this note for a Pre-GST Invoice?","Which type of Invoice is this note linked to?","Is the Customer a Composition dealer?","Return Filing Period","Is this document cancelled?","Customer Billing State","Customer Pincode"]

{"sheet":"All Sales Invoices","index":12,"n_rows":1,"n_cols":49,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Mark as cancelled","Delete Invoice","Edit Invoice","Print Invoice","Invoice Type","Invoice Number","Invoice Date","Customer Billing Name","Customer Billing GSTIN","State Place of Supply","Reference Number","Item Number","Item Description","Is the item a GOOD (G) or SERVICE (S)","HSN or SAC code","Item Quantity","Item Unit of Measurement","Item Rate","Discount %","Total Item Discount Amount","Item Taxable Value","GST Rate","CGST Rate","SGST Rate","IGST Rate","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount","Totals","Total Transaction Value","Type of Export","Shipping Port Code - Export","Shipping Bill Number - Export","Shipping Bill Date -Export","Is this a Bill of Supply","Is Reverse Charge Applicable?","Is this a Nil Rated/Exempt/NonGST item?","Customer Billing Address","Customer Billing City","Return Filing Period","Is this document cancelled?","Customer Billing State","Date of Linked Advance Receipt","Voucher Number of Linked Advance Receipt","Adjustment Amount of the Linked Advance Receipt","Is the customer a Composition dealer or UIN registered?","Customer Pincode"]

{"sheet":"Add Advance Receipt","index":13,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":true,"merged":[[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[0,0,0,1],[0,3,0,4],[4,3,4,4],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,19,16,19],[15,11,15,13],[15,14,15,16],[15,17,15,18],[15,10,16,10]]}
["Step 1: Enter Summary details below",null,null,"Customize Self-Invoice"]
["Invoice Number *",{"$f":"E6  & E7","v":"ADV-PAY1"},null,"Prefix","RC-INV"]
["Invoice Date *",null,null,"Serial No",1]
["Transaction Date"]
[null,null,null,"Customize Invoice"]
["Supplier Name",null,null,"Prefix","ADV-PAY"]
["Supplier GSTIN",null,null,"Serial No",1]
["Place of Supply *"]
["Reference No"]
["Reverse Charge"]
["Is this for Bill of Supply"]
[]
[]
[]
[]
["#","Item Description","Item Type","HSN/ SAC","Quantity","Unit","Per Unit Item Value","Discount %","Discount Value","Taxable Value","GST Rate","Tax Rates(%)",null,null,"Tax Value (Rs.)",null,null,"CESS",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,"CGST %","SGST %","IGST %","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"J18+O18+P18+Q18+S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"J19+O19+P19+Q19+S19","v":0}]
[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,{"$f":"J20+O20+P20+Q20+S20","v":0}]
[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,{"$f":"J21+O21+P21+Q21+S21","v":0}]

{"sheet":"All Advance Receipts","index":14,"n_rows":1,"n_cols":46,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Mark as cancelled","Delete Invoice","Edit Invoice","Print Invoice","Invoice Type","Advance Receipt Voucher Number","Advance Receipt Voucher Date","Customer Billing Name","Customer Billing GSTIN","State Place of Supply","Reference Number","Item Number","Item Description","Is the item a GOOD (G) or SERVICE (S)","HSN or SAC code","Item Quantity","Item Unit of Measurement","Item Rate","Discount %","Total Item Discount Amount","Item Taxable Value","GST Rate","CGST Rate","SGST Rate","IGST Rate","CGST Amount","SGST Amount","IGST Amount","Cess Rate","Cess Amount","Totals","Total Transaction Value","Type of Export","Shipping Port Code - Export","Shipping Bill Number - Export","Shipping Bill Date -Export","Is this Advance for a Bill of Supply?","Is Reverse Charge Applicable?","Is this a Nil Rated/Exempt/NonGST item?","Customer Billing Address","Customer Billing City","Return Filing Period","Is this document cancelled?","Customer Billing State","Is the customer a Composition dealer or UIN registered?","Customer Pincode"]