CPE Catalog & Events

Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the Microsoft 365 suite of applications to unlock new efficiencies and opportunities within your business organization or CPA firm. Don't miss this chance to supercharge your operations with cutting-edge tools! Whether you are working in public practice or business and industry, this event will provide you with a return on investment many times greater than your investment to attend. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).

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.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You have more to do than time to do it. When you finally find the time, distractions steal it away again. As a leader with multiple layers of demands on your time, how can you possibly get it all done? In this course, I will help you learn practical productivity strategies so you can tame your to do list and multiply your time. It’s just wrong for a to-do list to rule your life. Learn how to take back your time…and your life.

Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.   

The role of today's financial leader, including CFO, transcends traditional financial stewardship; it demands agility, innovation, crisis management, and strategic foresight. This seminar will discuss the new, multifaceted skills and insights needed to excel in the dynamic role of modern finance. Through a blend of theory, research, and practical exercises, participants will explore the diverse roles of a CFO as innovation champions, technology evangelists, crisis managers, and change agents - leveraging practical principles to drive organizational success. Financial leaders can adapt or be left behind. Whether you are a seasoned CFO or aspiring to step into a leadership position, this seminar will discuss the essential tools and insights to navigate the newer demands of financial managers with confidence and competence.

QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

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.

As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency. Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations. Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets. This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets. This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts was scrutinized. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

When asked the question, “What would you like to improve about your leadership and communication style?” more than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicate leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident, compelling leader helps to inspire better relationships, promotes trust, and reduces stress in the workplace. Lack of confidence and assertiveness can lead to resentment, depression, low self-esteem, and loss of respect from colleagues and employers. Confident communication cultivates cooperation, goal achievement, and a more respectful work environment. Clear and compelling leaders are better equipped to move projects forward and make things happen while improving cooperation and respect from partners and subordinates.  

Loans, rental agreements, business combinations - what do these all have in common? They all have the potential of creating a related party transaction. This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. This course does not qualify for IRS credit.

This course dives 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 event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Harnessing the potential of PivotTables Whether you're just starting out or seeking to improve your Excel expertise, PivotTables are versatile and powerful tools for data analysis. This course delivers a well-organized method for effectively understanding and using PivotTables through: Practicing fundamentals with a leading expert in financial modeling Creating and using sample datasets Building PivotTables from the ground up Innovative possibilities for presenting data The core functionality of PivotTables for financial professionals is the ability to transform large datasets into meaningful summaries. By reorganizing data from a spreadsheet, PivotTables allows you to: Extract key information and identify trends quickly Simplify the process of analyzing data Reduce the time spent on repetitive tasks *Session 1 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 2: Working with PivotTables] (https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-2-working-with-pivottables) to tackle real-world issues and create powerful workbooks.*

The Internal Revenue Code (IRC) requires entities making certain types of payments, including business payments to contractors, to file information returns with the IRS. Information returns are intended to improve voluntary compliance with tax law by providing information about potentially taxable transactions to the IRS and taxpayers. A payment settlement entity (PSE) must file Form 1099-K for payments made in settlement of reportable payment transactions for each calendar year.

In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference.  

Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. Probably no other industry has so many elections and considerations that need to be considered and made in order to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of more recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation "tailor-made" for CPAs who either work for or represent construction contractors.

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs, including controllers and executives in industry, should understand how difficult the process of buying and selling a business has become.