Professional Development and Event Catalog

If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications.  What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives – is paramount. Be aware. 

You and I have a responsibility to our organizations and to the public to be ethical. We cannot forget this responsibility and this responsibility is constant. One lapse can cause profound issues that last. Ethics and trust are intertwined, no one follows a ‘leader’ who is not trusted. We will not focus on the negative and show the problems caused – rather, we focus on what and how to set the example for others to follow. This seminar outlines the seven components of trust, and how we should use these components daily.

What happens when businesspeople think they can lie and cheat at work, as long as it makes a profit? Some believe that business is like war, and there are no rules!  Do you really want to behave differently in business than in your personal life? Can, or should, ethics be ‘switched on’ or off?

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist.

The merger and acquisition market remains healthy. An oft-overlooked step in the business combination is the examination of expenses to make sure expense ratios are optimized. Explore the current M & A environment for dealers and the growing need to take a keen eye to major expenses prior to any transaction, regardless of whether you are on the buy or sell side. 

This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.

The number of accounting applications available today can be staggering for businesses with up to $15 million in annual revenue! In addition, cloud-based solutions such as QuickBooks Online, Xero, Accounting Power, and Wave are growing in breadth and depth. At the same time, traditional desktop and client-server applications continue to add more features, including hosted options. On top of all of this, financial reporting and other add-on solutions can further complicate your decision as to which tools you/your clients should use. In this course, we will take a deep look into setting up a Quickbooks Online Accountant (QBOA) account. We will examine all the various firm, staff, and client configuration options for getting this to work inside your organization. This session focuses specifically on the configuration options for the financial professional. QBO is an extensive application, requiring you to ensure you’ve correctly set up your firm and client files. Additionally, we will look at the various import/export functionality for getting your data into or out of QBO and some of the best 3rd party tools in the Intuit App Marketplace. Participants will leave this class supercharged with the knowledge of getting the most out of their QBOA subscription.  

Increasingly, accountants and auditors are called upon to use data analytics to understand and improve results. Yet, many professionals struggle with the concept of data analytics and remain unaware of how to obtain the results needed using tools they already own. In this session, you will learn about the four primary types of data analytics and when to use each. Further, you will learn how to generate meaningful analytical measurements using Excel, Power BI, and other tools and, more importantly, how to interpret the results. If you seek to use data analytics – and who isn’t – this session is for you.

The Corporate Transparency Act requires mandatory disclosure of the beneficial owners of existing and newly formed entities. This legislation imposes new compliance requirements for existing business entities.  Knowledge of this legislation and the new reporting requirements is critical for any person involved in the creation of a new business entity or advising existing business entities. More importantly, advisors must be aware of the new beneficial ownership interest reporting requirements to prevent the imposition of harsh penalties.  This course will provide the attendee with both knowledge of the legislation and knowledge of the exceptions to the legislation. 

The next five years are going to be eventful for CPA firms. The profession has never seen such rapid change, with new and changing technologies appearing almost daily! So, what will your firm do? How can you keep up without getting overwhelmed by these fast-paced transformations in the profession and stay profitable during this turmoil? What are the best technologies to handle client interactions, PBC lists, electronic signatures, and Advisory services? How do the cloud, next-generation accounting software, and client demands affect partner profitability? Attend this session to get an independent overview of the state of technology in the profession.

Blockchain is one of the most-watched emerging technologies. Yet, few accountants understand how to use this technology to make existing ledger-based systems more efficient, effective, and tamper-resistant. In this session, you will learn the basics of blockchain-based ledgers. You will also learn about the fundamentals of cryptocurrencies such as Bitcoin and Ripple. Additionally, you will learn about emerging issues in these fields, such as stablecoins, central bank-issued digital currencies, smart contracts, and sovereign identity management. By attending this session, you will see how blockchain-based technologies will change your work with others.

Google is one of the largest, most widely used and vital technology companies on the planet. Their name has become synonymous with search, knowledge, and cutting-edge technology. Google developed and maintains a wide range of products that have changed how we learn, find things in our community, and communicate with the world. Further, Google offers a business-ready cloud productivity suite used by a growing number of businesses worldwide. Google brings together a wide range of communication and business tools under one roof to serve as the backbone of an organization’s technology infrastructure. Most users are familiar with Google’s search service or Gmail but are unaware of the other services they provide. Additionally, most users barely scratch the surface of the functionality of Google’s tools and services. This course looks at the most valuable features, apps, and services of Google that the busy working professional could better utilize. Course participants will learn to find better web results using search operators and tools. Further, they will understand Workspace and use it as an organization’s back office. They will learn to create dynamic, creative, and useful business documents using Google tools. They will learn to back up and sync their electronic documents to the Cloud using Google Drive. Finally, they will learn to grow their business and expand their marketing using Google’s marketing and website tools. This session finishes with a top-five list of Google's best-hidden secrets and functionalities. Beginners to advanced users of Google products will leave this course with a much deeper understanding of the services, time-saving tips to use the products more effectively, and practical advice on how to best leverage their incredible technology.  

In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in the field of auditing, where internal and external auditors are increasingly turning to data analytics to identify situations requiring follow-up and investigation. Those who understand how to take advantage of various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application.

A burning question on the minds of many is, “What features should I use in Windows 11?” Presented with end-users in mind, in this session, you will get the answer you need to that question and others, all delivered in the context of improving productivity and security. Among other topics, you will learn about improvements in virtual desktops, changes to the user interface, customization options, and more. If you’re using Windows 11 now or plan to upgrade soon, this is a must-see session to help you make the most of your upgrade.  

Many CFOs place too much emphasis on external financial and statutory compliance reporting for government regulatory agencies and not enough on corporate performance management (CPM) methods including internal management accounting. The former is for valuation (e.g., inventories and COGS). The latter is for ocreating wealth value? to support better decisions. This course provides tools and information for how CFOs can transition from bean counters to bean growers. The best CFOs not only keep score, which is necessary, but they enable the organization to score more, which is much more valuable.

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

Automation is a great way to save time and improve accuracy and effectiveness. It also allows you to get more value from your workday. This session will teach you how to automate the tasks that are mundane or take up too much energy, so you complete them automatically instead. One of the best things a person can do is invest time into automating their workday to help them achieve more work, reduce daily stress, and provide better mental clarity. This session focuses on various tools and services you can use to help promote personal automation. In it, you will learn about technologies such as integration platform tools, Amazon Alexa and Google Home, and the Elgato Stream Deck.  

Automating the tax practice is – or should be – a major initiative of almost all public accounting firms today. From ingesting data, processing returns, distributing draft and final copies, and billing and collecting fees, practitioners have outstanding opportunities to automate their tax practice. Those that choose to automate will experience the benefits of reduced staff turnover, increased productivity and efficiency, fewer errors, and improved cash flow. Participate in this session to learn the “how’s and why’s” of automating your tax practice. This session includes critical topics such as hardware and software options, workflows, and security and privacy issues. Plan to join us in this session to position your tax practice for greater success! 

The adage, “what gets measured, gets managed,” has never been more true than it is today. Organizations of all kinds and sizes are creating systems and processes to categorize, track, and report on many of their operations by creating reports featuring key performance indicators (KPIs). This session will teach you about many different kinds of KPIs. Further, you will learn how to find data and use tools like Microsoft Excel and Power BI to measure performance. You will also identify the benefits and drawbacks of using KPIs in management philosophies like holacracy to make it easier for employees to know in real time where they stand.