WashingtonCPA 2016 Summer by Washington Society of CPAs

washington

CPA Summer 2016

Volume 60, Number 1

Ransomware & Cyber Risk Management Search for New President/CEO is Underway 2015-2016 Awards Protect Yourself from Cybercriminals

www.wscpa.org

WashingtonCPA Summer 2016

www.wscpa.org

wa s h i n g t o n

CPA www.wscpa.org • memberservices@wscpa.org Tel (425) 644-4800 • Toll free in WA (800) 272-8273 Fax (425) 562-8853 902 140th Ave NE Bellevue, WA 98005-3480 BOARD OF DIRECTORS David J. Miniken Chair Thomas G. Donaghy Vice Chair Kirsten S. Duke Treasurer Joseph P. Smith Secretary William A. Simer Immediate Past Chair Richard E. Jones President & CEO

Dawn E. Beck Amanda V. O’Rourke Justin A. Bourn Rhonda S. Powell Robert W. Heller Michael W. Reeves Erika C. Hosea Abby M. Sanders Brett J. Jordan Ronald L. Tilden Mary E. Joyce David E. Trujillo Kristine L. Lambright CHAPTER BOARD CHAIRS Erika Hosea Bellevue Area Lydia Ahn Bellingham Area Dana Lashbaugh Everett Area Benjamin Anderson Olympia Area Joe O’Meara Seattle Area Fred Peck Spokane Area Dani Espinda Tacoma Area Alexander King Tri-Cities Area Molly Andler Tri-Cities Area David Stubing Vancouver Area Alexandria Williams Yakima Area Melissa Wood Yakima Area Jeanette Kebede

Editor

The WashingtonCPA is published by the Washington Society of Certified Public Accountants for its members. Views and opinions appearing in this publication are not necessarily endorsed by the WSCPA. The products and services advertised in The Washington CPA have not been reviewed or endorsed by the Washington Society of Certified Public Accountants, its board of directors or staff. The WashingtonCPA (USPS 009754) is published four times annually by the Washington Society of Certified Public Accountants, 902 140th Avenue NE, Bellevue, WA 98005-3480. $12 of members’ annual dues goes toward a subscription to The WashingtonCPA.

CONTENTS 8

Ransomware and Cyber Risk Management

10 Tips to Protect Yourself from Cybercriminals 4

Search for New President/CEO is Underway

You Don’t Have to Go it Alone!

16 2015-2016 Awards 22 Accounting Students Receive $230,000 in

Washington CPA Foundation Scholarships

29 Using Excel’s Flash Fill Tool to Clean Up a QuickBooks Trial Balance

Periodicals postage paid at Bellevue, Washington and additional mailing offices. Cover photo: © Getty Images/Tek Images POSTMASTER: Send address changes to The WashingtonCPA, c/o WSCPA, 902 140th Avenue NE, Bellevue, WA 98005-3480.

www.wscpa.org

DEPARTMENTS 4

Leadership Lens

Conferences

News Briefs

Registration

Networking Events

Classified Ads

Advocacy

Photo Album

Tech Tip

47 Chapters

CPE Digest WashingtonCPA Summer 2016

LEADERSHIP LENS

Search for New President/CEO is Underway By Rich Jones, CPA, CGMA, President & CEO

n my last column I announced that I would be retiring after 12 years of service from my position as President and CEO of WSCPA at the end of this fiscal year (May 31, 2017). I have enjoyed every day of this experience and feel privileged and honored to have been entrusted with this important responsibility. Bill Simer (Chair) and Dave Miniken (co-Chair) of the CEO Search Task Force have recruited representatives from a broad cross-section of the membership and have initiated the process of searching for a new CEO. In addition to Bill and Dave, members of the task force are Tom Donaghy, Kirsten Duke, Jim Ladd, Kris Lambright, Sharon Philpott, Rhonda Powell, Joe Smith, Susie Thomson-Sines, and Dave Trujillo. Task force members have reviewed the job duties, developed the position description, and defined and prioritized key competencies candidates should demonstrate to be successful in the President/CEO position. Based on initial interest expressed by people with varied backgrounds, we expect to have an excellent pool of candidates apply for the position. If you or someone you know might be interested in being considered for this position, I encourage you to apply or to spread the word about this opportunity. I was not active in the WSCPA when I applied for the position 12 years ago, yet I convinced the task force (and eventually the board) that I had the experience and talent to succeed in the job and I think they also knew I had a passion for our profession. If this also describes you, please consider whether you believe you are a perfect fit for this position and apply.

The search process is straightforward and efficient and officially opened on July 15. The task force will close the

WashingtonCPA Summer 2016

If you or someone you know might be interested in being considered for the Society's President & CEO position, I encourage you to apply or to spread the word about this opportunity. Find the job description at www.wscpa.org/careers application period on September 30, 2016. To apply, email your resume and a cover letter to ceosearchtaskforce@wscpa.org. All materials received in connection with your application will be kept in strictest confidence. The task force has prepared background information on the WSCPA (e.g., mission and vision statements, current CEO position description, minutes of board meetings for the year ended May 31, 2016, current strategic plan document, audited financial statement for the year ended May 31, 2015, and approved budget for the current fiscal year). To request the information package, email ceosearchtaskforce@wscpa.org. The task force will be actively participating in the search process. The search process timeline is as follows: •

July—Finalize competency ranking and scoring methodologies and review advertising messages and distribution plans.

•

August and September— Finalize interview questions for applicants.

•

October—Review and score applications and select semi-finalists.

•

November—Conduct interviews with finalists and background checks.

•

December/January— Roundtable discussions with management team for final candidates. Candidate recommended to WSCPA Board of Directors. Extend offer and finalize employment agreement.

•

May—New CEO begins 30-day overlap period with current CEO.

•

June 1, 2017—New CEO takes over.

If you have any questions about the search process, please contact Helen Doty, WSCPA Manager of Governance and Human Resources, at hdoty@wscpa. org or (425) 586-1116. At right is a summary of the key duties and responsibilities for the WSCPA CEO position. Feel free to share it with anyone you think might be interested. And as always, do not hesitate to contact me with any questions you may have, at rjones@ wscpa.org. Thank you.

www.wscpa.org

POSITION

QUALIFICATIONS

President and CEO Washington Society of Certified Public Accountants

LOCATION

• • • • •

DESCRIPTION

•

Bellevue, Washington

The President and CEO will serve as the Chief Executive Officer, a voting member of the Board of Directors, and principal spokesperson of the Society. In collaboration with the Board of Directors, the President & CEO has overall responsibility to identify and implement the strategic initiatives, programs, services, and policies of the Society in response to the diverse and changing needs of the membership. His/ her charter will be to maintain a future-oriented approach to management that anticipates the direction of the profession while promoting the image of CPAs to the public and enhancing the value of the CPA designation to and for all members. Specific duties include: • •

•

• • • • •

Acting as the key strategist for the Board of Directors. Representing the WSCPA in dealings with the American Institute of CPAs (AICPA), Washington State Board of Accountancy (WBOA), the National Association of State Boards of Accountancy (NASBA), CPA/SEA (association of CEOs of state CPA societies), and other accounting organizations. Proactively maintaining effective relationships with the WBOA and its staff and committees, as well as the accounting academic community, business organizations and governmental organizations in Washington. Representing WSCPA in state and federal legislative efforts. Assuring implementation of immediate and long-range strategies and enhancement of the Society’s image. Hiring, firing, titling, compensation and supervision of personnel. Assuring effective delivery of member services, including identification and development of new member services. Assuring the preparation and achievement of the annual operating budget and capital budgets of the Society and keeping the Board of Directors informed of circumstances that may result in not achieving the budgeted results.

•

• •

High level of energy and enthusiasm for the job Well-developed sense of ethics Fiscally responsible Persuasive presenter Strong leadership skills in people and project management, including motivation, innovation, mentorship, diplomacy, timeliness, sensitivity, and compassion Proven ability to deal effectively with complex issues, think analytically and strategically, and negotiate successfully for win/win solutions in a diverse group Understanding and appreciation of the importance of staff culture, chapters, continuing professional education, diverse member groups, and statewide public relations CPA credential is a plus Certification in association management (CAE) is a plus

EDUCATION

Bachelor’s degree or equivalent experience

SALARY

Competitive salary DOE

BENEFITS • • • • • •

Health, life, and disability insurance Thirty-six days per year of Paid Time Off Professional dues Business club membership Retirement plan (401k with match) Relocation assistance negotiable

THE SOCIETY

Headquartered in the Society-owned building in Bellevue, Washington, the Society is an 8,000+ member organization with a good public image and national reputation for being a leader among state CPA societies, and maintains excellent relations with national professional accountancy organizations, state boards of accountancy and Washington universities. The staff of 22 is dedicated and cohesive, and very responsive to members. The CEO position is open due to the retirement of current CEO after 12 years of service. Employment to start May 1, 2017. Washington Society of CPAs is an Equal Opportunity Employer.

TO APPLY

Email resume with cover letter by September 30, 2016 to confidential electronic mailbox at: ceosearchtaskforce@wscpa.org www.wscpa.org

WashingtonCPA Summer 2016

LEADERSHIP LENS

You Don’t Have to Go it Alone! By David Miniken, CPA, WSCPA Chair for 2016-17

’m honored to serve as the WSCPA Board Chair for the next year. I recently attended the AICPA Spring Council meeting in New Orleans as one of three delegates from our state, and a central theme of the meeting was the staggering pace of change in the business landscape. Technology continues to evolve. More than 90% of the data amassed in history was collected during the last two years, much of which is due to the intersection of three forces: the growth in the number of mobile devices, the growth in cloud computing, and the development of software to process all the data. Technology is drastically changing the world of professional services. Given the greater amounts of data available, our challenge is to find a way to synthesize this data into a form that facilitates decision making, rather than allowing ourselves to become paralyzed by the sheer volume of information available. Firm cultures are evolving. The marketplace is moving toward flexible staffing models as well as variable and virtual work arrangements. In order to meet the changing needs of our workforce and enhance staff retention, leaders within “Firms of the Future” are embracing these changes and developing tools to invest in their team members’ futures so that their younger professionals feel more engaged, contribute ideas, and help set the direction at those firms. Our talented workforce is evolving. As leadership at most firms currently consists largely of white males, the Firm of the Future is committing efforts to understand the needs and expectations of women and minorities so that they can become leaders within those firms. There is a strong business case for the development of a more inclusive culture. Forward-facing firms are considering alternative career paths that focus on the strengths and interests of each of their

WashingtonCPA Summer 2016

The marketplace is moving toward flexible staffing models as well as variable and virtual work arrangements. In order to meet the changing needs of our workforce and enhance staff retention, leaders within “Firms of the Future” are embracing these changes and developing tools to invest in their team members’ futures...

people, as well as embracing the generational differences in their offices (which I particularly appreciate each time I try to download a new app onto my cell phone). Our client relationships are changing. Your clients understand that you cannot be all things to all people, so it is increasingly important to carefully choose who you serve. Leadership within the Firm of the Future understands the importance of forming alliances to build working relationships with other firms and experts to strengthen their deliverables. It is important to revisit your firm’s service offerings, considering the future needs of the marketplace. This is a good time to reignite your relationships with your clients and strengthen your team’s ability to understand client preferences. Considering how to remain competitive during this period of significant change can seem daunting, but the great news is that you don’t have to go it alone as you transition toward being a high-performing Firm of the Future. The AICPA’s Private Companies Practice Section (PCPS), an add-on firm membership section within the AICPA, focuses on the needs of those of you managing local practices. The PCPS provides practical tools and resources specifically designed to boost the success of local practices, helping you to become the Firm of the Future. The PCPS supports CPA firms in the everyday intricacies of running a practice by

providing high-quality management tools dealing with such varied issues as virtual work arrangements, engagement pricing tools, recruitment and retention, building a social media presence, and going paperless. If your firm is not already a member of the PCPS, I encourage you to consider it. Firm membership is only $35 per CPA, up to a maximum of $700 per firm due and it provides a great wealth of resources for small- and medium-sized practices. In addition, your membership in the WSCPA provides you with many opportunities to discuss these issues with your peers and find out how they are dealing with these trends. In partnership with the PCPS, the WSCPA offers a free rotating tool available every month on the WSCPA website at www.wscpa. org/pcpsresources. As this rotating tool is replaced by another tool each monthend, you will want to check the WSCPA website frequently so that you can take advantage of these free resources. I look forward to serving as Chairman of your Board of Directors, and I look forward to meeting as many of you as possible over the coming year. Dave Miniken is a member of the management team at Sweeney Conrad, where he serves as the Director of Sweeney Conrad’s audit and accounting practice. You can contact him at dave@sweeneyconrad.com. www.wscpa.org

www.wscpa.org

WashingtonCPA Summer 2016

CYBER SECURITY

Ransomware and Cyber Risk Management By Randy R. Werner

ansomware and cyber extortion represent one of today’s more malicious types of hacker attacks. It sneaks into computer systems, encrypts files, and demands a ransom before decrypting the files. A major problem is that ransomware does not always decrypt files even after the ransom is paid. Being prepared and taking precautions against cyber risk exposures such as ransomware is therefore essential. Otherwise, you’re at the mercy of criminals who prey on unprepared and unsuspecting businesses and individuals. Ransom demands range from a few hundred dollars to several thousand, depending on the size of the victim. Not all ransomware attacks are reported to authorities, so estimates of the total amount paid over the past few years vary widely, ranging up to $300 million.

WashingtonCPA Summer 2016

©Getty Images/Tek Images

gathering, re-entering and reconstructing data. Rebuilding work, such as tax returns based on the backups, also takes time. If personally identifiable information is involved, such as Social Security numbers, the firm might also need a professional risk assessment to determine its legal responsibilities.

The more notorious names among ransomware are CryptoLocker, CryptoWall, TorrentLocker and Locky, among others. Some attacks rely on software that now has known fixes, so a solution might be found online. However, other ransomware is technically advanced and has no known fix, except for the victim to rely on current backup files. The primary defense is to institute frequent backups of the files you do not want to lose. Some ransomware even seeks out backup copies of files, so best practices include creating multiple backups in different locations. Cloud services, or remote backup services, and external or USB hard drives are options to consider for multiple backups. Even with backup files in place, a firm may still spend many hours

Such losses can sometimes be avoided by creating user awareness and training everyone in your firm to be extremely cautious about unsolicited or questionable attachments or hyperlinks in email messages. Training can broaden your firm’s prevention IQ. It also never hurts to call or contact senders to ask if they sent you a document before you open it. Sometimes ransomware enters a computer system via innocuous-looking Word or Excel documents. There’s a reason why people say, “An ounce of prevention is worth a pound of cure.”

Loss Prevention Tips •

Create backup copies of all important data and information on a regular basis. The frequency of backup depends on: how often your data changes, and the impact on your business if you lose the data between the last backup and the time of loss. Store and secure backup copies away from your office location and use encryption to protect any sensitive information about your firm and clients. Regular backups better ensure that critical data is not lost in the event of a cyber-attack or physical incident such as a fire or flood.

•

Do not open attachments or hyperlinks if you did not request them or if the e-mail is suspicious or questionable. www.wscpa.org

CYBER SECURITY

Do not follow instructions to “enable macros” or “enable content.” Many attacks appear to come from a trusted source or someone you know, as part of a social engineering scheme. A scheduled event, travel plans, or user interests can be used to create what looks like a legitimate document, employing logos and brands to deceive users into performing an action such as opening a document, clicking a link, or changing a password. The action then enables a hacker to commandeer accounts and launch attacks. By hovering your mouse over a link, without clicking it, you can check the address for the website. If the address is for a different website, that’s a big red flag, as is a misspelled link. •

Strictly define user permissions and restrictions so that users don’t have any more rights or access to a program or system than they need, also known as the “least

Ransomware and cyber extortion represent one of today’s more malicious types of hacker attacks. It sneaks into computer systems, encrypts files, and demands a ransom before decrypting the files. A major problem is that ransomware does not always decrypt files even after the ransom is paid.

privilege” concept. The same applies to administrators, who should not stay logged in as an administrator any longer than is strictly necessary. Excessive rights and activities can allow malware to do extra harm and lead to large losses of data. •

ran.som.ware /’ransƏm,we(Ə)r/ noun ransomware; ransom-ware A type of malicious software designed to block access to a computer system until a sum of money is paid.

www.wscpa.org

•

Apply all software security updates to your computer. Once a software vulnerability is identified, most software companies automatically issue software updates. If the software you are using does not have an automatic update feature, develop a business practice to check for latest updates. Antivirus software is a must. Antivirus companies constantly update virus definitions to defend computers against new threats, and for the most part these software updates are seamless to the user. Most antivirus software includes spyware, adware and e-mail attachment protection. If not, they should be deployed along with antivirus software.

•

Consider cyber insurance. Coverage for extortion expenses incurred as a result of a credible cyber extortion threat is a good feature, but remember that paying a ransom does not always decrypt files.

With more devices becoming connected to the Internet, it’s important to take steps toward avoiding cyber threats such as ransomware. Have a plan in place for mitigating threats and risks. If and when you are hit by a threat, you’ll at least be in line with the Boy Scout motto, “Be prepared.” Randy R.Werner, J.D., LL.M./Tax, CPA is a loss prevention executive with CAMICO (www. camico.com). She responds to CAMICO loss prevention hotline inquiries and speaks to CPA groups on various topics.

WashingtonCPA Summer 2016

CYBER SECURITY

Tips to Protect Yourself from Cybercriminals By Kaspersky Labs

Spam & Phishing Scams

pam is a form of electronic junk mail sent en masse to users. While annoying in its own right, it can potentially be very dangerous if part of a larger phishing scam. Phishing scams are a form of cybercrime that involves defrauding users by acting as legitimate companies or organizations in order to obtain sensitive information such as passwords and login credentials. Spam is the electronic equivalent of the “junk mail” that arrives on your doormat or in your postbox. However, spam is more than just annoying. It can be dangerous especially if it’s part of a phishing scam. Spam emails are sent out in mass quantities by spammers and cybercriminals that are looking to do one or more of the following: • •

•

Make money from the small percentage of recipients that actually respond to the message Run phishing scams in order to obtain passwords, credit card numbers, bank account details, and more Spread malicious code onto recipients’ computers

How to protect yourself against spam email and phishing

Here are some useful tips from Kaspersky Lab’s team of Internet security experts to help you reduce the amount of spam email you receive: Set up multiple email addresses

It’s a good idea to have at least two email addresses: Private email address • This should only be used for

WashingtonCPA Summer 2016

personal correspondence. Because spammers build lists of possible email addresses, by using combinations of obvious names, words, and numbers, you should try to make this address difficult for a spammer to guess. Your private address should not simply be your first and last name – and you should protect the address by doing the following:

• Never publish your private email address on publicly accessible online resources. • If you must publish your private address electronically, try to mask it in order to avoid having the address picked up by spammers. For example, “Joe.Smith@ yahoo.com” is an easy address for spammers to find. Try writing it as “Joe-dot-Smith-at-yahoo. com” instead. • When you need to publish your private address on a website, it’s safer to do this as a graphics file rather than as a link. • If your private address is discovered by spammers – you should change it. Although this may be inconvenient, changing your email address will help you to avoid spam.

Public email address • Use this address when you need to register on public forums and in chat rooms, or to subscribe to mailing lists and other

Internet services. The following tips will also help you to reduce the volume of spam you receive via your public email address:

• Treat your public address as a temporary address. The chances are high that spammers will rapidly get hold of your public address, especially if it is frequently being used on the Internet. • Don’t be afraid to change your public email address quite often. • Consider using a number of public addresses. That way you’ll have a better chance of tracing which services may be selling your address to spammers.

Never respond to any spam

Most spammers verify receipt and log responses. The more you respond, the more spam you’re likely to receive. Think before you click ‘unsubscribe’

Spammers send fake unsubscribe letters, in an attempt to collect active email addresses. If you click “unsubscribe” in one of these letters, it may simply increase the amount of spam you receive. Do not click on “unsubscribe” links in emails that come from unknown sources. Keep your browser updated

Make sure that you use the latest version of your web browser and that all of the latest Internet security patches have been applied. Use anti-spam filters

Only open email accounts with providers that include spam filtering. www.wscpa.org

CYBER SECURITY

Smartphone Security

martphones and other mobile devices can be vulnerable to cyberattacks and other threats, but following a few common sense security tips can help keep your device safe. Today’s smartphones are capable of doing so much more than the mobile phones of a few years ago – but this greatly extended range of capabilities has also seen the introduction of some new security risks. Because we’re using our phones for a much wider range of activities, from social networking to online shopping, banking, and surfing the web, we all need to take sensible precautions to ensure our phones and our information are safe from malware attacks and cybercriminals.

Security tips for safer smartphone use

Here are some useful tips from Kaspersky Lab’s team of Internet security experts: Keep it locked

Make sure your phone’s screen lock is on at all times so there’s less at risk if your phone falls into the hands of a cybercriminal.

©Getty Images/Tek Images

Encrypt your sensitive information

www.wscpa.org

If your phone includes data encryption features, make sure you use them. In the event of your phone being stolen, criminals will not be able to access the personal information that’s stored on your phone – if that information has already been encrypted. Monitor how apps behave on your phone

your phone. It’s especially important to do this for Android smartphones. Protect your phone and your data

Many users that wouldn’t ever consider running a laptop, PC, or Mac computer without anti-malware software forget that today’s smartphones are powerful computers and they are vulnerable to the same risks. Make sure you use a reputable anti-malware program on all of your mobile devices and ensure the antivirus databases are regularly updated. Be aware of the risks of jailbreaking / rooting

Although it might be tempting to root or jailbreak your phone, in order to access specific apps or services, this will strip away the security. To help keep your phone and your data secure don’t root or jailbreak your phone. Switch off Bluetooth when you can

If you’re not using your Bluetooth connection, it’s a great idea to switch it off. That way, you’ll make your phone less vulnerable to cyberattack and you’ll reduce the drain on your phone’s battery. Choose a smartphone security solution with anti-theft features

Some smartphone security products include a range of anti-theft features that give you remote access to your lost or stolen phone – so you can lock the phone, wipe data from it, and find its location. Reprinted with permission of Kaspersky Lab (usa.kaspersky.com), one of the world’s fasting-growing cybersecurity companies.

Be aware of permission access/ requests from applications running on WashingtonCPA Summer 2016

NEWS BRIEFS

AND THE WINNERS ARE...

IT Directors Committee The IT Directors Committee meets 3-5 times a year, usually at the WSCPA office in Bellevue, with the option to participate via telephone. Occasionally the committee will meet at a member’s office for “show and tell,” if they have installed a new technology and would like to share with the group. The committee works to facilitate an environment for information sharing between the members of the WSCPA. At each meeting the committee strives to:

Four WSCPA members were selected as winners from 6,461 entries in the annual dues drawing. Each winner received a $300 Amazon™ gift card. Congratulations and happy spending to these members: Christine Ricker – A student member since 2015, Christine is working toward earning her CPA license. She is a staff accountant at Alegria & Company, PS, in Yakima, and is interested in Accounting, Auditing and Assurance Services and Federal Tax. Mark Faller - Mark is the CFO at University Mechanical Contractors in Mukilteo, and has been a WSCPA member since 1989. He is very excited to be a winner!

Mimi Watanabe - Mimi joined the WSCPA in 1993. She has been working for hospitals since 2004, is a registered nurse and works for Valley Medical Center as a healthcare data analyst. One additional member, who works in Shoreline, preferred to remain anonymous, and was excited to be chosen as a winner. Thank you to all members who renewed their membership by June 1st and took the time to update contact information including areas of interest. If you have not selected your areas of interest, visit www.wscpa.org/mywscpa (login and click “Manage My Interests”) to ensure that you are receiving information that is of interest to you.

MEMBERS’ RECEPTION August 18 at Woodmark Hotel Kirkland, WA Register at www.wscpa.org/events Free for members | Limited space available

WashingtonCPA Summer 2016

• •

•

• •

Provide value to the committee membership; Assess and recommend technology services, processes, software and hardware that would be beneficial to members; Discuss the latest IT changes in an everchanging technologically advanced world; Seek innovative and creative opportunities in order to improve information technologies; Strive to make technology integrate seamlessly with your business; and Make technology an asset for your business, not a problem.

The WSCPA depends upon the active participation of member companies and their employees for the committee’s success. If you are already a committee member, but haven’t been active, consider attending. If you aren’t a member, join and learn how the IT Directors Committee might enhance your practice. To learn more contact memberservices@ wscpa.org or call (425) 644-4800. www.wscpa.org

NEWS BRIEFS

CALL FOR NOMINATIONS Join the WSCPA Board of Directors The WSCPA Board Governance Committee is accepting nominations for the 2017-2018 Board of Directors. To submit a nomination, contact Helen Doty (hdoty@wscpa.org). Nominations are due November 1.

AICPA, CIMA Members Overwhelmingly Approve Proposal to Advance Profession Members of the American Institute of CPAs (AICPA) and The Chartered Institute of Management Accountants (CIMA) have overwhelmingly approved a proposal to create a new, international accounting association that will integrate operations of both organizations, while preserving the existing membership bodies. Voting concluded in separate AICPA and CIMA membership ballots on June 16 and a supermajority of members who voted from both organizations endorsed the proposal.The AICPA ballot passed 86.5 percent to 13.5 percent, according to independent tabulator Survey and Ballot Systems. CIMA members endorsed the proposal 89.7 percent to 10.3 percent, according to their independent tabulator Electoral Reform Services. “In developing this proposal, we were careful to structure commitments to CPA and CGMA, CIMA and AICPA and public practice and management accounting,” said Barry Melancon, CPA, CGMA, AICPA President and CEO. “We are excited about crafting a path forward that reflects how the world is changing. At the same time, we will be extraordinarily mindful of protecting our collective history and the strong reputation both organizations have built over the past century. This is about building on what is great – and addressing an exciting evolving world.” The new association will represent more than 600,000 current and future accounting professionals and will raise the profile of public and management accounting in the U.S. and abroad. It will enhance resources, provide more market insights and have a stronger advocacy voice. AICPA members will get these benefits and automatic dual membership in the AICPA and new association as part of their regular AICPA dues, which will continue to be set and adjusted in line with historic norms. The AICPA will continue its strong partnership with state societies to promote, protect and grow the CPA. Fifty-two state CPA societies passed resolutions in support of the member ballot proposal, including the WSCPA, which welcomed the vote outcome. “This is an important milestone for the profession, one that will ultimately benefit accountants of today and tomorrow as they navigate accelerating complexity and change,” said Rich Jones, President and CEO of the WSCPA. The new association is expected to launch in 2017. Additional details will be provided as they become available in the coming months. www.wscpa.org

Free Monthly PCPS Resource In partnership with the AICPA Private Companies Practice Section (PCPS), the WSCPA offers a free rotating tool available every month atxwww.wscpa.org/pcpsresources. Past tools have included: • Cost of Turnover Worksheet • Overcoming Pricing Objections Tool, • Firm inMotion Transition Continuum and Checklist, • Business Development Expectations by Level Tool. Watch your Short Form for a link to the latest tool or visit the website.

In Memoriam The WSCPA holds in memory with families and the larger community, these members who have recently passed on: Tricia Adams Richard Brookbush Kenneth Domingues A. Estes Robert Farr Patricia Gardner Stephen Gardner Thomas McBride Phillip Mee Catherine Meyer Terry Nuzzo Patrick O’Shaughnessy Roy Ovist Henry Pierman Tom Saelid Susan Stewart Richard Swan Lo-Ying Wong Scott Wroblewski www.wscpa.org/community/ in-memoriam WashingtonCPA Summer 2016

NEWS BRIEFS

Join the conversation! LinkedIn

Are you a member of the WSCPA group on LinkedIn? Join the conversation today! Plus, follow WSCPA news and find event photos on Facebook and Twitter. Here are some of the recent discussions, news and posts:

Facebook

Twitter

Accounting for Rewards/Incentive Programs Washington State local and state tax update meeting WSCPA & Becker Student Reception event in Seattle Seeking HR/talent management recommendations for small businesses Self-service analytics using Tableau to answer common business questions

Connect with fellow members and participate in discussions at www.wscpa.org/linkedin

WSCPA Blog Read WSCPA News & Resources at www.wscpa.org/news Article submissions welcome. Contact webmaster@wscpa.org.

WashingtonCPA Summer 2016

Like the WSCPA on Facebook WashingtonCPAs

Follow the WSCPA on Twitter @wscpa

10 Perks You’ll Receive with Your New WSCPA Passport Corporate Card The Cost of Turnover Worksheet (July PCPS Tool) Six Tips for Starting an Advisory Practice IRS Warns of Latest Scam Variation Involving Bogus “Federal Student Tax”

www.wscpa.org

WashingtonCPA Summer 2016

2015-2016 AWARDS

2015-2016 Awards

very year the WSCPA recognizes individuals and businesses for making a difference in their communities, providing outstanding service, dedication or leadership to advance the accounting profession and the Society. Congratulations to this year’s honorees!

Lifetime Achievement Award James Ladd, CPA, CGMA

Business of the Year Award

Outstanding Volunteer Leader Award

CliftonLarsonAllen LLP

Lydia Ahn, CPA

For an exemplary career of leadership in the accounting profession and the community

For support of the WSCPA through volunteerism and sponsorship

Jim Ladd has demonstrated exceptional career-long leadership in public accounting, business, professional and community organizations. After graduating from Duke University, Jim joined Deloitte, where he served for 28 years and was managing partner in Seattle, New York and Tokyo. Following his retirement from Deloitte, he held senior officer roles with a number of businesses for 21 years. During his distinguished career, Jim has served on the boards of 20+ community organizations, including Seattle Children’s Hospital. A WSCPA member since 1966, he served on the WSCPA Board of Directors (2007-2012) and as WSCPA Board Chair (2010-2011). He is a member of the Washington State Board of Accountancy. Though he currently is semi-retired, Jim stays active with board membership and advisory roles.

“Over the years CliftonLarsonAllen staff have been actively engaged with the WSCPA,” said WSCPA President & CEO Rich Jones. “From board participation to conference planning and sponsorship, CLA has been an outstanding supporter of the WSCPA.” CLA staff currently sit on at least eight different committees, boards or chapters. They promote WSCPA and encourage their staff to get involved. CLA is a supporter of the Women’s Leadership Summit as a sponsor, actively helps with planning the Not-For-Profit Conference, and is a continuing sponsor of the Annual Meeting. One CLA partner participates on the executive committee of the Washington CPA Foundation, while another CLA staff member actively volunteers on the CPAPAC and several members have helped the Society build strong relationships with legislators.

WashingtonCPA Summer 2016

For leadership and dedication to the WSCPA Bellingham Chapter

Lydia Ahn, a Principal at Ahn Tax & Business Advisors, PLLC, took over as the WSCPA Bellingham Chapter Chair in 2015. Under her leadership, the chapter reinstated networking events and increased attendance at CPE events. “These changes have attracted new faces to the events and new board members to help with the planning. She is working with local chapter members to increase their connection to local colleges and help influence the next group of accounting majors to consider becoming a CPA,” said Amy O’Donnell, WSCPA Director of Member Services. Before founding Ahn Tax & Business Advisors, Lydia worked with CPA firms in Bellevue and Bellingham,WA and spent most of her career at a fast-growing CPA firm specializing in international tax and consulting. She is a member of the WSCPA International Tax Committee. www.wscpa.org

2015-2016 AWARDS

Outstanding Volunteer Leader Award

Brett Jordan, CPA

Jonathan McNicol, CPA

Susan Thomson-Sines, CPA

For years of active leadership in the WSCPA and the Washington CPA Foundation

For collaborative and inclusive leadership in the WSCPA South Puget Sound area chapters

“Brett Jordan is very dedicated to the profession and the WSCPA and has been an active volunteer for years,” said Kimberly Scott, WSCPA Vice President of Member Services. Brett, the chair of the Washington CPA Foundation, testified in 2015 in Olympia in support of legislation which created the Certified Public Accounting Scholarship Program. A graduate of the AICPA Leadership Academy, he serves on the WSCPA Seattle Chapter Board. Prior to joining the Foundation board, Brett served as the chair of the Society’s New Professionals Committee. A senior internal auditor for Russell Investments, Brett serves as Treasurer of the Municipal League of King County and board member of the Alumni Association of Western Washington University.

Jonathan McNicol has served as chair of the South Sound Industry Roundtable for the past two years. Recently, when the Society made the decision to merge the South Sound Industry Roundtable with the Tacoma Chapter, he was instrumental in bringing the two groups together. “Jonathan’s collaborative, efficient and inclusive leadership style has been a strong force behind the success of events in the Tacoma area,” said Amy O’Donnell, WSCPA Director of Member Services. “Jonathan has been trying new approaches for CPE events and regularly seeks feedback from attendees to improve the next event. We can always count on him to regularly promote events and programs of the WSCPA.” Jonathan has 17 years of accounting experience, including eight years as a Senior Accountant with Milgard Windows and Doors.

www.wscpa.org

For years of leadership and dedicated service to the WSCPA

Since joining the WSCPA in 1997, Susie Thomson-Sines has been an active volunteer and outstanding ambassador of the WSCPA. For several years she served on the Bellingham Chapter Board taking on many roles including chair and secretary. “The Bellingham Chapter was firing on all cylinders under her leadership,” said Tom Donaghy, WSCPA Vice Chair. She has also served on numerous committees for the Society. She was a member of the WSCPA Board of Directors (2005-07) and served as Chair and Trustee of the Washington CPA Foundation. The owner of Thomson & Company, PLLC in Bellingham, Susie currently serves on the Peer Review Executive and Peer Review System RAB Committees. She has over 18 years of experience in accounting and auditing, preparation of income taxes, and small business consulting and is active in serving her community. WashingtonCPA Summer 2016

2015-2016 AWARDS

Special Award

New Professional Award

Rising Star Award

Jennifer Sciba

Erika Hosea, CPA, CGMA

Rigoberto Garcia

For dedication to the CPA profession in Washington State

For passion and commitment to the WSCPA and the CPA profession

For passion and service to the WSCPA and accounting community

As Deputy Director of the Washington State Board of Accountancy (WBOA), Jennifer Sciba has been working as the Executive Director’s right hand for many years—first under Rick Sweeney, who retired early in 2016, and now under Charles Satterlund, the new Executive Director. As the supervisor of WBOA operations, Jennifer strives to uphold public protection and provide excellent customer service. She has been instrumental in maintaining a strong working relationship between the WSCPA and the WBOA. “She always graciously helps our staff, finding solutions to problems and often helping us to avoid surprises,” said Kimberly Scott, WSCPA Vice President of Government and Member Relations. “She cares deeply about the CPA profession. Maintaining the integrity and value of the designation in our state is very important to her. Washington State is fortunate to have her in her role at the state board.”

“Erika Hosea has been in the profession for years working in industry. She was an engaged and active volunteer even before earning her CPA license in 2014,” said Kimberly Scott, WSCPA Vice President of Government and Member Relations. Erika began her career with KPMG implementing full scale enterprise solutions for Fortune 500 organizations. She has worked for T-Mobile, Alaska Airlines, and Washington State Department of Labor and Industries. Currently, Erika is President of Elite Strategies, LLC and is the WSCPA Bellevue Chapter Board Chair and just began a term on the WSCPA Board of Directors. She served on the New Professionals Committee (2010-14), serving as Co-Chair (2012-13). Erika actively participates in events to encourage students of all backgrounds to become CPAs and WSCPA members. She is treasurer for the Accounting Career Awareness Program.

Since joining the WSCPA as a student member, Rigoberto Garcia has been an ambassador for the Society and the Washington CPA Foundation scholarship program on his campus, Seattle University (SU). A scholarship recipient since 2015, Rigo regularly attends WSCPA networking events and is a member of the Tacoma Chapter Board. The first member of his family to attain higher education and an honors graduate of Highline College, Rigo is a senior at SU and Vice President of Programming for Beta Alpha Psi. He was awarded the SU Messina Scholarship and Pride Foundation-GSBA scholarships for his impressive academic performance and community service and will pursue his master’s in accounting at SU. “We look forward to seeing the outstanding impact Rigoberto will continue to have on the profession,” said Monette Anderson, WSCPA Academic Relations Coordinator. Rigo will sit for the CPA exam and begin an internship at EY in January 2017.

WashingtonCPA Summer 2016

www.wscpa.org

2015-2016 AWARDS

2016-2017 Awards CALL FOR NOMINATIONS Submit your nomination for 2016-2017 awards by March 15, 2017 at www.wscpa.org/community/awards

LIFETIME ACHIEVEMENT AWARD

Chair’s Award

President’s Award

Joseph Paul Smith, CPA, CGMA

William Simer, CPA

For support of the WSCPA in the Spokane area, especially in college outreach, legislation and the scholarship program

Prototype Leader: gracious, inclusive, energetic, interesting, smart and fun

“Looking back at the accomplishments of the past year the successful roll out of the scholarship program was clearly the high point of my year as chair,” said Bill Simer, CPA, WSCPA Chair for 2015-2016. “This success is due to the efforts of many but one member of our board stood out in his support and ‘boots on the ground’ effort. I am pleased to recognize Joe Smith as the recipient of the Chairs Award this year for his support of the Scholarship program.” As the Associate Vice President of Finance and an adjunct professor of accounting at Gonzaga University in Spokane, Joe understands the importance of scholarship support and he took a lead role in promoting the scholarship program to colleges and universities throughout the state. Prior to joining Gonzaga, Joe was a Senior Manager in the audit practice of KPMG LLP in Seattle. He serves as a board member for Catholic Housing Communities (a division of Catholic Charities of Spokane) and RiteCare of Washington.

“Bill Simer, WSCPA Board Chair for 2015-2016, is a tremendous role model and representative of the CPA profession,” said Rich Jones, WSCPA President & CEO. Bill is a tax partner in the Spokane office of Eide Bailly, a large regional firm headquartered in North Dakota. He agreed to become Chair of the WSCPA Board of Directors during the time that his firm was merging into Eide Bailly. During his year as Board Chair he presented Professional Issue Updates to several chapters. Bill was an advocate for increasing the strategic importance of our chapters and personally demonstrated his support of this initiative by attending as many chapter events as possible. He went above and beyond by testifying three times in front of the Washington legislature to support a bill sponsored by the WSCPA that allows out-of-state firms doing attest work to perform that work in Washington without registering with the state board or paying additional fees.

www.wscpa.org

Recognizes a current or former WSCPA member for a career of leadership and dedicated service to the accounting profession and as an exemplary role model for other CPAs.

COMMUNITY LEADERSHIP AWARD

Recognizes a WSCPA member whose respected leadership in community organizations has enhanced the image or public perception of CPAs.

COMPANY OR FIRM OF THE YEAR AWARD

Recognizes a company or firm that provides noteworthy support to the WSCPA and its members.

SPECIAL AWARD

Recognizes an individual who is not a CPA but has supported or promoted the activities of CPAs and the WSCPA.

OUTSTANDING VOLUNTEER LEADER AWARD

Recognizes an active WSCPA member for outstanding service and dedication and/or innovative and inspirational WSCPA leadership.

NEW PROFESSIONALS AWARD

Recognizes an active WSCPA member who has been a CPA for fewer than 10 years for outstanding WSCPA leadership.

RISING STAR AWARD

Recognizes a WSCPA member who is in the process of obtaining a CPA License for active WSCPA leadership, dedication, and service.

WashingtonCPA Summer 2016

ADVOCACY

Supporting the CPAPAC: What it means and why your contribution is important By Kimberly Scott, CAE

hen you contribute to the CPAPAC, you provide essential support to the WSCPA’s advocacy efforts. The WSCPA is the only professional association advocating for CPAs in Olympia. The CPAPAC provides contributions to the campaigns of legislators who sit on key committees, are CPAs or have shown support for the profession. Contributions are delivered in person so that local CPAs can build relationships with their legislators. These relationships are essential to ensuring that legislators understand the value of a CPA. It is important to understand that the CPAPAC is bipartisan, and does not endorse candidates.

•

State Board Relations: Rich Jones, WSCPA CEO, and I attend the WBOA’s quarterly meetings, and participate in other meetings throughout the year. The WSCPA provides both feedback and public testimony during the rule-making process. The two organizations have a great working relationship and work collaboratively on issues when necessary. Here are some WBOA highlights:

Washington State Elections

In case you have missed the news, 2016 is a major election year. What that means in Washington State is that all House seats and half of the Senate seats are up for election. We also will be electing a Governor, Lieutenant Governor, State Auditor and State Treasurer, to name a few. The WSCPA is not expecting to bring any legislation forward this year; however, we expect, as in recent years, that the Society may want to weigh in on any proposed legislation related to taxes or issues affecting the profession. This summer dozens of WSCPA members and advocacy staff are visiting with legislators to get a better understanding of what may be happening in Olympia in 2017.

Recent Washington State Highlights

State Legislation: The WSCPA is always watching for legislation that could directly affect the profession.The WSCPA also drafts legislation when necessary to amend our statute, or other statutes that may affect the way a CPA can do business in Washington State. When bills are being heard, WSCPA member volunteers and staff travel to Olympia to testify on issues.

WashingtonCPA Summer 2016

House Bill 2148, which did not pass and was not drafted by the WSCPA, would have allowed CPA firms to audit municipalities that are currently only able to receive an audit from the State Auditor’s Office. While the concept of the bill was satisfactory, some language in the proposed legislation would have caused issues for CPAs.

•

The new Executive Director, Charles Satterlund, started his term in office as of February 8, 2016. Unlike in most other states, in Washington State the Governor appoints the Executive Director.

•

The WBOA has three new board members who were officially appointed to the board by the Governor in July 2016. In total the WBOA has nine members, six CPA members and three public members. The three newly appointed members are: Mark Hugh, CPA Member, Public Accounting; Joel Cambern, Public Member, Banker; Rajib Doogar, Public Member, Educator.

2015 - WSPCA passed two bills: • House Bill 1263 provides an exemption for CPAs in the Private Investigator Statute. •

Senate Bill 5534 creates a scholarship fund for accounting students in Washington State. This was funded by money from the Washington State Board of Accountancy (WBOA) that would otherwise would have been moved to the state general fund.

2016 - WSCPA passed one bill: • House Bill 2433 aligns the Washington Accountancy Act with the Uniform Accountancy Act. The bill updates the definition of attest and allows firm mobility (similar to individual CPA mobility).

National Highlights

WSCPA advocacy staff attend the NASBA (National Association of www.wscpa.org

State Boards of Accountancy) meetings twice a year with WBOA members, where we stay informed about topics being discussed by national and international regulators. The WSCPA leaders and key staff also attend AICPA council and leadership meetings to better understand national and global issues. Leaders and staff also meet every other year in Washington, D.C. with our state senators and Congressmen and women to discuss www.wscpa.org

key issues affecting the profession. Without your monetary support the WSCPA would not be able to be such an effective watchdog and advocate for the profession. Contributions can be made online by the individual or via check mailed to the CPAPAC 902 140th Ave NE, Bellevue WA 98005. For questions about contributions or the Societyâ&#x20AC;&#x2122;s advocacy efforts, please contact me at kscott@wscpa.org or (425) 586-1108.

Kimberly Scott is WSCPA Vice President of Government and Member Relations.

WashingtonCPA Summer 2016

2016-2017 Scholarships Accounting Students Receive $230,000 in Scholarships By Kimberly Scott, CAE, Executive Director, Washington CPA Foundation

he Washington CPA Foundation is extremely grateful that so many WSCPA members choose to contribute to the Foundation.Your generous contributions ensure that the Foundation can continue to foster the next generation of CPAs in Washington State through scholarships. Not only are you helping the students listed here, but you are also ensuring the successful future of accounting in Washington State. For the 2016-17 school year, the Foundation awarded 46 scholarships for a total of $230,000. These scholarships are possible thanks to contributions from individuals, and from organizations via the named scholarship program, and the new Certified Public Accounting Scholarship Program. In 2015, the Washington State legislature passed substitute Senate Bill 5534 which created the Certified Public Accounting Scholarship Program, to be administered by the Washington CPA Foundation. The final State Operating Budget for 2015-17 allocated a total of $3.3 million to this program, which was effective July 24, 2015. In 2016, the program funded 35 $5,000 scholarships. The Foundation also awarded eight named scholarships, two endowed scholarships and one Foundation Ph.D. scholarship for accounting students in Washington State. Congratulations to this yearâ&#x20AC;&#x2122;s scholarship recipients!

George J. Waterman Memorial Scholarship

Christine Upton Western Governors University

WashingtonCPA Summer 2016

KPMG Accounting Scholarship Amanda Staten University of Washington

Clark Nuber Accounting Scholarship Colin Williams Seattle Pacific University

EY Accounting Scholarship

Megan Stevens University of Washington

Moss Adams Accounting Scholarship Daniel Verburg Seattle University

www.wscpa.org

WASHINGTON CPA FOUNDATION

Peterson Sullivan Accounting Scholarship Jordan Berg Pacific Lutheran University

PWC Accounting Scholarship

Tomoki Yamaguchi University of Washington

Roy J.Polley Memorial Scholarship

Sambataro Family Accounting Scholarship

Shimer Family Foundation (Deloitte) Scholarship

Washington CPA Foundation Accounting Scholarship

Michiru Tsuji Seattle University

Washington CPA Foundation Accounting Scholarship Clare Beusch University of Washington

www.wscpa.org

Samantha Belleque Gonzaga University

Washington CPA Foundation Accounting Scholarship Danielle Bradley Pacific Lutheran University

Trey Takara Seattle University

Michelle Bauer University of Washington

Washington CPA Foundation Accounting Scholarship Jessica Butler Seattle Pacific University

WashingtonCPA Summer 2016

WASHINGTON CPA FOUNDATION

Washington CPA Foundation Accounting Scholarship

Washington CPA Foundation Accounting Scholarship Kyle Engman Western Washington University

Washington CPA Foundation Accounting Scholarship

Matthew Evans Central Washington University - Ellensburg

Washington CPA Foundation Accounting Scholarship

Elizabeth Covillo Eastern Washington University

Spencer Ekle Western Washington University

Dylan Gale University of Washington - Bothell

WashingtonCPA Summer 2016

Michael De La Cruz University of Washington

Rigoberto Garcia University of Washington - Tacoma

Robert Dowdle Western Washington University

Whitney Godby Western Washington University

www.wscpa.org

WASHINGTON CPA FOUNDATION

Washington CPA Foundation Accounting Scholarship

Elizabeth Gray University of Washington

Samuel Hardy Washington State University - Vancouver

Casey Heim Central Washington University - Ellensburg

Washington CPA Foundation Accounting Scholarship

Adama Kandeh University of Washington - Bothell

Thomas Leake Eastern Washington University

www.wscpa.org

Morghan Kruml Western Washington University

Minae Lee Gonzaga University

Tara Lambert Doctoral Candidate Whitworth University

Cuong Luong Seattle University

WashingtonCPA Summer 2016

WASHINGTON CPA FOUNDATION

Washington CPA Foundation Accounting Scholarship

Jenna Metzer Gonzaga University

Allison Rae University of Washington - Bothell

Kayla Shewbert University of Washington - Tacoma

WashingtonCPA Summer 2016

Britta Nelson Whitworth University

Kira Regester University of Washington at Bothell

Victoria Simboli Eastern Washington University

Preston Paulson Western Washington University

Megan Rykaczewski Gonzaga University

Tserenlkham Tsogbadrakh Whitworth University

www.wscpa.org

WASHINGTON CPA FOUNDATION

Thank you for your continued support of the future of the accounting profession. If you would like more information

Washington CPA Foundation Accounting Scholarship Madeleine Verspieren Gonzaga University

Washington CPA Foundation Accounting Scholarship

Katherine Walter Washington State University - Pullman

about the Foundation or how to contribute, please contact Kimberly Scott at kscott@wscpa.org.

How to apply Starting in fall 2016, apply online at www.wscpa.org/scholarships for 2017-2018 scholarships. Application deadline: February 2017.

Washington CPA Foundation Accounting Scholarship Allison Wonn Gonzaga University

Washington CPA Foundation Accounting Scholarship Bryan Wyche Gonzaga University

Help Select Next Yearâ&#x20AC;&#x2122;s Scholarship Recipients JOIN THE SCHOLARSHIP REVIEW TEAM Do you want to help give away $275,000 in scholarships? Would you like to read about and meet some amazing students? Are you interested in helping students achieve their dream of becoming a CPA? Are you available during February and March to participate in online training and review scholarship applications?

Washington CPA Foundation Accounting Scholarship Torrey Yost Western Washington University

www.wscpa.org

If so, please consider volunteering your time and talent to be part of the review team for the 2017 Accounting Scholarships offered by the Washington CPA Foundation and the Washington Society of CPAs. To learn more, contact Jocelyn Nystrom at (425) 586-1114 or jnystrom@wscpa.org. WashingtonCPA Summer 2016

WashingtonCPA Summer 2016

www.wscpa.org

TECH TIP

Using Excel’s Flash Fill Tool to Clean Up a QuickBooks Trial Balance By K2 Enterprises

©iStock by Getty Images/Skip ODonnell

xcel 2013 introduced Flash Fill, a great feature for manipulating data in a number of ways. You can use Flash Fill to format data, parse or split apart data, and concatenate or join data. And as you will see in this tip, you can use Flash Fill to clean up a QuickBooksgenerated Trial Balance report and put it in a format that most accountants prefer. To begin, export the Trial Balance report from QuickBooks into Excel by opening the report in QuickBooks and choosing the Export option. Upon doing so, your report will look similar to the one pictured in Figure 1 (with some rows hidden for presentation purposes). What is problematic in this case, to many accountants, is the presence of the account numbers and account names in the same column in the Excel worksheet. Additionally, subaccounts in the same cell as their parent account – such as Federal Withholding sharing cell A21 with Payroll Liabilities – is also an issue for many. Fortunately, we can quickly reformat this report in Excel using Flash Fill. Flash Fill is a pattern-recognition tool, meaning that it manipulates data based on patterns that you specify. Flash Fill is not perfect, as it will not always interpret the patterns correctly. However, as you provide additional guidance to Flash Fill, it “learns” from its mistakes.

Figure 1 - Exported QuickBooks Trial Balance

To address the issues identified with the report in Figure 1, begin by specifying the pattern you want Flash Fill to use. In this case, we will enter “10100” for the Account No field in cell D2 and “Checking” for theAccount field in cell E2, as shown in Figure 2. Next, we click in cell D2 and execute Flash Fill by using either a CTRL + E keyboard shortcut or by choosingFlash Fill www.wscpa.org

Figure 2 - Establishing a Pattern for Flash Fill WashingtonCPA Summer 2016

TECH TIP

from the Data tab of the Ribbon. Based on the pattern it recognized, Flash Fill provides the results shown in Figure 3 – a good start, but not exactly what we were looking for because Flash Fill did not correctly interpret the pattern as it relates to the nested subaccounts. We can manipulate the preliminary results generated by Flash Fill by providing the tool with some additional guidance. Simply click in cell E21 and type “24010” – the subaccount number. Upon doing so and pressing enter, Flash Fill’s pattern recognition engine interprets this additional guidance and generates the results shown in Figure 4. Notice that Flash Fill has correctly extracted all of the Account Numbers from column A and placed them in corresponding cells in column D. With the Account Number field addressed, let us now focus on the Account Name field. Because we have already established a pattern in cell E2 for Flash Fill to use, all that is necessary is to click in cell E2 and run Flash Fill. Upon doing so, Flash Fill provides the results illustrated in Figure 5.

Figure 3 - Preliminary Flash Fill Results

Figure 4 - Updated Flash Fill Results

In a matter of just a few seconds, we have completely cleaned up the report using this incredibly simple, yet powerful, feature of Excel.

Summary

Flash Fill – added to the Excel 2013 release – is indeed a versatile and powerful tool. Using pattern-recognition algorithms, Flash Fill was able to quickly address the formatting issues that many QuickBooks users have with Trial Balance reports generated by the application. Of course, the usefulness of Flash Fill doesn’t end there...give it a try whenever you have a set of data you need to manipulate. For a video demonstration of this tip, please visit www.tinyurl.com/k2tips196.

Figure 5 - QuickBooks Trial Balance Report Cleaned up by Excel's Flash Fill Tool

Learn More AUGUST 25 Technology For CPAs Don’t Get Left Behind Bellevue - 8 CPE credits

AUGUST 26 Excel Best Practices Bellevue - 8 CPE credits

Find more technology courses, including webinars at ww.wscpa.org/cpe

WashingtonCPA Summer 2016

www.wscpa.org

CPE Digest COMING IN AUGUST

Cutting Edge Tax Strategies from Dynamic Duo Koutelieris & White

Come and learn from the dynamic duo of White and Koutelieris, two of our great local tax instructors.You’ll enjoy their high energy, often humorous CPE presentations. George and Greg will take complicated tax topics and make them easily understandable. Join them at the WSCPA in Bellevue or via webcast for these seminars: AUG 17

Real Estate Taxation: Cutting Edge Tax Strategies in the Taxation of Real Estate Cutting Edge Tax Strategies LLC (17GGRETAU, Webcast 17WWGGRETA)

AUG 24

S-Corporation Taxation: Cutting Edge Tax Strategies for Entities Taxed as S Corporations (17GGSCOAU, Webcast 17WWGGSOAU)

“These guys are great. I took the class because these two were teaching. Great course.” - past attendee www.wscpa.org

WashingtonCPA Summer 2016

EDUCATION AND EVENTS Date

Course

CPE Credits

Code

Type

EVENTS BY LOCATION WSCPA education and events scheduled for August - October 2016 are listed below, chronologically by location. If you are looking for a program in another location, it may be scheduled for later in the year. Using the online CPE & Event Catalog at www.wscpa.org/cpe/ catalog, you can search by location. LEARN MORE To view complete course details, please visit the CPE & Event Catalog at www.wscpa.org/cpe/catalog.

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

NEW CPE events added throughout year to: www.wscpa.org/cpe/catalog

A&A CS EB PFP

SUBJECTS The main subject area is listed for each program.

Ethics GNP MG PD SK TAX

NEED HELP finding a seminar or webcast? Call (800) 272-8273 or (425) 644-4800.

TEC

Subject

Accounting and Auditing Consulting Services Employee Benefits Estate/Financial Planning Ethics Government / NFP Management Personal Development Specialized Knowledge Taxation Technology

Fees

Date

CPE Credits

Course

Type

Code

For more details, search by code at www.wscpa.org/cpe

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Bellevue 8/11

8/12

8/15

8/16

8/17

8/18

Multi-State Taxation of Business, 8am-4pm

17MSTBAU

310

410

WSCPA

TAX

Webcast also available

17WWMSTBAU

300

400

Webcast

TAX

Income Taxation of Trusts and Estates: Planning and Preparation of Form 1041, 8am-4pm

17ITTEAU

310

410

WSCPA

TAX

Webcast also available

17WWITTEAU

300

400

Webcast

TAX

Preparing Form 1041: Understanding the Basics, 8am-4pm

17PF41AU

310

410

WSCPA

TAX

Webcast also available

17WWPF41AU

300

400

Webcast

TAX

Preparing Form 1120s: Understanding the Basics, 8am-4pm

17PFOSAU

310

410

WSCPA

TAX

Real Estate Taxation: Cutting Edge Tax Strategies in the Taxation of Real Estate, 8am-4pm

17GGRETAU

310

410

WSCPA

TAX

Webcast also available

17WWGGRETA

300

400

Webcast

TAX

FASB Review: Common GAAP Issues Impacting All CPAs, 8am-4pm 17FRUAU

305

405

-30

WSCPA

A&A

Webcast also available

17WWFRUAU

295

395

-30

Webcast

A&A

Internal Control Best Practices for Small and Medium-Sized Entities, 8am-4pm

17ICSMAU

305

405

-30

WSCPA

A&A

Webcast also available

17WWICSMAU

295

395

-30

Webcast

A&A

Social Security, Medicare and Prescription Drug Retirement Benefits: What Every Baby Boomer Needs to Know, 8am-4pm

17SSRBAU

320

420

WSCPA

TAX

Webcast also available

17WWSSRBAU

310

410

Webcast

TAX

Surgent Comprehensive Guide to Tax Depreciation, Amortization and Property Transactions from Acquistion to Exchange or Disposition, 8am-4pm

17TDAPAU

320

420

WSCPA

TAX

Webcast also available

17WWTDAPAU

310

410

Webcast

TAX

S-Corporation Taxation: Cutting Edge Tax Strategies for Entities Taxed as S-Corporations, 8am-4pm

17GGSCOAU

310

410

WSCPA

TAX

Webcast also available

17WWGGSOAU

300

400

Webcast

TAX

Partnership Taxation, 8am-4pm

17PTSAU

525

625

WSCPA

TAX

8/19

8/22

8/23

8/24

8/25-26

Webcast also available

17WWPTSAU

515

615

Webcast

TAX

8/25

Technology For CPAs - Don't Get Left Behind, 8am-4pm

17TECAU

305

405

WSCPA

TEC

8/26

Excel Best Practices, 8am-4pm

17EBPAU

305

405

WSCPA

TEC

9/7

Statements on Standards for Accounting and Review Services Annual Update and Review (including the Compilation and Review Standards) by Walter Haig, 8am-4pm

17CRURST07

325

425

WSCPA

A&A

Webcast also available

17WWCRURST

315

415

Webcast

A&A

ç New |  Non-tech credits |

WashingtonCPA Summer 2016

Networking event

www.wscpa.org

CPE Credits

Course

EDUCATION AND EVENTS Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

10/20

Fraud Update: Detecting and Preventing the Top Ten Fraud Schemes, 8am-4pm

17TTFSOC

305

405

10/20

Rental Real Estate, 8am-4pm

17RREOC

305

405

Webcast also available

17WWRREOC

295

395

10/21

Identity Theft: Preventing, Detecting, and Investigating, 8am-4pm

17IDENTOC

305

405

10/21

Like Kind Exchanges & Involuntary Conversions, 8am-4pm

17LKEOC

305

Webcast also available

17WWLKEOC

10/24

Internal Control and COSO Essentials for Financial Managers, Accountants and Auditors, 8am-4pm

17ICDADOC

10/24

Fiduciary Income Tax Returns - Form 1041 Workshop, 8am-4pm

-30

WSCPA

A&A

WSCPA

TAX

Webcast

TAX

WSCPA

A&A

405

WSCPA

TAX

295

395

Webcast

TAX

305

405

WSCPA

A&A

171041OC

320

420

WSCPA

TAX

Webcast also available

17WW1041OC

310

410

Webcast

TAX

Financial Statement Analysis: Basis for Management Advice, 8am-4pm

17FSABMOC

305

405

-30

WSCPA

A&A

Webcast also available

17WWFSABMO

295

395

-30

Webcast

A&A

Advanced Selected Issues for Trust, Estates and Their Beneficiaries, 8am-4pm

17ITEBOC

320

420

WSCPA

TAX

WSCPA

-30

10/25

10/26

Financial Forecasting and Decision Making, 8am-4pm

17FFMDOC

305

405

10/27

Combating Fraud: Turning Vulnerability to Victory Every Day, 8am-4pm

17CFVVOC

320

420

WSCPA

A&A

Webcast also available

17WWCFVVOC

310

410

Webcast

A&A

10/27-28

Excel Boot Camp- Two Days of Intensive Excel Training, 8am-4pm

17EBCOC

525

625

WSCPA

TEC

10/28

Annual Accounting and Auditing Update, 8am-4pm

17ACAUOC

320

420

WSCPA

A&A

Webcast also available

17WWACAUOC

310

410

Webcast

A&A

10/31

IRA Boot Camp, 8am-4pm

17IRABOC

320

420

WSCPA

TAX

Financial Accounting Standards and Financial Reporting Standards: The Annual Update and Review of GAAP, Special Purpose Frameworks, the SSARS, and the AICPA Auditing Standards, 8am-4pm

17ARSURAU

590

690

The Coeur d'Alene

A&A

-30

Coeur d'Alene 8/18

Kirkland 8/18

N S

Members' Reception at Woodmark Hotel

17NPAU18

Woodmark Hotel

l S

Bocce Ball-Rhein Haus 2016

17CHSEOC20

Rhein Haus

2016 Governmental Accounting & Auditing Update WEBCAST, 7am-3pm

17WBAAU11A

195

245

Webcast

GNP

Seattle 10/20

Your Desk - Webcast and Webinars 8/11

8/11

What Advisors Need to Know Regarding Social Security Changes due to the Bi-Partisan Budget Bill WEBINAR, 12pm-2pm

17WNCAU11A

Webinar

TAX

8/12

Entity Choice - Tax Considerations WEBCAST, 8:30am-4:30pm

17WBCAU12A

275

375

Webcast

TAX

8/12

IRA/ Roth IRA Planning Strategies WEBINAR, 11am-1pm

17WNCAU12A

Webinar

TAX

8/15

AICPA's Applying the Uniform Guidance for Federal Awards in Your Single Audits WEBCAST, 7:30am-3:30pm

17WBBAU08A

249

319

Webcast

GNP

8/15

Federal Taxation of Legal Marijuana WEBCAST, 9am-1pm

17WBAAU15A

129

159

Webcast

TAX

8/15

Not-for-Profit Organizations: Accounting and Auditing Principles and Applications WEBCAST, 8:30am-4:30pm

17WBCAU15A

275

375

Webcast

GNP

8/15

Performance Auditing Essentials WEBINAR, 8am-10am

17WNCAU15A

Webinar

A&A

8/16

2016 Financial Statement Preparation, Compilation, and Review WEBCAST, 7am-3pm

17WBAAU17A

195

245

Webcast

A&A

8/16

Passive Activity Rules and the Net Investment Income Tax WEBINAR, 12pm-2pm

17WNCAU17A

Webinar

TAX

8/17

Advanced Fraud Case Study: Part 1 (25% California Content) WEBCAST, 8:30am-12pm

17WBCAU17B

140

188

Webcast

A&A

ç New |  Non-tech credits |

www.wscpa.org

Networking event

WashingtonCPA Summer 2016

EDUCATION AND EVENTS Date

CPE Credits

# 9/8

Course

Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

Financial Accounting Standards for Small- and Medium-Sized Businesses: The Annual Update and Review of GAAP and the Tax, Cash, and AICPA Special Purpose Frameworks by Walter Haig, 8am-4pm

17ASURST08

325

425

WSCPA

A&A

Webcast also available

17WWASURST

315

415

Webcast

A&A

9/9

The Business Financial Health Checkup: A Process to Identify Misstatements and Profitability Roadblocks Using Analytical Procedures by Walter Haig, 8am-4pm

17BFHCST09

325

425

WSCPA

A&A

9/12

Financial Statement Presentation and Disclosure– 2016, 8am-4pm

17FSPDST

305

405

WSCPA

A&A

Webcast also available

17WWFSPDST

295

395

Webcast

A&A

9/13

Annual Accounting Update for Accountants in Industry - 2016, 8am-4pm

17AAUDIST

305

405

WSCPA

A&A

Webcast also available

17WWAAUDI

295

395

Webcast

A&A

9/16

Washington Tax and New Developments, 8am-4pm

17WSTXST

305

405

WSCPA

TAX

Webcast also available

17WWWSTXST

295

395

Webcast

TAX

9/19

Yellow Book: Government Auditing Standards, 8am-4pm

17EOYBST

305

405

-30

WSCPA

GNP

Webcast also available

17WWEOYBST

295

395

-30

Webcast

GNP

9/20

Audits of State and Local Governments: What You Need to Know, 8am-4pm

17AUSLST

305

405

-30

WSCPA

GNP

9/22

The Complete Guide to Payroll Taxes and 1099 issues, 8am-4pm

17CGPTST

320

420

WSCPA

TAX

Webcast also available

17WWCGPTST

310

410

Webcast

TAX

Surgent McCoy's Handbook for Mastering Basis, Distributions and Loss Limitation Issues for S Corporations, LLC, 8am-4pm

17HMBIST

320

420

WSCPA

TAX

Webcast

TAX

Y Y

9/23

Webcast also available

17WWHMBIST

310

410

9/29

Transforming Your Role as Controller to Business Partner, 8am-4pm

17COBPST

305

405

-30

WSCPA

9/29

Employment Law Update: Key Risks and Recent Trends, 8am-4pm

17LAWUST

305

405

-30

WSCPA

Webcast also available

17WWLAWUST

295

395

-30

Webcast

Advanced Business Law for CPAs, 8am-4pm

17ABLTST

305

405

-30

WSCPA

Webcast also available

17WWABLTOC

295

395

-30

Webcast

Common Frauds and Internal Controls for Revenue, Purchasing and Cash Receipts, 8am-4pm

17CFICOC

305

405

-30

WSCPA

A&A

Webcast also available

17WWCFICOC

295

395

-30

Webcast

A&A

Real Estate Accounting & Auditing, 8am-4pm

17REAAOC

305

405

-30

WSCPA

A&A

Webcast also available

17WWREAAOC

295

395

-30

Webcast

A&A

Form 990: Mastering Its Unique Characteristics with Jane Searing, 8am-4pm

17EOF990OC

305

405

-30

WSCPA

TAX

Webcast also available

17WWEOF9OC

295

395

-30

Webcast

TAX

4 Most Overlooked Business Risks: Preparing for the Future, 8am-4pm

17MOBROC

305

405

WSCPA

A&A

Webcast also available

17WWMOBROC

295

395

Webcast

A&A

Executive Education's Annual CFO Spotlight: 4 Select Issues, 8am-4pm

17ACFOSOC

305

405

WSCPA

Webcast also available

17WWACFOSO

295

395

Webcast

Annual Update for Controllers, 8am-4pm

17SKSBOC

305

405

-30

WSCPA

Webcast also available

17WWSKSBO

295

395

-30

Webcast

Getting on Top of It All: The New Science of Increasing Productivity in Yourself and Others, 8am-4pm

17GOTOC

305

405

WSCPA

Webcast also available

17WWGOTOC

295

395

Webcast

Achieving Balance in Work and Life, 8am-4pm

17ABWLOC

305

405

WSCPA

Webcast also available

17WWABWLOC

295

395

Webcast

9/30

10/3

10/4

10/7

10/13

10/14

10/17

10/18

10/19



ç New |  Non-tech credits |

WashingtonCPA Summer 2016

Networking event

www.wscpa.org

CPE Credits

Course

EDUCATION AND EVENTS Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

8/17

Advanced Fraud Case Study: Part 2 (25% California Content) WEBCAST, 1pm-4:30pm

17WBCAU17C

140

188

Webcast

A&A

8/17

AICPA's Preparation, Compilation, and Review Engagements Update WEBCAST, 10am-2pm

17WBBAU17A

159

199

Webcast

A&A

8/17

Creating Equity Compensation Plans WEBINAR, 9am-11am

17WNCAU17B

Webinar

8/17

Preparing Form 5500 WEBCAST, 8:30am-4pm

17WBCAU17A

275

375

Webcast

TAX

8/18

Deception, Embezzlement and Fraud WEBCAST, 8:30am-4:30pm

17WBCAU18B

275

375

Webcast

A&A

8/18

PATH ACT 2015 - Emphasis on Depreciation & Cost Segregation WEBCAST, 10am-12pm

17WBAAU18A

109

Webcast

TAX

8/18

Real Estate Tax Update: Key Changes for Investors and Owners WEBINAR, 10am-12pm

17WNCAU18A

Webinar

TAX

8/18

The Top Ten Business Myths WEBCAST, 8:30am-4:30pm

17WBCAU18A

275

375

Webcast

8/19

AICPA's Audit Workpapers: Reviewing Field Work WEBCAST, 10am-2pm

17WBBAU19A

159

199

Webcast

A&A

8/19

Effective Tax Return and Cash Flow Analysis WEBCAST, 8:30am-4pm

17WBCAU19A

275

375

Webcast

8/19

Individual Tax Planning Topics WEBCAST, 8:30am-4pm

17WBCAU19B

275

375

Webcast

TAX

8/19

Leveraging Social Technologies to Increase Firm Profits WEBINAR, 7am-9am

17WNCAU19A

Webinar

TEC

8/22

AICPA's Identity Theft: Preventing, Detecting, and Investigating WEBCAST, 7:30am-3:30pm

17WBBAU22A

159

199

Webcast

8/22

Captive Insurance: An Effective Financial and Risk Management WEBINAR, 7am-9am

17WNCAU22A

Webinar

TAX

8/22

Corporate Income Tax Return Fundamentals WEBCAST, 8:30am4:30pm

17WBCAU22A

275

375

Webcast

TAX

8/22

Other Comprehensive Basis of Accounting Fundamentals WEBCAST, 8:30am-4pm

17WBCAU22B

275

375

Webcast

A&A

8/23

Expense Management via the Cloud WEBINAR, 11am-1pm

17WNCAU23A

Webinar

TEC

8/23

Fraud: Essential Audit Tools and Techniques WEBCAST, 8:30am-12pm

17WBCAU23A

140

188

Webcast

A&A

8/23

Mitigating Fraud Engagement Risk for Nonaudit Practitioners WEBCAST, 12:30pm-4pm

17WBCAU23B

140

188

Webcast

A&A

8/24

Financial Fitness Forever - Five Steps to More Money, Less Risk and More Peace of Mind WEBCAST, 9am-12pm

17WBAAU24B

Webcast

PFP

8/24



Leaders Eat Last: The Characteristics of Great Leaders WEBINAR, 9am-11am

17WNCAU24A

Webinar

8/24

Single Audits: A Case Study Approach WEBCAST, 8:30am-4:30pm

17WBCAU24A

275

375

Webcast

GNP

8/24

Winning at the Bank - Making the Best of Your First Impression WEBCAST, 9am-11am

17WBAAU24A

109

Webcast

8/25

AICPA Conflicts of Interest: A New Approach WEBCAST, 9am-10am

17WBAAU25A

Webcast

8/25

AICPA Independence Rules - A New 2016 Approach WEBCAST, 10am-11am

17WBAAU25B

Webcast

8/25

Retirement Plans in the Closely Held Business - A Tax Planning Perspective WEBINAR, 9am-11am

17WNCAU25A

Webinar

TAX

8/25

Staying Current with Nonprofit Accounting and Auditing WEBCAST, 8:30am-4:30pm

17WBCAU25A

275

375

Webcast

A&A

8/26

Accounting Fraud WEBCAST, 8:30am-4:30pm

17WBCAU26A

275

375

Webcast

A&A

8/26

HUD Audits of Multifamily Housing Projects: Audit Requirements Under the HUD Audit Guide and for Single Audits WEBCAST, 8:30am-4pm

17WBCAU26B

275

375

Webcast

GNP

8/26

Trusts – Accounting and Taxation WEBINAR, 9:30am-11:30am

17WNCAU26A

Webinar

TAX

8/29

Foreign Information Tax Returns and the IRS Offshore Voluntary Disclosure Program WEBCAST, 8:30am-4:30pm

17WBCAU29A

275

375

Webcast

TAX

8/29

The GAO’s Green Book: Internal Controls WEBINAR, 8am-10am

17WNCAU29A

Webinar

A&A

8/30

AICPA's Forensic Accounting: Uncovering Schemes and Scams WEBCAST, 10am-2pm

17WBBAU30A

159

199

Webcast

A&A

8/30

Common Frauds and the Internal Controls Designed to Prevent and Detect Them WEBCAST, 8:30am-4pm

17WBCAU30A

275

375

Webcast

A&A

ç New |  Non-tech credits |

www.wscpa.org

Networking event

WashingtonCPA Summer 2016

CONFERENCES

While you’re stuck at the office, I’ll be enjoying a gourmet lunch with a view of Puget Sound.

Get the good stuff @ WSCPA Conferences

WashingtonCPA Summer 2016

www.wscpa.org

CONFERENCES

2016 Conferences Great topics - phenomenal speakers opportunities too amazing for you to miss!

November 2-3

Pacific Tax Institute

November 7

Accounting & Auditing Conference

November 14-15

WSCPA/CFMA Construction Industry Conference

November 17-18

Not-For-Profit Conference

December 8

Fraud Conference

December 12-13

Information Technology Conference

webcast available

www.wscpa.org

WashingtonCPA Summer 2016

EDUCATION AND EVENTS Date

CPE Credits

Course

Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

8/30

What’s New in A & A? WEBINAR, 11am-1pm

17WNCAU30B

Webinar

A&A

8/30

Year-End Tax Planning: Thinking Outside the Box WEBINAR, 10am-12pm

17WNCAU30A

Webinar

TAX

8/31

Advanced Issues: The Art of the Estate Tax Return (25% California Content) WEBCAST, 8:30am-4:30pm

17WBCAU31A

275

375

Webcast

TAX

8/31

AICPA's Risk, Cost, and Cash Management for Controllers and Financial Managers WEBCAST, 10am-2pm

17WBBAU31A

159

199

Webcast

8/31

Final Repair Regulations: Current Developments and Update WEBINAR, 8am-10am

17WNCAU31A

Webinar

TAX

9/1

Performance Auditing Essentials WEBINAR, 11am-1pm

17WNCST01A

Webinar

A&A

9/6

Accounting Firm- Development & Transfer WEBINAR, 2pm-4pm

17WNCST06C

Webinar

A&A

9/6

AICPA's Not-for-Profit Accounting and Auditing Update WEBCAST, 10am-2pm

17WBBST06A

159

199

Webcast

GNP

9/6

Single Audit Primer and Update WEBINAR, 8am-10am

17WNCST06A

Webinar

GNP

9/6

Yellow Book: Heartburn Inducing Requirements WEBINAR, 11am-1pm

17WNCST06B

Webinar

GNP

9/7

Excel Formula Expert Series - Lookup & Reference WEBINAR, 8am-10am

17WNCST07B

Webinar

TEC

9/7

Individual Tax Update and Recent Developments WEBINAR, 12pm-2pm

17WNCST07C

Webinar

TAX

9/7

Passive Activity Rules and the Net Investment Income Tax WEBINAR, 7am-9am

17WNCST07A

Webinar

TAX

9/8

Washington CPA Ethics and New Developments 2016 by Mark Hugh (A WA Requirement) WEBCAST, 8am-12pm

17WBAST08A

164

194

Webcast

Ethics

9/9

Small Business Health Insurance Reimbursement & Penalty WEBINAR, 9:30am-11:30am

17WNCST09A

Webinar

TAX

9/9

Washington B&O Tax and New Developments 2016 by Mark Hugh WEBCAST, 8am-12pm

17WBAST09A

129

159

Webcast

TAX

9/9

Washington Sales Tax and New Developments 2016 by Mark Hugh WEBCAST, 12pm-4pm

17WBAST09B

129

159

Webcast

TAX

9/12

AICPA's Form 990: Mastering Its Unique Characteristics WEBCAST, 7:30am-3:30pm

17WBBST12A

249

319

Webcast

TAX

9/12

Partnership Investments - How to Calculate the Owner's Basis WEBINAR, 12pm-2pm

17WNCST12A

Webinar

TAX

9/13

Medicare and Its Gaps: What You and Your Clients Simply MUST Know WEBCAST, 11am-12pm

17WBAST13C

Webcast

9/13

Passive Activities: Helping Clients Survive the IRS’s Challenges WEBINAR, 2pm-4pm

17WNCST13B

Webinar

TAX

9/13

Real Estate Tax Update: Key Changes for Investors and Owners WEBINAR, 10am-12pm

17WNCST13A

Webinar

TAX

9/13

Social Security 201 Mastering the Client Mysteries WEBCAST, 9am-10am

17WBAST13A

Webcast

PFP

9/13

Social Security 202 Advanced Client Strategies Update WEBCAST, 10am-11am

17WBAST13B

Webcast

PFP

9/14

Financial Accounting for Related Party Transactions WEBINAR, 9:30am-11:30am

17WNCST14A

Webinar

A&A

9/15

AICPA's Forensic Accounting: Uncovering Schemes and Scams WEBCAST, 10am-2pm

17WBBST15A

159

199

Webcast

A&A

9/15

Capital Gains Tax Strategies for Advanced Transactions WEBINAR, 7am-9am

17WNCST15A

Webinar

TAX

9/16

Creating Equity Compensation Plans WEBINAR, 9am-11am

17WNCST17A

Webinar

9/16

US State Taxation Internet Resources for Accountants WEBINAR, 10am-12pm

17WNCST17B

Webinar

TEC

9/19

AICPA's Risk, Cost, and Cash Management for Controllers and Financial Managers WEBCAST, 7:30am-11:30am

17WBBST19A

159

199

Webcast

9/19

Business Tax Update and Recent Developments WEBINAR, 9am-11am

17WNCST19A

Webinar

TAX

9/19

Fraud - Practical Approaches to Prevention & Detection WEBCAST, 12:30pm-4pm

17WBCST19A

140

188

Webcast

A&A

ç New |  Non-tech credits |

WashingtonCPA Summer 2016

Networking event

www.wscpa.org

CPE Credits

Course

EDUCATION AND EVENTS Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

9/19

PATH ACT 2015 - Emphasis on Depreciation & Cost Segregation WEBCAST, 10am-12pm

17WBAST19A

109

Webcast

TAX

9/20

Auditing Defined Contribution Plans WEBCAST, 8:30am-4pm

17WBCST20A

275

375

Webcast

A&A

9/20

Trust Income Issues —Uniform Principal and Income Act and Distributable Net Income WEBINAR, 1pm-3pm

17WNCST20A

Webinar

TAX

9/21

2016 Business Fraud Update WEBCAST, 7am-3pm

17WBAST21A

195

245

Webcast

A&A

9/21

AICPA's Interpreting the New Revenue Recognition Standard: What All CPAs Need to Know WEBCAST, 10am-2pm

17WBBST21A

159

199

Webcast

A&A

9/21

Key Tax Strategies for Partnerships and LLCs WEBINAR, 7am-9am

17WNCST21A

Webinar

TAX

9/21

Keys to Balanced Scorecard: Keeping your Business On-Track! WEBINAR, 9am-11am

17WNCST21B

Webinar

A&A

9/21

Small-Business Financial Statements WEBCAST, 8:30am-12pm

17WBCST21A

140

188

Webcast

A&A

9/22

What’s New in A & A? WEBINAR, 10am-12pm

17WNCST22A

Webinar

A&A

9/22

Why Do We Need Another Basis of Accounting - FRF for SMEs? WEBINAR, 1pm-3pm

17WNCST22B

Webinar

A&A

9/22

Winning at the Bank - Making the Best of Your First Impression WEBCAST, 9am-11am

17WBAST22A

109

Webcast

9/23

Accounting and Auditing Update WEBCAST, 8:30am-4pm

17WBCST23B

275

375

Webcast

A&A

9/23

Corporate Finance Checkup: Renovate Your Analytical Toolbox WEBCAST, 8:30am-4pm

17WBCST23A

275

375

Webcast

9/23

US City Taxation Internet Resources for Accountants WEBINAR, 10am-12pm

17WNCST23A

Webinar

TEC

9/24

Small GAAP: AICPA Private Company Financial Reporting Standards WEBINAR, 7am-9am

17WNCST24A

Webinar

A&A

9/26

AICPA's Internal Controls and Risk Assessment: Key Factors in a Successful Audit WEBCAST, 7:30am-3:30pm

17WBBST26A

249

319

Webcast

A&A

9/26

Private Company Accounting: New Challenges, New Directions WEBCAST, 8:30am-4pm

17WBCST26A

275

375

Webcast

A&A

9/26

SSARS 21: The Newly Effective Preparation, Compilation and Review Standards WEBCAST, 8:30am-4pm

17WBCST26B

275

375

Webcast

A&A

9/26

Supplier Audits to Protect Your Bottom Line WEBINAR, 11am-1pm

17WNCST26B

Webinar

A&A

9/26

Year-End Tax Planning: Thinking Outside the Box WEBINAR, 9am-11am

17WNCST26A

Webinar

TAX

9/27

Final Repair Regulations: Current Developments and Update WEBINAR, 9am-11am

17WNCST27A

Webinar

TAX

9/28

AICPA's Financial Forecasting: Planning for Success WEBCAST, 10am-2pm

17WBBST28A

159

199

Webcast

9/28

AICPA's One Year Later: Updates on FASB’s Not-for-Profit Financial Statement Proposal WEBCAST, 10am-12pm

17WBBST28B

129

Webcast

GNP

9/28

AICPA's Using Charitable Trusts to Avoid Capital Gains Taxes & the 3.8% Surtax WEBCAST, 10am-12pm

17WBBST28C

129

Webcast

9/28

COD Income Issues WEBINAR, 2pm-4pm

17WNCST28B

Webinar

TAX

9/28

Incorporating a Business WEBCAST, 12:30pm-4pm

17WBCST28A

140

188

Webcast

TAX

9/28

Other Comprehensive Basis of Accounting Fundamentals WEBCAST, 8:30am-4pm

17WBCST28B

275

375

Webcast

A&A

www.wscpa.org/cpexpress

ç New |  Non-tech credits |

www.wscpa.org

Networking event

WashingtonCPA Summer 2016

EDUCATION AND EVENTS Date

CPE Credits

Course

Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

9/28

S Corporations: How to Calculate the Owner's Basis WEBINAR, 12pm-2pm

17WNCST28A

Webinar

TAX

9/29

2016 Not-for-Profit Accounting, Auditing & Tax Update WEBCAST, 7am-3pm

17WBAST29A

195

245

Webcast

GNP

9/29

Deal Structure for Mergers and Acquisitions WEBCAST, 8:30am-4pm

17WBCST29B

275

375

Webcast

TAX

9/29

Mitigating Fraud Engagement Risk for Nonaudit Practitioners WEBCAST, 12:30pm-4pm

17WBCST29A

140

188

Webcast

A&A

9/29

What You Need to Know About the New AICPA PFP Standards WEBINAR, 2pm-4pm

17WNCST29A

Webinar

9/30

Detecting Fraudulent Financial Reporting WEBCAST, 8:30am-4pm

17WBCST30A

275

375

Webcast

A&A

9/30

International Taxation Internet Resources for Accountants WEBINAR, 7am-9am

17WNCST30A

Webinar

TEC

9/30

US Federal Government Internet Resources for Accountants WEBINAR, 10am-12pm

17WNCST30B

Webinar

TEC

10/3

2016 Government Fraud and Abuse: 5 New Cases WEBINAR, 1pm-3pm

17WNCOC03B

Webinar

GNP

10/3

Passive Activity Rules and the Net Investment Income Tax WEBINAR, 11am-1pm

17WNCOC03A

Webinar

TAX

10/4

The Complex Area of Partnership Allocations - Properly Dividing Up the Items on the Form 1065 WEBINAR, 1pm-3pm

17WNCOC04B

Webinar

TAX

10/4

Yellow Book: Heartburn Inducing Requirements WEBINAR, 10am-12pm

17WNCOC04A

Webinar

GNP

10/5

AICPA's Applying the Risk Assessment Standards to Enhance Audit WEBCAST, 10am-2pm

17WBBOC05A

159

199

Webcast

A&A

10/5

Financial Accounting for Related Party Transactions WEBINAR, 11am-1pm

17WNCOC05B

Webinar

A&A

10/5

Individual Tax Update and Recent Developments WEBINAR, 7am-9am

17WNCOC05A

Webinar

TAX

10/6

2016 Business Fraud Update WEBCAST, 7am-3pm

17WBAOC06A

195

245

Webcast

A&A

10/6

Partnerships and LLCs vs. S Corporations - How Many Tax Differences Remain? WEBINAR, 10am-12pm

17WNCOC06A

Webinar

TAX

10/6

SSARS 21: The Newly Effective Preparation, Compilation and Review Standards WEBCAST, 8:30am-4pm

17WBCOC06A

275

375

Webcast

A&A

10/6

Supplier Audits to Protect Your Bottom Line WEBINAR, 3pm-5pm

17WNCOC06B

Webinar

A&A

10/6

Washington CPA Ethics and New Developments 2016 by Mark Hugh (A WA Requirement) WEBCAST, 8am-12pm

17WBAOC06B

164

194

Webcast

Ethics

10/7

AICPA's Audit Workpapers: Reviewing Field Work WEBCAST, 10am-2pm

17WBBOC07A

159

199

Webcast

A&A

10/7

Beyond Traditional Budgeting: Change Your Approach to Planning and Control WEBINAR, 9am-11am

17WNCOC07A

Webinar

A&A

10/7

Key Ratio Analysis WEBCAST, 8:30am-4:30pm

17WBCOC07A

275

375

Webcast

A&A

10/7

Washington B&O Tax and New Developments 2016 by Mark Hugh WEBCAST, 8am-12pm

17WBAOC07A

129

159

Webcast

TAX

10/7

Washington Sales Tax and New Developments 2016 by Mark Hugh WEBCAST, 12pm-4pm

17WBAOC07B

129

159

Webcast

TAX

10/7

What CPAs Need to Know About Detecting Ponzi Schemes WEBINAR, 11am-1pm

17WNCOC07B

Webinar

A&A

10/10

AICPA's Revenue Recognition: Mastering the New FASB Requirements WEBCAST, 7:30am-3:30pm

17WBBOC10A

249

319

Webcast

A&A

10/10

Trust Income Issues —Uniform Principal and Income Act and Distributable Net Income WEBINAR, 8am-10am

17WNCOC10A

Webinar

TAX

10/10

Why Do We Need Another Basis of Accounting - FRF for SMEs? WEBINAR, 12pm-2pm

17WNCOC10B

Webinar

A&A

10/11

2016 Nonprofit Fraud and Abuse: 5 New Cases WEBINAR, 1pm-3pm

17WNCOC11B

Webinar

GNP

10/11

Alternative Minimum Tax: How it Can Impact Your Clients WEBINAR, 11am-1pm

17WNCOC11A

Webinar

TAX

10/11

Medicare and Its Gaps: What You and Your Clients Simply MUST Know WEBCAST, 11am-12pm

17WBAOC11C

Webcast

ç New |  Non-tech credits |

WashingtonCPA Summer 2016

Networking event

www.wscpa.org

CPE Credits

Course

EDUCATION AND EVENTS Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

10/11

Social Security 201 Mastering the Client Mysteries WEBCAST, 9am-10am

17WBAOC11A

Webcast

PFP

10/11

Social Security 202 Advanced Client Strategies Update WEBCAST, 10am-11am

17WBAOC11B

Webcast

PFP

10/12

Government Fraud & Abuse: How Reporters Find It Before Auditors WEBINAR, 8am-10am

17WNCOC12A

Webinar

A&A

10/12

Key Tax Strategies for Partnerships and LLCs WEBINAR, 10am-12pm

17WNCOC12B

Webinar

TAX

10/12

What CPAs Need to Know about Elder Fraud to Protect Themselves and Clients WEBINAR, 2pm-4pm

17WNCOC12C

Webinar

A&A

10/13

AICPA's Fraud: Recent Findings, Red Flags and Corruption Schemes WEBCAST, 10am-2pm

17WBBOC13A

159

199

Webcast

A&A

10/13

ASC 740/FAS 109 Step by Step Instruction - Level Basic WEBCAST, 10am-6pm

17WBAOC13A

195

245

Webcast

A&A

10/13

Financial Infidelity and Divorce Strategies WEBINAR, 1pm-3pm

17WNCOC13B

Webinar

10/13

Single Audit Primer and Update WEBINAR, 10am-12pm

17WNCOC13A

Webinar

GNP

10/14

AICPA's Fraud and Cash Receipts: Common Frauds and Internal Controls WEBCAST, 10am-2pm

17WBBOC14A

159

199

Webcast

A&A

10/14

Creating Equity Compensation Plans WEBINAR, 9am-11am

17WNCOC14B

Webinar

10/14

Excel Formula Expert Series - Financial, Stats & Math WEBINAR, 8am-10am

17WNCOC14A

Webinar

TEC

10/14

Financial Statement Analysis: Unraveling the Mystery For Management WEBCAST, 8:30am-4pm

17WBCOC14A

275

375

Webcast

A&A

10/14

Passive Activities: Helping Clients Survive the IRS’s Challenges WEBINAR, 11am-1pm

17WNCOC14C

Webinar

TAX

10/17

AICPA's Not-for-Profit Accounting & Reporting: From Start to Finish WEBCAST, 7:30am-3:30pm

17WBBOC17A

249

319

Webcast

GNP

10/17

Dealing with the Net Investment Income Tax and Additional Medicare Tax WEBINAR, 10am-12pm

17WNCOC17A

Webinar

TAX

10/17

PATH ACT 2015 - Emphasis on Depreciation & Cost Segregation WEBCAST, 10am-12pm

17WBAOC17A

109

Webcast

TAX

10/18

Foreign Account Reporting Requirements: Forms 8938 and 3520 WEBINAR, 11am-1pm

17WNCOC18C

Webinar

TAX

10/18

Mergers and Acquisitions: Fundamentals of Acquiring or Selling MidMarket Companies and Professional Service Organizations WEBCAST, 8:30am-4:30pm

17WBCOC18B

275

375

Webcast

10/18

QuickBooks for Accountants WEBCAST, 8:30am-4pm

17WBCOC18A

275

375

Webcast

TEC

10/18

Small GAAP: AICPA Private Company Financial Reporting Standards WEBINAR, 8am-10am

17WNCOC18B

Webinar

A&A

10/18

The GAO’s Green Book: Internal Controls WEBINAR, 7am-9am

17WNCOC18A

Webinar

A&A

10/19

2016 Accounting and Auditing Update WEBCAST, 7am-3pm

17WBAOC19A

195

245

Webcast

A&A

10/19

AICPA's Affordable Care Act: Tax and Insurance Ramifications WEBCAST, 10am-2pm

17WBBOC19A

159

199

Webcast

TAX

10/19

Buying and Selling Corporate Businesses: Stock Sales WEBCAST, 12:30pm-4pm

17WBCOC19B

140

188

Webcast

TAX

10/19

Compilations and Reviews: Risks, Procedures and Fraud WEBCAST, 8:30am-4pm

17WBCOC19A

275

375

Webcast

A&A

10/19

Final Repair Regulations: Current Developments and Update WEBINAR, 11am-1pm

17WNCOC19B

Webinar

TAX

10/19

Financial Fitness Forever - Five Steps to More Money, Less Risk and More Peace of Mind WEBCAST, 9am-12pm

17WBAOC19B

Webcast

PFP

10/19

Tax Depreciation Update: Rules and Special Situations WEBINAR, 7am-9am

17WNCOC19A

Webinar

TAX

10/20

AICPA Conflicts of Interest: A New Approach WEBCAST, 9am-10am

17WBAOC20C

Webcast

10/20

AICPA Independence Rules - A New 2016 Approach WEBCAST, 10am-11am

17WBAOC20D

Webcast

10/20

AICPA's The Most Common Financial Statement and Asset Fraud Schemes: How to Detect and Prevent Them WEBCAST, 10am-2pm

17WBBOC20A

159

199

Webcast

A&A

ç New |  Non-tech credits |

www.wscpa.org

Networking event

WashingtonCPA Summer 2016

EDUCATION AND EVENTS Date

CPE Credits

Course

Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

10/20

Identifying Fraud Risks WEBCAST, 1pm-4:30pm

17WBCOC20D

140

188

Webcast

A&A

10/20

Internal Control’s New Muscles WEBINAR, 2pm-4pm

17WNCOC20B

Webinar

A&A

10/20

IRS Representation: Key Strategies to Represent Your Clients WEBINAR, 9am-11am

17WNCOC20A

Webinar

TAX

10/20

Navigating The Choppy Seas of The Streamlined Procedures EVENING WEBCAST, 4pm-7pm

17WBAOC20B

129

Webcast

TAX

10/20

Practical Guide to Accounting Fraud WEBCAST, 8:30am-12pm

17WBCOC20C

140

188

Webcast

A&A

10/20

Private Foundations and Form 990-PF Basics WEBCAST, 8:30am-12pm

17WBCOC20A

140

188

Webcast

TAX

10/20

Winning at the Bank - Making the Best of Your First Impression WEBCAST, 9am-11am

17WBAOC20A

109

Webcast

10/20

Working With, Storing and Securing Digital Information WEBCAST, 8:30am-4pm

17WBCOC20B

275

375

Webcast

TEC

10/21

Audit Standards Update: Clarifying Risk Assessment WEBCAST, 8:30am-4:30pm

17WBCOC21B

275

375

Webcast

A&A

10/21

Real Estate Tax Update: Key Changes for Investors and Owners WEBINAR, 9:30am-11:30am

17WNCOC21A

Webinar

TAX

10/21

Social Security: Advanced Education and Training WEBCAST, 8:30am4pm

17WBCOC21A

275

375

Webcast

10/24

AICPA's Best Practices for Payroll Taxes and 1099 Issues WEBCAST, 7:30am-3:30pm

17WBBOC24A

249

319

Webcast

TAX

10/24

Captive Insurance: An Effective Financial and Risk Management WEBINAR, 11am-1pm

17WNCOC24B

Webinar

TAX

10/24

Federal Taxation of Partnerships and LLCs Part I: Formation, Operation and Allocations WEBCAST, 8:30am-4:30pm

17WBCOC24A

275

375

Webcast

TAX

10/24

S Corporations: How to Calculate the Owner's Basis WEBINAR, 9am-11am

17WNCOC24A

Webinar

TAX

10/25

AICPA's Preparation, Compilation, and Review Engagements Update WEBCAST, 10am-2pm

17WBBOC25A

159

199

Webcast

A&A

10/25

Detecting and Preventing Internal Fraud, Theft and Abuse WEBINAR, 12pm-2pm

17WNCOC25C

Webinar

A&A

10/25

Excel Formula Expert Series - Lookup & Reference WEBINAR, 8am-10am

17WNCOC25A

Webinar

TEC

10/25

Nine Tax & Financial Planning Topics That Will Make You a Hero to Your Clients WEBCAST, 8:30am-4:30pm

17WBCOC25B

275

375

Webcast

TAX

10/25

Passive Activities Rules: Cutting-Edge Tax Strategies in Passive Losses WEBCAST, 8:30am-4:30pm

17WBCOC25A

275

375

Webcast

TAX

10/25

What’s New in A & A? WEBINAR, 9am-11am

17WNCOC25B

Webinar

A&A

10/26

2016 Financial Statement Preparation, Compilation, and Review WEBCAST, 7am-3pm

17WBAOC26A

195

245

Webcast

A&A

10/26

AICPA's Social Security and Medicare: Maximizing Retirement Benefits WEBCAST, 10am-2pm

17WBBOC26A

159

199

Webcast

TAX

10/26

Choice of Entity: Cutting-Edge Tax Strategies in Choice of Entity Decisions WEBCAST, 8:30am-4:30pm

17WBCOC26A

275

375

Webcast

TAX

10/26

Corporate Tax Planning: Actual and Constructive Distributions WEBCAST, 12:30pm-4pm

17WBCOC26B

140

188

Webcast

TAX

10/26

What Advisors Need to Know Regarding Social Security Changes due to the Bi-Partisan Budget Bill WEBINAR, 10am-12pm

17WNCOC26A

Webinar

TAX

10/27

AICPA's U.S. GAAP: Latest Developments for Business & Industry WEBCAST, 10am-2pm

17WBBOC27A

159

199

Webcast

A&A

10/27

Increase Revenue with Time Management WEBINAR, 7am-9am

17WNCOC27A

Webinar

10/27

Tax Research Skills WEBCAST, 8:30am-4pm

17WBCOC27A

275

375

Webcast

TAX

10/28

ESOPs: Uses, Strategies, Benefits and Pitfalls WEBCAST, 8:30am-4pm

17WBCOC28A

275

375

Webcast

10/28

Multistate Taxation of the Mobile Work Force and Issues Related to Nonresident, Estate and Trust Tax Returns WEBCAST, 8:30am-4pm

17WBCOC28B

275

375

Webcast

TAX

10/28

S Corporations: Tax Planning Ideas and Strategies WEBCAST, 8:30am-4:30pm

17WBCOC28C

275

375

Webcast

TAX



ç New |  Non-tech credits |

WashingtonCPA Summer 2016

Networking event

www.wscpa.org

CPE Credits

# 10/29

10/29

EDUCATION AND EVENTS

Course

Code

WSCPA NonAICPA Member Member Member Discount Fee Fee

Facility

Subject

Type

Washington B&O Tax and New Developments 2016 by Mark Hugh SATURDAY WEBCAST, 8am-12pm

17WBAOC29B

129

159

Webcast

TAX

Washington CPA Ethics and New Developments 2016 by Mark Hugh (A WA Requirement) SATURDAY WEBCAST, 8am-12pm

17WBAOC29A

164

194

Webcast

Ethics

Washington Sales Tax and New Developments 2016 by Mark Hugh SATURDAY WEBCAST, 12pm-4pm

17WBAOC29C

129

159

Webcast

TAX

10/31

AICPA's Analyzing a Company’s Financial Statement WEBCAST, 7:30am-11:30am

17WBBOC31A

159

199

Webcast

A&A

10/31

AICPA's Risk, Cost, and Cash Management for Controllers and Financial Managers WEBCAST, 11:30am-3:30pm

17WBBOC31B

159

199

Webcast

10/31

Business Tax Update and Recent Developments WEBINAR, 7am-9am

17WNCOC31A

Webinar

TAX

10/31

Living Trust Administration Workshop WEBCAST, 8:30am-4pm

17WBCOC31B

275

375

Webcast

TAX

10/31

Partnerships and LLCs vs. S Corporations - How Many Tax Differences Remain? WEBINAR, 1pm-3pm

17WNCOC31B

Webinar

TAX

Are you A&A Andy? Tax Goddess Gina? Nonprofit Nicole?

Tax Goddess Gina, CPA

A&A Andy, CPA

Superhero CFO Stan, CPA

ç New |  Non-tech credits |

www.wscpa.org

We recognize that you’re busy and want to send you the information that’s of interest to you. Update your interests today! www.wscpa.org/mywscpa Click “Manage My Interests”

Nonprofit Nicole, CPA Construction Ken, CPA

Networking event

WashingtonCPA Summer 2016

REGISTRATION

Register online with credit card at www.wscpa.org/cpe/catalog or: • Mail form with check to WSCPA, 902 140th Ave NE, Bellevue, WA 98005-3480 • Call (425) 644-4800 or (800) 272-8273 (toll-free in Washington) Questions? E-mail cpe@wscpa.org or call the WSCPA.

Code

Title

Date

City

Fee1

To pay by credit card, please visit www.wscpa.org/cpe/catalog or call (425) 644-4800.

WSCPA CPE policies apply to all programs in the CPE Digest. Review the CPE policies at www.wscpa.org.

WashingtonCPA Summer 2016

www.wscpa.org

CLASSIFIED ADS

Detailed advertising information is available online at www.wscpa.org under More. Ads are $1 per word, with a $50 minimum fee. Active e-mail and web site addresses are included. Ads are placed on the website for 60 days when received and in the next magazine when received by the deadline, September 1 for the fall 2016 issue. Post a job listing at www.wscpa.org (click Job Board). For rental or vacation property use the miscellaneous category. Contact Janet White at (425) 586-1126, or memberservices@wscpa.org for more information. All ads must be pre-paid. MERGERS & SALES Seattle/Bellevue Practice for Sale.Tax Practice for sale with $ 250,000 gross revenue. 40% Business, 60% Individuals.Established (22 years) Practice.Ideal for CPA wanting to establish own practice. Owner will be available to assist in transition. Contact idemonyc@aol.com. Over $100,000 Estimated Earnings 2015 & Growing. Established for over 60 years; this well respected firm has grown in the past year in both number of clients and in fees. Competent bookkeeper in place. Perfect opportunity for an experienced EA/CPA wishing to own her/his own practice. Located in a growth-oriented community. FinancingAvailable.For additional information,please contact Scott Weyer @ First Harbor RE:Aberdeen, WA 360-581-3696 / scot.weyer@gmail.com. Stand Alone building for sale or lease. For Sale - Snohomish County and Seattle Metro CPA Firm. Business and personal tax. Established for nearly three decades.Employs 5Very high Client retention. Sale is a planned retirement transition. www.Transition360.com has assisted in the sale of local CPA firms and their trusted clients for over 30 years. References available. Contact Information: Tod Fiscus, todfiscus@transition360. com; (206)226-4311. Considering Selling Your Practice? Consider all your options. We do the work. Confidential. We have buyers actively seeking practices. Call Mark Hause at (877) 345-7722 or visit our website at www.accountingpracticesales.com. Accounting Practice Sales.We make dreams happen! IBA Sells Privately Held Companies. Do you represent a client who is ready to retire or has taken a company as far as they want to or can? IBA is the Pacific Northwest’s oldest business brokerage (M&A) firm. We are professional negotiators with over 4000 completed transactions. Please contact us if we can be of assistance at (800) 218-4422 or www.ibainc.com. OFFICE SPACE South Hill Spokane. Six window offices with open reception area, rent one or all. Most come with matching furniture and a wooden front counter. Cross referrals will be available June 1st to the right person/group of accountants or other professionals. Kitchen and conference room are included. Good rental rates and fair terms are offered. Contact Anson Avery, CPA at anson@aaverycpa.com (509) 315-8510.

www.wscpa.org

PRACTICES FOR SALE Contact Mark Hause at Accounting Practice Sales by e-mail at MARKHAUSE@CONTACTAPS.COM or call (877) 345-7722 for more information on the following practices: (WA 1104) Anacortes, La Conner, Mount Vernon Area CPA Practice for Sale: This CPA practice has experienced explosive growth with revenues increasing by approx. 42% per year for the last two years. The firm has a variety of services but the focus is on tax with these services equaling 54% of fees collected over the last 12-month period ending April 2016. The balance of the revenue is found in consulting, write up, and compilations. This dynamic practice with excellent revenue increases is primed for a new owner and continued prosperity. (WA 1103) Renton CPA Practice for Sale: This CPA practice with many loyal clients is for sale. The firm can be described as tax practice with 78% of revenues coming from tax services. The balance is comprised of write up and to a lesser degree consulting. The firm has benefited from positive social medial reviews to continue a solid growth path with all types of clients. The office facility is owned by the Seller making the client transition a simple process toward continued success. The buyer of this practice, that fits a number of buyers, is a significant opportunity coupled with a net cash flow that is above the norm. (WA 1102) Seattle CPA Tax Practice for Sale: This CPA firm is a tax practice that specializes in the commercial fishing industry. The firm has no write up work electing to focus on rendering income tax services to the clients of the practice. The next attribute is the overall average of fees equaling $879 per return which creates a great net cash flow. Last but by no means least is a tax practice without the 4-15 crunch. The firm extends many of the returns with the result being that 45% of the annual billable time is performed in the time period from June to October. This practice with all these elements mentioned including a great staff is the kind professionals actively seek and rarely find. All of this without the really difficult tax season stresses that push the staff and owner to the limit. (WA 1101) Bellingham/Ferndale-Whatcom County CPA Tax Practice for Sale: This wellmanaged CPA tax centric practice is for sale. The

SITUATIONS WANTED Join a Good Team - Spokane Area. We are an established CPA firm that lost associates and a partner to illness and retirement. We are seeking an accountant, CPA preferred but not required, to share office space and possibly merge with our firm. If you want to upgrade your practice and your location, this can be considered. Contact Anson Avery, anson@aaverycpa.com (509)315-8510.

firm is filled with clients that return year after year and produce a net cash flow that exceeds 50% of revenues. The revenues are 87% income tax and the balance is write up and consulting. With an excellent staff providing solid backup, the firm offers ample opportunity for the expansion of services consistent with the abilities and interest of the new owner. Whether looking for your first practice or a highly profitable addition to an existing firm, this practice provides ample challenge and reward. (WA 1096) Marysville CPA Tax Practice for Sale: This CPA practice that provides quality tax services for many loyal clients is for sale. This firm is the type of practice many seek with a high percentage of the annual revenues from the preparation of income tax returns. The firm’s revenue dollars by category of service are 94% income tax and 6% write up. The practice, with a great bottom line, is the right opportunity for any accountant ready to start their own firm, take a small firm to the next level, or a nearby firm seeking to add a book of business to an existing practice. (WA 1092) Kittitas County EATax Practice for Sale: This well-established Enrolled Agent practice with remarkable balance in professional fees is for sale. The firm has two great books of business with tax and write-up revenues being approximately equal and a small amount of consulting making up the balance. The revenue stream provides great balance and great cash flow through the year. The firm also has great momentum with revenue increasing in double digits for the last two years. This firm fits a number of buyers who are looking for an opportunity to enjoy the fruits of their labor. (WA 1073) Island County EATax Practice for Sale: This well-established Enrolled Agent practice is for sale. The firm is well balanced with a tax practice that produces 71% of the firm’s revenue with writeup generating the remainder of the income. The practice is well positioned for future growth due to having a solid staff serving long term clients. The seller is retiring but will be available to assist in transition. For any firm looking for a satellite office, an existing practice wishing to branch out, or an individual who has aspirations of getting out on their own,this practice is an excellent choice.

VOLUNTEER OPPORTUNITIES

The following organizations need a CPA to serve on the board of directors and/or provide other guidance on financial matters. Learn more about these, and others organizations that need your help, under Volunteer opportunities for CPAs, at www.wscpa.org/more/marketing-to-cpas. artEast Chance Fashion CoolMom Far West Agribusiness Association Helping Link-Mot Dau Noi Jet City Improv Momentum Music and Dance Academy Seattle Veterans Employees Association WashingtonCPA Summer 2016

WashingtonCPA Summer 2016

www.wscpa.org

PHOTO PHOTO ALBUM ALBUM

Washington State Tax Conference - June 24 | Seattle

Annual Meeting June 9 | Seattle

Women's Leadership Summit - May 18 | Bellevue

Get involved in

YOUR LOCAL CHAPTER Bellevue Area

Spokane Area

Bellingham Area

Tacoma Area

Everett Area

Tri-Cities Area

Olympia Area

Vancouver Area

Seattle Area

Yakima Area

www.wscpa.org/chapters www.wscpa.org

WashingtonCPA Summer 2016

Periodicals postage paid at Bellevue WA and additional mailing offices

Your Profession. Your Future. Your Advocate.

OD MER

AREA

NTS

& h t l s hea llnes we

DINE. SHOP. TRAVEL. SAVE.

NTS

Learn more at www.wscpa.org/passport

D 4 VE ble PROnsfera APfully tra

bers

CPA

hip

UISES R C -

L E AV S

d natiscINouC ion nLU tsDED t WSC wiw PA M hiydoeur em

3,00 0+

OD MER

Register your card by N EI G H B August 31, O 2016 and you could win a 2-night stay in a Lakeview Guest Room at The Woodmark Hotel on Lake Washington! O RH

S EL

You should have received your card in late June. If not, contact us at (425) 586-1142 or memberservices@wscpa.org.

T R O P S s S g n i A v a P s o t

Did you receive your Passport Corporte card?

ble era n sf

N EI G H B

O RH

CLEAR

PRES T REST IGIOUS AURA NTS

DINE

Dinne a pric r for two w e tag for onith e