Filter a Profit and Loss or Balance Sheet by Account Number in QuickBooks Online

The problem

Your chart of accounts encodes structure in the account number. Accounts starting 1-XXX are one reporting entity, 2-XXX are another, or one block is a division and another is a fund. In QuickBooks Desktop you could run a Balance Sheet restricted to a number range and get that entity on its own. In QuickBooks Online you cannot, so you either run the full statement and delete rows by hand every month, or you keep a Desktop file alive purely to produce these reports.

Why QuickBooks can't do it

QuickBooks Online treats the account number as a display field, not something the report filters on. Customize lets you filter by class, location, customer, and vendor, but there is no account number range filter on the Profit and Loss or Balance Sheet. This is an open request on Intuit's public feedback board, marked Planned as of September 2026, with accountants describing it as the last thing keeping them on Desktop.

Do it in Google Sheets with Retriever

Once the statement is in Google Sheets with account numbers attached, the number becomes ordinary data. Filtering on a prefix is then a formula, and it holds every month.

1. Pull the statement with account numbers included

   Use Retriever to bring the Profit and Loss or Balance Sheet into Google Sheets with the account number column present. It arrives as structured rows rather than a formatted export, so every account number is in its own cell.

2. Split the prefix into its own column

   Add a column that takes the leading block of the account number, for example the characters before the first dash. That column is the reporting entity, division, or fund the account belongs to.

3. Filter or group on the prefix

   Use a filter view, a QUERY, or a SUMIF against the prefix column to produce a statement for a single number range. One tab per entity, all reading from the same pulled data, is the layout most firms end up with.

4. Keep the subtotals correct

   Total from the filtered detail rows rather than reusing the totals QuickBooks calculated for the whole company, since those cover every account. Rebuilding the subtotals in the sheet is what makes each filtered statement stand on its own.

5. Refresh on a schedule

   New accounts appear in the pulled data automatically and fall into the right block by their number, so the split does not need rebuilding when the chart of accounts grows.

See also

Frequently asked questions