# Managing Included And Excluded Accounts

### Abstract <a href="#id-7leub68u75wo" id="id-7leub68u75wo"></a>

Administrators configuring *Accrual Automation* in *NetSuite* need precise control over which accounts  appear in the *Accruals Worksheet*. This configuration ensures the worksheet reflects only relevant financial data for more streamlined and accurate accrual calculations. For example, a business might only want to remove accounts like **Office Expenses** from being part of the accrual logic.

This article provides step-by-step instructions for managing included and excluded accounts in the Accrual Automation feature. It explains how to control Accrual Automation account types and how to exclude specific *GL accounts* from the accrual process by referencing their internal IDs.

### Configuring Additional GL Account Types for Accrual Automation <a href="#cfpwam12pt27" id="cfpwam12pt27"></a>

Accrual automation, by default, considers expense-type accounts when generating accrual entries. In many cases, organizations need to account for *Cost of Goods Sold* (COGS), *Other Expenses*, or other *GL* account types to reflect the full scope of their financial activities. By specifying these additional account types, you can extend your accrual process to capture all relevant transactions.

Follow these steps to configure the **GL Account Types**:<br>

1. Begin by accessing the **Charted Platform Features,** then click the **Settings** button on the **Accrual Automation** section:<br>

   <figure><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FB8bWmQiY5K1R5HqQUQIa%2Fimage.png?alt=media&#x26;token=e5a11b84-ab80-4eb6-864d-1a7421c66f6c" alt=""><figcaption></figcaption></figure>

   It will open a new screen for the **Accrual Automation Settings:**\ <br>

   <div align="left"><figure><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FPGLqNbwX8LiwBnKueGbl%2Fimage.png?alt=media&#x26;token=72236c47-c764-4767-b2a0-3397109b53a0" alt=""><figcaption></figcaption></figure></div>

2. To add to the default list of expense accounts, look for the included **GL Accounts Types** under the **Advanced Settings** page:\ <br>

   ![
   ](https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FPacauo5w2j0IyQBJiKBz%2F2.png?alt=media\&token=2b501813-2078-4153-83c3-98cf63d67321)

   <br>

3. If your organization’s accrual process relies on additional account types, select each applicable type (e.g., **Cost of Goods Sold**, **Other Expense**) from the provided options:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FCAPuMC1ksdAOdtDi2qwd%2F3.png?alt=media&#x26;token=5e8bc2ce-2b1c-405a-b35c-160147d6f5bc" alt="
   " width="450"></div>

   <br>

4. After choosing the **GL Account Types**, click the **Submit** button to confirm your changes:

   <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FaVJCVR9Q0HZtaORd6vgc%2F4.png?alt=media&#x26;token=c9ec1b24-85f8-4669-8080-ff459e5e545c" alt="
   "></div>

   \
   \
   **Note:** Since you’ve included these account types, remember that your **Accrual Worksheet** data will now reflect them in real-time the next time you run the process:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FaZfWjyMDq342CLJewjiZ%2F5.png?alt=media&#x26;token=7e838800-018e-4f89-8f85-9d653c7e67f6" alt="
   "></div>

   <br>

5. Now, to check the added **GL Account Types**, locate the **Chart of Accounts** by going to the **Setup** menu, hovering over **Accounting**, and selecting **Chart of Accounts:**<br>

   <div align="left"><figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXe0f4kpV7phBpWdh4NXFvC759ioQ4iCn6vlZiD0_M9-Z2sxmVeAe-AMba26_Zf7pBVbfjBvEp18a8aC9FnJ4Nt2jF2319yPxgknF_NBTJ3_t1B69QwH7IJx_J6VONQW8g?key=WLLZvAdyJ39JJX1OVGOMh_Vq" alt=""><figcaption><p><br></p></figcaption></figure></div>

6. Next, it will open the screen for the **Chart of Accounts** with the **GL Account Types** shown under the **Type** column:\ <br>

   <div align="left"><figure><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FQV2KjXnBOBaruCpp7MCH%2F7.png?alt=media&#x26;token=afb84db2-b2b0-461c-a10b-81bf49eea8af" alt=""><figcaption><p><br></p></figcaption></figure></div>

   \
   \
   Simply scroll up and down to locate your added **GL Account Types (**&#x65;.g., **Cost of Goods Sold**):\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FrpX7W9GYDTr2nvNZ7rDR%2F8.png?alt=media&#x26;token=1b85e20f-40a5-4824-9bf5-3115ebf8a60c" alt="
   "></div>

   <br>

### Excluding Specific GL Accounts <a href="#id-3w9wn76mbm6n" id="id-3w9wn76mbm6n"></a>

The Accrual Automation feature also allows administrators to exclude specific GL accounts from being included in the accrual logic. This is useful when certain accounts — such as Office Expenses — should not be part of the accrual process. This can be configured using the **Exclude GL Accounts IDs** field, which accepts a comma-separated list of internal IDs associated with the accounts to be excluded.

Follow the steps below to exclude GL accounts from the accrual calculation:<br>

1. To begin the process, go back to the **Account Automation Settings** section and click the **Settings** button in front of the **Accrual Automation** module:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FQETVGl3Oda2hGOmpHD81%2F7.png?alt=media&#x26;token=aacdc8ad-bf89-47a8-beba-51cde35d7b34" alt="
   "></div>

   <br>
2. Once inside the settings, scroll to the **Advanced Settings** section. If you need to exclude one or more accounts, locate the field labeled **Exclude GL Accounts IDs**:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2F26ZhVJ30DSIOJV8NA5sg%2F8.png?alt=media&#x26;token=f87ea850-bc86-444b-b0f5-b220074b7f05" alt="
   "></div>

   <br>
3. To correctly fill out this field, you will need to know the internal IDs of the accounts you want to exclude. To retrieve these IDs, go to the **Setup** menu, hover over **Accounting**, and click the **Chart of Accounts** tab:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FqRmxA0y2LozK0XXWixV9%2F9.png?alt=media&#x26;token=4afdd928-a60e-4222-8441-38ea13daa400" alt="
   " width="563"></div>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2F1ZBHuTVD2D4v67Mbt8bK%2F10.png?alt=media&#x26;token=d8465991-4cae-4384-9aad-62e222246106" alt="
   "></div>

   <br>
4. Because the internal ID column is not shown by default, you will need to enable it. Click the **Home** icon and then navigate to the **Set Preferences** tab:\ <br>

   <div align="left"><figure><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2F9pCTCmPvrBzV53FBEaZk%2Fimage.png?alt=media&#x26;token=b04766c9-5e89-479b-9559-bf7a5aa761d6" alt=""><figcaption></figcaption></figure></div>

   <br>
5. In the **Defaults** section, check the box labeled **SHOW INTERNAL IDS** and then click the **Save** button to apply the preference:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2F3Mo0yHARSEOAKImsCTs1%2F12.png?alt=media&#x26;token=f8e31a7d-c8ed-41b1-9a7f-e8b3f6a97af0" alt="
   "></div>

   <br>
6. After saving, return to the **Chart of Accounts** page and refresh your page. You should now see a column labeled **Internal ID**, which will show the values you need:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FwMwedPu5brRdbXQwnMFI%2F13.png?alt=media&#x26;token=4e1a5947-7cfd-46c7-b019-7b51fe3ff134" alt="
   "></div>

   <br>
7. For example, if you want to exclude the **Dues & Subscriptions** and **Equipment Rental** accounts, note their internal IDs, such as **67** and **68**:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2FOTMRyYNppMFhhozgB3x2%2F14.png?alt=media&#x26;token=f30f6aca-1502-4587-b5c0-0712998f01fa" alt="
   "></div>

   <br>
8. To complete the exclusion, enter these IDs as a comma-separated list (e.g., **67, 68**) into the **Exclude GL Accounts IDs** field in the **Advanced Settings** section. Once the IDs are entered, click the **Submit** button to save the changes and apply the exclusion:\ <br>

   <div align="left"><img src="https://4244775538-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDi74GwuQpTYzdGbZQFpz%2Fuploads%2Fup6XhJrNClEn6UlxZCYJ%2F15.png?alt=media&#x26;token=af2575cd-a34f-465d-9582-6a15538602d8" alt="
   "></div>

   \
   \
   This concludes the process of managing included and excluded accounts in *Netsuite*.
