CPE + Events Catalog

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds.  This course will provide a concise look at these hot 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.

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.

Preparing corporate income taxes requires a shift in mindset from individual tax preparation and compliance. In this webcast, you'll learn the concepts and tools necessary to support clients or businesses. Key topics include capitalization, depreciation, carrybacks and major book-to-tax issues involving corporations and Form 1120 preparation. Examine practical spreadsheet approaches that allow practitioners to efficiently and effectively manage book vs. tax differences (M-1 or M-3 items). Cover the impact of new tax law changes with ideas for client consideration. Additionally, dive into a complex corporate return case study, including a discussion of identifying book-to-tax differences and self-review tips. Discuss certain elections and a brief Update of mergers and acquisition issues. Focused on concepts with the presentation in the return, not how to input in return. This is Part 1 of a 2-part series. Be sure to register for both.

In this course, you'll review what ethics means for a CPA firm and how to use the rules. The interactive workshop is designed for practitioners in small and medium-sized CPA firms and includes generous time for questions and case studies.

Think about how much time you spend reviewing and creating PDF files. This course teaches you how to take advantage of a multitude of features and functions available in Adobe Acrobat to create, review, organize, edit and secure your PDF files more effectively and efficiently. Like many personal productivity software applications, it is very likely that you are using only a fraction of the potential of Adobe Acrobat when working with your PDF files. For many CPAs, a PDF file is the final presentation of your work product, whether it is a tax return, financial statement, audit report or other financial reports. This course will teach you how improve the quality of those report presentations. The tips you learn in this course will save you time on a daily basis. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Covers ways to integrate the latest tax law changes into planning and compliance engagements., Corporations and pass-through entities are subject to new regulations in 2023. Practitioners gain access to all-new content to help them stay on top of new business tax developments.

This course provides in-depth coverage of ASC Topic 842, Leases. Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

This two-day, interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh your research skills and practice using the Codification. Case studies and real-life examples will help attendees readily apply the information covered.

The Audit Risk Model - Understanding Foundational Principles is a critical foundational course. Financial statement auditors are engaged to provide reasonable assurance that financial statements are not materially misstated, whether due to fraud or error. Professional standards require auditors to obtain sufficient and appropriate evidence to support that opinion. It is critical for effective and efficient auditors to have a clear understanding of all the important elements and concepts related to properly identifying, evaluating, and deciding how to respond to risk in a financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has the need to understand the foundational principles of the audit risk model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

CPAs in public practice are required to maintain independence. In this course, we will discuss concepts associated with independence and review the rules from the AICPA Code of Professional Conduct with a focus on their practical application.  We will also review the recently issued ethics interpretations from the Professional Ethics Executive Committee (PEEC), which impact independence, and discuss practical methods of implementation. 

This session features the latest behavioral science, demonstrations of experiments, and compelling real-life stories to disrupt everything you thought you knew about fraud. It will spur you to challenge "sacred cows" of the industry and help you develop better thinking approaches to detect, deter, or investigate fraud, waste and abuse. Learn why many of our basic assumptions about fraud are flawed, why some widely accepted investigative practices are more harmful than helpful, and how auditors and investigators sometimes unwittingly assist fraud schemes. 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 will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll 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. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing  group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB.

The initial career focus of many CPAs is to develop technical skills. However, they must understand nonverbal communication to attain upward mobility, which provides a career-building advantage. Understanding nonverbal communication helps in everything from proposals to final negotiations to mentorship, reducing inconsistent messaging and building stronger relationships. We'll continue to have "Virtual" opportunities in our professional world. Unique non-verbal awareness in this platform is critical.

The presentation includes an in-depth discussion of the when the Forms 1065 and 1120S, Schedules K-2 and K-3 must be completed, as well as important developments for filing 2021 flow-through entity tax forms and other recent developments impacting both partnership and S corporation entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

A challenge for many small business owners is choosing the `right' type of retirement plan for their businesses. Many hesitate to make a choice because they are intimidated by the governing rules. In those cases, an IRA-based retirement plan is an easy, effective, and efficient way to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. In some cases, employer contributions are discretionary, providing the business owners with the choice of whether to fund every year.

There are numerous federal laws that restrict what businesses can do in terms of hiring and firing employees. Many of these laws impose significant penalties if employers violate them. Accordingly, it is crucial that all employers and their professional advisors understand these laws and apply them to their employment practices.

Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will owe estate tax and this issue will eventually be thrust upon you. Finding an affordable, competent specialist who you trust to work with you and your client may be difficult. Learning the basics of the tax and how to complete the form will give you confidence to help your clients navigate that difficult time.