Fully Automatic Profit & Loss Calculation in MS Excel | Stock Management with Profit & Loss in Excel

In this video we will learn to Create Stock Management with Profit and Loss Calculation in Microsoft Excel step by step.
#stock_management
#inventory_management
#profit_and_loss_calculation
#profit_and_loss_statement_format
#microsoft_excel_tutorial
#studyspan
Music: Outside
Musician: @iksonmusic
Thank you

[@aartikaushik6556]

Next level sir I follow your all videos

[@StudySpan]

Thank you so much. Stay tuned for latest videos

[@aartikaushik6556]

@@StudySpan ok sir

[@shaharfat5911]

Wow. Great sir g.. It's is easy way of stocking management and also. Without macro... I already used excel for stocking bt i have used 4 . 5 sheets. Only for stocking

[@ahmadtayyab001]

Nice Sir I love it🙂

[@arkillergaming2039]

Good job i like you

[@rishabshukla-dz1sf]

THANKYOU SIR IT HELP ME A LOT

[@chetlalbhogta1510]

Sir G ye apka shortcut me kam krne ka bahut achha laga

[@ManojSahewala-mx9wc]

Very useful video

[@harshithaganesh6984]

Awesome sir thank you

[@mustafaalizada6855]

very useful thank you

[@subham3367]

Acha laga video 👌👍

[@evolutionzone-tr3rn]

sir, yeh format Date wise bna dein or same item ko different price se purchase krwa k samjha dein...Thanks

[@dipendramahara7052]

Sir aapka video bahut acha rehta hai. Excel ka sara tab aur option par video banaye.

[@amritagurung4813]

Wow thankyou somuch sir🙏👍️👍️👍️

[@asadjanichannel.1931]

very Weldon sir

[@mirjarayan1393]

You are great 💝💝

[@IndarsinghThakur-sr1ff]

Thank you so much sir🥰🙏

[@colors_in_pak]

Bro, you're amazing man really thankful for tutoring computer softwares...love from Pakistan ❤️

[@gayatrisrivastava5626]

F7
M
MH TIN30
.

[@colors_in_pak]

@@gayatrisrivastava5626 ???

[@loveneture5753]

Bhaiya bahot badiya par kuch chut gaya =sum me auto sum, or purches amount me bhi लगाना है, or profit loss की total me से purches की total ko - kar ek dam parfect figer nikalna he profit ki or loss ki

[@Goku-sw2el]

sir, u are doing great 👌👌👌
Kindly provide Excel Complete Lecture Series

[@rheapeter9709]

Thank you sir!!

[@varshasingh3364]

Easy to use and working
Thanks for the video sir

[@StudySpan]

You are mostly welcome. Stay tuned for latest videos

[@shafiqshaf85]

Janu

[@SalmanKhan-es3qb]

@@StudySpan men will be men 🤣🤣

[@komaltripathi9197]

Very nice 👍

[@swarnadeepsarkar6760]

Excellent video

[@HafizMudassir-r2v]

Very good

[@surajmishra-ce2qy]

Sir day by day stock managment ka video banaiye

[@gautamisinha1026]

Thanks you so much 🌺

[@AQHOUSE]

very nice

[@DivyaVaniRecords]

Umda h sir👌

[@HafizMudassir-r2v]

Thanks bro

[@shankarraanu2804]

Bhut badhiya 👍👌👌👌👌👌

[@iZacq]

*VERY NICE* 👌🏻 but...
Please make one like mention Below:
1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum of Damage but it should Total Damage 1pc & 9pc Good = 10pc in STOCK
2) Most Important, in Dates coloum when I put 5pc sold, for Computers I need to add the Inv #
For Eg: If I sold 5p. COMP on 10th want it to show in next Coloum
2pc Comp sold to Inv# 1,
1pc Comp sold to Inv# 2
2pc Comp sold to Inv# 3 & so on ....
How would we be able to add coloum for that

[@hamidstk2650]

Hello Bro,
Can you please make a Video How to calculate the exchange money profit and loss.
Ex, £££ to $$$ and €€€ etc

[@mdshahidul2181]

Good video

[@ArvindGautam-lv1ok]

Thanks sir

[@farooqahmadafridi5602]

Very good effort but it is one time entry of an item. If it was purchased / sold 2nd time, how can we calculate? Thanks.

[@MAUNEMPLOYED]

Just increase the numbers it will automatically calculate

[@SuhailAnsari-ry7pr]

Sir aapne formula kaise lagaya bataye nahi pleased bata dijiye nice video sir btate

[@anwarulhaqanwar8405]

Sir, this video does not show how to calculate Closing Stock if again purchase is made for the repeat item viz. keyboard is purchased then what will be the total stock of keyboard. Also if the rate differs from the earlier purchase rate then how to calculate TOTAL STOCK AND VALUE OF PARTICULAR ITEM. This video skipped the vital point and raise the question of the feasibility of maintaining of stock. It will be very much helpful if the above point is described in your next video.

[@ritvikrajput758]

use data validatioin for all the product which you purchase or sale then it will automaticlay calculate closing stock.

[@shivhydraulic1099]

Good job

[@shibamsutradhar8313]

Per day ke stock maintain kar rahe hai ya fir monthly

[@singersrk9123]

Apne bhut accha samjhaya sir but agr kisi ne return kiya fir usko kese adjust krna h

[@shibamsutradhar8313]

Dada ek sawal pls dada answer me.........
Agar selling rate alag alag ho to wo kaise entry kare. Aur stock daily maintain karna chahiye ya fir monthly.....?🙏🙏🙏🙏🙏🙏🙏🙏🙏dada bataiye

[@YTitskhani]

Bro agar ek customer keyboard 375 ka buy kre next customer 395 ka kre tho phr kesa add hogy....??
Ek video daily reports pr be bana dai ThanKU bro

[@simuislam5752]

Nice video ❤❤❤❤❤❤❤

[@jishukumarsing4278]

Thanks you sir 🙏🙏🙏🙏🙏

[@amir.khan1950]

EXCELLENT VIDEO. THANKYOU

[@deepakjaiswal6697]

FMCG Stock pe video bnane plzz

[@muzicialnightmarezz2125]

Gd job

[@SHAILESHBHAGAT-ut7gj]

Sir bil bana ne ke sath hi stock management with profit & loss, nhi ho sakta sir? Matlab ki purchase likhe, or seling bil banate he, usse hi selling entry ho jaye or stock and profit loss dikhaye, wo kese kar sakte he

[@Dalimscreative]

Nice video 👍

[@Giribaba143]

Bhaiji
100qnt share buy aur 10qnt same share sell kiya to average price kya hoga . Iska formula kya hoga

[@NoorAzam-cz5re]

❤❤

[@SaurabhKumar-od5cb]

Shopping mall me billing karne wala video banayiye sir

[@sanjivdasmahant8128]

Tq sir tq so much

[@amreshpurikhan8512]

If i buy 500 stocks on the price of 300 and buy 200 on the price of 285 then how to calculate the percentage of my loss on calculator?

[@RaazViews]

u can handle in respect to batches

[@parmeshwarkawle9179]

Very nice video sirji...

[@positivemind016]

what if I purchase 2 model keyboards and has different rates, eg 350, 500 and selling for 375 and 525 respectively? how to calculate profit for this?

[@YamKrishnaSM]

I can make this item 2 section

[@everycute9519]

Brilliant excellent Excel tutorial

[@saurabhaditya5627]

Sir Aaj mai aapki video dekh kar bana Raha tha management

[@surojitpaul5957]

is this excel sheet is prepare as per fifo method basis

[@sagarmakwana2361]

Thank you so much ❣️✨

[@gadamprathap1751]

Sir u r doing great 👌👌👌

[@RohitKumar-gy7et]

Or yesa hi video banaye

[@sangitabagh9835]

Thank you so much sir 🙏

[@lamaarEldad]

can i have a tutorial on how to create such table

[@rheajobin06]

Thank you so much!!

[@hilalrehman1849]

Sir kindly show how to even make set up show from beginning would be appreciated 🙏

[@MuhammadWaqas-ci7el]

Of sale of different prices then how excel will calculate?

[@cliftonwoods]

IF I HAVE DIFFERENTSIZE FROM 1-12 IN EACH PRODUCT HOW SHOULD I MAKE THE ENTRY AND IF THERE ARE MIX SIZES IN ONE BILL ONLY HOW TO DO THE ENTRY?

[@HasanRonee]

what if I buy same product deferent price in same day

[@kumararsekar9882]

Amazing bro I am impressed

[@mdsalimahmed4319]

Nice

[@ArunHole-bp8uk]

नमस्कार सर,
Please Attach one sheet ...( Stock Maintain ) this Stock Stock Management With Profit & Loss

[@sdew7128]

Sir gst stock manage karne par video banaye

[@mahfujurrahmanraju5175]

❤

[@baskinathshuklaboss9799]

Thanks

[@raginivishwakarma6712]

Dhanyawad

[@savewater8344]

Thank You 🙂

[@Total-visit18]

Thank u sir❣️

[@parthopratimdas175]

Thank you sir

[@kisaanfarm2395]

Sir bohat se items 1 date/din me bar bar sale ya purchase kiye jate hai to unka balance etc kaise set kiya jayega.

[@rahmatali9435]

Nice 👍👍👍

[@CARTOONTEACHERSSG]

Dada kaishe daily collection report banai with Excel

[@maximillion9800]

Super

[@darakshaparveen8895]

Very useful vedio ,,👍🏻

[@anwarulhaqanwar8405]

Aap Nay hr item ki entry sirf aik baar ki hay agr aik item kay wahi item dobra purchase ho to phir?

[@ritvikrajput758]

use data validation for all the items which you buy or sale in the business.

[@rajsinghania1844]

But how to add same item , for eg. Some item purchase again n again so how I maintain stock

[@shubhabarman5238]

Thank you sir ❤❤

[@StudySpan]

You are mostly welcome.

[@ankitdholariya8921]

Very useful video
🙏

[@Live-Entrtainment35]

Simple don't go with manually numbers type in column run the Randbetween method formula function

[@alaminmollaalamin9354]

Wow

[@mohammadal4322]

What if the item is sold in 3 operations (3 closing operations)?

[@dilhanilasantha175]

Thank

[@purbachpujari]

Thank❤🙏 sir

[@SonuYadav-xk6ng]

Why gst and sales tax are not included at the time of profit calculatiin

[@promiwelwann6751]

Awesome

[@bhaktabag351]

Thank you sir 🙏🙏

[@md.shareefmulla7240]

Sir Har item ka price hamesh same nahi hota ek din kam aur jiyada hota hai usko ham kaise closing stock mai add kar sakte hai iss procedure se ..

[@Arvindarvindmewada72]

💯

[@inamullah276]

Zbrdstttt

[@StudySpan]

Thank you so much. Stay tuned for latest videos

[@inamullah276]

@@StudySpan what not keep it up

[@realmenarzo2061]

Sir including GST price entry Kiya