The sheet is great. just wonderful. Just one thing I wanted to add is that the Journal Sheet does not work when I have one debit and multiple credit items, for example Depreciation Entry or when there is multiple debit and credit entries within the same JV.
Sir, Thank you so much for all the support and for the Excel macro preparation. We are really greatfull to you for this great job and for helping people all around the world by investing your valuable time Please let us know if we can help you in any way 🙏 Senior Business Analyst, Team, Bizarc Ventures, Bhubaneswar, Odisha
Sir ham itna sab khch karne ke bajaye bank reconciliation use karr sakte hai na. Pdf to tally samajta nhi to Excel ke hi pdf ko import karr lende phir ek jagah save karke phir bank reconciliation me import karr lenge to poora data dump ho jayega. Jo ledgers nhi hote usko wahi pe create karke add karr sakte hai na
I usually do this as well. First use suspense and then match with the ledgers to post in proper ledger. Alternatively, use can first export the list of accounts in tally and then use the exact names from there to make excel using filters. This will improve efficiency.
There are various OCR tools available for conversion of PDF to Excel. Alternatively, All banks offer download of statement in Excel format using NetBanking.
No doubt it's great, I've been ysing since 1-1.5 years. However, X2T Beta bs kch time tk hi free h, jb tk development me h. So, basically they're capitalising you until their app is fully free of bugs. Another reason being creating demand in market.
Dear Yash sahb, we didn't ask him or any gentle men to make video for me. He out of his own interest made video on our tool (without even my knowledge), which I really do appreciate. No one is capitalizing anyone, neither me by him promoting my tool nor him by making video on my tool. And I am not waiting to commercialize till I fix the bugs. You think it takes 1-1.5 years to find and fix bugs? We didn't hide any of the facts. Our future pricing plan is very much visible in our website for a long time.
I'd like to clarify that Arun, the creator behind Macrolix's free tool, is a highly respected individual who has positively impacted many. Instead of spreading false rumors, I encourage you to express any concerns you may have in a respectful manner. Let's appreciate the hard work and generosity of individuals like Arun in fostering a supportive community ❤❤
@@Macrolix I'm so sorry if anything I said was wrong. I know you didn't asked him to create a video on it, neither I said that it's sponsored video. I just said that you're creating demand in the market, and I guess nothing's wrong in that. Even Jio did that, providing free data and calls to everyone. Also, I mentioned in the first place, that no doubt it's great tool, and I'm one of the user of your tool. Maine bs additional info add kiya ki ye tool kuch time tak hi free hai bs ab. So, that's just my view. I'm not stopping anybody from using it. Maybe you misunderstood my words.
@@caratools Sir/respected senior/fraternity buddy, please tell me from which phrase of mine made you feel that I disrespected Shri Arun Ji. I didn't. As mentioned above, I just added additional info, to which the admin of the channel took it very positively.
@@yashkeshari17Sahb ji, you didn't give additional information, you just made opinions and indirect advices: 1. I am CAPITALISING from this gentleman's video Making a video on my tool didn't bring 13K viewers to this channel in two months? Which is also the highest viewed video of the channel as on date. So only I am making USE of this gentleman's innocence & efforts? He had no benefit on making a video on my tool? 2. I am waiting to CHARGE once we fix the bugs So according to you it takes 1.5 years + to find and fix bugs in this small tool? Is there any rule that, people shouldn't pay for tool that might have some minor bugs? If I wanted to charge, I could have started it long back. 3. I am keeping it to create MARKET DEMAND and using JIO strategy A small part time developer, making tools and planning to charge Re.1 per day is a CORPORATE LEVEL idea? Sahb ji, INTENTION is important. I am neither waiting to CREATE A MARKET DEMAND nor WAITING TO FIX BUGS. I am waiting for the backend system to get ready. If you don't know about something, it is just your opinion and not information. People may not know our telegram conversation we had couple of months back but I remember them very well.
The issues with report file will be in your tally log, it will tell you what's the error. I think you have not generated the correct XML. Please generate again, your problems will be solved.
THANK YOU U REALLY MADE MY DAY WITH THOUSANDS OF BANK ENTRY SOLVED IN LESS THAN 1 HR... WHICH EARLITER TOOK ME AN WEEK ... THANK YOU SOO MUCH
Glad it helped. Please like and share the video.
Superb Utility.Must for every tally user making bulk entries.I give 7 star rating to this and i thank the team for making my work easier
Please support us by liking and sharing our content.
Thank you so much for taking your time and effort to make this video on our tool. Best wishes 🙂🙏
So nice of you. Thanks for the awesome work and helping the community!
@@HorizonLearning Very Very Thanks... Dear Bro
Thank you so much sir 😊
Thanks a life saver utility. 🌟🌟🌟
Thanks for supporting the channel ❤️
Your videos are very genuine and works perfectly ❤️❤️. Thank you so much for Such amazing Content 🙏
Thanks for the appreciation.
Macrolix Team your work is outstanding just one word magic
Hey bro it really works. I am so happy after seeing work of this utility.
Thanks. Please share te video if you find it useful.
YOU DID AN AMAZING JOB MAN HATS OFF TO YOU
Thanks for your kind words
THANK YOU SO MUCH FOR THIS VIDEO I WILL SHAER MY ALL FRNDS
So nice of you
Kaleje se thank you ❤❤
Useful video - well explained. Thank you.
Glad it was helpful!
Sir, Thank you very much for this excellent utility. Has made life easy
You are most welcome
Sir you made my day thank you so much 💓
Like, share and subscribe if you found usefull.
Good dear many many thanks .
Thank you so much sir, it is really helping me a lot lot
Thanks. Share the video if you found it helpful!
Very use full thank you ❤
Glad it helped
Thank you so much Sir ji
Thankss sir ❤❤❤
Thanks a lot sir for making this video.
Most welcome
Very powerful video
Thank you 🙏
Thank you so much sir 🙏
Most welcome
The sheet is great. just wonderful. Just one thing I wanted to add is that the Journal Sheet does not work when I have one debit and multiple credit items, for example Depreciation Entry or when there is multiple debit and credit entries within the same JV.
Use the basic version of the utility for JV.
Thank you so much... You made my day...
Thanks. Share the video on social media, if you find helpful.
Sir,
Thank you so much for all the support and for the Excel macro preparation.
We are really greatfull to you for this great job and for helping people all around the world by investing your valuable time
Please let us know if we can help you in any way 🙏
Senior Business Analyst,
Team, Bizarc Ventures,
Bhubaneswar, Odisha
You are most welcome
It really works !!!
Thanks a lot sir ❤
Most welcome
you are amazing sir ji
Full enjoy!
Excellent
Thank you! Cheers!
Thank you Sir
Most welcome
Yes
Really too good...
Thanks. Like and share with your friends.
THANKS TO GIVE ME THANK YOU VERY MUCH
You're very welcome!
U r God
Sir ham itna sab khch karne ke bajaye bank reconciliation use karr sakte hai na. Pdf to tally samajta nhi to Excel ke hi pdf ko import karr lende phir ek jagah save karke phir bank reconciliation me import karr lenge to poora data dump ho jayega. Jo ledgers nhi hote usko wahi pe create karke add karr sakte hai na
Reconciliation is made after posting entries, this video is for posting entries in the first place which will be auto reconciled.
Thanks a lot.
Most welcome!
Tds payroll voucher or unke kedgers ko or uske sath unke Accounting ko tally me kese import kare usper ek vidio banaiye
Currently busy in ROC filing season. Will make video soon.
Please press bell notification icon to get the update as soon as we post a new video.
Will it work on Pirated ERP 9 ?
We don't recommend using it on that, but yes it works.
Need a Video on purchase & Sell import
Video already uploaded on the channel.
Thanks
Please show how to create sales and purchase voucher transactions with sales and purchase return.
Very useful but one question can this be used in tally prime 3.0 ?
Yes, definitely
1:35
For How many entries we can create Xml file is their is any minimum limitation ?
Unlimited.
How to use this utility for Tally Prime 4.1
Bulk New stock creation with opening qty,opening Rate and value वाला भीडीयाे स्टेपवाइज दिखाएं.
th-cam.com/video/UWvxyJzwZe0/w-d-xo.html
Happy 😀
B2b purchase ko import kaise kare tally me pls reply video link
Download nhi horha sir. Website link not opening
Is there any limitation on volume of data ?
No limits
kya ye tally prime me use kar sakte he?
Yes, it works perfectly fine in prime.
sir sale or purchase ki entry with stock item keep sat kese karege
th-cam.com/video/UWvxyJzwZe0/w-d-xo.html
Non inventory voucher ko tally me kese import kare uske upper ek vidio banaiye
th-cam.com/video/Pwq5WvIr140/w-d-xo.html
Wow
❤ se thanks
Aise hi comments ♥️ Jeet lete hain!
Will it be supported in Tally Prime ?
Fully supported in tally prime.
Stock item bala opening stock ka vedio banao
th-cam.com/video/UWvxyJzwZe0/w-d-xo.html
How to import Cash statement
Ye utility tally prime cloud me kam karegi kya?
Prime cloud will work only if allowed from server.
ke bar me kitni entry kar sakte he
Unlimited
how can we import purchase order or sale order with stock
Option provided in the utility
How to import in tally from purchase bills in Excel
Please provide link for how we import sale voucher with stock item In tally erp-9
th-cam.com/video/UWvxyJzwZe0/w-d-xo.html
Will it work in tally prime 2.1
Yes it works in tally prime
I USED ALL LEDGERS AS SUS ACCOUNT.. TO DO IT IN MY WAY IN TALLY
I usually do this as well. First use suspense and then match with the ledgers to post in proper ledger. Alternatively, use can first export the list of accounts in tally and then use the exact names from there to make excel using filters. This will improve efficiency.
Sales ki entry kaise kare
Option provided in the utility, detailed tutorial coming soon.
Excel sheet Download nhi ho rha h
Ye tally prime pr work karega
Yes, fully compatible with Tally prime
How to import GSTR 2 Data in this excell
th-cam.com/video/Pwq5WvIr140/w-d-xo.html
Sir. Hoe to convert pdf statement to excel. Please support 🙏
There are various OCR tools available for conversion of PDF to Excel. Alternatively, All banks offer download of statement in Excel format using NetBanking.
No doubt it's great, I've been ysing since 1-1.5 years. However, X2T Beta bs kch time tk hi free h, jb tk development me h. So, basically they're capitalising you until their app is fully free of bugs. Another reason being creating demand in market.
Dear Yash sahb, we didn't ask him or any gentle men to make video for me. He out of his own interest made video on our tool (without even my knowledge), which I really do appreciate. No one is capitalizing anyone, neither me by him promoting my tool nor him by making video on my tool. And I am not waiting to commercialize till I fix the bugs. You think it takes 1-1.5 years to find and fix bugs? We didn't hide any of the facts. Our future pricing plan is very much visible in our website for a long time.
I'd like to clarify that Arun, the creator behind Macrolix's free tool, is a highly respected individual who has positively impacted many. Instead of spreading false rumors, I encourage you to express any concerns you may have in a respectful manner. Let's appreciate the hard work and generosity of individuals like Arun in fostering a supportive community ❤❤
@@Macrolix I'm so sorry if anything I said was wrong. I know you didn't asked him to create a video on it, neither I said that it's sponsored video. I just said that you're creating demand in the market, and I guess nothing's wrong in that. Even Jio did that, providing free data and calls to everyone. Also, I mentioned in the first place, that no doubt it's great tool, and I'm one of the user of your tool. Maine bs additional info add kiya ki ye tool kuch time tak hi free hai bs ab. So, that's just my view. I'm not stopping anybody from using it. Maybe you misunderstood my words.
@@caratools Sir/respected senior/fraternity buddy, please tell me from which phrase of mine made you feel that I disrespected Shri Arun Ji. I didn't. As mentioned above, I just added additional info, to which the admin of the channel took it very positively.
@@yashkeshari17Sahb ji, you didn't give additional information, you just made opinions and indirect advices:
1. I am CAPITALISING from this gentleman's video
Making a video on my tool didn't bring 13K viewers to this channel in two months? Which is also the highest viewed video of the channel as on date. So only I am making USE of this gentleman's innocence & efforts? He had no benefit on making a video on my tool?
2. I am waiting to CHARGE once we fix the bugs
So according to you it takes 1.5 years + to find and fix bugs in this small tool? Is there any rule that, people shouldn't pay for tool that might have some minor bugs? If I wanted to charge, I could have started it long back.
3. I am keeping it to create MARKET DEMAND and using JIO strategy
A small part time developer, making tools and planning to charge Re.1 per day is a CORPORATE LEVEL idea? Sahb ji, INTENTION is important. I am neither waiting to CREATE A MARKET DEMAND nor WAITING TO FIX BUGS. I am waiting for the backend system to get ready. If you don't know about something, it is just your opinion and not information.
People may not know our telegram conversation we had couple of months back but I remember them very well.
Where can i download it
Download link in description
How to do sales and purchase entries in Excel
th-cam.com/video/Pwq5WvIr140/w-d-xo.html
Will it work in Tally Prime
Yes
I use tally prime ❤
Yes it works for tally ERP 9 and Tally prime as well
tried to open the link but failed as it is trojan virus infected
All macro enabled files are detected as malware by antivirus. It's 100% safe to use. I have been using it for over 3 years now.
im not able to access this link you provide
It's a direct download link. After clicking it, it will get saved in your default download location.
Sir how we can add stock items and import in tally
th-cam.com/video/UWvxyJzwZe0/w-d-xo.html
Bank name copy paste nahi ho raha hai
Use paste special ctrl+alt+v
IS it working in tally prime
Yes it works in tally prime as well. Check out part 2 on our channel for more.
Excel sheet is protected, what is the password to unprotect this sheet ????
Macros are protected. The password is restricted so that fair use shall be done of the utility.
Getting error on importing bank statement,
Check tally log file. Set groups for master before generating XML from Excel file.
How to import sales voucher entry from Excel to tally prime
Video coming out soon.
Cash payment voucher kayse kare
Use Contra in voucher type.
Bank Name paste hone ke bad gayab ho jata hai
Double click on bank space and then type bank name, it won't disappear
not allowing to download saying it is virus
It's a macro enabled excel, and by default it shows virus, but it's virus free, no problem in using.
Brother Please teach me Tamil language. I don't Know other Language. Please sir.
Sir you can use auto translated subtitles for the same.
Sir, Show journal voucher xml video pls
Video coming soon. Subscribe the channel and press bell icon to get notified.
Link kaha hai
Link in description
Dear sir free ya paid hai
absolutely free
sir file support Tally Prime
Yes
link 1 download nahi ho raha hai
You can use link 2
Import fail check the even log for more details aaa raha h
Data import nahi ho raha h
Check masters XML file. The name of group under you make a ledger, would be wrong. Use only default ledger groups available in tally.
I want to buy 15000 tak aajayega
Sir, its free to use.
1004 ki error aa rahi hai
Read Tally.imp file using notepad in the Tally installation folder. It will tell you the exact error.
This error comes due to improper data feeding.
I can use this software tally prime
Yes, this works on ERP 9 and Prime as well.
YOU MEAN DUDE ADVANCED EXCEL ARE FUCKLESS IN FRONT OF U THAT EXCEL WHICH A DATA ANALYST USED
Kindly reframe in correct grammar to make this understandable.
Error aa raha hai.. can do i WhatsApp message you.
Yes. You can contact us.
Thank you so much as you made my day...🎉🎉
Thank you sir. Please share the video with your friends!
Issues with import file, file import hone ke baad data nahi a raha
Share log file on email. Will try and resolve your issue.
@@HorizonLearning log file ?
The issues with report file will be in your tally log, it will tell you what's the error. I think you have not generated the correct XML. Please generate again, your problems will be solved.