CPE Catalog & Events

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.

This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com

Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts.

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.

A chain is only as strong as its weakest link.  The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor.  Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble.  The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment.  Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results.  

This program will address recent legislation, rulings and developments affecting business taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.

Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.

A common challenge for the controller role is in closing the month-end and period-end books in preparation to issue financial statements. This duty requires precision, timing and efficiency. In today’s digital world, many organizations have access to financial accounting software that will assist with the steps in the financial close. However, even with this aid it is critical the accountant understand the various steps for the close process and how they inter-relate to other accounting processes. This course gives you an insight into the inter-relationships between many processes that impact the financial close. The closing process has traditionally been a slow one with many companies taking two weeks to close its subsidiary’s books and another two to three weeks to roll up and consolidated the results. With the introduction of technology much has been done to help accelerate that process with integrated enterprise resource planning systems and general ledger and consolidate software. Within this segment we will discuss the elements of the financial close and also important concepts to assist the controller in accelerating their close timeline. This includes addressing all functional areas of the close including payroll, invoicing, payables, inventory, cash, and the general ledger. We will also discuss important concepts of ensuring your financial close is accurate by discussing bank reconciliations, overhead allocations, bad debt reserves, unpaid wages and accruals for vacation time, account reconciliations, deprecation and overall financial statement review. Note: This course does not address utilizing technology in the financial close. Its focus is to understand the varied procedures involved in the financial close whether or not technology is utilized.  

All entities are subject to the new expected credit loss model established by recent GAAP.  This course will provide highlights of the latest requirements for measurement, presentation, and disclosure.  

This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques.  Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. 

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

The Uniform Guidance (2 CFR 200) pertains to the management of Federal Financial Assistance for grants and cooperative agreements.  The Biden Administration has performed a comprehensive update where the revised Uniform Guidance was released in April 2024. We will review all of the significant compliance and threshold changes. In addition, we will provide a brief presentation of the revised guidance as it pertains to Time and Effort reporting.

Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. 

Working with a small business, you know that keeping the company's finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects. In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we'll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. We also cover various add-on solutions that can enhance the overall functionality of your accounting platform. Join us to learn your options for achieving your small business management financial goals.

Many practitioners dealing with government and not-for-profit issues are asked to serve as expert witnesses in courts of law or other adjudicatory venues.  This session will discuss key issues you need to know when you are asked to serve in this capacity, including: Applicable standards and other engagement acceptance considerations. Preparation requirements and techniques. Dos and don'ts of testifying. Avoiding commons traps and tricks designed to undermine your effectiveness. The session will conclude with a “mock cross-examination” with participants serving as the jury to identify what our witness does right and what he does wrong.

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.