cancel
Showing results for 
Search instead for 
Did you mean: 

Financial Reports and Reporting Features

Setting up for Success in QuickBooks Online Banner.png

 

This article is all about reports and financial reporting tools available in QuickBooks Online. Reports really are the core of your accounting. They frame all of your sales, expenses and everything in-between to tell you about the health of your business.

 

Of course, reports are only useful if you’ve entered complete data, so make sure you’ve entered all of your business income, expenses assets and liabilities entered into QuickBooks so you get a comprehensive, accurate snapshot of your business every time you run a report.


 How to Use Reports Center: Categories, Insights & Information | QuickBooks Online Tutorial 2018

 

Reports appear on the Reports Tab Dashboard list (Reports Center), or you can search for something specific from the search field at the top. There are tons of reports available. Most will follow this titling convention: 

(What you want to know) by (the criteria specified)

Some have very specific use-cases, giving you lots of options. There are common reports you’ll want to run on a daily or weekly basis such as:

 

  • Balance Sheet (which follows the Balance Sheet Equation) – tracks assets, liabilities and equity of your business – what you “own” and “owe” within a given time period.
    • Assets - Make sure you understand the difference between current assets (plan to sell within 1 year) and fixed assets (large purchases you plan to use over the course of several years).

    • Liabilities – again, know the difference between a current and long-term liability so you know how to enter things like open bills and loans appropriately. Note that while liabilities are what you owe and you’d assume this should be a negative number, it’s represented as a positive value here.

    • Equity  the value of your business from the perspective of the owner (including their contributions, owner’s draw and net income [activity from income and expense accounts]).

  • Profit & Loss Statement - tracks your income and compares it against the cost of running your business (i.e. expenses).
     
    • This is the most common report you’re likely to run. It’s essentially a summary of your income and expenses so you can see your cash flow.

    • Net Income is your profit after your total income, expenses and Cost of Goods Sold have been factored in. This line shows up at the bottom of your Balance Sheet under Equity (above).

  •  Sales by Product/Service Report – the easiest way to track your sales that can be customized to show varying levels of detail. 

 

How to Use Reports: Understanding When to Use the 3 Types | QuickBooks Online Tutorial 2018

 

 There are three primary types of reports and each has their uses.

  • Summary Reports – for pulling “overview” data with some applied analysis, which is what you will probably use most often or on a recurring basis.
  • List reports – for pulling broad data, such as all your existing accounts or products and services.
  • Detail reports – for pulling “by-line” datasets within a specified date range, such as looking at your sales by customer.

 

How to Use Summary Reports: Summaries & Information | QuickBooks Online Tutorial 2018

 

Summary Reports focus in on specific data points (such as you’re A/P or A/R or total income by accounts) without getting too lost in the line-by-line details. Instead, get a mid-ranged overview of your accounts.

Setting up for Success - Reports 7.PNG

 

These types of reports are particularly useful for looking at long-range trends between specified periods of time.

 


 

How to Use Detail Reports: Transactions, Expenses, & More | QuickBooks Online Tutorial 2018

 

Detail Reports are for when you want to get into the nitty-gritty of your accounts.

Setting up for Success - Reports 8.PNG

 

These provide account summaries as well as individual line-by-line transaction details. “Customer Balance Detail” and “Sales by Customer Detail” Reports are common and useful for zeroing in on very narrow information or identifying a specific set of transactions.

 

The “group” function is also a great way to identify trends while having the specific details displayed side-by-side on the same page.


 

How to Use List Reports: Looking Up Customers, Vendors

 

List Reports are useful for looking at everything in your QuickBooks system, from Products and Services to Employee information to Payment Methods used by your company. Most are broad, but some can get fairly narrow -- want to see all the bills you’ve paid in QuickBooks over the last 3 months? There’s a report for that.

 

Want to hand your team a list of contact emails but not their phone numbers? Run a Customer List Report and customize with the phone number column removed.

 

Another use for List Reports is to clean up your data. Let’s say you want to remove inactive customers from your books but you have a large sales team: pull a CSV for (or print) a Customer List Report, sharing around your team to identify who is no longer a customer and hand it back to a single team member to make those customers inactive.

 


 

How to Customize Reports: Basics, Sorting & Date Ranges | QuickBooks Online Tutorial 2018

 


Running custom reports in QuickBooks lets you narrow in on the data that matters, render the data in ways that make sense to you and eliminate extraneous details so you can easily zero-in on account specifics. Moreover, going narrow with reports means knowing more about how each part of your business impacts its overall health, which ultimately helps you make more informed financial decisions. 

 

Custom reports offer a lot of flexibility: you can apply various filters, sorting tools and ranges to pull very specific data sets.  But some custom reports need not be complicated – a Profit and Loss Report scheduled to be run and emailed on a Monthly basis is a simple one with powerful insights about the trajectory of your business.

 

You can apply these customizations at the top of the form in these two areas:

 

Setting up for Success - Reports 6.png

 

Depending on the report you use, different customization options will be available – not all reports have the same sets of filters, but most do. Don’t forget to hit “Run Report” to apply your customizations. Customizing also enables some other cool features which we will go into later in the article.

 


 

How to Filter Reports: Customers, Vendors, & Products | QuickBooks Online Tutorial 2018

 

Customizing reports with “filters” brings you down to the ground from a high-altitude view of your business. Clicking “Customize” from either the report page or the vertical ellipses tool next to the report on the list gives you access to a number of filters for both row and column report data.

 

Rather than browsing at the enormously diverse array of customizations available to build a report, ask yourself “what data am I really interested in?” Use that answer to find the necessary filters to arrive at your answer - through this process you, will learn what is available.

 


 

How to Add Columns to Reports: Comparing Customers & Time Periods, | QuickBooks Online Tutorial 2018

 

Customizing reports by adding, removing or reordering columns is another great to render the data in ways that make sense to you and eliminating information that is not as useful or potentially distracting, getting you to the insights you need most with the least amount of friction.

 

Displaying figures as percentages, rather than raw figures, is just one compelling reason to dive into the reporting features. 

 


 

How to Save Customized Reports | QuickBooks Online Tutorial 2018

 

Once you find the perfect set customizations, rather than reenter the same set every time you want this data, you can save a customization. Give saved reports a unique name to distinguish them and click “save customization” at the top of the report page.

 

Here are a few custom reports you might want to create and have on hand at all times:

 

  • Monthly Balance Sheet

Filters applied: (“All Dates,” “Date-you-opened” to “1/1/2020,” Display columns by “Months”)

 

Setting up for Success - Reports 2.PNG
 

  • Sales by Customer Detail Report for a high-value customer John Freeman

Filters applied: (“All Dates,” Customize - Filter “Customer - by “Freeman Sporting Goods”)Setting up for Success - Reports 1.PNG

 

 

  • Profit and Loss Report for only Landscaping Installation Income (Service)

 Filters applied: (“All Dates” Display columns by “Months,” Customize – Filter Products/Service “Landscaping Installation”)

 

Setting up for Success - Reports 5.png

 

  • Profit and Loss Report for weekly utility expenses

Filters applied P and L report: (“All Dates,” Display columns by “week” – Customize – Filters Distribution Account “Gas and Electric” and “Telephone”)

 

Setting up for Success - Reports 4.png

 

Saving reports also allows you to group them so you can set permission for who can access and view the data – which might be important if you’re working with sensitive information across a wide team.

 

Remember too that reports automatically update with fresh data every time you run them.

 


 

How to Automatically Email Reports | QuickBooks Online Tutorial 2018

 

The more features you can set on auto, the more time you will have to focus on more important business matters.

 

There are cyclical reports you can schedule right away that coincide with financial periods, such as a monthly Profit and Loss Report or a weekly Balance Sheet. Remember, custom reports don’t have to be complex and the interval may be enough to put it on this “recurring” email basis. 

 

If there are custom reports you run regularly or you want constant updates on a particular report, consider scheduling them. At first, schedule them to send more often than you’d think you need and adjust from there – it’s better to get more information ahead of time than too little information too late.  

 

To email reports, click on the Reports Tab and then the “Custom Reports” sub-tab. Select the report you want to modify, click “edit” and you can enable permissions for the report – which is separate from who will receive the email. Once you turn on “set email schedule,” you can designate the date, time interval and even set an end-date (or “none” for indefinite sending).

 


 

How to Create a Management Report: Different Kinds, Editing & More | QuickBooks Online Tutorial 2018

 

These are stylized “presentation-worthy” versions of reports that allow you to include notes. You can also export these into PDF or DocX files and even edit them to have a table of contents. Your team may prefer the standard format, but management reports are a great way to send a professional-looking PDF to share good news around to the team. 


Set up for Success in QuickBooks Online

 

Check your progress

 

Learn everything you need to be successful in QuickBooks

 

Version history
Revision #:
8 of 8
Last update:
‎09-18-2018 06:29 PM
Updated by:
 
Contributors
Comments

We have a vehicle loan set up as a long term liability.  When I do the budget, only income and expenses show - so the monthly amount paid towards this loan is not showing as an expense.  How do I fix this?