Diploma in Financial Accounting
Kickstart your IT career with our 12-months DCA program!
- Duration: 6 months
- Course Fee: ₹ 9,000
- Career Opportunities: Data Entry Operator, Computer Operator, and more
Gain skills and industry-relevant knowledge to boost your career in the tech world.
Course Curriculum
Computer Fundamental
- Introduction of Computer
- Features and Limitations of Computer
- Application of Computer System
- What is Computer System
- Input Devices of Computer System
- Data Information Processing
- Output Device of Computer System
- Memory Management of Computer system
- Primary Memory of Computer System
- Secondary Memory of Computer
- Types of Computer System
- Central Processing Unit
- History and Generations Of Computer
- Internal Components of Computer System
- System Assembling Dissembling
- Introduction to Operating System
Windows 11
- Installing and setting up Windows 11
- Navigating the new Start menu
- Customizing the taskbar and Start menu
- Managing user accounts and sign-in options (PIN, Password, Microsoft Account)
Module 1: Introduction to Windows 11
- Creating, renaming, moving, and deleting files/folders
- Using File Explorer to manage files
- Pinning folders to the Quick Access menu
- Searching files and folders in File Explorer
- Using the Context Menu (right-click options)
- Working with File Extensions and Preview Pane
Module 2: File and Folder Management
- Changing the desktop wallpaper and lock screen image
- Customizing the taskbar (icons, system tray, transparency)
- Changing system themes and colors (light/dark mode)
- Setting up multiple desktops and virtual desktops
- Adjusting screen resolution and display settings
- Using Snap Layouts and Snap Groups for multitasking
Module 3: Personalizing Windows 11
- Accessing and navigating the Windows Settings app
- Configuring system settings (Network, Devices, Time & Language)
- Adjusting system sound and notifications
- Managing power options and battery settings
- Privacy settings and App permissions
- Changing system language, region, and keyboard layout
- Enabling and configuring Windows Update
Module 4: Working with Windows Settings
- Installing, updating, and uninstalling apps from Microsoft Store
- Managing installed apps and their permissions
- Using Task Manager to monitor and end tasks
- Pinning apps to the Start menu and taskbar
- Using Settings to manage default apps (browser, email, etc.)
Module 5: Managing Apps and Software
- Creating a System Restore Point
- Using File History to back up files and restore them
- Creating and using Windows 11 backup options (Backup & Restore, OneDrive backup)
- Resetting Windows 11 to its default state without losing personal files
Module 6: File Backup and Recovery
- Setting up Windows Defender Antivirus and performing scans
- Configuring Windows Security settings (Firewall, Virus & Threat Protection)
- Using Windows Hello for secure login (Fingerprint, Face recognition)
- Enabling BitLocker for disk encryption
- Managing app permissions and privacy settings
- Understanding Windows 11 Firewall and network protection
Module 7: Security and Privacy Settings
- Customizing the taskbar (alignment, shortcuts, system icons)
- Using Windows 11 Snap Assist for multitasking
- Managing multiple windows and virtual desktops
- Using Quick Settings (Wi-Fi, Bluetooth, Brightness, Focus Assist)
- Managing system notifications and widgets
- Organizing the desktop using icons, folders, and taskbar shortcuts
Module 8: Taskbar and Window Management
- Connecting to Wi-Fi and Ethernet networks
- Setting up and managing network shares and printers
- Troubleshooting network issues using the Network Troubleshooter
- Using Airplane Mode, Bluetooth, and VPN settings
- Configuring proxy settings and remote desktop connection
Module 9: Networking and Connectivity
- Using Microsoft Teams and other built-in communication tools
- Managing apps using the new Microsoft Store
- Using Widgets for news, weather, and personal information
- Managing system resources using Task Manager
- Working with Windows PowerShell for advanced tasks
Module 10: Windows 11 for Productivity
- Performing manual system updates via Windows Update
- Managing update settings (active hours, restart options)
- Using Disk Cleanup and Storage Sense for maintenance
- Checking system health and performance
- Uninstalling apps, software, and cleaning up unnecessary files
Module 11: Updates and Maintenance
- Using Cortana for voice commands and productivity
- Configuring advanced security options (Windows Sandbox, Device Encryption)
- Using the Windows Subsystem for Linux (WSL)
- Exploring PowerToys and other productivity utilities
- Managing device drivers and updates using Device Manager
Module 12: Advanced Features and Tips
- Students will complete a project incorporating all learned skills. The project may involve:
- Customizing the Windows 11 interface and settings
- Configuring system and security settings for a personal or business setup
- Setting up network connections and sharing files between multiple devices
- Troubleshooting common Windows 11 problems and demonstrating solutions
Module 13: Final Project
- Practical Evaluation: Hands-on exercises and tasks after each module
- Final Project: An overall project showcasing the student's learning
- Feedback: Continuous feedback after each session to improve practical skills
Assessment:
- Computers with Windows 11 OS installed
- Internet access for updates and online resources
- External storage devices for backup tasks (USB, External Hard Drives)
- Optional: Microsoft Teams for collaboration and online sessions
Tools Required:
Microsoft Word 365
- Opening, closing, and saving documents in Word
- Navigating the Ribbon and understanding the interface
- Using the Quick Access Toolbar and customizing it
- Zoom in and zoom out in the document
- Creating a new document and using templates
Module 1: Introduction to MS Word 365
- Typing, editing, and deleting text
- Changing font style, size, color, and applying bold, italic, underline
- Aligning text (left, right, center, justify)
- Adjusting line spacing and paragraph spacing
- Using bullet points and numbered lists
- Using Undo and Redo options
- Formatting headings and subheadings using Styles
Module 2: Basic Document Formatting
- Adjusting page margins (Normal, Narrow, Custom)
- Changing page orientation (Portrait, Landscape)
- Inserting and removing page breaks
- Setting up headers and footers (page numbers, date, document title)
- Adding and formatting page borders
- Changing paper size and orientation
Module 3: Working with Pages and Layout
- Inserting a table (number of rows and columns)
- Adding and deleting rows/columns
- Merging and splitting cells
- Adjusting column width and row height
- Formatting table (borders, shading, text alignment)
- Using table styles for quick formatting
- Sorting data within a table
- Converting text to a table and vice versa
Module 4: Working with Tables
- Inserting pictures and resizing them
- Using WordArt for creative text effects
- Inserting shapes, icons, and SmartArt
- Working with text boxes (inserting, resizing, moving)
- Inserting charts (column, pie, bar) and customizing them
- Using Screenshots and Snipping Tool in Word
- Wrapping text around images and objects
Module 5: Inserting Graphics and Objects
- Applying and customizing themes and templates
- Using the Format Painter to copy formatting
- Creating and modifying paragraph styles
- Inserting and formatting columns (newspaper-style text)
- Creating and formatting lists with bullets, numbering, and multilevel lists
- Inserting and formatting footnotes, endnotes, and citations
Module 6: Advanced Formatting Techniques
- Inserting and editing headers and footers
- Adding different headers/footers for odd and even pages
- Customizing page numbers (position, format)
- Inserting document date/time in headers or footers
- Using Section Breaks for different formatting in sections
Module 7: Working with Headers, Footers, and Page Numbers
- Using Spelling and Grammar check
- Adding comments and track changes for document review
- Accepting or rejecting changes in the document
- Using the Thesaurus and synonyms tool
- Comparing and merging two documents
- Checking document readability and readability scores
Module 8: Reviewing and Proofreading Tools
- Sharing documents via OneDrive or SharePoint
- Collaborating in real-time with others (track changes, comments)
- Using @mentions and notifications in shared documents
- Protecting a document (password protection, restricting editing)
- Using the "Compare" and "Combine" features for document comparison
- Saving a document in various formats (PDF, Word, etc.)
Module 9: Collaboration and Sharing
- Setting up a Mail Merge (creating a letter template)
- Using Excel as a data source for mail merge
- Inserting merge fields (name, address, etc.)
- Previewing and finishing the Mail Merge (print, email, or save)
Module 10: Using Mail Merge
- Creating documents using built-in templates
- Designing a form with fillable fields (using Content Controls)
- Protecting forms (restricting editing to fillable areas)
- Saving and using custom templates for future documents
Module 11: Using Templates and Forms
- Creating a professional report or newsletter with tables, images, headers, and footers
- Performing mail merge for personalized letters
- Designing a form with fillable fields and submitting it
- Formatting a document with advanced styles, sections, and columns
Module 12: Final Project
- Practical Assignments: After each module, students will complete hands-on tasks.
- Final Project: A final project incorporating all the features covered in the course.
- Feedback: Continuous feedback on each task to enhance learning.
Assessment:
Microsoft Excel 365
- Opening, closing, and saving Excel files
- Navigating the Excel interface (Ribbon, Formula bar, Cells, Rows, Columns)
- Creating a new workbook and worksheet
- Understanding the use of cells, rows, columns, and ranges
- Adjusting column width and row height
- Basic navigation using keyboard shortcuts (e.g., Ctrl + Arrow keys)
Module 1: Introduction to MS Excel 365
- Entering text, numbers, and dates in cells
- Formatting cells (font size, style, color)
- Number formatting (currency, percentage, decimal places)
- Aligning data (left, center, right)
- Changing cell borders, fills, and text wrapping
- Merging and splitting cells
- Using Format Painter to copy formatting
Module 2: Data Entry and Formatting
- Writing simple formulas (addition, subtraction, multiplication, division)
- Using AutoSum for quick calculations
- Introduction to basic functions (SUM, AVERAGE, MIN, MAX)
- Using AutoFill to copy formulas and patterns
- Understanding relative, absolute, and mixed references in formulas (e.g., $A$1, A1, A$1)
- Using the Quick Analysis tool for basic calculations
Module 3: Basic Formulas and Functions
- Sorting data (ascending, descending) by one or multiple columns
- Filtering data using the Filter tool
- Removing duplicates from data
- Using Conditional Formatting for highlighting data (color scales, data bars, icon sets)
- Using the Flash Fill tool for automatic pattern recognition
- Working with Excel tables (inserting, formatting, and managing tables)
Module 4: Working with Data and Sorting
- Introduction to advanced Excel functions
- Using IF function for conditional logic (simple IF, nested IF)
- Using COUNTIF, SUMIF, and AVERAGEIF functions for conditional calculations
- Working with text functions (CONCATENATE, LEFT, RIGHT, MID, TRIM)
- Using date functions (TODAY, NOW, DATE, YEAR, MONTH, DAY)
- Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Using logical functions (AND, OR, NOT)
Module 5: Advanced Formulas and Functions
- Importance of data visualization in Excel
- Creating basic charts (Column, Line, Bar, Pie)
- Customizing charts (titles, labels, legends, data series)
- Using Pivot Charts to summarize data visually
- Adding trendlines to charts
- Using the Recommended Charts tool for automatic chart selection
- Formatting charts (colors, styles, and 3D effects)
- Working with Sparklines for quick data visualization
Module 5: Advanced Formulas and Functions
- Creating and modifying PivotTables
- Adding and removing fields in PivotTable
- Grouping data in PivotTable (by date, numbers, etc.)
- Using calculated fields in PivotTables
- Refreshing and updating PivotTables
- Creating PivotCharts from PivotTables for advanced data analysis
Module 7: Working with PivotTables and PivotCharts
- Introduction to advanced data analysis tools
- Using Goal Seek for finding values
- Performing data analysis with the What-If analysis tools
- Using Data Tables for sensitivity analysis
- Using Solver for complex optimization problems
- Using Forecasting tools for trend analysis
- Analyzing data with Scenario Manager
Module 8: Data Analysis Tools and Functions
- Managing multiple sheets and workbooks in Excel
- Linking data between different sheets and workbooks
- Copying and pasting data across workbooks
- Grouping and ungrouping worksheets
- Renaming, adding, and deleting sheets
- Protecting worksheets and workbooks (password protection)
- Using the Consolidate tool to combine data from multiple sheets
Module 9: Working with Multiple Sheets and Workbooks
- Setting print areas and adjusting page layout for printing
- Using Page Break Preview and Print Titles
- Printing selected data and entire workbooks
- Saving workbooks as PDF or XPS
- Sharing workbooks via OneDrive or email
- Co-authoring and collaborating in real-time with other users
- Protecting and securing Excel workbooks while sharing
Module 10: Printing and Sharing Excel Workbooks
- Using Power Query to import and transform data from external sources
- Connecting Excel to databases, text files, and web sources
- Using Power Pivot for advanced data modeling and analysis
- Creating relationships between different data sources
- Using DAX formulas in Power Pivot for complex calculations
Module 11: Advanced Excel Features (Power Query, Power Pivot)
- Create and format a complex Excel report with data, tables, formulas, and charts
- Use PivotTables and PivotCharts to summarize and analyze data
- Implement advanced functions (IF, VLOOKUP, COUNTIF, etc.) in real-world scenarios
- Collaborate on a workbook, sharing data and managing version control
Module 12: Final Project
- Practical Assignments: Hands-on tasks after each module
- Final Project: A final project that integrates all the concepts covered in the course
- Feedback: Continuous feedback after each practical exercise
Assessment:
Microsoft PowerPoint 365
- Opening, saving, and closing presentations
- Navigating the PowerPoint interface (Ribbon, Quick Access Toolbar)
- Understanding slide layouts and themes
- Creating a new presentation and choosing a template
- Using the Design Tab to choose a theme for your presentation
- Basic slide navigation (Next, Previous, Go to Slide)
Module 1: Introduction to MS PowerPoint 365
- Basics of adding and editing slides
- Inserting new slides (title, text, blank, etc.)
- Changing slide layouts (Title, Content, Two Content, Comparison)
- Deleting, duplicating, and reordering slides
- Changing slide background color and design
- Applying slide transitions and setting duration
- Using the Slide Sorter view for slide organization
- Setting up slide master for consistent design
Module 2: Working with Slides
- Typing and editing text in text boxes
- Formatting text (font style, size, color, bold, italic, underline)
- Using bullets, numbering, and multilevel lists
- Aligning text (left, center, right, justify)
- Inserting text boxes and adjusting their size and position
- Copying and pasting content with and without formatting
- Formatting paragraphs (line spacing, indentations, etc.)
Module 3: Text and Content Formatting
- Inserting images from file and web sources
- Inserting icons and graphics from PowerPoint library
- Using the "Insert" tab to add shapes, smart art, and charts
- Inserting and formatting tables for data display
- Inserting screenshots and screen recordings
- Using Picture Tools to resize, crop, and adjust images
- Applying effects and styles to images (shadows, reflections, borders)
- Adding text effects and WordArt
Module 4: Inserting Visuals and Objects
- Inserting and customizing different types of charts (bar, pie, line, etc.)
- Modifying chart data and changing chart types
- Formatting chart titles, labels, and legends
- Customizing chart colors and styles
- Adding trendlines and data labels to charts
- Linking Excel data with PowerPoint for dynamic charts
- Using the Chart Tools to format and modify charts
Module 5: Working with Charts and Graphs
- Applying animations to text, images, and other objects
- Customizing animation effects (entrance, emphasis, exit)
- Setting animation duration and delay times
- Using the Animation Pane for managing animations
- Applying slide transitions (Fade, Wipe, Push, etc.)
- Setting transition duration and sound effects
- Creating interactive animations for engaging presentations
Module 6: Animations and Transitions
- Inserting and playing audio files in a slide (MP3, WAV)
- Inserting and editing video files (MP4, WMV, etc.)
- Using the Playback tools for audio and video
- Embedding online videos from YouTube or other sources
- Adjusting audio and video settings (volume, start, playback options)
- Using Action Buttons for interactive presentations (Hyperlinks, triggers)
Module 7: Audio, Video, and Multimedia
- Inserting hyperlinks to navigate to other slides or external websites
- Creating interactive presentations using action buttons
- Setting up a navigation menu with hyperlinks
- Using action buttons to link slides within the presentation
- Setting up a self-running presentation with action buttons
Module 8: Working with Hyperlinks and Action Buttons
- Sharing PowerPoint presentations via OneDrive or SharePoint
- Collaborating in real-time with others using Comments and Annotations
- Comparing and merging different versions of the presentation
- Adding and reviewing comments in slides
- Presenting a slide show with notes for the presenter
- Exporting presentations to PDF, Word, or video formats
- Printing presentations (handouts, notes, and slides)
Module 9: Collaboration and Sharing
- Setting up and customizing the Slide Show (loop, auto-advance)
- Adding speaker notes and rehearse timings
- Using Presenter View during a presentation
- Finalizing presentation by checking for consistency
- Practicing the presentation using Presenter View
- Creating a custom slide show (selecting specific slides for different audiences)
- Adding slide transitions for a smoother presentation flow
Module 10: Finalizing and Presenting
- Exploring advanced features for complex presentations
- Using PowerPoint Designer to auto-generate slide layouts and designs
- Using advanced charts and graphs for complex data presentations
- Customizing PowerPoint themes and saving as a template
- Using Morph transition for seamless slide animations
- Advanced editing of videos within PowerPoint
- Creating and using custom slide layouts
- Using external add-ins for enhanced functionality
Module 11: Advanced PowerPoint Features (Optional)
- Students will create a comprehensive presentation that includes:
- Custom slide layouts, animations, and transitions
- Charts, graphs, images, and multimedia elements
- Action buttons and hyperlinks for interactivity
- Slide master and consistent design throughout the presentation
- Real-time collaboration on a group presentation (if applicable)
Module 12: Final Project
- Practical Assignments: Hands-on tasks at the end of each module
- Final Project: A complete presentation showcasing all learned features
- Feedback: Continuous feedback after each session to improve presentation skills
Assessment:
Typing in Hindi & English
Computer Hardware
- Document Scanning & Printing
- System Assembling & Dissembling
- System Formatting & Windows Installation
- Installation of Drivers and Application
Application of Internet & Email System
- Introduction of Internet & Email System
- Gmail Account Creation , Password Change, Sending Email , Attach Any File in Gmail
- How to change Profile Picture in Gmail Account ?
- How to Change Themes in Gmail Account
- What is Two Step Verification ? How to Use Two Step Verification in Gmail ?
- What is PAN Card ? Use of Pan Card ?
- Apply Pan application using NSDL Portal
- Correction Pan application using NSDL Portal
- Reprint of PAN Card using NSDL Portal
- Introduction of Aadhar Portal https://uidai.gov.in/
- What is Aadhaar Features of Aadhaar
- Download Aadhaar & Update Aadhaar Data
- Order Aadhaar PVC Card o Check Aadhaar PVC Card Status
- Check Aadhaar Update Status
- National Voter Service Portal https://www.nvsp.in/
- Register as a New Elector/Voter
- Track Application Status
- Download E-EPIC
- Passport Seva Portal (https://www.passportindia.gov.in/)
- Registration on Passport Seva Portal
- Apply Online for the Passport
- Book Appointment on PSK
- Check Status of Passport
- Driving License Portal (https://parivahan.gov.in/)
- Apply for DL, Slot Booking,
- Ccc online form
- Resizing of photo,sign,and thumb impression
- E district
- CSC
- Caste,income residence certificate online
Basic of Financial Accounting
- Definition and Importance of Financial Accounting
- Role of Accounting in Business
- Basic Accounting Terms: Assets, Liabilities, Capital, Revenue, and Expenses
- Users of Financial Accounting Information (Internal and External Users)
- The Accounting Cycle and its Phases
Module 1: Introduction to Financial Accounting
- Generally Accepted Accounting Principles (GAAP)
- Accounting Standards and their Importance
- Basic Accounting Concepts:
- Entity Concept
- Going Concern Concept
- Matching Concept
- Cost Concept
- Revenue Recognition Concept
- Accrual Concept
- Qualitative Characteristics of Accounting Information:
- Relevance
- Reliability
- Comparability
- Understandability
Module 2: Accounting Principles and Concepts
- The Concept of Double-Entry Bookkeeping
- Basic Rules of Debit and Credit:
- Debit the receiver, Credit the giver
- Debit what comes in, Credit what goes out
- Debit all expenses and losses, Credit all incomes and gains
- Classification of Accounts:
- Personal Accounts
- Real Accounts
- Nominal Accounts
Module 3: Double-Entry System of Accounting
- Introduction to the Journal: Meaning, Types, and Importance
- Format of Journal Entries
- Recording Transactions in the Journal
- Posting Journal Entries to the Ledger
- Understanding the Trial Balance and its Importance
- Difference between Journal and Ledger
Module 4: Journal Entries and Ledger
- Meaning and Types of Subsidiary Books
- Cash Book
- Purchase Book
- Sales Book
- Purchase Return Book
- Sales Return Book
- Bills Receivable and Bills Payable Book
- Recording transactions in subsidiary books
- Transfer from subsidiary books to the ledger
Module 5: Subsidiary Books
- Profit and Loss Account:
- Purpose and Importance
- Structure and Format of Profit and Loss Account
- Balance Sheet:
- Purpose and Importance
- Structure and Format of the Balance Sheet
- Relationship Between Profit and Loss Account and Balance Sheet
- Adjustments to be made before preparing final accounts
- Closing of accounts at the end of the accounting period
Module 6: Preparation of Financial Statements
Goods and Services Tax (GST)
- Definition of GST: Meaning and concept of Goods and Services Tax
- GST and its significance: How GST simplifies the taxation system
- Objectives of GST: To ensure tax compliance, reduce the cascading effect, and simplify the taxation process
- Types of GST:
- Central Goods and Services Tax (CGST)
- State Goods and Services Tax (SGST)
- Integrated Goods and Services Tax (IGST)
- Evolution of GST in India: From VAT to GST
- Constitutional Amendments: 101st Constitutional Amendment Act, 2016
Module 1: Introduction to Goods and Services Tax (GST)
- Basic Structure of GST: Overview of the GST framework in India
- Taxable Event under GST: When does GST become applicable (supply of goods and services)
- Supply of Goods and Services: Definition and types (composite, mixed, and exempted supplies)
- Place of Supply: How the place of supply determines the type of tax (CGST, SGST, IGST)
- Time of Supply: Determining the time at which GST is payable on a transaction
- Valuation under GST: How to value goods and services for GST
Module 2: GST Structure and Taxable Events
- GST Registration Process: Who needs to register under GST?
- Compulsory Registration: Threshold limit for GST registration
- Voluntary Registration: Benefits of voluntary registration
- Types of GST Registration:
- Normal Registration
- Composition Scheme Registration
- GSTIN (Goods and Services Tax Identification Number)
- GST Registration Procedure: Step-by-step process of registration
- Obligations of GST Registrants: Compliance and filing requirements
Module 3: GST Registration
- Classification of Goods and Services under GST: Goods and Services as per HSN and SAC codes
- Tax Rates under GST:
- 0%, 5%, 12%, 18%, and 28% Tax Slabs
- Specific tax rates for goods (luxury goods, essential goods, etc.)
- Specific tax rates for services (transportation, IT services, hospitality, etc.)
- Exemptions under GST: Goods and services exempted from GST
- Reverse Charge Mechanism (RCM): When the recipient is liable to pay GST instead of the supplier
- Input Tax Credit (ITC): How businesses can claim tax credits on their purchases
Module 4: GST on Goods and Services
- Overview of the Composition Scheme: A simplified tax scheme for small businesses
- Eligibility for Composition Scheme: Who can opt for the scheme
- Advantages and Disadvantages of the Composition Scheme
- Rates under Composition Scheme: Tax rates for various categories of taxpayers
- Filing and Compliance under the Composition Scheme
Module 5: Composition Scheme under GST
- GST Invoice: Types of invoices under GST (Tax Invoice, Bill of Supply, Receipt Voucher, Payment Voucher)
- Contents of GST Invoice: Mandatory details to be included in an invoice
- GST Payments: How payments of GST are made by taxpayers
- GST Returns: Types of GST returns (GSTR-1, GSTR-3B, GSTR-9, etc.)
- GSTR-1: Outward supply return
- GSTR-3B: Summary return for monthly GST payment
- GSTR-9: Annual return
- Due Dates for GST Returns: When GST returns need to be filed
- GST Filing and Penalties: Consequences of non-filing or late filing of returns
Module 6: GST Invoices, Payments, and Returns
- Meaning and Concept of ITC: How businesses can claim credit for taxes paid on purchases
- Eligibility and Conditions for Claiming ITC: When and how can a business claim ITC
- ITC on Capital Goods: Special provisions for claiming ITC on capital goods
- Blocked Credits: Goods and services on which ITC cannot be claimed
- Reversal of ITC: Conditions under which ITC needs to be reversed
Module 7: Input Tax Credit (ITC) under GST
- GST Compliance Requirements: Regular filing of returns, maintaining records, and paying taxes
- Books of Accounts under GST: Types of records that need to be maintained by businesses (sales registers, purchase registers, tax payment records)
- Audit and GST: Concept of GST audit and its importance for businesses
- GST and E-way Bill: What is an E-way Bill, and when is it required for goods transport?
Module 8: GST Compliance and Record-Keeping
- GST Refunds: Process of claiming a refund for excess tax paid
- Reasons for Refund: Export of goods/services, input tax credit mismatch, etc.
- Procedure for Refund: Steps involved in the GST refund process
- Adjudication Process under GST: How disputes are resolved in GST-related matters
- Appeals and Review under GST: Process of challenging GST assessments
Module 9: GST Refund and Adjudication
- GST Compliance and Enforcement: Role of tax authorities in enforcing GST regulations
- GST Audits: Concept of tax audits under GST for taxpayers
- Penalties for Non-Compliance:
- Penalties for failure to register, file returns, or pay taxes
- Penalties for issuing incorrect invoices or documents
- Prosecution under GST: Serious offenses under GST and their legal implications
Module 10: GST Enforcement and Penalties
- GST and Economic Growth: How GST contributes to India’s economy
- GST and Business Efficiency: Simplification of business processes, impact on supply chain management
- Impact of GST on Various Sectors:
- Impact on the manufacturing sector
- Impact on the service sector
- Impact on small businesses and MSMEs
- GST and International Trade: Impact on exports and imports
Module 11: Impact of GST on the Economy
Tally Prime with GST
- Installing and configuring Tally Prime with GST settings
- Creating a company in Tally Prime with GST configuration
- Exploring the GST features in Tally (activation, configuration of GSTIN, tax rates)
- Setting up GST tax categories and GST Ledger accounts
Module 1: Introduction to Tally Prime and GST
- Step-by-step guide to GST registration in Tally Prime
- Configuring GST-related details for the company: GSTIN, GST Registration type
- Creating GST Ledgers: CGST, SGST, IGST, and Input Tax Credit (ITC) ledgers
- Setting up tax rates: 0%, 5%, 12%, 18%, and 28% tax slabs in Tally
- Enabling GST on purchases, sales, and expenses in Tally
Module 2: GST Registration and Setup in Tally
- Recording GST sales transactions with tax calculation (both cash and credit sales)
- Recording GST purchase transactions with tax calculation (both cash and credit purchases)
- Generating tax invoices for different GST transactions
- Recording GST payments and GST receipts in Tally
- Generating sales and purchase reports for GST compliance
Module 3: Recording GST Sales and Purchases
- Generating GSTR-1 (Outward Supplies) from Tally:
- Sales invoices
- B2B and B2C details
- HSN-wise summary
- Filing GSTR-3B from Tally:
- Calculating and reporting tax liability (Output tax and Input tax)
- Generating ITC (Input Tax Credit) details
- Filing GSTR-9 (Annual return) from Tally
- Exporting GST Returns in XML format for submission to GST portal
- Understanding GST filing deadlines and the process of late filing
Module 4: Managing GST Returns in Tally
- Recording reverse charge transactions (RCM purchases and sales)
- Handling GST on export transactions (zero-rated sales, tax-exempt transactions)
- Managing stock transfers between different branches or warehouses and its impact on GST
- Recording imports and exports in Tally (customs duties and shipping charges)
- Generating export-related GST reports for businesses
Module 5: Advanced GST Transactions
- Configuring multi-state business operations in Tally
- Recording sales and purchases for multiple states with appropriate GST tax slabs
- Generating state-wise GST reports for compliance
- Filing IGST returns for inter-state transactions
- Managing inter-state stock transfers and tax implications in Tally
Module 6: Managing GST in Multi-State Businesses
- Configuring payroll in Tally (salary components, deductions)
- Managing Employee-related GST: TDS on salary payments and other employee benefits
- Generating payslips and statutory reports (PF, ESI, and TDS) using Tally
- TDS adjustments and GST liability from employee-related transactions
- Generating compliance reports for payroll-related taxation in Tally
Module 7: Payroll and Taxation Compliance in Tally
- Setting up stock groups, stock categories, and units of measurement for GST-compliant inventory
- Recording inventory purchases and sales with GST calculations
- Tracking GST Input Tax Credit (ITC) on inventory purchases
- Managing stock transfers and GST adjustments in Tally
- Generating stock reports: Stock Summary, Stock Movement, and Inventory Valuation reports
Module 8: GST and Inventory Management
- Performing bank reconciliation in Tally while matching GST-related payments and receipts
- GST payments: Recording payments to the government for GST tax liabilities
- Handling GST refunds: Recording and tracking refunds due to excess payments
- Generating GST payment reports and reconciliation statements
- Managing GST refund claims and their status in Tally
Module 9: Bank Reconciliation and GST Compliance
- Closing books for the financial year with GST adjustments
- Filing GSTR-9 for the end of the financial year
- Generating final GST reports: Annual returns, reconciliation reports
- Preparing for GST audits and tax assessments using Tally data
- GST-related year-end reconciliation and ITC claims
Module 10: Year-End Process and GST Filing
- Practical Exams: Students will be required to handle real-world accounting scenarios with GST in Tally, including transactions, invoicing, GST filing, and reconciliation.
- Assignments: Completion of GST returns, sales and purchase entries, and inventory management in Tally.
- Project Work: Students will create and maintain complete accounting books for a sample business, ensuring GST compliance and generating all required reports.
Assessment:
- Hands-on experience with GST-compliant accounting processes, including GST invoicing, filing returns, and completing transactions.
- Practical knowledge of handling GST in multi-state operations, export/import businesses, and GST audits.
- Expertise in using Tally Prime software for tax filing, GST reports, and compliance management.