CPE & Event Calendar

This session will provide a basic overview of Employee Stock Ownership Plans (“ESOPs”). It will specifically address what companies are well suited for establishing an ESOP, how ESOPs are implemented, and how employees and departing owners alike can benefit from them. The session is intended to provide business and tax advisors with talking points about how an ESOP may be used as a succession planning strategy.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webinar helps attendees gain an understanding of Corporate Transparency Act and Beneficial Ownership Information (BOI) reporting operations within firms. Learn about the procedures, challenges, and best practices for compliance. Gain strategies to minimize your liability while effectively supporting clients in adhering to CTA requirements. Find out the necessary tools to navigate the complexities of the Corporate Transparency Act and enhance your professional practice. Attendees will get the tools they need to make a decision on: Whether to incorporate BOI reporting into their service portfolio. How to incorporate it. The difference between manual, direct filing to FinCEN vs and automated software solution. FincenFetch is a leading Corporate Transparency Act filing platform for CPAs and attorneys. The company offers SOC2-certified solutions trusted by hundreds of firms, including many of the top 100. FincenFetch features integrate seamlessly into CPA processes, allowing accountants to offer their clients secure, automated, and easy BOI reporting.

Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-1725. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org. This 4 Hr webinar focuses on the preparation of the Uniform Financial Statement. Changes to the 2024 Audit & Preparation Manual including Chapter 257 changes will be highlighted.  Directives contained in Manual addendums and revisions will be discussed. Topics include general Schedule B program definitions and types, specific program requirements, impact of COVID funding, PPP loan forgiveness, obsolete UFR lines and sections, specific line item usage, reporting contributions in programs, correlation of client revenue lines with program statistics, capital budget assets, FTEs, blue flags, salary limits, allocation of administration expense, required supplemental schedules, VendorWeb data, the Federal Funds Listing – contract numbers, MMARS and object codes, the use of pivot tables to generate UFR data your clients can understand, available analytical tools, and more. Included is a list of common errors from the 2020 UFR database as well as common but unnecessary reporting.

What were they thinking? Why do business leaders sometimes make horrible decisions that severely damage themselves and their organizations? It is tempting to assume that poor choices must be due to someone's incompetence, inexperience, bad character, or low intelligence. Yet, when we make a mistake ourselves, we someone rationalize it as a choice other people would make under the same circumstances. This session will discuss the common decision-making errors people make and to help you avoid making these blunders yourself. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Build your network and make lasting connections with peers who can help you throughout your career. You will stay up-to-date on hot topics in accounting, plus engage in meaningful dialogue on the issues affecting your organization. This is a forum to share ideas, resources and establish a robust network of accounting peers who you can turn to for guidance and advice. Whether you recently left public accounting or you've been with your organization for decades, all industry members are encouraged to participate. Please reach out to Melissa Nystedt at mnystedt@masscpas.org with topics and questions. CPE Credit: In order to verify your attendance, you must log into zoom using the same email address used to register for this event and linked to your MassCPAs profile 

The course provides a concise overview of cognitive biases - thinking errors and "brain bugs" that may distort perceptions, compromise ethics, trigger inaccurate judgments, and spark illogical interpretations in your accounting work. Discover the most common types of cognitive biases in the profession, and how to recognize and address these flaws and blindspots in your "mental firmware". This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The newest acronym in the business community is ESG (Environmental, Social and Governance) Investors’ demand enhanced information about how companies are approaching environmental sustainability. (Sustainability accounting) The foundation of sustainability reporting is for an organization to identify and prioritize its impacts on the economy, environment, and people - to be transparent about their impacts The foundation of sustainability reporting is for an organization to identify and prioritize its impacts on the economy, environment, and people - to be transparent about their impacts This session is an introduction to the topic of ESG and what accountants and management should know

This program focuses on two parts of Subchapter K, partnership distributions and sales of partnership interests - topics that tax practitioners are often asked about by clients. Tax practitioners are called upon to advise both the partnership which makes distributions and the partners receiving the distributions regarding the tax consequences of these transactions. Additionally, tax practitioners will be deeply involved in decisions regarding the sale and purchase of a partnership interest. These topics are thoroughly covered in this program. The presenters also discuss several types of partnership distributions and the tax rules relating to them, as well as analyze the tax rules relating to the sale of a partnership interest. Tax practitioners will be given an in-depth analysis of these complex topics, so that they can effectively answer their clients' questions.

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including revenue recognition, contributions, and leases. The course materials utilize a highly illustrative and innovative format, including over 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

Effective January 1, 2024, an estimated 32.6 million entities will be required to report information about their beneficial owners to FinCEN as part of the Corporate Transparency Act (CTA). In an effort to combat money laundering and other illegal activities, the law provides harsh penalties for the failure to report the required information. This reporting specifically targets small businesses and holding entities, creating opportunities for accountants, tax practitioners, and other business advisors to expand their service offerings. The reports require the listing of all "beneficial owners," and they are imprecisely defined, possibly requiring an exercise of judgement. Therefore, proper education of professionals and business owners is paramount for accurate reporting. The course includes an overview of the CTA and a detailed discussion of what information needs to be reported to FinCEN.

It's not about top-down management anymore - things have changed. For organizations to be successful today, everyone needs to contribute. Our success depends not just on how you manage those who report to you but also on those to whom you report. The world is too complex now for any one person to have all the answers. Sometimes those in charge need and want your support. Learn how to manage the managers in "Managing Up the Ladder." It takes a special finesse and approach. You'll learn strategies for acquiring buy-in from those above you in the organization and tools for more effective communications and building respect.

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-2138. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.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 format your spreadsheets quickly and efficiently 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.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.