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

HI
I AM MANOJ KUMAR
DOWNLOAD FILE LINK*****
docs.google.co...
contact: 7760630434
store management in excel |stock management system |#excel
Keeping track of inventory can be a daunting task, but with the power of Microsoft Excel, you can easily manage your store's inventory. In this tutorial, we'll show you how to create a comprehensive inventory management system that will track your stock levels for an entire year, as well as provide monthly stock balances and in/out records. You'll learn how to use Excel functions such as SUMIF, COUNTIF, and IFERROR to calculate inventory levels, and how to create drop-down menus and data validation rules to ensure accurate data entry. We'll also cover how to use conditional formatting to highlight low stock levels and how to create a dashboard to display key inventory metrics. By the end of this tutorial, you'll have a fully functional inventory management system that will save you time and help you make informed purchasing ydecisions.
by‪@manojkumarexcel‬
from
bhorha
simri bakhtiyarpur
saharsa
bihar
india

[@Youtubemahi98]

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

[@manojkumarexcel]

Welcome

[@salimaluva8213]

Bahuth Acha samjaya ❤ Thank you

[@Krishnasolankilivevideo123]

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

[@hafizfahadsafdar243]

Sir i am really happy after viewing your video

[@pm_rasoi]

8 like great sharing 👍

[@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]

[@AliHassan-ro4vo]

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

[@princ3ali432]

Best video with full explanation

[@enayetkhan999]

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

[@manojkumarexcel]

Glad to hear that

[@munirkhanyousufzai3274]

Great 👍

[@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]

kzbin.info/www/bejne/Z6uunKujgZekobs

[@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

[@bhumitarak7558]

Thank You sir ji🎉

[@sindhulekha887]

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

[@manojkumarexcel]

Contact me [e-mail]

[@chenjumtamang7167]

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

[@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

[@promitsaha8559]

Thank u very much sir You solved my problem.

[@hafizfahadsafdar243]

Thanks for shot this type of vedio ❣️

[@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]

[@arslanaziz7082]

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

[@chenjumtamang7167]

thank you sir .. help full video

[@AsgariKhatoon-ej2nz]

Good

[@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]

[@muhammadarslan8599]

thanks alot dear sir

[@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]

[@manasmruti_shorts]

❤❤❤

[@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]

[@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]

[@pramodtiwari1715]

Awesome.

[@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

[@RAJKUAMRTYAGI]

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

[@ArkbPublications]

Tq so much sir

[@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]

[@ovejerof]

👌🏻👍🏻👌🏻👍🏻

[@PoorsCinema]

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

[@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]

kzbin.info/www/bejne/amKUgamflpmLgcU

[@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

[@srinivaskamampalli4000]

Nice

[@manojkumarexcel]

Thanks

[@differentvoice252]

Isme issue by or issue to bhi add krna h

[@raiyanahmad590]

Thnxx a lot

[@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]

[@radhakrishanjoshi9509]

sir jan ka out feb ka in hoga ya out?

[@manojkumarexcel]

In

[@manjitsaini4740]

Ok thanks

[@pratikthakur6408]

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

[@manojkumarexcel]

Other then any issue

[@pratikthakur6408]

@@manojkumarexcel nothing

[@brajkishoregope6308]

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

[@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]

[@harauri1]

Sir ye sheet excel per chahiye..

[@remosi7163]

Shoes and clothes ka size wise diknai kishi kare

[@manojkumarexcel]

What's me 7760630434

[@sunilravat330]

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

[@manojkumarexcel]

[e-mail]

[@wadera_yt]

Ya link expired hay open nai ho rha hay

[@arslanaziz7082]

If store related video have you please share me

[@manojkumarexcel]

[e-mail]

[@pintukumarsingh8611]

Saman ko kaise jore koi bhi saman late hai

[@manojkumarexcel]

Last row me add kar digiye

[@pintukumarsingh8611]

@@manojkumarexcel think you sir

[@SiddhantaPesticides]

Sir Excell pdf download link

[@manojkumarexcel]

Description me link hai

[@SiddhantaPesticides]

@@manojkumarexcel Drive not filled

[@manojkumarexcel]

Contact me [e-mail]

[@pankajdhiman9485]

Bhai kuj jada hi long krdi video

[@rahulkumarrk302]

How more items name

[@manojkumarexcel]

Add and dragging the formula

[@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

[@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]

kzbin.info/www/bejne/b6bMe5hqaZZlY9U

[@manojkumarexcel]

kzbin.info/www/bejne/amfUlnejbsSsqaM

[@sampathkumar3444]

Supper sir pls contact number pls sir

[@manojkumarexcel]

[e-mail]