Tally allows only limited features in its Education Mode, which allows you to pass entries only on opening and closing dates of a Month. The same applies while exporting data to excel. Only opening and closing entries have date along with them and the rest labeled as “Educational Mode”.

There is easy workaround for getting the complete data with date. All you have to do is export the data into HTML(Web Publishing) format.

Once you have selected to export the data, Tally shows various options including Export format. Select the HTML (Web Publishing) format as shown in the image.

Select the HTML(Web Publishing) format

Then once you export, open the exported file in any browser (e.g. Google Chrome, IE, Edge) and it will display the entire Ledger/Report in a webpage and now all you have to do is to select all (Ctrl + A) then open an Excel sheet and do a Value Paste or normal paste and then remove default Tally Formatting.

Tags:

Author Bio

More Under CA, CS, CMA

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

October 2020
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031