CPE Catalog & Events
ACPEN: Advanced Excel: Hidden Secrets and Gems
-
Webinar
2.00 Credits
Member Price: $89
Awareness of advanced functions Creative methods for data manipulation Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox
ACPEN: K2’s Taking Another Look At Power BI
-
Webinar
2.00 Credits
Member Price: $89
Getting started with Power BI Creating effective visualizations in Power BI Publishing Power BI reports to dashboards Optimizing dashboards for viewing on mobile devices
ACPEN: Five Amazing Business Books in 100 Minutes
-
Webinar
2.00 Credits
Member Price: $89
Five business books, including, • “Leaders Eat Last”, by Simon Sinek, • “Zero to One” by Peter Thiel, • “American Icon” by Bryce Hoffman, • “Slide:ology” by Nancy Duarte, and • “Brain Rules” by John Molina.
ACPEN: Ethical Practices and Responsibilities Under Circular 230
-
Webinar
2.00 Credits
Member Price: $89
Circular 230 (IRS) rules for conducting a tax practice Provide guidelines for registered tax return preparers and tax return preparation Contingent fees Proposed new rules addressing the evolving nature of tax practice Conflict of interest, best practices, errors and omissions, written opinion requirements Evolving rules for CPA "mobility" History and background for Circular 230
ACPEN: Drive Results with Metrics
-
Webinar
2.00 Credits
Member Price: $89
Performance Metrics Budgets
Business Tax Update: OBBA and Recent Developments
-
Webinar
2.00 Credits
Member Price: $89
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
Smart Formula Selection in Excel: What to Use When
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Surgent's Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
Webinar
2.00 Credits
Member Price: $99
S corporation earnings layers Observations on earnings layers S corporation basis calculation IRC 351 transactions Four loss tiers Appreciated property distributions
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Webinar
4.00 Credits
Member Price: $159
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Identify and develop practical controls to prevent and detect fraud Tailor controls to the size and fit of the government or nonprofit
Surgent's Required Minimum Distributions: Compliance and Planning
-
Webinar
4.00 Credits
Member Price: $159
Minimum distribution requirement changes by the SECURE Act 2.0 Latest IRS guidance, including final regulations The calculation of required minimum distributions using the Uniform Life Table Required minimum distributions from multiple accounts New §401(k) rules of SECURE Act 2.0 Inherited employer retirement accounts and IRAs: Changes to spousal and non-spousal beneficiary distribution options and stretch IRAs under the SECURE Act Required minimum distributions in the year of death Roth conversions for estate planning and avoiding required minimum distributions Timing of distributions for maximum tax-free compounding Section 529 rollovers to Roth accounts under SECURE Act 2.0 Qualified charitable distributions from IRAs and the relationship between deductible IRAs and QCDs under the new anti-abuse rules. Includes SECURE Act 2.0 rollovers to CRUTs and CRATs Taxation of distributions Penalties for missed required minimum distributions and reasonable cause for abatement of penalties. Includes SECURE Act 2.0 changes
ACPEN: Federal Tax Update for Business with Doug Van Der Aa
-
Webinar
4.00 Credits
Member Price: $149
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
ACPEN: Partnership Essentials: Review & Update
-
Webinar
4.00 Credits
Member Price: $149
Recent legislative, rules and tax developments impacting partnerships and their partners Transfer of partnership interests TCJA §461(l) Excess Business Losses and §163(j) Business Interest Expense Importance of capital accounts Form 1065, Schedules K-1 and M-2 Schedules K-2 and K-3 update Reporting partner capital accounts Effect of the Ceiling Rule Alternative and Remedial Methods Effect on financial capital accounts Tax basis capital accounts
Master the Art of CPA Communication: Boost Your Influence!
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication
Comprehensive S Corporation Taxation Form 1120S 26-27
-
Webinar
8.00 Credits
Member Price: $329
Learn how to qualify and to make the S corporation election Determine how to calculate initial and annual stock and debt basis amounts and the three reasons why they are maintained Understand the four loss limitation rules applied on the shareholder's individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Understand the proper tax treatment and reporting of a distribution from the S corporation to a shareholder Determine how to calculate AAA and OAA account for an S corporation as well as the 3 potential taxes Determine the impact of health insurance, the net investment income tax, qualified business income tax deduction and unreasonable compensation issues on the reporting function of the S corporation
Leases: ASC Topic 842 in Depth 26-27
-
Webinar
8.00 Credits
Member Price: $329
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Retirement Distributions: Planning Options 26-27
-
Webinar
8.00 Credits
Member Price: $329
Roth IRA: The right choice" Income tax treatment of distributions from retirement plans of all types Laws, regulations and IRS rulings concerning plan distributions Avoiding penalty on distributions that happen too early or too late Beneficiary choices - eligible or not" Self-directed IRA investment problems
ACPEN: K2’s Excel Best Practices
-
Webinar
8.00 Credits
Member Price: $250
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
Surgent's Advanced Individual Income Tax Return Issues
-
Webinar
8.00 Credits
Member Price: $279
New issues for the current year tax return and §199A Installment sales — understanding the complicated issues Form 8582: Passive losses with carryovers — Complicated case with filled-in forms Puts, calls, straddling, and unusual investments — Understanding the tax laws and reporting them correctly on the tax return Capital gain and loss issues — The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more... At-risk rules: What a return preparer really needs to know Passive loss issues — You cannot just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right! Incentive and nonqualified stock options — Reporting; key strategies for planning; dealing with the alternative minimum tax Alternative minimum tax — Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client Form 6251: Detailed calculation example
Surgent's Annual Accounting and Auditing Update
-
Webinar
8.00 Credits
Member Price: $299
Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Webinar
8.00 Credits
Member Price: $299
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters