CPE Catalog & Events

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. 

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit businesses to achieve success.

The AICPA's Auditing Standards Board has several large projects that will be impacting entities in the near future. We'll take a deep dive into the changes related quality management as well as group audits. We'll also review common audit deficiencies. This course will keep auditors up to date on the work of the ASB. 

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A significant amount of information is electronically initiated, recorded, processed, or reported, and information to be used as audit evidence may be available only in electronic form. During this session we will look at different types of information commonly presented to an auditor during the audit of an employee benefit plan, and identify considerations for auditors when evaluating information to be used as audit evidence.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

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.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data. This webcast focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. **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 is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics. 

Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing accounts receivable. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Develop financial reporting expertise to conduct an accounting analysis and detect distortions in financial statements. Accounting savvy permits the business analyst to leverage financial information to manage and implement business plans. Gain the tools necessary to become skilled at such analyses. Review the impact of financial and accounting data on the function of capital markets in relation to the changing economic landscape and globalization.