E-lite Institute Of Finance & Management

+91-7828025941 +91-9983026744

Pay Now

E-Accounts, E-Taxation, E-GST Training Course in Jaipur, NCR By 3 CA Trainer

Accounting-GST Certification

Industry-oriented certification Accounts & Taxation training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.

Experienced CA/CFA Faculty

Professional expert 4-5 CA/FCA With 10+ Years of working experience will provide you industrial level training and online e-filing on real time.

100% Interview Guarantee

Receive placement assistance after completion of 70% training, E-Lite team will arrange interviews till you’ll get the placement.

LAB Facility

You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.

BAT Workshop Sessions

You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete E-Lite workshop.

Admin Support

E-Lite’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.

E-Accounting, E-Taxation, E-GST Course Details

E-Accounts, E-Taxation & E-GST Practical Training With Advanced Excel-SAP FICO-Tally ERP9 By Chartered Accountant.

Course Duration: 200 – 210 Hours with Highly Skilled 3 – 5 Corporate Trainers

(CA/HR Manager/MIS Analyst) for 9 Modules

E-Lite Institute Jaipur – E-Accounts , E-Taxation, E-GST Practical Training Delivery Method:

Web / Desktop Base.
Instructor-Led Classroom Sessions.
Presentations/Demonstration/Practicals of concepts.
Handouts/Assignments/Real-time Exposure to work on Clients.

NOTE: Classes are also Available on Module Basis

E-Accounting, E-Taxation and E-GST Course Modules

Certified Taxation, Accounting, Finance TAF Course

Module 1 – Advanced Goods & Services Tax Practitioner Course - By CA– (Indirect Tax)

Module 1.1 – Basic of GST Overview of Model GST Law <ul> <li>Why GST is an Indirect Tax?</li> <li>FCM vs RCM</li> <li>Political and Constitutional Journey Saga of GST.</li> <li>GST Components</li> </ul> <ul> <li>GST HSN and SAC issues and Challenges</li> <li>VAT Concept interplay with GST</li> <li>Assessing GST Impact on Business through Detailed Business Process Modal</li> </ul> <ul> </ul>   Module 1.2 – E-GST Registration with GST Rules & Formats <ul> <li>Registration in GST….A legal Analysis</li> <li>Registration on The basis of Threshold Limit (Sec-22)</li> <li>Compulsory Registration (Sec 24)</li> <li>Compulsory Registration for GST-TDS</li> <li>ISD in GST and its Compliances from Registration to Return and Distribution of credit.</li> <li>Legal Insight on Sec 25 Procedure of Registration</li> </ul> <ul> <li>GST Registration through GSTN Portal</li> <li>Filing Application for Clarification through Portal on issue raised from Department on Registration</li> <li>Amendment in Registration through GSTN Portal</li> <li>Cancellation of Registration</li> <li>Application for Revocation of Registration</li> </ul> <ul> </ul>   Module 1.3- Levy and Collection with TOS (Section 7 ,8 and 9 with GST SCH-I,II and III) <ul> <li>Analysis of Taxable Event –SUPPLY (Section 7 with Schedules)</li> <li>Concept of Composite and Mixed Supply Section 8</li> <li>FCM levy- Section 9(1)</li> </ul> <ul> <li>RCM Levy- Section 9(3) and Section 9(4)</li> <li>Time and Value of Supply Section (12-15) Chapter IV</li> <li>Valuation Rules</li> <li>Application of Dr. Note and Cr. Note in GST</li> </ul> <ul> </ul>   Module 1.4- Input Tax Credit – Section 16-21 with GST Rules <ul> <li>Eligibility & Conditions for taking ITC (Section-16)</li> <li>Section 17 an applied knowledge on Block Credit vs Reversal of Credit</li> <li>Availability of Credit in Special Cases (Section-18)</li> <li>ITC for Job Work (Section-19)</li> <li>ITC Distribution by ISD (section-20)</li> </ul> <ul> <li>A Correct GSTR-3B needs application of Section 16 and Sec 17…..An Important Discussion on General mistake in filing GSTR-3B due lack of legal knowledge.</li> <li>How ITC (Sec 16 and Sec 17) is related to GSTR 2A & GSTR 2B</li> </ul> <ul> </ul>   Module 1.5 – Electronic Commerce in GST – Section 52 <ul> <li>A complete Legal analysis on Online Business operation Through Inegrated Flowchart to answer the following-</li> <li>Who is E-commerce operator</li> <li>When liable for TCS</li> </ul> <ul> <li>Who is Aggregator and their Compliance obligation</li> <li>What is ODIAR and legalities</li> <li>Special returns for E-commerce Operator</li> <li>Legal and Practical Clarity through live example</li> </ul> <ul> </ul>   Module 1.6 – Job Work & Composition Levy in GST <ul> <li>Job work vs Works Contract ….A legal Integration to be applied in Practice in true spirit of law</li> <li>Composition Levy Section 10</li> </ul> <ul> <li>Quarterly Return for Compounding Taxable Person GSTR-4</li> <li>FAQ</li> </ul> <ul> </ul>   Module 1.7- Returns Under GST Section (37-48) with GST Rules & Formats <ul> <li>An Ideal Demonstrated Approach of Govt. which couldn’t be implemented…..An enlightening Discussion</li> <li>Interdependence and integration of various return inter-se</li> <li>Change in Return Format and Compliance with Time</li> </ul> <ul> <li>QRMP Scheme- (Quarterly Return and Monthly Payment Scheme)</li> <li>Invoice Furnishing Facility on GST Portal</li> <li>GSTR-1,GSTR-3B, GSTR-2A, GSTR-2B</li> <li>GSTR-6, GSTR-7 (Special Return)</li> <li>FAQ</li> </ul> <ul> </ul>   Module 1.8 – Government to Roll out E-way Bill <ul> <li>Why E-Way Bill?</li> <li>Purpose Served with E-way bill</li> <li>Centre and States E-way bill</li> <li>Who is responsible for E-way Bill</li> <li>Consequences of Not Raising E-way bill</li> <li>Introduction to E-way bill Portal</li> </ul> <ul> <li>Registration on E-way Portal</li> <li>Generation of E-Way Bill on Portal(Export and Domestic)</li> <li>Amendment and Cancellation of E-way bill</li> <li>Dashboard on E-way bill Portal</li> </ul> <ul> </ul>   Module 1.9 – IGST LAW   (Total Chapter IX, Total Section 1-25)   <ul> <li>Place of Supply (Goods and Services)</li> <li>Zero Rated Supply (Section 16)</li> </ul> <ul> <li>Integration of Export Benefit</li> </ul> <ul> </ul>   Module 1.10- Refunds – Section 54-58 with GST Rules <ul> <li>Concept of Unjust enrichment where refund is not allowed</li> <li>Situation when refund is allowed in Bank Account</li> <li>Circular No. 125 and 135 on Refund</li> <li>Deficiency Memo an Injustice in GST Law</li> <li>Refund Application through PORTA</li> <li>Understanding Time limit for Refund</li> </ul> <ul> <li>Managing Annexure A and Annexure B a compulsory Document for Refund Application</li> <li>Uploading documents for Refund Application</li> <li>Concept of FIRC and BRC and it procurement needed to claim Refund in case of Export of Services</li> </ul> <ul> </ul>   Module 1.11 – GST Annual Return <ul> <li>What is Annual Return its Objective and Compliance</li> <li>Difference Between GSTR-9, GSTR-9A, GSTR-9B and GSTR-9C</li> <li>Who is required to file GSTR-9</li> <li>Challenges in filing GSTR-9</li> <li>Jow to meet those Challenges</li> </ul> <ul> <li>Understanding of 6 Parts and 19 Tables of GSTR-9</li> <li>Consequences of not filing GSTR-9</li> <li>Preparation of GSTR-9 filing</li> <li>Processing of GSTR-9 at Department and Post filing Scenario.</li> </ul> <ul> </ul>

Module 2 - Part A – Advanced Income Tax Practitioner Certification

<h3>Module 2.1 Integration of Interdependent Legal Terms of Direct Tax</h3> <ul> <li>Person vs Assessee</li> <li>Previous Year Vs Assessment Year</li> <li>Benefits Available to Asseessee</li> <li>(Deductions, Rebate and Exemption)</li> <li>Understanding of Gross Total Income</li> </ul> <ul> <li>(Intro of Income from Heads)</li> <li>Gross Total Income vs Taxable Income</li> <li>Residential Status and its impact on Tax Liability</li> </ul> <ul> </ul>   <h3>Module 2.2 Dependent of Gross Total Income</h3> <ul> <li>Clubbing of Income</li> <li>Set off and Carry forward of Losses</li> </ul> <ul> <li>Deduction under Chapter VI-A</li> </ul> <ul> </ul>   <h3>Moduel2.3 Rates Applicable on Income</h3> <ul> <li>General and Slab Rate of Income Tax</li> <li>Special Rates Applicable on Different Income</li> </ul> <ul> <li>Surcharge vs Cess…A constitutional Analysis</li> </ul> <ul> </ul>   <h3>Module2.4 TDS -Receivable Reporting in Return</h3> <ul> <li>26AS Reconciliation with Form 16 and 16A</li> <li>Feeding 26AS information in ITR</li> </ul> <ul> <li>Claiming TDS in Current year and Carry Forward of TDS</li> </ul> <ul> </ul>   <h3>Module2.5 Introduction of Return Forms (ITR)</h3> <ul> <li>Intro to ITR1 to ITR7</li> <li>Importance of ITR 3</li> </ul> <ul> <li>Who is liable to file Which Return</li> </ul> <ul> </ul>   <h3>Module 2.6 ITR-3 for Individual Having Income From Business and Profession</h3> <ul> <li>Filling Data in PART A (General Information)-ITR3</li> <li>Concept of Return under Sec 139</li> <li>Concept of Representative Assessee</li> <li>Individual Being Director or Partner have to mandatory file ITR-3</li> <li>Detail of holding of Unlisted Share</li> <li>Mandatory Maintenance of Books of Accounts (Sec 44AA)</li> </ul> <ul> <li>Mandatory Audit of Books of Accounts (Sec 44AB)</li> <li>Audit under any Law other than Income Tax Act</li> <li>Reporting in PART A of ITR-3</li> </ul> <ul> </ul>   <h3>Module 2.7 .Concept of Business Profession Through ITR-3</h3> <ul> <li>Understanding difference in Accounting Format</li> </ul> <ul> <li>ITR-3 Format</li> </ul> <ul> </ul>   <h3>Module2.8 Working on PART A-OI of ITR-3 (Row 1 to 4)</h3> <ul> <li>Mercantile Vs Cash Accounting</li> <li>Change in Accounting Mated</li> </ul> <ul> <li>Concept of ICDS and Reporting</li> <li>Stock Valuation Method Reporting</li> </ul> <ul> </ul>   Module2.9 <ul> <li>Income not Credited in PL and Reporting to ITR Row5</li> <li>Concept of Allowance of Expenses and its Reporting in ITR-3</li> <li>Concept of Allowance of Residual Expenses</li> </ul> <ul> <li>Section 28 of The Act Through ITR3</li> <li>Section 36 Through ITR-3 Row 6</li> <li>Section 37 Through ITR-3 Row 7</li> </ul> <ul> </ul>   Module 2.10 <ul> <li>Concept of Disallowed Expenses and Its Reporting Methodology</li> <li>Covered Row No. 8 to 11</li> <li>of PART A- OI of ITR-3</li> </ul> <ul> <li>Section 40A</li> <li>Section 40</li> <li>Section 43B</li> </ul> <ul> </ul>   Module2.11 <ul> <li>Misc. Concept</li> </ul> <ul> <li>Covered Row No. 12 to 14 of PART A- OI of ITR-3</li> </ul> <ul> </ul> <h3>Module 2.12 Going through the Schedule of BP of ITR-3</h3> <ul> <li>Understanding the Regular Business</li> <li>Speculative Business</li> </ul> <ul> <li>Specified Business Reporting</li> </ul> <ul> </ul>   Module 2.13 <ul> <li>Concept of Depreciation in Income Tax through ITR-3</li> <li>Depreciation Schedule in ITR-3</li> </ul> <ul> <li>Section 32</li> <li>Section 35</li> </ul> <ul> </ul>   <h3>Module 2.14.Capitl Gain Through ITR-3</h3> <ul> <li>Long Term and Short Term Assets /li></li> <li>CG on Transfer of Immovable Assets/li></li> <li>Slump Sale</li> <li>Listed Shares</li> </ul> <ul> <li>Unlisted Shares</li> <li>Exemptions under Capital Gain (Sec 54 Series)</li> <li>Deemed Capital Gain</li> </ul> <ul> </ul>   <h3>Module2.15 Salary Through ITR-3</h3> <ul> <li>Salary</li> <li>Allowances</li> </ul> <ul> <li>Perquisites</li> <li>Deduction under Sec 16</li> </ul> <ul> </ul>   Module2.16 <ul> <li>House Property and Other Sources through ITR-3</li> </ul> <ul> </ul> <h3>Module 2.17 Detailed Discussion of ITR-4</h3> <ul> <li>Presumptive Taxation Scheme For:-</li> <li>Business Owners</li> </ul> <ul> <li>Professionals</li> <li>Goods Transport Agency</li> </ul> <ul> </ul>   <h3>Module2.18 – ITR-5</h3> <ul> <li>Partnership Firm</li> </ul> <ul> </ul>   <h3>Module2.19- ITR-6</h3> <ul> <li>MAT Schedule</li> <li>Special Provision to Company</li> </ul> <ul> <li>CDT ( Corporate dividend Tax)detail</li> </ul> <ul> </ul>   <h3>Module2.20 Basic Discussion on ITR-7</h3> <ul> <li>NGO and Others on Which ITR 1-6 is not Applied</li> </ul> <ul> </ul>

Module 2 - Part B - Advanced TDS Practical Course

Module 2.1 Tax Deducted At Sources <ul> <li>Introduction to TDS</li> <li>Related and other linked provision</li> <li>Lower TDS</li> <li>TDS on Salary (Sec 192)</li> <li>TDS on Interest (Sec 194A)</li> <li>Section 195 to be read with Section 9 for Non Resident</li> </ul> <ul> <li>TDS on Commission (Sec 194H)</li> <li>TDS on Professional Services (Sec 194J)</li> <li>TDS on Rent (Sec 194I)</li> <li>TDS on Contract (194C)</li> <li>Other provisions of TDS</li> </ul> <ul> </ul> Module 2.9 Tax Deducted At Sources <ul> <li>TDS Payment</li> <li>TDS Return on Taxman Software</li> <li>TDS return Practice on Cloud computing System</li> <li>TDS return through Return Prepare Utility (PPT)</li> </ul> <ul> <li>Consequences for Non Deposit of TDS</li> <li>Consequences for Non Filing of TDS Return</li> <li>TDS demand and resolution</li> </ul> <ul> </ul> Module 2.10 Tax Deducted At Sources <ul> <li>TRACE online Introduction</li> <li>Downloading the Conso. File from TRACES</li> <li>Filing Correction Statement (Challan Mismatch and PAN Mismatch)</li> <li>Downloading Form 16/16A</li> </ul> <ul> <li>Registering DSC on TRACE</li> <li>Revised Return</li> <li>Application For TAN</li> </ul> <ul> </ul>

Module 3 - Part A - Finalization of Balance sheet/Preparation of Financial Statement & Banking-by CA

<ul> <li>Analysis of Balance Sheet and its components as per Revised Schedule of Companies Act 2013.</li> <li>Logical Process of preparing balance sheet on Excel of a company registered under companies Act.</li> <li>An overview of Indian GAAP(Generally Accepted Accounting Principles) and Ind AS and its applicability on Finalization of accounts.</li> <li>Comparative Analysis of provisions of Depreciation in Income Tax Act and Companies Act.</li> </ul> <ul> <li>Bank Reconciliation Statement and its importance for finalization.</li> <li>Year-end Adjustment entries. (New Topic)</li> <li>Deferred Tax (New Topic)</li> <li>Real World demo of Grouping of Heads of income and expenses through trial balance.</li> <li>Practical demo on linking skill of cells in Excel and preparation Financial Statement on multi excel sheet with its other component.</li> <li>Financial Analysis (how to read the financial accounts of a Company – important ratio analysis) (New Topic)</li> </ul> <ul> </ul>

Module 3 - Part B - Banking & Finance

<ul> <li>Documentation in Finance for CC Limit/OD Limit</li> <li>Project Reports</li> <li>CMA Data</li> <li>Practical Analytical Review of Reports</li> <li>Stock Statement</li> <li>LC(Letter of Credit)</li> </ul> <ul> <li>Letter of Credit- How to Open the LC</li> <li>How to Sanction the LC Limit from Bank</li> <li>Documentation for LC Limit</li> <li>Ratio Analysis</li> <li>Bank Guarantee (Usage and Format)</li> <li>Online Payment of Taxes</li> </ul> <ul> </ul>

Module 4 - Customs / Import & Export Procedures - By Chartered Accountant

Module 4.1 <ul> <li>Introduction to export and import</li> <li>Going through Legal Integration of CBIC,Fema , DGFT and RBI</li> </ul> <ul> <li>Foreign Trade Policy-An Introduction</li> <li> </li> <li> </li> </ul> <ul> </ul> Module 4.2 <ul> <li>Basic Procedure to Export and Import</li> <li>Various Duties Applicable on Import</li> <li>Concept of CHA and Its Working</li> <li>Introduction to- Shipping Bill and Bill of Entry</li> </ul> <ul> <li>Concept of CHA and Its Working</li> </ul> <ul> </ul> Module 4.3 <ul> <li>Settlement of Consideration through Authorized Dealer</li> </ul> <ul> <li>A complete Practical Discussion</li> </ul> <ul> </ul> Module 4.4 <ul> <li>Export Incentive under FTP</li> <li>Duty Draw Back</li> <li>Remission of Duty</li> <li>MEIS</li> </ul> <ul> <li>EPCG</li> <li>Advance Autorisation</li> <li>Scrips</li> </ul> <ul> </ul>

Module 5 - Part A - Advanced Tally Prime & ERP 9

Module 5.1 – Basic of Tally Prime & ERP 9 <ul> <li>What is Tally</li> <li>Overview of Software</li> <li>Introducing Gateway and its elements</li> <li>Creation of Company</li> <li>Basics Of Accounting</li> <li>Fundamentals of Tally ERP 9</li> <li>Create Accounting Masters in Tally ERP 9</li> <li>Accounting Vouchers</li> <li>Financial Statements and Accounting Books & Reports</li> </ul> Module 5.2 – Inventory Management- Tally Prime & ERP 9 <ul> <li>Creating Inventory Masters in Tally ERP 9</li> <li>Inventory Vouchers</li> <li>Generating Inventory Books & Reports</li> <li>Introducing BOM – Bill of Materials</li> <li>Accounting with Inventory</li> </ul> <h3>Module 5.3 -Accounting Management Through Advanced Tally Prime & ERP 9</h3> Module 3A – Bill –Wise Details <ul> <li>Types of Bill can be created through Tally</li> <li>Debit Note/Credit note through Tally</li> <li>Accounting Memos</li> </ul> Module 3B – Accounting Ledgers Details <ul> <li>When to create ledger</li> <li>Information required while creating ledger</li> <li>Grouping and sub grouping of Ledger</li> <li>Importance of tax information in ledger</li> </ul> Module 3C – Cost Centre and Cost Categories <ul> <li>Cost Accumulation</li> <li>Defined cost unit</li> <li>Cost Management</li> <li>Direct Cost Vs Indirect Cost</li> </ul> Module 3D – Voucher Classes <ul> <li>Sale Voucher</li> <li>Purchases Voucher</li> <li>Receipt</li> <li>Payment</li> <li>Journal Voucher</li> <li>Others</li> </ul> Module 3E – Multiple Currencies Module 3F – Interest Calculations Module 3G – Budget & Controls Module 3H – Banking Module 5.4 – Production and Stock Management Tally Prime & ERP 9 <ul> <li>Order Processing</li> <li>Multiple Price Level</li> <li>Batch – wise Details</li> <li>Additional Cost Details</li> <li>Bill of Materials (BoM)</li> <li>Price Levels and Price Lists</li> <li>Stock Valuation</li> <li>Zero Valued Entries</li> <li>Inventory Analysis</li> <li>Different Actual and Billed Quantities</li> <li>Job Costing</li> <li>Job Order Processing</li> </ul> Module 5.5 – TDS Module 5.6 – Payroll Management in Tally ERP 9 <ul> <li>TDS Payable Computation & Reconciliation</li> <li>TDS Receivable Computation & Reconciliation</li> <li>Payment of TDS</li> <li>Reporting on TDS Compliance</li> <li>Generation of Employee Database</li> <li>Salary Structure</li> <li>Calculation Attendance & Leave Details</li> <li>Salary Slip Generation</li> <li>PF, ESI, Gratuity Bonus</li> <li>Professional Tax</li> <li>Various Payroll Reports</li> </ul>

Module 5 - Part B - Tally Prime & ERP 9 With GST Compliance

Module 5.1 – <ul> <li>Upgrading to Tally.ERP 9 Release 6.4</li> <li>Start Using Tally.ERP 9 for GST Compliance</li> <li>Activating GST for Your Company</li> <li>Setting Up GST Rates</li> <li>Updating Stock Items and Stock Groups for GST Compliance</li> <li>Updating a Services Ledger for GST Compliance</li> <li>Updating Sales and Purchase Ledgers for GST Compliance</li> <li>Updating Party GSTIN</li> <li>Creating GST Ledgers</li> <li>Creating Income and Expense Ledgers</li> <li>Recording Sales and Printing Invoices</li> <li>Recording Purchases</li> <li>Recording a Tax Payment</li> <li>Transferring Tax Credits of VAT, excise and services tax to GST</li> <li>Other Scenarios</li> <li>Sales – Nil Rated, Exempt, SEZ, and Deemed Export</li> <li>Recording Sales Returns</li> <li>Recording Purchase Returns</li> <li>Debit Note</li> <li>Credit Note</li> <li>Particulars (Computation Details)</li> </ul> <ul> <li>Summary of Exceptions</li> <li>Table-wise GSTR-1</li> <li>Challan Reconciliation</li> <li>Recording Export Sales</li> <li>Reverse Charge under GST</li> <li>Recording an Advance Receipt from Customer</li> <li>Recording an Advance Payment to Supplier</li> <li>Recording Journal Vouchers for Adjustments Against Tax Credit</li> <li>Recording a Journal Voucher for TDS Adjustment</li> <li>Recording a Journal Voucher for TCS Adjustment</li> <li>Recording a Journal Voucher for Refund of Tax Credit</li> <li>Recording a Journal Voucher for ISD Credit</li> <li>Recording a Journal Voucher for Transitional Credit</li> <li>Recording Journal Vouchers for Other Liabilities</li> <li>Recording Journal Vouchers for Reversal of Tax Credit</li> <li>GSTR-1</li> <li>Returns Summary</li> <li>Status Reconciliation</li> <li>Exporting GSTR-1</li> <li>GSTR – 3B</li> <li>Annual Return</li> </ul> <ul> </ul>

Module 6 – Financial Reporting - Advanced Excel & MIS For Accounts & Finance - By Data Analyst Trainer

Objective Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information. Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split. Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geome And, Or, If, Iferror, Not, Nested If VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot <ul> <li>Introduction to Excel:-</li> <li>Mathematical Functions:-</li> <li>Date & Time Function:-</li> <li>Text Functions & Data Validation:-</li> <li>Statistical Function & Other Functions:-</li> <li>Logical Functions</li> <li>Lookup & Reference Functions:-</li> <li>Power Pivot- MIS, Data Analysis & Visualization:-</li> <li>Data Collection Method:-</li> <li>Analysis Single/Multidimensional Analysis:-</li> <li>Advanced Dashboard in Excel.</li> </ul>

Module 7 – Advanced SAP FICO Certification

<h3>SAP FICO Practical Training By Charted Financial Analyst</h3>   SAP FI – ENTERPRISE STRUCTURE <ul> <li>Definition</li> <li>Overview</li> <li>Corporate scenario & Usage</li>   </ul> FINANCIAL ACCOUNTING GLOBAL SETTINGS <ul> <li>Fiscal Year Variant</li> <li>Posting Period Variant</li> <li>Field Status Variant</li> <li>Posting Keys</li> <li>Tolerance Groups</li> <li>Document Types</li> </ul>   <ul> <li>Define alternate reconciliation for Down payment made</li> <li>Payment Terms</li> <li>Create GL Account for Cash Discount</li> <li>Define Terms of payments</li> <li>Vendor Also become a Customer</li> <li>Automatic Payment Program</li> <li>Define Bank Master Records</li> <li>Define House Bank</li> <li>Define Cheque Lot Automatic Payment Program</li> <li>All Company Codes</li> <li>Paying Company Codes</li> <li>Payment Methods In Country</li> <li>Payment Methods In Company Code</li> <li>Bank Determination</li> </ul>   GENERAL LEDGER ACCOUNTING <ul> <li>Chart of Accounts</li> <li>Account Groups</li> <li>Retained Earnings Account</li> <li>GL Master Records</li> <li>Open item Management</li> <li>Line item Display</li> <li>Sort Key</li> <li>Automatic Posting</li> <li>General Topics in GL</li> <li>Parking Documents</li> <li>Sample Document</li> <li>Recurring Document</li> <li>Foreign Currency Translation</li> <li>Cross Company Code Transactions</li>   </ul> ACCOUNTS PAYABLE <ul> <li>Vendor Account Groups</li> <li>Number Ranges for Vendor Account groups</li> <li>Tolerance groups for Vendors</li> <li>Vendor Master records</li> <li>General Data</li> <li>Company Code Data</li> <li>Purchase Organizational Data</li> <li>Vendor Advance Posting</li> <li>Create GL account for alternate reconciliation</li> </ul>   ACCOUNTS RECEIVABLE <ul> <li>Customer Account Groups</li> <li>Number Ranges for Customer Account Groups</li> <li>Assign Number Ranges to Customers</li> <li>Tolerance Groups for Customers</li> <li>Customer Master Records</li> <li>General Data</li> <li>Company Code Data</li> <li>Sales Organization</li> <li>Customer Advance Posting</li> <li>Create GL Account For an alternate reconciliation</li> <li>Define alternate reconciliation for Customer Down payment</li> <li>Payment Terms</li> <li>Create GL Account For Cash Discount Received</li> <li>Define Payment Terms</li> <li>Assign Payment terms in Customer master Record</li> <li>Define automatic Posting for Cash Discount</li> <li>Customer Also become a Vendor</li> <li>Bill of Exchange</li> <li>Create GL Account for Bill of Exchange</li> <li>Create GL Account For Bills Discounting</li> <li>Create GL Account for Cash Discount</li> <li>Define alternate Reconciliation Account for Bill of Exchange</li> <li>Define Bank Sub Account</li> <li>Dunning</li> <li>Define Dunning Area</li> <li>Define Dunning Procedure</li> <li>Assign Dunning Procedure in Customer Master Record.</li> </ul>   ASSET ACCOUNTING <ul> <li>Chart of Depreciation</li> <li>Copy Reference Chart of Depreciation.</li> <li>Create 0% Purchase & Sales Tax Codes for non Taxable transactions.</li> <li>Assign 0% Tax codes to non taxable Transactions.</li> <li>Assign Company Code to Chart of Account.</li> <li>Depreciation Area</li> <li>Define Depreciation Area.</li> <li>Determine Depreciation Area in Asset Class</li> <li>Asset Class</li> <li>Define Account Determination</li> <li>Define Screen Layout</li> <li>Create number ranges for the asset class</li> <li>Create Asset Class</li> <li>Integration with the GL Account</li> <li>Creation of GL Accounts</li> <li>Assign GL Accounts</li> <li>Valuation Methods</li> <li>Define Base Method</li> <li>Define Multilevel method</li> <li>Define Period Control method</li> <li>Depreciation Key</li> <li>Asset Master Record</li> <li>Creation of Screen layout for Asset master records</li> <li>Create Screen layout for Depreciation ( Layout ) area</li> <li>Define Document Types for Depreciation Posting</li> <li>Asset End user Transactions</li> <li>Creation of Asset Master Record</li> <li>Asset Acquisition/Purchase Posting</li> <li>Asset Explorer</li> <li>Asset Depreciation Run</li> <li>The retirement of Asset with Sale/Scrap</li> </ul>   <ul> <li>Controlling Area /Organizational Structure</li> <li>Define Controlling area</li> <li>Maintain Number Ranges</li> <li>Maintain Plan Versions</li> <li>Cost Element Accounting</li> <li>Primary Cost Elements</li> <li>Revenue Cost Elements</li> <li>Secondary Cost Elements</li> <li>Cost Center Accounting</li> <li>Activate Cost Center Accounting</li> <li>Define New Field Status for Cost Center mandatory</li> <li>Master Data</li> <li>Creation of Cost Centers</li> <li>Create Cost Center Groups/Cost Center Hierarchy</li> <li>Cost Center Planning</li> <li>Cost Center Reposting</li> <li>Cost Center Assessment</li> <li>Cost Center Distribution</li> <li>Internal orders</li> <li>Activate Internal order</li> <li>Define Internal Order Types</li> <li>Create New Field Status Variant for Making I/O Mandatory</li> <li>Master Data</li> <li>Create Internal orders</li> <li>Create Internal order Groups</li> <li>Internal order Planning</li> <li>Internal order Settlement</li> <li>Profit Center Accounting</li> <li>Set-Controlling area</li> <li>Define Dummy Profit Center</li> <li>Set-Controlling area parameters</li> <li>Maintain Plan Versions</li> <li>Master Records</li> <li>Create Profit Centers</li> <li>Create Profit Center Group</li> <li>Assign Profit Center to Cost Centers</li> </ul>   FI – GENERAL TOPICS <ul> <li>Foreign Exchange</li> <li>Cash Journal</li> <li>Interest Calculation</li> <li>Taxes</li> <li>Tax On Sales/Purchases</li> <li>Extended Withholding Taxes</li> </ul>   SAP INTEGRATION BETWEEN FI-SD & FI – MM <ul> <li>Integration Between FI –SD</li> <li>Integration Between FI – MM</li> </ul> CO – CONTROLLING <ul> <li>Year End Reports</li> <li>Financial Statement Versions</li> </ul> SAP FICO – REPORTS <ul> <li>Month End reports</li> </ul> <ul> </ul>