%20web%20banner%204.27.26.png)
CPE Catalog & Events
CPE & Event Classes
MTCPA offers thousands of live and online courses to support your professional development. Our goal is to strengthen your knowledge and help you achieve even greater success.
Most MTCPA courses are offered in both LIVE (In-Person) and VIRTUAL formats—MTCPA Webcasts (in-house) or Webinars (other providers).
Looking for flexibility? Explore Anytime CPE, our on-demand learning platform. Choose individual courses or an all-access subscription to our full Anytime library. Click the Anytime CPE tab below to get started!
Courses are listed by format. Be sure to choose the correct tab below to view and register for the class you want.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Webcast Only
2.00 Credits
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Exploring Business Valuation Fundamentals
-
Webcast Only
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
Surgent's Forms 7217 and 7203
-
Webcast Only
2.00 Credits
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution Executive Order 14219 withdrawing the IRS’s new regulations regarding basis shifting Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis
Advanced Personal Financial Planning Update 26-27
-
Webcast Only
8.00 Credits
Retirement: accumulation and decumulation techniques, Social Security, Medicare and long-term care Debt management, including mortgages and education financing Insurance and investments from a life-planning perspective Income tax legislation, cases, and rulings Estate and trust planning strategies
Leases: ASC Topic 842 in Depth 26-27
-
Webcast Only
8.00 Credits
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Surgent's Excel Tables and Conditional Summing
-
Webcast Only
2.00 Credits
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
Webcast Only
0.00 Credits
The evolving landscape of client expectations in the accounting profession Building strong and lasting client relationships through effective communication, empathy, and proactive service Implementing efficient client onboarding and engagement processes Leveraging technology to streamline communication, enhance collaboration, and deliver personalized service Effectively resolving client concerns and complaints Utilizing client feedback to continually improve your practice
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Webcast Only
4.00 Credits
Relevant sections of SSARS No. 21, Clarification and Recodification SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements
Surgent's Taxation of Tips and Overtime Under OBBBA
-
Webcast Only
2.00 Credits
$12,500 deduction per individual for qualified overtime pay Payment of overtime under the Fair Labor Standards Act (FLSA) Calculating the “premium portion” of the extra half-time pay Social Security and Medicare withholding Employer furnishing the record of qualified overtime compensation to employees Definition of a qualified tip IRS list of traditionally-tipped occupations $25,000 deduction for reported tips The transition rule allowing employers to indicate the approximate amount designated as tips or overtime State tax issues relating to tips and overtime Changes in the W-2 reflecting new employer reporting responsibilities
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Webcast Only
4.00 Credits
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance with Statements on Standards for Accounting and Review Services SSARS No. 27, Applicability of AR-C Section 70 to Financial Statements Prepared as Part of a Consulting Services Engagement Sample comprehensive engagement work programs for preparation, compilation, and review engagements
Surgent's A Guide to Gig Economy Tax Issues
-
Webcast Only
2.00 Credits
Characteristics of a gig economy Who is an employee and who is an independent contractor? Form 1099-NEC and reporting of non-employee compensation Reporting on Form 1099-K Gig workers and the requirement to pay self-employment tax throughout the year State tax implications of remote work for the business owner and workers How remote work creates state tax nexus Tax implications of employee telecommuting for the employer The “convenience of the employer” rule Drivers of both people and of meals or other products Section 199A deduction Implications of the Vizcaino case
Surgent's Business Writing: Professional & Effective Emails
-
Webcast Only
2.00 Credits
Preparing to write: what is my purpose and objective and who is my audience When email is the appropriate communication methodology and when it’s not Common email mistakes and how to avoid them Proven techniques for writing more efficient, readable, and outcome-focused emails
Surgent's Unique Tax Attributes of Different Entity Types
-
Webcast Only
2.00 Credits
Considerations for a small business owner Self-employment taxes Guaranteed payments to partners QBI deductions: Section 199A Built-in gains tax: S corporations Excess passive income tax: S corporations PTE elections: S corporations and partnerships Taxation of fringe benefits: S corporations Double taxation of C corporation dividends Taxation of limited liability companies Which entity to choose?
Ethics in the Real World 26-27
-
Webcast Only
4.00 Credits
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
Fraud—How to Find, How to Prevent 26-27
-
Webcast Only
4.00 Credits
Fraud and its impact on our clients Fraud prevention Internal controls Fraud risks Fraud prevention tips
The ACFE Report to the Nations 26-27
-
Webcast Only
4.00 Credits
Results of the study Red-flags in fraud How fraud is perpetrated How fraud is discovered Methods of minimizing fraud
Predicting the Future: 21st Century Budgets and Projections 26-27
-
Webcast Only
8.00 Credits
Why great predictions are not intuitive How to separate correlation from causation How to recognize and overcome bias Learn from the past without hindsight bias Why the many purposes and types of budgets and projections cause distortions How benchmarking and metrics have changed the budget process
Surgent's Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Webcast Only
4.00 Credits
ERISA compliance: employee welfare plans and qualified plans Fringe benefit issues: COBRA, Family and Medical Leave Act, and new developments in health care Health care plans: HRAs, HSAs, and other employer-sponsored plans Qualified plan requirements: eligibility, coverage, and vesting
Surgent's Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
-
Webcast Only
4.00 Credits
Overview of ERM and how it affects all organizations What COVID-19 has taught us about risk management Risk tolerance and developing a plan Risk identification Risk analysis Risk responses Strategy risk
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Webcast Only
2.00 Credits
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports