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.
The 10 Must Know Excel Features
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit
-
Webcast Only
2.00 Credits
The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program — advantages and disadvantages The DOL Final Rule
Surgent's Guide to the AICPA Quality Management Standards
-
Webcast Only
2.00 Credits
Quality management standards SAS 146, SSARS No. 26, and SSAE 23 Risk assessment, which forms the basis of the SQM Monitoring and evaluating the SQM
Accounting for the Gig Economy
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors
Reasonable Compensation for S Corps
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explain the payroll tax advantage of taking distributions over wagesReview key court cases that shape todays reasonable compensation landscapeHow to use court factors to stress test reasonable compensationBest practices for determining reasonable compensationReview of the IRS’s enforcement on reasonable compensation; past, present and future
Calculating the Retirement Need
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Overview of retirement expenses and needsOverview of risk tolerance, time value of money and retirement planning factorsExamples of client retirement situations
Internal Controls Over Compliance vs Compliance
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
Self-Rental Real Estate: Passive Activity & Section 199A
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
The Bookkeeper Goes to Prison
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Money Laundering 101 for CPAs
-
Webcast Only
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Building Security and Efficiency With Internal Control
-
Webcast Only
8.00 Credits
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
-
Webcast Only
8.00 Credits
Developing issues related to the Yellow Book and single audits Key AICPA developments affecting audits of governments and nonprofits The implementation of GASB No. 103 on financial reporting model improvements GASB No. 104 addressing disclosure of certain capital assets Impacts of recently applied governmental standards, recently issued implementation guide questions, and additional GASB projects (e.g., subsequent events) The essential disclosure requirements specific to not-for-profit organizations and strategies for enhancing clarity and value The advantages, challenges, and best practices for effectively presenting a measure of operations
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
-
Webcast Only
8.00 Credits
Regulatory, fiscal, and monetary policies impact on the organization Dodd-Frank Bill and impact on financial reform Health insurance reform and the impact on the employer Managing risk in an uncertain economic climate
Surgent's The Complete Guide to Payroll Taxes and 1099 Issues
-
Webcast Only
8.00 Credits
Payroll tax requirements for wages, including wages subject to the .9 percent tax, employee benefits and reimbursements, nonqualified deferred compensation, stock options, and tips Fringe benefits issues, such as health insurance, life insurance, cafeteria plan benefits, accountable and non-accountable plans, standard mileage rates, and per diem rates Special issues -- Using a common paymaster, how to file W-2s after a takeover, merger, or acquisition, and state and local tax withholding Statutory employees, independent contractors, and possible changes to §530 relief Penalties -- Who is a responsible person? Expenses and gross-up calculations Pension issues and payroll taxes including SIMPLE plans, and §401(k) and pension distributions The Electronic Federal Tax Payment System (EFTPS) Forms I-9, W-9, W-2, 1099, 1099-NEC, SS-8, and 940 Understanding payroll tax responsibilities in the gig economy
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Webcast Only
8.00 Credits
Discussion of key individual provisions of the One Big Beautiful Bill Act, such as TCJA provisions made permanent, new tip income deduction, new overtime pay deduction, Trump accounts, and the expanded SALT cap Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion Excess Business Loss Limitation Section 1244 Small Business Stock and Section 1202 Qualified Small Business Stock treatment and applicability Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Partnership Distributions, Form 7217, and S Corporation Redemptions Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Decentralized Autonomous Organizations (DAOs)
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
Analyzing IFRS Financial Statements
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Financial Analysis fundamentals: Overview of financial statements, their interconnections, and the foundation of advanced analysisLoblaw Companies Case Study: Introduction to our example company and its financial performanceAdvanced Analysis Techniques: Common size analysis, Dupont framework, financial leverage, and operational metricsOperational Focus: Separating core business performance from financing activitiesApplied analysis and managerial ratios: Segment analysis, cash flow analysis, and managerial ratiosManagement Commentary: Overview of the corporate narrative as presented from IFRS lens.
Common Financial Statement Disclosures
-
Webcast Only
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
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