Automatic Purchase and Sales Management with Profit | Automatic Inventory Management in Excel
ฝัง
- เผยแพร่เมื่อ 11 พ.ย. 2024
- Formulas and functions used:
Sum
Sumif
sumifs
subtraction
addition
Multiplication
data validation
If
Iferror
Vlookup
Conditional Formatting
Fill numbers and dates
• 10 Easy excel tips and...
For inquiries: shinuboss1@gmail.com
Instagram: Shinuboss1
#excel #inventorymanagement #stockmanagement #cutechinfotamil #software #inventorysoftware #stocksoftware
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.15 (3/4)](http://i.ytimg.com/vi/IVwR87OH0_A/mqdefault.jpg)
I have worked out these all sheets.. very useful. Thank you sir.
Really good job, a great service to the man kind
Tank you sir
Purchase and purchase return and sales and sales return stock nalla irikkirazu sir
மிக்க நன்றி, மிக எளிதாகவும் ullazu.
இதனுடன் Invoice and printing வேண்டும் sir!
upload soon
சார் வணக்கம் நீங்க சொன்னது அருமையா புரிந்தது . தங்களை தொடர்புகொள்ளவேண்டும் டிரான்ஸ்போர்ட்டு கணக்கு எப்படி பாக்கனும்னு தெரிஞ்சுக்கனும் தங்கள் தொலைபேசி எண் வேண்டும்
Sir romba super ha irukku sir ❤
And ithukuda invoice and printing vennum sir please..... Sollunga sir 🥹🙏
hi sir, useful document & clear explanation. i request you to provide a similar kind of document preparation video for a manufacturing company business. please reply sir.
1) Brother, thanks for your presentation on the training course. Ok. Really appreciated. then in this how We can make the daily Invoice. Please advise. How to make the Invoice In Autotmaic
Very nice teaching
Tell us to manage inventory on ecom sites like amazon etc.
Excellent job... very useful.. thank you...
Boss u are Amazing ❤
Sir, thanks it's useful ....Barcode scan pannura mathuri options irruka sir and add HSN code (LocaL) Tamil Nadu SGST, CGST, and (CENTRAL) Others States IGST include pannanum
சார் வணக்கம் நீங்கள் சொண்னது அருமையா புரிந்தது.தங்கலை தொடர்பு கொள்ளவேண்டும். Ston crusher கணக்கு எப்படி பார்க்கனும் தெரிஞ்சுக்கனும்.தன்கள் தொலைபேசி எண் வேண்டும்
மிக்க நன்றி
It is very useful...to me Sir
Glad to hear that
i request you to provide a similar kind of document preparation video for a manufacturing company business.
Hi sir,
really amazing one that you gave us.
thank you.
I have a small query.
if I want to add new products to the product list, how can I apply all the formulas for that?
My glad wishes for you.., such a great work..,
special thanks for your hard work..
i m looking forward more accounting videos ...
Thank you, I will
Super sir
Thank you❤
Super Work thank you
Thanks a lot😃
Sir month wise not showing in net purchase and sales ...very useful sir thanks a lot sir
Very good method of teaching with a wonderful voice message. How can we add our sales to this program with an invoice printing
Useful video very nice 👌👍👍
Thanks for liking
Love you bro ❤️ your amazing 🤩 thanks for your hard work
Happy to know that you understand our hard work
@@cutechinfotamil I’ll always support you bro keep doing good videos 💝 and very all the best for your great feature
Doubt in profit sheet-
As per unga video le Cost ore price kattudu supose purchase price le daily change aagumhodu yeppadi Podanum.
Thank u much sir
Welcome 👍
Anna garments production accountability details xl la yepadi maintain pannanum potunga rombaa help ah irukum
watch this. it may be helpful for you
th-cam.com/video/YRk8LOE-trM/w-d-xo.html
Bro can u explain the masterdata, purchase report, sale report monthwise in single spreadsheet
Thank you anna
Super Bro
❤️😁😁 Thank you
Excellent sir , thank you
Very good explanation thank you sir
Keep watching
Product ID -tv, company-Samsung, Sony, next- size or in -Qty, ipadi na work pannaum atha palakanum bro unga video la na Tamil enaku ec ya iruku enku na gatta mathuri oru video time kedikum pothu panuka bro plz
Hii bro I'm Ranjith...enga business ku intha mathiri report sheet ready panni thara mutiuma bro...pay pantrom....same ithe mathiri
Tq bro bt ithula product ID Samsung iruku product 43 inches tv iruku ok bt enuku tv edutha athu ena company athula ena siz or in tv iruku nu paakara pathuri sollithanga bro
Nice
Bro have some doubts in purches return
Helo bro.. After completing all these I insert a phone number column in between party name and quantity... If i do that will i get any problem in the remaining all the formulas which has been completed .?
Namma entry pandra data ellam automatic ah eppudi backup aagura maathiri set pandrathu bro
Bro ithuvae medical khu batch no and exp date thaen check panni sales pananhum so athukhu yethavathu poturukingae la
sir Create the sheet last 5 month back . Ipa Open panna the Macro may not open or all macros Disabled message showing and also product sheet maintain in the sheet. how to reprocess Method in tamil
add multiple Good won zone rack and bin wise matinee stock
Hai ..... Bro Many Time i am try but net stack is not working ..... plss slove the problem
🙂
Sir enakku indha sheet kidaikkumaa sir im a manager, accountant and Store keeper in a company so very less time i have so I can't create this
why you use ">=" ?
make video for manufacturing process Automatic Purchase and Sales Management with Profit | Automatic Inventory Management in Excel
Pls send Excel drive link for download sir.
Pls how transfer for next fincial year. All opening stock, profit and loss , net purchase & Sale etc
Brother, then how to connect different files, for example as below in the Insurance
Motor Insurance
General Insurance
Claims
Refund if any
How to connect them in one sheet in the Main Board, please support
I applied monthly qty formula (22:50) in Purchse report but i faced value is 0 i did't getting correct value.. so what is the problem in this case sir..??
GOOD
Thank you sir.
Hello brother,
Automatic Rotational 3 shift monthly schedule excel la panra video podunga
How to download in Excel
Hi Sir,
Intha formula use panni ennoda shopla use panra, athula profit cell profit amount wronga katuthu.
(Oru productku 2type sale rate type pannunalum 1st product sale rate mattumtha profitla eduthukuthu.
Sales sheet
Oil - sale 10rs
Same producta oil - 8rs
Type pannunalum first 10 rs mattumtha ptrofitla eduthukuthu
Ithuku solution irukaa...
11 minutes la data validation paitu list kuduttu edayum click agude illa
Bro, I am doing a part time Biz in shares I find difficult in maintaining accounts buying, selling and P&L. Do we have solutions in Excel
Oru product ku different amount kudutha 1st tha price tha eduthukuthu epdi bro different price oru productku tharathu
how to download
Purchase returns confuse aguthu plz explain
Sir medical shop software
I can not include product list in the data validation.....how can I do explain me sis
I want some changes for report this excel file can be possible?
👍
ok
Sir once I created stock mgmt project how can I use it in another system?Just copy paste files or any other procedure to use this in another computer?
This software can be used in any system by copying it. Thank you
Can you share this Excell Book
Na create pannan sir elam vandudu but product list matum thani sheet la pota varala... Windows 7ku sonna mari seidan... But Enna name tharamo(product_list) Adan varudu products varala Aduku Enna seiradu sir...
Eathavathu mistake irukkanum
@@cutechinfotamil but really super sir... Create panita elam easy ah Iruku Na full ah prepare panitan extra tevai anadum Nenga sonna formulas copy create panitan... Thank you so much sir
Anna stock availability ah vida extra enter panna mudiyatha alavukku panna enna formula apply panrathu?
How add "Nos & Kgs" in QTY column after numeric and get values in total amount or in total QTY
Bro tech Marcos for billing
I’m getting incorrect value for net stock when tried to add flavours of the product also selected in formula range?
Do each and every steps as per my instructions, even if you make small mistake, you wont get it right. Thank you for watching.
CAN YOU GIVE DOWNLOAD LINK JI
Sir, I want accounts ageing wise report how to prepare that format need pls help me
upload soon
One product have a different amount how to calculate sir, pls tell me
Let me check
Give example
Hi Bro
kindly share this worked excel file in description it may help me to practice.
Subscriber request 🙏 waiting for your reply
Sir, when I make data validation in Purchase sheet, the Products list (sheet no.8) is not copied in source, how to correct the error
Even if you make small mistake, you will face errors. Please Follow my procedures carefully sir. Thank you
@@cutechinfotamil sir, after selecting source, I clicked product list sheet but its not selected in source.
@@balachandar4752 version you are using
@@balachandar4752 ms office 2007 version ku data validation format onnu sollirupen. Atha try panni parunga
@@cutechinfotamil 2007
Please share that template bro
How can download this file
mail me.
Anyone Having this Excell file, If had share please
This file send me bro
Sir mobile number small doubt
Very very unimpressive narration, sure to drive away the viewers!.. (even though the content is good)
Sorry we dont understand tha language
Your native place
hi sir could you send me this excel sheet in my mail id????