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

КОМЕНТАРІ • 43

  • @rajsahu8900
    @rajsahu8900 2 місяці тому

    VERY USEFUL VIDEO FOR ALL

  • @Seriously_Busy_in_Patna
    @Seriously_Busy_in_Patna 10 місяців тому +4

    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???

    • @PowerExbyJitendra
      @PowerExbyJitendra  10 місяців тому +1

      Contra entry is recorded on both sides.

    • @Seriously_Busy_in_Patna
      @Seriously_Busy_in_Patna 10 місяців тому +1

      @@PowerExbyJitendra yes ,both side but how it will indicate automatically for a particular entry in an excel sheets?

  • @brandsmerkez
    @brandsmerkez 5 днів тому

    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 ?

  • @kashmirvalleyTheatre
    @kashmirvalleyTheatre 4 місяці тому

    bahut hee achha hai app ka vedio appreciated your guiding

  • @goodman-it2qy
    @goodman-it2qy 10 місяців тому

    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.

  • @Shafqitmum
    @Shafqitmum 9 місяців тому +1

    Can we do it manually. Means personalized hard copy in Schools.

  • @MadhuGupta-pk7te
    @MadhuGupta-pk7te Місяць тому

    Superb 🎉

  • @golehathi3453
    @golehathi3453 14 днів тому

    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.

  • @golehathi3453
    @golehathi3453 15 днів тому

    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 ?

  • @prahladjithakor2321
    @prahladjithakor2321 10 місяців тому

    Simple, Easy and user friendly......!

  • @jamshediqbal7113
    @jamshediqbal7113 5 місяців тому +1

    Thank You Sir

  • @Seriously_Busy_in_Patna
    @Seriously_Busy_in_Patna 10 місяців тому +1

    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?

    • @PowerExbyJitendra
      @PowerExbyJitendra  10 місяців тому +1

      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.

  • @FireFuseTV
    @FireFuseTV 4 місяці тому

    Thank u sir ji

  • @jamshediqbal7113
    @jamshediqbal7113 5 місяців тому

    sir Cash Book Ko Khata Book aur Trial Balance Kesy Banayengy ????

  • @athartahir3341
    @athartahir3341 4 місяці тому

    How can we create same cashbook on google sheets, because there formatting tools don't work fully

  • @PranaySoni-l3f
    @PranaySoni-l3f Місяць тому

    Cash or bank ka closing balance alag alag kaise nikale

  • @Aman_yadavV_official
    @Aman_yadavV_official 8 місяців тому

    THANK SIR

  • @menonradhakrishnanparakkat2184
    @menonradhakrishnanparakkat2184 5 місяців тому

    Can you make the xl worksheet available for downloads.

  • @gurjassvlog7733
    @gurjassvlog7733 3 місяці тому

    Sir Google sheet main kaise banaye

  • @Virk_Vinkal_Army07
    @Virk_Vinkal_Army07 9 місяців тому

    cash book closed karna ka videobna do sir

  • @DadMuhammadktkDadMuhamma-bv1jg
    @DadMuhammadktkDadMuhamma-bv1jg 4 місяці тому +1

    Don't understand the Bank and cash column on the payment side in your day book.

    • @taxpayer8253
      @taxpayer8253 2 місяці тому

      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.

  • @Mithlesh_19
    @Mithlesh_19 5 місяців тому

    I am not able to change Date2 particulars 2 i don't know why

  • @SKumarOfficial_
    @SKumarOfficial_ 10 місяців тому

    Superb 👌

    • @PowerExbyJitendra
      @PowerExbyJitendra  10 місяців тому

      Thanks a lot

    • @user-bn1kt3fm2k
      @user-bn1kt3fm2k 10 місяців тому

      ua-cam.com/users/shortsQfH8jfLgfGA?si=LNLa8qW8XXEL4LiJ

    • @user-bn1kt3fm2k
      @user-bn1kt3fm2k 10 місяців тому

      ua-cam.com/users/shortsQfH8jfLgfGA?si=LNLa8qW8XXEL4LiJ

  • @Shafqitmum
    @Shafqitmum 9 місяців тому

    But where to enter voucher or bill number etc

  • @mjakabir
    @mjakabir 10 місяців тому

    👍

  • @surajitghosh4404
    @surajitghosh4404 2 місяці тому

    Voucher number ka ek hona chahiye