You saved a report last quarter. You open it today and the figures have not moved. Nothing is broken, and your data is fine. The report is doing exactly what you told it to, which is the frustrating part.

The cause: a fixed date range instead of a moving one

When you build a report, the Report period dropdown offers two kinds of option, and they look almost identical in the saved report.

  • Fixed dates, such as 1 April to 30 June. These never move. The report will show that quarter forever.
  • Relative periods, such as This Month-to-date, Last Month, or This Fiscal Year-to-date. These recalculate every time the report is opened.

If you picked dates from the calendar, even once, the report froze at that moment. Most people do this without noticing, because choosing exact dates feels more precise.

The fix

  1. Open the report.
  2. Open the Report period dropdown.
  3. Pick a named period such as Last Month rather than typing dates.
  4. Click Save customization and overwrite the existing saved report.

Open it next month and the numbers will have moved. That is the whole fix, and it is the single most common cause of this complaint.

Two other reasons a report looks stuck

The accounting method is not what you think

Cash and accrual produce different figures from identical books. On a cash-basis report, an invoice you raised last week does not appear until it is paid. The report is not stale, it is answering a different question. Check the Accounting method setting under Customize.

You are looking at a saved copy, not the live report

Reports under Custom reports are saved settings, not saved results, so they should refresh. A PDF or spreadsheet someone emailed you is a snapshot and will never change. It is worth confirming which one is open before hunting for a bug.

Better: stop opening it at all

If you are logging in monthly to run the same report, QuickBooks can send it to you instead. This is a genuinely good feature and it is underused.

  1. Go to Reports, then the Custom reports tab.
  2. Find your saved report and open the Edit action on its row.
  3. Turn on Set email schedule.
  4. Choose how often, pick the day, and add recipients.
  5. Decide whether to attach the report as a spreadsheet as well as putting it in the email body.
  6. Save.

Make sure the report uses a relative period first. Scheduling a report with fixed dates just emails you the same frozen figures on a timetable, which is worse than not scheduling it, because now it looks maintained.

What the built-in scheduling will not do

  • It sends one saved report per schedule. A client pack of four reports means four emails.
  • It sends QuickBooks formatting and QuickBooks branding. If you are forwarding it to a client under your own firm's name, you will still be reformatting.
  • It cannot send a report QuickBooks cannot build, which is where most of this frustration actually starts.

Where this leaves you

For a standard report on a moving date range, the built-in schedule is the right answer and you should use it. Fix the period, set the schedule, and stop logging in to press the same button.

Where it stops working is when the thing you want is not one of the standard reports. That is the case for revenue against costs per client, and it is why so many monthly packs still end in a spreadsheet.

AskLedger takes the same idea a step further: ask a question once in plain English, save it, and it re-runs itself every month and arrives in your inbox as a clean summary. Because the question is a sentence rather than a saved filter set, there is no date range to freeze by accident.

In short

  • A report that never changes almost always has fixed dates. Swap to a named period such as Last Month and re-save.
  • Check the accounting method before assuming the figures are wrong.
  • Use Set email schedule so the report comes to you.
  • Fix the date range before scheduling, or you will automate a frozen report.

Related reading: building custom reports in QuickBooks Online.