hero

Detailed Agenda

 

Jump to: Tuesday | Wednesday | Thursday | Friday

 

Tuesday, June 14

6:30-9:30 p.m. — Registration — Events Center Foyer


7-8:15 p.m. — New Standards for Sophisticated Client/Customer Experience (1.5 credits, PD) — Events Center | Salon D

Heather Sperduto — ADP
A digital transformation was already in full swing, but due to the major global disruption caused by the pandemic, customer behaviors and preferred interactions have changed significantly — and likely much faster than many companies were able to prepare for. Clients and customers desire different experiences when buying products and services, and their buying behaviors have changed, too! This session will help you meet the new standards of the client/customer experience in a virtual environment by understanding the marketplace and utilizing technology.

 


Sponsored by:
jpmc_logo

8:15-10 p.m. — Welcome Reception — Events Center Foyer

Start your convention experience off right with early convention check in and an evening of hors d’oeuvres, drinks and networking.

 

Wednesday, June 15

7-9 a.m. — Registration and Continental Breakfast — Conference Center


8-9:40 a.m. — BREAKOUT Sessions (2 credits)

1A. Accounting Update (AA) — Conference Center | Ballroom A
Renee Rampulla, CPA, CGMA — Rampulla Advisory Services LLC
This session covers relevant and effective guidance recently issued by the Financial Accounting Standards Board (FASB). 

1B. Annual Tax Refresher: Individuals (TX) — Music Box
Deborah A. Phillips, CPA, MST — Surgent Professional Education
The ripple effects of tax reform continue, and it is now more important than ever to understand the best tactics for individual clients in light of new guidance and case law. Hear the latest developments and get the best tax-saving strategies for individuals. Topics covered will include legislation, case law and IRS regulations, rulings and pronouncements.

1C. Data Analytics, Predictive Analytics and Business Intelligence — Evolution of the Accountant (MT) — Conference Center | Ballroom B
Jim Lindell, CSP, CPA, M.B.A., CGMA — Thorsten Consulting Group, Inc.
Data analytics and business intelligence have enabled accountants to morph from transaction aggregation and reporting to providers of value-added insights derived from data. Attend this session to: 

  • Understand how reporting can be improved with data analytics.
  • Learn how visual application can complement and sometimes outweigh traditional financial reporting.
  • Identify the four phases of analytics and their relationship to the accounting function and career advancement.
  • Discover how business intelligence impacts the accounting role for staffing, data acquisition and analysis, and machine learning.
Sponsored by:
PAYCHEXLogo_4Services-11-2-2016

1D. Managing Virtual and Remote Work Teams (MT) — Conference Center | Ballroom D
Rose Ludgate  Paychex
Based on what employers and employees experienced during the coronavirus pandemic, virtual work teams and remote employees may become the way businesses decide to operate long term. With impactful strategies, you can effectively develop and lead virtual teams. Benefit from having the right tools, protocols, expectations and culture in place to achieve the most success with managing remote work teams.

Topics will include:

  • Important principles of virtual management
  • Strategies and best practices for managing remote work teams
  • Remote safety and security considerations
  • Technology tools and solutions to effectively connect with virtual teams
Sponsored by:
SMI / CALLTOWER
TierPoint

1E. TechTalk: Utilizing Microsoft Teams and Leveraging Microsoft 365 Security (SK) — Conference Center | Ballroom C
Chuck Phaneuf — CallTower
Tara Kovaleksi  TierPoint
Microsoft Teams has enabled accountants to continue to thrive and collaborate effectively, keeping customers, partners and employees connected over the past two years in the work-from-anywhere environment. Explore this business communication technology to help empower your business to prosper today and tomorrow as workplaces continue to evolve.  To improve productivity and reduce cost, more businesses are moving to Microsoft's 365 platform every day, but how secure is their data? M365 is an amazing platform, but security is rarely, if ever, a set-it-and-forget-it operation.  This session will walk through the top security features that companies use to stay secure and the features that are often neglected.

1F. Board of Trustees Meeting — Room 5


9:40-10 a.m. — Break — Conference Center Foyer


10-11:40 a.m. — Breakout Sessions (2 credits)

2A. Recent Auditing and SSARS Guidance (AA) — Conference Center | Ballroom A
Renee Rampulla, CPA, CGMA — Rampulla Advisory Services LLC
This session will address recently issued and proposed auditing and SSARS guidance issued by the AICPA. 

2B. Annual Tax Refresher: Corporations and Partnerships (TX) — Music Box
Deborah A. Phillips, CPA, MST — Surgent Professional Education
Even with several post-TCJA tax seasons in the rearview mirror, important guidance is still being issued, and complex changes related to business clients are still being understood. Explore the latest updates related to pass-through entities and focus on tax-planning strategies and techniques related to S corporations, partnerships, LLCs and LLPs. Topics will include new tax legislation, case law and the most recent IRS regulations.

2C. Business Longevity — Successful Tactics and Strategies (MT) — Conference Center | Ballroom B
Jim Lindell, CSP, CPA, M.B.A., CGMA — Thorsten Consulting Group, Inc.
Nearly 50 percent 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. In this session, attendees will learn how to: 

  • Identify the financial health of their company and industry
  • Determine their organization’s business cycle and relationship to the industry’s business cycle
  • Determine the competitive, legal and technological landscape of the business environment
  • Increase the utilization and interpretation of one standard ratio
  • Evaluate whether their organization is aligned and incentivized to be successful

2D. Preparing for the Future — and How to Get There (SK) — Conference Center | Ballroom D
Moderator: Zack Cohen
Panelists: Joseph F. Hunt, CPA — SobelCo
Philip Sookram, CPA, MAcc — Saint Peter’s University
Tara M. Baldwin, CPA — WilkinGuttenplan
Ryan Berdnik, CPA, CFP — Mazars USA LLP
Sofia Cordero, CPA — Mazars USA LLP
Jay H. Guttmann, CPA — SRG Advisors, LLC

Emerging leaders in the accounting profession are often surrounded by constant change. Through this panel discussion, attendees will walk away with tips and tricks for how to navigate the constant changes with a focus on transitioning and innovating their careers through growth with a forward look to the future. Attendees are encouraged to ask questions and interact with the panel of emerging leaders throughout the session. 
Hosted by the Emerging Leaders Interest Group 

Sponsored by:
PCS

2E. TechTalk: Cybersecurity 101 — Breaches, Ransomware and How to Protect Yourself (SK) — Conference Center | Ballroom C
Anthony Mongeluzo — PCS
Cyber attacks can lead to stolen valuable personal information, a significant amount of downtime to your network, loss of employee productivity and, ultimately, can damage relationships with clients and vendors. It’s not a matter of if someone will attack your network; it is a guarantee. Learn how to best protect yourself from a cyberattack, what to do if you’ve been breached and the steps that will be required even to obtain cyber insurance.

2F. Leadership Training — Conference Center | Rooms 1, 2, 3, 5
This nuts ‘n’ bolts session will provide practical, easy-to-follow how-tos to help NJCPA leaders successfully carry out their responsibilities. Learn the basics of volunteering roles, whether it is how to be a responsible board member or how to operate a chapter or committee. NJCPA staff and 2022/23 President Kathleen F. Powers, CPA, will provide the guidance leaders at all levels need. Topics will include motivating volunteers, communicating more effectively, sharing best practices and handling challenges. This session is required for all 2022/23 NJCPA leaders.


Sponsored by:
PNC

11 a.m.-1 p.m. — Lunch/Expo Floor — Events Center | Expo Hall



Sponsored by:
First Bank

11:45 a.m.-12:45 p.m. — Emerging Leaders Lunch — American Bar and Grille

Join fellow emerging leaders to make new connections and expand your professional network.


1-2:30 p.m. — Welcome and Opening Remarks — Music Box

Don Meyer, CAE — NJCPA

IssuesWatch Live: Professional Issues Update (1.5 credits, SK)

Moderator: Theresa Hinton — NJCPA
Panelists: Ralph Albert Thomas, CPA (DC), CGMA — NJCPA
Kathleen F. Powers, CPA — Matheny Medical and Educational Center and 2022/23 NJCPA president
Harry P. Wills III, CPA — Bowman & Company LLP and 2021/22 NJCPA president

In this kick-off session, our panelists will cover a wide variety of issues impacting CPAs on the New Jersey and national levels. As a CPA or financial professional, it is imperative that you know where the profession is headed so you can make the necessary changes to be ready for the future.


Sponsored by:
PAYCHEXLogo_4Services-11-2-2016

2:30-3:30 p.m. — Break — Events Center | Expo Hall



3:30-4:30 p.m. — Crafting Your Accounting Innovation Strategy (1 credit, SK) — Music Box

Donny Shimamoto CPA, CITP, CGMA — IntrapriseTechKnowlogies LLC
In this session, you’ll learn how to create an innovation strategy and develop a plan to modernize the way you perform accounting activities with the latest technologies. You’ll also examine how to establish your “intraprise architecture” and use it to visualize the changes to your firm’s or finance department’s operations, as well as obtain insight into the skills and knowledge you will need to build in your staff to maintain your team’s relevance and improve the services you provide. 


Sponsored by:
EisnerAmper

4:30-5:30 p.m. — Growth 2022: Strategies and Actions to Increase Profitability (1 credit, SK) — Music Box

Gene Marks, CPA — Marks Group PC
Booster shots are here, the economy is in flux, inflation is increasing and mid-term elections are coming. So, what does this mean for your company, your people, your partners and your community? What new issues will we be facing? What investments should we be making? How will the economy fare? How will the mid-term elections impact your operations? What are smart leaders around the country doing to navigate their companies towards growth and profitability over the next two years? Join nationally recognized journalist, best-selling author and business owner Gene Marks for a fast-paced, entertaining and data-filled presentation where he will share with you the advice, lessons and actions being taken by his audience of more than half a million business owners, managers and leaders to deal with these issues and position their companies for success in the years to come.


Sponsored by:
ADP

5:30-7 p.m. — Reception — Events Center | Expo Hall

Head back to the expo floor to network with attendees, sponsors and exhibitors while enjoying food and drinks.


Sponsored by:
Bank of America

9-10:30 p.m. — After-Dinner Drinks — Water Club Indoor Pool

Join your fellow convention attendees for dessert, drinks and live entertainment.

Thursday, June 16

7-9 a.m. — Breakfast — Events Center | Expo Hall


8-9:15 a.m. — Breakout Sessions (1.5 credits)

3A. Single Audits — Best Practices for Internal Controls Over Federal Awards (AA) — Conference Center | Ballroom D
Alexander K. Buchholz, CPA, CGMA — PKF O’Connor Davies
Learn about single audits and internal controls, with a focus on nonprofits and healthcare entities. This presentation will focus on single audit reporting requirements, factors affecting potential noncompliance and management’s responsibility for compliance.
Hosted by the Nonprofit Interest Group

3B. Key Income Tax Issues for Trusts and Estates (TX) — Conference Center | Ballroom B
Edward K. Zollars, CPA — Thomas Zollars & Lynch, Ltd.
Explore the New Jersey Uniform Principal and Income Act's interaction with the taxation of trusts and estates, special rules for charitable contribution deductions, the major change to excess deductions on termination following the Tax Cuts and Jobs Act and other key items that impact the income taxation of trusts and estates. 

3C. How to Identify Automation and AI Opportunities for Accounting Innovation (SK) — Conference Center | Ballroom C
Donny Shimamoto, CPA.CITP, CGMA — IntrapriseTechKnowlogies LLC
Headlines abound saying that robotic process automation (RPA) and artificial intelligence (AI) are going to eliminate the need for accountants. In reality, RPA and AI provide great opportunities for accountants to automate routine procedures and focus on delivering more value-added insights. This can help them work more efficiently and enhance client service or finance operations. Conversely, the use of AI can also have some perverse results if not managed properly. Accountants must be aware of these risks and work to ensure that the proper controls are in place to manage an organization’s operational and financial risks associated with automation and AI. Attend this session to learn more about these technologies, how to identify opportunities for innovation, and their implications to the skills and knowledge needed to be an effective accountant. 

3D. Survival Skills for Emerging Leaders in Accounting (PD) — Conference Center | Ballroom A
Dr. Kecia Williams Smith, Ph.D., CPA — North Carolina A&T State University
This session will discuss the non-technical skills (e.g., emotional intelligence, growth mindset, and communication) necessary for the “new normal” in the accounting profession. 

Sponsored by:
Xact IT Solutions

3E. TechTalk: Right of Boom — Lessons Learned from a Cyber Attack and How to Prepare (SK) — Conference Center | Room 1
Bryan Hornung — Xact IT Solutions
As the old saying goes, it’s not if but when. Yes, preventing cyber-attacks is important, but what happens after a business gets attacked by cyber criminals? This session will walk you through two very different types of cyber attacks — one with a firm with cyber insurance and one without. Learn the best practices and importance of incident response, disaster recovery and business continuity planning as well as critical lessons learned from these two cyber attacks.

3F. Design Your Own Partner Development Program (SK) — Conference Center | Rooms 2 and 3
Jon Lokhorst, CPA, ACC — Lokhorst Consulting
For decades, firms have kept the path to becoming a partner shrouded in secrecy or ambiguity. It’s time to pull back the curtain on a more effective and transparent process. Otherwise, you risk losing your best talent and future leaders, whether they’re seeking partnership or another leadership role. Learn how to design a development program that prepares your firm’s prospective partners and other leaders. This session is also suitable for staff who desire to advance to partnership or another leadership role in their firm.


9:30-10:30 a.m. — Moving Forward Together: How to Advance in an Everchanging Business Environment  (1 credit, SK) — Music Box

Dr. Kecia Williams Smith, Ph.D., CPA — North Carolina A&T State University
The emergence of accounting technology, data analytics and sustainability reporting coupled with an emphasis on diversity, equity and inclusion has presented the accounting profession with tremendous opportunities for growth. This keynote session will discuss specific strategies for professionals to utilize their individual abilities and collective strength to advance in an everchanging business environment while embracing an attitude of inclusion.


Sponsored by:
Smolin

10:30-11 a.m. — Break — Events Center | Expo Hall



11 a.m.-12:15 p.m. — Annual Business Meeting (1 credit, SK) — Music Box

Attend the NJCPA’s Annual Business Meeting to: 

  • Stay abreast of the status and health of the association.
  • Learn about new business developments.
  • Meet the 2022/23 Board of Trustees, chapter board members and committee and interest group leaders.
  • See who won this year’s Ovation Awards.

12:15-1:45 p.m. — Lunch/Expo Floor — Events Center | Expo Hall


Sponsored by:
M&T Bank

12:15-1:30 p.m. — Managing Partner Lunch and Roundtable Discussion (1 credit, SK) — Conference Center | Rooms 2 and 3

Jon Lokhorst, CPA, ACC — Lokhorst Consulting
Join other managing partners for a discussion of the top leadership challenges facing firms today including attracting and retaining top talent; navigating remote and hybrid work arrangements; and succession planning. Gain insights and share best practices on these real-time challenges as you establish priorities for your firm for the rest of 2022.


1:45-3 p.m. — Breakout Sessions (1.5 credits)

4A. Top 10 Peer Review Findings and How to Avoid Them (AA) — Conference Center | Ballroom A
Frank R. Boutillette, CPA, CGMA, ABV — WithumSmith+Brown
Brad E. Muniz, CPA — SobelCo
The AICPA continues to see findings reported on peer reviews. This session will review the list of most common matters noted, including some new and some of the old favorites. Practitioners should attend to enhance their engagement quality. Those in industry should attend to understand why engagement intensity continues to increase. 

4B. Required Minimum Distributions and More: Issues for IRAs (TX) — Conference Center | Ballroom B
Edward K. Zollars, CPA — Thomas Zollars & Lynch, Ltd.
The SECURE Act and the new life expectancy tables for required minimum distributions (RMDs) have changed tax planning for IRAs and defined benefit retirement plan balances. Learn about the changes made by the SECURE Act to IRAs in areas such as inherited IRAs, lifting of the age cap on contributions and more. The revised 2022 life expectancy tables that revised RMDs will be reviewed, as well as other recent developments impacting such retirement accounts.

Sponsored by:
kearny_bank_logo

4C. Manage Your Next Project Like a Pro — Tips for a Successful Project Implementation (MT) — Conference Center | Ballroom C
Sean Byrnes, CPA — Kearny Bank
Shekhar C. Somaiya, CPA, M.B.A., PMP, CSM — Equus Strategy
Wally Merkas  WithumSmith+Brown 
Have you ever needed to take on a large project? Whether it’s implementing new technology, managing the move to new facilities, adopting a new product or service line, or evaluating a business acquisition, there can be financial, reputational and emotional capital costs if a project is not managed well. Learn the step-by-step project management process from start to finish and stress-free methods for getting from one to the other.
Hosted by the Business & Industry Professionals Interest Group 

4D. Mission-Critical Leadership: How Smart Managers Lead Well in All Directions (PD) — Conference Center | Ballroom D
Jon Lokhorst, CPA, ACC — Lokhorst Consulting
Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across to peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive organizational culture. 

Sponsored by:
Titan Technologies

4E. TechTalk: How Cloud Computing Can Cut Your IT Costs, Address Security and Compliance Concerns and Allow You to Work From Anywhere (SK) — Conference Center | Rooms 2 and 3
Paul Nebb Titan Technologies
Until 2020, remote work was a “nice to have,” now it’s a necessity. Learn about different cloud options that will help you grow your firm and ensure that security and compliance requirements are addressed. Already in the cloud? Great!- You’ll want to attend this session, because you’ll learn that not all clouds are created equally. Even if you aren’t ready to make a change from who or what you’re using now, this session will give you valuable insights and information on how to drop IT costs while enabling everyone in your organization to work faster and more efficiently. And, if you are considering outsourcing your IT support to someone else, this session will arm you with the right questions to ask when the time comes.

Sponsored by:
Accountants Advisory Group

4F. Trends in Public Accounting and Future Predictions (SK) — Conference Center | Room 1
Joseph A. Tarasco, CPA — Accountants Advisory Group, LLC
The world of public accounting is going through significant transition and challenges each year. We will discuss the hard trends that will happen and the softer trends that could happen. The future success of your firm depends on how quickly your partners can adapt to the changing marketplace and anticipate the future and timing of the changes to come.

Learn how to:

  • Anticipate disruptions, new obstacles, challenges and strategies to remain competitive.
  • Create a succession plan in a dynamic marketplace.
  • Leverage the skills, talents and leadership potential within your firm to maintain a competitive edge and continuously increase profitability.


Sponsored by:
Investors

3-3:15 p.m.— Break — Music Box Foyer


3:15-4:15 p.m.— Transformation of the Profession: How to Remain Relevant as We Go Back to Our Trusted Advisor Roots (1 credit, CS) — Music Box

James C. Bourke Jr., CPA, CITP, CFF, CGMA — WithumSmith+Brown
This session will address the rapid transformation of the accounting profession fueled by availability of technology. The pandemic forced change onto the profession, and with that change came massive disruption of how we do business and collaborate with colleagues and clients. Selecting the “right” technologies was a recent differentiator in an organization’s ability to survive. While some accountants struggled with client service or encountered challenges with a remote workforce, some found the silver lining to leverage technology to enhance customer service or internal processes. Jim will share some of the best practices for technology and innovative solutions in this new world. You’ll walk away from this session with a new appreciation and awareness about some of the unique opportunities available to CPAs today. If you’re willing to pivot from a compliance focus to an advisory focus, the growth possibilities are endless. 


Sponsored by:
CohnReznick

4:15-5:15 p.m.— SEVEN LEADERSHIP AND LIFE LESSONS (1 credit, PD) — Music Box

Susan O’Malley — First female president of a professional sports franchise
Get ready for an engaging and upbeat presentation where Susan will apprise you of the seven seminal ‘rules’ for leadership and life. She will share insider stories about entertainment, hockey and basketball as well as management lessons she learned from her family. Life lessons are often learned early from family and familial experiences. By focusing on the lessons of her own childhood and then reinforcing them with her proven business expertise, Susan offers vital insights for leaders of all stripes. A trailblazer for herself and others, she is hilarious, brilliant, genuine and inviting. Her warm sense of humor, self-described “folksy” style, entertaining stories and sharp wit make her lessons memorable and an instant favorite. Take away lessons for your own life and business.


Entertainment sponsor:
Provident 

Closing Dinner sponsor:
Matheny Medical and Education Center 

Open Bar sponsors:
Bowman & Company
Harry_Krystalla

7-11:30 p.m.— Celebration and Entertainment — Events Center | Salons A, B, C then Premier Nightclub

Cap off the convention as we toast our incoming leaders and Ovation Award winners and enjoy dinner, drinks and live entertainment by:
Brian Kirk & The Jirks



Friday, June 17

Sponsored by:
Columbia Bank

7:30-8:15 a.m.— Breakfast — Events Center | Salon D


8:15-9:15 a.m.— National Economic Outlook: Lessons Learned (1 credit, SK) — Events Center | Salon D

G. Scott Clemons, CFA — Brown Brothers Harriman & Co.
As the immediate effects of the pandemic wane and economic leadership reverts to more traditional drivers, we are finding that the “new normal” is different, both for better and worse. Accelerated technology is a boon to some parts of the economy, while economic inequality widens further elsewhere, with implications for policy and markets. Join us for a discussion of the new normal for investors and businesses, both nationwide and in New Jersey in particular.


Sponsored by:
Columbia Bank

9:15-10:30 a.m.— New Jersey Economic and Business Roundtable (1.5 credits, SK) — Events Center | Salon D

Moderator: Ralph Albert Thomas, CPA (DC), CGMA — NJCPA
Panelists: G. Scott Clemons, CFA — Brown Brothers Harriman & Co.
Regina Egea  Garden State Initiative
Daniel Munoz  NorthJersey.com 
Our panelists will discuss key economic issues facing businesses and individuals in New Jersey. Find out what the public and private sectors need to do now in order to emerge from the pandemic and make New Jersey an attractive place to live and do business.


10:30-10:45 a.m.— Break Events Center Foyer


10:45 a.m.-12 p.m. — Breakout Sessions (1.5 credits)

5A. Financial Statement Challenges for Private Entities and Practitioners (AA) — Events Center | Salon B
Panelists: Kenneth A. Heaslip, CPA, CGMA, M.B.A., Cullari Carrico LLC
M
ichael S. Kaplan, CPA, Smolin, Lupin & Co., P.A.
Jay L. Levine, CPA, Prager Metis CPAs, LLC
This year, CPAs will be encountering several new financial statement issues for the first time. The long-awaited lease standard is now implemented for private companies. In addition, more entities are engaging in digital currency (e.g., bitcoin) transactions. Many others have elected to be taxed using Business Alternative Income Tax (BAIT) rules. Accounting for these transactions encounter many unforeseen complications. This session will discuss these issues as they apply to private entities and practitioners.
Hosted by the Accounting & Auditing Standards Interest Group

5B. The Aftershocks of MTC’s Revised Guidance on P.L. 86-272 (TX) Events Center | Studio 1
Moderators: Barry H. Horowitz, CPA, MST and Jason Rosenberg, CPA, CGMA, EA, MST Withum
Panelists: Alysse McLoughlin, Esq. Jones Walker
James B. Evans Jr., J.D., LL.M., CPA Kulzer & DiPadova, P.A.
Jorge Rodriguez, J.D., LL.M., CPA  RSM US LLP 
This session will explore the recent revisions to the guidelines of P.L. 86-272 as recently adopted by the Multistate Tax Commission (MTC). The federal law was enacted to protect taxpayers from state income taxes when their sole activity in the state is limited to soliciting the sale of tangible personal property. Due to the rise of the digital economy and state pushback, taxpayer protection under P.L. 86-272 has been steadily eroding. The panelists will examine the impact of these revisions, whereby a business could lose protection by solely engaging with customers through the internet.
Hosted by the State Tax Interest Group

5C. What CPAs Need to Know to Serve Cannabis Clients (CS) Events Center | Studio 2
Moderator: Alex Krasnomowitz, CPA — Alex E. Krasnomowitz, CPA
Panelists: Ryan Brandt, CPA — Withum
Todd W. Polyniak, CPA — SAX LLP
Stacey D. Udell, CPA/ABV/CFF, CVA — HBK CPAs & Consultants

As the adult-use cannabis market gets up and running in New Jersey, these business owners will need the guidance and support of CPAs. Find out what you need to know to properly advise cannabis clients, given certain limitations the industry has to comply with.
Hosted by the Cannabis Interest Group 

5D. Analytical Techniques for Accounting and Audit Professionals (SK) Events Center | Salon A
Melissa A. Dardani, CPA, MAcc — MD Advisory
The field of data analytics is shaping the future of the profession as accountants move away from the traditional role as “bean counters” to business advisors. While sophisticated (and often expensive) technologies to assist in financial data analytics are becoming more popular, accountants can tap into one of their favorite tools with lesser-known but powerful functionality built in: Microsoft Excel. This session will provide an overview of the powerful and easy-to-use capabilities of Power Query, Power Pivot and the Data Model. We will step through an analysis of a sample financial data set, beginning with the source data, applying cleansing steps and analytical procedures, and then demonstrate the replicability of those financial procedures with little additional work. 

5E. Top 20 Tech Tips (SK) Events Center | Salon C
Mark W. Eckerle, CPA — Withum
Karolis Matulis, CPA, CVA  WilkinGuttenplan
Dr. Sean D. Stein Smith, CPA, CFE, CGMA, CMA, DB — Lehman College

Technology plays an increasingly important role for every CPA. Our panelists will provide 20 (or more!) tips, tricks and time-saving tactics you can implement right away to help you be more productive and serve your company or clients better.
Hosted by the Emerging Technologies Interest Group