APPX Software Library

2Monthly Processing

Option 2Budget Comparison by Account Report

This function prints a summary of the Subsidiary Codes by Account file, sorted by subsidiary code within account number. The following processing steps accomplish this job.

  1. Step 1In preparation for performing a sort/selection process on the Subsidiary Codes by Account information, this step provides sequencing of data records by Account and Subsidiary Code, with no option to change the sequence at run time. Selection of data records is provided by Account Component, Subsidiary Code, Subsidiary Code Type, and Alpha Sort, with the option to enter user-specified comparisons at run time.
  2. Step 2This disposition type is used for all standard General Subsidiary 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 Budget Comparison by Account Report, this step formats the Subsidiary Codes by Account information. The following data items are shown: Subsidiary Code, Description, Annual Budget, Year-to-Date Balance, Difference, Lifetime Budget, Life-to-Date Balance, and Difference. As appropriate, group headings and totals appear whenever a change occurs in Account.

A sample is shown below.

                                                       Expert Computing, Inc.
11/08/94 16:26                                                                                                       LGG Page:  1
                                                Budget Comparison by Account Report


                                                       Annual           YTD                    Lifetime           LTD
Sub Code         Description                           Budget       Balance    Difference        Budget       Balance  Difference
=================================================================================================================================

Account 1150001000MA  Equipment

COMPUTER         New Computer Syst. Development      58400.00           .00      58400.00     236000.00     121630.00  114370.00
GENERAL          Non Project-Specific Costs          24000.00           .00      24000.00           .00     476670.00  476670.00-
                                                    _________      ________      ________      ________      ________  _________
                       — Account Totals —>           82400.00           .00      82400.00     236000.00     598300.00  362300.00-
                                                 ============   ===========  ============  ============  ============ ===========

Account 1170001000    Accumulated Depreciation

COMPUTER         New Computer Syst. Development           .00       1904.00-      1904.00           .00      30844.00-
30844.00
GENERAL          Non Project-Specific Costs               .00      55917.00-     55917.00           .00     711143.74-
711143.74
                                                   _________      ________      ________      ________      ________    _________
                       — Account Totals —>              .00      57821.00-     57821.00           .00     741987.74-    741987.74
                                                ============  ============  ============  ============  ============ ============

Account 3010001001MA  Sales, Manufacturing

JONES            Salesperson Sam Jones             1831317.00-    411194.51-   1420122.49-          .00     411194.51-
411194.51
PETERS           Salesperson George Peters         1465085.00-    382984.83-   1082100.17-          .00     382984.83-
382984.83
WILLIAMS         Salesperson Kris Williams         1281890.00-    360119.34-    921770.66-          .00     360119.34-
360119.34
                                                  _________      ________      ________      ________      ________    _________
                       — Account Totals —>       4578292.00-   1154298.68-   3423993.32-          .00    1154298.68-   1154298.68
                                               ============  ============  ============  ============  ============  ============

Account 4010000001MA  Cost of Goods Sold, Sales/Mfg.

JONES            Salesperson Sam Jones              107127.00      15004.70      92122.30           .00      15004.70   15004.70-
PETERS           Salesperson George Peters           85701.00      14640.76      71060.24           .00      14640.76   14640.76-
WILLIAMS         Salesperson Kris Williams           74989.00      13071.01      61917.99           .00      13071.01   13071.01-
                                                   _________      ________      ________      ________      ________    _________
                       — Account Totals —>        267817.00      42716.47     225100.53           .00      42716.47     42716.47-
                                                 ============  ============  ============  ============  ============  ==========