Syllabus – Course in Digital Accounting Duration – 1 year Sr. No. Modules 1. IT Foundation and Digital Tools 2. Introduction to Accounting with Tally 3. Forms of Organization and Financial Statement Analysis 4. Indian Financial System 5. Taxation (Income Tax & GST) 6. Employability Skills DGT (30 hrs.) 7. OJT/ Project & Viva (30 hrs.) Module - 1 IT Foundation and Digital Tools 1. Computer Fundamentals & Operating System • What is a Computer • Characteristics of a Computer • Basic Applications of Computer • Advantages and Disadvantages of a Computer • History of Computer • Generation of Computer • Classification of Computers • Components of computer (Input unit, Arithmetic and logic unit, Control unit, Storage /Memory unit, Output unit) • Computer Memory ( What is computer memory, Types of memory, Difference between Primary memory & Secondary memory) • Concepts of Hardware and Software (Definition of Hardware and Software, Input devices, Secondary Storage devices, Output devices, Mother board, Power supply, System software, Application Software) • Languages (Machine Language, Assembly Language, High Level Language) • Concepts of data and information • Number System (Base conversion, binary, decimal, hexadecimal, and octal systems, conversion from one system to the other) • Binary Arithmetic( Addition, subtraction and multiplication) • IECT (Information Electronics and Communication Technology) and its applications of IECT o E-governance o Multimedia and Entertainment 2. Knowing GUI based Operating System and basic troubleshooting • Operating System and types of operating systems • Functions of Operating System. • GUI Operating Systems. • Types of GUI Operating System (Window, Linux, Android, Apple IOS, MAC OS) • Elements of GUI Operating System(Desktop, Windows, Title Bar, Task Bar, Start Menu/ Launcher, Icon, Button, Menu, Dialogue Box, Tab, Toolbar, Ribbon) • How Graphical User Interface Works? • Advantages and Disadvantages of GUI • Difference between GUI and CUI Operating System • Window Operating System • Managing files and folders in Window Operating System • Control Panel • Connecting keyboard, mouse, monitor, printer and projector to CPU • Basic Troubleshooting for common computer issues (power Supply), Handling issues related to printer (paper jam, printer isn’t printing, paper size mismatch, Printer error etc.), Handling issues related to scanner (paper jam, poor image quality etc.) 3. Introduction to Word Processing • Opening Word Processing Package • Menu Bar • Creating, opening and saving document • Entering and editing text • paragraph creation • Moving text (Cut, Copy & Paste) • Undo, Redo, Using Shortcuts • Formatting Documents ( Setting font styles, size, color, Typeface (Bold, Italic, Underline), Font effects, Change case, Highlighting, paragraph indenting , Alignments, Line Spacing, Drop cap, Bullets & Numberings, Borders & shadings, Header & Footer, Footnote & Endnote, Inserting Page break, Page numbering, Date & Time, Line Break, Word Wrap, Creating Cover page, Page Border, Table of Contents, Using Page Themes & Color, Inserting Watermarks) • Working with Tables (Creating tables, Table Styles, Borders & Shadings, Cell Alignment, Inserting & Deleting rows or columns, Merging, Splitting, Sorting, Using formula. Converting table into graphs) • Inserting Objects- Inserting Pictures, Formatting & editing pictures, picture styles, Picture borders, effects & layouts, Positioning, grouping & ordering, rotating and cropping, Adding and Editing Textbox, Shapes & SmartArt, Inserting Various types of charts, Charts layout and formatting. • Page Layout & Printing- Page Orientation, Setting page margins, Page size, Columns, Page Setup & Printing. • Features & Tools- Find and Replace, Auto Correct, Bookmarks, Hyperlinks, Spell Check, Thesaurus, Mail Merge. • Converting document into pdf 4. Typing Skills • Keyboard basics • Correct way of typing • Alphabet Placement and Positioning • Typing with Various keys • Speed typing • Using shortcut keys. 5. Introduction to Spreadsheet • Opening, creating and saving Spreadsheet. • Entering & editing data, Selecting Range • Cell Addressing • Creating text, number and date series. • Inserting, Deleting or Hiding a Row & Column. • Changing Cell Height & Width. • Formulas & Functions • Cell Referencing (Absolute, Relative & Mixed) • HLookup & VLookup. • Conditional Formatting. • Data Sorting & Filtering, Creating Data List, Data Validation • Consolidation, What-if Analysis. • Creating Charts and Graphs- Adding different types of Charts, Charts layout and formatting. • Find & Replace, Spell Check, Thesaurus • Page Setup & Printing. 6. Introduction to Digital Presentation • Creating a Presentation using Template • Creating a Blank Presentation • Opening and saving a Presentation • Entering and Editing Text • Inserting and Deleting Slides in a Presentation • Applying Themes & Background • Adding Pictures, Textbox, Tables, Charts, Shapes, Word Tables or Excel Worksheets • Adding Text to Shapes, Group/Ungroup Objects • Adding Header & Footer, Using Slide Master. • Setting Animation & Transition effects, Adding Audio & Video. • Running a slide show • Save as PDF, Image or Video file, PowerPoint Views, Printing handouts and slides. 7. Secure Web Access and communication • Concept of Internet (What is Network, Types of networks, Concept of Client and Server, Network Topologies, Network communication media, Concept of Internet and its applications, Advantages and disadvantages of internet, Internet protocol, Domain Name System, IP Address, URL, Internet Connectivity, Using WiFi & Bluetooth on digital devices, WWW and Web browsers, Popular Search Engines, Navigating through web, Uploading & Downloading, Services on web, Using Online Services (Banking, Using egovernance websites, Shopping, Streaming, social networking sites)) • Introduction to E-mail (History of Email, E-mail addressing, Creating new email account, Composing & sending email without and with attachments, Email Drafts and Scheduled sending, Replying & forwarding, Sorting & searching email, Sending email to multiple users, CC and BCC, Email protocol, Signatures (appended to the end of outgoing messages) • Basic Internet Security Concepts (Need of Security over internet, security threats, viruses and malwares, e-mail spam, security and privacy issues related to online shopping and social networking sites, safety measureschoosing strong password, Antivirus, Firewalls, safe browsing) 8. Cloud Storage and Online Collaboration • What is cloud and cloud storage • Types of cloud storage (Public, private, hybrid and community cloud) • Cloud Storage Service Providers(Google Drive, OneDrive, Dropbox) • Benefits of online storage over local storage and portable storage • Creating and Managing Files on the Cloud • Sharing and Collaborating on Documents • Syncing Files Across Devices • Introduction to Online Collaboration Tools (Google Workspace, Microsoft Office 365) Module 2 Introduction to Accounting with Tally 1. Basics of Accounting • Introduction to Accounting (Basic Accounting concepts, Kinds of Accounts, Double Entry Book Keeping, Rules of Debit and Credit) • Recording of Transactions (Preparation of Journal and Ledger Accounts) • Subsidiary books (cash book, types of cash book, purchase book, sales book, sales return, purchase return books, Journal proper) • Trial balance and Rectification of Errors (Meaning and purpose, Preparation of trial balance, Errors, Types of Errors) • Bank Reconciliation Statement ( Need for Bank Reconciliation, Reasons for Difference between Cash Book and Pass Book Balances, Preparation of Bank Reconciliation Statement) • Final Accounts (Preparation of Final Accounts: Trading account, Profit and Loss account, Balance Sheet, Final Accounts with Adjustments) 2. Accounting Software-Tally ERP9 • Fundamentals of Tally.ERP9 (Company Features, Configuration, Getting functions with Tally.ERP9, Creation / setting up of Company in Tally.ERP9) • Accounting Masters (Chart of Groups, Groups, Multiple Groups, Ledgers, Multiple Ledgers) • Inventory Masters (Stock Groups, Multiple Stock Groups, Stock Categories, Multiple Stock Categories, Units of Measure, Stock Items) • Vouchers Entries (Introduction to Vouchers, Types of Vouchers, Chart of Vouchers, Accounting Vouchers, Inventory Vouchers, Invoicing ) • Advance Accounting (Bill wise details, Cost centers and Cost Categories, Multiple currencies, Interest calculations, Budget and controls, Scenario management, Bank Reconciliation ) • Advance Inventory (Order Processing, Recorder Levels, Batch-wise details, Bill of Materials Batch-Wise Details, Different Actual and Billed Quantities, Price Lists, Zero-Valued Entries, Additional cost details, POS ) • Taxes (TDS, TDS Reports, TDS Online Payment, TDS Returns filing, TDS Certificate issuing, 26AS Reconciliation, TCS, TCS Reports, GST, GST Returns, EPF, ESIC, Professional Tax) • Data Security & Administration (Tally vault, Security controls, Tally Audit, Backup and restore, Split company data, Import and export of data) • Payroll Accounting (Employee Creation, Salary Define, Employee Attendance Register, Pay Heads Creation, Salary Report ) • Generating Reports (Financial Statements, Trading Account, Profit & Loss Account, Balance Sheet, Accounts Books and Reports, Inventory Books and Reports, Exception Reports, Statutory Reports, Payroll Reports, Trail balance, Day Book, List of Accounts, Stock Summary, Outstanding Statement) Module 3: Forms of Organization and Financial Statement Analysis • Forms of Business Organizations (Sole-Proprietorship and Types, Hindu Undivided Family (HUF) Business, Partnership, Types of Partnership, Goodwill and its importance, Companies and type of companies) • Financial Analysis and Interpretation (Meaning of Financial Statement Analysis, Purpose of Financial Statement Analysis, Users of Financial Statement Analysis, Financial Statement Analysis & Tools, Calculation of Accounting Ratios: - Liquidity Ratios, Solvency Ratios, Activity Ratios, Profitability Ratios Interpretation of Financial Statements. Module 4: Indian Financial System • Introduction to Indian Financial System (Definition and scope of the financial system, Structure and components of the Indian financial system, Evolution and development of the Indian financial system) • Financial Institutions (Commercial banks (Public sector banks, Private sector banks, Foreign banks, Cooperative banks), Non-banking financial companies (NBFCs), Development banks and financial institutions (e.g., NABARD, SIDBI, EXIM Bank), Insurance companies (Life insurance, General insurance), Mutual funds, Pension funds) • Financial Markets (Functions of Financial Markets, Types of Financial Markets, Money market (Call money market, Treasury bills, Commercial papers, Certificate of deposits), Capital market (Primary market, Secondary market, Stock exchanges, IPOs, FPOs), Difference between Capital Market and Money Market) • Regulatory Framework (Role of regulatory authorities (RBI, SEBI, IRDAI, PFRDA), Regulatory reforms and initiatives, Banking and Securities regulations • Financial Instruments (Deposit products (Savings account, Current account, Fixed deposits), Loans and advances (Retail loans, Corporate loans), Stocks and Bonds, Insurance policies (Life insurance policies, Health insurance policies)) • Financial Services (Wealth management and Investment banking, Credit rating agencies, Financial advisory services) • Financial Inclusion (Meaning, Objectives and importance, Government schemes for financial inclusion, Role of technology in promoting financial inclusion) • Challenges and Issues (Non-performing assets (NPAs) in the banking sector, Cyber security threats, Financial Inclusion and Access to Credit) Module 5- Taxation (Income Tax & GST) • Introduction to Taxation (Meaning, Types of Taxes- Direct and Indirect, Direct- Income Tax, Corporate Tax, Property Tax, Indirect Tax- GST) • Introduction to Income Tax (Definition and objectives of income taxation, Historical development of income tax laws, Overview of the income tax system in the country, Definition of various terms used in Taxation like Assessee, Assessment Year, Previous Year/ financial year ) • Concepts of Income (Different types of income (e.g., salary, wages, interest, dividends, capital gains), Distinction between revenue and capital receipts, Exempted incomes and tax-free allowances) • Residential Status and Scope of Total Income (Determination of residential status for tax purposes, Scope of total income under the Income Tax Act, Taxability of income earned by residents and non-residents) • Income from Salary(Computation of taxable income from salary, Allowances and perquisites taxable under the Income Tax Act, Deductions and exemptions available to salaried individuals) • Income from House Property (Taxation of rental income from house property, Deductions available for interest on housing loan and property taxes paid) • Income from Business or Profession (Taxation of business income for individuals and entities, Computation of business income under different methods (e.g., cash basis, accrual basis), Allowable deductions and expenses related to business or profession) • Income from Capital Gains (Taxation of capital gains from the sale of assets (e.g., stocks, real estate, securities), Classification of capital assets and computation of capital gains, Exemptions and rollover provisions available for capital gains) • Income from Other Sources (Taxation of income from other sources not covered under the previous heads (e.g., interest income, dividend income, lottery winnings), Deductions and exemptions available for income from other sources) • Tax Deductions and Exemptions (Overview of deductions available under various sections of the Income Tax Act (e.g., Section 80C, Section 80D, Section 80G, TDS, Standard Deductions), Exemptions available for certain incomes (e.g., agricultural income, income of charitable institutions)) • E-Filing of Income Tax Return(ITR) (Meaning of ITR, Types of ITR Forms, Requirement for filing of ITR online (Income, PAN, Bank account details), Meaning of e-filing, types of e-filing, Introduction to Income Tax Portal, e-filing process, due date of filing of income tax return • Tax deducted at Source(TDS) (What Is TDS, Who are Deductor & Deductee, TAN, , TDS deducted under different sections, Due dates TDS Payments & Return filing, issuance of TDS Certificate (Form 16, 16A, 16B), Return filing, Penalty, e-Filing of TDS Returns, List of forms used in return (Form 24Q, 26Q, 26QB, 27Q) • GST Return (What is GST Return, Overview of the GST system, Objectives and benefits of GST implementation, Structure of GST in the country (e.g., CGST, SGST, IGST), Taxable events under GST, Procedure for GST Registration, Concept of input tax credit under GST, Types of GST Returns (e.g., GSTR-1, GSTR-3B, GSTR-9), Frequency and due dates for filing GST returns, formats of various GST return forms, Online Filing process for GST Returns, Penalties and interest for late filing or incorrect filing of GST returns, Emerging issues and challenges in GST compliance) Module 6 - Employability Skills (DGT 30 hrs.) Module 7- OJT/Project & Viva