Diploma In Advance Financia Accounting (E-DAFA)

Download Course Brochure

Computer Component & Fundamental

Application Based Training-ABT	Tools and Application
IT/Digital Era - Entering into Computer World Devices of Computer/ Gadgets of computer 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

Application Based Training-ABT	Tools and Application
Operating System Computer Industry	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

Application Based Training-ABT	Tools and Application
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

Application Based Training-ABT	Tools and Application
Start your Career - CV/Resume Creation	Definition, Feature How to start Ms Word File, font group
Beautifying your CV/Resume (Formatting)	Quick Access Tool Bar Paragraph Group, Clipboard group, Editing group
Letterhead - Show case of Your Company	Insert tab: Header & footer group Date & Time, Symbol Picture Home tab: change Case, Border & Shading
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
Create your Own Book	Refrence tab: Insert endnotes, Insert footnotes, table of content watermark, Hyphenation
Links and Security	Refrence tab: Insert caption, index entry, Links: Booksmarks, Hyperlink, cross Reference Review tab: Track changes, Protect document
Connect your Customer (Bulk Mailing)	Mail Merge main document & Data source
Mark sheet Creation (Tabular format data )	Insert table, Draw table Layout tab Design tab
Document is ready to print/Record your actions	Page setup Print preview Print Macro

Application Based Training-ABT	Tools and Application
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
Invoice / Bill of Supply	Type of Reference : Absolute, Relative Basic formulas Sum, Product, Minus, Quotient, Mod, Percentage)
Result Declared (Automatic Calculation)	Function
Secure your Data/ Lock your data/ Restrict editing	Styles group : Format as table, Conditional Formatting, Cell styles Protection: Track Changes, Protection
Data Analysing Tool (Expense Limit & Comparision)	What if Analysis: Goal seek, Scenario, Data table
Pictorial Representation of Data (Chart Magic)	Pictorial Represntation of data Chart, type of chart, formatting of charts
Organize your Data (Easier to Analyze)	Data validation, Data filtration, sort, subtotal
Analysing Complex Data (Pivot Table)	Logical function: if and, if or Pivot table, Pivot chart, Paste special
Lookup & Reference , Extract Your Data	Lookup functions : lookup, vlookup, hlookup match, index
Data is ready to Print /Page Setup	Page setup Print preview

Application Based Training-ABT	Tools and Application
Welcome to Presentation World	Powerpoint - Definition feature, purpose ,view of slides Home tab-slide group
Beautifying presentation (Formatting of presentation)	Font & Alignment Group Inset tab - Illustration group Themes & Background
Masters of Slide/ Slide Automation	Masters Animation(triggers Transition Hyperlink, Actions Slide background
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
Advance feature of Presentation	Running Clock, Moving Car, Making Picture, Bouncing Ball

Application Based Training-ABT	Tools and Application
World of Internet	Internet introduction & Benefit Computer Network: LAN, WAN, MAN Services of internet Search engine, Web browser
Online Communication	Inbox , Reply, Forward, composing, Attachments of file, change password(setting of E-mails) Facebook account handling, Facebook page creation
Downloads/Booking	Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket Download: Image, font style, app, pdf, song, movie,
Digital India	Cash less society E-wallets, UPI, Plastic money, USSD, Net Banking

Application Based Training-ABT	Tools and Application
Fundamental of Accounting	What is Accounting Process of Accounting Event of Transaction
Fundamental of Accounting	Accounting Terminology
Accounting Concept	Rules of Debit Credit Accounting Equation Accounting Principles
Accounting Concept	Rules and Approach For Accounting Traditional approach Modern approach
Journal Entries	Advance Journal Entries with Students Practice Assignments
Preparation of Ledger Account	What do you mean by leadger Format method of posting leader
Explanation of Cash Book	What is cash book Types of cashbook Single column Double column Triple column Why cash book maintain separately
Bank Reconciliation Statement	Introduction who maintain cash book and pass book why it is necessary causes of BRS
Depreciation	what is Depreciation factor Causes of Depreciation Equation of Depreciation Method of Dep. SLM WDV Class Assignment
Basics of final Account	Trading A/C Profit and loss A/C Balance sheet format of final accounting Class assignment

Application Based Training-ABT	Tools and Application
Stock/ inventory Keeping Units	Introduction Creation of stock group Creation of Unit of Measure Creation of Stock Item Creation of Godown
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
Management of Accounts receivable and Payable	Management of bill wise bill maintenance Credit Limit
Fundaments of Inventory Management	Recording of Day to Day Transaction –Voucher
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
Management of purchase and sales order	Purchase order processing Sales order processing Viewing order details Pre close order Reorder level Assignments

Application Based Training-ABT	Tools and Application
Banking	Cheque management Cheque Printing Multi Cheque Printing Cheque Register Cancelled Cheque Blank Cheque Bank Reconciliation Deposit Slip Assignment
Cost Centre and Profit Centre Allocation	Create Cost Centre Cost centre summary Create Cost Category Cost Category summary Cost Centre Class Assignments
Price level and price list	Creation of price list Using price list Revise price list Assignments
Bills of Material	Set component (BOM) Accounting of manufacturing process Transferring of manufactured goods Reports Cost estimation Assignments
Job Costing	Enable job costing Creating Required masters Creating manufacturing journal voucher Job costing reports Assignments
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
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

Application Based Training-ABT	Tools and Application
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
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

Application Based Training-ABT	Tools and Application
Setting up a Company in BUSY	Creating a New Company Opening a Company Editing a Company Closing a Company Deleting a Company
Accounting & Inventory	Creating Masters Accounts Account Group Item Item Group Material Centre Material Centre Group Unit
Entering Vouchers	Sales Sales Return Purchase Purchase Return Payment Receipt Journal Contra Debit Note Credit Note Stock Transfer
Advance Features	Budget Credit Limit cost Centers Price Levels Point of Sale- POS Bills of Material -BOM
Taxation In Busy	Tax Deduction at Source -TDS Tax Collection at Source -TCS Goods and Service Tax -GST

Application Based Training-ABT	Tools and Application
Introduction Of Income Tax	About Taxation in India Direct and Indirect tax Act and Law Activity Day 01
Assessee And Computation With Slab	Assessee - tax payer Period of taxation Heads of Income Slab Rate Activity Day 02
Prepaid Taxes And Interest	Prepaid Taxes Interest on Advance Tax Final Computation ITRs Applicable on Different Income Activity Day 03
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
E Filing Of ITR - 03-Business Income	Business or Professional Income Schedule of ITR-3 Computation
Return Filing Form -ITR-03	Practice Assignment MCQ -10 Question
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

Application Based Training-ABT	Tools and Application
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
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
TDS Return -26Q [Practical]	Step by Step Computation -FORM 26Q Generate FVU File and FORM 26Q through Software
Allowance & Basic Salary	Type of Allowances Computation of Allowance
Perquisites	Type of Perquisites Computation of Perquisites
TDS Return -24Q	Salary Computation of Employee TDS Deduction and Deposit by Employer Generate FVU File and FORM 24Q through Web-e-TDS Software
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
About Traces Website-WWW.Tdscpc.Gov.In	Login on TRACES View 26AS -Details of Advance Tax and TCS/TCS Download FORM 16/16A

Application Based Training-ABT	Tools and Application
Introduction of GST	Eligibility in India About GST Council GST Registration Slab Rates
Understanding the concept of supply	Definition of supply Type of Taxable payer Type of supply Composite Supply Mixed supply
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
Place of supply	Supply in India Supply outside India
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
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
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
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
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
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

Application Based Training-ABT	Tools and Application
Lets Upgrade Advance Skills	Type Of Function Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown, Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text
Audit & Management Of Data	Trace Precedent , Trace Dependent , Remove Arrow , Error Checking , Text to Column , Flash Fill, Data Validation , Remove Duplicate , Consolidate
Salary Sheet	Definition Salary sheet Calculation Pay slip
Dashboard	Pivot Table Pivot Chart Slicer Timeline Value Function Convert Function
Loan Installment Sheet	Financial Function PMT, NPER, PV , FV, RATE
Garbage Clearing	If function in Loan Sheet Age Calculation
Working With Function	Double Vlookup Function Vlookup With Match Vlookup With Hlookup
Xfunction	If with Vlookup & Hlookup IF with Not Xlookukp Function XOR
Special Tools In Excel	Name Manager Conditional Formatting Calendar Checkbox
Attendance Sheet	If Error Function Eomonth Function
Trick & Techniques	Basic Tricks Subtotal With Filter
Revision /Test

Have you ever thought about who actually identifies financial problems in a company and develops solutions to prevent it? Either it is maintenance of financial records, preparation of financial statements, comparison of results, decision making, evidence in legal matters, accounting helps a company and an individual in all of these spheres.

When it comes to accounting, some people call it an art, or some call it science, but in any company the task of classifying, recording and summarising financial transactions is one of the biggest responsibilities given to an accountant.

As we all know that any business or company is built on a few pillars, so one of the major pillars of any company is its finance and accounts, that's why the need for an individual to manage the finances is at its peak.

ACCOUNTING - A WAY TO A SUCCESSFUL CAREER

With the growth of new businesses and companies, the need for an accountant is growing, even if the company is well established, or just starting, there's always a vacant position when it comes to finances.

Not just financial, even if it's strategic advice, or business consultancy, accountancy plays a major role in any business decision.

As any business strive for success, either in private sector, governmental sector or non governmental sector, accountants have an immense value, as they help them to grow globally, and take any economy forward.

With the growing need of accountants, there are other perks that comes with it -

Employment of accountants and auditors is projected to grow 4 percent from 2022 to 2032.
About 125,600 openings for accountants and auditors are projected each year.
High salary and competitive income.
After pursuing accounting course one can expect a secure career as accountancy has given paramouont importance in any business
One of the prestigious position has been given to an individual after pursuing this course better work experience and environment.

ACCOUNTING COURSE - To skyrocket one's career

After understanding how important this course is for one's career, we need to realize the fact, that for better job opportunities we need better accounting courses, cause a course done by a reputed institution plays a major role in your upcoming working years.

Not just an accountant, accounting clerk, accounting assistant, financial planner, financial advisor and what not, This course gives you an open field, where you can choose any position with stability in your career life.

But just knowing the need of this course and accountants/ auditors/ audit managers won't skyrocket your career, for that you need to pursue this course from an institution that works on skill based courses, has a long journey, and a lot of experience, mentors who provide you with their best teachings, pocket friendly courses, accessible courses (both online and offline), has a high recruitment/placement rate after the completion of course and these are the qualities SPARC institution has and all of this helps us to stand out amongst all !

This is where you belong, and SPARC sees you starting your journey with us!

Accountant: You could work as an accountant in various industries, managing financial records, preparing financial statements, and ensuring compliance with taxation laws.

Tax Consultant: With knowledge of Income Tax, GST, and TDS return filing, you could work as a tax consultant, helping individuals and businesses with tax planning, compliance, and filing.

Financial Analyst: Your skills in Excel and Advanced Excel could be valuable in financial analysis roles, where you analyze financial data, prepare reports, and provide insights to support decision-making.

Auditor: You could work as an auditor, examining financial records to ensure accuracy and compliance with regulations. Your understanding of Tally and Busy could be particularly useful in auditing roles.

Finance Manager: With experience and additional qualifications, you could advance to roles such as finance manager, where you oversee financial operations, develop budgets, and provide strategic financial guidance to organizations.

Freelancer/Consultant: You may choose to work independently as a freelance accountant, tax consultant, or financial analyst, offering your services to clients on a contract basis.

Educator/Trainer: If you enjoy teaching, you could become a trainer or educator, sharing your expertise in e-accounting software and financial management with students or professionals through workshops, seminars, or online courses.

Business Owner: With your skills in financial management and taxation, you may consider starting your own accounting or consulting firm, providing services to small businesses and individuals.

Contact

Job Oriented Courses