Get a snapshot of cash, what you're owed and what you owe!

You need to quickly see how your business is doing financially without the time-consuming hassle of printing and sifting through reports, registers and statements. With GOV- General Ledger Management Overview, quickly view on a single screen up-to-date summaries of your cash, receivables and payables without printing reports and going through a pile of paperwork. Answer the basic "day-to-day" questions you need to operate your business such as how much cash do I have? How much do I owe my vendors? How much of my receivables are over 60 days? and more ...

GOV- General Ledger Management Overview is available in the G/L reports module under "Extended Reporting Options".

+------------------------------------------------------------------------------+
¦GLRPTS                    Extended Reporting Options       COMPANY ID: SP     ¦
¦03/04/97                    Software Professionals         GENERATION #: 11   ¦
+------------------------------------------------------------------------------+

                        + Extended Reporting Options -+
                        ¦  O - Management Overview    ¦
                        +-----------------------------+

F1-Help                                   F10 - Menu     ShF10-Home          N

The GOV- General Ledger Management Overview report provides a quick overview of company performance. Cash balances in all G/L cash accounts are shown. These accounts are the cash accounts set up in Accounts Payable which allows for up to 35 accounts. The amount posted to those G/L accounts is used to generate the cash balance. A Bank Account Manager (BAM) user can optionally use the total of all BAM bank accounts in place of using the G/L cash accounts.

Job Cost Summary information is provided and is calculated in the same way as it is done for the dedicated Job Cost Summary report.

Accounts Receivable Aging and Accounts Payable Aging is likewise a summary of the more in-depth comparable reports provided in each of those modules.

Sales Invoicing Backorder status is also shown to gauge the impact on cash flow of items that are backordered.

Finally, a measure of fiscal performance is presented that compares Accounts Receivable to Accounts Payable and also shows the impact of cash on the overall company fiscal status.

Each of the sections of the report can be updated individually or they can all can be updated at the same time. The function keys at the bottom of the screen provide this capability. Shift-F5 updates the bank account/BAM section, F6 updates Job Cost, Shift-F6 updates AR, F7 updates SI, and Shift-F7 updates AP. F8 will scan all data and update all sections of the report. The fiscal performance section is updated whenever AR, AP or the cash sections are updated. If your data files are sizeable the scanning process can take some time. During scanning of your data files, the scanning "busy" activity is shown on the screen.

When updating the A/R, A/P and cash account sections the user is prompted for an exclusion date, with the default being the end of the current month. This allows the user to exclude transactions after the given exclusion date. We recommend that the same exclusion date be used when updating these three sections. It is however, possible to give a different exclusion date in each section. The Excl. Date shown at the top of the report only reflects the LATEST exclusion date used. It would not show the use of a different, earlier exclusion date in AP, for example, if you updated AR with a later exclusion date.

Users of BAM have the option of using either the G/L Accounts maintained in Peachtree or their BAM account data. However, cutoff dates do not apply to BAM accounts. Only the current BAM balances are used. To properly view BAM balances the file ckcomp.dxx (where xx is the company ID) must be in the default Peachtree directory.

+------------------------------------------------------------------------------+
¦GLRPTS                    Extended Reporting Options       COMPANY ID: SP     ¦
¦03/04/97                   Software Professionals          GENERATION #: 11   ¦
+------------------------------------------------------------------------------+
+---------------- Management Overview --- Excl. Date: 02/28/97 ----------------+
¦ Bank Balance using G/L cash accounts ¦    Job Cost Summary       Percent of  ¦
¦ Updtd 02/14/97  5:13 PM              ¦ Updtd 03/04/97  9:40 AM   Rev. Price  ¦
¦ Cash Balance:      227463.82         ¦ Num Jobs  :        2                  ¦
¦--------------------------------------¦ Rev. Price:    10000.00               ¦
¦      Fiscal Performance Ratios       ¦ Billings  :    10000.00     100.0     ¦
¦ Updtd 02/14/97  5:13 PM              ¦ Payments  :    10000.00     100.0     ¦
¦        AR to AP      7.31 to  10     ¦ Costs     :    10670.50     106.7     ¦
¦ AR + Cash to AP      8.08 to  10     ¦ Margin    :     -670.50      -6.7     ¦
¦------------------------------------------------------------------------------¦
¦      A/R Aging          ¦   S/I Backorder Status   ¦     A/P Aging           ¦
¦ Updtd 02/14/97  5:13 PM ¦ Updtd 02/14/97  5:13 PM  ¦Updtd 02/14/97  5:13 PM  ¦
¦                         ¦                          ¦  Current :   113327.00  ¦
¦ Current  :  2124153.08  ¦ # Items  :         1     ¦   1 - 30 :  2753579.00  ¦
¦   1 -120 :    16570.79  ¦ Qty Bkord:         5.00  ¦  31 - 60 :    56486.32  ¦
¦ 121 -240 :     1231.98  ¦ Qty Avail:         0.00  ¦  61 - 90 :    36278.38  ¦
¦  Over240 :    22592.80  ¦ On Hand  :         5.00  ¦  Over 90 :        0.00  ¦
¦ Op.Credit:      -50.00  ¦ Tot Cost :      1053.75  ¦  Credits :        0.00  ¦
¦   Total  :  2164498.65  ¦ Tot Price:      2499.95  ¦ Total Due:  2959670.70 A¦
+------------------------------------------------------------------------------+
 F1-Help  F5-Prt  SF5-Bk  F6-JC  SF6-AR  F7-SI  SF7-AP  F8-All  F10-Done      N

A printed report containing the same information is also available by pressing F5. It is formatted slightly differently as more space is available on the printed page. An example of a printed report is shown below:

GOV- General Ledger Management Overview sample report:

RUN DATE: 03/04/97         Software Professionals                PAGE  1
RUN TIME: 10:19 AM
                         Management Overview Report
--------------------------------------------------------------------------------
                                                       Exclusion Date: 02/28/97



     Bank Balance using G/L Cash Accts        Job Cost Summary       Percent of
       Updated: 02/14/97  5:13 PM      Updated:  03/04/97  9:40 AM  Rev. Price


     Cash Balance:    $227,463.82       Num Jobs  :         2
                                       Rev. Price:    10,000.00
    Fiscal Performance Ratios          Billings  :    10,000.00       100.0
        Updated: 02/14/97  5:13 PM     Payments  :    10,000.00       100.0
           AR to AP     7.31 to  10    Costs     :    10,670.50       106.7
    AR + Cash to AP     8.08 to  10    Margin    :      -670.50        -6.7






        Accounts Receivable Aging                 Accounts Payable Aging
        Updated: 02/14/97  5:13 PM              Updated: 02/14/97  5:13 PM


                                              Current :          113,327.00
      Current   :      2,124,153.08            1 - 30 :        2,753,579.00
       1 -120   :         16,570.79           31 - 60 :           56,486.32
     121 -240   :          1,231.98           61 - 90 :           36,278.38
      Over240   :         22,592.80           Over 90 :                0.00
    Open Credits:            -50.00           Credits :                0.00
       Total    :     $2,164,498.65          Total Due:       $2,959,670.70






                           S/I Backorder Status
                         Updated:02/14/97  5:13 PM


                   Number of Items       :             1
                   Quantity Backordered  :             5.00
                   Quantity Available    :             0.00
                   Quantity on Hand      :             5.00
                   Total Cost            :        $1,053.75
                   Total Price           :        $2,499.95
                   ** End of Management Overview Report **