CPE Catalog & Events

What is a merge query? What are the data requirements for a merge query? What are the types of joins for a merge query? Hands-on examples: creating merge queries, creating a full anti-join using an append query, grouping queries

Workflow of the data transformation for a general ledger with sub-accounts Loading a query Loading options for a query Changing the load destination of a query Hands-on examples: flattening a general ledger with sub-accounts; making a connection to the data source; reviewing and documenting the steps created by Power Query

Removing unwanted characters from a data set All data appears in one column Two categories appear in one column Extracting useful information from inconsistent data (Text Analytics) Have a sub-header that is in a row and should be in a column Hands-on examples

Data before and after transformation: unpivoting, pivoting, split to column by delimiter (by columns or rows) Filtering and grouping Fuzzy matching Hands-on examples

Objective of financial reporting Inter-relationships of financial statements and disclosures Accounting changes Financial statement preparation and review process Best practices for financial statement preparation and review

The key presentation requirements with respect to an entity’s financial statements ASC topics related to presentation requirements, with a focus on ASC Topic 205, ASC Topic 210, ASC Topic 220, ASC Topic 225, ASC Topic 230, ASC Topic 235, and ASC Topic 250 Considerations around changes in accounting principles

Create clear and concise email communication and utilize protocols that support and enhance your professionalism Best practices for excellent email etiquette Types of subject lines to avoid Subject line structure for maximum impact Creating effective greetings and sign offs When and how to use cc/bcc fields to avoid conflict and enhance connection Elevated “out of office reply” messages How to best convey the proper tone Avoiding common pitfalls How to handle misunderstandings and mishaps Examination of when to use text, instant messaging, or phone call instead of email Synthesizing ideas and using efficient methods of writing Creating concise email strings

Defining progressive discipline, including typical steps in any progressive discipline process The importance of a fair disciplinary process When and how progressive discipline should be used, including using progressive discipline in the lead-up to termination Documentation best practices Limitations on at-will employment, including contracts and laws regarding discrimination and retaliation Avoiding key risks in the termination process Best practices for legally compliant termination procedures

Project management is a way of thinking and managing Identifying projects, needs, objectives, and deliverables Project feasibility evaluation Life cycle of a project What causes projects to fail Establishing the project scope and preventing “project creep” Defining and managing stakeholders Organizational politics and conflict management Establishing the detailed schedule Introduction to project management software

Contrasting project management with operations management Reviewing organizational culture and how it applies to project management The various types of project management including Agile, Scrum, Waterfall, Critical path, and others Looking at risk management software and its application in different types of project management Managing and leading project management stakeholders

How experienced speakers manage presentation anxiety The elements of effective persuasion The three styles of speech Strategies to improve speech pace The importance of volume when presenting The art of the pause Methods for using visual aids Best practices for preparing for a presentation Components of an effective presentation

General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home

AICPA’s Engagement Quality Initiative When peer reviews are required and how they work Recent deficiencies noted by peer reviewers in audit, review and compilation engagements System of Quality Control required by the Auditing Standards Board (ASB) Changes to the system of Quality Control proposed by the ASB

Review of case studies, including the SEC X account hack, the Starfish Transportation Inc. fraud, and Morgan Stanley block trading leak Overview of red flags signalling fraud, such as unusual trading patterns and inconsistent financial documentation Recommended preventative measures, including increased whistleblower protections and regular compliance training

Discussion of the importance of financial education for the next generation Understanding a client’s financial values Determining a client’s financial literacy Helping clients develop a teaching roadmap Using knowledge to protect against entitlement Developing a knowledge base for the information, including a full list of recommended books on the topic and games for families to play Discussion of specific topics, including tips and tricks related to: Allowances Earning, work, and entrepreneurship Spending, saving, and investing Philanthropy Taxes Credit cards, crypto, and financial fraud

The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales

Rental income and expense calculation and reporting Deciphering Schedule E (Form 1040) Nuances of vacation home rules Passive activity loss rules: foundations and implications Active vs. material participation in rental activities Tax reporting: how to group passive activities Limitations on passive losses: at-risk rules and deductions Classifying rental real estate activities Navigating exceptions in rental real estate taxation

Final Rule - Employee or Independent Contractor Classification Under the FLSA: the multifactor “economic reality” test; What analysis guides whether a worker is an employee or independent contractor under this final rule? Can a worker voluntarily waive employee status and choose to be classified as an independent contractor? Are any of the economic reality factors adopted in this rule more important than others when evaluating a worker’s employment status? How does the final rule explain “extent to which the work performed is an integral part of the employer’s business?” The Federal Trade Commission’s Decision on Non-compete Agreements: impact on new and existing non-competes; treatment and definitional terms for senior executives; definition of a non-compete clause; definition of a “worker” New Overtime Rules: exemptions from minimum wage and overtime pay requirements for executive, administrative, professional, outside sales, and computer employees; increases in the standard level and the highly compensated employee total annual compensation threshold; new mechanism allowing for the timely and efficient updating of the salary and compensation thresholds

Who are Next Gen employees, and what are their career objectives? How employers can align their values with Next Gen values  Establishing procedures and priorities that allow for attracting the best talent Maintaining relationships with employees to reduce turnover and grow organizations

Section 1402(a)(1) exclusions from the definition of self-employment income Application of the SE tax to members of limited liability companies Taking a self-employed owner's health insurance deductions against self-employment tax How using the S corporation and the MMLLC treated as a partnership can help reduce an individual's exposure to self-employment tax How hiring a spouse and/or child helps reduce self-employment tax Differentiating between income treated as self- employment income and income that is not self-employment income