How to Create Custom Reports in QuickBooks Online: Save a Standard One, or Build From Blank
A partner wants profit by month for one location, or the owner wants the same aging report every week without having to ask. On most plans you open the closest standard report, change it, and save it under a name. On Advanced, the Custom Report Builder lets you start from an empty report instead.
Open the nearest standard report, then set the dates, filters and columns until it answers the question.
Reports › Standard reportsSave it under a name with Save As, and switch on Share with others if colleagues should see it too.
Save As › Report name › SaveRun it again any time from the Custom reports tab. It picks up the latest numbers each time.
Reports › Custom reportsTurning a standard report into one you'll reuse
- 1
Pick the report closest to the question
Sales by Customer Detail, A/R Aging Summary, Profit and Loss by Class: whichever already has the right rows means less to change. Customizing a near match is nearly always quicker than starting over.
- 2
Set the period and the basis
Choose cash or accrual, and the date range. A relative range such as This month or Last quarter moves forward every time the saved report runs. A fixed range from the calendar stays put.
- 3
Narrow it with filters
Customer, vendor, class, location, account, transaction type: this is usually what makes a report yours rather than Intuit's. In classic view the options sit behind Customize; the modern view keeps them on the report screen.
Watch for: missing class or location filters. They only appear once tracking is switched on, which takes Plus or Advanced. Our class tracking guide shows the setting.
- 4
Choose rows, columns and grouping
Group by customer, month or account, and drop the columns nobody reads. A report that fits on one screen gets read; one that scrolls sideways gets exported and rebuilt in a spreadsheet.
- 5
Save As, then share or group it
Give it a name someone else will recognize, decide on Share with others, and use Add to group if you plan to schedule it. Edit it later and you'll need to save again, or the changes are gone the next time it runs.
Customize a standard report, or use the Advanced builder
A saved standard report
- Starts from one of Intuit's reports, so the layout and totals are already right.
- You change dates, filters, columns and grouping, then save it.
- Lives on the Custom reports tab with every other saved one.
Custom Report Builder
- Reports, then Custom reports, then Create new report: pick a report type and add the columns you want.
- Filters can be And or Or, and you can group by up to three columns.
- Pivot, chart view and calculated fields are built in.
If a standard report gets you most of the way, customize it. Reach for the builder when no report starts anywhere near the question, and only if you're on Advanced.
Scheduled emails, and the report QuickBooks can only run one company at a time
A saved report can go out on its own. It has to be in modern view and in a group: from the Custom reports tab, open the ⋮ menu next to the report, choose Schedule report, set who gets it and how often, then Save and turn on. Every report in a group follows that group's schedule. Simple Start, called EasyStart in some regions, can't schedule.
What the schedule can't do is look across companies. Each QuickBooks Online report runs inside one company, so a business with three entities gets three separate emails and somebody adds them up by hand. Intuit Enterprise Suite adds multi-entity reporting, but on Plus or Advanced n-frames builds the consolidated version: the same report pulled from each company through the QuickBooks API, set side by side with a combined total, and sent on the schedule you'd have chosen in QuickBooks.
Questions people ask
How do I edit a custom report I've already saved in QuickBooks Online?
Open it from the Custom reports tab, change what you need, then save again. Use Save As with a new name if you'd rather keep the old version alongside it.
Can I export a custom report to Excel with its filters intact?
Yes. Open the saved report and use the export option above it to choose Excel. The file contains what's on screen, so your filters, columns and grouping come with it. Our export to Excel guide covers exporting everything at once.
How do I delete a saved custom report in QuickBooks Online without losing data?
On the Custom reports tab, open the Action dropdown beside the report and pick Delete. Only the saved layout goes; every transaction it reported on stays. Desktop users can follow our memorized report guide.
Is a custom report in QuickBooks Online the same thing as a Desktop memorized report?
Same idea, different names. Desktop calls a saved, customized report a memorized report and lists it under Reports, Memorized Reports. Online calls it a custom report and keeps it on the Custom reports tab. Memorized reports generally don't come across when a Desktop file is converted to Online, so plan to rebuild your favorites.
Can one custom report cover several QuickBooks companies?
Not inside QuickBooks Online Plus or Advanced. Each report reads one company's books. n-frames builds consolidated reporting for multi-entity businesses, pulling the same report from each company and combining them on a schedule.