CPE Catalog & Events
ACPEN: Excelling at Excel: The Magic of Power Query
-
TBD
2.0 Credits
Member Price: $89
Intro to Power Query & how to get started Examples of data clean up using Power Query Combining workbooks and files with Power Query
ACPEN: K2's AI Accounting And Fraud Detection
-
TBD
2.0 Credits
Member Price: $89
AI-based accounting software and general ledger innovations ROI measurement and tech investment strategy Low-code/no-code and vibe coding for process automation
ACPEN: K2's Ripped From The Headlines: Lessons Learned From The Most Interesting Tech Crimes
-
TBD
2.0 Credits
Member Price: $89
Financial fraud and embezzlement case studies Cybercrime, data breaches, and AI-enabled fraud Practical ethics, controls, and compliance lessons for prevention
Surgent's A Complete Guide to Reporting Form 1099-DA
-
TBD
2.0 Credits
Member Price: $119
Definition of a digital asset for purposes of Form 1099-DA What is a sale of a digital asset affected by a broker on behalf of another person? Mandatory 2025 reporting of gross proceeds information and voluntary reporting of basis information Treatment of sales of digital assets Who is a broker for purposes of Form 1099-DA? Information required to complete Form 1099-DA Reporting closing transactions and covered securities Who is a processor of digital asset payments? How many transactions to report on each Form 1099-DA and how many forms to file for each transaction Optional reporting methods for digital asset transactions Substitute statements for the Form 1099 Reporting a disposition of digital assets held by a widely held fixed investment trust
Surgent's Excel: Mastering PivotTables
-
TBD
2.0 Credits
Member Price: $99
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
TBD
2.0 Credits
Member Price: $99
The new Roth SEP IRAs and Roth SIMPLE IRAs created under SECURE Act 2.0 Key factors for choosing a retirement plan for a small business Key questions an advisor must ask a small business owner to help determine which retirement plan is suitable for their business Key questions an advisor must ask a small business owner to help ensure compliance with applicable rules and regulations How SEP and SIMPLE IRAs benefit the small business owner How SEP and SIMPLE IRAs benefit employees of small businesses The tax benefits that help to offset the cost of employer contributions How to determine which business is eligible to adopt a SIMPLE IRA or SEP IRA How to determine which employees must be covered
ACPEN: The Complete Guide to the Preparation of Form 1041
-
TBD
8.0 Credits
Member Price: $250
Step-by-step Form 1041 preparation Key issues in decedent’s estates and trusts Understanding Subchapter J and its impact on taxation Compliance strategies for fiduciary entities Tax treatment of DNI and IRD Case studies illustrating real-world application Legislative updates affecting estate and trust taxation
Surgent's Guide to Payroll Taxes and 1099 Issues
-
TBD
4.0 Credits
Member Price: $159
Statutory employees, independent contractors, and possible changes to §530 relief Using SS-8 Payroll Tax Penalties -- Who is a responsible person? Forms W-2, 1099, 1099-NEC, SS-8, W-4, 941, and Form 940 reporting/deposit requirements and due dates Understanding payroll tax responsibilities in the gig economy
ACPEN: Addressing Misconduct
-
TBD
1.0 Credits
Member Price: $39
Insubordination Personality and attitude problems Generalized disparaging comments Previously unaddressed conduct Misconduct due to mental condition Corrective action meetings and documentation Attendance control
ACPEN: The Controllership Series - The Controllers Role in Financial Forecasting
-
TBD
1.5 Credits
Member Price: $79
Accounting Finance
ACPEN: Introduction to Governmental Accounting 102
-
TBD
1.0 Credits
Member Price: $89
Major and Non-major funds Basis of accounting variations Why geography matters in a financial statement report
Surgent's How to Effectively Represent Clients Under IRS Audit
-
TBD
2.0 Credits
Member Price: $99
Why the IRS selects a tax return for audit What happens when the taxpayer disagrees with the results of the audit IRS employees who interact with taxpayers during an audit FATCA audits Types of IRS examinations Potential IRS audit outcomes Substitute for returns Large Partnership Compliance Program IRS’s shift in audit strategies Responding to IRS Notices online Audits of high income and high net-worth individuals The Bipartisan Budget Act of 2015 (BBA) and its impact on auditing partnerships IRS Letters of Concern
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
TBD
2.0 Credits
Member Price: $99
The evolving landscape of client expectations in the accounting profession Building strong and lasting client relationships through effective communication, empathy, and proactive service Implementing efficient client onboarding and engagement processes Leveraging technology to streamline communication, enhance collaboration, and deliver personalized service Effectively resolving client concerns and complaints Utilizing client feedback to continually improve your practice
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
TBD
2.0 Credits
Member Price: $119
Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!
ACPEN: Guide to Deducting Travel, Meals and Entertainment Expenses
-
TBD
4.0 Credits
Member Price: $149
Recent tax legislation, rules and developments impacting travel and meals expense reporting Adequate accounting rules for reimbursements, including accountable plans, going paperless, reimbursement for non-deductible expenses Reporting travel expenses: travel status, simplified per diem "Directly related to" and associated with" tests Facility vs. activity expenses 9 exceptions to Section 274 Business meals: IRS Notice 2018-76
ACPEN: Using Psychology Secrets to Love your life and Get More Done
-
TBD
4.0 Credits
Member Price: $149
What makes people really happy—and what doesn’t The 3 most important things you can do to increase both happiness and productivity How to handle stress in under two minutes How to deal with difficult people so they don’t bring you down How to use positive psychology principles to help your business
ACPEN: Preparing and Reviewing Workpapers for Higher Quality Audits
-
TBD
4.0 Credits
Member Price: $149
The primary purpose of workpaper documentation, and minimum documentation requirements for workpaper preparers Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards
ACPEN: Partnership Checkup: Tax Issues & Forms Reporting
-
TBD
4.0 Credits
Member Price: $149
Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis Impact of contributed property Explain the importance of shareholder loans to the entity Discuss how basis is impacted by distributions of corporation property and the sale/or liquidation of the S corporation interest Comprehensive examples illustrate the mechanics of the basis determination process Discusses how S corporation losses impact Form 1040 Schedule E reporting How to get from the Schedule K-1 information to the basis calculations
ACPEN: Preparing and Reviewing Workpapers – Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
TBD
8.0 Credits
Member Price: $250
Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation
ACPEN: K2's Dynamic Arrays In Excel
-
TBD
1.0 Credits
Member Price: $39
Differentiating between dynamic arrays and traditional Excel formulas Identifying which functions support dynamic arrays Using dynamic arrays to link data from external data sources