Fully Automated Customer Ledger in Excel | Automate Accounting Bookkeeping and Ledger in Excel

Fully Automated Customer Ledger in Excel | Automate Accounting Bookkeeping and Ledger in Excel
In this video tutorial you will learn:
1. How to create a customer ledger in Microsoft Excel
2. How to ceate a customer ledger summary that too in such a way that if there is any entry in any customer ledger or if any new customer is added, then it gets automatically added to the customer ledger summary.
3. How to use Power Query for process automation
✅For more videos please subscribe our channel: / powerexbyjitendra
Sample workbook:
==============================
docs.google.co...
==============================
Power Query Playlist:
• Advanced Excel Power Q...
----------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
8. Best Excel Shortcut Keys
• Best Shortcut Keys in ...
9. Power Query Tutorials
• Advanced Excel Power Q...
10. MIS Report in Excel
• MIS Report
11. Excel PivotTable
• Excel Pivot Table
-------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#accounting_in_Excel
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexby...
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.
Thanks

[@RohitKumar-uy7cx]

Wow 😲 sir bahut hi helpful video hai sir, Sir Power Quarry from basic to advanced level tak sikhaiye🙏

[@PowerExbyJitendra]

Please check out Power Query playlist.

[@subramanig3564]

What about sales account and bank account? Use macros and create form. So that it will be easy

[@vishnuarrawatia6451]

Excellent sir, keep it up

[@PowerExbyJitendra]

Thank you so much❤

[@AVTARSINGH-qq7xn]

Sir please make video for NGO software where we can find all data like trial balance, balance sheet, daily ledger etc

[@FaheraliAli-eg2fl]

Sir g love you from🇵🇰❤️abe ap ke receivable wle vide dkhe ha kamal sir ❤ allah ap ko seyat r tandruste da 💞💞💞💞💞❤️❤️

[@PowerExbyJitendra]

Thank you so much❤ bro

[@alokanand571]

Nice video sir, sir kon sa ms office use karu. Please bataye

[@PowerExbyJitendra]

I am using office 2019

[@ekanshagarwal9003]

not able to apply this querry formula in google sheet

[@aakashchandel813]

Sir aap mere ko sirf yek hi seat ke adhik contactor ke summary nikal kar batayenge kya plz sir

[@kajalthakkar2070]

Es mei GST or TDS k entry kaise banayei gei.. for example mera bill GST k sath 18000 ka bana hai but party muje 2% TDS cut kar k chaque degei to us ka ledger kaise banaye...

[@ArmanKhan-te6xf]

How to the points

[@ArmanKhan-te6xf]

Sir power query windows me close & loded karte samay debit and credit for balance wrong ho ja rha hai iska koi upay hai

[@top5handicraft142]

how to manage debit credit ledgers when i sold any items . and suppose
1 client name is. XYZ purchage ₹500 and give ₹300 for deposit, then how i can manage all the his due balance and if the increases its products while purchase how i can manage all due and balance.

[@munawartariq4937]

HELLO SIR MY NAME IS TARIQ AND FROM PAKISTAN SIR I M ASKING SOME QUESTION
SIR POWER QUARRY MAY IMPORT DATA NAHI ARHA HY MAY RAY PASS KIS TRAH SAY OPEN HO GA PLEASE BATA DAIN MUJHY

[@PowerExbyJitendra]

Please click on data tab and click on get data and select option as per your data type

[@ArmanKhan-te6xf]

Sir debit credit and balance show nhi ho rha hai to kya kare

[@heselindianfoodrecipe2492]

Sir prebet report optionshow nahi kar rah hey merey computer mey kya karey

[@siraatnaqvi7901]

Ms excel 2007 mein blank query nahi mil rahi from other source mein

[@PowerExbyJitendra]

Please upgrade your version

[@ChotiKathaCasts]

sir mere company me bill amount and cash amount hota uska kaise hoga

[@ChotiKathaCasts]

Sir mere me - nhi show ho rha bracket show ho rha hai

[@ravikumarpatil5822]

My system not are all options kaise windows use for you

[@PowerExbyJitendra]

Please upgrade your Ms office version

[@sukantasaha2998]

Sir purchase entry korle automatic kaiseaaga

[@sameerabbas14]

Sir your telegram channel

[@ArmanKhan-te6xf]

Sir please help me

[@jamshediqbal7113]

Sir Kindly App Whatsap Nmber share kr sakty hn Please . Ap se Ledger k hawaly se Kuch Poochna Ha

[@aadi14hp17]

Window 10 par sir blank quiry option nhi aa rha

[@ravikumarpatil5822]

Yes it's me problem please solve the problem