K2's Road to Excellence - Part 3
Excel Guru and Receipt Bank

This is the first of the 2019 Excel Guru sessions series that will focus on Excel Tips and Tricks.

How much do you know about Excel and the features and functionality it provides that could make a difference in your personal day-to-day productivity? Most accountants and other business professionals use less than 20% of the functionality of this product. Are you taking advantage of the features that are best for you? This session is sure to deliver many thought-provoking ideas and tips for getting better results with less effort and in less time.

Learning Objectives

  • Identify key productivity-enhancing Excel functionality and features
  • Differentiate between Excel functions and features to obtain the best fit for your objectives
  • List capabilities that have direct application to your practice or business
  • Apply the knowledge gained to improve your personal productivity

Virtual Controller: New Services for Expanding Your Accounting & Bookkeeping Firm

There’s a huge opportunity for firms to add Virtual Controller services to their firm’s service offering. Clients are looking for more from their accountant, and understanding what the numbers mean for their business is the perfect compliment to your accounting and bookkeeping services. You’ll not only be helping your clients grow their business, but you’ll be growing your business with higher value and priced services.
 
Receipt Bank's Damien Greathead helps define what virtual controller services actually are, and how to create a package of these services to deliver to your clients. We’ll show you how the core technology stack integrates to get your client’s information processed efficiently. And you’ll learn how to pitch your clients and prospects on the value that you as a part-time, virtual controller can bring to their business.

More Ways to
Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
Catalogue of upcoming webinars

Questions and Answers

Excel Questions
Answers
Does the flash fill feature need to turned on, or is it automatic?
Automatic
What is the easiest and least expensive way of upgrading only Excel from 2013 or earlier to 2016 or later without purchasing new Office? Upgrade for Excel only. Is that possible?
There is no purchase of standalone anymore.
 
We would recommend Office 365 subscription, this includes features not available and very useful including Ideas. The full version of Office 365 Pro Plus is $16 user/month the pricing for standard is $11 user/month. For a comparison between one-time purchase and subscription check out this link.

For a comparison between Office 2019 and Office 365 ProPlus check out this link.
Receipt Bank Questions
Answers
In regards to the tax lines available in receipt bank, I have looked into similar software that did not allow for more than one tax code which causes a problem for me here in Saskatchewan. With Receipt Bank can I have separate line items for GST and PST at their separate rates?
We have multiple lines for separate tax codes - GST, PST, and HST when applicable.
It looked like your Starbucks receipt example had only GST. Can Receipt Bank deal with multiple taxes with different rates?
Yes. See above.
Do you have an integration for MS Dynamics GP?
We can compile and organize data for everyone, but only have direct integrations with QBO, Xero, Sage One Business Cloud Accounting.
Does Receipt Bank data flow to accounting applications e.g. Sage, QB, Fresh Books and Wave?
We can compile and organize data for everyone, but only have direct integrations with QBO, Xero, Sage One Business Cloud Accounting.
Does Receipt Bank integrate with QuickBooks Desktop?
We do not directly integrate with QB Desktop.
Does Receipt Book have benchmarking functionality?
We have advanced analytics in practice view.