CPE Catalog & Events
2024 Practical Excel Topics for the Public Accountant
-
Online
2.00 Credits
Member Price: $79
Data validation Underutilized, but powerful, formulas Formulas for manipulating, transforming, and cleansing data Formulas for data analysis Reference formulas such as =VLOOKUP Pivot tables
2024 Self-Rental Real Estate Passive Activity Rules
-
Online
2.00 Credits
Member Price: $79
Definition of self-rental property – both for Sections 199A and 469 Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1 Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2 Self-rental property and the Form 8582 (passive activity)Self-rental property and the flow-through entity grouping election Several real-life situations illustrate the various possibilities and discuss the consequences of failing to comply with the reporting standards Self-rental property and "former passive activities" rules
Shorten Month-End: Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Trends in financial statement closings including the Quick Close, Soft Close and Virtual CloseReview and discuss information systems' headaches that slow you downWork through examples of close cycle "time killers" and how to resolve themGet inventory and cost of sales under controlIdentify the improvement projects that will yield the biggest benefitReview what leading edge finance managers are doing to close more quickly
2024 Annual Update for Not-for-Profit Accountants & Auditors
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:The Not-for-Profit Advisory Committee (NAC).Accounting Standards Updates (ASUs).Year 2 considerations of the leases standard.Common nonprofit deficiencies identified in peer review.What's going on at the AICPA.
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:How to pro-actively find, identify, and connect with new candidates from various sources within LinkedIn.Best practices for organically attracting candidates to your company and team.Strategic talent networking opportunities.Essential considerations of employee advocacy and brand building using LinkedIn.Retention strategies such as promoting a positive work environment, and expanding employee recognition and engagement strategies.
2024 Risk Assessment - A Common Deficiency
-
Online
1.00 Credits
Member Price: $39
Risk Assessment Common Deficiencies
Ethical Situations - What to do When?, featuring Allison McLeod and Don Minges
-
Online
1.00 Credits
Member Price: $59
Intentions versus results. Is using the ‘Threats Based Approach’ always the best? What is, “The clean hands rule,” and how does it apply to Ethics? Situations where Ethics is not black-and-white.
Create Paginated Reports with Power BI Report Builder
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Power BI Report Builder: Overview of the tool, its interface, and integration with the Power BI ecosystem.Designing Report Layouts: Techniques for setting up professional layouts, including headers, footers, and managing pagination.Data Connection and Management: Connecting to various data sources and preparing data for reporting.Creating Visualizations: Utilizing Power BI’s visualization tools for impactful data presentation.Advanced Report Features: Exploring sub-reports, drill-through capabilities, and dynamic expressions.Publishing and Sharing: Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
Surgent's Unique Tax Attributes of Different Entity Types
-
Online
2.00 Credits
Member Price: $99
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?
Business Consulting for CPAs
-
Online
4.00 Credits
Member Price: $129
What is Business Consulting? Identify the types of Management services your firm could offer. How to become the trusted advisor – identification of client’s needs? Learn how client expectations may create different performance and understanding levels for CPAs in business consulting engagements. Know what it takes to create a valuable outcome for the client. Understand the competitive advantages/disadvantages that your firm has versus non-CPA business consultants. Learn techniques to become a more effective consultant. Professional standards application
2024 Your Front-Row Ticket to the 2024 Accounting & Auditing Season
-
Online
4.00 Credits
Member Price: $129
Analysis of relevant GAAP provisions Reminders regarding the continuing importance of ASC 606 for revenue recognition Fresh perspectives of lease accounting in the wake of ASC 842 implementation Overview of U.S. GAAP alternatives for certain entities Summary of selected, salient standards for today’s audit, review, and compilation engagements
Individual Tax Update & Recent Developments - Fall 2024
-
Online
4.00 Credits
Member Price: $129
Update and integration of recent tax legislation impacting 2024 individual returns Update on significant individual tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Section 199A changes, including use of carryforward passive activity and 199A losses and latest tax forms Crypto reporting update 2025 tax rate schedule and other inflation adjusted items; Passive activity and hobby loss rules changes
2024 Annual Update for Governments and Not-for-Profits
-
Online
8.00 Credits
Member Price: $225
Compensated Absences Financial Reporting Model 2024 Compliance Supplement Yellow Book Quality Management
Cybersecurity Fundamentals for CPAs
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Top cloud security threats and how to protect against themData security best practices and how to implement themTypes of cloud services and how to choose a good vendorEffective password management and multi-factor authentication for accountsHome network and device security practices
Consulting Services Secrets
-
Online
1.00 Credits
Member Price: $39
Identifying a consulting specialty Building a practice and translating knowledge into products Managing consulting projects Marketing consulting projects Building a referral network Contingent fees Professional standards for consultants
IRS Audits of the Employee Retention Credit 2024
-
Online
1.00 Credits
Member Price: $49
Employee Retention Credit details Employee Retention Credit Audit process and preparation Update on the market
Awful Ethical Dilemmas - Bringing it to Life, featuring J. Michael Inzina and Don Minges
-
Online
1.00 Credits
Member Price: $59
Following the letter of the Code versus following the spirit of the Code Preparing for conflicts of interest Document your analysis of the situations Five (5) case study examples
2024 Moving Beyond the Basics of Excel
-
Online
2.00 Credits
Member Price: $79
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables
2024 Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
Member Price: $79
Definition, pros and cons of being a real estate professional Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity’s reporting on Form 1040 How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the "grouping" election for passive activities and the flow-through deduction