APPX Software Library

2Monthly Processing

Option 5YTD General Ledger Report

This report prints monthly detail for the accounts identified as keeping YTD detail in the Chart of Accounts file, at the level of detail defined for each account. The following processing steps accomplish this job.

  1. Step 1In preparation for performing a sort/selection process on the YTD Postings information, this step provides you with a default sequencing of data records by Fiscal Year, Account, Fiscal Month, and Currency Code, with the option to change modifiable parameters at run time. Selection of data records is provided by Fiscal Year, Fiscal Month, Account Component, and Currency Code, with the option to enter user-specified comparisons at run time.
  2. Step 2This disposition type is used for all standard General Ledger reports.
  3. Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 4In order to print the YTD General Ledger Report, this step formats the YTD Postings information. The following data items are shown: Operator ID, Control No, Description, Journal Code, Source Transaction No, Transaction Date, Fiscal Month, Fiscal Year, Reference, Reversing?, Adjustment?, S/U/N Override, Intercompany, Intercompany Reference, Currency Code, Home Amount, and Amount. As appropriate, group headings appear whenever a change occurs in Account. If requested, totals appear whenever a change occurs in Account or Fiscal Year. When totals are specified, the following items are accumulated: Total Amount and Total Home Amount. Total Current Earnings is also shown.

A sample output is shown below.

                                                     APPX Demonstration Company
12/12/94 16:45                                                                                                       LGG Page:  1
                                                     YTD General Ledger Report


                                                         Fiscal Year 89

Control   Description                    Jrnl Trx  Trx Date Mo/Yr Ref    Rev Adj S/U/N Interco  Curr    Home Amount      Amount
=================================================================================================================================

Account 1020002000  Cash, Canadian Corporate                                                            552309.00

LGG       SUMMARY POSTING                 GL1               01 89        N   N                 CANADA   77672.29      93524.77
LGG       SUMMARY POSTING                 GL1               01 89        N   N                 CANADA   66440.00-     80000.00-
LGG       SUMMARY POSTING                 GL1               02 89        N   N                 CANADA   11572.68      13934.60
LGG       SUMMARY POSTING                 GL                03 89        N   N                 CANADA                 42448.59-
LGG       SUMMARY POSTING                 GL2               03 89        N   N                 CANADA  280040.07     286082.46
LGG       SUMMARY POSTING                 GL2               04 89        N   N                 CANADA  163932.55     197390.20
LGG       SUMMARY POSTING                 GL1               05 89        N   N                 CANADA  108352.53     130466.63
LGG       SUMMARY POSTING                 GL1               06 89        N   N                 CANADA   70803.20      85253.70
LGG       SUMMARY POSTING                 GL2               06 89        N   N                 CANADA   14351.49-     17280.54-
LGG       SUMMARY POSTING                 GL1               07 89        N   N                 CANADA   99909.46     120300.36
LGG       SUMMARY POSTING                 GL1               08 89        N   N                 CANADA   97750.91     117701.27
LGG       SUMMARY POSTING                 GL1               09 89        N   N                 CANADA   89276.24     107496.97
LGG       SUMMARY POSTING                 GL1               10 89        N   N                 CANADA   51277.79      61743.27
LGG       SUMMARY POSTING                 GL1               11 89        N   N                 CANADA   80219.85      96592.24
LGG       SUMMARY POSTING                 CURR              12 89        N   N                 CANADA                   506.24-
LGG       SUMMARY POSTING                 GL1               11 89        N   N                 CANADA   70916.76      85390.41

                                                                                                       ____________  ____________
                                                                             — Account Totals —>       1673241.84    1255641.51
                                                                                                       ============  ============
=================================================================================================================================

Account 1020002001  Cash, Canadian Sales Outlets                                                        385158.00

LGG       SUMMARY POSTING                 GL1               01 89        N   N                 CANADA   40174.77      48374.20
LGG       SUMMARY POSTING                 GL1               01 89        N   N                 CANADA   41525.00-     50000.00-
LGG       SUMMARY POSTING                 GL1               02 89        N   N                 CANADA    5328.82-      6416.39-
LGG       SUMMARY POSTING                 GL                03 89        N   N                 CANADA                 23971.64-
LGG       SUMMARY POSTING                 GL2               03 89        N   N                 CANADA  171679.48     177854.11
LGG       SUMMARY POSTING                 GL2               04 89        N   N                 CANADA   78305.20      94286.81
LGG       SUMMARY POSTING                 GL1               05 89        N   N                 CANADA   22656.04      27279.99
LGG       SUMMARY POSTING                 GL1               06 89        N   N                 CANADA   65831.41      79267.19
LGG       SUMMARY POSTING                 GL2               06 89        N   N                 CANADA   11384.08-     13707.50-
LGG       SUMMARY POSTING                 GL1               07 89        N   N                 CANADA   12368.83      14893.23
LGG       SUMMARY POSTING                 GL1               08 89        N   N                 CANADA   50366.88      60646.47
LGG       SUMMARY POSTING                 GL1               09 89        N   N                 CANADA   47711.07      57448.60
LGG       SUMMARY POSTING                 GL1               10 89        N   N                 CANADA   50880.18      61264.51
LGG       SUMMARY POSTING                 GL1               11 89        N   N                 CANADA   54468.30      65584.95
LGG       SUMMARY POSTING                 CURR              12 89        N   N                 CANADA                  2236.28-
LGG       SUMMARY POSTING                 GL1               11 89        N   N                 CANADA   41880.85      50428.48

                                                                                                       ____________  ____________
                                                                             — Account Totals —>        963243.11     640996.73
                                                                                                       ============  ============
=================================================================================================================================