v2

Coconut Sales Tracker

🧾 New Sale

πŸ₯₯ Good Quality (per kg)β‚Ή0
πŸ₯₯ Lower Quality (per kg)β‚Ή0
🌰 Coconut Husk | Kadambai (per piece)β‚Ή0
Labour charge per piece is subtracted from the husk rate β€” e.g. rate β‚Ή3 βˆ’ labour β‚Ή1 = β‚Ή2/pc paid to us.
AMOUNT TO COLLECT
β‚Ή0
Today's Sales
All Sales

πŸ“¦ Coconut Batch Received

πŸ’ͺ Labour (De-husking)

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)

Not connected. One-time setup: create a Google Sheet in your Drive β†’ Extensions β†’ Apps Script β†’ paste the Code.gs from the repo β†’ Deploy as Web App (Execute as Me, Access: Anyone) β†’ paste the /exec URL here. After that every entry auto-saves to the Sheet.

πŸ“ˆ Today's Market Rates

Rates change with the market (e.g. β‚Ή38/kg two months back, β‚Ή52/kg today). Saving here updates the defaults used in New Sale β€” each sale can still override its own rate.
Rate History