Getting the daybook data in excel friendly format

Опубликовано: 19 Май 2026
на канале: mndatasolutions
72
0

Helping our accountant friends get access to Tally data in a single Excel file as in a daybook
whom is this for?
a.) Accountants with large firms using Tally
b.) Accounting Freshers looking for an edge in interviews
c.) Excel developers looking for openings with Tally companies. Using Excel for easy development
d.) Mobile app developers
e.) Integration personnel

Whom is it for?
a.) Tally accountants
b.) Excel developers
c.) SQL developers

Problem statement: Most people get the complete transaction history in the daybook from Tally. The daybook gives complete export in
xml format. The xml format has compound data objects, is difficult to understand. The ASCII format currently does not give complete output.

We help resolve this issue through the following using our tool(Json and sql server 2020):
a.) Give complete Tally schema(ledger movement, inventory movement and bill movement) in one pivot friendly table. The sundry debtors/sundry creditors
gives the bill history movement. Tne sales accounts, purchase accounts give the inventory movements
b.) The final table can be used for data insertion into Tally also(bidirectional)

b.) The batch movements aand cost centre additions are work in progress.

Applications:
a.) Get the full transaction movements in one table
b.) Insert corrected bill data into Tally
c.) Extended version of the report includes group, ledger, stock group and stock item details additions also.
whom is it for?
a.) aaccountants for audit purposes
b.) Job seekers accountants for quicker processing
c.) Excel developers to help automation.

Name: apoorv chaturvedi
email: [email protected];[email protected]
Phone:+91-8802466356