CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Ethics: 10 Crucial Qualities of High Character CPAs
-
Virtual
2.00 Credits
The major topics covered in this class include:Discover why the ten crucial qualities of high-character CPAs are essential to your successLearn how to evaluate these qualities in job candidates and why you must do so
ACPEN: Are You Up For the Challenge? Test Your Skills as a Quality Control Reviewer
-
Online
4.00 Credits
AICPA professional standards EQCR expectations Firm-specific considerations Best practices for reducing the frequency of review points Best practices for mitigating the severity of review points Examples of common EQCR deficiencies The impending influence of SQMS No. 1, SQMS No. 2, SAS 146, and SSARS 26 An interactive, hands-on EQCR simulation
ChatGPT for Accountants: 50+ Use Cases
-
Virtual
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
ACPEN: 1065 – Understanding Partnerships Tax Returns
-
Online
2.00 Credits
Partnership taxation Different types of partnerships Tax obligations of partners Role of the partnership agreement in tax reporting Filing deadlines of Form 1065
ACPEN: Introduction to Forensic Accounting
-
Online
1.80 Credits
Forensic Accounting Accounting Auditing Finance
The Future of Audit: Technology, Talent & Transformation
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Explore AI, blockchain, and data analytics impact on audits Address talent crisis through retention and upskilling strategies Navigate PCAOB standards and regulatory sandbox concepts Expand audits to include ESG and nonfinancial metrics Implement technology solutions for firms of all sizes
ACPEN: Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Competitive bids Achieving target profitability
Business Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
Introduction to Yellow Book: 8-Credit Boot Camp
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:The basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The key financial reporting differences for governmental and nonprofit entities.The fundamentals of Yellow Book and Uniform Guidance audits.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Virtual
8.00 Credits
Proper planning of benefit plan audit engagements and developing audit strategy while improving overall efficiency Common pitfalls in planning and detailed audit procedures Changes affecting 401(k) plans, including recently issued SASs Common mistakes as noted in peer reviews and DOL inspections
ACPEN: The Ethics of How We Treat People; Why it Matters?
-
Online
1.00 Credits
Is it ethical to mistreat others? What are the signs and consequences of mistreatment? Why does treating people ethically matter for finance and business professionals? The consequences of mistreating people? What is the return on treating people well?
ACPEN: Digital Resilience: Building Stronger, Smarter Organizations
-
Online
1.00 Credits
Digital resilience Resilience frameworks Risk management Leadership & Cross-Functional Strategies
ACPEN: Revenue Recognition - Topic 606 Overview
-
Online
1.80 Credits
Revenue Recognition on Contracts with customers
ACPEN: K2’s Excel Tips – Today’s Best Features
-
Online
2.00 Credits
New features and functions in Excel How to improve efficiency and effectiveness when working in Excel Taking advantage of Copilot integration with Excel Better ways of creating and working with formulas
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of AI technology and how it worksIdentify where AI can be incorporated into tax research, planning, and compliance servicesDiscover new opportunities to enhance your client advisory tax services with AI toolsReview the market of emerging and AI enhanced tax software toolsLearn about the newest generation of AI enable 1040 source document collection and organizer applicationsReview specific use cases for generative AI tools (e.g. ChatGPT, Microsoft Copilot) in your tax services
ACPEN: Guide to Deducting Travel, Meals and Entertainment Expenses
-
Online
4.00 Credits
Recent tax legislation, rules and developments impacting travel and meals expense reporting Adequate accounting rules for reimbursements, including accountable plans, going paperless, reimbursement for non-deductible expenses Reporting travel expenses: travel status, simplified per diem "Directly related to" and associated with" tests Facility vs. activity expenses 9 exceptions to Section 274 Business meals: IRS Notice 2018-76
Reviewing Individual Tax Returns: What Are You Missing?
-
Virtual
4.00 Credits
Qualified business income deduction Temporary senior deduction State and local tax deduction Hobby losses Self-employment health insurance Business startup costs Depreciation Schedule C issues Like-kind exchanges
ACPEN: Form 1040 Individual Income Tax Prep
-
Online
8.00 Credits
Overview of Form 1040 and filing requirements Filing status and dependent rules Income reporting, including wages, interest, and dividends Adjustments to income Standard vs itemized deductions Common individual tax credits Introduction to Schedule C and Schedule E Preparer responsibilities, due diligence, and Circular 230
