CPE & Event Calendar

This introductory course provides a clear, concise, step-by-step example of the fundamentals of how to import data into Alteryx, how to select and configure its tools to transform that data according to your needs, and how to export the cleaned-up version to an Excel workbook for further CPA-related calculations. It also introduces those new to Alteryx to frequently used technical terms and concepts, and how you can use Alteryx as a powerful complement to Excel to turbocharge your ability to produce CPA work products. In addition, this course covers the purposes and functionality of the various sections of Alteryx's main screen, including the Canvas, the Tool Palette, the Configuration Window, and the Results window. This and other foundational knowledge taught in the course will increase your ability to confidently and expertly use the program's software tools. Finally, this course shares numerous insights and commentary that pertain directly to CPAs and the kind of work we do. If you've wanted to learn about Alteryx and how it can boost your productivity and advance your career, this course is for you!

This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.     **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 use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common 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.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A personal brand is your story. Having a well-defined personal brand can help you not only cultivate powerful connections but also set you apart. Explore the integral components to building a strong brand and gain strategies to help you create your own marketable personal brand.

Auditing Revenue Recognition - Grasping the Higher Risks and Special Audit Considerations will provide tips and techniques for obtaining sufficient and appropriate audit evidence to support conclusions related to accounting for revenues obtained from contracts with customers. Revenue recognition is presumed to be a significant risk for financial statement auditing purposes due to the increased risk of both fraud and error. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities in auditing revenues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.

You are not required to be a professional to prepare tax returns, but you are required to abide by regulations when preparing tax returns and representing clients with the IRS. Circular 230 is the guidebook that the United States Treasury uses to regulate those activities. Every year, return preparers are sanctioned, penalized, and sometimes imprisoned for violating various statutes and regulations. If a substantial amount of your CPA firm's revenue comes from tax preparation, this course is a must. Every year, return preparers violate these regulations, and are caught by the IRS. This presentation will help the CPA know the rules so they can stay in compliance with confidence while providing their client with tax preparation and IRS representation service. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

The course provides a concise overview of Environmental, Social and Governance (ESG) reporting -- an emerging system of non-financial record-keeping and governance. Around the world, organizations of all sizes and kinds are under increasing pressure from regulators, consumers, employees, and other stakeholders to provide a fuller and more integrated picture of the way in which entities operate, invest, and create value. This includes taking into account how their operations impact financial, manufactured, intellectual, human, social, relationship, and natural capital. Participants will walk away with an increased situational awareness of ESG reporting, and an ESG starter strategy. This can be used immediately to position themselves for ESG success in an era of growing expectations for conscious capitalism, ethical investing, and moral leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review options for structuring the sale of a C corporation business from both buyer's and seller's perspectives to minimize tax costs. This course covers topics not routinely considered in a tax compliance practice but essential to the sale of a C corporation business.

Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.

It is now common for those who live to the age of 65 to expect to live at least another 20 years. With increased length of life comes the need to understand that certain necessities must be considered for elderly/disabled clients. We walk you through issue spotting, including senior housing and care giving options, guardianships, conservatorships, financial and health care powers of attorney, Medicaid qualification and asset protection planning. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision.  This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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.

Please join us for our monthly Taxation committee meeting. Committee meetings are open to all MassCPAs members. If you have any questions, please contact Molly at msullivan@masscpas.org.

You love movies. You enjoy TV. You read books. That's why this is the webinar for you. The best works in popular culture provide valuable lessons in how to live your life well. Sometimes they show what *not* to do, which is just as important. A good story well told is the best way to learn what it means to be both a successful CPA and an honorable human being. This dynamic one-hour presentation will provide you with a list of recommended movies, TV shows and books that are enjoyable, provocative (in the best way), and guaranteed to yield rich dividends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.