CPE + Events Catalog

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.

This course is designed to assist practitioners in preparing Offers in Compromise (OIC). After this course, you should have an understanding of how proper planning can make a significant difference in the amount eventually paid to the IRS and the resulting financial well-being of your client. This program covers the basics, from choosing the proper forms to utilize through the filing of an appeal if necessary. We will also explain how to increase your chances of having your OIC approved by the IRS by going over the complexities involved.

With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Art of Discipline and Getting Things Done - Applying Better Time, Team, and Project Management Techniques provides best practices for various areas that support this culture of discipline, including time, team, and project management. Those in a supervisory or managerial role must create a culture of discipline, where a high priority is placed in accomplishing responsibilities in an effective and efficient manner. Note: This course is recommended as a part of an 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for project and time management. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A personal brand is your story. Having a well-defined personal brand can help you not only cultivate powerful connections but also set you apart. Explore the integral components to building a strong brand and gain strategies to help you create your own marketable personal brand.

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. 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 the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts.  **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.