MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Reports > Statistical General Ledger

Statistical General Ledger

GL202


 

DATE    2/14/92                               ANDERSEN CONSULTING                                                         PAGE     1

TIME   15:42:09                               ANDERSEN CONSULTING    LOCATION                 DEMAND POST                 CO     009

REPORT GL202                                                                                                              LOC    001

                                  STATISTICAL GENERAL LEDGER POSTING FOR 02/14/92

BASE CURRENCY BEF BELGIAN FRANC

  ACCOUNT         ACCOUNT DESCRIPTION                             --  CURRENT ACTIVITY  --

   CENTER          CENTER DESCRIPTION       JOURNAL REF1  REF2    UM         QUANTITY        ACCOUNT BALANCE         DESCRIPTION

------------------------------------------- ------- ----- ----    --    ------------------  ------------------    ------------------

XRT        EXTRA EXPENSE ACCOUNT

                                                                                   365.00                 .00     BEGINNING BALANCE

                                                                                   365.00              365.00     ENDING BALANCE

CPM01      CPM01 ACCT

                                                                                  1254.00                 .00     BEGINNING BALANCE

                                                                                  1254.00             1254.00     ENDING BALANCE

CPM013     CPM01 ACCT 3

                                                                                                          .00     BEGINNING BALANCE

                                                                                      .00                 .00     ENDING BALANCE

0001       PLANT SURFACE

  W1         WAREHOUSE 1                                                                                  .00     BEGINNING BALANCE

                                             XRTREV               EA    99,999,999,999.99

                                                                        99,999,999,999.99   99,999,999,999.99     ENDING BALANCE

0001       PLANT SURFACE

  W2         WAREHOUSE 2                                                           236.25                 .00     BEGINNING BALANCE

                                                                                   236.25              236.25     ENDING BALANCE

0001       PLANT SURFACE

  W3         WAREHOUSE 3                                                                                  .00     BEGINNING BALANCE

Statistical General Ledger - Control Totals (GL202)

 

DATE    2/14/92                               ANDERSEN CONSULTING                                                         PAGE     8

TIME   15:42:09                               ANDERSEN CONSULTING    LOCATION                 DEMAND POST                 CO     009

REPORT GL202                                                                                                              LOC    001

                                  STATISTICAL GENERAL LEDGER POSTING FOR 02/14/92

                                                      STATISTICAL LOCATION TOTALS

                                                                         QUANTITY

                                                                   --------------------

                                               BEGINNING BALANCE

                                                 BALANCE SHEET                     .00

                                                 INCOME STATEMENT                  .00

                                               TRANSACTION AMOUNTS

                                                 PREVIOUS POSTED                   .00

                                                 CURRENT POSTED               2,109.98

                                               ENDING BALANCE

                                                 BALANCE SHEET                2,109.98

                                                 INCOME STATEMENT                  .00

                                               MISMATCH SUSPENSE                   .00

                                               MISMATCHES                            0

                                               NO OF GL ACCOUNTS                    60

                                                VALID TRANSACTION CONTROL FILE TOTALS

                         BEGINNING BALANCE                POSTED ACTIVITY                 ENDING BALANCE

                   ------------------------------  ------------------------------ -------------------------------

            PERIOD   TRANS         QUANTITY          TRANS         QUANTITY         TRANS         QUANTITY

            ------ --------- --------------------  --------- -------------------- --------- ---------------------

               1         6              2,109.98         6              2,109.98        0                    .00

               2         1     99,999,999,999.99-        0                   .00        1      99,999,999,999.99-

               3         0                   .00         0                   .00        0                    .00

               4         0                   .00         0                   .00        0                    .00

               5         0                   .00         0                   .00        0                    .00

               6         0                   .00         0                   .00        0                    .00

               7         0                   .00         0                   .00        0                    .00

               8         0                   .00         0                   .00        0                    .00

               9         0                   .00         0                   .00        0                    .00

              10         0                   .00         0                   .00        0                    .00

              11         0                   .00         0                   .00        0                    .00

              12         0                   .00         0                   .00        0                    .00


 

                                             CUMULATIVE TRANSACTION CONTROL FILE TOTALS

                         BEGINNING BALANCE                POSTED ACTIVITY                 ENDING BALANCE

                   ------------------------------  ------------------------------ -------------------------------

            PERIOD   TRANS         QUANTITY          TRANS         QUANTITY         TRANS         QUANTITY

            ------ --------- --------------------  --------- -------------------- --------- ---------------------

               1         0                   .00         6              2,109.98        6               2,109.98

               2         0                   .00         0                   .00        0                    .00

               3         0                   .00         0                   .00        0                    .00

               4         0                   .00         0                   .00        0                    .00

               5         0                   .00         0                   .00        0                    .00

               6         0                   .00         0                   .00        0                    .00

               7         0                   .00         0                   .00        0                    .00

               8         0                   .00         0                   .00        0                    .00

               9         0                   .00         0                   .00        0                    .00

              10         0                   .00         0                   .00        0                    .00

              11         0                   .00         0                   .00        0                    .00

              12         0                   .00         0                   .00        0                    .00

Purpose

This report provides beginning and ending account balances, and transaction activity for the current posting run.  It also provides control totals, and serves as the primary audit trail for statistical account activity.

The report is produced automatically as part of the posting process.  The posting process is selected using the Post option on the General Ledger Menu.  For a list, demand post, or final post, the report will contain information for all account/centers.  For a quick list or quick post, the report will contain only account/centers that had transaction activity for the posting run.  For a list or quick list, the report represents what will happen if you actually post the unposted transactions for the current period.  For all other posting options, the report represents the transactions that were posted.

Based on the value defined on category P01, the report will include all transactions for the period or only the transactions from the most recent posting run.

Control Totals

Control totals are accumulated to summarize all posting activity and to verify that the statistical master file is in balance both before and after the current posting run.  Control totals are also listed for the Valid and Cumulative Transaction Files.

 

 

Report Heading

Full Name

 

BEGINNING
BALANCE

 

 

BALANCE SHEET

The total beginning balance of all statistical Balance Sheet accounts.

 

INCOME STATEMENT

The total beginning balance of all statistical Income Statement accounts.

 

TRANSACTION
AMOUNTS

 

 

PREVIOUS POSTED

The total amount of all statistical transactions posted in previous posting runs for the period.  This total is only printed if the Print Previously Posted Transactions option is selected on Reference File Processing Options Category (P01).

 

CURRENT POSTED

The total amount of all statistical transactions posted in the current posting run

 

ENDING BALANCE

 

 

BALANCE SHEET

The total ending balance of all statistical Balance Sheet accounts.

 

INCOME STATEMENT

The total ending balance of all statistical Income Statement accounts.

 

MISMATCH SUSPENSE

The amount of all statistical transactions which did not match an existing active account.

 

MISMATCHES

The number of statistical transactions which did not match an existing active account.

 

NO OF GL ACCOUNTS

The number of statistical General Ledger accounts.

 

VALID
TRANSACTION
CONTROL FILE
TOTALS

 

 

BEGINNING BALANCE

 

 

PERIOD

Fiscal Period

 

TRANS

The total number of transactions according to the control record before the current posting run.

 

QUANTITY

The total amount of all quantity transactions before the current posting run.

 

POSTED ACTIVITY

 

 

TRANS

The total number of transactions posted this run.

 

QUANTITY

The total amount quantity posted this run.

ENDING BALANCE

 

 

TRANS

The resulting control record transaction count balance according to the beginning and posted transaction counts.

 

QUANTITY

The resulting control record quantity amount balance according to the beginning and posted actual quantity amounts.

 

CUMULATIVE TRANSACTION
CONTROL FILE
TOTALS

 

 

PERIOD

Fiscal Period

 

BEGINNING
BALANCE

 

 

TRANS

The total number of transactions according to the control record before posting.

 

QUANTITY

The total amount of all quantity transactions before posting.

 

POSTED ACTIVITY

The total number of transactions posted this period.

 

QUANTITY

The total amount quantity posted this period.

 

ENDING BALANCE

 

 

TRANS

The resulting control record transaction count balance according to the beginning and posted transaction counts.

 

QUANTITY

The resulting control record quantity amount balance according to the beginning and posted actual quantity amounts.

 

         

Report Sequence

Account number.