{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["User Manual","Dashboard","Sales","Product Master","Customer Master","Supplier Master","Purchase Entry","Stock Register","Reports","Sales_Log","Invoice_Print"],"not_rendered":{"charts":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"User Manual","index":0,"n_rows":94,"n_cols":3,"rows_kept":94,"merged":[[0,0,0,2],[1,0,1,2],[3,0,3,2],[12,0,12,2],[25,0,25,2],[32,0,32,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[47,0,47,2],[52,0,52,2],[53,0,53,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[61,0,61,2],[62,0,62,2],[64,0,64,2],[65,0,65,2],[67,0,67,2],[68,0,68,2],[70,0,70,2],[80,0,80,2],[81,0,81,2],[82,0,82,2],[83,0,83,2],[84,0,84,2],[86,0,86,2],[93,0,93,2]]}
["📘 POS & INVENTORY SYSTEM — USER MANUAL"]
["A complete beginner-friendly guide to operating this workbook"]
[]
["1.  ONE-TIME SETUP"]
["Step","Action"]
[1.1,"Save the file as Excel Macro-Enabled Workbook (.xlsm). File → Save As → choose type '.xlsm'."]
[1.2,"Enable macros: when Excel shows a yellow security bar, click 'Enable Content'."]
[1.3,"Press Alt+F11 to open the VBA editor → Insert → Module → paste the VBA code provided → close the editor."]
[1.4,"Show the Developer tab: File → Options → Customize Ribbon → tick 'Developer'."]
[1.5,"On the Sales sheet, draw 4 buttons over the colored boxes in row 21 (Developer → Insert → Button) and assign macros: SaveSale, PrintInvoice, ClearForm, GoDashboard."]
[1.6,"Edit the shop name, address and GSTIN at the top of Invoice_Print (rows 3–5)."]
[]
["2.  SHEET MAP — what each tab does"]
["Sheet","Purpose","Where you type"]
["Dashboard","KPIs (Sales, Purchase, Profit, Low-Stock count) + charts","Read-only — auto updates"]
["Sales (POS)","Main billing screen — make every sale here","Yellow cells only"]
["Product Master","Catalog of all items you sell","Columns A–H (col I is auto)"]
["Customer Master","Customer list used by the dropdown on Sales","All columns"]
["Supplier Master","Supplier list for purchases","All columns"]
["Purchase Entry","Record stock you buy in — auto-increases inventory","Date, Product ID, Supplier ID, Qty, Bill No."]
["Stock Register","Live ledger: Opening + Purchased − Sold = Current","Read-only"]
["Reports","Date-filtered Sales / Purchase / Profit summary","Date range in C3 and E3"]
["Sales_Log","Hidden transaction database — VBA writes here","Don't edit manually"]
["Invoice_Print","Print-ready invoice — mirrors current Sales screen","Read-only"]
[]
["3.  COLOR LEGEND"]
["Yellow cell","= INPUT — you type here"]
["Light blue","= LABEL — read-only"]
["Red fill","= ERROR / OUT OF STOCK — fix before saving"]
["Yellow fill","= LOW STOCK — reorder soon"]
["Green fill","= OK — stock healthy"]
[]
["4.  DAILY WORKFLOW — making a sale"]
["Step","Where","Do this"]
[1,"Sales!B4","Pick Customer ID from the dropdown (use C001 for walk-in)"]
[2,"Sales!H3","Pick Payment Mode: Cash / UPI / Card / Credit"]
[3,"Sales!B7","Pick first Product ID from dropdown — name, price, GST and stock auto-fill"]
[4,"Sales!E7","Type quantity. If qty > available stock the cell turns RED — fix it"]
[5,"Sales!B8:B16","Add more lines (up to 10 items per bill). Empty rows are skipped"]
[6,"Sales!I19","Verify Grand Total (yellow box)"]
[7,"Button: SAVE SALE","Click → sale logged, stock deducted, invoice number bumped, form cleared"]
[8,"Button: PRINT INVOICE","Opens Invoice_Print preview — print or save as PDF"]
[]
["5.  ADDING A NEW PRODUCT"]
["Option A — Manual: go to Product Master, type into the next empty row: Product ID (e.g. P004), Name, Category, Purchase Price, Selling Price, GST % (as 18%), Opening Stock, Reorder Level. Then COPY column I from the row above and paste into the new row so Current Stock formula extends."]
["Option B — Macro: run AddProduct (Alt+F8 → AddProduct → Run). It walks you through prompts and writes the formula automatically."]
[]
["6.  RECORDING A PURCHASE"]
[1,"Open Purchase Entry, go to next empty row"]
[2,"Fill: Date, Product ID, Supplier ID, Quantity, Bill No.  (Name, Price, GST, totals auto-fill)"]
[3,"Stock auto-increases — check it on Stock Register or Product Master col I"]
[]
["7.  ADDING CUSTOMERS / SUPPLIERS"]
["Customer Master / Supplier Master: just append a new row with a unique ID (e.g. C003, S002). They appear in the Sales / Purchase dropdowns immediately."]
[]
["8.  STOCK ALERTS"]
["• Stock Register colors each row Green (OK), Yellow (Low), Red (Out of Stock)."]
["• After every Save Sale a popup lists products at or below their Reorder Level."]
["• Dashboard shows total Low/Out count in the top-right KPI tile."]
["• Sales screen blocks you from saving if any line's Qty > available stock."]
[]
["9.  REPORTS"]
["Open Reports sheet. Change the From date in C3 and To date in E3. All KPIs (Total Sales, GST, Profit, Purchases) recalc instantly. Use this for daily/monthly/GST filing reviews."]
[]
["10.  PRINTING & PDF"]
["Click PRINT INVOICE on Sales — Invoice_Print previews. To save as PDF: File → Save As → pick PDF format. Invoice fits A4 and shows shop header, customer, items, GST, totals."]
[]
["11.  BARCODE SCANNER (optional)"]
["USB barcode scanners act like a keyboard. Click into Sales!B7 (or any cart row), then scan — the Product ID is typed automatically and the line auto-fills. Tip: use the barcode value as your Product ID in Product Master."]
[]
["12.  TROUBLESHOOTING"]
["Issue","Fix"]
["Buttons do nothing","Macros disabled — click 'Enable Content' on the yellow bar, or re-save as .xlsm"]
["#N/A in product name","Product ID typo — use the dropdown, don't type freely"]
["Qty cell is red","Quantity exceeds available stock — reduce qty or record a Purchase Entry first"]
["Stock not updating","Press F9 to recalculate. If column I in Product Master is blank, copy the formula down from row 2"]
["Invoice number not changing","It increments only after Save Sale runs successfully — check Sales_Log got a new row"]
["Dropdowns empty","Add at least one row to Product / Customer / Supplier Master"]
["Dashboard KPIs zero","No sales saved yet — make a test sale and check"]
[]
["13.  BACKUP & SAFETY"]
["• Save the file at end of each day (Ctrl+S). Keep a weekly copy on a different drive or cloud."]
["• Don't edit Sales_Log manually — it breaks profit & stock math."]
["• Don't delete columns from any sheet — formulas reference them by position."]
["• To clear test data: delete all rows in Sales_Log below row 1, and all rows in Purchase Entry below row 1."]
[]
["14.  QUICK KEYBOARD SHORTCUTS"]
["Alt+F11","Open VBA editor"]
["Alt+F8","Run a macro by name"]
["Ctrl+S","Save"]
["F9","Force recalculate all formulas"]
["Ctrl+Page Up / Down","Switch between sheets"]
[]
["— End of Manual —"]

{"sheet":"Dashboard","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"merged":[[0,0,0,7],[5,0,5,2],[5,4,5,6]]}
["📈 INVENTORY & POS DASHBOARD"]
[]
["TOTAL SALES",null,"TOTAL PURCHASE",null,"TOTAL PROFIT",null,"LOW / OUT STOCK",null,null,"Sales",{"$f":"A4","v":0}]
[{"$f":"SUM(Sales_Log!J:J)","v":{"v":0,"d":"₹0"}},null,{"$f":"SUM('Purchase Entry'!K:K)","v":{"v":1770,"d":"₹1,770"}},null,{"$f":"SUM(Sales_Log!O:O)","v":{"v":0,"d":"₹0"}},null,{"$f":"COUNTIF('Stock Register'!H:H,\"LOW STOCK\")+COUNTIF('Stock Register'!H:H,\"OUT OF STOCK\")","v":44},null,null,"Purchase",{"$f":"C4","v":1770}]
[{"$nulls":9},"Profit",{"$f":"E4","v":0}]
["TOP SELLING PRODUCTS (by Qty)",{"$nulls":3},"LOW STOCK ALERT"]
["Product","Qty Sold","Revenue",null,"Product","Stock","Status"]
[{"$f":"IFERROR('Product Master'!B2,\"\")","v":"Sample Soap"},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A2),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A2),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B4,\"\")","v":"Sample Soap"},{"$f":"IFERROR('Stock Register'!F4,\"\")","v":150},{"$f":"IFERROR('Stock Register'!H4,\"\")","v":"OK"}]
[{"$f":"IFERROR('Product Master'!B3,\"\")","v":"Sample Shampoo"},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A3),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A3),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B5,\"\")","v":"Sample Shampoo"},{"$f":"IFERROR('Stock Register'!F5,\"\")","v":50},{"$f":"IFERROR('Stock Register'!H5,\"\")","v":"OK"}]
[{"$f":"IFERROR('Product Master'!B4,\"\")","v":"Notebook A4"},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A4),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A4),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B6,\"\")","v":"Notebook A4"},{"$f":"IFERROR('Stock Register'!F6,\"\")","v":200},{"$f":"IFERROR('Stock Register'!H6,\"\")","v":"OK"}]
[{"$f":"IFERROR('Product Master'!B5,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A5),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A5),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B7,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F7,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H7,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B6,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A6),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A6),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B8,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F8,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H8,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B7,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A7),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A7),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B9,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F9,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H9,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B8,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A8),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A8),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B10,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F10,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H10,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B9,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A9),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A9),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B11,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F11,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H11,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B10,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A10),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A10),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B12,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F12,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H12,\"\")","v":"OUT OF STOCK"}]
[{"$f":"IFERROR('Product Master'!B11,\"\")","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,'Product Master'!A11),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!J:J,Sales_Log!C:C,'Product Master'!A11),0)","v":{"v":0,"d":"₹0.00"}},null,{"$f":"IFERROR('Stock Register'!B13,\"\")","v":0},{"$f":"IFERROR('Stock Register'!F13,\"\")","v":0},{"$f":"IFERROR('Stock Register'!H13,\"\")","v":"OUT OF STOCK"}]

{"sheet":"Sales","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[0,0,0,9],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[22,0,22,9]]}
["🧾 POS BILLING SCREEN"]
[]
["Invoice No:",{"$f":"\"INV-\"&TEXT(COUNTA(Sales_Log!A:A),\"0000\")","v":"INV-0001"},null,"Date:",{"$f":"TODAY()","v":"2026-05-01"},null,"Payment Mode:","Cash"]
["Customer ID:","C001",null,"Customer Name:",{"$f":"IFERROR(VLOOKUP(B4,'Customer Master'!A:B,2,FALSE),\"\")","v":"Walk-in Customer"},null,"Phone:",{"$f":"IFERROR(VLOOKUP(B4,'Customer Master'!A:C,3,FALSE),\"\")","v":"-"}]
[]
["#","Product ID","Product Name","Stock Avail.","Qty","Price","Taxable","GST %","GST Amt","Total"]
[1,"P001",{"$f":"IFERROR(VLOOKUP(B7,'Product Master'!A:B,2,FALSE),\"\")","v":"Sample Soap"},{"$f":"IFERROR(VLOOKUP(B7,'Product Master'!A:I,9,FALSE),0)","v":150},null,{"$f":"IFERROR(VLOOKUP(B7,'Product Master'!A:E,5,FALSE),0)","v":{"v":50,"d":"₹50.00"}},{"$f":"IFERROR(E7*F7,0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IFERROR(VLOOKUP(B7,'Product Master'!A:F,6,FALSE),0)","v":{"v":0.18,"d":"18%"}},{"$f":"G7*H7","v":{"v":0,"d":"₹0.00"}},{"$f":"G7+I7","v":{"v":0,"d":"₹0.00"}}]
[1,"P002",{"$f":"IFERROR(VLOOKUP(B8,'Product Master'!A:B,2,FALSE),\"\")","v":"Sample Shampoo"},{"$f":"IFERROR(VLOOKUP(B8,'Product Master'!A:I,9,FALSE),0)","v":50},null,{"$f":"IFERROR(VLOOKUP(B8,'Product Master'!A:E,5,FALSE),0)","v":{"v":180,"d":"₹180.00"}},{"$f":"IFERROR(E8*F8,0)","v":{"v":0,"d":"₹0.00"}},{"$f":"IFERROR(VLOOKUP(B8,'Product Master'!A:F,6,FALSE),0)","v":{"v":0.18,"d":"18%"}},{"$f":"G8*H8","v":{"v":0,"d":"₹0.00"}},{"$f":"G8+I8","v":{"v":0,"d":"₹0.00"}}]
[1,null,{"$f":"IFERROR(VLOOKUP(B9,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B9,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B9,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B10,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B10,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B10,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B11,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B11,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B11,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B12,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B12,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B12,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B13,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B13,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B13,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B14,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B14,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B14,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B15,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B15,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B15,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[1,null,{"$f":"IFERROR(VLOOKUP(B16,'Product Master'!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'Product Master'!A:I,9,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(B16,'Product Master'!A:E,5,FALSE),0)","v":{"v":0,"d":"₹0.00"}},{"v":0,"d":"₹0.00"},{"$f":"IFERROR(VLOOKUP(B16,'Product Master'!A:F,6,FALSE),0)","v":{"v":0,"d":"0%"}},{"v":0,"d":"₹0.00"},{"v":0,"d":"₹0.00"}]
[{"$nulls":6},"Sub-Total:",null,{"$f":"SUM(G7:G16)","v":{"v":0,"d":"₹0.00"}}]
[{"$nulls":6},"Total GST:",null,{"$f":"SUM(I7:I16)","v":{"v":0,"d":"₹0.00"}}]
[{"$nulls":6},"GRAND TOTAL:",null,{"$f":"SUM(J7:J16)","v":{"v":0,"d":"₹0.00"}}]
[]
["[ SAVE SALE ]",null,"[ PRINT INVOICE ]",null,"[ CLEAR FORM ]",null,"[ DASHBOARD ]"]
[]
["⚠️ Tip: Use buttons (Developer → Insert → Button) and assign the macros listed in the VBA module. Yellow cells are inputs."]

{"sheet":"Product Master","index":3,"n_rows":4,"n_cols":9,"rows_kept":4}
["Product ID","Product Name","Category","Purchase Price","Selling Price","GST %","Opening Stock","Reorder Level","Current Stock"]
["P001","Sample Soap","FMCG",{"v":30,"d":"₹30.00"},{"v":50,"d":"₹50.00"},{"v":0.18,"d":"18%"},100,20,{"$f":"G2+IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A2),0)-IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A2),0)","v":150}]
["P002","Sample Shampoo","FMCG",{"v":120,"d":"₹120.00"},{"v":180,"d":"₹180.00"},{"v":0.18,"d":"18%"},50,10,{"$f":"G3+IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A3),0)-IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A3),0)","v":50}]
["P003","Notebook A4","Stationery",{"v":40,"d":"₹40.00"},{"v":60,"d":"₹60.00"},{"v":0.12,"d":"12%"},200,30,{"$f":"G4+IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A4),0)-IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A4),0)","v":200}]

{"sheet":"Customer Master","index":4,"n_rows":3,"n_cols":6,"rows_kept":3}
["Customer ID","Customer Name","Phone","Email","Address","GSTIN"]
["C001","Walk-in Customer","-","-","-","-"]
["C002","Rahul Sharma",9876543210,"rahul@email.com","Delhi","07AAACR1234A1Z5"]

{"sheet":"Supplier Master","index":5,"n_rows":2,"n_cols":7,"rows_kept":2}
["Supplier ID","Supplier Name","Contact Person","Phone","Email","Address","GSTIN"]
["S001","ABC Distributors","Mr. Kumar",9000011111,"abc@dist.com","Mumbai","27AABCA1234B1Z5"]

{"sheet":"Purchase Entry","index":6,"n_rows":2,"n_cols":12,"rows_kept":2}
["Purchase Date","Product ID","Product Name","Supplier ID","Supplier Name","Quantity","Purchase Price","Taxable Value","GST %","GST Amount","Total Amount","Bill No."]
["2025-01-01","P001",{"$f":"IFERROR(VLOOKUP(B2,'Product Master'!A:B,2,FALSE),\"\")","v":"Sample Soap"},"S001",{"$f":"IFERROR(VLOOKUP(D2,'Supplier Master'!A:B,2,FALSE),\"\")","v":"ABC Distributors"},50,{"$f":"IFERROR(VLOOKUP(B2,'Product Master'!A:D,4,FALSE),0)","v":{"v":30,"d":"₹30.00"}},{"$f":"F2*G2","v":{"v":1500,"d":"₹1,500.00"}},{"$f":"IFERROR(VLOOKUP(B2,'Product Master'!A:F,6,FALSE),0)","v":{"v":0.18,"d":"18%"}},{"$f":"H2*I2","v":{"v":270,"d":"₹270.00"}},{"$f":"H2+J2","v":{"v":1770,"d":"₹1,770.00"}},"PB-001"]

{"sheet":"Stock Register","index":7,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[0,0,0,7]]}
["STOCK REGISTER (Live)"]
[]
["Product ID","Product Name","Opening Stock","Total Purchased","Total Sold","Current Stock","Reorder Level","Status"]
[{"$f":"IFERROR('Product Master'!A2,\"\")","v":"P001"},{"$f":"IFERROR('Product Master'!B2,\"\")","v":"Sample Soap"},{"$f":"IFERROR('Product Master'!G2,0)","v":100},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A4),0)","v":50},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A4),0)","v":0},{"$f":"C4+D4-E4","v":150},{"$f":"IFERROR('Product Master'!H2,0)","v":20},{"$f":"IF(A4=\"\",\"\",IF(F4<=0,\"OUT OF STOCK\",IF(F4<=G4,\"LOW STOCK\",\"OK\")))","v":"OK"}]
[{"$f":"IFERROR('Product Master'!A3,\"\")","v":"P002"},{"$f":"IFERROR('Product Master'!B3,\"\")","v":"Sample Shampoo"},{"$f":"IFERROR('Product Master'!G3,0)","v":50},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A5),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A5),0)","v":0},{"$f":"C5+D5-E5","v":50},{"$f":"IFERROR('Product Master'!H3,0)","v":10},{"$f":"IF(A5=\"\",\"\",IF(F5<=0,\"OUT OF STOCK\",IF(F5<=G5,\"LOW STOCK\",\"OK\")))","v":"OK"}]
[{"$f":"IFERROR('Product Master'!A4,\"\")","v":"P003"},{"$f":"IFERROR('Product Master'!B4,\"\")","v":"Notebook A4"},{"$f":"IFERROR('Product Master'!G4,0)","v":200},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A6),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A6),0)","v":0},200,{"$f":"IFERROR('Product Master'!H4,0)","v":30},"OK"]
[{"$f":"IFERROR('Product Master'!A5,\"\")","v":0},{"$f":"IFERROR('Product Master'!B5,\"\")","v":0},{"$f":"IFERROR('Product Master'!G5,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A7),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A7),0)","v":0},0,{"$f":"IFERROR('Product Master'!H5,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A6,\"\")","v":0},{"$f":"IFERROR('Product Master'!B6,\"\")","v":0},{"$f":"IFERROR('Product Master'!G6,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A8),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A8),0)","v":0},0,{"$f":"IFERROR('Product Master'!H6,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A7,\"\")","v":0},{"$f":"IFERROR('Product Master'!B7,\"\")","v":0},{"$f":"IFERROR('Product Master'!G7,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A9),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A9),0)","v":0},0,{"$f":"IFERROR('Product Master'!H7,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A8,\"\")","v":0},{"$f":"IFERROR('Product Master'!B8,\"\")","v":0},{"$f":"IFERROR('Product Master'!G8,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A10),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A10),0)","v":0},0,{"$f":"IFERROR('Product Master'!H8,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A9,\"\")","v":0},{"$f":"IFERROR('Product Master'!B9,\"\")","v":0},{"$f":"IFERROR('Product Master'!G9,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A11),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A11),0)","v":0},0,{"$f":"IFERROR('Product Master'!H9,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A10,\"\")","v":0},{"$f":"IFERROR('Product Master'!B10,\"\")","v":0},{"$f":"IFERROR('Product Master'!G10,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A12),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A12),0)","v":0},0,{"$f":"IFERROR('Product Master'!H10,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A11,\"\")","v":0},{"$f":"IFERROR('Product Master'!B11,\"\")","v":0},{"$f":"IFERROR('Product Master'!G11,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A13),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A13),0)","v":0},0,{"$f":"IFERROR('Product Master'!H11,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A12,\"\")","v":0},{"$f":"IFERROR('Product Master'!B12,\"\")","v":0},{"$f":"IFERROR('Product Master'!G12,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A14),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A14),0)","v":0},0,{"$f":"IFERROR('Product Master'!H12,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A13,\"\")","v":0},{"$f":"IFERROR('Product Master'!B13,\"\")","v":0},{"$f":"IFERROR('Product Master'!G13,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A15),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A15),0)","v":0},0,{"$f":"IFERROR('Product Master'!H13,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A14,\"\")","v":0},{"$f":"IFERROR('Product Master'!B14,\"\")","v":0},{"$f":"IFERROR('Product Master'!G14,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A16),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A16),0)","v":0},0,{"$f":"IFERROR('Product Master'!H14,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A15,\"\")","v":0},{"$f":"IFERROR('Product Master'!B15,\"\")","v":0},{"$f":"IFERROR('Product Master'!G15,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A17),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A17),0)","v":0},0,{"$f":"IFERROR('Product Master'!H15,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A16,\"\")","v":0},{"$f":"IFERROR('Product Master'!B16,\"\")","v":0},{"$f":"IFERROR('Product Master'!G16,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A18),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A18),0)","v":0},0,{"$f":"IFERROR('Product Master'!H16,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A17,\"\")","v":0},{"$f":"IFERROR('Product Master'!B17,\"\")","v":0},{"$f":"IFERROR('Product Master'!G17,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A19),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A19),0)","v":0},0,{"$f":"IFERROR('Product Master'!H17,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A18,\"\")","v":0},{"$f":"IFERROR('Product Master'!B18,\"\")","v":0},{"$f":"IFERROR('Product Master'!G18,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A20),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A20),0)","v":0},0,{"$f":"IFERROR('Product Master'!H18,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A19,\"\")","v":0},{"$f":"IFERROR('Product Master'!B19,\"\")","v":0},{"$f":"IFERROR('Product Master'!G19,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A21),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A21),0)","v":0},0,{"$f":"IFERROR('Product Master'!H19,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A20,\"\")","v":0},{"$f":"IFERROR('Product Master'!B20,\"\")","v":0},{"$f":"IFERROR('Product Master'!G20,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A22),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A22),0)","v":0},0,{"$f":"IFERROR('Product Master'!H20,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A21,\"\")","v":0},{"$f":"IFERROR('Product Master'!B21,\"\")","v":0},{"$f":"IFERROR('Product Master'!G21,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A23),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A23),0)","v":0},0,{"$f":"IFERROR('Product Master'!H21,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A22,\"\")","v":0},{"$f":"IFERROR('Product Master'!B22,\"\")","v":0},{"$f":"IFERROR('Product Master'!G22,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A24),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A24),0)","v":0},0,{"$f":"IFERROR('Product Master'!H22,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A23,\"\")","v":0},{"$f":"IFERROR('Product Master'!B23,\"\")","v":0},{"$f":"IFERROR('Product Master'!G23,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A25),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A25),0)","v":0},0,{"$f":"IFERROR('Product Master'!H23,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A24,\"\")","v":0},{"$f":"IFERROR('Product Master'!B24,\"\")","v":0},{"$f":"IFERROR('Product Master'!G24,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A26),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A26),0)","v":0},0,{"$f":"IFERROR('Product Master'!H24,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A25,\"\")","v":0},{"$f":"IFERROR('Product Master'!B25,\"\")","v":0},{"$f":"IFERROR('Product Master'!G25,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A27),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A27),0)","v":0},0,{"$f":"IFERROR('Product Master'!H25,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A26,\"\")","v":0},{"$f":"IFERROR('Product Master'!B26,\"\")","v":0},{"$f":"IFERROR('Product Master'!G26,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A28),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A28),0)","v":0},0,{"$f":"IFERROR('Product Master'!H26,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A27,\"\")","v":0},{"$f":"IFERROR('Product Master'!B27,\"\")","v":0},{"$f":"IFERROR('Product Master'!G27,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A29),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A29),0)","v":0},0,{"$f":"IFERROR('Product Master'!H27,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A28,\"\")","v":0},{"$f":"IFERROR('Product Master'!B28,\"\")","v":0},{"$f":"IFERROR('Product Master'!G28,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A30),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A30),0)","v":0},0,{"$f":"IFERROR('Product Master'!H28,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A29,\"\")","v":0},{"$f":"IFERROR('Product Master'!B29,\"\")","v":0},{"$f":"IFERROR('Product Master'!G29,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A31),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A31),0)","v":0},0,{"$f":"IFERROR('Product Master'!H29,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A30,\"\")","v":0},{"$f":"IFERROR('Product Master'!B30,\"\")","v":0},{"$f":"IFERROR('Product Master'!G30,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A32),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A32),0)","v":0},0,{"$f":"IFERROR('Product Master'!H30,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A31,\"\")","v":0},{"$f":"IFERROR('Product Master'!B31,\"\")","v":0},{"$f":"IFERROR('Product Master'!G31,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A33),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A33),0)","v":0},0,{"$f":"IFERROR('Product Master'!H31,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A32,\"\")","v":0},{"$f":"IFERROR('Product Master'!B32,\"\")","v":0},{"$f":"IFERROR('Product Master'!G32,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A34),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A34),0)","v":0},0,{"$f":"IFERROR('Product Master'!H32,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A33,\"\")","v":0},{"$f":"IFERROR('Product Master'!B33,\"\")","v":0},{"$f":"IFERROR('Product Master'!G33,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A35),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A35),0)","v":0},0,{"$f":"IFERROR('Product Master'!H33,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A34,\"\")","v":0},{"$f":"IFERROR('Product Master'!B34,\"\")","v":0},{"$f":"IFERROR('Product Master'!G34,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A36),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A36),0)","v":0},0,{"$f":"IFERROR('Product Master'!H34,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A35,\"\")","v":0},{"$f":"IFERROR('Product Master'!B35,\"\")","v":0},{"$f":"IFERROR('Product Master'!G35,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A37),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A37),0)","v":0},0,{"$f":"IFERROR('Product Master'!H35,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A36,\"\")","v":0},{"$f":"IFERROR('Product Master'!B36,\"\")","v":0},{"$f":"IFERROR('Product Master'!G36,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A38),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A38),0)","v":0},0,{"$f":"IFERROR('Product Master'!H36,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A37,\"\")","v":0},{"$f":"IFERROR('Product Master'!B37,\"\")","v":0},{"$f":"IFERROR('Product Master'!G37,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A39),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A39),0)","v":0},0,{"$f":"IFERROR('Product Master'!H37,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A38,\"\")","v":0},{"$f":"IFERROR('Product Master'!B38,\"\")","v":0},{"$f":"IFERROR('Product Master'!G38,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A40),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A40),0)","v":0},0,{"$f":"IFERROR('Product Master'!H38,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A39,\"\")","v":0},{"$f":"IFERROR('Product Master'!B39,\"\")","v":0},{"$f":"IFERROR('Product Master'!G39,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A41),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A41),0)","v":0},0,{"$f":"IFERROR('Product Master'!H39,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A40,\"\")","v":0},{"$f":"IFERROR('Product Master'!B40,\"\")","v":0},{"$f":"IFERROR('Product Master'!G40,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A42),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A42),0)","v":0},0,{"$f":"IFERROR('Product Master'!H40,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A41,\"\")","v":0},{"$f":"IFERROR('Product Master'!B41,\"\")","v":0},{"$f":"IFERROR('Product Master'!G41,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A43),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A43),0)","v":0},0,{"$f":"IFERROR('Product Master'!H41,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A42,\"\")","v":0},{"$f":"IFERROR('Product Master'!B42,\"\")","v":0},{"$f":"IFERROR('Product Master'!G42,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A44),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A44),0)","v":0},0,{"$f":"IFERROR('Product Master'!H42,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A43,\"\")","v":0},{"$f":"IFERROR('Product Master'!B43,\"\")","v":0},{"$f":"IFERROR('Product Master'!G43,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A45),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A45),0)","v":0},0,{"$f":"IFERROR('Product Master'!H43,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A44,\"\")","v":0},{"$f":"IFERROR('Product Master'!B44,\"\")","v":0},{"$f":"IFERROR('Product Master'!G44,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A46),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A46),0)","v":0},0,{"$f":"IFERROR('Product Master'!H44,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A45,\"\")","v":0},{"$f":"IFERROR('Product Master'!B45,\"\")","v":0},{"$f":"IFERROR('Product Master'!G45,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A47),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A47),0)","v":0},0,{"$f":"IFERROR('Product Master'!H45,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A46,\"\")","v":0},{"$f":"IFERROR('Product Master'!B46,\"\")","v":0},{"$f":"IFERROR('Product Master'!G46,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A48),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A48),0)","v":0},0,{"$f":"IFERROR('Product Master'!H46,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A47,\"\")","v":0},{"$f":"IFERROR('Product Master'!B47,\"\")","v":0},{"$f":"IFERROR('Product Master'!G47,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A49),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A49),0)","v":0},0,{"$f":"IFERROR('Product Master'!H47,0)","v":0},"OUT OF STOCK"]
[{"$f":"IFERROR('Product Master'!A48,\"\")","v":0},{"$f":"IFERROR('Product Master'!B48,\"\")","v":0},{"$f":"IFERROR('Product Master'!G48,0)","v":0},{"$f":"IFERROR(SUMIFS('Purchase Entry'!F:F,'Purchase Entry'!B:B,A50),0)","v":0},{"$f":"IFERROR(SUMIFS(Sales_Log!E:E,Sales_Log!C:C,A50),0)","v":0},0,{"$f":"IFERROR('Product Master'!H48,0)","v":0},"OUT OF STOCK"]

{"sheet":"Reports","index":8,"n_rows":14,"n_cols":5,"rows_kept":14}
["📊 REPORTS"]
[]
["Date Filter:","From",{"$f":"TODAY()-30","v":"2026-04-01"},"To",{"$f":"TODAY()","v":"2026-05-01"}]
[]
["SALES REPORT",null,null,"PURCHASE REPORT"]
["Total Invoices",{"$f":"SUMPRODUCT((Sales_Log!B2:B10000>=C3)*(Sales_Log!B2:B10000<=E3)*(Sales_Log!A2:A10000<>\"\")/COUNTIF(Sales_Log!A2:A10000,Sales_Log!A2:A10000&\"\"))","v":0},null,"Total Purchases (Taxable)",{"$f":"SUMIFS('Purchase Entry'!H:H,'Purchase Entry'!A:A,\">=\"&C3,'Purchase Entry'!A:A,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}}]
["Total Sales (Taxable)",{"$f":"SUMIFS(Sales_Log!G:G,Sales_Log!B:B,\">=\"&C3,Sales_Log!B:B,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}},null,"Total Purchase GST",{"$f":"SUMIFS('Purchase Entry'!J:J,'Purchase Entry'!A:A,\">=\"&C3,'Purchase Entry'!A:A,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}}]
["Total GST Collected",{"$f":"SUMIFS(Sales_Log!I:I,Sales_Log!B:B,\">=\"&C3,Sales_Log!B:B,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}},null,"Total Purchases (with GST)",{"$f":"SUMIFS('Purchase Entry'!K:K,'Purchase Entry'!A:A,\">=\"&C3,'Purchase Entry'!A:A,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}}]
["Total Sales (with GST)",{"$f":"SUMIFS(Sales_Log!J:J,Sales_Log!B:B,\">=\"&C3,Sales_Log!B:B,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}}]
["Total Profit",{"$f":"SUMIFS(Sales_Log!O:O,Sales_Log!B:B,\">=\"&C3,Sales_Log!B:B,\"<=\"&E3)","v":{"v":0,"d":"₹0.00"}}]
[]
["STOCK SUMMARY (see Stock Register tab for live ledger)"]
["Items Out of Stock",{"$f":"COUNTIF('Stock Register'!H:H,\"OUT OF STOCK\")","v":44}]
["Items at Low Stock",{"$f":"COUNTIF('Stock Register'!H:H,\"LOW STOCK\")","v":0}]

{"sheet":"Sales_Log","index":9,"n_rows":1,"n_cols":15,"rows_kept":1}
["Invoice No","Date","Product ID","Product Name","Quantity","Selling Price","Taxable Value","GST %","GST Amount","Total Amount","Customer ID","Customer Name","Payment Mode","Purchase Price","Profit"]

{"sheet":"Invoice_Print","index":10,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,0,0,7]]}
["TAX INVOICE"]
[]
["Your Shop Name",{"$nulls":4},"Invoice No:",{"$f":"Sales!B3","v":"INV-0001"}]
["Address Line 1, City - PIN",{"$nulls":4},"Date:",{"$f":"Sales!E3","v":"2026-05-01"}]
["GSTIN: 00XXXXXXXXXXXXX  |  Phone: 9999999999",{"$nulls":4},"Payment:",{"$f":"Sales!H3","v":"Cash"}]
[]
["Bill To:",{"$f":"Sales!E4","v":"Walk-in Customer"}]
["Phone:",{"$f":"Sales!H4","v":"-"}]
[]
["#","Product","Qty","Price","Taxable","GST%","GST","Total"]
[{"$f":"IF(Sales!B7=\"\",\"\",Sales!A7)","v":1},{"$f":"IF(Sales!B7=\"\",\"\",Sales!C7)","v":"Sample Soap"},{"$f":"IF(Sales!B7=\"\",\"\",Sales!E7)","v":0},{"$f":"IF(Sales!B7=\"\",\"\",Sales!F7)","v":{"v":50,"d":"₹50.00"}},{"$f":"IF(Sales!B7=\"\",\"\",Sales!G7)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(Sales!B7=\"\",\"\",Sales!H7)","v":{"v":0.18,"d":"18%"}},{"$f":"IF(Sales!B7=\"\",\"\",Sales!I7)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(Sales!B7=\"\",\"\",Sales!J7)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(Sales!B8=\"\",\"\",Sales!A8)","v":1},{"$f":"IF(Sales!B8=\"\",\"\",Sales!C8)","v":"Sample Shampoo"},{"$f":"IF(Sales!B8=\"\",\"\",Sales!E8)","v":0},{"$f":"IF(Sales!B8=\"\",\"\",Sales!F8)","v":{"v":180,"d":"₹180.00"}},{"$f":"IF(Sales!B8=\"\",\"\",Sales!G8)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(Sales!B8=\"\",\"\",Sales!H8)","v":{"v":0.18,"d":"18%"}},{"$f":"IF(Sales!B8=\"\",\"\",Sales!I8)","v":{"v":0,"d":"₹0.00"}},{"$f":"IF(Sales!B8=\"\",\"\",Sales!J8)","v":{"v":0,"d":"₹0.00"}}]
[{"$f":"IF(Sales!B9=\"\",\"\",Sales!A9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!C9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!E9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!F9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!G9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!H9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!I9)","v":""},{"$f":"IF(Sales!B9=\"\",\"\",Sales!J9)","v":""}]
[{"$f":"IF(Sales!B10=\"\",\"\",Sales!A10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!C10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!E10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!F10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!G10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!H10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!I10)","v":""},{"$f":"IF(Sales!B10=\"\",\"\",Sales!J10)","v":""}]
[{"$f":"IF(Sales!B11=\"\",\"\",Sales!A11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!C11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!E11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!F11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!G11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!H11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!I11)","v":""},{"$f":"IF(Sales!B11=\"\",\"\",Sales!J11)","v":""}]
[{"$f":"IF(Sales!B12=\"\",\"\",Sales!A12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!C12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!E12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!F12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!G12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!H12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!I12)","v":""},{"$f":"IF(Sales!B12=\"\",\"\",Sales!J12)","v":""}]
[{"$f":"IF(Sales!B13=\"\",\"\",Sales!A13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!C13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!E13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!F13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!G13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!H13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!I13)","v":""},{"$f":"IF(Sales!B13=\"\",\"\",Sales!J13)","v":""}]
[{"$f":"IF(Sales!B14=\"\",\"\",Sales!A14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!C14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!E14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!F14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!G14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!H14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!I14)","v":""},{"$f":"IF(Sales!B14=\"\",\"\",Sales!J14)","v":""}]
[{"$f":"IF(Sales!B15=\"\",\"\",Sales!A15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!C15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!E15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!F15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!G15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!H15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!I15)","v":""},{"$f":"IF(Sales!B15=\"\",\"\",Sales!J15)","v":""}]
[{"$f":"IF(Sales!B16=\"\",\"\",Sales!A16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!C16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!E16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!F16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!G16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!H16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!I16)","v":""},{"$f":"IF(Sales!B16=\"\",\"\",Sales!J16)","v":""}]
[{"$nulls":5},"Sub-Total:",null,{"$f":"Sales!I17","v":{"v":0,"d":"₹0.00"}}]
[{"$nulls":5},"GST:",null,{"$f":"Sales!I18","v":{"v":0,"d":"₹0.00"}}]
[{"$nulls":5},"GRAND TOTAL:",null,{"$f":"Sales!I19","v":{"v":0,"d":"₹0.00"}}]
[]
[]
["Thank you for your business!"]
[]
["Authorized Signatory"]