CPE Catalog & Events
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
The major topics that will be covered in this class include:Financial functions best practices for creating amortization schedules and calculating annual interest paymentsCalculating & summarizing data with SUMIF and SUBTOTAL functions Statistical functions used to analyze data
Power BI - Use Power Query to Transform Your Data
-
Online
2.00 Credits
Append files Combine multiple files from a folder Add custom columns Unpivot a table Create a lookup table from a table
Surgent's International Tax Challenges and Opportunities for U.S. Filers
-
Online
3.00 Credits
Residency status for U.S. federal income tax purposes Key provisions of U.S. income tax treaties Overview of the taxation of income from foreign entities Understanding Foreign Tax Credit Identifying foreign-source and U.S.-source income Foreign earned income and housing exclusion Foreign informational form filing requirements
Auditing, SSARS and Attest Update
-
Online
2.00 Credits
The major topics covered in this course include:Recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services CommitteeRecently issued New Quality Management StandardsHighlight of projects in progress at the Public Company Accounting Oversight Board and International Auditing and Assurance Standards BoardRecap of recent changes and present common peer review findings and best practices to improve practice quality
Audit 203: Auditing Accounts Receivable - Common Risks
-
Online
2.00 Credits
The major topics covered in this course include:Typical risks of material misstatement related to accounts receivablePractice tailoring the detailed audit plan to the assessed risk of material misstatementOverview of more complex issues, such as methods for converting accounts receivable to cashExternal confirmation audit considerations, including evaluating responses for proprietyEvaluating the valuation of accounts receivable
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
IRS Highly Effective Penalty Relief Strategies
-
Online
1.00 Credits
The major topics covered in this course include:The basis for penalty reliefDiffering options for penalty reliefEmploying an effective strategy using different forms of penalty reliefAppealing any proposed rejectionsA clever penalty relief strategy for full pay case
ChatGPT: What Every CPA Should Know-Updated
-
Online
2.00 Credits
The major topics covered in this course include:Overview of the current landscape for AI in businessHistory of ChatGPT and generative AIFundamentals of generative AI technology and related nomenclatureABC's of how to use ChatGPTDemonstration of practical ChatGPT applications for accounting, finance and taxA word of caution: What you should be concerned aboutDeveloping a ChatGPT usage policy for your firm / business
Tales from the Darkside: IRS Enforcement of Cryptocurrency
-
Online
2.00 Credits
The major topics covered in this class include:Overview of Bitcoin and cryptocurrenciesDefinition of proof of work and proof of stakeTax laws regarding cryptocurrency transactionsDefinition of common money laundering laws involving cryptocurrenciesTools used by the IRS to identify cryptocurrency transactions and cryptocurrency in criminal investigationsReal life examples of cryptocurrency used in criminal activities
Estate & Trust Primer - Tax Staff Essentials
-
Online
4.00 Credits
Types of trusts Trustee powers Recognition and realization of income Elements of an estate Taxation of trusts and estates Basic concepts of estate planning
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
The major topics that will be covered in this class include:Learning the art of nesting formulasTechniques to troubleshoot complex formulas Review of the 9 built-in error checking optionsTechniques to resolve rounding errors
Surgent's Artificial Intelligence for Accounting and Finance Professionals
-
Online
2.00 Credits
What is artificial intelligence? What are the different forms of artificial intelligence? The difference between artificial intelligence and machine learning The types of problems artificial intelligence can solve The role of algorithms How artificial intelligence will affect accounting and finance careers Data governance, security, and privacy How accounting firms are using AI today The role of artificial intelligence in asset management
Surgent's Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
Online
2.00 Credits
S corporation earnings layers Observations on earnings layers S corporation basis calculation IRC 351 transactions Four loss tiers Appreciated property distributions
Surgent's Ethical Considerations for the CPA
-
Online
4.00 Credits
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Tax Season Update for Individuals with Steve Dilley
-
Online
4.00 Credits
The major topics covered in this class include:2021/22 legislative developments, cases and rulings impacting individual taxpayersChanges to Form 1040 and other related forms, worksheets and schedulesIndividual income items, itemized deductions and creditsUpdated tax rate schedule and other inflation adjusted itemsImplications for self-employed taxpayers of various legislationSection 199A changes, including use of carryforward passive activity and 199A lossesCapital gains and lossesPassive activity and hobby loss rules changes
Audit 204: Auditing Basic Inventory - Focus on Observations
-
Online
2.00 Credits
The major topics covered in this course include:Typical inventory observation procedures and special considerationsHandling various inventory observation real-life scenariosHigh level overview of valuation and pricing methodsKey controls related to inventory
Understanding the Form 990 and its Preparation Prerequisites
-
Online
2.00 Credits
The major topics that will be covered in this class include:Overview of the Form 990's design and goals in play upon the Core Form and tack-on SchedulesAddress of the definition's key factors that make a third-party organization a "related organization"Exploring the definitions of parties who are to be disclosed as managers at Part VII-A (i.e., as a TDOKE -- a Trustee/Director (TD)/Officer (O)/Key Employee (KE) ƒ?" or as a High 5) and understanding what is the definition and measure of "reportable compensation"Working with the definitions of "family member" and "independence" as same are used in Parts VI and Schedule LApplying the definition of "business relationship" as same is used in Part VISequencing of the form's preparation tasks and who to go to for informationWorking with the Board of Directors to have them understand what the completed Form 990 conveys to the public/regulators
Surgent's IRS Tax Examinations and Hot Issues
-
Online
4.00 Credits
Coverage of the Inflation Reduction Act of 2022 Criteria that the IRS uses to select returns for examination Vehicles, meals, and virtual currency considerations Worker classification determinations on who is an employee and who is an independent contractor S corporation officer’s reasonable compensation issues Responsibilities to pay the employment taxes when the business defaults Tax-related identity theft procedures
Surgent's S Corporation Taxation: Advanced Issues
-
Online
4.00 Credits
Detailed rules governing basis in the shareholder’s debt and stock AAA Built-in gains incurred from the sale of assets Redemptions and liquidations Compensation planning for shareholders, including planning strategies under the SECURE Act Tax Cuts and Jobs Act of 2017 and the various stimulus acts, as applicable
Illicit to Essential: Marijuana & Hemp/CBD Evolving Issues
-
Online
2.00 Credits
The major topics covered in this course include:Fast-paced discussion of what has been learned in other more mature markets like Colorado, Oregon and CaliforniaDiscussion of what to expect in emerging markets where there is currently only medical access to cannabis or recent state legal regulatory access to recreational cannabisThe state of Colorado will be used as an example of cannabis economics and regulatory oversight