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
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 🙏
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
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
@@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
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
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
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
@@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 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 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
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
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?
Thank you so much for this video.
Very very time-saving video.
Your Welcome
@ayanacademy5080 getting error like account number does not matched; but everything is correct
Very useful for all accountants
Excellent explanation, you nailed it.
Thank you
Ayan sir aap bohut ache se explain krte ho mai aapki sari video dekhta hu
Thank you
thank you sir it helped me to import easily
Welcome ,
Please aise videos or banayi very helpfull video
Sure ..
Thanks bro...❤
Ayan sir's teaching style is very good
Thank you :)
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
Absolutely
Awesome Video Brother👌
God Bless you ❤
Thank you
Best sir ❤️🦅
Thanks
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 🙏
One by one
Thank you so much.... 👍👍👍
My pleasure
Thank you perfect guideline
Welcome
Best For Knowledge
Keep watching
Thank you very useful video 🙌
Welcome
Thank you sir ❤
Welcome
Very very helpful topic❤❤❤❤
Keep Sharing
Bohut mast information bhai
Thank you
Nice dear
Very useful
Glad to hear that
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
Kindly sent this Queries on my email I’d - ayanacademy5@gmail.com
Vehicle insurance
Thank you🙏 so much sir
Keep watching and keep sharing this channel because Tally prime with accounting Beginner Course will coming soon .!
Supar❤️✔️
:)
I tried uploading but the file format doesn’t support tally is there any specific format to upload???
Same problem
Mapping format se import karte hai tally mein tabhi support karti hai tally
Excel file Direct Bank se Download karna he and then Import karna he Tally me
@@ayanacademy5080 exception aate hai gstr mismtachs mein jaati hai kai baar entries.
Good knowledge
Thank you
Appreciate your efforts
Thanks
Thumbnail आपने बिलकुल सही पढ़ा 😂 (KJ Classess)
Thank ❤you❤
Welcome
very help ful
Thank you
thank you sir
Thank you
Thanks and is it possible to import Purchase vouchers also
You Need to Buy TDL From Tally. Then you Can do this.
Good vedio sir
👍
Helpful video bro
Thanks Dear..!
Superb sir
Thank you
Thank you 🙏
You’re welcome
Sir hum educational mode mein import aur reconciliation kar skate hai kya
Educational Mode main Nahi kar skte
@@ayanacademy5080 OK
Thank you
Welcome
Supar baest
Thanks
thanks
Welcome
Sir i uploaded 2000 transaction in one time
Please tell where i get import data in next day
Pura bank statement one by one entar karna padega ya koi sort formula hai
Jaisa Video me Btaya he Vaisa hi karna pdega
I appreciate ❤
Thanks Dear
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
Han vo esa hi krna pdega
Ayan sir ❤❤❤❤❤❤
I tried it worked but after selecting 1st entry I came out of reconciliation and now I can't find the other entries.
Excilent ❤
:)
once upload Union bank of India bank statement plz
Direct Bank ki website se Excel file Download krke Tally me Import Kia hua hona chahiye
Can sales entry be done?
no
Nice video is there an option to import amounts in the particular ledger? Any Add On available
No dear
Sir uske liye koi video bana sakte ho ap to vo Bata do sir pls
If alt+j se entry ko accept kar ke ledger nai dala to vo bank entry save nai hoga?please reply
Yes Nahi hoga
In my tally bank statement is blurred, what can i do to reconcile
You can download a new Bank statement from Internet Banking.
@@ayanacademy5080 i downloaded a new bank statement , when i want to import the bank statemnt option in tally is unselectable
Is there an add on for this or its a default setup in tally ?
default set up - just follow steps which is shown to you in this video.
@@ayanacademy5080 bank statement ko excel me convert kiya aur jab export kar raha hu to ho nahi raha
@@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
Sir, Post for required an "employee on LinkedIn " Expenses goes in which CHART OF ACCOUNT?
If you pay for this post, then you can booked under Indirect Expense
mene bank of baroda statement download karke kiya format not valid aa raha h plz reply
Direct Website se kiya tha download ?
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
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
Please share email id. I will share the excel file and screenshot
@@russiav15 already mentioned
Sir koi v Bank ka statement download karte h Excel me to vo aise hi le lega ya koi format h please help
Koe bhi bank hogi ese hi vo automatic le lega
Same date ki same party ki 4 payment entry hai tally me vo ek saath merged ho rha hai
Screen shots on our Email I'd - ayanacademy5@gmail.com , will check and revert you
How much period statement can be imported
No Period limit
Sir. Pdf to excel & how to import in tally. Please reply or provide special software or TDL. OR ANY METHOD. FOR ALL INDIAN BANKS
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
@@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 🙏.
@@rajendral.1553 pdf file ko excel me convert ka ke import karoge to nahi hoga import
@@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 🙏
@@rajendral.1553 Suvit kar ke ek app he usko Try kro
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
Nahi, Direct Excel file Original Jo Bank ki site par se nikla hua ho vhi import karna he
Sir how to import bulk items Excel sheet
I didn’t understand what you say
Sir,bank statement download kiye me but kaha download hua pata chalra aur
Download ke folder main hua hoga
Nice 👍
Thank you
Hi sir tally prime edu me bank reconciliation kar sakte hai kya use me enable auto reconilation nahi ho raha kya kare?
Education Mode me Auto bank reconciliation nahi hoga , License version is compulsory.
Ok
but sir how to enable bank statement option in tally erp 9 or tally prime
Bank ka aapne jo ledger bnaya he usme niche option aayega ( Tally License Version hona Compulsory he )
Sir Jab Ham krte h to path dene k bad jab import krte h toh, Invalid format show ho rha h😢
Try Again .. Jaise Video me btaya he
Nice video.. Bank statement PDF main to yoga, keya PDF se excel korke, karna yoga'?
Direct Net Banking se Excel Format me bank statement ko download karna he or use hi important krna he tally me
@@ayanacademy5080 pdf file ko excel main convert korke nehi hoga na?
@@dip850 Nahi ese nahi hoga, aapko Excel File download karna pdega netbanking se or fir import marna pdega
bank statement option for import not highlight in my tally prime
I think you are in a Tally Prime Educational mode
Account number of bank statement doesn't match error coming
Share me Error Screen shot on My Email id ayanacademy5@gmail.com
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
Yes Please note this pdf to excel convert not worked
@@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
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
Yes, Sirf Bank statement hi hoga
Sir, it does not work for Axis Bank statement?
Yes It will work
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?
Try Again
Sir tally prime mai credit card ki entry kaise kare
Naved , Credit card ke payment ki entry ki bat kr rhe ho bhai ?
ICICI Bank statement ka kaise hoga
Same
If bank statment option nay aa rahai to ?
Alt +o karne ke baad
Aana Chahiye
Statement pdf mai import ho jayega kya sir
No dear nahi Hoga
Tally prime
Tally prime mai Excel import ke liye template ki jarurat hai vah kease download kare sir plz help me
@@omrathore6770Apke bank ki Site par se direct excel file download kr ke upload marna he
any patch file required sir
No
Import ke time par bank statement ka option hi nai aa raha
I have tally prime gold
Pura video aap skip kiye dekhiye bcz aap Kuch miss kar rhe he Isliye nahi ho rha he
Sir mujhe tally prime m customise karna h
Customise Kya karna h ?
invaild format problm kese solve kre
Aapko Bank Statement Excel format mein Bank ki Website pr se download krna hoga
Bhi aya erp9 me bhi batao na
Erp me bhi same hi he bhai , aap is video ko dekhne ke bad usme Try kre, usme bhi ho jayega
Sir import mai Bank Statement highlight nhi ho rha hai uske highlight kaise kare
Education mode mai
Educational Mode me nahi hoga yeh
MERE CSV IMPORT HONE KE BAAD BHI 0 ENTRIES AATI HAI. KYA KARE?
May be Statement sahi import nahi kiaa hoga aapne
2:17 account number of bank statement does not match . Error aaya hai Kay karna padega
Share screen shot on this - ayanacademy5@gmail.com
SIR JAB IMPORT KARTE HE TO TALLY CLOSE HO JAATA HE . KYA KARE ?
Hona to Nahi Chahiue
Error
Opps!
Not a valid farmat
फाइल सपोर्ट करने के बाद में यह error आ रहा है
Bank statement Excel format ko Aapko download krna pdega direct Bank ki website se, yeh esa nahi kroge to yehi error btayega
Sir iska tdl kaise milega
TDL Ki koe zrurt nai he
Sir file name kya dalna hai pls bataiye
Dear aap import karogi Excel file ko to vo automatic hi file naam le lega, hme Manually Kuch Likhne ki zrurt nahi he
Excel export?
Yes From your Internet Banking
Not valid format show kr raha hia bro kya lru
Bank ki Website pr se statement excel format mein nikalna pdega aapko
Format support nai karta, Axis bank ka to nai karta hai..
Axis bank ki website pr se excel format mein Statement ko download kro, Try again ho jayega
Tally prime shows not a valid format...what to do
Your Format is wrong. Download the Excel file bank statement from the internet banking of your bank.
Mere tally me voucher create karne ke bad bhi nahin hat Raha
Kya nahi hat rha ?
@@ayanacademy5080 jo bhi transaction Maine Reconcile kar liya hai vah Reconcile karne ke bad bhi nahin hat Raha
Excel format not valid aave to su karvanu?
You need to download proper Excel file from the net banking.
Not a valid format aa rah hai
Format sahi nahi he aapka
last me success ki jagah not in valid format aa rha h
Aapne File import ki he vo Valid nahi he Galat he Esa bol rha he
2/3 bank hai to bhi hoga import in specific bank
Yes, Hoga