How to Maintain Customer Ledger in Excel (Hindi)

How to Maintain Customer Ledger in Excel (Hindi)
In this video you will learn how to create a customer ledger in Microsoft Excel. After watching this video you will not need any kind of accounting software for maintainig the ledger of the customers. You can maintain it in Excel very smartly.
So watch the video and let your love go as usual.
Downloading link:
drive.google.c...
Formula used in the video:
1. If Function
• If Function in Excel i...
2. If Function with multiple conditions
• If Function in Excel W...
Most popular videos on Stock Management System:
1. Stock Management in Excel
• Stock Management in Ex...
2. Stock Management in Excel Part 2
• Stock Management in Ex...
3. Stock Management in Excel Part 3
• Stock Management in Ex...
4. Stock Management in Excel Part 4
• Stock Management in Ex...
5. Stock Management in Excel (Hindi) | Without Macro
• Stock Management in Ex...
6. Stock Management in Excel (Hindi) | Inventory Management System in Excel | Stock Register
• Stock Management in Ex...
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#customerledger
#powerxbyjitendra
#excel
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.

[@abdulsiddiqui4604]

Sir ji I am working As Accountant. Above format is become very very useful to me.Thankyou very much sir. Please upload petty cash book sheet also.

[@baharali7429]

Good Job Sir Ji Achi Tarah se samjhaya Sir

[@BISWAJITROY-pc9mg]

Best Vdo ... thank you DADA...ahsei aur Vdo banai e ...pls

[@yomisodiq3340]

Well done, sir. You have really done a great job.

[@shantilalrajput8708]

V.Useful Sir Thank You Sir 🇮🇳🇮🇳🇮🇳

[@PowerExbyJitendra]

Thanks

[@Dev_6171]

Thanks brother. Your format is become very useful for me. Thanks a lot brother

[@ariyaantanjir7404]

Thanks a Million Sir

[@PowerExbyJitendra]

Thanks Ariyaan ji

[@sunnyhoodaoptiontrader0007]

Grt..100 video k baad ek dhang ki video mili h

[@kashifqasim8069]

Great

[@nagarojoshpk3139]

It's really feel worthy watching your video. It is simple in explaining and better in understanding. Thanks for your video. Keep uploading more. 👍

[@PowerExbyJitendra]

We would like to thank you very much for watching our videos.

[@haroonhusseini9330]

I love you sir from Afghanistan 🇦🇫, the most easy well teaching video ever seen in the past.🥰🥰🥰🥰

[@PowerExbyJitendra]

Dear Haroon, A lot of love to you too.

[@6070avm]

Thank you sir - நன்றி ஐயா

[@MohammadAhmed-rx8tg]

Well explained your effort I got four classes by online about explain in proper way. Ledger subject

[@rafisiddique9955]

Great Work Sir

[@abdulghaffarasi6649]

very nice and easy way to understand all things, Stay Happy dear

[@PowerExbyJitendra]

Thanks

[@PowerExbyJitendra]

Thanks for your wishes

[@akram01010]

Thank you so much very helpful 🎉

[@PowerExbyJitendra]

Welcome

[@ompalchaudhary4370]

This is power ful video 👍

[@dipamsahu6825]

Well explained. Thank you for your effort. But one thing I noticed that you put "if" clause for Dr. & Cr. that is wrong. If the value is >0 then it is Dr. If

[@mahtajsingh296]

If all explain here baby so we lose our tution fee 😘

[@bapithehope]

Sahi pakde😆

[@ompalchaudhary4370]

This is power ful video sir👍👍

[@PowerExbyJitendra]

Thanks Ompal ji

[@skrental-pd2ig]

party ka bill debit main likhna hai jo party nay paisay diye hain wo credit main likhna hai. agar debit ki amount ziada hai to dr aye ga agar amount kam howe to cr aye ga ple reply

[@saleeshapkannur9910]

Very good teaching

[@PowerExbyJitendra]

Thank you 🙏 sir

[@deepakdalal8731]

Great work sir jii 👌👌👌👌

[@PowerExbyJitendra]

Thanks Deepak ji

[@d.subrat9947]

Well explained

[@PowerExbyJitendra]

Thanks

[@nareshmaneji8122]

Agar 100 logo ki banana ho to har bar click karna hoga kya. Account balance ke liye index wali sheet me. Agar ha to iska koi formula nhi hai kya.

[@skrental-pd2ig]

sir debit ki amount ziada hai to dr aye ga na agar kam hai to cr aye ga ple reply

[@jamshediqbal7113]

Sir How to Connect Cash Book with Ledger ??? please Muj se Aksar Ghalat Jaga Pr Entry Ho jati ha Pir Dondna Parta Ha

[@understandthewordsfeelthes3036]

👍

[@u.s.bishwas9911]

300 ledget ko maintain hai to kya ek sheet me ho jayega

[@navyapanwar4760]

Good job👍👍

[@PowerExbyJitendra]

Thanks ji

[@MrKaushikbhar]

good one but can it be in one sheet by selecting customers name from list box. i mean there will one ledger sheet. we can select the customer name from list box and get data.

[@atlanticwork2119]

This file download but not worked 😏 Ur video useful IAM creating

[@ghulamullahkhan597]

Sir for example we start new business opening balance is 50 lac how to maintain in excel etc.

[@kmprachi4561]

Good 👍👍👍

[@PowerExbyJitendra]

Thanks 🙏

[@vanshpanwar2861]

Nice Bhai

[@PowerExbyJitendra]

Thanks ji

[@lokenathsarkar9076]

Sir,apka video Acha tha ,but up video pe all daily cash value nehi dekhaye .... 🙏Up please video me all customers kO daily cash collection total value kitne Huya dekhaye.

[@user-zf3ww2hx6k]

Pivot table plz

[@jitendrapatel3897]

Nice

[@PowerExbyJitendra]

Thanks Jitendra ji

[@bapithehope]

Sir agar humein kisi k pass se paisa lena hain to wo humare debtors huyein to Dr/Cr mein Arnab traders k last mein (Debtors) Dr ana chahiye tha

[@kkapadia25]

Have you made this type of ledger account which is created through coding? Only have to add the name of the customer in the single sheet, as and when added a new customer name in the sheet, automatic added new customer ledger.

[@pervezkhn]

how to make trial balance profit and loss balance sheet cashflow from invoice in automatically

[@rabiroy8693]

Debtors also show debit balance

[@hanumanpatodiya3744]

Sir mere ho ye bena hu mil sakta he kya

[@basavarajbasanaik3747]

Sir petrol pump cr sales customer leaders and stock management summary deatils excel acconts

[@sidrajaved7790]

Sir apse kch puchna ha, bat ho skti ha?

[@farjanaakter8093]

Vaiya ap Excel ki Jo officeal Kam ha o sab dekhana

[@deepakarya9512]

It is indeed a very useful video for an accountant but there exists small mistake at showing Dr and Cr balance. Debit balace is shown as "Credit" and Credit balance as "Debit". It should be reversed.

[@PowerExbyJitendra]

Sorry for the mistake

[@afsalnaha3218]

Dear sir Mistake is being happened. All customer balance is debit.

[@svs20081963]

Your debit and credit are wrong, debtors greater than 0 , are debit balance. Please correct accordingly.

[@md.nadimali1280]

p

[@vijaykadu3509]

Not explain well....Plz detail formulas explain sir

[@TariqDewateringServices]

Ye sheet computer chal rahi haior computer pe bana kar oppo android min send karen to ye farmule Kam nahin karty ?????? This video links kzbin.info/www/bejne/nl68lad3druhfrs

[@apnamalakwalinfo505]

sir all your vidio is copied by Mr bot

[@kansingh5968]

Nice

[@PowerExbyJitendra]

Thanks Kan singh ji

[@viswasbhujel9146]

Great work😀

[@PowerExbyJitendra]

Thanks Biswas ji