CPE Catalog & Events

Successful organizations understand the importance of effective internal controls and develop a system to stay on the intended course. Those who design policies and procedures benefit by knowing why control measures are necessary. First, we'll examine critical concepts and the importance of strong internal control policies. Then, we'll look at why standards are needed and control creation methods. Finally, discuss strategies to implement policies and procedures.

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 year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.

Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives.  Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth.  This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit.  Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.

As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency.  Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations.  Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets.  This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets.  This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts were scrutinized. **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.  

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

Poorly handled conflicts can lead to break downs in communication, reduced morale, and higher turnover. However, when managed well, conflict has the potential to bring value to the organization and the team. Conflict is a costly and often mishandled occurrence in the workplace. Successful conflict resolution occurs by listening to and providing opportunities to meet each side needs, and adequately addressing their interests so that they are each satisfied with the outcome. In this you will learn the different conflict modes, how to choose the appropriate strategy for your situation, and how relationships impact your ability to promote the positive outcomes and minimize the negative outcomes of conflict.

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics. 

Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit organizations to achieve success.

As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added.  This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code.  The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.

Understand the basics of remote auditing and how it can be used in your engagements Remote auditing has become increasingly popular in recent years. Learn how to apply auditing standards to real-life examples of remote auditing in this all-new webcast. Join us to explore ways to overcome the challenges of remote auditing and conduct efficient engagements for your clients.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools. 

CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What do people say about you when you leave the room? Is it what you want them to say? How you show up in the room, get listened to, build trust, and are known amongst your colleagues are all critical components of your future success. In this workshop Michelle Tillis Lederman, CEO and Founder of Executive Essentials, will discuss how to determine you brand attributes, demonstrate the nuances of body language on your professional presence, and discuss how to strengthen trust and the lasting impressions you make on your network, expanding upon lessons from her books The Connectors; Advantage and The 11 Laws of Likability. 

External auditors understand concepts like materiality, reasonableness, and risk of material misstatement.  This course will explain how to think like an auditor when preparing and fairly presenting your financial statements and related disclosures.

It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.

This course is a case study designed to provide a comprehensive overview of U.S. taxation of a foreign corporation. Using a specific example, the course will walk through step-by-step mechanics on how to calculate the income inclusions and foreign tax credits under GILTI (Global Intangible Low-Taxed Income), Subpart F, and PFIC (Passive Foreign Investment Company) regimes. The case study will further evaluate tax impact of subsequent distributions from the foreign corporation and sales of its stock. A compare-and-contrast approach will highlight the different outcomes of these regimes for individuals and for C corporations, empowering participants to advise their clients on the most tax efficient way to structure their international investments.

Which technology trends will impact you and your business? What emerging technologies will potentially help you to address security and efficiency? How will the emergence of Windows 11 affect you? Should you consider subscription-based software? What does the future of communication technology have in store for you? Get answers to these and other questions by participating in K2’s Technology Update, a four-hour review of technology trends and developments affecting virtually all business professionals. In this session, you will learn about significant issues such as: • Hardware trends, • Software innovations, • Communication and collaboration tools, • Security issues and solutions, • Key products to consider for implementation, and • Unusual and emerging technologies you may have missed. If you’re taking just one technology-focused training session this year, this should be it!