Professional Development and Event Catalog

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 course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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.

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?

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. 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 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.

Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace.  These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets.  **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.

Cover the basic requirements of a peer review performed in accordance with AICPA's Peer Review Standards for firms that perform preparation, compilation, and review engagements. Topics include the documents reviewed by peer reviewers, the evaluation of the engagements, types of matters and peer review reports, the administrative process, peer review committee involvement, and requirements of the state boards of accountancy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Session 7 of Borenstein's Form 990 Foundational Series: 'C the BAD DoG' is a handy phrase to remind preparers of the Form 990's five most frequently applied substantive Schedules (A, B, C, D, G) along with the ALWAYS-required Schedule O. This webinar addresses the first three of these substantive Schedules - A (required of all 501(c)(3) organizations); B (required for many (c)(3)s AND some non-(c)(3)s); and C (reporting on spheres of public policy intersection). The author/instructor's approach to all three is designed to: (1) demystify the Schedule A overall (and explain the nature of the two public support tests); (2) address common misconceptions concerning the Schedule B's reporting of donors; and (3) highlight the reach and underlying preparer needs behind Schedule C's three parts, including commonly missed Sched. C reporting obligations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this session, participants will delve into the differences and similarities that coexist between the Baby Boomers, Gen X, Millennials, and Gen Z in the workplace. Guided by generational whisperer, Summer Jelinek, this immersive session will equip HR professionals with actionable strategies to foster understanding, drive productivity, and promote a harmonious working environment, irrespective of generational backgrounds.

CPAs in public practice are required to maintain independence. In this course, we will discuss concepts associated with independence and review the rules from the AICPA Code of Professional Conduct with a focus on their practical application.  We will also review the recently issued ethics interpretations from the Professional Ethics Executive Committee (PEEC), which impact independence, and discuss practical methods of implementation. 

Excel has over 500 functions and among those, Defined Names is one of the top choices in creating formulas that make your spreadsheets work better for you. After understanding what they are and how to properly create Defined Names, you will wonder how you managed without them for so long. This course is designed to build the foundation to becoming an Excel Formula Expert. Our focus will be on design techniques that should be used when creating formulas. You will learn how to use Defined Names and Excel Tables as an important and fundamental part of EVERY spreadsheet. You will learn techniques that most advanced users don't implement in their spreadsheets but should. After completing this course, you will be well on your way to becoming an Excel Formula Expert. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.

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!”

This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.

This course focuses on the key federal tax issues affecting business from the internal accountant's point of view, with a focus on the major ramifications of the TCJA and other 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.

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 CPE course provides an examination of the recent reports from a selection of Single Audit results. The instructor will go over the most common deficiencies found in Yellow Book and Single Audits and common peer review findings and OIG investigations. This course will also provide examples of common controls, best practices, and mitigation techniques. 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 explores the multitude of issues that taking on a new client can bring with it, and then interprets them using three sets of ethical rules.  A group of “players” reveal real-life challenges faced by the CPA firm in bringing the new client into compliance, as well as proper financial and tax compliance issues. **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 will address the most recent tax legislation, rulings and developments occurring in 2023-24 that will impact both the business and individual taxpaying client.  The course is designed to prepare the practitioner for the upcoming filing season and provide useful strategies to assist in the tax preparation process. **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 will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.