> ## Documentation Index
> Fetch the complete documentation index at: https://hc.saas-manager.biz.nuro.jp/llms.txt
> Use this file to discover all available pages before exploring further.
# 4. How to Use the Shadow IT Management Ledger
> Setup instructions and usage guide for the Shadow IT Management Ledger.
#### What you can do with the Shadow IT Management Ledger
The tool uses SaaS access history from event logs to identify SaaS services the IT department has not yet noticed.
You can then categorize those services into a whitelist or blacklist.
#### Shadow IT management workflow
Review the flow diagram below to understand how shadow IT is defined and handled when operating this tool.
#### Supported environments
* Google Sheets
Excel (Windows/Mac) is not currently supported.
Support for Microsoft Excel (Windows) is planned for a future release.
#### Prerequisites
* Event logs must already be collected (browser extension setup or equivalent is required).
Reference: [Shadow IT detection using browser extensions](/en/it-management/shadow-it/7q1wryx3dk-extension)
[Shadow IT detection using Google Workspace](/en/it-management/shadow-it/8nwq5urwh5-shadow-it)
[How to review event logs](/en/it-management/shadow-it/oepl0j5y5g-eventlog)
#### Setup instructions
#### Preparation
1. Go to **Settings** > **API Key List** to obtain your **Organization ID** and **API Key**.
2. Download the ledger using the link below.
\[Spreadsheet]
[Admina\_Shadow IT Management Ledger\_ver1.0](https://docs.google.com/spreadsheets/d/1jUKf9h6H9QVZSVNwnoWQTiKQaMvJ9_GHJrzc8eggrq4/copy)
A screen like the one shown below will appear. Save the file to your own environment to start using it.
3. \[Spreadsheet]
Open **Extensions** > **Apps Script**, then go to **Project Settings** > **Script Properties**.
Add properties named `APIToken` and `OrgId`, and enter the **API Key** and **Organization ID** you obtained in step 1.
\[Excel]
Open the Excel file and go to the **Setting** sheet. Enter the **Organization ID** obtained in step 1 into the `OrgID` field, and the **API Key** into the `APIToken` field.
#### How to use the Shadow IT Management Ledger
1. On the **HOME** sheet, enter the year and month you want to review (in `yyyy-mm` format).
Click **Fetch Data** to retrieve the data.
2. The event log for the entered month is generated as a sheet named `eventLog_yyyymm`.
The `eventLog` sheet updates on a per-sheet basis.
Event logs for months other than the one you entered are not updated,
so past months remain as historical records, one sheet per month.
Update the **List Type** using the **LinkedList**, **WhiteList**, and **BlackList** sheets.
The list of SaaS services already connected is also generated as the **LinkedList** sheet.
The `eventLog_yyyymm` and `LinkedList` sheets are generated using the Admina API.
\[/en/api-reference/it-management/introduction)
\[/en/api-reference/it-management/introduction)
A **Service Matrix** is also generated at the same time.
This table combines data from **WhiteList**, **BlackList**, **LinkedList**, and all `eventLog_yyyymm` sheets. It includes past months and shows which list each service belongs to.
3. Define your **WhiteList** and **BlackList** in accordance with your security policy.
4. To reflect new integrations or updates to the **WhiteList** and **BlackList**, click **Fetch Data** again on the **HOME** sheet.
The following items are overwritten:
* **LinkedList**
* `eventLog_yyyymm` (the existing sheet for the same month is overwritten; a new sheet is created if none exists)
* **Detection Total** and **Unprocessed** counts on the **HOME** sheet
* **Service Matrix**
This completes the guide on how to use the Shadow IT Management Ledger.
If you have any questions or need assistance, please contact our chat support.