CPE Catalog & Events

The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.

SQMS 1 and 2 Auditing Yellowbook

The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture

Accounting Finance

The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options

Inventory accounting GAAP Methods for dealing with variances  

The major topics that will be covered in this course include:Deep dive into the Accounting Standards Updates (ASUs) effective in 2025.Insights from the FAF's 2024 PCC Review.Overview of FASB's Invitation to Comment - Agenda Consultation.The essential changes in quality management standards that firms must implement by the end of 2025. Common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB).

Underlying concepts of internal control Defining where and why controls, policies and procedures are needed Legacy control measures that are still important for businesses today Creating control measures that address the use and protection of technology

Filing requirements and personal exemptions Gross income inclusions, exclusions and adjustments Standard and itemized deductions Tax credits Tax provisions for high-income taxpayers 3.8% net investment income tax Roth IRA, IRA and retirement plan options Section 199A qualified business income deduction

Timely coverage of breaking tax legislation Applicable coverage of any basis considerations within any recent tax legislation   Passthrough basis calculations required as attachments to certain individual returns  Executor’s form for disclosing basis in certain distributed property; what about the basis of a property distribution from a trust?  How §179 limitations affect basis and how tax-benefit rule is applied  Basis implications of personal assets converted to business use  How to calculate basis of inherited qualified and joint tenancy property  Tax basis capital account reporting requirements  S corporations: Beware of final IRS regulations regarding “open debt”; determine how to calculate basis; worksheets are included; understand the effect of stock basis and debt basis and IRS’s recent focus on “at-risk basis” for shareholders; recognize how AAA applies or doesn’t apply to S corporations; learn to apply the complex basis ordering rules and special elections that can have a big tax result; discuss loss limitation rules in depth; when you can have a taxable dividend in an S corporation; understand distributions of cash and property; understand the post-termination transition rules, and temporary post-termination rules for eligible corporations, which will be important for S corps returning to C corps  LLCs and partnerships: Learn the detailed rules of §704 for preventing the shifting of tax consequences among partners or members; learn to calculate basis under §704 & for “at-risk” under §465; recognize how recourse, nonrecourse, and qualified nonrecourse debt can create significantly different tax results; learn the difference between basis and “at-risk basis”; review §754 step-up in basis rules; the economic effect equivalence test or “dumb-but-lucky” rule; learn to apply the complex rules of distribution of cash vs. property, and the basis treatment of charitable contributions and foreign taxes paid 

The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models

Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application 

Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.

What are the three types of misconceptions of communication? What are the different types of personality styles in the workplace? Recognize how to communicate with the different types of personality styles effectively Key takeaways

Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence

Frequently asked questions about income tax and sales tax nexus New developments  Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources

Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations

The types of findings reported in Yellow Book and single audits The requirements for reporting findings under the 2024 Yellow Book revision and the 2024 revision to the Uniform Guidance How to really think through the elements of a finding to assist report users

New Clean Vehicles (CV) and the Clean Vehicle Credit What the CV seller must provide to the buyer Credit for previously owned CVs Energy efficient home improvement credit Increase in age for required beginning date for RMDs Reduction in excise tax on RMD failures Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62 and 63 Withdrawals for certain emergency expenses Qualifying longevity annuity contracts (QLACs) One-time election for qualified charitable distribution (QCD) to split-interest entity; increase in QCD limitation

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