TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack)

A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Tax Professional, Auditors n Bsns Management sectors

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

Requirements
a desire to learn new skills

Description
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 Accounting2. TallyPrime3. TallPrime - All Levels4. GST & GST Portal Concepts (GST Master Course)5. Incomes Tax(non-audit)6. TDS & TCS 7. Payroll Management7. MS Excel if you already purchased my individual course(classes) you will be re-purchasing them in this bundle course. _________________________________________________________________Course HighlightsFaculty : A Person who trains the trainersTally Authorized Institute Facultywell known as TallyGuru & Office ExpertGSTN Recognized Tax PractitionerAll topics covered Course(Like-nothing left in tally)Classes on Licensed Version TallyCase-Studies ExplainedQuiz for Each Individual Chapter100% Satisfactory results/ReviewsReference Questions/Soft copy Material availableafter these course Student can handle All Book of Accounts & GSTAll GST Classes Based on Real-Time DataAssignmentsQuizzesPractices TestsLectures-wise resources_________________________________________________________________Course Curriculum _________________________________________________________________Section-1: Basics of Commerce, AccountingS1.1 What is CommerceS1.2 What is Accounting & Why do we need itS1.3 Double Entry Systems Step-StructureS1.4 Golden Rules of AccountsS1.5 Golden Rules of Accounting with JournalsS1.6 Fundamentals of AccountingSection-2: Course Tips, Download Materials, Practice NotesS2.1 Download MaterialsS2.2 Learn How to watch & practiceSection-3: TallyPrime BasicsS3.1 Overview on Tally – History, Advantages, ReleasesS3.2 Pricing of Tally Application – Modules of licensesS3.3 Tally Rental LicenseS3.4 Download & Installation, Update TallyPrimeS3.5 Licensing options – Education mode, License from network and Activate New LicenseS3.6 Create your first company – Shut company, alter company and delete company, change default data saving pathS3.7 TallyPrime – pre-defined voucher an IntroductionS3.8 Recording simple purchases & SalesS3.9 Recording Contra, receipt, payment vouchersS3.10 Recording Journals in TallyPrimeS3.11 How to update opening balance for ledger, opening stock for itemsS3.12 Group Company creation in TallyPrimeS3.13 TallyPrime DATA Recording StepsSection-4: Billing in TallyPrime with GSTS4.1 What is GST-a short Introduction to GSTS4.2 GST Classifications and Place of SupplyS4.3 Recording GST Purchases & Sales – Traditional MethodS4.4 Recording GST with Auto Billing, Exclusive GST Ledgers for Input and OutputS4.5 Billing Configuration – Company LogoS4.6 Billing Configuration – Additional Description for Stock items & LedgersS4.7 Billing Configuration – Enable Rate Inclusive of Taxes columnS4.8 Billing Configuration – Update Sales Voucher NumberingS4.9 Printing Configuration – Invoice Status, Bank Details, Jurisdiction, Customer seal & SignS4.10 Optimize Paper Printing sizeS4.11 Recording GST ServicesS4.12 Recording GST Expenses Claimable and Non-claimableS4.13 Recording GST Assets – claimable and non-claimableSection-5: GST Filing, E-Invoice & E-waybill generationsS5.1 Understanding GST Returns & TypesS5.2 GST Tax Computation & AdjustmentsS5.3 Learn GSTR-1 TablesS5.4 GSTR-1 Filing using TallyPrimeS5.5 GSTR-1 Nil FilingS5.6 GSTR-1 AmendmentsS5.7 GSTR-2A ReconciliationS5.8 GSTR-3B Filing – with Tax PaymentsS5.9 GSTR-4 filing (Exclusive for Composition Tax Payers)S5.10 E-Way bill RegistrationS5.11 E-Way bill Generation, Update & Cancellation (in Portal)S5.12 E-Invoice IntroductionS5.13 E-Invoice GSTIN RegistrationS5.14 E-Invoice Enablement of GSTINS5.15 E-Invoice Generation (manual upload) in TallyPrimeS5.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 TallyS5.18 E-Invoice Generation Using Official Excel kit - Excel to JSON, JSON uploadSection-6: Inventory ManagementS6. 1 Inventory Management - Introduction, Importance, AdvantagesS6. 2 Introduction to additional supply vouchersS6. 3 Activation of Purchase Order and Sales OrderS6. 4 Activation of Delivery & Receipt NotesS6. 5 Activation of Debit & Credit NoteS6. 6 Purchases Management - Purchase Order, Receipt Note, Purchase, Purchase ReturnsS6. 7 Sales Management - Sales Order, Delivery Note, Sales, Sales ReturnsS6. 8 Activation of Batches for Stock ItemS6. 9 Allocation of Batch Details in Purchase InvoiceS6. 10 Selling of Stock Items from Batch and Identifying of Expired Batch in SalesS6. 11 Returning of Expired Batch Stock ItemS6. 12 Activating Price LevelsS6. 13 Defining Price Levels, Creating Price List, Usage of Price List in Sale VoucherS6. 14 Different Types of Inventory ValuationsS6. 15 Creation of GodownS6. 16 How to Create and Manage Multiple Godowns in TallyPrimeS6. 17 How to Record Inter Godown Stock Transfer in TallyPrimeSection-7: Bill-wise accounts I Accounts Receivable & Payable ManagementS7.1 Basic Illustration to Understand TallyPrime VouchersS7.2 Bills wise details for PurchasesS7.3 Bill-wise Details for Sales - Bills ReceivableS7.4 How to View and Analyze Bills Outstanding Reports in TallyPrimeS7.5 Bill-wise Accounts Supply Against AdvancesS7.6 Bill-wise Accounts-Tracking Overdue SuppliesSection-8: TallyPrime with BankingS8.1 Cheque Book Configuration in TallyPrimeS8.2 Cheque Printing in TallyPrimeS8.3 Enabling All-Banking Transaction TypesS8.4 An Introduction to Post Dated Cheques ManagementS8.5 Post Dated Cheques Management in TallyPrimeS8.6 Applying for TallyPrime LicenseS8.7 Introduction to Bank Reconciliation Process in TallyPrimeS8.8 Bank Reconciliation in TallyPrimeS8.9 How to Do Auto Bank Reconciliationand more.

Who this course is for:
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