COURSE OVERVIEW
A comprehensive training course covering office tools and advanced accounting for success in office and accounting roles
G-FAT (Global Certificate Course in Financial Accounting and Taxation)
- Office Tools
- MS-Word 2019
- MS-Excel 2019
- MS-PowerPoint 2019
- MS-Outlook 2019
- Advance Excel
- Excel Essentials
- Working with Multiple Worksheet
- Cell Referencing
- Conditional Function
- Data Cleaning
- Charts/ Dashboard
- MIS Reporting
- Lookup Function
- Advanced Lookup
- Statistical Function
- What-If Analysis
- Pivot Table
- Pivot Chart
- Power Pivot
- Power View
- Power Map
- Power Query
- Working with Data Lists
- Conditional Formatting
- Data Validation
- Formula Auditing
- Protection
- Manual
Accounting
- Basic of Accounting
- Accounting Concepts
- Journal Entries
- Concept of Accounting Standards
- Bank Reconciliation Statement (BRS)
- Capital & Revenue Expenditure
- Depreciation
- Provisions & Reserves
- Valuation of Inventory
- Account Documents
- Final Accounts
- Project on Books of Account
- Advance
Accounting
- Adv. Journal Entries
- Cash flow Statement
- Debtors & Creditors Reconciliation Statement
- Accounting for Digital Transactions
- Final Accounts
- Profit Screening
- Business
Accounting
- Basic of Accounting
- Accounting Terminology
- Journal Entries
- Concept of Accounting Standards
- Bank Reconciliation Statement (BRS)
- Capital & Revenue Expenditure
- Depreciation
- Provisions & Reserves
- Cash flow Statement
- Ratio Analysis
- Debtors & Creditors Reconciliation Statement
- Final Accounts
- Profit Screening
- Direct
Tax
Income Tax- Income Tax Overview
- Computation for Salary
- Computation for House Property
- Computation for Business & Professions
- Computation for Capital Gains
- Computation for Other sources
- Other Exemptions and Deductions
- Presumptive Income Calculation
- Computation of Income & Tax payable
- Advance Tax Liability
- Interest Calculation
- Clubbing of Income
- Set off and carry forward losses
- Deduction from Gross Total Income
- Online registration for PAN
- ITR Filing 1
- ITR Filing 2
- ITR Filing 3
- ITR Filing 4
TDS- TDS Fundamentals
- Important Forms, Due Dates, Penalties
- TAN & PAN No.
- TDS Computation of Employees
- Complete TDS Non Salary Sec.194
- TDS & TCS Book in the System
- TDS & TCS Online Payment in Challan 281
- TDS Online Return Filing
- Form 15G, 15H, Form 26AS
- Indirect Tax -
GST
- GST Concept & Overview
- Time & Place of supply
- Value of Supply
- Reverse charge mechanism
- Normal Vs Composition Scheme
- Input Tax Credit
- Tax Invoice, Credit & Debit Notes
- Registration
- Return filling
- E-Way Bill
- Offline Utility
- GST Practical’s-GSTR1, GSTR 3B, GSTR 4
- Tally
Prime
Fundamentals of Accounting- Introduction
- Terminology used in Accounting
- Concept of Accounting
- Golden Rules of Accounting
- Journalising Transactions
- Trial Balance
- Financial Statements
- Subsidiary Books & Control Accounts
TALLY PRIME Basics- Download Tally Prime Setup File
- Tally Prime Installation, Company Creation, Alteration, Deletion
- Tally Prime Ledgers Creation
- Tally Prime Inventory Creation, Stock Items, Groups, Units
TALLY PRIME with ADVANCE ACCOUNTING- Bill Wise details
- Cost Centre & Cost Categories
- Voucher Class & Cost Centre Class
- Multiple Currency
- Interest Calculation
a. Simple b. compound - Budgets & Controls
- Scenario Management
TALLY PRIME with ADVANCE INVENTORY- Order Processing Reorder Levels
- Tracking Number Batch- wise Details
- Rejection in/Out
- Delivery & Receipt Note
- Additional Cost Details Bill of Materials (BOM)
- Price Levels and Price Lists Stock Valuation
- Stock Journal & Physical Journal
- Different Actual and Billed Quantities
- Zero Valued Entries
- Stock Valuation
- Point of Sale
- Single Payment Mode
- Multiple Payment Mode
- Invoice Printing
Tally Prime with Banking- Cheque Book Configuration in Tally Prime
- Banking Transaction Types
- Post Dated Cheque Management
- Post Dated Cheque Note Video
- BRS Note
- Bank Reconciliation
Tally Prime with GST- Activation of GST in Tally Prime
- Accounting of GST Transactions
- Purchase from URD
- Imports
- Advance Receipt and Payments
- Mixed Supply & Composite Supply under GST
- MRP Transaction
- Defining GST Rate - Slab Rate or Price Range
- Accounting of Supply of Services
- Input Credit
- GST Tax payment
- GST Reports & GSTR-1 & 2
- GSTR 3B
- Filling of GSTR-1 (Excel Format)
Tally Prime with TAX DEDUCTED AT SOURCE (TDS)- TDS Process
- Enabling TDS in Tally Prime
- Creating TDS Masters
- TDS Deduction
- Payment of TDS in Tally Prime
- Form 26Q
- TDS Outstanding
- TDS Reports
Tally Prime with TAX COLLECTED AT SOURCE- Basic Concept of TCS
- Enabling TCS in Tally Prime
- Sales of TCS Goods at Lower Rate & Nil Rated
- TCS on Transfer of Right to Use
- Payment of TCS
- TCS Reports
- Form 27EQ
- Saving Form 27EQ
Tally Prime with JOB COSTING- Introduction
- Features of Job Costing
- Enabling Job Costing
- Creating Required Masters
- Creating Ledgers for Job Costing
- Recording of Job Costing Related Transactions
- Job Costing Reports
- Job Work Analysis Report
- Materials Consumption Summary Report
- Comparative Job Work Analysis Report
Tally Prime with JOB WORKS- Introduction
- Features of Job Order Processing in Tally Prime
- Configuring Job Order Processing in Tally Prime
- Company Setup
- Enabling Job Order Processing
- Voucher Type Setup
- Job Order Processing
- Job Work Out Order
- Job Work in Order
- Job Order Reports
- Job Work Out Reports
Tally Prime with MIS Reports- Introduction
- Advantages of Management Information Systems
- MIS Reports in Tally Prime
- Trial Balance
- Balance Sheet
- Profit and Loss Account
- Cash Flow Statement
- Ratio Analysis
- Books and Reports
- Day Book
- Receipts and Payments
- Purchase Register
- Sales Register
- Bills Receivable and Bills Payable
Tally Prime with Payroll- Introduction to Payroll
- Payroll In Tally Prime
- Enable Payroll in Tally Prime
- Payroll Transaction
- Generate Pay Slips
- BFSI (Banking,
Financial Services, Insurance &
Investment)
Banking- Banking Instruments
- E-Banking
- Introduction to Audit
- Audit Report
- Audit Project
- Introduction of Bank
- Features of Bank
- Importance of Bank
- Types of Deposits
- Business Loans & Advances
- Innovative Services (Cards)
Financial Services- Fundamental Analysis
- Technical Analysis
- Mutual Funds
- Insurance
- Financial Planning
Insurance- Introduction to Insurance
- Term Used in Insurance
- Functions of Insurance
- Basic Principal of Insurance
- Kinds of Insurance
- Importance of Life Insurance
- Types of Insurance Policies
- Tax benefit in Insurance
Procedure for taking Insurance Policy
Investment- Introduction of Investment
- Types of Investments
- Discuss Investment alternatives
- Share Market & Investments
- Mutual Funds
- Quick Books (10
Hrs.)
- Features & Benefits of Quick Books
- Assignment using Quick books
- Invoicing, Bookkeeping Quick Books
- Billing in Quick Books
- Creating & Managing Invoices
- Reports
- MCA & IND
AS
- Introduction to MCA
- Understanding Concept of MCA
- Basic Concept of AS
- Roadmap for Implementing (IND AS)
- Costing & Auditing
- Introduction to Costing
- Cost sheet
- Introduction to Audit
- Audit Project
- SAP FICO
- SAP ERP Overview & Navigation
- General Ledger Accounting
- Accounts Payable Business Process
- Accounts Receivable Business Process
- Bank Related Accounting Business Process
- Financial Statement Creation Business Process
- Closing Activities
- Asset Accounting
- Controlling
- Soft Skills and
Personality Development
- Communication Skills
- Business Etiquette
- Resume Writing
- Interview Skills
- Sage 50 Accounting
- Introduction
- Installation process
- Company creation
- Chart of account
- Customer & vendor master
- Inventory master
- General journal entry
- Purchase management
- Sales management
- Payroll management
- Job costing
- Assembly
- Banking
- Conclusion
-
- Proficiency in using office tools like MS Word, Excel, PowerPoint, and Outlook.
- Advanced skills in Excel, including data analysis, conditional formatting, and pivot tables.
- Understanding of manual accounting principles, journal entries, and preparation of final accounts.
- Knowledge of advanced accounting topics such as cash flow statements and profit screening.
- Comprehensive understanding of direct tax regulations and income tax computation.
- Familiarity with indirect tax - GST, including return filing and compliance.
- Expertise in using advanced features of Tally Prime for accounting and inventory management.
- Proficiency in SAGE 50 for company management, inventory control, and report generation.
- Practical skills in QuickBooks for financial management and report generation.
- Understanding of banking fundamentals, e-banking, and auditing principles.
- Knowledge of investment analysis, mutual funds, insurance, and financial planning.
- Familiarity with MCA/IND AS and the implementation of accounting standards.
- Proficiency in SAP FICO for financial and management accounting tasks.
Certificates
