CPE Catalog & Events
Surgent's Excel for Staff Level 3 - Build Reports and Analyze Data
Available Until
TBD
2.00 Credits
Member Price: $109
The steps for creating professional and functional Best practices for compiling and cleaning data for accurate analysis Applying formulas and functions to calculate meaningful insights Strategies for using formatting tools to create Data accuracy verification and potential error troubleshooting Methods for distributing reports effectively within your organization
Surgent's Excel: The Data Tools for Analysis - Power Query and Power Pivot
Available Until
TBD
1.00 Credits
Member Price: $59
Demonstration in Excel: where to locate the data tools of Power Query and Power Pivot Data skills demonstrated: data preparation and data modeling Demonstrations in Power Query – the Extract Transform and Load tool for data preparation of the Power BI ecosystem, including data sources Power Query can connect to; transformations; load options; operations; and sample of use cases Demonstrations in Power Pivot, the data modeling tool of the Power BI ecosystem, including query organization; custom columns; parameters; and database capabilities
Surgent's Exploring Business Valuation Fundamentals
Available Until
TBD
2.00 Credits
Member Price: $109
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
Surgent's Exploring Client Advisory Services: Tax Due Dates and Penalties/Where Do I Need To File?
Available Until
TBD
2.00 Credits
Member Price: $89
Estimated taxes and deadlines Tax due dates for common returns and filings Potential penalties and interest Information return penalties Penalties applicable to pass-through entities Accuracy-related penalties First-time abatement (FTA) FTA eligible returns Reasonable cause Nexus: sales tax vs. income tax Sales tax nexus with state specific examples Remote work and sales tax nexus Income tax nexus with state-specific examples Remote work and income tax nexus Sales factor: throwback rules
Surgent's FASB Accounting Standards Update
Available Until
TBD
1.00 Credits
Member Price: $49
FASB Accounting Standards Updates issued in 2020 and 2021 to date Items on which the PCC is consulting Projects on the FASB’s Technical Agenda
Surgent's FASB Update for Small and Medium-Sized Businesses: A Practical Implementation Guide
Available Until
TBD
8.00 Credits
Member Price: $159
Private company standard setting activities FASB Accounting Standards Updates (ASUs) relevant to smaller businesses Lease accounting implementation guidance ASC 326, Credit Losses Accounting for income taxes Accounting for debt instruments
Surgent's FASB Update: New and Recent Accounting Standards Updates
Available Until
TBD
2.00 Credits
Member Price: $49
Recently issued FASB Accounting Standards Updates Implementation issues related to ASC Topic 842, Leases
Surgent's Federal Tax Update
Available Until
TBD
4.00 Credits
Member Price: $79
Comprehensive coverage of individual provisions of the One Big Beautiful Bill Act, including but not limited to: TCJA provisions made permanent New Tip Income Deduction New Overtime Pay Deduction New Car Loan Interest Deduction New Temporary Senior Deduction Expanded SALT Cap Trump Accounts Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges and employer reporting responsibilities Timely coverage of breaking tax legislation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Surgent's Federal Tax Update
Available Until
TBD
4.00 Credits
Member Price: $129
Comprehensive coverage of individual provisions of the One Big Beautiful Bill Act, including but not limited to: TCJA provisions made permanent New Tip Income Deduction New Overtime Pay Deduction New Car Loan Interest Deduction New Temporary Senior Deduction Expanded SALT Cap Trump Accounts Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges and employer reporting responsibilities Timely coverage of breaking tax legislation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
Available Until
TBD
10.00 Credits
Member Price: $189
Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done? Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
Available Until
TBD
8.00 Credits
Member Price: $199
Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done? Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Surgent's Financial Reporting Update for Tax Practitioners
Available Until
TBD
8.00 Credits
Member Price: $159
Recent 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
Surgent's Financial Reporting Update for Tax Practitioners
Available Until
TBD
8.00 Credits
Member Price: $199
Recent 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
Surgent's Financial Statement Disclosures: A Guide for Small and Medium-Sized Businesses
Available Until
TBD
4.00 Credits
Member Price: $129
Financial statement disclosures for small and medium-sized businesses Balance sheet, income statement, and statement of cash flows presentation and disclosure issues Disclosure examples from all sized entities which you can use to base your disclosures on Developing disclosure issues, including disclosures related to the adoption of Topic 606
Surgent's Financial Statement Disclosures: A Guide for Small and Medium-Sized Businesses
Available Until
TBD
4.00 Credits
Member Price: $79
Financial statement disclosures for small and medium-sized businesses Balance sheet, income statement, and statement of cash flows presentation and disclosure issues Disclosure examples from all-sized entities that you can use to base your disclosures on Developing disclosure issues, including disclosures related to the adoption of ASC 606 and ASC 842
Surgent's Finding Errors in Excel Spreadsheets
Available Until
TBD
2.00 Credits
Member Price: $109
Common Excel errors, including formula errors, reference errors, and logic errors Advanced Excel functions and formulas that are crucial for error detection and data analysis Data validation techniques, including setting up data validation rules and using conditional formatting to highlight potential inaccuracies Error tracing and auditing tools, including Trace Precedents, Trace Dependents, and the Error Checking tool
Surgent's Focus on Engagement Quality: How to Avoid Deficiencies in Peer Reviews
Available Until
TBD
8.00 Credits
Member Price: $159
AICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Issues related to compilations and reviews Issues related to employee benefit plans Issues related to Government Auditing Standards/Single Audits Best practices in documentation
Surgent's Food, Beverage, and Entertainment Expensing
Available Until
TBD
2.00 Credits
Member Price: $89
The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment
Surgent's Form 1040 Return Review Boot Camp for New and Experienced Reviewers
Available Until
TBD
8.00 Credits
Member Price: $159
Key provisions of the recent HR 1, One Big Beautiful Bill Act, have been incorpoated throughout the course Review 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 the main credit provisions as enacted under the American Rescue Plan What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters, questionnaires, and §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
Surgent's Form 1040 Return Review Boot Camp for New and Experienced Reviewers
Available Until
TBD
8.00 Credits
Member Price: $199
Key provisions of the recent HR 1, One Big Beautiful Bill Act, have been incorpoated throughout the course Review 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 the main credit provisions as enacted under the American Rescue Plan What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters, questionnaires, and §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