Allocation Schedule For Allocation Using Multi Step Expense Allocation

User wants to allocate Expenses (Expense Account) to all Departments based on their headcounts, allocating further, the expenses allocated to Department X.

1. Create Units of Measure for the Statistical Account
• Navigate to Lists > Accounting > Units of Measure > New
• Enter Values for the following fields
• Name
• Plural Name
• Abbreviation
• Plural Abbreviation
• Conversation Rate
• Base Unit
• Click Save
  Note: For detailed instructions see article Setting Up Units of Measure.
2. Create Statistical Account to identify Headcount for all Departments
• Navigate to Lists > Accounting > Accounts > New
• Enter values for following fields
• Account Number
• Account Name
• Type: Select Statistical
• Click Save
  Note: For detailed instructions see article Creating Statistical Accounts.
3. Create another Statistical Account to identify headcount per Location of Department X using same steps as above
4. Create Saved Search to be the basis of the statistical Journal
• Navigate to Reports > Saved Searches > All Saved Searches > New
• Click Employee
• Search Title: Enter Title
• Criteria:
• Inactive: Select False
• Department: Select is not - unassigned -
• Location: Select is not - unassigned -
• Results:
• Internal ID:
• Summary Type: Select Count
• Department:
• Summary Type: Select Group
• Click Save
5. Create a Saved Search for specific department
• Navigate to Reports > Saved Searches > All Saved Searches > New
• Click Employee
• Search Title: Enter Title
• Criteria:
• Inactive: Select False
• Department: Select is Department X
• Location: Select is not – unassigned –
• Results:
• Internal ID:
• Summary Type: Select  Count
• Department:
•  Summary Type: Select Group
• Location: 
• Summary Type: Select Group
6. Create Statistical Schedules for all Departments
• Navigate to Transactions > Financial > Create Statistical Schedule
• Name: Enter Name
• Statistical Account: Select Account created for all Departments
• Saved Search: Select Saved search for all Departments
• Frequency: Select preferred frequency
• Click Save
7. Create Statistical Schedule for Department X
• Navigate to Transactions > Financial > Create Statistical Schedule
• Name: Enter Name
• Statistical Account: Select Account created for Department X
• Saved Search: Select Saved Search for Department X
• Frequency: Select preferred frequency
• Click Save
  Note: For detailed instructions see article Creating a Statistical Schedule to Run a Saved Search.
8. Create Statistical Journals from Statistical Schedules
   Note: This process posts the current headcounts based from the results of the Saved Searches already created
• Navigate to Transactions > Financial > Create Statistical Schedule > List
• Click View on both Statistical Schedules that are created from the previous step
• On both Statistical Schedule Records, click Create Journal Entry buttons
• When the process is successfully completed, Statistical journals are created based on the results of the Saved Searches already created.
  Note: Even though it is a Journal, it does not create any entries that affect the Balance Sheet or Income Statement accounts. In case there is an update to the headcount then all that has to be done is go back to the Statistical Schedule Record and click on Create Journal Entry button again and NetSuite will automatically compute for the changes in headcount. For detailed instructions see article Making Statistical Journal Entries.
9. Create Allocation Schedule For All Departments
• Navigate to Transactions > Financial > Create Allocation Schedules
• Name: Enter Name
• Frequency: Select Run by Batch
• Source:
• Account: Select Expense account
• Leave everything else blank
• Destination: 
• Use Source/ Credit Accounts: Mark Checkbox
• Location: Select Auto Populate
• Allocation Mode: Select Dynamic Allocation
  Note: A new section named Dynamic Allocation appears.
• Weight Source: Select Statistical Account for All Departments
• Date Basis: Select As of Date
• Click Save
10. Create Allocation Schedule for Department X
• Navigate to Transactions > Financial > Create Allocation Schedules
• Name: Enter Name
• Frequency: Select Run by Batch
• Source:
• Account: Select Expense account
• Department: Select Department X
• Destination: 
• Use Source/ Credit Accounts: Mark Checkbox
• Location: Select Auto Populate
• Allocation Mode: Select Dynamic Allocation
• Weight Source: Select Statistical Account
• Date Basis: Select As of Date
• Click Save
  Note: For detailed instructions see article Creating Expense Allocation Schedules.
11. Create Allocation Batch to run the Allocation Schedules so they will create Journal Entries to allocate expenses
• Navigate to Transactions > Financial > Create Allocation Batches
• Batch Name: Enter Name
• Posting Date: Enter Date
• Allocation Schedule: Select Schedule already created
• Click Save
12. Allocation Batch: Click View
13. Click Execute button
14. Two Journal entries are created, one to allocate the Expense Account to all Departments according to headcount and another one to allocate the amount allocated to Department X according to its headcount per Location
    Note: For detailed instructions see article Creating an Allocation Batch.