Professional Development and Event Catalog

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your experience level, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and streamlining report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples to improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience delivering spreadsheet training to accounting and financial professionals, assuring you of the relevance and usefulness of the information and guidance provided during the program.

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.

Important: This is a VIRTUAL program and is being offered in partnership with the Greater Washington Society of CPAs Join us as we partner with the Greater Washington Society of CPAs for this premier conference, where financial leaders from all industries converge to explore the latest trends, share insights, and foster strategic collaboration. This conference is tailored to meet the unique needs of CFOs, Controllers and other financial management professionals, offering a comprehensive program that addresses key challenges and opportunities in the financial landscape. By attending this conference, you will enhance your knowledge, expand your network, and stay at the forefront of industry trends. You will hear from experts, leaders and peers for the latest and greatest information on topics of importance for CFOs, Controllers. Sessions include: Economic Update  Hot Topics Panel  AI Expert Session Technology Panel Interview Chess: Making the Right Moves as a Hiring Manager or Job Seeker Please note that the Class Pass does not apply to this program.

Advance your skills to propel your career. This course is the second in a five-course series, provides the guidance needed to handle small engagements and to complete small audits, reviews and compilations with minimal supervision. Gain knowledge to improve your skills to perform more complex analytical procedures, as well as drafting financial statements and footnotes. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

QuickBooks Online's (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool's available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures contributing to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is applying information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general and application control failures that contributed to each fraud. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.

Improve your planning, review, audit and other engagement skills. Master techniques for effective communication with clients and colleagues in part three of this five-course series. Discover the secrets to planning and efficiently completing engagements, explore methods for assuming higher levels of responsibility, and develop your ability to assess risk and materiality. Learn how AI can be used on engagements to enhance efficiency and quality. Designed to offer audit staff members extensive training in crucial procedural, evaluative and supervisory areas. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

This CTCPA conference updates practitioners on a variety of topics in the employee benefit plans area.

This program is an in-depth analysis of the Section 754 election and the two adjustments associated with the election under Section 743(b) and Section 734(b). The 754 election is a highly technical provision that provides great tax benefits to the owners of the partnership, and particularly in the case of Section 743(b), a new partner. This course covers the most common questions encountered by practitioners in their daily practices. The program includes a number of examples that provide insights into the mechanics of the two adjustments that follow upon a Section 754 election.

*IMPORTANT:  This is a virtual conference being run in partnership with the Iowa Society of CPAs The ISCPA Financial Institutions Conference brings together CPAs and other professionals working in or with the banking industry to discuss the latest trends, innovations and challenges facing the industry today. Gain valuable insights, connect with industry leaders, and expand your network. Please note that the Class Pass does not apply to this program.

Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!

The new administration has proposed significant tax policy changes that may impact individual taxpayers and financial planning strategies. This course provides tax practitioners with essential updates on recent legislation, regulatory changes, and potential future reforms. Participants will explore the implications of proposed tax cuts, adjustments to Social Security and retirement taxation, and potential modifications to deductions and credits. The course also examines ongoing discussions about IRS restructuring and the expansion of tax incentives for American businesses and families. With a focus on practical strategies, this course equips tax professionals with the tools to help clients prepare for these changes before year-end. Whether addressing Form 1040 issues, capital gains planning, or income and estate tax considerations, participants will gain insights to help clients make informed decisions.

SSARS 21 significantly changed the way CPA services are being offered. There is still confusion CPA responsibilities and procedures. The course will discuss differences between bookkeeping, preparation and compilation engagements and how they differ. It will also discuss financial statement frameworks and how they influence the engagement as well as analytical procedures in review engagements

Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.

Virtually all accounting and financial professionals use Excel but, unfortunately, most don’t use it as efficiently and effectively as they could or should. If you’re ready to elevate your Excel skills, plan today to participate in this special 8-hour conference designed to help you work better with Excel.In this event, you will go well beyond simple functions such as SUM to learn how you can take full advantage of many key features in Excel. Included in the discussion are newer functions and features such as LAMBDA, PIVOTBY, and XLOOKUP. You will also learn various tips for improving productivity and security when working with Excel. And you will learn best practices for working with PivotTables. You don’t want to miss this special opportunity to learn better ways for working with Excel!

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years, including the 16 SASs effective since 2021 and beyond. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. On the financial front, the course covers the 9 ASUs issued in 2023, including ASUs covering crypto assets and leases for common control entities. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

The estate and financial planning landscape for Generations X and Y (individuals born between 1965 and 1996) presents a broad array of challenges and considerations. This course provides a fresh perspective on the unique issues professionals encounter when developing strategies tailored for this demographic. Participants will gain insight into key factors affecting these generations, from estate planning missteps to navigating retirement and education funding challenges. Professionals will also explore how evolving workplace dynamics, nontraditional domestic partnerships, and future trends impact financial planning for Generations X and Y. By the end of this course, participants will be equipped with the tools and strategies necessary to address the specific needs of their Gen X and Y clients, ensuring they are prepared to meet their clients' diverse financial goals.

When performing an audit, an auditor bases their opinion about whether the financial statements are free from material misstatement on a variety of tests on the underlying account balances and classes of transactions. Some balances, such as debt or cash, may be tested 100 percent, but more commonly the auditor will use sampling to test a subset of the population to obtain sufficient evidence to support the opinion. The auditor will also use sampling when testing control activities to conclude on the effectiveness of the controls. For other account balances and transactions, auditors may choose to perform analytical procedures as substantive tests instead of, or alongside, sampling techniques. It is important to properly design and perform analytical procedures to ensure an effective and efficient audit engagement. This course will provide detailed guidance and methods for performing these analytical techniques and explore the different sampling applications used in a financial statement/compliance audit.

Accounting estimates are often some of the most difficult and subjective amounts included in U.S. GAAP financial statements. These estimates are pervasive and are often sensitive to relatively small changes in assumptions or circumstances, which can have a significant impact on the recorded (or not recorded) estimate in the financial statements. In this course, we will review the relevant auditing guidance related to auditing estimates, including the estimate for credit losses under ASC 326. We will focus on the three most common ways auditors can approach their audit of accounting estimates: waiting for the contingency to resolve itself, auditing the client's estimation process, and developing the auditor's point or range of estimate. Then we will review what has changed since SAS 143 became effective for 2023 audits.