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

Sir Excell pdf download link

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

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

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

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

thanks alot dear sir

Shoes and clothes ka size wise diknai kishi kare

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

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

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

Saman ko kaise jore koi bhi saman late hai

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

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

Sir ye sheet excel per chahiye..

Ok thanks

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

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

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

If store related video have you please share me

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

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

sir jan ka out feb ka in hoga ya out?

Nice

❤❤❤

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

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

Ya link expired hay open nai ho rha hay

Thnxx a lot

Thanks for shot this type of vedio ❣️

Sir i am really happy after viewing your video

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.

Awesome.

Sir can you send this sheet or work with me

8 like great sharing 👍

Thank u very much sir
You solved my problem.

👌🏻👍🏻👌🏻👍🏻