CPA自述在会计师事务所的日子(一)

July 6, 2007 by royandy

http://www.renmi.com/group/?gid=68

    当我赶到汪漾定下的中环广场底楼的咖啡厅时,汪漾已为自己买好了带气的矿泉水,
坐在那里静静地等我。她穿着深蓝细白条的短袖职业装,左手边,小巧的手机下垫着绣花
的手机套,感觉上她是个井井有条的女人,好像很适合做CPA。

    “我是CPA。”汪漾的声音清脆而细腻,但我感到柔中有刚。

    这是我对她——普华永道中天会计师事务所高级审计员汪漾的第一印象。

    名校毕业生走进普华永道

    从复旦大学毕业前,汪漾根本就没想到她今后的职业生涯是和注册会计师联系在一起
的。那是大四临近毕业的时候,普华永道中天会计师事务所像许多外企公司一样来到复旦
大学开讲座,毕业生都不会放弃任何一个可能的机会,汪漾也一样。这一听不要紧,汪漾
被它所呈现的职业前景迷住了。

    汪漾在大学念的是化学,但她似乎并不非常喜欢纯理科,四年中她已渐渐明确了方向
,“从商”成了她的目标。普华永道的报告会深深触动了她,再加上作为国际著名的五大
会计师事务所之一,普华永道卓越的声誉以及良好的培训制度都使汪漾辗转反侧。

    汪漾如愿以偿地来到普华永道后立刻就发现她这样原先念理工科的人并不少,这里似
乎并不像本土的会计师事务所那样重视会计学专业背景。汪漾上班的第一天,公司就有条
不紊地为他们安排了培训,在长达2个月的培训中汪漾不仅充分了解了会计学的基本概念,
而且也全方位了解了公司的各个部门和业务情况,也就是从这个时刻起,汪漾开始准备CP
A的考试,公司也适时地给予员工一些支持,为参加考试的同仁做些适应性训练,出模拟考
试题,帮助他们顺利取得注册会计师的资格。

    相比之下在本土会计师事务所里,专业背景就显得比较重要一些,也许是那里没有如
此良好的培训条件吧,面对发展迅速的市场,他们需要的是更努力、更快捷地开创自己的
品牌,急速地盼望着一个会计师成熟起来,而不是胸有成竹地栽培他。

    汪漾称她是沾了名校的光,上海普华永道每年的招聘会只在复旦大学、上海交通大学
和上海财经大学中进行:理工科的人通常会对数字有特别的敏感,对英语和计算机的掌握
和运用这些基本功应该非常扎实——就群体而言,名校学生总是胜人一筹的!

    情商比专业知识更重要

    普华永道中天会计师事务所的审计部和其它外资的会计师事务所一样主要从事法定审
计、对上市公司季报、中报、年报的审核、企业的收购与合并、企业的内部审计、企业的
合规性操作等项目,行业不同,审计的侧重点也就不同。汪漾说:“也许是我比较幸运的
吧,这几年我差不多把审计部门所做的项目都过了一遍。”

    经过2个月的培训后,汪漾便随着同事一起去沈阳的一家大型国企,第一次参与正式的
审计工作,而且又是要到远离上海的东北,这对刚走出校门的学生来说特别的兴奋,但在
沈阳一个多月的时间里,她除了下榻的宾馆就是工作的工厂,两点一直线,比在上海还要
枯燥。等审计做完了,人差不多累得要趴下,当初公私兼顾的玩心也不知在什么时候走远
了,就这样,连对城市的大概都说不上来,又走回了上海。

    普华永道的客户大多是与海外普华永道有过合作的跨国公司、国内的超大型上市公司
、金融机构,他们的财务管理也会是庞大的,审计工作通常是以小组的形式进行。汪漾如
今是普华永道会计师事务所的高级审计员,时常会带领着一个小组到客户那里协助他们做
好审计工作,除了用眼睛看,还要能不断地向客户提出问题并解答他们的问题,协助他们
将财务管理规范化,这已不是我们传统意义上国家政府机构去管辖的公司查帐纠错的概念
了,它是服务性行业。

    在服务性行业工作的人,他的能力是在服务被认可的过程中体现的。汪漾说小组成员
一起工作,团队精神非常重要;和客户打交道,沟通能力越强就越容易完满地完成工作;
相处能力则是两个能力之上的更重要的一点。

    在事务所内部,每年都对员工进行一年的业绩评估,评估结果不理想的人一般是态度
不够好、不很负责任,或者就是悟性不够。排除对薪酬不满或者职位升迁的问题,从事务
所流失出去的人多半不是智商问题而是情商不够高。(待续)

四大的生活

July 6, 2007 by royandy

newcomer 发言于2007-06-27 15:36:34

http://www.renmi.com/group/topic.php?tid=10934

最近一直没有时间呆在公司,只在每周一清早会回在公司开个短暂的next job meeting
,随即便紧紧张张的出发。其间也看到很多ddmm穿得很professional的坐在reception那
里等候面试,不知道他们看到我们这样忙来忙去的时候心情是怎样的。公司的人很多,
可是办公条件很差,办公桌椅严重紧缺,只有manager才有自己的位置。有一次礼拜一回
公司开完meeting,在走之前想坐下来喝杯水,却找不到位置坐,只好坐在reception那
儿的沙发上,旁边等候面试的dd看着我也不知是搞笑还是好奇的表情…

出job的时候,时常会碰到客户的财务经理或总监是原来在四大作audit的。昨天客户的
财务总监还跟我们闲聊叙旧,谈她自己当初在我们公司的情形。她说,四大的确是非常
不错的career start,但是也要看你的忍耐力是不是够强了。我和在场的senior们,带着
疲倦的面容,心中都是百味杂陈。

诚然,很多工作,都只是终日坐在一个固定的办公桌前,对着固定的同事和类似的客户
,做着每天差不多的不多不少的那么些活儿,聊着每天不怎么变得那些话题。这样看来
,四大的工作真的并不枯燥,总是新鲜的令人振奋的。每一两个礼拜差不多就换一个客
户,去一个陌生的企业,感受全新的环境,认识不同的人,解决不同的问题,当然还有

享受不同的待遇,有时是冷漠的接待,有时是笑里藏刀的挑战,午餐有时是冷冰冰的残
羹冷炙,有时是硬梆梆的德国汉堡,也有时是美味的泰国炒饭。job team的成员,总是
随着job在变,每次都会和不同的同事共事,有的热情,有的冷漠,有的单纯,有的阴深
,有的自私自利,有的乐于助人,有的高高在上,有的平易近人,有的严肃认真,有的
捣捣浆糊。这样的工作,可以在很快的时间里给你带来很丰富的阅历,也极能锻炼你的适
应能力和吃苦耐劳的精神。短短一两年,就能比过别人工作五六年。看上去还是年轻的
小伙子小丫头,都已不再稚嫩,都已和无数年纪比自己大一倍的老辣江湖打过交道,都
已经历过不少困难和艰辛。

谁都知道,在这样的职业上历练几年,会使自己得到很大的受益。但谁都不确定自己能
坚持下去。就好像看到一个很好吃的果子鲜嫩的在前方诱惑你,但是要爬完面前的这一
片荆棘地。同做job的senior,一次艰苦的长途出差回来,胃病发了,仍旧拖着脆弱的身
体,面黄肌瘦的做着,忍受着客户食堂里垃圾一样的午餐,每日下午以自带的饼干充饥。
有的senior,身体有伤了,工作却不能延误,仍旧要带着伤病,赶飞机,赶job,再赶飞
机,赶job。即便是身体健康的正常人,也会觉得忍受不了长时间的高强度工作。每天都
像拉紧的弦,有做不完的事。客户一年的乱账,几年的复杂,我们都得在短短几天里搞
得清清楚楚。常常会觉得脑子已经再也想不了这些错综复杂的事情,要爆炸了一样。所
有人,每天一边惶恐自己撑不下去了,一边告诉自己还有这么多人都能做得下去,
为什么我不可以?于是一晃眼,一个peak season就过去。就像我只睡了三个小时之后,
以为自己第二天会撑不住,可到了第二天,没有时间体味疲倦,又马不停蹄的做,
转眼间一天辛苦又过去,庆幸自己捱过来了。就这样,一天一天熬下去。盼到slack
season到来,就好好把握这短暂的休闲,等待下一个peak season.

Life in Big Four

July 6, 2007 by royandy

 http://chutki19.spaces.live.com/Blog/cns!4455335321E86A2A!344.entry

For pursuing CA articleship, we have a variety of CA firms all over India offering training to students. But getting in one of the big four is a dream come true. Yeah… the big 4 – Deloitte, E&Y, KPMG & PWC. You have to be an all India rank holder, or have a strong recommendation, or crack their toughest interview, provided they have vacancy for Article Assistants (AA) ! 

Most of the ppl in this profession believe that its better to pursue one’s articleship in a medium sized firm as such firms provide experience in various kinds of audits and one gets time to prepare for his/her final papers too.  

Recently, a close friend, who is employed in one of those big 4 at blore, shared his experience with me. Neither did he have a strong recommendation nor a rank. (v all expected a rank from him though! ) yessss.. He managed to crack the interview. 

Delighted coz deloitted?? LETS CHECK OUT!!!!

THE EDGE

These firms have the audits of giant MNCs and transnational org. A person employed there gets to do one thing at a time but he gets a thorough understanding of what he does rather than getting confused by doing different kind of work at its different stages of completion. The work is systematic and very well organized. They have their own customized audit software which helps to maintain the standard of work done. Every single person employed there, may it be a qualified CA or an article assistant is provided with a laptop so that work doesn’t get delayed waiting for client’s computer to be available and secrecy can be maintained. The work done is also protected from unwanted modifications by unauthorized ppl. The stipend is pretty good. At the end of the month when ur bank account is credited with a few thousands, u don’t mind getting exploited royally by ur employer in the coming month. 

DRAWBACKS

In such firms, the no: of qualified chartered accountants outnumber article assistants and even a rank holder is underestimated by them. They are hardly given any chance to prove themselves better than the qualified ones. Moreover the work goes on 24X7 (laptop being the disadvantage here). Once you are sent for outstation audit, there is no way to attend the morn classes that u managed to attend. Getting leave sanctioned is out of question. A few days before the last date for submitting CCs, they realise that thier main purpose is to clear the final papers which cannot happen unless they are certified eligible for it. and then the hunt for their friends’  already valued CCs begins….

OUTSTATION ASSIGNMENTS

When there is an outstation audit, the routine of a normal article assistant goes like this:  he gets up in an ordinary hostel room, has his tea from a nearby shop, borrows branded bags from his friends, stuffs the best of his clothes in those borrowed bags, takes his laptop,  takes a rick to airport, travels in the best airline, finds clients car waiting for him at the airport, stays in city’s best hotel, goes to clients ‘s place, switches on his laptop, works day and night  to complete the work b4 deadline, later dropped to the airport, returns by the best airline, takes a rick back to hostel, returns his friends’ bags and sleeps in the same old hostel room.  

JOBLESS

Yes there are times when the AAs in Big 4s remain unassigned for a long time. And this is the time when the lessons in info tech that we learn (rather mug up) during PE2 find their practical use. Yes,  They are busy adjusting page setup, taking print outs, Xerox copies etc etc. All the file closure work of their seniors flows to them which they keep doing as long as they remain unassigned.  

FRIENDS..

 If any of you have friends who also happen to be big 4 articles, You can forget them for a period of 3 years, or compromise ur sleep to meet them early in the morn or have lunch with them at the time specified by them. and if u happen to be AA in a medium sized firm, then the added disadvantage is that there are 110% chances of argument taking place as to whose workplace is better. 

Top 10 tips for life at the Big Four

July 6, 2007 by royandy

Some hints for those headed to or considering professional services firms. Before you read this, please be warned that I have only spent a handful of months as a summer intern at one of the Big Four, and probably can抰 provide the quintessential list of tips or things to do to land the partnership before turning 30. But, what I can tell you is what I have witnessed in my professional work experience and how I was able to make time, and hopefully my future time, at a large public accounting firm both enriching and fun.

10. Be flexible. As the intern or first year full-time analyst/consultant/staff accountant at one of the Big Four you are at the bottom of the corporate 搕otem pole? You are there to support your seniors, managers and others in getting the final product to the client. There are times when you will have five things on your plate at once and people will still be swinging by your desk asking for your assistance with additional work. You have to be able to manage the workload and be able to switch from one project to the next when asked to do so.   

9. Work hard. Throughout your young life you have heard time and time again you only get what you want with hard work and at the Big Four, it is no different. Hard work will get you a lot further than trying to be the smartest person in the room. So when you start, keep to yourself your ambitions for partnership or leaving the firm for industry and sit down and do your assigned work as well as you can.

8. Have a positive attitude. Simply put, at Schulich you have done about a gazillion group projects and you know that the people you would work with again are the ones that not only got their work done on time, but that made the experience enjoyable.
 
7. Be friendly. Having a friendly disposition is key at any of the Big Four. On client engagements you will be spending a lot of the time with a small group of coworkers and being on friendly terms with all of them will make the work experience that much more enjoyable and enriching.

6. Ask questions. The Big Four all have similar programs where there are one or two individuals, usually at or close to your own level, that are designated to answer any questions you may have when you start working: so why not ask?

5. Be strategic. We all know that networking is vital to getting into one of the Big Four, but it does not end there. In each firm there are different functions and within each of these functions there are different industry groups. For example, in my summer experience I was part of the Tax practice in the Mergers and Acquisitions Group that focused on Financial Services Clients. However, because my coach and the managers I first worked for focused largely on private equity clients, I found that most of my work for the entire summer was for private equity firms. If there is a certain type of client you want to be working on or if you want to experience or develop in a different part of the firm抯 practice, you need to let your managers be aware of it.

4. Never act like you are above menial work. There is a lot of work to be done at large public accounting firms and some of it includes filing, organizing and other such administrative tasks. As a junior you may be asked on occasion to do such work. While it is not challenging or very interesting, it is still important to put in your best effort into it and not complain.

3. Establish a balance. While your workload as a junior or summer intern may not be that heavy, it is still important to begin to develop how you will achieve a work-life balance for yourself as a professional accountant. Inquire about your wellness subsidies or allowances at your firm and how you can use them, as well as gyms and other athletic centers near the office. As well, most large firms also offer fully paid wellness and personal days for their employees to use at their own discretion, so learn to use them.

2. Never say NO! This advice is particularly important in functions such as tax or financial advisory where you are not staffed on engagements, but simply asked by a senior or manager to do some work for a client. You may find yourself working on several projects for different clients at once with similar due dates. While you may feel that if you take on the extra work you will be stretching yourself far too thin, never say No. Usually, if you show that you are willing to do the work and fit it into your schedule, the manager or partner will try to help you in getting the work done.

1. Be professional. You are working for a professional services firm, so be professional. Make the effort to look and act presentable even if you are not seeing a client that day. Even as a junior accountant you are not far away from being a pedigree professional ?so act like one.

CPAs Leave the Big Four for Better Life

July 5, 2007 by royandy

May 5, 2005 (Associated Press) — Fresh out of Georgetown University in 2001, accountant Monica DiCenso was assigned by PricewaterhouseCoopers LLP to advertising firm Interpublic Group of Cos., which was about to restate five years of financial results.



For weeks at a stretch, she worked seven days a week, often eating sushi at her cubicle as she headed into evenings of more number-crunching. Promoted quickly, she soon supervised three other young auditors.

Late last year, Ms. DiCenso quit the accounting firm, frustrated that her annual bonus in effect rewarded her overtime at a rate of less than half the minimum wage. She now is a Wall Street securities researcher.

She became a statistic that the Big Four accounting firms aren’t happy about: another of the experienced young accountants who have fled the profession even as they may never be more needed.

The workload of the big accounting firms has jumped in the past several years, as companies ramp up the scope of audit work to better ensure that accounting scandal stays far from their doorsteps.

The Big Four accounting firms also face extra work created by the 2002 Sarbanes-Oxley securities-overhaul act, passed in the wake of the blowups at Enron Corp. and WorldCom (now MCI Inc.). At the same time, the pressure to get the job done right also comes from within: Faced with mounting litigation from the accounting debacles of earlier this decade, the Big Four can’t afford many more mistakes.

Junior auditors, with three to five years’ experience, long have done much of the grunt work in auditing publicly traded companies. They have always had the highest turnover at accounting firms – as many as one in four quits annually at PricewaterhouseCoopers, according to a recent study it commissioned. Overall, nearly one in five accountants at large CPA firms left in 2003, up from 17 percent in 2002, according to the American Institute of Certified Public Accountants. The AICPA expects that trend to continue this year.

To combat the problem, the Big Four are trying to move from a culture of overloading and underpaying youngsters to nurturing and better rewarding them.

They are hiring larger numbers of them, and offering bigger bonuses, more vacation and special referral fees. Ernst & Young LLP has started a concierge service to make restaurant reservations and pick up dry cleaning. Deloitte & Touche LLP holds “town hall meetings” to let junior employees vent gripes to senior partners. The big firms are more aggressive in dropping or turning down business, to hold down the workload, and they are pulling older staff from other departments, like tax-services, to help out.

“The profession has recognized that we have a lot of stress in the system, and we’re doing a lot of things to execute against that,” says Bob Moritz, a senior partner at PricewaterhouseCoopers.

“Does this model still work?” asks Jim Walsh, a human-resources managing director for the firm. “It’s a good question” that is under review there.

PricewaterhouseCoopers is part of a “Talent Task Force,” a 15-member panel of Big Four partners, professors and regulators that has met about three times since last year to discuss junior-staffing shortages. “Public accounting firms have just been inundated with work, and one of their challenges is finding talent to do that,” says Richard Dietrich, a task-force member and accounting-department chairman at Ohio State University in Columbus.

“Right now there isn’t enough staff at my level,” says Michelle Walker, a first-year auditor at Deloitte & Touche in Pittsburgh. She was one of 20 current or former Big Four junior auditors interviewed for this article who detailed the pressures that play into turnover. “This year is going to be hell.”

After leaving Georgetown in 2001, Ms. DiCenso was assigned by PricewaterhouseCoopers to a unit focused on technology, information communication and entertainment companies. At Interpublic, she spent a lot of 80-hour workweeks focused on the company’s financial restatement. Soon, Interpublic faced another restatement, when Interpublic says it “identified cash flows that had been misclassified” in financial filings that had to be in order before a planned December 2003 securities offering. Ms. DiCenso and her colleagues had just days to correct the filings.

Every few weeks, Ms. DiCenso and fellow junior auditors swapped war stories over beers at O’Lunney’s, a pub in Times Square. Her manager, Sarah Petit, 27, sometimes broke away for drinks, and she and Ms. DiCenso talked about their frustration. Ms. Petit’s overtime escalated from 100 hours in 1999 to 950 last year, she says, when she left after a desired promotion was delayed.

“The job kind of spiraled out of control,” says Ms. Petit, now associate director of financial reporting for Warner Music Group and president of the New York Chapter of the American Women’s Society of CPAs. “We lost a lot of managers and they’re very hard to replace.”

Aware of the dissatisfaction, PricewaterhouseCoopers last summer released a study, “The value of the PwC professional experience: What employees gain by staying longer at the Firm, and why they leave.” Covering the years 1988 through 2003, it confirmed that turnover was highest with senior associates – one in four left annually. “There will be a learning curve for everyone but they put too much responsibility on people who do not have very much experience,” one senior associate told the interviewers. One manager professed to being “nervous about the quality of the audits.”

The study argued that young people who stayed the seven or so years it takes to become a senior manager typically earned 49 percent more, on average, in the long run than those leaving as senior associates. They also typically had greater job satisfaction later on, it said, and acquired quantitative and managerial know-how.

Still, Ms. DiCenso opted to quit when she received her bonus check in September – for $2,000. In her view, that translated into $2.86 an hour in overtime pay. “I could have made more working at a fast-food restaurant,” she says, although acknowledging the valuable skills she learned.

PricewaterhouseCoopers said it doesn’t comment on salary matters. Mr. Walsh notes that compensation is based on many factors, including work quality and performance reviews.

Of the 35 junior auditors with whom Ms. DiCenso started work in the TICE group in 2001, more than 20 were gone when she left. She now follows restaurants for Merrill Lynch & Co.

“I’m not knocking it as an educational experience,” says Amanda Morgenstern, a former junior auditor for PricewaterhouseCoopers. “But five years of my life are just gone.” She now is manager of financial reporting at Hearst-Argyle Television Inc.

– Diya Gullapalli (The Wall Street Journal)

A Day in the Life: Auditor Intern (Big Four Firm)

July 5, 2007 by royandy

Following is a description of a typical day as experienced by an intern at an auditing department at one of the Big Four firms:9:00 a.m.: If I’m unassigned, go to the office to check e-mails and phone messages. If assigned, arrive at the client site (but days usually start around 8 a.m.). At the client’s office, I’ll be meeting the client on a new job (usually the controller, other accounting personnel or pension plan administrator), getting to know where the files are, networking my laptop with my co-workers’, and getting to know the job. I’ll also find out the first account I’ll be working on — usually equipment, accounts receivable or attributes testing for pension plans. My senior will usually sit down with me for about a half-hour, and walk through most everything I’d be doing on the account (using the audit program and last year’s work papers).10:00 a.m.: Still working through my first account or attribute test. I stop lots to ask questions, which is encouraged. Sometimes the answer to my question has to be found with the client, and sometimes I’m sent by myself to approach the client. This helps in building a relationship with the client (if I end up working here full-time, I’ll definitely see them the next year), confidence skills, and analytical skills in learning to ask the right question. 11:00 a.m.: Probably still working through the same account. Some larger accounts, like accounts receivable, take days and days. Around 11:30, one of my engagement team members will mention lunch and that will be discussed for a while.12:00 p.m.: Lunch! A lot of variety here. I’ve eaten at everything from fancy places to fast food. Usually, if clients or partners are involved, lunch is taken care of. This is the time to get to know your team on a more personal level, which is always enjoyable.

1:00 p.m.: Back to work. Get some caffeine to fight off the after-lunch slump. There’s a possibility that I might be starting something new at this point, and thus the cycle of explanation begins again.

2:00 p.m.: Still working though the accounts. If unassigned and in the office, there’s a good possibility I’ll be picked up on a small in-office job. These jobs usually consist of photocopying, typing and pulling files. It isn’t bad to work these types of jobs; I enjoy the exposure I get to people I would not work with otherwise, like those in our tax department. If unassigned and not on a job, I’ll be working through an online tutorial, surfing the Web, writing e-mails or chatting with friends. Unassigned time can get pretty boring, but I luckily don’t have too much of it.

3:00 p.m.: Audit, audit, audit. I try to take lots of notes on my work towards the end of the day so I’ll be set when I come in the next morning.

4:00 p.m.: Making sure all my work papers are organized, understandable, and that the notes make sense. If at the end of an engagement, I will always sit down with my senior and explain exactly what I had finished, where I left off, and what still needs to be done. I try to always write out all of that too, just so the message got across.

5:00 p.m.: I’ll usually leave pretty close to 5 p.m., definitely by 5:30. On a few jobs I had, I left as early at 3:00.

6:00 p.m.: Fighting the traffic home or to an intern event.

A Day in the Life: Tax Staff Professional (Big Four Firm)

July 5, 2007 by royandy

Following is a description of a typical day as experienced by a tax staff professional at a Big Four firm.8:00 a.m.: I like to get in a little earlier than others (most other people in the office get in around 9:00). This gives me a chance to check e-mail and voice mail, take care of administrative tasks, check my open items from the previous day and make a general plan for my day. If things are slow, this is the time I read The Wall Street Journal or other periodicals for news regarding my clients.

9:00 a.m.: The office is jumping and the phone calls are starting to come in. At this time, I often have meetings with my manager and senior to discuss work in progress. These meetings will usually touch on the following: list of open (i.e., unfinished) items on tax returns, general tax matters for clients, tax technical issues requiring further research, and client management issues and administration. My manager will generally prioritize these items and the senior and I will form a plan of attack.

10:00 a.m.: As the tax staff, I’ll most likely address the tax return open items and perform any research on technical tax issues; the senior will deal more often with general tax matters and client relationship items. Preparing a corporate tax return is relatively straightforward. While corporate tax returns can be quite complex, you can more or less prepare a corporate return line-by-line, same as an individual return.

The primary challenge in preparing a corporate return is ensuring that you have complete, full and accurate information from the client. This is more daunting than it sounds. Information necessary to complete a tax return can come from numerous sources within a company, not just the accounting and tax departments. The larger the company, the more potentially difficult it is to get all of your information. As a result, most of the hours I bill on tax return preparation projects are spent not on actually preparing the return, but on tracking down all of the necessary information. I’ll generally put together an information request that, after a brief review by the manager, I will e-mail or fax to the client.

Tax research is generally more straightforward than tax return preparation. The firm has every possible tax research tool and source, from print to electronic to online to human. The ironic thing is that most of the research items you get at this level are ones for which answers are already known. Managers give you these research items pretty much knowing what the likely outcomes will be: you just confirm the suspicion with actual Internal Revenue Code sources, tax court cases or other citations. Sometimes you’ll get a unique and challenging assignment, but the new topics are usually researched by groups within the firm that specialize in that technical area.

In any case, these activities could easily take up the rest of my day, depending on how cooperative the client is or how difficult the information is to get.

1:00 p.m.: Lunch.

2:00 p.m.: Another e-mail and voice mail check, after which I’ll resume my activities from the morning. At this point, I probably will have spent a good amount of time on the phone with client personnel trying to track down information. In the best-case scenario, the client will have sent me back my information request with at least some information; realistically, the information request will get back to me no earlier than two or three days after I send it.

I’ll most likely spend some time making sure that the information we do have is correctly entered into the tax preparation software our firm uses. And at this point, I’ll hopefully have some answers or information regarding the research I performed on the tax issues. If so, I’ll try to schedule some time with my senior and/or manager later this afternoon to discuss my findings. Throughout the day, I’ll be gathering and organizing my work papers for inclusion in the client’s file.

4:00 p.m.: If all goes well, I’m having a brief meeting with my senior and/or manager discussing the research I performed. This discussion will hammer out how this issue could affect the tax return. Often, this discussion will result in my drafting of a technical memorandum that outlines the issue and our findings. These memos are pretty interesting because they represent more strategic and interpretive thought than plugging numbers into a tax return. The research and memos feel like the real meat of tax work.

6:00 p.m.: Finishing touches on my draft memo (the manager always has modifications), organizing my work papers, checking off my open items for tomorrow, and preparing my timesheet for the day. This will all probably take me 30-40 minutes, and then I’m off home. Incidentally, I should note that I’m usually working on multiple tax returns and other projects at one time. So there’s usually a lot of juggling going on, putting a premium on my time management and organizational skills. And if this was busy season, my leaving time wouldn’t be anywhere near 6:00 p.m. — it’d probably be closer to 11:00 p.m.

分享下 QP – FPE 我覺得既 Pass Golden rule

July 5, 2007 by royandy

實戰經驗,我認為 Golden rule 係:

1. “做” past paper:

唔係睇完望答案,用手寫,一路做,一路身邊放好自己所有 notes,唔識就開書,當自己考緊試咁寫,我 Pass FPE 個次,一份 paper,做連埋研究對答案,我要一日半,我用來做 past paper 既紙, 疊起來有一個 module 既 CLP 厚。

2. 睇 CLP 方法:

速睇,唔好要明哂,d 野 好難明既,唔好轉牛角尖,好快咁有個 idea 就得,以做 past paper 為主。

3. 補習:

可以選 FTC/BU,佢地會精選d past paper/essential note ,個d 題目都幾好用ga,用作最後 review~

4 .Critical file:

有人會寫低d CLP main point,我就反而唔會,因為補習個度(FTC/BU) 已經有 1 set 比我,我唔會浪費時間再做。我既 Critical file ,只有一樣野,Past paper 既 Question,同answer,咁點做呢?

大家都知有 Special topic 。我就會用 special topic,來選一d 以前past paper 成日問既野,放入去,仲會做個 heading ,知道問乜個時,要答乜。(Module A 同
C 用呢個方法最有用)

Module B & D,真係無計,佢d special topic = 無,我都要開 CLP/textbook 先做到 past paper.

5(a). Module B 點溫:

呢科係好虛無既,絕對考你臨場吹水,CLP module B 幾乎無用,除左某d 計數類既 formula 要記之外,其他野真係有睇內無睇一樣。我自己就做左 2-3 年past paper 後,先可以掌握到 module B 想我答乜,要我講既,就係用 common sense 吹大水….=_=

5 (b). Module A 點溫:
Special topic,其他我唔睇。

5c. Module C 點溫:
以 past paper 問法做重點,年年問既都差唔多。

5d. module D tax 點溫:
呢個真係無 quick road, 真係你做得多,就贏面大,佢d tax question 會搞到好煩,做得唔多既,真係會玩死你。想當年佢d salary tax 真係煩到…. @_@

總結:
30% CLP, 70% past paper.

祝考試成功。

用Excel自動轉大寫之方法 (可大至999Trillion)

July 5, 2007 by royandy

在 Excel 入面 , 按alt + f11 開 Visual Basic Editor

insert > module

把以下綠色文字copy, paste上 module 視窗入面
Function ConvertCurrencyToEnglish (ByVal MyNumber)
         Dim Temp
         Dim Dollars, Cents
         Dim DecimalPlace, Count
         ReDim Place(9) As String
         Place(2) = ” Thousand “
         Place(3) = ” Million “
         Place(4) = ” Billion “
         Place(5) = ” Trillion “
         ’ Convert MyNumber to a string, trimming extra spaces.
         MyNumber = Trim(Str(MyNumber))

         ’ Find decimal place.
         DecimalPlace = InStr(MyNumber, “.”)

         ’ If we find decimal place…
         If DecimalPlace > 0 Then
            ’ Convert cents
            Temp = Left(Mid(MyNumber, DecimalPlace + 1) & “00″, 2)
            Cents = ConvertTens(Temp)

            ’ Strip off cents from remainder to convert.
            MyNumber = Trim(Left(MyNumber, DecimalPlace – 1))
         End If

         Count = 1
         Do While MyNumber <> “”
            ’ Convert last 3 digits of MyNumber to English dollars.
            Temp = ConvertHundreds(Right(MyNumber, 3))
            If Temp <> “” Then Dollars = Temp & Place(Count) & Dollars
            If Len(MyNumber) > 3 Then
               ’ Remove last 3 converted digits from MyNumber.
               MyNumber = Left(MyNumber, Len(MyNumber) – 3)
            Else
               MyNumber = “”
            End If
            Count = Count + 1
         Loop

         ’ Clean up dollars.
         Select Case Dollars
            Case “”
               Dollars = “No Dollars”
            Case “One”
               Dollars = “One Dollar”
            Case Else
               Dollars = Dollars & ” Dollars”
         End Select

         ’ Clean up cents.
         Select Case Cents
            Case “”
               Cents = ” And No Cents”
            Case “One”
               Cents = ” And One Cent”
            Case Else
               Cents = ” And ” & Cents & ” Cents”
         End Select

         ConvertCurrencyToEnglish = Dollars & Cents
      End Function

     Private Function ConvertHundreds (ByVal MyNumber)
         Dim Result As String

         ’ Exit if there is nothing to convert.
         If Val(MyNumber) = 0 Then Exit Function

         ’ Append leading zeros to number.
         MyNumber = Right(“000″ & MyNumber, 3)

         ’ Do we have a hundreds place digit to convert?
         If Left(MyNumber, 1) <> “0″ Then
            Result = ConvertDigit(Left(MyNumber, 1)) & ” Hundred “
         End If

         ’ Do we have a tens place digit to convert?
         If Mid(MyNumber, 2, 1) <> “0″ Then
            Result = Result & ConvertTens(Mid(MyNumber, 2))
         Else
            ’ If not, then convert the ones place digit.
            Result = Result & ConvertDigit(Mid(MyNumber, 3))
         End If

         ConvertHundreds = Trim(Result)
      End Function

      Private Function ConvertTens (ByVal MyTens)
         Dim Result As String

         ’ Is value between 10 and 19?
         If Val(Left(MyTens, 1)) = 1 Then
            Select Case Val(MyTens)
               Case 10: Result = “Ten”
               Case 11: Result = “Eleven”
               Case 12: Result = “Twelve”
               Case 13: Result = “Thirteen”
               Case 14: Result = “Fourteen”
               Case 15: Result = “Fifteen”
               Case 16: Result = “Sixteen”
               Case 17: Result = “Seventeen”
               Case 18: Result = “Eighteen”
               Case 19: Result = “Nineteen”
               Case Else
            End Select
         Else
            ’ .. otherwise it’s between 20 and 99.
            Select Case Val(Left(MyTens, 1))
               Case 2: Result = “Twenty “
               Case 3: Result = “Thirty “
               Case 4: Result = “Forty “
               Case 5: Result = “Fifty “
               Case 6: Result = “Sixty “
               Case 7: Result = “Seventy “
               Case 8: Result = “Eighty “
               Case 9: Result = “Ninety “
               Case Else
            End Select

            ’ Convert ones place digit.
            Result = Result & ConvertDigit(Right(MyTens, 1))
         End If

         ConvertTens = Result
     End Function

      Private Function ConvertDigit (ByVal MyDigit)
         Select Case Val(MyDigit)
            Case 1: C
            Case 2: C
            Case 3: C
            Case 4: C
            Case 5: C
            Case 6: C
            Case 7: C
            Case 8: C
            Case 9: C
            Case Else: C
         End Select
      End Function

完成後 , 關閉 Visual Basic Editor
Insert > Function
就會見到多左一個function叫 ” ConvertCurrencyToEnglish “
之後亦可以如普通Function用, 如
=ConvertCurrencyToEnglish(100.50) –>

One Hundred Dollars And Fifty  Cents

有用會計網站連結

July 5, 2007 by royandy