How do I get free Excel to Tally TDL?
Tally’s development language, TDL, stands for Tally Definition Language (TDL). The steps for getting free Excel to Tally are as follows:
You’ll need a TCP file and an Excel file for this, which you’ll have to import into Tally.
Let’s look at how the TCP file should be configured. Make sure to copy and paste the location of this file anywhere you put it. Save the above directory in a location where it won’t be destroyed or misplaced by clicking on it.
After copying and pasting the complete directory as (Desktop/tally data/ fillet cp) into Tally, open the Tally Gateway and click on F12, select products and features, and there is a Manage TDL option on the left. Copy the directory and paste it into the “list of TDL Files to preload on startup” option. Also, keep it.
There will be a specific update on the tally sheet as TDLs 1 of 1 loaded. You will be given the option of importing to data after clicking on import of data.
After selecting Import to Data, you will be presented with the option of generating a sales report. The next step is to import the file. To do so, go to the excel sheet, as all of the data will be listed there, and you will see a notation at the top of the sheet that says “sales import with multi stock items in sales voucher.” Do not change the sheet name in any way.
You’ll be given the opportunity to generate a sales report after selecting Import to Data. The file must then be imported. To do so, open the excel page, which will have all of the data, and look for a note at the top of the file that says “sales import with multi stock items in sales voucher.” Make no changes to the sheet’s name.
On the sales invoice, you can include one or more stock items. You’d have to adjust a setting in the tally sheet for this specific data. Return to the tally sheet, choose the voucher type, click edit, select a method of voucher numbering, click manual, and the next option, prohibits duplicate, is set to Yes. If you don’t have a sales invoice, this approach will be used.
If you already have a sales invoice, you must create a new voucher type, name it, and pick “sales” as the kind of voucher. The method of voucher numbering will be set to manual, and the prevent duplication option will be set to yes.
The reason we chose yes for prevent duplicate is so the tally sheet will alert you if you upload the same invoice twice. Save all of your changes now.
The next step is to choose the same extract date in the tally sheet as in the excel sheet. Make precise adjustments in the Excel to Tally sheet as indicated in the Excel sheet for the alternatives. In the tally sheet, you may also choose the calculating formula.
