CPE + Events Catalog

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.

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.

This course aims to reveal many examples of companies, leaders and industries who are building new talent models. The world of work is less certain than ever before and this world requires experimentation. In this course you will learn about many experiments that organizations are deploying to build a new model that fits the pace of change the world is experiencing today.  IN this course we will consider many new models and approaches and learn from them. In a world of work with few benchmarks - today organizations need to learn how to experiment and become the benchmark. 

The need for individual tax planning has never been greater. With the 2024 elections and 2026 around the corner, individuals will look to their personal goals and the tax formula as they develop their plans. Exclusions from income, above-the-line deductions, and credits will play a critical role for the next two years, but the return of itemized deductions, exemption deductions, and higher tax rates is coming soon. This course reviews the different types of planning and essential planning techniques. Examples of these approaches are illustrated as scores of tax strategies are presented.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

The need for individual tax planning has never been greater. With the 2024 elections and 2026 around the corner, individuals will look to their personal goals and the tax formula as they develop their plans. Exclusions from income, above-the-line deductions, and credits will play a critical role for the next two years, but the return of itemized deductions, exemption deductions, and higher tax rates is coming soon. This course reviews the different types of planning and essential planning techniques. Examples of these approaches are illustrated as scores of tax strategies are presented.

Our goal is to keep you current with the changing tax environment by focusing on recent legislative, administrative, and judicial decisions and examining topics addressed in the media, publications, journals and conferences. Our belief is that the better informed we are, the better we can serve the profession and our clients. Check in monthly to see the current topic and objectives.

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

QuickBooks remains one of the leading accounting solutions for small and growing businesses and Intuit has added numerous advanced features to the application over the past few releases. In this seminar, you will learn how to take advantage of many of QuickBooks’ new and advanced features to solve important issues. For example, you will learn advanced inventory management techniques, including the ability to change the default costing methodology in QuickBooks, and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to put the Client Data Review feature to work to streamline the process of identifying and correcting errors and closing accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. Take advantage of this opportunity to learn about QuickBooks’ “deep” features so that you maximize your effectiveness with the application.

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. 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.

Fraud Trends - Applying Real-life Lessons to Small- and Mid-Size Entities will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud. Note: This is a part of the suggested 16-hour Audit Skills Level 4 curriculum for experienced in-charges or seniors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. This course fulfills the four-hour ethics education requirement.

Successful organizations understand the importance of effective internal controls and develop a system to stay on the intended course. Those who design policies and procedures benefit by knowing why control measures are necessary. First, we'll examine critical concepts and the importance of strong internal control policies. Then, we'll look at why standards are needed and control creation methods. Finally, discuss strategies to implement policies and procedures.

With the bull market in real estate, securities, and even cryptocurrencies since the enactment of the Tax Cut and Jobs Act, the ability for individuals to take Section 165 losses has been more academic than practical. With the bear market, these limitation provisions have come back to haunt many taxpayers. This program will examine the limitations in the code, the Treasury Regulations, and case law that provide a fuller understanding of when exactly an individual can deduct a section 165 loss.

This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.

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

Form 709 is filed by many tax practitioners but are frequently filed incorrectly. Especially troublesome is reporting the gift correctly on Schedule A, making the correct GST allocations and meeting the adequate disclosure requirements. This program will review common problems for preparers and provide examples of presentations for many of the frequently reported gifts in recent years.