CPE Catalog+Events
Start Here and Get on Course
Welcome to our online catalog. LCPA offers thousands of live and online courses to satisfy your professional development needs. Our easy-to-use filter enables you to find just the right courses to enhance your knowledge and help you succeed even more.
Whether you have an hour during lunch or an entire day, LCPA provides quality, flexible options to fit your schedule. Look for the "See more dates" dropdown to view availability. Several events/classes produced by LCPA can be taken either LIVE (In-Person) or VIRTUAL—please ensure you register for the correct one.
LCPA is proud to partner with ACPEN, CPA Crossings, and Surgent to deliver high-quality webcast and self-study content conveniently and cost-effectively. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.
Mastering the Excel Lookup Functions
-
Online/Webcast
2.00 Credits
See more dates
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.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
2024 Federal Tax Update for Individuals with Doug Van Der Aa
Online/Webcast
4.00 Credits
See more dates
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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 - Doug Van Der Aa, CPA, JD
More Dates
2024 Internal Controls for Small and Medium-Sized Entities
Online/Webcast
1.00 Credits
See more dates
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed. Speaker - Chris Harper
More Dates
IRS Revenue Officers, Field Collection, and Best Practices
Online/Webcast
1.00 Credits
See more dates
You've probably been there. You have a client in your office with excess baggage. That's right, they're in field collection with a Revenue Officer. Now what are you going to do? How are you going to get where you want to be? This program will provide an overview of field collection, how to effectively work with Revenue Officers, general case processing, and important IRM deadlines. This will include taking a deep dive into the "RO Mindset" along with structuring your casework to flow with IRS case processing actions so you can get to the outcome you want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Billy L. Fauller, III, EA, CTRS, NTPI
More Dates
Eight Biggest Threats to your business and introducing Three Pillars of Cybersecurity
Online/Webcast
1.00 Credits
See more dates
Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes. By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around. Speaker - Jon Melloy
More Dates
Cyber Attacks Through Impersonation
Online/Webcast
1.00 Credits
See more dates
This course describes how cyber attacks through impersonation are conducted. It also provides practical advice and recommended security controls to implement, reducing the likelihood and impact of an impersonation cyber attack. 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
More Dates
Surgent's Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
Online/Webcast
2.00 Credits
See more dates
Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.
More Dates
Surgent's Required Minimum Distributions: Compliance and Planning
Online/Webcast
4.00 Credits
See more dates
Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.
More Dates
The Role of Internal Control in the Risk-Based Audit
Online/Webcast
4.00 Credits
See more dates
This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.Speaker - Chris Harper, CPA
More Dates
Surgent's Advanced Individual Income Tax Return Issues
Online/Webcast
8.00 Credits
See more dates
Most Accounting and Financial Professionals have been preparing individual income tax returns for years, and while many of the returns are easy, there are always a number of issues that come up in busy season of which experienced practitioners wish they had more knowledge. This course is designed to explore the tough tax issues for experienced practitioners and help them provide better planning strategies and results for their higher income clients.
More Dates
Surgent's Annual Accounting and Auditing Update
Online/Webcast
8.00 Credits
See more dates
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
More Dates
Available Until
Available Until
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
Online/Webcast
8.00 Credits
See more dates
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.
More Dates
Available Until
Available Until
Surgent's Technical Business Practice Issues and Tax Forms for Experienced Practitioners
Online/Webcast
8.00 Credits
See more dates
Don't let the title frighten you. It is critical that staff be trained on the increasingly complex forms-related issues that challenge them each busy season. This course will help experienced staff focus on the essential amidst the cacophony of IRS and legislative changes and avoid costly mistakes. This course brings to the forefront advanced preparation issues, from individual returns to flow-through entities such as S corporations, LLCs, and partnerships.
More Dates
Walter Haig's AICPA Auditing Standards Update
Online/Webcast
8.00 Credits
See more dates
This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Walter J. Haig
More Dates
Qualified Business Income (QBI) Deduction (199A) - The Ins & Outs
Online/Webcast
8.00 Credits
See more dates
The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A. **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 - J. Patrick Garverick
More Dates
S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis
Online/Webcast
8.00 Credits
See more dates
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 Speaker - J. Patrick Garverick
More Dates
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Online/Webcast
8.00 Credits
See more dates
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff.
More Dates
Excel - Advanced Spreadsheet Troubleshooting Techniques
Online/Webcast
2.00 Credits
See more dates
Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. 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.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Busy Season Survival Strategies
Online/Webcast
2.00 Credits
Busy season is a time when effective communication and efficiency is vital, but that isn't so easy with increased workloads and pressure. Attend this session to explore accountability, communication, employee engagement, and stress management strategies. Leave this session with ideas you can implement immediately to ensure that the spring busy season is highly productive, positive and successful!Speaker - Renee Moelders/Samantha Mansfield
More Money: Strategic Ways to Improve Cash Flow
Online/Webcast
4.00 Credits
See more dates
Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - David Peters