COMPLET ADVANCE PROFESSIONAL ACCOUNTING COURSE IN CHANDIGARH : TALLY ,GST , EXCEL , TDS ,INCOME TAX
TALLY + GST + EXCEL + TDS + INCOME TAX
SECTION 1: TALLYPRIME +
ACCOUNTING COURSE
Chapter 1: Fundamentals of Accounting
- Introduction
- Meaning
of Accounting
- Terminologies
used in Accounting
- Concepts of
Accounting
- Double Entry
System of Accounting
- Uses
of Debit and Credit
- Rules
of Debit and Credit
- Golden Rules of
Accounting
- Recording of
Business Transactions
- Journalising
Transactions
- Trial Balance
- Financial Statements
- Trading
Account
- Profit
& Loss Account
- Balance
Sheet
- Subsidiary Books
& Control Accounts
- Cash
Book
- Petty
Cash Book
- Purchase
Book
- Purchase
Return Book
- Sales
Book
- Sales
Return Book
- Journal
Proper
- Control
Accounts
- Depreciation
- Methods
- Depreciation
Schedule
- Computerised
Accounting
- Advantages
- Accounting
Structure
Chapter 2: Introduction to TallyPrime
- Features
- Installation
- Types of Licenses
- Activate /
Reactivate License
- Educational Mode
- Company Creation
- Navigation
- F12 Configuration
- Alter / Shut Company
Chapter 3: Chart of Accounts
- Introduction
- Creation of
Masters
- Contra
Voucher (F4)
- Payment
(F5)
- Purchase
(F9)
- Sales
(F8)
- Debit
Note (Alt+F5)
- Credit
Note (Alt+F6)
- Inventory Masters
- Alteration,
Deletion
- Multi-Masters
Creation
- Groups
- Ledgers
- Stock
Groups
- Stock
Items
Chapter 4: Accounting Transactions
- Recording
Transactions
- Accounting
Vouchers
- Receipt
Voucher (F6)
- Journal
Voucher (F7)
Chapter 5: Banking
- Cheque Printing
(Single / Multi)
- Cash & Bank
Book
- Purchase / Sales
Register
- Deposit Slip (Cheque
/ Cash)
- Payment Advice
- Manual & Auto
Bank
Chapter 6: Financial Statements & MIS
- Trial Balance
- Profit & Loss
- Balance Sheet
- Cash Flow, Fund
Flow
- Stock Summary
- Day Book
- Journal Register
Chapter 7: Data Security
- Security Control
- Creating Users
& Roles
- Migration &
Repair
- Login using
various levels
Chapter 8: Company Data Management
- Backup
- Restore
Chapter 9: GST in TallyPrime
- Why GST
- GST Structure
- Registration
- HSN/SAC
- GST Rate
Structure
- Supply of Goods /
Services
- Input Tax Credit
- E-Way Bill
- Activating GST in
Tally
- Masters Creation
- Recording GST
Transactions
- Intrastate
& Interstate
- GST Payment
- Challan
- Reconciliation
- GST Returns
- GSTR-1
- GSTR-3B
- GSTR-9
Chapter 10: Inventory Management
- Bill-wise Entry
- Supply Chain
Basics
- Activation of
Batches
- Batch Reports
- Price Levels /
Price Lists
Chapter 11: AR & AP Management
- Bill-wise Entry
- Credit Limits
- Purchase Order
Processing
- Receipt Note
- Sales Order
- Outstanding
Reports
- Ageing
- Reminder Letters
- Confirmation of
Accounts
Chapter 12: Purchase & Sales Order
Management
- Debit Note
- Payment Voucher
- Sales Order
- Delivery Note
- Receipt Voucher
- Order Outstanding
Chapter 13: Additional Cost of Purchase
- Configuration
- Voucher Mode
& Item Invoice Mode
- Debit Note with
Additional Cost
Chapter 14: Cost Centres
- Activation
- Allocation
- Cost Centre
Classes
- Reports
Chapter 15: Budgets & Scenarios
- Creating Budget
- Recording
Transactions
- Budget Variance
- Scenario
Management
Chapter 16: Reports & Printing
- On the Fly
Reporting
- Drill Down
- Date/Period Based
- Stock Summary
- Movement Analysis
- Balance Sheet
- P&L
- Books &
Registers
- Printing Invoice
& Reports
SECTION 2: PRACTICAL GST
TRAINING
Module 1: Introduction to GST
- Introduction to
GST
- Concept,
History, Objectives, and Structure
Module 2: GST Tax Rates & Classifications
- Exercise:
Understanding GST Tax Rates (5%, 12%, 18%, 28%)
Module 3: GST Registration
- Registration
Under GST
- Exercise:
Registering a Business on GST Portal
- Assignment:
Prepare a Registration File for a Sample Business
Module 4: Invoicing and Documentation
- Tax Invoice
Format & Rules
- Other Documents
in GST (Bill of Supply, Debit/Credit Notes)
- Exercise: Create
Different GST Documents
Module 5: E-Way Bill
- E-Way Bill:
Concept, Applicability, and Process
- Exercise:
Generate an E-Way Bill on the GST Portal
- Assignment:
Prepare an E-Way Bill Scenario
Module 6: Supply Transactions and Tax
Calculations
- Outward &
Inward Supplies
- Input Tax Credit
(ITC) vs Output Tax
- GSTR-1 Overview
- Exercise: File a
GSTR-1 Return
- Assignment:
Prepare a Mock GSTR-1 Return
Module 7: Input Tax Credit &
Reconciliation
- Understanding
GSTR-2B
- Eligible &
Ineligible ITC Rules
- Exercise: Search
a Taxpayer on GST Portal
Module 8: GST Transactions
- Types of GST
Transactions
- B2B, B2C,
Imports, Exports, Reverse Charge
Module 9: Filing GSTR-3B
- Overview of
GSTR-3B
- Exercise: File
GSTR-3B
- Assignment:
GSTR-3B Filing for a Case Study
Module 10: GST Payment and Ledgers
E-Ledgers (Cash, Credit, Liability)
- Exercise:
Generate a Payment Challan
- Assignment:
Complete a Payment Cycle on Mock Portal
Module 11: Advanced Topics
- GST Suvidha
Providers (GSPs) & Tally/ERP Integration
- Journal Entries
under GST
SECTION 3: EXCEL + ADVANCED
EXCEL + POWER BI
Introduction to Excel
- Navigating the
Excel Interface
- Understanding
Workbooks, Worksheets, and Cells
- Basic Excel
Terminology
Basic Data Entry and Formatting
- Entering and
Editing Data
- Formatting Cells
(Font, Color, Borders)
- Number Formatting
and Conditional Formatting
Basic Formulas and Functions
- Introduction to
Formulas (SUM, AVERAGE, MIN, MAX)
- Basic Functions
(COUNT, COUNTA, IF)
- Understanding
Relative vs. Absolute References
Practical Exercises and Case Studies
- Applying Basic
Formulas and Formatting
Advanced Formulas
- Nested IF
Statements
- Logical Functions
(AND, OR, NOT)
- Text Functions
(LEFT, RIGHT, MID, CONCATENATE)
Lookup and Reference Functions
- VLOOKUP and
HLOOKUP
- INDEX and MATCH
- Using INDIRECT
and OFFSET
Data Management Techniques
- Data Validation
(Drop-down Lists, Input Messages)
- Data Cleaning
Techniques (Removing Duplicates, Text-to-Columns)
- Using Named
Ranges for Better Data Management
Practical Exercises and Case Studies
- Applying Advanced
Formulas and Data Management Techniques
Introduction to PivotTables
- Creating and
Customizing PivotTables
- Using Filters and
Slicers
- Grouping Data in
PivotTables
PivotCharts and Advanced PivotTable Features
- Creating
PivotCharts for Dynamic Data Visualization
- Calculated Fields
and Items
- Advanced Sorting
and Filtering in PivotTables
Data Analysis Tools
- Using What-If
Analysis (Data Tables, Scenario Manager)
- Utilizing Goal
Seek for Target Setting
- Introduction to
Solver for Optimization Problems
Practical Exercises and Case Studies
- Building
PivotTables and Charts for Reporting and Analysis
Creating and Customizing Reports
- Designing
Effective Report Layouts
- Using Templates
for Consistent Reporting
- Customizing Print
Settings and Page Layouts
Advanced Data Visualization
- Creating and
Customizing Charts (Column, Line, Pie, Bar)
- Using Sparklines
and Data Bars for Insights
- Best Practices
for Data Visualization
Dashboards and Interactive Reports
- Building
Interactive Dashboards with Slicers and Timelines
- Designing
Dashboards for Decision-Making
- Using Conditional
Formatting for Visual Impact
Practical Exercises and Case Studies
- Developing and
Customizing Reports and Dashboards
Data Import and Integration
- Importing Data
(CSV, Text Files)
- Connecting to
Databases using Excel Queries
- Combining Data
from Multiple Worksheets and Workbooks
Data Validation and Error Checking
- Implementing Data
Validation Rules
- Error Checking
Tools
- Auditing Formulas
and Tracking Changes
Practical Exercises and Case Studies
- Integrating Data
- Automating Tasks
- Ensuring Data
Accuracy
Project and Review
- End-to-End Excel
Reporting Project
- Dashboard
Creation
- Data Cleaning +
Analysis + Visualization
- Final Evaluation
& Review
SECTION 4: TDS COURSE
Topics Included
- TDS Overview
- Challan Payment
(26Q) without login
- Downloading
Challan PDF
- TAN Registration
- TAN Login Steps
- Utility Data
Entry
- Validation with
Challan
- FVU File Creation
- Converting to ZIP
- Uploading FVU to
Income Tax Portal
- Downloading
Receipt
- TRACES
Registration
- TRACES Login
- Requesting &
Downloading Form 16 / 16A
SECTION 5: INCOME TAX
COURSE
Topics Included
- PAN Registration
- Generating Login
Password
- Income Entry
- Deduction Entry
- Automatic Tax
Computation
- TDS/TCS/Advance
Tax Adjustment
- Net Tax Liability
Computation
- Challan
Generation
- ITR-1 Filing
- Uploading Return
- Downloading ITR-V
Acknowledgment
9988113578
#GSTTrainingMohali; #GBTrainingInstitute; #MohaliEducation; #TaxationSkills; #CareerDevelopmentMohali; #LearnGSTMohali; #FinanceCourses; #ProfessionalSkillsMohali; #ChandigarhTricity; #GBTrainingMohali; #CommerceEducation; #MohaliOpportunities; #GSTCertification; #FutureInFinance; #SkillBuildingMohali; #GBTrainingHub; #CareerGrowthMohali; #TricityLearning; #GBTrainingCenter; #MohaliProfessionals
Experienced Instructors:
Learn from industry experts with extensive knowledge in GST and taxation.
Practical Insights:
Gain hands-on experience through real-world case studies and practical exercises.
Contact US - 9988113578
Welcome to GB Training, where we pave the way for your expertise in Goods and Services Tax (GST) right in the heart of the Tricity! At GB Training, we understand the pivotal role that GST plays in the contemporary business landscape, and we are committed to empowering individuals with the knowledge and skills necessary to navigate this complex taxation domain.
About GB Training
Contact US - 9988113578
GB Training is not just an institute; it's your gateway to unlocking the intricacies of GST with precision and proficiency. Our comprehensive training programs are designed to cater to the dynamic needs of students and professionals alike, offering a blend of theoretical insights and practical applications. Whether you're a commerce student looking to enhance your skills or a professional aiming to stay ahead in your career, GB Training provides a supportive learning environment to fuel your success.
Why Choose GB Training?
Experienced Instructors:
Learn from industry experts with extensive knowledge in GST and taxation.
Practical Insights:
Gain hands-on experience through real-world case studies and practical exercises.
Industry-Relevant Curriculum:
Our courses are crafted to align with the latest developments in GST regulations and compliance.
Personalized Learning:
Small class sizes ensure individual attention and personalized guidance.
Career Support:
Access resources and assistance to boost your career in finance, accounting, and taxation.
Embark on your journey to GST mastery with confidence! GB Training invites you to experience the quality of our training through a **free demo class**. This is your opportunity to interact with our instructors, explore our teaching methodologies, and get a taste of the valuable knowledge we impart.
Schedule your free demo class today and take the first step towards mastering GST with GB Training!
Ready to empower your career and excel in finance? Join us at GB Training, where expertise meets excellence!
Course Content
Chapter 1: Introduction to GST
Chapter 2: Registration under GST
Chapter 3: Exercise:-Registration of a Business
using GST Portal
Chapter 4: Assignment:-GST Registration
Chapter 5: Tax Invoice
Chapter 6: Other Documents in GST
Chapter 7: Assignment-Documents in GST
Chapter 8: E-way Bill
Chapter 9: Exercise:-Generating i-way Bill using
GST Portal
Chapter 10: Assignment-E-way Bill
Chapter 11: Outward Supplies
Chapter 12: Different Transactions in GST Law
Chapter 13: Output Tax and Input Tax
Chapter 14: Understanding GSTR-1 Return
Chapter 15: Exercise: Filing GSTR-1 Return in
GST Portal
Chapter 16: Assignment: GSTR-1 Return
Chapter 17. GSTR-28 Statement
Chapter 18: Understanding GSTR-3B Return
Chapter 19: Exercise-Filing GSTR-3B Return in
GST Portal
Chapter 20: Assignment, GSTR-38 Return
Chapter 21: E-Ledgers
Chapter 22: Journal Entries in GST
Chapter 23: Exercise: Generating Payment
Challan using GST Portal
Chapter 24: Assignment: GST Challan
Generation
Key Answers
GSTR-1 Return Exercise
GSTR-1 Return Assignment
GSTR-3B Return- Exercise
GSTR-3B Return-Assignment
In summary, while GST training may not be mandatory in all cases, it is highly beneficial for commerce students. It equips them with practical skills, enhances their employability, and ensures they are well-prepared for the demands of the modern business and financial landscape.A GST course is an invaluable asset for anyone pursuing a career in commerce, finance, or accounting. It enhances employability, provides specialization in taxation, opens up career advancement opportunities, ensures compliance management, keeps you updated with GST changes, and prepares you for professional exams. Whether you are a B.com student seeking a competitive edge or an experienced professional looking to expand your skillset, a GST course is a worthwhile investment in your career growth and success.
Free Demo Class for Prospects
Embark on your journey to GST mastery with confidence! GB Training invites you to experience the quality of our training through a **free demo class**. This is your opportunity to interact with our instructors, explore our teaching methodologies, and get a taste of the valuable knowledge we impart.
Schedule your free demo class today and take the first step towards mastering GST with GB Training!
Ready to empower your career and excel in finance? Join us at GB Training, where expertise meets excellence!
Contact US - 9988113578
Course Content
Chapter 1: Introduction to GST
Chapter 2: Registration under GST
Chapter 3: Exercise:-Registration of a Business
using GST Portal
Chapter 4: Assignment:-GST Registration
Chapter 5: Tax Invoice
Chapter 6: Other Documents in GST
Chapter 7: Assignment-Documents in GST
Chapter 8: E-way Bill
Chapter 9: Exercise:-Generating i-way Bill using
GST Portal
Chapter 10: Assignment-E-way Bill
Chapter 11: Outward Supplies
Chapter 12: Different Transactions in GST Law
Chapter 13: Output Tax and Input Tax
Chapter 14: Understanding GSTR-1 Return
Chapter 15: Exercise: Filing GSTR-1 Return in
GST Portal
Chapter 16: Assignment: GSTR-1 Return
Chapter 17. GSTR-28 Statement
Chapter 18: Understanding GSTR-3B Return
Chapter 19: Exercise-Filing GSTR-3B Return in
GST Portal
Chapter 20: Assignment, GSTR-38 Return
Chapter 21: E-Ledgers
Chapter 22: Journal Entries in GST
Chapter 23: Exercise: Generating Payment
Challan using GST Portal
Chapter 24: Assignment: GST Challan
Generation
Key Answers
GSTR-1 Return Exercise
GSTR-1 Return Assignment
GSTR-3B Return- Exercise
GSTR-3B Return-Assignment
In summary, while GST training may not be mandatory in all cases, it is highly beneficial for commerce students. It equips them with practical skills, enhances their employability, and ensures they are well-prepared for the demands of the modern business and financial landscape.A GST course is an invaluable asset for anyone pursuing a career in commerce, finance, or accounting. It enhances employability, provides specialization in taxation, opens up career advancement opportunities, ensures compliance management, keeps you updated with GST changes, and prepares you for professional exams. Whether you are a B.com student seeking a competitive edge or an experienced professional looking to expand your skillset, a GST course is a worthwhile investment in your career growth and success.
Contact US - 9988113578
#CareerEmpowerment; #ExcelInFinance; #GatewayToExpertise; #GBTrainingImpact; #TricityEducationHub; #EmpowerYourJourney; #ExpertiseInGST; #CareerExcelWithGBTraining; #FinanceMastery; #TricityTrainingHub; #UnlockYourPotential; #GSTSuccess; #GBTrainingAdvantage; #CareerGrowthWithExpertise; #FinanceExcellence; #GBTrainingSuccess; #TricityProfessionals; #GSTSkillsMatter; #EmpowerYourPath; #GBTrainingJourney ,#GSTtraining ;#GSTcourse ;#GSTcertification ;#taxationexcellence ;GBTraining ;#Mohali ;#Chandigarh ;#GSTexpert ;#GSTsimplified ;#GSTindia ;#GSTcompliance ;#GSTentrepreneur ;#GSTcareers;#GSTTrainingChandigarh; #GBTrainingChandigarh; #ChandigarhEducation; #TaxationSkillsChd; #CareerDevelopmentChandigarh; #LearnGSTChandigarh; #FinanceCoursesChd; #ProfessionalSkillsChandigarh; #ChandigarhTricityTraining; #GBTrainingChd; #CommerceEducationChandigarh; #ChandigarhOpportunities; #GSTCertificationChd; #FutureInFinanceChandigarh; #SkillBuildingChd; #GBTrainingHubChandigarh; #CareerGrowthChd; #TricityLearningChandigarh; #GBTrainingCenterChd; #ChandigarhProfessionals
#GSTTrainingPanchkula; #GBTrainingPanchkula; #PanchkulaEducation; #TaxationSkillsPanchkula; #CareerDevelopmentPanchkula; #LearnGSTPanchkula; #FinanceCoursesPanchkula; #ProfessionalSkillsPanchkula; #PanchkulaTricityTraining; #GBTrainingPanchkula; #CommerceEducationPanchkula; #PanchkulaOpportunities; #GSTCertificationPanchkula; #FutureInFinancePanchkula; #SkillBuildingPanchkula; #GBTrainingHubPanchkula; #CareerGrowthPanchkula; #TricityLearningPanchkula; #GBTrainingCenterPanchkula; #PanchkulaProfessionals
#GSTTraining; #GBTraining; #MohaliEducation; #ChandigarhLearning; #TaxationExcellence; #FinanceSkills; #CareerEmpowerment; #TricityEducation; #ProfessionalDevelopment; #SkillsForSuccess; #GBTrainingInstitute; #LearnGST; #TaxationMastery; #ChandigarhStudents; #MohaliSkills; #FutureReady; #BusinessCompliance; #JobOpportunities; #CommerceTraining; #CareerAdvancement ,
No comments:
Post a Comment