Auto-Generating Statistical Journal Entries

Statistical journal entries are used with statistical accounts to make single-sided transactions by class, department, and location. Statistical journals do not need to be in balance. They appear as a positive, debit amount. If you feel it is necessary, you can balance statistical journals against a statistical balancing dummy account.

NetSuite provides two methods through which you can enter statistical journals into your system. You can create a saved search run by a statistical schedule to autogenerate statistical journals, and you can manually make statistical journals. Both autogenerated and manual statistical journals can be maintained by the same methods. For more information, see Working with Statistical Journal Entries.

If you want the system to autogenerate statistical journals, you must first define a saved search to retrieve the type of data you want to collect. You must then assign that saved search to a statistical schedule to be run at specified intervals. If the saved search yields a positive or negative value from the value retrieved during the preceding run, a statistical journal is automatically generated. If there is no difference in values from one run to the subsequent run, the system does not create a statistical journal. For example, you defined a saved search to collect the number of employees per department for the headcount statistical account. Your statistical schedule runs your saved search one time per week. The first week, the employee headcount is 10. The second week the employee headcount is 13. Based on the delta between the two runs, the system generated a statistical journal with +3 amount for the headcount statistical account.

Note:

Your user role must have the Set Up Accounting permission to create a statistical schedule.

Related Topics