CPE Catalog
Excel: Mastering PivotTables
-
Online
2.00 Credits
Member Price: $99
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Implementing Subscription Pricing to Your Practice
-
Online
2.00 Credits
Member Price: $119
The basics of subscription pricing Pricing strategies, with an eye toward a modern model for your business How to implement subscription pricing The need to look back and assess the financial impact of the implementation How to manage customer retention The optimum subscription pricing for your business
Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Taxation of Tips and Overtime Under OBBBA
-
Online
2.00 Credits
Member Price: $119
$12,500 deduction per individual for qualified overtime pay Payment of overtime under the Fair Labor Standards Act (FLSA) Calculating the “premium portion” of the extra half-time pay Social Security and Medicare withholding Employer furnishing the record of qualified overtime compensation to employees Definition of a qualified tip IRS list of traditionally-tipped occupations $25,000 deduction for reported tips The transition rule allowing employers to indicate the approximate amount designated as tips or overtime State tax issues relating to tips and overtime Changes in the W-2 reflecting new employer reporting responsibilities
Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $119
Establishing and administering a Trump Account Who can make contributions to a Trump Account Limits on contributions to a Trump Account Employer contributions to a Trump Account Participation in the pilot program What a Trump Account can invest in Basis tracking for after-tax contributions Taxation of distributions from a Trump Account Rolling a Trump Account into another account The potential advantages and disadvantages of having a Trump Account Opting out of a Trump Account Issues impacting a Trump Account, such as distribution, when the beneficiary turns 18
The One Big Beautiful Bill Act (OBBBA): What You Need To Know
-
Online
4.00 Credits
Member Price: $199
The $6,000 senior deduction The QBI deduction Changes in the estate tax Wagering losses The SALT cap Tips, overtime, and car loan interest 1099 changes Trump Accounts Investments in students and education Bonus and Section 179 changes, including depreciation for qualified production property Full expensing of domestic research and experimental expenditures Changes in the deduction of business interest and business losses Renewal of Opportunity Zones Individual and corporate charitable contribution changes Expansion of Section 1202 stock Termination of credits for environmentally clean autos and expenditures Many other individual and business income tax changes contained in the OBBBA
Reasonable Suspicion
-
Online
1.00 Credits
Member Price: $59
The psychosocial, physiological, and behavioral aspects of drug and alcohol abuse in the workplace The impact of drug and alcohol abuse on workplace safety The possible connection between performance issues and drug or alcohol abuse The role of documentation in reasonable suspicion testing Confidentiality concerns in the testing process
Managing Up the Ladder
-
Online
2.00 Credits
Member Price: $99
Influence, persuasion, and power Navigating without position power
Management Fundamentals
-
Online
4.00 Credits
Member Price: $159
What it takes to be effective as a manager Exploring the challenges that get in the way Looking at the driving forces that have evolved how managers engage with employees today Motivating employees of multi-generations Twelve practices that can be adopted to influence employees to become more engaged Identifying what it takes to develop employees Delegation and accountability
Where To Live in Retirement
-
Online
2.00 Credits
Member Price: $119
Does continuing to live at the current location meet retirement goals and lifestyle? Are there family concerns such as an elderly parent that prevent moving away from the current location? Is the current location affordable when income from a salary ceases? What health concerns are there that would limit the ability to move to another location? Is an assisted living facility something that should be considered now or in the future and is a suitable one available? What happens if a person is disabled while retired? Are there state and local tax considerations that would encourage staying in place or moving? Are there climate and weather concerns that would encourage a person to stay in place or move to a more desirable location? Should a retiree downsize?
The Accountant as the Expert Witness
-
Online
2.00 Credits
Member Price: $99
Becoming qualified as an expert witness Best practices for testifying at trial Understanding the different roles accountants can play in litigation Working with attorneys to prepare and present a case at trial The role of experts in commercial versus personal injury litigation Confidentiality orders Compensation for expert witnesses Preparing for and attending depositions Daubert challenges to experts Expert reports The role of experts in antitrust, securities litigation, and professional liability cases Credibility as a witness
Successfully Completing an Estate Tax Return -- Form 706
-
Online
2.00 Credits
Member Price: $99
Changes to the IRS Form 706 How to successfully navigate the form The ins and outs of the “portability” rules, including how the rules actually work using common examples Income tax consequences How to avoid malpractice traps Overlooked GST issues
Tax Research
-
Online
2.00 Credits
Member Price: $99
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Online
3.00 Credits
Member Price: $149
How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation
Accountability and Action
-
Online
4.00 Credits
Member Price: $159
Defining three critical elements: responsibility, empowerment and accountability, and how they work together to create results Designing and using clear agreements that provide clarity Skills for holding yourself and others accountable for results, no matter what Knowing where you are in the accountability game... what you do/don’t do well
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
Purchase and Sale of a Residence: Critical Tax Issues
-
Online
2.00 Credits
Member Price: $99
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
Ethical Considerations for the CPA
-
Online
4.00 Credits
Member Price: $159
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Managing People Through Motivation
-
Online
4.00 Credits
Member Price: $159
What it means to engage people; discuss the meaning of motivation by getting to the core of what impacts your employees’ productivity Get your employees charged; find out what makes them tick through examining and understanding some of the classics in motivational theory Learn how to drill down to what truly motivates your employees Using the C.A.R.E. model to improve employee motivation through case studies
Home Office Rules
-
Online
2.00 Credits
Member Price: $99
Calculating the home office deduction Actual expense method Simplified expense method Definition of a home for purposes of the home office deduction Whether working-from-home employees can claim a home office deduction What is a “separate, identifiable space?” The “regularly and exclusively used” rule Defining a “principal place of business” Meeting clients, patients, and customers More than one trade or business Special rules that apply to daycare providers Separate, free-standing structures Depreciating the home