You will need the Reporting permission to schedule reports for yourself. To send them to other people you will also need Limited Report Scheduler, and to manage other users' schedules, Full Report Scheduler.
You can have One Church Software run a saved query or a built-in report on a schedule and email the results to you, to people you add individually, or to the members of a group. The report is attached to the email automatically.
Schedule a report
To schedule a query, save it in the Query Builder first. Then go to Reporting > Scheduler in the left-hand navigation menu and click Add New to select the saved query or built-in report, or edit an existing schedule.
Choose how often it runs (for example weekly, bi-weekly or monthly) and customize the email content. Recipients do not need system access, and their own permissions are never checked against what the report contains, so you can share results with people who cannot run the report themselves.
Tip: Reports built with the AI Assistant can be scheduled too. Choose the query data source that matches the report, then pick the AI report from the Query list; it shows a sparkle icon. A scheduled AI report is always sent as a CSV file, and running it never uses AI messages. If the AI report is later flagged Needs attention, the schedule pauses until the report is fixed and saved again. See How do I save and use an AI report?
Who the report runs as
A scheduled report runs as its report owner, with the access that person has on the day it runs. Your campus selector never applies to a scheduled run. For security, the report owner is set to the person who creates or last edits the schedule.
Reporting - schedule reports for yourself only. You cannot add other recipients.
Limited Report Scheduler - change the recipient list on your own schedules. Only the owner sets recipients.
Full Report Scheduler - view, edit, delete and take ownership of other users' schedules. You must take ownership before you can edit the recipients. Without this permission, the list shows only your own schedules.
Each recipient must be someone the owner can see, both when the schedule is saved and on every run. A recipient the owner can no longer see is skipped, and the email says so. If your account has more than one organization and the owner can see none of the recipients, nobody is emailed. When that owner has a campus or organization limit, the schedule is blocked and the owner is told once.
Giving queries need an organization
Once your church has more than one organization and giving is split by organization, a query that reads giving reads one organization at a time:
A Contributions query has an Organization field at the top of Display.
A People query with a giving column or filter asks for the organization the first time it runs, then shows the field.
The organization is saved with the query. Without one, a schedule or link that uses the query is refused, and a list that uses the query as an audience reads every organization. To fix a blocked schedule, open the query, choose an organization, and save it. Anything run from the query's results, such as bulk changes, messages, giving statements, labels, mail merge and library reports, keeps that organization.
A saved AI report that reads gifts or pledges without an Organization column is refused for schedules too. How do I save and use an AI report? explains how to fix it.
When a schedule is blocked
A schedule stops running, and its owner receives one email, when:
The owner can no longer run the report.
A giving or accounting report's organization is no longer one the owner can reach.
A group stored on the schedule is hidden from the owner.
A query excludes an organization outside the owner's access.
An AI report fails, or adds two organizations' giving together.
A record the report uses, or its source query, is deleted.
Giving is split by organization and a query that reads giving has no organization chosen.
To clear it, fix the cause, for example by choosing an organization on the query or restoring the owner's access.
Note: Some changes do not block a schedule. If the owner's campus access shrinks, or an organization named in an is in list filter drops out of their reach, the report still runs with fewer rows and nobody is told.
When nothing is sent
An empty query, library report or AI report sends nothing, and nobody is told. If a schedule seems to have stopped, check whether the report currently has any rows before assuming it has failed.
A scheduled accounting report is the exception. It always sends its file, even when the file is empty.
What the email looks like
The email body includes a Campuses line, and the attachment's name carries the campuses the report covers.
If your account has more than one organization, the email carries the name, phone and logo of the organization the report reads: a giving or accounting report's organization, or the query's saved organization. Without one, it uses your account's details. The sender address does not change.
Scheduled AI reports are always sent as a CSV file.
Other automatic emails follow the organization that owns the record, and use the default organization when a record has two owners or none. To-do reminders, for example, go out under the organization of the person they are assigned to. What is an organization? explains organizations.
Built-in reports you can schedule
Statement of Financial Position
Statement of Activities
Budget to Actual
Trial Balance
Transaction List
General Ledger
Expenses by Vendor Summary
Event Attendance
Group Attendance
Lapsed Attendance
Batch Summary
Contribution Range Report
Designation Detail Listing
Lapsed Donors
Facilities Daily Breakdown
Facilities Usage Summary
Missing Facility Requests
Combined Contributions
Connection Report
Envelope Numbers
Family Listing
People Directory
Person Notes
Once giving or the books are split by organization, giving and accounting reports read one organization, and a schedule runs on the organization saved with it. How do books work with more than one organization? explains how split books work.


