The QuickBooks Online Advanced custom report builder: set it up so the numbers tie.
Set up well, the custom report builder in QuickBooks Online Advanced answers the question no standard report does. Set up wrong, it sends out confident numbers that don’t tie to the Profit and Loss — a filter that drops a transaction type, a grouping on classes nobody applies consistently. Bring in a professional when the report will go to a lender, a board, or partners, or when it groups on classes and locations that aren’t clean yet. The feature itself lets you pick the fields you want, group and subtotal them, filter to the rows that matter, and visualize the result with custom charts. It requires the Advanced subscription tier, and a custom report is only as trustworthy as the data underneath it. Below: what Intuit’s help article says, how to build reports that hold up, what the report must tie to, and when a ProAdvisor should help.
The QuickBooks Online Advanced custom report builder builds reports the standard report set doesn’t cover.
Intuit’s help article Customize your reports with a modern view in QuickBooks (read October 15, 2026) says: “With QuickBooks Online Advanced and Intuit Enterprise Suite, you can create and personalize reports” using Custom Report Builder, starting from Reports, then Custom reports, then Create new report. You choose the fields (columns), group rows into subtotals (“You can select up to 3 columns”), filter to the records that matter, add custom charts, and schedule the report by email. It’s the feature for reporting questions a canned report can’t answer — revenue by class and customer, say, or a margin view the standard P&L doesn’t produce. A custom report inherits whatever is true of the underlying data, so the test before anyone relies on it is simple: its total for the period equals the same figure on the standard Profit and Loss, on the same accounting method.
What Intuit’s help article says about the custom report builder.
We read Intuit’s help article Customize your reports with a modern view in QuickBooks on October 15, 2026 (Intuit dates it September 7, 2026), with the custom-roles article dated October 9, 2026. The rules that matter for the books:
- Plan. “With QuickBooks Online Advanced and Intuit Enterprise Suite, you can create and personalize reports.”
- Grouping. “You can select up to 3 columns” to group by.
- Time intervals. “Weeks isn’t available as a time interval if Show unrealized gain or loss is toggled on.”
- Who can see it. Intuit’s custom-roles article says “Custom roles let users manage access only to standard reports and not custom reports created by other users.” A report built for a manager on a custom role may need another route to reach them.
The steps, as Intuit gives them
- Go to Reports, then Custom reports, and select Create new report.
- Choose a starting point and select Create: the report creation wizard (“Search for a specific report type”) or a blank report (“Manually add, remove, or drag columns to reorder”).
- Group from the Groups dropdown, then Group by. Filter from Customize, then the Filters dropdown: choose a data type, an operation, and the values.
- For a chart, select Chart View, pick the chart type and axes, and select Save. Column changes save through Save As.
- To schedule it, open the report, select the three-dots icon, then Schedule report; name the workflow, set the email recurrence, subject and message, and select Save and turn on.
Menu names change as Intuit updates the product, so check the article itself before you follow a step. TechBrot is not Intuit: a plan, login, or software problem goes to Intuit.
What the QuickBooks Online Advanced custom report builder does.
The moving parts of the feature, in the order you meet them — from choosing fields through saving and scheduling the report you build.
Part 01 · Start from your data, not a pre-built report
The standard QuickBooks Online reports are templates you adjust at the edges. The custom report builder starts the other way around: you begin from your underlying data and assemble the report you actually need. That’s the whole point of the feature — it answers a reporting question the canned reports don’t, instead of forcing your question into a report that was built for a different one.
Part 02 · Pick the fields the report shows
You choose the fields — the columns — that appear in the report, selecting the data points that matter and leaving out the noise. Picking the right fields is what makes a report readable: enough to answer the question, not so many that the answer gets buried. This is the first real decision in the builder, and it’s where a clear sense of the report’s purpose pays off.
Part 03 · Group rows into meaningful subtotals
Grouping rolls rows up into subtotals — by customer, class, location, product, or another dimension — so the report reads as totals that mean something rather than a flat list. Grouping is where reporting structure meets accounting structure: it only works as well as the chart of accounts and class tracking it groups on, which is why clean data underneath matters here more than anywhere else.
Part 04 · Filter to the records that matter
Filters narrow the report to exactly the records in scope — a date range, a class, a customer set, a transaction type — and drop everything else. Good filtering is the difference between a report that answers the question and one that technically contains the answer somewhere in a thousand rows. Filters and grouping together are what turn raw data into a focused view.
Part 05 · Visualize with custom charts
Custom charts turn the report you’ve built into a visual — so a trend, a comparison, or a concentration reads at a glance instead of as a column of figures. The chart is the presentation layer; it inherits whatever is true of the report behind it. Build the report well and a custom chart makes the answer obvious; build it carelessly and the chart just makes a wrong answer look confident.
Part 06 · Save and schedule the report to share
Once a report is built, you can save it so you’re not rebuilding it each month, and schedule it to be shared on a regular cadence with the people who rely on it. Saving and scheduling is what turns a one-off report into a repeatable reporting process — the same trustworthy view, delivered automatically, instead of someone recreating it from memory every period.
How to build custom reports well.
Six steps, in order. The first defines what the report is for; the rest build it so the answer is reliable instead of just impressive.
- 1
Define the decision the report supports first
Before touching the builder, name the decision the report is meant to inform — which customers to focus on, where margin is leaking, whether a segment is growing. A report built to answer a specific question is sharp and useful; a report built to “show everything” answers nothing. The decision dictates the fields, grouping, and filters, so settle it first.
- 2
Get the chart of accounts and classes clean
A custom report groups and totals on your underlying structure, so a disorganized chart of accounts or inconsistent class tracking produces a report that’s wrong in ways that aren’t obvious. Before building, make sure accounts are categorized consistently and classes (or locations) are applied the same way across transactions — the groupings only mean something if the data underneath is structured the same way every time.
- 3
Pick fields and grouping that match the question
Choose the columns that answer the question and the grouping dimension that frames it — revenue by class, profitability by customer, spend by location. Resist adding every available field; each extra column is a row of noise to read past. The right report shows the answer and its supporting detail, and stops there.
- 4
Filter deliberately and check the totals
Set filters — date range, class, customer, transaction type — so the report covers exactly the scope of the question, then sanity-check the totals against a number you already trust, like the standard P&L for the same period. If a custom report’s totals don’t tie to a known figure, the filtering or the underlying data is off, and the report can’t be trusted until that’s resolved.
- 5
Add a custom chart only when it clarifies
Add a custom chart when a visual genuinely makes the answer faster to read — a trend over time, a concentration, a comparison. Skip it when a clean table is clearer. A chart should reveal the answer, not decorate the report; if the chart and the table disagree at a glance, fix the report rather than picking the prettier picture.
- 6
Save it, schedule it, and review it on cadence
Save the report so it’s reusable, and schedule it to go to the people who act on it on a regular cadence. Then actually review it each period — a saved report quietly drifts out of usefulness as the business changes, classes get added, or the question evolves. A custom report is a living tool: build it once, but revisit it so it keeps answering a question that still matters.
What a revenue-by-class report must tie to.
An example: the owners want quarterly revenue by class, then by customer, emailed to the partners on the fifth of each month. Before the first copy goes out, the report is checked against records QuickBooks already produces.
| Check | What it must show |
|---|---|
| Report total | Equals Total Income on the standard Profit and Loss for the same dates and the same accounting method (cash or accrual). |
| Class subtotals | Each class matches its column on Profit and Loss by Class for the same period. |
| Unclassified income | The column for income with no class is zero, or every line in it is explained. Income missing a class is the usual reason the report and the Profit and Loss differ. |
| Filters | Every filter is written down with its reason. A filter that drops a transaction type, such as sales receipts, shows up as a gap against Total Income. |
| The scheduled copy | Re-tied each period after the books close, before the email goes out. |
A report that passes these checks can go to a lender or a board. One that fails them is a bookkeeping problem first, not a reporting one.
When a ProAdvisor should help.
A reporting need no standard report meets
When leadership keeps asking a question — profitability by segment, revenue by class and customer, a margin view the standard P&L doesn’t produce — and the canned reports can’t answer it, that’s the case the custom report builder exists for. Turning a fuzzy reporting need into a precise, reliable saved report takes judgment about fields, grouping, and filters, and it’s exactly what a ProAdvisor does well.
The data underneath needs fixing first
A custom report inherits whatever is true of the chart of accounts and class tracking beneath it. If accounts are inconsistent or classes are applied unevenly, the report will be confidently wrong — and a custom chart will publish that error on a schedule. Often the real work isn’t the report at all; it’s correcting the data structure first so the report can be trusted, which is a file review and a fixed-fee scope.
Reports that need to be shared and trusted
When a report is going to drive decisions — shared with partners, a lender, or a board, and scheduled to go out regularly — the cost of it being subtly wrong rises sharply. Building it so the totals tie to known figures, the groupings are sound, and the scheduled version stays accurate over time is where a ProAdvisor protects you from a report that looks authoritative and isn’t.
A QuickBooks ProAdvisor builds the report inside your own books.
Dragging fields into a report takes minutes; building a report that answers the right question and stays trustworthy is the real work. A QuickBooks ProAdvisor starts from the decision the report is meant to support, gets the chart of accounts and class tracking clean enough for the groupings to mean something, then builds the report — fields, grouping, filters, and custom charts — and saves and schedules it so the right people get it on cadence. Where the underlying data is the actual problem, we fix that first, because a custom report on bad data just publishes the errors on a schedule. All against a written scope, inside your own QuickBooks Online Advanced file.
What TechBrot does with custom reports, and what it does not.
- We do: turn a reporting question into a saved report, fix the chart of accounts and class tracking it groups on, and run the tie-out above, inside your own QuickBooks Online Advanced file. If we keep the books afterward, they are prepared by a senior bookkeeper who works in your software, or by a signed specialist practice when your books need one, with every close reviewed by a Certified QuickBooks ProAdvisor before it reaches you.
- We do not: change your Intuit plan, billing, or login, or fix a fault in the report builder itself. TechBrot is not Intuit and is not Intuit’s support, and we do not quote Intuit’s prices.
- Where this fits: how we set up and run the whole file is on the QuickBooks Online page, and what the top plan adds is on the QuickBooks Online Advanced overview.
What people ask about the QuickBooks Online Advanced custom report builder.
What is the QuickBooks Online Advanced custom report builder?
It’s a reporting feature in QuickBooks Online Advanced — the top QBO tier — that lets you build reports beyond the standard set. You start from your data and pick the fields (columns) you want, group rows into meaningful subtotals, filter to the records that matter, and visualize the result with custom charts. You can then save the report and schedule it to be shared. It answers a reporting question no pre-built report covers.
Do I need QuickBooks Online Advanced to use the custom report builder?
Yes. The custom report builder and custom charts are features of QuickBooks Online Advanced, the top QuickBooks Online subscription tier; the lower plans don’t include them. We don’t quote Advanced pricing here because Intuit sets and changes it — confirm the current price and tier with Intuit directly. As an independent firm we can’t change your subscription, since that’s an Intuit account matter.
How is the custom report builder different from customizing a standard report?
A standard report is a pre-built template — Profit & Loss, Balance Sheet, A/R Aging — that you adjust at the edges. The custom report builder starts from your data instead, so you assemble exactly the columns, groupings, and filters the question needs and visualize it with custom charts. Use a standard report when one answers your question; use the builder when none does, which is the situation the Advanced feature is for.
How many columns can I group a custom report by?
Three. Intuit’s help article on the custom report builder says “You can select up to 3 columns” under Groups, then Group by (read October 15, 2026). A common three-level layout is class, then customer, then product or service. Each level only means something if that field is filled in consistently on every transaction, so check the unclassified line before you trust the subtotals.
Why does my custom report show the wrong numbers?
Usually because of the data underneath, not the builder. A custom report groups and totals on your chart of accounts and class tracking, so if accounts are categorized inconsistently or classes are applied unevenly, the report will be wrong in ways that aren’t obvious. Sanity-check the totals against a figure you trust, like the standard P&L for the same period; if they don’t tie, the filtering or the underlying data needs fixing before the report can be trusted.
Can custom charts replace my regular financial statements?
No. Custom charts visualize a report you’ve built; they don’t replace the standard financial statements or a reconciliation. A chart is only as accurate as the report and the data behind it, and it’s a presentation layer, not a control. Use custom charts to make a trustworthy report easier to read — not as a substitute for the reconciled books and statements that prove the numbers are true in the first place.
Can you build custom reports in my QuickBooks Online Advanced file?
Yes — that’s operational work we do inside your own books: turning a reporting need into a reliable saved report, picking the right fields, grouping, and filters, adding custom charts where they clarify, and scheduling it to the right people. We start with a free file review, then a focused build is one fixed fee, scoped in writing, or a bookkeeping cleanup ($1,200–$15,000+) if the chart of accounts and classes need correcting first. An Intuit account or subscription issue stays with Intuit.
What if my chart of accounts is a mess — can I still build a useful report?
Not a trustworthy one, until the structure is fixed. The custom report builder reports on exactly what’s there; it won’t clean up a disorganized chart of accounts or inconsistent class tracking for you — it just renders the mess faster. In practice the right order is to correct the underlying structure first, then build the report on top of it. Often that data fix is the real engagement, and the report is the easy part once the books are sound.