Using “Where Used”

Where Used is a forward audit trail, identifying the accounts that depend on other accounts. You select accounts and calculate all scenarios, and Where Used tracks the accounts using the selected accounts.

  To use Where Used to identify account dependencies:

  1. From the Accounts spreadsheet, select Accounts then Where Used.

  2. Optional: To list only financial accounts in Available Accounts, select Show Accounts Only.

    If this option is not selected, informational accounts such as Company Name and Default Currency are listed.

  3. In Available Accounts, select an account and click >>.

  4. Optional: to limit the calculation to only the scenario currently selected in the model, select Calculate Current Scenario Only.

  5. Click Run.

  6. In Where Used, view dependent accounts.

  7. Optional: To store the results as a .txt file, click Save.