CPE & Event Calendar
For details about the CPE and event categories below, please click here.
Excel - Advanced Financial and Statistical Calculations
Tuesday, August 29
12:00pm - 2:00pm
TBD
2.00 Credits
Member Price: $89
Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. 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.
The Aftermath of Government Investigations: Varsity Blues
Tuesday, August 29
12:00pm - 2:00pm
TBD
2.00 Credits
Member Price: $89
Learn the inner workings of a government investigation from people who've gone through them. In 2019, the U.S. Attorney's office in Boston brought charges against more than 50 people in a single case. Those people did not have any idea that law-enforcement officers would have an interest in them. They were movie stars, business owners, CEOs, and professionals. Yet each of those people retained Rick Singer, a man who claimed that he could help their children get accepted into elite colleges. Although the parents thought they were making a donation to a nonprofit, they unintentionally implicated themselves in serious criminal charges that would expose them to the possibility of many years in federal prison. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Best Non-Google Search Tools for Accountants
Tuesday, August 29
12:30pm - 2:30pm
TBD
2.00 Credits
Member Price: $89
The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leverage Integrated Technology Ecosystem to Maximize Profit
Tuesday, August 29
1:00pm - 2:00pm
TBD
1.00 Credits
Member Price: $55
Dawn Brolin, author of the new book, "The Designated Motivator for Accounting Professionals", leads this practical, play-by-play session to help you understand the key positions that every firm needs to fill with the right technology solutions and provider partnerships. Attendees will learn how to leverage integrations between all technology applications for tax, accounting, client experience, and administrative workflows. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporations: Built-in Gain Tax 2023
Tuesday, August 29
1:00pm - 3:00pm
TBD
2.00 Credits
Member Price: $89
When an existing corporation considers making the S corporation election, the potential corporate-level 'built-in gain tax' (IRC 1374) is often the most important tax cost to evaluate. Learn when and how the built-in gain tax is determined. Discuss topics that include the application of multiple 'limitations' on determining the tax and the potential use of existing corporate net operating losses and tax credits. Identify and evaluate tax planning ideas and strategies.
Surgent's Excel Budgeting Ideas
Tuesday, August 29
1:00pm - 3:00pm
TBD
2.00 Credits
Member Price: $99
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
Surgent's Guide to Understanding the At-Risk Basis Rules and Forms 6198 and 7203
Tuesday, August 29
1:00pm - 3:00pm
TBD
2.00 Credits
Member Price: $99
Many tax clients with losses from their S corporations, partnerships, and multiple-member LLCs treated as partnerships will want to use these losses to offset their other income from other sources. This program explains when, why, and how the at-risk rules apply to allow or to prevent the owner of a pass-through entity from taking a loss from a pass-through entity and using it to offset other income. This program is extremely helpful for anyone with pass-through entity clients.
Tackling Turnover: Key Reasons Your Staff Are Leaving What to Do About It 2023
Tuesday, August 29
2:00pm - 4:00pm
TBD
2.00 Credits
Member Price: $89
"There is not enough experienced talent available in the market" is one of the most common challenges cited by accounting firms today. Many firms are understaffed and struggle to find talent to fill the gaps. Engaged employees are more productive, and they stay longer. Discover the four steps to successful employee engagement enabling you to develop, engage and retain staff, and become more attractive to future employees.
What You Can Learn From the Statement of Cash Flows
Tuesday, August 29
2:00pm - 4:00pm
TBD
2.00 Credits
Member Price: $89
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Preparing Schedules K-2 and K-3: Critical Updates for Reporting Foreign-Related Tax Information for Partnerships and S Corporations
Tuesday, August 29
2:00pm - 5:00pm
TBD
3.00 Credits
Member Price: $149
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2022 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. The course includes an overview of and introduction to Schedules K-2 and K-3, an in-depth discussion of filing requirements and exceptions, a walk-through of what information is required to be reported in different parts of the schedules, and real-life tips and examples. The course includes three comprehensive case studies on how the form should be completed for operating, real estate rental, and investment partnerships.
Steps to Stop External Fraud
Tuesday, August 29
2:30pm - 4:30pm
TBD
2.00 Credits
Member Price: $89
Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Intro to Remaining "Most Common" Form 990 Schedules: D & G
Tuesday, August 29
2:30pm - 5:00pm
TBD
2.50 Credits
Member Price: $89
Session 8 of Borenstein's Form 990 Foundational Series: Schedule G is a top five 'most common substantive'' Schedule as it details with more specificity than the Core Form a filer's revenue capture and the direct expenses from a filer's galas (i.e., fundraising events) and non-event fundraising sales, as well as reportings on the conduct of gaming activities. Schedule G also applies if the filer has used a professional fundraiser. Schedule D's parts are there to denote financial information as well as compliance points and/or data-capture the IRS seeks when a filer has certain assets on its balance sheet. Schedule D also requires input of audited financial statements' footnote specifying whether or not an uncertain tax position has been taken. This session highlights not only what informs the IRS' inquiries in each of these Schedules, and also notes how the required disclosures are used by the IRS and State/local regulators as well as by the public at large. Although this course is categorized as "Basic", the content is also suitable for those seeking intermediate-level training. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forensic Accounting 2023
Tuesday, August 29
3:00pm - 6:30pm
TBD
4.00 Credits
Member Price: $159
This course will discuss the basics of Forensic Accounting and the primary practice areas such as Family Law, Business Valuations, Economic Damages, Fraud and Financial Investigations.
Small Business Stock Gains: Exclusion and Deferral Opportunities 2023
Tuesday, August 29
4:00pm - 6:00pm
TBD
2.00 Credits
Member Price: $89
Review the availability and application of three special rules that allow exclusion or deferral of gain from the sale of the stock of a corporation not making the S corporation election. IRC 1202 provides that all or part of the gain from the sale of "qualified small business stock" can be excluded from gross income. IRC 1045 describes situations when the gain from the sale of "qualified small business stock" can be deferred. To understand the application of these two favorable provisions, the meaning of "qualified small business stock" must be understood, as well as other requirements and limitations. IRC 1042 allows deferral of gain from the sale of corporate stock to an employee ownership plan ( ESOP). This deferral requires a qualified reinvestment at the right time in an adequate amount. Study how these three provisions apply in the context of tax planning for corporate businesses.
A History of Investing and a Look Ahead
Wednesday, August 30
9:00am - 10:30am
TBD
1.50 Credits
Member Price: $69
You hear it all the time. Financial products are becoming more complex. Diversification has changed. Our approach to investing has changed. What does all this mean? In this course, we will explore how investment theory has changed over time from Markowitz to Factor Investing. Using examples and practical applications, we will talk about how our modern notions of portfolio building have developed throughout history. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Women in Accounting Committee Meeting: August
Wednesday, August 30
9:00am - 10:30am
Virtual
0.00 Credits
Free for Members
Please join us for our quarterly Women in Accounting committee meeting. Committee meetings are open to all MassCPAs members. If you have any questions, please contact Maggie at mgrasso@masscpas.org
Payroll Essentials: The Payroll Cycle of Life
Wednesday, August 30
9:00am - 11:00am
TBD
2.00 Credits
Member Price: $89
Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you pull back the curtain, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on various government forms. This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
Wednesday, August 30
9:00am - 12:30pm
TBD
4.00 Credits
Member Price: $159
2020 taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.
Cases in Corporate Ethics: Discuss Real Life Conflicts
Wednesday, August 30
9:00am - 1:00pm
TBD
4.00 Credits
Member Price: $149
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Wednesday, August 30
9:00am - 5:00pm
TBD
8.00 Credits
Member Price: $279
This course is a great foundation to introduce new preparers to tax rules related to business returns. The course provides new staff coverage of tax areas affecting all business entities, providing staff training which they may carry to other business entity returns. Such business tax topics include the sale of assets used in any trade or business (Form 4797), depreciation (Form 4562), deductible vs. non-deductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a complicated federal corporate income tax return. It is a hands-on, practical course in filling out most tax forms, with extra emphasis on form changes due to new tax law.