The Arcade BBS

home *** CD-ROM | disk | FTP | other *** search

/ The Arcade BBS / arcadebbs.zip / arcadebbs / MISC / CHECKS2.ZIP / CHECKS.2 < prev next >

Wrap

Text File | 1989-11-01 | 57.5 KB | 1,321 lines

Checkbook Management Program You have duplicated a check number. This is possible either by mistake, or because you have changed banks, or because this check is split between two or more budget categories. The date associated with each check with this number is displayed. Find the date of the one you want and enter its location on the list. If you really want the second one on the list, press <2> then <enter>. The correct one will appear on the screen in the same format as case 3 below. If none of these is correct, press <0> then <enter> and you will return to the Correction Menu. If you enter a number larger than the list is long (for example, you enter 4 and there are only 3 dates on the screen), you will receive a warning that the number is out of range. Please reenter your selection, keeping within the range. If more than 10 checks with this number are found, only the first ten occurrences will appear on the screen. Case 3: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Correcting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Check Check Number xxxx ║ ║ ║ ║ Date xx/xx/xx ║ ║ ║ ║ To Whom XXXXXXXXXXXXXXXXXXXXXXXXXXXXX Amount __xxx.xx ║ ║ ║ ║ Memo XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ║ ║ ║ ║ Budget Category XXXXXXXXXX ║ ║ ║ ║ Cleared the bank NO_ ║ ║ ║ ║ Keep? (Y/N) X ║ ╚══════════════════════════════════════════════════════════╝ The screen will be displaying the check you requested. You may now use the arrow keys to make any changes you need to for this check. When satisfied with the changes, position the cursor on the box following keep and press <enter> or <Y>. This will change the check in the file to match the one on the screen, then return you to the Correction menu. If the amount is left zero when you indicate you are satisfied with the check, you will be asked if you want to void, edit, or quit. Void will enter the check with a zero amount. Edit will allow you to change the check as it appears. Quit will ignore any changes made. If you don't want to change this one, or make a mistake and change the wrong items, position the cursor on the box following keep and press <N>. This will return you to the Correction menu without making any changes to the check on the file. Page 18 Checkbook Management Program Correct Other Transactions Non-check transactions have the same general correction process. They are grouped here for convenience. When correcting a non-check transactions (Deposit, Auto-Teller Withdrawal, Auto-Teller Deposit, Bank Charge, or Interest), the screen changes to the following: ╔══════════════════════════════════════════════════════════╗ ║ Correcting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date? __/__/__ ║ ╚══════════════════════════════════════════════════════════╝ The phrase [transaction type] will be replaced with the actual type chosen (Deposit, Automatic Teller Withdrawal, Automatic Teller Deposit, Bank Charge, or Interest). Enter the date on the transaction you want to correct. It must be a valid date (February 30 is not a valid date), and must match the one on the actual transaction as it appears in the file. Press <enter> when the date is correct. The program searches for the proper transaction type with that date. There are three possible outcomes to this search. 1. The requested transaction is not found. 2. More than one transaction of that type for that date is found. 3. The requested transaction is found. Case 1: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Correcting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Not found ║ ╚══════════════════════════════════════════════════════════╝ Check the date you entered. It must be an exact match. Press any key to continue. The screen will clear and you will see the Correction menu. Case 2: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Correcting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ More than one found. Indicate which you want (1, 2, 3..)║ ║ ║ ║ xxx.xx ║ ║ xx.xx ║ ║ xxxx.xx ║ ╚══════════════════════════════════════════════════════════╝ Page 19 Checkbook Management Program You have more than one transaction of this type for that date. The amounts for all such transactions made on that day are displayed. Select the one you want. If you want the first on the list, press <1> then <enter>. If the one you want isn't on this list, press <0> then <enter>. The one selected will appear on the screen in the same form as case 3 below. If you enter a number larger than the list is long (for example, you enter 4 and there are only 3 amounts on the screen), you will receive a warning that the number is out of range. Please reenter your selection, keeping within the range. Up to forty transactions may appear. If you have more than forty transactions of this type for this date, only the first forty will be shown. Case 3: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Correcting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date xx/xx/xx Amount ___xxx.xx ║ ║ ║ ║ Category XXXXXXXXXX ║ ║ ║ ║ Memo xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ║ ║ ║ ║ Cleared the bank NO_ ║ ║ ║ ║ Keep? (Y/N) X ║ ╚══════════════════════════════════════════════════════════╝ The screen will be displaying the transaction you requested. You may now use the arrow keys to make any changes you need to for this transaction. When satisfied with the changes, position the cursor on the box following keep and press <enter> or <Y>. This will change the transaction in the file to match the one on the screen, then return you to the Correction menu. If the amount is left zero when you indicate you are satisfied with the transaction, you will be asked if you want to void, edit, or quit. Void will enter the transaction with a zero amount. Edit will allow you to change the transaction as it appears. Quit will ignore any changes made. If you don't want to change this one, or make a mistake and change the wrong items, position the cursor on the box following keep and press <N>. This will return you to the Correction menu without making any changes to the transaction in the file. Page 20 Checkbook Management Program Deletions This option allows you to remove a specific transaction or remove obsolete records. The Deletion menu will ask you to specify which you want. If a specific transaction is deleted, the amount of that transaction is removed completely. If it was a debit, the amount will return to your account. If it was a credit, the amount will be removed from your balance. The requested record will be displayed and you must verify it is the one to be deleted. Once deleted, a record cannot be reactivated. If the Delete All option is selected, you will be asked to specify a date. All cleared transactions with dates prior to that date will be deleted. It is strongly recommended that you make a back-up copy of the data files before using this option. Once deleted, the records cannot be recovered. They may be reentered. The Deletion menu: ╔═══════════════════════════════════════════════════════════════════╗ ║ Checkbook Management Program ║ ║Account: (account name) Deletion Menu║ ║Current Balance: xxxxx.xx ║ ║ ║ ║ ╔════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ (Q)uit ║ ║ ║ ║ (1) Delete Check ║ ║ ║ ║ (2) Delete Deposit ║ ║ ║ ║ (3) Delete Auto-Teller Withdrawal ║ ║ ║ ║ (4) Delete Auto-Teller Deposit ║ ║ ║ ║ (5) Delete Bank Charge ║ ║ ║ ║ (6) Delete Interest ║ ║ ║ ║ (7) Delete all before specified date ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════╝ ║ ║ ║ ║ Enter your choice: _ ║ ╚═══════════════════════════════════════════════════════════════════╝ When this menu first appears, the first option (Quit) is highlighted in reverse video. Use the arrow keys (up and down) to maneuver the highlighting to the option you want. Press <enter> when the option you wish is highlighted. As an alternate on this menu, you may press the number in parentheses to select the option associated with that letter. For example, to delete an interest entry, either move the highlighting to the line saying Delete Interest and press <enter> or press <6> only. The options on this menu are: Quit - Return to the Main Menu. Delete Check - Delete a check. Delete Deposit - Delete a deposit. Delete Auto-Teller Withdrawal - Delete an automatic teller withdrawal. Page 21 Checkbook Management Program Delete Auto-Teller Deposit - Delete an automatic teller deposit. Delete Bank Charge - Delete a bank service or other charge. Delete Interest - Delete an interest entry (NOW accounts). Delete all before specified date - Delete all transactions with dates which are earlier than the date you will be asked to provide. Delete a Check When this option is chosen, the screen changes to the following: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Check ║ ║ ║ ║ Check Number? ______ ║ ╚══════════════════════════════════════════════════════════╝ Enter the number of the check you want to delete. Five characters are allowed. Press <enter> when finished. The program searches for the check with that number. There are three possible outcomes to this search. 1. The check is not found. 2. More than one check with that number is found. 3. The check is found. Case 1: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Check ║ ║ ║ ║ Check Number? XXXXX ║ ║ ║ ║ Not found ║ ╚══════════════════════════════════════════════════════════╝ Check the number you entered. Alignment in the field must be exactly as it was when you entered the check in the first place. Press any key to continue. The screen will clear and you will see the Deletion menu. Page 22 Checkbook Management Program Case 2: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Check ║ ║ ║ ║ More than one found. Indicate which you want (1, 2, 3..)║ ║ ║ ║ xx/xx/xx ║ ║ xx/xx/xx ║ ╚══════════════════════════════════════════════════════════╝ You have duplicated a check number. This is possible either by mistake, or because you have changed banks, or because this check is split between two or more budget categories. The date associated with each check with this number is displayed. Find the date of the one you want and enter its location on the list. If you really want the second one on the list, press <2> then <enter>. The correct one will appear on the screen in the same format as case 3 below. If none of these is correct, press <0> then <enter> and you will return to the Deletion Menu. If you enter a number larger than the list is long (for example, you enter 4 and there are only 3 dates on the screen), you will receive a warning that the number is out of range. Please reenter your selection, keeping within the range. If more than ten checks with this number are found, only the first ten occurrences will appear on the screen. Case 3: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ Check Check Number xxxx ║ ║ ║ ║ Date xx/xx/xx ║ ║ ║ ║ To Whom XXXXXXXXXXXXXXXXXXXXXXXXXXXXX Amount __xxx.xx ║ ║ ║ ║ Memo XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ║ ║ ║ ║ Budget Category XXXXXXXXXX ║ ║ ║ ║ Cleared the bank NO_ ║ ║ ║ ║ Delete? X Or Keep? X ║ ╚══════════════════════════════════════════════════════════╝ The screen will be displaying the check you requested. You may now use the arrow keys to move the cursor back and forth between the two boxes marked Delete and Keep. Doublecheck the details of the displayed check. If it is the one you want to delete, place the cursor in the box following Delete and press Page 23 Checkbook Management Program <enter>. If this is not the one to be deleted, place the cursor in the box following Keep and press <enter>. Once it has been deleted, it cannot be recovered. Delete Other Transactions Non-check transactions have the same general deletion process. They are grouped here for convenience. When deleting a non-check transactions (Deposit, Auto-Teller Withdrawal, Auto-Teller Deposit, Bank Charge, or Interest), the screen changes to the following: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date? __/__/__ ║ ╚══════════════════════════════════════════════════════════╝ The phrase [transaction type] will be replaced with the actual type chosen (Deposit, Automatic Teller Withdrawal, Automatic Teller Deposit, Bank Charge, or Interest). Enter the date on the transaction you want to delete (Bank Charges and Interest bear the system date of the Reconciliation which generated it). It must be a valid date (February 30 is not a valid date), and must match the one on the actual transaction as it appears in the file. Press <enter> when the date is correct. The program searches for the proper transaction type with that date. There are three possible outcomes to this search. 1. The requested transaction is not found. 2. More than one transaction of that type for that date is found. 3. The requested transaction is found. Case 1: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date? xx/xx/xx ║ ║ ║ ║ Not found ║ ╚══════════════════════════════════════════════════════════╝ Page 24 Checkbook Management Program Check the date you entered. It must be an exact match. Press any key to continue. The screen will clear and you will see the Deletion menu. Case 2: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date xx/xx/xx ║ ║ ║ ║ More than one found. Indicate which you want (1, 2, 3..)║ ║ ║ ║ xxx.xx ║ ║ xx.xx ║ ║ xxxx.xx ║ ╚══════════════════════════════════════════════════════════╝ You have more than one transaction of this type for that date. The amounts for all such transactions made on that day are displayed. Select the one you want. If you want the first on the list, press <1> then <enter>. If the one you want isn't on this list, press <0> then <enter>. The one selected will appear on the screen in the same form as case 3 below. If you enter a number larger than the list is long (for example, you enter 4 and there are only 3 amounts on the screen), you will receive a warning that the number is out of range. Please reenter your selection, keeping within the range. If more than forty transactions with this date are found, only the first forty occurrences will appear on the screen. Case 3: The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ Balance $ xxxx.xx ║ ║ ║ ║ [transaction type] ║ ║ ║ ║ Date xx/xx/xx Amount ___xxx.xx ║ ║ ║ ║ Category XXXXXXXXXX ║ ║ ║ ║ Memo xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ║ ║ ║ ║ Cleared the bank NO_ ║ ║ ║ ║ Delete? X Or Keep? X ║ ╚══════════════════════════════════════════════════════════╝ The screen will be displaying the transaction you requested. You may now use the arrow keys to move the cursor back and forth between the two boxes marked Delete and Keep. Doublecheck the details of the displayed transaction. If it is the one you want to delete, place the cursor in the box following Delete and Page 25 Checkbook Management Program press <enter>. If this is not the one to be deleted, place the cursor in the box following Keep and press <enter>. Once it has been deleted, it cannot be recovered. Delete all Before Specified Date This option is particularly unfriendly to use. It will try to keep you from destroying your account records. It's not difficult, but it will continually ask you to verify that this is what you really want to do. When this option is chosen, the screen displays this warning message: ╔══════════════════════════════════════════════════════════╗ ║ If you have not copied the data file recently, it is ║ ║ recommended that you do so before continuing. Press ║ ║ <enter> to continue, anything else to abort. ║ ╚══════════════════════════════════════════════════════════╝ This is displayed because there is no way to restore transactions once they have been deleted. If you make an error in the date, your only recourse is having a back-up copy of the data files. If your back-up copy is not identical to your working copy, please stop here and make another copy. Once that is done, return to this point and press <enter>. If you do not press <enter>, you will return to the Deletion Menu. If you do press <enter>, this is the next screen: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ ║ ║ Delete all prior to what date? __/__/__ ║ ╚══════════════════════════════════════════════════════════╝ Enter the date requested. All transactions with dates earlier than this date will be deleted in a few minutes. Those with dates identical to or later than this date will be retained. You must press <enter> at the end of the date. This will give you the chance to change it if you accidentally press the wrong key. Once the date has been entered, the screen changes to this: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ ║ ║ Delete all prior to what date? xx/xx/xx ║ ║ ║ ║ Is this date correct? (Y or N) ║ ╚══════════════════════════════════════════════════════════╝ Page 26 Checkbook Management Program You're given one last chance to verify the date. If it is the date you want, press <Y>. If you press anything else, the screen asking for the date will repeat, then this one will. Once you press <Y>, the deletion process begins. When the program is finished deleting transactions, it will display this screen: ╔══════════════════════════════════════════════════════════╗ ║ Deleting transactions for account (account name) ║ ║ ║ ║ xxx Records deleted ║ ╚══════════════════════════════════════════════════════════╝ This informs you how many transactions were actually deleted. Press any key to return to the Deletion Menu. Page 27 Checkbook Management Program Bank Statement Reconciliation This option is designed to help you reconcile the bank statement for your account each month. You can mark those transactions which have cleared the bank, enter any bank charges, service charges, or (if you have a NOW account) interest earned, and the program will use these to calculate the balance which should appear on your bank statement. That is, it takes your current balance, deducts any uncleared deposits, adds any uncleared checks, and displays the result. If the amounts do not agree, there is an option included for reviewing the transactions just cleared to see if the bank and the program disagree on the amount. This can be corrected while still in this option in an attempt to get the two amounts to agree. When this option is selected, the screen becomes: ╔══════════════════════════════════════════════════════════╗ ║ Reconciling bank statement ║ ║ Clr Check # Date To Whom Amount ║ ║ ┌┐.┌┐ . . . . ║ ║ ││.││ . . . . ║ ║ ││.││ . . . . ║ ║ └┘ └┘ ║ ║ Enter an (X) for those which have cleared the bank. ║ ║ Space or <enter> to remove an extraneous X. Use the ║ ║ arrow keys to change lines. ║ ║ Press enter here when done. X ║ ╚══════════════════════════════════════════════════════════╝ (Note: The final X on the above screen appears on the computer monitor as a solid box.) Your data file is scanned from earliest entry to latest. All transactions which have not been marked as having cleared the bank will eventually appear on this screen. Fifteen transactions are displayed at a time. The leftmost column is surrounded by solid boxes to show you where to place any X's. Use the arrow keys (up and down), home key, and end key, to position the cursor next to any transaction which has cleared the bank. Press any of the normal typewriter keys (0 - 9, A - Z, or a - z) and an X will appear next to that transaction. It is now marked as cleared. This marking is not permanently recorded until you signal you are finished with this screen. When you have finished with the transactions on the screen, position the cursor in the box at the bottom of the screen. Pressing the end key will automatically take you there. Press <enter>. This will make the markings permanent and present you with 15 uncleared transactions. Some of these may have just appeared on the last screen. Any transactions which are not marked as cleared will reappear on the next screen. One exception to this is if there were no transactions marked as cleared. In this case, the screen display will advance to the next set of 15 uncleared transactions. This gives you another chance to clear them, in case you accidentally missed some the first time. This is especially helpful if the checks you received with your statement are not sorted. If you have 15 transactions on the screen and none of them have Page 28 Checkbook Management Program cleared, place the cursor in the bottom box and press <enter> to move you on to the next set of 15 transactions. Once a transaction disappears from the screen, it will not reappear unless you return to the Main Menu and start again. After your final set of uncleared transactions, the screen will clear and the following three screens appear: ╔══════════════════════════════════════════════════════════╗ 1. ║ Service Charge ║ ║ ║ ║ Date xx/xx/xx Amount ______.00 ║ ║ ║ ║ Category BANK______ ║ ║ ║ ║ Memo ___________________________________________ ║ ║ ║ ║ Cleared the bank YES ║ ║ ║ ║ Keep? (Y/N) X ║ ╚══════════════════════════════════════════════════════════╝ If the bank charged you a service charge for this month, enter the amount here. Make any other changes you want to the transaction. Press <enter> or <Y> while the cursor is in the "Keep" box when satisfied with the screen appearance. ╔══════════════════════════════════════════════════════════╗ 2. ║ Other Charges ║ ║ (This screen repeats until the amount is left zero.) ║ ║ ║ ║ Date xx/xx/xx Amount ______.00 ║ ║ ║ ║ Category BANK______ ║ ║ ║ ║ Memo ___________________________________________ ║ ║ ║ ║ Cleared the bank YES ║ ║ ║ ║ Keep? (Y/N) X ║ ╚══════════════════════════════════════════════════════════╝ If there are any other charges (for example, new checks printed, bounced checks, etc.), enter the amount here. Make any other necessary changes. Press <enter> or <Y> when the cursor is in the "Keep" box when you are satisfied with the screen appearance. Important! This second screen will repeat until it receives a zero amount. If you have more than one extra charge, this allows you to enter each of them individually. Once you are finished, leave the amount zero and the program will continue to the third screen. Page 29 Checkbook Management Program ╔══════════════════════════════════════════════════════════╗ 3. ║ Interest earned ║ ║ ║ ║ Date xx/xx/xx Amount ______.00 ║ ║ ║ ║ Category BANK______ ║ ║ ║ ║ Memo ___________________________________________ ║ ║ ║ ║ Cleared the bank YES ║ ║ ║ ║ Keep? (Y/N) X ║ ╚══════════════════════════════════════════════════════════╝ If you have a NOW account, it earns interest each month. That interest can be added in here. Make any other necessary changes to the transaction. Press <enter> or <Y> when the cursor is in the "Keep" box when satisfied with the screen appearance. The program will now pause and check all the transactions in the file. It is totalling the amounts on uncleared transactions to calculate what it thinks the bank statement should read. When it is ready, it will display the following: ╔═══════════════════════════════════════════════════════════════════╗ ║ Bank's balance should read xxxx.xx ║ ║ Current balance is xxxx.xx ║ ║ ║ ║ xxx checks cleared for a total of xxx.xx ║ ║ xxx deposits cleared for a total of xxx.xx ║ ║ ║ ║ (Q)uit ║ ║ (1) Correct Reconciled Transactions ║ ║ (2) Print Reconciliation Report ║ ║ ║ ║ Enter your choice: __ ║ ╚═══════════════════════════════════════════════════════════════════╝ The first balance on the screen should agree with the one printed on the bank statement. The second is the current check register balance. Also displayed is the total number of checks and deposits cleared during this reconciliation session and the total amounts of each. Select <Q> to return to the Main Menu. Select <1> to attempt to correct any discrepancies between the displayed bank balance and that printed on the bank statement. See details below. Select <2> to print a reconciliation report. See details below. There is one other message that could be generated by this option. It is: 1. No entries to reconcile. This message will appear if you choose the Bank Statement Reconciliation option before entering any transactions into the file. Page 30 Checkbook Management Program Correct Reconciled Transactions When this option is selected, the following screen appears: ╔══════════════════════════════════════════════════════════╗ ║ Reconciling account (account name) ║ ║ Bank's balance should read xxxx.xx ║ ║ Check # Date To Whom Amount Category Clr ║ ║ . ║ ║ . ║ ║ . ║ ║ ║ ║ Cursor control keys: ║ ║ . . . . . . . . . . . . . . . . . . . ║ ╚══════════════════════════════════════════════════════════╝ Each transaction just cleared will appear on a line. Fifteen will appear on any given screen. Use the following cursor control keys to move up and down the list comparing the displayed amounts to the amounts on the cleared checks. Using the procedure outlined below, select any that disagree, change the amount, and return to this list. The displayed bank's balance will be updated to reflect any changes made during this process. Cursor control keys for this segment: Home - redisplay the first screen of 15 transactions. Down arrow - move down one row. If this moves you off the screen, the next screen of 15 transactions (if any) appears. Up arrow - move up one row. If this moves you off the screen, the previous screen of 15 transactions (if any) appears. PgUp - redisplay the previous screen of 15 transactions (if any). PgDn - display the next screen of 15 transactions (if any). <enter> - select this transaction. End - exit this option and return to Reconciliation Menu. When a transaction is selected, the current screen is replaced by the appropriate screen used by the Correction option. (See Correct for details on these screens.) Once you've indicated the changes are satisfactory, you will be returned to the same list of 15 transactions you had in front of you when you selected the transaction. Any change to the amount of that transaction will be reflected in the displayed bank balance. Once the discrepancy has been taken care of, or you give up trying to find it, press <end> and you will return to the Reconciliation Menu. If this process has not found the error, print a check register for the time period in question, examine it carefully and use either Correct or Enter to fix the problem. There are two other messages that could be generated by this option. These are: 1. None cleared this time. You requested the program assist you in finding a discrepancy or printing a reconciliation report, yet no transactions have been cleared since requesting the Reconciliation option. Page 31 Checkbook Management Program 2. More than 200 transactions were cleared. The internal array to hold cleared transactions can only hold the first 200 cleared. This should be adequate for most accounts, but could conceivably be exceeded. Only the first 200 transactions can appear on the assistance screens or the Reconciliation Report. If this does not isolate the problem, print a check register and use Correct to fix the problem. Print Reconciliation Report When this option is selected, the following is added to the Reconciliation Menu screen: ┌─────────────────────────────────────────────────────────────────────────────┐ │Press <enter> when the printer is ready at the top of a page. │ └─────────────────────────────────────────────────────────────────────────────┘ Verify your printer is on and positioned properly, then press any key except <Q>. If you have no printer, or if you decide to stop here, press <Q> and you will return to the Reconciliation Menu. If you have no printer and you press anything but <Q>, your system will die and you will have to reboot. The report now appears. It looks like this: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Reconciliation Report ║ ║ ║ ║ 09/05/89 ║ ║(account name) Balance: xxxxx.xx ║ ║ Bank Balance: xxxxx.xx ║ ║ Transactions Cleared Page: 1 ║ ║ ║ ║ Check # Date To Whom Amount Category Clr ║ ║ 1234 02/15/85 Cash 50.00 CASH X ║ ║ 1235 02/16/85 Food City 73.56 GROCERIES X ║ ║ . . . . . . ║ ║ . . . . . . ║ ║ xxx checks cleared for a total of xxxxx.xx ║ ║ xxx deposits cleared for a total of xxxxx.xx ║ ╚════════════════════════════════════════════════════════════════════════════╝ This report starts a new page after 55 transactions have been printed. The first amount appearing in the heading of the report is the current balance for this account. The second amount is the bank statement balance. At the end of the report, the total number of deposits and withdrawals and the total amount for each appears. Page 32 Checkbook Management Program Heading explanations: Check # - The check number or transaction type identifier. These identifiers are: ATD - Automatic Teller Deposit. ATW - Automatic Teller Withdrawal. CHAR - Bank charge. DEP - Regular Deposit. INT - NOW account interest. Date - Date of the transaction. To Whom - Recipient of a check, or explanation of other transaction types. Amount - Amount of the check, deposit, etc. Category - Budget category. Clr - If an X appears, the transaction has cleared the bank. If not, then it hasn't. Page 33 Checkbook Management Program Reports This option presents the Report Menu which allows you to choose among the thirteen reports currently available. This menu follows: ╔═══════════════════════════════════════════════════════════════════╗ ║ Checkbook Management Program ║ ║Account: (account name) Report Menu║ ║Current Balance: xxxxx.xx ║ ║ ║ ║ ╔════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ (Q)uit ║ ║ ║ ║ (1) Check Register - list all transactions ║ ║ ║ ║ (2) List Checks Only ║ ║ ║ ║ (3) List Deposits ║ ║ ║ ║ (4) List Automatic Teller Deposits ║ ║ ║ ║ (5) List Automatic Teller Withdrawals ║ ║ ║ ║ (6) List All Bank Transactions ║ ║ ║ ║ (7) List Uncleared Transactions ║ ║ ║ ║ (8) List All Budget Categories ║ ║ ║ ║ (9) Transactions in a Category ║ ║ ║ ║ (0) Transactions in Category/All Categories ║ ║ ║ ║ (A) Annual Expenditure Report ║ ║ ║ ║ (B) Annual Income Report ║ ║ ║ ║ (C) Summary Report ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ ║ ║ ║ ║ Enter choice ║ ╚═══════════════════════════════════════════════════════════════════╝ This menu appears with the first option (Quit) highlighted with reverse video. Use the arrow keys (up and down) to change the highlighting to rest on the report you want generated. Press <enter> when the proper one is highlighted. Or press the number or letter in parentheses to select any of the reports. These options are: Quit - Return to the Main Menu. Check Register - a listing of all transactions in the order entered. You will be asked to supply dates defining the interval you wish displayed. Only those transactions in the interval will be listed. This report can be displayed on the screen or listed on a printer. Checks Only - a listing of all checks in the order entered. You will be asked to supply dates defining the interval you wish displayed. Only those checks in the interval will be listed. The total money for the listed transactions is also displayed. This report can be displayed on the screen or listed on a printer. Deposits - A listing of all deposits in the order entered. Automatic teller deposits are not listed here. They are included in the list of Automatic Page 34 Checkbook Management Program Teller Deposits. You will be asked to supply dates defining the interval you wish displayed. Only those deposits with dates in the interval will be listed. The total money for the listed transactions is also displayed. This report can be displayed on the screen or listed on a printer. List of all Automatic Teller Deposits - a listing of all automatic teller deposits, in the order entered. You will be asked to supply dates defining the interval you wish displayed. Only those automatic teller deposits with dates in the interval will be listed. The total money for the listed transactions is also displayed. This report can be displayed on the screen or listed on a printer. List of all Automatic Teller Withdrawals - a listing of all automatic teller withdrawals, in the order entered. You will be asked to supply dates defining the interval you wish displayed. Only those automatic teller withdrawals with dates in the interval will be listed. The total money for the listed transactions is also displayed. This report can be displayed on the screen or listed on a printer. List of all Bank Transactions - a listing of all bank transactions, interest, service and other charges, in the order entered. You will be asked to supply dates defining the interval you wish displayed. Only those bank transactions with dates in the interval will be listed. The total money deposited and withdrawn will be totaled separately and displayed. This report can be displayed on the screen or listed on a printer. List Uncleared Transactions - a listing of all transactions in the order entered which have not yet been marked as having cleared the bank. The total money for the listed transactions is also displayed. Deposits and withdrawals are totaled separately. This report can be displayed on the screen or listed on a printer. List of all Current Categories - a listing of all categories currently in use in your data file in alphabetical order. This report can be displayed on the screen or listed on a printer. Transactions in a Category - a listing of all transactions in the order entered which have the same category. You will be asked to supply dates defining the interval you wish displayed and the category you wish displayed. Only those transactions in the interval and exactly matching the category will be listed. The total money for the listed transactions is also displayed. Deposits and withdrawals will be totaled separately. This report can be displayed on the screen or listed on a printer. Transactions in Category for all Categories - a listing of all transactions, in the order entered, arranged by category. You will be asked to supply dates defining the interval you wish considered. All categories represented by transactions within this interval will appear on the report, each beginning on a fresh page. The total money for the listed transactions is also displayed. Deposits and withdrawals will be totaled separately. The categories will appear in alphabetical order. This report, which can take several pages to print, can only be printed on a printer. It is not available for screen display. For screen display of any one category, use the report described above. Page 35 Checkbook Management Program Annual Expenditure Report - lists a table of the total amounts spent per month for every category. Totals are given for each month and each category. The average monthly expenditure for each category is also displayed. Budget categories are displayed in alphabetical order. You will be asked to supply the last two digits of the year the report is to cover. This report can be displayed on the screen or listed on a printer. Annual Income Report - lists a table of the total amounts deposited per month for every category. Totals are given for each month and each category. The average monthly income for each category is also displayed. Budget categories are displayed in alphabetical order. You will be asked to supply the last two digits of the year the report is to cover. This report can be displayed on the screen or listed on a printer. Summary Report - lists the total expenditures and deposits for the account for each month and the total for the year. This report can be displayed on the screen or listed on a printer. Check Register This report produces a listing of all transactions in the current order. You will be asked to supply dates defining the time interval you wish displayed. Only those transactions with dates in the interval will be listed. This report can be displayed on the screen or listed on a printer. When this report is chosen, the screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Check Register ║ ║ ║ ║ This report lists all transactions taking place over a ║ ║ range of dates. Please enter them in order. ║ ║ ║ ║ Start date ff/ff/ff ║ ║ End date ll/ll/ll ║ ╚══════════════════════════════════════════════════════════╝ The first time any report with a range of dates is selected, the start date (ff/ff/ff) is set to the date of the earliest transaction in the data file. The end date is set to the system date. Make any changes you wish to these dates. Press <enter> when satisfied with each date. Once you press <enter>, you may not go back to the previous date. If you change the dates, then the next report you request that needs a range of dates will use these new dates. This is so you can print a series of reports covering the same range of dates without having to reenter the dates each time. Page 36 Checkbook Management Program There are two potential error messages with these dates. 1) Invalid date. The dates must be valid dates (February 30 is not a valid date). The cursor will be placed in the beginning of the invalid date so that it may be reentered. 2) Dates out of order. The start date must be at least one day earlier than the end date. The cursor will be placed back in the start date so that both dates may be reentered. You will then be asked about the display of the report. The screen displays: ╔══════════════════════════════════════════════════════════╗ ║ Check Register ║ ║ ║ ║ This report lists all transactions taking place over a ║ ║ range of dates. Please enter them in order. ║ ║ ║ ║ Start date ff/ff/ff ║ ║ End date ll/ll/ll ║ ║ ║ ║ List on the screen (S) or print on the printer (P)? ║ ╚══════════════════════════════════════════════════════════╝ Press one of three letters (case makes no difference): S - Display the report on the screen. P - Display the report on the printer. Q - Return to the Report Menu. If you press <P>, you have one more task before the report begins. The screen becomes: ╔══════════════════════════════════════════════════════════╗ ║ Check Register ║ ║ ║ ║ . . . ║ ║ ║ ║ List on the screen (S) or print on the printer (P)? P ║ ║ Press <enter> when the printer is ready at the top of ║ ║ a page. ║ ╚══════════════════════════════════════════════════════════╝ Verify your printer is on and positioned properly, then press any key except <Q>. If you have no printer, or if you decide to stop here, press <Q> and you will return to the Report Menu. If you have no printer and you press anything but <Q>, your system will die and you will have to reboot. Page 37