CPE + Events Catalog

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

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.

This CPE course provides an examination of the recent reports from a selection of Single Audit results. The instructor will go over the most common deficiencies found in Yellow Book and Single Audits and common peer review findings and OIG investigations. This course will also provide examples of common controls, best practices, and mitigation techniques. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.  

This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant.   This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work.  Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques.  The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.  

Payroll is among the most common tasks an employer undertakes in the course of running their business. At it's most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. However, once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll. Attendees will leave with a comprehensive framework for ethical decision making in the payroll function, as well as some real-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. For example: Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve into further investigative procedures used including digital forensics. Future sessions will focus on computer forensics, network forensics and mobile forensics.  

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

Designed to guide CPA firms venturing into the realm of SOC for service organizations examinations, this dynamic webcast offers comprehensive insights and practical examples. Whether you're considering SOC 1r, SOC 2r, or SOC 3r examinations, this session equips you with the essential know-how to confidently step into this space.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

Following the ever-changing tax deprecation rules is not a game for the faint hearted!  This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions.  **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.

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer. If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due dates requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business clients.  **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.

Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.