Module 1 : Service Tax Registration
| Notification | Circulars | Black List | Exemption | Declared Services
| EOU (Export & Import) | SEZ | Tax Treatment | CENVAT | Valuation
| Work Contract Tax | RCM | PRCM | Calculations | Filings | Records |
Defaults| Remedies | Q&A Session Module 2 : VAT Registration
| Documentation | VAT | DVAT | HVAT | CST | Schedule | Rate | DVAT 04 |
Invoicing | Bill of Lading | | Challan | Calculation | Quarterly Return
| Online Submissions | Road Permit | CST Registration | C-Form |
Online | Returns | Composition WCT | Assessment | Tally Entries |
Calculations | Administration | Payments | Rules | Returns | Filing |
Claims | Inspections | Documentation | Defaults & Remedies | Q&A
Session | Discussion on GST Module 3 : Central Excise Central
Excise Registration | CETA | Tariff Valuation | Credit Rules @ CCR
-2004 | Monthly Return ER-1, ER-6, ER-4 | Annual Return ER-5 |
Registration RG-1, RG - 23A Part - I & II, RG 23 C Part-I & II |
Payment | Excise Entries Tally | Online Registration A1 | Payment GAR -
7 | Defaults & Remedies | Adjudication | Penalties | Power of
Commissioner | Q&A Session | Module 4 : Import & Exports Registration |
Compliance | Rules | Acts | Regulations | Schedules | Foreign Exchange |
Import & Export Procedures | Accounting Treatment | Tariff 2015-16
|Import Export Documentation | Formats | Forms | Notifications | Case
Law ECS | Circulars | Instructions | SEZ | Drawback Schedule | Payment
of Duty | Intellectual Property Rights (IPR) | Defaults | Penalties |
Adjudication | Discussion on FEMA | Legal Proceedings Module
5 : Financing & Funding Bank Financing Procedures Mortgage, Collateral & Security Cash Credit & Overdraft Term Loan Business, Home and Personal Loan Project Financing - Report & Procedure Credit Monitoring Arrangement (CMA) Credit Analysis Reports Stock Statement Loan Subsidies Module 6 : Negotiable Instruments Letter of Credit - Types & Procedure Bank Guarantee - Issue & Disposal Escrow NEFT / RTGS
Ratio Analysis Bank Reconciliation Statement Module 7 : TDS u / Income Tax Act PAN
| TAN | Documentation | Calculations | Digital Signature | Deduction
u/s 192 - 196 | Challan 281, 280 & 26 QB | TDS Return 24 Q & 26 Q
| Form 16 & 16 A | 26 AS | Foreign Remittance 15 CA & 15 CB |
Lower or No Deductions – Form 13 & 15G-H |Tally Entries Interest |
Penalty | Defaults | Legal Proceedings | Module 8 : Balance Sheet, Final A/cs & Financial Statements I-GAAP Accounting Standard Final Accounts Finalization of Balance Sheet for Corporate & Large Enterprises SME Accounting Revised Schedule III (Schedule VI of Companies Act 1956) Depreciation Schedule as per IT & Companies Act Depreciation Rate Comparison Inventory Control Bank Reconciliation Statement ROC Annual
Filings (23AC, 23ACA, 20B) Module 9 : Excel for Accounting V-lookup | H-lookup | If Logical Condition | Dynamic Pivot Tables & Charts | Sum | Count | Count Blank | Average | Max | Large Min | Abs | SumIf | CountIf | Lower | Conditional Formatting What If Analysis | Dated If | Match Index | Offset Function | User form Function in Excel | Data Validation | Advance Filter | Sorting | Group & Ungroup | Data split | Text Fx | Data Separation | Substitution Upper | Proper | Trim | Len | Left | Right | Mid | Concatenate | Subtotal | And | Or | Day and Time Calculation | Numeric Calculation || Day | Year | EO month | E date | Net Workdays | Today | Weekday | Week # | Workday | Find | Search Module 10 - Advanced Tally ERP 9 |