QuickBooks HelpQuickBooksHelpIntuit

Set up and modify Scheduled Reports

by Intuit Updated 3 weeks ago

Scheduled Reports is a feature in QuickBooks Desktop 2018 and later versions that allows you to send reports on a regular and recurring scheduled time. If you’ve ever found yourself sending the same reports on a daily, weekly, monthly or quarterly basis, you can set up Scheduled Reports to automate this task. You can choose the time and frequency for sending out your scheduled reports. You can also send out multiple reports in one schedule.

In this article, you'll learn how to:

This article is part of a series that covers basic information about reports in QuickBooks Desktop.



Requirements for Scheduled Reports

QuickBooks can send out your scheduled reports, if at the time they're scheduled to send:

  • The computer you set up the scheduled report on is running and NOT in sleep or hibernate mode.
  • QuickBooks is running.
    • A company file with scheduled report should be open.
    • If you have scheduled reports on multiple company files, NO Company file should be opened.
  • QuickBooks is updated to the latest release.
    • The company file is in single-user mode.
    • An email account is setup up in QuickBooks. If the email preference is set to Outlook, make sure it's open and running.
  • You have the Keep QuickBooks running for quick startups preference disabled. Here's how to check this:
    1. Select the Edit menu, then select Preferences.
    2. From the left menu, select General, then choose My Preferences tab.
    3. Uncheck the box for 'Keep QuickBooks running for quick startup'. Note: This preference is NOT available for QuickBooks 2018 and later.

If you have multiple versions of QuickBooks Desktop installed (e.g., you have both QuickBooks Desktop Pro 2018 and QuickBooks Enterprise 18.0 installed), and the sub-menu for Scheduled Reports is greyed out, make sure to download the latest update.



Set up a new scheduled report

Before scheduling reports, ensure there's an email account set up and integrated with QuickBooks. If you haven't done so, Set up your email service in QuickBooks Desktop.

Follow these steps to create a new scheduled report:

  1. From the QuickBooks Reports menu, choose Scheduled Reports > Schedule Setup.
  2. Select the report you wish to send. You may select multiple reports to be sent in the same schedule. Once you have selected your reports, click Next.
    Important
    : You can only set up a schedule for memorized reports. If you don't see the report you wish to send, open that report and memorize it.scheduled report setup
  3. Set up report schedule.Set up scheduled for reports
    1. Give your new schedule a name.
    2. Set how often you want to send the report.
    3. Select a Start date and Time. Additionally, you may choose to have QuickBooks notify you 4 hours before it sends the reports.
    4. Click Next to proceed.
  4. Compose scheduled reports email.Compose scheduled report email
    1. Enter the e-mail address you want to send the report to. You can send to multiple e-mail addresses by using a semicolon to separate them.
    2. Before finalizing the set-up, you must assign a password for the report attachments. For security reasons, Do NOT enter the password in to the subject or body fields of the e-mail.
    3. Click Schedule to complete the process.
  5. Check if the preferences is set up correctly.
    1. Select the Edit menu, then select Preferences.
    2. From the left menu, select Integrated Apps, then choose Company Preferences tab.
    3. Put a check on Scheduled Reports, then select Properties.
    4. On the Access Rights tab make sure both permissions are selected.
    5. Select OK, then choose OK.


Edit or delete an existing scheduled report

Follow these steps to modify an existing scheduled report:

edit scheduled reports

  1. From the QuickBooks Reports menu, choose Scheduled Reports > Scheduled Report Centre.
  2. Select the Action dropdown, select either Edit Schedule or Delete.
  3. If you want to make a Scheduled Report inactive, remove the check mark in the Active box. This will retain the settings of a scheduled report but will prevent it from running until re-activated.


Scheduled Reports Centre

Once you create scheduled reports using the Setup Reports Schedule assistant, you can view, run, and edit them in the Scheduled Reports Centre.

  1. From the Reports, select Scheduled and then select Scheduled Reports Centre.
  2. Highlight any scheduled report and double-click it to open the Scheduled Report window where you can make changes. You may also select the Edit button in the lower right corner.
  3. Select the plus and minus icons to add or delete a schedule. You can also copy a schedule.


Will scheduled reports send even if I am working in the company file?

Yes. QuickBooks can send out your scheduled reports even if you are currently working on the file as long as it is not open in multi-user mode and no other company files are open.

Is there a way to turn off the password requirement for scheduled reports?

No. Currently there is no way to turn off the password requirements for scheduled reports.

Why are passwords required when setting up a scheduled report?

In order to protect your financial data, QuickBooks requires a password to be set on scheduled reports. We highly suggest that you DO NOT include the password for the report in the subject or body of the e-mail.

What format are reports sent out in?

Reports are sent out in .pdf format.

What will happen if my report fails to send?

QuickBooks will alert you if a report has failed to send and include a failure reason. Scheduled reports will fail to send if at the scheduled time:

  • The company file is open in multi-user mode.
  • There is another company file open.
  • The computer is turned off or is in hibernation/sleep mode.
  • Your e-mail preference is set to Outlook but Outlook is not open.
  • You have the preference enabled to Keep QuickBooks running for quick startups.

QuickBooks will continue to attempt to send failed reports every hour until successful.

Will Scheduled Reports work in hosted environments?

At this time the feature is NOT designed to work in hosted environments that have roaming profiles.

Will Scheduled Reports work in multi-user environments?

No. Scheduled Reports is designed to work in single user mode only. It will not work in Multi-User Setup, not in Citrix or hosted environments, including Right Networks.

Why are my options for Scheduled Report greyed out?

The Scheduled Reports options will be greyed out if you have multiple editions of QuickBooks Desktop installed and you are not on the latest release, make sure to download the latest update.

Are scheduled reports included in Accountant's Copy files?

Yes. scheduled reports are included in Accountant's Copy files. However, they will be disabled by default and will not send.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this