How To Create Day Book In Excel – छोटे से छोटा या बड़े से बड़ा कोई भी बिज़नेस मैन हो दोस्तों Day Book Maintain करने की जरुरत तो सबको होती है जिसमे डेली के लेन देन का हिसाब किताब होता है की किस किस सोर्स से हमारे पास कितना पैसा आया सोर्स का मतलब गूगल पे से कितना आया फ़ोन पे से कितना आया कार्ड से कितना आया और कॅश में कितना आया और किस किस सोर्स से हमने कितना पैसा किसी को दिया और फाइनली कितना हमारे पास बैलेंस बचा
अब Excel Me Day book kaise banaye अगर आपको एक्सेल की ज्यादा नॉलेज नहीं है तो आपके मन में एक सवाल जरूर टिक टिक कर रहा होगा की How To Create Day Book in Excel तो इस पोस्ट में हम आपके साथ Excel की एक वैरी सिंपल एंड फुल्ली आटोमेटिक Day Book Repot शेयर कर रहें हैं जिसको आप खुद भी आसानी से बना सकते हो और मेन्टेन भी कर सकते हो
इस Day Book Report का डेमो आप वीडियो में देखिये और वीडियो टुटोरिअल में हमने स्टेप बाय स्टेप बताया है की Excel में फुल्ली आटोमेटिक Day book kaise banaye और आप इस Day Book Format को Download भी कर सकते हो वीडियो के नीचे लिंक दिया हुआ है
Video Tutorial
Main Points of This Day Book
- इस डे बुक में टोटल ३ शीट हैं Receipt / Payment / Day Book
- रिसीप्ट / पेमेंट/ डे बुक शीट में सीरियल नंबर एंड डे की एंट्री नहीं करनी। डेट की एंट्री करते ही सीरियल नंबर एंड डे आटोमेटिक आ जायेगा
- हमारे पास जो पैसा आया उसकी एंट्री रिसीप्ट शीट में होगी और हमने जो पैसा किसी को दिया उसकी एंट्री पेमेंट शीट में होगी और डे बुक शीट में सारा काम आटोमेटिक होगा जिसमे आपको डेली बैलेंस के साथ साथ फाइनल बैलेंस भी दिखाई देता रहेगा
- इस डे बुक में आप पुरे एक साल की एंट्री कर सकते हो
- रिसीप्ट / पेमेंट / डे बुक शीट में सर्च का ऑप्शन है आप किसी भी डेट का कम्पलीट बैलेंस चेक कर सकते हो की किस डेट हमारे पास टोटल कितना पैसा आया कितना गया और कितना बैलेंस बचा
- किस किस सोर्स से कितना पैसा आया कितना हमने दिया ये भी समरी रिपोर्ट में दिखाई देता रहेगा
Formulas Used To Create This Day Book Report
इस डे बुक को बनाने के लिए इन फ़ॉर्मूलास का यूज किया गया है
- Sum Formula
- Sumif Formula
- Vlookup Formula
- Iferror Formula
वीडियो में सब कुछ स्टेप बाय स्टेप बताया है मुझे उम्मीद है दोस्तों वीडियो देखने के बाद आप आसानी से इस डे बुक रिपोर्ट को बना सकते हो और हमारी इस Stock Inventory Management Excel पोस्ट को भी जरूर पढ़े इसमें बहुत कुछ नया आपको सीखने को मिलेगा
और हां दोस्तों हमारे YouTube चैनल को आप जरूर सब्सक्राइब कर ले वहां पर हम आपके लिए नए-नए एक्सेल के काम आने वाले वीडियोस अपलोड करते रहते हैं
कृपया हमे बताई कि हमसे फोर्मुला गलत लगता ऐसा क्यू होता है i हम आपके जैसाही फोर्मुला लागते है
आप कोनसा फार्मूला नहीं लगा पा रहे हैं lakhichand G
Automatic Serial Number ???
NOT ABLE TO DOWNLOAD
Hello sir
This file dose not working its look like currepted
Hi Abdul G,
File is working properly, i have checked it.
and What exact issue you are facing on your side ? and which excel version you are using ?
Here some one error when open file is blank
Thank You so much sir for your guidance
hi Nice Sheet,
But how can we mange balance in case we are deposit cash from cash account to bank account?
I wached your YouTube channel and I have been trying to learn like you excel
mai jaise hi date mai 1/4/2021 dalta hu to day mai day nahi aata same date aajati hai. aisa kyu?
plz video dhyaan se dekho aap
Excel me head wise expenditure kaiese banaye.
Thanks, bro its was amazing work for peoples
Apka day report formula bhaut acha laga..
Please mujhe excel sheet send kijiye
Please download link Day book report in excel
kya hamare liye ak software bna skti h apki team
Thank you for sharing excellent informations. Your website is very cool. I am impressed by the details that you have on this web site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for more articles. You, my friend, ROCK! I found simply the info I already searched everywhere and simply could not come across. What an ideal website.
I just couldn’t leave your website prior to suggesting that I actually enjoyed the standard information an individual supply on your visitors? Is going to be back steadily in order to check out new posts.
Really nice style and great subject material, nothing at all else we require : D.
Every sentence is infused with excitement — incredible work!
I appreciate how thorough and well researched this is.
This post completely blew me away — absolutely phenomenal!
You always bring a unique and valuable perspective.
This post is bursting with value — amazing!!
You’ve got an amazing ability to simplify things.
You’ve made this topic far more approachable.
This was one of the best reads I’ve had in a while.
I’m consistently impressed by the quality of your work.
You’re bringing fireworks with posts like this — impressive!
This was inspiring and genuinely enjoyable.
Your ability to excite readers is unreal — fantastic job!
Your perspective on this topic is so valuable.
Your writing is consistently high quality.
Your advice is spot-on and has already given me a new way to approach things. I cant wait to put these tips into action!
Thank you for expressing this so clearly.
I appreciate how genuine and insightful your writing is.
Your excitement is absolutely contagious — great writing!
This post really exceeded my expectations.
You have an incredible ability to inspire and excite!
This is exactly the energy I needed today!
This was such a well-structured and thoughtful read.
Such an uplifting and electrifying read!
You communicate ideas with so much ease and clarity.
I’m genuinely hyped after reading this — incredible!
This is why I love following your content.
You’ve outdone yourself — what a fun read!
This made me feel so motivated — thank you!
This is exactly the energy I needed today!
This was such a pleasure to read — excellent job.
point resonated strongly and was presented beautifully. It is remarkable
Mind-blowingly good — keep these coming!
Hey! Would you mind if I share your blog
with my facebook group? There’s a lot of people that I think would really appreciate your
content. Please let me know. Thanks
you can share ✔️
What a wonderfully written and informative post.
This is the kind of writing that keeps readers coming back — excellent!
Your content always brings fresh insight.
So many great insights packed into one post.
I appreciate how engaging and informative this was.
This is one of the most exciting posts I’ve read in a long time!
This added so much value to my day — thank you!
This article bursts with life and inspiration — beautiful!
This was overflowing with positivity and energy — loved it!
Your voice is so lively and fun — amazing work!
create an experience that feels both educational and inspiring. Every
Comment 286: This blog post is truly outstanding and provides such a
finish because the clarity, structure, and passion in your writing
point resonated strongly and was presented beautifully. It is remarkable
Your energy is a breath of fresh air — fantastic post!
You have a real talent for breaking down complex ideas.
This had so much spark and energy — WOW!
I appreciate the positive energy you bring to your posts.
This is the kind of content that wakes people up — amazing work!
This was such a well-crafted article.
This is the kind of content that keeps me coming back.
This was both insightful and enjoyable — perfect combination.
So lively, so engaging, so well done — amazing job!
This is the kind of post that sticks with you — amazing!
This post is ALIVE — phenomenal writing!
Your ability to communicate ideas is exceptional.
What a wonderfully written and informative post.
I learned so many new things from this article.
I admire the clarity and depth in your writing.
Seriously HIGH-VIBRATION content — amazing job!
You always give readers something meaningful to take away.
You’ve beautifully expressed ideas many struggle to articulate.
You’ve turned this topic into something thrilling — impressive!
I appreciate how thorough and well researched this is.
You consistently offer such high-quality information.
Wow!! I’m honestly amazed by how good this was!
Absolutely brilliant — I’ll be bookmarking this!
Such a lively, powerful burst of content — awesome!
Your enthusiasm transforms every topic — incredible writing!
Fantastic breakdown. I learned so much from this.
This was beautifully written and easy to follow.
Such a spirited, exciting perspective — loved it!
You write with so much intention and clarity.
This was brilliant — thank you for sharing it.
I always look forward to your next article.
Everything about this post screams passion — incredible work!
Your energy in this post is infectious — LOVE IT!
This was such a meaningful and insightful post.
This post has such an exciting rhythm — I loved it!
I’m seriously impressed — this post is next-level!
I appreciate how genuine and insightful your writing is.
The energy here is unmatched — you crushed it!
I genuinely look forward to your content every time.
Such a powerful and well-written post.
You’ve injected so much enthusiasm into this — amazing!
I can’t get over how good this is — seriously impressive!
You always bring clarity to confusing subjects.
Your attention to detail really shines through.
You’ve turned a complicated topic into something enjoyable.
I gained so much clarity from this article.
You absolutely nailed the tone — energetic and sharp!