Fully Automated Cash Book in Excel Hindi | Day Book in Excel
Вставка
- Опубліковано 28 сер 2024
- Fully Automated Cash Book in Excel Hindi | Day Book in Excel
Learn how to create a basic cash book in Excel with this step-by-step tutorial. In just a few minutes, you'll discover how to set up a spreadsheet to record your income and expenses, manage your finances, and keep track of your cash flow. This easy-to-follow Excel tutorial is perfect for beginners and small business owners looking for a simple way to manage their money. Start organizing your finances today with this practical Excel cash book guide!
✅For more videos please subscribe our channel: / powerexbyjitendra
Sample workbook:
==============================
docs.google.co...
==============================
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.
#cashbookinexcel
#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
VERY USEFUL VIDEO FOR ALL
Thanks 🌹🙏🙏
Ok Sir , Thank you so much for yours reply.
one more thing i would like to ask regarding contra entry
Can we show "C" in created Cash-Book for Deposits & Withdrawals???
Contra entry is recorded on both sides.
@@PowerExbyJitendra yes ,both side but how it will indicate automatically for a particular entry in an excel sheets?
Mujhe formula lagana ha k mein filter kru *cash Received* or mere ps balance mein only cash received wali values ka hi Balance show ho rather than all ledger values ?
bahut hee achha hai app ka vedio appreciated your guiding
Thanks a lot
Sir, you made it too good for maintain cash, bank & expenses entries at cash book. Sir, One thing are also required too much each and every cash, bank and others expenses entries separately create ledgers. Sir, do its I need it very much please.
Can we do it manually. Means personalized hard copy in Schools.
Superb 🎉
Thanks 🙏🙏
Hello dear,aapki banai hui cashbook ko agar laser se canect kana ho to vo sikhye n ge.jaize sonu mart ka pement received me daltehi apne aap sonu mart ke laser me jama ho jaye. Esa har a/C. E ho.
DEAR YOUR CASH BOOK FORMET IS WANDARFULL BUT CAN YOU ADD ON AUTOMETIC IN EVERY ENTRY IS AUTO SIFT IN PARTYCULAR HIS LASER TEACH IT ?
Simple, Easy and user friendly......!
Thanks a lot
Thank You Sir
Dear Sir, Myself Ravinesh Kumar and I wish to have day to day home expenses in Micro enabled google sheets. i have created in excel sheet but stop working when I upload it into google sheets.
So, please tell me how i can create Micro enabled Cash-Book in google sheets?
If you have added an Excel file to Google Drive or have converted an Excel file into a Google Sheets document, the macros in the Excel file WILL NOT work.
Thank u sir ji
Welcome ji
sir Cash Book Ko Khata Book aur Trial Balance Kesy Banayengy ????
How can we create same cashbook on google sheets, because there formatting tools don't work fully
Cash or bank ka closing balance alag alag kaise nikale
THANK SIR
welcome
Can you make the xl worksheet available for downloads.
Yes this is available link is in description
Sir Google sheet main kaise banaye
cash book closed karna ka videobna do sir
Don't understand the Bank and cash column on the payment side in your day book.
Let say you have 50000 in your bank. But you have to make payment of 40000 in cash to someone. You cannot make that payment as you don't have any cash jn hand. So first withdraw the amount from bank then make 40000 payment in cash.
This segregation is important to keep track of wheather you have enough cash in hand to make payments or not.
I am not able to change Date2 particulars 2 i don't know why
Superb 👌
Thanks a lot
ua-cam.com/users/shortsQfH8jfLgfGA?si=LNLa8qW8XXEL4LiJ
ua-cam.com/users/shortsQfH8jfLgfGA?si=LNLa8qW8XXEL4LiJ
But where to enter voucher or bill number etc
👍
Thanks 🙏
ua-cam.com/users/shortsQfH8jfLgfGA?si=LNLa8qW8XXEL4LiJ
Voucher number ka ek hona chahiye