Professional Development and Event Catalog

Estate planning is rapidly evolving, with new trends and strategies emerging that require professionals to stay informed and adaptable. This comprehensive course provides an in-depth look at the most significant developments shaping estate planning as we move into 2025 and beyond. It covers legislative updates, innovative techniques, and the latest industry insights to equip participants with the tools they need to create effective and lasting estate plans. Participants will gain a deeper understanding of how to incorporate advanced tax strategies, handle complex family dynamics, and integrate digital assets into their planning frameworks. By staying ahead of the curve, attendees will be better prepared to offer their clients customized solutions that safeguard wealth and honor legacies across generations.

It's crazy to try to audit not-for-profits in the same manner that you do for-profits! The sane approach to auditing not-for-profits is to incorporate what makes them unique into the planning and performance of the audit. This course is designed to help you do just that! Obtain a superior working knowledge of auditing not-for-profit entities effectively and efficiently.

This CTCPA conference discusses the most relevant issues facing the accounting profession today.

One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs, including controllers and executives in industry, should understand how difficult the process of buying and selling a business has become.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.

The Association of Certified Fraud Examiners says that there is fraud lurking in all businesses, including not-for-profit organizations. It often goes undetected for years and when uncovered, management and the board may question why an auditor did not identify it. The auditor's responsibility in a financial statement audit is to assess risk and perform sufficient procedures to obtain reasonable assurance that the financial statements are free from material misstatement due to fraud or error. However, failure to perform an adequate fraud risk assessment and report deficiencies in internal control, such as a lack of segregation of duties, can leave a firm vulnerable. This course will discuss the audit procedures that should be performed in accordance with AU-C 240 as recently amended, best practices in performing fraud risk assessment procedures, when and how to report control deficiencies noted in an audit, and the most frequent types of fraud found in small to mid-sized entities along with internal controls that could be implemented to help prevent and detect them. We will look at various cyber fraud schemes and how they might be prevented or detected, the use of analytics as fraud risk procedures, and assessments of fraud risk in a Single Audit. This course features case studies.

Important: This is a VIRTUAL program and is being offered in partnership with the Iowa Society of CPAs Discover fresh trends and top-notch practices shaping the insurance sector. Whether you're a seasoned pro or new to the field, this conference promises to arm you with valuable insights and expertise to level up your understanding of the insurance world. Please note that the Class Pass does not apply to this program.

Change is inevitable and at times overwhelming if you are unprepared. You can ensure you are current in governmental and not-for-profit accounting and auditing with this update course. Designed to prepare you for the latest accounting and auditing developments affecting governments and not-for-profits, this course gives you the tools and knowledge to implement the new standards.

IMPORTANT: Please be aware this is a 2 day, 16 credit conference and you must register for both days. This Conference is filled with 16 hours of fast-paced presentations designed to maximize your time and enhance your learning. Nationally recognized speakers have extensive expertise in numerous software applications. They will share their knowledge with you in order to help you do your job with efficiency and ease. Participants will receive helpful tips and advanced techniques, along with the tools and skills necessary to keep up with the ever-increasing pace of changes in computer technology. This conference is designed for CPAs in public practice or industry who want to take better advantage of technology to improve efficiency and effectiveness.  

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

This course is a comprehensive review of the AICPA Code of Professional Conduct. Focus is put on the applicability of the Code in the practice of public accountancy and well as for CPAs in private industry. The course will also focus on Noncompliance with Laws and Regulations (NOCLAR), Independence, Records requests and other newly issued interpretations.

As spreadsheets evolve, so must your creating, editing, and auditing practices. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today's best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this "must-see" CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel fully.

The "permanent" changes from the TCJA may stand like a lion in the pathway of change, but Washington has its own definition of permanent. Inflation adjustments and technical corrections are included within this deep analysis of the complex maze of rules dealing with depreciation, amortization, and sale of property. This course contains many examples and cases to illustrate the most important points of which CPAs need to be aware.

The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in the area of nexus. Learn how nexus requirements have changed and where the state laws may be heading in the future.

Specifically tailored for practitioners who not only perform audits but provide other attest and non-attest services to small and medium-sized businesses, this course is a comprehensive update covering recently issued accounting, auditing, and SSARS standards, as well as other professional guidance impacting small and medium-sized business accountants. The course uses practical examples and illustrations to help you understand and apply the new guidance. Through a detailed review of lease accounting guidance (ASC 842), common special purpose frameworks, new guidance related to audits and SSARS engagements, and the fully implemented credit loss standard (ASC 326, CECL), this course will get you up to speed on the things that are most important to your smaller and medium-sized clients.

Artificial Intelligence (AI) and automation tools offer incredible opportunities for all business professionals to improve productivity and accuracy. For example, generative AI tools such as ChatGPT and Bard can be beneficial when conducting research or drafting reports and correspondence. Likewise, Microsoft's Power Automate platform and similar tools such as Zapier can help you elevate efficiency to levels you may have thought unattainable. If this sounds appealing, plan to participate in this session to modernize your workflows and take advantage of these tools. This session will teach you practical applications of today's AI and automation tools. Moving beyond fundamental discussions, you will learn how to use AI and automation to streamline workflows, improve internal control, maximize productivity, and even improve team member morale. In addition, you will learn about some potential pitfalls associated with these technologies and how to avoid making mistakes when using these tools. In sum, this session is "must-see CPE," and you should plan to participate in this class today.

Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.