home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR15
/
JOUR165.ZIP
/
JOUR165.EXE
/
JOUR1.HLP
< prev
next >
Wrap
Text File
|
1993-06-03
|
16KB
|
325 lines
I'M NO ACCOUNTANT. (TM)
Single Business Journal Template
Copyright 1991 Willis E. Howard, III
All rights reserved.
I'm no accountant. But I run a business and need to keep
the books. The checkbook needs to be balanced. At the
end of the year, my accountant needs a copy of the books,
summarizing where the money came from, and were it went.
I looked at accounting software but found it too complex.
The I'M NO ACCOUNTANT (TM) accounting template provides
quick and easy bookkeeping for a small business.
ALT A The main accounting menu comes up when the spreadsheet is
loaded or when you press the ALT A key from 1-2-3 READY.
The following options can be selected:
1-2-3 Transactions Journal Extract Register Help Quit
1-2-3 enters 1-2-3 (R) READY mode.
The TRANSACTIONS menu processes new data.
The JOURNAL menu allows balancing and printouts.
The EXTRACT menu displays entries by account number.
The REGISTER item provides information on registration.
The HELP command shows these help screens.
The QUIT command from the main menu saves and exits.
1-2-3 Almost all accounting functions can be accessed from the
menu items. When other spreadsheet functions are needed,
select the 1-2-3 item. The accounting menu will be turned
off and you may use standard 1-2-3 (R) commands to access
the information in the spreadsheet.
When you have finished and wish to return to the main
accounting menu, press the ALT A key.
This is the first item on each menu. When any menu is
displayed, just press the ENTER key to access the
1-2-3 READY mode. Press the ALT A key to continue.
TRANSACTIONS When the TRANSACTIONS item is selected from the main menu,
the following menu is displayed:
1-2-3 Deposit Payment Salary Reconcile Bottom Help Quit
1-2-3 enters 1-2-3 (R) READY mode.
DEPOSIT inputs information on income received.
PAYMENT inputs information on checks which are written.
SALARY inputs information on a salary paid.
RECONCILE allows reconciliation with a bank statement.
BOTTOM positions the spreadsheet at the final entry.
HELP shows these help screens.
QUIT returns to the main menu.
TRANSACTIONS Select the DEPOSIT item to enter information on a bank
DEPOSIT deposit. Be sure to enter the date, account number,
and amount.
Keep a list of income (deposit) account numbers handy.
To make a list, select a JOURNAL printout item.
Words may be used in place of account numbers.
If the deposit amount is left blank, the data will
be ignored. The spreadsheet will be positioned under
the current bank balance.
TRANSACTIONS Select the PAYMENT item to provide information on the
PAYMENT payment of an expense. Be sure that the date, account
number and amount are entered.
Keep a list of expense (payment) account numbers handy.
To make a list, select a JOURNAL printout item.
Words may be used in place of account numbers.
If the expense amount is left blank, the data will
be ignored. The spreadsheet will be positioned under
the current bank balance.
TRANSACTIONS Select the SALARY item from the TRANSACTIONS menu when
SALARY you pay a salary. Tax and FICA are not computed, but
may be entered on the input screen.
If the gross salary is left blank, the data will be
ignored. The spreadsheet will be positioned under the
current bank balance.
If the gross salary does not equal the net salary plus
the deductions, the entries must be modified.
Information may be extracted by Employee ID. Use numbers
different from account numbers.
TRANSACTIONS The RECONCILE item allows the spreadsheet entries
RECONCILE to be reconciled with the bank statement. Invoke
this each time you get a new bank statement, after
all the month's information is entered.
After an initial setup, the spreadsheet will be
positioned on an empty entry in the MONTH column.
An entry from 1 to 12 indicates which month the item
was processed by the bank. Either leave the cell empty
or type in a number from 1 to 12, followed by the
ENTER key.
Pressing ENTER until reaching the end of the spreadsheet
is the only way to complete reconciliation.
HELP From the main menu, select the HELP item to get help
on the commands. This screen is the help screen on HELP.
Use the PAGE UP and PAGE DOWN keys to go between the
help screens. Press the ENTER key to return to the
menu from which you requested help.
From 1-2-3 READY mode, press the ALT A key to return
to the main accounting menu.
JOURNAL When the JOURNAL item is selected from the main menu,
the following JOURNAL menu is displayed:
1-2-3 Balance Modify Clear Normal Sideways Help Quit
1-2-3 enters 1-2-3 (R) READY mode.
BALANCE will balance all accounts, verifying entries.
MODIFY adds new account numbers or changes sort criteria.
CLEAR erases all deposit and payment information. (BEWARE !)
NORMAL performs a journal listing on a printer.
SIDEWAYS performs a SIDEWAYS(R) journal listing.
HELP shows these help screens.
QUIT returns to the main menu.
JOURNAL After entering the information for each month, the BALANCE
BALANCE item should be selected. All account information in the
journal will be transferred to income and expense ledgers.
Total deposits will be compared against income accounts.
Total payments will be compared against expense accounts.
Improper account numbers must be corrected.
Change any of the account names and/or numbers to
correspond to your chart of accounts. Add new account
numbers with the JOURNAL MODIFY command.
JOURNAL When the MODIFY item is selected from the JOURNAL menu,
MODIFY the following JOURNAL MODIFY menu is displayed:
1-2-3 Expense Income Sort Help Quit
1-2-3 enters 1-2-3 (R) READY mode.
EXPENSE adds a new expense account number and name.
INCOME adds a new income account number and name.
SORT toggles between showing accounts by number or name.
HELP shows these help screens.
QUIT returns to the main menu.
JOURNAL Selection of the EXPENSE item from the JOURNAL MODIFY menu
MODIFY allows you to add a new expense account number and name
EXPENSE to the list of expense account numbers. After adding the
new number and name, the list is sorted.
If no account number is given, the command is ignored.
The spreadsheet will be positioned to show expense
ledger entries.
Use account numbers if your accountant prefers them. It
is easier to remember single, short words to identify the
account. Set up your accounts with words if you prefer.
JOURNAL Selection of the INCOME item from the JOURNAL MODIFY menu
MODIFY allows you to add a new income account number and name
INCOME to the list of income account numbers. After adding the
new number and name, the list is sorted.
If no account number is given, the command is ignored.
The spreadsheet will be positioned to show income
ledger entries.
Use account numbers if your accountant prefers them. It
is easier to remember single, short words to identify the
account. Set up your accounts with words if you prefer.
JOURNAL Selection of the SORT item from the JOURNAL MODIFY menu
MODIFY changes the way in which the deposit and expense account
SORT entries are sorted. If they are currently sorted by
account number, they will be resorted alphabetically by
name. If now sorted by name, they will be resorted by
number.
This command has no impact on the information in
the ledger, only on how it is displayed.
JOURNAL Selection of JOURNAL CLEAR will erase all spreadsheet data.
CLEAR
All data will be lost by using this command.
The initial date and account balance must be set.
A new file name for the spreadsheet will be requested.
A new business name for the title will be requested.
Use this command to start a new year or checking account.
JOURNAL To make a printout of the spreadsheet, select the JOURNAL
NORMAL item from the main menu. If SIDEWAYS(R) is loaded, you
may use the SIDEWAYS print item from the JOURNAL menu.
Otherwise, select the NORMAL item for a normal printout
using the using 1-2-3 (R) print defaults.
For JOURNAL NORMAL printouts only, a header will be
automatically generated with business name and date.
Before using this template, be sure that 1-2-3 is set
up properly for your printer.
JOURNAL To make a printout of the spreadsheet, select the JOURNAL
SIDEWAYS item from the main menu. If SIDEWAYS(R) is loaded, you
may use the SIDEWAYS print item from the JOURNAL menu.
Otherwise, select the NORMAL item for a normal printout
using the using 1-2-3 (R) print defaults.
This product does not come with SIDEWAYS(R) which must
be purchased separately if desired. SIDEWAYS(R) is
a registered trademark of Funk Software, Inc.
The SIDEWAYS(R) add-in must be attached as ALT-F7 or app1
before invoking SIDEWAYS options or else the template may
be corrupted. Be sure to configure SIDEWAYS(R).
EXTRACT Selection of the EXTRACT option from the main menu
results in the display of the following menu:
1-2-3 Input Normal Sideways Up Down Help Quit
1-2-3 enters 1-2-3 (R) READY mode.
INPUT allows you to select one account number to view.
NORMAL generates a normal printout for that account number.
SIDEWAYS produces a sideways printout.
UP shows the previous screen up when there is one.
DOWN shows the next screen down.
HELP shows these help screens.
QUIT returns to the main menu.
EXTRACT The EXTRACT INPUT command allows a set of journal entries
INPUT with the same account number to be viewed. The account
number will first be requested. The previous display will
be erased before the new display is shown.
If an employee ID number is given instead of an expense or
deposit account number, the information on salary for that
employee will be extracted.
An optional starting date and/or ending date may be given.
If a starting date is given, no entry before the starting
date will be extracted. If an ending date is given, no
entry after the ending date will be extracted. The default
is to extract entries without regard to the date.
EXTRACT After the EXTRACT INPUT command has been given to extract
NORMAL the information on one account number, that information may
be printed out on the printer. Use the EXTRACT NORMAL
command to get a normal printout. Use the EXTRACT SIDEWAYS
command to get a sideways printout
For EXTRACT NORMAL printouts only, a header will be
automatically generated with business name and date.
Before using this template, be sure that 1-2-3 is set
up properly for your printer.
EXTRACT After the EXTRACT INPUT command has been given to extract
SIDEWAYS the information on one account number, that information may
be printed out on the printer. Use the EXTRACT NORMAL
command to get a normal printout. Use the EXTRACT SIDEWAYS
command to get a sideways printout
This product does not come with SIDEWAYS(R) which must
be purchased separately if desired. SIDEWAYS(R) is
a registered trademark of Funk Software, Inc.
The SIDEWAYS(R) add-in must be attached as ALT-F7 or app1
before invoking SIDEWAYS options or else the template may
be corrupted. Be sure to configure SIDEWAYS(R) for your
printer.
EXTRACT Extracted account information can sometimes fill more than
UP one screen. When this happens, use the EXTRACT UP command
and the EXTRACT DOWN command to view different parts of the
extracted information without entering 1-2-3 (R) READY
mode.
Use this command only when extracted information is
visible on the screen.
EXTRACT Extracted account information can sometimes fill more than
DOWN one screen. When this happens, use the EXTRACT DOWN
command and the EXTRACT UP command to view different parts
of the extracted information without entering 1-2-3 (R)
READY mode.
Use this command only when extracted information is
visible on the screen.