CPE Catalog & Events

Frequently, third parties may request certain financial and nonfinancial information to be verified by the external accountant (often referred to as ";comfort letters"). This course will provide insight into how to respond to requests for comfort in a way that will minimize professional liability risk. 

Two seemingly similar products can have very different costs, yet many companies are completely oblivious to these differences causing them to lose money or competitive bids.  When companies compete, those with good information win the “gravy” contracts and those with bad information lose money on “dog” jobs.  Attend this session to gain insights on how to win bids for the best opportunities and give the money-losers to your competitors.  Achieve your target profitability in the process.  

Quality management is important.  Every CPA firm that provides audit and other attest services must undergo a third-party quality control review.  This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review.

This comprehensive training is designed to get the accountant up to speed quickly with the different types of individual retirement accounts (IRAs). The cornerstone of the course is an in-depth coverage of the contribution and distribution rules to the Traditional, Roth, Simplified Employee Pension (SEP) and Savings Incentive Match Plan for Employees (SIMPLE) IRAs. The course will also discuss the basics of the health savings account (HSA) as well as any newly enacted tax legislation related to IRAs. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted.  The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future.

These are uncertain times. With constant economic fluctuation, geopolitical uncertainty and inflation pressures, corporations and their professionals are facing challenges at every turn. The Controllership function is accustomed to dealing with changing variables but when the change is constant and every evolving, even the simplest of tasks like cash flow and cash forecasting can become difficult.  This webinar is to focus on what methods the controller can elicit to attempt to address the current uncertainty when working with their cash flow issues and forecasting. Of course, there are basic measures that can be employed such as: Proactively managing receivables and payables Automate your accounts payable and receivables process Keep business expenses at a minimum Work with digital methods of payment from vendors Use credit wisely However, this webinar will explore methods used to create and manage your cash flow and forecasting processes. These methods go one-step past your typical forecasting to enable management to explore various alternatives and scenarios for the business.

Numbers and especially the digits within those numbers can conceal a lot of information.  Benford's Law and other digital analysis techniques can be the keys to unlocking that information.  This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data.  Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques.  But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.

By the nature of our work and training, financial professionals have more personal finance knowledge than the general population. However, sometimes we spend so much time planning our company's future that we neglect or defer taking steps to build our own personal net worth. If you are dissatisfied about the speed that you are accumulating savings, this session will help put you on the right track. Even if you are meeting your goals, this session will provide insights and ideas which will add to and reinforce what you may already be doing.

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.

An operational audit is a method of examining how an organization conducts business. It identifies areas where an entity can improve to be more effective and efficient. This course will focus on how to plan and perform operational audits, as well as delivering value-added recommendations as a result.

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.  

This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.

Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools. 

When it comes to hiring, using a conventional hiring process may not be as reliant as flipping a coin. A coin flip may often be better because it would bypass a lot of hidden biases and inefficient processes. We need to get back with a clean sheet of paper and do it better. In this course we will look at improving a process that is deeply flawed, and we will look objectively and outside the box on things we can do to identify and hire high performers.

Companies reporting under International Financial Reporting Standards (IFRS) continue to face a steady flow of new standards and interpretations. The resulting changes range from significant amendments of fundamental principles to some minor changes from the annual improvements process. The changes will affect different areas of accounting, such as recognition, measurement, presentation and disclosure.  It can be time-consuming and confusing to keep up-to-date on the resulting impact on financial statements and disclosures. This course will provide an executive summary of recent IFRS updates with current and upcoming effective dates.  

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

In forensic accounting, interviewing is used to obtain important information from witnesses and suspects. An important aspect is the ability of investigators to obtain accurate and reliable information from victims, witnesses and the suspects or any interviewee. The interview process is an essential part of information gathering for any investigation. The importance of improving the quality of the interviewing with the potential for visual recording of all interviews should be placed high on the agenda of all organizations across the globe. A properly conducted forensic interview can result in an extreme benefit regarding collection of information. The interviewer’s role is to develop a full understanding of the facts. There is a distinct difference between a forensic interview and a criminal interrogation. Typically, forensic auditors will not be involved in interrogations. The Canadian or U.S. forensic accounting profession does not have a standardized interview model to truly equip its professionals with the interview tools required to elicit confessions ethically. Majority of their skills are developed through experience, and not through a standardized model of training.  This session focuses on various interview concepts and methods.