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,1^st 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, 2^nd 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, 9^th 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 15^th 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, 16^th 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

RRC at Mahabaleshwar

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.

133nd STUDY COURSE ON AUDIT OF CO-OPERATIVE BANKS AND CO-OPERATIVE SOCIETIES

133nd STUDY COURSE ON AUDIT OF CO-OPERATIVE BANKS AND CO-OPERATIVE SOCIETIES
Arranged by Western India Regional Council of ICAI
Hosted by Kolhapur Branch of WIRC of ICAI
Day & Dates: Friday 3rd August & Saturday 4th August
Venue: Hotel Pearl, Kolhapur
Fees: Rs 1,500/-
CPE Credit: 12 Hours
Chief Co-ordinators:	CA. Durgesh Kabra, Chairman, WIRC   of ICAI
	CA. Dinesh Gandhi, Chairman, Cooperative Committee, (Maharashtra) of WIRC
	CA. Anil Jadhav, Chairman, Kolhapur Branch of WIRC of ICAI
	CA. Satish Dakare, Secretary, Kolhapur Branch of WIRC of ICAI
PROGRAMME STRUCTURE
Day: Friday 3rd August 2012
Time	Particulars	Speaker
11.00 to 12.30 pm	Common Accounting System for Primary Agricultural Societies	CA. D A Chougale
12.30 to 01.30 pm	System Audit/Auditing in Computerized Environment.	CA. P S Kulkarni
1.30 to 02.15	Lunch Break
02.15 to 3.15 pm	Accounting Standards as applicable to Co-operative Societies & Co-operative  Banks	CA. Mukund Bhave
03.15 to 3.30 pm	Tea Break
03.30 to 4.30 pm	Indirect Taxes- As applicable to Co-operative Societies & Banks.	Adv. Vinayak Gaikwad
04.30 to 05.30 pm	Various records , registers and documents to be maintained by the Cooperative Banks and Societies and duties and responsibilities of the directors and officers.	Adv. Abhijit Kapse
Day: Saturday 4th August 2012
10.00 to 11.30 am	Important Sections in MSC Act,1960 and important rules in MSC Rules,1961.	Adv. Shivajirao Chavan
11.30 to 01.00 pm	Advances including NPA Requirement & Income Recognition norms, provisioning	CA. Sunil Nagaonkar
1.00 to 01.45	Lunch Break
01.45 to 03.15 pm	Introduction to principles of  Co-operation, Types of Societies, Registration Procedure, Law & Management of Co-operative Societies	Eminent Faculty
03.15 to 04.15 pm	Audit reports & Audit Memos including special audits report under MCS Act, 1960 & MCS Rules, 1961.	CA. D S Patil
04.15 to 04.30 pm	Tea Break
04.30 to 05.30 pm	Direct taxes – Taxation of Co-operative Societies including deduction u/s 80P & concept of Mutuality, provisions of TDS and Section 269 SS and 269T.	CA. Sanjay Vhanbatte

Felicitation of President & Vice President

CA. Anil Jadhav, Kolhapur Branch Chairman welcoming President, CA Jaydeep Shah

CA. Mrs. Deepika Kumbhojkar welcoming Mrs. Harsha Jaydeep Shah

More Photos - Click here

TWO DAYS WORKSHOP ON ENABLING SERVICE TAX PRACTICE

PROGRAMME

FIRST DAY – 13.07.2012

 Time: 10.00 am to 05.00 pm

First Technical Session

Overview of Service Tax, Definition of Service,  Relevant basic concepts,   Selective vs Negative   approach, Declared Service

CA. Naresh Sheth, Mumbai

Second Technical Session

Negative List of Services [Section 66D], Exemptions of Services [Notification No. 12/2012-ST   Dated 17-3-2012], Other Exemptions

CA. Naresh Sheth, Mumbai

Third Technical Session

Charging Section [sec 66B], Person liable to pay Service Tax, Reverse Charge, Point of taxation Rules, 2011

CA. Ashit Shah, Mumbai           

Fourth Technical Session

Valuation of services, Abatement, Composition scheme, Taxable Territory,  Place of Provision of Service Rules, 2012

CA. Ashit Shah, Mumbai           

 SECOND DAY   – 14.07.2012

 Time: 10.00 am to 05.00 pm

                       

Fifth Technical Session

Cenvat credit rules as applicable to service providers

CA. Narendra Soni, Mumbai

Sixth Technical Session

Concept of Input Service Distributor

CA. Narendra Soni, Mumbai                

Seventh Technical Session

Service tax Registration, Service tax Payments, Issuance of Invoice, Maintenance of Records, Adjustment of excess payment of service tax

CA. Manish Gadia, Mumbai                

                          

Eighth Technical Session

Filling of Service Tax return, Rectification of Mistake, Interest  & Penalties,    Handling Service Tax Audit, Special Audit, Show Cause Notice

CA. Manish Gadia, Mumbai                

Registration Fees: Rs. 1,500/- (Inclusive of background material of Institute, breakfast & lunch for 2 days)

For Spot Registration: Rs. 200/- extra       

Cheque/ DD in favour of Kolhapur Branch of WIRC of ICAI and send to :

Kolhapur Branch of WIRC of The Institute of Chartered Accountants of India, 

Vardhaman Chambers, 2^nd Floor, Shahupuri, Kolhapur 416001. Ph : 0231 – 2665856

Email : kolhapur@icai.org, kopbr.icai@gmail.com 

Newsletter - July 2012

Newsletter July 2012 - Click Here

We don’t have to be a doctor to save a life. All that is needed is some kindness, which in turn can make a big difference in some one’s life. Yes, we can really be a savior for someone counting breaths. Give blood. Save life. Every minute of every day someone needs blood. That blood can only come from a volunteer donor like you. Your blood is special & will help save lives. 

Let’s make an attempt to gift a life to someone who is striving for it. The feeling of giving is different within itself, so why deprived from such a benevolent act. Give a thought..:). It’s a joy to give blood. Let’s experience it one more time, on 1st July 2012. Come and join us for a noble cause.

Donate Blood – Gift life.

Seminar on Reporting of UCB's

CA. S R Shah inaugurating the seminar.

CA Sunil Nagaonkar - "Camels Rating"

CA Prakash Kulkarni - "Audit through CBS" & "Applicability of AS to UCB's"

CA D A Chougule - "Important Aspects of Audit Report"

Camels Rating - Click Here
AS applicability to UCB's - Click Here
Bank Audit Through CBS - Click Here
Additional Slides - Click Here
List of Qualifications - Click Here
Customer Ledger - Click Here
Important Aspects of Audit of UCB's - Click Here

Workshop on Financial Reporting Practices

CA Atul Shah - Commonly observed non-complainces in financial statements 

CA. Mehul Shah - Issues in CARO

Background Material Click Here
PPT of CA Sanjeev Maheshwari Click Here
PPT of CA Lalit Bajaj Click Here
PPT of CA Atul Shah Click Here
PPT of CA Mehul Shah Click Here
Report Execution Click Here
Basic Checklist for Audit Staff Click Here

Newsletter - June 2012

Newsletter June 2012 - Click Here