QuickBooks HelpQuickBooksHelpIntuit

Common custom reports in QuickBooks Online

SOLVEDby QuickBooks401Updated 3 weeks ago

Learn specific ways to customize your reports to get awesome insights.

In QuickBooks, you can customize your reports so you can focus on specific details in your financial reports. Here’s how to customize common custom reports that fit your specific needs:

Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.

Run and add filters to Transaction List by Date report to see transactions with your customers or vendors.

  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select Transaction List by Date.
  3. In the Report period ▼ dropdown, select the date range.
  4. In the Group by ▼ dropdown, select  Customer, Vendor, or Employees.
  5. Select Customize.
  6. In the Filter ▼ dropdown, select the transaction that you want to see in the report.
    Note: If you want to see specific customers or vendors, select their name in the Name ▼ dropdown.
  7. Select Run report.

Run a Profit and Loss report to see income and expenses for your customers or vendors.

  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select Profit and Loss.
  3. Select Customize.
  4. In the Columns ▼ dropdown, select Customers or Vendors.
  5. Select Run report.
  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select the report that you want to open.
  3. Select Customize.
  4. In the Columns ▼ dropdown, select Customers or Vendors.
  5. Select the Filter ▼ dropdown.
  6. Select the Name ▼ dropdown, then select the name of the customer or vendor that you want to see in the report.
  7. Select Run report.

Run Budget vs. Actual report to compare your budget and actual spend.
Note: If you haven’t, create your budget first.

  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select Budget vs. Actuals.
  3. Select Customize to add the needed filters.
  4. Select Run report.

You can customize report columns to show different report periods.

In this example, let's compare different years on a Profit and Loss report. You can use these steps for other reports and time periods:

  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select Profit and Loss.
  3. Select Customize.
  4. Select Rows/Columns ▼ dropdown.
  5. In the Columns ▼ dropdown, select Years, Fiscal Years, or Calendar Years. You can also select days, weeks, or quarters to get other time periods.
  6. Select the Previous year checkbox.
  7. If you want to see your numbers as percentages of your account totals, select one of the % options. 
  8. Select Run report.

This lets you quickly see which products or services have the biggest impact on your business.

  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select the report that you want to open.
  3. Select Customize.
  4. Select Rows/Columns ▼ dropdown. 
  5. Put a checkmark in the % of income checkbox.
  6. Select Run report.
  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select the report that you want to open.
  3. Select Customize.
  4. In the General ▼ dropdown, put a checkmark in the Show in red checkbox.
  5. Select Run report.
  1. Go to Reports (Take me there).
  2. In the Find report by name ▼ dropdown, select the report that you want to open.
  3. Select Customize.
  4. Select the Header/Footer ▼ dropdown.
  5. Remove the check in the checkbox of the info that you no longer want to include in the report.
    Note: You can change the company name in the Company name field or remove it. You can also do the same for the report title.
  6. Select Run report.

Share your tips and learn from others in our community.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this