The Spectrum: General Ledger dataset provides a source of general ledger information including contract status and summary trial balance information. You can use this data source to create a Work-in-Process (WIP) schedule. It includes Contract Billings To Date, Cost To Date, Earned Revenue To Date, Over/Under Billed to Date, Percent Complete, Projected Cost To Date, Provision for Loss and Revised Contract To Date, as well as Actuals, Budget, and Year-To-Date amounts.

This dataset is intended for the Controller and other accountants with financial reporting duties.

Actuals & Budget

Actuals

The sum of accounting transactions for the selected fiscal period.

Actual Year To Date

The beginning balance of the year plus the sum of accounting transactions year-to-date.

Budget

The sum of estimated transactions for the selected fiscal period.

Budget Year To Date

The sum of estimated transactions year-to-date.

Company

Company Code

This code represents the Spectrum Company or Spectrum Group of Entities.

GL Code

A user-defined numerical account code that is used to keep track of the entity's financial transactions. This version of the GL code is specific to the company and cannot be used to group across multiple companies.

GL Code Description

Defines the parameters of the GL Code.

GL Code Short Description

This is a simple identifier for the GL Code.

Fiscal Date

Month

Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.

Period

Includes all dates from the start of the month through the end of the month.

Quarter

This is the fiscal year and quarter.

Year

Based on the Company's fiscal calendar, this is the fiscal year.

General Ledger

Account Type

Indicates whether a transaction is an Asset, Liability, Capital, Income, or Expense.

Cost Center

This code represents the cost center, profit center, or other way of grouping of the organization.

Cost Center Description

The description for the specific cost center.

Cost Groups

This code represents the cost center, profit center, or other way of grouping of the organization.

Direct Cost

Indicates whether the cost is a Non-direct cost, Job cost, Equipment costs, or Work order cost.

Multi-Comp GL Code

A user-defined numerical account code that is used to keep track of financial transactions of the entity. This version of the GL code is independent of the company and can be used to group across companies, and identify general ledger accounts for multiple companies.

Multi-Comp GL Code Description

Defines the parameters of the Multi-Comp GL Code.

Multi-Comp GL Code Short Description

This is a simple identifier for the Multi-Comp GL Code.

Status

Indicates whether the account code is Active, Inactive, or Not used.