CPE & Event Calendar

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC 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

This comprehensive training is designed to get the accountant up to speed quickly with the complex passive activity loss (PAL) rules that apply to certain investments in trades or businesses and rental activities. The cornerstone of the course is the in-depth coverage of the detailed tax law and regulations applicable to passive activities under IRC §469 and how and when the 3.8% net investment income tax under §1411 applies. **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

Part 1 of a 2-part series is an overview of GAAP requirements for nonprofit organizations and will help you become proficient in nonprofit financial reporting. This webcast focuses on presentation and disclosure unique to nonprofit organizations. Be sure to register for the next in the series: Nonprofit A&A Series Part 2: Revenue Recognition.

Personal financial planning issues evolve in an increasingly challenging environment where it's harder to keep up with important and timely changes. And since changes seem to be occurring quicker than anticipated, with several recent twists, CPAs must be prepared for the unexpected and be in tune with new approaches. As a result, CPAs must challenge clients to stay focused on their goals while managing expectations and striving for realism in order to achieve objectives. We'll focus on the newest personal financial planning changes and prepare for new opportunities related to income tax, retirement and estate planning issues. You'll learn what you need to know in identifying critical exposures and providing appropriate solutions when working with your client in these rapidly changing and life-altering disciplines. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement, and Estate Planning PFP Update: Issues, Exposures, and Developing Client Strategy PFP Update: Investment Planning in This New Era

Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.

Gift taxation is a critical component of estate planning, and Form 709 serves as the key reporting tool. This course provides a comprehensive line-by-line guide to preparing Form 709, ensuring accuracy and compliance. Participants will learn how to determine taxable gifts, apply exclusions, and utilize available deductions. Special attention will be given to valuation techniques, gift-splitting, and generation-skipping transfer tax (GSTT) considerations. Additionally, this course will examine any new legislative changes from the current administration and how they may impact gift tax planning and reporting. *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 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This 8-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, 2-hour SSARS Highlight Reel and 2-hour SQMS programs available as stand-alone courses.

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.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Starting with tax year 2021, Form 7203, S Corporation Shareholder Stock and Debt Basis Limitation, may be required to accompany shareholders’ Individual Income Tax Returns (Form 1040). This form is essential for reporting a shareholder's outside basis and debt basis to properly apply loss limitations under I.R.C. §461 and at-risk limitations. This course will provide a detailed overview of Form 7203, including its mechanics and strategies for completing it accurately. Additionally, strategies for reconstructing shareholder basis when it has not been maintained in the past will be discussed, helping practitioners handle these scenarios effectively. *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

Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. 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 provides a concise overview of recent IRS criminal investigations and what practitioners can learn from these cases to help fight economic crime and even avoid personal criminal prosecution. While accountants are numbers people by training (not detectives per se with the exception of forensic accountants), practitioners are increasingly being called upon by governments and economic organizations at all levels to step up and help law enforcement battle financial impropriety. The stakes are huge. In the United States alone, the OECD estimates that 5% to 10% of the annual budget of the US health care programs, Medicare and Medicaid, is wasted as a result of corruption. Every dollar lost to monetary malfeasance has a crippling effect that ripples through countries, industries, companies, communities and individual lives. Government resources are wasted, public services are compromised, companies are financially destabilized, shareholders are cheated, employers are swindled, charities are undermined and much more. By increasing their awareness of what and how the IRS investigates and prosecutes, accountants can heighten their "spidey sense" of what doesn't look right in financial records. This includes honing skills to more readily notice -- and report -- ledger anomalies and irregularities, and even rethink a "silence is always safer" mindset. As technology disrupts and automates many fundamental accounting functions, practitioners can add value by more diligently scanning for "creative accounting" red flags on the frontlines. Prioritizing transparency and behaving ethically -- the core of the profession -- not only helps society and the economy as a whole, it can help accountants boost their reputation as highly trusted business advisors and even supercharge their bottom line. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Part 2 of a 2-part series is an overview of GAAP requirements for nonprofit organizations and will help you become proficient in nonprofit financial reporting. This session focuses on revenue recognition. Be sure to register for part 1 in the series: Nonprofit A&A Series Part 1: Financial Statement Presentation & Disclosure

Our clients' personal financial planning issues are quickly developing and keep us challenged in a new operating environment! Many new approaches are needed in working through, understanding, diagnosing and then adopting innovative and proven strategies. Additional ways of experiencing these client situations are entering the picture. With information overload, part of the CPA's challenge is to help clients stay focused on goals while managing expectations in a rapidly changing environment. This course will update you on the newest personal financial planning changes related to insurance, investments, education, retirement, estate, cash flow management, divorce, closely held businesses and other relevant topics. We'll discuss critical issues, including planning for education, divorce, charitable, exceptional circumstances, business owners and highly compensated executives. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement, and Estate Planning PFP Update: Issues, Exposures, and Developing Client Strategy PFP Update: Investment Planning in This New Era

This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.

This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.