CPE Catalog & Events
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 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
Surgent's Form 1065 Boot Camp: Step-by-Step Preparation with Completed Forms
Available Until
TBD
8.00 Credits
Member Price: $159
Comprehensive coverage of HR 1, One Big Beautiful Bill Act Gain a thorough understanding of federal income tax laws for partnerships and LLCs, from formation to tax return preparation issues Filing requirements for Schedules K-2 and K-3 Who files Form 1065, and who does not file Form 1065 Tax Basis Capital Account Reporting Requirements Trade or Business income and expenses versus Separately Stated Items The importance of Schedule M-1 Partnership distributions -- current or liquidating, cash or property How to allocate recourse and nonrecourse debt Self-employment tax issues; court cases and trends in tax audits of earnings subject to self-employment taxes Complete coverage of any new legislation enacted before presentation Section 163(j) limitations Mastering two common tax forms, Depreciation (4562) and Sale of Assets (4797) Final regulations on Section 168(k) Partnership reporting oddities Accurately preparing partnership returns and reconciling book income to taxable income The Centralized Audit Regime under the Bipartisan Budget Act of 2015
Surgent's Form 1065 Boot Camp: Step-by-Step Preparation with Completed Forms
Available Until
TBD
8.00 Credits
Member Price: $199
Comprehensive coverage of HR 1, One Big Beautiful Bill Act Gain a thorough understanding of federal income tax laws for partnerships and LLCs, from formation to tax return preparation issues Filing requirements for Schedules K-2 and K-3 Who files Form 1065, and who does not file Form 1065 Tax Basis Capital Account Reporting Requirements Trade or Business income and expenses versus Separately Stated Items The importance of Schedule M-1 Partnership distributions -- current or liquidating, cash or property How to allocate recourse and nonrecourse debt Self-employment tax issues; court cases and trends in tax audits of earnings subject to self-employment taxes Complete coverage of any new legislation enacted before presentation Section 163(j) limitations Mastering two common tax forms, Depreciation (4562) and Sale of Assets (4797) Final regulations on Section 168(k) Partnership reporting oddities Accurately preparing partnership returns and reconciling book income to taxable income The Centralized Audit Regime under the Bipartisan Budget Act of 2015