CPE + Events Catalog

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.

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.

Employees drive the written and unwritten culture at your organization. Understanding the key workplace issues and how to solve them in today's environment can maximize the returns that employees provide for an organization. We take a deep dive into the research behind the larger issues with our workforce and discuss multiple practical solutions that will enhance your leadership and growth. How can we realize the most from our staff?

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 Update 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.

This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also be discussed.  **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.

Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”

BBA partnership audits have begun, and adjustments will come with them. This course will provide an in-depth, practical guide to navigating the confusing world of partnership adjustments. This program will not only cover the new terminology that every practitioner should know. Still, it will provide a roadmap to the critical procedural steps after the IRS has issued a notice of proposed adjustments. In addition, this program will provide real-world examples of the strategic considerations that come with the choices every partnership will have to make once a notice of proposed adjustments is made, including should the partnership pay the tax or push out the adjustment to the partners, what impact does a change in ownership play in who pays the tax, and what can be done to reduce the amount of the imputed underpayment if I have partners that are taxed at less than the maximum rate?

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.

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.