--- title: "Bulk set reporting permissions" slug: "bulk-set-reporting-permissions" updated: 2026-10-15T01:18:36Z published: 2026-10-15T01:18:36Z canonical: "help.servicetitan.com/bulk-set-reporting-permissions" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # Bulk set reporting permissions ## Overview You can bulk set reporting permissions for your team in a spreadsheet and import the file back into ServiceTitan, making managing reporting permissions for a large team quick and efficient. --- ### #### Who uses this feature - Administrators ## ## Things to know - Reporting permissions are managed separately from [office employee permissions](/construction/docs/explanation-of-office-employee-permissions-in-servicetitan). - To access built-in reports—reports included with ServiceTitan—you need reporting permissions enabled for: - The custom report template the report is based on - The reporting category of the report - To view a custom report, you must also have [sharing access](/construction/docs/create-custom-reports#add-sharing-settings) to that custom report. Access to a custom report is managed by the report’s creator. - You can also [set reporting permissions](/construction/docs/set-reporting-permissions) by individual or company role. ## Export reporting permissions You can export your team’s reporting permissions to an XLSX file for bulk editing. To export your reporting permissions: 1. Go to the navigation bar and click **Settings** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-gnav-settings-inactive.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D) . 2. From the side menu, go to **Tools** > **Import / Export Data**. 3. Click the **Export** tab. 4. Click the **Export Type** dropdown and select **User Permissions**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-bkd6knhz.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D) 5. Click **Export**. An XLSX file of your team’s permissions downloads to your computer. ## Edit reporting template permissions You can allow access to reports by custom report template. For example, if you only want certain office employees to view and run timesheets reports, you can control access to the Timesheets report template. All reports based on the Timesheets template can only be viewed and edited by those with this permission enabled. To set access to reports based on custom report templates: 1. Open the exported XLSX permissions file in a spreadsheet application. 2. Click the **Reporting Templates** tab. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-jjv5p1e0.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D)The sheet displays your office employees, their company role, and which view and edit report permissions are enabled as indicated by an **X**. 1. *View* permissions allow employees to view and run reports based on that report template. 2. *Edit* permissions allow employees to create, edit, view, and run reports based on that report template. 3. Set view and edit permissions for report templates for individual employees: 1. Enter an **X** for a report template to enable a permission. 2. Delete an **X** for a report template to disable a permission. 4. When you’re done, save the spreadsheet as an XLSX file and [import the file into ServiceTitan](/construction/docs/bulk-set-reporting-permissions#import-reporting-permissions). ## Edit reporting category permissions You can allow access to reports by report category. When you go to **Reports** > **All Reports**, reports are organized by category. You can control access to certain categories to protect sensitive data. To set access to reports based on reporting category: 1. Open the exported XLSX permissions file in a spreadsheet application. 2. Click the **Reporting Categories** tab. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-cb9mcej0.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D)The sheet displays your office employees, their company role, and which view and edit report permissions are enabled as indicated by an **X**. 1. *View* permissions allow employees to view and run reports within that category. 2. *Edit* permissions allow employees to create, edit, view, and run reports within that category. 3. Set view and edit permissions for report categories for individual employees: 1. Enter an **X** for a category to enable a permission. 2. Delete an **X** for a category to disable a permission. 4. When you’re done, save the spreadsheet as an XLSX file and [import the file into ServiceTitan](/construction/docs/bulk-set-reporting-permissions#import-reporting-permissions). ## Edit business unit reporting permissions > **Note:** Account configuration is required to use this feature. Please contact [Technical Support](/construction/docs/contact-servicetitan-technical-support) for details. You can control access so only office employees with the proper permissions can report on specific business units (BUs). If they don’t have permissions enabled for a BU, their reports won’t include data for that BU. For more on BUs, see [Add and edit business units](/construction/docs/add-and-edit-business-units-3). To set reporting permissions for BUs: 1. Open the exported XLSX permissions file in a spreadsheet application. 2. Click the **Reporting Business Units** tab. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-i2v04vn4.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D)The sheet displays your office employees, their company role, and which BU permissions are enabled as indicated by an **X**. 3. Set view and permissions for BUs for individual employees: 1. Enter an **X** for a BU to enable a permission. 2. Delete an **X** for a BU to disable a permission. 4. When you’re done, save the spreadsheet as an XLSX file and [import the file into ServiceTitan](/construction/docs/bulk-set-reporting-permissions#import-reporting-permissions). ## Import reporting permissions When you’re done editing your exported report permissions spreadsheet, save it as an XLSX file. To import your reporting permissions: 1. Go to the navigation bar and click **Settings** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-gnav-settings-inactive.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D) . 2. From the side panel, go to **Tools** > **Import / Export Data**. The *Import* tab opens. 3. Click the **Data File Type** dropdown and select **User Permissions**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-96xfr4e8.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D) 4. Click **Upload**. 5. Select the XSLX file you want to upload. 6. After the file uploads, click **Import**. A notification displays indicating that the file uploaded successfully. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/bulk-set-reporting-permissions-image-039m4p94.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A42%3A05Z&se=2026-10-31T01%3A42%3A05Z&sr=c&sp=r&sig=Wmr%2Ft1mEYwLa5yGK5fU%2Ftg9xHQjHmfRzS7ltnNhlVyg%3D) ## Want to learn more? - Visit ServiceTitan Academy and enroll in [Navigating Reports](https://servicetitan.docebosaas.com/academy/learn/courses/377/navigating-reports) - See [Create custom reports](/construction/docs/create-custom-reports) - See [Edit custom reports](/construction/docs/edit-custom-reports)