Excel to Tally: Bulk Import of Accounting Entries

This video demonstrates how to prepare XML using Excel template which can be imported into Tally for import of multiple accounting entry vouchers (without use of any Macros)

Download link of template:

[samsontimes]

Amazing work sir, God Bless You. This is more useful for non accounting professionals. I am an Excel Programmer.

[rakeshchoudhary]

I also made it before and am using it too, but bro u made it better than me, keep upgrading and help people. Best of luck

[kapsheashish]

Dear Sir,
Thank you so much for taking efforts and creating the file, explaining us in such a nice way... And sharing the invaluable knowledge 👍🏼🙏🏼
This helped me a lot....

[fzozjdi]

Thank you so much sir, you wonderfully explained the core concept. This has really helped me to get my job done very quickly and also very effectively. It is a kind request that can you also make a video on combined entries. For example when we pass sales entries with GST.

Thank you so much once again sir...

[mineshsoni]

Thank you Sir... you have prepared a very nice utility indeed. What I was looking for this... Thank you Sir..

[zzodhoz]

Hello sir, Sir Journal Voucher me Ek Ledger ko Dr. or 2 ledger ko cr. krna ho to kaise kre

[abhishekmalviya]

sir need to import sales or purchase with xml code in old version of tally please help

[abhishekmalviya]

Hi sir, Need to import the sales with stock item please suggest the formula, I created some but need some help in that.

[tallyclasses]

Sir, can you tell me how to share my excel mapped template to my friend . This mapped template is working in my computer . but its not working in my friend computer . please suggest

[CaSandalJain]

Thankyou so much for this knowledge✅

Pls guide how to add cheque no, and bank reference no.

[Adarsh-ntls]

Hi sir,

Is there any option to convert a journal entry, to this table format automatically in excel?

[TheSachin]

Nice....i have not 365 but i have done with your help.

[barjisabdulla]

How can I put narration for line items using this?

[Adarsh-ntls]

Hi sir, can you help me to resolve "exemptions occured while importing data from excel to tally prime 4.1". It is showing that the debit and credit amounts are not matching. Actually it is showing equal.

[abhineetagrawal]

Hi, Thanks for the video. I tried doing the same and changed the formula for ms excel too. I was trying it for a journal entry. But tally showing error on import. How to resolve the issue?

[TheLeelarathna]

the template works with me first upload, then it didnt, an error message come like Invalkid Char for token start

[Nagarajan_K.]

Its realy a great job. Can you explain how to import sales data with inventories.

[nehajatinatara]

HELLO SIR THANKU FOR THIS VEDIO IT WORKS MAGIC, PLS HELP WITH GST 2A IMPORT FORMULAS.

[ayushsaraf]

Sir, when I use the template and incorporate information, under column H, "XML" of the excel template - it gives me an error = #NAME? Please advise how can I resolve this

[mltechnologies]

Hello Sir, I want to import quotation in tally with USD value and need to make further quotation in tally with Dutys in INR