Diploma in Computerized Financial Accounting

Part 1: Tally Prime

• Company Setup & Architecture: Creating, altering, and configuring companies in Tally Prime, along with setting up the chart of accounts (Groups and Ledgers).
• Voucher Entry Operations: Mastering accounting vouchers including Sales, Purchases, Receipts, Payments, and Contra entries.
• Inventory & Stock Management: Setting up stock groups, categories, units of measure, and managing multiple godowns/warehouses.
• Bill-wise Details: Tracking outstanding balances of suppliers and customers, and setting credit limits/periods.
• GST Invoice: Generating GST-compliant invoices with automated calculations for CGST, SGST, and IGST,
• TDS Compliance: Setting up Tax Deducted at Source (TDS), deducting tax on expenses, and generating TDS reports.
• Cost Centres & Profit Centres: Allocating business expenses and revenues to specific departments, branches, or projects for micro-level analysis.
• Manufacturing & Bill of Materials (BOM): Creating item configurations to track raw materials consumed and finished goods produced.
• Financial Reporting & Security: Generating instant Balance Sheets, P&L accounts, and setting up Tally Vault user access controls.

Part 2: Advanced Excel

• Data Retrieval & Lookups: Mastering XLOOKUP, VLOOKUP, HLOOKUP, and INDEX-MATCH to pull data across heavy financial files.
• Advanced Pivot Tables: Summarizing thousands of raw transaction rows instantly into clean, readable sales and expense reports.
• Logical & Financial Formulas: Utilizing formulas like IF, IFS, AND, OR, alongside financial functions like PMT (EMI calculations) and FV (Future Value).
• What-If Analysis & Forecasting: Using Goal Seek, Scenario Manager, and Data Tables to predict future business profits and budgets.
• MIS Dashboard Creation: Building live, interactive executive dashboards using Slicers, Timelines, and professional charts.
• Conditional Formatting & Risk Flagging: Setting up automated color rules to instantly highlight negative cash flows or overdue customer invoices.
• Data Validation & Worksheet Security: Restricting cell inputs to valid accounting formats and protecting sheets with passwords to prevent data tampering.