PCjs Machines

Home of the original IBM PC emulator for browsers.


PC-SIG Diskette Library (Disk #2495)

[PCjs Machine "ibm5170"]

Waiting for machine "ibm5170" to load....


Disk No: 2495                                                           
Disk Title: QUE Accounting General Ledger                               
PC-SIG Version: S2.2                                                    
Program Title: Que Accounting General Ledger                            
Author Version: 2.2                                                     
Author Registration: $45.00                                             
Special Requirements: 640K RAM, and a hard drive.                       
QUE ACCOUNTING GENERAL LEDGER (QUE G/L) is a full-featured general      
ledger that supports multiple companies and multiple departments.  While
the QUE G/L is easy to use because of its menu-based design and context 
sensitive help screens, it is a serious accounting package.  You must   
have accounting knowledge to use it.                                    
QUE G/L includes the following features:                                
~ Batch entry of transactions                                           
~ Detailed listings with account and department totals                  
~ Automatic repeating entries                                           
~ Posting to closed periods                                             
~ Audit trails with batch dates                                         
~ 99 fiscal periods and transaction limit of $99,999,999                
~ Budget entries by company, department, and account                    
~ Financial statements by corporation, company, and department          
~ Financial and budget comparisons between companies and periods        
~ dBase file compatibility                                              
QUE G/L comes with a functional practice set that quickly introduces you
to its many features.  The extensive report writer and query systems    
make it the type of system that's popular with CPA firms.  QUE G/L      
integrates easily with the other QUE accounting modules and is a great  
way to get serious about your financial information.                    
1030D East Duane Avenue                                                 
Sunnyvale  Ca. 94086                                                    
(408) 730-9291                                                          
(c) Copyright 1989 PC-SIG, Inc.                                         


                         QUE ACCOUNTING

For the system to function properly, it must be installed on a
hard drive.  The specific requirements are listed below.  Note
some adjustments may be required of DOS configuration files.


QUE requires : 
  - 640K MEMORY 
  - 1,000,000 BYTES FREE on hard disk * 
  - a floppy drive used for installation 


  - CONFIG.SYS - needs to have FILES=25 and a BUFFERS=16 
  - Must be installed on C or D drive. To install to other 
    drives the knowledgeable person can change the INSTALL bat 

The directory structure created during installation is the value
entered at the command: 

       where QUEACC is the name of the directory to be created
In case this directory is already used for another application,
no files or programs will be overwritten and no harm should come
to that system.  However removing the other system to a separate
directory, is advised.


The system comes with 1 diskette. To install the system insert
the diskette into  drive A and type in 

To install from another drive(example B), change the INSTALL.BAT
file to read B: in all places where A: is found or type in the
following commands:

        C> MD QUEACC
        C> CD QUEACC

The documentation may be viewed on line or printed out by typeing
the following command. Note the manual is segregated into several
sections following the Main Menu structure.


You are now ready to start. Please do the following: 

        C> CD QUEACC
        C> MAINMENU 

Enter "AAA" for COMPANY and "test" for PASSWORD and then go to
the UT Menu and select the REINDEX option in order to create the
index files. If you don't do this step, the system will not work. 


                            Chapter 4
                        Signon Procedure 


Starting the system by typing in MAINMENU at the C prompt (C>)
will display the following screen:

              Enter the COMPANY Code AAA

The user is given 3 attempts at entering the correct password
before the system is aborted.  Once successful, the MAINMENU will
be displayed.  For first time users a ZZZ company code and 'TEST'
password provides access.

Passwords and Company codes are setup in the ST Setup file.

Main menu

                   * YOUR COMPANY NAME HERE *

             UT. UTILITY MENU.
             ST. Setup Files


Options are selected by pressing the leftmost character in the
desired selection or by highlighting it with the cursor bar and
pressing enter.

Although functions overlap, the MAINMENU may be segregated into
four areas:

                   SYSTEM FUNCTIONS
                   MASTER FILES

The SYSTEM FUNCTIONS are named so because of their broad and
general affect on the entire system.  They include:

     TB - Used to install beginning account balances, to enter
          Budget information, to perform account balance
          comparisons between periods and to display current and
          Year to date balances when desired.

     PE - End of Period processing assures all transactions were
          posted and the balanced sheet is balanced before
          current transactions are deleted. Also any valid
          Repeating entries are Posted to the GL transaction file
          for the new period after the current transactions files
          are archived.

     UT - Utility menu includes the Backup, Restore and Reindex
          commands.  The backup procedure copies the current data
          files to seperate areas.  Restore is used to transfer
          saved files back to hard disk.  Reindex is used to
          reorder the files and to remove unneeded space.  This
          menu also provides the means to activate the Practice

     ST - The install program is used to set up the system. 
          Entered here is a record for each company that includes
          company names to appear on reports and screen headings,
          passwords and access controls and other initialization

The MASTER TABLES are used to create and modify the validation
tables and the Chart of Accounts.  They include:

     GL - General Ledger chart of accounts module allows the
          addition, deletion and modification of account records.
          Also, records may be displayed based on ACCOUNT ranges,
          TYPEs and CLASSes.

     DT - Department master is used to manipulate and display the
          Department Master file.
The TRANSACTION PROCESSING section concerns the recording of
daily operational transactions such as, cash receipts, cash
disbursements, incoming bills, and journal entries. 

     ET - The General Ledger transaction module handles the
          recording of all transactions not recorded in the
          special journals (AP,AR and INV) such as cash receipts,
          jounal entries, prior period adjustments, etc.

     RE - Repeating entries are applied to the GL data file at
          the time of EP.  Validation is made against the chart
          of account to assure the account exists and hasn't been
          retired or marked closed.

The REPORT menu provides the ability to produce the necessary
financial statements at any desired point throughout the period. 
The balance sheet, income statement, and detailed trial balance
may be created for individual companies, for departments within a
company, or for the corporation as a whole.  Subsidiary schedules
and individual account transaction listings are provided.

     RP - The report menu includes:

            o  Balance sheets by dept, by company, and
            o  Income statement by dept, by company, and
            o  Account Query by account within a company,
               account/department combinations, and queries
               across company boundaries.  The queries may be
               printed or sent to the screen and may include
               searches through history files.
            o  Detailed balanced sheet, detailed trial balance,
               and  detailed income statement.


                      QUE ACCOUNTING SYSTEM
                       USEFUL DOS COMMANDS

Command           Description

CTRL S            These two keys when pressed together will
                  pause the present activity.  It will stop
                  screen scrolling and halt the printer.  A
                  likely use would be  to change the printer's
                  paper when jammed.  Hitting CTRL S again will
                  resume activity.

CTRL ALT DEL      These three keys when hit together will
                  "reboot" the system.  Rebooting is similar to
                  turning the machine off and back on.  This is
                  a good command to try only when the computer
                  seems hung and no input is accepted from the

SHIFT PRTSC       These two keys allows us to print whatever is
                  on the screen.  It may be useful in recording
                  error messages or displaying data not readily 
                  available on reports.  For instance printing a 
                  single master file record.

CHKDSK /F         Used to check the memory  available for use 
                  and the amount of diskspace. The /F parameter
                  is used to rebuild bad file allocations.

FORMAT            Used to ready a diskette for copying during
                  the backup procedure.
                      QUE ACCOUNTING SYSTEM
                        USEFUL Keystrokes

Cursor Movement

The cursor, a flashing minus sign, may be moved through the use
of the four directional keys on the right hand side of the
keyboard.  The upper arrow is used to return back to the
preceding field.  The down arrow or the RETURN key are used to
move on to the next field.  The right and left arrows move the
cursor one space in the corresponding direction.

      Vendor PE     
      Invoice test12     
      Date    12/31/87

For instance, if the cursor was sitting on the eight of the date
field, hitting the up arrow twice would move it to the Vendor
field.  If I wanted to move it only to the beginning of date, I
would hit the left arrow 4 times, since the "/" are fixed and not
considered part of the data.

Any field where the last character entered fills up the display,
the computer will automatically assume the entry is finished and
will continue onto the next field.  In the case of most menu
selections, therefore, hitting return after a selection is not

Screen Function Keys

While processing data on a data screen, certain key combination
can be used to facilitate the process. Intuitively, moving the
cursor key with the arrows, as described above and pressing the
DEL and INS keys will get the job done  and may be all that is
necessary. However, there are advantages to using the keystrokes
listed below:

  CTRL A          Moves the cursor a Word to the left.
  CTRL F          Moves the cursor a Word to the right.
  CTRL Home       Moves the cursor to the top of the screen.
  CTRL END        Moves the cursor to the bottom of the screen.
  CTRL T          Deletes the word to the right of the cursor.
  CTRL Y          Deletes from the cursor position to the end of
                  the field.
  CTRL U          Restore the current field to its original
                  value, as long as you did not exit the field. 
  CTRL U          Terminate the current process, saving all
                  changes made including the current field.
  ESC             Terminate current process, saving all changes 
                  but those made to the current field.


                         QUE ACCOUNTING

Version 2.0 was developed and tested on a 80386 based machine
using a 28 millisecond hard drive. The performance we found to be
quite impressive however, with the next upgrade, the machine will
be optimized for speed and tested on lower end machines using
8088 based chips.

The systems comes equipped with a conversion program that will
take the older version files and format them for use in Version
2.0. To execute this conversion type in


Version 1.2 and older files will be saved under OLDQUE directory
on the current drive.

It is very important that the conversion be done during the
beginning of a new period, since transaction batches from the
older system cannot be referenced by the batch date and number.

These transactions however are accessible through those programs
accessing history files.


                           QUE Accounting

                       Copyright (c) 1989,1990


              The QUE Accounting series is a well prepared
              and tested series of Accounting programs.
              QUE Accounting makes no expressed or implied
              warranty of any kind in regards to the
              programs and documentation. In no event
              will QUE Accounting be liable for
              damages incurred due to incidental use of
              these programs. QUE Accounting reserves the
              right to modify the programs and documentation
              as deemed necessary without any obligation of
              notifying any persons or organizations.

                          QUE Accounting
                          Suite 180
                          1450 West Chester Pike
                          West Chester, PA 19382



a) descriptions

The RE function is used to create transactions to be
automatically transferred each period to the General Ledger
transaction file.  During the End of Period (EP) process, the
Repeating entries are checked against the Chart of Accounts.  If
the account has been closed or in the case of assets, retired,
the transaction will not be posted to the new period's General

    17:16:32        * PRACTICE AAA COMPANY *           06/04/90
                      Accounting Main Menu            Period:13

    F1 Help     ESC Exit          F6 Calculator     F10 Window

              ┌──────────<< Batch Records >>───────────────┐
              │Comp:    AAA   Source : RE                  │
              │                                            │
              │Transactions:       6    Total:        0.00 │
    │Account Dept  TransDate     Amount   Reference     Descr │
    │ 1120   15    05/15/90      100.00     cash      money re│
    │ 1120   15    05/15/90     -100.00     cash      offset f│
    │ 5300   16    05/22/90    12300.00     rent      rent all│
    │ 1120   16    05/22/90   -12300.00                       │
    │ 1120   15    05/22/90 -1000000.00                       │
    │ 1130   16    05/22/90  1000000.00     account           │
                           F3 Print Batch

      A Add     E Edit    D Delete   <>  to move    Esc to exit

As the example shows, the screen format is very much like the ET
ADD function.  All entries in RE are given an 'RE' source code.

For control, no records will be written until the entire batch is
balanced.  If unbalanced, the modify screen will display, forcing
adjustments to records that have been entered before exiting.
b) operations

1) Add and Edit

The Add, Edit and Delete operations are exactly like the Add,
Edit and Delete operations decribed in the ET Transaction Entry

Please see the ET Transaction Entry portion of this manual.

2) Delete

This function will delete a transaction from the repeating entry
file.  Any transaction deleted during the current period will
still be included in the GL transaction file unless specifically
deleted from that file also.  Subsequent periods will not contain
the deleted entry.

F3 Print Report

This option prints the entire batch of repeating entries since
there are usually not enough to warrent a selection screen on
account and transaction number range.

Please see the Report Examples in the Appendix.

F4 Post Immediate

This program allows the owner to post individul batches to the
General Ledger without having to wait for the EP process.  The
advantage here is to allow entry of repeating entries at any
point during the current period and to post them immediately.




  There must be at least one department identified for each
company in the system.

a) description

DT is used to add, modify and delete department records.  Each
department number must be unique within that specific company
when entered.

The department master is used in validations during transaction
entry and in report production to help determine how information
is to be summarized and printed.

A department record may be identified as a group, single, or
subsidiary department.  A group department may include one or
many subsidiaries.  The ENDING DEPARTMENT field identifies the
last department for a given group. GRPIND with a value of 'Y'
indicates a group department. A 'N' GRPIND indicates a subsidiary
department or a single department unaligned with a given group. 

In certain functions, like the balance sheet and income
statements, the client may select all group departments by
entering a "99".  The group indicator (GRPIND) therefore is used
for purposes beyond the identification of group records.

    16:56:34       * PRACTICE AAA COMPANY *            06/04/90
                      Department Master               Period:13

   F1 Help      ESC Exit           F6 Calculator     F10 Window

     Comp    Dept     Department Name       Grpind     End Dept

      AAA      13   Group Department           Y         19
      AAA      15   East Bay Toke Club         N         15
      AAA      16   East bay S & R             N         16
      AAA      18   test department            N         18
      AAA      20   Group Data Processing      Y         29
      AAA      22   test sub department        N         22

                        F3 print report

     A Add     E Edit     D Delete       to move   Esc to exit

b) operations

1) Add and Edit

   16:56:34       * PRACTICE AAA COMPANY *            06/04/90
                     Department Master               Period:13

   F1 Help      ESC Exit          F6 Calculator     F10 Window

    │Comp    Dept     Department Name     Grpind     End Dept│
    │                                                        │
    │ AAA      13   Group Department           Y         19  │
  │(Comp) (Dept)            (Name)        (Grpind)  (End Dept)│
  │ AAA     16    East bay S & R              N           16  │
    │ AAA      20   Group Data Processing      Y         29  │
    │ AAA      22   test sub department        N         22  │

            Ctrl-W save edits    Esc exit without saving

  The Add/Edit screen is similar to the Add/Edit screens in other
functions. Ctrl-W will save the current changes and ESC will
restore the record back to its values prior to changing.

  The COMPANY must exist in the system's STARTUP file, before the
transaction will be accepted.  The ENDING DEPARTMENT field
appears only if a Y is entered for the GROUP FIELD ? prompt.  The
value must be equal to or greater than the DEPARTMENT in order to
be accepted.


2) Delete

To DELETE a record, it must exist on the file.  Any department
with active transactions will not be deleted.  If this occurs, a
message will appear on the screen "To delete a department under
this condition, first delete the transactions".

    16:56:34       * PRACTICE AAA COMPANY *            06/04/90
                       Department Master              Period:13

    F1 Help      ESC Exit          F6 Calculator     F10 Window

   │Comp    Dept     Department Name       Grpind     End Dept│
   │ AAA      13   Group Department           Y         19    │
   │ AAA      15   East Bay Toke Club         N         15    │
   │ AAA      16   East bay S & R             N         16    │
   │ AAA      18   test department            N         18    │
           │  This record will be deleted from the file│
           │        Do you want to do this? Y/N        │

F3 Print Report

  The report option is simply a straight record by record print
of the Department master file
                         Department List

        Comp    Dept   Name               Grp     Erange    

        ABC      10    ACCOUNTING          Y        19
        ABC      20    FINANCE             N        20
        ABC      30    PRODUCTION          Y        49
        BBC      10    ACCOUNTING          N        10


PE is used to archive the current data files and to prepare the
system for the new period.  In order to execute, all transactions
must be posted and the required financial statements executed and

While running, the screen will indicate the program's progress. 
The first screen to appear is a WARNING message that describes the
procedure and tells the user how to abort the process in case of
accidental selection.

The first validation checks for unposted transactions.  If there
were modifications, deletions, or additions to the General Ledger
(Accounts Payable and Accounts Receivable if installed) transaction
files since the last execution of the financial statements the
following message will appear:

     'Unposted Transactions.  Need to run both Income
      and Balance Sheet.'

If one of the required statements was executed the message will
request the one still needed.  For example:

     'Income Statement ran.  Still need to run 
      Balance Sheet.'

Continuing, if both of the required statements were executed and
the balance sheet is balanced, a message will appear on the screen
defining the process to follow.

     'Updating account balances ...'

At this point, Files will be updated and backup copies made.  Once
done, the current Trial Balance is archived.  The name assigned is
composed of the 'AS OF DATE' of the current period and a two
character mnemonic indicating the file type.  For example, a period
ending May 31, 1985 will have an associated file archived as
T053186.  The user will be prompted for a new period 'AS OF DATE'
for each company in the system.

     'Please enter new period As of Date' 06/30/86 

If the new date is greater than the old period date, the repeating
entries are validated and transferred to the now empty GL
transaction file.  Any transaction with an account number that has
been retired or closed in the GL master will not be copied.

If the old period happens to be the end of the fiscal year, the
income statement accounts are "zeroed" out and the Trial Balance
updated for the Retained Earnings account specified in the SETUP

Finally, the files are reindexed and control is returned to the



a) description

ET is used to record general transactions not recorded in the
specific modules (Accounts Payable/Accounts Receivable).  When
added, modified or deleted the transaction is posted to the
General Ledger Transaction file and the Trial Balance

ET transactions can only be entered for a the signon company
during a given session.

At the start of each update function, a special security flag is
set to assure only balanced batches are posted.  During the
normal exit of the ET function an automatic file backup is
executed if the AUTO RESTORE flag is set on in the company's
setup file. In the case of an abnormal termination, such as a
power loss, an automatic file recovery is conducted during the
sign on process. This effectively restores the General Ledger and
Trial Balance to the point prior to the aborted function.

    22:34:08         * PRACTICE AAA COMPANY *         06/06/90
                   General Ledger Transactions       Period:10

    F1 Help    ESC Exit           F6 Calculator     F10 Window

         ┌────────────────<< Batches >>─────────────────┐
         │                                              │
         │Comp  Code   Period  Batch Date  Batch Number │
         │ AAA   CSD    10     06/06/90          2      │
         │ AAA   JE     10     06/06/90          3      │
         │ AAA   INV    10     06/06/90         10      │
         │ AAA   RE     10     07/31/89        999      │
     F3 print report  F4 select batch  F5 transaction register

     A Add     E Edit    D Delete   <>  to move    Esc to exit
b) Operations
1) Add and Edit

 The Add, Edit and Delete functions deal with the batch group
record. Add and Edit provide the means to add new batch header
records and change existing ones, respectively. The batch date
and batch number must be unique for the given company when

 In the case of Edit, only the Code, Batch date and Batch Number
can be changed. If any of these values are changed the change is
also reflected in each of the transaction records composing the

 For instance if we were to change the source code in the first
batch listed, from CSD to CSR then all those transactions in the
batch would be changed accordingly.

2) Delete

 In the delete mode, all records associated with the batch will
be deleted and the Trial Balance updated. This powerful command
has a warning message displayed at time of selection.
Furthermore, precautions have been placed in the system to allow
the disabling of this function through the Company Setup file

F3 Print Report

 This option will list all batches in the system giving a total
transaction count and dollar amount for each.

 Please refer to the Report Example appendix for an example of
the report layout.

F4 select batch
 This option opens a particular batch for viewing and/or

   22:34:08        * PRACTICE AAA COMPANY *           06/06/90
                  General Ledger Transactions        Period:10

   F1 Help      ESC Exit         F6 Calculator     F10 Window

            ┌───────────<< Batch Records >>───────────────┐
            │Comp:    AAA   Source : RE                   │
            │Batch Date: 07/31/89  Batch Numb:  999       │
            │Transactions:       2    Total:         0.00 │
    │Account Dept  TransDate   Amount    Reference     Descr  │
    │ 1130   15   06/06/90      100.00   cash deposit  mellon │
    │ 1120   15   06/06/90     -100.00   transfer             │
    │ 1210   15   06/06/90  1000000.00                        │
    │ 1220   15   06/06/90  1000000.00   sales to dt          │
    │ 4200   16   06/06/90 -2000000.00                        │

      A Add     E Edit    D Delete  <>  to move   Esc to exit

1) Add and Edit

a) Description

 A batch consists of a number of transaction records which
together net to the balance of zero. If the Change and Delete
flag is set in the Company Setup record, records may be changed
for Accounts, Departments and Amounts.
 When exiting the batch, the balance must be equal to zero or the
individual will be stuck in the process until the batch is in
balance. Turning off the computer or 'rebooting' to avoid
balancing will be recognized during the next signon process and
depending on the security measure selected, an online restore
will be automatically performed to assure data integrity. This
option is controlled in the Setup function.

 Assuming the batch is balanced the trial balance is updated
during the exit process and the user is returned to the Batch
listing screen. 

 Several Edits are in place to assure intergrity and to avoid
costly keying errors. Besides forced balancing, account and
departments must be validated for the selected company while
amounts entered in the transaction amount field must be within
the range determined in the General Ledger for that particular
account number.

 In particularly the range function helps control common mistakes
with debit and credits by allowing the specification of negative
and positive dollar amounts. For instance, a sales account number
may be set up to handle transaction amounts in the range of -
999,999.99 to -9.99. If the keyer were to erroneously enter a
positive figure recognition would be immediate.

b) operations

As in most multi-record display screens desired records are
selected by highlighting them and pressing enter. In the case of
Add a blank record appears. Fields may be navigated by using the
navigation keys described in the appendix. CTrl W saves the
changes made or adds a new record if that be the case. The ESC
key aborts the process and restores the batch back to the state
prior to selecting the record.

2) Delete

The current highlighted record may be deleted by pressing  the
delete key (D). A confirmation message will appear before the
record is actually deleted and the batch balance reduced.
 F5 Transaction Register

This option provides the ability to create various reports by
allowing the operator to chose an Account and Transaction Date
range, and by selecting specific Source Codes.  Default values
exist in the fields in order to facilitate the process.  A source
code window is provided by hitting the F10 key.

The screen body appears below: 

                                      │     Source Codes:      │
                                      │                        │
   ENTER START TRANS DATE   07/02/86  │CSD - cash disbursements│
   ENTER END TRANS DATE     07/02/86  │CSR - cash receipts     │
                                      │JE  - journal entry     │
                                      │RJE - reverse journal   │
                                      │PPA - prior period adj  │
   ENTER SOURCE CODE(S)               └────────────────────────┘
   ENTER ACCOUNT #  -- START      0 
   (To cancel enter 0)  END    9999 

Any combination of the above fields may be used to select records
from the General Ledger transaction file.  Please note only those
transactions pertaining to the company selected will be

To cancel a request and return to the GL menu, enter a zero in
the END account number field or press the ESC kay.

The Transaction register may also be used to print all records
within a given batch. As the function is selected a prompt will
appear asking whether or not a single batch list is desired. By
entering the Batch Date and Batch number the entire batch is
printed. *

*  NOTE: This idea came from several users who desired an easy
way to see an entire batch of transactions.
Report Examples

Some common report examples from the Transaction Register
function may include the following: 
     Find all cash receipt transactions entered during the month.

 Selection criteria: 
     Enter "CSR" in the first source code field and the first and
     last dates of the month 07/01/86 - 07/31/86.
     Get all cash account entries regardless of source code. 

 Selection Criteria: 
     Enter the cash account range in the START and END account 
     fields and leave Source Code fields blank.
     List all transactions for the current period. 

 Selection Criteria: 
     Simply enter the date parameters that assure all records 
     will be selected 01/01/80 - 12/31/87 and leave the other
     fields at default values.

     List all cash transactions with "CSD" and "CSR" source

 Selection Criteria: 
     Enter "CSR" and "CSD" into the first 2 source code fields
     and the appropriate account range for cash accounts based on
     the Chart of Accounts.

The above examples may or may not be useful for your particular
needs but they do show the possible selection criteria available.
As you become more familiar with the software and the
application, requests will be tailored to specific needs. 

More specifity is available through the Report Writer option
described in Chapter 5.


                         QUE ACCOUNTING
                    FUNCTION KEYS ASSIGNMENT

          Generally, the following keys are assigned
          within each module. 
               F1 - Help key to Help Database 

               F6  - Pop Up calculator

               F10 - Window to the Appropriate Master file 

               ESC - To abort out of a process or menu.


                            Chapter 5
                         Other Functions

 RW Query and Report Writer 

The RW Query and Report writer function is a powerful utility to
select information upon complex condtions set with 'easy to
follow' instructions. It can even be used to access files outside
the QUE Accounting series or programs.


The popup window style access allows you to select files, set
relations between files and to select the fields to appear on the
output. The output may be directed to either a table format on
the screen or a report.

Chosing Files

When you first enter the program, a listing of files in the
current directory are displayed. Highlight the desired file(s)
and press F10 to continue to the next phase.

Making Relations

When more than one file is selected, the first file chosen is
considered the parent and a relation must be set between it and
its children( subsequent files).

To relate files select the field in the parent by highlighting it
and pressing enter. Select the corresponding field in the child

   eg. Soc Sec Num   relates to   Soc Sec Num

Press F10 when complete.

Select, Sorted by and Where

This section tells the computer what data is to be selected and
in what sequence.

  Select the fields from the files and press F10 when complete.
  Sort the fields in the order in which you would like to see
them displayed by selecting them in the sort sequence.

   eg. Lastname Firstname
  The Where section uses boolean algebra and range values to
create a subset of data.

  eg. State='PA' .and. Lastname>'MAAA' .or. rate>100.00

Screen or Printer Output

The selected information automatically goes to a table display
but may be redirected to a printer.

Printed reports may include one or more of the following:

    report headings
    maximum and minimun values
    page widths and lengths
The math functions are also available while in the screen mode.

Saving the Query

The selected boolean criteria may be saved for future reference
by pressing the F6 key and entering in the brief description.

Saved queries may be accessed and executed at any time
eliminating the need of having to rekey in the selection
criteria. Each time executed the latest data is read from the

An example of a typical output screen appears below

║Filelist ║

General Ledger

     MEMFILE        Company Setup file
     GLMAS          Chart of Accounts
     GLTRANS        General Ledger Transactions
     GLBATCH        General Ledger Transaction Batch Headers
     TBDEPT         Trial Balance
     DEPTMAS        Department Master
     SOURCE         Source Code table
     RETRANS        Repeating entries
     SYSFILE        Account range file
     GLHIST         General Ledger Transaction History

Accounts Receivable

     ARMEM          AR Setup
     ARHEAD         Invoice Headers
     ARDETL         Invoice Line Items
     PRODUCT        Inventory file
     ARMAS          Customer master records


║Utility Menu║

 │09:51:48           Accounts Receivable           02/24/90 │
 │Company-> ABC         Utility Menu               Period: 7│
 │                                                          │
 │F1 Help      ESC Exit         F6 Calculator    F10 Window │
 │                 ┌────────────────────────┐               │
 │                 │QUIT return to MAIN MENU│               │
 │                 │                        │               │
 │                 │BU. Backup files        │               │
 │                 │RS. Restore from Backups│               │
 │                 │IX. Reindex files       │               │
 │                 └────────────────────────┘               │


The utility menu includes miscellaneous functions and those
outside the normal realm of operations. They are however very
important elements of the system.

Backup / Restore / Reindex

The first three options on the menu prime responsibility is
recovering from hardware and unexpected system malfunctions. 

The Backup feature copies the system files to backup diskettes.
So that in the case of an emergency they may be used to restore
the system back to the point in time the copy was made. It is a
good idea to perform this operation periodically based on a
specific event such as after the close of a period. 

The Restore function is selected to perform the restoration of
files back onto the system. Diskettes must be saved using the
backup feature of this system in order to perform a restore.

The Reindexing utility is called automatically by the end of
period process but may be called more frequently. It recreates
your file linkages and cleans up any unused space reserved by
deleted records. It is usually the first recourse when
experiencing index problems as may be noted by missing or out of
sequence data.

The simple on screen instructions will guide you through the

NOTEPAD (optional)


The NOTEPAD is a handy, mini word processor that will meet most
of your word processing needs. It works most effectively with
memo and letters but may be used to access larger documents.

Like many word processors it is limited by the size of available
memory. Most typical users (640K) will not have a problem.
However, it s a good precautionary measure to periodically save
your file as you are typing.


The NOTEPAD option may be activated from the menu or by pressing
the F9 key from within other designated functions.The following
keys are active within the NOTEPAD window.

    Alt-A  (A)ppend a file to current file and continue
    Alt-B  (B) place a block marker
    Alt-F  Insert a field from a database 
    Alt-G  (G)oto line number
    Alt-H  (H)elp screen
    Alt-I  (I)nsert line     
    Alt-K  (K)ill current line
    Alt-L  page (L)ength for printing
    Alt-M  change (M)argins
    Alt-N  edit (N)ew file             
    Alt-P  (P)rint file
    Alt-Q  (Q)uit but save edits           
    Alt-R  search and (R)eplace
    Alt-S  (S)ave file & continue          
    Alt-T  (T)oggle wordwrap on/off
    Alt-W  (W)rite to new file             
    Alt-X  e(X)it without saving
    Alt-Y  change director(Y)/wildcard


EDIT WINDOW/STATUS LINE: when you enter the notepad, the edit
window takes up nearly the full screen.  There is a status line
at the bottom, which displays the name of the file being edited,
the current line and column position of the cursor, the left and
right margins, and the status of wordwrap and insert modes
(displayed when active as "<Wrap>" and "<Ins>", respectively.)
When a file has been edited, an asterisk will appear at the right
side of the top row (next to the "Alt-H=Help" message).

CURRENT DIRECTORY/WILDCARD - the notepad gives you the ability to
change the working directory and/or filemask at any time.  When
you first enter the notepad, the current directory will be set to
the default DOS directory, and the wildcard will be set to '*.*'.

If you would like to change either the directory where the
notepad looks for files or the wildcard used (e.g., "*.TXT",
"*.PRG"), press Alt-Y and enter the new information.  You do not
have to enter slashes in front or back of the directory name
UNLESS you include a wildcard.  For example, to change the
current directory to "\ACCT\", you need only enter "ACCT". 
However, if you want the notepad to look for all the .TXT files
in subdirectory \ACCT\, you must enter "\ACCT\*.TXT".

If you enter just the wildcard, the current directory will remain
unchanged.  If you enter a directory name only, the wildcard will
be reset to "*.*".  If you press Enter without typing in
anything, neither the current directory nor the wildcard will be

Examples: let's assume that your application is in a subdirectory
named \WORKSTUF.  The initial current directory/wildcard will be
set to "\WORKSTUF\*.*".  If you press Alt-Y and enter "*.TXT
<CR>", the directory/wildcard will be changed to
"\WORKSTUF\*.TXT".  If you wish to change to the ACCT
subdirectory, press Alt-Y and enter "\ACCT <CR>".  The
directory/wildcard will then be changed to "\ACCT\*.*".   Suppose
you then want to look at only the .TXT files starting with the
letter P in the directory \ACCT You would press Alt-Y again, and
enter "\ACCT\P*.TXT".

FILENAMES: when you press Alt-N to edit a new file or Alt-W to
write to another file, a scrolling window will appear containing
all files that match the current directory and wildcard mask.

The directory and wildcard mask will be shown at the top of this
window for reference.  Note that files with the following
extensions will not appear in this directory, based on the
assumption that there should be no need to edit binary files:

To select a file, move the highlight bar to it and press Enter.
Also note by pressing a letter key, the first file starting with
that value is highlighted. PgUp, PgDn, Home and End keys are also
INSERT and WORDWRAP: the start-up values for these modes is on.
They may toggled off and on at any time by pressing Insert and
Alt-W, respectively.  The status of these modes appears at the
right side of the status line.  Additionally, the cursor size
will change from large (insert) to small (overwrite) based on the
current mode.

MARGINS: the start-up margins are 1 and 80.  However, you may
change these margins at any time by pressing Alt-M and entering
the desired values.  When you change the margins, the on-screen
display will adjust to reflect the new margins.  You may use
larger values for the right margin than would appear on the
80-column screen.  In such instances, you should toggle wordwrap
off and scroll to the right to display text beyond the on-screen
right margin.  The current values of the margins appear on the
status line.

PAGE LENGTH: the start-up page length for printing is 60 lines. 
You can change this at any time by pressing Alt-L.

SEARCH AND REPLACE: you can search and replace for all or for
only a specific number of occurrences of a character string. 
When you press Alt-R, you will be prompted first to enter the
search string, then the replacement string.  You will then be
asked if you want to replace all occurrences of the search
string.  If you answer 'N', you will be prompted to enter the
number of occurrences to replace.

Please note that the search begins at the top of the file and
continues either to the end of the file or until the specified
number of occurrences have been replaced.

PRINTING: you may print the current file at any time by pressing
Alt-P.  Printing may be aborted at any time by pressing Esc.  The
format of the printed page is determined by the current settings
of the margins and page length.

BLOCK COPY used to highlight a block of text to be copied moved
or deleted. Alt-B both starts and stops the block marking. A
third Alt-B brings up the function window.

FIELD INSERTION used to bring in fields from a database. The
selected fields will be printed in the body of the letter.



This is a useful calculator that includes all the basic
operators: addition (+), subtraction (-), multiplication (*), and
division (/).

But it also has some other goodies, including exponentation (^),
a percentage(%), a paste function and a full-featured memory. 
Plus, whenever you press an operator ('+', '-', '*', '/', or
'^'), the previous number is shown above the display window. 
This is handy for when you are processing a list of numbers and
forget where you were.  Also the calculator can be moved around
the screen using the directional arrow keys.

The maximum value that can be stored in the calculator is


Active Keys:

    '+' -- addition                        '-' -- subtraction
    '*' -- multiplication                  '/' -- division
    '^' -- exponentation                   'C' -- clear 
    '%' -- Percentage                           current number
    'E' -- clear entry (does not clear previously
           entered number in pending operation)
    'P' -- print (adding machine mode)     'M' -- Memory
    '=' or Enter -- process operation       Esc -- exit
    'D' -- change the number of decimal options
    'R' -- round the numbers to a specified number pf places

Calculator movement keys:

    UpArrow      -- move calculator up one row
    DnArrow      -- move calculator down one row
    LtArrow      -- move calculator left one column
    RtArrow      -- move calculator right one column
    Ctrl-LtArrow -- move calculator to far left (rows
    Ctrl-RtArrow -- move calculator to far right (rows
    Home         -- move calculator to top left corner
    End          -- move calculator to bottom right corner
    PgUp         -- move calculator to top row (columns
    PgDn         -- move calculator to bottom row (columns
Memory Functions:

To access memory functions, press "M", then one of the flashing
function keys.  The function keys are:

    'R' -- recall number stored in memory
    'C' -- clear memory (reset to zero)
    '+' -- add current number to number stored in memory
    '-' -- subtract current number from number stored in
    '*' -- multiply number stored in memory by current number
    '/' -- divide number stored in memory by current number

PASTE function

The paste function enables you to paste the current calculator
value into a numeric field while adding or changing records in a

However, erratic results may occur if the number of decimal
places in the number to be pasted is larger than the number
of decimals of the field described in your file. For example,
suppose that you have just used the calculator to derive the
result 75.2877.  You wish to paste this number into an amount
field on the screen prior to popping up the calculator. If the
field is only 2 decimal places than the probability is strong
that this number will be stored on-screen as 75.29 (although
internally it will remain 75.2877).

PRINT - Adding machine mode

By pushing "P" for Print, the calculator emulates an adding
machine.This will be noted by a small "P" to the right of the
number window. Each calculation will be sent to the printer (if
it is on-line). After all, if you have invested several thousand
dollars in PC hardware (and software), why bother spending more
money on a ten-key adding machine?  Press "P" again to leave
adding machine mode.


                            Chapter 2
                         GETTING STARTED 

This section prepares the user for the system by highlighting the
file structures and system functions in a simple descriptive
overview illustrated by two dissimilar examples.


The QUE Accounting system can be structured in various ways
because of the freedom it allows in defining the General Ledger,
the Department file and the Company Master.  It can accommodate a
single company that uses a simple chart of accounts or a more
elaborate setup that uses subsidiary accounts and departments and
requires reporting for multiple companies, and departments within

The following examples depict these extremes. 

     EXAMPLE - Company A The Corporation 
Company A is a corporation composed of two separate companies,
XYZ and ABC.  Each company has multiple departments which include
subsidiaries.  Likewise, the Chart of Accounts has both Group and
Subsidiary accounts.  The controller wishes to run a tight ship
and does so by reporting financials departmentally.

     EXAMPLE - Company B The Small Company 
Company B is a small company that is composed of two departments.
The departments represent a Warehouse and a Sales Office.  The
proprietor wishes to record expenses separately for these two
areas and is accomplishing this by recording transactions by the
department identifier (10 for Warehouse and 20 for Sales).  The
Chart of Accounts is a simple structure that uses no subsidiary

Each company has been setup in the system according to its own
specific needs. 
There are six files used in the system Setup.  The SOURCE code,
SETUP and RANGE files come predefined but may be changed to
reflect your specific needs.  The files are inter-related and
should be setup in the sequence shown.

 Table           Description
 SYSTEM        stores a record for each Company in the
               corporation. Keeps track of company data such as
               current period, password and miscellaneous

 RANGE         This file identifies the Account number ranges
               used for the different account classifications in
               the Chart of Accounts.  For example, 1000 - 1999
               are reserved for Assets, etc. *(Inventory range).

 GENERAL       The Chart of Accounts is responsible for account
 LEDGER        validations, transaction limits and controlling
               the printing of financial statements.
 DEPT          The Department Master records a record for each
               department in the system.
 TRIAL         The Trial Balance contains a record for each
 BALANCE       unique combination of Company, Department and
               Account.  It can be created as Departments and
               Accounts are being entered or by selecting the
               'REBUILD TRIAL BALANCE' option on The SU menu.

 SOURCE        The Source Code table is used to identify the
               batches entered in ET and to identify the default
               Debit and Credit Account numbers. 

The actual table layouts appear below as well as transaction
examples and a discussion on the implication of setup design on
reporting capabilities.



Both Companies use similar Range and Souce Code tables

a) Range Table

The three columns below represent the account type, starting and
ending account ranges from the table.

   A    1000    1999      Assets        * When interfacing with
   L    2000    2999      Liabilities     inventory, the Cost of
   C    3000    3999      Capital         Goods Sold field is
   R    4000    4999      Revenue         used to record the
   E    5000    5999      Expenses        reduction in inventory.

b) Source Code Table

The table below represent the three character source code,
followed by the default Debit and Credit account numbers.

   INV   1500  4100       Invoicing= Debit to Accounts Receivable
                          Credit to Sales  
   CSR   1100  1500       Cash receipts= Debit to Cash, Credit to
                          Accounts Receivable
   CSD   2010  1100       Cash Disbursements= Debit Accounts
                          Payable and Credit to Cash

The companies use different Chart of Accounts, Department file
and Setup files as illustrated in the following pages.

The Chart of Accounts shows the Account number, the account
class, the account type, the account group indicator and the
ending account range.

The Department file shows the Company code, the Department code,
the department group indicator and the ending department range.

The System file shows only the Company Code and the company name.

**  For the purposes of these illustrations, only selected
elements appear in these tables. Chapter 3 provides a detailed
description of each element in the tables aligned with the Setup
Company A 

Acct Cls Type Group End     Description

1000  A   L    Y    1050    Group Cash Account 
1010  A   L    N    1010    Subsidiary cash account (Bank 1)
1020  A   L    N    1020    Subsidiary cash account(Bank 2)
1100  A   L    Y    1100    Inventory w/ no subs
1500  A   L    Y    1500    Equipment no sub accounts
2000  L   L    Y    2050    Group Payables
2010  L   L    N    2010    Accounts Payable sub account
2020  L   L    N    2020    Accounts Payable sub account    
4100  R   L    Y    4100    Revenue Account

Comp Dept Group End  

ABC  10    Y    19 
ABC  11    N    11 
ABC  12    N    12 
ABC  13    N    13 
ABC  20    Y    20 
XYZ  10    Y    19 
XYZ  20    Y    20 


Comp  Name

ABC   ABC Company 
XYZ   XYZ Company

The Trial Balance is a result of each unique Company, account and
Department combination entered into the system. The Current and
Year To Date figures are included in the example to illustrate
the update process.

Both companies are starting out with clean balance sheets.

TRIAL BALANCE  (only ABC is shown)
Cmp Acct Dept Current  YTDbal

ABC 1000 10    0.00    0.00    ABC 2010 10-1000.00   0.00 
ABC 1000 11    0.00    0.00    ABC 2010 11    0.00   0.00 
ABC 1000 12    0.00    0.00    ABC 2010 12    0.00   0.00 
ABC 1000 13    0.00    0.00    ABC 2010 13    0.00   0.00 
ABC 1010 10    0.00    0.00    ABC 2020 10    0.00   0.00 
ABC 1010 11    0.00    0.00    ABC 2020 11    0.00   0.00 
ABC 1010 12    0.00    0.00    ABC 2020 12    0.00   0.00 
ABC 1010 13    0.00    0.00    ABC 2020 13    0.00   0.00 
ABC 1010 20    0.00    0.00 
ABC 1020 10    0.00    0.00 
ABC 1020 11    0.00    0.00 
ABC 1020 12    0.00    0.00 
ABC 1020 13    0.00    0.00 
ABC 1020 20    0.00    0.00 
ABC 1100 10    0.00    0.00 
ABC 1100 11  300.00    0.00 
ABC 1100 12  300.00    0.00 
ABC 1100 13  400.00    0.00 
ABC 1500 10    0.00    0.00 
ABC 1500 11    0.00    0.00 
ABC 1500 12    0.00    0.00 
ABC 1500 13    0.00    0.00 
ABC 2000 10 1000.00    0.00 
ABC 2000 11    0.00    0.00 
ABC 2000 12    0.00    0.00 
ABC 2000 13    0.00    0.00 

 The dollar amounts represent balances of transactions occurring
in the current period. These transactions may come from one of
the input modules, ET, Accounts Payable, Accounts Receivable,
Payroll or directly changed through the Change Trial Balance
function of the TB module.
 Company B

Acct Cls Type Group End      Description

1000  A   L    Y    1000   Cash
1100  A   L    Y    1100   Office Furniture
1500  A   L    Y    1500   Equipment
2010  L   L    Y    2010   Accounts payable
4100  R   L    Y    4100   Revenue

Comp Dept Group End

BBB  10    Y    10  
BBB  20    Y    20 


Comp  Name

BBB   BBB Company


Cmp Acct Dept Current  YTDbal 

BBB 1000 10   0.00   0.00 
BBB 1000 20   0.00   0.00 
BBB 1100 10   0.00   0.00 
BBB 1100 20   0.00   0.00 
BBB 1500 10   0.00   0.00 
BBB 1500 20   0.00   0.00 
BBB 2000 10   0.00   0.00 
BBB 2000 20   0.00   0.00 


Company B books are less extensive than Company A. As depicted
there is a direct relationship between the number of accounts,
companies and departments entered and the number of entries in
the Trial balance.  At any time through the course of the year,
department and account records may be added at will and without
affecting any existing balances. Likewise, Departments and
Accounts may be deleted as long as there are no transaction
balances, current or Year to Date.

As transactions are entered, deleted, and modified through one of
the update modules (ET, AR and AP), and the Trial Balance is
updated simultaneously. For example, Company A wishes to
distribute inventory just purchased on credit to the three
subsidiary departments in Company ABC.  Since Account Payable is
recorded at the Group level, the transaction would be entered in
ET as:

          Company   Account   Department     Amount

            ABC      2010        10        -1000.00 
            ABC      1100        11          300.00 
            ABC      1100        12          300.00 
            ABC      1100        13          400.00 

A similar transaction for Company B would yield like results. But
instead of recording the credit (Accounts Payable) for one
department, the expense of purchasing office furniture is divided
equally between the two departments receiving the goods.

          Company   Account   Department     Amount

            BBB      2010        10        -1000.00 
            BBB      1100        11          300.00 
            BBB      1100        12          300.00 
            BBB      1100        13          400.00 

The appropriate adjustments to the Trial balance are shown. 
Note both sets of transactions constitute a balanced accounting
entry and that the adjustments made to the Trial Balance keep the
books in balance.

Detailed transactions reports can be printed through the
Transaction Register function in each of the input entry
processes. Ranges on accounts and dates may be specified as well
as specifying certain source codes.

The Transaction Register is used to produce standard registers
such as Cash Receipts, Cash Disbursements, and Sales jounals.

Since the financial statements access the Trial Balance directly,
all balances will encompass all  entries in the Transaction
files. The financial statements may be ran as often as needed
without any restrictions to the contrary. As new transactions are
added to the transaction files, changed or deleted, the Trial
Balance is affected, accordingly. A value set in the SYSTEM file
for each company keeps track of changes to the Trial Balance and
forces the print of certain financial statements before the
period may be closed.

To access transactions which reside in multiple modules such as
Accounts Payable and Accounts Receivable, the Detailed Trial
Balance or Report Writer modules may be used. If a specific
account is the target, the Account Query function provides a
listing of all transaction for that account number for Current or
History files.

Company A has more reporting options since it has more accounts,
companies and department entries. Financial statements may be
produced for an individual department, a group department  an
entire company or for the entire corporation.

Company B has less options. Reports can be produced for the
entire company as a whole or for one of the individual
departments.              Chapter 3 

The Setup section covers the setup process, that is necessary
before the system may be used in a 'live' mode. If you are
uncomfortable at this time or at any time throughout the process,
you may end the session and continue later without any
interruptions to the system. All the information entered will be
intact as you left it. For a overview of how the system is used
we strongly suggest using the Practice system that is installed
with the system. 

Practice System

To start the system enter 'ZZZ' for the Company and TEST for the
password.  As you will notice, all files in the production system
are blank except for the ZZZ Company record.

To install the Practice System go to the UT menu and select
'START PRACTICE' from the menu.  

The files used in the system Setup are listed below.  The SOURCE
code, SETUP and RANGE files come predefined but may be changed to
reflect your specific needs.  The files are inter-related and
should be setup in the sequence shown.

 Table           Description
 SETUP         stores a record for each Company in the
               corporation. Keeps track of company data such as
               current period, password and miscellaneous
 RANGE         This file identifies the Account number ranges
               used for the different account classifications in
               the Chart of Accounts.  For example, 1000 - 1999
               is reserved for assets.
 GENERAL       The Chart of Accounts is responsible for account
 LEDGER        validations, transaction limits and controlling
               the printing of financial statements.
 DEPT          The Department Master records a record for each
               department in the system.
 TRIAL         The Trial Balance contains a record for each
 BALANCE       unique combination of Company, Department and
               Account.  It can be created as Departments and
               Accounts are being entered or by selecting the
               'REBUILD TRIAL BALANCE' option on The SU menu.
 SOURCE        The Source Code table is used to identify the
               batches entered in ET and to identify the default
               Debit and Credit Account numbers. 
 System Table

      Field             Field Description

     Period         Ending date of the current period
     Password       The password used to log in to the package. 
     Company        3 character alphabetical mnemonic for the
     Report Flag    Identifies which required financial
                    statements have been executed during the
                    current period.  No entry needed.
     Balance?       Tells whether or not the Balance Sheet is
                    balanced for that company.  No entry needed.
     Number         The number of periods in fiscal year. 
     Current        The value of the current period. 
     Screen         The title to appear on the screen.
     Report         The title to appear on the reports.
     Retained Earnings   The Retained earnings account number. 
                         Imperative for proper Balance Sheet
     Printer Control     80 or 132 columns printer identifier. 
                         Use the condense print sequence for 80
                         col printers. 
     Restore Check       Used to alert system of incomplete
                         updates.  Set by system ET process.
     Auto Restore        Tells system whether or not to do
                         automatic restore during signon. Also is
                         used to signify automatic backup during
     Restore Password    Password to be able to do restores.
     Change/Delete Access  Field signifies whether or not
                           changes can be made to transactions.
     Trial Balance Access  Field signifies whther or not
                           access is granted to Trial Balance
                           Change mode and Budget Entries
     Override Password     Password used to enter the ST Setup
                           function which allows the setting
                           of passwords and access control.
     Report Writer Password  Password to guard access to Report
                             Writer option.
     General Ledger Access   Controls access to update functions
                             to the Chart of Accounts
     Accts Receivable Dir    The directory where AR resides *
     Accts Payable Directory The directory where AP resides *  
     Payroll Directory       The directory where Payroll resides.

 * Only used in case the QUE Accounting modules are used in an
integrated fashion.
Range Table

     Class     The accounting classification.  (A-Assets,
               L-Liabilities, R-Revenue, E-expense, C-Capital) In
               case the Inventory Module is installed, it is used
               also to identify the range of Inventory.
     Start     The first account in range. 
     End       The last account in range. 

     Cost of   The Account number form the Chart of Accounts used
     Goods     to record the offsetting entry to an inventory

Source Code

     Code           The 3 character code to represent transaction 
     Description    Description
     Default Debit  The debit account normally associated with 
                    this transaction type.
     Default Credit The credit account normally associated with
                    this transaction type.
Chart of Accounts
     Account        Account number
     Class          Account Classification such as A for Assets,
     Type           Identifies Type of account such as L for pos- 
     Group          Group indicator to identify group accounts 
     End            Identifies the last possible account in the 
     Closed         Closed indicator
     Retire         Retirement date for assets

     Comp           Three Character company identifier. 
     Department     Two digit identifier. Comp+Dept must 
                    be unique to the file. 
     Group          Group indicator
     End            Identifies the last possible Dept in that

The Source Code table and the Range table are modified through
the ST function off of the main menu. The Chart of Accounts and
Department master files are changed through their own functions.

For a more detailed description of the elements composing the
Chart of Accounts and Department Master, please consult the
operational manual.
Table Design

The focal point of the Accounting System is composed of the
structure set up in the General Ledger and Department Master. 
The Trial Balance is a conglomeration of this structure.  When
designing your system, it is advisable to sketch your Chart of
Account (GL) and Departments out on paper before entering them
into the computer.  Make sure to plan for future growth if you
expect to add some accounts between existing numbers.  For

         Before                     After Addition 
   1000 Cash                    1000 Cash 
   1100 CDs at First Pennsy.    1100 CDs at First Pennsy 
   1200 Accounts Receivable     1110 CDs at Mellon 
   1300 Inventory               1200 Accounts Receivable 
                                1300 Inventory 

Accounting principle
QUE Accounting System follows a standard double entry accounting
system.  The system assumes no default values for accounts and
therefore requires the keyer to use the proper signs (+ and -)
for debits and credits.  Please consult Chapter 1 if you are
unsure of the accounting terms of debits and credits.

                     To increase         To decrease 
 Assets           use positive numbers  use negative values
 Liabilities      use negatives         use positive
 Capital          use negatives         use positive
 Revenue          use negatives         use positive
 Expense          use positive          use negatives

Group Accounts and Departments

Group accounts appear on as single line items on the financial
statements while any subsidiary account appears in a detailed
schedule printed as optioned at the end of an Income statement or
Balance sheet.

Group accounts facilitate reporting while providing detail if
needed. Larger firms with many accounts might want to use group
account to assure their financial statemenst are unclutterred.

Group departments are similar in that financial statements
printed for group departments will include all amounts for the
subsidiary departments. However unlike accounts, a single
subsidiary department balance sheet and income statement can be
User Defined Reporting

The TYPE categories in the Chart of Accounts allows you to define
your own sub totaling, report headings and page breaking on the
financial statements.

The Transaction Registers allow selection of date and account
ranges thereby providing reports for a wide range of data.

The Query and Report Writer provides the most flexibilty in
producing reports. It allows you to combine information from
several files and to determine  conditional selection, much like
the range selection of Transaction Registers. The order of fields
to appear on the report as well as the sorting sequence and
subtotaling may be defined as well. Queries may be saved for
future reference.




The General Ledger Master programs are used to enter and modify
the General Ledger Chart of Accounts (GL).  Comprehension of the
following information is crucial to the successful implementation
of the accounting package.  Practice is STRONGLY RECOMMENDED
before attempting to set up the chart of accounts for your actual
business.  See the Utility Menu for a more detailed description
of the Practice System.
All the transaction programs use the GL to validate entries and
to produce reports.  The Report program formats the financial
statements based on the account TYPE assigned.  One GL Master is
created for all the companies in a corporation.  Individual
accounts are assigned by adding them with the ADD option.

a) Description
The number entered into the ACCOUNT NUMBER field must be unique
for the corporation.  If an account record already exist with the
account entered, a message will appear '** ALREADY HAVE AN ENTRY
FOR THIS ACCOUNT **' and the screen will be redisplayed.

Duplicate account numbers are not allowed. Group account numbers
within the boundaries of another defined group and ending range
values that extend into another group field are disallowed.
Detailed field descriptions

The CLASSIFICATION field relates to the accounting classification
of Assets, Liabilities, Capital, Revenue and Expense.  It is
required that the account numbers entered for any classification
be contiguous or the financial statements might produce erroneous
balances.  The range file determines the allowable range for
accounts within a given classification.  Any value other than
that specified will be discarded and an 'OUT OF RANGE' error

The TYPE field is used to describe the type of account for
transaction posting and financial statement headings. 

o  A TYPE 'P' account designates that when encountered during a
balance sheet or income statement (financials) execution, the
printer will advance and print the Account DESCRIPTION centered
at the top of the next page.

o  A TYPE 'T' field will print the description in the center of
the page without advancing.

o  A TYPE 'S' account when encountered will print the current
total of the prior postable accounts (L) since the last 'S'

o  A TYPE 'G' will print the description and total of preceding
'L' balances up to the last 'G' entry. 

o  A TYPE 'M' account is used to subtract the current 'S' type
account from  the preceding 'S' type. Its most familar use is to
determine Gross Profit on a income statement.

o  Finally, an 'L' type account represents a postable account
used for the recording of daily operations.  Only L TYPE accounts
may be posted. An 'L' account may be designated as a GROUP
account by entering the ENDING RANGE account.
The GROUP FIELD entry is to identify an account with
subsidiaries. The 'ENDING ACCOUNT' number is the ending range of
the subsidiary accounts.  That is, any account greater than or
equal to the group account and less than or equal to the ending
account will be included in the "group" account balance.  The
group field designator is also used to identify which accounts
appear on the financial statements.  Since only group fields do
appear, to include single postable account records enter 'Y'. 
The system will automatically enter the same account number in
the ENDING ACCOUNT field.  A group account cannot be within
another group account for unpredictable results may occur.

The CLOSED INDICATOR is used to stop entry of transactions from
ET, AR, and AP transaction programs. To close an account enter a
'Y' via the Modification option.

The RETIREMENT DATE field appears for asset classified accounts
only.  It is used to automatically delete repeating depreciation
entries from the RE file.  When the current period's date exceeds
the retirement date, the entry is deleted from the repeating
transaction batch during the EP process after the final
transaction is posted to the new period.

1) Add Edit

     15:29:15       * PRACTICE AAA COMPANY *       06/20/90
                     General Ledger Master         Period:1

      F1 Help     ESC Exit       F6 Calculator     F10 Window

    │Account Description            Class  Type Group Endrang│
    │ 1100 Cash                        A      L    Y     1149│
    │ 1120 Bank Two                    A      L    N     1120│
    │ 1130 Bank three                  A      L    N     1130│
    │ 1150 Accounts Receivable         A      L    Y     1150│
    │ 1160 Notes Receivable            A      L    Y     1160│
    │ 1210 Raw Materials               A      L    Y     1210│
    │ 1220 Finished Goods - WIP also   A      L    Y     1220│
    │ 1299 CURRENT ASSETS              A      S    N     1299│
    │ 1300 Equipment                   A      L    Y     1339│
    │ 1320 Truck                       A      L    N     1320│
    │ 1340 Accumulated Depreciation    A      L    Y     1340│
    │ 1350 FIXED ASSETS                A      S          1350│
                 F3 Print report        F4 Display totals

        A Add    E Edit   D Delete   <> to move    Esc to exit

2) Delete

This function is used to delete records from the account master. 
No deletion will be allowed if there exist transaction records in
the Accounts Payable(AP), Accounts Receivable(AR), or General
Ledger(ET) transaction files.  To delete these accounts, you must
first delete the corresponding transactions.  This check is
provided to assure that all transactions are posted and 
included in the financial statements. 

F3 Print Records

The Print account option lists the account records stored in the
Chart of Accounts.  To print all accounts, hit the ESC key to
accept the default values placed on the screen by the computer. 
The screen appears below. To exit place a zero in the END account
field and hit the RETURN key.

               ENTER ACCOUNT #     -- START     0 
               (TO CANCEL ENTER 0 HERE) END  9999 

F4 Display Totals
This option prints the current Trial Balance in Account sequence
either by company or for the corporation.

                          TRIAL BALANCE

 Comp Acct Dept  Description     Beginning   Current     YTD 
 AAA  1100  10   CASH             100.00     100.00     200.00 
 AAA  1100  15   CASH               0.00     100.00     100.00 
 AAA  1100  16   CASH               0.00      10.00      10.00 
 AAA  1120  10   CASH AT BANK1    200.00      10.00     210.00 
 AAA  1120  15   CASH AT BANK1    200.00       0.00     200.00 
 AAA  1120  16   CASH AT BANK1      0.00       0.00       0.00 


                         QUE ACCOUNTING

For the system to function properly, it must be installed on a
hard drive.  The specific requirements are listed below.  Note
some adjustments may be required of DOS configuration files.


QUE requires : 
  - 640K MEMORY 
  - 1,000,000 BYTES FREE on hard disk * 
  - a floppy drive used for installation 


  - CONFIG.SYS - needs to have FILES=25 and a BUFFERS=16 
  - Must be installed on C or D drive. To install to other 
    drives the knowledgeable person can change the INSTALL bat 

The directory structure created during installation is the value
entered at the command: 

       where QUEACC is the name of the directory to be created
In case this directory is already used for another application,
no files or programs will be overwritten and no harm should come
to that system.  However removing the other system to a separate
directory, is advised.


The system comes with 1 diskette. To install the system insert
the diskette into  drive A and type in 

To install from another drive(example B), change the INSTALL.BAT
file to read B: in all places where A: is found or type in the
following commands:

        C> MD QUEACC
        C> CD QUEACC

The documentation may be viewed on line or printed out by typeing
the following command. Note the manual is segregated into several
sections following the Main Menu structure.


You are now ready to start. Please do the following: 

        C> CD QUEACC
        C> MAINMENU 

Enter "AAA" for COMPANY and "test" for PASSWORD and then go to
the UT Menu and select the REINDEX option in order to create the
index files. If you don't do this step, the system will not work. 


                         Que Accounting
                      Password and Security

The passwords and access flags are stored in the company record.
There are three passwords in the system:

 1) logon access
 2) override password
 3) report writer password.

Each controls access to the system and/or a particular function.
The override password controls access to the company setup file.
Once into the Setup record, access to the General Ledger, the
Trial Balance balances and budget amounts are controlled by the 
access control flags.

Data integrity

  Restore Flag                     The two restore flags work in
  Automatic Online Restore         unison to assure data
                                   integrity. The Restore flag
                                   is the indicator showing 
                                   when a power failure occurred
                                   during transaction entry. The
                                   second flag is used to tell
                                   the computer to do an
                                   automatic backup if it occurs.
                                   Otherwise a warning message
                                   is displayed during the next

Two level password protection

  Company Logon                    The Company Logon controls
                                   access to the system while
  Override password                the override controls access
                                   to the ST Setup function. 

Access Control

  Change and Delete transactions   These access flags may be set
  Change Trial Balance and Budget  in the Setup option. They
   entries                         control access to various
  General Ledger access permission segments of the system.
  Report Writer permission


                           QUE ACCOUNTING
                       PRODUCT ANNOUNCEMENTS
                             MAY 1990

QUE Accounting General Ledger           --------------  $45.00

    The General Ledger is the foundation on which all the other
    accounting modules are based. It is a double entry system that
    boasts a powerful and flexible Chart of Accounts that allows
    group and subsidiary account definitions and recording of
    transactions by departments within individual companies.

    The reporting functions include user-defined financial
    statements that may be produced for a single company or
    several companies, as in a consolidation. A complete set of
    transaction registers with a broad range of selection criteria
    and a full feature Query and Report Writer are also included.

QUE Accounting Accounts Payable         --------------  $45.00

    Comes complete with a vendor master and a separate
    transaction file. Invoices may be entered with an unlimited
    number of detail lines which may be used to distribute
    charges to several departments and to record expenses and 
    replenish inventory.

    No invoice is added or changed without balancing the invoice
    amount with the detail entries.

    Invoices may be partially paid and adjusted with credit and
    debit memo transactions.

    The flexible Transaction Register provides various reports and
    journals, such as Payment registers, Vendor balances, and
    several ad hoc reports:

      1)  by account number and date ranges
      2)  show vendor balances by product code
      3)  vendor balances exceeding a certain value
      4)  more...

    An Aging report provides a chronological breakdown of
    outstanding bills. 

    Discounts may be expressed as percentages or dollar values and
    are calculated based on the payment date entered.
    Mail merge capabilities.
QUE Accounting Payroll                  --------------- $45.00

    This 'after the fact' system records labor expenses, federal
    and state income taxes, FICA, and any other deductions
    normally associated with payroll.

    The General Ledger trial balance is updated as data is added,
    deleted or modified for each employee.

    History files can be used to study trends, determine expenses
    by job class, localities, etc..

    An interface with the QUE Accounting Time and Attendance
    system is available.

QUE Accounting Accounts Receivable      --------------  $45.00

   Similar in concept to the Accounts Payable module, this
   function provides similar type reports and has the same
   control features.

   Invoices may be printed on user-defined criteria.

   Client Statements may be printed in various sequences.

   Client records record credit limit, year to date balances,   
   payment terms and other pertinent and active information.

* The integrated accounting series of programs include the
previous four modules (GL,AP,AR,PR) and may be purchased as one
integrated system for $149.00.


QUE Accounting Time and Attendance      -------------- $195.00 *

   Time and Attendance is used to keep track of employee time
   punches and to validate entries against user-defined tables
   and employee schedules. Time tracking includes vacation,
   holidays, personal time and other user-defined categories.

   May be used with or without an electronic time clock. Punches
   can be recorded for specific job codes or departments for
   job costing purposes.

   Employees can be grouped by like workrules, such as, shift
   differentials, break and lunch durations, grace periods for
   time punches, overtime calculations, etc..

   Benefits include increased accuracy and reduced clerical
   expenses in determining gross pay, on demand reporting, and
   historical data to be used in forecasting future budgets.

QUE Accounting Personal Information Manager   --------  $45.00

    The Personal Information Manager system provides the ability
    to access information based on a range of values using simple 
    'english like' phrases, such as;  ( State='PA' .and.
    Amount>1000.or. Name='SMITH'). The query statements can be
    saved for future recall.

    The selected subset of information is either printed or
    displayed in the order of the fields selected and in the
    sequence desired.  The display mode allows full update
    capabilities of deleting, adding and modifying records.

    The system allows for the creation and design of your own file
    structures and the import/export of information into and out
    of these files to interface with other systems such as
    speadsheets, database products, and word processors.

    Also included are several nice utilities. A mini word
    processor that includes 'block' commands and mail merge
    features, an appointment calendar and a pop-up calculator
    make this a complete system that can be used to track any
    information desired.

    Most encouraged!
    Most software purchased 'off the shelf' or 'as is' never does
100 % of what is needed. However, some demands such as an
additonal report or to have additional space added to an invoice
detail line can be a simple and inexpensive solution.  Optimally,
enhancements to software is best done by the same team as those
who have developed the software.

    Customization of systems based around the 'core' products
listed in this brochure is most cost effective. Actual costs are
almost always much cheaper than complete customized systems and
are frequently within the range of higher priced PC accounting

    Customization may be applied to existing systems or new


     QUE Accounting performs in house training on:

       1) introduction to computers
       2) DBASE Beginners
       3) DBASE Intermediate / Advanced

    (also includes other DBASE dialects such as Clipper and
     FOXPRO, and FOXBASE)  

Prices for customization and training are done on an individual
contract basis.



     The QUE Accounting series of programs has been developed
over the years with much input from the user community. Many of
the features included in Version 2.0 are based on the results    
from a graduate study of PC based accounting systems and    
direct inquiry from the users of earlier versions of QUE
Accounting. We are confident our system offers a number of
advantages over other PC accounting packages.

     It is easy to understand and use

provides on-line help and a completely functional practice system
that may be started and stopped at will without affecting 'live'

     It is flexible and will grow with you

much thought has been placed in the design to allow the system to
adapt to your organization and not vice-versa

     It is inexpensive

packages with these capabilities are often priced many times the
QUE Accounting list price.

     Supported by professionals

developed by accounting and data processing professionals   


because the system is entirely developed by QUE Accounting,
changes and enhancements are inexpensive  

About this manual

This manual is meant to be both an introduction into computerized
accounting system and a detailed description of the QUE
Accounting system. As you progress through the pages, you'll find
many screen displays that may be viewed on the computer. 

The manual has an introduction to accounting and some
illustrations but does not pretend to be an accounting text book.
Accordingly, some skills on how to use a computer is assumed.
There are many excellent books on both subjects that may be
obtained from your local library or bookstore to supplement the
material presented here.
Conventions used in this manual

 Bold                    highlight functions
 Underlined              highlight field names on screens
 Capital letters         highlight field names in files
 Shadowed Box outlines   screen displays 

How this book is organized

 This book is organized into several chapters. Users familiar
with accounting systems and computers may go directly to the
operational manual starting with Chapter 4.

 Chapter 1 gives a brief description of accounting fundamentals
and illustrates how computers are used in the automation of the
accounting process and what additional benefits are derived.

 Chapter 2 gets more specific with accounting transactions and
outlines how two dissimilar corporations may use the QUE
Accounting system. An example of the Chart of Accounts and common
accounting transactions are illustrated for both.

 Chapter 3 covers the preplanning process and details how the QUE
Accounting system is setup to be used.

 Chapter 4 begins the operation manual starting with the sigon-on
screen and continuing through the Utility Menu.

 Chapter 5 describes how to use the report writer, the pop-up
calculator and the mini word processor.

 The Appendix includes miscellaneous information such as help
text on cursor control and function keys, report examples and
installation instructions.

                            Chapter 1
                        Accounting Basics 

 Control and operations

 Accounting is used to measure how your business is doing. It is
the process of recording sales and expenses and groups that
information into meaningful data to be used in determining the
financial well-being of your firm.

 Accounting weaves its way into everyday activity. When a
salesman is on the road  he has expenses that must be recorded.
Just as the office person receives a paycheck or a check is
written to acquire office furniture, all these activities
constitute an accounting transaction. The accounting transaction
records the fundamental operation used in determining how to
better control costs and thereby increase the 'bottom line'.

 The importance of controlling costs may mean the difference
between profit and loss. With proper accounting practices,
expenses can be easily tracked to departments and or individuals
highlighting problem areas. Perhaps your sales force is spending
too much time on the road or your advertising budget is out of
kilter with revenues. With a good accounting system, these areas
can be easily detected.

 In recording daily activity such as sales, petty cash
disbursements, material expenses and the like, a good accounting
system should facilitate the transaction entry process and
provide a good tracking mechanism. Perhaps certain recurring
expenses such as rent could be automatically posted to the trial
balance monthly while various edits may be put into place to
avoid errant data entry. Limit checking by account, date and
account number validations, batch control to assure proper book
balancing, are just some of the features used to help control
costs and facilitate data entry.

 Depending on the size and needs of your organization, you may
need more or less in automation. A basic General Ledger system
may be just fine for a company with a few transactions monthly,
while larger firms need more control and automation through
integration with Accounts Receivable, Accounts Payables, Payroll
and Inventory modules.
 Reporting and Planning

 Once the information is in the computer you need to get it out
into a meaningful format. The reporting needs of an automated
system should meet requirements for reporting on a range or
subset of information; for the entire corporation or for honing
in on a given department.  A report writer and parameter driven
reports are vital extensions to a system that has needs for
reporting on any imaginable grouping of information. Whatever
your needs the reports produced should include at the minimum, an
income statement, a balance sheet and detailed ledgers to back
these vital reports.

 Reports highlight the company's performance. The sooner these
reports can be produced the sooner management is aware of
problems. Systems providing dynamic transaction updating are
necessary in providing on-demand, real-time reporting. In other
words, to produce reports as frequently as desired, all
information entered into the computer should be accessible to all
reporting mechanisms. Systems with separate posting requirements
do not easily provide this opportunity.

 Reporting needs also facilitate the reporting requirements for
outside concerns such as your CPA firm and federal and state

 The planning process starts with the evaluation of past
performance. With the reports provided from the accounting system
performance can be evaluated for specific profit and cost centers
thus aiding in the determination of future budgetary needs.
Moreso, with a good foundation of information your company is
better positioned to determine and attain realistic goals.


 Accounts, Transactions and Summarization

 The basic building block of the accounting system is an Account.
The chart of Accounts or General Ledger is a list of all accounts
used in the system. Accounts can be viewed as buckets or storage
areas for information. If for instance your are writing a check
against a certain bank account then that checking account could
be assigned an account number to represent it, or one account
number could be used to represent all bank accounts. The level of
detail is up to you. The more account numbers used the more
detail in the ledger and the finer the reporting possibilities.
 The transaction is the recording of an event against an account.
It is the mechanism used to increase or decrease an account's
balance. For instance you purchase computer supplies from the
local computer store, you need to record the reduction in cash
and the increase of computer supply inventory. The transaction
may appear as:

   Computer supplies  100.00
   Cash              -100.00

 The two parts of this transaction constitute one 'double entry'
accounting transaction. A double entry always nets to zero. For
every positive fiqure there must be an equal amount of negatives
and vice-versa. The positive amounts are referred to debits and
the negatives as credits. Depending on the type of account,
debits and credits either increase or decrease an accounts

 Account types are used to group accounts in like categories. The
five major groupings are assets, liabilities, capital, revenue
and expense.

 Assets are resources your company uses to generate revenues. In
the example above, both Cash and Computer Supplies are used to
keep the company going. A truck used to pick up the supplies and
an office building where office staff are working are also
contributing to the company's on-going existance and are assets
but of a more permanent nature. Assets, like all the account
types, can be broken down further into sub groupings (such as
Current Assets, Buildings and Equipment). Assets are increased
with positive (debits) amounts and decreased with negatives

 Liabilities, on the other hand, are claims against your
companies assets. When you purchase supplies on credit that
creditor has a claim against you company as recorded in a
liability account. Liabilities like assets can be of a short-term
or long term nature. Vendor invoices, accrued salaries, and
outstanding bank loans all represent liabilities.  Liabilities
are increased with negative amounts.

 Capital accounts represent the net worth of a company. If you
have more assets than liabilities you are said to have postive
net worth. This can be seen when assets (positive) are greater
than liabilities (negatives) a positive value remains. When
liabilities exceed assets, the company has negative net worth and
an unfavorable position.  Capital accounts are treated like
liabilities in that they are increased with negative values and
decreased with positives.
 Revenue accounts record incoming funds from the sales of
products and services. The offsetting entry may be to cash and/or
Accounts Receivable in the case where clients pay by credit.

 Expense accounts are the day to day costs of operation. Office
salaries, computer supplies, rent, utilities are all examples of
costs that must be paid to keep a business going. 

 Accounts are grouped and summarized into standard
classifications and reports used to compare your company's
performance either to past performances and/or other firms in
your industry.

 Financial Statements

 The Asset, Liability and Capital accounts make up the company's
Balance Sheet. The Balance sheet is a snapshot of your company's
well-being. It always lists Assets first followed by  Liabilities
and Capital. The equation used to represent the Balance Sheet is


 The Revenue and Expense accounts make up the Income Statement.
Perhaps the single most important piece of information on your
company's performance is the amount of profitability for a period
of time. When Revenue exceeds expenses you are said to have a
profit. This profit increases your company's net worth and value.
When Expenses exceed Revenues, the amount reduces the company's
value. Considerable losses over a period of time will deteriorate
a company's balance sheet and may result in bankruptcy.

 Automation with QUE Accounting

 Automating with QUE Accounting is easy and perhaps one of the
most valuable investments you can make. When forethought is
placed upfront in understanding the QUE system and designing the
company's Chart of Accounts, Company amd Department master files
an invaluable understanding of your company may result. Effective
application of the system may save thousands in manual processing
costs, the time tracking down errors and accounting fees.

     increased efficiency

 avoid costly billing errors, bookkeeping time, and tying up
valuable resources in manually recording transactions, writing
checks and determining balances owed and due.


 expanding reporting needs is as simple as adding new accounts,
departments and/or companies

     more information analysis

 timely reports are available that were before cost prohibitive.
History files are easily accessible to produce trend analysis,
and vendor history may be used to help bargain for vendor
discounts by showing volumes purchased.




a) description

The Report Program (RP) provides access to the financial
statements and account queries.  At any time during the current
period these reports may be executed.  Since the system has
automatic posting, they provide figures as of that moment in

The consolidated Balance Sheet and Income Statement must be
executed and balanced following any modifications to the
transaction files before an end of period (EP) can be performed. 
Balance Sheets by department and by company do not have to
balance in order to close the current period's books.

                   * Your Company Name Here * 
                         Report Program 

               A.   EXIT - RETURN TO MAIN MENU 
               B.   BALANCE SHEET per Company 
               C.   BALANCE SHEET Consolidated 
               D.   BALANCE SHEET per Department 
               E.   INCOME STATEMENT per Company 
               F.   INCOME STATEMENT Consolidated 
               G.   INCOME STATEMENT per Department 
               H.   QUERY AN ACCOUNT 
               I.   DETAILED TRIAL BALANCE. 
               J.   DETAILED BALANCE SHEET 

                    ENTER A SELECTION:      

Balance Sheet per Company

The Balance Sheet option first prompts us for the company name: 

               Select a COMPANY
               Hit the ESC key to exit
and provides for request cancellation.  If an invalid company is
entered an error message will appear and the program will abort
and return to the Report Menu.
All non zero accounts defined as group accounts will be printed.
If the total Assets is not equal to Liabilities and Capital, an
error message will be printed on the last line of the report.  An
"Unbalanced" message is however, highly unlikely due to the
stringent validation routines used in the transaction programs.  
After the Balance Sheet is created, the user will be asked: 

                Do you want subsidiary schedules?
Entering a 'Y' will produce a seperate schedule for each group
account defined in the Chart of Accounts.  A balance will be
printed for each account within the group account's defined

Balance Sheet Consolidated 

This option is used to create the consolidated balance sheet. 
All company balances both Year to Date and Current will be
combined in this report.  Similar to option B, the user will have
the option of producing subsidiary schedules.

A new feature provided in Version 2.0 is the ability to select
the companies to combine.

Balance Sheet Departmental 

This option allows the production of balance sheets by
departments within a specific company.  All group departments may
be selected by entering "99" into the department field.  The
entry screen appears below:

             Select a Company      BAR 
             Select a department of 99 for all   0 
             Make sure the PRINTER is on ! 
             Enter a "Q" to quit and return to MENU 

Only those departments assigned in the Department Master (DT)
table will be used.  Group departments, like group accounts, will
combine the amounts for all subsidiaries in the reported fiqure. 
To get a balance sheet for a subsidiary department either change
the department's group indicator on the department master to 'Y'
prior to a '99' department selection or select it specifically by
entering the department number in the selection screen.

Income Statements 
Since the Income Statement selection screens are identical to
those used for the Balance Sheets, an operational clarification
is not needed.  However, the report formats do differ.  Notably,
the calculation of NET INCOME and percentages for each line item
appear on the statements.  For a detailed example of all reports
in this section see REPORT EXAMPLES. 

Query an Account

          Select a Company or leave blank for ALL   BAR 
          Enter the desired ACCOUNT                1000 
          Select a department                 0 
          (enter 99 for all) 
          Enter a "Q" to quit and return to MENU 

To QUERY an account enter the desired account number.  A second
screen will ask whether or not Year to Date or Current data is
requested and whether or not to display the data to the CRT or
the printer.

If the account is present on the General Ledger Master, the
description field and all transactions in the current or history
GL, AR and AP transaction files will be printed.

Unlike the Transaction Register functions provided in ET, AP, and
AP, querying an account includes transactions from all files.

Detailed Trial Balances

The DETAILED TRIAL BALANCE list all transactions in the current
Accounts Payable, Accounts Receivable and General Ledger files. 
The report is broken down by department within account and lists
only those departments with transactions.

been provided to allow the accountant to select only those
accounts associated with a specific financial statement. This
facilitates research, since history transaction listings can be


│TB Trial Balance and Comparisons  │

a) description.

TB is primarily used to enter the initial account balances for each
company defined in the SETUP file.  It can also be used to modify
or display trial balances and, to compare by company or
corporation, account balances from different periods. Option E
produces a variance report of budget and actual balances. Option F
is used to enter the current and Yearly budget figures. 

                   * Your Company Name Here *
                           SU Start Up

               A.   EXIT - RETURN TO MAIN MENU 
               B.   Display Trial Balances 
               C.   Change Trial Balances 
               D.   Periodic Comparison 
               E.   Budget Comparison 
               F.   Budget Entries 
               G.   Create Trial Balance File 

                    ENTER A SELECTION:      

b) Operations

Display Trial Balances

Displays a record from the Trial Balance file to the screen.

               Enter ACCOUNT   1000 
               Enter COMPANY           XYZ 
               Enter DEPARTMENT         10 
                    YTD Balance              1000.00 
                    Current Bal              1000.00 
                    Current Budget            500.00 
                    YTD Budget               1000.00 

No modifications may be done on this screen. 
Pressing any key but the ESC key will advance to the next record.
Change Trial Balance 

Allows us to change a record in the current period's Trial balance
file. The accountant may start at a specific account number by
filling in the appropriate field or may elect automatic prompting. 

                  Enter Starting Company   XYZ 
                  Enter Starting Account   1000 

The system will list the accounts in Company, Account and
Department order.

When displayed the user may change either the YEAR TO DATE or
CURRENT balance field or both. Hitting the return key advances to
the next field and then the next record on file.

            ** Hit ESC to Quit ** 

            Enter ACCOUNT    1000         CASH Account 
            Enter COMPANY     XYZ 
            Enter DEPARTMENT   10 

            YTD balance       123.45 
            Current Balance   100.00 

The user may exit from this screen by hitting the ESCape key.  Any
changes prior to this will be saved in the current file.  

Periodic Comparisons

The financial compare program will allows us to compare any two
previous accounting periods. Both periods must exist on the current
disk or an error message will appear:

 'Sorry Can't find both files'

 Past period files are saved during the EP process.

The selection screen appears below: 

                   * Your Company Name Here * 
                       SU Period Compare 

            Enter first period  (MM/DD/YY) ' 01/31/86 
                  second period (MM/DD/YY) ' 02/28/86 

            Do you want Group Accounts only ?   
            Enter the Company desired or   
               leave blank for ALL 

Budget Comparisons
The Budget Comparison program displays the Variance between the
current period's account balances in the Trial Balance and the
Budgeted amount (see OPTION F on entering budget).

The selection screen appears below: 

                   * Your Company Name Here * 
                       SU Budget Compare 

                 Do you want Group Accounts only ? 
                 Enter the Company desired or 
                    leave blank for ALL 

See an example of the report layout in the REPORT EXAMPLE section
of this manual.

Budget Entries

Like OPTION C, the Budget can be entered through an automatic
prompting mode that is based on the combination of Company, Account
and Department.

                  Enter Starting Company   XYZ 
                  Enter Starting Account   1000 

When displayed the user may change either the YEAR TO DATE or
CURRENT budget field or both. Hitting the return key advances to
the next field and then the next record on file.

               ** Hit ESC to Quit ** 

               Enter ACCOUNT    1000    CASH Account 
               Enter COMPANY     XYZ 
               Enter DEPARTMENT   10 

               YTD budget        123.45 
               Current Budget    100.00 

The user may exit from this screen by hitting the ESCape key.  Any
changes prior to this will be saved in the current file.

Create Trial Balance

This option displays the following description when chosen: 

          ** This procedure automatically erases the ** 
          ** current Trial Balance file and rebuilds ** 
          ** it record by record based on the Ac-    ** 
          ** counts and Departments in the current   ** 
          ** files. 

          Do you wish to continue ? 

CAUTION All balances are destroyed when this procedure is executed.


                         QUE ACCOUNTING
                         SYSTEM CONTENTS


I.     Introduction                                           A
       A.    About this manual
       B.    Conventions used in the manual
       C.    How this manual is organized      

II.    Chapter I Accounting Basics
       A.    Control and Operations
       B.    Reporting and Planning
       C.    Fundamentals
       D.    Automation with QUE Accounting

III.   Chapter 2 Getting Started                              A 4
       A.    Overview
       B.    Setup                                            A 4
       C.    Transaction Processing                           A 7
       D.    Reporting

IV.    Chapter 3 Setup
       A.    Setup file
       B.    Table Design
       C.    Group Accounts and Departments
       D.    User Defined Reports

V.     Chapter 4 Operations Manual                             A 
       A. System Overview                                      A 
       B. ET Enter Transactions                                A 
       C. RE Repeating Entries                                 A 
       D. GL General Ledger                                    A 
       E. DT Department Master                                 A 
       F. TB Trial Balance and Comparisons                     A 
       G. RP Financial Statements                              A 
       H. PE End of Period                                     A 
       I. UT Utility Menu                                      A 

VI.    Chapter 5  Other Functions
       A. Query and Report Writer
       B. Notepad
       C. Calculator 

       A. Useful DOS Commands                                  A 
       B. Function Key Assignment                              A 
       C. System features
       D. System Installation
       E. Report Examples
       F. Windowed Screen
       G. Conversion from older versions



UT provides certain functions essential for proper system use.

                   * YOUR COMPANY NAME HERE *
                          UTILITY MENU

               A.   EXIT - RETURN TO MAIN MENU
               B.   BACKUP to diskette
               C.   RESTORE from diskette
               D.   REINDEX All Files
               E.   RESTORE from online
               F.   PRACTICE System Install
               G.   PRACTICE System Deinstall
               H.   Access to DOS
               I.   Query and Report Writer
               J.   Notepad
               K.   Calculator
               L.   Read Manual on-line
                    Enter a Selection:      

The BACKUP facilities (B) are used to back up the current
period's transaction files to diskette.  The backups are a safety
measure in case of hardware failures or accidental file deletion. 
Backups can be created as often as desired but frequency usually
depends on the volume of activity.  If the AUTO RESTORE flag is
set in the company's setup record, an online backup is saved each
time records have been modified. The files are stored in the
\ACCT directory with a SAV extension.  Offline backups require
formatted diskettes for operations.  Consult your DOS manual for
the FORMAT command if necessary.

The RESTORE programs (C and D) are used to copy saved files back
into the system.  Caution is advised since any data not stored on
the back ups will be overwritten.  Once complete, the REINDEX
option must be executed.  In case of hard disk failure, a
reinstall of the software is necessary before an Offline restore
can be completed. 
The REINDEX utility recreates the inter-file relationships
necessary for data retrieval.  This facility should be the first
course of action taken when the system 'hangs' or produces bad
data during program execution.  If it fails to alleviate the
problem, try restoring back up files before reindexing. 

The system comes equipped with a PRACTICE set of files for the
General Ledger Chart of Accounts and Department Master.  For
first time users and those exploring new areas of the system, it
is advised to perform such activity using these files prior to
production use.

Selecting the PRACTICE SYSTEM INSTALL Option copies the practice
files into the production environment after it safely saves the
current files to the backups (Online Backup).

To end the Practice session, select option G.  All data entered
in the Practice System will be saved so that a customized test 
system may evolve.  This feature allows a trainee to pick up
where he/she left off.

Option H allows direct access to the operating system without
leaving the Accounting System.  Any DOS command can be executed,
including other programs, as long as there is enough memory. 

The Query, Notepad and Calculator functions are utility programs
described in detail in the appendix.

Option L allows viewing the operation manual on-line without
leaving the system.

Directory of PC-SIG Library Disk #2495

 Volume in drive A has no label
 Directory of A:\

QUEACC   ZIP    288377   5-11-91   1:14p
INSTALL  TXT      1956   7-09-90   1:29p
PKUNZIP  EXE     22022  10-01-89   1:02a
INSTALL  BAT       166   3-30-91   2:48p
GO       BAT        39   6-14-91   1:28a
FILE2495 TXT      3553   6-14-91   2:47p
        6 file(s)     316113 bytes
                        3072 bytes free