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.

Discuss the most recent individual and business income tax legislation passed to date Walk through major tax changes to corporations, partnerships and/or individuals and any changes to the income tax forms and other related schedules Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, retirement plans, fringe benefits and entertainment expenses Brush up on the individual and business income tax rates (e.g., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Discuss other individual income tax topics and changes to filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income and income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Review other important IRS audit areas such as basis and at-risk limitations for S shareholders and partners, passive activity losses and real estate professionals and self-employment taxes

The major topics that will be covered in this course include:Technology Hot Topics for Audits.Accounting Standard UpdatesProjects identified by the FASB's Invitation to Comment: Agenda Consultation.Year 2 considerations for leases including modification accounting.The impact of the changes to auditing group auditsThe status of the AICPA's quality management project management.The current work of the ASB. 

Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system

The major topics that will be covered in this course include:Accounting Standards Updates (ASUs) that are most likely to impact small businesses.ASUs initiated by the Private Company Council (PCC).Alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs.Audit standards that small business auditors will need to implement.

Research Analysis Interviewing Documenting  Reporting Results

Performance audit standards Performance audit types Performance audit objectives

The AICPA Code of Professional Conduct and its interpretations New developments in regulation at the national and state level Best practices, case studies, and disciplinary actions

Data analytics Key fraud risk management guidance documents  Data analytics frameworks  Leading techniques and innovations for preventing and detecting fraud

The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs  with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality 

How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary

Tools for FSA The 3 P's. The QST trifecta The integrated planning model Performance based management The value chain The balanced scorecard  

Overcoming the Common Obstacles to Public Speaking Fear of rejection/ failure and how to overcome From Unconscious Incompetence to Unconscious Competence Toastmasters and practicing by video Act “As If,” Do One Breath Technique to be more relaxed Creating the Content of the Talk What are the concerns of your audience? Talks consist of a title, an introduction, an opening, a body of content, a conclusion and a closing How to Deliver a Talk Effectively The clothes you wear and how you look matter Charisma = energy Smile and act enthusiastic Use self deprecating humor Making the Talk Entertaining Vary the speed of your delivery The Power of stories Memorization and Practice Key word system and note cards Practice thru video or get feedback through others Creating Stories that Rock

Recent legislative developments, cases and rulings impacting various business entity taxpayers Review of Inflation Reduction Act provisions impacting small businesses Business income, deductions and credits Section 174: Research and Experimentation Deduction update Form 1099-K reporting Depreciation update: Section 179 and 168(k) S Corporation and partnership update, including Schedule K-1 

"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

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

Discussion of financial reporting risks increased by the current economic environment, including increased uncertainty related to critical financial statement amounts and significant disclosures Executive summary of recent Accounting Standards Updates  Overview of fair value disclosure requirements and implementation issues Discussion of issues related to donor-restricted endowment funds Classification of net assets and reclassifications Endowments, including accounting, disclosures and UPMIFA Noncascontributions Contributions received and receivable Expense recognition issues Reporting expenses by function and nature Other relevant matters unique to the nonprofit environment

The major topics covered in this course include:The authority of the IRS in assessing tax penalties.The types of penalties that can be removed.The process the IRS uses to evaluate penalty abatements.How to request penalty abatements.Best practices in asking for penalty abatement, including using appeals.

What is emotional intelligence? Benefits of emotional intelligence Steps to increase your emotional intelligence Emotional intelligence in decision-making Self-awareness Skills to get ahead Relationship management

Ethical frameworks Threats and safeguards to objectivity and independence