+91-9321593932 info@landdedutech.com
Online certificate course in Professional Accounting & Taxation

DIRECT TAX (TDS WITH RETURN FILING + INCOME TAX – ITR FILING)

DURATION : 36 HOURS

1. TDS - TAX DEDUCTED AT SOURCE (TDS ON SALARY & NON-SALARY BOTH COVERED WITH RETURN –

TDS OVERVIEW, SECTION COVERS UNDER THIS COURSE (SEC 192: TDS ON SALARY, SEC 194DA –PAYMENT – LIC POLICY, SEC 194E – NRI SPORTS, SEC 194H – TDS ON COMMISSION/BROKERAGE, SEC 194I – TDS ON RENT, SEC 194IB – RENT, SEC 194IA – RENT, SEC 194C – TDS ON CONTRACT,SEC 194J – TDS ON PROFESSIONAL OR TECHNICAL, DIRECTOR, ROYALITY, SEC 194M – PAYMENT BY INDIVIDUAL NOT COVERED UNDER SECTION 44AB, SEC 194B, SEC 194BB, TAN APPLICATION(PRACTICALLY COVER, FORM 49B) ONLINE, PAN APPLICATION (PRACTICALLY COVER, FORM 49A)ONLINE, ALL TRANSACTION/CASES OF TDS ENTRIES ON TALLY ERP 9, DEPOSIT TDS CHALLAN281,FORM (LIVE), TDS RETURN26Q PRACTICALLY: TDS RETURN FOR NON-SALARY ONLY, FORM 16A PRACTICALLY COVERED THROUGH TDSCPC WEBSITE), TDS CERTIFICATE FOR NON-SALARY ONLY, 26AS FORM VIEW TDS CREDIT, FORM 15G/15H, FORM 13 UNDERSTANDING, INTEREST & PENALTY CALCULATION, FAQ (QUESTION & ANSWER AS PER PRACTICAL EXPOSURE).

2. INCOME TAX- ITR FILING

Terminology OF INCOME TAX, INCOME TAX COMPUTATION, INCOME TAX CHALLAN, DEDUCTION UNDER INCOME TAX, CALCULATION / COMPUTATION OF INCOME UNDER SALARY, CALCULATION /COMPUTATION OF INCOME UNDER HOUSE PROPERTY, CALCULATION / COMPUTATION OF INCOME UNDER PGBP, CALCULATION / COMPUTATION OF INCOME UNDER OTHER SOURCE, FILING OF INCOMETAX RETURN (ITR- 1 & ITR- 4 ONLY), FAQ.

INDIRECT TAX: GST WITH E-FILING LIVE

DURATION: 7 HOURS

1. GST (GOODS & SERVCES TAX) - BASIC TO PROFESSIONAL LEVEL COMPLETE COVERAGE

Introduction to GST Structure, SUPPLY: MEANING & SCOPE , Time of Supply, Place of Supply, VALUATION, JOB WORK, COMPOSITION SCHEME, E–WAY BILL, RCM – REVERSE CHARGE MECHANISM,E– COMMERCE, EXEMPTION FROM GST, IMPORT/EXPORT UNDER GST, INPUT TAX CREDIT RULES (ITC), GST REGISTRATION (PRACTICALLY), TAX INVOICE, DEBIT, CREDIT NOTE, GST COMPUTATION, TALLY ERP 9 MAPING/ENTRIES, GST REFUND PROCESS, GST CHALLAN/PAYMENT(ONLINE), GST RETURNS PRACTICALLY (OFFLINE & ONLINE BOTH WAY)(GSTR-1, GSTR 2A, GSTR-3B, GSTR-4, CMP 08, GSTR 9, ANNUAL RETURN) ETC, FAQ (QUESTION & ANSWER AS PER PRACTICAL EXPOSURE). PRACTICE DATA WILL ALSO PROVIDE

TALLY ERP 9 with GST, TDS & Payroll

DURATION : 9` HOURS

Module 1.1 – Basic of Tally ERP 9

  • What is Tally
  • DOWNLAOD AND INSTALL TALLY
  • Overview of Software
  • Introducing Gateway and its elements
  • Creation of Company
  • Basics Of Accounting
  • Fundamentals of Tally ERP 9
  • Create Accounting Masters in Tally ERP 9
  • Accounting Vouchers
  •  Financial Statements and Accounting Books
    and Reports

Module 1.2 – Tally ERP 9 and Inventory Management

  • Creating Inventory Masters in Tally ERP 9
  • Inventory Vouchers
  • Generating Inventory Books and Reports
  • Introducing BOM – Bill of Materials
  •  Accounting with Inventory

Module 1.3.1 – Bill –Wise Details

  • Types of Bill can be created through Tally
  • Debit Note/Credit note through Tally
  • Accounting Memos

Module 1.3.2 – Accounting Ledgers Details

  • When to create ledger
  •  Information required while creating ledger
  • Grouping and sub grouping of Ledger
  • Importance of tax information in ledger

Module 1.3.4 – Voucher Classes

  • Sale Voucher
  • Purchases Voucher
  • Receipt
  • Payment
  • Journal Voucher
  • Others

Module 1.5 – TDS ENTRIES WITH RETURN ON TALLY

  • TDS Payable Computation and Reconciliation
  •  TDS Receivable Computation and
    Reconciliation
  • Payment of TDS
  •  Reporting on TDS Compliance

Module 1.6 – Payroll Management in Tally ERP 9

  •  Generation of Employee Database
  •  Salary Structure
  • Calculation Attendance and Leave Details
  •  Salary Slip Generation
  • PF, ESI, Gratuity Bonus
  • Professional Tax
  • Various Payroll Reports

TALLY ERP 9 AND GST COMPLIANCE

  • Upgrading to Tally.ERP 9 Release 6.0
  • Start Using Tally.ERP 9 for GST Compliance
  • Activating GST for Your Company
  •  Setting Up GST Rates
  • Updating Stock Items and Stock Groups for GST
    Compliance
  • Updating a Services Ledger for GST Compliance
  •  Updating Sales and Purchase Ledgers for GST
    Compliance
  • Updating Party GSTIN
  • Creating GST Ledgers
  •  Creating Income and Expense Ledgers
  • Recording Sales and Printing Invoices
  • Recording Purchases
  •  Recording a Tax Payment
  • Transferring Tax Credits of VAT, excise and
    services tax to GST
  •  Other Scenarios
  • Sales – Nil Rated, Exempt, SEZ, and Deemed
    Export
  • Recording Sales Returns
  • Recording Purchase Returns
  • Debit Note
  • Credit Note
  • Particulars (Computation Details)
  •  Summary of Exceptions
  • Table-wise GSTR-1
  •  Challan Reconciliation
  • Recording Export Sales
  • Reverse Charge under GST
  • Recording an Advance Receipt from
    Customer
  • Recording an Advance Payment to Supplier
  • Recording Journal Vouchers for Adjustments
    Against Tax Credit
  • Recording a Journal Voucher for TDS
    Adjustment
  • Recording a Journal Voucher for TCS
    Adjustment
  • Recording a Journal Voucher for Refund of
    Tax Credit
  • Recording a Journal Voucher for ISD Credit
  •  Recording a Journal Voucher for Transitional
    Credit
  •  Recording Journal Vouchers for Other
    Liabilities
  • Recording Journal Vouchers for Reversal of
    Tax Credit
  •  GSTR-1
  • Returns Summary
  • Status Reconciliation
  • Exporting GSTR
  • GSTR – 3B
  • Annual Retun

ADVANCE EXCEL & MIS COURSE

BASIC TO ADVANCE EXCEL & MIS

Introduction to Excel

Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions in Advanced Excel:-

Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function in Advanced Excel:-

Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation in Advanced Excel:-

Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text,Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color),Conditional Formatting, Data Validation, Group & Ungroup, Data split.

Statistical Function & Other Functions in Advanced Excel:-

Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions in Advanced Excel:-

And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions in Advanced Excel:-

VLookup, HLookup, XLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

Logical Functions in Advanced Excel:-

And, Or, If, Iferror, Not, Nested If

Power Pivot- MIS, Data Analysis & Visualization:-

Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display

Data Collection Method in Advanced Excel

With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis Single/Multidimensional Analysis in Advanced Excel

Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

Advanced Dashboard in Excel

Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot.

Visit Us

Laxmi Commercial Bldg, 6th floor, 605, 606 , next to SBI Life Insurance, flower market, next to Kamat Hotel, Near Railway station, Dadar West 400028

Call Us

+91-9321593932

Email Us

info@landdedutech.com