CPE & Event Calendar

This course is a case study designed to provide a comprehensive overview of U.S. taxation of a foreign corporation. Using a specific example, the course will walk through step-by-step mechanics on how to calculate the income inclusions and foreign tax credits under GILTI (Global Intangible Low-Taxed Income), Subpart F, and PFIC (Passive Foreign Investment Company) regimes. The case study will further evaluate tax impact of subsequent distributions from the foreign corporation and sales of its stock. A compare-and-contrast approach will highlight the different outcomes of these regimes for individuals and for C corporations, empowering participants to advise their clients on the most tax efficient way to structure their international investments.

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

In today's dynamic corporate landscape, HR professionals are no longer just HR experts; they are integral business strategists. This session unveils the pivotal role HR plays in shaping and influencing a company's overarching business strategy. It emphasizes the need for HR to don the hat of a businessperson first and an HR professional second. In this engaging presentation, we will delve into the critical strategic business concepts that HR leaders should not only grasp but also embrace confidently at the executive level. Moreover, we will explore how HR can navigate the fast-paced, technology-driven world by adapting to evolving strategic HR concepts. Discover how HR can transform from a support function to a strategic partner, contributing directly to the organization's bottom line. Learn how to align HR initiatives with business objectives, fostering a synergy that propels the company forward. Join us as we explore the art of blending business acumen with HR expertise to create a winning formula for success at the executive table. It's time for HR to lead the way in strategic synergy!

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.

This session will highlight recent cases of ethical failures and fraud and will highlight concepts of trust, personal accountability, responding to fraud, and the conduct expected of CPAs outlined in the Code of Professional Conduct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Preparing GAAP financial statements can be treacherous. GAAP has become so voluminous and complex that it is easy to overlook accounting, reporting and disclosure requirements, potentially affecting the accountants' liability. Nonpublic entities, however, are not necessarily required to apply GAAP, and there are less complex financial reporting frameworks that may be much easier to apply without sacrificing the quality of financial reporting. Even when using GAAP, the less complicated business entity may find that numerous requirements, including disclosures, need to be more relevant to users of their financial statements, may not be material to users, and often overshadow the most pertinent information. This course will present alternative accounting frameworks that may be more suitable for the more straightforward business entity, including income tax basis and the modified cash basis of accounting. We will also discuss approaches to GAAP, including developing disclosure checklists unique to each set of financial statements, identifying when disclosures may be omitted or complex accounting approaches may be avoided, and how to document those decisions to minimize adverse effects. When the cost of financial reporting to the small business enterprise exceeds the benefits, entities will lose the motivation to issue financial statements that conform with GAAP, and both the business entities and the related capital markets suffer. This course provides alternatives that help alleviate that dilemma.

Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.  

Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is everywhere. It is one of the most common tasks an employer can perform and can be found embedded in nearly every facet of the business and individual tax realm. For many, it is something they encounter regularly, but without any knowledge of how it really works, so it remains a black box. Join us as we un-box the Top 10 most commonly asked questions about payroll from an employer perspective. We'll cover the answers to questions you didn't even know you had and build on the fundamentals of payroll that will help make that black box a bit more transparent. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Please join us for our monthly Taxation committee meeting. Committee meetings are open to all MassCPAs members. CPE Credit: In order to verify your attendance, you must log into zoom using the same email address used to register for this event and linked to your MassCPAs profile Join the committee roster? If you want to join this committee roster, to have access to the MassCPAs online community and be kept up to date with future events, let us know.If you have any questions, contact Melissa at MNystedt@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-1660. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.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.

You are likely familiar with the Trust Fund Recovery Penalty or TFRP, BUT - aside from appealing the proposed assessment, did you know that you can make a request to remove the TFRP by making an administrative request on Form 843 (Claim for Refund and Request for Abatement)? This program will provide an overview of the Trust Fund Recovery Penalty with an emphasis on evidence gathering and using Form 843 to prevail on the IRS as to why they should accept your request for refund, effectively undoing the TFRP. This will include what to request in a FOIA, what criteria need to be met for refund, analyzing the IRS' TFRP file, and reconciling requirements in the IRM. 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 will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction.  The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims.  Within each phase, “red flags” will be discussed.  These are the indicia of possible fraud that managers should be alert for.  Also, within each phase, the most common fraud schemes will be highlighted and discussed.  Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur.  This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.

The globalization of business, ongoing changes in technology, increased attention of shareholders and stakeholders and the continuing demands of the Audit Committee and senior management require a dynamic framework for managing today's internal audit department. This session, designed by a past Chief Audit Executive with significant exposure to a multitude of industries and internal audit frameworks, explores the key competencies and responsibilities of today's internal audit management and methods for meeting the requirements of the internal audit profession. We will also discuss some of the greatest challenges of the role and how to address those challenges.

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.

The control and compliance requirements for single audits differ from the requirements for GAAS audits. As a result, sometimes it's difficult to tell where the auditor's responsibilities start and stop in a single audit. This course is designed to help you proceed and succeed in applying the single audit control and compliance requirements. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in single auditing today.

This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.