CPE Catalog & Events

Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.

Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.

This course provides a focused update on major recent pronouncements issued by the Governmental Accounting Standards Board (GASB). Coverage includes GASB Statement No. 103 (financial reporting model), GASB Statement No. 104 (disclosures for capital assets), and GASB Statement No. 105 (subsequent events). Participants will also receive a high-level overview of active GASB exposure drafts and ongoing projects. The course is designed to help auditors, preparers, and financial leaders understand how these developments affect audits, financial statement preparation, and board reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses.

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations.

This comprehensive course delves into the intricate world of executive compensation, focusing on the taxation and reporting procedures for various types of compensation arrangements. Participants will gain a deep understanding of the key differences between incentive stock options (ISOs) and nonqualified stock options (NQSOs), as well as the tax treatment and reporting requirements for restricted stock awards, stock appreciation rights (SARs), phantom stock plans, and employee stock purchase plans (ESPPs). The course will also cover the accurate analysis of tax forms and schedules used for reporting executive compensation, common tax reporting errors to avoid, and strategies for handling extensions, estimated taxes, and increased IRS scrutiny.

This session provides a comprehensive analysis of meals and entertainment regulations under IRC 274 as amended by the Tax Cuts and Jobs Act. Participants will learn how to identify deductible vs. nondeductible expenditures, interpret the regulatory definitions surrounding "entertainment," "business associate," and reimbursement arrangements, and apply the numerous exceptions under IRC 274(e), including compensation, recreational activities, public availability, and goods or services sold to customers. Using examples from the final regulations, we will dissect key distinctions such as separately stated food and beverage costs, employer-provided meals, and the treatment of per diem reimbursements. This course equips practitioners with the technical precision required for compliance, documentation, and audit defense. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Reconciliation is how you confirm that your QuickBooks Online checking accounts, savings account, credit cards, loan balances, and liabilities are correct. If you don't reconcile correctly every month, your reports will be wrong! Even if you use the QuickBooks Online banking feed, it's not a guarantee that your bank balances are correct. And when you have extra or missing transactions, your Profit & Loss and Balance Sheet are wrong! Reconciliation is the monthly step to confirm your checkbook balance, credit cards, liabilities, and loans have been entered correctly. The problem is that most businesses reconcile the transactions that ARE on the statement, but ignore the ones that are not. That's not Reconciling, that's "reconciling," and the result is that you may be paying your taxes wrong! In this class, not only will Alicia show you how to reconcile properly, but she'll show you how to trick out the interface to finish in seconds instead of hours. Even better, learn how to identify errors in your accounting data by how they appear in your Reconciliation window. Use reconciling as a troubleshooting tool for duplicated entries, misclassified categories, transactions coded to the wrong funding source, and receipt captures that didn't match the banking feed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture

Is teamwork the ultimate competitive advantage" Every manager's primary purpose is to lead a team. This seminar will help you get every member of your team on the same page, improve performance and realize the potential of the talent you have.

We're all impacted directly or indirectly by the laws of real estate taxation, possibly as an owner, investor, landlord, developer, or real estate professional. This course explores the key principles of real estate taxation from all these perspectives. We'll discuss personal residences, vacation homes, credits, passive losses, qualified business income, installment sales, involuntary conversions, like-kind exchanges, real estate investment trusts (REITs), and the One Big Beautiful Bill's enhancement of depreciation deductions.

Theoretical conundrums and compliance issues Multistate taxation has never been more relevant. This course helps you skillfully navigate the maze of corporate tax codes across jurisdictions. Learners get fresh perspectives on: Interstate activity and nexus Modifications to federal tax income to arrive at state taxable income Allocation and apportionment Filing methods for multistate taxpayers By spotlighting updates on the latest state tax reforms, this course will help you develop a working knowledge of both multistate tax compliance and related planning opportunities.

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area. It will be updated and supplemented throughout the year to cover breaking developments.

Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting and finance practitioners are continually asked for strategic planning advice. In this course, we will cover topics that will make clients, and their advisors, tax smart and tax prepared for the coming year and beyond. This program is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting both individual and business clients.

This professional development course equips you with practical strategies to manage challenging interactions in the workplace. Although difficult individuals may represent a small segment of the workforce, their impact can be significant, often leading to time lost and decreased productivity. In this course, you will gain essential skills to address and navigate these situations effectively. Additionally, you'll identify specific challenges and develop a personalized action plan for implementing the strategies learned back in your workplace.

This course provides a comprehensive overview of SOC 2 reports, focusing on their structure, purpose, and how to interpret and apply them in a compliance or risk management context. Participants will learn about the five Trust Services Criteria (Security, Availability, Processing Integrity, Confidentiality, and Privacy), the difference between Type I and Type II reports, and the key components of a SOC 2 report including the system description, management assertion, and testing results. The course also covers common pitfalls in relying on SOC 2 reports and best practices for evaluating scope, subservice providers, and complementary user controls. Designed for auditors, compliance professionals, and vendor risk reviewers, this session equips attendees to effectively analyze and apply SOC 2 reports in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is designed to present the most common types of financial statement fraud and embezzlement, illustrated through real cases and situations. We'll distinguish financial reporting fraud from misappropriation of assets and highlight common schemes involving one or both types of fraud. We'll review high-profile cases and other real-world situations to emphasize the CPA's role and responsibility. This course will also touch on updated GAAS requirements. Get ready to examine the methods used to perpetrate and disguise schemes, learn how fraud can be detected by both management and auditors, and explore the CPA's role in preventing and detecting both types of fraud.