How to create day book in excel in Tamil | Receipt and payment
VERY IMPORTANT FOR JOBS. Learn it before you go for job.
formula download link
drive.google.com/uc?export=do...
For inquiries: shinuboss1@gmail.com
Instagram: Shinuboss1
#daybook #cashbook #receipts #payments #receiptsandpayments
Пікірлер: 154
Really super information sir very very useful information sir thank you sir
Tq very much sir clear explanation
@cutechinfotamil
16 күн бұрын
Thank you😀
very useful sir excellent
If you explain the formula (day for example why to put &,= and why to put 1:1 etc) that would be more useful
This video is very useful and thank you sir.
@cutechinfotamil
Жыл бұрын
Thank you ☺️
VERY USEFUL THANKS FOR VIDEO
@cutechinfotamil
2 жыл бұрын
Thank you. Keep watching
So good 😊
Thank you very much sir, lovely great you sir
excellent video. really useful. God Bless You
@cutechinfotamil
8 күн бұрын
Thanks for watching🤗
Sir na marketing field system work. Unga video usefull iriku🙏tq. Ithu related poduga sir tq
thank u sir full video pathu sheet creat pannitan romba nandri ,and then nan photostudio vachi irukuran bill receipt kudukuramathi oru method sollunga
Google sheet la ede mari epidi panrathu nu oru video podunga bro! Useful huh irukum!
Great 👍🙏
Superb Thanks...Its Really worth it
@cutechinfotamil
2 жыл бұрын
It's my pleasure
SUPER SIR ,HOW TO INSERT MISSED PAYMENT
very use video thank you
@cutechinfotamil
16 күн бұрын
😃
Good Learning Bro
@cutechinfotamil
3 жыл бұрын
Thanks for the visit bro.
Sir interest calculation eppadi potrathu konja video podunga
Thank you. Brother. Nice Explanation about the creation of Daybook, Receipt & Payment book. It was very useful for me. how to create the ledger from this. Do you have anyother postings for that...
THANK YOU VERY MUCH
@cutechinfotamil
Ай бұрын
You're welcome!🤗❤🙌
NICE PERSENTATION..............
@cutechinfotamil
Ай бұрын
Thanks a lot👍
Hi sir. Thanks for ur info. But I still have error at Day book at the row date. Try many time also still same error . Don't knw at where the error. Follow step by step but still same. Pls help to solve it.
GOOD JOB.KEEP IT UP.
@cutechinfotamil
16 күн бұрын
Thanks, you too!
Apka all video good
Thank you sir
@cutechinfotamil
2 жыл бұрын
Welcome
Sir reciept sheet la mela summay-receipt method la formula apply pannomla atha drag panni down panna correct ah varla sir.ex.Google pay oda total value ₹1500 but calculating only 500 than varuthu...enna reason sir..please answer me
வாழ்த்துக்கள் சார் இதையேதான் சாப்ட்வேர் ன்னு ரொம்ப பணம் வாங்குறாங்க
Very useful sir thank you so much for your service. Ennoda office ku oru sila Excel sheet create pannanum sir.ungala contact epdi panradusir
Sir nan google sheets la nenga Sona madri use paninen athula date column la date format change pana month varala then orey month iruka datas add aga matengthu, pls help me
God bless you
@mirunav3098
2 жыл бұрын
SIR, BALANCE AMOUNT INSTANT A 0(ZERO) THAN VARUMA
சார் பைனாஸ்க்கு இது மாதிரி data போடலமே pls
Anna workers ku daily wages poda xl sheet redy pana video podunga
Dear sir, enakku day book la ulla vlookup formula work akala sir amount kaattala
how arrive between two dates or two months in the same manner..pls..
Sir,36:07 la enakku #N/A nu varudhu,if error kudutha blnk ah varudhu. Enna seiyanumnu konjam sollithaanga,sir Sir,please give reply
நீங்கள் ஏன் அந்த XLS File யை இங்கு இணைக்கவில்லை சகோதரா?? பொதுவாக அனைவரும் பயன்படுத்த எளிதாகவும் இருக்கும்..!!
couple of Payments, or receipt in one date seems the formula does nt work individually,plz slove this
Super
Anna oru 5 company irruku aduku invoice automatic change aukanum Ana ippa oru company la invoice no 10 iruninda verra company ku bill podumpodum podu 11 change aukanum new invoice button press panuna But ellam company um thanithani sheet anna Appadi change panna mudiummma anna
Sir receipt book i used the formula but the formula is error =IFERROR(SUMIFS(Table2[AMOUNT],Table2[DATE],">="&F4,Table2[DATE],"
Super bro Can you able to create as mobile app
Bro itha one day ku Pana mudiuma ..means one day la matum ivlo transaction varuthuna epdi pananum
Bro gold finance ku use panra mari ready pannunga bro adaku kadaiku
Sir I have made a system same like this. There monthwise total showing without the sum of 31 of October month. Why does excel leave it sir? Please explain it. If possible please give me a contact no what's app
I want ledger trial balance vedios sir
Error varum nu sonlngala sir athula error vanduchu after extras add pannaparagu blank ah varudhu
இதுவரை பார்த்த exel வீடியோவில் இந்த மாதிரியான விளக்கம் யாரையும் பார்த்ததில்லை sir வாழ்த்துக்கள். God bless you
@cutechinfotamil
2 жыл бұрын
mikka magilchi.
Thank you sir i created like this day book but i can not include opening balance and closing balance how to add opening balance ? if you can tell me please
Good bro
@cutechinfotamil
Жыл бұрын
Thanks
How to Captitalise first letter of each word automatically in Excel
Is this what version of excel sir
நெல் ஆலை மில் system work பண்ற. Athu related excel sheet solug
Sir I want ledger and Tv vedios pls send vedios
Kindly post cash book for lorry loading and unloading
How to make cheque deposit (cash) and Seles credit
How to make opening balance
சார் cooperative jewel register pidunga sir excel
How to make a selling buying sheets
Tanks bro nigea puriyamatheri karatta teech panregea
@cutechinfotamil
3 жыл бұрын
Thank you bro. Keep watching.
formula lam epdi kandu pudikiringa?
sir Day book to Receipt Amount error how to mac
Bro pls Corel draw video
Sir ennaku day irundhu date ku close agamattuthu sir
Early iam waiting this video tq bro
@cutechinfotamil
3 жыл бұрын
Thank you for your first comment. Keep watching.
வணக்கம் சகோ, எனக்கு excel லா project லா கொஞ்சம் ப்ரோப்லேம் இருக்கு ப்ளீஸ் உதவி பண்ணுங்க. Right and left concept - number of cells erukum antha values default illa random than varum condition kodutha athuku etha matri values varum. For an example A B C D E F G intha 7 cells la A and G ( first and last value addition pani varanum ) athu matri B and F cells , C and E cells - first and last cells value addition pananum. Important ah remaining D matri middle cells vanthalum antha cells value eruntha matri erukanum intha value addition or separation pana vendam atha value show ahnale pothum. Nan keta matri first and last cells value addition panite varanum erukura cells ellathukum, last ah oru cells matum erukumethu antha value show ahnale pothum intha condition orey formula venum bro please.
@cutechinfotamil
3 жыл бұрын
insta la message pannunga. or mail pannunga bro.
My system cannot be accessed window
Sir cash book maintenance pls tamil
Please upload journal ledger credit record in excel
@cutechinfotamil
3 жыл бұрын
Upload as early as possible.
In what version did you made this? Will it work in windows 2007?
@cutechinfotamil
2 жыл бұрын
Yes. It will work 👍. Ms office 2007 version
@BoynamedlikeMMVSAN
Жыл бұрын
Not working
sir company 3or 4 bank use panaram intha method epti data entry panrathu.
@cutechinfotamil
3 жыл бұрын
Description la bank name kudukkalam. additional column add panni neinga use pannalam. Niray way irukku. Try panni parunga. It will definitely work. Thank you.
How to check the date
Sir Please insert onc column for writing narration
@cutechinfotamil
2 жыл бұрын
You can add with it sir.
Bro neenga sonamari receipt bood create pana start panen but date enter pana serial no and day varamatikuthu bro
@cutechinfotamil
2 жыл бұрын
Forumla correct ah apply panniruka ennu parunga
Dear sir how to ad 31.3.opening balance cash, A/c
College day, month samry Excel sheet solluga
Bro I got it
@cutechinfotamil
2 жыл бұрын
ok bro
Daybook month format not working
❤🎉
@cutechinfotamil
5 күн бұрын
💖💖
Monthly change Details pl
Sir s.no, day correct a varuthu but date enter panuna thirumba day column la date varuthu sir ena pantrathu
@cutechinfotamil
Жыл бұрын
Procedure correct ah follow panni pannunga. Correct ah varum mam
Please make a video Data Entry in a single sheet with search options
Date epdi check pani correct pandrathu video podunga bro I need thatpls
@cutechinfotamil
2 жыл бұрын
sure
@jaikarthik2279
2 жыл бұрын
Bro again problem .. Day book la elam create panne only aug 23 to aug 27 2021 .. Receipt amt formula pana daybookla poitu elam panne but 0 nu varuthu yen theriyala bro
Can u explain about to create this in Google sheets
@Shaikh.Muhammad786
Жыл бұрын
Yes please!
Enaku hyperlink agala bro
Software kitikkuma sri pl
How to use the "Form" facility with this?
Sir please sent me excel sheet .
Bro summary la cash, card ellam correct amount vanthutu but cheque amount varala Na Ellam select panitan but varala why sollunga Bro
@cutechinfotamil
3 жыл бұрын
Eathavathu mistakes irukkalam. Careful ah pathu pannunga. Correct ah varum. Nan ellam check pannitu than poturuken. Try again. You will get it. Thank you.
@SEsakkimuthubba
3 жыл бұрын
@@cutechinfotamil hmm ok Bro aprm neenga yen formula va type pandringa athu seriya purila soo nénga formula la poi formula va click panni box mari varuma athula solli kudunga Bro plzzzz
@cutechinfotamil
3 жыл бұрын
@@SEsakkimuthubba Ok bro. Single formula enna ok. Sometimes multiple formula use pannumpothu Sariya idea illathavanga confuse pannikuranga. I will consider your suggestion. Thank you.
@SEsakkimuthubba
3 жыл бұрын
@@cutechinfotamil Bro number kidaikuma
@SEsakkimuthubba
3 жыл бұрын
Tally pathi vdieos potturukingala Bro
B.com students ku use aguma?
@cutechinfotamil
3 жыл бұрын
Kandippa use agum. Works ku romba important. Make use of it.
@gunavathigunavathi5932
2 жыл бұрын
Bro formula romba lengthy so how to handle pls help me
Bro bba ku use aguma
@cutechinfotamil
3 жыл бұрын
kandipa use agum
@Romeo_chiloo
3 жыл бұрын
@@cutechinfotamil Tqsm bro... Tnpsc grp 4exam Epo Varum bro ethachum update vandha Solluga bro
@cutechinfotamil
3 жыл бұрын
@@Romeo_chiloo sollalam
Hi sir date type panna day thappa varudhu
@cutechinfotamil
2 жыл бұрын
Check your computer date and time
Sir enaku day laum date than katuthu
@cutechinfotamil
Жыл бұрын
Video sollirukkura padi pannunga mam. Correct ah varum
2023 to 2024 day book
Sir I need this excel sheet please send your contact details
Not working day book
@cutechinfotamil
2 жыл бұрын
It will work. You would have done errors.
@vj6735
2 жыл бұрын
@@cutechinfotamil day book is date enter பன்னுனா பணம் கம்பிக்கமாட்டினுத்
@vj6735
2 жыл бұрын
@@cutechinfotamil day bok மட்டும் 0 வில் இருக்கு என்ன பன்ன வேண்டும் அண்ணா
Ena problem theriyal
@cutechinfotamil
2 жыл бұрын
ok
❤ give me plz
Thanks bro. ஒரு கேள்வி; ஒரே நாளில் பல amounts வந்தால் அதனை எப்படி பதிவு செய்வது? உதாரணமாக : ஏப்ரல் மாதம் 01ஆவது திகதியில் வரவுத்தொகையாக வீட்டு வாடகை - 10,000ரூபாய் வாகன வாடகை - 5,000ரூபாய் மாதச் சம்பளம் 60,000 ரூபாய் இப்படியாக ஒரே நாளிலேயே பல வரவுகள் வருகின்றபோது அதனை எப்படி பதிவு செய்வது? அப்படி பதிவு செய்யும் போது ஏப்ரல் மாத முழுமையாக எப்படியான மாற்றங்களை செய்வது. அதேபோன்று ஒரே நாளிலே பல செலவுகள் வருகின்றபோது அதனது பதிவுகளையும் எப்படி செய்வது தொடர்பாகவும் சற்று விளக்கமாக கூறலாமா??
@cutechinfotamil
3 жыл бұрын
very simple. just enter the same date again and again to enter details.
@RazeenAkbar
3 жыл бұрын
@@cutechinfotamil Thanks again.🤝🤝 I'll try
@cutechinfotamil
3 жыл бұрын
@@RazeenAkbar ok