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.

Where the report builder hits its limits

Honest limits we hear from bookkeepers every week:

  • 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.