CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
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 quickly and easily format your spreadsheets 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.
Qualified Business Income (QBI) Deduction (199A) - The Ins & Outs
-
Online
8.00 Credits
The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A. **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
Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Online
8.00 Credits
As tax policies and economic conditions continue to evolve, staying ahead in fringe benefit planning is more essential than ever. This course provides financial professionals with a comprehensive update on fringe benefit strategies, ensuring compliance with evolving regulations while maximizing tax efficiency for businesses and individuals. Participants will explore the latest legislative and regulatory updates impacting employer-sponsored benefits, IRC §132 fringe benefits, cafeteria plans, and retirement healthcare strategies. This course also examines ERISA reporting requirements, tax-efficient compensation planning, and healthcare benefits, offering practical applications to help practitioners navigate compliance and optimize benefits for their clients. *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
K2's Better Reporting With QuickBooks Online
-
Online
1.00 Credits
Presently, over seven million businesses use QuickBooks Online. However, these businesses often struggle to get the reports they need. In some cases, they are limited because of their chosen subscription. However, necessary reports are available in other cases, yet users do not know how to access them. Join us in this session to learn about better reporting options in QuickBooks Online. In this session, you will learn how to create and customize your reports in QuickBooks Online. You will learn about Standard, Custom, and Management reports. You will also learn about the new Spreadsheet Sync tool that allows you to create customized reports, including multi-company reports in Excel. If you use QuickBooks Online and want to improve reporting, this session is for you!
Interviewing, Onboarding and Training 101
-
Online
1.00 Credits
Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one.
Ethics Aren't for the Byrdes in Ozark
-
Online
1.00 Credits
Professional codes of ethics provide guidance to professionals who are frequently required to choose between doing the right thing and the wrong thing. Sometimes, professionals violate their ethical code and do the wrong thing for what they rationalize is the right reason. This session uses the popular television show "Ozark" and its multiple examples of seemingly good people doing bad things for the right reason to define ethics as well as explore why people make unethical choices and how they justify those choices.
Was It Fraud or Just Poor Audit Quality?
-
Online
1.60 Credits
This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit. The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit. Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed. Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet. Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions. Were the auditors just sloppy, ignorant, negligent? Or were they active participants in producing fraudulent financial statements? You be the judge.
Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers. In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers. The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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.
Auditing For Fraud
-
Online
2.00 Credits
Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD. Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud. While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination. It’s not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations. After attending this session, you will more than likely never look at a financial statement audit the same way.
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.
K2's Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
How good are you with the technology you use daily? What new technology tools are available that could save you time and make you more effective? Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Conce
-
Online
8.00 Credits
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.
Global Internal Audit Standards (GIAS) Domain III - Part 1
-
Online
2.50 Credits
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
Before You Let Them Go: A Whole Brain Approach to Helping Team Members with ADHD Thrive in Your Organization
-
Online
1.00 Credits
Many employees with ADHD struggle with productivity. It’s heart-breaking to feel you have to let a team member go due to lack of performance. This course is for HR Professionals and Team Leaders who want more tools in their tool belt to help improve retention with ADHD team members. You will learn whole brain strategies to help your team members with ADHD improve performance, so they can not only survive but thrive. This innovative science-based approach is designed to help people with ADHD get more done in less time with a process designed with their creative brain in mind.
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series.
Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
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.
Current and Upcoming FASB Issues
-
Online
2.00 Credits
You'll learn about current and upcoming requirements in accounting standards (except financial instruments and leases) and understand how to apply the guidance in practice.
Taxation of Business Entities
-
Online
2.50 Credits
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. **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
Critical Technical Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound technical and analytical necessary for personal growth and organizational success. This course will provide insights into the most critical technical and analytical skills needed by CFOs and Controllers - or those that want to be!
K2'S Artificial Intelligence For Accounting And Financial Professionals
-
Online
4.50 Credits
Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.