CPE & Event Calendar

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.

GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will.

People fear presenting more than they do “death”.  Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting.   This is a fun session intended to be interactive with participation either live, virtual or both.  

This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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 two-hour course provides a comprehensive overview of the IRS collection process, guiding tax professionals through each stage, from the initial notice to enforced collection actions. Participants will gain insights into taxpayer expectations during the collection process, as well as strategies for resolving tax debts. The course highlights when to use Form 433-A or 433-B, the documentation needed, and the criteria for submitting an Offer in Compromise (OIC) to settle tax debts for less than the full amount owed. Attendees will also learn about the various payment options available and practical approaches to advising 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

Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.

Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides tax practitioners with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.

Savvy accountants pay attention to fraud trends so they can implement preventive and/or detective controls. This course examines novel frauds to explore potential mitigation measures. Participants will see how selected frauds were accomplished so they can consider internal controls that could have foiled the fraudsters' nefarious efforts. We examine broad ethical considerations and specific provisions of the AICPA Code of Professional Conduct. Along the way, we consider dramatic details of several fraud cases to illustrate practical applications that accountants can apply in their professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

The course provides a comprehensive, hands-on, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns, along with the underlying laws, regulations, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be aware of. The theoretical concepts get illustrated in comprehensive examples that incorporate the most up-to-date law changes and provisions.

Women finance leaders face challenges that traditional corporate training and mentoring rarely prepare them to overcome. For example, you've demonstrated yourself as an excellent tactician, you know how to get the job done, and do it very well on your own. Yet, what got you to your current level of success won't get you to the next level. It's time to change the way you think and operate in your role. You need to move from doer to leader. You're familiar with the saying that if you want to go fast, go alone, if you want to go far, go together. In this workshop, you'll learn key strategies that are unique and critical to women to be successful in their careers. These strategies will help you grow, expand and elevate yourself professionally. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Portable Document Format (PDF) documents are everywhere! Yet few know how to work effectively with these documents. If you are interested in working more effectively and efficiently with PDFs, this session is for you. In this session, you will learn valuable tips you can use to assist you with creating, editing, and securing PDFs. You will also learn how to convert PDFs to fillable forms and secure PDFs, among other features. Don't miss this chance to learn ten PDF tips you need to know to increase your ROI on PDFs.

Are you assisting clients who are selling or buying mid-size companies? We'll examine the accountant advisor's essential role in drafting and structuring purchase-price adjustment mechanisms, due diligence and accounting for transactions. We'll also review considerations such as buyer/seller perspectives and preferences, letters of intent, significant components of definitive purchase agreements, and the high-level tax considerations of buyers/sellers?including the implications of Section 338(h)(10) elections. Get ready to explore the M&A process from non-disclosure agreements to post-closing operations, focusing on the CPA?s role and ways to help clients. Be sure to register for both courses in this series: Mergers & Acquisitions Part 1: The Accountant's Role Mergers & Acquisitions Part 2: Financial Accounting

Strategic Planning for SMEs

This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.

Understanding the advantages and disadvantages of alternatives to Generally Accepted Accounting Principles (GAAP) financial statement presentations is vital to making proper client choices. For example, practitioners may seek to use the Other Comprehensive Basis of Accounting (OCBOA) financial statement presentations, as GAAP will increase complexity and the cost of compliance. Here, we'll explore compliance with the preparation, presentation, disclosure and reporting nuances of cash- and tax-basis financial statements. We'll also discuss the AICPA's Financial Reporting Framework for Small- and Medium-Sized Entities (FRF for SMEs). This course meets the specific OCBOA requirements that CPAs must meet for the re-issuance of their license.

Estate planning continues to evolve, and staying informed about the latest trends and strategies is crucial for professionals in the field. This forward-looking course delves into the intricacies of estate planning, with a specific focus on current issues. Participants will explore cutting-edge techniques, emerging legal considerations, and industry developments to ensure they are equipped with the knowledge and skills to create effective estate plans that withstand the test of time and safeguard their clients' legacies. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com  

This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Practitioners and members in industry responsible for accounting and financial reporting for nonprofit and governmental entities. Stay up-to-date on rapidly changing developments by participating in the 2025 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 2025, 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, 2025 will be a critical year for addressing the complex federal and local 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 2025 and beyond! Exciting new topics this year include focused discussions on addressing the new GASB pronouncement on financial reporting model improvements and capital asset disclosures, artificial intelligence and governments, 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.