CPE Catalog & Events
CPE & Event Classes
MTCPA offers thousands of live and online courses to meet your professional development needs. Our goal is to enhance your knowledge and help you achieve even greater success.
Most MTCPA classes are available both LIVE [In-Person] and VIRTUAL [MTCPA Webcasts (in-house) or Webinars (other providers)], so please be sure to register for the correct format under the appropriate tab below.
Also check out our on-demand learning platform, allowing you to earn CPE at your convenience. You can choose stand-alone courses or opt for an all-access subscription to our entire Anytime library. Click the Anytime CPE tab below to explore the available courses!
Taking Advantage of Array Formulas in Excel
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Fraud Busters: Controls to Prevent & Detect Fraud
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
Surgent's Strategies for Maximizing Social Security Benefits
-
Webcast Only
2.00 Credits
When is a person eligible to take Social Security benefits? Factors to consider when selecting an option for taking Social Security benefits Is there a best age to start taking Social Security benefits? How to maximize Social Security benefit payments for surviving spouses How can a divorced spouse collect Social Security benefits based on the work record of a former spouse? How minor children can collect Social Security benefits based on the work record of an older parent
What's Going on at the FASB (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
AI Privacy, Security, and Compliance Masterclass
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Corporate Transparency Act Developments
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
Microsoft 365 Application Lightning Round Review-Updated
-
Webcast Only
1.00 Credits
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
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
Fraud Case Studies: 21st Century Professional Misbehavior
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
Comprehensive Pass-Through Owners? Basis and Distribution Rules 25-26
-
Webcast Only
8.00 Credits
Understand the four loss limitation rules applied on the owner s individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Determine how to calculate an owners initial tax basis of his pass-through entity Learn how to correctly make annual adjustments to a pass-through owners tax basis Identify what constitutes a debt basis for an S corporation shareholder Learn the tax ramifications of repaying loans to S corporation shareholders
Leases: ASC Topic 842 in Depth 25-26
-
Webcast Only
8.00 Credits
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Social Security Basics and Strategies for Maximizing Benefits 25-26
-
Webcast Only
8.00 Credits
Social Security planning, benefit calculation, and beneficiaries Recent changes to "file and suspend" and "restricted application" strategies Increasing benefits for self-employed individuals Planning for surviving spouses Integrating retirement plan distribution strategies with Social Security claiming strategies Coordinating drawing Social Security benefits with the start of Medicare benefits, including a discussion of IRMAA
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
-
Webcast Only
8.00 Credits
Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done? Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Surgent's Forms 1120-S and 1065 Return Review Boot Camp for New and Experienced Reviewers
-
Webcast Only
8.00 Credits
Reviews of portions of error-prone “staff-prepared” Forms 1120-S and 1065 from client-provided information Be aware of legislative changes How to reduce input errors. When and how to rely on third-party data import software What are common errors preparers make and what are the areas generating malpractice claims? Initial administrative groundwork The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review Overview of new Schedules K-2 and K-3 Don’t fall prey to reporting oddities When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065? Form 1120-S – What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding “open debt”; the default method of calculating basis versus the election under §1367; can an S corporation distribute earnings and profits from C corporation years? Form 1065 – New tax reporting requirement for partners’ capital balances Why use §704(b) to maintain capital accounts; §704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse, nonrecourse, and qualified nonrecourse debt; a review of §754 step-up in basis rules Discussion of more complex transactions included in corporate structures Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return
Surgent's Preparing Not-for-Profit Financial Statements
-
Webcast Only
8.00 Credits
Key requirements, options, and disclosures related to each of the basic financial statements The reporting of functional and natural expense information Requirements related to providing liquidity and availability of financial assets information Core not-for-profit accounting requirements related to conditional and unconditional contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more
The Best Federal Tax Update Course by Surgent
-
Webcast Only
8.00 Credits
Congressional Budget Reconciliation Process - explore how this powerful legislative tool allows Congress to fast track tax law changes and how it could be used to enact significant tax reforms in the current political climate President Trump's tax proposals - review key components of President Trump's tax agenda, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Potential expiration of select TCJA provisions - understand the implications for individual and business taxpayers as key provisions of the TCJA approach sunset dates Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Digital assets and tax implications - understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence - discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements - understand the evolving IRS thresholds and rules for third-party payment platforms Sale of Passthrough Entity Interests and Net Investment Income Tax - analyze the tax implications of selling interests in passthrough entities, including relevant examples, and how the Net Investment Income Tax (NIIT) applies to these transactions The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Walter Haig's Business Financial Health Checkup
-
Webcast Only
8.00 Credits
The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results
Partnership Tax Updates (2025)
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Court decisions covering partnership issues such as TEFRA, Statute of Limitations, Economic Substance, and Sec. 754 Elections.IRS procedural updates on passthrough entities.New developments on conservation easements.
Microsoft Teams - Everything You Need to Know from A to Z
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:Understanding the "big picture" of the role the Teams app plays in your Microsoft 365 ecosystemHow to effectively design your teams / channels configurationDetailed review of all the features for creating conversation postsDetailed review of all the features for creating, editing and managing Office files within the Teams appHow to use the search features to find Teams content instantlyStep by step review of how to host and participate in Teams online meetingsUsing Teams calling features for your phone systemHow to manage your notification settings in TeamsAnd more
About the TIGTA: Who Watches the IRS?
-
Webcast Only
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system