CPE Catalog & Events

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 class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage  data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Yellowbook Accounting and Auditing Nonprofit

Accounting Finance Auditing

"Tales from the Front" - practice issues CPAs are dealing with in these extraordinary times Review of AICPA Code of Professional Conduct Review of IRS Circular 230 Review of client tax return disclosure rules (Sec. 6103) Crisis impacts on engagement letters, contingent fees, independence, consulting services, attest and non-attest services, billing, and collections

The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.

Enhancing communication and collaboration: Shared Mailboxes, Groups, and Places Optimizing task and project management: Planner, Lists, and To Do Streamlining training and workflow automation: Stream, Viva Learning, Forms, Bookings, and Approvals

Historical context of U.S. taxation Industrial hemp vs. marijuana Income definitions under I.R.C. §61 Tax code restrictions: §280E and §471 State-specific marijuana laws Cash management in cannabis businesses Federal court case analysis

Sample Schedule M calculations Sample work papers for deferred tax computations Comprehensive two-year example and computations Review and analysis of recurring temporary differences Identification of the sources to compute cumulative temporary differences Sample workpapers for analysis of tax positions

Types of Corporate Fraud Introduction to fraud risk Fraud risk prevention programs Fraud investigations

AICPA Code of Professional Conduct Ethics requirements for CPA firms

Taxpayers' rights and protections Professional oversight in tax practice Navigating Circular 230 complexities Ethical practice before the IRS Preparer roles and responsibilities Compliance with rules on written advice Ensuring client confidentiality Upholding best practices in tax preparation

The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits

Review of select AICPA Technical Questions and Answers Upcoming changes to accounting for goodwill, leasing and business combinations Compilation and review standards and interpretations (SSARS) Auditing standards and interpretations (SAS & SSAE)

Special and Targeted allocations Proper calculation of outside and inside tax basis Tax consequences of distributions including the impact of hot assets Transfer of partnership interests Issuance of partnership interests to service partners

Not-for-profit GAAP Expense allocation methodologies Risk management Accounting errors

The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.

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

Why do some choose to deceive, cheat and steal Can accounting scandals be prevented A brief history of accounting scandals What to look for What should ethical professionals like you do

Utilizing Power Query to access data from the web, spreadsheets, folders, and databases Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel Producing various reporting documents from data delivered from Power Query