Accounting & Taxation Master's Program

·      Identifying the different Excel

·      Identifying new features of Excel

·      Working with the ribbon

·      Customizing the Excel program window

·      Zooming in on a worksheet

·      Arranging multiple workbook windows

·      Adding buttons to the Quick Access Toolbar

·      Customizing the ribbon

·      Maximizing usable space in the program window

·      Modifying workbooks

·      Modifying worksheets

·      Inserting rows, columns, and cells

·      Merging and unmerging cells           

·      Entering and revising data

·      Managing data by using Flash Fill

·      Moving data within a workbook

·      Finding and replacing data

·      Correcting and expanding upon worksheet data

·      Defining Excel tables

·      Naming groups of data

·      Creating formulas to calculate values

·      Summarizing data that meets specific conditions

·      Working with iterative calculation options and automatic workbook

·      calculation

·      Using array formulas

·      Finding and correcting errors in calculations       

·      Formatting cells

·      Defining styles

·      Applying workbook themes and Excel table styles

·      Making numbers easier to read

·      Changing the appearance of data based on its value

·      Adding images to worksheets    

·      Limiting data that appears on your screen

·      Filtering Excel table data by using slicers

·      Manipulating worksheet data

·      Selecting list rows at random

·      Summarizing worksheets by using hidden and filtered rows

·      Finding unique values within a data set

·      Defining valid sets of values for ranges of cells    

·      Sorting worksheet data

·      Sorting data by using custom lists

·      Organizing data into levels

·      Looking up information in a worksheet

·      Using workbooks as templates for other workbooks

·      Linking to data in other worksheets and workbooks

·      Consolidating multiple sets of data into a single workbook        

·      Examining data by using the Quick Analysis Lens

·      Defining an alternative data set

·      Defining multiple alternative data sets

·      Analyzing data by using data tables

·      Varying your data to get a specific result by using Goal Seek

·      Finding optimal solutions by using Solver

·      Analyzing data by using descriptive statistics       

·      Creating charts

·      Customizing the appearance of charts

·      Finding trends in your data

·      Creating dual-axis charts

·      Summarizing your data by using sparklines

·      Creating diagrams by using SmartArt

·      Creating shapes and mathematical equations       

·      Analyzing data dynamically by using PivotTables

·      Filtering, showing, and hiding PivotTable data

·      Editing PivotTables

·      Formatting PivotTables

·      Creating PivotTables from external data

·      Creating dynamic charts by using Pivot Charts

·      Adding headers and footers to printed pages

·      Preparing worksheets for printing

·      Previewing worksheets before printing

·      Changing page breaks in a worksheet

·      Changing the page printing order for worksheets

·      Printing worksheets

·      Printing parts of worksheets

·      Printing charts

·      Linking to Office documents from workbooks

·      Embedding workbooks into other Office documents

·      Creating hyperlinks

·      Pasting charts into other Office documents          

·      Sharing workbooks

·      Saving workbooks for electronic distribution

·      Managing comments

·      Tracking and managing colleagues’ changes

·      Protecting workbooks and worksheets

·      Authenticating workbooks

·      Saving workbooks as web content

·      Importing and exporting XML data

·      Working with SkyDrive and Excel Web App         

·         Components of an Accounting Manual

·         Example of an Accounting Manual

·         What Is Accounting?

·         How Accounting Works

·         Types of Accounting

·         Requirements for Accounting

·      What is Commerce?

·      Why Accounting is needed?

·      Basic concept of accounting

·      Types of accounts

·      Golden Rules of Accounts

·      Introduction to Tally Prime

·      Top 10 Tally Prime Features

·      What’s New in Tally Prime

·      Comparison between Tally ERP 9 and Tally Prime

·      Gateway of Tally

·      Company Creation in Tally Prime

·      Alter/Delete Company Details

·      Introduction to Company Menu

·      Company Features

·      Tally Company Configuration

·      Create Account Groups Single/Multiple

·      Creating a Single/Multiple Ledger

·      Maintain Balances Bill-by-Bill & Default Credit Period

·      Ledgers with Opening Balances

·      Balance Sheet

·      Examples of Journal Entries

·      Contra

·      Payment

·      Receipt

·      Journal

·      Sales

·      Purchase

·      Debit note

·      Credit note

·      Accounting Problems for Practice

·      Cost Centers Allocation

·      Cost categories for parallel allocation

·      Cost center class

·      Report related to cost center/category

·      Create/Alter a Budget

·      View Budget Variance

·      Delete a Budget

·      Create/Alter a Scenario

·      Use Optional Vouchers in Scenarios

·      Use Scenarios in Reports

·      Calculate Interest Using Simple Parameters

·      Calculate Interest Transaction-by-Transaction

·      Calculate Interest Using Advanced Parameters

·      Calculate Interest on Group

·      Calculate Interest on Ledger Balances

·      View Interest Amount on Invoices

·      Record Transaction for Interest Calculation

·      Balance Sheet

·      Profit & Loss

·      Cash Flow

·      Funds Flow

·      Receivables

·      Payables

·      Trial Balance

·      Day Book

·      Cash Book

·      Bank Book

·      Creating a Single Stock Group

·      Modifying / Deleting a Single Stock Group

·      Creating a Multiple Stock Group

·      Creating Single/multiple Stock category

·      Creation of Units of Measure

·      Simple Units of Measure

·      Compound Units of Measure

·      Alternation / Deletion of Stock Units

·      Creation of Single Stock Items

·      Inventory storage using godown

·      Setup Bill of Materials (BOM)

·      Creating a Manufacturing Journal

·      Set Up Batches for Stock Items

·      Sell Stock Items from Batches

·      Batches for Purchased Stock Items

·      Batch Summary

·      Batch Vouchers

·      Purchase Order Processing in Tally.ERP9

·      Receipt Note Voucher (GRN) against Purchase Order

·      Rejection Out Voucher against Purchase Order

·      Purchase Voucher against Receipt Note Voucher (GRN)

·      Sales Order Processing

·      Delivery Note Against Sales Order

·      Rejection In Against Sales order

·      Sale Invoice Against Delivery Note

·      Job Work

·      Job Work Masters

·      Principal Manufacturer (Job Work Out)

·      Job Work In

·      Material In/ Material Out Voucher

·      Track Additional Cost of Purchase

·      Zero valued Transactions

·      Use Different Actual & Billed Quantity

·      Transaction using Stock journal with purchase/sales:

·      Separate Discount Column in Invoices

·      Price Levels

·      Create Price Levels

·      Assign Price Levels to Ledger Accounts

·      Price List

·      Use Price Levels & Price List during Voucher Entry

·      Complete cancellation of order

·      Partial cancellation of order

·      Record Quotation

·      Record a POS Invoice

·      POS Invoice with Multiple Modes of Payment

·      Faster Data Entry for POS Invoice

·      POS Register

·      Track Your Inventory | Stock Summary

·      Location/Godown Summary

·      Movement Analysis

·      Stock Ageing Analysis

·      Stock Query

·      Physical Stock Register

·      Stock Cost Estimation

·      Group Company

·      Multi Currency

·      Multiple Addresses for Ledger

·      Specify Credit limit

·      Use Security Control

·      Creating Users and Passwords

·      TallyVault Password

·      Backup/ Restore Company data

·      Splitting Company Data

·      Import/Export data

·      Cheque printing

·      Cheque Register

·      Banking Transaction Types

·      Post Dated Cheque

·      Deposit Slip

·      Payment Advice

·      Bank Reconciliation

·      Introduction to Payroll

·      Payroll in TallyPrime

·      Enable Payroll in TallyPrime

·      Payroll Transactions

·      Generate Pay Slips

·      GST Introduction

·      SGST, CGST and IGST Terms

·      GST – What is HSN and SAC

·      GST Classifications

·      Enable & Recording GST Transactions

·      Recording GST Transactions - Multi Tax Rates

·      GST Payment

·      Recording GST on Item Rate

·      Recording GST Services

·      Recording GST Expenses

·      Recording GST Assets

·      GST on Reverse Charge Mechanism (RCM)

·      GST Advance Receipts

·      GSTR-1 Filing

·      GSTR-3B Filing

·      GSTR-1

·      GSTR-2

·      GSTR-3B

·      GST Annual Computation Report

·      Setup e-Way Bill

·      Generate JSON of E-Way Bill

·      Record invoice with details required for e-Way Bill, and create JSON

·      Step to generate e-Way Bill on the e-Way Bill Portal

·      Print the invoice with e-Way Bill number

·      Enable TDS

·      TDS Nature of Payment

·      TDS Ledger- Expenses Ledger, Party Ledger

·      Record TDS Transactions

·      Generate TDS Reports

·      Set Up Your Books For Tax Collected at Source

·      Record TCS Transactions

·      Generate TCS Reports

·      Create New Company In QuickBooks

·      Opening an Existing Company

·      Modify Company Info

·      Practical Exercise

·      QuickBooks Menu

·      Icon bar

·      Home page

·      Practical Exercise

·      Planning the Chart of Accounts

·      Creating Accounts and Subaccount

·      Practical Exercise

·      Creating Customers  in QuickBooks

·      Creating Jobs, Creating Vendors

·      Working with customers, jobs & vendors

·      Managing Leads

·      Practical Exercise

·      Creating Items

·      Service Items

·      Product Items

·      Creating other types of Items

·      Practical Exercise

·      Adding & editing multiple records

·      Importing information

·      Practical Exercise

·      Price Levels

·      Customer profile lists

·      Vendors profile lists

·      Fixed Item List

·      Practical Exercise

·      Setting up Time Tracking

·      Tracking Mileage

·      Generating Mileage Reports

·      Practical Exercise

·      Viewing payables with bill tracker

·      Entering Bills

·      Paying Bills- Deposit to a Vendor

·      Handling Reimbursable Expenses

·      Writing Checks & Other Payment Methods

·      Practical Exercise

·      Creating Invoice

·      Deposits, Down Payments and Retainers

·      Estimating Jobs, Creating Progress Invoices

·      Handling Customer Refunds and Credits

·      Practical Exercise

·      Generating Statements

·      Practical Exercise

·      Memorizing Transactions

·      Finding Transactions

·      Practical Exercise

·      Receiving Payments, Cash Sales

·      Making Deposits

·      Practical Exercise

·      Entering Transactions in Account Register

·      Transferring Funds

·      Reconciling Accounts

·      Managing Loans

·      Practical Exercise

·      Payroll in QuickBooks

·      Practical Exercise

·      Balancing Debit & Credit amounts

·      Creating Journal Entries

·      Checking Journal Entries

·      Reclassification & corrections

·      Practical Exercise

·      Generating Financial Reports

·      Generating Tax Reports

·      Closing the books for the year

·      Practical Exercise

·      Tracking To-Dos

·      Reminders

·      Practical Exercise

·      Backing up files

·      Restoring Backups

·      Practical Exercise

·      Setting Up Inventory Items

·      Purchasing  Inventory

·      Selling Inventory

·      Practical Exercise

·      Working with Sales Tax

·      Paying Sales Tax

·      Practical Exercise

·      Creating Budgets in QuickBooks

·      Filling in budget values

·      Running budget reports

·      Practical Exercise

·      Tracking Finances with Reports and Graphs

·      Practical Exercise

·      Online Banking with QuickBooks

·      Practical Exercise

·      Configuring Preferences

·      Practical Exercise

·      Integrating QuickBooks with Other Programs

·      Customizing QuickBooks

·      Practical Exercise

·      Data Security in QuickBooks

·      Practical Exercise

·         Business Dress Code

·         Business Ethics

·         Business Etiquette

·         Business Negotiation Skills

·         Business Writing Skills

·         Business Emails Writings

·         Cracking Interviews

·         Effective Communication

·         Interpersonal Skills

·         Career Development Planning

·         Defining the ‘Previous year’

·         Assessment Year

·         Understanding your Salary

·         Income on which you pay Tax?

·         Deductions

·         Make Section 80C your best friend

·         TDS or Tax deducted at source?

·         Calculating Tax Payable

·         Standard Deduction

·         Illustration on salary TDS

Now a days all Govt returns are filed through internet. E-filing of all GST, TDS, IT, PF, ESI returns are now mandatory and hence every accountant should learn to file these returns with in the specified time. Every Firms, Company, business need Accountants with this knowledge, we advise you to study this Course along with Tally ERP Expert Course.

·         GST

Overview of Goods & Services tax, Overview of GST – Introduction, Implementation of GST, Liability of the tax payers, GST network, GST council, Levy of and exemption from tax, Levy of GST – Introduction, Composition scheme, Remission of tax/duty, Registration, Registration-introduction, Registration procedure, Important points, Special persons, Cancellation/amendment, Meaning and scope of supply, Taxable supply, Supply of goods and supply of services, Course or furtherance of business, Special transactions, Time of supply, Time of supply-goods, Time of supply-services, Time of supply-other points, Valuation in GST, Valuation in GST, Valuation rule, Payment of GST, Payment of GST- Introduction, Time of GST payment, How to make payment of GST, Challan generation, TDS & TCS, Electronic commerce, Tax collection at source, Procedure for e-commerce operator, Job work, Input tax credit, Job Worker, Input service distributor, Legal formalities-Input service distributor, Distribution of credit, E-Way bill & rules, Returns in gst, Introduction, GSTR-1 GSTR-2, GSTR-3 Other taxable persons, Annual return, Overview of the IGST act, IGST act-other provisions, Place of supply of goods & service, Introduction, Registered and unregistered persons, GST common portal, Introduction, GST eco-system, GST suvidha provider(gsp), Uploading invoices

·         Practical E-filing

SGST, CGST & IGST, Input Tax Credits, Monthly Returns, GSTR 1,1A,2,2A,3, E-way bill and other Returns, Annual Returns. Due date of Returns, Penalties & Interest to be paid, Payment by Challans.

·         ESI

Monthly Return, Challan payment, Due date of filing, Employees & Companies Covered, Share of Employees and Companies.

·         PF

Monthly Return, Challan payment, Due date of filing, Employees & Companies Covered, Share of Employees and Companies.

·         TDS

24Q, 26Q, Revised Returns, Downloading Form 16, Form 16A, Justification Report, Challan payment, Due date of payment of TDS and filing returns, TDS on various payments, Percentage TDS on Monthly Salary.

·         Income tax-Salary Return of all Online Return Filing

Form ITR-1 and ITR-2, Challan payment, Due date of filing returns, Deductions available under Chapter VI A : 80C, 80CCA, 80G etc

·      Official Correspondences

·      Online Correspondences

·      Mastering various deeds

·      Partnership deeds, Joint Venture Agreements

·      MOU

·      Gift deeds