Diploma in Financial Computer Accounting (E

Diploma in Financial Computer Accounting (E - DFCA)

Number of Classes : ---

The level or the year of study for which the class is intended.

Batch Size : 20

Batch size refers to the number of training instances in the batch.

Duration : 9 Months

The predetermined time span provided for completing a course.

Download Course Brochure

Basics of Accounting

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	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 Filte
Revision /Test

In the ever-evolving landscape of finance, Computerised Financial Accounting stands as a beacon of progress. Gone are the days of laborious manual bookkeeping—today, technology takes the reins, streamlining processes and empowering financial professionals.

Let’s delve into the intricacies of this transformative field:

The Technological Revolution

Imagine a world where stacks of paper ledgers have been replaced by sleek software interfaces. That’s the reality of computerised financial accounting.

This cutting-edge technology has revolutionised the finance sector, making it faster, more accurate, and infinitely more efficient.

Course Overview

Our course immerses students in the technical nuances of accounting and finance.

If you’re passionate about commerce and crave a deep understanding of financial intricacies, this course is your gateway.

We focus on the technical aspects of the accounting and finance sectors, equipping candidates with the skills needed for success.

Mastering the Art of Tracking Income

At its core, accounting is the art of tracking an organisation’s financial pulse. Computerised financial accounting takes this art to new heights.

Our curriculum covers essential activities

Preparation of Financial Statements: Crafting balance sheets, income statements, and cash flow reports.

Recording Business Transactions: Capturing every financial move, from sales to expenses.

Software Proficiency

Our diploma program ensures proficiency in various subjects, complemented by mastery of essential software packages. Dive into software-based accounting tools and digital spreadsheets. These digital marvels empower you to track transactions seamlessly.

Familiarise yourself with Microsoft Office Suite—Excel, Word, and PowerPoint—essential tools for any financial professional.

Career Pathways

Upon completing the Diploma in Computerised Financial Accounting, a world of opportunities awaits

Accountant: Manage accounts efficiently using specialised software.

Business Executive: Forge client relationships, boost product sales, and contribute to organisational growth.

Audit Officer: Keep a watchful eye on financial operations, ensuring compliance and accuracy.

Private and Government Sectors

Whether you aspire to work in private firms or government agencies, your skills will be in high demand.From entry-level positions to executive roles, chart your own path based on your interests and strengths.

But just knowing the need of this course and Financial accountants 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!

Accounting:

Recording financial transactions accurately in Tally software.
Managing accounts payable and accounts receivable.
Reconciling bank statements and other financial accounts.
Generating financial reports such as balance sheets, profit and loss statements, cash flow statements, and trial balances.

Inventory Management:

Setting up and maintaining inventory records in Tally.
Tracking stock levels, purchases, sales, and returns.
Performing stock reconciliation and valuation.
Generating inventory reports to monitor stock movements and optimize inventory levels.

GST Compliance:

Ensuring compliance with Goods and Services Tax (GST) regulations.
Generating GST-compliant invoices and tax returns.
Reconciling input tax credits and handling GST-related transactions in Tally.

Payroll Processing:

Managing employee payroll processing using Tally software.
Calculating salaries, deductions, and taxes accurately.
Generating pay slips and maintaining payroll records.
Ensuring compliance with statutory requirements related to payroll.

Data Analysis and Reporting:

Analyzing financial data and generating custom reports as per management requirements.
Providing insights and recommendations based on financial analysis.
Presenting financial information to stakeholders in a clear and concise manner.

Training and Support:

Providing training to users on Tally software features and functionalities.
Offering technical support and troubleshooting assistance to resolve software-related issues.
Keeping up-to-date with new features and updates in Tally software.

Customization and Integration:

Customizing Tally software to meet specific business requirements.
Integrating Tally with other business applications and systems as needed.
Developing custom solutions using Tally Prime software development kit (SDK).

Data Security and Compliance:

Ensuring data security and confidentiality of financial information stored in Tally.
Implementing best practices for data backup, disaster recovery, and access controls.
Adhering to regulatory compliance requirements related to financial reporting and data protection.

Contact

Job Oriented Courses