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!
Finding Errors in Excel Spreadsheets
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
Best Non-Google Search Tools for Accountants
-
Webcast Only
2.00 Credits
The major topics that will be covered in this class include:Why Advanced Search Skills Are So Critical for AccountantsWhy You Need More than Google to Search the InternetGARP: Generally Accepted Research PrinciplesAlternatives to GoogleAdvisory SearchSocial SearchSpecialty searchSearch Engine resourcesWhat's Ahead in Search
Forensic Accounting: Investigating Divorce Cases
-
Webcast Only
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Deception, Embezzlement and Fraud 25-26
-
Webcast Only
8.00 Credits
Narcissism Studies Fraud Embezzlement Technology used in scams
Ethics of AI: A CPA's Guide
-
Webcast Only
2.00 Credits
The major subjects that will be covered in this course include:A primer on AI technology applications in the accounting professionEthical dilemmas that originate from the use of AI by CPAsPractical guidelines for using AI technology ethicallyStep by step guide for creating an AI usage policy for your organizationReview of a variety of reference materials to assist you in using AI ethically
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
How to Audit Inventory
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.
Financial Decisions that Led Two Businessmen 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
Cultural Transformation
-
Webcast Only
1.00 Credits
The major topics that will be covered in this course include:What is culture Why culture matters A process to change your organization’s culture
Advanced Excel for Staff - Build Reports and Analyze Data
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
Surgent's Raising Financially Capable Children
-
Webcast Only
2.00 Credits
Discussion of the importance of financial education for the next generation Understanding a client’s financial values Determining a client’s financial literacy Helping clients develop a teaching roadmap Using knowledge to protect against entitlement Developing a knowledge base for the information, including a full list of recommended books on the topic and games for families to play Discussion of specific topics, including tips and tricks related to: Allowances Earning, work, and entrepreneurship Spending, saving, and investing Philanthropy Taxes Credit cards, crypto, and financial fraud
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Webcast Only
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
Surgent's Mastering Accounting for Income Taxes
-
Webcast Only
4.00 Credits
The sources of deferred tax assets and liabilities Calculating the deferred tax asset or liability Reporting income-tax expense and balance sheet items CARES Act accounting implications Defining, analyzing, and reporting uncertain tax positions Classification of deferred tax assets and liabilities Disclosure requirements Recent and proposed changes to the accounting and disclosure requirements for income taxes
Exploring Internal Controls That Could Have Prevented Frauds
-
Webcast Only
2.00 Credits
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios
Retaining Talent in a Competitive Marketplace
-
Webcast Only
4.00 Credits
The major topics that will be covered in this class include:Decision Making TheoryCompensation & Employee SatisfactionWhat benefits do employees care about?Retirement Plan BasicsHealth Insurance BasicsDisability Insurance BasicsLife Insurance BasicsFringe BenefitsSumming It Up
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Webcast Only
2.00 Credits
529 to Roth: who, what, when, and how SECURE Act 1.0 and the 10-year rule Roth IRA beneficiary options Where the stretch IRA really ends The new limitations for spouse IRA beneficiaries The new spouse options for spouse beneficiaries New RMD rules for Roth 401(k)s Overriding the 10-year rule for an eligible designated beneficiary How the age of death affects beneficiary options The new early distribution penalty exceptions Rollovers vs. transfers for spouse beneficiaries Qualified charitable distributions (QCDs) for owners and beneficiaries The “at least as rapidly” (ALAR) rule New reduced rate for excess accumulation penalty on RMD failures How to avoid unlimited accrual of the 6% excise tax How to avoid unlimited accrual of the 25% excise tax Clarifying the definition of disability for an exception to the 10% additional tax The new starting ages for RMDs Designated vs. eligible designated beneficiaries and their options Catch-up contributions for ages 50 and over Catch-up contributions for ages 60 to 63 When the 60-day deadline is missed When the one-per-year rollover limit is about to be broken Retaining qualifications for exceptions to the 10% additional tax
Operations Level Internal Control
-
Webcast Only
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
Coaching the Next Generation of CPAs
-
Webcast Only
2.00 Credits
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.