The more our customers use, the more we train. We get excited about learning new queries because it means we are always getting better and becoming a more powerful tool for our customers.

We’re proud to have trained thousands of types of questions and continue train more every day. Check out these queries:

November 26, 2018

Number of new customers – a key sales & marketing metric  

New customers you acquire in a specific time frame is an excellent metric to track the progress of your sales and marketing initiatives. You can just query: 

  • Number of new customer last month 
  • Number of new customers in the last 3 months 
  • List all new customers in the last 6 months 
  • Number of new customers YTD 

You can also use this information to create targeted marketing campaigns, custom content, and ideas for upselling. Get to know what your new customers are purchasing by querying: 

  • Total sales for [specific customer] last month  
  • List all sales for [specific customer] last month 
  • All sales by line item to [specific new customer]  

>>>Check out this article by email marketing tool, Constant Contact, on the importance of data quality for small business marketing: Why Data Quality is a Small Business Problem Too, and What to Do About It

November 12, 2018

Comparing your expenses to income: Business Planning 

If you are a growth-focused business owner or an advisor, creating a plan and closely monitoring finances is critical to achieving set targets. When you are in the weeds with the day-to-day operations it can be challenging to monitor performance. can help. A great place to start is by researching your past performance and setting up easy reporting to monitor trends. Try these income and expense queries to kick off your game planning session:  

  • Average income and average expenses per month last year 
  • Average income and average expenses per month for the last 3 months 
  • Total income and expenses for last month 

You can also think of this in terms of an expense to sale ratio. Just query: 

  • What were my expenses for the last 3 months as a percentage of income 
  • What were my expenses for the last year as a percentage of income 

Use your data to plan the work >>> then work the plan! 

October 31, 2018

Cash Flow (Show me the money!)

For business owners, cash is key. Cash flow determines your resources, budgets and ultimately your growth. Channel your inner Jerry Maguire with these queries and we’ll show you the money!

Keep in mind:
Cash flow is money in and money out
Inflow is just money in
Outflow is just money out


  • What is my cash inflow this month?
  • What was my cash outflow last month?
  • What is my cash flow for the last three months?
  • Show me cash flow by customer for the last three months?
  • Cash flow by customer by month for the last three months
  • Average cash flow per quarter

Tip >>> using these cash flow queries in is a great way to keep a high-level pulse on what is going on with your business and help you to start planning. Pair the power of with our favourite forecasting app, Dryrun, and take the  next steps in planning for the future growth of your business.

October 4, 2018

Track your profits by class 

Utilizing classes or tracking categories in your cloud accounting software can help you get answers you need quickly and easily by organizing your data effectively. You can use classes to track categories for revenue streams, business departments, locations and expenses to help you monitor important trends and make proactive decisions. Reporting on class types is now even easier using  

Easily report and track your profits based on class by using the following queries in a template: 

  • What was the class with the highest net profit last month 
  • What was the class with the highest net profit last year 
  • What were top 5 classes by total profit YTD 
  • List total profit by class by month for the last 6 months (this gives you a beautiful pivot table!) 

Check out these two “How-To” articles to get started with tracking classes (QuickBooks Online) or tracking categories (Xero): 

>>>Using classes and locations in QuickBooks Online 

>>>How to set up tracking categories in Xero 

September 20, 2018

Pivot Tables: Compare related pieces of data at the same time

Being able to compare two important components impacting your financial data has been tough – until now. has recently learned how to do pivot tables. Now you can easily extract and compare data by using queries like:

  • Total expenses per supplier per month last year
  • Total revenue by customer by month last 3 months
  • COGS per customer by product last 6 months

Your data will be presented to you in an easy to read pivot table >>>

Tip >>> If you want to visualize this type of information a different way, ask for a heat map or a bubble chart by clicking the option on the top left corner of your pivot table result. Next steps: drill down to get the details right with one click on a piece of data in your table.

August 30, 2018

Sales Receipts

Digging through countless transactions, finding customer receipts and then verifying inventory up against sales receipts can be dizzying. Try some of these queries to help get a handle on that paper trail.

  • All sales receipts for <<product name>>
  • Total and average sales receipts this month
  • List all sales receipts for <<customer name>>

You can also query “List all Invoices”. Asking “List all sales transactions” will give you the full list of sales receipts and invoices.

Tip>>> We’ve preloaded a Sales Template in your account, give it a try. You can now easily add and take away queries from templates by simply editing the master copy.

August 28, 2018

Accounts Payable: Bills

Tracking unpaid bills is now as simple as just asking, so you’ll never pay late again.

  • List all unpaid bills
  • List all unpaid bills for the last 30 days
  • All bills per account
  • Total bills per quarter

You can also simply ask “Who do I owe money to?” You will receive a list of vendors and your total outstanding bills. Go ahead and click on a vendor to drill down and get to the details.

Tip>>> Bills are a reality of any business and most recur on a monthly basis. Set up a template, using our new template builder in to track your bills and who you owe money to. Visibility with your AP has never been easier.

August 23, 2018


Sales tax is a complex challenge for many businesses! It must be taken into consideration for both sales and purchase transactions. 

On top of that, the complexity increases as the business landscape changes through advances in technology and resulting compliance standards  

Head spinning? We can help! Start to understand how sales tax is impacting your business by asking questions. 

  • Show me all sales tax per month 
  • Total sales tax last month 
  • Total invoices and total sales tax 

>>> Have you heard about “economic nexus”? Check out this article & watch the videos from our friends at Avalara: South Dakota vs Wayfair – Economic Nexus.

  • You can query “total sales per state last year” to understand where you may need to take action. 

August 21, 2018

Evaluating your customers  

Getting to know your customers and how they impact your bottom line is vital to your business. There’s multiple ways you can assess their behavior over time. Identify the true quantitative value of a customer by determining their percentage or ratio of the big picture. You can also look at how long it truly takes them to get the cash flowing. Ask questions like:

  • Percent total income per customer 
  • Percent total income per customer per month
  • Average days to pay per customer
  • Average days to pay per customer per month 

An even more powerful query:

  • Total sales divided by average days to pay per customer 

How long would it take you to find these answers without!

*Mind blown* 

August 16, 2018


All business owners benefit from having a handle on their day-to-day business transactions. With it’s easy to explore your transactions by customer, date and transaction type. Just ask questions like:

  • Total expense transactions by account
  • All transactions from Tommy Joe [or any of your customers] for 2018
  • All revenue transactions from July 2018 above $2000

Tip >>> Although our system can disambiguate or understand the context of your question, it is helpful to be specific on what type of transaction you are looking for. For example, use the phrasing “expense transaction” or a “revenue transaction.”

August 14, 2018

Cost of Goods Sold

When looking at how to increase your gross profit, it is important to understand your cost of goods sold and monitor trends so that you can plan ahead. Just query:

  • Total COGS last month
  • COGS per product last month
  • COGS per product per customer last month
  • Change in COGS per month last 3 months
  • Total COGS per month last 12 months

Tip >>> Set up a template or run a report that includes queries on gross profit, cost of goods sold and inventory to get the full picture.

July 26, 2018

Estimates and Purchase Orders (PO) numbers

For many product or service-based businesses, tracking estimates and open purchase orders from clients can be a headache. Keep track of issued estimates and the progress of purchase orders with these queries +


  • All accepted estimates from May 2018
  • Open estimates for Home Depot
  • Total estimates by status
  • All pending estimates this month
  • All pending estimates above $200

Purchase Orders:

  • All open purchase orders
  • All open purchase orders for July 2018
  • All open purchase orders for July above $500
  • All open purchase orders for July above $200 for Home Depot
  • Count open POs for June
  • Closed purchase orders June 2017

Tip >>> To get a quick list of all of your estimates and POs that are saved in your accounting software, simply ask ‘all POs’ or ‘all estimates’ – you can then explore further by asking more specific questions about certain clients,  vendors, time frames, and status.

July 19, 2018


Being able to ask questions about the last time your accounting data was reconciled is important in ensuring transactions in your accounting software match what you have in the bank.

Examples of questions you can ask:

  • All reconciled transactions
  • All unreconciled transactions this month
  • Show me reconciled transactions over $500 last month
  • Show me reconciliation discrepancies
  • All unreconciled transactions this quarter

Tip >>> With our latest update, you can query your reconciled and unreconciled transactions, so you can find discrepancies and ensure the data you are querying is accurate and up to date.

June 21, 2018


Unless you are a super genius and can remember exact quantities of a product you have on hand – can now help jog your memory with queries like: 

  • Total quantity on hand per product 
  • How many boilers did I sell  
  • All item purchases  

Tip>>> With our mobile app, you can now check inventory from your phone, while you’re on the jobsite. Take the guess work out of quantity on hand – from the palm of your hand. 

Tip >>> From our friend Seth David at Nerd Enterprises, learn more about the e-commerce inventory cycle.


June 19, 2018


Gross profit calculations can be complicated for some and time consuming for others. Until now.  

Now, you can just ask. can calculate your revenue less cost of goods sold in a flash! Here is just a snap shot of just a few types of profit queries that we can now handle:

  • Total profit per customer last month 
  • Compare profit month over month 
  • What is my gross profit per quarter? 
  • Total profit per product per month 

Tip>>> Make sure when inputting expenses into your account that you have linked your “class” to your “expense”. This way you will get a more accurate answer of your gross profit calculation 

Did you know? >>> “Total profit per product” is one of many calculations that can’t be done directly in QBO? One more reason to sign-up for 

June 12, 2018 has received a “query boost” recently!

Item Sales

  • total and average sales per item this month
  • total and average sales per customer per item this month
  • change in total sales per item per month

Tip >>> Try different time periods instead of “this month”. You can ask “this year”, “last year”, “January 2017 – March 2017”, “from the last three months”, “from the last three days” etc.

Accounts Receivable

  • all open invoices
  • customer balance
  • all customers with outstanding invoices
  • How much does Lew Plumbing owe me?

Tip>>> Drill down! Run one of the above queries like, “customer balance”. Click on one of the customers that appears and you will be shown all of the transactions that make up the outstanding balance.


Our team is working hard to provide the best possible education content. If there's anything you would like to learn more about, please connect with us at

More posts by