Professional Development and Event Catalog

The term “automate” has been an industry buzzword for at least a decade. Yet, few organizations have embarked on successful automation journeys, leading to greater efficiencies, reduced errors, and happier team members. In this session, you will learn how to crank up your automation projects and see first-hand how easy and effective automation can be. More specifically, this session shows you exactly how you can work with tools from Zoho, Zapier, and Microsoft to enable powerful routines that will allow you and your team to get more done in less time.

Remote work environments have created many new opportunities for cybercriminals and other fraudsters to exploit, and accounting professionals are some of the most commonly targeted individuals. This session is a series of case studies that examine actual criminal filings and news accounts and use them to highlight some of the actions you can take to limit your exposure to similar schemes. Attend this session and learn more about how high-profile control failures occurred so you can be more effective at preventing crimes in your organization.

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.

Artificial Intelligence (AI) is no longer just a theoretical concept! Instead, AI is a practical tool available today to help you address and solve real-world problems. In this course, you will learn about the fundamentals of AI and how you can put this amazing technology to work today to help you and your team work more efficiently and effectively. Participate in this course to learn about the fundamentals of AI and specific types of problems AI can help you address. You will learn about AI features available in everyday applications – including Excel – and how you can use these features in situations such as detecting fraud and identifying potential errors in transactions. You will also learn how AI is changing how accounting and financial professionals work, both today and in the future.  

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.

Form 1065 is the tax return filed by partnerships, which is one of the most common forms of business organizations in the United States. This course provides an in-depth understanding of the preparation and filing of Form 1065. The course will cover the basics of partnership taxation, including how partnerships are taxed, the different types of partnerships, and the tax obligations of partners. It will also discuss the importance of keeping accurate financial records, the role of the partnership agreement in tax reporting, and the filing deadlines for Form 1065. Participants will gain a comprehensive understanding of the various sections of Form 1065, including the Schedule K-1, which reports each partner's share of the partnership's income, deductions, and credits. The course will also cover how to report partnership income, expenses, and deductions, as well as the tax implications of buying and selling partnership interests. In addition, the course will provide an overview of common errors and omissions made when preparing Form 1065, and how to avoid them. It will also cover recent changes in tax laws that affect partnership taxation. Overall, this course is designed for tax professionals, accountants, business owners, and individuals who need to understand the intricacies of partnership taxation and the preparation and filing of Form 1065. Upon completion of the course, participants will have a solid understanding of partnership taxation and will be able to prepare and file Form 1065 with confidence. **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.

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! 

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!    

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.

Every organization claims to be ethical, but words and deeds do not always jibe. How do you assess the real Ethics of an organization?  What are the key factors and behaviors to be aware of? Many organizations lack prescriptive policies, but is that an excuse to deviate from the spirit of doing the right thing? How can professionals abuse ‘what is right’ and circumvent policies for their personal benefit. What are some egregious examples of violating policies? How allowing exceptions invites abuse. This seminar outlines steps to gauge the ethics of an organization.

Ethical situations occur more often than many realize. We must stay vigilant. Sometimes a seemingly simple situation may seem innocuous at first, but it can lead to large complications in the near future. In today’s competitive environment, one error posted on social media can damage a reputation forever. Social media posts can cause havoc. 

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?

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.

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.

Tax compliance issues for fiduciary entities are sometimes confusing to practitioners due to the fact that many lack experience in this area. This course provides the practitioner with a practical understanding of the issues involved in preparing the U.S. Income Tax Return for Estates and Trusts (Form 1041), including a Line-by-Line presentation of the form.  The practitioner will have a better understanding of entities and the basics of Subchapter J of the Internal Revenue Code.  Understanding these areas will allow the practitioner to start their understanding of tax compliance in preparing the U.S. Income Tax Return for Estates and Trusts (Form 1041). **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 leighanne.conroy@acpen.com.

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.  

Privacy should be everywhere, yet every day seemingly brings a new story about a privacy violation. While it can be frustrating and sometimes scary to think about mishandling our personal information, it’s important to remember that we can take steps to protect our privacy. This session will teach you where your critical threats are and what information you may already have at risk. More importantly, you will learn how to manage and mitigate privacy risks. In an era of increasing connectivity – and by extension, risk – this session should be high on your list to take as soon as possible.

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.