CPE Catalog & Events

Accounting Finance Skills

Common tax deadlines and penalties Employee Retention Credit – new developments Beneficial ownership information reporting Bonus depreciation changes Form 1099 reporting and changes Online accounts and IP PINs Virtual currency updates Green energy credit compliance

Economic update Leadership and management changes as a result of the pandemic Managing for productivity Metrics and benchmarking Social media's place in our organizations

What are ethics? Why study ethics? Ethical responsibilities of CPAs Professional code of ethics and conduct AICPA Codification – updated Ethical dilemmas CPA vision Real disciplinary cases to illustrate critical points

Business Management Organization  

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.

Understanding the workbook and worksheet environment Obtaining and utilizing data Editing and formatting The “Insert” Menu The “Page Layout” Menu The “View” Menu Selecting and using formulas Shortcuts and tricks

The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes

Accounting Internal Controls Internal Audit Standards

Benefits and pitfalls of artificial intelligence in the accounting profession Selecting and utilizing artificial intelligence resources Applying professional skepticism to results Maintaining independence while utilizing artificial intelligence Upholding client confidentiality Data security and retention Citation of sources and related reporting considerations

AICPA Code of Professional Conduct Accounting & Auditing Yellowbook

The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.

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

The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment

How the effect of a misstatement due to error effects the scope of our audit vs a misstatement due to fraud Inquires of management …….. and others The audit planning process; when we start and when we stop The importance of brainstorming and what two things should a talk about Revisions of our risk assessment Determining materiality

Principles of Visual Design for Dashboards and Reports Chart Design for Rapid Understanding Table Design for Efficiency Effective Use of Commentary Strategic Layout Techniques Trend Analysis Methods Developing Organizational Design Standards Excel Application Techniques Critical Review Skills Best Practices for Data Presentation

A methodical approach to business and strategic planning Overview of The Balanced Scorecard approach to creating key performance metrics Common metrics for analyzing financial statements and trends Accounting and finance role in Enterprise-wide Risk Management (ERM)

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

Detailed coverage of any new legislation affecting basis computations and distributions and changes to the schedule K-1s (including the NEW Form 7203 – S Corporation Shareholder Stock and Debt Basis Limitations) Line-by-line analysis of the Schedule K-1s to determine how the items affect a S shareholder’s stock and debt basis and a partner/member’s outside basis and where the items get reported on Federal individual income tax return The three loss and deduction limitations on the owner’s individual income tax return (i.e. basis, at-risk and other Form 1040 limitations) How cash or non-cash distributions affect the basis calculations and whether or not they are taxable to the owners Compare the tax treatment of the sale of a shareholder’s stock in a S corporation and a partner’s interest in a partnership What constitutes debt basis for a S corporation shareholder under the final regulations The tax ramifications of repaying loans to S corporation shareholders and on open account debt How recourse and non-recourse debt effect a partner or member’s basis calculations and amount at-risk

The major topics that will be covered in this course include:The Not-for-Profit Advisory Committee (NAC).Accounting Standards Updates (ASUs).Year 2 considerations of the leases standard.Common nonprofit deficiencies identified in peer review.What's going on at the AICPA.