CPE Catalog & Events

Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.

Target setting can drive breathtaking positive results, the moonlandings, the eradication of smallpox or the repair of the ozone layer, for example.  They can also have a dark side that can put executives in jail, bring global businesses to their knees and even cause wholesale loss of life.  Using practical examples and case studies, this course walks you through the steps you need to follow to design robust, effective and credible targets for your organization.

Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. **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.

This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations.  **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

This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax returns. **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

Stay up-to-date on rapidly changing developments by participating in the 2024 Governmental Accounting and Auditing Update! Take advantage of this opportunity to find out about breaking government issues. This is your opportunity to hear about the latest challenges facing state and local governments and practitioners who work with them and audit them, presented by leading experts on governmental accounting and auditing, both those who work in the trenches and those from the regulatory world. With all of the fiscal, regulatory, and new standards challenges facing governments and their auditors, it is important to keep current on critical issues and developments. In 2024, governments and their auditors continue to operate in a rapidly changing environment as they continue to face the many challenges associated with significant federal funding with complex requirements. From a governmental accounting, auditing, and compliance perspective, 2024 will be a critical year for addressing the complex federal funding challenges as well as focusing on implementing new standards and requirements! Plus, it is imperative that you start planning for the significant changes coming in 2024 and beyond! Exciting new topics this year include focused discussions on addressing the new GASB pronouncement on risk disclosures and the GAO’s 2024 Yellow Book! You’ll receive an update on the most recent accounting and auditing developments affecting governments and government auditors. This includes Single Audit issues, AICPA and Yellow Book issues, new and recently effective GASB pronouncements, audit issues, and a look at what’s on the horizon. Join ACPEN’s panel of experts as they discuss, not only the technical requirements of new standards, but also the key implementation issues that must be addressed by auditors and their governmental clients! Benefit from their experience and insights from many perspectives, as well as their long experience in governmental accounting and auditing. **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.

LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors.  This program will address the latest developments: New IRS audit initiatives An SE tax update for LLCs and partnerships Disregarded entity rules and transactions Common allocation problems Identifying various types of partnership debt properly for basis purposes The 754 election in the sale of interests and at death Reporting LLC and partnership interests on gift and estate tax returns and valuation of closely held businesses and minority interests **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.

Project Management is not the same as workflow management, and a project manager is more than a task master. Driving change, leading a team and managing client engagements requires a great deal of organization and planning. Successfully launching a new technology, onboarding clients, developing a new service line ... all takes more than a checklist of to-do items. You need to monitor risks and opportunities. You need to gain buy-in to drive adoption. Proper scoping and projections help keep projects on course, and not become a costly experiment that gets shoved to the back burner. Project managers are trained in analyzing the data while also managing people. In this session explore basic project management best practices and mindset to more effectively managing change in your firm.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today’s popular and software tools and examine the AICPA’s Five-step approach to incorporating data analytics into public accounting engagements.

The topic of fraud continues to be on the radar of investors, shareholders, and regulators. Despite a Kroll Advisors survey showing a decrease of corporate fraud incidents in recent years, new fraud methods are continually being devised and identified thanks in large part to advances in technology and IT infrastructure. Compliance professionals and auditors are not expected to have the expertise of forensic investigators but should have working knowledge of the aspects of fraudulent activities and maintain a skeptical mind when it comes to reviewing potential violations. This course provides a practitioner’s perspective of what your company should include in their internal audit programs and processes to mitigate and avoid fraud. We’ll cover: The psychology of fraud and connection to the fraud triangle and fraud diamond The International Professional Practices Framework (IPPF) for internal auditors Employing the COSO 2013 towards fraud Rightsizing the internal audit team's responsibilities Risk assessment considerations Reporting procedures

Personality Styles - Adapting to Different Types of Personalities for Improved Relationships and Interactions provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.  

Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

To get started in estate planning, learn the basics of intestate succession, probate, wills, health care directives, general powers of attorney, trusts, gift and estate tax planning, as well as transfers of assets. Become familiar with some basics of transfer tax planning, including A-B trusts and QTIPs/marital deduction planning, portability, planning with life insurance trusts, family limited partnerships and more. Also, particular attention will be paid to the human elements that are impacted by estate planning and related tax strategies.

This course is a comprehensive overview of critical Federal tax law updates resulting from changes to current laws, regulations and court cases impacting all business entity types, including S corporations, Partnerships, C corporations and Sole Proprietorships. We will also review recent modifications to tax forms, small business tax law and administrative updates, retirement plan changes and tax practice and procedures. We will also explore the impacts of the Consolidated Appropriations Act of 2021 (CAA), the American Rescue Plan of 2021 (ARPA) and other legislative changes.

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 format your spreadsheets quickly and efficiently 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.

One of the most important aspect of transforming your practice or business to a digital model is to know how to prioritize the applications and initiatives that you focus on and invest in. There is an abundance of "low hanging fruit" initiatives that can provide useful benefits quickly and economically. Using Microsoft Teams meeting app is a perfect example. Chances are pretty good that you are already investing in Microsoft 365 subscriptions for your office. This course will show you how to use the Microsoft 365 subscription ROI by fully utilizing the meeting app and eliminate the unnecessary cost of a separate third-party meeting app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this course, participants will gain a broad understanding of the various anti-fraud preventive and detective tests available to practitioners and take initial steps in building their own library of tests unique to their business or industry risks. Specific discussions and examples will include vendor analysis to look for potentially improper payments around conflicts of interests, fake vendor schemes, bribery & corruption, sanctions and trade compliance, anomalous payments, segregation of duties, among other risk categories.  Participants will also explore tests around customers or distributors that include margin analysis, free goods, discounts and revenue recognition. Further, we will explore employee related test to mitigate travel & entertainment expense abuses. We will also point out various online and public resources for participants to start building their own library of tests to support both reactive investigations as well as proactive prevention and detection.