QuickBooks Online ships with more than 80 built-in reports — and yet the report you actually need is somehow never one of them. Maybe you want revenue by customer but only for unpaid work, or expenses by vendor but just for one category since January. This guide walks through building that report yourself with QuickBooks' customization tools, where the limits are, and a faster path when you just need the answer.

Step 1: Start from the closest built-in report

Custom reports in QuickBooks Online aren't built from a blank page — you always start from an existing report and bend it toward what you need. So the first job is picking the right starting point:

  • Money coming in → start from Invoice List, Open Invoices, or Sales by Customer Detail
  • Money going out → start from Expenses by Vendor Detail or Transaction Detail by Account
  • The big picture → start from Profit and Loss and drill in

Find them under Reports in the left menu, then use the search box at the top of the Reports page.

Step 2: Open the customization panel

With the report open, click Customize(top right). Depending on your QuickBooks version you'll see either the classic customization drawer or the newer side panel — the options are the same idea:

  • General — report period (this month, last quarter, custom dates), accounting method (cash vs accrual)
  • Rows/Columns — which columns show, and what the rows group by (customer, vendor, account, month…)
  • Filter — narrow to specific customers, vendors, products, transaction types, or amounts
  • Header/Footer — titles and labels for a client-ready look

The three customizations people actually need

Filter by status: in Invoice List-type reports, set the A/R Paid filter to "Unpaid" to see only open invoices. Group by month:in Rows/Columns, change "Display columns by" to Months to turn a flat list into a trend. Amount thresholds:use the Filter section's Amount condition to hide the noise below a cutoff.

Step 3: Save it so you never rebuild it

Click Save customization (top of the report). Give it a clear name, optionally share it with your team, and it appears from then on under Reports → Custom reports. You can also set a schedule to email it — though only on the schedule QuickBooks offers, in the format QuickBooks chooses.

If your saved reports stopped working, you are not imagining it

Intuit retired the Classic View report engine and moved everyone to the modern view. If you built and saved reports under the old view, this is why they look different or no longer behave the way you set them up.

The reaction from working bookkeepers has been blunt. On r/QuickBooks, in a thread that drew dozens of replies, the person who raised it put the cost plainly:

"I'm going to have to rebuild every single report I use and figure out how to get those data fields I currently use into the new reports. That's going to take me a lot of time; time spent where the end result is roughly I'm in the same place as when I started. In other words, wasted time."

A commenter defending the change still conceded the part that stings most: "the most flexible reporting is only in the top level subscriptions." That matches what the customization panel actually lets you do. The deeper filtering and the extra columns show up on the more expensive plans, and on Simple Start or Essentials you will hit a wall the panel never warns you about.

What to do if you are rebuilding

  • Write down the columns and filters first, from a screenshot of the old report if you still have one. Rebuilding from memory is where the mistakes happen.
  • Rebuild the two or three reports you actually send to clients, not all thirty. Most saved reports were run once and never opened again.
  • Use a named period, not fixed dates, so the rebuilt report keeps working next month.
  • Check the accounting method on the rebuild. It does not always carry across, and cash versus accrual will change every figure on the page.

Where the report builder hits its limits

The limits below are the ones that send people to a spreadsheet, and they are the same ones raised repeatedly in the QuickBooks community:

  • Cross-report questions don't work."Compare marketing spend to revenue by month" needs two reports and a spreadsheet.
  • Some fields can't be combined.The columns you want aren't always available on the report you started from — and you can't switch starting points without rebuilding.
  • It's slow to iterate.Every "hmm, what about only overdue ones?" means another trip through the Customize panel.
  • Most people export to Excel anyway— and then the report is frozen the moment it's downloaded.

The faster way: ask in plain English

If the report you need is really just a question — "who owes us the most money?", "what did we spend on fuel since January?" — you can skip the builder entirely. AskLedger connects to QuickBooks Online (read-only, official connection) and turns plain English into the exact table, with a "Showing:" line that tells you precisely how your question was understood. Ask, refine, save it, and have it emailed to you monthly.

FAQ

Can I build a report from scratch in QuickBooks Online?

Not truly from scratch — you always start from a built-in report and customize it. Fully free-form reporting needs an export or a third-party tool.

Are custom reports available on every QuickBooks plan?

Customization exists on all plans, but the deeper options (like certain column/filter combinations and some scheduling features) are richer on Plus and Advanced.

Can I schedule a custom report to email automatically?

Yes — save the customization, then use "Set email schedule". If you want the schedule tied to a plain-English question instead of a built report, that's what AskLedger' monthly saved reports do.