News & Tech Tips

Quickbooks Tips – Exporting to Excel

When you export from Quickbooks note that you have an “Advanced” tab. There are three items which are not checked automatically which can help you in Excel. They are as follows:

  • Send Header to screen in Excel – The header does not automatically show on the screen. It is hidden unless you print. This option will show it in the document.
  • Auto Outline (Allows collapsing / Expanding) – With this option, the data will be automatically subtotaled in Excel. You can expand and collapse as you see fit based on the subtotals. (Example: if you have four cash accounts, but want to see one, you can collapse the tree for the cash account. But, if you want to see all F/A accounts, you can leave that tree as it is).

NOTE: If you collapse the accounts and want to copy and paste ONLY what you see without bringing all the data with it – you can. You can copy, click the cell you want to paste into or start the range with and click the clipboard. This will paste only what you see without bringing the data along with it. If you just copy and paste using Control C and Control V, you will bring all the data hidden in the subtotals along with what you actually are seeing on the screen. This also works for any rows or cells which are hidden. You will only bring over what you see, not what is in the hidden ranges.  Can’t see the clipboard? The shortcut to get to it is Control C and C again. This should show your clipboard. You have to click directly on the clipboard for this to work.

  • Auto Filtering (Allows Custom Data Filters): With this option, you will have filters across all columns and be able to select only what you want. For instance, if you have transactions from four cash accounts and only want to show two, you will have all four as an option on the filters. Just unclick “all” and select what you want. Then, you will only show transactions from the two accounts you want.

The Rise of Hydraulic Drilling and What It Means to Ohio

In recent months, there has been much interest in the rise of the Ohio Shale Play currently taking place on the eastern side of our state.  As widely reported in the news media, new technologies and discoveries have given many energy companies the ability to drill hydraulically fractured horizontal wells, also known as “fracking.”  With the ability to actually drill into the shale of the earth 5,000 to 6,000 beneath the surface, they are primarily extracting “wet gas,” which is later processed into butane, propane and methane.

Currently, only about 100 wells have been drilled in the state, but the potential is for thousands of these wells to be drilled here. The economic impact has significant implications for almost all industries in Ohio.

Approximately $2.3 billion have already been invested from companies both inside and outside the state.  Analysts project that because of this development there will be 65,680 new jobs created, value added growth of $4.9 million and $433 million generated in state and local taxes in Ohio by 2014.  So great is the impact, Governor Kasich has proposed that the personal income tax be significantly reduced or eliminated.

This is an industry that is on the rise, and clients, including surveyors, contractors and engineering firms, may be directly affected.  In addition to the impact on businesses, many individuals who live in the eastern counties of the state are receiving significant lease bonus payments, up to and exceeding $1 million.  These payments preclude any royalty payments based on quantities extracted.

There are several tax implications if you or someone you know is involved at any level with this industry.  Business owners who derive source income related to services provided with the oil and gas industry may find unique savings and tax-planning opportunities.

Likewise, manufacturing companies that are selling products related to this industry may also be able to take advantage of such savings.  Finally, individuals who are recipients of lease bonus payments and royalties need to be aware that those payments are subject to federal, state, and possibly local taxation. Strategic tax planning may be needed.

For more information about this subject, contact your Whalen tax adviser.

Rich Vogt is a tax specialist and has been with the firm for four years. He provides tax and consulting services to business and individual clients. Rich has more than 10 years of experience in the accounting and tax industry.

Image courtesy of freedigitalphotos.net
 

Greatness is a Choice

courtesy of freedigitalphotos.net

At a recent Women Presidents’ Organization (WPO) conference in Atlanta I had the opportunity to attend a seminar led by Jim Collins, titled “Great by Choice.”  The information I left with would be valuable to any and all business owners.  Below is an outline of what I learned, including links to even more in-depth information.

Greatness is a choice.  You can choose to be good, or just good enough, or truly great.  Truly great leaders have drive and confidence, but also the humility to put the needs of the company, clients and employees ahead of their own.

So what distinguishes the greatest leaders from the rest?

FANATIC DISCIPLINE
It’s all about having fanatic discipline – sticking to your goals no matter what.  Discipline is not a natural trait that some people are born with and others are not.  Rather, discipline is an art form to be learned.  It takes practice and dedication to be disciplined.

EMPIRICAL CREATIVITY
Another trait is what Collins referred to as empirical creativity.  This involves taking our natural creativity and adding discipline to it for maximum effectiveness.  By empirically testing our creative ideas first, before throwing a lot of time and resources at them, we are able to find out what works and move ahead in the right direction.  We test our ideas by trying them out on a small scale and verifying their effectiveness before drastically moving forward.

PRODUCTIVE PARANOIA
And finally, great leaders employ productive paranoia – being prepared for the situations that could put your company’s future at risk.  One key is having the cash reserves and buffers to protect your business from any economic catastrophe.  It is important to understand what would be disastrous to your company, and then prepare for it.  The second key is not putting your business in jeopardy by taking big risks.

THE RETURN ON LUCK
Luck happens to everyone, both good and bad.  What separates the great leaders from the rest is the ability to maximize the return on luck.  Start thinking of luck as an event, rather than just some indefinable aura that follows some people around and not others.  Then, when luck happens, make the most of it.  Back it with your drive and discipline to get the highest return on your luck possible.  And remember that a single good luck event will not make your business, but one catastrophic bad luck event could break it – so always be prepared and have your business protected.

Understanding Your Multi-Generational Workforce

Laura Wojciechowski, CPA, EA, PFS is a partner and serves as the firm’s president.

My fellow partners and I recently attended a symposium conducted by Enterprise Worldwide. The organization is an alliance of independent accounting and advisory firms working together to provide the best possible service to clients on a worldwide basis. Belonging to Enterprise makes available to our firm a pool of knowledge and experience to address the international and other specialized business needs of our clients whenever needed.

Professional development programs are another benefit of our Enterprise membership, and the symposium offered topics of general business interest and those geared to CPA firms. One of the sessions I attended was on the challenge for business owners to manage four different generations of workers in their organizations. The presenter was Guy Gage of PartnersCoach.

Gage explained that 20th Century generations include Builders (born between 1930 and 1945), Baby Boomers ((born between 1946 and 1964), Generation X (born between 1965 and 1980) and Generation Y (born between 1981 and 1995).

Each group has its own distinct characteristics, values, and attitudes toward work, based on its generation’s life experiences. Parenting style, education philosophy and defining moments are major influencers. 

  • Builders. Builders are considered among the most loyal workers and “work to live.” They are planners, tend to be cautious, but hopeful, and have great respect for authority. They value hard work, duty before fun and adherence to the rules. 
  • Baby Boomers. Boomers are the first generation to actively declare a higher priority for work over personal life. They value collaboration and teamwork. They are more optimistic and open to change than the prior generation, but they are also responsible for the “Me Generation” with its pursuit of personal gratification. Their generation’s motto would be “Just do it.” 
  • Generation Xers. Generation Xers are often considered the “slacker” generation. They naturally question authority figures and are responsible for creating the work/life balance concept. They are self-reliant and tend to be more pessimistic than other generations. They need to be appreciated and like direct and immediate communication.
  • Generation Ys. This group has an appreciation for diversity and social contributions. Because of significant gains in technology and an increase in educational programming during the 1990s, Generation Ys are also the most educated generation of workers today and they like to work with other bright, creative people. They want to have challenging work or they will move on. They have high expectations, may seem overconfident and seek recognition of their talent. At times, they can appear impatient.

Gage said that to successfully integrate these diverse generations into the workplace, companies need to create a culture that actively demonstrates respect and inclusion for its multigenerational work force and to embrace major changes in recruitment and benefits.

Learning how to communicate with the different generations can eliminate many major confrontations and misunderstandings in an organization and lead to a more productive and effective workplace.

If you would like more information about this presentation, contact Laura Wojciechowski.