BEGIN:VCALENDAR VERSION:2.0 PRODID:-//South Carolina Association of CPAs - ECPv6.17.2//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-ORIGINAL-URL:https://sc.cpa X-WR-CALDESC:Events for South Carolina Association of CPAs REFRESH-INTERVAL;VALUE=DURATION:PT1H X-Robots-Tag:noindex X-PUBLISHED-TTL:PT1H BEGIN:VTIMEZONE TZID:America/Detroit BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20260308T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20261101T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20270314T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20271107T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20280312T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20281105T060000 END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T023946Z CREATED:20260807T023945Z LAST-MODIFIED:20260807T023946Z UID:10006959-1814356800-1814356800@sc.cpa SUMMARY:(SSTX300/27) Surgent's Weekly Expert Hour (Original Air Date: 9/02/21) DESCRIPTION:Event Description\nAs financial and tax professionals well know\, information overload is a constant struggle we face because things change quickly\, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a new weekly series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients. We are all aware that the IRS\, along with other state and federal regulators\, is issuing guidance with increased frequency due to the coronavirus pandemic tax changes. New rules need to be analyzed\, dissected\, and explained more quickly than in days gone by so that our clients are kept informed of opportunities that may not last long. This weekly series will provide relevant and important tax and financial changes in a quick\, concise format. Each week\, Mike and his co-presenters will dispense news on current events impacting taxes\, finance\, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. Please Note: CFP credit is not available for this course in 2021. \nDesigned For\nFinancial professionals who wish to be up to speed on the latest news affecting themselves and their clients \nObjectives\n\nBe well informed on current topics impacting taxes\, finance\, and industry\n\nMajor Subjects\nS corporation PPP loan forgiveness Tax issues related to remote workers Family offices: an overview Investing in bitcoin and cryptocurrency \nInstructions\nNone URL:https://sc.cpa/event/sstx300-27-surgents-weekly-expert-hour-original-air-date-9-02-21/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024032Z CREATED:20260807T024030Z LAST-MODIFIED:20260807T024032Z UID:10006960-1814356800-1814356800@sc.cpa SUMMARY:(SSTX370/27) Surgent’s Weekly Expert Hour (Original Air Date: 5/15/25) DESCRIPTION:Event Description\nAs financial and tax professionals well know\, information overload is a constant struggle we face because things change quickly\, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients.Mike and his co-presenters will dispense news on current events impacting taxes\, finance\, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. \nDesigned For\nFinancial professionals who wish to be up to speed on the latest news affecting themselves and their clients \nObjectives\n\nBe well informed on current topics impacting taxes\, finance\, and industry\n\nMajor Subjects\nProposed provisions included in the “one big\, beautiful bill” Extension of TCJA provisions MAGA accounts Termination of federal clean energy tax credits \nInstructions\nNone URL:https://sc.cpa/event/sstx370-27-surgents-weekly-expert-hour-original-air-date-5-15-25/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024225Z CREATED:20260807T024225Z LAST-MODIFIED:20260807T024225Z UID:10006962-1814356800-1814356800@sc.cpa SUMMARY:(SSBM122/27) Surgent's Project Management for Finance Professionals DESCRIPTION:Event Description\nThe past few years have shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is an important part of every organization; however\, often companies do not differentiate between project management and operations management. Sometimes the finance professional is called upon to serve on a project team\, or in other cases is in a position to manage a project within the finance or accounting department. In either case\, he or she should be well versed in both the theory and practice of project management. While project management has probably been around since the time of building the pyramids\, the modern discipline started to take hold in large organizations in the late ’50s and early ’60s. From there it spread to smaller organizations to the point where almost any-sized organization can benefit from its ideas. This course is designed for the finance professional of the small and medium-sized organization. It is not meant for the experienced project manager of a large organization or the person wanting training for project management certification. In an effort to avoid talking theory without concrete examples\, we will often use examples born from projects needed as a result of recent changes in both economics and politics. \nDesigned For\nCFOs\, controllers\, and finance professionals \nObjectives\n\nUnderstand when and when not to apply project management thinking\n Know how to define success in a project\n Understand and manage the critical path of a project\n Understand the theory of constraints in project management\n Know how to both choose and lead people on the project team\n\nMajor Subjects\nProject management is a way of thinking and managing Identifying projects\, needs\, objectives\, and deliverables Project feasibility evaluation Life cycle of a project What causes projects to fail Establishing the project scope and preventing project creep Defining and managing stakeholders Organizational politics and conflict management Establishing the detailed schedule Introduction to project management software \nInstructions\nNone URL:https://sc.cpa/event/ssbm122-27-surgents-project-management-for-finance-professionals/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024227Z CREATED:20260807T024227Z LAST-MODIFIED:20260807T024227Z UID:10006963-1814356800-1814356800@sc.cpa SUMMARY:(SSTX109/27) Surgent's Advanced Critical Tax Issues for S Corporations DESCRIPTION:Event Description\nThis course goes beyond the basics and addresses important practical issues that an experienced practitioner must know. Even if you have attended other S corporation courses\, you will learn something new in this course. \nDesigned For\nAll practitioners and controllers who have attended a basic S corporation course and want to understand more complex issues and their practical implications \nObjectives\n\nUnderstand how stock basis\, AAA\, and other limitations are determined \n Appreciate how corporation planning can be used in an S corporation to change the effects of the one-class-of-stock rule\n Understand what S corporation issues are being debated with the Service\, settled in courts\, and guided by administrative decisions\n\nMajor Subjects\nInclusion of OBBBA (One Big Beautiful Bill Act) provisions that are germane to this course Final regulations on eligible terminated S corporations (ETSCs) Cases\, rulings\, and tax law changes affecting S corporations Compensation planning in S corporations\, including limitations in a family-controlled business; self-employment tax issues\, including IRS efforts to address underreporing of S corporation officer compensation Use of redemptions: still some advantages Planning for the liquidation of an S corporation Tax issues for family ownership of S corporation stock Impact of the tax on net investment income on sales of S corporation stock Stock basis: Loss limitations\, AAA\, and distribution issues in depth Debt basis: what the regulations on back-to-back loans mean to investors Estate planning for S corporation shareholders\, including buy-sell agreements\, QSubs\, ESBTs\, and uses of life insurance Built-in gains: the 5-year recognition period S corporation structuring: one class of stock Methods of accounting Legislation on mortgage interest reporting\, basis\, statute of limitations\, and tax return due dates New cases on revocation of S election in bankruptcy court and documentation of open account indebtedness and Chief Counsel Advice on carryover of losses for ESBTs \nInstructions\nNone URL:https://sc.cpa/event/sstx109-27-surgents-advanced-critical-tax-issues-for-s-corporations/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024315Z CREATED:20260807T024314Z LAST-MODIFIED:20260807T024315Z UID:10006964-1814356800-1814356800@sc.cpa SUMMARY:(SSTX318/27) Surgent's Weekly Expert Hour (Original Air Date: 1/06/22) DESCRIPTION:Event Description\nAs financial and tax professionals well know\, information overload is a constant struggle we face because things change quickly\, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a new weekly series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients. We are all aware that the IRS\, along with other state and federal regulators\, is issuing guidance with increased frequency due to the coronavirus pandemic tax changes. New rules need to be analyzed\, dissected\, and explained more quickly than in days gone by so that our clients are kept informed of opportunities that may not last long. This weekly series will provide relevant and important tax and financial changes in a quick\, concise format.Each week\, Mike and his co-presenters will dispense news on current events impacting taxes\, finance\, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. \nDesigned For\nFinancial professionals who wish to be up to speed on the latest news affecting themselves and their clients \nObjectives\n\nBe well informed on current topics impacting taxes\, finance\, and industry\n\nMajor Subjects\nThe status of the Build Back Better Act as of 1/6/22 IRS Letters 6419 and;6475 Update on disaster relief as of 1/6/22 Individual health insurance in 2022 \nInstructions\nNone URL:https://sc.cpa/event/sstx318-27-surgents-weekly-expert-hour-original-air-date-1-06-22/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024318Z CREATED:20260807T024317Z LAST-MODIFIED:20260807T024318Z UID:10006965-1814356800-1814356800@sc.cpa SUMMARY:(SSBM111/27) Surgent's Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers DESCRIPTION:Event Description\nAll organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs\, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate\, and that has proven to be the case in all areas of finance\, management\, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. Become the “financial hero” of your organization and make a positive impact on the bottom-line. \nDesigned For\nCFOs\, controllers\, and finance professionals \nObjectives\n\nMake better financial decisions that have a positive impact on the organization\n Lead the organization into the rapidly changing decade\n Apply what we have learned from recent economic and political changes to have a positive impact on the organization\n\nMajor Subjects\nLatest state of the economy Expense control that works Understanding our changing workforce and working environment Financial risk analysis Enterprise risk management Improving bank relationships \nInstructions\nNone URL:https://sc.cpa/event/ssbm111-27-surgents-gaining-a-competitive-advantage-critical-skills-for-cfos-and-controllers/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024412Z CREATED:20260807T024412Z LAST-MODIFIED:20260807T024412Z UID:10006966-1814356800-1814356800@sc.cpa SUMMARY:(SSTX378/27) Surgent’s Weekly Expert Hour (Original Air Date: 7/24/25) DESCRIPTION:Event Description\nAs financial and tax professionals well know\, information overload is a constant struggle we face because things change quickly\, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients.Mike and his co-presenters will dispense news on current events impacting taxes\, finance\, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. \nDesigned For\nFinancial professionals who wish to be up to speed on the latest news affecting themselves and their clients \nObjectives\n\nBe well informed on current topics impacting taxes\, finance\, and industry\n\nMajor Subjects\nChanges in the Tax Laws Impacting Gamblers HR-1: Bonus Depreciation HSA Changes in OBBB Act \nInstructions\nNone URL:https://sc.cpa/event/sstx378-27-surgents-weekly-expert-hour-original-air-date-7-24-25/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024413Z CREATED:20260807T024413Z LAST-MODIFIED:20260807T024413Z UID:10006967-1814356800-1814356800@sc.cpa SUMMARY:(SSTX247/27) Surgent's Buying and Selling a Business: Tax and Structuring Overview DESCRIPTION:Event Description\nOne of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients\, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs\, including controllers and executives in industry\, should understand how difficult the process of buying and selling a business has become. \nDesigned For\nAll practitioners who will be involved in the sale of a business \nObjectives\n\nUnderstand the CPA’s role in the beginning of the transaction and throughout the process\n Identify the different tax consequences for various forms of acquired businesses\n Identify the tax consequences for sellers of various forms of businesses\, including the impact of the net investment income tax (NIIT) and the Section 199A pass-through deduction\n Appreciate Section 338 and Section 338(h)(10) elections and the benefits of installment sales\n Understand the impact of Section Section 751\, 743\, 734\, and 754 on the purchase or sale of a partnership\n\nMajor Subjects\nComprehensive coverage of the One Big Beautiful Bill Act An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions\, including checklists of important points Deemed asset sales – Section 338 and Section 338(h)(10) The impact of the Section 197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the Section 199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill \nInstructions\nNone URL:https://sc.cpa/event/sstx247-27-surgents-buying-and-selling-a-business-tax-and-structuring-overview/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024417Z CREATED:20260807T024417Z LAST-MODIFIED:20260807T024417Z UID:10006968-1814356800-1814356800@sc.cpa SUMMARY:(SSAA106/27) Surgent's Audit Documentation Requirements DESCRIPTION:Event Description\nAudit documentation provides evidence that the audit was planned and performed in accordance with generally accepted auditing standards (GAAS) as well as applicable legal and regulatory requirements. It also serves a number of other purposes such as assisting the engagement team to plan and perform the audit\, assisting members of the engagement team responsible for supervision to direct and supervise the audit work and to discharge their review responsibilities. Audit documentation enables the engagement team to demonstrate that it is accountable for its work by documenting the procedures performed\, the audit evidence examined\, and the conclusions reached. As noted in the auditor’s opinion “The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error\, as fraud may involve collusion\, forgery\, intentional omissions\, misrepresentations\, or the override of internal control. Audit documentation also supports the judgments of the auditor should a lawsuit arise where the auditor is called on to support that professional standards were followed. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 1.) \nDesigned For\nProfessionals new to auditing \nObjectives\n\nDiscuss the minimum documentation requirements found in professional standards\n Discuss tips and techniques for self-review\n Describe common workpaper deficiencies\n Explain how to prepare workpapers in proper form\n\nMajor Subjects\nProper documentation as a means of audit quality Factors impacting the nature and extent of documentation Illustrative workpapers and exercises Use of practice aids and other mechanisms as means of audit documentation Checklist for self-review of workpapers \nInstructions\nNone URL:https://sc.cpa/event/ssaa106-27-surgents-audit-documentation-requirements/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024514Z CREATED:20260807T024514Z LAST-MODIFIED:20260807T024514Z UID:10006972-1814356800-1814356800@sc.cpa SUMMARY:(SSAA254/27) Surgent's Applying the Yellow Book to a Financial Statement Audit DESCRIPTION:Event Description\nA thorough understanding of the Yellow Book is essential for anyone working with governments and not-for-profits. This course provides comprehensive coverage of the Yellow Book financial auditing requirements and prepares you to excel in applying the standards. The course uses a highly illustrative and engaging format\, featuring 15 focused exercises designed to strengthen practical application and enhance working knowledge. \nDesigned For\nAuditors performing Yellow Book engagements \nObjectives\n\nThoroughly understand the Yellow Book\n Excel in the Yellow Book auditing arena\n Save time and improve performance on Yellow Book engagements via in-depth knowledge of the requirements\n\nMajor Subjects\nCircumstances requiring auditors to follow the Yellow Book (Government Auditing Standards or GAGAS) Relationship of Yellow Book requirements to GAAS and single audit requirements The Yellow Book requirements related to the performance of and reporting on a financial audit Identifying and reporting findings under the Yellow Book \nInstructions\nNone URL:https://sc.cpa/event/ssaa254-27-surgents-applying-the-yellow-book-to-a-financial-statement-audit/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024515Z CREATED:20260807T024515Z LAST-MODIFIED:20260807T024515Z UID:10006973-1814356800-1814356800@sc.cpa SUMMARY:(SSAA117/27) Surgent's Accounting for and Auditing Inventory DESCRIPTION:Event Description\nMany entities have inventory on their books. The types of inventory can range from simple resale of goods purchased to more complex inventories that use process costing. This module will discuss accounting for and auditing less complex inventories and provide an overview of issues associated with auditing more complex inventories. Inventory observations were covered in an earlier module. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 3.) \nDesigned For\nAccounting and auditing practitioners at all levels desiring to develop a detailed understanding of inventory accounting. \nObjectives\n\nRecall the elements of inventory costing\n Apply inventory valuation methodologies to various types of inventory\n Determine reserve methodologies for inventory obsolescence\n Recall issues related to consignment inventory\n Assess risk and perform audit procedures on less complex inventories\n\nMajor Subjects\nElements of inventory cost and full-absorption costing Valuation methodologies\, including LIFO\, FIFO\, weighted average\, and specific identification Obsolescence reserves Retail inventory valuation basics Physical inventory observation approach refresher Accounting issues related to consigned inventory Risk associated with and steps performed in auditing of inventories. \nInstructions\nNone URL:https://sc.cpa/event/ssaa117-27-surgents-accounting-for-and-auditing-inventory/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024520Z CREATED:20260807T024520Z LAST-MODIFIED:20260807T024520Z UID:10006974-1814356800-1814356800@sc.cpa SUMMARY:(SSTX140/27) Surgent's Guide to Partner Capital Account Reporting DESCRIPTION:Event Description\nAccounting and finance professionals are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This webinar covers exactly that. For accounting and finance professionals preparing partnership 1065 forms\, this course explains these complex rules in practical and understandable terms. \nDesigned For\nAccounting and finance professionals who will be preparing partnership income tax returns \nObjectives\n\nUnderstand how a partner determines and reports his or her tax basis capital account;\n\nMajor Subjects\nHow a partner’s outside basis and capital account differ Reconciling Schedule M-2 Form 1065 with Partnership K-1 Schedule L IRS requirement to report partner tax basis on the transactional approach Implications if a capital account is negative Deficit restoration accounts and qualified income offsets Modified outside basis method and modified previously taxed capital method Determining a partner’s beginning capital account; Beginning capital account for partnerships and partners consistently reporting on the tax basis The two types of adjustments under 754 and how 743 and 734 require different capital account presentations \nInstructions\nNone URL:https://sc.cpa/event/sstx140-27-surgents-guide-to-partner-capital-account-reporting/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024522Z CREATED:20260807T024522Z LAST-MODIFIED:20260807T024522Z UID:10006975-1814356800-1814356800@sc.cpa SUMMARY:(SSTE150/27) Surgent's Mastering the Excel Lookup Functions DESCRIPTION:Event Description\nIn today’s data-driven world\, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel\, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel’s lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course\, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you’re a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel’s full potential\, this course is tailored to meet your learning needs. \nDesigned For\nAny Excel user that wants to learn how to use the LOOKUP functions \nObjectives\n\nIdentify which lookup function works for your needs\n Distinguish between the many lookup functions\n Recall how to effectively utilize Excel’s lookup functions\n\nMajor Subjects\nA review of the various lookup functions\, beyond VLOOKUP Which lookup works best for your situation? How to apply the many lookup functions Advanced lookup techniques like nested lookups\, approximate matching\, and handling errors effectively An in-depth review of the following functions: VLOOKUP/HLOOKUP\, XLOOKUP\, MATCH / INDEX\, XMATCH\, INDIRECT\, FILTER\, SORT/SORTBY\, UNIQUE An overview of some newer functions \nInstructions\nNone URL:https://sc.cpa/event/sste150-27-surgents-mastering-the-excel-lookup-functions/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024523Z CREATED:20260807T024523Z LAST-MODIFIED:20260807T024523Z UID:10006976-1814356800-1814356800@sc.cpa SUMMARY:(SSTX346/27) Surgent’s Weekly Expert Hour (Original Air Date: 8/1/24) DESCRIPTION:Event Description\nAs financial and tax professionals well know\, information overload is a constant struggle we face because things change quickly\, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients.Mike and his co-presenters will dispense news on current events impacting taxes\, finance\, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. \nDesigned For\nFinancial professionals who wish to be up to speed on the latest news affecting themselves and their clients \nObjectives\n\nBe well informed on current topics impacting taxes\, finance\, and industry\n\nMajor Subjects\nDiscussion of the 2024 presidential race reset 2024 Tax Legislation Update Transfer and direct pay of energy credits \nInstructions\nNone URL:https://sc.cpa/event/sstx346-27-surgents-weekly-expert-hour-original-air-date-8-1-24/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024613Z CREATED:20260807T024613Z LAST-MODIFIED:20260807T024613Z UID:10006978-1814356800-1814356800@sc.cpa SUMMARY:(SSBM107/27) Surgent's Engagement and Client Retention Best Practices DESCRIPTION:Event Description\nPositive client relationships require work. Miscommunication\, unrealistic expectations\, and differing personality styles may strain a client’s relationship with professional advisors. Fortunately\, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help.This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm’s profitability. Yet automation\, for example\, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey\, ensuring consistent client interactions\, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business. \nDesigned For\nAccounting and finance professionals seeking to understand how to engage and retain clients \nObjectives\n\nCreate and implement a client retention strategy\n Create content to educate clients\n Track customer retention metrics\n Leverage employee engagement with clients\n Map your customer journey\n Understand the role of technology in improving client retention\n\nMajor Subjects\nManaging client expectations How automation improves client engagement Understanding the role of feedback systems Seeking referrals Building client loyalty Customer retention marketing Expanding services offered to clients Knowing when it is appropriate to enter new markets \nInstructions\nNone URL:https://sc.cpa/event/ssbm107-27-surgents-engagement-and-client-retention-best-practices/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024622Z CREATED:20260807T024621Z LAST-MODIFIED:20260807T024622Z UID:10006980-1814356800-1814356800@sc.cpa SUMMARY:(SSAA248/27) Surgent's Preparation and Compilation Engagements Under the SSARS DESCRIPTION:Event Description\nBe the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements\, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80\, respectively. You will learn the ins and outs of applying SSARS No. 21\, Clarification and Recodification\, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-24 and SSARS Nos. 26-27 by the ARSC. In addition to SSARS No. 26\, the entire suite of quality management standards is discussed.Most importantly\, you will be provided with practical examples and illustrations to help you effectively and efficiently perform those engagements\, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly\, the course will review recent peer review feedback on these types of engagements\, highlighting areas where you can improve engagement quality. \nDesigned For\nAccounting practitioners and their staff performing and managing preparation and compilation engagement services \nObjectives\n\nUnderstand and apply relevant sections of SSARS No. 21\, Clarification and Recodification\n Be familiar with guidance impacting preparation and compilation engagements that is contained in SSARS Nos. 22\, 23\, 24\, 26\, and 27\n Be familiar with preparation and compilation work program examples\n Be aware of the most recent reports and other required communications\n Keep abreast of relevant ARSC agenda items and projects\n Utilize hands-on examples and illustrations to increase your overall understanding and application of the material\n\nMajor Subjects\nRelevant sections of SSARS No. 21\, Clarification and Recodification SSARS No. 21\, Clarification and Recodification\, and updates to SSARS No. 21 due to the issuance of SSARS No. 23\, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22\, Compilation of Pro Forma Financial Information SSARS No. 24\, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26\, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services SSARS No. 27\, Applicability of AR-C Section 70 to Financial Statements Prepared as Part of a Consulting Services Engagement Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form\, specified line item\, pro forma\, and other engagement variations Complete illustrations of relevant engagement letters\, reporting\, and other required communications for preparation and compilation engagements \nInstructions\nNone URL:https://sc.cpa/event/ssaa248-27-surgents-preparation-and-compilation-engagements-under-the-ssars/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T024706Z CREATED:20260807T024706Z LAST-MODIFIED:20260807T024706Z UID:10006981-1814356800-1814356800@sc.cpa SUMMARY:(SSAA232/27) Surgent's Mastering the Basics of Inventory Accounting DESCRIPTION:Event Description\nWhile many entities maintain inventory\, they are often challenged when applying the complexities of inventory accounting. The goal of this course is to provide a detailed overview of inventory accounting concepts that can be applied to a variety of inventory types.The course will cover the basics of inventory capitalization\, for both book and tax\, as well as the basic inventory valuation methods\, LIFO\, FIFO\, weighted average\, and specific identification. Then the course will give a more detailed review of the LIFO and retail methodologies. It will cover the topics of inventory obsolescence reserves and other issues related to inventory accounting\, including a discussion of how COVID-19 has impacted these accounting considerations.This course will be the one-shop stop to get you up-to-speed on the accounting for this critical\, revenue-producing asset. \nDesigned For\nAccounting and auditing practitioners at all levels desiring to develop a detailed understanding of inventory accounting \nObjectives\n\nRecall the elements of inventory cost for book and income tax accounting purposes\n Apply inventory valuation methodologies to various types of inventory\n Determine reserve methodologies for inventory obsolescence\n Determine appropriate inventory observation approaches\n Recall issues related to consignment inventory\n\nMajor Subjects\nElements of inventory cost and full-absorption costing Valuation methodologies\, including LIFO\, FIFO\, weighted average\, and specific identification Obsolescence reserves LIFO accounting Differences between book and tax cost capitalization and related income tax accounting Retail inventory valuation methodology Physical inventory observation approaches Accounting issues related to consigned inventory Other challenging issues related to inventory accounting \nInstructions\nNone URL:https://sc.cpa/event/ssaa232-27-surgents-mastering-the-basics-of-inventory-accounting/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025005Z CREATED:20260807T025003Z LAST-MODIFIED:20260807T025005Z UID:10006982-1814356800-1814356800@sc.cpa SUMMARY:(SSAA199/27) Surgent's FASB Accounting Standards Update DESCRIPTION:Event Description\nDesigned to keep you up to date on recent activity of the Financial Accounting Standards Board (FASB)\, this course will summarize recently issued Accounting Standards Updates (ASUs) issued by the FASB in 2020 and 2021 year to date. The course will discuss the main provisions of the ASU\, application guidance\, and information on transition and the effective dates for the new ASU. This course is the place to go to stay current on all FASB-related matters. \nDesigned For\nAccounting and auditing practitioners at all levels desiring to remain up to date on recent pronouncements and other standard setters’ activities \nObjectives\n\nRecall recently issued ASUs of greatest significance to smaller and medium-sized entities\n Identify items on the FASB’s technical agenda\n\nMajor Subjects\nFASB Accounting Standards Updates issued in 2020 and 2021 to date Items on which the PCC is consulting; Projects on the FASB’s Technical Agenda \nInstructions\nNone URL:https://sc.cpa/event/ssaa199-27-surgents-fasb-accounting-standards-update/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025013Z CREATED:20260807T025011Z LAST-MODIFIED:20260807T025013Z UID:10006983-1814356800-1814356800@sc.cpa SUMMARY:(SSTX145/27) Surgent's Food\, Beverage\, and Entertainment Expensing DESCRIPTION:Event Description\nThe IRS has issued final regulations regarding the Tax Cuts and Jobs Act’s (TCJA) elimination of the deduction for expenditures related to entertainment\, amusement\, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. To effectively advise clients\, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment. \nDesigned For\nTax practitioners who anticipate advising clients with respect to employer meals and entertainment expenditures \nObjectives\n\nUnderstand the new rules relating to the deductibility of expenses associated with meals\, entertainment\, and food and beverages that employers provide to employees\n\nMajor Subjects\nThe 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment \nInstructions\nNone URL:https://sc.cpa/event/sstx145-27-surgents-food-beverage-and-entertainment-expensing/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025229Z CREATED:20260807T025228Z LAST-MODIFIED:20260807T025229Z UID:10006986-1814356800-1814356800@sc.cpa SUMMARY:(SSOT116/27) Surgent's Build Professional Relationships to Enhance Your Career-Authentic Networking DESCRIPTION:Event Description\nNetworking can be a game changer but is too often viewed as a self- promotion tool that is not natural for most people. When one flips the context and instead views it as a way to help and support others while also improving professional relationships and ultimately enhancing career opportunities\, the results are undeniable! This seminar provides participants with techniques to feel comfortable and confident in every networking setting from large conferences to one-on-one encounters. Both external and internal (within the company or firm) strategies are covered. \nDesigned For\nAnyone in the accounting or financial service professions interested in learning how to build and sustain long term professional relationships and connections for career success. \nObjectives\n\nUnderstand the three components of effective networking: preparation\, participation\, and follow-up;\n Know how to build a business network in the workplace and industry\n Understand the mechanics of retaining and reinforcing existing professional relationships\n\nMajor Subjects\nThe psychology of perception Preparation checklist for networking Presenting your best self Perception management Preparing oneself for networking Setting expectations and limits Seamless self-introductions How to introduce others Overcoming anxiety How to start conversations Situational questions The art of conversation flow Listening skills Topics to avoid Graceful exits Body language Navigating large events/conferences One-on-one meetings Cocktail party etiquette Remembering names Strategies for introverts Follow up recommendations How to maintain and sustain relationships long term \nInstructions\nNone URL:https://sc.cpa/event/ssot116-27-surgents-build-professional-relationships-to-enhance-your-career-authentic-networking/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025240Z CREATED:20260807T025240Z LAST-MODIFIED:20260807T025240Z UID:10006988-1814356800-1814356800@sc.cpa SUMMARY:(SSTE106/27) Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence DESCRIPTION:Event Description\nWe see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools\, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies\, or how important it is that companies embrace the opportunity to execute them correctly. Having conversations regarding the proper adoption of these technologies and tools is a crucial first step\, including drafting policies to assist companies with their beneficial and thoughtful implementation and use. This course will define the state of AI tools\, what benefits and risks exist\, and which steps to take to begin adopting these technologies with appropriate guardrails\, policies\, and training. It is less likely that AI will destroy industries\, and more likely that companies that embrace AI will overtake those companies that do not. \nDesigned For\nAccounting and finance professionals seeking to understand the role of AI tools today and in the future \nObjectives\n\nBe familiar with AI tools and the current status of AI tool development\n Be able to explain what ChatGPT is and how it works\n Understand how AI tools will change the accounting and finance professions\n Be able to explain the benefits and risks of adopting AI tools\n Begin drafting policies around AI implementation for your firm or company \n\nMajor Subjects\nWhat are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools \nInstructions\nNone URL:https://sc.cpa/event/sste106-27-surgents-the-risks-and-benefits-of-chatgpt-and-artificial-intelligence/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025243Z CREATED:20260807T025243Z LAST-MODIFIED:20260807T025243Z UID:10006989-1814356800-1814356800@sc.cpa SUMMARY:(SSAA207/27) Surgent's Government and Nonprofit Frauds and Controls to Stop Them DESCRIPTION:Event Description\nThe cost of fraud\, dearly paid by governments and nonprofits\, is too severe to not learn from past experiences. This course examines real-world fraud cases to uncover the lessons they provide and translate them into practical\, preventive controls. Using a highly illustrative and innovative format\, the course engages participants with over 15 focused exercises designed to build a strong working knowledge of fraud risks and effective anti-fraud controls. Whether you are an auditor or an industry professional\, you’ll gain actionable strategies to strengthen oversight\, reduce vulnerabilities\, and safeguard your organization. \nDesigned For\nAuditors and industry professionals working in the government and nonprofit environment \nObjectives\n\nIdentify common frauds occurring in governments and nonprofits today\n Skillfully develop controls to combat frauds\n Protect governments and nonprofits from fraud\n\nMajor Subjects\nExamine real-world misappropriations of cash\, check frauds\, vendor scams\, credit card abuse\, grant frauds\, benefit schemes\, inventory thefts\, and payroll frauds Identify and develop practical controls to prevent and detect fraud Tailor controls to the size and fit of the government or nonprofit \nInstructions\nNone URL:https://sc.cpa/event/ssaa207-27-surgents-government-and-nonprofit-frauds-and-controls-to-stop-them/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025317Z CREATED:20260807T025317Z LAST-MODIFIED:20260807T025317Z UID:10006990-1814356800-1814356800@sc.cpa SUMMARY:(SSTX192/27) Surgent's The Essential Multistate Tax Update DESCRIPTION:Event Description\nWith the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case\, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets\, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation\, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance. \nDesigned For\nAccountants who want an update on current multistate tax issues to minimize clients’ potential state and local tax liability \nObjectives\n\nUnderstand changes in state statutes\, regulations and case law\n Determine how the states will treat changes under the Tax Cuts and Jobs Act\n Identify areas that may require additional attention for state tax planning purposes\n Identify areas that may be costly for employers or clients\n Understand the who\, what\, when\, and where of nexus for income and sales tax\n\nMajor Subjects\nEmployees working in multiple states: Withholding issues (when to start and where to withhold) special issues depending on type of tax assessed in the state or locality Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers\, members\, partners\, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax \nInstructions\nNone URL:https://sc.cpa/event/sstx192-27-surgents-the-essential-multistate-tax-update/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025326Z CREATED:20260807T025325Z LAST-MODIFIED:20260807T025326Z UID:10006992-1814356800-1814356800@sc.cpa SUMMARY:(SSAA186/27) Surgent's Construction Contractors: Accounting and Financial Reporting Issues DESCRIPTION:Event Description\nAccounting and financial reporting for construction contractors may be the most difficult area to comply with the various standards. Construction engagements are\, in many instances\, more complicated than most lines of business due to the many users of the financial statements. In this course\, we will discuss why construction accounting and financial reporting is so complex and examine the relationship between the contractor and the surety\, both from an underwriting and a claims perspective. We will also explore what the surety looks for to maximize potential bond credit. \nDesigned For\nPractitioners who have construction clients and professionals in the construction industry who need to be up to date on the latest information \nObjectives\n\nRecognize accounting and financial reporting standards relevant to construction contractors\n\nMajor Subjects\nOverall landscape of the construction industry GAAP and recent changes affecting the construction industry FASB ASC 606 and its impact on the construction industry The unique relationship between the contractor and the surety FASB ASC 842 and its impact on the construction industry \nInstructions\nNone URL:https://sc.cpa/event/ssaa186-27-surgents-construction-contractors-accounting-and-financial-reporting-issues/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025330Z CREATED:20260807T025329Z LAST-MODIFIED:20260807T025330Z UID:10006993-1814356800-1814356800@sc.cpa SUMMARY:(SSAA227/27) Surgent's Goodwill Impairment - An Essential Guide DESCRIPTION:Event Description\nThis course provides an overview of goodwill impairment testing. This course focuses on topics such as the initial recognition of goodwill and subsequent measurement requirements including the accounting alternative allowed for certain eligible entities. This course also addresses the disclosure requirements for goodwill. \nDesigned For\nAccounting professionals \nObjectives\n\nIdentify the recognition requirements related to goodwill\n Recognize overall characteristics of goodwill impairment testing\n Differentiate between the qualitative and quantitative test of goodwill impairment\n Identify key characteristics of the accounting alternative for goodwill\n List the key disclosure requirements for goodwill and goodwill impairment losses\n\nMajor Subjects\nInitial recognition of goodwill Subsequent measurement requirements including the accounting alternative allowed for certain eligible entities Disclosure requirements for goodwill \nInstructions\nNone URL:https://sc.cpa/event/ssaa227-27-surgents-goodwill-impairment-an-essential-guide/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025410Z CREATED:20260807T025409Z LAST-MODIFIED:20260807T025410Z UID:10006994-1814356800-1814356800@sc.cpa SUMMARY:(SSTE141/27) Surgent's Power Query Series: Useful Transformations DESCRIPTION:Event Description\nThis course covers a number of useful transformations using Power Query (Excel version) to clean\, enrich\, and shape data. Coverage includes pivoting and unpivoting\, filtering and grouping\, fuzzy matching\, and more\, with hands-on exercises for users to practice these skills.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the ninth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\n\nBe familiar with various useful transformations available in Power Query\n\nMajor Subjects\nData before and after transformation: unpivoting\, pivoting\, split to column by delimiter (by columns or rows) Filtering and grouping Fuzzy matching Hands-on examples \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste141-27-surgents-power-query-series-useful-transformations/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025524Z CREATED:20260807T025524Z LAST-MODIFIED:20260807T025524Z UID:10006995-1814356800-1814356800@sc.cpa SUMMARY:(SSAA156/27) Surgent's Guide to the AICPA Quality Management Standards DESCRIPTION:Event Description\nWith only a few months to go before the AICPA’s Statement on Quality Management Standards 1\, 2\, and 3 (SQMS 1\, SQMS 2\, and SQMS 3\, respectively)\, SSARS No. 26\, SAS 146\, and SSAE 23 are required to be implemented\, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved.The Quality Management Suite of Standards must be implemented by December 15\, 2025. The standards modernize the firm’s approach to quality to reflect an increased focus on risk assessment\, technology use\, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach\, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control).The results of the firm’s risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards.We will cover how to perform a risk assessment\, including the key provisions of the standards\, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026. \nDesigned For\nAuditors in public accounting in a partner\, owner\, or managerial role \nObjectives\n\nIdentify key provisions of SQMS 1\, SQMS 2\, and SQMS 3\n Recall quality management provisions in SAS 146\, SSARS No. 26\, and SSAE 23\n Understand the role of firm leadership in establishing quality management standards\n Create a risk assessment\n Draft the new QM document\n Perform steps used in monitoring and the assessment of the firm’s System of Quality Management\n\nMajor Subjects\nQuality management standards SAS 146\, SSARS No. 26\, and SSAE 23 Risk assessment\, which forms the basis of the SQM Monitoring and evaluating the SQM \nInstructions\nNone URL:https://sc.cpa/event/ssaa156-27-surgents-guide-to-the-aicpa-quality-management-standards/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025525Z CREATED:20260807T025525Z LAST-MODIFIED:20260807T025525Z UID:10006996-1814356800-1814356800@sc.cpa SUMMARY:(SSAA278/27) Surgent's Understanding Derivatives and Hedge Accounting: A Simplified Guide for CPAs DESCRIPTION:Event Description\nThis course provides CPAs with a comprehensive understanding of derivatives and hedging in financial management. Participants will explore the fundamentals of derivatives\, their strategic role in risk management\, and the differences between hedge accounting and traditional accounting methods. The course specifically covers fair value\, cash flow\, and net investment hedges\, and discusses their practical applications. This course also addresses hedge accounting\, including designation\, documentation\, and effectiveness testing. \nDesigned For\nCPAs interested in derivatives and hedge accounting \nObjectives\n\nIdentify derivatives’ strategic role in financial risk management\n Recognize differences between hedge accounting and traditional methods\n Distinguish fair value\, cash flow\, and net investment hedges in practice\n Determine key steps in hedge accounting: designation\, documentation\, and effectiveness testing\n Diffenentiate how fair value\, cash flow\, and net investment hedges mitigate financial risks\n\nMajor Subjects\nCommon types of derivatives Hedging vs. Speculation Market risk\, credit risk\, liquidity risk \nInstructions\nNone URL:https://sc.cpa/event/ssaa278-27-surgents-understanding-derivatives-and-hedge-accounting-a-simplified-guide-for-cpas/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025548Z CREATED:20260807T025547Z LAST-MODIFIED:20260807T025548Z UID:10007001-1814356800-1814356800@sc.cpa SUMMARY:(SSBM127/27) Surgent's Planning and Strategy Formulation for Your Organization's Financial Success DESCRIPTION:Event Description\nHave you noticed that change is continuing to happen at a more and more rapid pace? Obviously\, some organizations survived change far better than others due to their ability to handle unexpected developments. Sick and tired of taking CPE that has no practical application or just regurgitates the same information over and over? Join us for this practical course\, which will present a fresh approach to planning and strategy formulation for your organization. Often thought of as a painful process\, planning and strategy formulation is probably one of the most important processes any organization undertakes in order to achieve financial success. We’ll explore this fresh approach to many different planning stages\, including the marketing plan\, the technology plan\, the capital plan\, the five-year operating plan and much more! The pandemic has shown us that our planning process must be far nimbler and allow our organization to shift rapidly. Today’s dynamic economic environment requires much more careful planning and strategy execution. Come find out how to make that happen for your organization. \nDesigned For\nCFOs\, controllers\, and finance professionals \nObjectives\n\nDevelop strategies for the organization that make an impact\n Avoid the political pitfalls that often come with the planning process and inhibit change\n Maximize the usefulness of the different plans developed for the organization\n Identify the differences between strategic and incremental planning\n Implement strategic planning at the department level\n Make the planning process enjoyable and painless for the entire organization\n Be familiar with the results of the case studies and exercises that reinforce key learning points throughout the course\n\nMajor Subjects\nDifferences between planning and budgeting Building change into the planning process The business model Strategic plan Marketing plan Financial forecasting Financial risk analysis Five-year operating plan \nInstructions\nNone URL:https://sc.cpa/event/ssbm127-27-surgents-planning-and-strategy-formulation-for-your-organizations-financial-success/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20270630T120000 DTEND;TZID=America/Detroit:20270630T120000 DTSTAMP:20260807T025551Z CREATED:20260807T025550Z LAST-MODIFIED:20260807T025551Z UID:10007002-1814356800-1814356800@sc.cpa SUMMARY:(SSAA196/27) Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality DESCRIPTION:Event Description\nWith the AICPA’s heightened focus on enhancing audit quality\, increased oversight of the peer review process and the auditor’s overall responsibility to provide high quality services\, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it’s easy to see why it’s more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor’s assessment of risk and linking the results of the assessment to substantive procedures performed. In addition\, auditors are not adequately documenting their consideration of fraud\, expectations in analytical procedures and the appropriate level of work needed to understand an entity’s internal control.The effective date for the AICPA’s Revised Quality Management Standards is fast approaching. Firms are required to implement the standards by December 15\, 2025. And the firm’s evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm’s existing QM document\, the standard requires a risk assessment process to identify risk and there are new quality objectives that are specified in SQMS 1-3. The AICPA further issued a SAS\, SSARS and SSAE that set forth requirements for quality at the engagement level. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards\, documentation requirements\, and best practices. We will address the new QM standards. \nDesigned For\nAccounting and auditing practitioners at all levels desiring to improve engagement quality \nObjectives\n\nIdentify key elements of the AICPA’s Enhancing Audit Quality initiative\n Recognize changes in Quality Management standards\n Recognize key trends in recent peer review deficiencies noted\n Identify professional standards related to performing a risk assessment\, understanding and testing internal controls\, and linking these procedures to further audit consideration\n Implement best practices to help ensure overall engagement quality \n\nMajor Subjects\nAICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews\, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Best practices in documentation \nInstructions\nNone URL:https://sc.cpa/event/ssaa196-27-surgents-avoiding-deficiencies-in-peer-reviews-focus-on-engagement-quality/ CATEGORIES:Self-Study Video END:VEVENT END:VCALENDAR