Techultra POS profit — user wise

Sales fetched live from this database (Techultra's own POS).

Profit by POS user (revenue excl. GST minus cost of goods)

User summary

Oil manufacturing

Weight/pack is the product's real pack size — read from the product name, or from its Odoo variant ("100ml", "500ml"...) when the name has none; "set Pack (L) →" means neither was found and the Pack (L) figure is an unverified guess, so check it. Cost/unit = raw material ₹/kg (avg of last 5 Techultra vendor bills) ÷ output % × oil density (kg/L) × pack size (L) + packing ₹. Enter the output % you get from the raw material (e.g. 55 for 55% oil from coconut chips) — everything blue is editable, and untick "Mfg?" to use the vendor-billed cost instead. Remember to save.

Products

Cost pricelist (top right) switches what the cost column is built from: Actual cost is Techultra's own vendor-bill purchase price for the matching raw material — true store-level profit. Franchise cost is the same rule used on themillers.odoo.com/pos-profit (avg of last 5 B2B invoice prices billed to franchisees) — shows profit as if this store bought at the wholesale-to-franchise rate instead, for comparing this store against franchisee economics. Either way: cost/unit defaults to the average of the last 5 posted prices on/before the end date (size-adjusted where billed per kg); manual cost edits, oil setups, and the "own purchase" vs "kg rate ×" source label are tracked separately per pricelist. Type in the box to correct a cost or fill a red "manual" product, then save. Amber "review" = per-kg rate assumed on a product with no pack size in its name. "Download Excel (filtered)" exports exactly the dates, POS user, search text, and selected pricelist — Summary, Detail, and an Oil manufacturing sheet when oils are in view — not the whole database.