CPE & Event Calendar

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You could pay $0 for this course!Advance your skills to propel your career. This course is the second in a five-course series, provides the guidance needed to handle small engagements and to complete small audits, reviews and compilations with minimal supervision. Gain knowledge to improve your skills to perform more complex analytical procedures, as well as drafting financial statements and footnotes. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone. This course qualifies for reimbursement through the state’s Workforce Training Express Fund. Massachusetts 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 Massachusetts Workforce Training Express Fund website a minimum of three weeks prior to the start of the course. The course code for this program is C-3273. To learn more, click here or contact Julia Ekelund at jekelund@necpas.org

Portable Document Format (PDF) documents are everywhere! Yet few know how to work effectively with these documents. If you are interested in working more effectively and efficiently with PDFs, this session is for you. In this session, you will learn valuable tips you can use to assist you with creating, editing, and securing PDFs. You will also learn how to convert PDFs to fillable forms and secure PDFs, among other features. Don't miss this chance to learn ten PDF tips you need to know to increase your ROI on PDFs.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

The first course in a four-part series, fiduciary accounting and taxation field, has transitioned over the past several years with updated rules and the increased tax cost of accumulating income in a non-grantor trust. The changes in the income tax rate structure at the federal and state levels have pulled income tax planning forward as a prime objective for estate planners. The rules and understanding of fiduciary accounting continue to be in a state of development and challenge. It is an understatement to say that fiduciary accounting and taxation have entered a new and very different phase of complexity and change. We will explore many of these issues in Parts 1-4 of Form 1041 Advanced Series. Be sure to register for all courses in this series: Form 1041 Advanced Series Part 1: Why Complex Trusts are Complicated Form 1041 Advanced Series Part 2: Cash & Property Distribution Issues Form 1041 Advanced Series Part 3: Sec. 199. Sec. 67(g) & Charitable Deductions Form 1041 Advanced Series Part 4: Post Mortem Considerations

This section of the four-part series will cover the fundamentals of Form 706 and provide numerous examples of how to properly report deductions on the estate tax return, including marital and charitable deductions. Form 706 Series: Part 1: Overview Including Portability Part 2: Reporting Assets Part 3: Reporting Deductions Part 4: GST Schedule R, Form 8971, Payments & Credits

Financial statements tell a story. Ratios reveal the plot. Desegregate key ratios that show effective management of a company. Learn a compact, efficient approach to financial statement analysis. Be introduced to a set of basic-to-intermediate analytic techniques and tools that provide insightful outputs to a broad spectrum of users with varied analytical objectives. Evaluate management performance, address the changing economic landscape, and the need for a new way of thinking.

Despite the country's polarized politics and troubled economy, the interest in stock investing remains high as younger investors accumulate for retirement and retirees seek to outpace inflation. We'll explore the most popular stock investment strategies and their taxation, including dividend and capital appreciation strategies, while avoiding the net investment income tax and restrictions on losses and straddles. Companion course: Income Tax Planning For Bond Investments

Every two years, the Association of Certified Fraud Examiners releases a study that details fraud cases internationally. This comprehensive study can serve as an important tool in investigating fraud, establishing internal controls, and identifying red-flags in an audit.

The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.

This course provides a concise overview of how artificial intelligence (AI) is transforming financial strategies, tax compliance, and audit practices in the global retail industry. As retailers deploy AI to personalize customer experiences, automate inventory, and optimize pricing, accounting professionals must adapt to new challenges in data integrity, regulatory compliance, and financial reporting. Drawing on real-world case studies from retail giants and small businesses alike, this course explores how AI technologies intersect with accounting workflows and outlines strategies to maintain accuracy, trust, and control in an AI-driven marketplace. 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 is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.      

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session explores these differences and provides best practices for planning, executing, documenting, and reporting the results of an HR investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. 

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

Sarbanes-Oxley legislation. Although there have not been any changes in the legislative concepts of the law since its release in 2002, some aspects of executing the work have evolved. Sarbanes-Oxley was passed in 2002 and year one of attestation for publicly traded companies was 2004. Years later the legislation continues to challenge companies, auditors and compliance professionals when evaluating a company's control structure. SOX 404, although the most prominent, is only one of the many requirements covered under the legislation. In addition, the impetus of COSO 2013 has re-focused companies' efforts on evaluating their key controls. Companies must continually evaluate whether they have designed and identified the proper controls and have adequate tests in place to determine control efficiency. With the evolution of technology solutions, the impact of information systems changes must be continually evaluated to ensure controls are adequately addressed. 

The accounting profession is at a crossroads — not because of a new generation, but because the entire architecture of work is being rewritten. Smaller firms are feeling it most: recruiting has become harder, AI is changing client expectations overnight, and leadership succession looms large. In this fast-moving and practical session, global future-of-work strategist Steve Cadigan (LinkedIn’s first CHRO and author of Workquake) unpacks how small and mid-sized firms can reimagine how they attract, develop, and lead talent in a world where certainty is gone and adaptability is gold. Through real-world examples from progressive firms like Bookminders, Prestige Accounting, LedgerWise, Nova Accounting, and Insights CPAs, Steve shows how leaders are reshaping work models, leveraging AI as a time- creator, and making accounting a magnet for modern talent again. 

Artificial Intelligence (AI) is rapidly transforming industries and redefining how organizations operate. While the benefits of AI-efficiency, automation, data-driven insights, and innovation-are significant, the risks are equally profound and demand careful consideration. AI introduces a range of technical risks, such as bias, lack of transparency, data dependency, and vulnerability to manipulation. Ethical risks arise in the form of workforce disruption, diminished accountability, potential misuse, and the erosion of human autonomy. On a broader societal scale, AI threatens to widen inequalities, accelerate disinformation, and erode trust in institutions, while raising concerns of cultural homogenization and disproportionate power concentration among a few entities. Governance challenges further complicate the landscape, as regulation struggles to keep pace with technological advances, and questions emerge about the long-term safety and alignment of advanced AI systems. Leaders and organizations must recognize that AI is not only a technological innovation but also a strategic risk management issue. Responsible adoption requires robust governance, transparent and ethical frameworks, ongoing monitoring, and human oversight. By proactively addressing these risks, organizations can balance innovation with accountability, safeguard trust, and position themselves for sustainable success in an AI-driven future. Note:  This is Part 1 in a two-part series on the risks of AI

This is the second in a four-part series. One of the basic rules in fiduciary taxation is that the person or entity that receives the taxable income from the trust or estate is taxed on that income. The calculation of Distributable Net Income (DNI) and the Distribution Deduction determine the allocation of the tax burden between the fiduciary entity and the beneficiary. Therefore, when distributions are made that "carry out" DNI, the fiduciary entity operates as a conduit and the beneficiaries are taxed on the amounts reflected on the Schedule K-1. The fiduciary entity receives a corresponding distribution deduction. When taxable income is accumulated by the entity, the fiduciary pays the tax. We will explore the various distributions made to beneficiaries and their impact on the entity's taxation. Be sure to register for all courses in this series: Form 1041 Advanced Series Part 1: Why Complex Trusts are Complicated Form 1041 Advanced Series Part 2: Cash & Property Distribution Issues Form 1041 Advanced Series Part 3: Sec. 199. Sec. 67(g) & Charitable Deductions Form 1041 Advanced Series Part 4: Post Mortem Considerations