Alantia Institute of Information Technology (AIIT)

"Apprise Education, Reprise Innovation"
An ISO 9001: 2015 Certified Institute


+91-9735596611
+91-8001281345
[email protected]
OUR BLOG | ENQUIRE NOW


Gain Tally ERP 9 with 100% Placements

100% Placement Assurity for Fresher's, Working Professionals.

Extremely Experienced Trainer (10+ Years)

Free Software Installations

Tally ERP 9 Training with GST

Certification in Tally

We provide Latest course Study Materials

Resume & Interviews Preparation Support

Tally Training

TALLY EDUCATION

Course Structure for Tally ERP 9

Certificate Program in Financial Accounting

Duration : 4 Months [40 Hours I 20 Classes]
Classes Schedule : 6 Classes In a Week with Weekends Days
Course Fees : Rs.5,000/- (One Time Payment)
Rs.1,500/- for Admission + [Rs.1,000 x 4] = Rs. 5,500/- (Instalment Payment)
Eligibility : Higher Secondary in any discipline from any Recognized Board. Final year Students may also apply.

Diploma Program in Financial Accounting

Duration : 6 Months [54 Hours I 36 Classes]
Classes Schedule : 6 Classes In a Week with Weekends Days
Course Fees : Rs.7,500/- (One Time Payment)
Rs.2,500/- for Admission + [Rs.1,000/- x 6] = Rs.8,500/- (Instalment Payment)
Eligibility : Graduate in any discipline from any UGC Recognized University. Final year Students may also apply.

Advance Diploma Program in Financial Program

Duration : 9 Months [81 Hours I 54 Classes]
Classes Schedule : 6 Classes In a Week with Weekends Day
Course Fees : Rs.10,500/- (One Time Payment)
Rs.2,500/- for Admission + [Rs.1,000/- X 9] = Rs.11,500/- (Instalment Payment)
Eligibility : Graduate in any discipline (Including CA, ICWA, CMA & MBA) from any UGC Recognized University. Final year Students may also apply.

ABOUT THE COURSE

BENEFITS

COURSE OBJECTIVE

WHY LEARN TALLY ERP 9 ?

Adoption of GST ready Tally ERP 9 software in sectors like BFSI, Retail, Manufacturing,
Trading etc. has lead to perpetual demand of Tally skilled & certified professionals.
Multiple job vacancies popup every day in different fields.

Accounting Technologies

We have one of the best courses for Tally ERP9 available in Burdwan. The course is suitable not only for students but also for accounting professionals. we have a unique course which gives you complete knowledge of Tally ERP 9. It includes all the features of this software. After completion of this course, you will get an extreme control over Tally ERP 9. The details of this course are given below.

Professional Accounts and Taxation Training & E-filing Course (Including Goods and Services Tax)

Attend our Practical Training Course to Get Challan, Return, E-filing and Accounting Practice with Goods and Services Tax (GST)
The course will be entirely Home Environment and you will be provided with assignments. You are required to submit the assignments which we will check and provide you feedback.
This will help you do well in Interviews and get good job offers You will also receive a Certificate of Professional Training after the completion of course.
You can also attend our classes at Purba Burdwan Center.

Basics Of Accounting & Full Course Content

  • History of Tally.ERP 9
  • Modules in Tally.ERP 9
  • Salient Features of Tally. ERP 9
  • Technological Advantages
  • Products of Tally
  • Install Tally.ERP 9 Download or from CD
  • Tally.ERP 9 Startup (Edu. Version)
  • Tally.ERP 9 Startup
  • Tally.ERP 9 Screen Component
  • Interface of Tally.ERP 9
  • Use of ‘Alt’ and ‘Ctrl’ Buttons
  • Using Calculator in Tally.ERP 9
  • Quitting Tally.ERP 9
  • What is Tally Vault & It’s Use
  • Accounts Basics
  • Type of Accounts
  • Golden Rules
  • Accounting Principle
  • Concepts & Convention
  • Double Entry Systems
  • Mode of Accounting
  • Financial Statements
  • Transactions
  • Company in Tally.ERP 9
  • Gateway of Tally
  • Create another Company – Ashok Traders
  • Opening a Company
  • Modification a Company
  • Shut a Company
  • Select a Company in Tally.ERP 9
  • Alter a Company
  • Delete a Company
  • What are Groups and Ledgers?
  • Groups and Ledgers in Tally.ERP 9
  • Creating a Ledger in Tally.ERP 9
  • Creating Multiple Ledgers in Tally.ERP 9
  • Displaying, Altering & Deleting Ledgers
  • Creating Chart of Accounts
  • Creating Bank Ledgers
  • Creating Single, Purchase, Sales, Expenses, Income, Party Ledgers & Tax Ledgers
  • Creating Duties and Taxes Ledgers
  • Creating Assets, Liabilities, Income & Expenses Ledger
i) Basic Level :-
  • Stock Group
  • Stock Categories
  • Stock Item
  • Godown
  • Unit of Measure
  • Standard Cost and Price
  • Stock Group
  • Create Multiple Stock Group
  • Display, Alter and Delete a Stock Group
  • Unit of Measurement
  • Create Compound Unit of Measure
  • Display, Alter and Delete a Unit of Measure
  • Creating Stock Categories
  • Creating Multiple Stock Categories
  • Display, Alter and Delete a Stock Category
  • Creating Godowns
  • Creating Multiple Godowns
  • Creating Multiple Godowns
  • Display and Alter a Godown
  • Creating Stock Item
  • Create Multiple Stock Items
  • Creating a Stock Item in Advanced Mode
ii) Advance Lavels :-
  • Introduction
  • Order Processing
  • Re-Order Processing
  • Tracking Numbers
  • Batch wise details
  • Bill of Materials (BOM)
  • Price Level & Price Lists
  • Displaying Stock Summary
  • Zero valued Entries
  • Physical Stock Voucher
  • Rejection IN
  • Rejection OUT
  • Stock Journal
  • Other Inventory Reports
  • Movement Analysis
  • Ageing Analysis
  • Entering a Voucher in Tally.ERP 9
  • Entering a Payment Voucher
  • Entering Voucher in Single Entry Mode
  • Payment Voucher for Bank Transactions
  • Receipt Voucher
  • Receipt Voucher for Cash Transactions
  • Receipt Voucher for Bank Transactions
  • Contra Voucher
  • Entering a Sales Voucher
  • Entering Sales Transactions in Tally.ERP 9
  • Entering a Purchase Voucher
  • Entering Purchase Transactions in Tally.ERP 9
  • Journal Voucher
  • Entering Journal Transactions in Tally.ERP 9
  • Entering Voucher Entry in Invoice Mode
  • Introduction
  • Purchase Order Processing
  • Sales Order Processing
  • Receipt Note – Part 1
  • Receipt Note – Part 2
  • Delivery Note
  • Interest Calculation in Simple Mode
  • Interest Calculation in Advance Mode
  • Multi-Currency
  • Bill of Material
  • Post-Dated Voucher
  • Optional Voucher
  • Memo (Memorandum) Voucher
  • Assembly Voucher
  • Manufacturing Voucher
  • Predefined Vouchers
  • Creating a Voucher Type
  • Display &Altering a Voucher Type
  • Voucher Mode and Invoice Mode
  • Item Invoice and Account Invoice
  • Enabling Invoice Mode in Tally
  • Entering Sales Transactions in Invoice Mode
  • Entering Sales Invoice with Discount
  • Entering Purchase Invoice with Discount
  • Debtors and Creditors
  • Debit Note and Credit Note
  • Situations where Debit Note and Credit Notes are used
  • Activating Debit Note and Credit Note
  • Entering a Debit Note
  • Entering a Credit Note
  • Accountant using Tally.ERP 9
  • Day Book
  • Generate Day Book in Tally.ERP 9
  • Display/Alter/Delete a Voucher
  • Ledger
  • View Ledger in Tally.ERP 9
  • Introduction
  • Cash Book
  • Petty Cash Book
  • Bank Book
  • Purchase Register
  • Sales Register
  • Journal Register
  • Statistics
  • Introduction
  • Methods of Adjustment
  • Activating Bill – Wise Details
  • Creating Purchase Voucher and View Statements
  • Creating Payment Voucher and View Statements
  • Creating Sales Transaction
  • Enter Receipt Voucher and View Ledger Statements
  • Post Dated Vouchers
  • Bill-Wise Details
  • Outstanding Reports
  • Advance Payment Adjustment
  • Print Outstanding Report
  • Alter Banking Details
  • Import Bank Details from Excel
  • Cash & Cheque Deposit Slip
  • Payment Advice
  • Bank Reconciliation Manual
  • Bank Reconciliation Auto
  • Cheque Register
  • Introduction
  • Activating Interest Calculation
  • Interest Calculation on Outstanding Balance
  • Report on Interest Calculated on Outstanding Balance
  • Interest Calculation Transaction by Transaction
  • Calculating Interest on Ledger Balances
  • Introduction of Job Costing
  • Master Creation of Job Costing
  • Consumption Voucher
  • Purchase Voucher
  • Inter Godown Transfer
  • Expenses
  • Sales Booking
  • Introduction
  • Activating Batch – Wise Details
  • Using Batch – Wise Details in Purchase Invoice
  • Using Batch – Wise Details in Sales Invoice
  • Creating Purchase Voucher
  • Creating Sales Voucher
  • Introduction of Cost Center
  • Cost Center & Cost Category Implement
  • Creating Cost Category
  • Sales in Cost Center
  • Creating Cost Centers in Single & Multiple Mode
  • Allocating Income to Cost Centers
  • Cost Center Repost
  • Introduction
  • Activating Price Lists and Price Levels
  • Creating Price List as on Starting & Ending Month
  • Using Price Lists
  • Create Sales Invoice.
  • Payroll Introduction
  • How to Enable Payroll
  • Payroll Statutory Information
  • Employee Group Creation
  • Employee Creation
  • Payroll Master Creation
  • Pay head Creation
  • Pay head Deductions
  • Payroll Master Employers
  • Pay head Employers
  • Pay head Gratuity
  • Loans and Advances
  • Employers other Contribution Pay heads
  • Define Salary Structure
  • Creation Payable Ledgers
  • Record Attendance Voucher
  • Salary Process
  • PF Admin Expense Process
  • Payment of Salaries through Payroll Vouchers
  • PF and ESIC Payment and Challan Creation
  • View Payroll Reports
  • Receivable and Payable Statement Report
  • Ageing Report
  • Godown wise Stock Report
  • Movement Analysis
  • Transaction wise Profitability Analysis
  • Stock Summery
  • Bank Reconciliation
  • Stock Category wise Report
  • Sales Order Pending Register
  • Purchase Order Pending Register
  • Sales Bill Pending Register
  • Product Register
  • Bill of Materials (BOM)
  • Interest Calculations
  • Point of sale (POS Invoicing)
  • Fringe Benefit Tax (FBT)
  • Back Up / Restore
  • Split Company Data
  • How to Split Financial Years
  • Tally Vault
  • Exporting Master Data
  • Importing Data
  • Consolidation of Companies
  • Create a Group Company
  • Password or Security Control
  • Types of Security (security or authority levels)
  • Users and Passwords
  • Enabling Cheque Printing
  • Printing Cheques
  • Credit Limits
  • Setting Credit Limits
  • Exceeding Credit Limits
  • Receivable and Payable Statement Report
  • Ageing Report
  • Godown wise Stock Report
  • Movement Analysis
  • Transaction wise Profitability Analysis
  • Stock Summery
  • Bank Reconciliation
  • Stock Category wise Report
  • Sales Order Pending Register
  • Purchase Order Pending Register
  • Sales Bill Pending Register
  • Outstanding Report
  • Print Outstanding Report
  • Product Register
  • Cash Book
  • Petty Cash Book
  • Bank Book
  • Journal Register
  • Introduction
  • Activating Budgets
  • Creating Group Budget on Closing Balance
  • Creating a Ledger Budget
  • Displaying Budgets and Variances for Group Budget on Closing Balance
  • Displaying Budgets and Variances for Ledger Budget
  • Trial Balance
  • Profit & Loss Account
  • Balance Sheet
  • Ratio Analysis
  • Functions Keys
  • Special Key Combinations
  • Special Function Key Combination
  • Key Combination used for Navigation
  • Basic Understanding of VAT
  • Introduction of VAT
  • Create Company & Enable VAT Feature
  • Activating CST in Tally
  • Creating a CST Payment Voucher
  • Create Stock Master for VAT
  • Create Accounting Master for VAT
  • Purchase Voucher Under VAT on MRP
  • Purchase Voucher for CST
  • Purchase Other
  • Sales Voucher for VAT on MRP
  • Sales Others
  • Sales of Exempted Goods
  • VAT Accounting Master Each Separate Transaction
  • Payment of VAT & CST Payable
  • Adjustment of Surcharge
  • Purchase Return in VAT
  • Sales Return in VAT
  • Reversal of VAT Input Credit
  • CST Payable Adjustment with VAT Input Credit
  • Statutory Declaration From
  • Challan Reconciliation
  • Filing West Bengal VAT Return
  • Introduction of TDS
  • TDS Rates
  • TAN
  • Implement TDS in Tally.ERP 9 Accounting Master
  • E-filling procedure on software of all forms
  • Lower Deduction under Section 197
  • Payment of TDS
  • Practice of Form
  • Quarterly TDS Return
  • Challan Reconciliation
  • Generate E-File TDS Return
  • Tax Collected for source
  • General provision of service tax, taxable service, rate of service tax
  • Registration provision under service tax
  • Enable Service Tax in Tally
  • Define Service Tax Rates at Company, Ledger & Group level
  • Define Service Tax Rate at Stock Item & Voucher level
  • Sale of Single & Multiple Service
  • Sale of Service Inclusive of Tax
  • Sale of Exempted Service
  • Purchase of Service
  • Export of Service
  • Pure Agent Service
  • Receipt cum Challan of Service Tax
  • Define Abatements Rate
  • Service Tax Liability on Recipient of Service
  • Service Tax Reverse Charge
  • Service Tax Adjustment
  • Service Tax Payment and Challan Reconciliaion
  • Service tax challan
  • Service tax return Form ST-3 filling
  • Excise Act-Basic Concepts
  • Enable Excise in Tally.ERP 9
  • Master of Excise
  • Excise Purchase, Sales and MRP Sales
  • Sales Inclusive of Tax
  • Major aspects of duty liability
  • Case Study-Manufacture and concept of tariff
  • Central Excise Tariff ACT CETA
  • Job work and provisions
  • Central Excise practical process, Registration
  • Record, Invoice, Maintenance of PLA
  • Excise for Dealer
  • E-payment procedure
  • Excise Adjustment Payment and Return
  • Deduction of TDS with Salary, Allowances, Perquisites
  • Treatment of Deductions under Chapter VIA
  • Computation and Online deposit of PF ECR
  • Computation and Online deposit of ESI
  • Making Salary Structure for Employees
  • Making Salary Sheet and Disbursement of Salary
  • Important forms/records to be maintained for handling Payroll
  • Understanding Treatment of PF/TDS/ESI in case of Leave /New Joining
  • Using Relevant Advanced Excel formulas for Payroll Processing
  • Taxability of Different Allowances and Perquisites
  • Deductions (Tax Savings) Under Chapter VI A
  • Salary Calculate/Structure
  • Passing Routine and Book Closure Entries in Tally ERP 9
  • Provisioning for Different Expenses and Payables
  • Preparing Depreciation Chart as Per Companies Act and Income Tax Act
  • Current and Deferred Tax Computation and its Provisioning
  • Preparation of Bank Reconciliation Statement (BRS) in Tally ERP 9
  • Exporting Data in Excel
  • Preparation of P & L Balance Sheet as per Revised Schedule III (Schedule VI of company act 1956) Of Company ACT 2013
  • Preparation of Balance Sheet of SME Accounts
  • Preparation of Balance Sheet of Large and Medium Entrepreneur
  • Composition of Annual Final Accounts of Company
  • Indian Gaps Compliances (Account Standard)
  • Depreciation Chart as per Income Tax & Company Act
  • Depreciation Rate Comparison
  • Inventory Control
  • Documentation in Finance for CC Limit/OD Limit
  • Project Reports
  • CMA Data
  • Practical Analytical Review of Reports
  • Stock Statement
  • LC(Letter of Credit)
  • Letter of Credit- How to Open the LC
  • How to Sanction the LC Limit from Bank
  • Documentation for LC Limit
  • Ratio Analysis
  • Bank Guarantee (Usage & Format)
  • Online Payment of Taxes
  • Ratio Analysis
  • Preparation of Projections/Budgets
  • Preparation of Fund Flow Statement and Cash Flow Statement
  • Cost Centre Reporting in Tally ERP 9
  • Debtor and Creditor Aging Report in Tally ERP 9
  • E-Filing ITR For Salaried Business
  • Terminology of income tax like P.Y, A.Y, Income, Assesse
  • Incidence of income tax
  • Residential status like ROR, RNOR, HUF
    1. -Income under Various Heads
    2. -Deduction from Income
    3. -Assessments 0f Income
    4. -Various Provisions
  • Advance Tax Computation and Deposit
  • E-Filing ITR For Small Proprietorship
  • Deduction and E-Filing ITR For Partnership Business
  • Practical implications of Important Points of Different Incomes
  • Understanding Expense Disallowed
  • Current Tax and Deferred Tax Computation for Companies
  • Challan 280 Online and Offline Procedure
  • Accounting for TDS Receivable and Payable in Tally ERP 9
  • TDS Rates and E-Payment of Challan 281
  • Filing TDS Return Form 26Q
  • Checking of Form 26AS
  • Procedure of Form 15CB and 15CA and Form 27Q
  • Enable Service Tax
  • Define Service Tax Rates at Company Level
  • Define Service Tax Rate at Ledger Level
  • Define Service Tax Rate at Group Level
  • Define Service Tax Rate at Stock Item or Voucher Level
  • Sale of Single Service
  • Sale of Multiple Service
  • Sale of Service Inclusive of Tax
  • Sale of Exempted Service
  • Purchase of Service
  • Export of Service
  • Pure Agent Service
  • Receipt cum Challan of Service Tax
  • Define Abatement Rate
  • Service Tax Liability on Recipient of Service
  • Service Tax Reverse Charge
  • Service Tax Adjustment
  • Service Tax payment and Challan Reconciliation
  • Service Tax Return Form ST-3
  • How to Deal with Import and Export
  • Import and Export Procedure
  • Import Documents
  • Import Procedure
  • How to Release the Dollar from Banks to Pay Outside India A-1/A-2
  • Export Procedure
  • Export Document
  • Bill of Entries
  • Bill of Lading

From the above discussion, it is clear that pursuing a course in AIIT Computer Education would give shape to the dreams of a student who is looking to secure a top job position in an MNC.



The GST course is the foremost training program offers rigorous training in GST advanced concepts and provides the platform for the exchange of tax knowledge to the participants and upgrade their skills and comprehension for their professional career. AIIT has designed this specialized course for students who lacks confidence in their skills of pursuing the career of their dreams. The GST classes are conducted on weekends, which offers flexibility to the participants who don’t have to adjust their office or college timings in order to attend the classes. The best thing about this course is the candidates will receive the insights and knowledge on Goods and Service Tax from reputed and admired Professional with years of industry experience. You will gain exceptional expertise on tax processing and analysis, which will increment your chances of acceptance in a business firm for the role of tax consultants.

Why learn Direct & Indirect Taxation

Every organization, no matter the scale, needs to provide a certain amount of tax to the Government for their business purposes. They are also required to attain taxes from their employees and clients in a proper way. And to do this, they hire professionals who have the necessary skills and expertise to execute these operations in an accurate and timely manner.

These are only some of the benefits of learning Income Tax & GST Course which you can get. Thus, wait for no further and join our prestigious institute immediately. Get training from teachers who have helped thousands of students acquire high paying jobs in numerous industries. Forge a promising career in the taxation field in any reputed firm within a span of few months.

India’s decision of deploying GST in the market will see a great change in the country’s economy. This would make the process of supplying the Goods and Service Tax to the end user easier and reduce a considerable time and price of the commodity. However, one of the best ways Indian economy could benefit from this move is the rise of opportunities of GST operators and tax consultants and students looking to pursue this career can benefit from this extensive course to solidify their chances of achieving their goals. Other important reasons why you should learn GST are as follows:

The job of a tax consultant holds a great importance for every business organization as he or she is responsible to analyze, evaluate and process all the tax related procedures within the company and helps the company to perform their business activities in a legal manner. In order to become a professional tax consultant, you first need to acquire comprehensive knowledge and skills in the field and gain momentum and experience, which is only possible by attending a quality advanced direct and indirect taxation training. AIIT offer the most reliable advanced direct and indirect taxation course to candidate who wish to pursue a career as a Tax consultant or tax manager. In this course, the participants are taught about different types of direct and indirect taxes and Goods and Service Tax (GST), where they are levied and how these are computed in a proper and efficient manner. Our highly effective taxation course is designed with updated course material, real time training, proficient instructors and latest technology to help the students gain deeper prospects of taxation system. We encourage the candidates to pursue their career in taxation field and build inner confidence to make it big in the industry through our dedicated team of Professional’s and finest learning environment.

The specially designed industry focused course is the first step of every accounts professional & fresher’s who wish to learn the complexities of Income Tax and Goods and Service Tax system and put it to better use for their business organization. AIIT provides the needed platform to those Learners with our competitive course material and live training. Our Trainers are industry professionals and Sr. Tax Consultants with immense experience in Consulting & Teaching. During the course, the participants will gain knowledge on Income Tax, Goods and Service Tax in great details along with several act & laws. We ensure that the participant garner the skills effectively and put it into practical use confidently when appointed in any industry.

Our Advanced Direct and Indirect Taxation Course that can be completed in 1-3 months involves various other features such as live training sessions from industry experts with projects and assignments, latest study material and much more. After the completion of the course, we will also provide placement in industries or certainly help you find a relevant job, although it may not be needed.

Module 1 – GST- Goods & Service Tax – By Professional (Indirect Tax)

  • Principles
  • Important Definitions. (Section 2)
  • Why GST is Necessary?
  • Impact of GST.
  • Benefits/ Demerits.
  • Different Rates of GST
  • FAQ
  • Migration of Existing Dealer.
  • Registration Structure under GST.
  • Persons required to be registered.
  • Process of Registration.
  • Amendment in Registration.
  • Cancellation of Registration.
  • Forms for GST Registration
  • GST REG-01- Application.
  • GST REG-02- Acknowledgement.
  • GST REG-06- Certificate.
  • REG-01 to REG-29
  • FAQ
  • Definition & Important Notes to Return.
  • Types of Returns. (Annual Return, First Return, Regular Return)
  • Notice to Return Defaulters.
  • Levy of Late Fee.
  • Goods and Services Tax Practitioners
  • Various Return Form
  • e. GSTR-I, II ,III
  • FAQ
  • Refund of Tax (Section-54)
  • Refund in Certain Cases (Section-55)
  • Interest on Delayed Refunds (Section-56)
  • Consumer Welfare Fund (Section-57)
  • Utilization of Fund (section-58)
  • FAQ
  • Eligibility & Conditions for taking ITC (Section-16)
  • Block Credit (Section-17)
  • Availability of Credit in Special Cases (Section-18)
  • ITC for Job Work (Section-19)
  • ITC Distribution by ISD (section-20)
  • FAQ
  • Definitions
  • Collect of Tax at Source – E Commerce
  • FAQ
  • Special Provision for Job Worker
  • Composition Levy Section 10
  • Quarterly Return for Compounding Taxable Person GSTR-4
  • FAQ
  • Payment of Tax, Interest, Penalty and other charges Section 49
  • Interest on delayed payment of tax Section 50
  • Tax Deduction at source Section 51
  • Tax Invoices Section 31
  • Time and Value of Supply Section (12-15) Chapter IV
  • Transitional Provisions Section (139-142) Chapter XX
  • FAQ
  • Important Definitions. Section 2
  • Determination of Nature of Supply (Section 7-9)
  • Place of Supply of Goods and/or Services (Section 10-14)
  • Zero Rated Supply (Section 16)
  • FAQ
  • Terminology of income tax like P.Y, A.Y, Income, Assesse
  • Incidence of income tax
  • Residential status like ROR, RNOR, OR
  • Analytically-Income under head salary computation theoretically& by utility
  • (Allowances,
  • Perquisites, Retirement benefit)
  • Income under head house property
  • Income under head PGBP (corporate exposure) Real time calculation
  • TAX AUDIT 44AB ONLINE REPORTING 3CA, 3CB, 3CD REAL TIME FILLING
  • Presumptive taxation u/s 44AB, AD, AE
  • Income under capital gain
  • computation in utility of CG Income
  • Exemption under 54 to 54H for capital gain
  • Income from other sources
  • Deduction u/s 80c to 80u
  • Assessment of Individual
  • Assessment of Partnership firm
  • Assessment of company
  • Assessment by ITD u/s 143(2), 144, 148, 153
  • MAT
  • AMT
  • RAIDS/Survey
  • Clubbing of income
  • Set off and carry forwards of losses
  • Returns of Income u/s 139 from ITR-1 to ITR-7 for all assesse
  • Agriculture Income
  • Advance Tax
  • Interest u/s 234A,B,C
  • Illustration on every topic
  • PPT on topics

MIS Advanced Excel

OBJECTIVE: Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools

TOPICS COVERED: Introduction, Basic Understanding , Sum, Count, Count, Count blank, Average, Max, Large Min, Abs, Sum if, Count if, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EO month, E-date, Net workdays, Today, Weekday, Week number, Workday, Find, Search. V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formatting, Dated if, What If Analysis, Match Index, Offset Function, User form Function in Excel, Data Validation, Advance Filter, Sorting, Group & Ungroup, Data split, Text Function (Data Separation), Substitute.

Who can do this course?

Our Government Certified Tally ERP 9 with GST training course is a professional course useful for Accounting and Finance Students and Young Professionals who are interested in the field of Finance and Account.

1) What is Book Keeping?

Ans.1)Book-Keeping is an art of recording business transaction.

2) What is an Account?

Ans.2)An Account is a summarized record of transaction effecting one person, one kind of property or one kind of gain or loss.

3) What is Debit?

Ans.3)The Receiver of any benefit is termed a Debtor & is Debited. To Debit an A/c: means to enter a transaction on the ‘Debit’ side of that A/c i.e Left Hand side.

4) What is Credit?

Ans.4)The Giver of any benefit is termed a Creditor & is Credited. To Credit an A/c: means to enter a transaction on the ‘Credit’ side of that A/c i.e Right Hand side.

5) What is a Contra Entry?

Ans. 5)Contra-Entry effects both the sides of the Cash Book.After we getting to know the basic Accounting terms, we move further in increasing our knowledge & getting deeper in our study, to know all about this powerful 8letter word ‘A C C O U N T S’ There are 3 RULES OF ACCOUNTING on which entire accounts depends upon. Understanding the rules of Accounting is making your foundation in Accounts strong, whereby any transaction can be solved immediately.

7)What is Journal Voucher?
8)Explain the word Liability
9)Explain the word assets
10)Books of Accounts
11)Definition of Indirect Exp / Indirect Income
12)Definition of Direct Exp / Direct Income
13)What is debit?
14)What is credit?
15)Difference between Journal voucher / Journal entry

The 3 Basic Golden Rules of Accounting.

1. Personal Accounts

Accounts recording transaction with persons or firms are known as Personal accounts. Accounts recording transaction which do not effect particular person, but effects business in general are known as Impersonal A/c’s Impersonal A/c’s may be either Real Accounts or Nominal Accounts. RULE

  • Dr-TheReceiver
  • Cr-The Giver

2. Real Accounts Real Accounts are those accounts of property or possession.

Example:Goods Accounts, Cash Account, Bank Account, Office Furniture Accounts. RULE

  • Dr-What Comes in
  • Cr-What Goes out

3. Nominal or Fictitious Accounts

Records Expenses, gains & losses.
Examples:Rent A/c Salaries A/c Advertising A/c
Interest Recd A/c
Discount A/c
Commission Recd A/c
Wages A/c
RULE

  • Dr-All Expenses & Losses
  • Cr-All Income & Gains
  • 1) Accounting Software
  • 2) Why use Tally to maintain Account
  • 3) Advantage over manual Accounting
  • Understanding the Various Books Of Accounts

    • Journal Book - It is one of the Subsidiary Books. It is used for entering the names of accounts which are effected by each transaction. With effect to Dr. & Cr.
    • Ledger Book - It is the process of transferring that transaction which has been Previously recorded in the Journal into appropriate heads of accounts. It is also known as Posting.
    • Cash/Bank Book - It records all Cash/Bank transactions. Cash transaction means Cash Receipts & Cash Payments from day to day.
    • Purchase Book - Records all Credit Purchases of goods.
    • Sales Book - Records all Credit Sales of goods. Out of these various Books of Accounts, we get the following Financial Accounting Statements. These financial statements help in knowing the status of the business at any given date.
    1. Trial Balance –Is the Summary of ALL your Accounts. It is a list of all Dr Balances & Cr Balances.
    2. Trading Account –Is an account which gives you the result that is(Gross Profit or Gross Loss) from buying & selling of goods.
    3. Profit & Loss A/c –Is an account which gives you the result that is (Net Profit or Net Loss)from the transaction during certain.
    4. Balance Sheet -It is a statement which gives you the exact financial position of the business at the end of the month of year .It is prepared from the Trail Balance. It represents All Assets & All Liabilities Assets means various possession of business. Liabilities mean the amount owing by the business. The Excess of Assets over Liabilities represents Capital of owner.

    Accounting terms, understanding the Accounting rules & knowing the various Books & Financial Statements of Accounts you are now in a Position to maintain your Accounts on the Computer by using software called Tally. Tally is a user friendly program.

    Steps Involved in maintaining Accounts by using Tally

    1. Double Click the Icon tally72.exe to bring up the Tally Screen.

    2. Create the Company.

    3. Create all Ledger Accounts.

    • Liabilities
    • Assets
    • Indirect Expenses
    • Indirect Income
    • Purchase
    • Sales

    4. Create the Accounting Vouchers

    • Payment Voucher
    • Receipt Voucher
    • Contra Voucher
    • Journal Voucher
    • Purchase Voucher
    • Sales Voucher
    • Debit Note Voucher
    • Credit Note Voucher
    • Purchase Order Voucher
    • Sales Order Voucher
    • After Entering all the Vouchers you will automatically get the Books of Accounts mentioned below :

    5. Various Books of Accounts

    • Cash/Bank Book
    • Ledger Book
    • Journal Voucher Book
    • Purchase Book
    • Sales Book
    • Debit Note Book
    • Credit Note Book
    • Purchase Order Book
    • Sales Order book

    From the Books of Accounts you will automatically get the Financial Statements of Accounts mentioned below

    6. Financial Statements of Accounting

    • Trail Balance
    • Trading A/c
    • Profit & Loss A/c
    • Balance Sheet

    Latest News

    We ,AIIT is a privileged of Tally.ERP9 with GST, SAP & Advance Excel Training. We focus on the needs of the Tally & SAP ERP community. We AIIT provide the ideal platform to meet the demands of the constantly evolving Present job market.


    Quick Contact

    +91-9735596611
    +91-8001281345
    [email protected]
    [email protected]

    Register Address: Satgachia Manashatala, Satgachia, Memari, Burdwan-713422 Training Center Address: Bhairab nath tala, J.B Mitra Lane, Burdwan-713104
    Copyright ©2018 AIIT . All Rights Reserved
    Follow us on: