Download the Brochure by filling the form below
Key Highlights
Comprehensive curriculum
Comprehensive curriculum covering advanced office automation and financial
accounting.
Extensive training
Extensive training in MS Office tools, including Word, Excel, PowerPoint, and
Outlook.
In-depth instruction
In-depth instruction on advanced Excel functions, data analysis, and reporting
techniques.
Practical training
Practical training in Tally Prime software, covering accounting, inventory,
banking, GST, payroll, and more.
Learner-centric approach
Learner-centric approach with hands-on exercises, case studies, and real-world
scenarios.
Industry-experienced instructors
Industry-experienced instructors providing personalized guidance and support
throughout the course.
Things To Know
- Aspiring accountants, finance professionals, office administrators, and individuals looking to enhance their office automation and financial accounting skills.
The course duration is 150 Hrs. and 6 Months Program
- Advance Computing Skills
- Office Skills
- Web & Social Skills
- Analytical Skills
- Data Presentation Skills
- Administrative Skills
- Advance Accounting Skills
- Data Management Skills
- Report Generation & Management
If you are ready to learn and want to light up your future with
us. Enroll now in this course.
About the Course
Comprehensive course covering MS Office tools, advanced Excel, and Tally Prime. Gain essential skills for accounting industry.
Learn advanced Excel techniques for data analysis, reporting, and decision-making. Enhance your efficiency in office tasks.
Extensive training in Tally Prime software for accounting, inventory management, banking transactions, and GST compliance.
Develop proficiency in financial accounting principles, journalizing transactions, trial balance, and financial statements.
Practical approach with hands-on exercises and real-world scenarios. Experienced instructors provide personalized guidance.
Gain expertise in TDS, payroll accounting, audit trail, and other crucial aspects of financial management. Prepare for a successful career.
Content
Introducing AOAFA (Professional Certification in Advanced Office Automation & Financial Account), a comprehensive 6-month course designed to equip commerce students with the necessary skills to meet the demands of the accounting industry. This course covers advanced office automation using MS Office tools, along with in-depth training in financial accounting principles and Tally Prime software. With a focus on practical applications and real-world scenarios, AOAFA prepares learners to handle accounting tasks for manufacturing, trading, and service-oriented companies.
Content : This course is designed to provide a comprehensive understanding of computer fundamentals, advanced office tools, financial accounting, and Tally Prime with GST and payroll. It covers practical applications of MS Office, advanced Excel with data analysis, and AI integration using ChatGPT to enhance productivity. Learners will gain hands-on experience in both manual and computerized accounting, including real-world business scenarios. The program ensures industry-ready skills through a balanced approach of theory and practical training.
- COMPUTER COMPETENCY
- SYSTEM SOFTWARE
- WINDOWS OS
- APPLICATION SOFTWARE
- MS-Word 2019
AI Tools: Editor (grammar suggestions), Smart Lookup, Dictation, and Translator - MS-Excel 2019
AI Tools: Ideas for insights, Flash Fill, Smart Data Types, Power BI overview
- MS-PowerPoint 2019
AI Tools: Designer, QuickStarter, Morph, Zoom, Presenter Coach, Live Captions - MS-Outlook 2019
AI Tools: Focused Inbox, Suggested Replies, MyAnalytics (overview)
- Excel Essentials
- Working with Multiple Worksheet
- Cell Referencing
- Conditional Function
- Data Cleaning
- Charts/ Dashboard
- MIS Reporting
- Lookup Function
- Advanced Lookup
- Statistical Function
- Pivot Table
- Pivot Chart
- Power Pivot
- Power View
- Power Map
- Power Query
- Working with Data Lists
- Conditional Formatting
- Data Validation
- What-If Analysis
- Formula Auditing
- Protection
- Introduction ChatGPT with Excel
- Enhancing Excel Formulas with ChatGPT
- Advanced Formula Assistance with ChatGPT
- Data Cleaning and Transformation
- Basic Data Analysis Techniques
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
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)
Recording and Maintaining Accounting Transactions
- Recording Transaction in Tally
- Recording Accounting Vouchers in Tally Prime
- Receipt Voucher
- Contra Voucher
- Payment Voucher
- Sales Voucher
- Debit Note Voucher
- Credit Note Voucher
- Journal Voucher
- Recording for Provisions
Tally Prime with Advanced 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 Advanced 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 & 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
Generating Financial Statements & MIS Reports
- 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
Data Security
- Security Control
- Activation of Security Control
- Creation of Security Control (User Roles)
- Creation of Uses & Passwords for Company
- Tally Vault
Company Data Management
- Backup of Company Data
- Restoring of Company Data
- Company Data Repair
- Migration of Tally EPR 9.0 Company Data to Tally Prime
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
- E-Way Bill
- Components of E-Way Bill
- Who must generate E-Way Bill
- Validity of E-Way Bill
- E-Way Bill Process Flow
- Export for e-Way Bill Report
- Update e-Way Bill Information
- Input Tax Credit Set Off against Liability
- GST Tax Payment
- Generating GST Returns for Regular Dealer in Tally
- GST Reports & GSTR-1
- GSTR 3B
- GSTR 9 -GST Annual Computation
- Filing GST Returns in Tally
- Filing GSTR-1 Returns
- Generating the JSON file from Tally and uploading the same in the GST portal
- Filing GSTR-9 Returns - GST Annual Computation
- Generating e-Invoice in Tally Prime
- Recording Outward Supply and Generating e-Invoice without e-Way Bill
- Recording Outward Supply and Generating e-Invoice with e-Way Bill
Tally Prime with TAX DEDUCTED AT SOURCE (TDS)
- Introduction to TDS
- Basic Concepts of TDS
- TDS Process
- Enabling TDS in Tally Prime
- TDS Statutory Masters
- Configuration of TDS at Different levels
- Recording TDS Compliant Transactions in Tally Prime
- TDS Exceptions
- TDS Deduction
- Payment of TDS in Tally Prime
- TDS Reports
Payroll Accounting & Compliance
- Configuring Payroll in Tally Prime
- Enable Payroll in Tally Prime
- Payroll Masters
- Payroll Transaction
- Statutory Reports
- Generate Pay Slips & Pay Sheet
- Payroll Statement
Tally Prime with Audit Trail
- Introduction
- Importance of Audit Trail in Accounting
- Enable Audit Trail in Tally Prime
- Purpose of Audit Trail in Tally Prime
Generating & Printing Reports
- Drill Down Display
- Date/Period Based Reporting & Comparing
- Inventory Report
- Stock Summary
- Go down Wise Stock Availability
- Movement Analysis
- Stock Query
- Printing of Invoice & Reports
Management of Business Data
- Exporting of data in available formats
- Export and Import of Data
- Export and Import of Masters from one company to another in XML format
- Export and Import of Transactions from one company to another in XML format
- Exporting Reports to MS Excel
- Exporting Reports to PDF
- Open Database Connectivity (ODBC)
- Printing of Company Logo on Vouchers, Invoices & Reports
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
- 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
- Introduction of Bank
- Features of Bank
- Importance of Bank
- Types of Deposits
- Business Loans & Advances
- Innovative Services (Cards)
- Banking Instruments
- E-Banking
- Introduction to Audit
- Audit Report
- Audit Project
- Fundamental Analysis
- Technical Analysis
- Mutual Funds
- Insurance
- Financial Planning
- Communication Skills
- Business Etiquette
- Resume Writing
- Interview Skills
Certificate
-
- Jain: This certificate course is designed to equip learners with the expertise required to efficiently manage office tasks and financial transactions, ensuring smooth operations in the modern business environment.
-
- GJX:The main objective of this certificate course is to provide learners with the necessary expertise to effectively handle office tasks and financial transactions, ensuring seamless operations in today's dynamic business landscape.
Our Affiliations & Associations
We believe people are at the centre of every solution, leading us to the right solution just waiting to be delivered.
Our Students are Working in Following Companies
What Our Students Say
I highly recommend the Web Designing Course at G-TEC JAINx Education for anyone interested in pursuing a career in web design."
The Data Analysis Course at G-TEC JAINx exceeded my expectations. Through practical assignments and real-world case studies, I gained hands-on experience in data analysis techniques and tools.
Taking the Digital Marketing Course at G-TEC JAINx was a game-changer for my career. I am now equipped with the skills to plan and execute successful online marketing campaigns