Statistics Codes
Statistics codes are values that you use to identify non-monetary amounts; for example, full-time equivalent (FTE) workdays, shipment size, or generic units. To add or modify statistics codes, use the Statistics Code page.
You also use statistics codes to track statistical amounts on the same journal line as the corresponding monetary amount entry. For example, the journal line that records an individual department's rent expense can include the dollar amount of the rent charged as well as the amount of floor space that is used to determine the charge.
For example, if you enter these accounting entries on the Bill Line Distribution pages:
| Bill Line Distrib. Page | Acct | Dept | Prod | Proj |
|---|---|---|---|---|
|
AR Offset |
120000 |
<no value> |
<no value> |
<no value> |
|
Revenue Dist. |
400000 |
<no value> |
<no value> |
<no value> |
| Affiliate | Stat Code | Monetary Amt | Stat Amt | UOM Derived |
|---|---|---|---|---|
|
<no value> |
Fl Space |
50000 |
700 |
SQF |
|
<no value> |
|
50000 |
<no value> |
<no value> |
then the Load GL process and Journal Generator generate these accounting entries and journal entries when passing this information to the general ledger system:
| Acct | Dept | Prod | Proj |
|---|---|---|---|
|
120000 |
<no value> |
<no value> |
<no value> |
|
400000 |
<no value> |
<no value> |
<no value> |
| Affiliate | Stat Code | Monetary Amt | Stat Amt |
|---|---|---|---|
|
<no value> |
Fl Space |
50000 |
700 |
|
<no value> |
<no value> |
50000 |
<no value> |
These resulting journal lines include both the monetary and statistical amounts.
Associating Statistic Codes with UOMs at the Distribution Level
All statistics codes are associated with a specific unit of measure (UOM), a value that quantifies the statistical amount. The UOM that is associated with a statistics code or a statistical account may differ from the UOM that is associated with a charge code on the bill line. Statistical information can be a different type of information from the charge code information that is carried in the bill line distribution pages. For example:
| Charge Code | Unit of Measure That Is Associated With Charge Code | Correlated Statistical Data | Unit of Measure That Is Associated With Statistical Data |
|---|---|---|---|
|
Rent |
SQF |
Floor Space |
SQF |
|
Parking Fee |
EA |
Parking Space |
EA |
|
Consulting Service |
HOUR |
Head Count |
FTE |
In this example, the UOMs that are associated with the charge code and with the statistical data are the same for rental charges and parking fee. For consulting services, however, the charge code is billed by hours, whereas the statistical data that is tracked is the head count for the consulting staff and is measured by FTE.
Because the UOMs that are associated with statistical information and with the charge code can be different, QTY (quantity) and statistical amount can also be different. However, there are situations in which these would be the same. For example, if the UOM that is associated with a charge code is SQF, and the UOM that is associated with the statistical data is SQF, QTY and statistical amount are identical.
In some scenarios, there may be a correlation between a charge code and a statistics code. However, a statistics code can represent an aspect of the data that is different from that which the charge code represents, primarily from a general ledger, budgeting, and financial reporting perspective. The example reflects this difference: The charge code is consulting service, and the statistics code is head count.
Related Topics