CPE Catalog & Events

The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful.

What Form 1099-K is designed to do Filing thresholds for the Form 1099-K Who sends and who receives Form 1099-K Form 1099-K reporting thresholds Personal payments from family and friends Personal items sold at a gain or a loss Reporting provisions for gig workers, partnerships, and corporations Mistaken receipt of a Form 1099-K What to do when the Form 1099-K has a mistake Situations when the gross amount on a Form 1099-K must be shared How to handle the receipt of multiple Forms 1099-K

Understanding what the metaverse is and what it is not How to access the metaverse Why accounting and other professionals should use the metaverse Where accountants can find their space in the metaverse How the metaverse is changing the way we work Ownership opportunities in the metaverse Work and taxation in the metaverse

The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models

Introduction to the Fiduciary Entity and Basic Fiduciary Entity Flowchart Authorities & Disciplines in Fiduciary Accounting & Taxation Fiduciary Tax Rates and Brackets Introduction to Subchapter J 5 Basic Rules & Concept of Fiduciary Taxation and Steps to Calculating the Income Taxation of Trusts & Estates Use of a Tax Spreadsheet

The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.

Review real-world examples of fraud schemes perpetrated against governments and not-for-profits, including misappropriations of cash, grant frauds, vendor frauds, inventory thefts, and payroll frauds Understand and recognize fraud risk and fraud indicators Consider types of fraud prevention programs

Rental activities and passive activities Material participation Real estate professional status Active participation status Depreciation recapture – Sections 1245, 1250, and 291 Vacation homes rented out QBI deduction and rental properties Section 1237 safe harbor for divided parcel sales Practitioner considerations

Federal and California statutory and regulatory standards governing tax preparers: Preparer penalty provisions, Circular 230 and; AICPA Statements on Standards for Tax Services Tax shelter and reportable transaction issues in depth Attorney-client, Sec. 7525 and work product privilege issues and Kovel arrangements

How is fraud detected The role of external auditors in finding fraud Revenue recognition issues Corrupt management Data mining Physical and biometric controls

The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives 

Overview of the four loss limitation rules and how the PAL rules interact with the other limitations Definition of a PAL including a detailed review of the 7 determining factors contained in the Treasury Regulations with a review of several recent court decisions that interpret this regulation Impact of PAL rules on real estate ownership Learn the six Nonshelterable Passive Activity (NOPA) rules that act as anti-abuse rules to the PAL rules Discuss how the PAL rules impact tax credits Discuss tax elections and planning techniques associated with PALs

The key requirements and responsibilities related to the schedule of expenditures of federal awards and the determination of major programs The processes of determining the direct and material compliance requirements, obtaining an understanding of and testing the related internal controls, and performing compliance testing The development and reporting of findings in the schedule of findings and questioned costs Additional performance and reporting responsibilities

The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit

How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment

Making an S corporation election and late filing relief Disproportionate distributions Selling S corporation shares Redemption rules

Review the Basic Concept of Fiduciary Duty Review the Basic Concept of Fiduciary Accounting Use of a Diagram to Distinguish Income and Principal Calculating Fiduciary Accounting Income Requirements of a Simple Trust Problem Example Spreadsheets Reflecting Fiduciary Accounting and Taxation of Simple Trusts as well as how Depreciation is Handled by a Fiduciary Entity Problem Examples Reflecting a Completed Form 1041 using Spreadsheet Calculations for Fiduciary Accounting and Taxation of Simple Trusts

The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure

The major topics covered in this class include:A step-by-step process from the initial client phone call to you writing a report of your findings for any civil or criminal actions that may be pursuedHow to advise your client in approaching an allegation of embezzlementWhat pitfalls may arise in finding the truthThe best practices to ensure that the evidence is preserved properly for potential civil or criminal actions

The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators