CPE & Event Calendar

This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Don't let the title frighten you. It is critical that staff be trained on the increasingly complex forms-related issues that challenge them each busy season. This course will help experienced staff focus on the essential amidst the cacophony of IRS and legislative changes and avoid costly mistakes. This course brings to the forefront advanced preparation issues, from individual returns to flow-through entities such as S corporations, LLCs, and partnerships.

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join us for our next monthly Government Accounting & Auditing Committee meeting! All MassCPAs members are welcome and you don't have to be a member of the committee to attend a meeting. CPE credit: In order to verify your attendance, you must log into Zoom with the same email address you used to register for this event. This email address should also be linked to your MassCPAs profile.To review or update your account, please click here. Join the committee! By joining the committee roster, you'll have special access to the Government Accounting & Auditing Committee Online Community on The HUB-an exclusive space for committee members to connect, post messages and access meeting resources. If you have any questions, contact Melissa at MNystedt@masscpas.org

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.

How much can you contribute to a Roth IRA, Roth 401(k), SEP Roth IRA, or SIMPLE Roth IRA? How will a Roth distribution qualify to be tax-free? How did SECURE Act 1.0 and SECURE Act 2.0 change the Roth rules? These are only some of the key Roth questions advisors must know the answers to. Plus, as Roth accounts have increasingly become an essential component of retirement savings portfolios, with one-third of IRA owners owning Roth IRAs, advisors have even more reasons to be Roth-proficient. To that end, the instructor will simplify critical rules that govern Roth funding and Roth distributions for Roth IRAs, Roth 401(k)s, and sister plans.

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.

Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.

This course equips practitioners with the knowledge to help clients navigate complex tax and financial challenges. Covering a range of difficult situations—such as divorce, bankruptcy, and other personal and business matters—this course provides key tax insights and strategic planning considerations. Participants will gain practical strategies to support clients in making informed decisions while understanding the tax implications of these situations.

Level 1 focuses on the basic skill sets that new staff need to quickly master in order to "hit the ground running," while not overwhelming them with too much information all at once. This course explains the basics of what new auditors are generally expected to know and do. This course will focus on "why" certain procedures are performed, as well as "how" to perform typical procedures expected of new staff. This course is critical in establishing the groundwork for the expectation that all staff should critically analyze and understand the underlying purpose of procedures, as well as how to effectively and efficiently complete assigned tasks. IMPORTANT NOTE: This course takes place over two consecutive days. Registration for both days is required.

There has never been a greater opportunity to leverage technology tools to automate various aspects of 1040 tax preparation. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your core 1040 tax prep software. You will learn how to leverage AI to automate the collection and organization of client source documents, enhance the engagement management process and add value to your 1040 service through AI enhanced 1040 advisory services. This course will separate the hype from reality about AI and how it can be used in 1040 tax preparation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This two-hour CPE course is designed for accounting professionals and technology enthusiasts seeking to enhance productivity through Microsoft 365's versatile applications. Participants will explore ten key apps - including Shared Mailboxes, Planner, Lists, To Do, Stream, Viva Learning, Forms, Bookings, Approvals, and Places - and learn to integrate them effectively into their workflows. The course emphasizes practical applications within accounting contexts, aiming to streamline operations and foster collaboration.