IBI Wholesale Price Generator

⚙️ Settings & Connections

Gemini API Key (stored only on this device)

Used only to read the scanned invoice. Sent directly to Google, nowhere else.

Gemini Model

Default transport split method

Default GST treatment for landed cost

IBI claims ITC, so GST is excluded from cost by default. Switch to "Include" only if you do not reclaim purchase GST.

Google Apps Script Web App URL (saves to your ERP sheet)

Deploy the included Code.gs as a Web App and paste the /exec URL here.

Google Sheet link (to view saved data — optional)

Paste your Wholesale Price / ERP sheet link to show an Open Sheet button below. Or click Test Sheet Connection and it auto-detects the link.

📊 Google Sheet — Saved Wholesale Prices

Every calculation you save is written to your Google Sheet & ERP. Open or preview it here.

1Scan / Upload Invoice — or enter manually

Take a photo, or upload an image or PDF of a Tax Invoice / handwritten note. Images can be cropped; PDFs (incl. multi-page) are read directly. No bill? Use Enter Manually for local purchases.

📷 Scan with Camera 📄 Upload Image / PDF

2Review & Correct Line Items

Edit any value before computing. Description is saved exactly as entered.
Incl. GST? tick it only if the Amount figure already includes GST; untick it when GST is charged separately in a tax summary (as on most invoices — including this one). Whether that GST stays in your cost or is treated as recoverable ITC is set by GST in landed cost in step 3.
Manual (no-bill) entry: type the product name, HSN, GST %, Unit Price and Qty; leave Amount blank.

Supplier / Vendor

Invoice No

Invoice / Purchase Date

Description of Good	Role	HSN Code	Qty	Unit Price (rate)	GST %	Amount (if billed)	Incl. GST?

2bCombine Products into a Single SKU (optional)

Club two or more products that you sell together (e.g. Uruli 17 + SUPLATE 12 Inch). Nothing is pre-selected — you choose every product and quantity yourself. Each component's per-unit landed cost (incl. packing + transport) is summed into one combined WSP.

3Transportation & Wholesale Price

Total Transportation Charges (₹)

Transport Split Method

Margin % (optional)

GST in landed cost (ITC treatment)

Packing cost distribution (for lines marked "Packing")

📒 Local Memory (last 24 items)

0 of 24 stored on this device

Tap the × on any item to remove just that one, or Clear All to erase everything.

No items stored yet. Calculated items appear here automatically.