CPE Catalog & Events

What are ethics? Why study ethics? Ethical responsibilities of CPAs Professional code of ethics and conduct AICPA Codification – updated Ethical dilemmas CPA vision Real disciplinary cases to illustrate critical points

SAS 142, Audit Evidence (recently issued) Relevance and reliability of audit evidence Sources of evidence Audit procedures Evaluation of tests of controls Evaluation of sufficiency and appropriateness of evidence

Navigating around worksheets Selecting cells and ranges How to use custom number formatting How to leverage Views How to build better formulas with referenced variables and defined names How to quickly format cells with Cell Styles Proper worksheet structure

Overview of setting up spreadsheets for data analysis and how Excel tables can help Learning the importance of consistent column calculations How to use conditional formatting to highlight important information How to leverage Excel tables by analyzing them in PivotTables Learning to leverage array formulas

Demonstration in Excel: where to locate the data tools of Power Query and Power Pivot Data skills demonstrated: data preparation and data modeling Demonstrations in Power Query – the Extract Transform and Load tool for data preparation of the Power BI ecosystem, including data sources Power Query can connect to; transformations; load options; operations; and sample of use cases Demonstrations in Power Pivot, the data modeling tool of the Power BI ecosystem, including query organization; custom columns; parameters; and database capabilities

Estimated taxes and deadlines Tax due dates for common returns and filings Potential penalties and interest Information return penalties Penalties applicable to pass-through entities Accuracy-related penalties First-time abatement (FTA) FTA eligible returns Reasonable cause Nexus: sales tax vs. income tax Sales tax nexus with state specific examples Remote work and sales tax nexus Income tax nexus with state-specific examples Remote work and income tax nexus Sales factor: throwback rules

FASB Accounting Standards Updates issued in 2020 and 2021 to date Items on which the PCC is consulting  Projects on the FASB’s Technical Agenda

Private company standard setting activities FASB Accounting Standards Updates (ASUs) relevant to smaller businesses Lease accounting implementation guidance ASC 326, Credit Losses Accounting for income taxes Accounting for debt instruments

Recently issued FASB Accounting Standards Updates Implementation issues related to ASC Topic 842, Leases

Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done?  Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Effects of the CARES and Tax Relief Acts on trusts: §461(l) Excess Business Loss Limitation, NOL, §163(j) modifications, new employer credits Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms

Recent standard setting and consulting activities at the FASB Proposed updates to income tax accounting and financial statement disclosures Tax basis financial statements Recently issued Statements on Auditing Standards and other audit-related hot topics

Financial statement disclosures for small and medium-sized businesses Balance sheet, income statement, and statement of cash flows presentation and disclosure issues Disclosure examples from all sized entities which you can use to base your disclosures on Developing disclosure issues, including disclosures related to the adoption of Topic 606

Common Excel errors, including formula errors, reference errors, and logic errors Advanced Excel functions and formulas that are crucial for error detection and data analysis Data validation techniques, including setting up data validation rules and using conditional formatting to highlight potential inaccuracies Error tracing and auditing tools, including Trace Precedents, Trace Dependents, and the Error Checking tool

AICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Issues related to compilations and reviews Issues related to employee benefit plans Issues related to Government Auditing Standards/Single Audits Best practices in documentation

Common embezzlement schemes Common financial statement fraud schemes Commonly missed red flags

Recent fraud cases Common fraud schemes perpetrated by those within and outside victim organizations Consider the lessons learned Best practices to further our fraud prevention

Statistics compiled by the ACFE related to fraud Professional responsibilities to identity, respond to and report fraudulent activity The current fraud landscape, including who commits fraud, how and why they commit it and how they are detected

•     Explain the expectation gap with financial statement users regarding the auditor’s responsibilities for preventing and detecting fraud •     Fraud inquiries and engagement team discussion points •     Identifying and responding to fraud risk on an audit •     Testing journal entries and other tests for management override •     Fraud communications

Gaining an understanding of the evolution of internal controls Components of the COSO Internal Control – Integrated Framework Approaches for documenting and evaluating the design and implementation of internal control over financial reporting Critical elements of entity-level and transactional-level controls covering all assertions Internal controls that are responsive to the risk of fraud Case studies related to identifying deficiencies in internal control documentation

An overview of key accounting and reporting topics within U.S. GAAP A discussion of accounting for business combinations, revenue recognition principles, and leasing transfers Goodwill impairment, segment reporting, and how to account for software Requirements related to accounting changes and error corrections