CPE Catalog & Events

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.

Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.

What if being nice, or specifically being a positive best version of yourself, made you a more effective leader?  Ethical leadership, is effective leadership. That’s what Dr. Cohen, noted psychologist, transformational speaker, executive coach, and author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen’s work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen’s path to this work, what the Heliotropic Effect is, and how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day.

Although Windows incorporates the OneDrive app, you may not have configured it correctly for your specific needs. Using the OneDrive app and the related Cloud storage service to their fullest potential means you can access your files when and where you need them. Further, sharing your files and collaborating with others is easy when using OneDrive correctly. In this session, you will learn best practices for taking full advantage of OneDrive.

Numbers and especially the digits within those numbers can conceal a lot of information.  Benford's Law and other digital analysis techniques can be the keys to unlocking that information.  This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data.  Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques.  But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.

When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction.  **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.

Could you imagine a drug dealer using a credit-card terminal to accept payment? How about someone paying for a television they bought off the back of a truck with a personal check? Hard to imagine, right? Most criminals conduct their business in cash. For years, criminals kept their ill-gotten gains in cash and used it to pay for everything from real estate to jewelry to things such as private school tuition. This prompted governments around the globe to pass laws prohibiting large cash payments or, at the least, requiring such payments to be reported. These laws created the need for criminals to conceal the true source of the money or to "launder" it. To combat these threats, laws, and regulations have been enacted in countries around the globe that make financial services firms, and in some cases individuals, responsible for preventing or stopping money laundering. Within this course, we explore AML warning signs and potential mitigation techniques companies and professionals can take to help eliminate money laundering.

If sales increase, so should profits.  Yet, the opposite result often leaves executives scratching their heads.  When organizations work with inferior cost information, they make mistakes in four specific situations.  Bad information causes sellers to overprice easy, high-volume work and underprice difficult, low-volume work.  This session discusses how to use activity-based costing data to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.  

Cover the basic requirements of a peer review performed in accordance with AICPA's Peer Review Standards for firms that perform preparation, compilation, and review engagements. Topics include the documents reviewed by peer reviewers, the evaluation of the engagements, types of matters and peer review reports, the administrative process, peer review committee involvement, and requirements of the state boards of accountancy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The effective date for private companies of ASC 326, Credit Losses, is rapidly approaching. Staring in 2023, all entities will be recording credit losses using the current estimate of credit loss (CECL) model, which will accelerate the recognition of such losses for all companies, including non-lending institutions and companies with trade accounts and leases receivable. This new guidance truly impacts all entities. In this course, we'll focus on applying the ASC 326 guidance to non-lending institutions. We'll review the CECL model and discuss how to apply it to trade accounts receivables and lease receivables, as well as the other financial assets which are in the scope of the new guidance. We'll also examine how to transition to the CECL guidance as well as review the new and voluminous disclosures required by ASC 326. 2023 is right around the corner and now is the time to get up to speed on the impact of this new guidance.

Enterprise Risk Management for SMEs

A multitude of tax changes have are currently taking place, challenging tax practitioner to stay well-informed. This 4 hour program will cover tax developments specific to business, including new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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.  

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. 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 new 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.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you ready to maximize the utility of ChatGPT? If so, participate in this session so you can learn the best ways to leverage this tool.

According to the Gallup Organization, only 10% of employees believe that their organization does a good job onboarding new employees. This means most organizations are overlooking this crucial phase of the employee lifecycle, which not only includes the often-neglected pre-boarding stage but also the continuous efforts to reduce uncertainty, bolster excitement, and foster connections for their new recruits. By streamlining these processes and crafting impactful moments from pre-boarding through the initial weeks, HR and Business leaders can significantly enhance efficiency, foster trust, and establish a foundation of psychological safety for years to come. In this session, attendees will discover strategies and resources that craft a holistic onboarding experience, mitigating risks like employee ghosting, and paving the way for heightened engagement and retention.