How to Import Bank Statement in Tally Prime | Auto Bank Reconciliation | Excel to Tally Prime |

Подписаться 1,4 тыс.

Просмотров 92 тыс.

50% 1

#Autobankreconcilation #Importbankstatement #exceltotally
How to Import Bank Statement in Tally Prime || Auto Bank Reconciliation || Bank Statement Excel to Tally Prime.
*****************************************************
Don’t forget to subscribe to our channel:- / @ayanacademy5080
For More videos…
1) 3 Amazing Tally Prime Shortcut key :-
• 3 Amazing Tally Prime ...
2) Aap Accountant ho to Yeh to aana hi Chahiye :-
• Aap Accountant ho to Y...
3) टैली प्राइम का यह शार्ट कट की आपको एक्सपोर्ट बना देगा :-
• टैली प्राइम का यह शार्...
4) How to Download Tally Erp9 & Tally Prime?
• How to Download Tally ...
5) What is TDS? | Complete Knowledge | Ayan Academy
• What is TDS ? | Comple...
6) Tally Prime में TDS की Entry का सही और आसान तरीका | TDS Deduction Auto Calculation | Ayan Academy
• Tally Prime में TDS की...
7) जिसका TDS कटा हे , वो अपने Tally में कैसे और कोनसी Entry करेगा | TDS | Ayan Academy
• जिसका TDS कटा हे , वो ...
8) Tally Prime Keyboard Shortcut Keys in Hindi | Boost your working speed | Ayan Academy
• Tally Prime Keyboard S...
You can Follow me on
Instagram - ayan_academy
#Tallyautobankreconcilation #Importbankstaement #tally #tallyprime #tally #activetally #updatetally #allabouttally #generatesaleinvoice #basictallycourse #newtally #tallyprimesikhe #tallyfeature #allabouttally #tricksoftally #tallyshortcuts #tallybasictoadvance #tallycourse #TallyTips #tallyprime #learntally #allabouttally #accountsadvice #accounting #tallytipsinhindi #learnaccounting#
============================================================
Please like, comment, share and subscribe for more latest updates like -TDS, TCS ,GST,BANKING,ACCOUNTING,ALL TYPE OF REGISTRATION etc.. Thank you.

Опубликовано:

10 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 254

@Manojkumar-em6tp Год назад

Ayan sir aap bohut ache se explain krte ho mai aapki sari video dekhta hu

@faizankazi6249 Год назад

Very useful for all accountants

@expertsafetysolutions2454 8 месяцев назад

Thank you so much for this video. Very very time-saving video.

@ayanacademy5080 8 месяцев назад

Your Welcome

@sriramgovindarajan5802 14 дней назад

@ayanacademy5080 getting error like account number does not matched; but everything is correct

@sarvandhiman3532 Год назад

Please aise videos or banayi very helpfull video

@ayanacademy5080 Год назад

Sure ..

@kamalkannan1563 10 месяцев назад

Excellent explanation, you nailed it.

@ayanacademy5080 10 месяцев назад

Thank you

@faizankazi6249 Год назад

Ayan sir's teaching style is very good

@ayanacademy5080 Год назад

Thank you :)

@subramanig3564 5 месяцев назад

instead of use suspense ledger in each entries one by one you can use excel template in tallyprime 4 to upload bulk vouchers at a time . In this method one by one you need to shift to suspense and again you need to clear suspense to corresponding ledgers . its very complex while the data is more than 100 entries

@ayanacademy5080 5 месяцев назад

Absolutely

@zalaaryandev6182 3 месяца назад

Thank you sir ❤

@ayanacademy5080 3 месяца назад

Welcome

@deliniemendonca7914 3 месяца назад

I tried uploading but the file format doesn’t support tally is there any specific format to upload???

@jssingh3505 2 месяца назад

Same problem

@poonambanshi9540 24 дня назад

Mapping format se import karte hai tally mein tabhi support karti hai tally

@ayanacademy5080 17 дней назад

Excel file Direct Bank se Download karna he and then Import karna he Tally me

@poonambanshi9540 11 дней назад

@@ayanacademy5080 exception aate hai gstr mismtachs mein jaati hai kai baar entries.

@bhaveshsinghvi1073 12 дней назад

Best For Knowledge

@humair___shaikh___ Год назад

Best sir ❤️🦅

@ayanacademy5080 Год назад

Thanks

@dhanashrilad1732 Месяц назад

Thank you perfect guideline

@ayanacademy5080 17 дней назад

Welcome

@altafpatangwala-if4gc Год назад

Supar❤️✔️

@ayanacademy5080 Год назад

@milanpatel9527 2 месяца назад

Very useful

@ayanacademy5080 Месяц назад

Glad to hear that

@Arunkumar-kt2pw 2 месяца назад

Thank you very useful video 🙌

@ayanacademy5080 17 дней назад

Welcome

@vineshkumaraedpu7956 16 дней назад

Super brother its really helpful... thank you so much..😊 I imported 2000 transactions easily but how can i send into suspense account all the entries in one go...thank you 🙏

@vikassinger5308 5 месяцев назад

Bohut mast information bhai

@ayanacademy5080 4 месяца назад

Thank you

@es..8034 Год назад

Very very helpful topic❤❤❤❤

@ayanacademy5080 Год назад

Keep Sharing

@maheshtaxconsultancy9281 11 месяцев назад

Awesome Video Brother👌 God Bless you ❤

@ayanacademy5080 11 месяцев назад

Thank you

@vrboychaudhary4913 5 месяцев назад

Sir everything is ok... But jabi bi ek entry ka voucher alt+j se karta hu fir vapas muje scroll krke niche aana padta hai... To vo kese set kru ki jahase entry chhodi vaha vapas aau... Qki yese to pura last year ka scroll krte karte thak jaate hai

@ayanacademy5080 4 месяца назад

Han vo esa hi krna pdega

@abdulgafoorvilayil4377 Год назад

Appreciate your efforts

@ayanacademy5080 Год назад

Thanks

@Janvicool426 Год назад

Thank you🙏 so much sir

@ayanacademy5080 Год назад

Keep watching and keep sharing this channel because Tally prime with accounting Beginner Course will coming soon .!

@sujaymajumder7271 6 месяцев назад

Thank you so much.... 👍👍👍

@ayanacademy5080 6 месяцев назад

My pleasure

@ahmedhusain-fb9ou Год назад

Supar baest

@ayanacademy5080 Год назад

Thanks

@vaishnaviamble4269 17 дней назад

Sir hum educational mode mein import aur reconciliation kar skate hai kya

@ayanacademy5080 13 дней назад

Educational Mode main Nahi kar skte

@vaishnaviamble4269 13 дней назад

@@ayanacademy5080 OK

@bhaveshsinghvi1073 12 дней назад

mene bank of baroda statement download karke kiya format not valid aa raha h plz reply

@abdulgafoorvilayil4377 Год назад

Nice dear

@vidushi6258 4 месяца назад

very help ful

@ayanacademy5080 4 месяца назад

Thank you

@jayumore9500 4 месяца назад

Thank you😊

@ayanacademy5080 3 месяца назад

Welcome

@kajala5598 5 часов назад

Sir,bank statement download kiye me but kaha download hua pata chalra aur

@jssingh3505 2 месяца назад

Sir Jab Ham krte h to path dene k bad jab import krte h toh, Invalid format show ho rha h😢

@ayanacademy5080 17 дней назад

Try Again .. Jaise Video me btaya he

@vidushi6258 4 месяца назад

thank you sir

@ayanacademy5080 4 месяца назад

Thank you

@mjs-junaidsaifi2181 Год назад

Helpful video bro

@ayanacademy5080 Год назад

Thanks Dear..!

@steadycorpse Год назад

Thanks for the video...sir if we run a car showroom and customer takes insurance from us...under what head will the insurance provider fall under...thanks 👍 hoping for a feedback

@ayanacademy5080 Год назад

Kindly sent this Queries on my email I’d - ayanacademy5@gmail.com

@guthadhanalakshmi3457 Год назад

Vehicle insurance

@shaikhmohammedimran9230 6 месяцев назад

Good knowledge

@ayanacademy5080 6 месяцев назад

Thank you

@lateststatus0statuswhats 9 месяцев назад

Thank ❤you❤

@ayanacademy5080 9 месяцев назад

Welcome

@amitmaity7459 9 месяцев назад

Thank you

@ayanacademy5080 9 месяцев назад

Welcome

@Usedcarby-AKJ Месяц назад

Good vedio sir

@ayanacademy5080 17 дней назад

👍

@adityahagawane5610 5 месяцев назад

Hello sir humne Jo bank statement import Kiya usko save kar sakte hay kya please batana muje

@ayanacademy5080 4 месяца назад

Import Kroge to Entries to saved ho hi jayegi na

@chavdajanvi2803 Год назад

I appreciate ❤

@ayanacademy5080 Год назад

Thanks Dear

@hitendrapatel8558 Год назад

Excilent ❤

@ayanacademy5080 Год назад

@a2zartattack358 Год назад

Superb sir

@ayanacademy5080 Год назад

Thank you

@gayatrikj5455 7 дней назад

Sir i uploaded 2000 transaction in one time Please tell where i get import data in next day

@nawshadshaikh9745 2 месяца назад

Same date ki same party ki 4 payment entry hai tally me vo ek saath merged ho rha hai

@MaheswaraReddyKommuru 2 месяца назад

once upload Union bank of India bank statement plz

@ayanacademy5080 17 дней назад

Direct Bank ki website se Excel file Download krke Tally me Import Kia hua hona chahiye

@russiav15 Год назад

I tried and imported the excel file. Successfully imported all transactions but none of the transactions is reconciled. What can be the possible error in this. All transactions are showing as "Amount not reflected in Company books". What to do

@ayanacademy5080 Год назад

Not possible, the matching is done automatically when you import Excel. So Kindly sent your Error on email I’d I will check you error and revert you asap. Email I’d - ayanacademy5@gmail.com

@russiav15 Год назад

Please share email id. I will share the excel file and screenshot

@ayanacademy5080 Год назад

@@russiav15 already mentioned

@abhisekhjain2178 9 месяцев назад

thanks

@ayanacademy5080 9 месяцев назад

Welcome

@asmapatangwala4089 8 месяцев назад

Ayan sir ❤❤❤❤❤❤

@earthpossess Год назад

Thanks and is it possible to import Purchase vouchers also

@ayanacademy5080 Год назад

You Need to Buy TDL From Tally. Then you Can do this.

@dimplethakker4253 8 месяцев назад

If alt+j se entry ko accept kar ke ledger nai dala to vo bank entry save nai hoga?please reply

@ayanacademy5080 8 месяцев назад

Yes Nahi hoga

@ashutoshpandey3672 Год назад

Sir koi v Bank ka statement download karte h Excel me to vo aise hi le lega ya koi format h please help

@ayanacademy5080 Год назад

Koe bhi bank hogi ese hi vo automatic le lega

@vikramsharma7849 2 месяца назад

Pura bank statement one by one entar karna padega ya koi sort formula hai

@ayanacademy5080 17 дней назад

Jaisa Video me Btaya he Vaisa hi karna pdega

@rajeshpandey4399 Год назад

sir pdf bank statment file excel me convert kr ke import krne se aa skta hai ye video dekhne ke bad maine kiya per aaya nhi kya aisa ho skta hai

@ayanacademy5080 Год назад

Nahi, Direct Excel file Original Jo Bank ki site par se nikla hua ho vhi import karna he

@taukeelahmadquadari 5 месяцев назад

Thumbnail आपने बिलकुल सही पढ़ा 😂 (KJ Classess)

@suneetak445 9 месяцев назад

Nice 👍

@ayanacademy5080 9 месяцев назад

Thank you

@AbhishekTiwari-up7is 4 месяца назад

Sir, Bank statement successfully Import hone ke baad 4:52 , mai galti se back aa gaya! ab saari entries bhi missing hai and 'Bank statement' option bhi nahi aa raha, abb kya Karu sir?

@ayanacademy5080 3 месяца назад

Try Again

@themusthafa0 9 месяцев назад

In my tally bank statement is blurred, what can i do to reconcile

@ayanacademy5080 9 месяцев назад

You can download a new Bank statement from Internet Banking.

@themusthafa0 9 месяцев назад

@@ayanacademy5080 i downloaded a new bank statement , when i want to import the bank statemnt option in tally is unselectable

@islamichamd787 10 месяцев назад

Sir, Post for required an "employee on LinkedIn " Expenses goes in which CHART OF ACCOUNT?

@ayanacademy5080 6 месяцев назад

If you pay for this post, then you can booked under Indirect Expense

@nitinsharma7839 6 месяцев назад

SIR ONLY HDFC BANK EXCEL WHICH IS DOWNLOAD FROM BANK OH HDFC WORK ...WHATS WILL BE OTHER MEANS WHICH IS PDF TO EXCEL COVERT NOT WORK

@ayanacademy5080 6 месяцев назад

Yes Please note this pdf to excel convert not worked

@nitinsharma7839 6 месяцев назад

@@ayanacademy5080 sir I have downloaded SBI bank statement from in Excel format but at the time of uploading... error showing that account no. Not matching...pls provide me your contact no. It's help for me

@responsemanish Год назад

Nice video is there an option to import amounts in the particular ledger? Any Add On available

@ayanacademy5080 Год назад

No dear

@natarajapillai7098 Год назад

Hi sir tally prime edu me bank reconciliation kar sakte hai kya use me enable auto reconilation nahi ho raha kya kare?

@ayanacademy5080 Год назад

Education Mode me Auto bank reconciliation nahi hoga , License version is compulsory.

@natarajapillai7098 Год назад

@ambalalpatel2192 28 дней назад

Can sales entry be done?

@ayanacademy5080 17 дней назад

@rajkumarn3366 4 месяца назад

How much period statement can be imported

@ayanacademy5080 3 месяца назад

No Period limit

@amitlad8368 4 месяца назад

Sir import mai Bank Statement highlight nhi ho rha hai uske highlight kaise kare Education mode mai

@ayanacademy5080 3 месяца назад

Educational Mode me nahi hoga yeh

@kinjalparmar5932 3 месяца назад

If bank statment option nay aa rahai to ? Alt +o karne ke baad

@ayanacademy5080 17 дней назад

Aana Chahiye

@anandmewada852 Год назад

Sir uske liye koi video bana sakte ho ap to vo Bata do sir pls

@user-dq6oh9ds7w Год назад

Is there an add on for this or its a default setup in tally ?

@ayanacademy5080 Год назад

default set up - just follow steps which is shown to you in this video.

@bkrahulprasadsingh 11 месяцев назад

@@ayanacademy5080 bank statement ko excel me convert kiya aur jab export kar raha hu to ho nahi raha

@ayanacademy5080 11 месяцев назад

@@bkrahulprasadsingh Brother Pdf vale bank statement ko excel mein convert krke kroge to nahi hoga, apko bank ki website he actual excel download kar ke use import karna he tally me

@user-le6lp5sj8i 11 месяцев назад

2:17 account number of bank statement does not match . Error aaya hai Kay karna padega

@ayanacademy5080 11 месяцев назад

Share screen shot on this - ayanacademy5@gmail.com

@shubhamlawane9766 Год назад

but sir how to enable bank statement option in tally erp 9 or tally prime

@ayanacademy5080 Год назад

Bank ka aapne jo ledger bnaya he usme niche option aayega ( Tally License Version hona Compulsory he )

@anandmewada852 Год назад

Sir ye video mujhe puri samjh aa gai h pr isme sirf bank statement hi hota h mene duri ek excel file ko import karna ki Koshishi kri pr vo NHi hua sir Mene isme GST ki sales or purchase ki entry ka vo dala to vo nhi dala

@ayanacademy5080 Год назад

Yes, Sirf Bank statement hi hoga

@shrirangmoghe2840 4 месяца назад

MERE CSV IMPORT HONE KE BAAD BHI 0 ENTRIES AATI HAI. KYA KARE?

@ayanacademy5080 4 месяца назад

May be Statement sahi import nahi kiaa hoga aapne

@eltonsukumar Год назад

Sir, it does not work for Axis Bank statement?

@ayanacademy5080 Год назад

Yes It will work

@ankushkumar-cm8qh 7 месяцев назад

Account number of bank statement doesn't match error coming

@ayanacademy5080 7 месяцев назад

Share me Error Screen shot on My Email id ayanacademy5@gmail.com

@thetanish01 Месяц назад

SIR JAB IMPORT KARTE HE TO TALLY CLOSE HO JAATA HE . KYA KARE ?

@ayanacademy5080 17 дней назад

Hona to Nahi Chahiue

@choudharynasir8253 8 месяцев назад

bank statement option for import not highlight in my tally prime

@ayanacademy5080 7 месяцев назад

I think you are in a Tally Prime Educational mode

@sonalikothmire1653 Год назад

Sir file name kya dalna hai pls bataiye

@ayanacademy5080 Год назад

Dear aap import karogi Excel file ko to vo automatic hi file naam le lega, hme Manually Kuch Likhne ki zrurt nahi he

@mohdnaiyar4497 3 месяца назад

ICICI Bank statement ka kaise hoga

@ayanacademy5080 3 месяца назад

Same

@mohdsaif9866 7 месяцев назад

Not valid format show kr raha hia bro kya lru

@ayanacademy5080 7 месяцев назад

Bank ki Website pr se statement excel format mein nikalna pdega aapko

@professionalknowledge5382 5 месяцев назад

Format support nai karta, Axis bank ka to nai karta hai..

@ayanacademy5080 5 месяцев назад

Axis bank ki website pr se excel format mein Statement ko download kro, Try again ho jayega

@omrathore6770 Год назад

Statement pdf mai import ho jayega kya sir

@ayanacademy5080 Год назад

No dear nahi Hoga

@omrathore6770 Год назад

Tally prime

@omrathore6770 Год назад

Tally prime mai Excel import ke liye template ki jarurat hai vah kease download kare sir plz help me

@ayanacademy5080 Год назад

@@omrathore6770Apke bank ki Site par se direct excel file download kr ke upload marna he

@dip850 Год назад

Nice video.. Bank statement PDF main to yoga, keya PDF se excel korke, karna yoga'?

@ayanacademy5080 Год назад

Direct Net Banking se Excel Format me bank statement ko download karna he or use hi important krna he tally me

@dip850 Год назад

@@ayanacademy5080 pdf file ko excel main convert korke nehi hoga na?

@ayanacademy5080 Год назад

@@dip850 Nahi ese nahi hoga, aapko Excel File download karna pdega netbanking se or fir import marna pdega

@karthik5103 Год назад

Sir how to import bulk items Excel sheet

@ayanacademy5080 Год назад

I didn’t understand what you say

@rajendral.1553 Год назад

Sir. Pdf to excel & how to import in tally. Please reply or provide special software or TDL. OR ANY METHOD. FOR ALL INDIAN BANKS

@ayanacademy5080 Год назад

Dear Brother, Aapko Jo bank statement import karna he , uski Excel file direct uske Net banking se hi Download kia hona chahiye, Direct net banking download ki hui Excel file aapko Import kroge to Bina Error ke vo import ho jayega

@rajendral.1553 Год назад

@@ayanacademy5080 but some bank statement in pdf. So difficult to convert for tally. Excel to very easily. But pdf to excel. Not properly transfer. Thanks sir for reply 🙏.

@ayanacademy5080 Год назад

@@rajendral.1553 pdf file ko excel me convert ka ke import karoge to nahi hoga import

@rajendral.1553 Год назад

@@ayanacademy5080 how to convert in excel. All statement not available in excel. I want properly method or any free software. ( on or offline) thanks for you sir 🙏

@ayanacademy5080 Год назад

@@rajendral.1553 Suvit kar ke ek app he usko Try kro

@akilazhar5533 6 месяцев назад

Sir mujhe tally prime m customise karna h

@ayanacademy5080 5 месяцев назад

Customise Kya karna h ?

@shibthainraza4833 8 месяцев назад

sir not valid format bata raha hai .

@ayanacademy5080 8 месяцев назад

You Doing Something Wrong Kindly Watch Full Video Again.

@nhasopwala3868 Год назад

Sir tally prime mai credit card ki entry kaise kare

@ayanacademy5080 Год назад

Naved , Credit card ke payment ki entry ki bat kr rhe ho bhai ?

@preetinagraj3441 7 месяцев назад

invaild format problm kese solve kre

@ayanacademy5080 7 месяцев назад

Aapko Bank Statement Excel format mein Bank ki Website pr se download krna hoga

@PrincyShah1806 Год назад

Excel format not valid aave to su karvanu?

@ayanacademy5080 Год назад

You need to download proper Excel file from the net banking.

@svassociates-vs2mv Год назад

any patch file required sir

@ayanacademy5080 Год назад

@jayashreejadhav1569 Год назад

2/3 bank hai to bhi hoga import in specific bank

@ayanacademy5080 Год назад

Yes, Hoga

@mohdmaaz3367 Год назад

What if the statement of xl downloaded from net banking shows not a valid format ?

@ayanacademy5080 Год назад

Then Quite Not possible, You can share screenshots of the whole process on the Email I'd. I will update you on the same.

@kiranrathod7296 Год назад

Liev

@studentslife7788 Год назад

Not in format AA Raha hai sir

@ayanacademy5080 Год назад

Why ? Share me Screenshot on my mail id - ayanacademy5@gmail.com

@bhaveshthorat0078 5 месяцев назад

sir statement has been imported but it does not reconcile previous entries

@ayanacademy5080 4 месяца назад

Share screen shot on my email I’d - ayanacademy5@gmail.com

@shopNow205 Год назад

Bhi aya erp9 me bhi batao na

@bipintsk Год назад

Sir iska tdl kaise milega

@ayanacademy5080 Год назад

TDL Ki koe zrurt nai he

@mohdmaaz3367 Год назад

Bank statement option enable nahi horaha hai sir

@ayanacademy5080 Год назад

Agar Education mode me Try kar rhe ho to usme enable nahi hoga

@mohdmaaz3367 Год назад

Tqsm sir

@mahikaswa3884 Год назад

Mera lisence verson hai fer bhi nhi ho rha hai

@ayanacademy5080 Год назад

@@mahikaswa3884 not possible

@bkrahulprasadsingh 11 месяцев назад

Mere tally me voucher create karne ke bad bhi nahin hat Raha

@ayanacademy5080 11 месяцев назад

Kya nahi hat rha ?

@bkrahulprasadsingh 11 месяцев назад

@@ayanacademy5080 jo bhi transaction Maine Reconcile kar liya hai vah Reconcile karne ke bad bhi nahin hat Raha

@bittudas1058 Год назад

Tally prime shows not a valid format...what to do

@ayanacademy5080 Год назад

Your Format is wrong. Download the Excel file bank statement from the internet banking of your bank.

@ketansharma9101 Год назад

Excel export?

@ayanacademy5080 Год назад

Yes From your Internet Banking