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...
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N4LTeqEJc2U.html
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
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
@@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
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.
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
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
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.
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 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) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N4LTeqEJc2U.html
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.
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.
I have covered modification of master in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fQi1SVQSqXU.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
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
@@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
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
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 है
I have not made this video or used this technique. But this might help you ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kZ2TCBkO8H8.htmlsi=uGQCxDBJNojZkAz5
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 RU-vid 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: 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
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.
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