TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack)
Offered By: Udemy
Course Description
Overview
What you'll learn:
- Basics of Accounting, TallyPrime All Levels
- GST & GST Portal Concepts
- Income Tax & TDS, TCS
- Payroll Management
- E-Way bill, E-Invoice, MS Excel
- MS Excel
- Capital Gains
- TallyPrime - Download , Install , Activation
- Golden Rules of Accounts
- Tally Prime 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
Unlock Your Potential with Our Ultimate Accounting Mastery Bundle!
Are you ready to take your accounting career to the next level? Look no further! Our comprehensive bundle course is designed to equip you with all the essential skills and knowledge needed to excel in the dynamic world of finance and accounting.
1. Basics of Accounting
2. TallyPrime
3. TallPrime - All Levels
4. GST & GST Portal Concepts (GST Master Course)
5. Incomes Tax(non-audit)
6. TDS& TCS
7. Payroll Management
7. MSExcel
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.
Taught by
Urs Ravi I Vedanta Educational Academy
Related Courses
Personal FinanceChaffey College via California Community Colleges System US/CA Income Tax Preparation
Chaffey College via California Community Colleges System ADVANCED TAX ACCOUNTING I
Foothill College via California Community Colleges System TAX ACCOUNTING
Foothill College via California Community Colleges System Accounting
Indiana University via edX