Diploma In Adv.Financial Accounting - (E-DAFA)

IT/Digital Era - Entering into Computer World Keep your Data (Storage Device)

• Computer Definition & Features
• Application of computer
• How to start Computer
• login screen - user & Password
• Desktop- Taskbar, Wallpaper, Icons
• How to start paint, some basic tools

• Computer Architecture Diagram
• Father of computer
• Devices of computer: Input, output & processing Memory Unit(MU)
• Primary memory, Secondary memory
• Unit of measurements
• Hardware & Software
• File & folder

Find your Space in Computer (File & Folder)

• Window explorer , File & folder

Searching : Find your File/Folder Wild Cards

• Extensions of program
• Wild card Asterisk(*), Question mark(?)
• Searching for file and folder

1.Start your Career - CV/Resume Creation

• Definition, Feature
• How to start Ms Word
• File, font group

2.Beautifying your CV/Resume (Formatting)

• Quick Access Tool Bar
• Paragraph Group, Clipboard group, Editing group

3.Letterhead - Show case of Your Company

• Insert tab: Header & footer group
• Date & Time, Symbol Picture
• Home tab: change Case, Border & Shading

4.News Paper & Magazine Creation (Column)

• Page layout tab: columns, column break
• Insert tab: Drop cap, Book cover
• file:Auto correct
• Review tab: Word Count, Spell Check, Thesaurus

5.Create your Own Book

• Refrence tab: Insert endnotes, Insert footnotes, table of content
  watermark, Hyphenation

6.Links and Security

• Refrence tab: Insert caption, index entry,
• Links: Booksmarks, Hyperlink, cross Reference
• Review tab: Track changes, Protect document

7.Connect your Customer (Bulk Mailing)

• Mail Merge , Main document & Data source

8.Connect your selected customer(Record filtration)

• Sorting of Record
• Filter of Record
• Lables
• Envelope

9.Mark sheet Creation (Tabular format data )

• Insert table, Draw table
• Layout tab
• Design tab

10.Document is ready to print/Record your actions

• Page setup
• Print preview
• Print
• Macro

1.World of Row and Column - First interaction with excel

• Introduction of excel, Workbook, Worksheet, Row, Column, Cell, type of entries
• Home tab: Cell group, Font group, Alignment

2.Invoice / Bill of Supply

• Type of Reference : Absolute, Relative
• Basic formulas
• Sum, Product, Minus, Quotient, Mod, Percentage)

3.Result Declared (Automatic Calculation)

• Function

4.Secure your Data/ Lock your data/ Restrict editing

• Styles group :  Format as table, Conditional Formatting, Cell styles
• Protection: Track Changes, Protection

5.Data Analysing Tool (Expense Limit & Comparision)

• What if Analysis: Goal seek, Scenario, Data table

6.Pictorial Representation of Data (Chart Magic)

• Pictorial Represntation of data
• Chart, type of chart, formatting of charts

7.Organize your Data (Easier to Analyze)

• Data validation, Data filtration, sort, subtotal

8.Analyzing Complex Data (Pivot Table)

• Logical function: if and, if or
• Pivot table, Pivot chart, Paste special

9.Lookup & Reference , Extract Your Data

• Lookup functions : lookup, vlookup, hlookup
  match, index

10.Data is ready to Print /Page Setup

• Page setup
• Print preview

1.Welcome to Presentation World

• PowerPoint - Definition feature, purpose ,view of slides
• Home tab-slide group

2.Beautifying presentation (Formatting of presentation)

• Font & Alignment Group
• Inset tab - Illustration group
• Themes & Background

3.Masters of Slide/ Slide Automation

• Masters
• Animation(triggers
• Transition
• Hyperlink, Actions
• Slide background

4.Its presentation time now

• Slide show tab - From beginnng, from current slide, Custom slide show,setup slide, Hide slide, Record narratio, Rehearse timing, slide show
• Inset tab- photo album

5.Advance feature of Presentation

• Running Clock, Moving Car, Making Picture, Bouncing Ball

1.World of Internet 

• Internet introduction & Benefit
• Computer Network: LAN, WAN, MAN
• Services of internet
• Search engine, Web browser

2.Online Communication

• Inbox , Reply, Forward, composing, Attachments of file,
  Change password(setting of E-mails) , Facebook account handling, 
  Facebook page creation

3.Downloads/Booking

• Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket
• Download: Image, font style, app, pdf, song, movie

4.Digital India

• Cash less society
• E-wallets, UPI, Plastic money, USSD, Net Banking

1.Lets Upgrade Advance Skills

• Type Of Function 
• Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown,
• Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text 

2.Audit & Management Of Data

• Trace Precedent , Trace Dependent ,
• Remove Arrow , Error Checking , 
• Text to Column , Flash Fill, 
• Data Validation , Remove Duplicate , 
• Consolidate

3.Salary Sheet

• Definition
• Salary sheet Calculation
• Pay slip

4.Dashboard

• Pivot Table
• Pivot Chart
• Slicer
• Timeline 
• Value Function
• Convert Function 

5.Loan Installment Sheet 

• Financial Function 
• PMT, NPER, PV , FV, RATE

6.Garbage Clearing

• If function in Loan Sheet 
• Age Calculation

7.Working With Function

• Double Vlookup Function 
• Vlookup With Match
• Vlookup With Hlookup

8.Xfunction

• If with Vlookup & Hlookup 
• IF with Not
• Xlookukp Function
• XOR

9.Special Tools In Excel 

• Name Manager 
• Conditional Formatting 
• Calendar
• Checkbox

10.Attendance Sheet

• If Error Function
• Eomonth Function

11.Trick & Techniques

• Basic Tricks
• Subtotal With Filter

1.Fundamental of Accounting

• What is Accounting
• Process of Accounting
• Event of  Transaction
• Accounting Terminology

2.Accounting Concept

• Rules of Debit Credit
• Accounting Equation 
• Accounting Principles
• Rules and Approach For Accounting
• Traditional approach
• Modern approach

3.Preparation of Ledger Account

• What do you mean by leadger Format  method of posting leader

4.Explanation of Cash Book

• What is cash book
• Types of cashbook
• Single column
• Double column
• Triple column
• Why cash book maintain separately

5.Bank Reconciliation Statement

• Introduction
• Who maintain cash book and pass book
• Why it is necessary
• Causes of BRS

6.Depreciation

• What is Depreciation factor
  causes of depreciation
• Equation of Depreciation
• Method of Dep.
• SLM
• WDV
• Class Assignment

7.Basics of final Account

• Trading A/C
• Profit and loss  A/C
• Balance sheet
• Format of final accounting
• Class assignment

1.Stock/ inventory Keeping Units

• Introduction
• Creation of stock group
• Creation of Unit of Measure
• Creation of Stock Item
• Creation of Godown

2.Recording of Day to Day Transaction –Voucher

• Introduction
• Receipt Voucher
• Contra Voucher
• Payment Voucher
• Purchase Voucher
• Sale Voucher
• Debit Note Voucher
• Credit Note Voucher
• Journal Voucher
• Creation new Voucher Type
• Non Accounting Voucher
• Inventory Voucher
• Assignment

3.Management of Accounts receivable and Payable

• Management of bill wise bill maintenance Credit Limit

4.Fundaments of Inventory Management

• Recording of  Day to Day Transaction –Voucher

5.Godown Management

• Allocation of stock to Particular Godown while defining opening Balance
• Recording of purchase ,sales, and Stock transfer with Godown Details
• Stock category
• Movements of goods in Batch/Lots-Batch wise Detail
• Expired Batch/Transfer
• Batch Reports
• Stock Valuation Method
• Assignments

6.Management of purchase and sales order

• Purchase order processing
• Sales order processing
• Viewing order details
• Pre close order
• Reorder level
• Assignments

1.Banking

• Cheque management
• Cheque Printing
• Multi Cheque Printing
• Cheque Register
• Cancelled Cheque
• Blank Cheque
• Bank Reconciliation 
• Deposit Slip
• Assignment

2.Cost Centre and Profit Centre Allocation

• Create Cost Centre
• Cost center summary
• Create Cost Category
• Cost Category summary
• Cost Centre Class
• Assignments

3.Price level and price list

• Creation of price list
• Using price list
• Revise price list
• Assignments

4.Bills of Material

• Set component (BOM)
• Accounting of manufacturing process
• Transferring of manufactured goods
• Reports
• Cost estimation
• Assignments

5.Job Costing

• Enable job costing
• Creating Required masters
• Creating manufacturing journal voucher
• Job costing reports
• Assignments

6.Job Work

• Enabling job order processing
• Voucher type set up for job Work In
• Voucher type set up for job Work In
• Job order processing
• Voucher type set up for job Work In
• Job order processing
• Creation of inventory
• Record job work out order voucher
• Issued of raw material to job worker
• Receipt of finished goods
• Job work out reports
• Recording job work in order voucher
• Recording material in voucher
• Manufacturing of finished goods
• Dispatching finished goods to manufacturer
• Job work in order reports
• Assignments

7.Interest calculation

• Activating interest calculation brining the calculated interest amount in books of account
• Using advance parameters for interest calculation
• Advance parameter explanation
• Calculation of compound interest in Tally Prime
• Interest calculation reports
• Assignments

Payroll

• Activating payroll
• Employee group master
• Employee masters
• Creation of payroll units
• Attendance production type
• Creation of pay head
• Defining salary details for an employee
• Salary processing
• Payroll reports
• Payroll statuary deduction
• Provident fund
• EDLI
• Employee state insurance
• Professional tax
• National pension scheme
• Define salary details
• Process salary
• Payroll statuary reports
• Gratuity
• Assignments

Tax Collection at Source

• Configuring Tally Prime for TCS
• Create TCS nature of Goods
• Creation of Accounting Masters
• Sales of TCS Goods at Lower Rates
• Sales of TCS Goods at Nil rate
• TCS on transfer to Right to Use
• Payment of TCS
• TCS reports
• Assignments

Goods and Service Tax

• Getting started GST with GST(Goods)
• Introduction
• Enabling GST and Defining Tax details
• Intrastate Supply of Goods
• Intrastate outward supply
• Interstate supply
• Interstate Inward supply
• Interstate outward supply
• Return Of Goods
• Purchase return
• Sales Return
• Supplies Invoice of tax
• Defining GST Rates at Stock Group level
• Defining GST rates at Stock Item Level
• Defining GST rates at transaction Level
• GST Reports
• Input Tax Credit Set off
• GST Tax payment
• Challan reconciliation
• Assignments

GST(part-2)

• Getting started GST with GST(services)
• Introduction
• Enabling GST and Defining Tax details
• Intrastate Supply of service
• Intrastate Outward Supply
• Interstate Supply of Services
• Interstate Outward Supply of goods
• Cancellation of Services
• Cancellation of Outward Supply
• Defining tax Rates at Master and Transaction Level
• Assignment

1.Setting up a Company in BUSY

• Creating a New Company
• Opening a Company
• Editing a Company
• Closing a Company
• Deleting a Company

2.Accounting & Inventory

• Creating Masters
• Accounts
• Account Group
• Item
• Item Group
• Material Centre
• Material Centre Group
• Unit

3.Entering Vouchers

• Sales
• Sales Return
• Purchase
• Purchase Return
• Payment
• Receipt
• Journal
• Contra
• Debit Note
• Credit Note
• Stock Transfer

4.Advance Features

• Budget
• Credit Limit
• cost Centers
• Price Levels
• Point of Sale- POS
• Bills of Material -BOM

5.Taxation In Busy

• Tax Deduction at Source -TDS
• Tax Collection at Source -TCS
• Goods and Service Tax -GST

1.Introduction Of Income Tax

• About Taxation in India
• Direct and Indirect tax
• Act and Law
• Activity Day 01

2.Assessee And Computation With Slab

• Assessee - tax payer
• Period of taxation
• Heads of Income
• Slab Rate
• Activity Day 02 

3.Prepaid Taxes And Interest

• Prepaid Taxes
• Interest on Advance Tax
• Final Computation
• ITRs Applicable on Different Income
• Activity Day 03

4.E Filing Of ITR - 01

• Income from Salary
• One House Property
• Other Sources
• Deduction Chapter VI-A of the Act
• Computation
• e-filing of ITR -01 Through Portal
• Practice Assignment

5.E Filing Of ITR - 03-Business Income

• Business or Professional Income
• Schedule of ITR-3
• Computation

6.Return Filing Form -ITR-03

• Practice Assignment
• MCQ -10 Question

7.E Filing Of ITR -04-Presumptive Income

• About Presumptive Income
• Presumptive Scheme 44AD/44ADA/AE
• Computation of income
• Return filing form -ITR-04
• Practice Assignment
• MCQ -10 Question

1.TDS-Introduction

• Important Abbreviations and Definition
• Why TDS /TCS is Required
• Objective of TDS
• Who is Responsible for TDS Deduction
• Payment eligible for TDS Deduction
• TDS Deduction Threshold Limit & Rate
• Online Challan payment of TDS - Challan 281

2.Payment to Other Than Salary -26Q

• Party Payment and Deduction
• Threshold Limit & Rate with TDS Section -193 to 194IB
• FAQs on Payment and Deduction -26Q

3.TDS Return -26Q [Practical]

• Step by Step Computation -FORM 26Q
• Generate FVU File and FORM 26Q through Software

4.Allowance & Basic Salary

• Type of Allowances
• Computation of Allowance

5.Perquisites

• Type of Perquisites
• Computation of Perquisites

6.TDS Return -24Q

• Salary Computation of Employee
• TDS Deduction and Deposit by Employer
• Generate FVU File and FORM 24Q through Web-e-TDS Software

7.Tax Collection at Sources (TCS)

• What is TCS
• Payment eligible for TCS
• Threshold Limit & Section 206 with RATE CHART
• Computation and Return filing of FORM - 27EQ
• Generate FVU File and FORM 27EQ Through Software
• FAQs on Payment and Deduction -27EQ

8.About Traces Website-WWW.Tdscpc.Gov.In

• Login on TRACES
• View 26AS -Details of Advance Tax and TCS/TCS
• Download FORM 16/16A

1.Introduction of GST

• Eligibility in India 
• About GST Council 
• GST Registration 
• Slab Rates 

2.Understanding the concept of supply

• Definition of supply 
• Type of Taxable payer  
• Type of supply 
• Composite Supply 
• Mixed supply

3.Time of supply 

• Time of supply in case of Goods 
• Time of Supply in case of services 
• Time of supply in case of RCM
• Time of Supply in case of Voucher 
• Time of Supply in Case of Advance Receipt

4.Place of supply

• Supply in India 
• Supply outside India

5.Recording of advance entries in Tally Prime -1

• Accounting Multiple Services in a Single Supply
• Recording Partial Payment to Suppliers
• Recording Outward Supply with Additional Expenses
• B2C supply of services (Business to Consumers).
• Exempt supply of services under GST
• Reverse Charge on Services under GST
•  Advance Receipts from Customers under GST
• Advance Receipt and Issuing Invoice on Different Month

6.Recording of advance entries in Tally Prime -2

• Purchases from Composition Dealer
• Purchases from Unregistered Dealers
• Exports Through LUT/Bond
• Exempted Goods
• SEZ Sales  Advance Receipts and Payments

7.Composition scheme

• Threshold Limit for Composition Scheme
• Who is eligible Assessee
• Rate applicable to a Composition Dealer
• Limitations of GST Composition Scheme
• Registration under Composition Scheme

8.E-way bill under GST

• Who Is Eligible to Issue E Way Bill
• E-Way Bill Is Not Required
• Format & Eligibility to Issue E- Way Bill
• Information’s to Be Filled In E-Way-Bill
• Process to Generate E Way Bill
• Documents or Details Required to Generate E-way Bill

9.Input tax credit (ITC) and payment

• How we claim ITC-Set off Tax Liability
• How to Claim Input Credit Under GST
• Documents to avail ITC
• ITC on Job Work
• Who is liable to pay GST
• Electronic Ledger
• Electronic LIABILITY ledger
• Electronic CREDIT ledger
• Electronic CASH ledger
• Payment Process of GST
• Due Date of Tax Deposit
• FAQ On Payment

10.Return filing of GST-GSTR

• Annual Return 
• Due Date Chart
• Process of e-filing of GSTR-01- Outward Supply
• What is HSN Code
• Process of Return Filing GSTR -2A to GSTR -02
• Process of filing GSTR-03