Professional Development and Event Catalog

"Did you know that fraud is like a parasite, feeding on the lifeblood of the industry and causing billions in losses each year? Join Chuck Gallagher, a renowned expert in fraud prevention, for 'The Many Faces of Fraud: Shedding Light on the Tactics of Modern-Day Swindlers,' a captivating two-hour course that will empower you to thwart these financial predators. Chuck will guide you through the most common forms of fraud, revealing the psychology and motivations of swindlers. Through real-life case studies and hands-on exercises, you'll learn practical strategies for identifying red flags and responding effectively to safeguard your organization. Enroll now to gain invaluable insights and join the fight against these cunning adversaries!"

Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. 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.

Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision.  This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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.

Tax Season can be a daunting time for tax preparers, but it doesn’t have to be with the help of tax automation software tools and other innovative technology. This session will provide an overview of the latest technologies and tools that can help automate your workflow and make the entire tax return preparation process smoother and more efficient. From client portals, workflow management, and e-signatures to robotic process automation, you’ll learn about all the options available to help streamline your tax preparation process. So don’t dread Tax Season - attend this session and arm yourself with the tools you need to succeed!

Ethics is ultimately about our relationship to ourself, others, and the world in which we live. Therefore, to enhance our relationships with those around us, we must first start with the regard we hold for ourselves. From an ethical vantage, it can be said that we have a moral obligation to work toward self-love, honor, and respect. Matters of self-esteem are important in every aspect of life including goal setting, relationships, establishing boundaries, handling conflict, levels of productivity, and expressing our needs in respectful and dignified ways. This course explores traps of low self-esteem and ways to minimize those traps. We also explore components of high self-esteem and actions to foster higher regard for self. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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 course provides a concise overview of how the Internal Revenue Service (IRS) thinks. The session reviews how the agency uses behavioral insights -- the study of how people reflect and behave -- to drive compliance, positively impact taxpayer engagement, and reduce taxpayer burden. While the IRS is governed by federal tax law, it's also shaped by social norms. As part of their mission to collect taxes and administer the Internal Revenue Code, the agency utilizes human psychology to achieve their goals. These activities include public identity (using the IRS logo, seal, and symbol), voluntary compliance (using public shaming and the "Wesley Snipes" effect), trust building (using a Taxpayer Bill of Rights), and error reductions (using alerts and reminders to nudge behaviors). The session reveals how to "get into the head" of the agency and better understand the key psychological factors (individual, environmental, social) that drive leading IRS operations and decisions. The course also spotlights the leading issues and pain-points that are currently "top of mind" for the agency and how practitioners can be more mindful in their interactions with the IRS to improve outcomes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We all are busy, pressed for time and we strive to do as much as we can – as fast as we can. This is our world.  However, there are times when we should stop and think. When we do not analyze (one of our many talents) this inaction causes problems. We will review the penalties of moving too fast. Let’s learn from the mistakes of others.

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.

The QuickBooks platform is a robust environment with features and capabilities that many users are unaware of or do not know how to utilize effectively.  This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues that even experienced QuickBooks users struggle with, such as locking down prior periods.  This program starts fast with a chapter covering the top issues accountants face with QuickBooks.  The day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues, such as setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features.  Also, you will learn how to lock down transactions in prior periods, the audit trail, customizing reports, exporting reports to Excel, and extending QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.    

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

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.