If you wish to receive emails/sms from Kolhapur Branch, please write your contact details to kopbr.icai@gmail.com

Friday, December 14, 2012

Annual Sports Day


Dear Member,

We are pleased to inform you that the Annual Sports Day is scheduled on 22nd & 23rd December 2012 the details of which are as under.

Annual Sports Day

Cricket, Chess, Badminton & Table Tennis Matches for Members & Students.

Date -              December 22 & 23, 2012

Time -               08.30 a.m. onwards

Contribution - Rs. 100/- per game (students Rs.50/- per game)

Cricket matches will be held on 22nd & 23rd December. 

The number of teams for cricket is restricted & teams enrolling earlier will be given preference. 

Indoor games will be held on 22nd December.

All the interested members & students are requested to enrol their names/teams before 20 December 2012 at branch office.


Thanking you,

Yours faithfully,

CA Satish S Dakare
Secretary

Tuesday, December 4, 2012

Seminar on MVAT Audit

CA. Umesh Sharma - Faculty





Material
Principal issues in MVAT Audit Click Here
Practical issues in MVAT Audit Click Here

Wednesday, November 21, 2012

Mahabaleshwar RRC

Material of CA Dilip Phadke 
Issues in VAT Audit - Click here
Notes on Taxation of Builders - Click Here

Tuesday, November 20, 2012

Workshop on Advanced Excel


Dates: 1, 2, 9, 15 & 16 December 2012                         CPE: 30 hrs
Venue: SIBER, Univeristy Road, Kolhapur                                
Fees (Incl lunch): Rs. 3,000/- (for members)

Workshop 1 ( Saturday,1st December 2012)

Objective

§  Learn New features of Excel 2010
§  Acquaintance with Excel Interface
§  Basic Functions

Overview of the Basics

·         Introduction with new Excel interface
·         Default settings of Excel
·         Introduction to Ribbon
·         Quick Access Toolbar
·         Contextual Tabs
·         Ribbon Customization

Formula and Functions

·         Text Functions
·         Cell Referencing
·         Logical Functions

Workshop 2 (Sunday, 2nd December 2012)

Objective

§  Validating data
§  Advanced Functions

Formula and Functions

·         Data Validation
·         Lookup Functions (Vlookup, Hlookup, Index, Match etc.)
·         Sumif, Countif, Sumproduct and Averageif
·         Statistical and Financial Functions

Workshop 3 (Sunday, 9th December 2012)

Objective

§  Protect Sheets and Workbook
§  Sorting and Filtering data
§  Working with tables

Sharing and Protection

·         Sharing and Protection
·         Introduction to Tables

Sorting and Filtering

·         Single and Multiple level Sorting, Custom Sorting
·         Advance Filters
·         Single and Multiple level Subtotals including grouping

Working with styles

·         Conditional Formatting

Workshop 4 (Saturday 15th December 2012)

Objective

§  Pivot tables
§  Consolidation
§  Analysis

Pivot tables

·         Pivot Table
·         Power Pivot

Consolidation

·         Consolidation

What if Analysis

·         What if Analysis and Scenario Manager

Workshop 5 (Sunday, 16th December 2012)

Objective

§  Presenting data visually
§  Automating tasks with macros

Presenting data

·         Charts and Dashboards
§  Column Chart 2D and 3D
§  Bar Charts
§  Stacked Column Charts
§  Line Chart
§  Line and Column Chart (Limitation of primary axis)
§  Pie Chart
§  Limitations of Pie Chart (Doughnut Chart)
§  Pie Chart with developer tools
§  Thermometer Chart
§  Scroll Chart

Macros

·         Macro (Recording, Editing and Basic Formulas)
§  Recording Macro
§  Limitation of recording macro
§  Recording Macro with Relative reference
§  Editing Macro
§  Executing Macro in different ways
§  Introduction to VBA window
§  Creating Basic Functions in VBA

Saturday, October 20, 2012

RESIDENTIAL REFRESHER CONFERENCE (RRC) 2012
HOSTED BY :- PUNE BRANCH OF WIRC OF ICAI
JOINTLY WITH :- NAGPUR, PIMPRI CHINCHWAD, KOLHAPUR BRANCHES & SATARA CHAPTER OF WIRC OF ICAI
 ON 2ND, 3RD & 4TH NOVEMBER, 2012
TENTATIVE TABLE PLAN


CPE: 15 Hrs
Fees: Rs. 4500/-


DAY - 1 (2ND NOV, 12)

REGISTRATION & BREAKFAST

INAUGURAL SESSION
30 MINS




SR. NO.
TOPIC
SPEAKER
TIME DURATION
1ST TECHNICAL SESSION

1
Recent Landmark Judgements
CA. Mandar Vaidya
1.30 HRS.

LUNCH BREAK

2ND TECHNICAL SESSION

2
Service Tax - Negative List & Reverse Charge
CA. Naresh Sheth
2 Hrs.

TEA BREAK

3RD TECHNICAL SESSION

3
How to make practice remunerative - Panel Discussion
CA. Atul Bheda, Group Leader
1.30 HRS.

DAY - 2 (3RD NOV, 12)

BREAKFAST

4TH TECHNICAL SESSION

4
Automation & CA Office
CA. Pankaj Deshpande
1.30 HRS.

5TH TECHNICAL SESSION

5
Company Amendment Bill
CS. Vinayak Khanvalkar, Past President, ICSI
1.30 HRS.

LUNCH BREAK

6TH TECHNICAL SESSION

6
Domestic Tranfer Pricing / Internatioal Transfer Pricing
CA. Mahesh Sarda
1.30 HRS.

7TH TECHNICAL SESSION

7
Mock Tribunal
CA. Neelesh Khandelwal
1.30 HRS.
CA. C. D. Upasani
CA. Singh
CA. C. V. Chitale

DAY - 3 (4TH NOV, 12)

BREAKFAST

8TH TECHNICAL SESSION

8
Scrutiny Asst. & Appeals
CA. Jayant Gokhale
1.30 HRS.

9TH TECHNICAL SESSION

9
Vat Audit
CA. Dilip Phadke
1.30 HRS.

LUNCH BREAK

10TH TECHNICAL SESSION

10
Penalties under Income Tax Act
Eminent Faculty
1.00 HRS.