Integrated Case Study for Advanced ITT: FORENSIC ACCOUNTING AND FRAUD DETECTION & ERP AUTOMATION
Objective:
To provide CA students with hands-on experience in handling real-world accounting, finance, and audit scenarios by integrating Tally with automation tools like Excel, Power BI, and Python.
Case Background: ABC Enterprises Pvt. Ltd.
ABC Enterprises Pvt. Ltd. is a mid-sized company operating in the FMCG sector. It has multiple branches across India and uses Zoho Books for its cloud-based accounting while maintaining a Tally ERP system at the HQ for internal reporting and compliance.
The finance team faces challenges in:
Data Reconciliation: Differences between Tally and Zoho Books.
Accounts Payable & Receivable (AP/AR) Aging Analysis: Overdue invoices and vendor payments.
Inventory Management & Cost Control: Discrepancies in stock reports.
GST Compliance & E-Invoicing: Managing ITC mismatches.
Automation & Reporting: Manual effort in preparing financial reports.
As a consultant, your role is to automate, analyze, and improve decision-making using IT tools.
Module 1: Setting Up ERP and Data Import
Tasks
Set up Tally and Zoho Books with master data.
Import past 12 months’ transactions into both ERPs.
Compare GL balances, trial balance, and ledgers between Tally & Zoho.
Automation:
Identify the Required reports in Both the ERP's Refer Tally SQL viewtopic.php?t=35
Refer tally Pyhton integration here viewtopic.php?t=47
Refer Tally TDL Here viewtopic.php?t=44
Excel Macro \ Python to extract reports from Zoho & Tally and format for comparison. Python Script to automate data transformation. Extract the data in Excel / CSV File