In NetSuite manually creating statistical journal entries is like manually creating general financial journals with the exception that you do not provide financial specific data. Instead, you are utilizing the unit of measures we previously set up to allocate fees such as monthly rent per department or shipping cost by items sold. When manually creating statistical journals, you are also given the opportunity to make an absolute balance for multiple statistical accounts at the same time.
This is useful for updating data that is not tracked periodically but instead overwriting a value at the time of journal creation. In this blog post we will review the process of manually creating a statistical journal to create an absolute balance to our statistical account we created in our last blog post, Creating Statistical Accounts and Unit Types.
Steps to create a statistical journal:
- Go to Transactions > Financial > Make Statistical Journal Entries.
- In the Primary Information section:
-
- In the Entry No. field, accept the default or enter a different number.
- In the Date field, accept today's date or enter a new date for the statistical journal entry.
- If you use fiscal accounting periods, select the period with which to associate this transaction.
- Leave the Reversal Date field blank unless you want to create a reversing entry at the same time.
- In the Memo field, enter information to help you identify this intercompany journal entry in a list of other intercompany journal entries.
-
- In the Statistical Information section:
-
- Select the Unit of Measure Type.
**Important to know that this value cannot be modified after you save the statistical journal. - Check the Absolute Update box to update the balance of one or more statistical accounts at the same time.
**The account balances you enter in the Amount field overwrite all previous values. If you check this box, you are prompted to confirm the action when you save the transaction.
- Select the Unit of Measure Type.
-
- In the Classification section:
-
- If you use NetSuite OneWorld, select a Subsidiary to associate with this statistical journal.
- If you have enabled Departments, Classes, or both on the Company subtab of the Enable Features page, select the appropriate classification to associate with this journal entry.
-
- On the Lines subtab, enter the detailed information for the statistical journal lines.
-
- In the Account field, select the statistical account to be affected by this statistical journal.
- In the Amount field, enter the value associated with the default Unit of Measure.
- Optionally, enter a memo to help you recognize this entry in the Statistical Register for this account.
- Optionally, select the name of a person, vendor, or company to associate with this entry.
- If you have enabled classifications on the Company subtab of the Enable Features page and you specify classifications at the line-level, select the appropriate department, class, and location to associate with this line.
- The Units field defaults to the unit type associated with this statistical account.
- Click Add.
- Repeat these steps for each line item.
-
- Click Save.
Now you have your statistical journal with absolute value. Next in this series we will review how to auto-create statistical journals from a saved search.
About Us
Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.
Read About Our Implementation Methodology
Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos