WICPA CPE & Special Event Catalog
Business Tax Update: Recent Developments
-
Online
2.00 Credits
Member Price: $89
A discussion of the latest 2024/25 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics at Work: Diversity, Equity & Inclusion
-
Online
2.00 Credits
Member Price: $89
Embracing and cultivating Diversity, Equity and Inclusion (DEI) in the workplace IS Ethics at Work! This session explores ethical values and principles related to these initiatives and examines workplace behaviors, individually and collectively, that foster and promote organizational well being. Robbie offers findings on strategies that work to improve DEI efforts based on best practices and interviews with experts in the field. Please note that for those of you who have taken courses from Robbie there will be some duplication and much new content. This session is designed for people who wish for a more fair and just world and workplace. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Mastering Charitable Remainder Trusts & Form 5227 ComplianceCompliance
-
Online
2.00 Credits
Member Price: $79
Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227. This course will provide a comprehensive overview of CRTs, including their purpose, benefits and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation and the different scenarios in which they are most beneficial. A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements. **Please Note: If you need credit reported to the IRS for this IRS-approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
Surgent's Data at 30,000 Feet: Traveling Smart with Client & Personal Information
-
Online
2.00 Credits
Member Price: $119
Whether you're heading across town or across the globe, traveling with electronic devices carries real risks to the sensitive client & firm data stored on them. In this session, we'll explore the ethical obligations CPAs have to protect confidential information, including guidance from the AICPA Code of Professional Conduct & applicable laws. We'll examine how data can be accessed - legitimately or maliciously - by third parties during travel & offer practical strategies to minimize risk, from using loaner devices & mobile device management to coordinating with IT before departure. The session includes current border search rules, international considerations & actionable tips for staying secure in transit.
Topic 842: Implementing Leases Workshop
-
Online
4.00 Credits
Member Price: $129
This updated course offers an in-depth look at the FASB leases standard (ASC 842), which requires organizations to recognize lease assets and liabilities on the balance sheet. This comprehensive course will cover recognition, measurement, presentation and disclosure requirements, while also focusing on a critical area of change which is the proper identification of a lease using a principles-based approach. We will discuss implementation requirements from both the lessee and lessor accounting models. In addition, we explore a variety of scenarios, including short-term leases, purchase options, variable lease payments and remeasurement. This course offers practical journal entry examples and lessons learned from implementation, while exploring recently issued amendments to the lease accounting guidance.
The Competent Accountant: Mastering the Role of the Controller/ CFO
-
Online
4.00 Credits
Member Price: $129
How do you raise your skills to the next level to master the Controller or CFO role? Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency. How are your technical skills? Are you a traditional accountant or have you learned to expand your technical skills to go beyond "what are the financial numbers?" to "why did these financial results occur?" Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action? Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills? Can you set a vision? Can you develop a strategy? Do you understand the macroeconomic environment of your organization? Can you lead a major project to a successful conclusion? This session will explore the role of business as opposed to tracking the results of the business. How are your people skills? How good is your ability to influence others? How are successful are your negotiation skills? How well can you communicate? Are you a collaborator or a partner? This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills? Do you inspire staff or make them angry? Do you know why your staff work for your company and you? Do you understand what employees want from their position? Do you know how to deal with a difficult staff person? Can you lead difficult change? This session will help you recognize what leadership truly is as opposed to what passes for day to day management.
PPP Fraud & Financial Professionals
-
Online
2.00 Credits
Member Price: $89
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Ethics: Keeping the Good From Breaking Bad
-
Online
1.00 Credits
Member Price: $39
Ethics are how groups define right from wrong. Codes of Ethics define good behavior from bad behavior for professionals. When we break those codes, we "break bad." For five seasons, the popular television show "Breaking Bad" explored the transformation of one good man breaking bad. This session provides an overview of ethics and why people break bad, while using examples from the TV show as well as case studies of good people who broke bad.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Is Activity-Based Costing the Right Tool for Your Organization?
-
Online
2.00 Credits
Member Price: $79
This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.
CFO Series: Storytelling Your Financials for Impact
-
Online
2.00 Credits
Member Price: $89
Data alone doesn't drive decisions, stories do. Financial professionals must go beyond spreadsheets and craft compelling financial narratives that engage boards, CEOs, and team members. Using real-world examples, we'll demonstrate how to frame financial results within a broader business story, drawing insights and communicating tangible meaning instead of just displaying boring numbers. Learn how to shift from "presenting financials" to telling a story that aligns with strategic goals, inspires confidence, and drives action. This session equips attendees with the tools to turn financial statements into strategic storytelling assets. Our clients do not recall numbers, but they do remember stories. Stories are memorable, we will show you how to use them.
K2's Eight Awesome PivotTable Features 25-26
-
Online
2.00 Credits
Member Price: $99
Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel's most powerful feature. Yet, most who create and work with them barely scratch the surface of all PivotTables can do. In this session, you'll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we'll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.
Single Audit Update 2025
-
Online
2.00 Credits
Member Price: $89
This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Ethics & Technology 25-26
-
Online
4.00 Credits
Member Price: $175
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.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Professional Ethical Considerations for CPAs
-
Online
2.00 Credits
Member Price: $89
Every CPA must comply with a Code of Professional Conduct, which is a hallmark of the CPA designation. CPAs in public practice must overcome higher barriers, such as when attest service providers must also retain independence. This course will provide an overview of the core principles from which the CPA profession is built upon. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Excelling at Excel: Tips, Tricks & Updates
-
Online
2.00 Credits
Member Price: $79
Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.
Liquidity & Uncertainty Disclosures for Nonprofits
-
Online
2.00 Credits
Member Price: $79
The current environment could be having an enormous impact on accounting and financial reporting for all entities, including nonprofits. This course will provide insights into the most critical disclosures related to liquidity, accounting uncertainty and going concern for nonprofits.
1065: Understanding Partnerships Tax Returns
-
Online
2.00 Credits
Member Price: $79
Form 1065 is the tax return filed by partnerships, which is one of the most common forms of business organizations in the United States. This course provides an in-depth understanding of the preparation and filing of Form 1065. The course will cover the basics of partnership taxation, including how partnerships are taxed, the different types of partnerships and the tax obligations of partners. It will also discuss the importance of keeping accurate financial records, the role of the partnership agreement in tax reporting and the filing deadlines for Form 1065. Participants will gain a comprehensive understanding of the various sections of Form 1065, including the Schedule K-1, which reports each partner's share of the partnership's income, deductions and credits. The course will also cover how to report partnership income, expenses and deductions, as well as the tax implications of buying and selling partnership interests. In addition, the course will provide an overview of common errors and omissions made when preparing Form 1065 and how to avoid them. It will also cover recent changes in tax laws that affect partnership taxation. Overall, this course is designed for tax professionals, accountants, business owners and individuals who need to understand the intricacies of partnership taxation and the preparation and filing of Form 1065. Upon completion of the course, participants will have a solid understanding of partnership taxation and will be able to prepare and file Form 1065 with confidence. **Please Note: If you need credit reported to the IRS for this IRS-approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
Member Price: $89
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Successful Family Business
-
Online
4.00 Credits
Member Price: $129
Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business and will help the participant navigate delicate issues while learning to provide counsel that will grow: or protect: the family business and non-family staff.
