Please consider supporting our work with a contribution to wikiHow. Depending on the nature of your business, it can be created in the Invoice mode or Voucher mode. 4. Must Read: How to prepare Pay slip, Payroll report in Tally. In Tally ERP9 Voucher type is the data entry form or templates where we can enter different types of transactions like Sales,Purchase,Receipt etc. Emp Name : Mr. Rahul Present Days   : 26 Days. Open the exported .xml file in Notepad++ and open your vouchers in Excel that you want to import to Tally. You can use attendance voucher to record one or more employees attendance data. Step 3: If you need to give the additional information then use narration field and save the entry. Tally shortcut keys – Functionality (Available screens) F1 – To select a company (At all masters menu screen) F1 – To select the Accounts Button (At the Accounting Voucher creation and Alteration screen) ALT+F1 – To select the Inventory (At the Inventory/Payroll Voucher creation and alteration screen) Insert blank columns between each column in your Excel project (including a blank first and last column). The invoice format enables users to print a copy of invoices for customers. A payment voucher in Tally ERP 9 software is a sort of proof of the monetary transaction done between two parties. If the ledger creation is perfect and you post vouchers correctly then Tally.ERP 9 will give you a balance sheet or a trail balance automatically. Sales Voucher in Tally Sales voucher is one of the most used accounting vouchers in Tally. To Cash/Bank a/c 59,000 . Check the Day Book to see a list of the vouchers you imported from Excel. Multi-user auto voucher numbering helps: Tally Main → Gateway of Tally: Step 1: To enter the voucher creation screen, select the menu option 'Accounting Vouchers'. We've been helping billions of people around the world continue to learn, adapt, grow, and thrive for over a decade. You can create, delete or modify other vouchers as per your requirement. To record this detail in payroll voucher you have to take following given steps. Three types of payroll vouchers in Tally ERP 9 with the name of Attendance, Payroll and Payment vouchers. Select the Account Cash or Bank > under particulars select the appropriate creditors ledger > fill the amount and accept the voucher. 2. The Payroll voucher in Tally ERP 9 is used to record and compute the value in different pay heads for one or more employees. Now you can choose any required option to view or print the Payroll reports. Go to Gateway of Tally > Accounting Vouchers > F5: Payment . Introduction to Voucher Entry in Tally.ERP 9 A voucher is a document that contains details of a financial transaction and is required for recording the same into the books of accounts. this is a quick save option. Edit the Excel project to match the .xml file format and copy the main data from the .xml file into a new file. 1. If view all the transactions use Alt+F2 and set the period based on your requirement. You can easily record any employee attendance or production units in active company. Hello, Your questions little ambiguous Still I will try to give you both possible answers. Payroll Ledger: Select the Cash in this field and press enter. Now All set just select template file in software using Purchase with Inventory Button & Click on Import Button, . Step 2: Press F2 and fill the date in the respective date field and press enter. You can easily create payslip, statement of payroll, attendance sheet or attendance register using these vouchers. Note that the header and footer sections of the ""DayBook.xml" file are left alone. For eg: If you have an employee and entitled them for variable pay for the month of Aug 2017. Notepad++ will color-code the tags for you, which is why it is recommended, but if you don't need that feature, you can use any word-processor. These are used for recording different types of transactions. Now tally shows all the transactions recorded between the period you have entered. You must have to choose bank name in Bank / Cash Ledger and Salary Payable in Payroll Ledger option in Payment Auto Fill box. During working on Attendance voucher you can use Alt+A (auto fill) shortcut key. You can also use Alt+A (Auto Fill) … Tally 9 allows users to record memorandum vouchers which is a non accounting voucher and entries through a memorandum voucher in tally 9 does not affect the accounting books.. First, you will need to create a template in Tally so you know how to format your Excel data, then you need to format your Excel data accordingly, finally, you can transfer that to the formatted voucher from Tally and import all the voucher information. If you are satisfied then press ‘ESC’ key and again you will come back in previous screen. Create a voucher by clicking Accounting Vouchers in the Gateway of Tally window then select F7: Journal to create the appropriate voucher. Go to Gateway of Tally >select Accounting Vouchers > Press F5 key : Payment. Employee Category: Select the Primary Cost Category or another category which you create in active company. Note: To add the voucher reference number and date, press F12 and enable the option Use ref. 4 Open the day book. Copy and paste a line of static data from your .xml file into the blank columns in Excel then drag and drop to autofill the rest of the rows in each column (each row has different data). These are Attendance voucher Payroll voucher and Payment voucher. To view different Payroll Reports you have to go on GOT > Display > Payroll Reports. 9. For every transaction, you can use the appropriate Tally voucher to enter the details into the ledgers and update the financial position of the company. This wikiHow will teach you how to import vouchers from Excel to Tally on your computer. Vouchers 2. Entry . Step 1: Open the Payment voucher from GOT > Accounting Vouchers > Press F5. Now Tally displays the list of vouchers based on the last date of transaction. From (blank for beginning): Fill the starting date for the month of Aug 1-8-2017. In the business realm, the payment voucher brings in a variety of benefits. In Tally.ERP 9, you can pass payroll vouchers manually for individual employee as well as for the entire group/ organisation by using the Auto Fill facility (Alt+A). But with the arrival of COVID-19, the stakes are higher than ever. In Tally.ERP 9 Voucher entry section is the place where you can feed your data in the software. .Employee Group: You can select one or more groups as per your need. The Payroll voucher in Tally ERP 9 is used to record and compute the value in different pay heads for one or more employees. 10. Step 1: Open the Gateway of Tally (GOT) > Payroll Vouchers > Press Ctrl+F5 to open the Attendance voucher. Open Tally, make the necessary ledgers, and create a journal voucher. 8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/12427118-1.jpg\/v4-460px-12427118-1.jpg","bigUrl":"\/images\/thumb\/e\/e2\/12427118-1.jpg\/aid12427118-v4-728px-12427118-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense: Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/72\/12427118-2.jpg\/v4-460px-12427118-2.jpg","bigUrl":"\/images\/thumb\/7\/72\/12427118-2.jpg\/aid12427118-v4-728px-12427118-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/45\/12427118-3.jpg\/v4-460px-12427118-3.jpg","bigUrl":"\/images\/thumb\/4\/45\/12427118-3.jpg\/aid12427118-v4-728px-12427118-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/12427118-4.jpg\/v4-460px-12427118-4.jpg","bigUrl":"\/images\/thumb\/e\/e1\/12427118-4.jpg\/aid12427118-v4-728px-12427118-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/93\/12427118-5.jpg\/v4-460px-12427118-5.jpg","bigUrl":"\/images\/thumb\/9\/93\/12427118-5.jpg\/aid12427118-v4-728px-12427118-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/37\/12427118-6.jpg\/v4-460px-12427118-6.jpg","bigUrl":"\/images\/thumb\/3\/37\/12427118-6.jpg\/aid12427118-v4-728px-12427118-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/12427118-7.jpg\/v4-460px-12427118-7.jpg","bigUrl":"\/images\/thumb\/2\/21\/12427118-7.jpg\/aid12427118-v4-728px-12427118-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b4\/12427118-8.jpg\/v4-460px-12427118-8.jpg","bigUrl":"\/images\/thumb\/b\/b4\/12427118-8.jpg\/aid12427118-v4-728px-12427118-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/10\/12427118-9.jpg\/v4-460px-12427118-9.jpg","bigUrl":"\/images\/thumb\/1\/10\/12427118-9.jpg\/aid12427118-v4-728px-12427118-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/12427118-10.jpg\/v4-460px-12427118-10.jpg","bigUrl":"\/images\/thumb\/8\/8f\/12427118-10.jpg\/aid12427118-v4-728px-12427118-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5a\/12427118-11.jpg\/v4-460px-12427118-11.jpg","bigUrl":"\/images\/thumb\/5\/5a\/12427118-11.jpg\/aid12427118-v4-728px-12427118-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/12427118-12.jpg\/v4-460px-12427118-12.jpg","bigUrl":"\/images\/thumb\/a\/ac\/12427118-12.jpg\/aid12427118-v4-728px-12427118-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/12427118-13.jpg\/v4-460px-12427118-13.jpg","bigUrl":"\/images\/thumb\/f\/f0\/12427118-13.jpg\/aid12427118-v4-728px-12427118-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6a\/12427118-14.jpg\/v4-460px-12427118-14.jpg","bigUrl":"\/images\/thumb\/6\/6a\/12427118-14.jpg\/aid12427118-v4-728px-12427118-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/12427118-15.jpg\/v4-460px-12427118-15.jpg","bigUrl":"\/images\/thumb\/9\/95\/12427118-15.jpg\/aid12427118-v4-728px-12427118-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/80\/12427118-16.jpg\/v4-460px-12427118-16.jpg","bigUrl":"\/images\/thumb\/8\/80\/12427118-16.jpg\/aid12427118-v4-728px-12427118-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/12427118-17.jpg\/v4-460px-12427118-17.jpg","bigUrl":"\/images\/thumb\/1\/1d\/12427118-17.jpg\/aid12427118-v4-728px-12427118-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/12427118-18.jpg\/v4-460px-12427118-18.jpg","bigUrl":"\/images\/thumb\/a\/a3\/12427118-18.jpg\/aid12427118-v4-728px-12427118-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/12427118-19.jpg\/v4-460px-12427118-19.jpg","bigUrl":"\/images\/thumb\/e\/ed\/12427118-19.jpg\/aid12427118-v4-728px-12427118-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/92\/12427118-20.jpg\/v4-460px-12427118-20.jpg","bigUrl":"\/images\/thumb\/9\/92\/12427118-20.jpg\/aid12427118-v4-728px-12427118-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0f\/12427118-21.jpg\/v4-460px-12427118-21.jpg","bigUrl":"\/images\/thumb\/0\/0f\/12427118-21.jpg\/aid12427118-v4-728px-12427118-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

Image by: Uploader
\nLicense:
Creative Commons<\/a>\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/12427118-22.jpg\/v4-460px-12427118-22.jpg","bigUrl":"\/images\/thumb\/7\/75\/12427118-22.jpg\/aid12427118-v4-728px-12427118-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"