Professional Development and Event Catalog

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect.  In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

Become a trusted and valued business partner In the dynamic landscape of modern business, the role of finance professionals is rapidly evolving. No longer confined to traditional number-crunching, today's finance experts are expected to be strategic partners, influential in shaping the future of their organizations. Global trends and changing organizational environments drive finance to be more strategic and proactive - to move beyond reporting on results to helping business units achieve results. During this session, we will dive into essential skills for finance professionals, such as: Building effective stakeholder relationships Developing acute business acumen Enhancing strategic thinking and problem-solving abilities This webcast will provide attendees with a roadmap to becoming a trusted and valued business partner.

If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.

Many of us expect to use logic when it comes to how we allocate our investments. The adage of "buy low, sell high" is a saying that makes logical sense. So, why do we always seem to do the opposite? Every day we are faced with decisions, and we are often influenced by two seemingly opposing voices that come from two different parts of our brain. The frontal cortex processes lots of information to help us make logical and informed choices. But there's also a small part of the brain, known as the reflexive brain, that is responsible for emotions and survival instincts. Often, this reflexive brain can have a detrimental effect on the way we handle our investments. This course will discuss some behavioral biases that affect our financial decisions. As humans, we need to be aware of how our reflexive behavior impacts our investment decision-making ability. By uncovering and understanding these biases, we may have a better chance of meeting our long-term financial goals.

How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.

This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will be discussed. **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.

Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Tax developments have been in the forefront of the news, and tax practitioner can find it challenging to remain up-to-date with these changes.  This 8 hour program will cover tax issues relating to individuals, including new court decisions, recent IRS publications, and the latest tax legislation.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.   **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.

Part one of a five-course series, address common issues new staff members face. Focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. Dive into the fundamentals: workpaper techniques, analytical procedures, compilation and review services, tax recognition and research techniques, understanding audit objectives, and auditing and reviewing selected accounts. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers.  In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers.  The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency.  Also included will be case studies illustrating dilemmas faced by tax practitioners.   **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.  

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The issue of civility, or lack thereof, has garnered much attention from leaders, Human Resource professionals and employees at large. The cost of incivility is high not only to the bottom line but to the human spirit. This webinar, based on ethical principles and values, is designed to look at the fundamental relationship skills that foster workplace civility. Understanding that workplace civility is far more than manners, we will dive into behaviors that help promote a workplace where each individual feels respected and valued. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.