Guide · TallyPrime to Excel
Export the Tally Day Book and vouchers to Excel
Auditors and accountants often need every voucher for a period in Excel: the Day Book, the cash and bank book and the voucher registers. Here are two ways to get them out of TallyPrime.
In TallyPrime, one report at a time
- Open the company in TallyPrime.
- Open the Day Book: press Alt+G (Go To) and type Day Book.
- Press Alt+F2 and set the period you need.
- Press Ctrl+E to export the current report. Set the file format to Excel, check the folder, then press E to export.
- Repeat for each register you need, such as the Journal, Payment, Receipt and Contra registers and the Cash or Bank Book. Each one becomes its own file.
This is fine for one or two reports. For an audit file you usually need many registers for the same period, which means many exports and then combining the files by hand.
With TExtract, every register in one workbook
- Set up once. Turn on TallyPrime's ODBC server on port 9000 and load the small TDL file TExtract gives you. The setup video shows each step.
- Set the period in TallyPrime. Open the company and press Alt+F2 to set the period.
- Tick the reports. In TExtract, pick the same period and tick All Vouchers, Day Book, Cash-Bank Book, Journal Register and the Contra, Payment and Receipt registers.
- Click Extract. When it says DONE, one Excel workbook is waiting in your output folder, with one sheet per report and an Index sheet on top.
Need the narration on every line? Tick Narration columns. They are off by default because on a large company they can make a run up to ten times longer.
What you get
- One workbook for the whole period, one sheet per report.
- An Index sheet with the company, the period, the sheets and their row counts.
- The sales, purchase, GST and ledger reports in the same run if you tick them. See GST registers to Excel.
- TExtract only reads. Nothing changes in Tally, and your data stays on your computer.
Tips
- Always set the same period with Alt+F2 in TallyPrime as in TExtract, so every sheet covers the same dates.
- TExtract is in beta. Check important figures against Tally.