Standard sheets are used for numerous tasks, including data entry, report-building, and information tracking.
Creating a New Standard Sheet
Use the standard sheet builder to create a new standard sheet. When you create a new standard sheet, you specify accounts, dimensions, display options, and sheet availability.
To create a new standard sheet:
- Navigate to: Modeling > Model Management.
- Choose one of the following options.
- Level Assigned Sheets: Create a level-assigned sheet.
- User Assigned Sheets: Create a user-assigned sheet.
- Click New Sheet.
- Enter a Sheet name. The sheet name must be unique for your installation.
- Select Create a new sheet > Standard, then click Next.
Define Accounts Groups
Use Accounts for Sheet to specify which accounts appear on the sheet. Account groups are only visible on the sheet where they are created, and are a quick way to bring accounts together from different parts of your account tree. First you create an account group, then you add accounts to the group.
To add a new account group:
- Click New Group.
- In Group Details:
- In the Heading field, give the group a name.
- To show the group's heading (name) on the sheet, select Display heading.
- To include a subtotal of the group's accounts to appear on the sheet, select Display subtotal.
- Click Save.
To add accounts to the group:
- Select a group.
- In the Select Accounts area, select the accounts to add to the group. You can:
- Choose accounts by Type.
- Navigate the accounts tree to pick an account.
- Search for accounts by name or number.
Adding an account rollup to a group automatically brings all child accounts onto the sheet as well.
3. Click Add to Group.
Once accounts are added to groups, you can make specific accounts read-only for the sheet, meaning they cannot be edited on any levels for the sheet.
To make an account read-only:
- Select an account in Accounts for Sheet.
- In Account Details, select Read Only.
- Click Save.
When you have finished creating account groups and adding accounts to the sheet, click Next.
You can assign dimensions to the sheet. Dimensions provide custom filters to help categorize and analyze plan data. You can use dimensions to view data or include it in formulas in multiple ways. Dimensions you add are available as columns on the sheet next to the columns for time. A standard sheet is not required to have dimensions.
To add a dimension to the sheet:
- Select a dimension in Available Dimensions.
- Click the right arrow >> add the dimension to Selected Dimensions for the sheet.
- When you've finished adding dimensions, you can use Move Up, Move Down to set the order the dimensions appear in the sheet.
When you have finished adding dimensions to the sheet, click Next.
Specify Display Options
Choose the state in which the sheet loads when it is first opened. Choices include:
- Start in view by level mode: The sheet appears with the company's organization structure on the Y axis and time on the X axis (View by Level). Leave it unchecked to have the sheet appear with the selected account groups for the sheet on the Y axis (View by Account).
- Suppress rows if zero or blank: Automatically hides any row with zeros or blank values.
When you have finished adding display options for the sheet, click Next.
Specify Sheet Availability
Specify which levels in your organization structure have access to the sheet. Users with access to the selected levels have access to the sheet. A parent level is automatically selected if one of its sub-levels is selected.
If you are creating a user-assigned sheet, you specify which users have access to the sheet, then you specify which levels are present on the sheet.
Navigate through the organization structure and select the levels to include:
- The screen first appears with only the topmost levels of the organization structure displayed.
- To specify access in a more granular way, click Customize Sub-Levels. This opens the Customize Sheet for Sub-Levels which includes the Accounts you selected for the sheet (on the left) and organization Levels you selected (on the right).
- The table shows whether users with access to a given level can:
- Edit the various accounts on the sheet (Editable)/
- Read, but not edit the accounts (Read Only),
- Not see the accounts (Hidden)
A few rules:
- If an account is hidden from a parent level, then none of the child levels can see the account.
- If an account was marked Read Only (on the Select Accounts page of the sheet builder), it cannot be made Editable here, only Hidden or Read Only.
When you have finished selecting levels, click Create Sheet. A summary appears with links to the sheet settings: Account Groups, Dimensions, Display Options, and Level Availability.
To manage sheets:
- Navigate to Modeling > Model Management > Sheets.
- Choose Level Assigned Sheets or User Assigned Sheets, depending on the type of sheets you want to manage.
- Make changes as desired:
- You can Edit, Delete, or Rename the sheet. When you edit the sheet to can adjust any of the settings you used to create the sheet, including Account Groups, Dimensions, Display Options, and Availability.
- Use the Move up/down arrows to change the position of the sheet in the list.