Statistical Account Feature

 

New for NetSuite release 2014.1 is the ability to create a statistical account, allowing you to track non-monetary amounts. Statistical account values can be used in reporting, and also to perform allocations based on weighted values. Some examples of data you might use Statistical Accounts to track include:

Enable Statistical Account Feature

Tip Image 1

Click image to enlarge

Statistical Account Setup

Tip Image 2

Click image to enlarge

Statistical type account is similar to any balance sheet account which will report latest ending balances automatically as well as track current and prior period balances. Once a new Statistical Account has been created, add information to this account by creating a Statistical Account Journal Entry to capture non-monetary data.

Statistical Account Journal Entry

Go to Transaction Tab > Financial > Make Statistical Journal Entry

Tip Image 3

Click image to enlarge

Including Statistical Information within a Report

Now that there is data associated with a statistical account we can incorporate this information into our reports. Below is an example and steps to include headcount and a calculation to produce an Income Statement with Revenue by Headcount

Tip Image 3

Click image to enlarge

Tip Image 3

Click image to enlarge

Tip Image 3

Click image to enlarge

Tip Image 3

Click image to enlarge

Note