Steps to Set Up Scheduled Reports in Quickbooks Online in 2024

How to Set Up Automated Reports in QuickBooks Online in 2024

Before clients can schedule a report, they need to save it with a distinctive name so that it appears under the Custom tab in the Reports menu.  

Let’s see how to do that with a monthly comparative Profit and Loss report and then schedule it. 

 To save the report under the Custom tab: 

1.     Select Reports from the left-hand navigation and select the Profit and Loss report

2.     At the top of the report, adjust the settings of the report as needed. In our case, we’re changing the Report period to last month, and in the Compare another period dropdown, we check the Previous period option

3.     Next, select Run report 

4.     At the top of the report, select Save customization 

Remember, only reports saved as Custom reports can be set up as scheduled reports.

5.     Enter a Custom report name. In our case, we call it Monthly Comparative Profit and Loss

Note that clients can add this report to a group or create a new one. They can also select Share with if they want to share it with other users.

6.     Next, select Save 

The customized report is now ready for scheduling. 

To do this: 

1.     Select Back to report list to return to the main Reports menu

2.     Select the Custom reports tab

As you can see, our customized report now appears here.

3.     To the right of the report, select Edit

4.     Set the Set email schedule slider to on

5.     Adjust the details in the Set Recurrence section. In our case, we set the Repeats to Monthly, and we select the 10th day of the month

Note that if you don’t want the report to run indefinitely, you can either define the number of times that the report will run, or set an end date. 

6.     Next, enter the recipients’ email addresses and adjust the content of the email in the Email information section

By default, QuickBooks Online sends the report in PDF format. To send it as an Excel file, check the box at the bottom.

7.     Finally, select Save, or Save and close 

That’s it.  

 

How to Automate Your Accounting with Scheduled Reporting in Ask My Accountant

Even in the event that the client is responsible for managing their own financial records and relies on Ask My Accountant to record uncertain transactions, the implementation of scheduled reporting can be beneficial. In what way? By configuring a specific report for the Ask My Accountant account, specifying the reporting timeframe as encompassing All Dates.

 

Then you can set up a schedule to send this report daily, weekly, monthly, or twice a month.

 

If you send this report as an Excel spreadsheet, you’ll be able to make comments on where and why the transactions should be reclassified.