Diploma in Financial Computer Accounting - DFCA

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.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 Deduction at Source

• Activation of TDS feature in Tally Prime
• TDS Statutory Masters
• Configuring TDS at group level
• Configuring TDS at ledger level
• Booking of expense in purchase voucher
• Expenses partly subject to TDS
• Booking expense and deducting TDS later
• Accounting multiple expense and deducting TDS later
• Accounting for TDS on advance payment against Transport
• TDS on expense at Lower rate
• TDS on expense at Zero rate
• Deducting TDS on payments
• Reversal of expense with TDS
• Deducting TDS on Expense with Inventory
• Accounting TDS on Fixed Assets
• Payment of TDS
• TDS reports
• 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