QuickBooks Reports Still Show the Old Number After You Fix a Transaction
The problem
The workflow is the same everywhere: spot something wrong on a report, drill into the transaction, correct it, go back to the report, confirm the fix. Firms report that last step failing. The report keeps showing the figure from before the edit, with nothing on screen to say it is out of date, until it is manually re-run. It shows up during reconciliations, cleanup and reclassification work, month-end review, and adjusting entries, which are exactly the moments you are trusting the report to tell you whether you are done.
Why QuickBooks can't do it
Automatic refresh after a drilled-down transaction changes was described as part of the modern reports experience as far back as October 2025, and firms running over a hundred company files report it working inconsistently across them. Separately, journal entries have been reported taking several minutes to appear on a Profit and Loss while an account detail report for the same account already shows them. Both threads sit on Intuit's public feedback board. The common thread is not that a report can be stale. It is that the report does not say when it was read.
Do it in Google Sheets with Retriever
A report pulled into a spreadsheet carries its own timestamp, and refreshing it is something you do rather than something you hope happened.
- Pull the report into Google Sheets
Each report writes a header block above the data: the company, the report, the date range, the accounting method, and the time it was last updated. The question of whether a figure is current stops being a guess.
- Refresh on demand after you fix something
The Manage tab lists every Retriever report in the spreadsheet with a refresh button on each. Correct the transaction in QuickBooks, refresh, and the figure moves.
- Put the workbook on a schedule
Auto-refresh runs hourly, daily, weekly, or monthly, set per spreadsheet from the Configure tab. Pick the cadence the work actually needs rather than refreshing everything constantly.
- Drill down from the sheet when a figure looks wrong
Select a cell with a monetary value and drill down to the transactions behind it, so you can check the detail without leaving the workbook you are reviewing in.
See also
Know when your numbers were pulled
Retriever stamps every report with the time it was last updated and refreshes on demand or on a schedule, so a stale figure announces itself instead of hiding.
See how Retriever worksFrequently asked questions
Why do my QuickBooks reports show old data after an edit?
Modern reports are meant to refresh after a drilled-down transaction is changed, and accountants report the behavior as inconsistent between company files. The native workaround is to re-run the report, which only helps if you knew it was stale.
How do I tell whether a figure is current?
In a Retriever report the header block carries a Last updated timestamp above the data, so the age of the numbers is visible to everyone who opens the file.
How often does a scheduled refresh run?
Hourly, daily, weekly, or monthly, chosen per spreadsheet in the Configure tab. Existing sheets on auto-refresh run daily by default; change it to Every 1 hour if the work needs it.
Does a spreadsheet keep refreshing forever?
No. Auto-refresh pauses on a spreadsheet whose Retriever extension has not been opened in 90 days. You get an email when a sheet enters hibernation and can wake it back up.
Does a scheduled refresh solve staleness?
It narrows it, and the timestamp closes the rest. A report pulled at nine this morning is still a report from nine this morning. The difference is that it says so, and refreshing it is one click rather than a re-run you have to remember.
Questions about this? Reach out at aubrey@retrieverhq.com.