how to customize reports in quickbooks online

How to Customize Reports in QuickBooks Online

By Jessica Wilson
AD

Looking to streamline your bookkeeping tasks? Customizing reports in QuickBooks Online can save you time and ensure you're always up-to-date with accurate financial information. Let's dive in and explore how you can tailor reports to fit your business needs.

Before we get started, ensure you're logged into your QuickBooks Online account. Now, let's unlock the power of custom reports.

Accessing Custom Reports in QuickBooks Online

To begin, navigate to the 'Reports' menu at the top of your screen. Here, you'll find numerous report templates. To customize, click on 'Custom Reports' in the list.

AD
How To Run a Statement of Cash Flows in QuickBooks Online
How To Run a Statement of Cash Flows in QuickBooks Online
Saving Custom Reports in QuickBooks Online
Saving Custom Reports in QuickBooks Online
How To Customize A Profit & Loss Report In Quickbooks (Quickbooks Tutorial)
How To Customize A Profit & Loss Report In Quickbooks (Quickbooks Tutorial)

This brings you to the 'Custom Reports' section, where you can create, edit, or delete custom reports as needed.

Creating a New Custom Report

To start fresh, click on the 'New' button. You'll be prompted to choose a report type, such as Income & Expenses, Profit & Loss, and more. Select the one that suits your needs and click 'New' again.

How to pull a Report showing Emails sent in QuickBooks Online
How to pull a Report showing Emails sent in QuickBooks Online
QuickBooks Online Tutorial: Customizing Reports
QuickBooks Online Tutorial: Customizing Reports

This opens the 'Reports Settings' page, where you can customize the report layout, columns, filters, and more.

Editing an Existing Custom Report

If you already have a custom report and wish to modify it, select the report from the list and click 'Edit'. This again opens the 'Reports Settings' page, allowing you to make changes.

AD

Remember, editing a custom report doesn't affect the original template. It only changes the specific instance you're editing.

Customizing Report Settings in QuickBooks Online

In the 'Reports Settings' page, let's break down the customization options to help you create the perfect report.

1. **Layout**: Choose a layout that fits your needs, such as Accrual, Cash, or Custom. You can also change the report date range here.

AD

Customizing Columns

The 'Columns' section lets you add, remove, or rearrange data columns in your report. Simply drag and drop columns to customize your report's appearance.

To add a new column, click on 'Add column', choose the data field you want to add, and click 'Add'. To remove a column, click on the 'X' in the column header.

Filtering Report Data

The 'Filters' section helps you drill down into your data. You can add filters for Class, Customer, Vendor, Product/Service, and more. This ensures you're only viewing the data you need.

AD

To add a filter, click on 'Add filter', select the filter type and values, and click 'Add'. You can remove filters by clicking on the 'X' in the filter box.

Saving and Printing Custom Reports

Once you've customized your report to perfection, it's time to save and print. Click 'Save and run' to run the report with your customizations, or click 'Save as new template' if you want to save your report as a new template for future use.

To print your report, click the 'Print' button in the top right corner. Here you can choose your printer settings and - if desired - adjust margins to fit more data on a page.

Exporting Custom Reports

QuickBooks Online also offers an export option for your custom reports. After running your report, click on 'Export' and choose your preferred file format, such as Excel, PDF, or CSV.

This allows you to save your report to your computer or cloud storage and access it offline, or share it with others.

And there you have it! With these steps, you're well on your way to creating customized reports that save you time and provide the exact data you need. Keep experimenting with different report types, layouts, and filters to find the perfect combination for your business. Happy customizing!

AD