Getting data directly from Tally into MS Excel for further analysis is a big challenge due to formatting issues. It is also time-consuming and data even after formatting may not be feasible for further analysis.

The solution is T-CAAT which is an Add-In Software to MS Excel that facilitates data analytics for tally data by Importing data of Master, Transactions and Reports from Tally to MS Excel in a structured format in a few clicks.

Salient Features of T-CAAT:

Faster extraction of information from Tally as reports are directly extracted through query and xml for required/specified data.

The functions executed are automatically documented in excel log and activities log. T-CAAT also provides option to Link workbook with specific company for future printing/reference. You can rerun tasks (functions performed) to re-perform any of selected functions performed earlier.

• Why: Supplement simplicity of Tally with power of Data Analytics of MS Excel
• Who: Auditors and Accounting professionals, CXOs, Compliance Managers, etc.
• How: Select specific menu/function to import relevant info into MS Excel
• When: Extract specific/all information in a structured format for further/detailed analysis in MS Excel

How to use T-CAAT

1. Open Tally and select company and period for which data is to be imported.
2. Identify specific master/trans. data or report required to be imported from Tally.
3. Open MS Excel and click on T-CAAT Tab.
4. Use specific function of T-CAAT to get required data into MS Excel Worksheet(s).
5. Review the data in MS Excel Worksheet(s) and analyze as required.

You can do more analysis with Tally Data in less Time by using T-CAAT. Empower Tally Data with Insightful Data Analytics using T-CAAT/MS Excel.

Comparison based on Panels/Menus/Functions
Sl.	Tabs	Primarily	No. of Functions
No.	Panels/Menus	Used For	Ent	Pro
1	Configure, Docs & Profile	Configure, Docs and profile Tally Data	12	4
2	Accounting	Extract Vouchers/Masters & Perform Queries	22	10
3	Inventory, CC & Payroll	Extract Vouchers/Masters: Inventory, CC & Payroll	21	15
4	Reports & Tools	Extract Sales, Purchase & Other Reports	16	13
5	Analyse	Extract Reports of Scrutiny, Exceptions, summaries.	16	NA
	Total		87	42
Note: Some of Panels/Menus may be Re-arranged/Renamed in the Software

Comparison based on Features
Sl.	Features	Primary	No. of Functions
No.	Types	Benefits	Ent	Pro
1	Configure, Docs and Profile	Configure, Docs and profile Tally Data	12	3
2	Masters & Vouchers	Export Masters & Vouchers/Reports as required	59	39
3	Analyse	Export Audit info/statistics from Tally	16	NA
	Total		87	42
Note: Many of the functions could be used for multiple purposes. For example. The same function could be used for DA or BI/MIS or even as utility to analyse data. However the above grouping is most possible use.

Overview of Key Features of T-CAAT Pro: Data Analytics Software for Tally       

T-CAAT Videos

Webinar Recordings - Practical Case Studies of using T-CAAT for Assurance/Compliance!

T-CAAT - User Presentations