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

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

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

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

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

Create an equipment/technology checklist before each meeting Structure your environment for maximum effect Manage and mitigate distractions Handle and respond to technology issues Present yourself with authority Prepare to achieve the best outcomes Establish an authentic and accessible professional presence Navigate a group meeting as well as one on one discussions Master audio only meetings and discussions

The Yellow Book performance and reporting requirements related to internal control deficiencies Evaluating whether an internal control deficiency should be reported as a significant deficiency or a material weakness How the auditor develops the criteria, condition, cause, and effect elements of a Yellow Book finding

Key principles of Revenue Recognition Performance obligations in the Contract Noncash considerations Presentation of sales taxes Impairment reversal of capitalized contract costs Interim disclosures

Topic 606’s five-step revenue recognition model Determining whether to recognize revenue over time or at a point in time under Topic 606 Other unique considerations in applying the five-step model for entities currently using SOP 81-1 Lessons learned and best practices from entities already adopting Topic 606

Documentation as a means of audit quality Responsibilities of the workpaper reviewer Important tips for providing reviews notes that will promote an effective and efficient financial statement audit Appropriate review considerations at various phases of the engagement, including before and after audit report date and report release

Was COVID-19 a “black swan” or a “gray rhino”? Monitor centrally but control decentrally Establish specific plan for risk management Risk recognition Risk evaluation Risk mitigation

Revised format of audit opinion under SAS 134 Additional responsibilities of both management and the auditors under SAS 134 Additional requirements related to SASs 135-140 Qualified auditor reports, their wording, and when the auditor would issue one of them Circumstances requiring the addition of Emphasis of Matter and Other Matter paragraphs to the standard unqualified audit report

The overall purpose of the Form 8-K Triggering events for filing the Form 8-K Filing deadline for the Form 8-K

The overall importance of the rules and regulations with respect to the Management's Discussion and Analysis (MD&A) section of an entity's consolidated financial statements filed with the U.S. Securities and Exchange Commission (SEC) An overview of Non-GAAP Financial Measures