CPE Catalog
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
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?
Client Advisory Services (CAS): A Guide to the Variety of Offerings Professionals Can Provide
-
Online
2.00 Credits
Member Price: $99
Details on CAS: new services or rebranding? Review the value of timely accurate automated accounting Review the three levels of service Discuss technology options Assess your client base for who would benefit most from CAS Staffing requirements for CAS The value of servicing a niche
Preparation and Compilation Engagements Under the SSARS
-
Online
4.00 Credits
Member Price: $159
Relevant sections of SSARS No. 21, Clarification and Recodification 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. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements
Excel Budgeting Ideas
-
Online
2.00 Credits
Member Price: $99
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
Lessons Learned From Recent Accounting Malpractice Actions
-
Online
2.00 Credits
Member Price: $99
Common instances of accounting malpractice Current claim trends Frequent defenses to claims Statute of limitations Damages Claims by practice area
Preparing Not-for-Profit Financial Statements
-
Online
8.00 Credits
Member Price: $279
Key requirements, options, and disclosures related to each of the basic financial statements The reporting of functional and natural expense information Requirements related to providing liquidity and availability of financial assets information Core not-for-profit accounting requirements related to conditional and unconditional contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more
Understanding How the IRS Rewards Whistleblowers
-
Online
2.00 Credits
Member Price: $99
Overview of the law that authorizes the IRS to reward whistleblowers who submit information leading to recovery Review of the whistleblower claim process Criteria for eligible claims Case studies of significant claim recoveries paid by the IRS to whistleblowers Issues underlying whether a practitioner should ever act as the whistleblower Addressing delays inherent in the whistleblower claim process The structure and role of the Whistleblower Office Best practices for the submission of a good whistleblower claim Working with other governmental divisions in processing whistleblower claims A brief overview of other, non-IRS whistleblower claims
Managing Up the Ladder
-
Online
2.00 Credits
Member Price: $99
Influence, persuasion, and power Navigating without position power
Tax Research - Intermediate Concepts
-
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 authorities Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers
-
Online
4.00 Credits
Member Price: $159
Latest state of the economy Expense control that works Understanding our changing workforce and working environment Financial risk analysis Enterprise risk management Improving bank relationships
Getting Ahead: The Art of Marketing for CPAs
-
Online
2.00 Credits
Member Price: $99
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
Key Current Financial and Economic Issues Facing the Financial Executive
-
Online
8.00 Credits
Member Price: $279
Taking a strategic perspective relative to risk management and crisis management Reviewing the impact uncertainty and risk at the operational level relative to short- and intermediate-term decision making Determining the safety and soundness of the financial plans for your organization in an uncertain economic climate specifically as it relates to capital adequacy and strategic direction Managing the debt and equity mix for your organization in a rapidly changing economic landscape Determining the impact that competing in a global marketplace has on an organization and how to take steps to become more competitive globally Evaluating the impact of federal, state, and municipal deficits and unfunded mandates as it relates to tax planning Evaluating retirement programs with Social Security funding for your employees Determining the safety and soundness of your credit and collections processes and selection of customers in an uncertain environment Influencing growth through acquisition of distressed organizations The economic way ahead for the CFO/Controller
Guide to the AICPA Quality Management Standards
-
Online
2.00 Credits
Member Price: $99
Quality management standards SAS 146, SSARS No. 26, and SSAE 23 Risk assessment, which forms the basis of the SQM Monitoring and evaluating the SQM
Leveraging AI for Data Analytics in Accounting
-
Online
2.00 Credits
Member Price: $99
Transforming data analytics with AI Understanding the impact of AI on data analytics processes How AI enhances data accuracy, efficiency, and decision-making AI tools and techniques for data analysis Overview of AI-powered data analytics tools Techniques for improving data analysis accuracy and efficiency with AI Integrating AI into existing data analytics workflows Case studies on AI implementations for data analytics Success stories of AI-driven data analytics in accounting Challenges and lessons learned from AI integration Measuring the ROI of AI in data analytics Developing AI-powered data analytics skills Hands-on lab sessions using AI tools (e.g., ChatGPT, Excel) Practical exercises in filtering, sorting, summarizing, and visualizing data Applying AI insights to optimize data-driven decision making in accounting
Unconscious Bias in the Workplace
-
Online
2.00 Credits
Member Price: $99
Introduction to Unconscious Bias The “5 Things To Know” Framework Schemas and Mental Shortcuts Types of Unconscious Bias Bias in Action: Workplace Impacts Microaggressions and Language The Four Stages of Competence Strategies for Change Tools and Resources
Generative AI and Cybersecurity: Opportunities and Threats
-
Online
2.00 Credits
Member Price: $119
Generative AI applications in cybersecurity (e.g., threat detection, automation) AI-enabled cyber threats, including phishing, deepfakes, and malware Real-world incidents involving AI-related cybersecurity challenges Proactive strategies for leveraging generative AI in cybersecurity Regulatory and ethical implications of generative AI in financial cybersecurity
A Guide to Nonqualified Deferred Compensation
-
Online
2.00 Credits
Member Price: $99
The basics of nonqualified deferred compensation (NQDC) NQDC compliance Taxation of NQDC plans Types of NQDC plans Financing/funding NQDC plans Planning strategies
Going Out on Your Own: Entity Types and Accounting Methods
-
Online
2.00 Credits
Member Price: $99
Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations – S vs. C Double taxation
Managing Millennials
-
Online
2.00 Credits
Member Price: $99
Understanding who millennials are and what distinguishes them from other sectors of the workforce Changes millennials seek in the workplace Suggestions on engaging and developing millennials Best practices by organizations who have successfully integrated millennials Expectations as to learning, development and training Work environments and schedules School to work transitions Views on salary, benefits and corporate ethics Whether millennials’ expectations are significantly different from any other generation Strengths millennials offer which set them apart from others Common myths pertaining to millennials Definitions of success