CPE Catalog & Events

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New format of the auditor’s opinion, including the inclusion of key audit matters Significant unusual transactions Determining materiality Conforming changes to other reports issued under the SAS

An overview of workplace harassment and discrimination laws Clear definitions of unlawful harassment, hostile work environment, discrimination, and protected categories An overview of sexual harassment, workplace retaliation, and both internal and external complaint procedures Real-world examples to help employees understand the differences between unlawful harassment and lawful workplace interactions and assess whether they need to modify their workplace conduct

Comment letter analysis from several Big Four accounting firms Non-GAAP financial measures Comments from the SEC and FASB

What is blockchain technology? How do you buy crypto? How do you store crypto? Use cases of cryptocurrency Blockchain technology  Use cases of cryptocurrency Tax overview How taxes work for cryptocurrency investors How taxes work for cryptocurrency mining Taxation of other transactions Foreign reporting requirements and crypto How to use a tool like CoinTracker to calculate capital gains and losses New developments in the space Tax planning opportunities  Why do accountants need to care?

The three primary organizational cultures The best cultural fit for certain types of businesses How the finance professional affects culture How to choose the culture you want, and how to get it Greatest things that affect the culture of an organization

Treatment of state and local taxes (SALT) Taxation of overtime pay  Treatment of income from tips New deduction for senior citizens Marginal tax rates, personal exemptions, itemized deductions, Child Tax Credit, alternative minimum tax, casualty losses, and other return items Moving expense exclusion Dependent care assistance program and child and dependent care tax credit Home mortgage interest deduction Deduction for new vehicle loan interest Non-itemizer tax deductions Trump accounts/pilot program Estate and gift tax changes Energy deductions and credits Education: expanded use of 529 plans; student loans Many, many other newly enacted individual tax provisions in the far-reaching legislation affecting nearly all taxpayers and their advisors  

Employer treatment of new tips and overtime legislation Qualified business income (QBI) deduction 100% bonus depreciation/Section 179 depreciation Increased dollar limitations for expensing of certain depreciable business assets Qualified production property Full expensing for domestic research and development expenses Opportunity zones Section 1202 - treatment of qualified small business stock Business interest deduction Increased threshold for reporting payments to independent contractors and other payees Extension and enhancement of paid family and medical leave Termination of auto and other energy-related subsidies Excess business losses Foreign tax credit Increased penalties connected to Employee Retention Credits Many, many other newly enacted business tax provisions in the far-reaching legislation affecting nearly all taxpayers and their advisors  

Structure of the ASC codification Content included and not included in the ASC Other information contained in the codification Best practices for performing effective and efficient accounting research

Preliminary analytical procedures as risk assessment procedures Performing final analytical procedures to assess the conclusions reached during the audit and evaluate the overall financial statement presentation. When to use substantive analytical procedures for efficiency and effectiveness Establishing expectations for substantive analytic procedures Setting a threshold for differences Following up on differences from expectations Concluding on substantive analytical procedures

Inventory observation procedures When attendance at the inventory observation is impractical Inventory under the control of a third party Consideration of the risk of fraud in inventory counts Sampling related to inventory observations Considerations related to retail inventories, multiple locations Considerations for inventory observations

Compare and contrast the basis and requirements of preparation, compilation, and review engagements Identifying key reporting elements of compilation and review reports Impact of special purpose accounting frameworks and other special issues

Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22-25 Review of AR-C Section 60 requirements for all SSARS engagements Detailed guidance on performing compilation engagements under AR-C Section 80

Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22-25 Review of AR-C Section 60 requirements for all SSARS engagements Detailed guidance on performing preparation engagements under AR-C Section 70

Demonstration in Power BI Desktop of the following data tools: Power Query, Power Pivot, and Power View Skills demonstrated: DAX, data visualizations including AI visuals, and data storytelling Demonstration of DAX function types: Aggregation, Iterator, CALCULATE, CALCULATE Modifiers, Time Intelligence, Ranking, and Percentages Demonstration of how to curate a visual in PBI Desktop with a variety of formatting tools; visuals for exploratory analysis; and AI visuals for exploratory analysis

Demonstration of publishing from the desktop to the service Demonstration of workspaces – who has access, and what can they do? Demonstration of pinning tiles to a dashboard: quick insights, questions and answers, and what you can pin Demonstration of sharing content: analyze in Excel, apps, and dataflows Demonstration of administrative settings in the service: security, data access, and data quality

Create a new column from existing columns Adding columns is determined by the data type of the column Adding new columns Hands-on examples: column from examples, merging columns, duplicate columns, custom columns, conditional column, index column