CPE Catalog & Events

Individual tax developments coming from Congress, the Treasury Department, the courts, and academe. Time-sensitive topics from the past 30 days.

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.

Fund Types Budgetary Accounting Financial Reporting Requirements Single Audit Act Audit Standards and Procedures Best Practices in Governmental Accounting

The major topics that will be covered in this class include:What is ESG?Key Technology, Economic and Social Drivers of ESGESG Current LandscapeIssues in Shifting from Theory to PracticeCOP26: Implications for the Accounting ProfessionTechnical Examples of ESG ReportingThe "S" in ESG: Social MetricsThe "G" in ESG: Governance EthicsESG as an Emerging Client Advisory ServiceESG Reporting Best PracticesESG and BlockchainLeading ESG Reporting FrameworksESG CertificationsProminent ESG Software and CalculatorsESG Starter Strategy

New features and tools in Excel Updates to the Excel Function Library

The major topics covered in this course include:Threats and safeguardsIndependence RulesGAGAS

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

The major topics that will be covered in this class include:Navigating Adobe Acrobat DCCreating PDF files from other applicationsOrganize PDF files and pages within a PDFUsing the annotation tools to review and markup PDF filesPreparing your PDF for printingCreating links to pages, files and websitesSecuring your PDF filesSearching PDF filesCreating fillable formsAdobe Acrobat integration with Office 365

Key tools used by businesses and financial professionals across the globe to measure performance Detailed, real-world examples of businesses utilizing these tools

Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation New Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax Residency and Domicile Selling a principal residence, including tax planning strategies Real Estate professional requirements Virtual currency, including recent developments regarding NFTs Review of pertinent cases and rulings affecting taxpayers Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas

The major topics covered in this course include:Excel shortcuts and time saversWorking with templates, formats, styles, and themesCustomizing and enhancing ExcelProtecting and securing workbooksFormula building and the Excel function libraryNote: This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.

The major topics that will be covered in this class include:Each element of the risk assessment process:Understanding the client's business and industry in which it operatesInternal controlAssessing the magnitude and likelihood of riskLinking risk assessment to substantive audit procedures

The major topics that will be covered in this class include:Overview of setting up spreadsheets for data analysis and how Excel Tables can helpLearning the importance of Consistent Column CalculationsHow to use Conditional Formatting to highlight important informationHow to leverage Excel Tables by analyzing them in PivotTablesLearning to leverage array formulas

Lifestyle issues: Does the client's lifestyle reflect the level of reported income? Undisclosed income Transfers of cash between multiple bank accounts, related party transactions and mortgage refinancing Owner perks Tax deductions vs. family law deductions Business entity-related issues such as partnerships, S corps and corporations

Judicial tax doctrines such as the fruit of the tree, Arrowsmith and dominion and control Cases relevant to understanding many areas involved in computing income tax liability and practice and procedure Rules of statutory construction and relevance to tax research Importance of significant tax cases to compliance, planning and tax research

Overview of the taxation of corporations and shareholders, including making the S corporation election Built-in Gain Tax Planning Self-employment tax and S corporations Distribution tax planning Planning to minimize the impact of loss limitations Tax planning for years with both distributions and losses Termination Planning Tax planning regarding the transfer of appreciated assets to an S corporation Buying and selling S corporations-tax planning ideas Tax considerations of using the QSUB, Section 338(h)(10), or 336(e) elections Tax Issues to consider at the death of S corporation shareholder Stock redemptions as a tax planning tool Accommodating a "non-qualified" investor Trusts and tax-exempt shareholders The second class of stock risks

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:Best practices for fraud prevention and detection.Common fraud schemes in nonprofit including cash misappropriation; payroll fraud; vendor fraud; falsified billings; improper use of credit cards or purchase cards; the redirection of cash and non-cash contributions; personal use of assets; the redirection of grant benefits; other grant related fraud; travel and expense reporting fraud; and much more!

Cash receipts and disbursements method of accounting, including history Cash method limitations, including tax shelters per IRC Sec. 448(d)(3), 461(i)(3) and 1256(e)(3) Cash method by small businesses, including Revenue Procedures 2001-10 and 2002-28 NAICS codes Accrual of income and expenses, including history Economic Performance and Recurring Item Exception, IRC Sec. 461(h) Deferral of Certain Advance Payments (Revenue Procedure 2004-34) Changes made to the above by the 2018 Tax Cuts and Jobs Act

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