QuickBooksHelpIntuit
Combine multiple QuickBooks Online reports
by Intuit• Updated 2 months ago
If you want to bring together information and data from different reports into one report, you can do this by exporting the individual reports manually. After exporting, you can edit and combine them outside of QuickBooks Online.
This article guide you through each step:
1. Run and customise the report
- Go to Reports.
- Use the search bar to find the specific report you want to combine.
- Select the report.
- Choose the desired date range, filters and other options.
- Select Run report to generate the report.
- To further customise the report, select Customise.
2. Export the report
- Select Export.
- Choose the file format you prefer, like Excel or CSV.
- Save the report to your computer.
Repeat steps 2 and 1 for all the reports you want to combine, exporting them as well.
3. Edit and save the report
You'll need to use a spreadsheet program like Microsoft Excel or Google Sheets.
- Open the exported reports in your preferred spreadsheet program.
- Choose one exported report file to be the main report. This is where you’ll combine all the data.
- Copy the data from the other reports and paste it below the data of the first report in the same spreadsheet.
- Rearrange and format the combined data as needed, make sure that the columns align correctly.
- Once you’ve finished editing the combined report, save it as a new file on your computer.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.