Master Accountant using Tally

PART 1 — ACCOUNTING & TAXATION COMPREHENSIVE:

Includes ALL content from TallyEssential Levels 1, 2, 3 AND TallyProfessional Volumes 1, 2.

TallyEssential content (see TallyEssential entry for full detail):

• Level 1 (35 hrs): Fundamentals of Accounting, TallyPrime setup, Chart of Accounts, all voucher types (Contra/Payment/Receipt/Purchase/Sales/Debit Note/Credit Note/Journal/Memo/Optional/PDC), Banking (BRS, Cheque Printing, Deposit Slips, Payment Advice), Financial Statements (Trial Balance, P&L, Balance Sheet, Cash Flow, Ratio Analysis), MIS Reports (Daybook, Outstanding, Purchase/Sales Register, Stock Summary), Data Security (Users, Access Levels, Audit Trail, Password Policy), Company Data Management (Backup, Restore, Export, Year-end), GST basics (GSTR-1, GSTR-3B, intrastate, interstate, ITC set-off)
• Level 2 (35 hrs): Inventory Management (Stock Groups/Categories/Godowns/Batches, valuation methods FIFO/LIFO/Weighted Average, Reorder Levels), Accounts Payable/Receivable (Bill-wise accounting, Reference types, Aging Analysis, Credit Limit, Bill Settlement), Purchase/Sales Order Management (PO, GRN, SO, Delivery Note, Rejection In/Out), Additional Cost of Purchase (Landed Cost), Cost/Profit Centres (creating, allocating, Cost Centre Classes, Project-wise profitability), Budgets and Scenarios (variance analysis), Advanced Reporting, Advanced GST (E-Way Bill, Composition Dealer, Advance Receipt, ITC Reversal, Credit Note)
• Level 3 (36 hrs): Advanced GST (E-Invoice/IRN, RCM, Exports/SEZ, all supply types, GSTR-1 E-filing, GSTR-3B E-filing), TDS (Sections 194C/H/I/J/A/195, Form 26Q, Form 27Q, TRACES portal, TDS as Deductee), Company Data Management (ODBC, Export/Import, Splitting Company, Group Company), Year-end procedures

TallyProfessional content (see TallyProfessional entry for full detail):

• Volume 1 (Advanced): Multi-Currency Accounting (creating currencies, exchange rates, Forex Gain/Loss realised and unrealised), Interest Calculation (simple and compound), Manufacturing Process and Job Work (BOM, manufacturing journal, job work in/out order, inter-godown transfer), Job Costing (project-wise costing, profitability), Advanced Banking (cheque management, PDC, e-payments NEFT/RTGS, auto-bank reconciliation), Connectivity (Remote Access, TRiB, Data Sync, TVU)
• Volume 2 (Statutory): Advanced GST (E-Way Bill, E-Invoice in detail, all supply types, RCM all scenarios, Export with IGST/LUT, SEZ, E-filing GSTR-1 and GSTR-3B, ITC set-off and reversal Rule 42/43), Advanced TDS (all sections including 195, 196D, non-resident TDS, works contract, pure agent, 26Q, 27Q, TRACES e-filing, Form 16A), TCS (206C, 206C(1H), 206CCA, Form 27EQ), Payroll and Income Tax (employee masters, pay heads, salary structure, attendance, payroll computation, PF/ESI/PT/Gratuity, Form 16, Form 24Q e-filing)

═══════════════════════════════════════════════════

PART 2 — BUSINESS ENGLISH:

• Professional English grammar: tenses review (simple, continuous, perfect), active/passive voice, subject-verb agreement, modifiers, common grammatical errors in business writing
• Business writing:
• Emails: formal (request, complaint, enquiry, follow-up, introduction, thank you) and informal; subject line writing; email structure (salutation, opening, body, action items, closing); CC/BCC etiquette; out-of-office messages
• Memos (office memorandums): format, tone, purpose — internal communication
• Business letters: formal letter format, types (quotation letter, order letter, complaint letter, collection letter)
• Reports: structure (title, executive summary, introduction, findings, conclusion, recommendations), formal report writing for financial/operational topics
• Minutes of meeting: recording resolutions, action items, attendees, agenda items
• Professional vocabulary for accounting and finance domain: debit, credit, accrual, amortisation, depreciation, EBITDA, working capital, liquid assets, fiscal year, provision, contingent liability
• Reading comprehension: business news articles (Economic Times, Business Standard), financial reports, RBI circulars — understanding and summarising
• Spoken English basics: pronunciation tips for common accounting/business terms, office conversation scenarios (asking for clarification, presenting data, discussing numbers), telephone and video call etiquette

═══════════════════════════════════════════════════

PART 3 — OFFICE AUTOMATION:

• Computer Fundamentals: hardware components (processor, RAM, HDD/SSD, GPU, motherboard), computer generations, software types (system software: OS, drivers; application software: MS Office, browsers; utility software: antivirus, disk cleanup), Windows 10/11 — file management (File Explorer: folders, search, recent files, This PC), taskbar and Start menu customisation, Control Panel and Settings, system tools (Task Manager, Device Manager, Disk Management), keyboard shortcuts (Win+D, Win+E, Win+R, Ctrl+Z, Ctrl+Y, Alt+Tab, etc.), basic troubleshooting (restarting services, clearing temp files, checking disk space)

MS Word (Advanced):

• Document formatting: styles (Heading 1–3, Normal, Body Text), themes, formatting consistency using Format Painter
• Page layout: margins, columns, page breaks, section breaks, headers/footers with page numbers and document info
• Mail Merge: setting up data source (Excel list), inserting merge fields, previewing, merging to letters/labels/emails; merging with conditions (If-Then-Else rules)
• Table of Contents: automatic TOC from heading styles; updating TOC; multilevel TOC
• Track Changes and Comments: accepting/rejecting changes; commenting; comparing two document versions
• Cross-references and bookmarks: linking within document; hyperlinks
• Templates creation: saving custom templates; using templates for consistent formatting
• Document protection: password protection; restricting editing to specific sections

MS Excel (Advanced):

• Formulas: SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTBLANK; IF (nested IF up to 3 levels), IFS; IFERROR; VLOOKUP (lookup value, table array, col index, approximate/exact match); HLOOKUP; INDEX/MATCH (dynamic 2D lookup); SUMIF, SUMIFS (multiple criteria); COUNTIF, COUNTIFS; TEXT (formatting numbers as text); LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE (text manipulation); TRIM, CLEAN; DATE, TODAY, NOW, DATEDIF, EOMONTH; AND, OR, NOT
• Named Ranges: creating static and dynamic named ranges; using names in formulas; Name Manager
• Data Validation: dropdown lists (from list or cell range), date range restrictions, input message and error alert
• Conditional Formatting: highlight cell rules (greater than, text contains, duplicate values), top/bottom rules, data bars, colour scales, icon sets; using formulas in conditional formatting rules
• Sorting and Filtering: custom sort (multi-level), filter by colour, filter by condition; advanced filter (unique records, criteria range)
• Pivot Tables: creating from data range; row/column/value/filter fields; changing value summarisation (SUM, COUNT, AVERAGE); grouping dates (by month, quarter, year); creating calculated fields; refreshing pivot table; slicer and timeline for visual filtering
• Pivot Charts: creating charts from pivot tables; chart types (column, bar, pie, line, combo); chart formatting (axis titles, data labels, legend)
• Charts: column, bar, pie, line, area, scatter, combo (dual axis); sparklines for trend indicators; chart formatting best practices
• MIS Report Creation: designing a monthly MIS report dashboard with KPI scorecards (using INDEX/MATCH, SUMIFS), variance analysis, trend charts, executive summary; structuring MIS workbook with separate data sheet, calculation sheet, and dashboard sheet
• Data Tables: one-variable and two-variable data tables for sensitivity analysis (e.g., EMI calculation at different rates/tenures)
• Goal Seek: finding input value that achieves desired output
• Protecting: password-protecting sheets, hiding formulas, allowing specific editing ranges

MS PowerPoint (Advanced):

• Slide design principles: visual hierarchy, 6×6 rule (max 6 bullets, 6 words each), color for emphasis, white space, consistency
• Slide Master and Slide Layouts: creating custom layouts, placeholders, footer, logo placement; applying themes
• SmartArt: org charts, process diagrams, cycle, pyramid; converting bullet points to SmartArt
• Charts: inserting from Excel or PowerPoint; linking Excel data for live updates
• Animations: entry animations (Appear, Fade, Fly In), emphasis, exit; animation pane for sequencing; animation timing
• Transitions: selecting professional transitions (Morph for modern look); transition speed
• Presenter View: using presenter notes; rehearse timings; recording narration
• Exporting: to PDF (for sharing); to Video (MP4); printing handouts with notes

Internet and Email:

• Professional email management: Gmail — labels and filters for inbox organisation, canned responses (templates), schedule send, snooze, undo send; multiple signatures; search operators (from:, subject:, has:attachment, is:unread)
• G-Suite/Office 365 tools: Google Docs (track changes, comments, suggesting mode), Google Sheets (IMPORTDATA, GOOGLEFINANCE, sharing with edit/comment/view permissions), Google Forms (creating surveys, viewing responses in Sheets), Google Meet (scheduling, screen sharing, chat, recording), OneDrive and SharePoint basics

Google Sheets and Docs Basics:

• Google Sheets: creating and formatting spreadsheets; sharing and collaboration; basic formulas; IMPORTRANGE for cross-spreadsheet data; ARRAYFORMULA; Query function; Explore feature for AI-powered insights
• Google Docs: creating professional documents; sharing and commenting; DocHub for PDF signing integration

═══════════════════════════════════════════════════

PART 4 — PERSONALITY DEVELOPMENT:

• Self-confidence building: understanding self-perception vs external perception; body language (posture, eye contact, handshake); overcoming fear of public speaking; assertiveness training
• Communication and interpersonal skills: active listening (reflecting, paraphrasing, summarising); asking clarifying questions; feedback receiving and giving (SBI: Situation-Behaviour-Impact model); conflict resolution; negotiation basics
• Resume / CV writing for accounting roles: ideal resume structure (Contact Info, Summary/Objective, Education, Skills, Experience, Projects/Internships, Certifications); keywords (TallyPrime, GST, TDS, Accounts Payable, SAP basics); formatting with proper fonts and spacing; ATS-friendly resume tips; covering letter writing
• Interview preparation for accounting roles: common interview questions — "Tell me about yourself," "What is debit and credit?", "Explain bank reconciliation," "How do you handle month-end closing?", "What is GST and how is GSTR-3B filed?", "Describe a situation where you found an error in accounts"; technical round preparation (mental maths, TallyPrime demo); HR round preparation
• Group discussions: reading newspaper (Economic Times/Business Standard) for current affairs; understanding a topic and forming structured opinion; introduction; listening and countering; team coordination
• Mock interview sessions: 2-3 mock interviews conducted by trainers with feedback; video recording for self-review
• Professional grooming and office etiquette: formal dress code for different work environments (corporate, CA firm, startup); punctuality; workplace ethics; confidentiality in finance roles; behavior at client sites
• Goal setting and time management: SMART goals; daily/weekly task planning; Pomodoro technique for productivity; prioritisation matrix (Eisenhower Matrix)
• LinkedIn profile creation: professional photo, headline (Accounting Professional | TallyPrime | GST | TDS), summary (first-person, highlighting skills and goals), education, skills section (endorsements), certifications, projects; connecting with recruiters; LinkedIn job search strategies

═══════════════════════════════════════════════════

ADVANCED ADD-ON — GST SIMULATION (Extra fee):

• Full interactive simulation: GSTR-1 complete filing practice (all transaction types), GSTR-3B computation (auto-population, ITC, reversal, payment), E-Way Bill (bulk generation, cancellation, extension), E-Invoice (IRN generation, QR code, error handling)

═══════════════════════════════════════════════════

ONLINE INTERNSHIP — Role-Based, NEP 2020 Aligned:

• 4–8 week structured online internship with Tally Education partner organizations
• Role-based tasks mirroring real accountant job responsibilities: entering daily transactions, generating reports, preparing for GST filing, bank reconciliation, handling month-end tasks, payroll processing
• Mentored by experienced accountants; weekly task submission and feedback
• Final internship report and presentation
• NEP 2020 compliant: eligible for university internship credit under NEP guidelines
• Internship certificate issued by Tally Education on successful completion

═══════════════════════════════════════════════════

AI LEARNING — TALLY TUTOR:

• AI-powered learning assistant embedded throughout the course
• Instant contextual answers to TallyPrime queries (e.g., "How to record GST payment in TallyPrime?")
• Links to relevant chapters and tutorials; real-world Tally scenario examples
• Quiz-style learning reinforcement; adaptive difficulty based on user performance
• Available 24/7 — supports self-paced learning between classroom sessions