CPE + Events Catalog

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. 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.

A business conducted as a C corporation can be purchased through an asset acquisition or a stock acquisition. In an asset acquisition, the buyer purchases the business by purchasing the assets that make up the C corporation's ongoing business. In a stock acquisition, the buyer purchases the stock of the C corporation that owns all or a majority of the business assets. The seller and the buyer are usually at odds over how to structure the acquisition. Tax practitioners advising their business clients should be fully conversant in the tax rules that apply to stock and asset acquisitions. Discussing and explaining those rules is the focus of this course.

This program compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities. It includes a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed.

This course will review the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Critical issues, rules, and special opportunities when preparing your clients' Form 1041 U.S. Income Tax Return for Estates and Trusts will be examined, including what is considered taxable income and allowable deductions.  Planning and potential pitfalls will also be explored. 

This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations.  **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 comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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 allow you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company’s accrual-basis financial statements.

This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Delegation is a leadership must-have as no organization can grow or survive succession without encouraging its leaders to delegate. Unfortunately, real delegation is often desired and seldom practiced. At some point or another, we're all guilty of one or more of the seven "sins" of delegation. In this session, we'll explore ways to become better delegators and encourage the highest and best use for all team members. Attend this session to gain concrete strategies for empowering and developing others through powerful delegation! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

During part 3, of this 4-part series, we'll focus on the challenges preparers of fiduciary tax returns face when trying to apply new tax laws often targeted for individuals to non-grantor trusts. This webinar explores in depth the limitations posed by the new tax rules under IRC Sec. 67(g). It also explores presentation issues when the entity has Qualified Business Income (QBI) that results in a Sec. 199A deduction. Lastly, it explores difficult issues that can arise with the charitable contribution deduction.

Today's business leaders need to understand more than simply the financial impact of operations. They need to understand why these outcomes occur. Only by understanding the causes can you develop the appropriate actions for improved results. Learn how to get to the bottom of your financial performance. Discover how to use the "5 Whys Method" of root cause identification. Explore how to use these root causes in creating actionable reports. Successful financial managers know how to "Connect the Dots." Put the "Power of Why" in your analytical toolbox! Start connecting today!

The need for a forensic accountant has grown in the last two decades, with more expected in the future. From oil well spills to divorces - from stealing trust funds to partnership disputes - forensic accountants are needed to find and calculate losses. They are financial detectives that are needed to explain the money story to attorneys, judges, and juries. If you are interested in starting a forensic accounting practice or adding on this service to your existing firm, this course is for you. In this presentation, you will know what service to provide possible clients, how to find those clients, and the cost-effective ways to start the forensic accounting practice. Your instructor has over 20 years of experience as a special agent with IRS-Criminal Investigation where he conducted investigations into tax and money laundering crimes across the globe. After his successful investigative career, he started a CPA firm from scratch that focused on forensic accounting. He shares the successes and failures in starting a forensic accounting practice, including getting the right credentials, various ways of marketing to potential clients, closing the deal with engagement letters, and delivering the service to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program is structured to provide an update of relevant standards for the CPA practitioner or management personnel to consider when preparing and/or auditing financial statements or other associated attestation activities of financial information, concentrating on those standards that mostly impact private entities.

Leading change now ranks in the top three leader skills of the future. As audit, risk management, and governance are relied on more and more in organizational decision-making, the need to lead change is paramount. Leaders and practitioners at all levels must oversee or manage change in today's environment. Whether you are a CEO, small business owner, or individual practitioner, you lead change in your environment. In this session, learn how to lead change BETTER because everyone is a leader of someone. Build alignment with those you lead and work with, motivate and inspire, and model the behaviors that drive change. This session breaks down strategies into manageable steps that anyone can cultivate. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Audit Risk Model - Understanding Foundational Principles is a critical foundational course. Financial statement auditors are engaged to provide reasonable assurance that financial statements are not materially misstated, whether due to fraud or error. Professional standards require auditors to obtain sufficient and appropriate evidence to support that opinion. It is critical for effective and efficient auditors to have a clear understanding of all the important elements and concepts related to properly identifying, evaluating, and deciding how to respond to risk in a financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has the need to understand the foundational principles of the audit risk model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A significant amount of information is electronically initiated, recorded, processed, or reported, and information to be used as audit evidence may be available only in electronic form. During this session we will look at different types of information commonly presented to an auditor during the audit of an employee benefit plan, and identify considerations for auditors when evaluating information to be used as audit evidence.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

Excel tables are a fundamental feature that streamlines data organization, analysis, and visualization in Excel. Throughout this course, you will discover how to transform raw data into elegant, efficient, and visually appealing tables. By harnessing the full potential of Excel tables, you will be able to make better data-driven decisions and collaborate more effectively in various professional settings. Join us in "Improve Design and Productivity with Excel Tables" and unlock the full potential of Excel tables to revolutionize the way you manage, analyze, and present data, leading to improved efficiency and better decision-making in your personal and professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the new AICPA "small" GAAP accounting standards.

Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting.