1. Accounting
  2. Statistical Accounting
  3. Using Statistical Accounts
  4. Creating Statistical Accounts

Creating Statistical Accounts

A statistical account is a general ledger account that appears in your chart of accounts but does not impact your general ledger. This type of account enables you to track non-monetary data and then use that information about reports and income statements. You can then examine its relationship with the financial activity of your organization. For example, you may create a statistical account that tracks the rent fee for the square feet of occupied office space for each location in your organization.

A statistical account is always debit positive, and is always excluded from foreign currency translation.

You create a statistical account the same way you create other accounts. Currency-specific fields do not display when you create a statistical account because they are irrelevant for non-monetary accounts. Instead, you assign a default unit of measure type, and a default unit within that type. For example, you may define the Unit of Measure Type, AREA that includes the unit of measure, square feet (SQFT). You could also define a Unit of Measure Type, Currency that includes the unit of measure, USD.

Note:

If you use NetSuite OneWorld, you can assign statistical accounts to multiple subsidiaries. The statistical account balances of those subsidiaries are combined, and the exchange rate of the currency is always equal to one.

For more information about creating accounts, see Creating Accounts.

To create a new statistical account:

  1. Go to Setup > Accounting > Manage G/L > Chart of Accounts > New.

  2. If you are using account numbering, enter an account number.

    For information about enabling the preference to use account numbering, see Chart of Account Numbering.

  3. Enter a name for this statistical account.

    For example, you may create a statistical account that tracks rent fee for occupied office space and name the account Location by Square Feet.

  4. In the Type field, select Statistical.

    This name appears in the chart of accounts, statistical account register, and on reports.

  5. Select the type of unit to associate with this statistical account.

    The base unit assigned to the unit type displays in the Default Unit field.

    To create a new Unit Type, select –New- from the list, or click Screenshot of the New icon New to open the Unit Type window.

    For more information, see Creating a Unit Type for a Statistical Account.

    After you assign a unit type to a statistical account and save the record, the assigned unit type cannot be changed.

  6. Enter a description of the statistical account.

  7. The Date field indicates the date on which this statistical account can be used in statistical journal entries.

    It defaults to the current date, but you can modify the date as required.

  8. Check the Inactive box to deactivate this statistical account.

  9. If the Departments feature is enabled and you want to restrict the use of this statistical account to a single department, select the department.

  10. If the Classes feature is enabled and you want to restrict the use of this statistical account to a single class, select the class.

  11. If the Locations feature is enabled and you want to restrict the use of this statistical account to a single location, select the location.

    To enable Departments, Classes, and Locations, go to Setup > Company > Enable Features. These features appear on the Company subtab under Classifications. For more information, see Enabling Features.

    Important:

    After you select a class, department, location, or a combination of these, this account can be selected only on transactions where that class, department, and location are also selected.

  12. If you use NetSuite OneWorld and you want to limit the use of this statistical account to a subset of subsidiaries, select one or more subsidiaries.

    Important:

    If you intend to create dynamic allocation schedules based on a statistical account, the segments you define in the statistical account are the only segments that can be used in the allocation schedule. For example, if you want to allocate cost by subsidiary and department, the statistical account must also be segmented by subsidiary and department.

  13. Check the Include Children box to make the statistical account available to all of the child subsidiaries of selected subsidiaries.

  14. Click Save.

    The saved statistical account appears.

Related Topics:

General Notices