Professional Development and Event Catalog

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.

With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "technoethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.

Disclosures are on of the most challenging areas of financial statement preparation and one of the most cited deficiencies in peer reviews. This program tackles the many disclosure requirements with detailed discussions on topic requirements and examples. It is a fas- paced course that covers all the major balance sheet accounts, as well as revenue and expenses. Attention is also paid to the Statement of Cash Flows.

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.

In today's world of everchanging demands and dynamics of the workplace, it is imperative that we use a tool to help us bring balance, strength, and stability in all we do at work and at home. Mindfulness is an easy and effective tool to help us with this. The Mindful-CPA program via this webinar is designed specifically for Finance and Accounting Professionals. You will learn: The fundamental principles of Mindfulness An 8-minute Mindfulness Practice to be done daily Creative and fun ways to apply Mindfulness to work activities Effective overall strategies to bring creativity, balance, and energy to daily activities. Sunish Mehta, CPA has been a practitioner and instructor of Mindfulness for over 20 years and has worked with several Mindfulness Organizations to date. Having studied with some of the top Mindfulness Teachers in the world including His Holiness The Dalai Lama, Sunish has integrated mindfulness into his learning and consulting work with the focused goal to help conscious professionals bring focus, creativity, and balance to their professional and personal lives. You can learn more at www.mindful-cpa.com.

This CTCPA conference is designed to update practitioners on new developments in the nonprofit arena.

In today's ever-evolving regulatory landscape, maintaining relevance in the profession is crucial. You can stay up to date with the rapid developments in accounting and auditing through our comprehensive course. We delve into recent pronouncements, exposure drafts, and additional guidance pertinent to accounting, auditing, review, compilation, and preparation engagements. We'll navigate the complexities for you, assisting in identifying and implementing the latest standards and guidance from FASB, PCAOB, ARSC, and ASB.

In the world of "Big Data," virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft's Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!