CPE Catalog
Excel for Staff Level 1 - What You Never Learned
Available Until
Online
2.00 Credits
Member Price: $109
Navigating around worksheets Selecting cells and ranges How to use custom number formatting How to leverage Views How to build better formulas with referenced variables and defined names How to quickly format cells with Cell Styles Proper worksheet structure
Excel for Staff Level 2 - Getting More Out of Excel
Available Until
Online
2.00 Credits
Member Price: $109
Overview of setting up spreadsheets for data analysis and how Excel tables can help Learning the importance of consistent column calculations How to use conditional formatting to highlight important information How to leverage Excel tables by analyzing them in PivotTables Learning to leverage array formulas
Excel: The Data Tools for Analysis - Power Query and Power Pivot
Available Until
Online
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
Exploring Client Advisory Services: Tax Due Dates and Penalties/Where Do I Need To File?
Available Until
Online
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
FASB Accounting Standards Update
Available Until
Online
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
FASB Update for Small and Medium-Sized Businesses: A Practical Implementation Guide
Available Until
Online
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
FASB Update: New and Recent Accounting Standards Updates
Available Until
Online
2.00 Credits
Member Price: $49
Recently issued FASB Accounting Standards Updates Implementation issues related to ASC Topic 842, Leases
Federal Tax Update
Available Until
Online
4.00 Credits
Member Price: $129
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the 2024 DOL Final Rule Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Federal Tax Update
Available Until
Online
4.00 Credits
Member Price: $79
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the 2024 DOL Final Rule Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
Available Until
Online
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 Effects of the CARES and Tax Relief Acts on trusts: §461(l) Excess Business Loss Limitation, NOL, §163(j) modifications, new employer credits Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
Available Until
Online
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
Financial Reporting Update for Tax Practitioners
Available Until
Online
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
Financial Reporting Update for Tax Practitioners
Available Until
Online
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
Financial Statement Disclosures: A Guide for Small and Medium-Sized Businesses
Available Until
Online
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
Financial Statement Disclosures: A Guide for Small and Medium-Sized Businesses
Available Until
Online
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
Finding Errors in Excel Spreadsheets
Available Until
Online
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
Firm Quality Control Standards and Best Practices
Available Until
Online
1.00 Credits
Member Price: $49
The major requirements of QC Section 10, A Firm’s System of Quality Control Elements of an effective system of quality control Considerations for sole practitioners and smaller firms when implementing QC Section 10 Guidance in implementing an effective firm-wide system of quality control across its six components
Focus on Engagement Quality: How to Avoid Deficiencies in Peer Reviews
Available Until
Online
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
Food, Beverage, and Entertainment Expensing
Available Until
Online
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
Form 1040 Return Review Boot Camp for New and Experienced Reviewers
Available Until
Online
8.00 Credits
Member Price: $159
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