Understanding Statistical Data Tracking

PeopleSoft Billing maintains statistical data to facilitate financial analysis and reporting, or to form the basis for allocating certain expenses. Using statistics, you can track a variety of non-monetary amounts, including labor hours per product or workstations per department. Use direct labor hours, for example, to allocate overhead to products or to calculate a ratio of expense versus number of customers for a regional expense analysis.

PeopleSoft Billing supports statistical data tracking by:

  1. Capturing statistical data in statistical accounts using the Standard Billing - Acctg - Statistical Info page.

  2. Capturing statistical data in statistics codes using these pages:

    • Standard Billing - Acctg - AR Offset.

    • Standard Billing − Rev Distribution.

    • Standard Billing - Acctg - InterUnit Exp/Inv.

    • Standard Billing - Acctg - InterUnit Payables.

  3. Carrying statistical data in statistics codes at the bill header level.

  4. Passing statistical data to the Billing Accounting Entries table (BI_ACCT_ENTRY), the staging table for the information that the Load GL process (BILDGL01) eventually passes to the general ledger system.

    Use the account entry type translate value ST (statistical entry) to enter statistical data into the Billing Interface table, resulting in capturing data in statistical accounts. The system creates entries and displays them on the Standard Billing - Acctg - Statistical Info page after the Billing Interface creates the bill.

PeopleSoft tracks statistical information by:

  • Statistics codes.

  • Statistical accounts.