CPE Catalog+Events
Our comprehensive, easy-to-search list of all LCPA-sponsored courses helps you find exactly what you're looking for, or even a course on a new topic to expand your competencies. TIP: When doing multiple searches for different events, be sure to clear filters between searches.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online/Webcast
2.00 Credits
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Surgent's Update on the SECURE 2.0 Act
-
Online/Webcast
2.00 Credits
This course provides a comprehensive analysis of the SECURE 2.0 Act. The principal focus of the Act is to expand retirement coverage and increase retirement savings. As such, the Act has many important changes relating to IRAs and qualified plans. This legislation alters the landscape of retirement planning for taxpayers of all ages. Make sure you are up to date with the latest information available in order to effectively advise your clients on these important changes.
2024 Partnerships and S Corporations: How to Calculate Basis
-
Online/Webcast
4.00 Credits
The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the processes works and their many potential pitfalls. **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. Speaker - Steven Dilley, CPA, JD, PhD
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online/Webcast
8.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
Why Cybersecurity Matters to CPAs
-
Online/Webcast
2.00 Credits
CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going Concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Petrina Youhan, CPA, CISSP/Dr. Kenneth W. Cooper, DCS,
Operations Level Internal Control
-
Online/Webcast
4.00 Credits
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Karl Egnatoff, CPA.CITP
Audit 303: Internal Controls - Required Communications
-
Online/Webcast
2.00 Credits
Internal Control Deficiencies and Other Matters - Adding Value Through Required Auditor Communications will help the auditor with understanding how to improve required internal control communications to be more value-added from the perspective of the client. Professional and regulatory audit standards require communication of internal control matters noted in a financial statement audit. This assists management and those charged with governance with satisfying responsibilities for designing, implementing, maintaining, and monitoring internal controls. In addition, in order to retain existing clients, lower fee pressures and gain invaluable referral sources, financial statement auditors must place a priority on being a value-added business advisor. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for communicating internal control related matters 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.Speaker - Jennifer F. Louis, CPA
The Lifecycle of a Criminal Tax Investigation
-
Online/Webcast
2.00 Credits
Who investigates tax crimes and how are tax crimes prosecuted? Considered the "World's Finest Financial Investigators", the IRS-Criminal Investigation (IRS-CI) has sole jurisdiction in tax crimes and boasts a greater than 90% conviction rate. This agency was responsible for Al Capone going to federal prison and 90 years later they continue to investigate tax crimes such as tax evasion, filing false tax returns, and unpaid employment taxes. The course discusses how IRS-CI finds tax cases to prosecute, what happens during the course of the investigation, what techniques are used to prove tax crimes, what federal criminal statutes are commonly used, how IRS-CI evaluates an investigation, and the expected consequences of a successful prosecution.Speaker - Robert Nordlander, CPA, CFE
Engagement Management with the Microsoft 365 Planner App
-
Online/Webcast
2.00 Credits
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John Higgins, CPA.CITP
Business Federal Tax Update - Navigating the Current Tax Landscape
-
Online/Webcast
8.00 Credits
Stay at the forefront of business income taxation with this essential course tailored for tax practitioners seeking to enhance their expertise. This course offers an in-depth review of the intricacies surrounding business income taxation, focusing on the latest developments for the current tax year. Dive into recent changes and updates within the tax code, providing you with a comprehensive understanding of the evolving tax landscape. Equip yourself to effectively navigate new regulations, guidelines, and strategies while assisting clients in optimizing their business income tax planning. This course was updated in January of 2024 with an additional speaker, Shelli Huston. Speaker - Arthur Werner
Common Deficiencies in EBP Audits
-
Online/Webcast
2.00 Credits
During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melissa Critcher, CPA
Surgent's Auto and Energy-Related Tax Credits
-
Online/Webcast
2.00 Credits
The Inflation Reduction Act (IRA) contains many changes to auto and energy-related credits. Many if not most of these credits reduce the cost of individual- and business-related expenses. As a result of the changes brought about by the IRA, tax advisors have new and reformed credits to understand and explain to their clients. The IRS has issued extensive guidance regarding these credits in the form of Frequently Asked Questions that elaborate on and explain these new credits. This program covers the new and revised energy-related credits clients will be asking about, such as credits related to personal autos, energy-efficient commercial vehicles, and household-related utilities and improvements. This program will cover the IRA changes related to electric car credits in detail so that those attending can properly advise their individual and business clients regarding them.
Surgent's Excel Tables and Conditional Summing
-
Online/Webcast
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Surgent's Real Estate Taxation: Critical Considerations
-
Online/Webcast
4.00 Credits
This course is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022.
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
Communication Skills for Introverts
-
Online/Webcast
2.00 Credits
In today's technology-driven world, success in business depends upon your ability to translate data into information, communicate with anyone, and present ideas powerfully, whether it's one-on-one or in the boardroom. This fast-paced and interactive session covers specific techniques in three critical areas: listening, writing, and presenting. Learn about the hard skills involved in the softer side of leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer Elder, CSP, CPA, CMA, CIA, CFF, CGMA, MS
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online/Webcast
2.00 Credits
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Garrett Wasny, MA, CMC, CITP/FIBP
Audit 304: Auditing Basic Investments - Common Risks
-
Online/Webcast
2.00 Credits
Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
Surgent's Representing a Client in an IRS Audit
-
Online/Webcast
3.00 Credits
Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. Panelists will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.
2024 Financial & Tax Accounting for Partnerships & LLCs
-
Online/Webcast
4.00 Credits
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. Speaker - Steven Dilley, CPA, JD, PhD