Skip to main content

How do I schedule an accounting report?

Set up a built-in accounting report, such as the Statement of Activities, to run automatically and be emailed as a CSV file to you, your treasurer or your finance team.

You will need the Reporting permission to schedule a report, and the Full Read Accounting permission to run accounting reports. To email the report to other people, you will also need Limited Report Scheduler.

You can have One Church Software run any of the built-in accounting reports on a schedule and email it to you, your treasurer or your finance committee. For example, you could send a Statement of Activities for last month on the first Monday of every month. The report is attached to the email as a CSV file.

These accounting reports can be scheduled:


Choose the report

  1. Go to Reporting > Scheduler in the left-hand menu and click + Add New.

  2. On the General tab, enter a Name for the schedule. A Description is optional.

  3. Set Data Source to Built In Report.

  4. Choose the accounting report from the Report list. A short description of the report appears below it.

  5. Choose a Date Range, such as Last Month, This Quarter or Fiscal Year To Date.

  6. Set the report's options, such as Accounting Method, Funds and Include draft entries? These are the same options you see under additional options when you run the report, and they change depending on the report you choose.

The Add Report Schedule General tab with Built In Report and Statement of Activities selected

The Format is always CSV for accounting reports. Report User shows the person the report runs as, which is you when you create or edit the schedule.

Choose when it runs

  1. Under When should report run?, choose the Date and Time(s) of the first run. Click + to add another time.

  2. Under Recurrence, choose how often it repeats: Daily, Weekly, Monthly on a weekday (for example, the 3rd Friday), Monthly on a date, Annually, or Custom... for anything else.

Choose who receives it

  1. Click the Email + Recipients tab.

  2. Under Recipients, start typing a name to add a person. To send the report to everyone in a group, click Person and switch the search mode to Group.

  3. Change the email Subject and Body if you like. The report is attached automatically.

  4. Click Save.

Tip: Recipients do not need a login or accounting permissions to receive the report. This makes scheduling a handy way to keep a finance committee informed.

Edit, run or delete a schedule

The Report Scheduler list shows each schedule's report, who it runs as, the number of recipients, how often it runs and the next run. Click the ... menu next to a schedule to Edit it, Run now or Delete it.

To learn who a scheduled report runs as, how recipients are checked, and what happens when a schedule is blocked, see How can I schedule query builder results and built in reports be emailed?

Other Helpful Articles

Did this answer your question?