CPE Catalog & Events
Surgent's Power Query Series: Merge Queries
Available Until
Virtual
1.00 Credits
What is a merge query? What are the data requirements for a merge query? What are the types of joins for a merge query? Hands-on examples: creating merge queries, creating a full anti-join using an append query, grouping queries
Surgent's Power Query Series: More Transformations and Load Options
Available Until
Virtual
1.00 Credits
Workflow 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
Surgent's Power Query Series: Use Cases
Available Until
Virtual
1.00 Credits
Removing unwanted characters from a data set All data appears in one column Two categories appear in one column Extracting useful information from inconsistent data (Text Analytics) Have a sub-header that is in a row and should be in a column Hands-on examples
Surgent's Power Query Series: Useful Transformations
Available Until
Virtual
1.00 Credits
Data before and after transformation: unpivoting, pivoting, split to column by delimiter (by columns or rows) Filtering and grouping Fuzzy matching Hands-on examples
Surgent's Preparation and Compilation Engagements Under the SSARS
Available Until
Virtual
4.00 Credits
Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22, 23 and 24 Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements SSARS No. 21 implementation issues and peer review feedback
Surgent's Preparation and Compilation Engagements Under the SSARS
Available Until
Virtual
4.00 Credits
Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22, 23 and 24 Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements SSARS No. 21 implementation issues and peer review feedback
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until
Virtual
10.00 Credits
Preparation of a reasonably complicated Form 1120, “U.S. Corporate Income Tax Return,” from trial balance to completed return The importance of Schedule M-1, including adjustments in reconciling book income to tax income and items staff may look for on all business returns New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation under §168(k) as a result of new tax legislation Methods of accounting In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses, including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of common business deductions – deductibility and Schedule M-1 How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And more!
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until
Virtual
8.00 Credits
Preparation of a reasonably complicated Form 1120, “U.S. Corporate Income Tax Return,” from trial balance to completed return The importance of Schedule M-1, including adjustments in reconciling book income to tax income and items staff may look for on all business returns New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation under §168(k) as a result of new tax legislation Methods of accounting In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses, including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of common business deductions – deductibility and Schedule M-1 How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And more!
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Available Until
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act of 2022 and The SECURE Act 2.0 Preparation of various Form 1040 individual tax returns and schedules; provided answers include “filled-in” forms Coverage of Form 7203 Coverage of §199A qualified business income, its calculation, limitations, and examples Dividends and interest – Ordinary, return of capital, and capital gain distribution dividends; tax-exempt interest, original issue discount, etc. Security transactions – From Form 1099-B to Form 8949 to Schedule D, plus mutual fund sales and related basis issues Self-employed person issues Schedule C deductions including depreciation Sale and exchange of property – Understanding Form 4797 and depreciation recapture; capital gains A working understanding of passive losses – How to handle rental property and how the passive loss rules flow to the tax forms Itemized deductions – A thorough understanding of what’s deductible and what’s not Interest deductions – Limitations and timing problems Charitable contributions substituting for taxes, IRS says – No! Retirement contributions and education credits and deductions Tax computations – The Kiddie Tax, AMT, regular tax, tax credits Individual problems illustrated by form preparation for various items, with numerous “practice tips” Impact of recent legislation and forms changes on the 1040
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Available Until
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act of 2022 and The SECURE Act 2.0 Preparation of various Form 1040 individual tax returns and schedules; provided answers include “filled-in” forms Coverage of Form 7203 Coverage of §199A qualified business income, its calculation, limitations, and examples Dividends and interest – Ordinary, return of capital, and capital gain distribution dividends; tax-exempt interest, original issue discount, etc. Security transactions – From Form 1099-B to Form 8949 to Schedule D, plus mutual fund sales and related basis issues Self-employed person issues Schedule C deductions including depreciation Sale and exchange of property – Understanding Form 4797 and depreciation recapture; capital gains A working understanding of passive losses – How to handle rental property and how the passive loss rules flow to the tax forms Itemized deductions – A thorough understanding of what’s deductible and what’s not Interest deductions – Limitations and timing problems Charitable contributions substituting for taxes, IRS says – No! Retirement contributions and education credits and deductions Tax computations – The Kiddie Tax, AMT, regular tax, tax credits Individual problems illustrated by form preparation for various items, with numerous “practice tips” Impact of recent legislation and forms changes on the 1040
Surgent's Preparing Not-for-Profit Financial Statements
Available Until
Virtual
8.00 Credits
Key requirements, options, and disclosures related to each of the basic financial statements The reporting of functional and natural expense information Requirements related to providing liquidity and availability of financial assets information Core not-for-profit requirements related to conditional and unconditional contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more The impact of FASB ASC 842, Leases, on not-for-profits
Surgent's Preparing Not-for-Profit Financial Statements
Available Until
Virtual
8.00 Credits
Key requirements, options, and disclosures related to each of the basic financial statements The reporting of functional and natural expense information Requirements related to providing liquidity and availability of financial assets information Core not-for-profit accounting requirements related to conditional and unconditional contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more
Surgent's Preparing and Reviewing Client Prepared Financial Statements
Available Until
Virtual
2.00 Credits
Objective 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
Surgent's Principles of Financial Statement Presentation
Available Until
Virtual
3.00 Credits
The key presentation requirements with respect to an entity’s financial statements ASC topics related to presentation requirements, with a focus on ASC Topic 205, ASC Topic 210, ASC Topic 220, ASC Topic 225, ASC Topic 230, ASC Topic 235, and ASC Topic 250 Considerations around changes in accounting principles
Surgent's Privacy and Security Training: Obligations of Confidentiality and Safekeeping
Available Until
Virtual
2.00 Credits
Obligations of confidentiality and safekeeping Security best practices to apply beyond work Likely causes and effects of a large-scale cyberattack Email security best practices Remote work security Mobile device security Internet of Things (IoT) risks Public Wi-Fi risk and the importance of using a VPN Recognizing and avoiding text message/phone call phishing Data loss prevention (DLP)
Surgent's Professional Email Writing Basics
Available Until
Virtual
1.00 Credits
Create clear and concise email communication and utilize protocols that support and enhance your professionalism Best practices for excellent email etiquette Types of subject lines to avoid Subject line structure for maximum impact Creating effective greetings and sign offs When and how to use cc/bcc fields to avoid conflict and enhance connection Elevated “out of office reply” messages How to best convey the proper tone Avoiding common pitfalls How to handle misunderstandings and mishaps Examination of when to use text, instant messaging, or phone call instead of email Synthesizing ideas and using efficient methods of writing Creating concise email strings
Surgent's Progressive Discipline and Termination
Available Until
Virtual
2.00 Credits
Defining progressive discipline, including typical steps in any progressive discipline process The importance of a fair disciplinary process When and how progressive discipline should be used, including using progressive discipline in the lead-up to termination Documentation best practices Limitations on at-will employment, including contracts and laws regarding discrimination and retaliation Avoiding key risks in the termination process Best practices for legally compliant termination procedures
Surgent's Project Management for Finance Professionals
Available Until
Virtual
6.00 Credits
Project management is a way of thinking and managing Identifying projects, needs, objectives, and deliverables Project feasibility evaluation Life cycle of a project What causes projects to fail Establishing the project scope and preventing “project creep” Defining and managing stakeholders Organizational politics and conflict management Establishing the detailed schedule Introduction to project management software
Surgent's Project Management: Tips, Tricks, and Traps
Available Until
Virtual
4.00 Credits
Contrasting 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
Surgent's Project Management: Tips, Tricks, and Traps
Available Until
Virtual
4.00 Credits
Contrasting 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
