CPE Catalog & Events

Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.

Understanding the term "QBI" (qualified business income). Understanding the terms "SSTB" (specified service trade or business). Understanding the term "QTB" (qualified traded or business). Calculate the 199A deduction Understanding the phaseouts. Understanding "aggregation". Rental property as a trade or business. Identify how your clients can maximize the deduction. Planning ideas. Understand the Section 199A Regulations.

How to take advantage of the data available to you. Managing data, including avoiding duplication. Sharing data across multiple applications.

The importance of Business Intelligence in today's business climate. Differentiating between Power BI licensing options. A hands-on approach to creating effective Power BI reports and dashboards.

Understanding the small business accounting landscape. Learn how solutions from leading providers can potentially solve your small business accounting and reporting issues. Create investment estimates for acquiring and implementing a new small business accounting solution.

Recently issued FASB Accounting Standards Updates. PCC Update and items on the FASB's Technical Agenda. Leases - Topic 842, ASC 326: CECL. Review of SAS 142 - Focus on Audit Evidence. Recently issued SASs and other AICPA activity. SSARS No. 25 and other recently issued SSARS. Detailed review of SAS 145. Other important A&A practice matters.

Get up to speed on the latest legislative changes affecting tax law and rules in Washington and beyond. Learn how to comply with the new requirements and adapt to the changing environment. Hear from experienced tax attorney who will discuss the most important and relevant tax cases of the year, including Landis v. Department of Revenue and Antio v. Department of Revenue. Learn how these cases impact your tax practice and apply the lessons learned to your own situations. Explore the complexities and controversies surrounding the new capital gains tax in Washington. Learn how to calculate and report your capital gains, as well as how to avoid or reduce your tax liability. Find out what fixes and clarifications are being proposed or implemented by the legislature and the Department of Revenue. Understand the principles and methods of service apportionment in Washington and other states. Learn how to determine the source of your service income and allocate it to the appropriate jurisdictions. Discover the best practices and common pitfalls of service apportionment and how to resolve any issues or disputes. Stay on top of the latest developments and trends in multistate income taxation. Learn how to navigate the different rules and regulations of various states and how to manage your multistate tax obligations. Gain insights and tips from multistate tax experts and practitioners. Get a comprehensive overview of the current state of Oregon tax law and policy. Learn about the major changes and updates that have occurred or are expected to occur in the near future. Find out how these changes affect your Oregon tax filings and plan accordingly. Review the key aspects and requirements of Washington payroll related taxes, such as Labor and Industries (L&I), Employment Security Department (ESD), and Paid Family and Medical Leave (PFML). Learn how avoid penalties and interest by following the best practices and guidelines of payroll tax compliance. Learn about the scope and application of Washington sales and use tax on digital goods, digital automated services, and advertising. Find out how to classify and tax these transactions and how to deal with any nexus or sourcing issues. Understand the implications and challenges of the digital economy and how to stay ahead of the curve.

Overview of mid-market solutions. Probable third-party solutions required Accounting solutions for specific industries. Specific strategies to use on selecting a system. Guidance on preparatory steps and conversions.

Fundamental Excel techniques all accounting and financial professionals should know and use. Creating date-based calculations in Excel. How to create Excel templates. Key options you should enable in Excel. Linking data in Excel.

The rise of business intelligence (BI), business analytics (BA), and Big data. Why the interest in BI and BA? The analytics continuum. How BA can provide a competitive advantage. The difference between BI and BA. The difference between forecasting and predictive analytics. Fundamentals of analytical techniques. Examples for the CFO and accounting function. Benefits from applying analytics. The impact of artificial intelligence (AI) on the accounting profession.

Getting started with Excel macros by using the Macro Recorder. Fundamentals of writing VBA code. Saving and sharing macros. Getting started with User-Defined Functions.

Implications for individuals. Changes to the Saver's Credit. Changing the required minimum distribution rules for Roth 401(k)s. Changes to required beginning dates for required minimum distributions of retirement plans. Penalty free withdrawals for certain emergency expenses. Special provisions for firefighters and military personnel spouses. Increases in catch-up contributions. Impact on 529 plans. Opportunities for student loan payment matching.

Why great predictions are not intuitive but the result of critical thinking, gathering information and updating predictions when needed. How to separate correlation from causation. How to recognize and overcome bias. Who is Thomas Bayes and why he matters.

The shift to "predictive accounting" for Decision Making, Planning, and Budgeting. Problems with traditional annual budget processes. Develop a driver-based "operational budget" based on resource capacity planning. Classify resource capacities and their expenses as sunk, fixed, step-variable, and variable. Create closed loop capacity plans. Forecast demand for budgeting and rolling financial forecasts. Integrating enterprise risk management (ERM) with management accounting. Applying target costing for cost estimating.

Auditing. Fraud.

Implications for Employers. Starter 401(k) plans for small employers. Requiring automatic 401(k) enrollment. Improving worker access to emergency savings. Increasing part-time workers' access to retirement accounts. Statute of Limitations on excise taxes imposed on overcontributions to retirement plans. Multiple employer 403(b) plans. Automatic portability provisions. Other changes in the administration of company retirement plans

Communication. Social media. Marketing. Publicity. Public relations. Business strategy.

Getting started with Excel macros by using the Macro Recorder. Fundamentals of writing VBA code. Saving and sharing macros. Getting started with User-Defined Functions.

Federal laws providing greater visibility of sexual harassment and sexual assault claims. Agency rulings curtailing confidentiality and non-disparagement clauses in agreements.

CPA firm centric hardware. Software changes. Technology options for your firm. Specific technologies to improve productivity and profitability. Strategic products to consider for implementation.