Professional Development and Event Catalog

This program addresses the recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out.  An introduction to opportunity zones and other important issues will also be addressed. **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 program addresses the many issues impacting CPA practice with a world in crisis.  The unique challenges facing practitioners are related through actual practice situations – and then analyzed for their ethical implications. Based on real life experiences. **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.

You are likely familiar with the Trust Fund Recovery Penalty or TFRP, BUT - aside from appealing the proposed assessment, did you know that you can make a request to remove the TFRP by making an administrative request on Form 843 (Claim for Refund and Request for Abatement)? This program will provide an overview of the Trust Fund Recovery Penalty with an emphasis on evidence gathering and using Form 843 to prevail on the IRS as to why they should accept your request for refund, effectively undoing the TFRP. This will include what to request in a FOIA, what criteria need to be met for refund, analyzing the IRS' TFRP file, and reconciling requirements in the IRM. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

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.

Knowing just a little about the Yellow Book can hurt you! It is important to have a thorough understanding of the standards. This course covers the Yellow Book financial auditing requirements and prepares you to excel in applying the standards. You will learn precisely what the Yellow Book does and does not require auditors to do. The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced knowledge of the Yellow Book.

Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.

Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Artificial Intelligence (AI) is no longer just a theoretical concept! Instead, AI is a practical tool available today to help you address and solve real-world problems. In this course, you will learn about the fundamentals of AI and how you can put this amazing technology to work today to help you and your team work more efficiently and effectively. Participate in this course to learn about the fundamentals of AI and specific types of problems AI can help you address. You will learn about AI features available in everyday applications – including Excel – and how you can use these features in situations such as detecting fraud and identifying potential errors in transactions. You will also learn how AI is changing how accounting and financial professionals work, both today and in the future.  

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. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today.

Looking to improve the quality of your 401(k) benefit plan audits? This is the course for you. Based on recent data from the U.S. Department of Labor and peer reviews on employee benefit plan audits, we know auditors need to up their game to meet stakeholder demands and provide the best possible audit services. In this advanced course, we will discuss the audit and reporting requirements in accordance with SAS 136 and other recently issued SASs. We will also discuss laws and regulations (such as ERISA) that are unique to employee benefit plans and provide practical guidance on their application. Course topics will focus on the most common compliance issues identified in 401(k) audits by the Department of Labor and peer reviews, as well as recommended corrections. Auditors will identify best practices for auditing areas such as payroll and compensation, participant loans, hardship distributions, investments, and plan mergers and acquisitions.

This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

This presentation highlights the latest legislative changes affecting depreciation and capitalization rules, including inflation increases and Section 179 and 168(k) deductions.  Planning and potential pitfalls will also be presented.  **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.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.