CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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 The Preparation of Form 706 and 709 - Line-by-Line
-
Online
4.00 Credits
Navigating the challenges of estate and gift taxation can be overwhelming for practitioners, especially those lacking extensive experience in this field. In this comprehensive course, participants will undergo a practical exploration through the preparation of the Federal Forms 706 and 709 - line by line. Through hands-on instruction, attendees will gain invaluable insights into the complexities of tax compliance, equipping them with the skills and confidence needed to seamlessly integrate estate and gift tax preparation into their practice. With a focus on practical application, this course offers participants a unique opportunity to master the preparation of crucial tax returns, enhancing their professional expertise and strengthening client service offerings. From a detailed overview of the Federal Forms 706 and 709 to insights on complying with "Portability" and navigating postmortem estate planning issues, attendees will emerge with a newfound proficiency in estate and gift tax preparation, ready to excel in their practice. **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.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
A fundamental understanding of the taxation of business property transactions is essential to any tax practice. This course prepares tax professionals to handle the tax effects of common property transactions, including like-kind exchanges and involuntary conversions. It also covers important property-related timing issues and planning opportunities that can lead to significant tax savings.
New Quality Management Standards: Bringing It All Together - Exploring All Components of a Quality Management System
-
Online
1.00 Credits
Pull together all components for an effective and tailored QM system (bold) For a quality management (QM) system to be successful, it needs achievable objectives and tailored processes in place to enable the performance of quality engagements. It also needs clearly articulated roles and responsibilities and the ability to identify, evaluate, and correct deficiencies. The revised QM standards are designed to emphasize firm leadership's responsibility for proactively managing quality, strengthening a firm's monitoring and remediation processes, and advancing the ability of the firm to tailor its system of quality management to the nature and circumstances of the firm. To succeed under these new standards, you'll need to know how to set up a functioning QM system that will help your firm identify and address risks for its audit and assurance practice. Fourth in a four-part webcast series (bold) This is the fourth webcast in a four-part series on the Auditing Standard Board's (ASB) new Quality Management Standards and looks at how to create an effective QM system. You'll take a deep dive into aspects of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec.15, 2022, at 2:00pm ET.
5 Ways Your Onboarding Process Fails to Engage and Retain New Hires
-
Online
1.00 Credits
According to the Gallup Organization, only 10% of employees believe that their organization does a good job onboarding new employees. This means most organizations are overlooking this crucial phase of the employee lifecycle, which not only includes the often-neglected pre-boarding stage but also the continuous efforts to reduce uncertainty, bolster excitement, and foster connections for their new recruits. By streamlining these processes and crafting impactful moments from pre-boarding through the initial weeks, HR and Business leaders can significantly enhance efficiency, foster trust, and establish a foundation of psychological safety for years to come. In this session, attendees will discover strategies and resources that craft a holistic onboarding experience, mitigating risks like employee ghosting, and paving the way for heightened engagement and retention.
Top Employment Tools to Protect Your Business and Recommend to Business Clients
-
Online
1.00 Credits
Overview of the most important labor and employment policies and practices that every business should have. The review will go over confidentiality agreements, arbitration agreements, restrictive covenants, training, and severance agreements, as well as compliance issues related to each of them.
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
Explore the current audit environment, and recognize audit challenges triggered by the current environment. Provide a comprehensive review of recent audit pronouncement and exposure drafts. Understand topics critical to success in today's rapidly changing regulatory environment. This course provides 4 hours of CPE credit in the Auditing field of study.
Exploring the New Lease Accounting Standard
-
Online
2.00 Credits
It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Small Business Risk Avoidance
-
Online
4.00 Credits
Enterprise Risk Management for SMEs
Mock CPA Exam - Virtual
-
St Louis
0.00 Credits
For many candidates taking the CPA exam can be one of the biggest obstacles when transitioning into the profession. Often candidates are not sure if they have studied enough or focused on the relevant areas for each section. In order to help, Surgent has offered MOCPA student members and CPA exam candidates a means to best prepare and study for the exam. MOCPA is pleased to offer a FREE CPA exam simulation of the exam section of your choice. Don't miss this unique opportunity to experience the CPA exam and to receive your test results onsite. Questions are laid out according to the Uniform CPA Examination Blueprints. Click here for the most current version. Surgent CPA Review has offered to assist and guide CPA candidates through a 4-hour session where they will be immersed in an exam taking environment and walk away with insight on areas of focus for when you take the real thing! The goal is to simulate the environment and format of taking the CPA Exam, using actual m/c questions and simulations. Students who register will be able to select the exam portion of their choice and receive feedback. At the conclusion of the Mock Exam, candidates will receive their Exam ReadySCORE along with a diagnostic report showing areas of strength and weakness which are aligned with the CPA Exam Blueprint. Time: 12 p.m. to 4 p.m. Live simulation will begin at 12 p.m. and conclude at 4 p.m.Advance registration and selection of the exam section of your choice is required. The email address that you use to register for this event will be used by Surgent to set up simulation. This will expedite the start of the simulation and provide you proper access. For any questions, please contact Liz Schaetzel at (314) 392-5834 or lschaetzel@mocpa.org.
Audit 406: Auditing Revenue Recognition - Common Risks
-
Online
2.00 Credits
Auditing Revenue Recognition - Grasping the Higher Risks and Special Audit Considerations will provide tips and techniques for obtaining sufficient and appropriate audit evidence to support conclusions related to accounting for revenues obtained from contracts with customers. Revenue recognition is presumed to be a significant risk for financial statement auditing purposes due to the increased risk of both fraud and error. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities in auditing revenues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Making Culture A Competitive Advantage
-
Online
1.00 Credits
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture.
The Controllership Series - The Role of the Controller in ESG
-
Online
1.50 Credits
Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process. Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Online
1.60 Credits
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.
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).
Project Management: Getting the Best Out of Your Team
-
Online
2.00 Credits
With capacity challenges on the mind of many tax and accounting leaders, finding ways for their teams to work more efficiently is crucial. They need their teams to not be busy, but deliver value, and continue to develop their skills and knowledge. Project Management techniques help uncover inefficiencies and gaps in current processes, as well as, manage the planning and forecasting needed to drive necessary changes for future success. In this session, learn when to incorporate project management best practices that can help you get the best out of your team.
Use of technology in an audit of financial statements - Risk Assessment
-
Online
2.00 Credits
How technology can help auditors improve efficiency, effectiveness and quality [bold] Auditors are perpetually in pursuit of enhancing the efficiency and effectiveness of their audits while upholding consistently high standards of quality. The integration of technology into the audit process can seamlessly accomplish these objectives. Join us as we delve into the insights of two distinguished members of the AICPA Auditing Standards Board's Technology Working Group, including its chairperson. You'll learn how technology can empower auditors to navigate the escalating demands of modern audits, particularly in the face of overwhelming data volumes, by harnessing available tools. Our presenters discuss common reasons auditors may resist using technology and why those reasons, even more commonly, are not always valid. Once you have an understanding that overcoming barriers to entry is possible, the Technology Working Group experts will guide you through the audit process. You'll explore key junctures where automated tools, techniques and commercial software solutions can revolutionize your audit methodology for the better. Our presenters then return to examine, in detail, how technology can help auditors during one of the most important steps in the process, the risk assessment. Highlighting benefits to efficiency and effectiveness, the new AICPA practice aid "Use of technology in an audit of financial statements" is the focus. Part I of this evolving practice aid takes a deep dive into risk assessment procedures. Walking through examples allows you to see how the guidance in the practice aid can assist in your daily work.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Eight Biggest Threats to your business and introducing Three Pillars of Cybersecurity
-
Online
1.00 Credits
Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes. By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around.
Contract and Procurement Fraud
-
Online
2.00 Credits
This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction. The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims. Within each phase, “red flags” will be discussed. These are the indicia of possible fraud that managers should be alert for. Also, within each phase, the most common fraud schemes will be highlighted and discussed. Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur. This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.