cpabc.SkipToContent cpabc.SkipToRightNav
Page Banner

CPABC Nexus DaysDate: July 18-19, 2022
Time: 8:30am – 4:30pm
Location: Virtual Conference via Zoom


Full Event
Eligible CPD Hours: 14
Course Fee: $700
(Special discounted pricing)
PD Passport Valid: 24 credits
One Day
Eligible CPD Hours: 7
Course Fee: $380
(Special discounted pricing)
PD Passport Valid: 12 credits


PD Nexus: Information Technology Insights 2022 strives to be the touchstone conference-style PD Day for members and organizations who want the best for the customers and clients. Each session – plenaries and breakouts – have been custom tailored to enhance the day-to-day working environment of professional accountants.

Keeping Your Edge - gain a wealth of insights to keep current with the latest in business technologies

The conference will provide you with the insights into what to watch for, as well as practical technology solutions for today’s busy accountants and business professionals. This year’s offering will present three streams of breakout sessions, along with four great plenaries. 

Special Features

Full Event Registration Day 1 Registration Day 2 Registration

Nexus Day Agenda

Day 1 - July 18

8:30 am - 8:35 amWelcome and Introductory Remarks

8:30 am - 10:10 am

Tech Update 2022

Randy Johnston

The speed of technology change has been accelerating. But unfortunately, we can’t keep up, and we don’t know what to do about it. This visionary session provides insights, choices, and recommendations to help you decide how rapidly to move, which technologies will affect your business, and how to separate sales pitches from innovative ideas.

This session will explore emerging and evolving technologies important to accounting professionals. We will cover the benefits and risks of adopting new technologies in areas ranging from software applications to hardware devices. You’ll also learn how to develop a balanced technology strategy that includes current, emerging, and future technology choices for your firm or business.

  • Hardware trends
  • Software innovations
  • Communication and collaboration tools
  • Key products to consider for implementation

10:10 am - 10:20 amBreak

10:20 am - 12:00 pm

Options to Automate Your Tax Preparation Workflow

Randy Johnston

Tax Season can be a daunting time for tax preparers, but it doesn’t have to be with the help of tax automation software tools and other innovative technology. This session will provide an overview of the latest technologies and tools that can help automate your workflow and make the entire tax return preparation process smoother and more efficient.

From client portals, workflow management, and e-signatures to robotic process automation, you’ll learn about all the options available to help streamline your tax preparation process. So don’t dread Tax Season - attend this session and arm yourself with the tools you need to succeed!

  • Tax automation software options
  • Learn about the best client collaboration options
  • Leave with a checklist of tools to consider your tax practice

Eight Awesome PivotTable Features

Tommy Stephens

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do.

In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

  • Adding user-defined calculations to PivotTables
  • Enhancing PivotTables with Key Performance Indicators
  • Using PivotTables to consolidate  “standard” Excel reports
  • Creative ways to filter PivotTables
  • Linking accounting software data into PivotTables

Emerging Topics in Blockchain and Cryptocurrency

Jeff Cook

Blockchain is one of the most-watched emerging technologies. Yet, few accountants understand how to use this technology to make existing ledger-based systems more efficient, effective, and tamper-resistant. In this session, you will learn the basics of blockchain-based ledgers.

You will also learn about the fundamentals of cryptocurrencies such as Bitcoin and Ripple. Additionally, you will learn about emerging issues in these fields, such as stablecoins, central bank-issued digital currencies, smart contracts, and sovereign identity management. By attending this session, you will see how blockchain-based technologies will change your work with others.

  • Blockchain basics and regulations
  • Cryptocurrencies, stablecoins, and blockchain-enabled central bank digital currencies
  • Smart contracts, sovereign identity management, cross-border funds transfer
  • Emerging uses for blockchain-based ledgers
12:00 pm - 1:00 pmLunch Break

1:00 pm - 2:40 pm

CPA Firm Technology for the Future

Randy Johnston

The next five years are going to be eventful for CPA firms. The profession has never seen such rapid change, with new and changing technologies appearing almost daily! So, what will your firm do?

How can you keep up without getting overwhelmed by these fast-paced transformations in the profession and stay profitable during this turmoil? What are the best technologies to handle client interactions, PBC lists, electronic signatures, and Advisory services? How do the cloud, next-generation accounting software, and client demands affect partner profitability? Attend this session to get an independent overview of the state of technology in the profession.

  • CPA firm centric hardware 
  • Software changes
  • Technology options for your firm
  • Specific technologies to improve productivity and profitability
  • Strategic products to consider for implementation

The How’s and Why’s of Data Analytics

Tommy Stephens

Increasingly, accountants and auditors are called upon to use data analytics to understand and improve results. Yet, many professionals struggle with the concept of data analytics and remain unaware of how to obtain the results needed using tools they already own.

In this session, you will learn about the four primary types of data analytics and when to use each. Further, you will learn how to generate meaningful analytical measurements using Excel, Power BI, and other tools and, more importantly, how to interpret the results. If you seek to use data analytics – and who isn’t – this session is for you.

  • Understanding the four types of data analytics
  • Differentiating between correlation and causation
  • How to generate data analytics in Excel and other applications already in use
  • The role of Artificial Intelligence in data analytics

Tales of True Tech Crimes Ripped from the Headlines

Jeff Cook

We’re all familiar with the headlines describing how criminals use new and creative approaches to commit their crimes. But what you may not know is that these same criminal elements also target accounting professionals. Unfortunately, accountants are one of the most targeted groups on the Internet! In this session, you will learn how high-profile failures occurred due to control malfunctions.

Hackers have gained full reign over entire networks that contained sensitive information such as financial data stored online. Attend this session so you can be more effective at preventing crimes such as theft, malware, ransomware, phishing, and hacking.

  • Common security weaknesses which occur with hardware and software at home and in the office 
  • Malware, ransomware, data breach, and incident response tips
  • Internal control failures resulting in the theft of assets, or unauthorized data manipulation
2:40 pm - 2:50 pmBreak

2:50 pm - 4:30 pm

Windows 11 – What End Users Need to Know

Tommy Stephen

A burning question on the minds of many is, “What features should I use in Windows 11?” Presented with end-users in mind, in this session, you will get the answer you need to that question and others, all delivered in the context of improving productivity and security.

Among other topics, you will learn about improvements in virtual desktops, changes to the user interface, customization options, and more. If you’re using Windows 11 now or plan to upgrade soon, this is a must-see session to help you make the most of your upgrade.

  • Productivity improvements in Windows 11
  • How to work with virtual desktops
  • Customizing the user environment
  • Improved security tools available in Windows 11

Day 2 - July 19

8:20 am - 8:30 amWelcome Back and Housekeeping

8:30 am - 10:10 am

Security Risks and Solutions Roundtable

Randy Johnston, Tommy Stephens, Jeff Cook

Security remains one of the top issues on the minds of most business professionals today – and for a good reason! Unfortunately, given the ever-increasing volume of sensitive data our organizations store and manage, we have become prime targets for cybersecurity attacks. Fortunately, we can take steps to reduce our risks significantly. This session will teach you which measures will benefit you and your organization the most.

In a roundtable format, you will learn about security risks and solutions from the breadth and depth of experience of the K2 Enterprises team. A vital aspect of this session is the opportunity to ask questions of your presenters.  

  • Today's major cybersecurity threats
  • Examples of data breach issues that should be concerning
  • Practical solutions that you should consider implementing to reduce risk

10:10 am - 10:20 amBreak

10:20 am - 12:00 pm

Safeguarding Taxpayer Data – A Guide for Creating a Security Plan

Tommy Stephens

Combatting today’s cybercriminals takes all of us working together. Canada Revenue Agency works with provinces, tax professionals, and individuals to fight these 21st-century identity thieves. Unfortunately, data thefts at tax professionals’ offices are on the rise.

Online providers should follow the leading security and privacy standards. Targeting you for Identity theft of business and individual information is a common bad actor tactic. Learn how to fulfill your fiduciary obligations by participating in this session.

  • Tax automation software options
  • Learn about the best client collaboration options
  • Leave with a checklist of tools to consider

Automation for Increasing Personal Efficiency and Effectiveness

Jeff Cook

Automation is a great way to save time and improve accuracy and effectiveness. It also allows you to get more value from your workday. This session will teach you how to automate the tasks that are mundane or take up too much energy, so you complete them automatically instead.

One of the best things a person can do is invest time into automating their workday to help them achieve more work, reduce daily stress, and provide better mental clarity. This session focuses on various tools and services you can use to help promote personal automation. In it, you will learn about technologies such as integration platform tools, Amazon Alexa and Google Home, and the Elgato Stream Deck.

  • Automation opportunities
  • Understanding integration platforms
  • Productivity tips, tricks, and applications
  • Tips and tricks for saving valuable time

The Best Small Business Accounting Tools

Randy Johnston

Working with a small business, you know that keeping the company’s finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects.

In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we'll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. So, whether you work with a startup or an established small business, attend this session to find out which tools can help you achieve your financial goals.

  • Overview of small business accounting solutions
  • Traditional desktop and SaaS small business products
  • Shortfalls of specific accounting solutions
  • Strengths and weaknesses of various solutions
  • Setup and configuration tips
12:00 pm - 12:50 pmLunch Break

12:50 pm - 1:40 pm

Accounting Automation

Tommy Stephens

Why can it be hard to automate accounting? Because many accountants don’t know their options and, therefore, fail to reap the rewards of accounting automation. This session will teach you how easy and profitable accounting automation can be.

Learn how to automate many traditional accounting processes, often with technology you already own. In addition to bank feeds, you will learn about automation options for processing accounts payable and receivable, approving transactions, and linking data from one platform to another. If you are serious about improving efficiency and accuracy, you should make plans to attend this session.

  • Key automation opportunities
  • Benefits and risks associated with automation
  • Primary tools available for automation efforts

How to Run Microsoft Office from the Cloud

Jeff Cook

Cloud-based options of familiar Microsoft Office applications have been available for over a decade. Moreover, these tools have matured to the point where their functionality rivals desktop-based options. Further, the ease of deploying, accessing, and using these tools is striking.

In this session, you will learn about Cloud-based alternatives to everyday desktop applications and why you should consider adding them to your toolbox. You will also learn about the relative strengths of competitive services available from Zoho and Google and why you should consider these tools. Knowing all your options is imperative in the new cloud-connected world!

  • How to acquire and access Cloud-based Microsoft Office tools
  • The relative strengths and limitations of Cloud-based services compared to their desktop counterparts
  • Data storage requirements and options
  • Cloud-based options available from Zoho and Google

Implementing Data Loss Prevention for Better Security and Privacy

Randy Johnston

Data Loss Prevention (DLP) is a means of creating and enforcing security policies in an organization. For example, you can create DLP rules that programmatically block all outbound email messages containing Social Security or credit card numbers. Unfortunately, most business professionals have yet to discover DLP and how it improves security.

In this session, you will learn the fundamentals of DLP and, through demonstrations, see how you can use DLP to enhance organizational security. You do not want to miss this chance to learn how to take advantage of one of the most innovative security options available to you!

  • Understanding the concept of Data Loss Prevention
  • Examples of how DLP rules are beneficial
  • Creating and enforcing DLP rules
1:40 pm - 1:50 pmBreak

1:50 pm - 2:40 pm

Choosing Your Mid-Market Accounting Solution

Randy Johnston

Many businesses are being held back by legacy solutions. The old way of doing things just doesn’t work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments.

This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor's knowledge of the market to minimize your risk.

  • Overview of mid-market solutions
  • Probable third-party solutions required
  • Accounting solutions for specific industries
  • Specific strategies to use on selecting a system
  • Guidance on preparatory steps and conversions

Supercharging Your Spreadsheet Collaboration 

Jeff Cook

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration.

Further, Excel's Inquire tool can facilitate spreadsheet collaboration in offline environments. Don't let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.

  • Collaboration methods using Microsoft Office and Microsoft 365
  • Ways to track changes to sheets and compare different versions of a file 
  • Tools for sharing and responding to comments among a team from within a file

Privacy Issues and Solutions – What You Need to Know! 

Tommy Stephens

Privacy should be everywhere, yet every day seemingly brings a new story about a privacy violation. While it can be frustrating and sometimes scary to think about mishandling our personal information, it’s important to remember that we can take steps to protect our privacy.

This session will teach you where your critical threats are and what information you may already have at risk. More importantly, you will learn how to manage and mitigate privacy risks. In an era of increasing connectivity - and by extension, risk - this session should be high on your list to take as soon as possible.

  • The most significant privacy threats today
  • Your browser and search engine and why they matter
  • Privacy policies - the fine print
2:40 pm - 2:50 pmBreak

2:50 pm - 4:30 pm

The K2 Team’s Top Tech Productivity Tips and Tricks

Jeff Cook

The world of work changed radically and became much more virtual after the pandemic’s onset in 2020.  Over two years into the “new normal,” our team has compiled a list of the top technology productivity tips, tricks, and traps.

In this session, you will learn about shortcuts and hacks to help you accomplish more in Excel, Teams, Outlook, virtual meetings, and many other applications you use every day. Attend this session and learn the best tips to help you and your team accomplish more in less time.

  • Microsoft 365 tricks and tips
  • Best practices for virtual meetings
  • Productivity-enhancing apps and tools that you should consider using

Jeff Cook, CPA, CA, CITP, is the president of Cook+Co, Chartered Professional Accountants, a virtual accounting firm that services small to medium sized businesses across Canada in advisory, tax, and information systems.

Jeff has a rich history in public accounting having worked with a specialized boutique firm that provides training and consultation exclusively to the public accounting industry; a large regional firm; and the Office of the Auditor General. Beyond work Jeff volunteers with CPA Canada’s Financial Literacy, and Squash Canada.

Aranka Anema, PhD - CPABC Business and Innovation Speaker

Randy Johnston is a partner at K2E Canada Inc, and a nationally recognized educator, consultant, and writer.

He has over 40 years of experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services.

Tommy Stephens maintains professional memberships with the American Institute of Certified Public Accountants and the Georgia Society of Certified Public Accountants. In 2003, Mr. Stephens affiliated with K2 Enterprises and in 2007 he joined the firm as a partner.

To date, he has lectured nationally on subjects such as internal controls for small businesses, technology strategies, computer hardware and software applications, tax strategies and compliance, and financial accounting standards and applications. Tommy resides in Woodstock, Georgia where, in addition to his association with K2 Enterprises, he provides consulting services to small businesses and CPA firms.