chartOfAccounts

11/20/2020 12:36:53 PM

Line Field Name Data Type Description
1 str:chartOfAccounts Table Chart of accounts information by general ledger account.
2 term:accountSubtype Term (Text/String) Grouping for lower-level categories on the financial statements. Examples include reserve account, suspense account, intercompany account, and so on.
3 term:accountType Term (Text/String) Grouping for high-level category on the financial statements. Values should be assets, liabilities, equity, revenue, expenses, and so on.
4 term:businessUnitCode Term (Text/String) Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited and for which the trial balance is generated. For example, you may use a code aligned with the concept of a reportable segment as defined in FASB Accounting Standards Codification (ASC) 280, Segment Reporting.
5 term:fsCaption Term (Text/String) Financial statement caption. Grouping for the caption the GL account rolls up to on the financial statements (for example, cash and cash equivalents, accounts payable, cost of sales, and so on). Sometimes may prefer to be at the trial balance level.
6 term:glAccountDescription Term (Text/String) Label or description associated with GL_Account_Number.
7 term:glAccountName Term (Text/String) Name for the GL account.
8 term:glAccountNumber Term (Text/String) Identifier for the GL financial quarterly periods. GL_Account_Number in this file must match the GL_Account_Number used in the Trial_Balance and Chart_Of_Accounts files.
9 term:parentglAccountNumber Term (Text/String) A reference to the GL_Account_Number that is the parent in an account hierarchy. Provided to allow more than the predefined levels of hierarchy in the chart of accounts table.
10 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
11 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
12 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
13 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
14 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.