CPE Catalog & Events

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.

In this course, you'll learn why being able to do public speaking well is a major advantage in becoming successful in your career.  You'll learn how to write a good talk, how to present it well, and how to use your new found ability to get more clients and/or a promotion. In addition, you'll learn how to overcome your nervousness, and how to overcome stress in less than a minute.

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 analyzes. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you! 

The GASB has been working on some big projects lately. This course starts with a look at the GASB standards effective this year, including GASB 94, Public Private Partnerships and GASB 96, Subscription Based IT Arrangements. We will include practical applications in the form of case studies to apply the topics. We will then switch gears to the GASB standards coming down the pike, including the major projects of the GASB.

How good are you with the technology you use daily?  What new technology tools are available that could save you time and make you more effective?  Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends.  Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.  

This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also 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.

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.

This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s.  Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2. 

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme.

The TCJA made turning business losses into tax refunds far more difficult.  The CARES Act suspended and modified many of these changes.  This course will address the revised rules for deducting business losses and discuss planning ideas and 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.  

This course explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief.  The game changing impact of the Dynamex case and AB5 will also 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.  

One of the important roles of any member of the financial team. Including the controller, may be involvement in the preparation of the company’s financial statements. Even if that responsibility falls within the office of the CFO, the controller and other finance personnel must understand how their transitions recorded impact the financial statements. Financial statements (or financial reports) are formal records of the financial activities and position of a business, person, or other entity. Relevant financial information is presented in a structured manner and in a form which is easy to understand. They typically include four basic financial statements accompanied by a management discussion and analysis: A balance sheet or statement of financial position reports on a company's assets, liabilities and owners’ equity at a given point in time. An income statement may have varying names including profit and loss report (P&L report), statement of comprehensive income, or statement of revenue & expenses. These report on a company's income, expenses, and profits over a stated period. A profit and loss statement provides information on the operation of the enterprise. These include sales and the various expenses incurred during the stated period. A statement of changes in equity or “statement of equity” also called “statement of retained earnings” reports on the changes in equity of the company over a stated period. A cash flow statement reports on a company's cash flow, particularly its operating, investing and financing activities over a stated period. A balance sheet represents a single point in time, where the income statement, the statement of changes in equity, and the cash flow statement each represent activities over a stated period. For large corporations, these statements may be complex and may include an extensive set of footnotes to the financial statements, management discussion and analysis and supplementary information. The notes typically describe each item on the balance sheet, income statement and cash flow statement in further detail. Notes to financial statements are considered an integral part of the financial statements.  

Clients concerned about market volatility often prefer more conservative fixed-income investment strategies. There are many choices to consider: taxable or tax-exempt bonds; Treasury Bills or inflation-indexed bonds; and direct purchases, exchange-traded funds, or mutual funds. This course will explore the changing economic environment, various fixed-income strategies, and their taxation. Companion course: Tax Aspects of Stock Investing

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay current on recent changes in accounting and auditing. Review Financial Accounting Standards Board (FASB), U.S. Securities and Exchange Commission (SEC), Private Company Council (PCC), Public Company Accounting Oversight Board (PCAOB) and American Institute of Certified Public Accountants (AICPA) standard-setting activity in the current year. Implementation dates will be provided so you can plan for changes, and the course will highlight the changes that will be implemented in the current year. Also, we'll discuss the difference between public and private company requirements.

Any corporation or individual can be vulnerable to scams and hoaxes. Learn how to break down the deception into the psychology of the con. We'll review best practices to avoid embezzlement and fraud and case studies of embezzlement, including payroll scams, fraudulent payees, skimming and new technology scams. Fraud can also arise when companies downsize and technology goes missing because there aren't enough gatekeepers on watch. Learn about opportunistic vulnerabilities that stem from having few employees/contractors and using free software.

To get started in estate planning, learn the basics of intestate succession, probate, wills, health care directives, general powers of attorney, trusts, gift and estate tax planning, as well as transfers of assets. Become familiar with some basics of transfer tax planning, including A-B trusts and QTIPs/marital deduction planning, portability, planning with life insurance trusts, family limited partnerships and more. Also, particular attention will be paid to the human elements that are impacted by estate planning and related tax strategies.

Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.

Practitioners that provide non-audit services must strike the right balance between complying with relevant professional and regulatory standards, providing value-added client service, and mitigating litigation and other practice management risks. This course contains many case studies to reinforce best practices for managing the accounting, reporting, and performance issues associated with the attest services of compilations and reviews where reports are issued, as well as the SSARS  preparation of financial statements service and other nonattest engagements.