Tally.ERP9+TallyPrime+GST+IncomeTax+TDS+MS Excel (ComboPack)

A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Tax Professional, Auditors & Bsns Management Sectors

Ratings 4.41 / 5.00
Tally.ERP9+TallyPrime+GST+IncomeTax+TDS+MS Excel (ComboPack)

What You Will Learn!

  • TallyERP9 and TallyPrime
  • GST & GST Portal Concepts
  • Income Tax & TDS, TCS
  • Payroll Management
  • E-Way bill, E-Invoice, MS Excel
  • Tally - Introduction, History, Advantages
  • Costing of Tally
  • TallyERP9 - Download , Install , Activation
  • Golden Rules of Accounts
  • Tally ERP9 with GST - Course Material
  • Company-Creation, Alteration, Deletion & Securing
  • Understanding Tally Pre-defined Vouchers
  • Tally Data Processing Structure
  • Understanding Tally with Basic Illustrations
  • Recording & Maintaining Installments in Tally ERP9 I Bill-wise Accounts
  • Recording & Maintaining Supply against Advances - Advances Management
  • Tracking OverDue Supply - Credit Sales
  • Multi-Currency Accounting in Tally ERP9 & Adjustment Entries for Forex GainLoss
  • Cheque Book Configuration in Tally ERP9
  • Banking - Transaction Types
  • Post Dated Cheques Management in Tally ERP9 I PDC's
  • Bank Reconciliation Introduction
  • Bank Reconciliation in Tally ERP9 Practical I Case Study 1
  • Bank Reconciliation In in Tally ERP9 I Case Study 2
  • GST Revenue Sharing Ratios between Center & State Govt's
  • GST Classifications
  • Enabling GST Features in Tally ERP9
  • Recording GST Transactions SMART RECORDING METHOD
  • Recording GST Transactions TRADITIONAL METHOD
  • Recording GST Transactions - CaseStudy 2
  • GST Tax Invoice Configuration - Voucher Numbering
  • Recording GST Transaction with Auto-Billing
  • GST Tax Invoice, Bank Details-Cus Seal &Signature, Jurisdiction -Printing Confin
  • Rate Inclusive of GST I Enabling Item Description in Tally ERP9
  • Recording GST Transactions - Services
  • Recording GST Transactions - Assets I with Input Tax Credit I without ITC
  • Recording GST Transactions - Expenses with & without Input Tax Credit
  • Recording GST Transactions - Sales with Additional Expenditure
  • Genarate E-Way Bills Creation, Alter & Cancellation Online Offline methods
  • GST- Recording RCM in Tally ERP9
  • GST Overview Introduction
  • Key Points about GST Council
  • Introduction to GST Returns
  • GSTR - 3B Filing
  • GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Data
  • GST Registration - Live (Case Study 1)
  • GST Registration - Filing Clarifications
  • GST Registration - Tracking Submitted Applications
  • Viewing Submitted Applications - GST Registration
  • GST Registration - Core Filed Amendments
  • GST Registration - Non-Core Filed Amendments
  • GST Application for Refund
  • GST Registration -CANCELLATION
  • GST Tax Practitioner Registration
  • Opting Withdrawal of Composition Levy in GST Portal
  • What is TDS ( Tax deduction at source ) - How to calculate TDS - Introduction
  • How to Configure TDS in Tally ERP9 & Recordinng TDS Entries in Tally
  • Recording TDS Transaction in Tally ERP9
  • Purchase Returns & Sales Returns in Tally ERP9
  • Delivery Notes & Receipt Notes in Tally ERP9
  • Sales Orders Quotations in Tally ERP9
  • Tally ERP9 Discounts I Trade Discounts & Cash Discounts
  • PriceList's in Tally ERP9 I Party Level & Product Level
  • Auto-Interest Calculation on Overdue Installments
  • Basic of Manufacturing
  • Standard Manufacturing Practicals in Tally ERP9
  • Cost Centres in Tally ERP9 (Departments Handling)
  • Branch-Wise Accounts-Using Cost Centers & Godowns in Tally ERP9
  • Multi User Creation in Tally ERP9
  • Security , Password for Users in Tally ERP9
  • Tally Internal Data Verification & Tally Audit
  • Recording - Year End Adjustments in Tally ERP9
  • Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split
  • Payroll - in Tally ERP9 Introduction to Steps
  • Payroll-Complete Setup Monthly Process & Stop Computation - Overall Coverage
  • Budgets in Tally ERP9
  • Calculator Usage in Tally ERP9
  • Tally Data Backup & Restore
  • Alternate Units of Measurement in Tally ERP9
  • GSTR1 GSTR3B New Due Dates Late fee Updates (Feb-Mar-Apr-May) 2020
  • Batches Management (with Date of Manufacturing & Expiry )
  • Data Searching in Tally ERP9
  • DayBook Features in Tally ERP9
  • POS in Tally ERP9
  • Splitting in Tally ERP9
  • Part Numbers in Tally ERP9
  • Standard Rate Setup in Tally ERP9
  • Zero Valued Transactions
  • Export to Excel, JPEG, PDF, HTML
  • DATA Export & Import in Tally ERP9
  • Live Mailings from Tally ERP9
  • Tax Audit Due Date Extention
  • Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 bank
  • Reply to Students Request Know Your PAN Status
  • Budget 2020 I Highlights I Income Tax Slabs I New & Old I Benefits
  • 37th GST Council meeting I 2 major decisions I Relaxtion of Filing GSTR-9 &+more
  • Highlights of 38th GST Council Meeting
  • Microsoft Excel - Beginner to Advanced A Master Pro Course An Introduction to Microsoft Excel
  • How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells
  • MS Excel - Copy Cells, Move Cells
  • Learn How to Create Tabs, Groups and add Toll to it in MS Excel
  • MS Excel - Home Tab - Group Clipboard Features Functions Explained
  • MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
  • Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
  • MS Excel - Characteristics of Cell
  • Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
  • MS Excel - Fill Series - with formatting, without formatting & more
  • Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
  • Fill Series - Flash Fill
  • Excel - Editing Data I over writing I Go to I find & replace I undo & redo
  • MS Excel - Text to Columns
  • MS Excel - Comments - add, edit, delete & Show all
  • MS Excel - How to Hide and Unhide Rows, Columns, Sheets
  • Freeze Panes - Top Row, Columns & Multiple Rows & Columns
  • MS Excel - Filters - Learn How to Use Filter to analyse Big Data
  • MS Excel - Split Sheet Window
  • MS Excel - How to Insert & Delete Cells, Rows, Columns
  • MS Excel - Working with Sheets
  • MS Excel - Format Multiple Sheets at a time I Sheet Formatting
  • MS Excel - View Sheets Side by Side from One Excel File
  • MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
  • MS Excel - Sheet & Cells Protection
  • MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
  • Concatenate - Join Multiple Text Strings into ONE
  • MS Excel - Trim Functions - Remove unnecessary Elements from strings
  • MS Excel - Print Formulas Left, Right, Middle
  • MS Excel - Date Related Formulas
  • MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
  • MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
  • MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
  • MS Excel - Create & Remove Drop Down List
  • Introduction to Data Validation - Time limitation
  • Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
  • Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
  • Data Validation - Dependent - Multiple Drop Down Lists
  • MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
  • MS Excel - Import Data from Websites - Live Data
  • MS Excel - Import Data from Text Document - with Auto Refresh
  • MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
  • MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
  • MS Excel - Charts - Columnar, Bar, Line Charts
  • Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
  • Logical Test - IF Function
  • Logical Functions - Nested IF - Learn How to work with Nested if Formula
  • Logical Functions - AND function
  • Logical Function - Not & IFERROR
  • MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Mu
  • Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
  • MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
  • MS Excel - Consolidate ( 3d Sum extension)
  • Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
  • Formulas - sumproduct, mround, floor, ceiling
  • Index Formula - Find a Position of the Value, and Call cells references
  • Match Formula - Find Position of the Value
  • MS Excel - Age Calculator in Multiple Ways - Exclusive formula
  • StudentMark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
  • V Lookup - Introduction
  • V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  • H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  • X Lookup - Introduction
  • Download, Add & use X Lookup New Formula in MS Excel
  • X Lookup New Formula in MS Excel
  • Pivot Table Introduction & Basics of Pivot Table
  • Create a Pivot Chart from Table & Pivot Table
  • Pivot Table - Use slicers to filter data
  • Pivot Table, Charts, Progress Dashboard
  • MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
  • Working with Tables
  • Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
  • Share a workbook with Co Authors, Employees or with Anyone
  • Commission Calculation in MS Excel
  • Attendance Sheet Preparation in MS Excel
  • Salary Calculation with CA, DA, Commission, Advance, PF, ESI
  • Excel to SMS
  • Macros
  • VBA

Description

 Dear Students this is a bundle(combo pack) course covers following courses:

1. Basics of Accounting

2. TallyPrime

3. TallyPrime

4. GST & GST Portal Concepts (GST Master Course)

5. Incomes Tax(non-audit)

6. TDS & TCS

7. MS Excel

if you already purchased my individual course(classes) you will be re-purchasing them in this bundle course.

_________________________________________________________________

Course Highlights

  • Faculty : A Person who trains the trainers

  • Tally Authorized Institute Faculty

  • well known as TallyGuru & Office Expert

  • GSTN Recognized Tax Practitioner

  • All topics covered Course(Like-nothing left in tally)

  • Classes on Licensed Version Tally

  • Case-Studies Explained

  • Quiz for Each Individual Chapter

  • 100% Satisfactory results/Reviews

  • Reference Questions/Soft copy Material available

  • after these course Student can handle All Book of Accounts & GST

  • All GST Classes Based on Real-Time Data

  • Assignments

  • Quizzes

  • Practices Tests

  • Lectures-wise resources

_________________________________________________________________

Course Curriculum

_________________________________________________________________


Section-1: Basics of Commerce, Accounting

S1.1 What is Commerce

S1.2 What is Accounting & Why do we need it

S1.3 Double Entry Systems Step-Structure

S1.4 Golden Rules of Accounts

S1.5 Golden Rules of Accounting with Journals

S1.6 Fundamentals of Accounting

Section-2: Course Tips, Download Materials, Practice Notes

S2.1 Download Materials

S2.2 Learn How to watch & practice

Section-3: TallyPrime Basics

S3.1 Overview on Tally – History, Advantages, Releases

S3.2 Pricing of Tally Application – Modules of licenses

S3.3 Tally Rental License

S3.4 Download & Installation, Update TallyPrime

S3.5 Licensing options – Education mode, License from network and Activate New License

S3.6 Create your first company – Shut company, alter company and delete company, change default data saving path

S3.7 TallyPrime – pre-defined voucher an Introduction

S3.8 Recording simple purchases & Sales

S3.9 Recording Contra, receipt, payment vouchers

S3.10 Recording Journals in TallyPrime

S3.11 How to update opening balance for ledger, opening stock for items

S3.12 Group Company creation in TallyPrime

S3.13 TallyPrime DATA Recording Steps

Section-4: Billing in TallyPrime with GST

S4.1 What is GST-a short Introduction to GST

S4.2 GST Classifications and Place of Supply

S4.3 Recording GST Purchases & Sales – Traditional Method

S4.4 Recording GST with Auto Billing, Exclusive GST Ledgers for Input and Output

S4.5 Billing Configuration – Company Logo

S4.6 Billing Configuration – Additional Description for Stock items & Ledgers

S4.7 Billing Configuration – Enable Rate Inclusive of Taxes column

S4.8 Billing Configuration – Update Sales Voucher Numbering

S4.9 Printing Configuration – Invoice Status, Bank Details, Jurisdiction, Customer seal & Sign

S4.10 Optimize Paper Printing size

S4.11 Recording GST Services

S4.12 Recording GST Expenses Claimable and Non-claimable

S4.13 Recording GST Assets – claimable and non-claimable

Section-5: GST Filing, E-Invoice & E-waybill generations

S5.1 Understanding GST Returns & Types

S5.2 GST Tax Computation & Adjustments

S5.3 Learn GSTR-1 Tables

S5.4 GSTR-1 Filing using TallyPrime

S5.5 GSTR-1 Nil Filing

S5.6 GSTR-1 Amendments

S5.7 GSTR-2A Reconciliation

S5.8 GSTR-3B Filing – with Tax Payments

S5.9 GSTR-4 filing (Exclusive for Composition Tax Payers)

S5.10 E-Way bill Registration

S5.11 E-Way bill Generation, Update & Cancellation (in Portal)

S5.12 E-Invoice Introduction

S5.13 E-Invoice GSTIN Registration

S5.14 E-Invoice Enablement of GSTIN

S5.15 E-Invoice Generation (manual upload) in TallyPrime

S5.16 E-Invoice API logins creation on E-Invoice portal (to use API logins in Tally)

S5.17 Generate E-Invoice using Tally - Generate and E-Invoice, Print within Tally

S5.18 E-Invoice Generation Using Official Excel kit - Excel to JSON, JSON upload

Section-6: Inventory Management

S6. 1 Inventory Management - Introduction, Importance, Advantages

S6. 2 Introduction to additional supply vouchers

S6. 3 Activation of Purchase Order and Sales Order

S6. 4 Activation of Delivery & Receipt Notes

S6. 5 Activation of Debit & Credit Note

S6. 6 Purchases Management - Purchase Order, Receipt Note, Purchase, Purchase Returns

S6. 7 Sales Management - Sales Order, Delivery Note, Sales, Sales Returns

S6. 8 Activation of Batches for Stock Item

S6. 9 Allocation of Batch Details in Purchase Invoice

S6. 10 Selling of Stock Items from Batch and Identifying of Expired Batch in Sales

S6. 11 Returning of Expired Batch Stock Item

S6. 12 Activating Price Levels

S6. 13 Defining Price Levels, Creating Price List, Usage of Price List in Sale Voucher

S6. 14 Different Types of Inventory Valuations

S6. 15 Creation of Godown

S6. 16 How to Create and Manage Multiple Godowns in TallyPrime

S6. 17 How to Record Inter Godown Stock Transfer in TallyPrime

Section-7: Bill-wise accounts I Accounts Receivable & Payable Management

S7.1 Basic Illustration to Understand TallyPrime Vouchers

S7.2 Bills wise details for Purchases

S7.3 Bill-wise Details for Sales - Bills Receivable

S7.4 How to View and Analyze Bills Outstanding Reports in TallyPrime

S7.5 Bill-wise Accounts Supply Against Advances

S7.6 Bill-wise Accounts-Tracking Overdue Supplies

Section-8: TallyPrime with Banking

S8.1 Cheque Book Configuration in TallyPrime

S8.2 Cheque Printing in TallyPrime

S8.3 Enabling All-Banking Transaction Types

S8.4 An Introduction to Post Dated Cheques Management

S8.5 Post Dated Cheques Management in TallyPrime

S8.6 Applying for TallyPrime License

S8.7 Introduction to Bank Reconciliation Process in TallyPrime

S8.8 Bank Reconciliation in TallyPrime

S8.9 How to Do Auto Bank Reconciliation

and more.


Who Should Attend!

  • Course designed for all categories
  • Commerce Students
  • B Com, M Com MBA, CA, CS, CMA and Professionals
  • Accounting Professionals
  • Jr. and Sr., Accounts Executives and all kind of accounts dept employees

TAKE THIS COURSE

Tags

  • Excel
  • TallyPrime (Tally.ERP)
  • Goods and Services Tax

Subscribers

19776

Lectures

349

TAKE THIS COURSE



Related Courses