cancel
Showing results for 
Search instead for 
Did you mean: 
YehudaKalshi
Level 2

Custom Reports

Does anyone know of a way to build custom QuickBooks Online reports?
My CEO wants to see very specific details on our expenses, but not how our books are kept for accounting.
Is there a way to build a report that says:
Total expense categories X, Y, and Z together on line 1. A, B, C on line 2, etc.

 

I started off by exporting to Excel, but I need a solution so I don't need to be continually manually updating.

I'm sure there's some 3rd party integration that can do this. Any ideas?

2 Comments 2
JenoP
Moderator

Custom Reports

I'm glad you asked this question about customizing reports in the forum. I'll share details on how you can get the data you need, YehudaKalshi.

 

If you're using QBO Advanced, you can build a report from scratch by adding columns. Let me show you how:

 

  1. Go to the Reports menu and click Create new report.
  2. Select Start by adding data columns.
  3. Proceed to the Columns section.
  4. Add columns by clicking the type of transactions or parameters you want to add. Then, check the boxes before the specific data that will be part of the report. 
  5. Click the Save icon in the upper-right hand corner.

 

build.PNGbuild 2.PNGbuild 3.PNG

 

If you have a different type of subscription, you can continue exporting your data to Excel and customize the report from there. Just click the Export button and select Export to CSV.

 

Let me give you these articles that talk about this function for more details: 

 

 

QuickBooks Online also works with hundreds of third-party apps offering a variety of services, including building customized reports. You can follow these steps on how to look for and integrate an approved and accredited app:

 

  1. Go to the Apps menu and select Find apps.
  2. Type in the word "report" in the Search field and press Enter.
  3. Select an app and click on it to get more details about the program that you want to use.

 

 

Let me know if that answers your question about making reports. You can also ask follow-up questions if you need anything else. 

Fiat Lux - ASIA
Level 15

Custom Reports


@YehudaKalshi wrote:

I'm sure there's some 3rd party integration that can do this. Any ideas?


 

@YehudaKalshi 

Utilize a BI app

https://go.zoho.com/M5c

 

Need to get in touch?

Contact us