How To Import Bank Statement Excel To Tally | Bank Reconciliation In Tally

Sdílet
Vložit
  • čas přidán 3. 01. 2019
  • 🚀 Ready to become a legend in Tally Prime? Join our exclusive Tally Prime Mastery Course! 📚
    Click on the link below to enroll now:
    www.entertheclass.com/courses...
    Download Tally ERP9 Important PDF Notes (70 PDF files in Just 170 Rs.)
    imojo.in/1CnYv5​
    Ek Baar Fir Se hazir Hun Tally ERP 9 ke Tips And Tricks ke Video ke Sath Is Baar Me Aapko Bataung ki Kaise Aap Bank Statement ko Direct Excel Se Tally Me Import Kar Sakte hai Wo Bhi Bina Kisi Software Ki madad Se Bina Kisi TDL File Ke.
    Is Tips Ke Sath Aap Bank Statement Ki Entry Bahut Fast Kar Sakte Hai Aur Bahut Aasani Se Kar Sakte hai Matlab Aapko Baar Baar Statement Ki Entry Dekhne Ki Jarurat nahi Direct Aap Data Import Kijiye Aur Har Entry ko Save Kar Sakte hai Bas Ek Click Me
    Ye Video Kaafi Kaam Ka Hai Ise Aap Shuru Se Leke Aakhir Tak Jarur Dekhiyega Kyunki Ab Tak Jo Bank Statement Entry Karne Me Aapko 15 Minute Lag Jata Tha Wahi Ab Aapko Kewal Minute Hi Lagenge To Ummid Karta Hu Aapko Video Jarur Pasand Aayega
    Yaha Kuch Aur Tally ERP 9 Ke Shortcuts Ke Video Hai Jo Bahut Kaam Ke Aur Unique Hai Agar Aapne Ye Video Bhi Nahi Dekhe Hai To Abhi Dekh Sakte hai Main Yahi Kahunga Ki Miss Mat Karna Jarur Dekhna
    _____________________________________
    Tally ERP 9 Shortcut in Hindi Part-1
    • Tally ERP 9 Shortcuts ...
    _____________________________________
    Tally ERP 9 Shortcut in Hindi Part-2
    • Tally ERP 9 Shortcuts ...
    _____________________________________
    Tally ERP 9 Shortcut in Hindi Party-3
    • Tally ERP 9 Shortcuts ...
    _____________________________________
    How to Import Sales from Excel To Tally
    • How To Import Data Fro...
    _____________________________________
    Download EXCEL CSV file HERE
    wp.me/paEvlb-17
    _____________________________________
    Visit our Website
    www.tallyclass.com
    Thanks For Watching and Watch Out For Next Video
    Because My Mission
    Learn Everyone
    Happy Learny
    To Be Continued………….

Komentáře • 812

  • @anshikarastogi1255
    @anshikarastogi1255 Před 3 lety +2

    Your videos are very helpful for me and my sister also, thankyou for teaching us. You are doing great!

  • @sree9355
    @sree9355 Před 3 lety

    I tried this method. It's working 100% correctly.

  • @bubblebath2892
    @bubblebath2892 Před 3 lety +1

    Thanks a lot for the video ....works like a charm (when followed step by step 😂😂 ) ...I happened to skip things in between causing trouble ....so yes -please follow each step religiously

  • @taxsolution7715
    @taxsolution7715 Před 3 lety

    Thank You Sir. Aapki mehnat sach me lajawab hai.

  • @kishorkrpandey166
    @kishorkrpandey166 Před 5 lety +1

    Bohat majedhar video lagi sir....!! simple language me bohat asani se kaam ki knowledge di

  • @knowledgeenhancements9122

    First time dekha Unique lga idea and Work Mere pass 25 Page ki Entry krne m pura din lgta tha

  • @prabirpaul6141
    @prabirpaul6141 Před 3 lety

    Oh my god. 😲😲😲
    Oh my god .
    Think ing u just save my life 😂😂😂🙏🙏🙏
    Thanks bro....
    Ham to har entry alg se karta tha

  • @priyav8494
    @priyav8494 Před 3 lety

    Wow....kisine nhi bataya ye aaj tak. Easy n time saving

  • @shaikhhasina3683
    @shaikhhasina3683 Před 5 lety +1

    Thanks sir aap ne bht achchi video banay hai but bht fast explaination tha plz next video me slow explain kijiy plz

  • @shwetabhosale9039
    @shwetabhosale9039 Před 2 lety +2

    You are just Awesome Sir!!!
    Thank you so much... Keep making videos like this.

  • @pawantiwari8646
    @pawantiwari8646 Před 5 lety +1

    The best classes ever of tally courses. Thanks a lot for make video related tally. All the best air

  • @ArvindKumar-gq2pf
    @ArvindKumar-gq2pf Před 3 lety +1

    Really nice work sir 👍 we will appreciate you from heart.

  • @JavedAli-cs7qu
    @JavedAli-cs7qu Před 4 lety

    Nice & Great Video for every Accounting jobs.

  • @mohdrehan8965
    @mohdrehan8965 Před 5 lety +9

    thanx for this video brother, pls.make other videos on gst

  • @urvashikhandelwal1
    @urvashikhandelwal1 Před 3 lety

    Works perfectly.. Super helpful.. Thanks a ton..

  • @rajmaurya2277
    @rajmaurya2277 Před 4 lety +1

    Thankyou sir Very Valuabele video. 🙏🙏🙏

  • @vamsivaliveti2094
    @vamsivaliveti2094 Před 5 lety

    Perfectly working and Thank u very much sir. can u pls guide us how to check how we settled due bills. (we paid of due bill and our vendor asks details for the same) as there are lot of entries in that ledger, how can we check that bill payment details

  • @gayatrikj5455
    @gayatrikj5455 Před 5 lety +3

    Its very helpful for us👍

  • @SuperRajivjain
    @SuperRajivjain Před 4 lety

    Hats off to u sir such a great work done
    Thank u sir

  • @sophiaantonydharmaraj1469

    Thank u very much. It's very use full for my work. God bless u

  • @saifaligavandi6646
    @saifaligavandi6646 Před 5 lety +1

    Very nice sir suuuuperb......please keep continue more new videos .....

  • @riteshkurmi2355
    @riteshkurmi2355 Před 5 lety

    Kya bat hai sir
    Such an outstanding video

  • @syedkhurrumraza1
    @syedkhurrumraza1 Před 5 lety +1

    Thanks a lot very helpful for me

  • @rosshanjangid
    @rosshanjangid Před 3 lety

    Keep doing such videos it's helpful , god bless

  • @ramakantmaurya2459
    @ramakantmaurya2459 Před 4 lety

    wow sir , you are great sir and you are the best .

  • @abhishekarora9580
    @abhishekarora9580 Před 5 lety

    Kya tally main ferm ke naam ke alava other bank mtlb saving account ya family saving account maintain kr skte hai firm ke ledger main

  • @nikhilgarg3735
    @nikhilgarg3735 Před 4 lety

    Thankew Sir ...appreciable Efforts...:) Value Addition

  • @shrawan586
    @shrawan586 Před 5 lety

    Thank u sir for valuable information

  • @anammiddya7422
    @anammiddya7422 Před 3 lety

    Thanks sir it helped me so much its make my work easy please sir I want to learn return filling of GST and TDS please upload that video also latest version ☺️☺️

  • @RahulKumar-fl7uw
    @RahulKumar-fl7uw Před 3 lety

    Supber bhai ...ek like or comments tho banta hai sir ji

  • @rajubedipkl
    @rajubedipkl Před 5 lety +1

    Very Nice Sir . God bless you. thanks

  • @subirlahiri1674
    @subirlahiri1674 Před 5 lety +1

    Very helpful video 👍👍👍

  • @cashikshaarya8659
    @cashikshaarya8659 Před 4 lety

    Thank you for sharing the video .....

  • @KaileshHambireIJ-G-
    @KaileshHambireIJ-G- Před 5 lety +1

    Thanks for this video, keep making such types of videos.

  • @pagvinayak1894
    @pagvinayak1894 Před 4 lety +5

    Sir, Great Job, but after import Alt+C command not work, what to do

  • @sree9355
    @sree9355 Před 3 lety +1

    Sir, i there any similar method in tally to import/ reconcile 2A returns

  • @rajeshshah6758
    @rajeshshah6758 Před 4 lety

    Sir. I had around 500 entries whose ledger name had to be changed. I changed a few and closed. When i re start tally How do I view and alter the unchanged entries.

  • @maneeshpandey3361
    @maneeshpandey3361 Před 4 lety +1

    Good evening 🙏 Afjal, bhai October aa gya hai, GSTR1, GSTR2, GSTR3B kya band ho rahe hai ? Uski jagah par kya Hoga, or small or large turnover wale traders k liye kya treatment hogi ? Tally Mai yeh kis tarah hoga.Pls bataiye.
    Manish

  • @jitendragupta9341
    @jitendragupta9341 Před 5 lety +1

    Good trick Bhai keep it up

  • @bhaskarbm259
    @bhaskarbm259 Před 4 lety

    Thank you....so much....🙏🙏🙏🙏🙏

  • @sunilraneja9321
    @sunilraneja9321 Před 2 lety

    Thanks Sir. It's very useful.

  • @waizulhaque8746
    @waizulhaque8746 Před 5 lety

    Sir aap samjhate Bahut acha se but Bank statement hard copy se hi acha rajya hai entory. Karna or jald v hota hai

  • @KunalJawa077
    @KunalJawa077 Před rokem

    Thanks for sharing such content!

  • @vedantjaiswal8896
    @vedantjaiswal8896 Před 5 lety +1

    How to make an Excel file if we want to made by ourself for importing entry from excel in tally.

  • @pyro1998
    @pyro1998 Před 4 lety

    very useful information .Thanks

  • @onlyfacts1342
    @onlyfacts1342 Před 5 lety +1

    Awesome very helpful thank you very much..

  • @krishnajoshi874
    @krishnajoshi874 Před 5 lety +1

    Thank you sir🙏 for this amazing trick it saves my lot of time😊

  • @tallywithpawansir
    @tallywithpawansir Před 5 lety +3

    Very useful video...
    Best of luck bro.... 1000 likes from my side...

  • @AmitSharma-ti8zi
    @AmitSharma-ti8zi Před 4 lety

    Hello, when i imported bank statement it imports all entries but amount show only for payment entries and i saved all payment entries successfully. Neither receipt entries amount reflected nor i can save it manually.

  • @ssnpandu
    @ssnpandu Před 4 lety

    Tq very useful to
    1) doubt ❓ in this video tally sliver licensed or not ?

  • @devisiva2522
    @devisiva2522 Před 4 lety +1

    thankyou sir very useful video

  • @bablooji3273
    @bablooji3273 Před 4 lety +1

    THANK SIR RATE OF EXCEL TO TALLY BANK STATEMENT

  • @honeyranjita1
    @honeyranjita1 Před 3 lety

    Thank you so much for this video

  • @bapuhukam3027
    @bapuhukam3027 Před 5 lety +1

    Thenk you ser.

  • @rakshitbhatt3154
    @rakshitbhatt3154 Před rokem +1

    U r a professor of C. A students.... Superb work sir ji. 😁😁💯👌❤🙏👍

  • @anjalinirmal1071
    @anjalinirmal1071 Před rokem

    very very very helpful-god bless you

  • @tanyasachdeva3008
    @tanyasachdeva3008 Před 5 lety +4

    Wowwwwwwwwww. Too good. Gonna try today. Hope it works. Will reply regarding that soon.

  • @arrtepitts
    @arrtepitts Před 5 lety +1

    Aapka idea pasand ayaa. Thank u
    Share investing ki entry tally me kese kare ? Please guide

    • @HappyLearny
      @HappyLearny  Před 5 lety

      Main isi video par work Kar Raha hu.
      2-4 dino me video mil jayega

  • @shyamkumar-cd3ut
    @shyamkumar-cd3ut Před 5 lety +1

    Sir aap apana images laga kar rakhe good lagata h

  • @arihanttilessanitary2993

    hello sir kya tally me esa kiya a sakta hai ki galti se one month ki entry kisi dusre data me entry ho jaye to wo only wo entrys ko copy ya emport kiya ja sakta hai
    KKK

  • @nayyarnayyar1560
    @nayyarnayyar1560 Před 3 lety

    Bhaut badiya brother

  • @narenderparjapati5752
    @narenderparjapati5752 Před 4 lety

    Jo excel ki sheet h vo koi bhi blank sheet le kr kaam kr sakte h ya aap vali sheet hi leni pdegi

  • @rajitsalaria9982
    @rajitsalaria9982 Před 2 lety

    sir plz reply par pahle hame bank statement k pdf excel me enter krna hoga

  • @rahulkumarlath6364
    @rahulkumarlath6364 Před 9 měsíci

    Hi, I tried the same solution. It worked for the first month. When i tried doing the same for others for some reason it was showing additional bank entires lesser than the total entries i had in the file. Can you please help me understand why not all transactions are getting imported?

  • @sachindalvi8106
    @sachindalvi8106 Před 5 lety +1

    bhai kadak Video !

  • @mahboobzafar4250
    @mahboobzafar4250 Před 2 lety

    Assalamualaikum Afzal Bhai GST portal ki knowledge ki video banao

  • @akshaygauravco.8886
    @akshaygauravco.8886 Před 3 lety +7

    Hello guys we had the issue which showed "NOT A VALID FORMAT"
    Solution to this issue:
    First try all the 3 solutions suggested by sir in the description.
    If its not working , then check for your tally version and change to 6.4.7 (or other 6.4 series) which sir had in the video.Our issue is solved. (we have installed 6.4.9). We hope it helps.Thank you.

  • @vijendrakumar06
    @vijendrakumar06 Před 5 lety +1

    csv file Not Supported Show kar rha hai..
    And kya aap bata sakte hai ki OD Account k liye kaise karenge..
    Please..

  • @jayantdas7043
    @jayantdas7043 Před 2 lety

    Sir ek aisa video banaiye jisse bank statement ke narration ko dekh kr ye pta chal sake ki agr humne neft se payment kiya h to uska exact ref no konsa hai usko kaise pehchane agr imps se kiya hain to uska exact imps ref no konsa hain kaise kehchane agr RTGS se kiya ha to rtgs ka ref no konsa h kyuki sir narration me boht se no likhe hote h to isme ye samjh nhi aata ki agr humne jisse bhi payment kiya neft ho ya imsp ya RTGS uska ref no konsa h kyuki neft se kiya h ye to likha h but neft ke sth hi kaafi no likhe hote h usme se sahi ref kaise uthaye

  • @shahbazshaikh1431
    @shahbazshaikh1431 Před rokem

    After converted to csv, the file is not showing in correct colums and rows we have rearrange it correctly or what ?

  • @rajwesh4757
    @rajwesh4757 Před 3 lety

    ACCOUNTS PRO SOFTWARE INFORMIONSON PLEASE . RELATED JANKARI MIL SAKTI HAI KYA ISE USE KAISE KIYA JATA HAI USKI SHORTCUT KEY KAY HAI JAISA KI TALLY KI VIDEO MEIN AAPANE BATEYA HAI HUMNE AQAPKI KAFI VIDEO DEKHI HAI AUR HAMEN BAHUT ACCHI LAGTI HAI

  • @sureshnagwan7805
    @sureshnagwan7805 Před 3 lety

    I like your every video very much.

  • @chalotallysikhe5554
    @chalotallysikhe5554 Před 5 lety +1

    Wha sir wonderful

  • @laxmijetwani883
    @laxmijetwani883 Před 5 lety

    Tally erp9 se GSTR 2 kaise generate karte hai. Kuch settings karni hai kya pahle. Maine gstr2 generate kiya but blank sheet ati hai only headings ati hai. Please guide kariye

  • @shreejunagarajan1779
    @shreejunagarajan1779 Před 3 lety

    Sir,
    If I Imported than done 10Entries out of 100 with Alt + C. If I want to Do only for next 90 Entries What to do?

  • @hrp1800
    @hrp1800 Před 5 lety +2

    Thank you, it helped me lot.

  • @narendra7886
    @narendra7886 Před 4 lety

    i always download file in pdf but after convert in cvs,
    excel cont import b.s. in tally

  • @ps3422
    @ps3422 Před 3 lety

    Happy makar Sankranti 🙏

  • @shamshadahmad4871
    @shamshadahmad4871 Před 3 lety

    Thankyou so much sir 👍

  • @rameshbhaipatel3662
    @rameshbhaipatel3662 Před 5 lety

    Thank'S so much

  • @dilipkarle8664
    @dilipkarle8664 Před 3 lety

    Hello , sir Gst adjustment or service purchase ki entry pe video bnaiye....

  • @hardikkothari8544
    @hardikkothari8544 Před 2 lety

    Tried both formats CSV and Excel
    but I am getting a error “Not a valid format”
    Can you please help

  • @mahadevswami2748
    @mahadevswami2748 Před 2 měsíci

    Sir faceing some error bank statement is already open close the sum before saving BRS uploading the important status

  • @akashramesh3026
    @akashramesh3026 Před rokem

    Can we use it for tally primr as well

  • @samirmakwana2477
    @samirmakwana2477 Před 3 lety

    Cany you help me out If this Bank statement option is disabled then what should I do???

  • @ningarajps3635
    @ningarajps3635 Před 5 lety +1

    Thanks for ur information..

  • @sushilg111
    @sushilg111 Před 4 lety

    While Bank ledger alteration Bank Details not shown, as in this vedio, and reconciliation option not displayed. So I can't change this

  • @DINESHSHARMA-yj3si
    @DINESHSHARMA-yj3si Před 5 lety

    Statement.csv read only.to save a copy click OK than give the workbook anew name in the save as dialog box sir ye ata hai or new file ban jati hai please help me

  • @gausmohammad5125
    @gausmohammad5125 Před 3 lety

    Sir,
    Trail balance pr video bnaiye..

  • @abhishekprajapati6268
    @abhishekprajapati6268 Před 5 lety

    Sir agar bank statement me entry miss ho or difference ho to usko kaise kare ...or exal me agar amount galti se galat likh diya ho to usko kaise find kare..in sab ke upar video banaye plz

  • @manishyadav128
    @manishyadav128 Před 5 lety +1

    Sir bank account ka details video baje sir mujhe start se account banana first mujhe kaun kaun ledgers banana and usme Kya details barana hai sir plz help

  • @arjunsingh1811
    @arjunsingh1811 Před 5 lety +1

    Thanks Afjal Bhai

  • @HarjeetSingh-in1di
    @HarjeetSingh-in1di Před 5 lety +1

    Bhai superb

  • @shibakshetrapal2728
    @shibakshetrapal2728 Před 4 lety

    Nice video bhaiya thank you

  • @santhoshiprasad
    @santhoshiprasad Před 3 lety

    Can we use same format in tally prime???

  • @brawlgaming2345
    @brawlgaming2345 Před 3 lety

    sir ap ke dwara bataye gaye csv file ko uplod karne pr speling error arha hai please solution bataiye

  • @kunjikonjumon
    @kunjikonjumon Před rokem

    You are the best 👍

  • @VisualKreation
    @VisualKreation Před 3 lety

    Really Gr*8 Sir..TQ

  • @shubhamtashkiprajapati8256

    Sir. Sales ki sheet ki video video bnaiye (composition dealer ke liye)
    EXcel to tally

  • @sachinsharma4021
    @sachinsharma4021 Před rokem

    Can we purchase tdl file for rental licence of tally