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....
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...
For that actually you will have to export some voucher entry having these details of Cheque & Bank reference number into XML, to study how Tally writes this information in XML & accordingly, tweak Excel formula to include these details. Simple open any of such voucher entry, press Ctrl + E, which will give you export dialog where you can chose XML format. Simply open that XML in Notepad++, where you can catch hold of this information
Inventory will be a bit complicated to fit into this template, since for every voucher, you would have inventory rows separately. XML grows pretty complex in this scenario. I would say, this approach is best suited for simple scenario, with manageable XML
Explaining that complete thing will be difficult on chat. But I will insist you to study the XML I have generated via Excel carefully, as it is the key to get all the things done. Once you are able to understand that XML, then you will very easily know that I have constructed that XML in Excel. Try breaking Excel formula in parts, since in one shot you will not understand that formula, as I have myself constructed that formula one-by-one to mock that XML
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?
Can you check exact error in the file named "tally.imp" (you will have to open it via notepad) Mostly ledger names are incorrect which causes this. Or sometimes, specific entry is not allowed through journal (I guess if you attempt to pass receipt/payment like entry it will not allow). So you need to validate it For further details, you can reach out to me over email, where I can identify problem in detail
Thankyou so much sir...... utility made by you is Excellent, But Sir When I Use this in Receipt Voucher Dr. Side appear First and Credit Side Appear Lower but in Tally Prime By Default First Appear Cr. Side & then Dr. Please make suggest how can we change this.
That can be done by a bit manipulation to that XML generating formula. You will require IF function, which will check voucher type name for receipt & based on that it will change the order of what to take first Debit or Credit. By default I have linked Debit first in that formula. So you will have to make it conditional. It is pretty tricky considering complexity of formula, but still achievable you can give it a try
ESCAPE_XML is a LAMBDA named function, i.e. a custom function without using Macros. I have covered LAMBDA function is another video on my channel which you can check out. Office 365 is required for running it. You can use Excel Online if you don't have this version of Excel. You can for sure omit it, if your Excel does not support it & you like to play with complexity (I have given instruction on how to do it without that in one of the sheet). Personally I will advice use Office 365 / Online and make your work easy.
Big Thank you 🙏 I have successfully added GST fields and import was done. Then I used it for Credit Note entries as well by making changes in formula. Now trying to add Bill number in New Reference.
@@ExcelKida Import it to tally. In the above Video, the data should be arranged in a format like 1st column Voucher Number, then Debit Account, Then Credit Account and last Amount. So is there any easy way to convert the data in a Day book format to above said excel table
1) No. Day Book is technically not a tabular format. When you press Detailed button in Day Book, Tally arranges data in an indented format. 2) At the most, you can apply PIVOT. But if you are thinking of filling up template from existing Day Book, then you will have to struggle a lot to accommodate it, and I will personally not advice it. 3) This template is intended for simple data entry, especially people use it for import of Bank Statement
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
If you have Tally Prime 4.0 or above, you can ignore this video & refer this new one, where you can directly share template to your friend. th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Not supported in this template, as this template is a very basic level. You will have to customize the XML by including narration field since each line item.
The technique will work for Tally Prime 3 & 4 as per my logic, since Tally added fields in its database, never removed. I don't find any breaking changes from perspective of external integration.
and I too gained this knowledge from you, this idea of mail merge never strike my mind, but only issue with mail merge is XML character escape. I have seen single quote character by many Tally users in ledger names
That means somewhere your XML got disbursed breaking it's structure (might be some cells with formulae were accidentally modified). Kindly download a fresh copy of this Excel file, which should resolve this
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
@@ExcelKida eagerly waiting for that. thanks a lot!! any eta for that video? Also, your videos are very helpful for small scale businesses who can't hire consultants for automation of business processes.
This template is very much suitable even for Bank Statement. Simply filter all deposit rows, copy paste date, amount, narration, write bank ledger name in Debit (credit ledger you need to fill manually looking to narration). Repeat same for withdrawal & your bank statement import is ready
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.
Instead of try using xml tag. I have used this field during data extraction to obtain forex amount of any debit/credit amount, but not sure if this trick will work for import. But definitely worth to give it a try. Will get back with a solution on this thread if I get solution in future
I have covered modification of master in this video th-cam.com/video/fQi1SVQSqXU/w-d-xo.html I will insist that wait for 2 more month for Tally Prime 4.0 where Tally might be introducing this as a feature in-built
If you watch video till end, I have shared workaround. Upload this file to OneDrive & use Office Online free version of Excel, which too supports this.
Please ensure that you are first able to see the vouchers you import in the respective ledgers. It will definitely show up in Bank Reconciliation, if Voucher Type is receipt / payment / contra
Sir excel sheet mein ek hi voucher ki 10 entry hai toh tally mein import karte time vo first entry hi leta hai baki ki 9 chod deta hai fir usse manual hi karni padhti hai toh iska koi solution hai.
यह template multi debit/credit को support नही करता है, आप Tally Prime 4.0 upgrade करोगे तो आपको inbuilt feature मिलेगा of Excel voucher import, जहा यह supported है
Not possible with this template. This method simple Accounting Entry with just debit/credit. Inventory is pretty complicated to be handled in Excel formula.
Are yaar tum sablog kya easy easy journal entry import karke bata rahe ho... Badi sales entry with address, consignee address, amount, gst, item description etc. Wali import karke batao. Xml coding me master id, product id kaise krte hai wo batao.... Aur ho sake to hindi me video bana
Videos are created considering the fact that 99% of viewers are able to try this approach, so I keep it simple. You have a customized requirement, and viewers might get confused if too many things are demonstrated since it requires some technical knowledge of Tally database structure, XML & handling of complex Excel formula. Majority of viewers might not be techno savvy like you. In which language to create & record video is entirely my own choice. I will suggest that you should try these things by own & come up with your own TH-cam video.
Hi I am not able to import the vouchers, it is showing error , please can you help Importing Data from 'D:\import.xml' on 5-Mar-23 at 18:52:55 Importing Data to company: 'S - (from 1-Apr-2020)' ERROR: Voucher: ID:, Voucher Type: Sales, Source Voucher Number: Pur/Inv, Voucher Number: , Date:
Error message is pretty unclear. Prima-facie it looks you are missing some important column in template. I can try identifying error if you can provide XML or Excel template file you have prepared
That means you have a typo with your ledger name. Sometimes in Tally ledger name has hidden characters which causes this. Just alter that ledger & re-type it's name in Tally, which might fix this issue
Just upgrade to Tally Prime 4.0 and you will enjoy easy import of Sales / Purchase. You can check out my tutorial for this (on below link) th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Amazing work sir, God Bless You. This is more useful for non accounting professionals. I am an Excel Programmer.
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
Same with me too. I scrapped my website page with same functionality, to make it easier.
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....
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...
Dhanjay Ji, it is superb,
Well explained, Dhananjay
Thank you Sir... you have prepared a very nice utility indeed. What I was looking for this... Thank you Sir..
Thankyou so much for this knowledge✅
Pls guide how to add cheque no, and bank reference no.
For that actually you will have to export some voucher entry having these details of Cheque & Bank reference number into XML, to study how Tally writes this information in XML & accordingly, tweak Excel formula to include these details.
Simple open any of such voucher entry, press Ctrl + E, which will give you export dialog where you can chose XML format. Simply open that XML in Notepad++, where you can catch hold of this information
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Try this one. You can add cheque no & bank reference field to the template
Its realy a great job. Can you explain how to import sales data with inventories.
Inventory will be a bit complicated to fit into this template, since for every voucher, you would have inventory rows separately. XML grows pretty complex in this scenario. I would say, this approach is best suited for simple scenario, with manageable XML
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Here is the video you asked for
Thanks sir excellent video!! Sir how can I pass an entry in which more than one account is credited or debited for different amount?
you need to insert few more columns & tweak this Excel formula (expression) to include few more ledger entry parts
@@ExcelKidathanks for the reply sir but that formula tweaking is what I don't know how to do.
Explaining that complete thing will be difficult on chat. But I will insist you to study the XML I have generated via Excel carefully, as it is the key to get all the things done. Once you are able to understand that XML, then you will very easily know that I have constructed that XML in Excel. Try breaking Excel formula in parts, since in one shot you will not understand that formula, as I have myself constructed that formula one-by-one to mock that XML
@@ExcelKida will try it sir.
Nice....i have not 365 but i have done with your help.
You can use Excel Online (browser based version) which is available free of cost to everyone, which supports this.
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?
Can you check exact error in the file named "tally.imp" (you will have to open it via notepad)
Mostly ledger names are incorrect which causes this. Or sometimes, specific entry is not allowed through journal (I guess if you attempt to pass receipt/payment like entry it will not allow). So you need to validate it
For further details, you can reach out to me over email, where I can identify problem in detail
Thankyou so much sir...... utility made by you is Excellent, But Sir When I Use this in Receipt Voucher Dr. Side appear First and Credit Side Appear Lower but in Tally Prime By Default First Appear Cr. Side & then Dr. Please make suggest how can we change this.
That can be done by a bit manipulation to that XML generating formula. You will require IF function, which will check voucher type name for receipt & based on that it will change the order of what to take first Debit or Credit. By default I have linked Debit first in that formula. So you will have to make it conditional. It is pretty tricky considering complexity of formula, but still achievable you can give it a try
Sir Can You Change this, i Try many time but not do
Great. Can you please explain how you created ESCAPE_XML , Can I omit this function as the same is not there in my PC/Laptop ?
ESCAPE_XML is a LAMBDA named function, i.e. a custom function without using Macros. I have covered LAMBDA function is another video on my channel which you can check out. Office 365 is required for running it. You can use Excel Online if you don't have this version of Excel. You can for sure omit it, if your Excel does not support it & you like to play with complexity (I have given instruction on how to do it without that in one of the sheet). Personally I will advice use Office 365 / Online and make your work easy.
Big Thank you 🙏
I have successfully added GST fields and import was done.
Then I used it for Credit Note entries as well by making changes in formula.
Now trying to add Bill number in New Reference.
GENEOUS. SUPERB.
HELLO SIR THANKU FOR THIS VEDIO IT WORKS MAGIC , PLS HELP WITH GST 2A IMPORT FORMULAS.
This template is suitable for simple double entry with single debit & credit
Thank You Soo Much Sir.
Hi sir,
Is there any option to convert a journal entry, to this table format automatically in excel?
Not really getting if your question is related to import into Tally or export from Tally ?
@@ExcelKida Import it to tally. In the above Video, the data should be arranged in a format like 1st column Voucher Number, then Debit Account, Then Credit Account and last Amount. So is there any easy way to convert the data in a Day book format to above said excel table
1) No. Day Book is technically not a tabular format. When you press Detailed button in Day Book, Tally arranges data in an indented format.
2) At the most, you can apply PIVOT. But if you are thinking of filling up template from existing Day Book, then you will have to struggle a lot to accommodate it, and I will personally not advice it.
3) This template is intended for simple data entry, especially people use it for import of Bank Statement
Kindly provide us with the video of how to create multiple ledgers
Sure, I will plan of it
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Here is the video you were looking for
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
If you have Tally Prime 4.0 or above, you can ignore this video & refer this new one, where you can directly share template to your friend.
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
How can I put narration for line items using this?
Not supported in this template, as this template is a very basic level. You will have to customize the XML by including narration field since each line item.
Most easy.
Hello Sir, I want to import quotation in tally with USD value and need to make further quotation in tally with Dutys in INR
Not really sure if quotation can be implemented by modifying this template, since it is optional type of voucher & it has stock items in it.
Hello sir, Sir Journal Voucher me Ek Ledger ko Dr. or 2 ledger ko cr. krna ho to kaise kre
Refer this video, where I have demonstrated this
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Can u pls make a video of importing vouchers in tally prime 3
The technique will work for Tally Prime 3 & 4 as per my logic, since Tally added fields in its database, never removed. I don't find any breaking changes from perspective of external integration.
thank you @@ExcelKida
sir need to import sales or purchase with xml code in old version of tally please help
Refer this video where I have demonstrated this
th-cam.com/video/N4LTeqEJc2U/w-d-xo.htmlsi=VjOQcnZloLtlZDcA
Do you have excel to tally sales / purchase with inventory template?
Inventory is pretty complicated thing to accommodate in this template. This template supports simple accounting voucher
Try this video, I released. It does your job
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
I was doing the same thing usig word mail merge utility with Excel
You Teach me another option
and I too gained this knowledge from you, this idea of mail merge never strike my mind, but only issue with mail merge is XML character escape. I have seen single quote character by many Tally users in ledger names
Please share the template of purchase and sales with Account invoice mode
Invoice Mode requires too much modification in XML, which is pretty complex to be demonstrated & developed. This template is for simple scenarios.
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Try this one
the template works with me first upload, then it didnt, an error message come like Invalkid Char for token start
That means somewhere your XML got disbursed breaking it's structure (might be some cells with formulae were accidentally modified). Kindly download a fresh copy of this Excel file, which should resolve this
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
That means you don't have updated version of Office 365, which recently gave support to LAMBDA function.
Which version of excel you are using anyway ?
the excel template is not downloaded sir
Please give me suggestion
Issue is fixed now
Hi sir, how to do with cost centres using this template
Unfortunately cost centre not supported, as it is complex to accommodate in this Excel template
Thank You Sir@@ExcelKida
I want to upload multiple item sales data from excel to tally. Any video on that?
That template is in-development process. Will release it along with video as soon as I complete it. Keep an eye on my TH-cam channel
@@ExcelKida eagerly waiting for that. thanks a lot!! any eta for that video?
Also, your videos are very helpful for small scale businesses who can't hire consultants for automation of business processes.
@@ExcelKida also any video for bank statement from excel to tally coming soon?
This template is very much suitable even for Bank Statement. Simply filter all deposit rows, copy paste date, amount, narration, write bank ledger name in Debit (credit ledger you need to fill manually looking to narration). Repeat same for withdrawal & your bank statement import is ready
Cannot commit anything on ETA since I have acute shortage of time. I just maintain to-do list which guides me for upcoming videos
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.
Ensure you don't have rounding off differences.
@@ExcelKida No round offs
Email me your XML
how to adjust receipt voucher against bills no
Not supported by this excel template. It supports purely double entry scenario only
Sir Please can you tell me how to import multi currency transaction
Instead of try using xml tag. I have used this field during data extraction to obtain forex amount of any debit/credit amount, but not sure if this trick will work for import. But definitely worth to give it a try. Will get back with a solution on this thread if I get solution in future
Can you please tell me how to add auto voucher number thanks in advance
Leave voucher number column blank, Tally will itself take care it
Sir i want to import master same like this with pan number
I have covered modification of master in this video
th-cam.com/video/fQi1SVQSqXU/w-d-xo.html
I will insist that wait for 2 more month for Tally Prime 4.0 where Tally might be introducing this as a feature in-built
Sir please help in my laptop I don't have activated office 365 so XML column show as #NAME Error please help what I can do
If you watch video till end, I have shared workaround. Upload this file to OneDrive & use Office Online free version of Excel, which too supports this.
Thank you sir👍🙏🏻
Sir agar same date main 1 se jyada debit ho aur ek hi credit ho toh yeh kaise input file banani hogi?
इस्केलिये Tally Prime 4.0 वाला एक video बनाने वाला हु जिसमे यह दिखाया जायेगा
Jald banao sirji@@ExcelKida
th-cam.com/video/p1HmeTWXHP0/w-d-xo.html
hello sir how to add cost center
Adding cost centre to this will complicate template format a lot. Will not recommend this approach for cost centre.
Please send me vedio of image to talky import invoice
I have not made this video or used this technique. But this might help you
th-cam.com/video/kZ2TCBkO8H8/w-d-xo.htmlsi=uGQCxDBJNojZkAz5
hi sir this entry is not showing in bank reconciliation
Please ensure that you are first able to see the vouchers you import in the respective ledgers. It will definitely show up in Bank Reconciliation, if Voucher Type is receipt / payment / contra
@@ExcelKida I have done some amendments in the formula and added the cost center also now its working. Thank you
Great to hear that you managed to modify the template further to accommodate cost centre too
Sir sale import tally prime pe videos banaye
Sure. Once my demo data for purchase/sales register gets ready, I will be making a video on that
SIR IN XMAL COLUMN , #NAME? ERROR WAS SOWING
That means you don't Office 365 version of Excel. This template requires Office 365
Sir excel sheet mein ek hi voucher ki 10 entry hai toh tally mein import karte time vo first entry hi leta hai baki ki 9 chod deta hai fir usse manual hi karni padhti hai toh iska koi solution hai.
यह template multi debit/credit को support नही करता है, आप Tally Prime 4.0 upgrade करोगे तो आपको inbuilt feature मिलेगा of Excel voucher import, जहा यह supported है
@@ExcelKida accha thank u kal karke dekhta hoon
th-cam.com/video/p1HmeTWXHP0/w-d-xo.html
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
This supports multiple debit/credit
pl shaire code with bill gst import
This method support simply double entry only
Import with inventory
Not possible with this template. This method simple Accounting Entry with just debit/credit. Inventory is pretty complicated to be handled in Excel formula.
Xml line send
???
Sir I want class from you ....massage me on
Currently due to time crunch, treat my videos as class. More videos coming
Are yaar tum sablog kya easy easy journal entry import karke bata rahe ho... Badi sales entry with address, consignee address, amount, gst, item description etc. Wali import karke batao. Xml coding me master id, product id kaise krte hai wo batao.... Aur ho sake to hindi me video bana
Videos are created considering the fact that 99% of viewers are able to try this approach, so I keep it simple. You have a customized requirement, and viewers might get confused if too many things are demonstrated since it requires some technical knowledge of Tally database structure, XML & handling of complex Excel formula. Majority of viewers might not be techno savvy like you. In which language to create & record video is entirely my own choice. I will suggest that you should try these things by own & come up with your own TH-cam video.
@@ExcelKida True , thanks for making these knowledgeable videos, i am inspired to explore more between tally and Excel, thank you!
Hi I am not able to import the vouchers, it is showing error , please can you help
Importing Data from 'D:\import.xml' on 5-Mar-23 at 18:52:55
Importing Data to company: 'S - (from 1-Apr-2020)'
ERROR: Voucher: ID:, Voucher Type: Sales, Source Voucher Number: Pur/Inv, Voucher Number: , Date:
Import Summary
Created : 0
Altered : 0
Deleted : 0
Combined: 0
Ignored : 0
Errors : 1
----------------------------------------------
Error message is pretty unclear. Prima-facie it looks you are missing some important column in template.
I can try identifying error if you can provide XML or Excel template file you have prepared
@@ExcelKida I think it was because I am using educational mode, when I tried it on office laptop (silver license) it worked
Hi sir, Need to import the sales with stock item please suggest the formula, I created some but need some help in that.
I have already demonstrated this. Check out below video
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html
Sir event log error showing and it mentioned ledger not found
That means you have a typo with your ledger name. Sometimes in Tally ledger name has hidden characters which causes this. Just alter that ledger & re-type it's name in Tally, which might fix this issue
Thankyou sir could you please provide sales and purchase format for tally 2.0
Just upgrade to Tally Prime 4.0 and you will enjoy easy import of Sales / Purchase. You can check out my tutorial for this (on below link)
th-cam.com/video/N4LTeqEJc2U/w-d-xo.html