RetrieverRetriever
ProductTemplatesSecurityPricingStart HereGuides
Try for free
Guides
/

QuickBooks Modern Reports Renamed Your Total Rows and Broke Your Lookups

QuickBooks Modern Reports Renamed Your Total Rows and Broke Your Lookups

The problem

On the classic balance sheet the row read "Total Assets." On the modern balance sheet it reads "Total of Assets." Nothing about the figure changed. But a workbook that finds that row with VLOOKUP, XLOOKUP, INDEX and MATCH, FIND, or QUERY is matching on the exact text, so the moment the wording changed the formulas started returning errors. The same break was reported for data arriving through Spreadsheet Sync, which carries the report's own labels through to the sheet.

Why QuickBooks can't do it

An export is a grid of text. The label is the only handle it gives you, so every model built on top of an export identifies rows by what they say. There is no stable row identifier underneath, and no mapping layer to absorb a wording change, which is why a cosmetic edit on Intuit's side lands as a broken file on yours. The request to put the old wording back was filed on Intuit's public feedback board in October 2026 and is Under Review.

Do it in Google Sheets with Retriever

The durable fix is to stop keying formulas to label text. Retriever keeps track of which row is which itself, so the label becomes something you control rather than something that controls you.

  1. Pull the balance sheet in rather than exporting it

    Rows arrive in position and Retriever tracks each one across refreshes, so a refresh writes each value back into the row it belongs to instead of rebuilding the grid from scratch.

  2. Rename the labels to the wording your template expects

    Change "Total of Assets" back to "Total Assets," or "Revenue" to "Turnover," and the next refresh still places the right value in that row. Retriever matches on the row, not on what the row says.

  3. Point your model at the row, not at the string

    Reference the cell directly, or anchor a lookup to the account number rather than the label. A reference survives a wording change because it never depended on the wording.

  4. Let account renames in QuickBooks move the row for you

    When an account is renamed in QuickBooks, Retriever updates the name in the sheet and moves the whole row to its new position in QuickBooks order on the next refresh. Formulas that reference the row move with it.

See also

How to run a Balance Sheet reportChanges to your chart of accounts: renaming and re-ordering rowsHow Retriever decides which rows and columns to refreshShow, sort and filter reports by account numberQuickBooks Balance Sheet template for Google Sheets

A report that survives Intuit changing its mind

Retriever tracks rows and columns rather than label text, so you can name a row whatever your model expects and the numbers still land where they belong.

See how Retriever works

Frequently asked questions

Why did "Total Assets" become "Total of Assets"?

Intuit changed the wording of the total rows when the balance sheet moved to modern reports. The figures are unchanged. Accountants asked for the previous wording on Intuit's public feedback board in October 2026.

Can I just edit the label back in my export?

You can, and it fixes that one file. Next month's export arrives with the new wording again, so it becomes a step in your close checklist rather than a fix.

Will renaming a row in Google Sheets break the refresh?

No. Retriever tracks the row itself, so a renamed row label still receives the correct value. What it does not track is the movement of individual cells or cell ranges, so cutting and pasting a block of cells is the thing to avoid.

Can I re-order the report to suit my template?

Yes, and the order holds. On a Profit and Loss, Balance Sheet, Cash Flow, or Budget, select entire rows and drag them where you want them. On a list-style report the Sheets Sort feature works too, as long as entire rows are selected. The one movement Retriever does not follow is a sorted or cut-and-pasted cell range, because it tracks rows and columns rather than individual cells.

What else breaks when a label changes?

Anything that matches on text: lookup formulas, named ranges defined by label, QUERY statements, and any chart or dashboard fed by one of those.

Questions about this? Reach out at aubrey@retrieverhq.com.