IBI Coconut Sales Tracker

🧾 New Sale

Buyer Name

🥥 Good Quality (per kg)₹0

Weighment (kg)

× Times

Total Weight (kg)

Count (pcs)

Rate ₹/kg

🥥 Lower Quality (per kg)₹0

Weighment (kg)

× Times

Total Weight (kg)

Count (pcs)

Rate ₹/kg

🌰 Coconut Husk | Kadambai (per piece)₹0

Pieces (per labourer)

× Times

Total Pieces

Rate ₹/pc

Labour ₹/pc (−)

Labour charge per piece is subtracted from the husk rate — e.g. rate ₹3 − labour ₹1 = ₹2/pc paid to us.

💳 Payment

Mode

Paid Amount ₹

Date

AMOUNT TO COLLECT

₹0

Today's Sales

All Sales

📦 Coconut Batch Received

Date

Coconut Count

Note (optional)

💪 Labour (De-husking)

Date

Persons

Coconuts De-husked

Rate ₹/coconut

Labour amount = coconuts × rate. Coconut Husk (Kadambai) sale revenue is adjusted against labour in the Report tab.

Batches

Labour Charges

⚖️ Coconut Husk (Kadambai) vs Labour Adjustment

☁️ Save Data (Excel & Google Drive)

Data is stored in this phone/laptop (browser storage). Save it as an Excel sheet (goes to your Downloads — move it to Google Drive if you like). Backup/Import moves the app's full data between devices.

🟢 Google Drive Backend (Auto-Sync)

Connected — auto-sync is ON. Every entry auto-saves to the "Coconut Sales Tracker" Google Sheet in your Drive.

Apps Script Web App URL

📈 Today's Market Rates

Good Quality ₹/kg

Lower Quality ₹/kg

Coconut Husk | Kadambai ₹/pc

Labour ₹/coconut

Your UPI ID (GPay) — for payment links & QR on bills

Rates change with the market. Whatever rate you last used — here or inside a new sale — stays as the default until you change it again. Lower Quality automatically follows 50% of Good Quality; type a different value to fix your own, and setting it back to exactly half re-links the 50% rule.

Rate History