Professional Development and Event Catalog

Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid.

Prior to the COVID-19 pandemic, telework in state and local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work and are reevaluating hiring practices to offer more telework and hybrid work options, not simply as a result of an emergency.  This course will review various telework options and best practices for success. 

The Enhancing Audit Quality Initiative has identified inadequate or nonexistent audit documentation as one of the most significant issues facing the profession. Over half of the engagements reviewed by the AICPA did not meet the requirements of AU-C 230. This course will look at common misconceptions related to audit documentation and help attendees address these deficiencies with efficient and effective best practices.

Auditing PP&E, Including Leases under Topic 842 - Digesting the Risks of Improper Treatment of Tangible Long-Lived Assets will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. 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.

Hacks, attacks, ransomware, malware – where does it end? Unfortunately, tech crimes continue to plague businesses of all sizes. Participate in this session to learn how you can reduce the risk of becoming yet another victim.

Regardless of size, most public accounting firms are mandated to have a written security plan in place. Failing to have such a plan in place can lead to substantial fines. Join us in this session to learn what your security plan should include and how to implement it.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

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.

Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We’ll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.

Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!

You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of several factors, including excessive debt, decreased demand, increased costs, lawsuits or poor accounting practices. It is no secret bankruptcy filings will see a tremendous uptick in the wake of the Covid-19 pandemic. As an accountant, CFP, attorney or other professional, you need to be able to discuss the process and different available courses of action with your clients. Both landlords and tenants will be influenced tremendously. Individuals will look to your advice for a discharge and new start. Businesses will do the same and will also need to advise loyal employees. Creditors will receive proofs of claim and look to you for your expertise. Take this webinar and make sure you can speak fluently to both creditors and debtors. As trusted advisors, then, professionals should have a basic understanding of the bankruptcy process. This course provides a thorough review of the consumer and corporate bankruptcy practice. Participants in this webinar will gain an understanding of how consumer and corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This webinar provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients and your profit margin a favor and sign up for this invaluable webinar.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. 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 addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    **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 have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Navigating the complexities of business transactions requires a deep understanding of tax and estate planning strategies. In this comprehensive course tailored for financial professionals, participants will explore the intricacies of creative approaches to buying, selling, or gifting a business. Through real-world scenarios and practical insights, attendees will gain invaluable expertise in identifying tax risks, minimizing liabilities, and safeguarding assets. From evaluating valuation methods to exploring the details of stock versus asset purchases, this course equips you with the essential tools to provide informed counsel to clients. Discover the potential for strategic success as you master topics including estate transfer and tax implications, gifting strategies, and the utilization of various trusts and partnerships. Whether you're a CPA, EA, attorney, or financial planner, this course offers indispensable knowledge to elevate your practice. With a recommended 8 credit hours of Continuing Professional Education (CPE), this intermediate-level course is designed for professionals with a foundational understanding of business tax and estate planning. Join us and immerse yourself in a journey towards mastery in the vibrant landscape of business transactions. **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 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 is indeed another year of significant change in the world of government and nonprofit accounting and auditing. Time is valuable, and it's hard to stay current in today's rapidly changing environment. Let us save you time and effort with this informative update course. The course materials utilize a highly illustrative and innovative format. Over 30 focused exercises are included to provide an enhanced working knowledge of the latest developments in government and nonprofit accounting and auditing.