Professional Development and Event Catalog

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.

Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227.  This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial.  A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements.

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!

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.

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.    

Most ethics courses focus on unethical individuals and their terrible misdeeds. We don’t need another course on lessons from Enron or individuals committing fraud.  Most unethical failures result from unethical individuals.  Instead, this session will focus on how good people can do better, why there is no such thing as business ethics and why we only need one rule to lead ethical lives.

Blockchain technology offers the promise of digital truth. It provides a transparent, permanent, immutable, and high-speed record-keeping system when appropriately implemented. The possibilities are endless, from managing the logistics of supply chain networks to facilitating international commerce. The adoption of this technology is growing, with millions of new users every year. Organizations adopt this technology every day to help improve their existing operations through its ledger capabilities or executing smart contracts. Cryptocurrency is one example of blockchain technology. Its growth and value have exploded to over $2 trillion in the last few years. This growth has helped to fuel widespread adoption amongst Wall Street and regular investors alike. While more popular than ever, few business professionals understand these technologies, their capabilities, risks, and potential impacts on business operations and processes, such as contract execution, recording and maintaining real estate ownership records, and supply chains. In fact, this incredible technology is a mystery for most accounting professionals. This course will provide a detailed and in-depth look at this technology, including a detailed overview of the underlying technology, the benefits, the risks, the major players, and many practical applications. By participating in this session, you will gain a deeper understanding of the inner workings of this technology and recommendations on getting started.  

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

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.  

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do.  We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.

When the leadership in any organizations carries out their responsibilities of establishing, maintaining and monitoring internal controls, it significantly reduces the possibility of fraud occurring.  When and if it does occur, a good system of internal controls will often detect it early on.  This presentation is an illustration of what can happen when top management fails to carry out their responsibility of protecting an entity’s assets through a good system of internal controls.

Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process.Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.  

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Understanding and Preventing Budget Calamities •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.  

Join our course on Multistate Taxation – Issues and Planning Opportunities designed for financial professionals. Learn about crucial topics like nexus implications, state taxable income calculations, and audit defense strategies. Gain practical insights to integrate these considerations into client financial plans effectively. From deciphering complex formulas to understanding state-specific regulations, this course equips you with actionable knowledge to excel in finance. Explore multistate business activities, choice of business entity, and interstate commerce clauses. By course completion, you'll be ready to identify common pitfalls, mitigate risks, and ensure compliance with multistate taxation. Join us and navigate the complexities of finance confidently. **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 budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.    Understanding and Preventing Budget Calamities 2 Hours - Accounting •    Most of us lead or participate in the budget process at least annually.  Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.   Building Flexible Budgeting Models: Walking Through and Crunching The Numbers 2 Hours - Accounting •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial planning.  Avoiding Budget People Issues:  Managing Budgeting’s Soft Side 2 Hours - Accounting •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.   Budgeting:  Presenting and Communicating your Numbers 2 Hours - Accounting •    Now that the budget is complete, how we communicate our plan is critical.  this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans.   

How you onboard a new employee is critical in ensuring they understand your company culture and are immersed properly in your organization. On the flipside, in the event you are dealing with an employee termination, this too is critical in handling with care and sensitivity.  

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.  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 a bit deeper into the world of forensic accounting and identify some of the specific areas of expertise required to become a forensic accountant. We will then first delve deeper into the art of document analysis and handwriting analysis.  

In today’s real estate market, IRC §1031 tax-deferred exchanges can be one of the most important planning tools available to the real estate investor. The use of this technique is filled with pitfalls and traps. This new course will assist the practitioner in understanding the mechanics of a tax-deferred exchange and the value of a tax-deferred exchange in both tax and financial planning. Updated August 2022

Manufacturing overhead costs - how to identify, classify, and trace products. How to handle Phantom sub-assembly costing issues. How to account for costs when manufacturing deviates from normal operations - outside temporary contractors. Applying costing principles to a process cost system and a project cost system. Example of a best-in-class chart of accounts for management reporting.

Navigating the complexities of business transactions requires a deep understanding of tax and estate planning strategies. In this comprehensive course tailored for financial professionals, participants will explore the intricacies of creative approaches to buying, selling, or gifting a business. Through real-world scenarios and practical insights, attendees will gain invaluable expertise in identifying tax risks, minimizing liabilities, and safeguarding assets. From evaluating valuation methods to exploring the details of stock versus asset purchases, this course equips you with the essential tools to provide informed counsel to clients. Discover the potential for strategic success as you master topics including estate transfer and tax implications, gifting strategies, and the utilization of various trusts and partnerships. Whether you're a CPA, EA, attorney, or financial planner, this course offers indispensable knowledge to elevate your practice. With a recommended 8 credit hours of Continuing Professional Education (CPE), this intermediate-level course is designed for professionals with a foundational understanding of business tax and estate planning. Join us and immerse yourself in a journey towards mastery in the vibrant landscape of business transactions. **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.