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

TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack) | Udemy [Update 01/2024]
English | Size: 55 GB
Genre: eLearning

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

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. 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 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

DOWNLOAD FROM RAPIDGATOR

DOWNLOAD FROM TURBOBIT

DOWNLOAD FROM NITROFLARE

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment Cancel reply