CPE Catalog & Events

Basis and at-risk basis How to calculate the amount of annual at-risk basis Forms 6198 and 7203 When activities may be aggregated for at-risk purposes Qualified nonrecourse financing

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.

Understanding Fraud Psychology and Motivation of Fraudsters Detection and Prevention Strategies Real World Case Studies Effective Fraud Management

Recently issued FASB Accounting Standards Updates, the PCC Update, and items on the FASB’s Technical Agenda Leases – Topic 842 Review of SAS No. 142 – Audit Evidence Recently issued SASs and other AICPA activity Detailed review of SAS No. 145 Other important A&A practice matters

Education that is also transformation Key Learning Objectives A word collage to clarify your starting point with debt Practical and emotional aspects of debt  Your current story about debt 3 myths and 3 truths about debt that will help you start over A new philosophy on Doing Debt Differently Key concepts that lead to success in becoming debt free A petition for debt freedom Facing your debt problem and creating relief The six ways to find relief – awareness, letting go, identifying debt patterns, creating your new relationship, the alchemy process, inspired actions Creating your personal plan for debt freedom Review and tips for continued success The secret to success is support How to build your success team

The major topics covered in this course include:Overview of a risk-based audit processHow the individual elements of the audit risk formula interrelateEmphasis on overall risk, fraud risk, and control riskLinking the assessed risk of material misstatement to the detailed audit planDocumenting risk assessment conclusions and responses

Major topics covered in this course include:How government investigations for white-collar crimes beginHow investigators and prosecutors build cases against business leadersDifferences between witnesses, subjects, and targetsCivil versus criminal allegations and proceedingsCollateral consequences of a criminal chargeUnderstanding the role of defense attorneysDifferentiate between challenges in business and allegations of wrongdoingInfluence on financial loss amounts and sentencingLowering risk levels for government investigations or allegations of white-collar crime

How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection

What is money? What are digital assets? Understanding the what, why, and how of cryptocurrencies Understanding the what, why, and how of blockchain NFT’s (Non-Fungible Tokens), their role and impact Explaining the crypto language

ESG Sustainaibility

The major topics covered in this class include:Defining Federal Income TaxesComputing federal income tax liabilityCalculating adjusted gross incomeDefining Qualifying ChildDetermining filing statusCalculating the Kiddie TaxStandard deductionTax Rates for ordinary income, capital gains, and qualified dividend incomeCash v. Accrual MethodFiling deadlines and obtaining extensions

Business Management Organization

The major topics covered in this class include:Latest developments relevant to Yellow Book auditsBe prepared to avoid the most commonly misapplied concepts on audits performed in conformance with Government Audit Standards

Tolerations Goal setting Gratitude Setting a 'tone' of success Priorities as a means to mindful living Reflection & Planning as tools to generate clarity & intention Connecting with the wise resource often overlooked in business models  

The major topics covered in this course include:Overview of the Tax Division's role and responsibilitiesCivil litigation and appellate cases in the Tax DivisionCriminal investigations and prosecutions of tax law violationsProtecting the public fisc through affirmative civil litigationEncouraging voluntary compliance with tax lawsEnsuring fair and uniform enforcement of tax lawsCollaboration with other federal agencies in tax law enforcement

Corporate Culture Strategic Planning Leadership Staff Development  

GAGAS Yellow Book Independence

Compensated Absences Error Corrections Accounting Changes

The major topics that will be covered in this class include:Overview of the "core" Microsoft 365 apps and how they integrate with each otherReview of the key deployment decisions to be madeIdentifying the important settings to establish in the key appsEstablishing organizational policies for using Microsoft 365Developing a plan to educate your team members on how to integrate the apps into their business processesUnderstanding the role of the Admin app and system administrationPlanning for Microsoft Copilot for 365 AI capabilities

IRC 1202-The benefit of the exclusion IRC 1202-The requirements that must be met IRC 1202-Limitation on the amount of the exclusion Comparison of the IRC 1202 exclusion to making S corporation election IRC 1045-The benefit of the deferral IRC 1045-The requirements that must be met The basics of Employee Stock Ownership Plans (ESOP) IRC 1042-The benefit of the deferral IRC 1042-The requirements that must be met