Data Quality is vital to the success of any business, especially companies in the professional service sector. Whether you are serving a law firm, accounting practice, or marketing company, the importance of tracking specific details at the invoice level often becomes time intensive and expensive.  Discover how using QuickBooks Online Custom Fields will increase your profitability by streamlining your workflow while improving the accuracy of your data.  You’ll also learn how to uncover additional advisory opportunities utilizing custom reporting based on your custom fields.

DISCOVERING DATA POINTS

graphic Image of people studying data points

Sometimes the most challenging task for a business owner is understanding what data points they should be tracking. This is where, as their trusted adviser, we have an opportunity to make one of the greatest impacts to their business.

Knowing how to uncover the crucial data points for any business requires three tasks:

  1. Interview the company stakeholders to understand the business:
      • Mission & Vision
      • Pain Points
  2. Evaluate the complete sales cycle
      • Take note of the different roles assigned to employees
      • Reviewing the current flow of information
  3. Review the current accounting workflow

INTERVIEWING THE STAKEHOLDERS

Whether this is a new client or company that you have been working with for some time, scheduling a time to conduct a thorough interview of the important stakeholders will allow you to better understand the mission and the vision of the company.  While this step may seem trivial, it is a crucial starting point especially when a company has multiple stakeholders who may have different visions of the future.  By understanding the desired future of the business, we will be able to better evaluate their progress to date.

graphic image of a business manager looking into the future

Understanding the desired outcome also prepares us for our next task, uncovering the pain points impacting the company.  At surface level, most pain points will be simplified down to two categories; time and money.  During the interview process it is important to help the stakeholder dive below the surface to truly uncover the cause of the pain while allowing them to discover potential solutions at the same time.

Even with the small amount of information we gathered from the interview process, it would be easy for us to offer suggestions on how to evaluate the performance of the business without ever looking at the company financials or spending time to understand their sales cycle.

EVALUATE THE SALES CYCLE

Graphic image of the lifecycle of a new sales lead.

During the interview stage, we learned about the desired goals and the perceived pain points of the stakeholders, but now we need to validate that information.  To accomplish this, we must also understand the sales cycle of the business and how it relates to the daily operations of the company.

Starting from the acquisition of new leads, and through to the completion and payment of the transaction, it is important to note the different internal roles assigned to employees as well as the flow of information throughout the cycle. Pay attention to what information is collected at each touch point and where that information is stored.

REVIEW THE CURRENT WORKFLOW

Graphic Image of two people discussing the sales metrics of the business

Now that we have a complete picture of the business operations and how it connects with the stakeholder’s vision for the company, we can start our final task, the review of the accounting information.

By evaluating the structure of their accounting, it allows us to review their existing reporting and how they use:

This information will help us better understand what data points they are already tracking and evaluate it against the information we learned from our review of the sales cycle and stakeholder interview.

Discover what data points to track

CASE STUDY: SPOT-ON ACCOUNTING

If we evaluate our scenario, Mary introduced both the vision of her company and multiple pain points that she feels are holding her back.

Desired Goal: Industry specific marketing agency that is known as the specialist in that field.

Problems to Solve:

  • What industry should she specialize in?
  • Why am I less profitable with more sales and more employees?
  • Can I afford to hire another person?

CUSTOM REPORTS IN QBO

Custom Field / Class / Location / Project
Created and Updated by Hector Garcia & Matthew Fulton

bit.ly/qboreporting

CUSTOM REPORTING USING QUICKBOOKS ONLINE CUSTOM FIELDS

A/R AGING DETAIL REPORT BY SALES REP

By using the Sales Rep custom field, we can provide each sales rep with their own past due reporting.

This will help reduce the company’s Days Sales Outstanding ratio

How to Create This Report:

  1. Create an A/R Aging Detail Report
  2. Add Custom Field for Sales Rep
  3. Remove columns not shown in report
  4. Filter Data by Sales Rep
AR aging Detail Report using Custom Fields in QuickBooks Online Advanced

REVENUE EARNED BY PRODUCTION TEAM

Revenue Generated by Production Team using Custom Fields in QuickBooks Online Advnaced

By using the Content Creator custom field, we can evaluate the total revenue generated by each member of the production team.

This is information is helpful when evaluating the efficiency of the department for quarterly bonuses.

How to Create This Report:

  1. Create Transaction List By Customer Report
  2. Add Custom Field for Content Creator & Sales Rep
  3. Remove columns not shown in report
  4. Group Data by Content Creator

EXPLORING CUSTOM FIELDS IN
QUICKBOOKS ONLINE ADVANCED

THANK YOU FOR ATTENDING!

Matthew Fulton presenting at QuickBooks Connect 2019

I want to thank everyone who attended my sessions at QuickBooks Connect 2019! I hope that our time together provided you with the knowledge you were seeking and left you more excited about the benefits held within QuickBooks Online Advanced!

During our session I touched on a couple different resources that would be helpful:

Parkway YouTube Channel

QB Community Live Facebook Group

QBO Advanced Test Drive

CDATA Software

Lynda Artesani

Join to newsletter.

Subscribe to be notified of new content.

Do you have a question we can help you with?

Call us today at (805) 419-9197

We look forward to connecting soon.