Excel Inventory Management | Full Year and Monthly Stock Balance with In/Out Record

[@Krishnasolankilivevideo123]

Sir ❤tq
E video se seekh ke mera bhut kuch solve ho gaya tq much sir mera bhut bada doubt cleer ho gaya🙏🙏🙏🙏

[@Youtubemahi98]

Wow bohot shandar tarike se sikhaya hai apne sara confusion dur kar diya thank you so much sir

[@manojkumarexcel]

Welcome

[@pm_rasoi]

8 like great sharing 👍

[@hafizfahadsafdar243]

Sir i am really happy after viewing your video

[@princ3ali432]

Best video with full explanation

[@jigyasayadav4898]

Sir ye to apne 1 cartoon ka bta diya par jb maal retail or wholesale me jye to uska kaise bnaye pls sir video bnaiye

[@manojkumarexcel]

Contact me
[e-mail]

[@bhumitarak7558]

Thank You sir ji🎉

[@munirkhanyousufzai3274]

Great 👍

[@chenjumtamang7167]

thank you sir .. help full video

[@enayetkhan999]

Thank you sir,you are great, simply you taught me ❤

[@manojkumarexcel]

Glad to hear that

[@promitsaha8559]

Thank u very much sir
You solved my problem.

[@AliHassan-ro4vo]

Sir jo link apne video ki description main deya hai wo just view link hai usko download view main update kr de

[@arslanaziz7082]

Thanks it’s help me to much ❤❤❤❤❤❤

[@hafizfahadsafdar243]

Thanks for shot this type of vedio ❣️

[@AsgariKhatoon-ej2nz]

Good

[@ArkbPublications]

Tq so much sir

[@muhammadarslan8599]

thanks alot dear sir

[@vijaykumarbanagar2256]

Sir
It is easy and simple stock management , I have installed in the exel sheet.
It is working very fine.
Sir , I request you to show me how to enter new items that has purchased ,
Previously the new items are not in the present list.
Plz teach me , thanking u

[@shanedl7970]

Exactly looking for the same, if you got any updates please let me know

[@manojkumarexcel]

[e-mail]

[@manojkumarexcel]

[e-mail]

[@chenjumtamang7167]

Sir isme dursra raw ad kar k .. items name add karna ho aur b toh ..Kiya kare

[@manasmruti_shorts]

❤❤❤

[@manjitsaini4740]

Sir mane apse kaha tha ki plastic house hold me 2-3 type ki category hoti hai like 1st quality,. 2nd quality har item ki like table, tea chhalni, cloth brush, hanger suppose koi Ek cheejj 20/- ki hai, to iski better quality me 40/- ki hogi. Ase normal 40/- ki hai, wahi good quality me 60/- ki hogi. Bus sir app last me closing balance stock ke saath product no. ke saath product ki amount bhi show hoti rahe or Ek column last me profit loss margin bhi show Kare, app sir isi par Ek normal video banade please.
Product me app table, chalani, hanger, brush, balti, mugga etc se column create kar le.
Sir app ye bhi batayen ki aaj ka closing stock balance with amount , profit loss show hona chahiye or is closing balance ko, next day ka opening balance bhi show karna hai , jab hum next day ki shuruat karenge, ase hum daily basis par har din show karenge. Sir app jaldi se bana de is par video thanks

[@manojkumarexcel]

th-cam.com/video/1zKkxmL2qkY/w-d-xo.html

[@pramodtiwari1715]

Awesome.

[@RAJKUAMRTYAGI]

Hi, Feb month showing days 1 to 31 so please better calendar days should change as per month

[@ovejerof]

👌🏻👍🏻👌🏻👍🏻

[@differentvoice252]

Isme issue by or issue to bhi add krna h

[@sindhulekha887]

Sir tool purchase and consumption k report and stock in hand kaise maintain karen

[@manojkumarexcel]

Contact me
[e-mail]

[@manjitsaini4740]

Sir app plastic house hold items business par video banaye please kyonki plastic me kuch first quality ka product hota hai , kuch second quality ka, like balti, tub, table, tea chhalni, to Inka price bhi kam jyada ho Kara hai quality wise, sir Inka sale purchase stock kase banaye Excel me with price, with quantity or kase show karenge in out balance,
Sir jo apne ye video banayi hai app isme product ki quantity ke saath iska price bhi show Karen, or last me closing balance ke saath profit margin bhi update /show Karen month wise.
I am waiting your next video according to my requirement sir, please jaldi banaye sir plastic house hold items par

[@manojkumarexcel]

Sure will bring soon

[@sabirahmed2100]

Sir when I want to take closing balance from Jan In and not approving in opening balance in Out I am using same formula which u have shown formula =click Jan In and enter it shows in opening col 0
Ur guide line requested in office 9

[@manojkumarexcel]

Send your file
[e-mail]

[@manjitsaini4740]

Thanks, jo apne pahle video banayi thi wo bahut easy way mai hai to sir app usi video me ye 2-3 column add karde bus like quantity no. And product price or last me, day closing out quantity no. ke sath , uski total amount kitni balance hai day closings out me with profit loss margin ka saath show honi chahiye

[@manojkumarexcel]

You will get detail video on 16th as regular time

[@manojkumarexcel]

Kya aap ke price value change hote rahta hai ky foxed hota hai

[@manjitsaini4740]

Ok thanks

[@PoorsCinema]

Sir mera out me opening balance ka formula kaam nahi kar raha 😢 please help me.

[@raiyanahmad590]

Thnxx a lot

[@Rahimology03]

Bhai kis supplier se aaya. Uska name aur invoice number aur kis UOM UNIT OF MAJOR ME AAYA WO ISME KAISE KRENGE HR DIN KA ALAG ALG SUPPLIRE SE RECEIVE KRNA

[@manojkumarexcel]

Contact me
[e-mail]

[@manjitsaini4740]

Sir thoda bahut vary hoga bhi, but sari sheet aap wali hi rahe with full month of dates, dates bhi ase hi show kare, bus isme purchasing or selling ka bill no.wala column banana hai or quantity ke saath amount bhi show ho, dono sheets me yani purchase or in out balance me simple way me 16:26 17:52 2:08, sir please jaldi video banaye please

[@manojkumarexcel]

Contact me
[e-mail]

[@manjitsaini4740]

Sir app isi video me hi bataden, mujhe date ase hi rakhni hai month wise jo apne video banayi hai bus usme do column add karne hai. Dono sheet me like purchase or in out balance sheet me, ek bill no. Ka or doosra product ki amount ka column banana hai bus, please ye add karke video upload kar dijiye

[@manojkumarexcel]

Contact me [e-mail]

[@mahiei770]

General store ka record excel per kaise banaye jisme rice oil kg or liter me ho
10 kg rice hai price 400 to half kg, 250g aur 100g nikale
10 liter oil hai price 300 hai half liter, 250g 10g nikale

[@manojkumarexcel]

[e-mail]

[@manojkumarexcel]

Contact me
[e-mail]

[@srinivaskamampalli4000]

Nice

[@manojkumarexcel]

Thanks

[@manjitsaini4740]

Sir ye sari sheet same rakhni hai with date column, but isme jo purchase sheet hai us par bill no. Add karna hai purchasing ka or ek column amout ka bhi banana hai.
Or ase hi in out balance me bhi show ho opening balance or closing stock me bhi show ho sale bill no. Or quantity ke saath product amount ka column banaye, phir ise next Month me kase banaye ge isko bataye please

[@manojkumarexcel]

Price same rahega ya vary karega

[@chhotangupta5964]

Mere cell ke. Size select k bad v ek only jisski sizes Kam kar rha hu sirf wohi ho rha h Aisa kyo

[@manojkumarexcel]

Contact me
[e-mail]

[@harauri1]

Sir ye sheet excel per chahiye..

[@Akhillkorepu3341]

Hai sir, i want to make this data in dashboard, how to comeout dashboard report for our store materials

[@manojkumarexcel]

Contact me [e-mail]

[@manojkumarexcel]

[e-mail]

[@brajkishoregope6308]

Restaurant items ka stock inward report, stocks outward report,Net Stock report kaise kare

[@manojkumarexcel]

Contact me
[e-mail]

[@AsadPiracha-jj3ri]

Sir I am a distributor of an automobile related items manufacturing company. I take orders from my customers and supply items to them. I have made an invoicing system according to my business needs. It makes the invoice and gives me the total quantity of each product in the end.
I want to merge this system with inventory stock. For example I have stock maintained in my inventory, I use my invoicing system and whenever I make invoice, it automatically deduct from my inventory. Your help will be appreciated.

[@manojkumarexcel]

Yes sure

[@manojkumarexcel]

Contact me
[e-mail]

[@manojkumarexcel]

th-cam.com/video/411Pvia4XKc/w-d-xo.html

[@AsadPiracha-jj3ri]

@@manojkumarexcel kindly check your email, thank you.

[@sarifulrahaman5812]

Good Morning,, Sir..
This video is very nice and very Helpful..
But sir mujhe same sheet me,, present stock valu kaisa calculate karna hai...????? please help me..
For example: manlijiye mera stock me 10 Bag Basmati Rice hai,,, month end me uska stock valu kaisa calculate karna hai..? 9:49

[@pankajdhiman9485]

Bhai kuj jada hi long krdi video

[@wadera_yt]

Ya link expired hay open nai ho rha hay

[@radhakrishanjoshi9509]

sir jan ka out feb ka in hoga ya out?

[@manojkumarexcel]

In

[@pratikthakur6408]

Sir lekin date kaise automatically chenge hogi Feb to 28 days ka hota hai na

[@manojkumarexcel]

Other then any issue

[@pratikthakur6408]

@@manojkumarexcel nothing

[@remosi7163]

Shoes and clothes ka size wise diknai kishi kare

[@manojkumarexcel]

What's me 7760630434

[@pintukumarsingh8611]

Saman ko kaise jore koi bhi saman late hai

[@manojkumarexcel]

Last row me add kar digiye

[@pintukumarsingh8611]

@@manojkumarexcel think you sir

[@sunilravat330]

Sir in ka closing out opening karne me nahi a raha he

[@manojkumarexcel]

[e-mail]

[@rahulkumarrk302]

How more items name

[@manojkumarexcel]

Add and dragging the formula

[@newaccount480]

Faltu hai 1 hi din me 1 hi date me 50 admi ok sale kiya ya purchase kiya to nahi ho payega iska banaya hua format me

[@manojkumarexcel]

Aap apne hisab se format ko badal sakte hai
Contact me
[e-mail]

[@newaccount480]

@@manojkumarexcel kaise tum video bano or ajj upload karo ye format me 1 date me 10 item ok sale purchase karke dikhao tumhara banaya me me 1 hi item ka ho sakta hai wo v 1 item ko 1 bar hi purchase ya sale kar sakte ho

[@manojkumarexcel]

th-cam.com/video/9uiJe4412-s/w-d-xo.html

[@manojkumarexcel]

th-cam.com/video/46qeDm9_ysA/w-d-xo.html

[@arslanaziz7082]

If store related video have you please share me

[@manojkumarexcel]

[e-mail]

[@SiddhantaPesticides]

Sir Excell pdf download link

[@manojkumarexcel]

Description me link hai

[@SiddhantaPesticides]

@@manojkumarexcel
Drive not filled

[@manojkumarexcel]

Contact me
[e-mail]

[@fastinformation6709]

Sir can you send this sheet or work with me

[@manojkumarexcel]

Contact me
[e-mail]

[@tahirshaukat-ho9ej]

@@manojkumarexcel send me this sheet for mobile

[@sampathkumar3444]

Supper sir pls contact number pls sir

[@manojkumarexcel]

[e-mail]