What is T-CAAT?
- T-CAAT (Tally Computer Assisted Audit Techniques)
- One stop solution for Extracting Data of Masters, Transactions and Reports from Tally to MS Excel in a few Clicks.
- One stop solution for Importing Data of Masters and Transactions from MS Excel to Tally in a few Clicks.
- Perform Audit Tests and Dynamic Data Analytics & BI!
Why Use T-CAAT?
- Supplement Simplicity of Tally With Power Of Data Analytics Of MS Excel!
- Extract Data of Masters, Vouchers, Registers & Reports From Tally to MS Excel!
- Generate Various types of Reports and Summaries Useful for Audit/MIS in MS Excel from Tally Data in a Few Clicks!
- Perform further analysis as required using MS Excel or Data Analytics Software with the data exported in structured format.
- Supplements Powerful features of Tally with simplicity of MS Excel and Avoid manual data entry, related errors, save Time & Enhance Productivity.
- Build with simple Interface to import masters and vouchers from Excel templates into Tally in a few clicks.
- Use Specific standard formats to convert data of different types of Transactions into Tally vouchers for importing into Tally a few clicks.
Key Features of T-CAAT
Tally Master
Displays general info,master info from Tally of company, accounting, inventory, cost centre, compliances & payroll and ready-made queries for specific master info.
Accounting & Inventory
Displays transactions of accounting based on selected criteria, ledger vouchers, cash and bank transactions, inventory transactions and master data of accounting from Tally.
Cost Centre
Displays cost centre transactions and master data including category-wise, ledgerwise and cost centre-wise breakup reports from Tally.
Payroll
Displays payroll transactions and master data including salary and employee details from Tally.
Reports
Displays information from Registers of Sales, Purchase and Journal.
Analyse
Displays information from Tally and compliance features including exceptions. Provides overall statistics and option to validate GSTIN/Patterns of Ids and generate trendline reports.
Schedule III
Provides guidelines & instructions for the preparation of fin.statements, which include the BS, the statement of PnL, CFS, notes to accounts or notes to fin.statements and related statements of a company.
Import2Tally
Provides options to import/update masters/vouchers of Accounting, Inventory and Cost Centres.
Data Conversion Tool
Provides Formats/Functions for converting/importing transactions in different formats of Sales, Purchases, Services/JVs, Bank Statements, Reciept/Payment and Salaries.Benefits of T-CAAT?
- Add On software to MS Excel with 93 functions for extracting data from Tally.
- Enables users to import Masters, Vouchers And Registers from Tally directly into MS Excel in a few clicks.
- Provides all the information in structured format so that furthur analysis can be done easily in MS Excel.
- Provides Masters and Vouchers for various modules of tally such as Accounting, Inventory, Cost Centre and Bill wise.
- Provides Registers for Sales, Purchase and Journal with Vouchers, Extract & Columnar.
- Faster extraction of information from Tally as reports are directly extacted through query and XML for required or specified data.
- Provides option to generate Schedule-III reports.
- Automate Import in bulk / Input single entries from Excel to Tally using standard templates.
- Import Masters/Vouchers of Accounting, Inventory & Cost Centre from Excel Worksheets to Tally.
- Export Masters/Vouchers/Reports from Tally to Excel in structured format for Analysis.
Functions of T-CAAT
| SL.No | Panels / Menus | Primarily Used For | T-CAAT |
|---|---|---|---|
| 1 | Export from Tally | Extract Vouchers,Masters,Inventory,CC,Payroll & Reports | 78 |
| 2 | Import to Tally | Import Masters & Transactions | 05 |
| 3 | Data Conversion Tool | Convert Raw data to Structured Format | 08 |
| 4 | Tools | Displays Import Log & Search and Run | 02 |
| Total | 93 | ||