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

  • @ragak3354
    @ragak33542 жыл бұрын

    Really super information sir very very useful information sir thank you sir

  • @JayaSubaVetrivel
    @JayaSubaVetrivel17 күн бұрын

    Tq very much sir clear explanation

  • @cutechinfotamil

    @cutechinfotamil

    16 күн бұрын

    Thank you😀

  • @sinnasamysivakumar1806
    @sinnasamysivakumar1806 Жыл бұрын

    very useful sir excellent

  • @manoharsagunthalla9215
    @manoharsagunthalla9215 Жыл бұрын

    If you explain the formula (day for example why to put &,= and why to put 1:1 etc) that would be more useful

  • @deeparani8020
    @deeparani8020 Жыл бұрын

    This video is very useful and thank you sir.

  • @cutechinfotamil

    @cutechinfotamil

    Жыл бұрын

    Thank you ☺️

  • @velmurugan-fr4uh
    @velmurugan-fr4uh2 жыл бұрын

    VERY USEFUL THANKS FOR VIDEO

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    Thank you. Keep watching

  • @usefultime7127
    @usefultime71272 жыл бұрын

    So good 😊

  • @marxp9722
    @marxp97222 жыл бұрын

    Thank you very much sir, lovely great you sir

  • @234Seconds
    @234Seconds Жыл бұрын

    excellent video. really useful. God Bless You

  • @cutechinfotamil

    @cutechinfotamil

    8 күн бұрын

    Thanks for watching🤗

  • @thirubhuvaneshwaris9514
    @thirubhuvaneshwaris9514 Жыл бұрын

    Sir na marketing field system work. Unga video usefull iriku🙏tq. Ithu related poduga sir tq

  • @selfiedigitalstudio9147
    @selfiedigitalstudio91472 жыл бұрын

    thank u sir full video pathu sheet creat pannitan romba nandri ,and then nan photostudio vachi irukuran bill receipt kudukuramathi oru method sollunga

  • @Shaikh.Muhammad786
    @Shaikh.Muhammad786 Жыл бұрын

    Google sheet la ede mari epidi panrathu nu oru video podunga bro! Useful huh irukum!

  • @shafi_q7
    @shafi_q7 Жыл бұрын

    Great 👍🙏

  • @niroshvijay6139
    @niroshvijay61392 жыл бұрын

    Superb Thanks...Its Really worth it

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    It's my pleasure

  • @nandagopalkumar8164
    @nandagopalkumar81642 жыл бұрын

    SUPER SIR ,HOW TO INSERT MISSED PAYMENT

  • @manikandanmanikandan-lz8yl
    @manikandanmanikandan-lz8yl9 ай бұрын

    very use video thank you

  • @cutechinfotamil

    @cutechinfotamil

    16 күн бұрын

    😃

  • @nktrendings816
    @nktrendings8163 жыл бұрын

    Good Learning Bro

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    Thanks for the visit bro.

  • @aishaish6266
    @aishaish62662 жыл бұрын

    Sir interest calculation eppadi potrathu konja video podunga

  • @johnsonkennedy2383
    @johnsonkennedy23837 ай бұрын

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

  • @arconsultancy-xd3lt
    @arconsultancy-xd3lt3 ай бұрын

    THANK YOU VERY MUCH

  • @cutechinfotamil

    @cutechinfotamil

    Ай бұрын

    You're welcome!🤗❤🙌

  • @swanthamgraphics3516
    @swanthamgraphics35166 ай бұрын

    NICE PERSENTATION..............

  • @cutechinfotamil

    @cutechinfotamil

    Ай бұрын

    Thanks a lot👍

  • @jeevanesreddy6684
    @jeevanesreddy66842 жыл бұрын

    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.

  • @user-ys8tv2tb8c
    @user-ys8tv2tb8c27 күн бұрын

    GOOD JOB.KEEP IT UP.

  • @cutechinfotamil

    @cutechinfotamil

    16 күн бұрын

    Thanks, you too!

  • @lockdown1622
    @lockdown1622 Жыл бұрын

    Apka all video good

  • @sangeethakanniyappan1586
    @sangeethakanniyappan15862 жыл бұрын

    Thank you sir

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    Welcome

  • @divyagokul4107
    @divyagokul4107 Жыл бұрын

    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

  • @jawaharraj1
    @jawaharraj12 жыл бұрын

    வாழ்த்துக்கள் சார் இதையேதான் சாப்ட்வேர் ன்னு ரொம்ப பணம் வாங்குறாங்க

  • @kajasherif2667
    @kajasherif2667 Жыл бұрын

    Very useful sir thank you so much for your service. Ennoda office ku oru sila Excel sheet create pannanum sir.ungala contact epdi panradusir

  • @semponmanickam5924
    @semponmanickam59242 жыл бұрын

    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

  • @mirunav3098
    @mirunav30982 жыл бұрын

    God bless you

  • @mirunav3098

    @mirunav3098

    2 жыл бұрын

    SIR, BALANCE AMOUNT INSTANT A 0(ZERO) THAN VARUMA

  • @balamuruganmurugan9742
    @balamuruganmurugan974210 ай бұрын

    சார் பைனாஸ்க்கு இது மாதிரி data போடலமே pls

  • @esrplay7354
    @esrplay73542 жыл бұрын

    Anna workers ku daily wages poda xl sheet redy pana video podunga

  • @jsk1810-Life
    @jsk1810-Life2 жыл бұрын

    Dear sir, enakku day book la ulla vlookup formula work akala sir amount kaattala

  • @mohanomega9713
    @mohanomega97132 жыл бұрын

    how arrive between two dates or two months in the same manner..pls..

  • @subramanianshanmugam9836
    @subramanianshanmugam9836 Жыл бұрын

    Sir,36:07 la enakku #N/A nu varudhu,if error kudutha blnk ah varudhu. Enna seiyanumnu konjam sollithaanga,sir Sir,please give reply

  • @thiagarajanelangovan4359
    @thiagarajanelangovan4359 Жыл бұрын

    நீங்கள் ஏன் அந்த XLS File யை இங்கு இணைக்கவில்லை சகோதரா?? பொதுவாக அனைவரும் பயன்படுத்த எளிதாகவும் இருக்கும்..!!

  • @shoaibshuvro4821
    @shoaibshuvro48212 жыл бұрын

    couple of Payments, or receipt in one date seems the formula does nt work individually,plz slove this

  • @saravanan-gw1zo
    @saravanan-gw1zo Жыл бұрын

    Super

  • @beast-07-tamil92
    @beast-07-tamil922 ай бұрын

    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

  • @danielgraphicdsign
    @danielgraphicdsign7 ай бұрын

    Sir receipt book i used the formula but the formula is error =IFERROR(SUMIFS(Table2[AMOUNT],Table2[DATE],">="&F4,Table2[DATE],"

  • @kt.vinothkaasi6088
    @kt.vinothkaasi60885 ай бұрын

    Super bro Can you able to create as mobile app

  • @sivarajr7460
    @sivarajr7460 Жыл бұрын

    Bro itha one day ku Pana mudiuma ..means one day la matum ivlo transaction varuthuna epdi pananum

  • @billas7808
    @billas780811 ай бұрын

    Bro gold finance ku use panra mari ready pannunga bro adaku kadaiku

  • @pagalgroups1073
    @pagalgroups1073 Жыл бұрын

    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

  • @mraguraman3062
    @mraguraman30622 жыл бұрын

    I want ledger trial balance vedios sir

  • @tamilselva5668
    @tamilselva5668 Жыл бұрын

    Error varum nu sonlngala sir athula error vanduchu after extras add pannaparagu blank ah varudhu

  • @hasanmeeran5790
    @hasanmeeran57902 жыл бұрын

    இதுவரை பார்த்த exel வீடியோவில் இந்த மாதிரியான விளக்கம் யாரையும் பார்த்ததில்லை sir வாழ்த்துக்கள். God bless you

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    mikka magilchi.

  • @asadiyyah20
    @asadiyyah202 жыл бұрын

    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

  • @thalaivar169
    @thalaivar169 Жыл бұрын

    Good bro

  • @cutechinfotamil

    @cutechinfotamil

    Жыл бұрын

    Thanks

  • @kishokkumar165
    @kishokkumar165 Жыл бұрын

    How to Captitalise first letter of each word automatically in Excel

  • @vijyakumarvijyakumar6350
    @vijyakumarvijyakumar63503 ай бұрын

    Is this what version of excel sir

  • @thirubhuvaneshwaris9514
    @thirubhuvaneshwaris9514 Жыл бұрын

    நெல் ஆலை மில் system work பண்ற. Athu related excel sheet solug

  • @mraguraman3062
    @mraguraman30622 жыл бұрын

    Sir I want ledger and Tv vedios pls send vedios

  • @obushanthi
    @obushanthi10 ай бұрын

    Kindly post cash book for lorry loading and unloading

  • @mohamedsakeer3887
    @mohamedsakeer388710 ай бұрын

    How to make cheque deposit (cash) and Seles credit

  • @ameenabdullah3713
    @ameenabdullah37132 жыл бұрын

    How to make opening balance

  • @naturewithanu5037
    @naturewithanu50374 ай бұрын

    சார் cooperative jewel register pidunga sir excel

  • @mdm4443
    @mdm444312 күн бұрын

    How to make a selling buying sheets

  • @Subashkm-xl4zw
    @Subashkm-xl4zw3 жыл бұрын

    Tanks bro nigea puriyamatheri karatta teech panregea

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    Thank you bro. Keep watching.

  • @karthickchandrasekaran6726
    @karthickchandrasekaran67262 жыл бұрын

    formula lam epdi kandu pudikiringa?

  • @YogithaArtsAdvertisingCompany
    @YogithaArtsAdvertisingCompany2 жыл бұрын

    sir Day book to Receipt Amount error how to mac

  • @VishnuKumar-bh4rz
    @VishnuKumar-bh4rz2 жыл бұрын

    Bro pls Corel draw video

  • @pradeepkumar521
    @pradeepkumar5212 жыл бұрын

    Sir ennaku day irundhu date ku close agamattuthu sir

  • @subasini6752
    @subasini67523 жыл бұрын

    Early iam waiting this video tq bro

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    Thank you for your first comment. Keep watching.

  • @mgfilmsentertainmenthindi1040
    @mgfilmsentertainmenthindi10403 жыл бұрын

    வணக்கம் சகோ, எனக்கு 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

    @cutechinfotamil

    3 жыл бұрын

    insta la message pannunga. or mail pannunga bro.

  • @vijyakumarvijyakumar6350
    @vijyakumarvijyakumar63503 ай бұрын

    My system cannot be accessed window

  • @manigandan8666
    @manigandan86662 жыл бұрын

    Sir cash book maintenance pls tamil

  • @subasini6752
    @subasini67523 жыл бұрын

    Please upload journal ledger credit record in excel

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    Upload as early as possible.

  • @manoharsagunthalla9215
    @manoharsagunthalla92152 жыл бұрын

    In what version did you made this? Will it work in windows 2007?

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    Yes. It will work 👍. Ms office 2007 version

  • @BoynamedlikeMMVSAN

    @BoynamedlikeMMVSAN

    Жыл бұрын

    Not working

  • @ambikaambi7172
    @ambikaambi71723 жыл бұрын

    sir company 3or 4 bank use panaram intha method epti data entry panrathu.

  • @cutechinfotamil

    @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.

  • @YogithaArtsAdvertisingCompany
    @YogithaArtsAdvertisingCompany2 жыл бұрын

    How to check the date

  • @krishnamurthynandhagopal9884
    @krishnamurthynandhagopal98842 жыл бұрын

    Sir Please insert onc column for writing narration

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    You can add with it sir.

  • @jaikarthik2279
    @jaikarthik22792 жыл бұрын

    Bro neenga sonamari receipt bood create pana start panen but date enter pana serial no and day varamatikuthu bro

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    Forumla correct ah apply panniruka ennu parunga

  • @vijayakumar-wc8yg
    @vijayakumar-wc8yg2 жыл бұрын

    Dear sir how to ad 31.3.opening balance cash, A/c

  • @haneefhaneef140
    @haneefhaneef14022 күн бұрын

    College day, month samry Excel sheet solluga

  • @jaikarthik2279
    @jaikarthik22792 жыл бұрын

    Bro I got it

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    ok bro

  • @radhatharuni2947
    @radhatharuni2947 Жыл бұрын

    Daybook month format not working

  • @muthulakshmi-xp2tu
    @muthulakshmi-xp2tu Жыл бұрын

    ❤🎉

  • @cutechinfotamil

    @cutechinfotamil

    5 күн бұрын

    💖💖

  • @originautomation4533
    @originautomation45332 жыл бұрын

    Monthly change Details pl

  • @sarithaagri6793
    @sarithaagri6793 Жыл бұрын

    Sir s.no, day correct a varuthu but date enter panuna thirumba day column la date varuthu sir ena pantrathu

  • @cutechinfotamil

    @cutechinfotamil

    Жыл бұрын

    Procedure correct ah follow panni pannunga. Correct ah varum mam

  • @sweetjeba1981
    @sweetjeba19812 жыл бұрын

    Please make a video Data Entry in a single sheet with search options

  • @jaikarthik2279
    @jaikarthik22792 жыл бұрын

    Date epdi check pani correct pandrathu video podunga bro I need thatpls

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    sure

  • @jaikarthik2279

    @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

  • @sivaelangovan2721
    @sivaelangovan27213 жыл бұрын

    Can u explain about to create this in Google sheets

  • @Shaikh.Muhammad786

    @Shaikh.Muhammad786

    Жыл бұрын

    Yes please!

  • @StarGold-fs4ei
    @StarGold-fs4eiАй бұрын

    Enaku hyperlink agala bro

  • @selvarajvijaya20
    @selvarajvijaya20 Жыл бұрын

    Software kitikkuma sri pl

  • @chidambaramr5176
    @chidambaramr51762 жыл бұрын

    How to use the "Form" facility with this?

  • @lockdown1622
    @lockdown1622 Жыл бұрын

    Sir please sent me excel sheet .

  • @SEsakkimuthubba
    @SEsakkimuthubba3 жыл бұрын

    Bro summary la cash, card ellam correct amount vanthutu but cheque amount varala Na Ellam select panitan but varala why sollunga Bro

  • @cutechinfotamil

    @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

    @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

    @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

    @SEsakkimuthubba

    3 жыл бұрын

    @@cutechinfotamil Bro number kidaikuma

  • @SEsakkimuthubba

    @SEsakkimuthubba

    3 жыл бұрын

    Tally pathi vdieos potturukingala Bro

  • @sri7838
    @sri78383 жыл бұрын

    B.com students ku use aguma?

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    Kandippa use agum. Works ku romba important. Make use of it.

  • @gunavathigunavathi5932

    @gunavathigunavathi5932

    2 жыл бұрын

    Bro formula romba lengthy so how to handle pls help me

  • @Romeo_chiloo
    @Romeo_chiloo3 жыл бұрын

    Bro bba ku use aguma

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    kandipa use agum

  • @Romeo_chiloo

    @Romeo_chiloo

    3 жыл бұрын

    @@cutechinfotamil Tqsm bro... Tnpsc grp 4exam Epo Varum bro ethachum update vandha Solluga bro

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    @@Romeo_chiloo sollalam

  • @monimonishamonisha3814
    @monimonishamonisha38142 жыл бұрын

    Hi sir date type panna day thappa varudhu

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    Check your computer date and time

  • @saranya2734
    @saranya2734 Жыл бұрын

    Sir enaku day laum date than katuthu

  • @cutechinfotamil

    @cutechinfotamil

    Жыл бұрын

    Video sollirukkura padi pannunga mam. Correct ah varum

  • @radhatharuni2947
    @radhatharuni29476 ай бұрын

    2023 to 2024 day book

  • @linganathanr9993
    @linganathanr9993 Жыл бұрын

    Sir I need this excel sheet please send your contact details

  • @vj6735
    @vj67352 жыл бұрын

    Not working day book

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    It will work. You would have done errors.

  • @vj6735

    @vj6735

    2 жыл бұрын

    @@cutechinfotamil day book is date enter பன்னுனா பணம் கம்பிக்கமாட்டினுத்

  • @vj6735

    @vj6735

    2 жыл бұрын

    @@cutechinfotamil day bok மட்டும் 0 வில் இருக்கு என்ன பன்ன வேண்டும் அண்ணா

  • @jaikarthik2279
    @jaikarthik22792 жыл бұрын

    Ena problem theriyal

  • @cutechinfotamil

    @cutechinfotamil

    2 жыл бұрын

    ok

  • @lockdown1622
    @lockdown1622 Жыл бұрын

    ❤ give me plz

  • @RazeenAkbar
    @RazeenAkbar3 жыл бұрын

    Thanks bro. ஒரு கேள்வி; ஒரே நாளில் பல amounts வந்தால் அதனை எப்படி பதிவு செய்வது? உதாரணமாக : ஏப்ரல் மாதம் 01ஆவது திகதியில் வரவுத்தொகையாக வீட்டு வாடகை - 10,000ரூபாய் வாகன வாடகை - 5,000ரூபாய் மாதச் சம்பளம் 60,000 ரூபாய் இப்படியாக ஒரே நாளிலேயே பல வரவுகள் வருகின்றபோது அதனை எப்படி பதிவு செய்வது? அப்படி பதிவு செய்யும் போது ஏப்ரல் மாத முழுமையாக எப்படியான மாற்றங்களை செய்வது. அதேபோன்று ஒரே நாளிலே பல செலவுகள் வருகின்றபோது அதனது பதிவுகளையும் எப்படி செய்வது தொடர்பாகவும் சற்று விளக்கமாக கூறலாமா??

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    very simple. just enter the same date again and again to enter details.

  • @RazeenAkbar

    @RazeenAkbar

    3 жыл бұрын

    @@cutechinfotamil Thanks again.🤝🤝 I'll try

  • @cutechinfotamil

    @cutechinfotamil

    3 жыл бұрын

    @@RazeenAkbar ok