CPE Catalog & Events
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
Member Price: $39
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
AI In Audit and Financial Reporting
-
Online
1.60 Credits
Member Price: $39
Auditors and financial professionals must understand how to integrate AI responsibly while maintaining professional skepticism, audit quality, and compliance with regulatory expectations. However, the use of AI also introduces new governance, ethical, and regulatory considerations that organizations must carefully manage. This course explores how AI is currently being used in audit and financial reporting, the benefits and risks associated with its adoption, and how organizations can establish appropriate governance, controls, and oversight. Delivery Method: Individual webcast CPE Credit: 1.6Program Level: Basic
1065 – Understanding Partnerships Tax Returns
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Global Internal Audit Standards (GIAS) Domain III - Part 2
-
Online
2.00 Credits
Member Price: $89
The new Standards emphasize that quality performance requires conformance to the Standards. Each standard within Domain III specifically identifies the responsibilities of the CAE and the board, as well as joint responsibilities. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Internal Control - Testing for Operating Effectiveness
-
Online
2.00 Credits
Member Price: $89
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Surgent's Top 20 Effective Strategies for Avoiding RMD Mistakes and Penalties
-
Online
2.00 Credits
Member Price: $99
Required minimum distributions (RMDs) must begin for the year in which the account owner reaches age 72 (older if they were born after 1950). RMDs must also be taken from inherited accounts, and the process for determining RMDs for these accounts is more complex than those that apply to RMDs for non-inherited accounts. Failure to comply with the RMD rules will result in the account owner owing the IRS an excess accumulation penalty on any RMD shortfall. Interested parties must understand the compliance requirements that apply to RMDs to be able to assist in ensuring that penalties are avoided. Additionally, the recent changes that affect RMDs must be considered when advising clients about their RMD obligations.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
IT Controls & SOC Reporting in Financial Audits
-
Online
3.00 Credits
Member Price: $109
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs). Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
Member Price: $149
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
-
Online
8.00 Credits
Member Price: $250
In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Comprehensive Estate Planning: Administration & Postmortem Strategies
-
Online
8.00 Credits
Member Price: $250
Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **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. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Get started with Power BI
-
Online
2.00 Credits
Member Price: $89
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Leaders Eat Last. Why? 1 Hour Session
-
Online
1.00 Credits
Member Price: $39
Trust is essential, because without trust, there can be no teamwork. Trust is like oxygen, when it is gone - we suffocate. This session provides a 15-step action plan to gain commitment from your team members, build trust, hold each person accountable and create results for your organization. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Business Partnerships: Managing Supplier Relationships
-
Online
1.00 Credits
Member Price: $55
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
The Controllership Series - The Controllers Role in Strategic Thinking and Advising - Part 1
-
Online
1.80 Credits
Member Price: $89
The strategic controller helps leadership decide what should happen, not just explain what has already been done. The controller often acts as the enterprise translator between strategy, operations, and financial outcomes. This can sometimes appear to be accuracy-focused and not necessarily decision useful insight. Controllers must move away from just variance explanation and include performance interpretation. To do this, the controller must understand business models and value drivers, be able to translate strategy into financial growth and align KPIs with strategic priorities. Part of this process includes understanding concepts of root-cause analysis vs. surface-level variance analysis. It also includes understanding correlation vs. causation in financial data. Within this segment we will review all of these concepts and controllers will come away with insightful ideas regarding how to elevate their roles. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Basic
Character and Trust: The Difference Maker in Effective Collaboration
-
Online
2.00 Credits
Member Price: $89
This course examines the foundational role of character and trust in building effective collaboration. While individuals are often hired for their skills and knowledge, they are frequently let go due to behavioral issues—highlighting the importance of character in professional success. Participants will explore key attributes of character and engage in a thought-provoking self-assessment exercise to increase self-awareness. The course also delves into the dynamics of trust, offering practical tools and frameworks to evaluate trustworthiness—both in oneself and in others, including managers, colleagues, and team members. Ideal for anyone seeking to strengthen professional relationships, this course provides actionable insights into how character and trust directly impact workplace performance and collaboration. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Expense Reporting Automation
-
Online
2.00 Credits
Member Price: $89
Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company's use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Common Sense CFO: Decoding and Mitigating Internal and External Risks
-
Online
2.00 Credits
Member Price: $89
Do you get bored with similar rubrics’ cube COSO risk model courses? They are important and great, but this course is intended to offer a fresh approach on the view of risk using the dynamic landscape of modern business; CFOs are charged with navigating an array of external and internal risks that can impact organizational performance and sustainability. This seminar will empower finance professionals with the foresight and practical tools needed to understand, anticipate, and mitigate both external and internal risks. We must be aware and anticipate. If we do not adequately prepare, we will be exposed to avoidable and onerous risk. Essential for leaders and organizations that want to survive and thrive. This seminar stands on its own but is also part of the Common Sense CFO series. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
Member Price: $89
The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Accounting for the Gig Economy
-
Online
2.00 Credits
Member Price: $89
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
Member Price: $89
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.