CPE + Events Catalog

Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization.

Just as there is some convergence of U.S. accounting standards (GAAP) with international standards (IFRS), a convergence of U.S. professional ethics standards (AICPA Code of Professional Conduct) with the international Code of Ethics for Professional Accountants is continuing to emerge. This workshop compares these two sets of ethics standards, emphasizing both the theoretical aspects and practical implications for today's accounting professionals.

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.

Preparing corporate income taxes requires a shift in mindset from individual tax preparation and compliance. In this webcast, you'll learn the concepts and tools necessary to support clients or businesses. Key topics include capitalization, depreciation, carrybacks and major book-to-tax issues involving corporations and Form 1120 preparation. Examine practical spreadsheet approaches that allow practitioners to efficiently and effectively manage book vs. tax differences (M-1 or M-3 items). Cover the impact of new tax law changes with ideas for client consideration. Additionally, dive into a complex corporate return case study, including a discussion of identifying book-to-tax differences and self-review tips. Discuss certain elections and a brief Update of mergers and acquisition issues. Focused on concepts with the presentation in the return, not how to input in return. This is Part 1 of a 2-part series. Be sure to register for both.

Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. 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 will elevate your individual income tax preparation skills and knowledge. It will help you go beyond the basics and will help you provide superior service to your clients. We will cover topics including taxation of investments, reporting of partnership and S-corporation income, net investment income tax, calculation of self-employment taxes, household employer taxes, social security taxation, basic retirement planning opportunities and Alternative Minimum Tax (AMT). In addition, we will also do a review of loss limitations and much more.

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.

This two-day, interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh your research skills and practice using the Codification. Case studies and real-life examples will help attendees readily apply the information covered.

Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has sampling responsibilities. 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 provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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 webcast opens with how to use Excel's lookup functions to perform list comparisons. And, how to perform multicolumn list comparisons without first combining several columns into a single lookup column.

Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Navigate the intricate world of tax compliance for fiduciary entities with confidence through this comprehensive course tailored for financial professionals. Gain practical insights and expertise in preparing the U.S. Income Tax Return for Estates and Trusts (Form 1041), addressing specific issues surrounding decedents' estates and trusts. Delve into the fundamentals of Subchapter J of the Internal Revenue Code and master the art of compliance while decoding complex tax regulations. With engaging case studies and line-by-line instruction, participants will acquire the skills necessary to recognize and address key components of Form 1041, ensuring accuracy and efficiency in tax preparation. Don't miss this opportunity to enhance your proficiency and advance your career in fiduciary taxation. **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.

Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

In this session we focus on the early stages of a fraud investigation, including: who should be on the team, how to create an investigation plan, and the evidence that should be acquired and evaluated. Investigative techniques involving a variety of different sources will be covered, including financial document analysis, background checks, data analysis, and interviewing. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Starting a Fraud Investigation is Part 2 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. 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 course, we will explore the psychological and behavioral factors that contribute to irrational and biased money decision-making. We will examine the role of cognitive biases and emotions in financial decision-making, and discuss strategies for overcoming these biases to make more rational financial choices. 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 provides a detailed discussion on the key topics related to financial reporting, though in a summarized format. The course will focus on recent ASUs issued by the FASB with a concentration on issues of greatest significance to most accounting practitioners. Specifically, the course will review recently issued FASB standards on leases and provide an update on the status of ASC 842 implementation and other hot button accounting issues, such as what is on the FASB's technical agenda. This course is the place to go for a succinct but thorough update on the big topics impacting financial accounting and reporting.

CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.