Public email to this board - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Accounting - 会计审计

Public email to this board

Public email to this board# Accounting - 会计审计

m*12013-04-02 07:04

1 楼

Recently I received a lot emails asking guidance or advises. I tried my best
to reply most emails. For those email I didn't reply, let me try here:
Most people just want me to help them solve major problems and expect me to
give them quick answers like select ABCD in a exam. Unfortunately, life is
not like this and there is no quick answer to any major problem. You have to
be clear at what you want, what you can do and what you are willing to
compromise(give up). You have to work very hard (based on what should do,
not what you want to do) and if you are lucky, you may get help from
somebody to some extent. However, you are the owner of your own business and
you have to drive the whole process, not counting others.
Agree it or not, your chance to achieve any major goal, 60% is decided by
strategy (including choosing right tactics) and planning (including research
in great details). Execution only counts for 30% and luck is the remaining
10%. You have to work hard and don't even try to cut corners. Short-cut
always bite you hard later.
Most people's status (social, career or financial)is decided by which group
they really want to stay, top 5%, top 10%, top 20%, top 30-50 percentile or
lower 50 percentile. To me, my goal is to continue staying in my top 10% and
move up to top 5% if possible. Since luck is not controllable, I have to
master everything else besides luck. I play statistics, not lottery.
Unfortunately, most people here stuck in their lower 50% percentile or at
most top 30-50 percentile. Everything happens for a reason. Before you
complain life is not fair, you have to do a self check and find out what you
are missing.
Before I came to this board, I knew tons of people here need help and I knew
exactly where you need help most: strategy and planning. I heard a lot cry
for help but unfortunately not enough desire. Maybe this board is supposed
to be a market place for cheap answers while I'm a foreigner who want to
brainstorm folks in this most valuable and complicated skillset. Have to say
it's pretty frustrating so far. If I'm not working on my executive charisma
, I really don't know how long I will last.
As to the accounting technical, which is pretty popular here. I have to say
what discussed here are at low end to a CPA population with average master
degree. I could teach you some background in SEC reporting, global
consolidation, financial system design & control, financial database, GAAP
research and highly marketable financial analysis tool like SQL, VB & Macro,
Pivotable, advanced Access & Excel skills, software integration to enable
you to play 100K+ lines of database with few clicks & programming, but do
you have chance to utilize these skills and make them marketable to you?
Blogging is a brand new experience to me and I'm still adjusting. Maybe
frustration is part of this investing process.

z*a2013-04-02 07:04

2 楼

Waiting for more of your post.

d*92013-04-02 07:04

3 楼

Do you mind share with us how to align accounting skills with SQL/VBA/
Advance Access to get $100K job? I have accouting background and recently
have been learing database and VB, but not sure how to transfer those skills
into $$$ and how to combine it to my accouting background.
If you can shed some light, I really appreciate it.

m*12013-04-02 07:04

4 楼

A few comments:
1. Even you have a perfect skill sets combination of accounting &
database, you still can't make 6 figures in most states unless you get to
manager position.
2. How close you current position to this highly specialized area? If you
are too far away, forget about this. Normally, career grow in baby steps,
not by big turn or jumps. This back to my point in my upper post, 60% of
your success is decided by strategy and planning. No short cut.
3. The very first step to get in this specialized area is to work on your
Excel skills, actually Excel is the best interface software for every CPA
without exception. First work on some easy skills like vlookup, conditional
format, pivotable or any excel skills don't require programming. Buy a excel
handbook and practice new formulas and functions everyday (In my early U.S
career, I try to build 3-5 difference models by using difference functions
or formula for the same project when I get bored). Then work on VB & Macro
if your company need it. This will help you to become the "tech guru" in
your accounting department. If you are working in a mid-size $0.3-1B revenue
company, your company probably already have F/A, financial reporting or
system consolidation group, work hard and networking with them. You have a
great chance to sneak in if you have impressive Excel skills. If your
company are too big or too small, my recommendation is for you to give up on
this career track.
4. However, if you just like me, who is a builder, you can manage to
change the work habits/procedures in your department (build your tech guru
image first please), then you can slowly grow your data analysis functions
and make it a standalone position/group. This will takes a minimum 2-3 years
and this will get you to a lead/senior FA level or manager level if you
have managerial skills.
5. Actually if you read enough of my post, my #1 principle in career
advice is to match your skillset. In most case, you are good at what you are
doing and you probably don't have a lot talent/desire in something you don'
t know. Just focus on something reachable to you. As I said in my upper post
, I play statistics, not lottery.
6. Baby steps really works if you can make continuous improvements all
the time. If my starting point is my first permanent job in U.S, It took me
less than 8 years to triple my salary. If my starting point is my intern
during my master program, my hourly rate goes up more than 500%. What make
things even better? In long term, my work hours remain the same if not less
while my work pressure go down, if not significantly down. My career
probably could grow a little bit faster but that will eat up some of my
valuable time with my kids, hobbies and social life. Not worth it at all.
After all, I still have a long career down the road and I want the whole
process to be fun and enjoyable.
7. A lot times, I see folks spinning their wheels and chasing new
technical. Actually accounting don’t have a lots new skills. In addition,
it take you a minimum 3 years to learn a skill and make it marketable, it
only took me 5 minutes to control the input and output of your work. Even
you are not manger level, if you spend 1 hour/week on some valuable
coworkers in your office, you still can utilize his talents and make both
of you shine; it’s 100 times faster. Don’t feel bad, I did my fair shares
on this wrongdoing, I’m just fortunate enough to learn from my mistakes.
8. Most people like to chase money. Unfortunately, this is a very bad
attitude. You want more money, you have to grow your responsibilities and
develop skill set enable you to add value and merits to your employer. Once
you start to make enough contribution, everything comes so nature: green
card, raise, promotion, bonus, headcount, budget, network, everything…
Sometimes, it may means have to turn down highly appealing offers. Please,
just focus on something that always make you shine, then enjoy a “Hakuna
Matata” lifestyle
Life is a journey, make it more fun and enjoyable.

skills

【在 d**********9 的大作中提到】

: Do you mind share with us how to align accounting skills with SQL/VBA/
: Advance Access to get $100K job? I have accouting background and recently
: have been learing database and VB, but not sure how to transfer those skills
: into $$$ and how to combine it to my accouting background.
: If you can shed some light, I really appreciate it.