BEGIN:VCALENDAR VERSION:2.0 PRODID:-//South Carolina Association of CPAs - ECPv6.15.18//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:South Carolina Association of CPAs 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:20250309T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20251102T060000 END:STANDARD 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 END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205817Z LAST-MODIFIED:20250606T044815Z UID:10005201-1782820800-1782820800@sc.cpa SUMMARY:(SSAA493/26) Surgent's Disclosure Requirements for SEC Form 8-K DESCRIPTION:Event Description\nThis course provides an overview of the disclosure requirements for SEC Form 8-K\, the broad form used to notify investors in U.S. publicly traded companies of certain events that may be important . This course provides an overview of the key disclosure requirements for several of the triggering events requiring the filing of a Form 8-K with the SEC. This course also provides information about how the Form 8-K requirements have evolved over time. \nDesigned For\nFinancial practitioners who want an overview of the disclosure requirements for a Form 8-K \nObjectives\nRecognize the overall purpose of the Form 8-K Identify the filing deadline for Form 8-K triggering events Identify triggering events that require the filing of a Form 8-K Recognize overall disclosure requirements for a Form 8-K \nMajor Subjects\nThe overall purpose of the Form 8-K Triggering events for filing the Form 8-K Filing deadline for the Form 8-K \nInstructions\nNone URL:https://sc.cpa/event/ssaa493-26-surgents-disclosure-requirements-for-sec-form-8-k/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205909Z LAST-MODIFIED:20250606T043306Z UID:10005202-1782820800-1782820800@sc.cpa SUMMARY:(SSET401/26) Surgent's Ethical Considerations for CPAs DESCRIPTION:Event Description\nAs accounting firm’s non-attest offerings to their attest clients become more diversified\, such engagements increase firms’ exposure to independence violations. In order to thread the needle of providing value-added services and upholding their independence obligations\, firms need to have a strong foundational understanding of the applicable ethical and independence rules which govern these engagements. In this course\, we’ll review the relevant sections of the AICPA Code of Professional Conduct regarding independence\, objectivity\, and conflicts of interest. The course will focus on the Code’s Independence Rule and common threats to auditor’s independence. In particular\, the course will focus on those unique considerations related to non-attest services\, both from the perspective of AICPA interpretations and other applicable rules and regulations. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. \nDesigned For\nAll CPAs \nObjectives\nIdentify the key sources of guidance on auditor independence Recall key components of applicable independence guidance from the AICPA\, SEC and other regulators Assess independence risks related to common client situations \nMajor Subjects\nAuditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations \nInstructions\nNone URL:https://sc.cpa/event/sset401-26-surgents-ethical-considerations-for-cpas/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205910Z LAST-MODIFIED:20250606T044817Z UID:10005203-1782820800-1782820800@sc.cpa SUMMARY:(SSTX581/26) Surgent's Weekly Expert Hour (Original Air Date: 10/28/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\nBe well informed on current topics impacting taxes\, finance\, and industry \nMajor Subjects\nDetails of the Build Back Better framework announced by President Biden (as of 10/28/21) The IRS’ responses to questions about rehires following bona fide retirement and in-service distributions Employee Retention Tax Credit 2020 and 2021 legislation Medicare plans\, parts\, and costs \nInstructions\nNone URL:https://sc.cpa/event/sstx581-26-surgents-weekly-expert-hour-original-air-date-10-28-21/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205911Z LAST-MODIFIED:20250606T043308Z UID:10005204-1782820800-1782820800@sc.cpa SUMMARY:(SSTX494/26) 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\nUnderstand changes in state statutes\, regulations and case law Determine how the states will treat changes under the Tax Cuts and Jobs Act Identify areas that may require additional attention for state tax planning purposes Identify areas that may be costly for employers or clients Understand the who\, what\, when\, and where of nexus for income and sales tax \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/sstx494-26-surgents-the-essential-multistate-tax-update/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205913Z LAST-MODIFIED:20250606T044818Z UID:10005205-1782820800-1782820800@sc.cpa SUMMARY:(SSTX446/26) Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit DESCRIPTION:Event Description\nThe IRS believes\, perhaps with some justification\, that many workers classified as independent contractors are actually employees and should be treated as such for tax purposes. The result is that worker classification audits are frequent and often costly for business clients\, both in terms of time as well as money expended. This program prepares tax practitioners to assist their clients with worker classification audits\, and to avoid them if possible\, by discussing and explaining the circumstances under which workers will most likely be characterized as employees or as independent contractors. The program also deals with the first line of defense against the IRS in worker classification audits – Section 530\, as well as the common law factors distinguishing an employee from an independent contractor. This program also explores the IRS Voluntary Classification Settlement Program and discusses whether a practitioner should advise a client to request admission into this program. \nDesigned For\nAny tax practitioner who wishes to help their clients avoid having independent contractors reclassified by the IRS as employees and any tax practitioner whose clients currently use independent contractors rather than employees \nObjectives\nAdvise clients with respect to the risks associated with their treating workers as independent contractors rather than employees Understand how to employ Section 530 for purposes of defending against an IRS allegation that one or more workers are employees and not independent contractors \nMajor Subjects\nThe 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use Section 530 as a defense in worker classification audits What is “industry practice” for Section 530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program advantages and disadvantages \nInstructions\nNone URL:https://sc.cpa/event/sstx446-26-surgents-employee-vs-independent-contractor-achieving-success-in-a-worker-classification-audit/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205915Z LAST-MODIFIED:20250606T043310Z UID:10005206-1782820800-1782820800@sc.cpa SUMMARY:(SSOT409/26) Surgent's Business Law Essentials for Practitioners and Controllers DESCRIPTION:Event Description\nThis course covers basic legal principles that every accountant should be familiar with to avoid common legal disputes and costly litigation. By analyzing business law issues from the standpoint and background of accountants and auditors\, this course will help you develop an approach to client and practice issues with a sensitivity and appreciation for potential legal ramifications. \nDesigned For\nAll practitioners and controllers who want a better understanding of how the law can impact their practice and their clients \nObjectives\nIdentify the most common legal issues arising in the business context State the general legal rules applicable to business situations Recognize the role that accountants can play in identifying and resolving legal problems Identify compliance aspects of different entity types \nMajor Subjects\nContract principles Partnerships and limited liability entities Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Intellectual property Real property law Bankruptcy basics Environmental Law Merger Basics \nInstructions\nNone URL:https://sc.cpa/event/ssot409-26-surgents-business-law-essentials-for-practitioners-and-controllers/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205917Z LAST-MODIFIED:20250606T043313Z UID:10005208-1782820800-1782820800@sc.cpa SUMMARY:(SSTX487/26) Surgent's Taking Advantage of Like-Kind Exchanges DESCRIPTION:Event Description\nWhen real property is sold for a gain\, we always try to find ways to defer recognizing income so that it won’t be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as a “like-kind exchange.” Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision. \nDesigned For\nAccounting and Finance Professionals who either represent or work for entities that own real property \nObjectives\nUtilize the provisions of IRC Sec 1031 in order to defer recognizing gain on the sale of real property via a like-kind exchange \nMajor Subjects\nUnderstanding the history of IRC Sec 1031 Who does and does not qualify for utilizing the like-kind provisions Which properties do and do not qualify for like-kind exchanges The differences between a dealer and a non-dealer regarding like-kind exchanges How to complete a like-kind exchange The different types of like-kind exchanges The definition of boot and how it applies to like-kind exchanges Rules concerning Revenue Ruling 72-456\, and Form 8824 \nInstructions\nNone URL:https://sc.cpa/event/sstx487-26-surgents-taking-advantage-of-like-kind-exchanges/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205919Z LAST-MODIFIED:20250606T043315Z UID:10005210-1782820800-1782820800@sc.cpa SUMMARY:(SSOT418/26) Surgent's Contract Law for Accounting and Finance Professionals DESCRIPTION:Event Description\nAccounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors\, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability\, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts. \nDesigned For\nAnyone in the accounting or financial service professions who seeks to gain a better understanding of contract law and how it intersects with their profession \nObjectives\nRecognize the elements required to create a valid contract Understand common techniques to enforce a contract Be well versed in the rules of contract interpretation Understand defenses used to prevent contract enforcement Explain remedies that are available to a party enforcing a contract \nMajor Subjects\nContract formation The necessary components of an enforceable contract Common defenses to enforcement Legal capacity requirements Contract interpretation \nInstructions\nNone URL:https://sc.cpa/event/ssot418-26-surgents-contract-law-for-accounting-and-finance-professionals/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205921Z LAST-MODIFIED:20250606T044823Z UID:10005211-1782820800-1782820800@sc.cpa SUMMARY:(SSMG417/26) Surgent's Engaging and Managing Young Professionals DESCRIPTION:Event Description\nYounger professionals comprise a significant part of the accounting and finance workforce. Whether you are an owner of a small accounting practice or a manager in a multinational accounting firm\, it is important to understand the characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding young professionals are unfounded and counterproductive. This course provides an understanding of who young professionals are in comparison to their predecessors\, the Gen-Xers and baby boomers. Equally important\, the presentation will look at common myths regarding young professionals and why understanding this class of employees provides opportunities for your organization to grow and succeed. \nDesigned For\nAccounting and finance professionals who wish to better engage with employees and customers who comprise this ever-growing demographic \nObjectives\nUnderstand how managing younger professionals allows organizations to grow and reduce turnover Understand how other organizations are attracting and retaining this segment of the workforce Use research to learn younger professionals’ expectations\, strengths\, and motivations \nMajor Subjects\nCharacteristics that are more dominant among younger working professionals and what distinguishes them from other sectors of the workforce Changes younger professionals seek in the workplace Suggestions on engaging and developing younger workers Best practices by organizations who have successfully integrated younger professionals Expectations as to learning\, development\, and training Work environments and schedules School-to-work transitions Views on salary\, benefits\, and corporate ethics Whether younger professionals’ expectations are significantly different from any other generation Strengths younger professionals offer which set them apart from others Common myths pertaining to younger professionals Definitions of success \nInstructions\nNone URL:https://sc.cpa/event/ssmg417-26-surgents-engaging-and-managing-young-professionals/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205922Z LAST-MODIFIED:20250606T043309Z UID:10005212-1782820800-1782820800@sc.cpa SUMMARY:(SSAA491/26) Surgent's Fraud Basics: Protecting the Company Till DESCRIPTION:Event Description\nThe focus of this course is reducing the overall risk of fraud. To that end\, instruction will cover the factors that play a role in turning honest employees into fraudsters. Discussion will touch on integrity and ethics\, as well as how the reactions of people in certain situations may impact the prevalence of fraud. The course will also explore the dark net and cryptocurrency fraud. \nDesigned For\nCPAs in public practice and industry who wish to educate clients or colleagues on preventing fraud from occurring at the source \nObjectives\nRecognize the prevalence of fraud Understand the ways an organization may unintentionally cause fraud Identify the costs of fraud Comprehend how the new COSO framework for internal control focuses on fraud Grasp the importance of an internal control environment Understand how people may respond differently to certain factors See that there are many layers involved in fraud defense \nMajor Subjects\nThe price of fraud ACFE’s Report to the Nations and ancillary costs The current economy microeconomics and analysis COSO internal control framework\, particularly Principle 1 (integrity/ethics) and Principle 8 (fraud risk assessments) Power of morale shrinking the fraud triangle and employee motivation Why good folks go bad interesting findings and red flags \nInstructions\nNone URL:https://sc.cpa/event/ssaa491-26-surgents-fraud-basics-protecting-the-company-till/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205924Z LAST-MODIFIED:20250606T043311Z UID:10005214-1782820800-1782820800@sc.cpa SUMMARY:(SSTX667/26) Surgent's Weekly Expert Hour (Original Air Date: 9/26/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\nBe well informed on current topics impacting taxes\, finance\, and industry \nMajor Subjects\nThe Retirement Security Rule and fiduciary regulations IRS Notice 2024-63: Employer matching contributions made to retirement plans related to employee student loan payments Discussion of findings of the Treasury Inspector General for Tax Administration Updates to the IRS Form 1099-DA draft version \nInstructions\nNone URL:https://sc.cpa/event/sstx667-26-surgents-weekly-expert-hour-original-air-date-9-26-24/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205925Z LAST-MODIFIED:20250606T044830Z UID:10005215-1782820800-1782820800@sc.cpa SUMMARY:(SSOT446/26) Surgent's Time Management for Professionals DESCRIPTION:Event Description\nThe phrase “time management” is misleading. No one manages time. Instead\, we manage events in our lives which consume time. Like money\, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who “manage” or budget their time wisely often are more productive\, less stressed\, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still\, successful time management strategies vary based upon the personality\, motivation\, and discipline of each individual. This course provides simple\, practical\, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout\, which in turn improves the likelihood of achieving success in any endeavor. \nDesigned For\nAnyone in the accounting or financial service professions who seeks to gain a better understanding of strategies to improve time management \nObjectives\nRecognize how you use your time most effectively Understand your priorities when budgeting time Understand ways to schedule your time appropriately Manage external events that consume time Use strategies and tools to assist in properly managing time Be familiar with strategies for resolving time management problems \nMajor Subjects\nManaging interruptions The role of activity logs\, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan \nInstructions\nNone URL:https://sc.cpa/event/ssot446-26-surgents-time-management-for-professionals/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205926Z LAST-MODIFIED:20250606T043313Z UID:10005216-1782820800-1782820800@sc.cpa SUMMARY:(SSTX475/26) Surgent's Taking Advantage of Installment Sales DESCRIPTION:Event Description\nWhen real property is sold for a gain\, we always try to find ways to defer recognizing income so that it won’t be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as an “installment sale.” Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision. \nDesigned For\nAccounting and Finance Professionals who either represent or work for entities that own real property \nObjectives\nUtilize the provisions of IRC Sec 453 to defer recognizing gain on the sale of real property via an installment sale \nMajor Subjects\nHow does the IRC define an installment sale under IRC Sec 453? When can a taxpayer utilize the provisions of IRC Sec 453? When should a taxpayer utilize the provisions of an installment sale and when should it be avoided? How does the issue of a dealer vs. a non-dealer impact the use of the installment sale method? Reporting an installment sale when related parties are involved Calculating an installment sale How has the Tax Cuts and Jobs Act impacted the use of the installment sale method? \nInstructions\nNone URL:https://sc.cpa/event/sstx475-26-surgents-taking-advantage-of-installment-sales/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205927Z LAST-MODIFIED:20250606T044907Z UID:10005217-1782820800-1782820800@sc.cpa SUMMARY:(SSTX641/26) Surgent's Weekly Expert Hour (Original Air Date: 6/16/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\nBe well informed on current topics impacting taxes\, finance\, and industry \nMajor Subjects\nThe IRS “Dirty Dozen” list for 2022\, which include;potentially abusive arrangements that taxpayers should avoid Potential tax developments and legislation\, IRS proposed regulations\, and major rulings as of June 16\, 2022 Hybrid/asset-based long-term care insurance solutions \nInstructions\nNone URL:https://sc.cpa/event/sstx641-26-surgents-weekly-expert-hour-original-air-date-6-16-22/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205928Z LAST-MODIFIED:20250606T043317Z UID:10005218-1782820800-1782820800@sc.cpa SUMMARY:(SSTE411/26) Surgent's Data Analytics Readiness Series: Excel Tables DESCRIPTION:Event Description\nIn this one-hour course\, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables\, create structured references\, enter formulas\, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of statistics – descriptive statistics. Emphasis will be placed on mean\, median\, and standard errors.This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst; Apply skills learned to create and structure tables Determine the appropriate descriptive statistics to present them in a structured format Create structured references and understand their relation to formula creation Create formulas and apply troubleshooting techniques to formulas created \nMajor Subjects\nCreating a table Parts to a table Benefits of an Excel table Structured references How it helps to create formulas Formulas are column based not cell based Tables are data sources for Power Query Exercises- tables Creating a table Resizing a table Removing duplicates Descriptive Statistics using the Total Row Inserting a slicer Creating formulas using structured references \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste411-26-surgents-data-analytics-readiness-series-excel-tables/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205929Z LAST-MODIFIED:20250606T044908Z UID:10005219-1782820800-1782820800@sc.cpa SUMMARY:(SSMG410/26) 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\nMake better financial decisions that have a positive impact on the organization Lead the organization into the rapidly changing decade Apply what we have learned from recent economic and political changes to have a positive impact on the organization \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/ssmg410-26-surgents-gaining-a-competitive-advantage-critical-skills-for-cfos-and-controllers/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205931Z LAST-MODIFIED:20250606T043319Z UID:10005220-1782820800-1782820800@sc.cpa SUMMARY:(SSOT452/26) Surgent's Why People Quit: A Look at Accounting and Other Professionals DESCRIPTION:Event Description\nEmployee turnover has always been expensive\, and experts warn that the cost of employee attrition keeps rising. Tight labor markets\, a strong economy\, and increasingly collaborative jobs are just some of the explanations given for the high price of losing employees. While some of these “macro” factors are beyond an employer’s control\, there is substantial research showing practices employers can implement that encourage employees to remain and grow with an organization. So\, why do people quit? It is commonly thought that employees often leave their jobs because they do not like their boss\, they perceive low opportunities for growth\, or they are offered a better opportunity somewhere else. However\, new research reveals that what really affects career decisions are employees’ sense of how they are doing compared to their peers or where these individuals thought they would be at a certain point in life.This course provides an overview of how to improve employee retention. Whether you are a sole practitioner with one or two employees or part of a much larger organization\, this course will be valuable to you. \nDesigned For\nAccounting or financial service professionals who seeks to understand proven strategies for reducing employee turnover \nObjectives\nUnderstand strategies to reduce employee burnout Understand how an employee’s sense of how they are doing affects retention Be familiar with ways to offer incentives and growth opportunities that reduce turnover Recognize career stages at which an employee is more likely to leave \nMajor Subjects\nWhy employee retention matters Management’s thoughts on turnover Techniques employers use to retain and grow their employees Aspects of employment that matter most to employees Factors that contribute to employee turnover in accounting and finance professions \nInstructions\nNone URL:https://sc.cpa/event/ssot452-26-surgents-why-people-quit-a-look-at-accounting-and-other-professionals/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205932Z LAST-MODIFIED:20250606T044910Z UID:10005221-1782820800-1782820800@sc.cpa SUMMARY:(SSAA588/26) Surgent's Surging Auditors: Professional Skeptic DESCRIPTION:Event Description\nParticipants play the role of an auditor collecting information\, making inquiries\, and documenting findings around the audit of Home D‚cor and More. They develop professional skepticism skills as they analyze data obtained from an interview with Courtney the Controller\, comparing\, confirming\, and corroborating it against information provided by the CFO. Some things aren’t matching up and the player uses Courtney’s responses and their own questioning mind to consider the next step. They need to be alert to conditions that may indicate possible misstatement due to fraud or error\, and a critical assessment of the audit evidence to develop a sense of when things just don’t look right. \nDesigned For\nAccounting professionals in auditing needing to develop professional skepticism skills \nObjectives\nIdentify the importance of professional skepticism on engagements Recall ways to demonstrate professional skepticism on engagements \nMajor Subjects\nDemonstrating professional skepticism Assessing audit evidence Responding to contradictory evidence Assessing the sufficiency of audit evidence \nInstructions\nNone URL:https://sc.cpa/event/ssaa588-26-surgents-surging-auditors-professional-skeptic/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205934Z LAST-MODIFIED:20250606T044912Z UID:10005223-1782820800-1782820800@sc.cpa SUMMARY:(SSTX565/26) Surgent's Tax Forms Boot Camp: LLCs\, Partnerships\, and S Corporations DESCRIPTION:Event Description\nThe course provides a comprehensive\, hands-on\, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns\, along with the underlying laws\, regulations\, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be aware of. The theoretical concepts get illustrated in comprehensive examples that incorporate the most up-to-date law changes and provisions. \nDesigned For\nAll levels of staff and company controllers responsible for filing these forms \nObjectives\nLearn in detail about the preparation of Form 1120S\, Schedules M-1\, K\, and K-1 Learn in detail about the preparation of Form 1065\, Schedules M-1\, K\, and K-1 Identify and handle commonly found S corporation and partnership tax issues \nMajor Subjects\nCompare and contrast the tax consequences\, opportunities\, and pitfalls of operating a business as a partnership\, LLC\, or S corporation Reporting Requirements for Schedules K-2 and K-3 Form 7203\, S Corporation Shareholder Stock and Debt Basis Limitations Gain a comprehensive understanding of income tax laws for S corporations from eligibility and election to tax return preparation\, stock basis\, and loss limitation issues Recognize and properly handle special pass-through items of income and expense Accurately prepare S corporation returns and reconcile book income to taxable income Accurately prepare partnership returns and reconcile book income to taxable income What the transactional method entails and how to report partners’ capital accounts under this method Properly handle the tax treatment of distributions to shareholders\, partners\, or members Understand the special restrictions and sanctions for tax year-end selection Review the basics of partnership and LLC formation and basis calculation Self-employment tax or NOT\, for each entity Filling in K-1s correctly for S corporations\, partnerships\, and LLCs. Major changes in K-1 reporting on both partnership and S corporation forms and content The most frequently used forms and schedules\, including some form oddities \nInstructions\nNone URL:https://sc.cpa/event/sstx565-26-surgents-tax-forms-boot-camp-llcs-partnerships-and-s-corporations/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205935Z LAST-MODIFIED:20250606T043324Z UID:10005224-1782820800-1782820800@sc.cpa SUMMARY:(SSTX479/26) Surgent's Taking Advantage of Installment Sales and Like-Kind Exchanges DESCRIPTION:Event Description\nWhen real property is sold for a gain\, we always try to find ways to defer recognizing income so it won’t be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale: installment sales and like-kind exchanges. Knowing how and when to utilize these provisions makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals which could impact the future of these two provisions. \nDesigned For\nAccounting and Finance Professionals who either represent or work for entities that own real property \nObjectives\nLearn when and how to utilize the provisions of IRC Section 453 in order to defer recognizing gain on the sale of real property via installment sales Learn when and how to utilize the provisions of IRC Section 1031 in order to defer recognizing gain on the sale of real property via a like-kind exchange \nMajor Subjects\nHow does the IRC define an installment sale under Section 453? When can a taxpayer utilize the provisions of IRC Section 453? When should a taxpayer utilize the provisions of an installment sale and when should it be avoided How does the issue of a dealer vs. a non-dealer impact the use of the installment sale method How to report an installment sale when related parties are involved How to calculate an installment sale How has the Tax Cuts and Jobs Act impacted the use of the Installment Sale Method What is a like-kind exchange as defined by IRC Section 1031 When can a taxpayer utilize the provisions of IRC Section 1031 What types of real property are eligible for like-kind exchange treatment and what types are not What is boot and how does it impact the like-kind exchange deferral How to calculate a like-kind exchange including any taxable portion How has the Tax Cuts and Jobs Act impacted the use of like-kind exchanges \nInstructions\nNone URL:https://sc.cpa/event/sstx479-26-surgents-taking-advantage-of-installment-sales-and-like-kind-exchanges/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T205936Z LAST-MODIFIED:20250606T044913Z UID:10005225-1782820800-1782820800@sc.cpa SUMMARY:(SSAA566/26) Surgent's Performing a Compilation Engagement Under AR-C Section 80 DESCRIPTION:Event Description\nBe the go-to person for financial statement compilation engagements. Specifically designed for compilation practitioners and their staff\, this course will provide you with a hands-on application for performing compilation engagements under AR-C Section 80. You will learn the ins and outs of relevant sections of SSARS No. 21\, Clarification and Recodification\, the most significant change to the SSARS since their inception over thirty years ago. This course will bring you up to date on all SSARSs requirements and guidance as it relates to compilations\, including SSARS No. 25\, effective for 2021 reporting.The course will also provide an overview of the different services that an accountant can provide under the SSARS and review the requirements of AR-C Section 60 as it relates to compilation engagements. \nDesigned For\nAccounting practitioners and their staff performing and managing preparation and compilation engagement services \nObjectives\nIdentify differences in engagements performed under the SSARS Recall general requirements for all SSARS engagements Identify requirements for compilation engagements under AR-C Section 80 \nMajor Subjects\nRelevant sections of SSARS No. 21\, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22-25 Review of AR-C Section 60 requirements for all SSARS engagements Detailed guidance on performing compilation engagements under AR-C Section 80 \nInstructions\nNone URL:https://sc.cpa/event/ssaa566-26-surgents-performing-a-compilation-engagement-under-ar-c-section-80/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210006Z LAST-MODIFIED:20250606T043326Z UID:10005226-1782820800-1782820800@sc.cpa SUMMARY:(SSTE448/26) Surgent's Power Query Series: Merge Queries DESCRIPTION:Event Description\nA merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.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 eighth 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\nUnderstand what a merge query is and why it is so useful Recognize the data requirements for a merge query Be familiar with the types of joins for a merge query \nMajor Subjects\nWhat is a merge query? What are the data requirements for a merge query? What are the types of joins for a merge query? Hands-on examples: creating merge queries\, creating a full anti-join using an append query\, grouping queries \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste448-26-surgents-power-query-series-merge-queries/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210006Z LAST-MODIFIED:20250606T044915Z UID:10005227-1782820800-1782820800@sc.cpa SUMMARY:(SSTE410/26) Surgent's Data Analytics Readiness Series: Formulas\, Named Ranges\, and Formula Auditing DESCRIPTION:Event Description\nThis one-hour course will introduce users to table functions in Excel and Power BI. Users will demonstrate an ability to apply and utilize named ranges and naming conventions to data. Specific focus will be given to common formulas and functions within Excel. Common pitfalls in formula implementation will be discussed. Users will utilize exercises alongside an instructor to practice formula and function skills.This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst Apply formulas to existing data and debug errors in formulas Understand the importance of naming conventions in Excel tables Understand the basic formula language and implementation guidance and be able to apply that guidance to common formulas used in data analytics \nMajor Subjects\nNamed ranges- how they help in creating formulas Naming conventions and why they are important What you need to know to master formulas How to audit your formulas to limit errors Exercises- formulas Named ranges How to enter a formula- best practices to improve skill levels \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste410-26-surgents-data-analytics-readiness-series-formulas-named-ranges-and-formula-auditing/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210007Z LAST-MODIFIED:20250606T043329Z UID:10005228-1782820800-1782820800@sc.cpa SUMMARY:(SSTX649/26) Surgent's Weekly Expert Hour (Original Air Date: 5/16/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\nBe well informed on current topics impacting taxes\, finance\, and industry \nMajor Subjects\nOverview of Medicare in 2024 179D deduction New IRS guidance regarding the stock buyback tax \nInstructions\nNone URL:https://sc.cpa/event/sstx649-26-surgents-weekly-expert-hour-original-air-date-5-16-24/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210008Z LAST-MODIFIED:20250606T044916Z UID:10005229-1782820800-1782820800@sc.cpa SUMMARY:(SSAA573/26) Surgent's Quarterly Fraud Update (Original Air Date: 12/6/24) DESCRIPTION:Event Description\nFraud continues to be at record highs. According to NASDAQ’s Global Financial Crime Report\, fraud schemes and bank frauds led to global losses of over $485 billion. Four of the most cited frauds were customer fraud\, cybercrime\, asset misappropriation\, and bribery and corruption. From global banking giants to local charities and mom-and-pop shops\, no entities are immune from fraud\, even from their most trusted employees and leaders. It is critical for all organizations to learn fraud detection and prevention strategies to protect themselves from becoming the next fraud victims. CPAs and internal auditors must also learn how to detect fraud schemes before it’s too late. In this course\, we apply a case study approach to prepare you to spot fraud schemes that others have missed.In this quarterly fraud series\, follow our Surgent team as we explore and explain the latest fraud schemes and how accounting teams can better prevent and detect them. This course is designed to keep you up to date on the latest schemes and ways to protect your clients. \nDesigned For\nCPAs\, CFOs\, financial managers\, controllers\, and internal auditors who want to stay current on the latest fraud schemes and trends in prevention and detection methods \nObjectives\nUnderstand the latest fraud schemes Recognize red flags that could have identified the fraud scheme Understand the safeguards and controls that the entities could have used to prevent the fraud from occurring Apply the fraud triangle to gain a better understanding of the scheme \nMajor Subjects\nReview of case studies\, including the SEC X account hack\, the Starfish Transportation Inc. fraud\, and Morgan Stanley block trading leak Overview of red flags signalling fraud\, such as unusual trading patterns and inconsistent financial documentation Recommended preventative measures\, including increased whistleblower protections and regular compliance training \nInstructions\nNone URL:https://sc.cpa/event/ssaa573-26-surgents-quarterly-fraud-update-original-air-date-12-6-24/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210010Z LAST-MODIFIED:20250606T043334Z UID:10005230-1782820800-1782820800@sc.cpa SUMMARY:(SSAA435/26) Surgent's Lease Accounting: The Impact of Changing Standards on Both Lessors and Lessees DESCRIPTION:Event Description\nThe effective date for ASU 2016-02\, Leases (Topic 842) is finally here. The new standard eliminates one of the largest forms of off-balance sheet accounting and requires most leases to be brought onto the balance sheet irrespective of their classification as either financing or operating. The new guidance in ASC 842 also makes other changes in lease accounting for both lessees and lessors. This course will discuss the impact of these changing standards on both lessees and lessors and discusses recently issued updates to ASC 842. Now is time to get up to date on all that is going on with regard to lease accounting. \nDesigned For\nPracticing CPAs and accounting professionals in business and industry that prepare and review or audit financial statements \nObjectives\nIdentify finance lease transactions\, including both lessor and lessee perspectives Understand the proper accounting and financial reporting treatment for operating and finance leases Describe how lessor accounting is influenced by revenue recognition and measurement concepts Explain important transition issues from the current to new standards \nMajor Subjects\nOutcomes of the recent FASB and IASB Joint Project related to Leases Differentiating between accounting and reporting requirements for operating and finance leases Evaluating possible material misstatement related to lease recognition\, measurement\, presentation and disclosure \nInstructions\nNone URL:https://sc.cpa/event/ssaa435-26-surgents-lease-accounting-the-impact-of-changing-standards-on-both-lessors-and-lessees/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210011Z LAST-MODIFIED:20250606T044918Z UID:10005231-1782820800-1782820800@sc.cpa SUMMARY:(SSTE462/26) Surgent's The Latest and Greatest Excel Features DESCRIPTION:Event Description\nIn the ever-evolving world of data analysis and office productivity\, Microsoft Excel remains at the forefront\, continuously introducing new and powerful features. This comprehensive course is designed to familiarize participants with the most recent and significant updates in Excel as well as some old favorites. This course offers an in-depth exploration of these features\, ensuring learners can harness their full potential for the efficient and innovative use of Excel. \nDesigned For\nAll Excel users who want to use Excel more effectively and efficiently \nObjectives\nIdentify the key updates and enhancements in the latest version of Excel\, including their specific functionalities and how they contribute to improved efficiency and productivity in Excel Recognize the capabilities of new automation tools in Excel\, particularly those that are designed to streamline repetitive tasks and complex data analysis Recall how the fuzzy lookup add-in can be used for textual data matching in Excel \nMajor Subjects\nOverview of the latest updates in Excel\, focusing on their purpose and potential impact on efficiency and productivity New automation tools\, including features that streamline repetitive tasks and data analysis Fuzzy matching of textual data in Microsoft Excel Features that help to efficiently use data \nInstructions\nDownload the handout and practice material prior to the course URL:https://sc.cpa/event/sste462-26-surgents-the-latest-and-greatest-excel-features/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210012Z LAST-MODIFIED:20250606T043406Z UID:10005232-1782820800-1782820800@sc.cpa SUMMARY:(SSOT420/26) Surgent's Crowdfunding: A General Overview DESCRIPTION:Event Description\nIn the past\, entrepreneurs who sought investment capital for their start-ups were subject to the preferences and expectations of a small set of wealthy investors. These venture capitalists and angel investors often played the role of highly selective gatekeepers\, denying countless potential business leaders the opportunity to bring their well-thought ideas to market. Much has changed.Today\, crowdfunding disrupts many of the traditional models for start-up investing. Crowdfunding provides capital for new businesses by asking the general public for donations. The system works by entrepreneurs creating websites enabling internet users to view information\, photos and promotional videos explaining why they seek funding. Instead of receiving equity in the company\, investors are often rewarded for pledging their financial support for the start-up business. Despite the incredible growth in investment revenue from crowdfunding\, it remains underutilized by businesses. This course is intended to provide accounting and other professionals with a basic understanding of the crowdfunding process to better inform their clients and colleagues about this rapidly growing platform. \nDesigned For\nAnyone in the accounting or financial services profession who seeks to understand the crowdfunding process. Or\, accounting and financial professionals who counsel individuals who own or are considering starting a business that might benefit from crowdfun \nObjectives\nUnderstand how crowdfunding platforms work Understand the different types of crowdfunding campaigns Recognize strategies for building a successful crowdfunding campaign \nMajor Subjects\nHow crowdfunding works The different types of crowdfunding programs Popular crowdfunding platforms Strategies for building a crowdfunding community Creating a crowdfunding campaign Running a crowdfunding campaign \nInstructions\nNone URL:https://sc.cpa/event/ssot420-26-surgents-crowdfunding-a-general-overview/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210013Z LAST-MODIFIED:20250606T044920Z UID:10005233-1782820800-1782820800@sc.cpa SUMMARY:(SSTX465/26) Surgent's Handbook for Mastering Basis\, Distributions\, and Loss Limitation Issues for S Corporations\, LLCs\, and Partnerships DESCRIPTION:Event Description\nThe most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules. \nDesigned For\nAccounting and Financial Professionals who prepare both individual and flow-through business entity tax returns and need a thorough grasp of these significant issues. This course is a must to help reduce and avoid this exposure to malpractice. \nObjectives\nDetermine initial basis and organizing tax-free under §351 and §721 Understand what affects basis and how to treat distributions Pass the four loss limitation hurdles to deduct pass-through losses \nMajor Subjects\nTimely coverage of breaking tax legislation Applicable coverage of any basis considerations within any recent tax legislation Passthrough basis calculations required as attachments to certain individual returns Executor’s form for disclosing basis in certain distributed property; what about the basis of a property distribution from a trust How Section 179 limitations affect basis and how tax-benefit rule is applied Basis implications of personal assets converted to business use How to calculate basis of inherited qualified and joint tenancy property Tax basis capital account reporting requirements S corporations: Beware of final IRS regulations regarding open debt; determine how to calculate basis; worksheets are included; understand the effect of stock basis and debt basis and IRS’s recent focus on at-risk basis for shareholders; recognize how AAA applies or doesn’t apply to S corporations; learn to apply the complex basis ordering rules and special elections that can have a big tax result; discuss loss limitation rules in depth; when you can have a taxable dividend in an S corporation; understand distributions of cash and property; understand the post-termination transition rules\, and temporary post-termination rules for eligible corporations\, which will be important for S corps returning to C corps LLCs and partnerships: Learn the detailed rules of Section 704 for preventing the shifting of tax consequences among partners or members; learn to calculate basis under Section 704 for at-risk under Section 465; recognize how recourse\, nonrecourse\, and qualified nonrecourse debt can create significantly different tax results; learn the difference between basis and at-risk basis; review Section 754 step-up in basis rules; the economic effect equivalence test or dumb-but-lucky rule; learn to apply the complex rules of distribution of cash vs. property\, and the basis treatment of charitable contributions and foreign taxes paid \nInstructions\nNone URL:https://sc.cpa/event/sstx465-26-surgents-handbook-for-mastering-basis-distributions-and-loss-limitation-issues-for-s-corporations-llcs-and-partnerships/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260403T132228 CREATED:20250605T210015Z LAST-MODIFIED:20250606T043407Z UID:10005234-1782820800-1782820800@sc.cpa SUMMARY:(SSTE441/26) Surgent's Power Query Series: Introduction and First Connection DESCRIPTION:Event Description\nThis course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query\, using the Excel version. 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 first 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\nUnderstand what Power Query is and the benefits of using it Understand how to access Power Query \nMajor Subjects\nWhat is Power Query? Why should I learn Power Query? What are the benefits of using Power Query? Power Query is not just for Excel Power Query versions are not the same What version of Power Query do I have? How to get Power Query Making your first connection in Power Query Hands-on examples: connection query\, editing a query\, duplicating a query \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste441-26-surgents-power-query-series-introduction-and-first-connection/ CATEGORIES:Self-Study Video END:VEVENT END:VCALENDAR