CPE + Events Catalog

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.

Embracing and cultivating Diversity, Equity and Inclusion (DEI) in the workplace IS Ethics at Work! This session explores ethical values and principles related to these initiatives and examines workplace behaviors, individually and collectively, that foster and promote organizational well being. Robbie offers findings on strategies that work to improve DEI efforts based on best practices and interviews with experts in the field. Please note that for those of you who have taken courses from Robbie there will be some duplication and much new content. This session is designed for people who wish for a more fair and just world and workplace. 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 examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters’ ability to accomplish their nefarious acts.

Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources. 

Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!

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. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. **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 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.

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.  

In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.

Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. 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.

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.

Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. 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, we will explore the psychological and behavioral factors that contribute to irrational and biased money decision-making. We will examine the role of cognitive biases and emotions in financial decision-making, and discuss strategies for overcoming these biases to make more rational financial choices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.

Blockchain technology offers the promise of digital truth. When appropriately implemented, it provides a transparent, permanent, immutable, and high-speed record-keeping system. The possibilities are endless, from managing the logistics of supply chain networks to facilitating international commerce. The adoption of this technology is growing, with millions of new users every year. Organizations adopt this technology daily to help improve their existing operations through its ledger capabilities or by executing smart contracts. Cryptocurrency is one example of blockchain technology, and its growth and value have exploded to over $2 trillion in the last few years. This growth has helped fuel the adoption of Wall Street traders and traditional investors. While more popular than ever, few business professionals understand these technologies and their capabilities, risks, and potential impacts on business operations and processes, such as contract execution, recording and maintaining real estate ownership records, and supply chains. Unfortunately, this incredible technology is a mystery for most accounting professionals. This course will provide an in-depth look at this technology, including a detailed Update of the underlying technology, the benefits, the risks, the major players, and many practical applications. By participating in this session, you will gain a deeper understanding of the inner workings of this technology and recommendations for getting started.

This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Knowing the basics of advanced estate planning strategies is essential in advising clients with significant wealth seeking assistance in developing succession plans to address individual needs. However, running the numbers under various scenarios and assumptions is critical to the success of a plan. This webinar focuses on modeling the numbers for the different strategies and building flexibility into a plan. Such modeling in a live demonstration of financial planning software, running modeling exercises and reviewing examples of sophisticated estate and business planning scenarios is critical to understanding the concepts.