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:20260404T072813
CREATED:20250605T205513Z
LAST-MODIFIED:20250606T041808Z
UID:10005127-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX557/26) Surgent's Top Ten Questions from Partnership Clients Regarding the Section 754 Election
DESCRIPTION:Event Description\nThis program is an in-depth analysis of the Section 754 election and the two adjustments associated with the election under Section 743(b) and Section 734(b). The 754 election is a highly technical provision that provides great tax benefits to the owners of the partnership\, and particularly in the case of Section 743(b)\, a new partner. In this webinar\, our expert panel will cover the most common questions encountered by practitioners in their daily practices. The program includes a number of examples that provide insights into the mechanics of the two adjustments that follow upon a Section 754 election. \nDesigned For\nAccounting and financial professionals seeking to fortify their Section 754 knowledge base \nObjectives\nBe familiar with the practical issues surrounding Section 754 and its application    Effectively advise clients on these complex issues \nMajor Subjects\nHow does a partner compute his or her basis in a partnership?     What is the difference between a partner’s inside and outside basis?    What is the difference between a partner’s capital account and partner’s outside basis?    How does Section 732(d) impact the buyer of a partnership interest?    How does a partnership report a Section 754 election on the partnership’s tax return?    How does a partnership make a Section 754 election?    How does a partnership make a Section 743(b) adjustment?    How does a partnership make a Section 734(b) adjustment?    How is a Section 743(b) adjustment or Section 734(b) adjustment allocated to the assets of a partnership?    How is a Section 743(b) adjustment allocated within the class of ordinary income property and capital gain property? \nInstructions\nNone
URL:https://sc.cpa/event/sstx557-26-surgents-top-ten-questions-from-partnership-clients-regarding-the-section-754-election/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205514Z
LAST-MODIFIED:20250606T044511Z
UID:10005128-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA431/26) Surgent's Using the Work of a Specialist and Internal Audit
DESCRIPTION:Event Description\nDuring the audit of the financial statements\, an auditor will obtain evidence from many sources to support the account balances\, transactions\, and events that occurred during the period\, as well as the financial statement disclosures. This course discusses the use of management’s specialists\, the auditor’s specialists\, inventory counting services\, pricing services and internal audit. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 5.) \nDesigned For\nAccountants who have a basic level of audit experience \nObjectives\nIdentify the different types of specialists that can be used in a financial statement audit.     Describe the role that internal audit can play in a financial statement audit.    Identify the different roles that management specialists play and understand how auditors evaluate evidence obtained.     Identify the procedures the communications between an auditor and an auditor’s specialist \, the division of responsibility and the work to be performed by the auditor on information obtained.    Describe the role that a pricing service can plan in a financial statement audit and how the auditor should test the information. \nMajor Subjects\nUsing the work of management’s specialist    Using the work of the auditor’s specialist    Using the work of internal audit    Using the work of a pricing service \nInstructions\nNone
URL:https://sc.cpa/event/ssaa431-26-surgents-using-the-work-of-a-specialist-and-internal-audit/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205516Z
LAST-MODIFIED:20250606T041810Z
UID:10005129-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX571/26) Surgent's Advanced Trust Issues: A Roadmap for Success in An Increasingly Complex Area
DESCRIPTION:Event Description\nTrusts are not cookie-cutter documents. In fact\, they can be rather unwieldy\, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios\, what are the best trusts to use?  And how can the client be best protected? \nDesigned For\nTax practitioners who advise clients on the benefits of establishing a trust \nObjectives\nAdvise individual clients on the benefits of using a trust to achieve their personal goals    Save clients money in their estate planning \nMajor Subjects\nKey concepts of trusts\, including recent trends; best practices; jurisdiction; and ways to avoid pitfalls    Decanting    Federal estate tax exemption and remaining relevance of trusts    Irrevocable life insurance trusts    The role of family dynamics     Choice of trustee and other fiduciaries    State trust-friendly considerations    Charitable trusts    Delaware Statutory Trusts    Powers of attorne;    Pet Trusts  the emerging necessities    State\, county\, and local issues    Portability    QTIP issues    Creditor considerations    Potential IRA problems    Problems with re-titling assets \nInstructions\nNone
URL:https://sc.cpa/event/sstx571-26-surgents-advanced-trust-issues-a-roadmap-for-success-in-an-increasingly-complex-area/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205517Z
LAST-MODIFIED:20250606T044513Z
UID:10005130-1782820800-1782820800@sc.cpa
SUMMARY:(SSOT442/26) Surgent's Securing a Comfortable Retirement in the Age of Spending
DESCRIPTION:Event Description\nThis course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income will be required and strategizing about how to reach retirement goals. \nDesigned For\nCPAs looking to advise clients on retirement planning\, and CPAs looking for effective strategies for their own retirement \nObjectives\nHelp clients determine how much retirement income is necessary for the desired retirement lifestyle    Identify resources available for retirement    Explain how budgeting can determine retirement resources    Understand how to build the three-legged retirement stool through employer retirement\, savings\, and Social Security    Understand the need for Plan B when the ideal retirement goal is not achievable    Explain ways that clients can convert the equity in a home to retirement income    Explain how the value of a small business can be converted to retirement income    Explain survival possibilities and how first-to-die and last-to-die survival probabilities are used in retirement planning for married couples    Understand timing regarding the use of taxable retirement funds and nontaxable funds\, as well as strategies to minimize income tax on Social Security    Recognize the role of various investment types\, such as life insurance\, annuities\, mutual funds\, equity holdings\, and bonds in retirement planning    Summarize key points of recent research on the sustainability of retirement income and maintenance of desired retirement lifestyles \nMajor Subjects\nRetirement planning using variables such as desired lifestyle\, travel plans\, housing plans\, medical needs\, and family needs to customize a retirement plan unique to the client    Using a residence and other real estate as retirement assets through equity and rent    Using a small business as a retirement resource through creative retirement plans    Overview of asset allocation\, portfolio management\, portfolio rebalancing\, and investment selection concepts\, before and after retirement    The three-legged retirement stool: employer retirement\, savings\, and Social Security    Planning with the new retirement provisions of SECURE Act 2.0    Distribution/asset liquidation planning    Analysis of the most current/important research on retirement planning and sustaining retirement income levels \nInstructions\nNone
URL:https://sc.cpa/event/ssot442-26-surgents-securing-a-comfortable-retirement-in-the-age-of-spending/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205518Z
LAST-MODIFIED:20250606T041813Z
UID:10005131-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE407/26) Surgent's Data Analytics Readiness Series: Visualizations and Reporting
DESCRIPTION:Event Description\nThis one-hour course will serve as an introduction to data visualization and reporting using Power BI and Excel. Users will understand the benefits of using Power BI to create data visualizations and how Power BI differs from previous functions in Excel for visualizations. A hands-on exercise will be applied where the user will work alongside the instructor to create dashboarding for journal entry testing. Specific focus will be on the relation among various tools for data analytics: Power Query\, Power Pivot\, PivotTables\, DAX formulas\, and storyboarding.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;    Understand what data visualization tools are available in Excel and Power BI and how they are superior to previous Excel tools    Apply skills learned to create a dashboard for journal entry testing data    Apply skills to present the output of analytical modeling in an easy to interpret form and evaluate the output of the analytics    Be able to use the camera tool in Power BI to create dashboards \nMajor Subjects\nVisualization tools in Excel (camera\, slicers\, and timelines)    Data view- why it went away. Power BI is the visualization tool to use    All concepts learned in course are brought together in this last class to create a dashboard:            Power Query- to extract transform and load data for the dashboard        Power Pivot -to create the data model for the dashboard        DAX formulas- for pivot tables to calculate values needed for model        Pivot tables and charts- to create visualizations        Camera tool to create dashboard            Exercise- Using the data analytics workflow introduced in first class of series- to create dashboard for JE testing            Journal entry by month and income statement accounts        Descriptive statistics of journal entries        Number of journal entry by month        Journal entries by day of week        Round journal entries            Evaluate output of journal entry analytic            Other approaches        What are the false positives (noise)?            Next steps in data analytics journey \nInstructions\nInstall Power Pivot and Data Analysis ToolPak
URL:https://sc.cpa/event/sste407-26-surgents-data-analytics-readiness-series-visualizations-and-reporting/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205519Z
LAST-MODIFIED:20250606T044514Z
UID:10005132-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX554/26) Surgent's Advanced Individual Income Tax Return Issues
DESCRIPTION:Event Description\nMost accounting and financial professionals have been preparing individual income tax returns for years\, and while many of the returns are easy\, there are always a number of issues that come up in busy season of which experienced practitioners wish they had more knowledge. This course is designed to explore the tough tax issues for experienced practitioners and help them provide better planning strategies and results for their higher income clients. \nDesigned For\nExperienced Accounting and Financial Professionals who want and need an in-depth knowledge of the most difficult individual-income-tax-return issues \nObjectives\nUnderstand the basics of Section 199A    Understand how to properly report advanced transactions in financial instruments and investments    Understand the special problems and new issues for the current return    Identify the causes of alternative minimum tax liability and what can be done to reduce or eliminate it \nMajor Subjects\nNew issues for the current year tax return and Section 199A    Installment sales – understanding the complicated issues    Form 8582: Passive losses with carryovers – Complicated case with filled-in forms    Puts\, calls\, straddling\, and unusual investments – Understanding the tax laws and reporting them correctly on the tax return    Capital gain and loss issues – The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more    At-risk rules: What a return preparer really needs to know    Passive loss issues – You can’t just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right!    Incentive and nonqualified stock options – Reporting; key strategies for planning; dealing with the alternative minimum tax    Alternative minimum tax – Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client    Form 6251: Detailed calculation example \nInstructions\nNone
URL:https://sc.cpa/event/sstx554-26-surgents-advanced-individual-income-tax-return-issues/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205520Z
LAST-MODIFIED:20250606T041815Z
UID:10005133-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX593/26) Surgent's Weekly Expert Hour (Original Air Date: 8/05/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\nTax basis capital account reporting required for 2020 and after    Tax Pro Account    QR codes attached to IRS notices    1031 exchanges \nInstructions\nNone
URL:https://sc.cpa/event/sstx593-26-surgents-weekly-expert-hour-original-air-date-8-05-21/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205521Z
LAST-MODIFIED:20250606T044515Z
UID:10005134-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE409/26) Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform
DESCRIPTION:Event Description\nIn this one-hour course\, users will learn to apply Power Query to extract\, transform\, and load data for analysis. Users will learn how to manipulate data once it is loaded into the platform and will practice the manipulation during the course. Using the same data as the instructor\, users will perform an exercise to clean and transform a basic general ledger with an emphasis on preparing the data for analysis. 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 Power Query to extract\, transform\, and load (ETL) data    Understand and apply the basics of data cleaning    Understand what M Code is and how it is used    Apply ETL processes to a dataset \nMajor Subjects\nAn ETL tool- Extract Transform and Load    How Power Query ups your game in data analytics    Interface components of Power Query    Column level and table actions    Power Query is a sequential macro recorder    What is M Code?    Exercise- cleaning and transforming a general ledger \nInstructions\nInstall Power Pivot and Data Analysis ToolPak
URL:https://sc.cpa/event/sste409-26-surgents-data-analytics-readiness-series-data-preparation-using-get-and-transform/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205522Z
LAST-MODIFIED:20250606T041817Z
UID:10005135-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX589/26) 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\nBe well informed on current topics impacting taxes\, finance\, and industry \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/sstx589-26-surgents-weekly-expert-hour-original-air-date-9-02-21/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205524Z
LAST-MODIFIED:20250606T044516Z
UID:10005136-1782820800-1782820800@sc.cpa
SUMMARY:(SSOT402/26) Surgent's Coaching Skills for Managers and Supervisors
DESCRIPTION:Event Description\nThis one-day course will teach effective skills for coaching and training employees. You’ll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team\, with the goal of helping them improve morale\, productivity and quality. And\, you’ll learn a five-step approach for giving constructive criticism while managing defensive reactions. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 5.) \nDesigned For\nEmployees identified for advancement\, team leads\, supervisors\, and managers \nObjectives\nIdentify effective coaches and develop coaching strategies to support your team    Give constructive criticism while managing defensive reactions \nMajor Subjects\nThe definition of coaching and the coaching process    Characteristics of effective coaches    Coaching strategies to support and assist others as they change ineffective behaviors    Conducting one-on-one coaching sessions for setting goals and improving performance \nInstructions\nNone
URL:https://sc.cpa/event/ssot402-26-surgents-coaching-skills-for-managers-and-supervisors/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205525Z
LAST-MODIFIED:20250606T041820Z
UID:10005137-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA411/26) Surgent's A Guide to Auditing Common Investments
DESCRIPTION:Event Description\nMany small- and mid-size entities hold fewer complex investments including alternative investments. This module will provide an overview for evaluating the proper recognition\, measurement\, and disclosure of common investment types as well as how to audit them. Derivatives and other more complex investments will be discussed in another module. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 2.) \nDesigned For\nAccountants responsible for accounting for or auditing fewer complex investments\, including alternative investments. \nObjectives\nIdentify the proper accounting for common investments    Explain audit risks associated with auditing common investments    Discuss how to tailor the audit plan to assessed risks of material misstatement    Explain fair value; and other presentation and disclosure requirements \nMajor Subjects\nOverview of common investment types    Typical audit risks and related audit procedures    Alternative Investments    Fair value disclosure\, including applying the fair value hierarchy \nInstructions\nNone
URL:https://sc.cpa/event/ssaa411-26-surgents-a-guide-to-auditing-common-investments/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205526Z
LAST-MODIFIED:20250606T044516Z
UID:10005138-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA438/26) Surgent's Financial Reporting Update for Tax Practitioners
DESCRIPTION:Event Description\nTax advisors will be updated on the most recently enacted legislation and IRS guidance as well as updates of recent standard-setting activities at the FASB and AICPA. To start\, the course will review the significant tax\, financial accounting\, auditing\, accounting services\, and ethics guidance issued by standard setters over the past few years. The course will also focus on the unique income tax reporting  implications of recently issued accounting standards\, such as leases (ASC 842) and credit losses (ASC 326). The course then discusses the preparation of tax-basis financial statements. Lastly\, the course will dive into the unique income tax accounting considerations which arise from certain types of transactions\, such as stock-based compensation\, and review the presentation and disclosure requirements of ASC 740. \nDesigned For\nAll tax practitioners desiring to remain up-to-date on recent accounting\, reporting\, and compilation and review activities \nObjectives\nRecall recent legislation with income tax implications    Recognize recently issued Accounting Standards Updates (ASUs)    Understand updates to ASC 842 and ASC 326    Identify financial statement presentation and disclosure requirements under ASC 740    Remember significant standards issued by the AICPA \nMajor Subjects\nRecent standard setting and consulting activities at the FASB    Proposed updates to income tax accounting and financial statement disclosures    Tax basis financial statements    Recently issued Statements on Auditing Standards and other audit-related hot topics \nInstructions\nNone
URL:https://sc.cpa/event/ssaa438-26-surgents-financial-reporting-update-for-tax-practitioners/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205527Z
LAST-MODIFIED:20250606T041656Z
UID:10005139-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX551/26) Surgent's Social Security and Medicare: Planning for You and Your Clients
DESCRIPTION:Event Description\nSocial Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security\, and the myriad other related retirement planning issues. \nDesigned For\nPractitioners who have clients contemplating receipt of Social Security \nObjectives\nIdentify who is entitled to retirement benefits and in what amounts    Identify factors to consider in determining when to take benefits    Discuss taxation of Social Security benefits and how this impacts other income tax planning    Identify and describe the potential effects of retirement and estate planning strategies and tactics that can enhance overall retirement    Explain Medicare and the prescription drug provision; describe the basic supplementary insurance plans that are available to fill in the gaps in basic Medicare coverage \nMajor Subjects\nLegislative developments    A full chapter devoted to determining the best planning options for maximizing joint Social Security benefits    Retirement benefits: Amount of benefits in various circumstances; how the amounts are distributed within the family unit    Qualification: Has the client retired? How business entities may be used for Social Security advantage    Income taxation of Social Security: avoidance tactics    Spousal benefits: Should a spouse return to work? What benefits does a spouse have and when and how do they relate to benefits decisions by the client?    When can hiring the spouse increase overall benefits; Why should both spouses qualify for survivor benefits?    Disability benefits    When to start Social Security benefits: Advantages and disadvantages at ages 62\, full retirement age\, and 70    Coordinating benefits: Should you take Social Security first and higher-balance IRA distributions later\, or take IRA balances first and enhanced Social Security benefits later?    Pensions: Distribution strategies; how to use the minimum distribution rules in concert with Social Security benefits    IRAs: Is it time to convert to a Roth?    Medicare\, Part D prescription drugs: what retirees need to know \nInstructions\nNone
URL:https://sc.cpa/event/sstx551-26-surgents-social-security-and-medicare-planning-for-you-and-your-clients/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205529Z
LAST-MODIFIED:20250606T041703Z
UID:10005141-1782820800-1782820800@sc.cpa
SUMMARY:(SSMG428/26) Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs to Know
DESCRIPTION:Event Description\nStarting and owning a small business has often been referred to as the “Third Pillar of Wealth\,” right behind investments and owning real estate. Essentially\, all businesses start off as “small businesses.” Small businesses\, however\, require a large amount of preparation in order to successfully launch and grow. Starting a business requires the owners and managers to address a host of issues\, including an understanding of applicable laws\, appropriate financing\, staffing requirements\, marketing\, liability protection\, and many more.This course provides a broad overview of the critical issues business owners\, as well as their professional advisors\, must consider when starting and growing a small business.  There is extensive research regarding best practices in this area\, and this webinar is intended to distill down such information and focus on what is critical to get a small business up and running as seamlessly as possible. \nDesigned For\nAnyone in the accounting or financial services profession who seeks to understand proven strategies to establish and grow a small business or who counsels individuals who own\, or are considering owning\, a small business \nObjectives\nUnderstand how to successfully start and grow a small business or advise clients who are starting a small business    Understand basic legal issues that need to be addressed when forming a business    Explore marketing and financing plans to launch and develop a business    Recognize ways to protect business assets and owners from different forms of liability \nMajor Subjects\nUnderstanding the time commitment required to start and run a business    Selecting a corporate structure to protect your personal assets    Building your product or service    Sales and marketing in your business    Establishing your owners\, investors\, managers\, and employees    Accounting\, recording-keeping\, and other software programs    Leases\, contracts\, and employee agreements    Protecting intellectual property    Insurance    Business plans    Financing    Market position \nInstructions\nNone
URL:https://sc.cpa/event/ssmg428-26-surgents-starting-a-small-business-what-every-trusted-advisor-and-entrepreneur-needs-to-know/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205531Z
LAST-MODIFIED:20250606T041708Z
UID:10005143-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA445/26) Surgent's Accounting for Guarantees
DESCRIPTION:Event Description\nGuarantees are often included within certain purchase agreements\, sales agreements\, commercial agreements\, and many other types of agreements.  This course provides an overview of the accounting\, reporting\, and disclosure requirements related to guarantees.  The U.S. GAAP guidance related to guarantees is prescribed by ASC Topic 460. \nDesigned For\nCPAs in need of an overview of the accounting\, reporting\, and disclosure requirements related to guarantees. \nObjectives\nIdentify the primary types of guarantees    Recognize the guarantees that are within the scope of ASC Topic 460    Identify the recognition\, measurement\, and subsequent measurement requirements of guarantees    Recognize key disclosure requirements for guarantees \nMajor Subjects\nOverview of the accounting related to guarantees    Review of the reporting related to guarantees    Examination of the disclosure requirements related to guarantees \nInstructions\nNone
URL:https://sc.cpa/event/ssaa445-26-surgents-accounting-for-guarantees/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205532Z
LAST-MODIFIED:20250606T044519Z
UID:10005144-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX547/26) Surgent's Forms 1120-S and 1065 Return Review Boot Camp for New and Experienced Reviewers
DESCRIPTION:Event Description\nMost review techniques developed by professionals are self-taught and fine-tuned via experience. Yet how does one start? The purpose of this course is to give both new and seasoned reviewers additional and advanced procedures via a multitude of checklists to more thoroughly review S corporation and partnership tax returns. Its emphasis is not planning; rather\, it is to develop a strategy to properly review a return effectively and thoroughly. The course includes dozens of “practice tips for new reviewers” and is updated for impacts of newly enacted legislation. \nDesigned For\nSenior-level staff new to the review process or experienced staff members looking to update and/or expand their review procedures \nObjectives\nExpand the process involved in reviewing applicable tax returns    Identify the most common areas that result in errors    Document a review\, including consideration of risk management \nMajor Subjects\nReviews of portions of error-prone staff-prepared Forms 1120-S and 1065 from client-provided information    What are common errors preparers make and what are the areas generating malpractice claims?    Initial administrative groundwork    The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review    Reporting requirements and filing exceptions for Schedules K-2 and K-3    Don’t fall prey to reporting oddities    When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065?    Form 1120-S  What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding open debt; the default method of calculating basis versus the election under Section 1367; can an S corporation distribute earnings and profits from C corporation years?    Form 1065  New tax reporting requirement for partners’ capital balances    Why use Section 704(b) to maintain capital accounts; Section 704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse\, nonrecourse\, and qualified nonrecourse debt; a review of Section 754 step-up in basis rules    Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return \nInstructions\nNone
URL:https://sc.cpa/event/sstx547-26-surgents-forms-1120-s-and-1065-return-review-boot-camp-for-new-and-experienced-reviewers/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205534Z
LAST-MODIFIED:20250606T041716Z
UID:10005145-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX562/26) Surgent's Comprehensive Guide to Tax Depreciation\, Expensing\, and Property Transactions
DESCRIPTION:Event Description\nWith a greater-than-ever 179 deduction boosted by additional first-year depreciation and pandemic-related business-friendly provisions\, these are unprecedented times for businesses to make major asset investments.From the most-up-to-date depreciation regulations to inflation adjustments and technical corrections\, this course will help you navigate the complex maze of rules dealing with depreciation\, amortization\, and sales of property. This reference manual contains a wide range of case types and examples\, covering common and uncommon situations to illustrate the most important points CPAs need to be aware of. \nDesigned For\nCPAs in industry and public accounting who need a thorough grasp of this important area of tax law and who want to maximize the possible tax savings for their clients \nObjectives\nUnderstand which assets are subject to depreciation    Answer advanced Section 179 and automobile depreciation questions    Fully understand depreciation and MACRS cost recovery    Understand installment sales and reacquisitions    Complete cases related to depreciation and sales of assets \nMajor Subjects\nFinal regulations  bonus depreciation and Section 1031 exchanges    Technical correction Rev. Proc. 2019-13  use it or stand to lose second-year depreciation deductions for luxury automobiles    What are the components for real estate depreciation?    A new SUV or sedan? A study of depreciation alternatives    Permanency in Section 179 depreciation rules? How to maximize its use; when to use it; and what property qualifies    Sale of property and the depreciation recapture rules (Sections 1245\, Section 1250\, unrecaptured Section 1250 gain for real estate\, Section 291 for corporations)    How to depreciate like-kind exchange property    May Section 121 and Section 1031 apply to the same transfer of property?    Reacquired installment sale property  calculating potential gain and new basis    Understanding Section 197 amortization issues; how to handle intangible asset costs    Depreciation issues\, tax-deferred exchanges\, personal property converted to business property\, and an overview of home sale exclusion    Guide for compliance and planning issues    Cases and rulings of depreciation and amortization issues and how they impact clients\, along with the useful planning opportunities \nInstructions\nNone
URL:https://sc.cpa/event/sstx562-26-surgents-comprehensive-guide-to-tax-depreciation-expensing-and-property-transactions/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205613Z
LAST-MODIFIED:20250606T044520Z
UID:10005146-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX495/26) Surgent's 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. You can’t afford to ignore recent changes in state and local tax. Even tax-savvy businesses and their advisers often neglect to consider the consequences of state and local taxes. Multistate taxation is more complex and demanding than ever before. In addition to having their own unique tax laws\, states have been more focused on enforcement. 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\nThe domicile dilemma: Issues for individuals with homes in multiple states; traveling employees; where to withhold?    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: Attributional and agency nexus; presence of intangible property; is P.L. 86-272 still valid?    Income-tax apportionment issues: Prevalence of the single sales factor; determining the type of property being sold; sourcing of income from intangible property and services; sourcing of service income; Market Based versus Cost of Performance    Pass-through problems: Nexus issues for interest owners     Treatment of the 199A deduction for pass through entities by states: Withholding issues; sourcing of income; taxation at the entity level    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/sstx495-26-surgents-multistate-tax-update/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205614Z
LAST-MODIFIED:20250606T041726Z
UID:10005147-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX543/26) 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\nUnderstand the CPA’s role in the beginning of the transaction and throughout the process    Identify the different tax consequences for various forms of acquired businesses    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    Appreciate Section 338 and Section 338(h)(10) elections and the benefits of installment sales    Understand the impact of Sections 751\, 743\, 734\, and 754 on the purchase or sale of a partnership \nMajor Subjects\nAn 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/sstx543-26-surgents-buying-and-selling-a-business-tax-and-structuring-overview/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205615Z
LAST-MODIFIED:20250606T044609Z
UID:10005148-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE459/26) 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\nIdentify which lookup function works for your needs    Distinguish between the many lookup functions    Recall how to effectively utilize Excel’s lookup functions \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/sste459-26-surgents-mastering-the-excel-lookup-functions/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205618Z
LAST-MODIFIED:20250606T041809Z
UID:10005149-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA422/26) Surgent's Performing Effective Accounting Research
DESCRIPTION:Event Description\nFinancial accounting can be complex. An integral part of a senior associate’s job responsibilities is to perform effective and efficient research using the FASB’s Accounting Standards Codification (ASC). In this session\, participants will be introduced to the ASC\, including how it is structured\, organized\, and updated. They will also learn about other information that can be accessed from the ASC. Next\, the session will cover best practices for effective research using the ASC\, including the ASC’s search functionality and other tools that will make accounting research easier to perform. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 4.) \nDesigned For\nAccountants with several years in the auditing profession \nObjectives\nDetermine the sources of authoritative U.S. GAAP    Recall FASB Research and information sources    Identify the structure of the Accounting Standards Codification    Recall how to perform research with the ASC \nMajor Subjects\nStructure of the ASC codification    Content included and not included in the ASC    Other information contained in the codification    Best practices for performing effective and efficient accounting research \nInstructions\nNone
URL:https://sc.cpa/event/ssaa422-26-surgents-performing-effective-accounting-research/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205619Z
LAST-MODIFIED:20250606T044610Z
UID:10005150-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX470/26) Surgent's Individual and Financial-Planning Tax Camp
DESCRIPTION:Event Description\nEach year brings its own set of tax planning challenges\, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients\, but in particular\, wealthy clients\, middle-income clients\, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives\, while also bringing value to you and your firm.  This material is continuously updated for recent legislation impacting individual taxpayers. \nDesigned For\nThose involved in tax planning for individuals\, including those who may be partners or shareholders \nObjectives\nMine a tax return for tax planning with a client     Understand the planning implications of the  current environment     Determine the best tax strategies for retirement     Understand tax planning for the middle-income  client \nMajor Subjects\nComprehensive coverage of the SECURE Act 2.0    Understanding the environment: what’s new\, what’s expired or expiring\, and what’s likely to change    Reading a tax return for developing client-specific tax strategies    Changes to the lifetime estate tax exemption in light of proposed regulations    The net investment income tax: planning for compliance    Family income-splitting strategies that need to be considered    Income tax issues: impact on timing of other income    Selling a principal residence    Two principal residences at the same time    Use of life insurance to protect families: Whole Life Insurance\, Term Life Insurance\, Universal Life Insurance\, and Variable Life Insurance    Using Roth IRAs and Roth contribution programs to best advantage    Conversions: do they still make sense?    Taking distributions: matching timing to client requirements    Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed    Social Security solvency issues    Incentive Stock Options and Employee Stock Purchase Plan considerations    What to do about itemized deductions    Trans-generational planning: conversions\, income\, and gain-splitting    Tax benefits of HSAs and other tax-advantaged accounts    Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future    Planning for middle-income taxpayers: financial planning for the young\, the working\, and those approaching or in retirement    Best financial planning ideas for young people \nInstructions\nNone
URL:https://sc.cpa/event/sstx470-26-surgents-individual-and-financial-planning-tax-camp/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205620Z
LAST-MODIFIED:20250606T041811Z
UID:10005151-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX492/26) Surgent's Multistate Income Tax Issues
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 the area of nexus. Learn how nexus requirements have changed and where the state laws may be heading in the future. \nDesigned For\nAccountants who want an update on current multistate tax issues to minimize clients’ potential state and local tax liability \nObjectives\nIdentify changes in state statutes\, regulations and case law    Determine how the states will treat changes under the Tax Cuts and Jobs Act    Recognize areas that may require additional attention for state tax planning purposes    Recall areas that may be costly for employers or clients    Recognize the who\, what\, when\, and where of nexus for income and sales tax \nMajor Subjects\nEmerging 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?    When to consider voluntary compliance even though the laws do not dictate a sales tax responsibility \nInstructions\nNone
URL:https://sc.cpa/event/sstx492-26-surgents-multistate-income-tax-issues/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205624Z
LAST-MODIFIED:20250606T044612Z
UID:10005152-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE446/26) Surgent's Power Query Series: More Transformations and Load Options
DESCRIPTION:Event Description\nPower Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process\, focusing on data cleaning and data enrichment.  In addition\, this course explains query loading options and processes.  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 sixth 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 loading options in Power Query    Apply the data transformation process in Power Query \nMajor Subjects\nWorkflow of the data transformation for a general ledger with sub-accounts    Loading a query    Loading options for a query    Changing the load destination of a query    Hands-on examples: flattening a general ledger with sub-accounts; making a connection to the data source; reviewing and documenting the steps created by Power Query \nInstructions\nSave all data sets provided to a central location on your computer
URL:https://sc.cpa/event/sste446-26-surgents-power-query-series-more-transformations-and-load-options/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205628Z
LAST-MODIFIED:20250606T041813Z
UID:10005153-1782820800-1782820800@sc.cpa
SUMMARY:(SSTX424/26) Surgent's Federal Tax Update
DESCRIPTION:Event Description\nBoth businesses and individual clients face major changes as a result of new legislation\, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients.  Continually updated to reflect enacted legislation.  Please Note: Due to content overlap\, it is recommended that this course NOT be taken together with BIT4. \nDesigned For\nAccounting and Finance Professionals who need to know the latest tax law changes in all areas of practice \nObjectives\nUnderstand strategies and techniques to use in light of new legislation    Understand the latest enacted tax law changes    Understand current cases and rulings affecting your clients \nMajor Subjects\nDigital assets and tax implications – understand the new Form 1099-DA for reporting digital asset transactions\, along with updated IRS guidance on cryptocurrencies\, NFTs\, and broker responsibilities    Artificial intelligence – discover how AI and generative tools are transforming tax practices\, as well as how the IRS is leveraging AI to enhance audit selection    Form 1099-K reporting requirements – understand the evolving IRS thresholds and rules for third-party payment platforms    The Gig Economy – examine key tax implications for gig workers\, including Independent Contractor vs. Employee classification challenges\, reporting responsibilities\, and the impact of the 2024 Department of Labor Final Rule on worker status    Timely coverage of breaking tax legislation    Advanced practice\, reporting\, and other issues intertwined with advanced planning and discussion ideas \nInstructions\nNone
URL:https://sc.cpa/event/sstx424-26-surgents-federal-tax-update/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205632Z
LAST-MODIFIED:20250606T044614Z
UID:10005154-1782820800-1782820800@sc.cpa
SUMMARY:(SSOT443/26) Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
DESCRIPTION:Event Description\nIn today’s rapidly changing world\, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand\, they need to be abreast of the latest proven financial skills for making the best decisions\, and on the other hand they need the best skills to motivate\, manage\, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We’ll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations. \nDesigned For\nCFOs\, controllers\, and finance professionals \nObjectives\nUnderstand the current issues and latest trends impacting CFOs\, controllers\, and finance professionals    Understand how domestic and global economic conditions could impact an organization    Apply what we have learned from recent economic and political changes to have a positive impact on an organization    Be familiar with the results of the case studies and exercises that reinforce key learning points throughout the course \nMajor Subjects\nEconomic update    Leadership and management changes as a result of the pandemic    Managing for productivity    Metrics and benchmarking    Social media’s place in our organizations \nInstructions\nNone
URL:https://sc.cpa/event/ssot443-26-surgents-controller-cfo-update-hot-topics-facing-todays-financial-professional/
CATEGORIES:Self-Study Text
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205635Z
LAST-MODIFIED:20250606T041815Z
UID:10005155-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA449/26) Surgent's Going Concern Accounting and Reporting Considerations
DESCRIPTION:Event Description\nThis course will review the relevant considerations related to going concern\, including assessing when substantial doubt concerning an entity’s ability to continue as a going concern exists\, management mitigation efforts\, and required disclosures both when management\, and the accountant\, feel such efforts will be effective in mitigating the risk\, as well as when they do not. Lastly\, we’ll consider the accountant’s reporting responsibilities under various scopes of services in various scenarios and how to audit this often-contentious topic. \nDesigned For\nAccounting and auditing practitioners assisting in the preparation of financial statements \nObjectives\nDifferentiate between the external accountant’s and management’s responsibility related to identifying\, evaluating\, presenting\, and disclosing going concern uncertainty     Discuss how to obtain sufficient appropriate evidence to evaluate management’s assertions about an entity’s ability to continue as a going concern for a reasonable period of time     Describe the independent accountant’s reporting options under applicable auditing and other professional services standards when uncertainty associated with going concern exists \nMajor Subjects\nCurrent FASB accounting standards related to going concern\, including the new requirements of ASU 2014-15      Evaluating risk of material misstatement in financial reports related to improper presentation and disclosure of going concern uncertainty     The responsibility of an independent accountant for evaluating going concern uncertainty under various levels of engagement to perform attest and nonattest services     New requirements of SAS No. 132 and SSARS No. 24 related to an auditor’s responsibility for considering going concern uncertainty? \nInstructions\nNone
URL:https://sc.cpa/event/ssaa449-26-surgents-going-concern-accounting-and-reporting-considerations/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205637Z
LAST-MODIFIED:20250606T044615Z
UID:10005156-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA425/26) Surgent's SAS 134 and Other Reporting Considerations
DESCRIPTION:Event Description\nFor all the work performed on the audit\, the one thing that the public sees is the auditor’s report. So we need to make sure that the opinion is correct. With the effective date of SAS 134\, the auditor’s report underwent significant changes. This session will cover the format of the revised auditor’s report and discuss the responsibilities of both management and the auditors which are now explicitly identified in the revised report. The session will also cover other conforming changes made to the auditor’s report with the effective date of SAS 137-140.Lastly\, the session will address both when\, and how\, the auditor would issue qualified and adverse opinions and when the auditor would disclaim an opinion. The session will also address when the auditor is required to add either an Emphasis of Matter or Other Matter paragraph and its contents. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 4.) \nDesigned For\nAccountants with several years in the auditing profession \nObjectives\nIdentify key changes to auditor’s reporting with the effective dates of SASs 134-140    Identify circumstances when the auditor would issue an other than unqualified report    Recall when an auditor would issue a qualified auditor’s opinion and its wording    Recall the appropriate wording and location of emphasis of matter and Other Matter paragraphs \nMajor Subjects\nRevised format of audit opinion under SAS 134    Additional responsibilities of both management and the auditors under SAS 134    Additional requirements related to SASs 135-140    Qualified auditor reports\, their wording\, and when the auditor would issue one of them    Circumstances requiring the addition of Emphasis of Matter and Other Matter paragraphs to the standard unqualified audit report \nInstructions\nNone
URL:https://sc.cpa/event/ssaa425-26-surgents-sas-134-and-other-reporting-considerations/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205638Z
LAST-MODIFIED:20250606T041818Z
UID:10005157-1782820800-1782820800@sc.cpa
SUMMARY:(SSAA421/26) Surgent's Accounting for and Auditing Complex Investments
DESCRIPTION:Event Description\nAs companies look for greater investment returns in the current low interest rate environment\, they are often investing in more risky types of investments\, such as cryptocurrency. Further\, as they look to hedge business risks\, companies are frequently entering into derivative transactions\, which both can contain unexpected risk and accounting complexity.As you advance in your audit careers\, you will be faced with both understanding the accounting for and auditing these complex financial statement areas. In this course\, we’ll review the accounting models of several types of complex investments and review common audit procedures in these areas. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 3.) \nDesigned For\nAccountants who account for or audit more complex financial instruments \nObjectives\nRecall fair value accounting guidance under ASC 820    Recall the accounting guidance related to hedging transactions and other complex investments    Identify common audit procedures related to complex investments \nMajor Subjects\nThe fair value measurement process    Derivative and hedge accounting under ASC 815    Accounting and auditing considerations related to the use of the equity method of accounting under ASC 323    Accounting and auditing considerations related to investments in cryptocurrency and digital assets \nInstructions\nNone
URL:https://sc.cpa/event/ssaa421-26-surgents-accounting-for-and-auditing-complex-investments/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260404T072813
CREATED:20250605T205639Z
LAST-MODIFIED:20250606T044617Z
UID:10005158-1782820800-1782820800@sc.cpa
SUMMARY:(SSOT448/26) Surgent's Workplace Etiquette for Young Professionals
DESCRIPTION:Event Description\nUnderstanding the nuances of workplace protocol facilitates effective interactions within the office as well as at external business functions.  In this class you will learn how to cultivate your executive presence as well as how to conduct yourself in a variety of business settings.  The work environment extends beyond the walls of the office into client sites\, business events\, and conferences. You will be provided with the tools to navigate every situation with confidence and grace.  Although the workplace is an evolving structure\, the general rules of etiquette such as kindness\, respect\, cooperation\, and effective communication have not shifted. \nDesigned For\nYoung professionals in the accounting or financial service professions who are interested in elevating and fine tuning a workplace presence to enhance career opportunities. \nObjectives\nUnderstand how to cultivate and project an executive presence    Integrate perception management through appearance\, behavior\, and communication in the workplace    Effectively navigate business dining settings and client events \nMajor Subjects\nProjecting a professional presence    Verbal communication skills to elevate your message    Mastering non-verbal communication     Protocol for office settings    Building trust within the organization and with clients    Running an impactful meeting    Adding value as a meeting attendee    Executive dining etiquette strategies and tips \nInstructions\nNone
URL:https://sc.cpa/event/ssot448-26-surgents-workplace-etiquette-for-young-professionals/
CATEGORIES:Self-Study Video
END:VEVENT
END:VCALENDAR