CPE & Event Calendar

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

There are numerous federal laws that restrict what businesses can do in terms of hiring and firing employees. Many of these laws impose significant penalties if employers violate them. Accordingly, it is crucial that all employers and their professional advisors understand these laws and apply them to their employment practices.

You could pay $0 for this course!"Automation can be incredibly helpful for saving time, improving accuracy, promoting effectiveness, and getting more value out of your workday. One of the best things a person can do is to invest time into automating their workday because it will help them to complete more work in the same period of time, reduce daily stress and provide better mental clarity. Automation can be permanent time savings for a person, once something is automated you always get that time back on a project.This course will discuss the various tools, methods, apps, websites, and more that a person can use to help promote personal automation in both your personal and professional life. It will incorporate technologies such as integration platform as a service (iPaaS) tools, Amazon Alexa and Google Home, the Elgato Streamdeck, and more. Participants will learn methods that can help them save anywhere from a couple of hours to weeks of time." Massachusetts firms/companies with fewer than 50 staff can be reimbursed up to 100% of the cost of training and firms/companies with 50-100 employees can be reimbursed up to 50% of the cost of training. You must register for the course and apply for reimbursement through the Massachusetts Workforce Training Express Fund website a minimum of three weeks prior to the start of the course to be eligible. The course code for this program is C-15319. To learn more, click here or contact Julia Ekelund at jekelund@necpas.org.  

Whether you asked for it (or not) and its here!  The One Big Beautiful Bill Act was signed on July 4.  This program will dig into the meat of the Act that will matter to your clients, including No Tax on Tips, No Tax on Overtime, increased Section 199A Deduction, 100% Section 168(k) Bonus and much, much more! *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 comprehensive annual update brings together key accounting and auditing developments affecting accountants and auditors across industries. The course combines recent standard-setting activity issued by the Financial Accounting Standards Board with major audit and attestation updates from the AICPA, providing a well-rounded view of changes impacting financial reporting and engagement performance. Participants will begin with an overview of recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations. The course also highlights issued ASUs with future effective dates and provides high-level insight into recent exposure drafts to support implementation planning. The course then shifts to auditing and attestation developments, including the next phase of quality management with a focus on monitoring and remediation requirements. Participants will also review recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits. Designed for preparers, auditors, and firm professionals, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as standards and expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Let's face it: using technology is a necessity because technology permeates all our business activities. Yet, many continue to use technology unwisely, which results in declining productivity and data privacy and security concerns. Participate in this session to learn about seven specific items you can-and should-act upon right away to get back on track with technology. More than just a tech update, in this course, you will learn the "hows" and "whys" associated with implementing the seven technologies discussed. This is "must-see"; CPE for those interested in productivity, efficiency, and data privacy and security.  

You could pay $0 for this course!Required minimum distributions (RMDs) must be taken from certain tax-deferred retirement accounts, starting when the account owner reaches their applicable age. The RMD rules are complex and must be simplified to help ensure clients understand them. Accounting and finance professionals must understand the basics of RMDs for IRAs and employer plan accounts so as to help IRA owners, plan participants, and beneficiaries meet their RMD obligations and avoid penalties that apply to RMDs not taken by their applicable deadline. Accounting and finance professionals should also be able to demonstrate tax-efficient solutions for RMDs. This course will walk accounting and finance professionals through the fundamental concepts and rules that apply to RMDs, demonstrate how to calculate RMDs, and explain how to correct RMD errors. It can be taken by anyone, including those without any experience working with RMDs. The course will include cases to promote understanding of the rules. Massachusetts firms/companies with fewer than 50 staff can be reimbursed up to 100% of the cost of training and firms/companies with 50-100 employees can be reimbursed up to 50% of the cost of training. You must register for the course and apply for reimbursement through the Massachusetts Workforce Training Express Fund website a minimum of three weeks prior to the start of the course to be eligible. The course code for this program is C-15384. To learn more, click here or contact Julia Ekelund at jekelund@necpas.org.

Develop financial reporting expertise to conduct an accounting analysis and detect distortions in financial statements. Accounting savvy permits the business analyst to leverage financial information to manage and implement business plans. Gain the tools necessary to become skilled at such analyses. Review the impact of financial and accounting data on the function of capital markets in relation to the changing economic landscape and globalization.

In every audit, the auditor must identify and assess the risks of material misstatement in the financial statements, whether due to fraud or error. This process includes understanding the entity and its environment, including its internal control, thereby providing a basis for designing and implementing responses to the assessed risks of material misstatement. This program explores efficient ways to conduct audits (primarily for private companies), including discussing the applicable standards and their requirements.

To get started in estate planning, learn the basics of intestate succession, probate, wills, health care directives, general powers of attorney, trusts, gift and estate tax planning, as well as transfers of assets. Become familiar with some basics of transfer tax planning, including A-B trusts and QTIPs/marital deduction planning, portability, planning with life insurance trusts, family limited partnerships and more. Also, particular attention will be paid to the human elements that are impacted by estate planning and related tax strategies.

The title "Chief Financial Officer" is not an accurate description for what many financial managers do because the word "chief" implies the company has more than one degreed accountant. This seminar covers four major topics of importance to the financial manager who must do it all. We have designed Only Financial Officer 3.0 to give financial managers in small to medium-sized companies the high-level skills needed to act as a member of top management.

This comprehensive course covers the most common aspects and tax implications of S Corporations, providing a deep dive into their structure, tax treatment, and compliance requirements. Participants will learn the mechanics of electing Subchapter S status, with discussions on Form 2553 and relief options for late filings. The course also explores the application of Rev. Proc. 2022-19 and Rev. Proc. 2023-3, analyzing their differences and implications under I.R.C. §1361 and §1362. Key topics include corporate formalities, shareholder stock and debt basis, and highlights of Form 1120S and its schedules (K-1, K-2, and K-3). Additionally, participants will gain insights into officer reasonable compensation requirements, audit strategies, and corrective measures for eligibility errors. *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

From understanding fraud requirements to improving risk assessment procedures and from testing to meeting auditing standards, discover ways to audit more effectively and efficiently. Engage in discussions that cover reducing risk and effective planning, research and documentation. Review various case studies, real-life examples and sample documentation will reinforce ideas. This course meets the specific California Board of Accountancy requirements that CPAs are required to meet for re-issuance of their license.

Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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 year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.

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.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

A challenge for many small business owners is choosing the 'right' type of retirement plan for their businesses. Many hesitate to adopt retirement plans for their businesses because they are intimidated by the governing rules. In those cases, SEP and SIMPLE IRAs are reasonable solutions because they are easy to establish, maintain, and communicate with employees; have minimal administrative costs; and are practical and efficient ways to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. With IRA-based employer plans, employer contributions are sometimes discretionary, giving business owners the choice of whether to fund every year. Despite the simplicity of these plans, employers must ensure that applicable compliance requirements are met to avoid penalties. To that end, this course will cover some key provisions of SEP and SIMPLE IRAs.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.