home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
finance
/
cashc10.zip
/
DOCFILE3.TXT
< prev
next >
Wrap
Text File
|
1993-06-01
|
42KB
|
1,086 lines
-----------------------------------------------------------------------------
| |
| |
| Reports |
| |
| |
-----------------------------------------------------------------------------
.pa
5.1
-----------------------------------------------------------------------------
| Reports |
| |
| The Checkbook Register. |
| |
| |
-----------------------------------------------------------------------------
5.1 Enter starting date for the report.
Use the Plus and Minus keys to change the starting date. Press the
Enter key on the desired date.
Special keys included in the reports date that are not found in
other areas of the program.
+ = Go ahead one day.
- = Go back one day.
* = Go back one month.
/ = Start at beginning of year.
> = Go forward one month.
The date selected will remain in memory until changed again.
5.2 Report features.
The checkbook register lists all the entries to the checkbook
including checks, deposits, debits, and credits. The report will
start at the date selected. The balance shown at the end is correct
regardless of the starting date used.
-----------------------------------------------------------------------------
| Number Date Description Check Deposit Balance |
|---------------------------------------------------------------------------|
| 6601 01-01-1993 Pizza Hut 18.50 0.00 481.50 |
| 6602 01-03-1993 Super Value 89.77 0.00 391.73 |
| 6603 01-05-1993 Cenex Gas Station 15.00 0.00 376.73 |
| 0 01-08-1993 Deposit 0.00 500.00 876.73 |
| 6604 01-10-1993 Chi Chis 36.00 0.00 840.73 |
| 6605 01-15-1993 First National Bank 330.00 0.00 510.73 |
| |
| |
-----------------------------------------------------------------------------
Press the Enter key to advance the page.
Press the Escape key to exit.
Set the print option to ON to print the report.
.pa
5.3
-----------------------------------------------------------------------------
| Reports |
| |
| Single Check Detail View. |
| |
| |
-----------------------------------------------------------------------------
5.3 Enter the check number.
Enter the check or record number to view the check in detail.
Review the register to locate the correct number.
5.4 Viewing the check.
This option is used to view all the information on a check.
Information such as Invoice numbers or Memos can only be viewed
by viewing the single check.
Print the check by turning the print option ON or by pressing
the print screen key.
5.5
-----------------------------------------------------------------------------
| Reports |
| |
| View Register by Account or Flag |
| |
| |
-----------------------------------------------------------------------------
5.5 Enter the Account number
Enter the account number or press the F6 key to select the account
from a list. Use the arrow keys to highlight the correct account
and press the enter key.
Press the Enter key with no entry to advance to the Flag line.
.pa
5.6 Enter the Account Flag.
Enter the flag letter or press the F6 key to select the flag
from a list. Use the arrow keys to highlight the correct flag
and press the enter key.
A null entry on both lines will exit back to the main menu.
5.7 Viewing the report.
The report will list all checks with the account or flag attached
to the record.
Example
If you selected an account for utilities, all the
checks to the power, gas, water, and phone are
listed because you entered that code for each as the
check was entered.
-----------------------------------------------------------------------------
| Number Date Description Check Account |
|---------------------------------------------------------------------------|
| 6610 01-16-1993 Northern States Power 138.50 138.50 |
| 6677 02-12-1993 Grand Forks Water Dept. 32.22 32.22 |
| 6743 03-15-1993 Northwestern Bell 66.10 32.13 |
| 6744 03-15-1993 U.S. Sprint 22.64 22.64 |
| 6792 04-21-1993 Northern States Power 110.10 110.10 |
| 6801 04-30-1993 Northwestern Bell 75.41 35.20 |
| |
| |
-----------------------------------------------------------------------------
Press the Enter key to advance the page.
Press the Escape key to exit.
Set the print option to ON to print the report.
.pa
5.8
-----------------------------------------------------------------------------
| Reports |
| |
| View the Deposits and Budget Balance. |
| |
| |
-----------------------------------------------------------------------------
5.8 Select the starting date.
Use the Plus and Minus keys to change the starting date. Press the
Enter key on the desired date.
Special keys included in the reports date that are not found in
other areas of the program.
+ = Go ahead one day.
- = Go back one day.
* = Go back one month.
/ = Start at beginning of year.
> = Go forward one month.
The date selected will remain in memory until changed again.
.pa
5.9 Review the report
The report lists the dates and amounts for each deposit or
credit. The four budget account amounts are shown for each deposit.
The Net total on the right is the amount added to the checkbook
to write checks against. The totals at the bottom are for each
Budget Account balance.
-----------------------------------------------------------------------------
| Date Deposit ACT.1 ACT.2 ACT.3 ACT.4 NET |
|---------------------------------------------------------------------------|
| 01-07-1993 500.00 0.00 10.00 0.00 20.00 470.00 |
| 01-15-1993 1000.00 50.00 50.00 50.00 50.00 800.00 |
| 02-01-1993 500.00 0.00 50.00 0.00 50.00 400.00 |
| 02-15-1993 1000.00 100.00 0.00 100.00 0.00 800.00 |
| ........ |
| ........ |
| ........ |
| 3000.00 150.00 110.00 150.00 120.00 2470.00 |
-----------------------------------------------------------------------------
Press the Enter key to advance the page.
Press the Escape key to exit.
Set the print option to ON to print the report.
5.10
-----------------------------------------------------------------------------
| Reports |
| |
| Report the Expense Account Totals. |
| |
| |
-----------------------------------------------------------------------------
5.10 Viewing the report.
This report produces a total for each Expense Account. The break
down by account is used to report the totals for each account.
Print a copy of the Expense totals at the End of the year to complete
your tax return.
.pa
5.11
-----------------------------------------------------------------------------
| Reports |
| |
| Report the Deposit Account Totals. |
| |
| |
-----------------------------------------------------------------------------
5.11 Viewing the report.
This report produces a total for each Deposit Account. The break
down by account is used to report the totals for each account.
Print a copy of the Income totals at the End of the year to complete
your tax return.
5.12
-----------------------------------------------------------------------------
| Reports |
| |
| The Record Listing. |
| |
| |
-----------------------------------------------------------------------------
5.12 Viewing the report.
The Record listing is used to locate the absolute file position
of a check or debit. A item with a duplicate number is edited
by record number. The record numbers are displayed on the left side
of the report. They start at number one and continue to the end of
the file.
.pa
5.13
-----------------------------------------------------------------------------
| Reports |
| |
| Printer Status. |
| |
| |
-----------------------------------------------------------------------------
5.13 Inspect printer.
When using one printer to do both checks and reports, please
inspect the printer before printing. Do not start printing checks
on blank paper and reports over your checks. There is no way for
the program to know the type of form loaded in the printer.
5.14 Turn on the printer.
Select the Printer Status option from the Reports menu. A option
box will display the current settings. Press the letter ( P ) to
turn the printer On or Off. The Status will change each time the
letter is pressed.
When turning the printer ON a second Warning box prompts inspection
of the printer. Press the Plus key ( + ) to turn the Header option
on. The Header will print the checkbook information on the top of
each printed report.
--------------------------------------
| Printer Status On / Off |
| |
| |
| |
| Printer is : OFF |
| |
| |
| Header is : Off |
| |
| |
| |
| ESC = No Change P = Change |
| |
--------------------------------------
.pa
5.15 Print Header on Report.
Set the Header option by pressing the plus key (+) while viewing
this screen. The Header will be printed at the beginning of each
report.
--------------------------------------
| Warning Message |
| |
| |
| Check paper .............. |
| ..... |
| |
| |
| |
| Enter a ( + ) to include |
| a header on reports. |
| |
| |
| |
--------------------------------------
Please see the Appendix for more information on loading checks in
the printer.
.pa
-----------------------------------------------------------------------------
| |
| |
| Accounts |
| |
| |
-----------------------------------------------------------------------------
.pa
6.1
-----------------------------------------------------------------------------
| Accounts |
| |
| Accounts Payable Database. |
| |
| |
-----------------------------------------------------------------------------
6.1 Locating a record.
All records added to the database are in sequential order. The first
record is number one, the second is number two and so on. A record
is recalled by the number or by selecting the first line title
from a list.
6.2 Using the F keys
--------------
| # |
| |
| _______ | Type the record number on the line and press
| | the Enter key.
| F5 = New |
| | Press F5 to create a new entry in the database.
| F6 = List |
| | Press F6 to select a record from a list.
| F10 = Exit |
| | Press F10 to exit to the main menu.
| |
| |
| |
--------------
6.3 Enter or edit lines.
The Up and Down arrow keys move the cursor from one line to the next.
Pressing the Enter key saves the changes for each line. Press the
Enter key to the end of the page to exit.
The Escape key will exit without saving.
.pa
The information typed on the five lines is printed on the check
in a position to appear in a windowed envelope. All five lines will
appear in the window. It doesn't make a difference what is on each
line although the top line is used for the description in the F6
menu. The top line therefore should always be the name line.
-----------------------------------------------
| Accounts Payable Database |
| |
| |
Name | --------------------------------------- |
| |
Address | --------------------------------------- |
| |
City | --------------------------------------- |
| |
State | --------------------------------------- |
| |
Zip Code | --------------------------------------- |
| |
| -- -- -------- |
| |
-----------------------------------------------
^ ^ ^
Account Flag Amount
6.4 Account Flag and Amount.
The account, flag, and amount are printed on the computer screen
under the name and address lines when checks are being entered. They
serve as a reference when checks are entered. As you enter the check
amount, notice the amount under the address. This is the amount entered
in this portion of the program as a future reminder. Likewise the flag
and account number reminders are for a check when it is repeated.
Example
The local bank may have the same expense account, flag, and amount
when you write the check each month for a car payment. The amount
of the payments are the same, the account they are expensed to
are the same and the flag may or may not be the same.
6.5 Special Considerations.
The reminder numbers are not entered into the appropriate fields
automatically. The numbers are entered by the user. The reminder
numbers are used to be consistent in the expense account used
for checks written.
.pa
6.6
-----------------------------------------------------------------------------
| Accounts |
| |
| Viewing the Expense Accounts Codes. |
| |
| |
-----------------------------------------------------------------------------
6.6 Review the list.
This menu item is provided a quick reference of current expense
account codes. The menu will only display the items. The Expense
codes are changed with an ASCII editor. Please view the Install
section for more information on editing the Account codes.
6.7
-----------------------------------------------------------------------------
| Accounts |
| |
| Viewing the Flag Accounts Codes. |
| |
| |
-----------------------------------------------------------------------------
6.7 Review the list.
This menu item is provided a quick reference of current flag
account codes. The menu will only display the items. The Flag
codes are changed with an ASCII editor. Please view the Install
section for more information on editing the Account codes.
Please view section 1.6 in Checks for further information.
.pa
6.8
-----------------------------------------------------------------------------
| Accounts |
| |
| Viewing the Deposit Accounts Codes. |
| |
| |
-----------------------------------------------------------------------------
6.8 Review the list.
This menu item is provided a quick reference of current deposit
account codes. The menu will only display the items. The Deposit
codes are changed with an ASCII editor. Please view the Install
section for more information on editing the Account codes.
6.9
-----------------------------------------------------------------------------
| Accounts |
| |
| Printing Accounts Payable Reference. |
| |
| |
-----------------------------------------------------------------------------
6.9 Inspect Printer
When using one printer to do both checks and reports, please
inspect the printer before printing. Do not start printing checks
on blank paper and reports over your checks. There is no way for
the program to know the type of form loaded in the printer.
6.10 Printing the Report.
This option will print a guide book of codes and names used in check
entry. To expedite bill paying look up the code for each check to
print and write the code number on the bill. When paying a stack of
bills simply type in the code number for the name and address, the
amount and account, any general information.
This report will print without the Printer Status ( On / Off ) being
changed in the Reports menu.
Note: If you print this report before data has been entered to the
program, it will print a header and a blank report page.
.pa
6.11
-----------------------------------------------------------------------------
| Accounts |
| |
| Printing Income and Expense Code Reference Guide. |
| |
| |
-----------------------------------------------------------------------------
6.11 Inspect Printer
When using one printer to do both checks and reports, please
inspect the printer before printing. Do not start printing checks
on blank paper and reports over your checks. There is no way for
the program to know the type of form loaded in the printer.
6.12 Printing the Report.
This option will print a guide book of expense codes used in check
entry. To expedite bill paying look up the code for each check to
print and write the code number on the bill. When paying a stack
of bills simply type in the code number for the expense and enter the
bill in a batch run.
This report will print without the Printer Status being changed in
the Reports menu.
.pa
-----------------------------------------------------------------------------
| |
| |
| Exit |
| |
| |
-----------------------------------------------------------------------------
.pa
7.1
-----------------------------------------------------------------------------
| Exit |
| |
| Exit Program. |
| |
| |
-----------------------------------------------------------------------------
7.1 End Session
This is the proper way to end the program. Exiting the program in
any other manor may result in data loss. Always leave the disk in
the drive until the program terminates. Files may by updated and
closed before the program ends.
Your data is very important. Always make a backup of the data
after using the checkbook.
7.2
-----------------------------------------------------------------------------
| Exit |
| |
| Setup Values. |
| |
| |
-----------------------------------------------------------------------------
7.2 View Startup Values.
The starting balance and starting check number are provided here
as a reference. In business it is sometimes necessary to know
the beginning balance. This option provides a quick view of the
values set in the initial setup of the program.
The starting check number will only affect the first check written
in the checkbook. Otherwise any change would not affect the program.
.pa
7.3 Other Information
This screen also displays the setup values of the checkbook. The
data lengths declared in the install program are presented as
a reference. The Cash Control program will adjust the size of
the files if space is needed.
The Percentage Full indicator displays a percentage of the database
size used. A percentage of 25% would mean the database is one quarter
full.
7.4
-----------------------------------------------------------------------------
| Exit |
| |
| Checkbook Information |
| |
| |
-----------------------------------------------------------------------------
7.4 Enter or Edit Information.
Enter the specific information requested for each line. Press the
key to proceed. Use the arrow keys to move up and down or left and
right. Use the information as a quick reference to the bank name
and account number.
7.5 Report Headers
A copy of the Checkbook Information header is printed on each report
by invoking the option in the Printer Status under Reports.
Use this option to identify more than one account on a computer
system. Please view the Appendix for further information on
multiple checkbooks.
.pa
7.6
-----------------------------------------------------------------------------
| Exit |
| |
| Password |
| |
| |
-----------------------------------------------------------------------------
Cash Control Password security system does not protect the data
from being accessed with another program. The security system is
designed to deny access to users of the Cash Control program without
a correct password match. Other software may be able to read the
Cash Control data files. Protect your computer by using the key lock
and DOS password protection. Keep all data backup disks in a secure
place to prevent unauthorized copy.
7.6 Password Security.
The password for the program is ( cash ) in lower case. The
password remains in effect until changed by the user.
( Note ) When using the Batch file to load the
password, be sure the BAT file is edited to reflect
any change in the password. Batch file password loading
assumes that no security is wanted. The program will load
when any user loads the program. A password must be entered
by the user when installing the program.
The password is case sensitive. This means the word typed in as a
password must be typed with the upper case or lower case letters in
mind.
Example
The following are five different passwords.
CASH
cash
caSh
Cash
casH
( Notice the position of the upper case letters. )
A password must by typed in exactly as it was created.
.pa
7.7 Changing the password.
Select the option from the Exit menu. Enter the old password. After
a moment to verify the program will ask for the new password. Be
very careful to enter the password correctly.
7.8 Recover lost password
The password is scrambled with a random number in the file
CHECKSP.DAT.
If you forget the password, copy the file CHECKSP.DAT from the
master to the Cash Control directory and open the program using
( cash ) password. Put the master disk and all backup disks in
a safe place to prevent others from using the data file to gain
entrance.
Do not copy other files as they would replace your files and
destroy the data.
7.9
-----------------------------------------------------------------------------
| Exit |
| |
| Backup Data |
| |
| |
-----------------------------------------------------------------------------
7.9 Making a Data disk backup.
Place a blank formatted disk in the floppy disk drive ( A ) or ( B ).
If the backup files are to be copied to a subdirectory the sub-
directory should be created in advance. The program will not create
a sub directory.
Select the Backup option from the Exit menu.
The program files are copied to the backup disk.
The option terminates to the main menu when it is complete.
Place the backup disk is a safe location to prevent theft.
Note: If you are running the Cash Control program from a Shell
program, the copy option may abort. This option requires more
memory than normal program operation. If it fails try running
the backup from DOS.
.pa
7.10 Recovering data from the Backup Disk.
Always Write Protect the data disk before starting.
Place the data disk in the floppy drive. Log the destination drive
and directory.
Use the DOS copy to transfer the files back to the working area.
Example
Working Area ...... C:\CASH
Backup Disk ...... B:
From the Working Area type COPY B:*.*
The program files on the backup disk will overwrite the
files in the Working Area.
Be very careful to understand the DOS COPY before using it. A
file copy program is recommended.
7.11 System for Backup
Make a backup disk each time there are changes in the checkbook.
A daily pattern is best when the checkbook gets daily use.
A rotation system is also a good idea. Use three disks and always
rotate the disk used for backup.
.pa
7.12
-----------------------------------------------------------------------------
| Exit |
| |
| Color Selection |
| |
| |
-----------------------------------------------------------------------------
7.12 Color or Monochrome
Cash Control reads the monitor type as the program loads. A
monochrome system will not have the color option on the Exit menu.
7.13 Selecting a color file.
Cash Control has eight different color files to choose from. The
color files are preset for eight different color combinations. Most
users will find a color that is pleasant to the eye.
The color attributes are stored in the eight files beginning with
the letter ( C.CL1 ) through ( C.CL8 ).
Select a file by number. Enter the number to the left of the
description.
.pa
Appendix
========
A) Printed Checks
Cash Control prints Accounts Payable tractor feed checks. The checks
can be ordered from Deluxe Business Forms. You will need the
following information to place an order.
1) Your Account Number.
2) The Bank Number.
3) Full Name & Address Information.
4) Starting Check Number.
5) Product Numbers
Accounts Payable Check 9 1/2 by 7 # 00091002 ( 1 Part )
Double Window Envelope 8 # 00091500
6) Double Signature line ( If needed )
7) Title over signature.
Write to
Deluxe Business Forms
P.O. Box 35100
Colorado Springs, CO.
80935-3510
Or Call
1-800-328-0304
Fax
1-800-336-1112
How to load the printer
The first line prints one inch down on the stub portion of the
check. Each printer has its own problems when loading the checks
and getting them aligned correctly. You may have to waist a check
by printing it and observing the position. Make any adjustments
and waist another check to test the results.
A less waistefull option is to install the program in a different
directory to use for testing. By doing this you won't have to
edit out the voided checks as the data will be contrived for
test purposes only.
.pa
You may also elect to use blank paper to print the test on and
hold the printed results next to the actual checks to see if
the lines are printing correctly.
Once you have determined how to load the checks and align them
correctly, make a note of your procedure.
Some printers require a lead sheet to be attached to the first
check. The lead sheet has a gum strip on top to press against
the first check and roll it through the tractor feeds. Printers
with the tractor feeds a couple inches higher than the print
head need a lead sheet or else the fist check in a batch is
always wasted.
Printers that have the sheet feed option need to be set for
continuous form paper. Consult the manual that came with your
printer to determine the hardware configuration necessary.
Ink Jet printers do not print well on polished surface paper
such as checks. The smooth surface causes the ink to splash
back on the print head and will require frequent cleaning.
B) End of Year Processing
The Cash Control program should be used for ones years data.
At the end of the year a backup should be made to preserve the
totals. Use a copy program to place the entire contents of
the directory on a disk or disks. Computers with disk drives
larger than 360k will often be able to copy the files to a single
disk. Mark the disk and put it in a safe place.
Make printouts of your expenses and deposits for tax purposes.
Take note of the final checkbook balance as it will be the
beginning balance of the next years checkbook.
After all the backups are made and the reports are printed
you are ready to initialize a new checkbook for the next year.
Run the install program by typing CHECK INSTALL. The first
option of the install program allows you to erase the check
and deposit files. Do not erase the Accounts Payable file as
this is the file that has all the names and addresses you
will be writing checks to again in the new year.
Install option two allows you to edit the starting balance and
starting check number. Enter the ending balance and the next
check number as they will be different.
With these steps taken the program should be ready to begin a
new year.
.pa
When the statement arrives from you bank, make sure all items
from the previous year are cleared. Run the balance program
on the backup disk to clear each item. Review the year by
paging up and down to be sure there are no outstanding items.
Any outstanding check or deposit in last years checkbook
will cause the new checkbook not to balance. Once you are
sure there is no outstanding items you may exit the balance
program. Any credits or service charges you enter to the
old year will change the ending balance. Be sure the ending
balance of your previous year and the beginning balance of the
new year are the same.
Continue the process by running the balance program in the
new years checkbook. Clear any checks or deposits on the
statement that were entered after January 1. The statement
balance should match the banks statement when all items
are properly cleared and debits and credits are entered.
C) Errors & Problems
The following are a few problems the beta testers found while
using the Cash Control program. They are passed along to you
to help prevent an error while using Cash Control.
1) Writing two checks with the same number.
The Cash Control program does not check each number to see
if it was entered before. The program assumes that if you
hand write a check or print it on the computer, the check
number will only be used once. When checks are written
out of order the program looks at the last number entered and
assumes the next number will be that number plus one. If
you were to enter check number 100 and then enter check number
99, the program would advance the 99 and tell you the
next check number is 100 again. Please verify the check entry
on your computer with the actual check as it is entered.
2) You forgot to turn the check printer on.
You entered a check in the program and pressed the F5 or F10
key to complete the check and suddenly realized that you wanted
to print the check. The check is in the checkbook on the computer
yet the actual check is sitting in the printer unprinted. Select
the Edit check option and locate the check. Press the enter key
through the entry lines to the end of the check. A final screen
allows you to force the printing of a previous check. Proceed
with any other check entries in the normal manor.
.pa
3) Data files larger than the data disk.
If the program is setup with long file lengths it can create
data files so large that the backup option of this program
can not send them to a single disk. If large data files
are necessary you may have to use a file copy program to
backup each file on a separate disk. The backup option of
this program does not pause for multiple disks or divide
single files into smaller sizes.
Authors Note:
I just want to say thanks to my wife Debbie and my kids
Michael and Michelle for putting up with a guy who spent
hundreds of hours working on this program. Without their
support I could never have finished.
Thank you Kerry Jaeger for your consultations all for
a fee of a Marg at Chi Chis.
Thank you Mike Harvey of Dakota Shores Programming for
being the excellent programmer and beta tester you are.
Thank You
Rick Engen
Pipedream Software
