CPE + Events Catalog
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check (3.5 hours)
-
Online
3.5 Credits
Member Price: $175
See more dates
Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Forgotten Managerial Accounting Tools (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This session explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!
More Dates
Mastering Partnership Basis: Inside and Outside Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Mission-Critical Leadership: How Smart Managers Lead Well in All Directions (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
See more dates
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.
More Dates
How Fraud Can Affect Smaller Organizations (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Creating an Ethical Work Environment (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Controllership Series - Overhead, Direct and Indirect Costs and Allocation Methods (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.
More Dates
Improve Spreadsheets by Building Controls in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Federal Tax Update for Individuals with Doug Van Der Aa (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.
More Dates
How to Build a Custom AI Chatbot and GPT in Plain English (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Audit Inventory (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Controllership Series - Financial Statement Preparation (2.6 hours)
-
Online
2.6 Credits
Member Price: $89
See more dates
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.
More Dates
The Controllership Series - The Controller's Role in Pro Forma Financial Statements (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.
More Dates
Fiduciary Accounting for Estates and Trusts (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting.
More Dates
Guide to Preparing Form 1041 for Estates and Trusts (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **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.
More Dates
Revenue Recognition - Topic 606 Overview (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
This session is the beginning in a series on the new revenue recognition standard. The standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. This course is designed to provide an overview of the technical guidance and outline the five steps involved in the revenue recognition model. We also explore some concepts to consider within each step and then evaluate some challenges that specific industry's may have when complying with the standard. Future courses will further delve into each step and provide example and scenarios that should be considered to properly apply the step.
More Dates
Global Internal Audit Standards (GIAS) Domain V - Part 2 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
More Dates
Understanding the New Forms K-2 and K-3 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Peer review deficiencies and professional liability claims result from both audit and nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns for a wide variety of professional services offered by public accountants.
More Dates
Tax Season Update for Individuals with Steve Dilley (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This program provides an update to the latest tax developments, rules and regulations impacting individual taxpayers, with a review and integration of the numerous 2024/25 legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
