Hello if we maintain coustomer ledger will bill book like we have a sheet whoes format is particulars, quantity, rate, Dabit, credit, totel amount, please tell me which formula we can use to maintain this ledger format
ji, aap isko apne situation ke hisab se formula apply karenge. formula yahi hoga but jaise Dr. or Cr. hai uske hisab se isko aap apply karenge (10:35 par aap dekhenge ki formula yahi usee hua hai)
@Technical Alrounder Exactly what i was thinking, there needs to be < sign but apart from that the whole video is really helpful. (Thank u @Vinay Solanki sirji).
Asw सर एक वीडियो बनाए please जिसमे एक बिल में लोट में स्टॉक आता है जिसमे उसके बिल का descurption जिसमे date,bill no,D.O No,etc है और उसके मैटेरियल का description जैसे item name,qty,size,हो बिल महीने में 10से ज्यादा आता है same item और अलग item भी,स्टॉक का total भी एक जगह रहे, सर इसका format बहुत लोगो से तैयार करवाया नही हुआ प्लीज you can see, its like challange 🙏
I m using your this format but i have one question when i sort customers list A to Z on customer sheet and then i click on details link button correct customer ledger sheet will open but the heading name on the customer sheet was different but the sheet is correct. There is any way to lock the customers names with link button on the summary sheet when i sort the customer list so the data get not disturbed Please answer.
Sir Mera kab dr me Mai apke tarah 1000 likh rha hu toh vo balance me 1000 credit hojaa rha hai aysa kyu sir maine format ekdm same ap ke trh kiya hai fir bhi
Sir jo aap opening balance ke baad closing balance nikalne ke liye formula lagate hai wo samajh nahi aaya mujse nahi lag paa raha hai hai please help me
Protect an Excel file 1.Select File > Info. 2.Select the Protect Workbook box and choose Encrypt with Password. 3.Enter a password in the Password box, and then select OK. 4.Confirm the password in the Reenter Password box, and then select OK.
ya video very bater for me , magar jab me home tab ko link karne ka kosis kar raha hu ,tab link optation mujhae show nahi kar raha hay , kaya tum help kar sakte ho ?
Aap jab Ctrl+T karte ho uske baad Create Table karke ek option aayega, usme option hai "My table has headers" uss option par tick karenge toh col1, col2 aise nahi aayega
Apne execel me bataya opening balance debit hai to Dr dikhaya jayega agr opening balance credit hai to closing balance minus me credit show hoga par esa nhi ho Raha hai vo debit account me opening balance dikhane par vo credit kr rha hai credit balance me show krne par closing balance minus me debit dikha raha hai
apne formula mein mistake kiya hoga!! Agar aap isko Debtor ke liye create karoge toh same formula use hoga "Debit hua toh hame party se paise lene hai or agar credit hua toh balance negative show hoga matlab paise jayada aa gaye" {Dr/Cr. wale column mein formula lagayenge - =if(cell reference0,"Cr","Dr")
Maintain Customer Ledger - th-cam.com/play/PLTY9Qq888nq6EoTpbZNyGGgt8VL-Q7mse.html
Very well explained. Very calm and full of interest.
Appreciate from Pakistan
I don't know Hindi still i understand everything clearly Wonderful explanation!!!
When a party's money is received in the Daily Cashbook, how will that money be automatically added to the party's ledger?
Sabse achha video hai
Very nicely explain nd very knowledgeable and useful information Thanks 👍🏻
Very well organized and explained
Thank u for this information it's helps a lot again thank u so much
Thank you Bhai
Thank you for the video. Helped a lot ❤
Vinay Solanki, thank you very much. I was looking for just that.
Boss nice explain and so simple your mathod. Heads off
Very easy method thanku sir ❤️
Thank You so much bhai ❤❤
Very very thanks ❤
Thanks a lot bro ❤
Great information
very informative video keep it up brother
Best..need of that
How to sort the data according to date without messing the data? Eagerly waiting for your reply.......
Out class
Well customization
Thank you sir
My name is Anwar
Mujhe ap ka ye baat
Larger Pasand aaya
Ager Mujhe Kuch
Malum kerna Ho tau
Kese kersakte hu
Thanks a lot bro... 🌹🌹
Thank u sir 🙏
Best video 🎥... Helped me a lot
Nice video
Hello if we maintain coustomer ledger will bill book like we have a sheet whoes format is particulars, quantity, rate, Dabit, credit, totel amount, please tell me which formula we can use to maintain this ledger format
th-cam.com/video/eyX487HrXFE/w-d-xo.html
Jo formula iss sheet mein use Kiya SUMIF aap uska use kar sakte ho.
Entry hr paty ka ledger ma ja kr karni pada gi .koi solution do ki entry auto metick us party ma chali jeya jis party ki entry ha
can we show only selected person not all at once DR., Cr. and Balance after that detail. how can do it in excel.
In opening balance debit and credit formula I couldn't understand pls tell by typing
Bank transaction ke liye koi Excel me koi video hai to recommend me plz
aaisahi video supplier/vendor ke liye__recomend me plz
Sir while entering formula on customer sheet Balance table. Error coming.
How to Create same format in Ms Access? Please upload tutorial video and share file link.
How to inform customer for his Debit and credit...
Sir G2 cell par aap nay F2>0 write keya which means F2 is greater than 0 whenever there should be F2
ji, aap isko apne situation ke hisab se formula apply karenge. formula yahi hoga but jaise Dr. or Cr. hai uske hisab se isko aap apply karenge (10:35 par aap dekhenge ki formula yahi usee hua hai)
@Technical Alrounder Exactly what i was thinking, there needs to be < sign but apart from that the whole video is really helpful.
(Thank u @Vinay Solanki sirji).
Asw सर एक वीडियो बनाए please जिसमे एक बिल में लोट में स्टॉक आता है जिसमे उसके बिल का descurption जिसमे date,bill no,D.O No,etc है और उसके मैटेरियल का description जैसे item name,qty,size,हो बिल महीने में 10से ज्यादा आता है same item और अलग item भी,स्टॉक का total भी एक जगह रहे, सर इसका format बहुत लोगो से तैयार करवाया नही हुआ प्लीज you can see, its like challange 🙏
Sir ji aap na jesa jesa bola vesa to bun gaya vo bhi ok report
Pr party ka ledger ma ja kr entry kr na bhot zda mushkil lg ta ha .koi solution do
Ji haa apko alag alag hi entry karni padegi
Sir How can I Adjusted debtors ( amount received Bill Wise)
or according to invoice number.....
Amount bill wise adjust nahi ho sakta. Aap narration mein daal sakte h ki kis bill ke against payment aayi h
Hello, sir isko spread sheet mein kse create kr skte hain ?
Same jaise iss video mein create Kiya hai isko aap sheets mein create kar sakte hai
sir ledgers me agar hame multi branch ke sheet ke Kya karna hoga
JAISE me ek company hai abc company jiska 5/6 branch hai
Aap ek sheet alag Shee create kar sakte hai or sabka reference uss sheet par de sakte ho
Likely this ledger
Mujhe party ledger bana he kese karna he sir
Customer ki jo intry add ho gi wo cash book me jama ho Jay us ki b video ap ki us link send kare
I m using your this format but i have one question when i sort customers list A to Z on customer sheet and then i click on details link button correct customer ledger sheet will open but the heading name on the customer sheet was different but the sheet is correct.
There is any way to lock the customers names with link button on the summary sheet when i sort the customer list so the data get not disturbed
Please answer.
Have you got any solution? Am also facing the same issue.....
Sir is mai aur ek feature add Karo jab bhi due date aaye to uska reminder show ho
Isme bill ki picture kese add kare
Sir Mera kab dr me Mai apke tarah 1000 likh rha hu toh vo balance me 1000 credit hojaa rha hai aysa kyu sir maine format ekdm same ap ke trh kiya hai fir bhi
Agar hume is sheet me discount ka formula lagana ho to kaise lagayenge
Sir jo aap opening balance ke baad closing balance nikalne ke liye formula lagate hai wo samajh nahi aaya mujse nahi lag paa raha hai hai please help me
Sir Isme month wise ya date wise data kese nikale yani August month me Konsi Konsi party ko kitna maal sell hua or Konsi date ko
Use pivot table in that case
Can we manage in single sheet instead of creating new sheet for new customers
Yes we can! Check this out - th-cam.com/video/RYX03qxmpOs/w-d-xo.html
I need this sheet any 1 share this sheet
Agar hum ko ess sheet ko password protect karna ho to kai sai kar saktay hai
Protect an Excel file
1.Select File > Info.
2.Select the Protect Workbook box and choose Encrypt with Password.
3.Enter a password in the Password box, and then select OK.
4.Confirm the password in the Reenter Password box, and then select OK.
ya video very bater for me , magar jab me home tab ko link karne ka kosis kar raha hu ,tab link optation mujhae show nahi kar raha hay , kaya tum help kar sakte ho ?
Email me on - vinnaysolanki@gmail.com
(Your sheet & problem)
Aii sheet er opor sale dakhan
Sir excel sheet me hum Ctrl+T press kar ne baad murge Kiya colum me column1 column2 column3 estara aa Raha hai plz sir solve this problem
Aap jab Ctrl+T karte ho uske baad Create Table karke ek option aayega, usme option hai "My table has headers" uss option par tick karenge toh col1, col2 aise nahi aayega
How to connect customer with WhatsApp or mail id
Apne execel me bataya opening balance debit hai to Dr dikhaya jayega agr opening balance credit hai to closing balance minus me credit show hoga par esa nhi ho Raha hai vo debit account me opening balance dikhane par vo credit kr rha hai credit balance me show krne par closing balance minus me debit dikha raha hai
apne formula mein mistake kiya hoga!!
Agar aap isko Debtor ke liye create karoge toh same formula use hoga "Debit hua toh hame party se paise lene hai or agar credit hua toh balance negative show hoga matlab paise jayada aa gaye"
{Dr/Cr. wale column mein formula lagayenge - =if(cell reference0,"Cr","Dr")
Say if i have more than 1000 customers, i will still be able to create that many sheets right?
You can this sheet in office 365, in office 365 you can easily make auto updated drop down list
@@Excel4Freshers how can we make this drop down list in Excel.?
Check this out - th-cam.com/video/7DT1bvSUqAU/w-d-xo.html
Hlo sir I need help
Please bataiye kya help kar sakta hu??
एक ही पेज में बाकी amount - date दुसरे side जमा amount - date उसके बाद जोड़ घटा कायसे कारे
How can I change the currency to $ ?
Select your row>Home>in number block you will find currency option
You've used less than symbol greater then
Sheet download kaise karenge
Download Link in description
Formula error aa raha he entry karne pe or nahi to 0 shobkar raha he
video ko pura dekho or fir sheet create kro error nahi aayega!!
Bhai formula nhi work kr rhe
Sir agar 100 se uppar entry Hui tou
Aap isko Financial year wise banao, or agar 100 se uper jati hai toh Jane toh aap apni entry karte raho
2.30 MIN MEI CTRL + T HEI D NAHI
Hii
7:21 me konsi key dabayi h ??
Simply select Kiya (Dr.)-(Cr.)
@@Excel4Freshers ye toh krlia bhai ...jo row select krte h jo sabme 0 nahi aati likhi hui
wo drag and drop option use kiya hai, wo isko drag karoge toh formula niche bhi apply ho jayega
Sar formula samajh Nahin a Raha please fir se bata dijiye likh kar
DR/CR -
For Creditor = IF(CELL>0,"CR","DR")
For Debtor = IF(CELL>0,"DR","CR")
Thanks sir
Thanks sir
BHAI SIKHA RHE HO YA KHUD WORK KR RHE HO BHUT FAST KR RHE
Please send me download password We will practice
Button galat btata ha ye
Kya galat bataya hai bhai😐🥲
VBA coding
Nahi bhai only formula use Kiya h
@@Excel4Freshers is sheet me discount formula lagana ho to kaise lagayenge customer wise plz helf