Dukan ka stock register kaise banaye, iska seedha jawab: har item ke liye ek line rakhiye jisme date, item ka naam ya code, opening stock, kitna aaya, kitna gaya aur closing stock likha ho. Roz shaam closing nikaliye, aur mahine me ek baar shelf ki asli ginti register se milaiye. Notebook se shuru kar sakte hain, Excel ya billing app baad me.
Ek example lete hain. (Yeh ek typical dukan ka example hai, asli dukan nahi.) Nagpur me ek crockery aur gift ki dukan hai. Diwali se teen hafte pehle supplier ka tempo aata hai: dinner set, glass set, steel ke dabbe, pooja thali. Maal godown me chala jaata hai. Do hafte baad ek customer 24 piece wala dinner set maangta hai. Malik ko yaad hai ki chaar aaye the. Godown me ek bhi nahi milta.
Teen bik gaye. Ek toota hua kone me pada hai. Kisi ne likha nahi, kyunki rush me sabko laga ki koi aur likh dega. Yahi kaam stock register karta hai.
Stock register kya hota hai, aur dukan me kyun chahiye?
Stock register ek kitaab ya sheet hai jisme likha rehta hai ki aapke paas kaunsa maal kitna hai, kab aaya aur kab gaya. Isse teen sawaal ka jawab turant milta hai:
- Abhi kya bacha hai?
- Kya khatam hone wala hai, kab order karna hai?
- Jo maal hona chahiye tha, wo shelf pe hai ya nahi?
Bina register ke ye teeno jawab malik ki yaad me rehte hain. Aur Diwali ke rush me, jab counter pe chaar log khade hon, yaad sabse pehle dhoka deti hai.
Dukan ka stock register kaise banaye: kaunse columns rakhein
Ek page ya ek sheet pe ye columns banaiye:
| Column | Kya likhna hai | Example |
|---|---|---|
| Date | Entry ka din | 12 Oct |
| Item code | Har item ka chhota code | DS24-WHT |
| Item ka naam | Saaf naam, size ke saath | Dinner set 24 pc, white |
| Category | Maal ka group | Crockery |
| Opening stock | Din shuru me kitna tha | 4 |
| Aaya (purchase) | Wholesaler se kitna aaya | 6 |
| Gaya (sales) | Kitna bika | 2 |
| Closing stock | Din khatam pe kitna bacha | 8 |
| Rate | Kharid ka rate | ₹1,850 |
| Supplier / bill no. | Kisse aaya | Sharma Traders, bill 418 |
| Remarks | Toota, return, sample | 1 toota |
Item code sabse zaroori column hai. “White dinner set” do log do tarah likhte hain, code ek hi rehta hai. Chhota rakhiye (maal, size, rang) aur price tag pe bhi likhiye.
Ek cheez ki ek hi line ho. Agar dinner set 24 piece aur 32 piece dono rakhte hain, to dono ki alag line banaiye.
Copy karne layak stock register (example numbers)
Neeche ka register notebook, Excel ya Google Sheet mein seedha copy kar sakte hain. Har item ki apni line, har din ek nayi line. Saari entries example numbers hain, ek crockery dukan ke liye.
| Date | Item code | Item ka naam | Opening | Aaya | Gaya | Closing | Reorder level | Supplier / bill no. | Remarks |
|---|---|---|---|---|---|---|---|---|---|
| 12 Oct | DS24-WHT | Dinner set 24 pc, white | 4 | 6 | 2 | 8 | 3 | Sharma Traders, bill 418 | |
| 13 Oct | DS24-WHT | Dinner set 24 pc, white | 8 | 0 | 3 | 5 | 3 | ||
| 14 Oct | DS24-WHT | Dinner set 24 pc, white | 5 | 0 | 3 | 2 | 3 | 1 toota, alag rakha; reorder karo | |
| 12 Oct | GL06-CLR | Glass set 6 pc | 10 | 0 | 4 | 6 | 4 | ||
| 13 Oct | PT-BRS | Pooja thali, brass | 7 | 5 | 6 | 6 | 3 | Gupta Brass, bill 77 |
Formula ek hi hai: Closing = Opening + Aaya minus Gaya. Agle din ka Opening wahi hota hai jo aaj ka Closing tha. Excel mein Closing column mein =D2+E2-F2 likhiye (D = Opening, E = Aaya, F = Gaya).
Jab Closing, Reorder level ke barabar ya usse kam ho jaaye, us item ko order list mein daaliye. Upar ke example mein 14 Oct ko dinner set ka Closing 2 hai aur Reorder level 3, isliye reorder ka time hai. Toota hua piece bechne layak stock nahi hai, use Gaya mein likhiye aur Remarks mein wajah.
Mahine ke audit ka page (example numbers)
| Item code | Register ka Closing | Shelf par asli ginti | Farak | Wajah |
|---|---|---|---|---|
| DS24-WHT | 2 | 2 | 0 | Toota piece Gaya mein pehle hi likha tha |
| GL06-CLR | 6 | 5 | 1 kam | Counter par bika, entry chhoot gayi |
| PT-BRS | 6 | 7 | 1 zyada | Return aaya, entry chhoot gayi |
Opening stock kaise dale
Register shuru karne ke din ek baar poori dukan ginni padti hai. Isse bacha nahi ja sakta.
- Ek shaant din chuniye. Mahine ka pehla Monday ya koi chhutti.
- Ek aadmi ginta hai, doosra likhta hai. Ek hi aadmi dono kare to galti hoti hai.
- Shelf ke hisaab se chaliye, maal ke hisaab se nahi. Pehle rack 1 poora, phir rack 2.
- Toota ya kharab maal alag rakhiye aur use ginti me mat jodiye.
- Jo gina, wahi aapka shuruati stock hai. Purane bill ya yaad ke hisaab se mat bhariye.
- Purana maal aage rakhiye, naya peeche. Jo pehle aaya, wo pehle bike (isse FIFO kehte hain).
Pehli ginti me poora din lag sakta hai. Uske baad kaam roz ke 10 se 15 minute ka.
Roz stock kaise maintain kare
Register tabhi kaam ka hai jab roz bhara jaaye. Hafte me ek baar bharne wala register sirf ek purani diary hai. Teen aadatein kaafi hain:
Maal aate hi entry. Supplier ka bill haath me ho tab “Aaya” column bhariye. Tempo khaali hone ke baad nahi, ginti ke saath. Bill pe 12 likha hai aur aaye 11, to wahi waqt hai wholesaler ko phone karne ka.
Har bikri ka bill. Counter pe har sale ka bill ya kachchi parchi bane. Shaam ko parchiyon se “Gaya” bhariye. Bina parchi ki bikri hi register ka sabse bada dushman hai.
Shaam ko closing stock. Formula seedha hai: opening stock plus aaya, minus gaya. Aaj ka bacha hua maal kal ki shuruat ban jaata hai.
Excel me rakhte hain to aakhri column me yahi formula laga dijiye: pehle ka stock plus purchase minus sales. Ek column aur jodiye: balance quantity guna rate. Isse aapke paas pade maal ki total stock value niklegi, jo CA aur bank dono poochhte hain.
Notebook, Excel ya billing app: kya chuniye?
| Tarika | Kab theek hai | Dikkat |
|---|---|---|
| Notebook (stock book) | 50 se kam items, ek hi aadmi likhta hai | Hisaab haath se jodna, purana record dhoondhna mushkil |
| Excel ya Google Sheet | 50 se 500 items, roz koi baith ke bhar sake | Phone pe bharna thoda jhanjhat, formula galti se mit sakta hai |
| Billing app jisme stock ho | Roz zyada bills, barcode wala maal | Seekhne me ek do hafte, aur kharcha |
Stock book kaise likhe, iska jawab bhi upar ke columns hi hain. Notebook me har cheez ko apna page dijiye aur page ke upar item code likhiye. Bikri wali parchi se roz ek line.
Mahine me ek baar stock audit kaise kare
Register me likha hai 8 dinner set. Shelf pe 7 hain.
Har mahine register aur shelf milaiye. Poori dukan ek din me nahi gin sakte to har hafte ek category giniye: crockery, phir steel, phir gift items.
Fark mile to wajah dhoondhiye. Aam taur pe ye paanch hoti hain:
- Bikri hui par parchi nahi bani.
- Maal aaya par entry nahi hui, ya galat item pe hui.
- Toota ya kharab maal hata diya, likha nahi.
- Customer ne return kiya, wapas register me nahi chadha.
- Chori. Sabse aakhir me sochiye, pehle upar ke chaar dekhiye.
Fark Remarks me likhiye aur register ko asli ginti ke barabar kijiye. Ek hi item baar baar kam nikle, to wahan nazar rakhiye.
Reorder level: khatam hone se pehle kaise pata chale
Har chalne wale item ke saamne ek “minimum” number likh dijiye. Jaise steel ke dabbe: minimum 5. Bacha hua stock 5 ya kam ho to us line pe gol ghera, aur agle din order. Boutique me size ke hisaab se reorder karna ho to boutique inventory management padhiye.
Excel me conditional formatting se aisi line laal bhi ho sakti hai, ek tarah ka low stock alert.
Minimum kitna rakhein? Maal aane me kitne din lagte hain, aur us dauraan kitna bikta hai, utna. Diwali aur shaadi ke season me ise badha dijiye.
Agar dukan ke saath online bhi bechte hain
WhatsApp, Instagram ya website se bhi order aate hain to ek baat pakki kar lijiye: online wali bikri bhi register me jaaye. Bahut dukanon me counter ki bikri likhi jaati hai aur WhatsApp wala parcel bhool jaata hai. Jewellery counter ho to billing software for jewellery shop ka guide bhi dekhiye.
Do aasaan tarike hain:
- Register me “Gaya” ke do column banaiye: “Counter” aur “Online”. Mahine ke ant me pata chalega ki online se kitna bik raha hai.
- Online ke liye kuch maal alag rack pe rakhiye, khaaskar jo ek do piece hi bache hain. Wo rack sirf online orders ke liye.
Aur dukan band karte waqt: jo item counter pe khatam hua, use online listing se hataiye ya quantity kam kijiye. Do minute ka kaam, aur “sorry, khatam ho gaya” wala message bach jaata hai. WhatsApp aur Instagram orders ek list me rakhne ke liye WhatsApp order management padhiye.
Indi Andaz kahan fit hota hai
Agar notebook se aage badhna hai, to billing app ek raasta hai. Indi Andaz me the Counter app for GST billing Android pe chalta hai: barcode scan, GST bill, aur cash, UPI, card, udhar ya split payment. Counter pe bill banate hi Counter ka shop stock us bikri ke hisaab se kam ho jaata hai.
Online ke liye aapki dukan ka branded online store milta hai, link jaisa indiandaz.com/sellers/aapkidukan. Customer UPI, card ya COD se order karta hai, order ek list me aata hai, aur delivery Delhivery se jaati hai. Shipping ka charge alag hai.
Ek baat saaf rahe: counter ka stock aur online stock aaj alag alag rakhe jaate hain. Counter pe bikne se online quantity nahi badalti. Upar wala shaam ka check isliye zaroori hai.
Kharcha: no monthly fee, 5% only on delivered online orders. Isme payment processing shaamil hai, aur fee pe GST lagta hai.
Counter billing aur online bikri ko saath chalane ka poora hisaab hamari main guide billing software with an online store me hai. Saree ki dukan hai to ek ek design ka stock kaise rakhein, yeh saree shop inventory management wali post me likha hai. Saree ki dukan ki billing ke liye billing software for a saree shop bhi padhein.
Related reading: saree inventory management, boutique inventory management, billing software with online store.
FAQ
Stock register me kaunse columns zaroori hain?
Date, item code, item ka naam, shuru ka stock, aaya, gaya aur closing stock. Rate, supplier aur remarks bhi rakhiye, kyunki mahine ki ginti me fark ki wajah inhi se milti hai.
Closing stock kaise nikale?
Opening stock plus jo maal aaya, minus jo bika. Aaj ka bacha hua maal kal ka opening hota hai.
Kya Excel me stock register bana sakte hain?
Haan. Har column ek Excel column bana dijiye aur aakhri column me formula lagaiye. Roz sirf aaya aur gaya bharna padega.
Stock audit kitni baar karna chahiye?
Mahine me kam se kam ek baar register aur shelf milaiye. Badi dukan ho to har hafte ek category giniye.
Counter pe bikri hone se kya online stock kam hota hai?
Indi Andaz me nahi. Counter ka stock aur online stock alag rakhe jaate hain, isliye counter pe khatam hua item online se khud hataiye.
New here? Start with our Start here page.
About the author: Pritam Nandi is the founder of Prilix Labs, the company behind Indi Andaz. He builds Indi Andaz from Ashoknagar Kalyangarh, West Bengal, to help local Indian shops sell online and bill at the counter from one place.
Indi Andaz by Prilix Labs: an online store with UPI, card and COD checkout, plus GST billing at the counter.
Prilix Labs, Ashoknagar Kalyangarh, North 24 Parganas, West Bengal 743222
Email: indiandazsocial@gmail.com
Phone: 8653001257
© 2026 Prilix Labs
Leave a Reply