Professional Development and Event Catalog

One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs, including controllers and executives in industry, should understand how difficult the process of buying and selling a business has become.

Navigating the challenges of estate and gift taxation can be overwhelming for practitioners, especially those lacking extensive experience in this field. In this comprehensive course, participants will undergo a practical exploration through the preparation of the Federal Forms 706 and 709 - line by line. Through hands-on instruction, attendees will gain invaluable insights into the complexities of tax compliance, equipping them with the skills and confidence needed to seamlessly integrate estate and gift tax preparation into their practice. With a focus on practical application, this course offers participants a unique opportunity to master the preparation of crucial tax returns, enhancing their professional expertise and strengthening client service offerings. From a detailed overview of the Federal Forms 706 and 709 to insights on complying with "Portability" and navigating postmortem estate planning issues, attendees will emerge with a newfound proficiency in estate and gift tax preparation, ready to excel in their practice. **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.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. 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.

This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.    Understanding and Preventing Budget Calamities 2 Hours - Accounting •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.   Building Flexible Budgeting Models: Walking Through and Crunching The Numbers 2 Hours - Accounting •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial planning.  Avoiding Budget People Issues:  Managing Budgeting’s Soft Side 2 Hours - Accounting •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.   Budgeting:  Presenting and Communicating your Numbers 2 Hours - Accounting •    Now that the budget is complete, how we communicate our plan is critical.  this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans.   

Recently issued accounting standard updates provide important clarifications for determining whether a not-for-profit (NFP) organization's transactions are an exchange transaction or a contribution. This course will provide those responsible for preparing financial statements for NFPs examples of the proper accounting for exchange transactions covered by ASU No. 2014-09 versus contributions covered by ASU No. 2018-08. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.

This course focuses on the main elements of financial education and will help accounting and finance professionals guide their clients, and their clients' children, through a personalized teaching roadmap. Clients with wealth face questions about how to teach their children about money to raise financially capable children. Often, their first contact is to their accounting and financial professionals, so it is important to be able to provide a framework to help teach clients how to prepare their children for life with privilege. This course is designed for all practitioners who want to help their clients navigate the process of teaching the next generation about personal finances. Because every family and child are different, it is critical to develop a specific plan for each client, and likely each child and grandchild. By working with their clients' descendants, accounting and finance professionals not only build rapport and trust but also get to know the children and grandchildren, building firm value and long-term connection.

Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will owe estate tax and this issue will eventually be thrust upon you. Finding an affordable, competent specialist who you trust to work with you and your client may be difficult. Learning the basics of the tax and how to complete the form will give you confidence to help your clients navigate that difficult time.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

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

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.

Fraud continues to be a pervasive problem for organizations of all sizes and in all industries. And it can happen to your organization. Accountability professionals are the first line of defense against fraud. Accordingly, accountants, internal auditors, external auditors, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud. According to the Association of Certified Fraud Examiners’ (ACFE) 2022 Report to the Nations: Certified Fraud Examiners estimate that the typical organization loses about 5% of its revenues each year due to fraud.  The median loss per fraud case is $117,000; the average loss per fraud case is $1,783,000. 42% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (86%) but least costly ($100,000 median loss). Financial statement fraud schemes are the least common (9%) but most costly ($593,000 median loss). Corruption is the most common scheme in all global regions. These statistics are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is almost always devastating and can be catastrophic. The 2023 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility.   In addition, attendees will watch a unique and specially designed simulated case of fraud in a corporate setting and watch as the panelists, in their roles as characters in the simulation, respond to the emerging situation and deal with it as a corporate and legal matter to determine the fraud, identify the perpetrators, respond as an organization and deal with criminal and corporate fallout. Following each stage of the fact situation the entire panel will discuss the developments and consider how damage to the company could have been avoided and how it can be mitigated! **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.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you pull back the curtain, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on various government forms. This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Building Flexible Budgeting Models: Walking Through and Crunching The Numbers •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial planning. 

Critics have claimed that traditional managerial accounting is at best useless and at worst dysfunctional and misleading. Most line managers do not trust their management accounting data. 21st Century management accounting develops cost/unit metrics that are useful for budgeting, cost analysis and control. Activity-based costing (ABC) brings truly accurate fact-based costing visibility. ABC does not broadly allocate overhead, but traces costs by identifying cause-and-effect relationships. Such information can provide the ability to reveal true profit margins for products, service-lines, specific sales channels and customers. The same information also helps reduce costs and improve productivity by reporting unit costs that you can use to monitor cost trends and benchmark against your competition. Removing the barriers caused by your current management accounting techniques can provide huge rewards.

Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?