CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
2.0 Credits
Member Price: $89
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.
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
TBD
2.0 Credits
Member Price: $89
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
Leases Accounting under Topic 842 - Answers to FAQ After Implementation
-
TBD
2.0 Credits
Member Price: $79
Alternatives to adopting Topic 842 Short-term lease and related-party leasing arrangements Identifying lease agreements under the new rules Proper treatment of lease incentives, leasehold improvements, and lease modifications
FASB Update and Review
-
TBD
2.0 Credits
Member Price: $79
FASB updates that will affect near-term reporting Future topics that may soon be addressed by the FASB
IRS Penalties and Abatements
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
How to Start a CFO Service
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
Preparing to be a Forensic Accountant - Cloud Forensics
-
TBD
1.4 Credits
Member Price: $59
Forensic Accounting Accounting Auditing Finance
Independence Requirements for Auditors
-
TBD
2.0 Credits
Member Price: $79
PEEC Ethics Yellowbook
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
TBD
2.0 Credits
Member Price: $79
Requirements of GASB 96, GASB 94, and GASB 87 Implementation of GASB 96, 94 and 87
The AB5s of Employees and Independent Contractors
-
TBD
2.0 Credits
Member Price: $79
Four ways to classify a worker IRS 20 Factors 20% Section 199A deduction Cost of misclassifying an employee Section 530 relief Game changing impact of the Dynamex case and AB5
Planning in an Uncertain World
-
TBD
2.0 Credits
Member Price: $79
Why great predictions are not intuitive but the result of critical thinking, gathering information and updating predictions when needed How to separate correlation from causation How to recognize and overcome bias Who is Thomas Bayes and why he matters
Financial Statement Analysis
-
TBD
4.0 Credits
Member Price: $129
Purposes of financial statement analysis Trend analysis and vertical & horizontal analysis Simple and multivariate regression; Analysis of metrics Assessment of liquidity, solvency, and profitability Using data visualizations The role of qualitative factors
Year-End Tax Planning: Thinking Outside the Box
-
TBD
4.0 Credits
Member Price: $129
Discuss the most recent tax legislation, rulings and developments Section 163(j) interest expense deduction New 21% corporate tax rate Medicare tax on high income wages and SE income Tax provision and extensions Timing income and deductions Alternative minimum tax (AMT) issues
K2's Ten PDF Tips You Need To Know
-
TBD
1.0 Credits
Member Price: $39
Converting documents to the PDF format Editing PDF documents Securing PDF documents Extracting data from PDFs
K2's What's New With QuickBooks
-
TBD
1.0 Credits
Member Price: $39
Licensing issues Pricing updates New and improved features Transitioning from QuickBooks Desktop to QuickBooks Online
Anti-Bullying and Sensitivity
-
TBD
1.0 Credits
Member Price: $39
Taking credit for someone else’s work. Repeatedly belittling a co-worker. Withholding essential information. Failing to invite someone to an essential meeting. Ignoring a coworker with the intent to harm or control. Engaging in ongoing passive-aggressive behavior in which words and actions appear harmless but have the intent to harm or control. Constant and unfair criticism. Social bantering and teasing. Yelling, shouting and screaming. Insults and behind-the-back put-downs. Hostile glares and other intimidating gestures. Malicious gossiping. Monopolizing supplies and other resources. Aggressive e-mails or notes. Overt threats and aggression or violence Am I the bully?
Ethics for CPAs: The Practical and the Possible
-
TBD
2.0 Credits
Member Price: $79
The AICPA Code of Professional Conduct and its interpretations New developments in regulation at the national and state level Best practices, case studies, and disciplinary actions
Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
TBD
2.0 Credits
Member Price: $79
Financial Statement Preparation Common Mistakes made in Preparing Financial Statements GASB Financial Statement Preparation Standards
Progressive Management Accounting
-
TBD
2.0 Credits
Member Price: $79
A taxonomy of accounting: tax, financial, managerial A spectrum of direct and indirect absorption costing Fact-based Data with Activity Based Costing (ABC ) Why do we need advanced management accounting techniques, such as ABC? How the ABC cost assignment network structure connects costs to products and sales channels Learn to use ABC to manage product, service-line, channel, and customer profitability Understand two views of costs: (1) process view versus (2) product view Comparing ABC with time-driven ABC, resource consumption accounting (RCA), lean accounting, and other costing techniques Operational Costing to Optimize Process Costs - How driver-based budgets and rolling financial forecasts lead to productivity improvement and cost reduction Applying “Attributes” to assess ”value-added costs” and “costs of quality (COQ)” The Shift in ROI’s Source from Tangible to Intangible Assets Increasing the ROI from information – with Corporate Performance Management (CPM) as a Value-Multiplier Accelerating the Rate of Adoption for Implementing and CPM Understand the barriers that slow the adoption rate of CPM: technical, misperceptions, model design, and social / cultural How to overcome behavioral resistance to change
Business Losses: Going Backward and Forward
-
TBD
2.0 Credits
Member Price: $79
Recent legislative developments for deducting business losses TCJA net operating losses rules of §461(l) §163(j) Business Interest Expense Limitations of deducting losses and basis What is the “quickie” refund; Section 465 At-Risk amount Section 469 Passive Activity Loss rules