Advance Diploma in Financial Accounting (ADFA)

Computer Fundamental

Windows 11

Module 1: Introduction to 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 2: File and Folder Management

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 3: Personalizing Windows 11

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 4: Working with Windows Settings

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 5: Managing Apps and Software

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 6: File Backup and Recovery

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 7: Security and Privacy Settings

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 8: Taskbar and Window Management

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 9: Networking and Connectivity

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 10: Windows 11 for Productivity

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 11: Updates and Maintenance

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 12: Advanced Features and Tips

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 13: Final Project

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

Assessment:

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

Tools Required:

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

Microsoft Word 365

Module 1: Introduction to MS 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 2: Basic Document Formatting

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 3: Working with Pages and Layout

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 4: Working with Tables

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 5: Inserting Graphics and Objects

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 6: Advanced Formatting Techniques

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 7: Working with Headers, Footers, and Page Numbers

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 8: Reviewing and Proofreading Tools

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 9: Collaboration and Sharing

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 10: Using Mail Merge

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 11: Using Templates and Forms

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 12: Final Project

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

Assessment:

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.

Microsoft Excel 365

Module 1: Introduction to MS 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 2: Data Entry and Formatting

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 3: Basic Formulas and Functions

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 4: Working with Data and Sorting

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 5: Advanced Formulas and Functions

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 7: Working with PivotTables and PivotCharts

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 8: Data Analysis Tools and Functions

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 9: Working with Multiple Sheets and Workbooks

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 10: Printing and Sharing Excel 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 11: Advanced Excel Features (Power Query, Power Pivot)

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 12: Final Project

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

Assessment:

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

Microsoft PowerPoint 365

Module 1: Introduction to MS 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 2: Working with Slides

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 3: Text and Content Formatting

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 4: Inserting Visuals and Objects

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 5: Working with Charts and Graphs

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 6: Animations and Transitions

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 7: Audio, Video, and Multimedia

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 8: Working with Hyperlinks and Action Buttons

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 9: Collaboration and Sharing

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 10: Finalizing and Presenting

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 11: Advanced PowerPoint Features (Optional)

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 12: Final Project

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)

Assessment:

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

Typing in Hindi & English

Computer Hardware

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

Module 1: Introduction to 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 2: Accounting Principles and Concepts

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 3: Double-Entry System of Accounting

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 4: Journal Entries and Ledger

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 5: Subsidiary Books

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 6: Preparation of Financial Statements

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

Goods and Services Tax (GST)

Module 1: Introduction to 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 2: GST Structure and Taxable Events

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 3: GST Registration

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 4: GST on Goods and Services

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 5: Composition Scheme under GST

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 6: GST Invoices, Payments, and Returns

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 7: Input Tax Credit (ITC) under GST

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 8: GST Compliance and Record-Keeping

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 9: GST Refund and Adjudication

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 10: GST Enforcement and Penalties

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 11: Impact of GST on the Economy

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

Tally Prime with GST

Module 1: Introduction to Tally Prime and 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 2: GST Registration and Setup in Tally

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 3: Recording GST Sales and Purchases

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 4: Managing GST Returns in Tally

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 5: Advanced GST Transactions

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 6: Managing GST in Multi-State Businesses

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 7: Payroll and Taxation Compliance in Tally

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 8: GST and Inventory Management

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 9: Bank Reconciliation and GST Compliance

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

10: Year-End Process and GST Filing

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

Assessment:

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.

Job-Oriented Focus:

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.

Tally Prime with GST(Advance)

Module -1 COMPANY SETUP USING TallyPrime
- 1.2. Opening (Loading) the Company in TallyPrime
- 1.3. Modification | Update | Alter Company Details | Delete Company
Module-2 GST SETUP USING TallyPrime
- 2.1. Activate GST for Your Company
- 2.1.1. Activate GST for Regular Dealers
Module-3 ACCOUNTING SETUP USING TallyPrime
- 3.1. Account Groups in TallyPrime
- Practical Assignment-1 : Creation of Account Groups
- 3.2. Ledgers in TallyPrime
- Practical Assignment-2 : Creation of Assets & Liabilities
- 3.2.4. Creating Bank Account Ledgers in TallyPrime
- Practical Assignment-3 : Creation of Bank Account
- 3.2.5. Creating Party Ledgers (Sundry Debtor / Sundry Creditor)
- Practical Assignment-4 : Creation of Debtors and Creditors
- 3.2.6. Creating GST Ledger (CGST / SGST / IGST) under Duty and Taxes Group
- Practical Assignment-5 : Creation of GST Ledger
- 3.2.7. Creating Sales and Purchase Ledgers for GST Compliance
- Practical Assignment-6 : Creation of Sales & Purchase Ledger
- 3.2.8. Creating Expenses and Income Ledgers without GST Compliance
- Practical Assignment-7 : Creation of Income & Expenses Ledger without GST Compliance
- 3.2.9. Creating Service Ledger with GST Compliance
- Practical Assignment-8 : Creation of Service Ledger with GST Compliance
- 3.2.10. Creation of Ledger ‘Rounded off (+/-)’ for rounding the Invoice Value automatically

Module-4: INVENTORY SETUP USING TallyPrime
- 4.1. Creating a Stock Group
- 4.1.1. Modifying / Deleting a Single Stock Group
- Practical Assignment-9 : Creation of Stock Group
- 4.2. Creation of Stock Units of Measure
- 4.3. Creation of Stock Items
Module-5: PURCHASE PROCESS USING TallyPrime
- 5.1. Purchase Voucher (F9)
- 5.2. Local Purchase (within State) :
- Practical Assignment-12 : Purchase of Items & Goods – Within State
- 5.3. Interstate Purchase (Outside State) :
- Practical Assignment-13 : Purchase of Items & Goods – Outside State
- 5.4. Additional Charges/Discount etc. included or Excluded in Assessable Value for GST Calculation
- 5.5. Purchase Bill Voucher with Additional Charges/Discount both Inclusion or Exclusion in Assessable Value for GST Calculation
- Practical Assignment-14 : Purchase of Items & Goods with Additional Charges/Discount both Local and Outside State
- 5.6. Enter the Discount Percentage against each item – without using the Ledger Account
- Practical Assignment-15 : Purchase of Items & Goods with Discount Percentage (%) against each items
- 5.7. Enter Discount Percentage and/or Amount on Item Rates – using the Ledger Account
- Practical Assignment-16 : Purchase of Items & Goods with Discount Amount and / Or Percentage (%) against each items using Discount Ledger
- 5.8. Record Expenses with GST in Purchase Voucher (F9)
- 5.9. Purchase of Fixed Assets (Capital Goods) with GST in Purchase Voucher (F9) :
- Practical Assignment-18 : Creation of Fixed Assets with GST Compliance
- 5.10. Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods using TallyPrime
- Practical Assignment-20 : Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods
- 5.11. Purchase of FREE Items & Goods using TallyPrime
- 5.12. Purchase Return / Debit Note Voucher (Alt+F5)
Module-6: SALES PROCESS USING TallyPrime
- 6.1. Alter Pre-defined ‘Sale’ Voucher Types
- 6.2. Sale Voucher with Item Invoice for GST Compliance
- 6.3. Sale of ‘Nil-Rated’, ‘Exempted’, Supplies using TallyPrime
- 6.4. Ledger to Round-off the Invoice Value Automatically in Sale Invoice
- 6.5. Zero Valued Entries in Sale Invoice
- 6.6. Enable Item Rate (Inclusive of Tax) in Sale Invoice
- 6.7. Sales of Items with Discounts
- 6.8. Manage Selling Price Using Standard Price
- 6.9. Sale Voucher with Accounting Invoice for Service Ledger
- 6.10. Sales Return / Credit Note (Alt+F6)
- 6.11. Debit Note for the Increase in Sale Value
Module-7: e-Way Bill & e-Invoice using TallyPrime
- 7.1. Enable / Setup e-Way Bill in TallyPrime
- 7.2. Create e-Way Bill Profile on the e-Way Bill Govt. Portal
- 7.3. Generate Online e-Way Bill with Sales in TallyPrime
- 7.4. Print the Sales Invoice with e-Way Bill number using TallyPrime
- 7.5. How to Generate e-Invoice Instantly in TallyPrime?

Module-8: Printing of Sales Invoice with Multiple Configurations
- 8.1. Change of Invoice Title in Sales Invoice
- 8.2. Print Sales Invoice with Company LOGO
- 8.3. Printing Bank Details in Sales Invoice
- 8.4. Printing Previous and Current Balance in Invoice
- 8.5. Change Declaration / Terms & Conditions in Sales Invoices
- 8.6. ‘Setting Print Size of your Sales Invoice’ to Use Less Paper for Printing
- 8.7. Add Description for Items & Ledgers to Print in Invoice
- 8.8. Print Proforma Invoice (Optional Voucher)
- 8.9. Print Invoice on Saving a Voucher
Module-9: Set Up Goods / Services Under Reverse Charge Mechanism (RCM)
- 9.1. Set Up Goods / Services Under Reverse Charge Mechanism (RCM)
Module-10: CONTRA VOUCHER USING TallyPrime
- 10.1. Record Contra Voucher in Single-Entry Mode
Module-11: “PAYMENT VOUCHER” USING TallyPrime
- 11.1. Payment Voucher (F5)
- Practical Assignment-28 : Payment Transactions
Module-12: RECEIPT Using TallyPrime
- 12.1. Receipt Voucher (F6)
- Practical Assignment-29 : Receipt Transactions
Module-13: “JOURNAL VOUCHER” Using TallyPrime
- “JOURNAL VOUCHER (F7)” USING TallyPrime
- Practical Assignment-30 : Journal Transactions

Module-14: GST REPORT to File GST Return Using TallyPrime
- 14.1. Track GST Return Activities
- 14.2. GSTR -1 Report in TallyPrime
- 14.3. GSTR -3B Report in TallyPrime
- 14.4. GST Annual Computation Report in TallyPrime
Module-15: ORDER PROCESSING Using TallyPrime
- 15.1. Purchase Order (Ctrl+F9) Processing in TallyPrime
- 15.2. Sales Order (Ctrl+F8) Processing in TallyPrime
Module-16: Bill Of Material (BoM) for Manufacturing Unit
- 16.1. Setup Bill of Materials (BOM)
- 16.2. Creating a Manufacturing Voucher
Module-17: Price Levels & Price List Using TallyPrime
- 17.1. Price Levels in TallyPrime
- 17.2. Use Price Levels & Price List during Voucher Entry
Module-18: Cost Centre and Cost Category Using TallyPrime
- 18.1. Creating Cost Category and Cost Centre
- 18.2. Applying Cost Centres to Ledger Accounts
- 18.3. Cost Centres Allocation in Voucher Entry
Module-19: TDS (Tax Deducted At Source) Using TallyPrime
- 19.1. Enabling TDS in TallyPrime
- 19.2. Creating TDS Nature of Payment
- 19.3. Creating Master Ledger with TDS Transaction i.e. Expenses, Party Ledger, TDS Ledger
- 19.4. TDS on Advance Payment against Expenses
- 19.5. Recording Payment Transaction (TDS)
Module-20: Optional & Non-Accounting Vouchers
- 20.1. Memo (Memorandum) Voucher
- 20.2. Optional Voucher
- 20.3. Post-dated Voucher
- 20.4. Physical Stock Voucher (Ctrl + F7)
- 20.5. Stock Journal Voucher (Alt+F7)
- 20.6. Rejection In Voucher
- 20.7. Rejection Out Voucher
Module-21: Consignment Transactions (Material In & Material Out) in TallyPrime
- 21.1. Issue Stock Items (Material Out) for Consignment Sales
- 21.2. Record Sales of Goods by Third Party (Consignment Sale)
- 21.3. Record Receipt of Goods Returned by Third Party (Material In)
Module-22: REPORTS in TallyPrime
- 22.1. Modifying Reports
- 22.2. Display Financial Statements in TallyPrime
- 22.3. Display Books, Registers and Ledgers
- 22.4. Display Inventory Reports and Statements
- 22.5. Display Management Information System(MIS) Reports
Module-23: Filter in REPORTS using TallyPrime
- 23.1. Apply Filter in Reports | Basic Filter, Multi-Filter, Advanced Filter
Module-24: DashBoard in TallyPrime
- 24.1. View Dashboard
- 24.2. Add/Remove Tile in Dashboard
Module-25: Customize Reports in TallyPrime
- 25.1. How to Customize Reports in TallyPrime

GIT Padrauna

Advanced Diploma in Financial Accounting (ADFA)

Course Curriculum

Computer Fundamental

Windows 11

Microsoft Word 365

Microsoft Excel 365

Microsoft PowerPoint 365

Typing in Hindi & English

Computer Hardware

Application of Internet & Email System

Basic of Financial Accounting

Goods and Services Tax (GST)

Tally Prime with GST

Tally Prime with GST(Advance)

Gayatri Institute of Technology

Contact

Company

Our Features

Advanced Diploma in Financial Accounting (ADFA)

Course Curriculum

Computer Fundamental

Windows 11

Microsoft Word 365

Microsoft Excel 365

Microsoft PowerPoint 365

Typing in Hindi & English

Computer Hardware

Application of Internet & Email System

Basic of Financial Accounting

Goods and Services Tax (GST)

Tally Prime with GST

Tally Prime with GST(Advance)

Subscribe Our Newsletter

Gayatri Institute of Technology

Contact

Company

Our Features