CPE Catalog & Events

This session isfor accounting professionals aiming to enhance their automation expertise with the low-code/no-code tools in Microsoft Power Apps and Power Automate. Participants will explore techniques to create simple workflows and develop custom applications, including "describe it to design it." The session focuses on automating processes, such as approvals, workflow automation, and data manipulation, while accessing and utilizing data from Microsoft Fabric and external databases. Attendees will learn about different types of workflows and the platform's tools for Robotic Process Automation (RPA). Further, they will leave with a better understanding of the Power Platform so they can drive digital transformation in their organizations.

The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the process works and their many potential pitfalls. *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

Obligating Coronavirus State and Local Fiscal Recovery Funds (SLFRF) by December 31, 2024 is essential to ensure a recipient does not have to return funds to the Treasury. There are a number of requirements to properly obligate SLFRF funds and opportunities to make changes to projects after the obligation deadline. In this course, we will define what an obligation is under SLFRF, review guidance from the Treasury, learn how to meet the SLFRF obligation deadline in multiple areas, and identify when changes can be made to estimates, contracts, and subawards after the obligation deadline.

This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software.  

Common Audit and Financial Reporting Deficiencies in State and Local Governments, is a 2 hour webcast detailing many of the more common mistakes that auditors and accountants are making in either the preparation of their annual financial statements or the audits of such financial statements. Deficiencies in audit standards (AICPA, GAO, Single Audit) and preparation standards (GASB) noted in this webcast are driven by the most recent results found in audit organization peer reviews, workpaper or desk reviews, and various organizations checklists for oversight. 

Loans, rental agreements, business combinations - what do these all have in common? They all have the potential of creating a related party transaction. This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. This course does not qualify for IRS credit.

The difference between star performers and average ones in leadership roles is attributable largely to emotional intelligence (EQ). It’s surprising, then, that EQ is underrated as an essential ingredient for success in life and leadership. This presentation highlights the importance of EQ and provides participants with actionable tools to develop better relationships within and outside of the workplace, build healthy teams, and navigate constant change.

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. 

Partnership tax law is always difficult. However, when certain transactions come up, not knowing how to handle them can be costly to clients and practitioners. In this course, we discuss several of these types of situations. We will explore the tax impacts of a PTE election and how a 754 election affects the inside basis of partnership assets. We will then examine those tricky look-through provisions on the sale of a partnership interest in order to properly calculate the tax implications.

Gain the knowledge to read and understand the differences between IFRS and US GAAP financial reports. A recent IFRS Foundation survey found that 167 jurisdictions now require the use of IFRS Accounting Standards for all or most publicly listed companies, while 12 jurisdictions permit its use. With this global acceptance, and as more than 1,000 foreign companies are reporting to the SEC using IFRS, learn how to read and understand the differences between US GAAP and IFRS financial reports. Attendees will examine an IFRS financial report and a US GAAP financial report, outlining essential distinctions between the US GAAP and IFRS reports.

Gain hands-on knowledge while focusing on the trust administration process on the death of the single settlor and the first spouse in a joint settlor trust. In today's estate tax environment, with a change of the exemption in 2026, the answers to core questions concerning whether to file an estate tax return, make a portability election or make a QTIP election may surprise you. Learn what clauses to look for in the trust; when and how to make portability and QTIP elections; when to use the "Delaware Tax Trap" in place of QTIP election; how to educate the client concerning trust administration; and how to deal with assets outside the trust. Using checklists and forms, understand how to create a practical system for administering the living trust after death.

We're all impacted directly or indirectly by the laws of real estate taxation, possibly as an owner, investor, landlord, developer, or real estate professional. This course explores the key principles of real estate taxation from all these perspectives. We'll discuss personal residences, vacation homes, depreciation, credits, passive losses, qualified business income, installment sales, involuntary conversions, like-kind exchanges, and real estate investment trusts (REITs).

This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant.

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.

What obligations does an employer have when an employee needs to take a leave of absence? This presentation will provide an overview of the complicated, intertwined compliance obligations triggered when an employee requests a medical leave of absence (including for pregnancy, mental health, or addiction).  

Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. This module will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits.

This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Starting with tax year 2021, Form 7203, S Corporation Shareholder Stock and Debt Basis Limitation, may be required to accompany shareholders’ Individual Income Tax Returns (Form 1040). This form is essential for reporting a shareholder's outside basis and debt basis to properly apply loss limitations under I.R.C. §461 and at-risk limitations. This course will provide a detailed overview of Form 7203, including its mechanics and strategies for completing it accurately. Additionally, strategies for reconstructing shareholder basis when it has not been maintained in the past will be discussed, helping practitioners handle these scenarios effectively. *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