₹ProfitBook

ProfitBook — asli P&L ki tasveer

Amann Records Private Limited · Meesho + Amazon · Dec 2025 – Aug 2026

Internal audit · 16 Aug 2026 · Sabhi rakam ₹ me. Ye ek asli seller ki sheet ka audit hai.

Net profit — ProfitBook (corrected)
₹40,892
Net revenue ₹3,57,426 par 11.4% margin
Google Sheet ke Dashboard par ₹93,544 profit aur ₹2,48,655 cash likha tha — dono galat the. Arithmetic sahi thi; concept me kharche chhoot gaye the. Settlement gap ab sirf ₹4 hai, yaani numbers bank se milte hain.
Net revenue
₹3,57,426
ex-GST
COGS
₹1,55,474
43.5% of revenue
Orders
3,407
2,719 delivered
Return rate
20.2%
688 return + RTO
Stock value
₹84,626
179 products
Settlement gap
₹4
bank se milta hai

Orders ka haal

Har paanch me se ek order wapas aata hai. RTO (deliver hi nahi hua) return se bhi zyada hai.

Reverse shipping data se: Meesho RTO par ₹0 katta hai (363 orders me settlement ₹0), Meesho customer return par avg ₹147, Amazon return par avg ₹118. App me ₹30,092 + ₹1,530 bhar diya gaya.

P&L se gayab kharche

Sheet ka Dashboard sirf paanch cheezein ginta tha — COGS, commission, shipping, return/damage, ads. Ye baaki reh gaye.

₹52,080 (GST) + ₹41,850 (Meesho gap) = ₹93,930 — aur claimed profit tha ₹93,544. Kuch cheezein aapas me overlap karti hain aur ITC se ~₹20,090 wapas aayega, lekin asli profit claimed se bahut kam hai. Exact number ke liye Meesho ki sub-order level raw payment file chahiye.

Mahine-dar-mahine leak

GST payable (aapke apne GST_Report tab se) aur Meesho settlement ka anexplained gap — dono kabhi P&L me nahi gaye. Amazon me ye gap zero hai, isliye ye Meesho-specific baat hai.

Aug-2026 ka Meesho settlement abhi aaya nahi, isliye us mahine ka gap column khaali hai.

COGS ÷ Revenue — May me achanak jump

Ek hi tarah ke business me ye normal nahi hai. Ya to COGS me purchases count ho rahi hain (jo bika uska cost nahi), ya cost method beech me badal gaya.

May-2026 me ₹42,059 ka bada purchase hua tha. Agar COGS = purchases hai to ye P&L nahi, cash statement hai.

Reconciliation gaps — jo abhi tak nahi milte

Ye P&L ke kharche nahi hain, ye numbers aapas me nahi milte wali problem hai. Har ek profit ka figure hila deta hai.

COGS vs purchases
₹1,69,264
COGS ₹1,98,021 · ledger ₹42,201
Cash outflow gayab
₹41,141
Month column me Dec/Nov-2026 typo
Free-text row
₹10,525
kisi column me amount hi nahi
Sales rows SKU se match
15.5%
532 / 3,422 rows

Sabse bada supplier cahel enterprices (deepak) Supplier_Ledger me hai hi nahi. sadhvik hatras / sdhvik hatras spelling ke ek letter se do supplier ban gaye.

Top SKU — jahan working capital phansi hai

Paanch SKU se ₹1,32,530 revenue aata hai, profit sirf ₹1,001. Aur ye numbers GST aur missing charges jodne se pehle ke hain.

SKUQtyRevenueNet profitMargin

Bikri badhane se ye loss aur badhega, kam nahi hoga. Price Planner me RTO rate daal kar dobara price nikalna zaroori hai.

Excel me mili badi galtiyan

Arithmetic har jagah exact thi — monthly totals paise-paise jodte hain. Problem concept me thi.

GaltiAsarRakam

Abhi baaki hai

ProfitBook app me ye saari galtiyan structurally rok di gayi hain — lekin ye kaam abhi bache hue hain.

Kya karna hai — priority order

#KaamKyun
© 2026 Amann Records Private Limited · profitbook.online App kholein