BEGIN:VCALENDAR VERSION:2.0 PRODID:-//South Carolina Association of CPAs - ECPv6.15.18//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-ORIGINAL-URL:https://sc.cpa X-WR-CALDESC:Events for South Carolina Association of CPAs REFRESH-INTERVAL;VALUE=DURATION:PT1H X-Robots-Tag:noindex X-PUBLISHED-TTL:PT1H BEGIN:VTIMEZONE TZID:America/Detroit BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20240310T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20241103T060000 END:STANDARD 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 END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224714Z LAST-MODIFIED:20250401T033414Z UID:10004680-1751284800-1751284800@sc.cpa SUMMARY:(SSTX301/25) Surgent's Weekly Expert Hour (Original Air Date: 7/30/20) 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\nTD 9905 PTINs IRS guidance on recapture of excess employment tax credits (TD 9904 and REG-111879-20) Notice 2020-51 \nInstructions\nNone URL:https://sc.cpa/event/sstx301-25-surgents-weekly-expert-hour-original-air-date-7-30-20/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224806Z LAST-MODIFIED:20250401T033219Z UID:10004681-1751284800-1751284800@sc.cpa SUMMARY:(SSOT115/25) Surgent's Bankruptcy Basics: Understanding the Consumer Bankruptcy Process DESCRIPTION:Event Description\nConsumers file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies\, followed by medical expenses and foreclosure. As trusted advisors\, accounting and financial professionals should have a basic understanding of the bankruptcy process. This webinar provides a thorough review of consumer bankruptcy proceedings. Participants in this webinar will gain an understanding of how consumer bankruptcy proceedings begin and end\, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This webinar provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor\, the Bankruptcy Code provides substantial protections to creditors. Creditor rights\, however\, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself\, your clients\, and your profit margin a favor\, and sign up for this invaluable webinar. \nDesigned For\nProfessionals seeking to understand the basic components of bankruptcy proceedings \nObjectives\nUnderstand the different types of bankruptcy proceedings Advise clients regarding the proof of claim process Be well-versed in the eligibility requirements for consumer bankruptcies Understand the role of the automatic stay injunction \nMajor Subjects\nCommencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7\, 11\, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Bankruptcy trustees Special rights afforded to secured creditors \nInstructions\nNone URL:https://sc.cpa/event/ssot115-25-surgents-bankruptcy-basics-understanding-the-consumer-bankruptcy-process/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224811Z LAST-MODIFIED:20250401T044107Z UID:10004682-1751284800-1751284800@sc.cpa SUMMARY:(SSAA123/25) Surgent's Audit Quality Update DESCRIPTION:Event Description\nEngagement quality is the ultimate benchmark that auditors should be judged against. As a senior associate\, you have primary responsibility for ensuring that all engagement work is performed on time\, within budget\, and in accordance with professional standards. Unfortunately\, recent peer review results have shown us that our engagement quality is not always what it should be. In this session\, we will review the current status of the AICPA’s Enhancing Audit Quality initiative by reviewing recent results from peer reviews and points of focus for upcoming peer reviews. The session will review common sources of identified peer review deficiencies\, relevant guidance related to these deficiencies and suggestions for how to improve engagement quality. (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 elements of the AICPA’s Enhancing Audit Quality initiatives Recognize key trends noted in recent peer reviews Recognize the importance of audit documentation in the system of quality control Recall common peer review feedback identified on common attestation engagements \nMajor Subjects\n2017-2020 peer review results Common sources of peer review deficiencies AICPA Peer Review Program areas of focus for peer reviews \nInstructions\nNone URL:https://sc.cpa/event/ssaa123-25-surgents-audit-quality-update/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224915Z LAST-MODIFIED:20250401T031451Z UID:10004683-1751284800-1751284800@sc.cpa SUMMARY:(SSAA112/25) Surgent's Preparing and Reviewing Client Prepared Financial Statements DESCRIPTION:Event Description\nThe ultimate objective of a financial statement audit is to issue the independent auditor’s report. This module discusses the process\, introduces key elements of financial statements\, and provides best practices for auditors who either prepare or review the client’s financial statements. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 2.) \nDesigned For\nAccountants who have responsibilities for drafting financial statements or reviewing client prepared financial statements. \nObjectives\nExplain the key elements and variations of the auditor’s report Understand the appropriate treatment for accounting changes and error corrections Discuss the basic financial statements\, their key elements and required disclosures Understand the Codification layout and be able to perform research on presentation and disclosure issues that arise Use a framework to prepare or review client prepared financial statements Identify best practices for financial statement preparation or review of client prepared financial statements. \nMajor Subjects\nObjective of financial reporting Inter-relationships of financial statements and disclosures Accounting changes Financial statement preparation and review process Best practices for financial statement preparation and review \n\nInstructions\nNone URL:https://sc.cpa/event/ssaa112-25-surgents-preparing-and-reviewing-client-prepared-financial-statements/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224916Z LAST-MODIFIED:20250401T045225Z UID:10004684-1751284800-1751284800@sc.cpa SUMMARY:(SSTX138/25) Surgent's Form 1040 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 thoroughly review various 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\nReview an error-prone “staff-prepared” Form 1040 from client-provided information. Where do you start? Get to know your client and ask the questions Several new reporting issues for the reviewer to consider\, including new and enhanced clean energy credits under the Inflation Reduction Act (IRA) What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters\, questionnaires\, and Sect 7216 permission statement Initial administrative groundwork Identifying organizing issues in the tax return to be reviewed Avoiding willful blindness; handling ethical and moral dilemmas Efficient review of certain advanced issues for income\, adjustments\, deductions\, and credits Effective procedures for delinquent clients\, filing past-due tax returns First-time client issues requiring extra scrutiny Multiple checklists of efficient procedures to identify potential issues on a 1040 return Listing of schedules for staff to prepare to make a review easier\, including basis issues for 1040 clients Reconciling time pressure with thoroughness and quality control Professionals acting professionally \nInstructions\nNone URL:https://sc.cpa/event/sstx138-25-surgents-form-1040-return-review-boot-camp-for-new-and-experienced-reviewers/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T224931Z LAST-MODIFIED:20250401T034520Z UID:10004687-1751284800-1751284800@sc.cpa SUMMARY:(SSTE125/25) Surgent's Power Query Series: Editor - The User Interface of Power Query DESCRIPTION:Event Description\nThis course introduces users to the Power Query Editor\, using the Excel version of Power Query\, and includes a hands-on transformation exercise using the editor. 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 third 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\nBe familiar with the components of the Power Query Editor Perform a transformation using the Power Query Editor \nMajor Subjects\nWhat is the Power Query Editor? How can I launch the Power Query Editor? Review of the components of the Power Query Editor Preview pane Ribbon Queries pane Query settings pane Applied steps Formula bar \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste125-25-surgents-power-query-series-editor-the-user-interface-of-power-query/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225004Z LAST-MODIFIED:20250401T042614Z UID:10004688-1751284800-1751284800@sc.cpa SUMMARY:(SSAA101/25) Surgent's Fundamentals of Internal Controls DESCRIPTION:Event Description\nObtaining an understanding of the entity and its environment is critical part of assessing the risk of material misstatement. The auditor obtains an understanding of internal controls by evaluating the design and implementation of key controls over relevant systems as well as entity level and financial reporting controls. This module will provide the participant with an understanding of how to perform the work and document the understanding. Participants may also want to register for the audit skills module on testing internal controls. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 1.) \nDesigned For\nProfessionals new to evaluating the design and implementation of internal control \nObjectives\nDiscuss the evolution of Internal Controls Discuss the five of the COSO Internal Control Integrated Framework Document the auditor’s understanding of a systems description narrative Understand the requirements when systems are outsourced to a third party Identify controls that are responsive to the risk of fraud \nMajor Subjects\nGaining an understanding of the evolution of internal controls Components of the COSO Internal Control & Integrated Framework Approaches for documenting and evaluating the design and implementation of internal control over financial reporting Critical elements of entity-level and transactional-level controls covering all assertions Internal controls that are responsive to the risk of fraud Case studies related to identifying deficiencies in internal control documentation \nInstructions\nNone URL:https://sc.cpa/event/ssaa101-25-surgents-fundamentals-of-internal-controls/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225006Z LAST-MODIFIED:20250401T034122Z UID:10004689-1751284800-1751284800@sc.cpa SUMMARY:(SSTE123/25) 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/sste123-25-surgents-power-query-series-introduction-and-first-connection/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225113Z LAST-MODIFIED:20250401T051223Z UID:10004690-1751284800-1751284800@sc.cpa SUMMARY:(SSAA175/25) Surgent's Compilations\, Reviews\, and Preparations: Engagement Performance and Annual Update DESCRIPTION:Event Description\nSpecifically designed for preparation\, compilation\, and review practitioners\, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation\, compilation\, and review engagements. You will learn the ins and outs of applying SSARS No. 21\, Clarification and Recodification\, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26\, the entire suite of quality management standards is discussed.However\, knowing the standards is not enough. You need to be able to effectively apply them. To support this\, the course will review recent peer review feedback on SSARS engagements\, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance\, but more importantly\, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional\, ethical\, and technical requirements. \nDesigned For\nAccounting practitioners and their staff performing and managing compilation\, preparation\, and review engagement services \nObjectives\nUnderstand\, apply SSARS No. 21\, Clarification and Recodification Be familiar with changes due to the issuance of SSARS Nos. 22-26 Be familiar with compilation and review program examples and disclosure illustrations Identify and apply compilation\, preparation\, and review procedures Be aware of the most recent compilation and review reports and other communications Utilize hands-on examples and illustrations to increase your overall understanding and application of the material \nMajor Subjects\nSSARS No. 21\, Clarification and Recodification\, and updates to SSARS No. 21 due to the issuance of SSARS No. 23\, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22\, Compilation of Pro Forma Financial Information SSARS No. 24\, Omnibus Statement on Standards for Accounting and Review Services — 2018 SSARS No. 25\, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26\, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation\, compilation and review engagements Reporting and disclosure illustrations for each level of service\, including attesting on personal financial statements\, prescribed form\, special purpose framework and other engagement variations Other communication requirements\, such as sample engagement letters and management representation letters \nInstructions\nNone URL:https://sc.cpa/event/ssaa175-25-surgents-compilations-reviews-and-preparations-engagement-performance-and-annual-update/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225129Z LAST-MODIFIED:20250401T021702Z UID:10004691-1751284800-1751284800@sc.cpa SUMMARY:(SSMG136/25) Surgent's Microsoftr Excelr 2019: Working with Formulas and Functions DESCRIPTION:Event Description\nThis course guides you through creating\, copying and pasting\, reviewing\, and correcting basic and complex formulas in Excel 2019 using step-by-step\, hands-on activities. \nDesigned For\nUsers experienced with using Excel 2019 in the Windows 10 operating system environment or experienced Excel users switching from earlier versions of Excel. \nObjectives\nDescribe formula and function syntax and create basic formulas Copy/paste and fill formulas Enter formulas on grouped worksheets Use multiple methods to build formulas Apply conditional formatting to formulas’ results Find and correct formula errors using a variety of tools\, such as the Error Checking feature and Trace Error icon\, the Formula Auditing tools\, and the Watch Window \nMajor Subjects\nIdentify basic formula and function syntax Recognize formulas pasted with relative references Select status bar options and sum (AutoSum) for quick calculations Recognize formulas pasted with mixed or absolute references Identify formula results pasted as values Select worksheets for grouping and entering formulas Identify ways to link worksheets and workbooks with 3D formulas Select the insert function button or buttons from the function library to insert functions in formulas Recognize defined names as function arguments Apply conditional formatting to formulas results Identify and correct common errors using the trace error icon and the formula auditing tools Identify and correct circular references Select color-coded cell borders to correct a cell reference error in a formula Identify how to step through a nested formula Identify how to use the Watch Window and other tools to analyze\, protect\, and hide formulas \nInstructions\nNone URL:https://sc.cpa/event/ssmg136-25-surgents-microsoftr-excelr-2019-working-with-formulas-and-functions/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225132Z LAST-MODIFIED:20250401T021705Z UID:10004692-1751284800-1751284800@sc.cpa SUMMARY:(SSAA245/25) Surgent's Monthly Accounting and Auditing Update (Original Air Date: 8/31/21) DESCRIPTION:Event Description\nThe one constant in life is change. This is true in the A&A world as well. 2021 will continue to challenge the accounting profession in many areas\, including accounting for the impact of the COVID-19 pandemic\, working in a virtual environment\, and implementing new AICPA and FASB pronouncements. In this monthly series\, we will explore the hot topics and current events that are driving financial accounting today\, such as auditing and SSARS standards implementation and getting ready for ASC 842 implementation. Through detailed discussion of new standards and commentary from relevant industry experts\, this monthly update will keep you up to date on what you need to know in the accounting world.So\, whether your area of specialty is employee benefit plans\, leases\, not-for-profit and governmental accounting\, or something else\, this monthly hour will give you what you need to know to do your job as effectively as possible. \nDesigned For\nAccounting and auditing practitioners at all levels desiring to remain up to date on recent pronouncements and other standard setters’ activities \nObjectives\nIdentify new standard-setting activities by the FASB and AICPA Review relevant guidance in COVID-19-related accounting topics Recall strategies for working effectively and complying with professional standards in a changing work environment Identify key success factors for the upcoming busy season \nMajor Subjects\nNew professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners \nInstructions\nNone URL:https://sc.cpa/event/ssaa245-25-surgents-monthly-accounting-and-auditing-update-original-air-date-8-31-21/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225137Z LAST-MODIFIED:20250401T021722Z UID:10004693-1751284800-1751284800@sc.cpa SUMMARY:(SSTX130/25) Surgent's The Complete Guide to Payroll Taxes and 1099 Issues DESCRIPTION:Event Description\nEmployment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business\, and IRS penalties for noncompliance have risen dramatically in recent years. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high on its audit list. This course presents a comprehensive overview of federal payroll taxes\, Form 1099\, and related compliance issues. \nDesigned For\nCPAs in public accounting and industry with responsibility for payroll tax compliance \nObjectives\nDistinguish an employee from an independent contractor and understand the relief available to employers who misclassify employees Understand what is needed to complete Forms W-2\, 1099-MISC\, 1099-R\, and SS-8 Understand the gig economy and the payroll tax responsibilities associated with it \nMajor Subjects\nPayroll tax requirements for wages\, including wages subject to the .9 percent tax\, employee benefits and reimbursements\, nonqualified deferred compensation\, stock options\, and tips Fringe benefits issues\, such as health insurance\, life insurance\, cafeteria plan benefits\, accountable and non-accountable plans\, standard mileage rates\, and per diem rates Special issues — Using a common paymaster\, how to file W-2s after a takeover\, merger\, or acquisition\, and state and local tax withholding Statutory employees\, independent contractors\, and possible changes to Sect 530 relief Penalties — Who is a responsible person? Expenses and gross-up calculations Pension issues and payroll taxes including SIMPLE plans\, and Sect 401(k) and pension distributions The Electronic Federal Tax Payment System (EFTPS) Forms I-9\, W-9\, W-2\, 1099\, 1099-NEC\, SS-8\, and 940 Understanding payroll tax responsibilities in the gig economy \nInstructions\nNone URL:https://sc.cpa/event/sstx130-25-surgents-the-complete-guide-to-payroll-taxes-and-1099-issues/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225208Z LAST-MODIFIED:20250401T021727Z UID:10004694-1751284800-1751284800@sc.cpa SUMMARY:(SSAA164/25) Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today DESCRIPTION:Event Description\nThis year\, not-for-profit entities are preparing to apply critical new standards related to contributions of nonfinancial assets\, leases\, and more. Now is the time to know more than just what the standards say – we need to know what they mean and how they will affect not-for-profit entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in not-for-profit accounting today. \nDesigned For\nNot-for-profit industry professionals and auditors \nObjectives\nIdentify the critical changes occurring in not-for-profit accounting today Skillfully implement today’s most challenging FASB standards affecting not-for-profits More effectively audit not-for-profit entities through superior knowledge of key accounting issues \nMajor Subjects\nPreparing for the implementation of the new requirements related to contributions of nonfinanciual assets (i.e.\, ASU No. 2020-07) Developing a deeper understanding of the requirements in FASB ASC 842\, Leases\, and how not-for-profit entities will implement the standard Additional issues in not-for-profit financial reporting \nInstructions\nNone URL:https://sc.cpa/event/ssaa164-25-surgents-the-most-critical-challenges-in-not-for-profit-accounting-today/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225211Z LAST-MODIFIED:20250401T021905Z UID:10004695-1751284800-1751284800@sc.cpa SUMMARY:(SSAA293/25) Surgent's Fraud in Governments and Nonprofits DESCRIPTION:Event Description\nThe cost of fraud\, dearly paid by governments and nonprofits\, is too severe not to learn from. In this course\, we will look back on real-world government and nonprofit frauds and derive useful controls to stop them. \nDesigned For\nAuditors of governments and nonprofits and industry professionals interested in preventing fraud \nObjectives\nIdentify common frauds occurring in governments and nonprofits today Skillfully develop controls to combat frauds Protect governments and nonprofits from fraud \nMajor Subjects\nCommon characteristics of fraud perpetrators Frauds involving supplies\, credit card programs\, and overtime Key controls to detect and prevent fraud \nInstructions\nNone URL:https://sc.cpa/event/ssaa293-25-surgents-fraud-in-governments-and-nonprofits/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225413Z LAST-MODIFIED:20250401T022212Z UID:10004696-1751284800-1751284800@sc.cpa SUMMARY:(SSTX183/25) Surgent's Max the Tax: Schedule E DESCRIPTION:Event Description\nYou just received an email from Roni\, a prospective new client. He owns several properties under the business name Roni’s Real Rentals LLC and wants help minimizing rental income and maximizing deductions that offset the rental income. You will interview Roni and visit his two properties to gain a better understanding of his situation. Advise Roni by providing him good and relevant ideas\, and he will ask you to be his new tax accountant. \nDesigned For\nTax practitioners desiring an interactive approach to learn key tax knowledge \nObjectives\nUnderstand what qualifies as supplemental / rental income on Schedule E Understand what qualifies as expenses to report on Schedule E \nMajor Subjects\nBusiness development Types of properties Rental property use; Rental expenses Deductible expenses Repairs and maintenance Capitalization of expenses Depreciation Accounting methods Treatment of security deposits \nInstructions\nNone URL:https://sc.cpa/event/sstx183-25-surgents-max-the-tax-schedule-e/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225421Z LAST-MODIFIED:20250401T024017Z UID:10004697-1751284800-1751284800@sc.cpa SUMMARY:(SSMG126/25) Surgent's Project Management: Tips\, Tricks\, and Traps DESCRIPTION:Event Description\nThis past year has shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations\, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made\, the ways to avoid them\, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier. In an effort to avoid talking theory without concrete examples\, we will often use examples born from projects needed as a result of our experiences with COVID-19. \nDesigned For\nCFOs\, controllers\, and finance professionals \nObjectives\nUnderstand the importance of project management in parts of the financial function See how project management can help an individual executive better organize the department Review different types of project management and see which one or ones might be best for the department and organization Explore some of the project management software suited for the small to medium size enterprise \nMajor Subjects\nContrasting project management with operations management Reviewing organizational culture and how it applies to project management The various types of project management including Agile\, Scrum\, Waterfall\, Critical path\, and others Looking at risk management software and its application in different types of project management Managing and leading project management stakeholders \nInstructions\nNone URL:https://sc.cpa/event/ssmg126-25-surgents-project-management-tips-tricks-and-traps/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225513Z LAST-MODIFIED:20250401T034107Z UID:10004698-1751284800-1751284800@sc.cpa SUMMARY:(SSAA103/25) Surgent's A Practical Guide to Auditing Cash and Cash Equivalents DESCRIPTION:Event Description\nCash and cash equivalents tend to be one of the first areas assigned to new auditors since it tends to be straightforward with less complexity and risk as other areas. In addition\, there is little subjectivity involved and persuasive audit evidence from a third-party is generally available. Interestingly enough\, this is an area that can have a significant risk of misappropriation of assets if the appropriate level of segregation of duties and other internal controls is not present. New auditors should approach cash with the same professional skepticism as other areas since there is always the risk of material misstatement. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 1.) \nDesigned For\nProfessionals new to auditing cash and cash equivalents \nObjectives\nIdentify risks related to cash and cash equivalents Identify sources of audit evidence associated with cash and cash equivalents Discuss standard audit procedures related to cash and cash equivalents Explain how to evaluate audit evidence associated with cash Describe typical presentation and disclosure issues related to cash \nMajor Subjects\nExplain typical audit risks and special considerations related to cash and cash equivalents Identify the risk of fraud related to cash and cash equivalents Describe designing a detailed audit plan\, linking assessed risk to planned procedures Techniques used to perform the audit procedures associated with auditing cash and cash equivalents Obtaining evidence related to cash and cash equivalents Case study and test yourself questions related to auditing cash and cash equivalents \nInstructions\nNone URL:https://sc.cpa/event/ssaa103-25-surgents-a-practical-guide-to-auditing-cash-and-cash-equivalents/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225514Z LAST-MODIFIED:20250401T034109Z UID:10004699-1751284800-1751284800@sc.cpa SUMMARY:(SSOT130/25) Surgent's Securing a Comfortable Retirement DESCRIPTION:Event Description\nThis course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income they will require and planning for how to reach their 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 Understand how to build the three-legged retirement stool: employer retirement\, savings\, and Social Security Develop 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\, and 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 the residence and other real estate as retirement assets through equity and rent Using the small business as a retirement resource through creative retirement plans\, non-qualified deferred compensation\, and converting the value of the business through sales within the family or to an outside party An overview of portfolio management for retirees\, including: sustainable portfolio withdrawal rates; balancing investments between income and equity\, and taxable and nontaxable; and asset liquidation and distribution timing to minimize the tax impact of retirement distributions and maximize cash flow from retirement vehicles and Social Security Developing a three-legged retirement stool of employer retirement\, savings\, and Social Security\, and timing the use of the legs of the stool to maximize after tax retirement benefits Analysis of the most current/important research on retirement planning and sustaining retirement income levels and lifestyles and the impact of the most recent tax laws\, regulations\, and rulings Planning with the new retirement provisions of SECURE Act 2.0 \nInstructions\nNone URL:https://sc.cpa/event/ssot130-25-surgents-securing-a-comfortable-retirement/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225613Z LAST-MODIFIED:20250401T024704Z UID:10004700-1751284800-1751284800@sc.cpa SUMMARY:(SSAA247/25) Surgent's Monthly Accounting and Auditing Update (Original Air Date: 10/26/21) DESCRIPTION:Event Description\nThe one constant in life is change. This is true in the A&A world as well. 2021 will continue to challenge the accounting profession in many areas\, including accounting for the impact of the COVID-19 pandemic\, working in a virtual environment\, and implementing new AICPA and FASB pronouncements. In this monthly series\, we will explore the hot topics and current events that are driving financial accounting today\, such as auditing and SSARS standards implementation and getting ready for ASC 842 implementation. Through detailed discussion of new standards and commentary from relevant industry experts\, this monthly update will keep you up to date on what you need to know in the accounting world.So\, whether your area of specialty is employee benefit plans\, leases\, not-for-profit and governmental accounting\, or something else\, this monthly hour will give you what you need to know to do your job as effectively as possible. \nDesigned For\nAccounting and auditing practitioners at all levels desiring to remain up to date on recent pronouncements and other standard setters’ activities \nObjectives\nIdentify new standard-setting activities by the FASB and AICPA Review relevant guidance in COVID-19-related accounting topics Recall strategies for working effectively and complying with professional standards in a changing work environment Identify key success factors for the upcoming busy season \nMajor Subjects\nNew professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners \nInstructions\nNone URL:https://sc.cpa/event/ssaa247-25-surgents-monthly-accounting-and-auditing-update-original-air-date-10-26-21/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225614Z LAST-MODIFIED:20250401T034113Z UID:10004701-1751284800-1751284800@sc.cpa SUMMARY:(SSAA209/25) Surgent's FASB Update: New and Recent Accounting Standards Updates DESCRIPTION:Event Description\nDesigned for practitioners and their staff\, whether in public accounting or business and industry\, this course will provide you with an update of recently issued FASB Accounting Standards Updates (ASUs)\, and a review of the guidance related to ASC 842\, Leases\, which will be effective in 2022 for private companies. \nDesigned For\nPracticing CPAs and their staff\, both in public accounting and business and industry — controllers\, accountants\, and other financial accounting personnel involved in financial statement preparation and review \nObjectives\nIdentify and apply the latest FASB Accounting Standards Updates Review key challenges related to ASC 842 implementation \nMajor Subjects\nRecently issued FASB Accounting Standards Updates Implementation issues related to ASC Topic 842\, Leases \nInstructions\nNone URL:https://sc.cpa/event/ssaa209-25-surgents-fasb-update-new-and-recent-accounting-standards-updates/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225709Z LAST-MODIFIED:20250401T033222Z UID:10004702-1751284800-1751284800@sc.cpa SUMMARY:(SSAA117/25) Surgent's Accounting for and Auditing Inventory DESCRIPTION:Event Description\nMany entities have inventory on their books. The types of inventory can range from simple resale of goods purchased to more complex inventories that use process costing. This module will discuss accounting for and auditing less complex inventories and provide an overview of issues associated with auditing more complex inventories. Inventory observations were covered in an earlier module. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 3.) \nDesigned For\nAccounting and auditing practitioners at all levels desiring to develop a detailed understanding of inventory accounting. \nObjectives\nRecall the elements of inventory costing Apply inventory valuation methodologies to various types of inventory Determine reserve methodologies for inventory obsolescence Recall issues related to consignment inventory Assess risk and perform audit procedures on less complex inventories \nMajor Subjects\nElements of inventory cost and full-absorption costing Valuation methodologies\, including LIFO\, FIFO\, weighted average\, and specific identification Obsolescence reserves Retail inventory valuation basics Physical inventory observation approach refresher Accounting issues related to consigned inventory Risk associated with and steps performed in auditing of inventories. \nInstructions\nNone URL:https://sc.cpa/event/ssaa117-25-surgents-accounting-for-and-auditing-inventory/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225714Z LAST-MODIFIED:20250401T034320Z UID:10004703-1751284800-1751284800@sc.cpa SUMMARY:(SSTE113/25) Surgent's Data Analytics: Planning and Implementation Strategies DESCRIPTION:Event Description\nAs the rewards from data continue to grow\, companies must recognize the value of data to remain competitive in the current digital economy. Companies that use data in their business processes are outperforming those that do not. Data skills will become necessary in the next few years\, and your employees will need them to perform their jobs.In this course\, you will gain an understanding of how to transform your organization into a data-driven company. This understanding will increase your chances of successfully achieving your goal of implementing data analytics in your organization. \nDesigned For\nAnyone who needs a better understanding of how to go about implementing data analytics in their organization \nObjectives\nRecognize why business users need to develop data skills today Understand the limitations of Excel when working with data Be familiar with the data tools that are now available in Excel Understand how self-service business intelligence leads to data democratization Realize why the Power BI ecosystem is a good choice for implementing self-service business intelligence Plan for self-service business intelligence Implement self-service business intelligence \nMajor Subjects\nWhy have companies struggled to implement data analytics? What are the barriers you face in becoming a data-driven organization? How does self-service business intelligence help in developing a data-driven organization? Why is Power BI the self-service business intelligence application you should use? Why should everyone in your company be assigned a data role? \nInstructions\nNone URL:https://sc.cpa/event/sste113-25-surgents-data-analytics-planning-and-implementation-strategies/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225815Z LAST-MODIFIED:20250401T044811Z UID:10004704-1751284800-1751284800@sc.cpa SUMMARY:(SSTX179/25) 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/sstx179-25-surgents-multistate-tax-update/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225907Z LAST-MODIFIED:20250401T043918Z UID:10004705-1751284800-1751284800@sc.cpa SUMMARY:(SSAA159/25) Surgent's The Most Critical Challenges in Governmental Accounting Today DESCRIPTION:Event Description\nWith the leasing standard and other standards looming\, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today. \nDesigned For\nGovernmental industry professionals and auditors \nObjectives\nIdentify the critical changes occurring in governmental accounting today Skillfully implement today’s most challenging GASB standards More effectively audit governmental entities through superior knowledge of key accounting issues \nMajor Subjects\nLessons learned (and lessons remaining) from the implementation of GASB No. 87\, Leases How governments can prepare for and implement GASB No. 96\, Subscription-Based Information Technology Arrangements Additional recently issued GASB standards \nInstructions\nNone URL:https://sc.cpa/event/ssaa159-25-surgents-the-most-critical-challenges-in-governmental-accounting-today/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225909Z LAST-MODIFIED:20250401T051026Z UID:10004706-1751284800-1751284800@sc.cpa SUMMARY:(SSMG118/25) Surgent's Lessons Learned from Successful Companies DESCRIPTION:Event Description\nWhy do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership\, timing\, or unique ideas. Although these traits certainly play a role in helping companies grow\, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision.In this course\, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g.\, Disney\, Marriott\, or 3M)\, we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes\, including accounting and financial service firms. \nDesigned For\nAnyone in the accounting or financial organizations services professions who seeks to understand ways to implement or improve their profession \nObjectives\nUnderstand what differentiates highly successful organizations from their less successful peers\, according to research Recognize the myths regarding organizational success Implement strategies to improve corporate culture and effectiveness \nMajor Subjects\nCreating a visionary company Traits of successful\, visionary companies Goal setting to create a successful organization The role of experimentation and failure in achieving success How successful organizations emphasize learning new skills The role of effective communication in achieving corporate success The importance of emotional intelligence in building corporate culture How leadership can direct a company toward success \nInstructions\nNone URL:https://sc.cpa/event/ssmg118-25-surgents-lessons-learned-from-successful-companies/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T225914Z LAST-MODIFIED:20250401T040718Z UID:10004707-1751284800-1751284800@sc.cpa SUMMARY:(SSAA237/25) Surgent's How to Account for Internal-Use Software Arrangements DESCRIPTION:Event Description\nThis course provides an overview of the accounting for internal-use software. The accounting and reporting requirements related to internal-use software can be found within ASC Topic 350-40. The primary information addressed within this ASC Topic relates to the development costs that should and should not be capitalized\, how those costs are amortized\, how they are tested for impairment\, as well as presentation and disclosure requirements. \nDesigned For\nProfessional accountants \nObjectives\nDistinguish between software that is considered internal-use and not considered internal-use Recognize how implementation costs are accounted for in various stages of software development Identify when capitalization and amortization should commence Recognize how implementation costs of hosting arrangements are accounted for differently \nMajor Subjects\nDevelopment costs that should and should not be capitalized How these costs are amortized and how they are tested for impairment Presentation and disclosure requirements \nInstructions\nNone URL:https://sc.cpa/event/ssaa237-25-surgents-how-to-account-for-internal-use-software-arrangements/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T230012Z LAST-MODIFIED:20250401T045221Z UID:10004708-1751284800-1751284800@sc.cpa SUMMARY:(SSMG137/25) Surgent's Microsoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables DESCRIPTION:Event Description\nMicrosoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables is a two-lesson\, intermediate level course that guides you through organizing\, entering\, and validating worksheet data and then effectively sorting\, filtering\, subtotaling\, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with the data.In Lesson 1\, you learn how to organize columns and rows of data into a range so that you can effectively sort\, filter\, subtotal\, and outline the data. Then you learn how to protect the data from invalid data entry by setting data validation rules for specific cells. You learn how to copy these validation rules to other cells\, how to remove validation rules from cells\, and how to use the Data Form dialog box to enter and locate data in a range. Next\, you learn how to sort a data range on one column or on multiple columns and how to use a custom sort order\, the Filter (AutoFilter) feature\, and the Advanced Filter feature to view data that meets specific criteria. Then you learn how to add and remove subtotals from a data range while viewing the data range in outline form. You also learn how to create a chart using an outline’s subtotals.Finally\, in Lesson 2\, you explore the advantages of defining a range of data as an Excel table. You also learn how to analyze data using table tools.This course emphasizes using the traditional keyboard and mouse actions to perform tasks in Excel. \nDesigned For\nUsers experienced with using Excel 2019 in the Windows 10 operating system environment or experienced Excel users switching from earlier versions of Excel. \nObjectives\nIdentify the guidelines for a well-organized data range; select ways to create and test validation rules; select the Data Form for data entry Recognize ways to sort and filter a data range Select ways to add subtotals\, a grand total\, and data grouping to a data range Identify data range and table differences Identify multiple ways to define an Excel table using buttons on the Home and Insert tabs\, the Quick Analysis feature\, a keyboard shortcut\, and by formatting a data range as a table Recognize ways to enter data and formulas in a table; change table formatting; resize a table; scroll\, sort\, filter\, and summarize a table; and convert a table to a data range \nMajor Subjects\nIdentify the guidelines for a well-organized data range Enter\, test\, and copy validation rules Use the Data Form for data entry Sort and filter a data range Select ways to add subtotals\, a grand total\, and data grouping to a data range Identify data range and table differences Define an Excel table using buttons on the Home and Insert tabs\, the Quick Analysis feature\, a keyboard shortcut\, and by formatting a data range as a table Enter data and formulas in a table Change table formatting Resize a table Scroll\, sort\, filter\, and summarize a table Convert a table to a data range \nInstructions\nNone URL:https://sc.cpa/event/ssmg137-25-surgents-microsoftr-excelr-365-excelr-2019-working-with-data-ranges-and-tables/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T230017Z LAST-MODIFIED:20250401T020308Z UID:10004709-1751284800-1751284800@sc.cpa SUMMARY:(SSAA147/25) Surgent's Mastering Accounting for Income Taxes DESCRIPTION:Event Description\nSince its inception nearly 30 years ago\, many have continued to struggle with applying the current model for accounting for income taxes\, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and use of exercises\, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes\, income tax expense\, uncertain tax positions and other classification and disclosure requirements related to income taxes. We will also explore some specialized areas of income tax accounting\, such as intra-period allocations of income tax expense and accounting for changes in tax laws and rates\, and we will review proposed updates to ASC 740 disclosures on which the FASB is contemplating.In summary\, this course is the place to be to enhance your accounting for income taxes IQ. \nDesigned For\nPracticing CPAs and their staffs\, both in public accounting and business and industry — controllers\, accountants\, and other financial accounting personnel involved in financial statement preparation and review \nObjectives\nIdentify and calculate the deferred tax asset or liability for an entity Determine when and how to report uncertain tax positions Calculate and report the components of income tax expense Develop appropriate disclosures Comprehend recent and proposed changes to accounting guidance for income taxes \nMajor Subjects\nThe sources of deferred tax assets and liabilities Calculating the deferred tax asset or liability Reporting income-tax expense and balance sheet items CARES Act accounting implications Defining\, analyzing\, and reporting uncertain tax positions Classification of deferred tax assets and liabilities Disclosure requirements Recent and proposed changes to the accounting and disclosure requirements for income taxes \nInstructions\nNone URL:https://sc.cpa/event/ssaa147-25-surgents-mastering-accounting-for-income-taxes/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T230113Z LAST-MODIFIED:20250401T041322Z UID:10004710-1751284800-1751284800@sc.cpa SUMMARY:(SSAA234/25) Surgent's Internal Controls and COSO in a Post-COVID Landscape DESCRIPTION:Event Description\nCompanies that fall victim to fraud schemes need to reassess internal controls in order to prevent future fraudulent activity. In this course\, we will review the 18 most prevalent internal controls present as well as designed and operating effectively according to the Association of Certified Fraud Examiners’ Occupational Fraud 2022: A Report to the Nations. Then we will tie these controls to the 17 internal control principles offered by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)\, the framework used by virtually all entities and auditors to assess the design and operational effectiveness of internal controls. Lastly\, we will consider the impact of the 2020 pandemic on the internal control environment in the post-COVID pandemic era. \nDesigned For\nCPAs in public practice and industry who wish to educate clients or colleagues on how to assess internal controls and adapt in the post-COVID era \nObjectives\nUnderstand that fraud occurs in companies with seemingly sound internal control structures Assess how internal controls fit into the COSO framework and determine whether mitigating controls;are sufficient Understand the difference between reactions and responses to changing circumstances Recognize that the days of working in an office may be numbered (or certainly reduced) Recognize that the increase of remote work options presents new\, sometimes shocking challenges Understand that audits and other attestation engagements can actually be performed remotely\, reducing time and cost \nMajor Subjects\nACFE’s Occupational Fraud 2022: Report to the Nations and the most commonly found controls in fraud victim organizations; Internal controls in relation to COSO principles How to employ controls to cut losses How to modify controls in the post-COVID era Remote work circumstances and considerations \nInstructions\nNone URL:https://sc.cpa/event/ssaa234-25-surgents-internal-controls-and-coso-in-a-post-covid-landscape/ CATEGORIES:Self-Study Text END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20250630T120000 DTEND;TZID=America/Detroit:20250630T120000 DTSTAMP:20260406T020331 CREATED:20250331T230115Z LAST-MODIFIED:20250401T035818Z UID:10004711-1751284800-1751284800@sc.cpa SUMMARY:(SSTE122/25) Surgent's Power Query Series: Data Modeling and Next Steps DESCRIPTION:Event Description\nThis final course in the series covers advanced features in Power Query (Excel version)\, including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.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 last 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\nBe familiar with functions and parameters in Power Query Understand the basics of data modeling in Power BI and Power Pivot \nMajor Subjects\nFunctions and parameters Demonstration of invoking a function Basics of data modeling Power Query is everywhere Power BI preview features Hands-on examples: creating a data model from a flat file; transferring an Excel data model to Power BI desktop; preview feature: using text by examples in Power BI desktop \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste122-25-surgents-power-query-series-data-modeling-and-next-steps/ CATEGORIES:Self-Study Video END:VEVENT END:VCALENDAR