CPE & Event Calendar

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With governments worldwide pushing the automotive industry towards electric vehicles (EVs), there might be an EV in your future or for your corporate fleet. Today, some vehicles are all gas, all electric or hybrid. How much do EVs cost to purchase, maintain and charge? Most EV owners charge at home but need public charging when venturing beyond their vehicle's range. Not all EVs can use every public charger and various charger types recharge at different speeds. This session will simplify the issues and tell you what you'll want to know if there is an EV in your future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today - your clients and your bottom line will thank you.

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-6542. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.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.

The Art of Discipline and Getting Things Done - Applying Better Time, Team, and Project Management Techniques provides best practices for various areas that support this culture of discipline, including time, team, and project management. Those in a supervisory or managerial role must create a culture of discipline, where a high priority is placed in accomplishing responsibilities in an effective and efficient manner. Note: This course is recommended as a part of an 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for project and time management. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

People often judge our intelligence, professionalism, and competence in our grammar and punctuation. Don't let simple errors undermine your messaging or hamper your organization's ability to move ahead. This fast-paced webinar will teach you the secrets to common grammar and punctuation issues, including singular-plural agreement, sentence structure, and dangling modifiers. You'll review the right usage of the comma, hyphen, apostrophe, and semicolon. In addition, you can ask the instructor questions about any aspect of this topic. This program moves quickly as terrifying topics in school become easy to understand.

Most business ethics courses focus on concepts like “tone at the top”, “integrity”, “code of conduct”, “values”, and “ethical culture." These are extremely important concepts and must be understood But often, when a professional finds they are in a potential “ethical” situation, they question “What should I do?” It is not as easy as flipping a coin. Ethics aren’t always black and white and there are many variables that can impact both the issue and the outcome This course presents real-life ethical scenarios then challenges you to put yourself in the place of the professional to truly think about “What would I do?” The scenarios are all true…. the names have been changed to protect the innocent You will come away from this training with a new view of putting ethics into practice

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-6490. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, "One day, I'll learn how to write macros." Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel's Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don't miss this unique opportunity to learn how to begin working with macros - one of Excel's most powerful tools.

Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.

Significant changes in the audit environment for 401k plans have resulted from recent U.S. Department of Labor reviews of 401k audits and the issuance of Statement of Audit Standards Number 136 (SAS 136), the Auditing Standards Board's new standard for employee benefit plan audits. This course will assist the audit professional with guidance needed to perform 401k audits in the upcoming year. We will discuss the significant changes from SAS 136 and other recent auditing standards, including both the auditor's and plan sponsor's responsibilities when electing and performing an ERISA Section 103(a)(3)(C) audit, which replaced the former limited scope audit. We will also focus on the most common compliance issues identified in 401k audits from both the Department of Labor and peer reviews, along with best practices and recommended corrections.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You're invited to join us in Boston for our upcoming discussion all about cybersecurity risk in deal-making with the Alliance of Merger & Acquisition Advisors (AMAA). Listen to the panel of experts discuss how cybersecurity risk can impact your deals while enjoying drinks and appetizers. Learn how to implement best practices to enhance value and lead to successful transactions. Plus, explore how to evaluate cybersecurity risk in due diligence and minimize risk.  Bonus: Earn 1 CPE credit by attending this event Questions? Contact Melissa at MNystedt@masscpas.org

Almost 50% of businesses that started five years ago are no longer in operation today. Controllers and CFOs can and must influence the longevity of their organization to improve their success rate.  Jim will help you be aware and understand the answers to these issues: Can you describe the financial health of your company? Can you also explain what the financial health of your industry is? Do you know your Business Cycle compared to the industry business cycle? Do you have an executable plan? Do you know what the competitive, legal and technological landscape is currently, and for the future? Is your organization aligned and incentivize to be successful? Jim has developed his groundbreaking Business Longevity concept as a keynote and a workshop, and would be happy to speak to your organization on this topic. This session will focus on assessment (financial health, competitive environment), determination (effective business planning, including the future landscape), and execution (gettin’ it done!)

This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses.  Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses will also be addressed.  **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 highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.

Clients are living longer. Not only does that present challenges to the work we do with them to make sure that their money lasts, but it also brings into play additional issues and challenges that we may not have had to tackle in the past. How do we plan for where clients will live (possibly as solo agers)? How do we deal with issues of diminished capacity? How do we plan for long term care and end of life issues? How do we have complicated family conversations? How do we make sure that our clients have their best long lives possible both financially and otherwise?  Find out in this session where we will present tools you can use with clients to engage them in the planning process.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest.

Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer’s thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer’s shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers.