CPE Catalog & Events
K2's Mastering Advanced Excel Functions
-
Webinar
4.00 Credits
Member Price: $129
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use “legacy” features and functions such as AGGREGATE Creating effective forecasts in Excel
Passive Activities & Rental Real Estate Income Tax Issues
-
Webinar
8.00 Credits
Member Price: $300
Detailed coverage of the passive activity rules under IRC §469 (and related regulations), how the 3.8% net investment income tax under §1411 and qualified business income (QBI) deduction under §199A applies to rentals and passive activities, and what is a trade or business rental is under §162 How the PAL rules apply to rental real estate activities and investments in S corporations and partnerships Definition of an activity and the activity grouping and disclosure rules Real estate professional exception to the PAL rules for investments in non-passive rentals Special $25,000 loss allowance for rental real estate with active participation Material participation safe harbor rules Events that trigger suspended PALs Limitations on tax credits generated by passive activities Special rules that re-characterize passive income to non-passive income What rentals are subject to self-employment tax under §1402
S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis
-
Webinar
8.00 Credits
Member Price: $300
Extensive review of the S corporation tax laws with an emphasis on any new legislation Review the Form 1120S and discuss how items get reported on the S corporation tax return (i.e. page 1 versus Schedule K) and flow-thru to the shareholders on their schedule K-1 Analyze the Schedule K-1 line-by-line and discuss where the items get reported on the individual’s Federal income tax return and how the items affect the shareholder’s stock and debt basis Look at detailed Schedule K-1 information reporting to shareholders needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations S corporation formation issues under IRC §351 Tax ramifications and reporting of distributions at the S corporation level including when the S corporation has prior C corporation earnings and profits (E&P) Preparation of the Schedule M-2 and the ordering rules for distributions out of the AAA, PTI, E&P and OAA accounts
Relationship Networking: The Art Of Conversation
-
Webinar
1.00 Credits
Member Price: $39
Networking Replatinship Management
Ethics - Keeping the Good from Breaking Bad
-
Webinar
1.00 Credits
Member Price: $39
Ethical business behavior Ethical business decisions
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Webinar
1.00 Credits
Member Price: $39
COSO Fraud Risk Management Guide Aligning data analytics considerations to an effective fraud risk management program How to implement and sustain an effective forensic data analytics program as part of an effective fraud risk management and compliance program
Accounting Analysis Basics 26-27
-
Webinar
4.00 Credits
Member Price: $175
Accounting analysis and methodology Factors influencing the quality of accounting-based financial reports Impact of emerging business models on balance sheets Introduction to the Instructor's Open Balance Sheet
Fraud—How to Find, How to Prevent 26-27
-
Webinar
4.00 Credits
Member Price: $175
Fraud and its impact on our clients Fraud prevention Internal controls Fraud risks Fraud prevention tips
K2's Securing Your Data: Practical Tools For Protecting Information 26-27
-
Webinar
4.00 Credits
Member Price: $175
Understanding today's cybersecurity risks Identifying significant cybersecurity risks Implementing specific steps to reduce risk
Advanced Excel Topics for Spreadsheet Power Users
-
Webinar
8.00 Credits
Member Price: $280
This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience. The topics discussed in this session include: Using Excel for graphical output and dashboard reporting. Data tools and the Data Analysis ToolPak. Advanced functions and complex formulas. Working with Excel tables and PivotTables.
Four Most Overlooked Business Risks: Preparing for the Future 26-27
-
Webinar
8.00 Credits
Member Price: $329
Systemic Risk Strategic Risk Culture Risk Management Continuity Risk
K2's Excel Essentials For Staff Accountants 26-27
-
Webinar
8.00 Credits
Member Price: $329
Best practices for creating and working with Excel workbooks The importance of PivotTables in modern reporting environments Best practices for formatting your workbooks
How to Make Difficult People Disappear...Without Going to Jail
-
Webinar
1.00 Credits
Member Price: $39
Team dynamics Influence Organizational behavior Leadership
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits
-
Webinar
2.00 Credits
Member Price: $79
Types of sampling and sampling risk Differentiating statistical and nonstatistical sampling approaches Attribute testing for tests of controls and compliance Variables sampling for substantive audit assurance when performing tests of details Determining sample sizes in a compliance audit in conformance with Uniform Guidance
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT
-
Webinar
1.00 Credits
Member Price: $79
AI and ChatGPT Machine learning & predictive transaction tagging Profiles of an improper or corrupt vendor payment Data Sharing Consortium and Split Learning Techniques Cryptocurrency trends and applications from an accountant's perspective
Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Webinar
2.00 Credits
Member Price: $79
How to build a flexible budget model that works? What are the steps we can take to budget for economic and external factors beyond our control? How the right Chart of Accounts can simply your work? Budget and GAAP are not the same and why they are fine not to be Efficiently modeling payroll and benefits Identifying controllable and uncontrollable expense Using key variables to stress-test your budget
Audit Skills for Beginners
-
Webinar
4.00 Credits
Member Price: $129
Professional skepticism – Creating a mindset for finding fraud and error Audit documentation basics – Creating workpapers that pass review The audit risk model – Understanding the foundational principles Internal control fundamentals - Satisfying the requirements for evaluating the design and implementation of internal control over financial reporting
2025 Annual Update for Governments and Not-for-Profits
-
Webinar
3.00 Credits
Member Price: $209
Not for Profit Governmental Auditing & Accounting Yellowbook
K2's Excel Best Practices And Features
-
Webinar
2.00 Credits
Member Price: $79
What to look for in Excel 2024 How to take advantage of new functions and features in Excel Integrating Excel data with other applications Improving Excel security
K2'S Tech Update
-
Webinar
2.00 Credits
Member Price: $79
Trends in AI and machine learning Applications of quantum computing in accounting and finance The growing role of blockchain and digital currencies in accounting Innovations in software and hardware