CPE & Event Calendar

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing - three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-3162. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-11343. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org. This course qualifies for EA/IRS and CFP credit. If you need EA/IRS credit, please contact Tyler Dion (tdion@masscpas.org) after you have registered and provide him your PTIN number.

Forensic accounting encompasses fraud investigation and prevention, as well as a wide variety of functions in litigation. Forensic accountants provide services ranging from serving as an expert witness, to litigation consultant and bankruptcy trustee. As our economy grows more complex, the need for forensic accountants grows as well. One critical role of the forensic accountant is exposing and examining financial fraud. Technology expands the way companies conduct business; however, technology also provides greater opportunities for those willing to commit fraud. Forensic accountants rely on their skills in accounting, coupled with their investigative skills, to explain to clients, courts, and jurors how fraudulent schemes occur and the effect caused by fraud. Forensic accountants also provide expert opinions in calculating damages in litigation and administering bankruptcy estates, as well as a host of other services. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-11344. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-4115. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

Instances of financial statement fraud have occurred ever since the first financial statements were prepared. Financial statement fraud poses a significant threat to all businesses regardless of size. In this program, we will discuss fraud, the Fraud Triangle, who commits fraud, fraud red flags and motivations to commit fraud, common fraud activities, COSO internal controls, and selected financial statement fraud case studies. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-1660. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

This course is a `deep dive' into all things real estate tax-related for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, holding, managing, constructing, and disposing of real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact of recent tax legislation, as well as historically difficult areas of the law like passive activity and at-risk rules. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-3371. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

This 2-hour mini course is from our Level V course, which highlights leadership skills and situations that are common for managers and senior managers in CPA firms. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees. Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings. Helping the Firm Grow - the three levels of helping the firm grow and how to involve the entire team in expanding services to existing clients and generating referrals to new clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program) breakout rooms to ensure small group engagement and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course material. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-9414. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-4104. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-8960. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.  

You could pay $0 for this course! This course addresses the most recent tax legislation, rulings and developments occurring in 2022-23 that will impact both the business and individual taxpaying client. The course is designed to prepare the practitioner for the upcoming filing season and provide useful strategies to assist in the tax preparation process. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-6512. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!This course qualifies for EA/IRS and CFP credit. If you need EA/IRS credit, please contact Tyler Dion (tdion@masscpas.org) after you have registered and provide him your PTIN number.When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-6532. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course! 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. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-2138. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!This course qualifies for EA/IRS and CFP credit. If you need EA/IRS credit, please contact Tyler Dion (tdion@masscpas.org) after you have registered and provide him your PTIN number.Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This course covers exactly that. For tax practitioners preparing partnership 1065 forms, this program explains these complex rules in practical and understandable terms. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-6533. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!This course qualifies for EA/IRS and CFP credit. If you need EA/IRS credit, please contact Tyler Dion (tdion@masscpas.org) after you have registered and provide him your PTIN number.Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. The course will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-11346. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course! Essential knowledge for the new income tax return preparer presented in an information-packed day of practical instruction. Return preparation techniques are illustrated using real practice situations culled from hundreds of "tax organizers" and thousands of client questions. This program is a great jump start for the career of the new accountant. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-6208. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!The focus of this course is reducing the overall risk of fraud. To that end, instruction will cover the factors that play a role in turning honest employees into fraudsters. Discussion will touch on integrity and ethics, as well as how the reactions of people in certain situations may impact the prevalence of fraud. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-3421. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!This 2-hour mini course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-6542. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course! Over the past few years, the AICPA revamped the quality management standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, effective December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. With a risk-based approach, the standards enhance requirements for engagement quality reviews, encourage QMS monitoring, and focus on the entire system of quality control maintained by a firm. We will cover the key provisions of the standards, how to effectively implement them, and what you need to do today to prepare for the required implementation. The earlier your firm begins the transition, the better off you will be. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-11347. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

You could pay $0 for this course!This course qualifies for EA/IRS and CFP credit. If you need EA/IRS credit, please contact Tyler Dion (tdion@masscpas.org) after you have registered and provide him your PTIN number. Getting ready for busy season involves not only knowing what's new for the current year, but also understanding how the changing limits, phaseouts and other rules apply to current-year returns. With major legislation enacted over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information. In addition, this course provides an up-to-date review of important tax form changes, new tax forms, new limitations, key developments as they are reflected in the IRS forms, and IRS filing issues and deadlines that will be invaluable to attendees who prepare tax returns during busy season. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. 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 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-3351. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

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-6488. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org..Fraud plagues businesses at epidemic levels, and technology control failures are a major contributing factor. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each fraud. By learning through these real-world case studies, you will be better positioned to reduce fraud risk.