Account

The Chart of Accounts table is used as the core source for loading the GL Account dimension; it maintains a list of all the GL accounts for the organization.  This information is typically derived from the natural account segment of your General Ledger and consists of all accounts that had a balance in the current and prior years.  

Accounts can be built with a specific set of hierarchies as described in this table; alternatively, the hierarchies can be built using the GL_Rollups structure.  Only one methodology can be used for building the hierarchies.

To specify the account hierarchy using the account dimension table, each account should include one or more rollups depending on the depth of the hierarchy.  Account_Rollup_1 represents the top level of the hierarchy; Account_Rollup_2 represents the next level, so on and so forth.  The hierarchy can go up to 10 levels deep. To illustrate, let’s consider the following example using a few payroll tax accounts.  In the diagram below, there are a number of detail payroll taxes that are part of the overall Net Income hierarchy.  The numbers represent the corresponding rollup number, with rollup 1 being the top level of the hierarchy.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Alternatively, the hierarchy can be created in the GL_Rollups tables by specifying ranges and the hierarchy for each range or set of accounts.  Refer to the GL_Rollups section for detailed information.

Idx Field Type Maximum Length Required

 

 

 

 

 

1

Account_Code

Alphanumeric

20

Yes

2 Account_Name Alphanumeric 100 Yes
3 Account_Class_Code Alphanumeric 100 Yes
4 Account_Rollup_1 Alphanumeric 100 No
5 Account_Rollup_2 Alphanumeric 100 No
6 Account_Rollup_3 Alphanumeric 100 No
7 Account_Rollup_4 Alphanumeric 100 No
8 Account_Rollup_5 Alphanumeric 100 No
9 Account_Rollup_6 Alphanumeric 100 No
10 Account_Rollup_7 Alphanumeric 100 No
11 Account_Rollup_8 Alphanumeric 100 No
12 Account_Rollup_9 Alphanumeric 100 No
13 Account_Rollup_10 Alphanumeric 100 No

 

 

Summary

Account

Chart of Accounts table used as the core source for loading the GL Account dimension; it maintains a list of all the GL accounts for the organization.

Columns

 

Account_Code

The uniquely identifying account code for this GL account. Required.

Account_Name

The description of the GL account. Required.

Account_Class_Code

Maps to GL_Class name to determine code to determine net change signage. Required.

Optional Rollup Structure

 

Rollup Columns

 

Account_Rollup_1

Top level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_2

Second level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_3

Third level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Account_Rollup_4

Fourth level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Account_Rollup_5

Fifth level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Account_Rollup_6

Sixth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_7

Seventh level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_8

Eighth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_9

Ninth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Account_Rollup_10

Tenth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Documentation

 

Sample CSV Load File

This load file is a small sample of an Account load.

 

Sample CSV Load File

This load file is a small sample of an Account load.

Filename: Account.csv

45000001,FICA,E,Net Income,Total Expenses,Total Operating Expenses,Total Compensation & Fringes,Fringe Benefits & Other Emoloyee Costs,Payroll Taxes,,,

45000002,SUTA,E,Net Income,Total Expenses,Total Operating Expenses,Total Compensation & Fringes,Fringe Benefits & Other Emoloyee Costs,Payroll Taxes,,,
45000006,FUTA,E,Net Income,Total Expenses,Total Operating Expenses,Total Compensation & Fringes,Fringe Benefits & Other Emoloyee Costs,Payroll Taxes,,,
45000007,Paris Social Charge,E,Net Income,Total Expenses,Total Operating Expenses,Total Compensation & Fringes,Fringe Benefits & Other Emoloyee Costs,Payroll Taxes,,,
45000099,Pay Tax Allocated to Client,E,Net Income,Total Expenses,Total Operating Expenses,Total Compensation & Fringes,Fringe Benefits & Other Emoloyee Costs,Payroll Taxes,,,

Columns

Account_Code

Account_Code varchar( 20 ) NOT NULL

The uniquely identifying account code for this GL account. Required.

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

Account_Name

Account_Name varchar( 100 ) NOT NULL

The description of the GL account. Required.

 

Field Load File Format
Type Alphanumeric
Maximum Length 100
Required Yes

Account_Class_Code

Account_Class_Code varchar( 100 ) NOT NULL

Maps to GL_Class name to determine code to determine net change signage. Required.

 

Field Load File Format
Type Alphanumeric
Maximum Length 100
Required Yes

Optional Rollup Structure

Rollup Columns

Account_Rollup_1

Account_Rollup_1 varchar( 100 ) NULL

Top level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Records may be grouped into multiple rollups each separated by a separate rollup column.  Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level one.

Account_Rollup_2

Account_Rollup_2 varchar( 100 ) NULL

Second level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level two.

Account_Rollup_3

Account_Rollup_3 varchar( 100 ) NULL

Third level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level three.

Account_Rollup_4

Account_Rollup_4 varchar( 100 ) NULL

Fourth level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level four.

Account_Rollup_5

Account_Rollup_5 varchar( 100 ) NULL

Fifth level hierarchy the account rolls into for aggregating the Chart of Accounts.   Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level five.

Account_Rollup_6

Account_Rollup_6 varchar( 100 ) NULL

Sixth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level six.

Account_Rollup_7

Account_Rollup_7 varchar( 100 ) NULL

Seventh level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level seven.

Account_Rollup_8

Account_Rollup_8 varchar( 100 ) NULL

Eighth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level eight.

Account_Rollup_9

Account_Rollup_9 varchar( 100 ) NULL

Ninth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level nine.

Account_Rollup_10

Account_Rollup_10 varchar( 100 ) NULL

Tenth level hierarchy the account rolls into for aggregating the Chart of Accounts. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level ten.

 

 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk