CPE Catalog & Events

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

Each year brings its own set of tax planning challenges, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients, but in particular, wealthy clients, middle-income clients, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives, while also bringing value to you and your firm. This material is continuously updated for recent legislation impacting individual taxpayers.

This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.

The course provides a comprehensive, hands-on, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns, along with the underlying laws, regulations, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be aware of. The theoretical concepts get illustrated in comprehensive examples that incorporate the most up-to-date law changes and provisions.

A beginner's guide or a refresher on the essential elements of partnership and LLC taxation.

*** Save 15% on this event when you use the code SAVE15 at checkout *** Get important tax updates from popular instructor and tax guru Art Auerbach, CPA, in the monthly tax webinar series.   This course has been approved for CPE credit by the Internal Revenue Service (IRS). IRS CPE sponsor ID   Delivery Method: Group internet-basedCPE Credit: TaxesProgram Level: Update

This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future! Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence, such that personal and employer liability is avoided.

This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

Companies reporting under International Financial Reporting Standards (IFRS) continue to face a steady flow of new standards and interpretations. The resulting changes range from significant amendments of fundamental principles to some minor changes from the annual improvements process. The changes will affect different areas of accounting, such as recognition, measurement, presentation and disclosure.  It can be time-consuming and confusing to keep up-to-date on the resulting impact on financial statements and disclosures. This course will provide an executive summary of recent IFRS updates with current and upcoming effective dates.  

This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities.

The role of today's financial leader, including CFO, transcends traditional financial stewardship; it demands agility, innovation, crisis management, and strategic foresight. This seminar will discuss the new, multifaceted skills and insights needed to excel in the dynamic role of modern finance. Through a blend of theory, research, and practical exercises, participants will explore the diverse roles of a CFO as innovation champions, technology evangelists, crisis managers, and change agents - leveraging practical principles to drive organizational success. Financial leaders can adapt or be left behind. Whether you are a seasoned CFO or aspiring to step into a leadership position, this seminar will discuss the essential tools and insights to navigate the newer demands of financial managers with confidence and competence.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many clients end up selling one or more residences during their lifetimes. Tax practitioners must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides general tax practitioners with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.

Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence.

Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.

Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.

This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders.