CPE Catalog & Events

Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations

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.

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

The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards

The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business

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.

The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.

Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets

The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story

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

Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!

The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios

The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.

The major topics that will be covered in this course include:Utilizing ChatGPT for IRS Tax Law Research: Principles and PracticesNavigating IRS Databases Using Advanced AI TechniquesUsing IRS Prompt Templates: In-depth Analysis and ApplicationChatGPT in Action: Case Studies and Real-World ScenariosExploring IRS Tax Laws: Strategies, Loopholes, and ComplianceError Prevention and Correction in Tax Law ResearchFuture Trends: AI's Evolving Role in Taxation and Accounting

The major topics that will be covered in this course include:Are Accountants the Conscience of Business?Today’s Ethical Duty of ConfidentialityIESBA NOCLAR PronouncementWhere We Go from Here (No Clarity?)Case Discussion and AnalysisConclusion

Concepts of the Single Audit under the Uniform Guidance Performing the compliance audit of federal awards, including testing auditee compliance and internal control over compliance Auditor reporting responsibilities including the compliance audit reports, the report on the schedule of expenditures of federal awards, and schedule of findings and questioned costs Requirements for the schedule of expenditures of federal awards, known as the SEFA Update on the OMB Compliance Supplement

Recently issued but newly implemented Accounting Standards Updates (ASUs), the PCC Update, and items on the FASB’s Technical Agenda New ASUs covering common control leases, crypto assets (e.g., cryptocurrency), and income tax disclosures Leases – Topic 842 Recently issued SASs and other AICPA activity through SAS No. 149 Detailed review of SAS No. 145 Other important A&A practice matters

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

The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.

Trust obstacles and pitfalls Revoking irrevocable trusts Trust protectors Succession planning, retirement planning and estate planning through trusts Basic issues related to special needs and Medi-Cal planning General Outline of planning with GRATs, QPRTs, IDGTs, etc. Planning with A-B and A-B-C (QTIP) trusts Asset protection through domestic and foreign trusts