CPE Catalog & Events

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.

Why can it be hard to automate accounting? Because many accountants don’t know their options and, therefore, fail to reap the rewards of accounting automation. This session will teach you how easy and profitable accounting automation can be. In it, you will learn how to automate many traditional accounting processes, often with technology you already own. In addition to bank feeds, you will learn about automation options for processing accounts payable and receivable, approving transactions, and linking data from one platform to another. If you are serious about improving efficiency and accuracy, you should make plans to attend this session.

Being neuro-inclusive is not only kind, but can also help your team get the right things done in less time. This course will be about what neurodiversity is, give an overview of brain science, and show you tactical tips and techniques you can use to help your company get more of the right things done in less time with a strategy designed with more brains in mind. 

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?

If sales increase, so should profits.  Yet, the opposite result often leaves executives scratching their heads.  When organizations work with inferior cost information, they make mistakes in four specific situations.  Bad information causes sellers to overprice easy, high-volume work and underprice difficult, low-volume work.  This session discusses how to use activity-based costing data to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.  

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You spent your life building retirement savings.  Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation.  Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.  

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Audit Risk Assessment in Plain English, is a 2 hour webcast highlighting the AICPA’s clarified risk assessment standards, along with a new Statement on Auditing Standard (SAS 145) related to understanding the entity, the entity’s environment, the entity’s internal controls, and assessing the risks of material misstatement.  This session will attempt to simplify the requirements using common sense examples and language.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

Staying up to date with advances in today's technology has never been more vital, and K2's Tech Update equips you with the knowledge to stay ahead of the rapid pace of innovation. This comprehensive session is designed for accountants who want to understand the evolving technological landscape and its implications for the accounting profession. Which technology trends are worth monitoring? What are the proper hardware and software products for your strategic and tactical plans? How do Artificial Intelligence, quantum computing, Software-as-a-Service, and productivity suites like Microsoft 365 influence practice, especially since this year marks the 40th anniversary of the release of Excel? Separate vendor hype from reality and discover how to achieve a 2X or more return on investment from your technology expenditures. Attendees will leave with actionable insights, including ideas they may not have previously considered.

This course will provide a general understanding of the new reporting and disclosure requirements for employee benefit plans under the now effective SAS 136, the AICPA's new employee benefit plan auditing standard. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators, as well as the new requirements of both groups under the new SAS. The course will discuss the results from the Department of Labor's ("DOL") Criminal Enforcement initiative and audit quality study, and focus on the causes of the recent increase in the number of deficient engagements identified by the peer review process. This course will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements, including those related to the new ERISA Section 103(A)(3)(c) audits under SAS 136.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. In this course, we will examine how S corporations break away from the normal tax rules for flow-through entities. We will explore which employee benefits are disallowed for S corporation shareholders, as well as which taxes are assessed at the entity level. Finally, we will discuss how state level taxation may have changed permanently with the addition of PTE elections.

Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This webinar looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. We also discuss the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.