CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Inventory is a wonderful place to both hide fraud and commit fraud. The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it. When there are little or no internal controls related to inventory control, you are begging employees to steal it. No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed. Travel and entertainment are some of the favorite areas of committing expense fraud. In addition, payroll fraud will be discussed. Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.
The Updated Nuts and Bolts of IRC Section 1031 Exchanges
-
Online
2.00 Credits
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
Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation
-
Online
2.00 Credits
When we try to improve efficiency, we seek to delegate manual tasks to Excel. This implies that we seek to convert manual input cells into formula cells. When we realize that Excel can operate on and return date and text values, the opportunity for efficiency greatly expands. This webcast covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison operators. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Online
2.00 Credits
Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of several factors, including excessive debt, decreased demand, increased costs, lawsuits or poor accounting practices. It is no secret bankruptcy filings will see a tremendous uptick in the wake of the Covid-19 pandemic. As an accountant, CFP, attorney or other professional, you need to be able to discuss the process and different available courses of action with your clients. Both landlords and tenants will be influenced tremendously. Individuals will look to your advice for a discharge and new start. Businesses will do the same and will also need to advise loyal employees. Creditors will receive proofs of claim and look to you for your expertise. Take this webinar and make sure you can speak fluently to both creditors and debtors. As trusted advisors, then, professionals should have a basic understanding of the bankruptcy process. This course provides a thorough review of the consumer and corporate bankruptcy practice. Participants in this webinar will gain an understanding of how consumer and corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This webinar provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients and your profit margin a favor and sign up for this invaluable webinar. This course qualifies for CFP credit.
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Online
2.00 Credits
This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.This course qualifies for IRS credit.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
2024 Mid-Year Individual Tax Update
-
Online
4.00 Credits
This course is essential for the tax practitioner who wants to update their knowledge of individual income taxation so that the practitioner can provide solid planning advice to their clients prior to year-end. This course will provide a comprehensive review of Form 1040 issues for the current tax year. Included will be a thorough review of all Internal Revenue Code changes made by year-to-date. In addition, this course will instruct the participant as to where to expect potential changes to be made by the current administration.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - OLAP Formulas & More Time Intelligent Functions
-
Online
2.00 Credits
This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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.
Secure Act 2.0 - Everything that you Need to Know
-
Online
2.20 Credits
Congress was EXTREMELY busy in late December 2022! During this lame-duck session, Congress was able to pass SECURE 2.0, which is essentially the original SECURE Act that was passed in late 2019. There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master. This course will provide the participant with everything that that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **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 Power of a Good Story!
-
Online
4.00 Credits
Storytelling makes wisdom stick.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Online
4.00 Credits
Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 301: Code of Professional Conduct - Key for Auditors
-
Online
2.00 Credits
Professional Requirements for Assurance Providers, Including Independence - Understanding Critical Code of Professional Conduct Concepts will dig deeper into important foundational principles, primarily focusing on threats to independence and how to avoid or appropriately safeguard them. The AICPAs Code of Professional Conduct provides guidance for ethical business conduct, as well as other potentially relevant ethical requirements from the PCAOB and international bodies. An important pillar of any Code of Professional Conduct is the rules governing independence when performing attest services, particularly when both attest and non-attest services are provided. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has audit or attest engagement responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Valuation Fundamentals
-
Online
1.00 Credits
In this course we will look at the highlights of what valuation is doing, how to go about it and what to look for in business valuation reports. Areas such as types of reports, the standards by which they are prepared and process that is used to go from data to report. We will also discuss the purposes of reports and how that purpose may impact the value. Finally, we discuss how to determine the value of minority interests.
SAS 145 - Risk Assessment
-
Online
1.00 Credits
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
2024 A Guide to Sampling - Part 1
-
Online
2.00 Credits
Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.
2024 Best Practices: Conducting Meaningful Walkthroughs
-
Online
2.00 Credits
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough.
Drive Results with Metrics
-
Online
2.00 Credits
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance.
Reasonable Compensation for S Corps
-
Online
2.00 Credits
Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud. However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud. Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements. This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement. If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.