The details of a financial transaction can be contained in vouchers.You can learn how to import vouchers from excel to tally on your computer.First, you need to create a template in Tally so you know how to format your excel data, and then you can transfer that to a formatted voucher from Tally and import all the voucher information
Step 1: You can open the tally.
You can find it in your Start menu.It is not available on macOS.
Step 2: The necessary ledgers need to be made.
If you have a ledger for each account that you do business with, you can keep track of all transactions.Click in the Gateway of Tally window to create ledgers.Select to create multiple ledgers or a single ledger, then select the appropriate group, and enter information like the ledger name and the opening balance.
Step 3: A journal voucher can be created.
To format a voucher the same way in excel, you need to create a template in Tally.Click on the Gateway of Tally window to create a voucher.
Step 4: The day book can be opened.
You can see the voucher you created by clicking on the Gateway window.
Step 5: Press Alt+E if you want to.
You can use this window to create an.xml file from the voucher you've created.
Step 6: Select Yes.
Your voucher will be sent to the "DayBook.xml" folder in your File Explorer.
Step 7: You can open your project in excel.
If you want to right-click the file project in File Explorer, you can do that from the Start menu.
Step 8: "DayBook.xml" can be opened in a word-processor.
You want to be able to see the order of columns as well as the text format for numbers, dates, amounts and the rest of the data fields.If you don't need the color-coded tags, you can use any word-processor.
Step 9: Take the data from your excel sheet and put it in the.xml file.
You'll need to drag columns to the same position, make sure the date is in YYYYMMDD, limit the number of decimals to two, and change the currency format.
Step 10: The information should be copied between the lines.
This is where you need to change the coding.
Step 11: You can copy the code into a new file.
To change the language to "XML", just press to create a new file.The footer and head of the "DayBook.xml" file are left alone.
Step 12: The data can be removed from VOUCHER>.
You need to remove everything that is listed after VOUCHER> as well as the entire tags and coding.
Step 13: Use a single line to format the code.
To create a single line, you can either manually remove all the spaces or use the Find/Replace tool.
Step 14: The data should be separated into new lines.
Go through your code and create new lines to separate the static values from the variable data.The code could look like this.
Step 15: You can put blank columns into your excel sheet.
Before and after your data are included in the blank columns between each of your existing columns.
Step 16: Attach a line of static data from your.xml file to the blank columns in excel.
Tag data like TALLYMESSAGE> should be put into the first row of each column.If row 1 is a line of titles and headings, you'd paste TALLYMESSAGE/> into cell A2.
Step 17: Put in the rest of the rows.
You can drag the information down the column to fill each row by using the auto-fill handle.
Step 18: The "Concatenate" function can be used in the last column of each row.
To get a complete coding of each column, enter "Concatenate(ALLYOURCOLS)".You could enter something like "Concatenate(A2,B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2).
Step 19: You can drag and fill the rest of the rows.
The auto-fill handle can be used to drag the formula down the column to fill each row.
Step 20: The data from the last column should be copied.
You can copy the information by selecting the last column.
Step 21: Attach the data in your file to the test data.
The data is between the two lines.If the language is set to "XML", it will save as an.xml file.
Step 22: You can change the import settings.
To change "Ignore errors and continue during data import" to "Yes", open the Configuration menu.
Step 23: You can import data from the gateway of tally.
It's under the heading "Import".
Step 24: Select the vouchers you want.
If you open the window, you can change the file name to import.You can check the Day Book for a list of the vouchers you imported.