Statistical Ledger Entry

The Statistical Ledger Entry screen allows you to enter or adjust quantities in the statistical ledger. This does not update the project or subsidiary ledgers. Examples where a statistical ledger entry can be used include:

  • Listing various Statistical accounts and values from the statistical ledger. An example might be showing number of employees along with the voluntary / involuntary employee terminations to report on employee turnover.

  • Combining statistical data with financial information to create key metrics. An example would be adding a metric for Revenue per employee or Personnel cost per employee to the Income Statement.

  • Used to create formulas or act as variables in calculations for General Ledger Allocations.

Because values are not posted to the project or subsidiary ledgers, it is not necessary to enter project or subsidiary information. Some statistical ledger entries may need to be reversed in a future posting period and the Reverse Entry options allows you to define when the entry should be reversed.

General

In the General area, enter general information about the statistical ledger entry.

  Field Description
Posting Period

Enter or select the posting period. The posting period must allow this document type as an input and must be in an Open, Pending Close, or Adjustment stage.

  Suffix

Enter or select any active input document suffix that is available for the current document type. This can be used in reports to select or sort documents.

Document Number

Enter a unique document number to identify this document.
This field automatically prepopulates and be read-only if an auto-counter has been defined for this type of document.

Document Date

Enter or select the document date. The default is the current date.

  Description Enter text to further describe the nature of the transaction beyond the typical posting data. When the statistical ledger records are created, this description is used as the financial description for each line item unless overridden in the Line Items area.
  Reverse Entry

Select if the entry needs to be reversed on a future posting date. If this item is selected, this process creates a new Statistical Ledger document by copying the current document and negating the quantity; and posts appropriately to the statistical ledger detail.

  Reversal Posting Period

Enter or select the posting period when the general ledger entry should be reversed. This field is enabled and required when the Reverse Entry checkbox is selected.

The reversal posting period must allow general ledger entries as an input, must be in an Open or Pending Close stage, and be greater than the selected posting period for the original general ledger entry.

Line Items

In the Line Items area, enter the detail lines. Each line item contains a quantity to post to the statistical ledger.

  Field Description
Sequence Displays the automatically generated sequence number that identifies the transaction.
Company

Enter or select the company. The default is the Source Company.

Only the Source Company or active companies that are in an established intercompany relationship with the Source Company can be selected.

Account

Enter or select the account. Only active accounts that belong to the line item's Company and match the following criteria can be selected:

  • Accounts with an Asset account type and the subsidiary type set to Cash, Intercompany Receivable, Intercompany Work In Progress, Other Receivable, Project Receivable, Tax, or Work in Progress.
  • Accounts with an Asset or Expense account type, the subsidiary type set to None, and the posting type set to Non-Project.
  • Accounts with a Liability account type and the subsidiary type set to None, Accounts Payable, Intercompany Payable, or Tax.
  • Accounts with a Revenue or an Equity account type.
Organization Enter or select the organization. Only active organizations that belong to the line item's Company can be selected.
EVC Type Select if the general ledger entry is for an Employee, Vendor, or Client.
  Employee / Vendor / Client Enter or select the active employee , vendor, or client associated with the general ledger entry. The selection in EVC Type defines if employees, vendors, or clients are available in this field.
Quantity Enter the number of units for the line item.
  Measure Enter or select a unit of measure to apply to any quantity entered for the unit. This is used on reports and in billing to describe the value of the units.
  Description

Enter text to further describe the nature of the transaction beyond the typical posting data. When the statistical ledger records are created, this description is used as the financial description.

Note: BST11 creates a line that shows the total of the Quantity column at the bottom of the Line Items grid.