CPE Catalog & Events

The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.

Forensic Accounting Accounting Auditing Finance

The major topics that will be covered in this course include:Overview of AI and its evolution in businessDeep dive into generative AI and its applicationsImpact of AI on accounting, tax and finance sectorsFuture trends and opportunities for CPAsPreparing for the AI-driven business environment

Determining when filing a Tax Court case can be a strategic benefit Learn how to file the case Understand the steps and deadlines in the Tax Court process Review the settlement process Know when the case gets to the point where you need help

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

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

Components and principles of internal control Concepts associated with the COSO framework Management responsibilities versus auditor responsibilities Common significant accounting processes Tools and techniques used for internal control documentation

How does the IRC define an installment sale under Section 453? When can a taxpayer utilize the provisions of IRC Section 453? When should a taxpayer utilize the provisions of an installment sale and when should it be avoided How does the issue of a “dealer” vs. a “non-dealer” impact the use of the installment sale method How to report an installment sale when related parties are involved How to calculate an installment sale How has the Tax Cuts and Jobs Act impacted the use of the Installment Sale Method What is a like-kind exchange as defined by IRC Section 1031 When can a taxpayer utilize the provisions of IRC Section 1031 What types of real property are eligible for like-kind exchange treatment and what types are not What is “boot” and how does it impact the like-kind exchange deferral How to calculate a like-kind exchange including any taxable portion How has the Tax Cuts and Jobs Act impacted the use of like-kind exchanges

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

What is “Ethics”? Interaction between Law and Ethics Principles and Best Practices: AICPA Code of Professional Conduct IESBA Code of Ethics for Professional Accountants Case Study: Ardent Harmony Fund v. BDO Trinity

Reasons auditors fail to detect fraud Willful Ignorance SAS No. 82 Additional documentation How and who to talk to Determining the Tone At the Top How to Determining Intent If you expect it, you will see it

Writing Communications

529 to Roth: who, what, when, and how SECURE Act 1.0 and the 10-year rule Roth IRA beneficiary options Where the stretch IRA really ends The new limitations for spouse IRA beneficiaries The new spouse options for spouse beneficiaries New RMD rules for Roth 401(k)s Overriding the 10-year rule for an eligible designated beneficiary How the age of death affects beneficiary options The new early distribution penalty exceptions Rollovers vs. transfers for spouse beneficiaries Qualified charitable distributions (QCDs) for owners and beneficiaries The “at least as rapidly” (ALAR) rule New reduced rate for excess accumulation penalty on RMD failures How to avoid unlimited accrual of the 6% excise tax How to avoid unlimited accrual of the 25% excise tax Clarifying the definition of disability for an exception to the 10% additional tax The new starting ages for RMDs Designated vs. eligible designated beneficiaries and their options Catch-up contributions for ages 50 and over Catch-up contributions for ages 60 to 63 When the 60-day deadline is missed When the one-per-year rollover limit is about to be broken Retaining qualifications for exceptions to the 10% additional tax

Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and using the residual method Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock

The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.

Rules of civil and criminal procedure Applicable standards Testifying basics Cross-examination techniques

The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings

The 3 elements of storytelling    3 real world examples                  10 thoughts for the road   

Fraud risk management Fraud risk assessments Data analytics Fraud risk management tools