The Education Master 1994 (4th Edition)

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

/ The Education Master 1994 (4th Edition) / EDUCATIONS_MASTER_4TH_EDITION.bin / files / religion / cmts1 / cmts33a.exe / CMTS.DOC < prev next >

Wrap

Text File | 1993-10-10 | 320KB | 8,228 lines

CHURCH MEMBERSHIP DONATION TRACKING SYSTEM CMTS VERSION 3.3 User Manual Torbert Data Systems, Inc. P. O. Box 9218 Chesapeake, VA 23321 Telephone (804) 488-5506 FAX (804) 488-8630 Support BBS (804) 488-4146 COPYRIGHT (c) 1990-93 Torbert Data Systems, Inc. T a b l e O f C o n t e n t s Page FOREWORD ............................................ vi I. INTRODUCTION ........................................ 1.1 What is CMTS? ....................................... 1.1 Features Overview ................................... 1.1 Membership .......................................... 1.1 Donations ........................................... 1.2 Fund Accounting ..................................... 1.2 Attendance .......................................... 1.3 Visitation .......................................... 1.3 Customize Setup ..................................... 1.3 Additional Reports .................................. 1.4 Optional Products and Services ...................... 1.4 Conversion Services ................................. 1.4 Customization ....................................... 1.4 Network Support ..................................... 1.4 Ultimate MailList Manager ........................... 1.5 Ad Hoc Report Writer ................................ 1.5 II. GETTING STARTED ..................................... 2.1 System Requirements ................................. 2.1 Initial Installation Instructions ................... 2.1 Up and Running Quickly .............................. 2.2 Consistent Look and Feel ............................ 2.3 Upgrading From Prior Versions ....................... 2.5 III. THE MAIN MENU ....................................... 3.1 IV. MEMBERSHIP .......................................... 4.1 MEMBER.EXE .......................................... 4.1 Membership Information .............................. 4.2 Households / Individuals ....................... 4.2 Individuals By Name ............................ 4.6 Organizations .................................. 4.10 Special Talents ................................ 4.11 Special Dates .................................. 4.13 Purge Deleted Records .......................... 4.14 Mailing Labels ...................................... 4.15 By Household ................................... 4.15 By Individual .................................. 4.16 Members of an Organization ..................... 4.17 Label Test Pattern ............................. 4.17 i T a b l e O f C o n t e n t s Page Reports ............................................. 4.18 Complete Household Listing ..................... 4.18 Individual Profile Report ...................... 4.18 Special Dates Report ........................... 4.19 Special Talents Report ......................... 4.19 Organizational Rosters ......................... 4.20 Complete Church Roster ......................... 4.20 Family Church Directory ........................ 4.21 Individual Directory ........................... 4.21 Birthday List .................................. 4.22 Export Members for Mail Merge .................. 4.22 Auto Organization Build Utility ................ 4.23 V. DONATIONS ........................................... 5.1 DONATE.EXE .......................................... 5.1 Donation Data Entry and Update ...................... 5.2 Enter Donations By Name ........................ 5.3 Enter Donations By Envelope Number ............. 5.5 Detail Data Entry Edit Listing ................. 5.6 Summary Data Entry Edit Listing ................ 5.7 Finalize Data Entry ............................ 5.7 Miscellaneous Activities ............................ 5.8 Member Pledge/Giving Maintenance ............... 5.8 Year End Roll .................................. 5.10 Purge History (Date Range)...................... 5.10 Export Donation Data ........................... 5.11 Statement Processing Options ........................ 5.12 Build Statement Work File ...................... 5.12 Print Statements ............................... 5.13 Print Mailing Labels ........................... 5.13 Label Test Pattern ............................. 5.14 Single Statement - Summary Format .............. 5.14 Single Statement - Detail Format ............... 5.15 Print Statements In Detail Format .............. 5.15 Inquiries ........................................... 5.16 Detail Inquiry By Individual ................... 5.16 Detail Inquiry By Donation Category ............ 5.16 Quarterly Summary Donation Inquiry ............. 5.17 Reports ............................................. 5.17 Activity Report - Individual ................... 5.18 Activity Report - Fund ......................... 5.18 Donation Summary - Individual .................. 5.19 Donation Summary By Fund - Date Range .......... 5.19 Weekly Donation Summary ........................ 5.20 ii T a b l e O f C o n t e n t s Page Call List By Last Donation Date ................ 5.20 Quarterly Fund Summary ......................... 5.21 Member List By Envelope # ...................... 5.21 Alpha List With Envelope Number ................ 5.22 VI. FUND ACCOUNTING ..................................... 6.1 FUND.EXE ............................................ 6.1 MAINTAIN FILES SUBMENU .............................. 6.3 File Maintenance Activities ......................... 6.4 General Ledger Accounts ........................ 6.4 Budget Information ............................. 6.6 Bank Information ............................... 6.6 Vendors ........................................ 6.8 Autobuild Next Year's Budget ................... 6.9 Reset Next Year's Budget Back To Zero .......... 6.10 Reports ............................................. 6.10 Chart Of Accounts .............................. 6.11 Monthly Budget Information ..................... 6.11 Annual Budget Information ...................... 6.12 Actual/Budgeted Variance Report ................ 6.12 Bank File Listing .............................. 6.12 Vendor File Listing ............................ 6.13 DATA ENTRY SUBMENU .................................. 6.13 Transaction Data Entry .............................. 6.13 Enter Transactions ............................. 6.14 Data Entry Edit Listing ........................ 6.12 Finalize Transactions .......................... 6.23 Other Data Entry Activities ......................... 6.24 Check Reconciliation ........................... 6.24 Reports ............................................. 6.25 Check Register ................................. 6.25 Outstanding Check List ......................... 6.26 INQUIRIES SUBMENU ................................... 6.26 Transaction Detail Inquiry ..................... 6.26 Account Inquiry ................................ 6.27 Check Register ................................. 6.27 iii T a b l e O f C o n t e n t s Page PERIOD END PROCESSING SUBMENU ....................... 6.28 Period End Processing ............................... 6.28 Prepare For Monthly Financial Reports .......... 6.28 Monthly Financial Report ....................... 6.29 Monthly Trial Balance .......................... 6.29 Year End Processing ................................. 6.29 Year End Roll .................................. 6.30 Purge Old Transactions ......................... 6.30 Purge Deleted Accounts ......................... 6.31 Export Transactions ............................ 6.31 REPORTS SUBMENU ..................................... 6.33 Chart Of Accounts .............................. 6.33 Revenue and Expenditures ....................... 6.33 Sources and Uses of Funds (Detail) ............. 6.34 Trial Balance .................................. 6.34 Actual vs Budgeted Report ...................... 6.34 Check Register ................................. 6.35 Outstanding Check List ......................... 6.35 Transaction Audit Trail ........................ 6.35 Balance Sheet .................................. 6.35 Changes in Fund Equity ......................... 6.36 Fund Equity Account Analysis ................... 6.36 Monthly Budget Information ..................... 6.37 Annual Budget Information ...................... 6.37 Monthly Financial Report ....................... 6.37 Monthly Trial Balance .......................... 6.37 Account Detail Report By Date Range ............ 6.37 Actual/Budgeted Variance Report ................ 6.37 VII. ATTENDANCE .......................................... 7.1 ATTEND.EXE .......................................... 7.1 Congregational Attendance ........................... 7.2 Build Attendance Records ....................... 7.2 Enter Attendance By Date ....................... 7.3 Enter Attendance By Member ..................... 7.4 Update Last Attendance Date .................... 7.5 Purge Old Records .............................. 7.5 iv T a b l e O f C o n t e n t s Page Organizational Attendance ........................... 7.6 Build Attendance Records ....................... 7.6 Enter Attendance By Date ....................... 7.7 Enter Attendance By Member ..................... 7.8 Update Last Attendance Date .................... 7.9 Purge Old Records .............................. 7.9 Reports ............................................. 7.10 Attendance Call List ........................... 7.10 Congregational Summary By Date ................. 7.10 Organizational Summary By Date ................. 7.11 Congregational Detail By Member ................ 7.12 Organizational Detail By Member ................ 7.12 Date of Last Organizational Attendance ......... 7.12 Congregational Attendance Worksheet ........... 7.13 Organizational Attendance Worksheet ........... 7.13 VIII.VISITATION AND EVENT TRACKING ........................ 8.1 VISIT.EXE ........................................... 8.1 Data Entry .......................................... 8.2 Enter Events ................................... 8.2 Data Entry Edit Listing ........................ 8.3 Finalize Events ................................ 8.3 Event Inquiries and Year End Roll ................... 8.4 View Event Detail By Category .................. 8.4 View Event Detail By Member .................... 8.4 Ten Year Event Summary ......................... 8.5 Roll Event Year ................................ 8.5 Visitation Activities ................................ 8.5 Members' Visitation Information ................ 8.5 Appointment Schedular .......................... 8.7 Reports ............................................. 8.8 Event Detail By Date ........................... 8.8 Event Detail By Category ....................... 8.9 Event Summary By Date Range .................... 8.9 Five Year Event Summary ........................ 8.10 Visitation Roster By Route ..................... 8.10 Appointment Summary By Date .................... 8.11 Other ............................................... 8.11 Purge Event History ............................ 8.11 IX. CUSTOMIZE SETUP ..................................... 9.1 SETUP.EXE ........................................... 9.1 Maintenance Parameters .............................. 9.2 v T a b l e O f C o n t e n t s Page Donation Categories ............................ 9.2 Date Descriptions .............................. 9.3 Organizations .................................. 9.4 Talents ........................................ 9.6 Events ......................................... 9.7 Password Security .............................. 9.8 Miscellaneous Parameters ....................... 9.10 User Definable Field Descriptions .............. 9.11 Reports ............................................. 9.12 Donation Category Listing ...................... 9.12 List Of Date Descriptions ...................... 9.12 List Of Organizations .......................... 9.13 List Of Talents ................................ 9.13 List of Events ................................. 9.13 X. ADDITIONAL REPORTS .................................. 10.1 RPTINIT.EXE ......................................... 10.1 Run Reports ......................................... 10.2 Reports By Category ............................ 10.2 Reports By Name ................................ 10.2 Maintain Files ...................................... 10.3 Categories ..................................... 10.3 Reports ........................................ 10.4 XI. LIVE IMPLEMENTATION ................................. 11.1 FILECRE.EXE ......................................... 11.1 Instructions For Live Implementation ................ 11.1 MEMBERSHIP ..................................... 11.2 DONATIONS ...................................... 11.3 FUND ACCOUNTING ................................ 11.3 ATTENDANCE ..................................... 11.4 VISITATION ..................................... 11.4 XII. SPECIAL CONSIDERATIONS .............................. 12.1 Files ............................................... 12.1 Backup Procedures ................................... 12.4 Restoring From A Backup ............................. 12.6 Product Support ..................................... 12.6 XIII.In Case Of Difficulties ............................. 13.1 vi FOREWORD ======== Version 3.3 of CMTS represents Torbert Data System's ongoing commitment to the many churches now using this software. The many new features and enhancements implemented in this release are based on the suggestions and requests of current users. This version incorporates the simplicity and ease of use that have attracted churches to prior versions of this product while providing a total solution to church management needs. Torbert Data Systems would like to thank the many churches which have contributed to the development of version 3.3 through their suggestions and recommendations. We would like to extend a special thanks to the churches that have helped in testing and debugging beta releases of this version. ACKNOWLEDGEMENTS ================ The ability to view the manual from the main menu utilizes LIST.COM. LIST.COM is the property of Vernon D. Buerg. The software is distributed using self-extracting EXE files that were created by PKZIP under a license agreement between Torbert Data Systems, Inc. and PKWARE. The installation procedure was created using FIRST IMPRESSION under a license agreement with Lincoln Beach Software. ASP OMBUDSMAN STATEMENT ======================= "This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442 or send a CompuServe message via CompuServe Mail to ASP Ombudsman 70007,3536." vii TORBERT DATA SYSTEMS, INC. BELIEVES THAT THIS SOFTWARE IS REASONABLY FREE FROM BUGS AND DEFECTS AND FURTHER BELIEVES THAT IT WILL PERFORM SUBSTANTIALLY IN ACCORDANCE WITH THIS DOCUMENTATION. HOWEVER, TORBERT DATA SYSTEMS, INC. HEREBY DISCLAIMS ALL WARRANTIES RELATING TO THIS SOFTWARE, WHETHER EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT WILL TORBERT DATA SYSTEMS, INC. OR ITS SUPPLIERS BE LIABLE FOR ANY SPECIAL, INCIDENTAL, CONSEQUENTIAL, INDIRECT OR SIMILAR DAMAGES DUE TO LOSS OF DATA OR ANY OTHER REASON, EVEN IF TORBERT DATA SYSTEMS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. UNDER NO CIRCUMSTANCES SHALL TORBERT DATA SYSTEM'S LIABILITY FOR ANY DAMAGES EVER EXCEED THE PRICE PAID FOR THE LICENSE TO USE THIS SOFTWARE, REGARDLESS OF THE FORM OF THE CLAIM. THE PERSON USING THIS SOFTWARE BEARS ALL RISKS AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE. viii I. INTRODUCTION ============ WHAT IS CMTS? ============ Church Membership Tracking System (CMTS) is an exceptionally easy to use, full featured, church management system. The software is completely menu driven and provides context- sensitive help screens to guide the user through every step. The software is available in both single-user and network formats. FEATURES OVERVIEW ================= The system consists of seven individual modules and offers extensive reporting capabilities. There is also an optional report writer which allows the user to write additional reports or modify the many reports supplied with the system. o Membership o Donations o Fund Accounting o Attendance o Visitation o Setup o Additional Reports In all modules, reports prompt with an option to direct the report to either the screen or the printer. Reports directed to the screen may be scrolled up and down, etc. Reports may also be easily directed to disk. MEMBERSHIP ========== Extensive membership information is maintained. Store vital information on each household and each individual within the church. Members' special dates, talents, events and membership in church organizations may be entered based on user defined tables. Reports provide household and individual details, as well as a roster for any organization within the church, list of member's special talents, and a report for any "special date category" and date range. Membership information may be 1.1 exported into ASCII text format for use with the mail merge features common in many word processors. Mailing labels may be printed for each family, each individual, or all members of a church organization. DONATIONS ========= Donations may be entered by name or envelope number. A comprehensive audit trail of all giving may be accessed by member or by fund category. Transaction detail information may be retained indefinitely if there is adequate disk space. You may elect to combine individuals from the same household for statement purposes or print statements for each individual. Store individual's pledge information by fund category. Both annual and "life of the fund" pledge amount may be stored for each individual per fund. Excellent reports are provided to access transaction detail as well as current and prior year quarterly totals. You may print a complete detail donation listing grouped either by member or by fund category of all giving for any date range. Donation information may also be exported into ASCII text format for use in spreadsheets. FUND ACCOUNTING =============== This is a true double entry fund accounting general ledger system. It is recommended that an accountant assist in the initial setup of the church's chart of accounts, however once installed, the use of automatic transaction types makes it extremely easy to use with little or no accounting knowledge. The system provides budgeting capabilities for all sources of funds (revenue) and uses of funds (expenditures). Budget amounts may be entered on either a monthly or an annual basis. Prior year budget information is also available. Several automatic transaction types are provided to assist the user with a limited accounting background. First, when entering bank deposits, simply indicate the appropriate source of fund distribution. The journal entries are then made by the system automatically. Similarly, when cash disbursements (checks) are entered, indicate the use of fund distribution and the entries are again made automatically. 1.2 Complete records of all bank checking accounts are generated automatically. The system even allows you to print check registers and flag returned checks to assist in check reconciliation. There is also a transaction screen to enter fund equity transfers. A general journal entry screen is also provided to allow traditional debit and credit posting when necessary. Extensive reporting capabilities include several monthly financial reports, a statement of revenue and expenditures and changes in fund equity, statement of sources and uses of funds, chart of accounts listing, trial balance, check register and much more. Other reports include a detailed audit trail listing of all transactions for a user defined reporting period, budget report, and a current year vs prior year comparison. Information may also be exported into ASCII text format for import into spreadsheets, etc. ATTENDANCE ========== Attendance may be maintained for up to three user defined events (morning worship, evening worship, Sunday school, etc.) for the entire congregation. It is fast and easy to enter attendance information. You then have the information needed to recognize members with outstanding attendance and to call upon those who have been absent. A "call list" based on last attendance date is especially useful. Attendance may also be maintained for all organizational functions. Attendance may be entered for any frequency (daily, weekly, monthly, etc). The attendance module uses an "exception posting" approach. This means it is only necessary to post attendance records for members either present or absent, but not both. VISITATION AND EVENT TRACKING ============================= This module provides the ability to track statistically the events that occur in the church such as baptisms, deaths, transfers and so forth. Up to 9999 different type events may be defined and tracked for statistical purposes. Denominational churches often are required to submit statistical information on national and district reports. The event structure should help in this regard. 1.3 The visitation module also allows for tracking information on shut-ins, last visit dates, visitation routes, etc. and includes an appointment schedular. Use the appointment schedular to schedule visits and other appointments. There is even a memo pad to enter detailed information in a free- form text edition fashion. Memos may be associated with a member or a date. Reports include both event summary and event detail reports, call lists by either last attendance date or last donation, a visitation roster by route and appointment summary by date range. CUSTOMIZE SETUP =============== Customize CMTS to the needs of your church. Many parameters can be tailored to your unique requirements. Define the special dates such as birthdays, wedding anniversary, etc. to be tracked for each member. Similarly, define the members' talents you wish to track, any events to be tracked statistically and indicate all organizations within the church. Define all the contribution categories available for donation posting. In this module you may indicate whether you wish to require password security and if so, specify which modules each user may access. User-definable fields are available for further customization. The descriptions for each of these fields can be maintained here. ADDITIONAL REPORTS ================== This module permits additional reports written using the Clarion Report Writer to be added to the menu system. The menu is "soft" meaning that any reports you write can be added to the menu. In addition custom reports written by Torbert Data Systems and consultants can be placed here without modifying the program. OPTIONAL PRODUCTS AND SERVICES ============================== Several optional products are available to enhance your use of CMTS. For more information on any of these products, contact Torbert Data Systems at (804) 488-5506. 1.4 CONVERSION SERVICES =================== Torbert Data Systems offers data conversion services. If your church's membership is already computerized, you may be able to avoid rekeying your members. Contact Torbert Data Systems for more information on this service. CUSTOMIZATION ============= If your church desires features that are not currently in the standard CMTS package, we may be able to provided them for you. In many instances, the requested feature may already be planned for a future release. Otherwise, we might be able to include the features you need in a future version of the software. NETWORK SUPPORT =============== This version of CMTS is a single user version. It will operate on a network if only one user access the files at a time. Our commercial version, CMTS Plus offers full network support. Contact Torbert Data Systems for more information. ULTIMATE MAILLIST MANAGER ========================= Based on the prospect/maillist module of CMTS Plus, this product is excellent for tracking prospects, area businesses that might receive the weekly bulletin, day care children (with emergency medical information), and any other group that you do not wish to include in the membership module or track for donations and attendance. AD HOC REPORT WRITER ==================== Write your own ad-hoc reports and queries. Clarion Software's powerful Report Writer is just the product to enhance your CMTS system. The optional Report Writer module allows users to create their own reports and to modify the many reports supplied with the system. Furthermore, reports written with Report Writer may be fully integrated into the menu of the Additional Reports module. For more information on Report Writer, contact Torbert Data Systems. 1.5 II. GETTING STARTED =============== The following information is presented to allow the user to get the software up and running quickly in a test mode. Sample data files have been distributed with this software and should be used during this process. These sample files may be created by running the programs SAMPLE1.EXE and SAMPLE2.EXE. Prior to attempting the actual live installation and building of your church's data files, the remainder of the manual should be read completely. The sample data files are furnished for product evaluation and familiarization only. They must be purged prior to live installation. See information on FILECRE.EXE elsewhere in this manual. SYSTEM REQUIREMENTS =================== The following hardware is required to run CMTS. IBM PC or compatible 640 K of memory Hard disk (At least 5 Megabytes free) MS DOS Level 3.0 or higher The software should work with any monitor. INITIAL SETUP INSTRUCTIONS ========================== CMTS is distributed in several different ways. Usually, when you receive an on-disk copy, you need only place disk one into the drive and enter A:INSTALL or B:INSTALL. The installation is automatic at that point. IF THE SOFTWARE IS IN ZIP FORMAT, do the following: 1. Create a directory called CMTS33. Example: MD \CMTS33 Press <ENTER> 2. Make that your active directory. Example: CD \CMTS33 Press <ENTER> 3. Copy the three CMTS zip files to the directory and then unzip them. PKUNZIP CMTS33A Press <ENTER> PKUNZIP CMTS33B Press <ENTER> PKUNZIP CMTS33C Press <ENTER> 2.1 Before CMTS can be run, data files must be created. The program FILECRE.EXE will create sample data files to assis in quickly evaluating the look and feel of the software. This same program must be run again to create live data files prior to actual implementation. SEE CHAPTER 11 for details of live implementation. Example: FILECRE Press <ENTER> IMPORTANT: Insure that your CONFIG.SYS file contains values at least as great as "FILES = 50" (or greater). Failure to do this will result in the DOS "Too many open files" error. If you are not familiar with this file, refer to your DOS manual for additional information. The file may be maintained by using EDLIN or any ASCII text editor. In case of difficulty installing this software, please give us a call at (804) 488-5506. We will be glad to assist you. Once the software is intalled and sample data files are built, run the the program by executing CMTS. Example: CD \CMTS33 Press <ENTER> CMTS Press <ENTER> UP AND RUNNING QUICKLY ====================== This section will get you up and running as soon as possible so you can evaluate the look and feel of the software. It is strongly recommended that the remainder of this manual be read prior to building your files. To assist in evaluating this product, a set of sample data files has been included. Later in this manual, instructions will be given on how to create and build the actual data files required for live implementation. Follow the few steps below and "explore" the software. You will find the software to be extremely easy to use. If you experience any difficulty, do not hesitate to call. 1. To execute the program, type <CMTS> and press <ENTER>. When you run the software for the first time, the keyfiles will automatically be created. These files will have extensions such as *.K01 where * will be the same as the data file name. 2.2 2. Soon, the initial screen will appear. Press any key to go to the main menu. 3. To make a selection from the main menu, touch the letter on your keyboard corresponding to the menu selection. You may also use the <UP> or <DOWN> arrow key to position the selector bar at the module you wish to access. Press <ENTER> and the selection will be run. 4. The menu for the module you selected will now appear. You may select an option on the menu in the same manner as you did on the main menu. If you experience any difficulties, refer to the section on "IN CASE OF DIFFICULTIES" later in this manual. CONSISTENT LOOK AND FEEL ======================== As you begin to explore the software, you will find it incredibly easy to use. The software has a consistent look and feel. Several general conventions are followed throughout the system. They will be discussed here. 1. The screen will go blank after a period of inactivity. Press any key to display the screen. The key press will not be active. 2. You may press <F1> from any screen in the system to get a pop-up help screen. In many instances, the help screen will be context sensitive to the field on which the cursor is positioned. 3. Whenever a "scrolling lookup table" appears on the screen, the <UP> and <DOWN> arrow keys or the <PG UP> and <PG DN> keys may be used to quickly move the selector bar to the desired record. With large files, the desired record may be accessed more quickly by entering part or all of a designated key value. As each keystroke is entered, the selector bar will automatically position itself closer to the desired record. It is seldom necessary to input the entire value. When the selector bar is positioned over the desired record, press <ENTER>. 2.3 4. The <ESC> key will generally take you to the prior screen or activity. The only exception is when you are in a data entry field, in which case the <ESC> key aborts any data entered into that field. The following rules apply to most screens where data entry is permitted (file maintenance screens, donation posting screens, etc.). 5. You will normally choose between adding a new record or changing an existing record. To add a new record, press the <INSERT> key and the data entry form will appear. To make changes to an existing record, position the selector bar over the desired record as described above and press <ENTER>. The data entry form will appear with the current values for each field in place. 6. When entering data, use the <UP> and <DOWN> arrow keys to move from field to field. The <ENTER> key will also take you to the next field. 7. The <ESC> key will take you to the prior field and abort any values you placed in the current field. 8. To terminate the data entry to the screen without having to go through all the fields, press <CTL> <ENTER> (hold down the control key and press enter). The record will be written. 9. To terminate the data entry to the record and abort any changes you made, press <CTL> <ESC>. The original values will be restored. 10. While editing a field, press the <INS> key to toggle overtype on or off. The backspace and <DEL> keys will function as you would expect them to. 11. When editing a numeric field, press the spacebar to clear out the entire field. All data entered in a numeric field will be entered right justified with the cursor remaining stationary and the numbers moving from right to left. 2.4 12. In instances where the value you enter must reference existing data in another structure (entering the member or fund when posting a donation, etc.), a pop-up selection table may appear. For example, when prompted to enter a member's number, press <ENTER>. A table of all members will appear. Select the appropriate record by moving the selector bar as discussed earlier. 13. When building a file initially or if there are no records in the file, there will not be a scrolling table until after at least one record has been added. This is normal. 14. Never delete a record that has references in other files. For instance, if members have been assigned to certain organizations, do not delete those organizations. If a member has active donations in the transaction file, you must not delete that member. The proper way to delete an inactive member is to do so at the beginning of the year, before any transactions are posted. The following applies to all reports. 15. Whenever a report is initiated from the menu, a report confirmation screen will appear. This screen will display the name of the report you have chosen and indicate whether the current report direction is set at SCREEN or PRINTER. 16. You may toggle the report direction by pressing <F2>. To initiate report processing, press <ENTER>. 17. Reports directed to the screen may still be sent to a printer by pressing <CTL> <L> when the report appears on the screen. UPGRADING FROM PRIOR VERSIONS ============================= Users upgrading from earlier versions of CMTS must run the appropriate conversion program. Users upgrading this software will automatically receive this program as part of the upgrade service. When registering for the first time, indicate if you are currently using an earlier version. You will be sent the appropriate conversion program to convert to the current version. In no instance will data need to be reentered. 2.5 III. THE MAIN MENU ============= PROGRAM: CMTS.EXE ================= Functional Description CMTS.EXE is the main menu for the Church Membership Tracking System software. After you have become accustomed to the software, it is possible to bypass this program and run the individual module programs directly. However, it is recommended that you initially use this program. Step-By-Step Instructions 1. From the DOS command line, change into the CMTS32 directory. Example: CD \CMTS33 <ENTER> 2. Execute CMTS.EXE as follows: Example: CMTS <ENTER> 3. The introductory screen will appear. Press <ENTER> to continue. 4. The main menu will be displayed. To make a selection from the main menu, touch the letter on the keyboard corresponding to the menu selection. It is also possible to use the <UP> or <DOWN> arrow key to position the selector bar over the desired module. Press <ENTER> and the selection will be run. The main menu choices are: A) Membership B) Donations C) Fund Accounting D) Attendance E) Visitation and Event Tracking F) Customize Setup G) Additional Reports H) Backup Data Files 5. To terminate the program from the main menu, press <ESC>. 3.1 IV. MEMBERSHIP ========== PROGRAM: MEMBER.EXE =================== Functional Description MEMBER.EXE is the executable program for the membership module. This is the module where all membership details not relating to donations are maintained. Step-By-Step Instructions 1. This module may be accessed by selecting MEMBERSHIP from the main menu or by executing MEMBER from the DOS command line. To execute MEMBER from the DOS command line: Example: CD \CMTS33 <ENTER> MEMBER <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. Press <ENTER> at this time. If the security option is not set, the password prompt will not appear and this step may be skipped. 3. To make a selection from the membership menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: MEMBERSHIP INFORMATION A) Households / Individuals B) Individuals By Name C) Organizations D) Special Talents E) Special Dates F) Purge Deleted Records 4.1 MAILING LABELS G) By Family H) By Individual Member I) Members of an Organization J) Label Test Pattern REPORTS K) Complete Family Listing L) Membership Profile Report M) "Special Dates" Report N) "Special Talents" Report O) Organizational Rosters P) Complete Church Roster Q) Family Church Directory R) Individual Directory S) Birthday List OTHER T) Export Members for Mail Merge U) Auto Organization Build Utility MEMBERSHIP INFORMATION ====================== These selections will allow you to add and maintain information related to all members of the church. Information related to member's giving is not accessible from this module. This allows someone who should not have access to donation information to be able to use this module. MENU SELECTION: "A) Households / Individuals" ============================================= Functional Description This option allows you to update the family or household file. There should be one entry in this file for each household. Information that is general to all members of a family or household should be entered here. Step-By-Step Instructions 1. To select "Households / Individuals" from the menu, touch the letter <A> and then press <ENTER>. The arrow keys may also be used to select this option. 4.2 2. A scrolling table of all households currently defined will appear. At this point, you may elect to add a new family or change information for an existing family. To return to the menu 1. When you wish to return to the MEMBER menu, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. After entering each field of information, press <ENTER> to go to the next field. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel the entry for this record, press <CTRL ESC>. 2. "Family Number" - The system will automatically assign the next available family number. Optionally, you may manually enter any new family number that does not exist. 3. "Combined Family Name" - Enter up to 30 characters which identifies the family name or the head of the household. If you elect to print a single statement per family, this name will appear on the statement. 4. "Last Name (Sort)" - Enter up to the first twelve characters of the family's last name. This is necessary for name sorting purposes. 5. "Address Line 1" - Enter up to 32 characters for the first line of the address. 6. "Address Line 2" - Enter up to 32 characters for the second line of the address. 7. "City" - Enter up to 32 characters for the city or third line of the address if required(for international users). 8. "State" - Enter the 2 character state abbreviation. 9. "Zip" - Enter up to 10 characters for the zip code. 10. "Carrier Route" - Enter the 4 character postal carrier route. 4.3 11. "Phone Number" - Enter the ten digit telephone number including the area code. 12. "Alternate Address Line 1" - Enter up to 32 characters for the first line of the alternate address. This field is typically used when the family has a vacation home or other alternate address. 13. "Alternate Address Line 2" - Enter up to 32 characters for the second line of the address. 14. "Alternate City" - Enter up to 32 characters for the city or third line of the address if required(for international users). 15. "Alternate State" - Enter the 2 character state abbreviation. 16. "Alternate Zip" - Enter up to 10 characters for the zip code. 17. "Alternate Carrier Route" - Enter the 4 character postal carrier route. 19. "Alternate Phone Number" - Enter the ten digit telephone number including the area code. 20. "Status Code" - This is a user definable field. Use it in any manner you wish. 21. "Parent or Related Family" - A family member living at a temporary address, such as a student living at college, will have a different address from the rest of the family. Thus a new family must be set up for this person. Enter the family number to which the member actually belongs to. User Definable Fields There are 6 user definable fields at the household level. The field descriptions may be maintained in the setup module. The fields and there sizes are: 22. "User Desc 1" - This is a 1 character user definable field. You may use it and the other user definable fields as you wish. 23. "User Desc 2" - This is a 2 character user definable field. 4.4 24. "User Desc 3" - This is a 5 character user definable field. 25. "User Desc 4" - This is a 5 character user definable field. 26. "User Desc 5" - This is a 10 character user definable field. 27. "User Desc 6" - This is a 20 character user definable field. 28. "Delete Family" - When you wish to delete a family from the data base, change this value from "N" to "Y". See the section "Purge Deleted Records" for more information on the use of this field. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. You may also enter all or part of the family name to automatically position the selector bar. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. Press <CTRL> <ENTER> to write the record without entering data in all fields. To completely cancel all changes to this record, press <CTRL ESC>. After all fields have been maintained, the program will return to the scrolling table. Active Function Keys F1 HELP - Always active 1. Press F1 at any time for a pop-up context sensitive help screen. F2 Maintain Individuals 1. Press F2 while maintaining a family to go to a table of all members of this family. When adding a new family, press <CTL> <ENTER> to write the family record prior to accessing members with F2. F3 Swap Address/Alternate Address: 4.5 1. Press F3 to swap the primary and alternate addresses. All reports use the primary address. In instances where a family has a second home (vacation home, etc), store this address and phone number in the alternate fields. Then to make this address active, press F2. MENU SELECTION: "B) Individuals By Name" ======================================= Functional Description This option is used to update the member file. There should be one entry in this file for each family member who belongs to the church. Step-By-Step Instructions 1. To select "Individuals By Name" from the menu, touch the letter and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all members currently defined will appear. At this point, a new member may be added or an existing member may be maintained . To return to the menu 1. To return to the MEMBER menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. After entering each field of information, press <ENTER> to go to the next field. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel the entry for this record, press <CTRL ESC>. 2. "Member Number" - The system will automatically assign the next available member number. Optionally, you may manually enter any new member number that does not exist. 3. "Family No" - Enter the number representing the family to which the person belongs. If you do not know the number, press <ENTER> and a scrolling table will pop up displaying all the families. Once the family has been chosen, family data will be displayed on the right side of the screen. 4.6 4. "Title" - You may enter an optional title of up to 6 characters (Mr., Mrs., etc.). 5. "First Name" - Enter the person's first name of up to 12 characters. 6. "Middle Initial" - Enter a 1 character middle initial for this person. 7. "Last Name" - Enter up to 15 characters for the person's last name. 8. "Suffix" - Enter up to a 3 character suffix for this individual. 9. "Relation" - Enter the individual's relationship to the head of the household (spouse, child, etc.). 10. "Salutation" - Enter up to a 15 character salutation for this person. 11. "Marital Status" - Select the marriage code for the person. Valid choices are: S - Single M - Married W - Widowed D - Divorced 12. "Sex Code" - Indicate the sex of this person. Valid choices are: M - Male F - Female 13. "Label Code" - If this field has a value of <Y> when individual labels are printed, a label will print for this person. If it has a value of <N>, no label will be printed. 14. "Date Joined" - Enter the date the person joined this church. 15. "Birthdate" - Enter the birthdate of this person. 16. "Employer" - Enter up to 20 characters for the name of this individual's employer. 17. "Occupation" - Enter the individual's occupation of up to twenty characters. 18. "Work Phone" - Enter the individual's work telephone number. 4.7 19. "Status Code" - Enter a one character status code for this individual. Possible values are: M - Member G - Guest V - Visitor P - Prospect 20. "Comments" - Enter up to sixty characters if you wish to record any notes or special comments regarding this person. 21. "Delete Member?" - To delete a member from the data base, change this value from "N" to "Y". See the section "Purge Deleted Records" for more information on the use of this field. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. You may also enter all or part of the individual's last name to automatically position the selector bar. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the program will return to the scrolling table. Active Function Keys F1 HELP - Always active 1. Press F1 at any time for a pop-up context sensitive help screen. F2 Additional Information (Dates - Talents - Skills) 1. Press F2 at any time while adding or maintaining a member to go to a pop-up menu with the following options: A) Organizations B) Talents C) Dates This allows you to maintain organizations, talents, and special dates associated with this member. 4.8 2. To make a selection, touch the letter on the keyboard corresponding to the menu selection. You may also use the <UP> or <DOWN> arrow key to position the selector bar at the option you wish to access. Press <ENTER> and the selection will be executed. To disable the pop-up menu from this screen, press <ESC>. 3. A scrolling table of all organizations, talents, or dates associated with this member will appear on the screen. Use <INS> to add a new record, or <DELETE> to purge outdated information. To maintain existing information, press <ENTER> while positioned over the desired record.. 4. The look and feel for all three options is very similar and conforms to the standard look and feel throughout the system. Each of these selections is also available as a separate option from the main menu and will be discussed in more detail later in the manual. F3 Print Label 1. You may print a single label for this member at anytime while on the MAINTAIN MEMBERS screen. Press F3 and an image of the label will appear. 2. You may now change any information on the label. 3. Press F2 to print the label or press F3 to print a label test pattern. F4 User Definable fields 1 There are 20 user definable fields at the individual level. The field descriptions may be maintained in the setup module. The fields and there sizes are: "User Desc 1" - 1 "User Desc 2" - 1 "User Desc 3" - 1 "User Desc 4" - 1 "User Desc 5" - 1 "User Desc 6" - 2 "User Desc 7" - 2 "User Desc 8" - 2 "User Desc 9" - 2 "User Desc 10" - 2 "User Desc 11" - 3 "User Desc 12" - 3 "User Desc 13" - 5 "User Desc 14" - 5 "User Desc 15" - 5 "User Desc 16" - 5 "User Desc 17" - 10 "User Desc 18" - 10 "User Desc 19" - 20 "User Desc 20" - 20 4.9 MENU SELECTION: "C) Organizations" ================================= Functional Description This option allows data entry of organizational rosters. Using this option, all the members of a specific organization may be maintained whereas using the "Individual Members" screen, organizations for a specific member could be maintained. Also note that a table of valid organizations must first be defined in the "Customize Setup" module before they may be accessed here. Step-By-Step Instructions 1. To select "Organizations" from the menu, touch the letter <C> and then press <ENTER>. The arrow keys may also be used to select this option. 2. You will then be prompted to enter an organization number. Either enter a valid organization number or press <ENTER> to view a table of all organization. After selecting an organization, press <ENTER> to go to the next field. 3. A scrolling table of all members currently belonging to the selected organization will appear. At this point, you may elect to add a new member or change information for an existing member. To return to the menu 1. To return to the MEMBER menu from the scrolling table, press <ESC>. This will return you to the organization number prompt. Press <ESC> again to return to the menu. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. To write the record at any time without editing all fields, press <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. 2. "Member Number" - Enter a valid member number or press <ENTER> to view a lookup table of all members. 3. "Comments" - Enter any desired comments regarding this individual's membership. Officers of the organization may be noted here. Up to three lines of comments may be entered. 4.10 (To modify an existing record) 1. Use the arrow keys to position the selector bar over the individual's organization record to be change. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After each field has been maintained, the program will return to this individual's scrolling table of organizations. (To delete a record) 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record. A confirmation screen will appear. 2. The confirmation screen will display the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The program will return to the individual's scrolling table of organizations. MENU SELECTION: "D) Special Talents" =================================== Functional Description This option allows data entry of information concerning members possessing a specific skill or talent. Using this option, all the members possessing a specific talent may be maintained whereas using the "Individual Members" screen, talents for a specific member could be maintained. Also note that talents must first be defined in the "Customize Setup" module before they may be accessed here. Step-By-Step Instructions 1. To select "Special Talents" from the menu, touch the letter <D> and then press <ENTER>. The arrow keys may also be used to select this option. 2. You will then be prompted to enter a talent category. Enter a valid talent category number or press <ENTER> to view a table of all talents. After you select a talent press <ENTER> to go to the next field. 4.11 3. You will be presented with a scrolling table of all members currently associated with the selected talent or skill. At this point, it is possible to add a new member or change information for an existing member. To return to the menu 1. To return to the MEMBER menu from the scrolling table, press <ESC>. This will return you to the organization number prompt. Press <ESC> again to return to the menu. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. To write the record at any time without editing all fields, press <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. 2. "Member Number" - Enter a valid member number or press <ENTER> to view a lookup table of all members. Press <ENTER> to go to the next field. 3. "Comments" - Enter any desired comments regarding this individual's membership. You may enter up to three lines of comments. Press <ENTER> to return to the individual's scrolling table of talents. (To modify an existing record) 1. Use the arrow keys to position the selector bar over the individual's talent record you wish to change. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After each field has been maintained, the program will return to this individual's scrolling table of organizations. (To delete a record) 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record. A confirmation screen will appear. 2. The confirmation screen will display the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The program will return to the individual's scrolling table of organizations. 4.12 MENU SELECTION: "E) Special Dates" ================================= Functional Description This option allows data entry of special dates by date category. Using this option, all members data associated with a specific date category may be maintained whereas using the "Individual Members" screen, all dates for a specific member could be maintained. Also note that date categories must first be defined in the "Customize Setup" module before they may be accessed here. Step-By-Step Instructions 1. To select "Special Dates" from the menu, touch the letter <E> and then press <ENTER>. The arrow keys may also be used to indicate the desired selection. 2. You will then be prompted to enter a date category. Enter a valid date category or press <ENTER> to view a table of all date categories. After selecting a date category, press <ENTER> to go to the next field. 3. A scrolling table will appear of all members for whom this special date has been entered. The table will be in date order. To quickly scroll the table, enter any month. At this point, it is possible to add a new member or change information for an existing member. To return to the menu 1. Press ESC to return to the MEMBER menu from the scrolling table. The program will return to the date category prompt. Press <ESC> again to return to the menu. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. To write the record at any time without editing all fields, press <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. 2. "Member Number" - Enter a valid member number or press <ENTER> to view a lookup table of all members. Press <ENTER> to go to the next field. 3. "Date" - Enter the date in <mmddyy> format. 4.13 4. "Comments" - Enter any desired comments regarding this record. Up to three lines of comments may be entered. Press <ENTER> to return to the individual's scrolling table of special dates. (To modify an existing record) 1. Use the arrow keys to position the selector bar over the individual's date record you wish to change. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After each field has been maintained, the program will return to this individual's scrolling table of dates. (To delete a record) 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record. A confirmation screen will appear. 2. The confirmation screen will display the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The program will return to the individual's scrolling table of organizations. MENU SELECTION: "F) Purge Deleted Records" ========================================= Functional Description This option will purge members and families that have been marked for deletion. To delete inactive families and members, change the delete flag from "N" to "Y" using the "Individual Members" option. Then, by running this option, all members who have no current donation transactions will be purged. Also, families with no members will also be purged. Step-By-Step Instructions 1. To select "Purge Deleted Records" from the menu, touch the letter <F> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. To cancel this selection, press <ESC>. To proceed, press any other key. When the process is complete, the program will return to the menu. 4.14 MAILING LABELS ============== There are several mailing label options. Mailing labels may be printed for each family or household, for each individual, or for all members of a specific organization. All labels are printed in a 3 1/2 by 15/16 inch label format. This is a standard label size and can be obtained wherever computer supplies are sold. MENU SELECTION: "G) MAILING LABELS - By Household" ================================================= Functional Description Select this option to print a mailing label for each household in the church. When only one label per household is required, this is the appropriate option to select. The names and addresses as stored in the family file will be printed in zip code order. All households may be printed or just those of one status code. Step-By-Step Instructions 1. Select "By Family" from the menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Status CD" - Enter the status code corresponding to the family or household category to be printed or leave blank to print a label for all households. 4. Reports directed to the screen may be scrolled by pressing <PageUp> and <PageDn>. They may be redirected to a printer by pressing <CTRL> <L>. When processing is complete. To return to the menu, press <ESC>. If the report was directed to a printer, it will return to the menu automatically once printing is complete. 4.15 MENU SELECTION: "H) MAILING LABELS - By Individual" ================================================== Functional Description Select this option to print mailing labels for all individuals in the church. When one label per member is required, this is the appropriate option to select. This report uses the "Label Code" field in the member's file to determine whether or not to print an individual label. If the value in that field is set to "Y", then a label will be printed. If the value is set to "N", then no label will be printed for that member. All individuals may be printed or just those of one status code. The names will appear as set up in the membership file. The addresses as set up in the family file will be printed. The order in which the labels are printed will depend on the zip code value as defined in the "Statement Sort" field in the individual's family file. Step-By-Step Instructions 1. Select "By Individual Member" from the menu by touching the letter <H> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Status CD" - Enter the status code corresponding to the category to be printed or leave blank to print a label for all individuals. 4. Reports directed to the screen may be scrolled by pressing <PageUp> and <PageDn>. They may be redirected to a printer by pressing <CTRL> <L> once processing is complete. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. 4.16 MENU SELECTION: "I) MAILING LABELS - Organization Members" ========================================================= Functional Description Select this option to print mailing labels for all members of one or more organizations within the church. Step-By-Step Instructions 1. Select "Members of Organization" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Organization No (0=All)" - To print labels for only one organization, enter the organization number. To print labels for members of all organizations leave the field blank or enter zero. Press <ENTER> to continue. 4. Reports directed to the screen may be scrolled by pressing <PageUp> and <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear when printing is complete. MENU SELECTION: "J) Label Test Pattern" ======================================= Functional Description This option will print one sample mailing label to assist in lining up the labels in the printer. Step-By-Step Instructions 1. To select "Label Test Pattern" from the menu, touch the letter <J> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Insure that the printer is ready and the labels are positioned properly in the printer. Press <ESC> to cancel the selection. To proceed, press any other key. 4.17 3. When the label has printed, make any necessary adjustment and reprint if necessary. The main menu will automatically reappear once printing is complete. REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "K) Complete Household Listing" ============================================== Functional Description This report will list details for all households/families set up in the family file. Step-By-Step Instructions 1. Select "Complete Family Listing" from the menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "L) Individual Profile Report" ============================================= Functional Description This report will list details on all members set up in the membership file. Step-By-Step Instructions 1. Select "Individual Profile Report" from the menu by touching the letter <L> and then pressing <ENTER>. The 4.18 arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "M) Special Dates Report" ======================================== Functional Description The special dates report lists significant dates which have been entered for each member. You may specify a date range as well as a specific date category at report run time. Step-By-Step Instructions 1. Select "Special Dates Report" from the menu by touching the letter <M> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Month (1 - 12)" - Enter the starting month for the range of dates to be printed. 4. "Start Day of Month" - Enter the starting day of the indicated month for the range of dates to be print. 5. "End Month (1 - 12)" - Enter the ending month for the range of dates to be printed. 6. "End Day of Month" - Enter the ending day of the indicated month for the range of dates to be printed. 7. "Date Category (0-All Categories)" - To print a special date report for only one date category, enter the category number. To include all date categories, leave the field blank or enter zero. MENU SELECTION: "N) Special Talents Report" ========================================== Functional Description This report will list all members' special talents or skills as set up in the system. 4.19 Step-By-Step Instructions 1. Select "Special Talents Report" from the menu by touching the letter <N> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Talent Category (0-All)" - To print a report for only one talent category, enter the category number. To include all talent categories, leave the field blank or enter zero. MENU SELECTION: "O) Organizational Rosters" ========================================== Functional Description Select this option to print a membership roster for any organization within the church. Step-By-Step Instructions 1. Select "Organizational Rosters" from the menu by touching the letter <O> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Organization No (0-All)" - To print a roster for only one organization, enter the organization number. To print rosters for all organizations, leave the field blank or enter zero. MENU SELECTION - "P) Complete Church Roster" =========================================== Functional Description This report will print an alphabetical roster of all members. The roster includes the members name, phone number, and the associated family name. 4.20 Step-By-Step Instructions 1. Select "Complete Church Roster" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Status CD" - Enter the status code corresponding to the category to be printed or leave blank to print a roster of all individuals. MENU SELECTION - "Q) Family Church Directory" ============================================ Functional Description This report will print a directory of all households in a two across format suitable for distribution to the congregation. Step-By-Step Instructions 1. Select "Family Church Directory" from the menu by touching the letter <Q> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Status CD" - Enter the status code corresponding to the category to be printed or leave blank to print a directory for all households. MENU SELECTION - "R) Individual Directory" ========================================= Functional Description This report will print a directory of all individuals in a two across format suitable for distribution to the congregation. Step-By-Step Instructions 1. Select "Individual Directory" from the menu by touching the letter <R> and then pressing <ENTER>. The arrow keys may also be used to select this option. 4.21 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Status CD" - Enter the status code corresponding to the category to be printed or leave blank to print a directory for all individuals. MENU SELECTION - "S) Birthday List" ================================== Functional Description This report will print a list of all individuals celebrating a birthday in a particular month. Step-By-Step Instructions 1. Select "Birthday List" from the menu by touching the letter <S> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Month" - Enter a 2 digit month code. MENU SELECTION - "T) Export Members For Mail Merge" ================================================== Functional Description This option will export certain membership information into a comma delimited, ASCII text file. The file may then be accessed by the mail merge capability of many word processors. The file "MEMBER.ASC" will be created. The following fields of information will be exported: FIRST_NAME Member's First Name LAST_NAME Member's Last Name MIDDLE_INIT Member's Middle Initial ADDRESS1 First Address Line ADDRESS2 Second Address Line ADDRESS3 Third Address Line ZIP_CODE Zip Code for sorting MEMBER_NO Member Number FAMILY_NO Family Number 4.22 The first record is a header record containing the field names. It may be necessary to remove this record prior to using this file with some word processors. This can be easily done using any ASCII text editor or word processor. Step-By-Step Instructions 1. Select "Export Members For Mail Merge" from the menu by touching the letter <T> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. When processing is complete the main menu will automatically reappear. MENU SELECTION - "U) Auto Organization Build Utility" ==================================================== Functional Description This option will automatically add or remove individuals from an organization based on a range of birthdays. 1. Select "Auto Organization Build Utility" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Select Organization" - Either enter a valid organization number or press <ENTER> to view a table of all organization. After selecting an organization, press <ENTER> to go to the next field. 3. "Beginning Birthdate" - Enter a beginning birthdate in the MM/DD/YY format. 4. "Ending Birthdate" - Enter a ending birthdate in the MM/DD/YY format. 5. "Activity" - Select "Add" to add all individuals within the birthdate range to the selected organization. Select "Remove" to remove all individuals within the birthdate range from the selected organization. 6. Press <ENTER> to begin processing, <CTL> <ESC> to abort. 4.23 V. DONATIONS ========= PROGRAM: DONATE.EXE =================== Functional Description DONATE.EXE is the executable program for the donation module. This is the module where all donation related information is processed. Step-By-Step Instructions 1. This module may be accessed by selecting DONATIONS from the main menu or by executing DONATE from the DOS command line. To execute DONATE from the DOS command line: Example: CD \CMTS33 <ENTER> DONATE <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the password prompt will not appear. Instead, a prompt requesting the user's initials will appear. Press <ENTER> at this time. 3. To make a selection from the donations menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: DONATION DATA ENTRY AND UPDATE A) Enter Donations By Name B) Enter Donations By Envelope Number C) Detail Data Entry Edit Listing D) Summary Data Entry Edit Listing E) Finalize Data Entry MISCELLANEOUS ACTIVITIES F) Member Pledge/Giving Maintenance G) Year End Roll 5.1 H) Purge History (Date Range) I) Export Donation Data * J) Statement Processing Options INQUIRIES K) Detail Donation Inquiry By Individual L) Detail Donation Inquiry By Fund M) Quarterly Fund Inquiry REPORTS N) Donation Activity By Member O) Donation Activity By Fund P) Donation Summary By Member Q) Donation Summary By Fund - Date Range R) Weekly Donation Summary S) Call List By Last Donation Date T) Quarterly Fund Summary U) Member List By Envelope # V) Alpha List With Envelope # * The selection "Statement Processing Options" displays another menu. The choices are: A) Build Statement Work File B) Print Statements C) Label Test Pattern D) Print Mailing Labels E) Single Statement - Summary Format F) Single Statement - Detail Format G) Individual Statements in Detail Format DONATION DATA ENTRY AND UPDATE ============================== The donation data entry process consists of executing several procedures from the menu in a specific order. The relationship will be detailed here. 1. Access members by either name or by envelope number when entering donations. If the individual's last name is known and available, select the option to enter donations by name. If the only available identification is the envelope number, select the option to enter donations by envelope number. 2. Once a group of donations has been entered, a data entry edit listing should be run. Either a detailed or summary listing may be run. If the information is correct, the 5.2 transactions may be finalized. If there are corrections to make or additional transactions to post, return to step 1 and repeat the cycle. 3. Once the edit listing shows that the transactions have been posted properly, select "Finalize Data Entry" to update the information. Data files should be backed up prior to running this procedure. See details on backup elsewhere in this manual. MENU SELECTION: "A) Enter Donations By Name" =========================================== Functional Description Choose this option to access members by name when entering donations. Step-By-Step Instructions 1. Select "Enter Donations By Name" from the menu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all individuals will be displayed on the screen. Use the arrow keys to position the selector bar over the record of the person to be accessed. Enter all or part of the individual's last name to quickly position the selector bar. 3. If transactions already exist for this person, a table of transactions will be displayed. If there are no existing transactions, the donation data entry form will appear. (To return to the menu) 1. Anytime the table of individuals is present, press <ESC> to return to the menu. (To add a new donation) 1. Press <INSERT>. The donation data entry form will appear. 2. "Date" - Enter the date of the transaction. Only dates for the current year or the next year may be entered. "Next Year" transactions are kept in a "future transaction" holding area until after year end processing is completed. The system will remember the last date entered in this session. If this date is correct, simply press <ENTER>. 5.3 3. "Fund" - Enter the donation category or if unknown, leave the field blank. A table of valid funds will appear. Select the fund using the arrow keys. To zero out an existing value in this field, press the space bar. When presented with the lookup table, use the arrow keys to make your selection. Press <ENTER> to go to the next field. 4. "Amount" - Enter the amount of the donation. Press the space bar to clear any existing values in this field. 5. "Reference" - Enter any information about this transaction that should be noted. Press <ENTER> to return to the individual's scrolling table of donations. 6. If all donations for this member have been entered, press <ESC>. To add another donation for this member press <INSERT>. (To modify an existing donation for this member) 1. Use the arrow keys to position the selector bar over the transaction you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the display will return to the individual's scrolling table of donations. 3. If all donations for this member have been entered, press <ESC>. (To delete a transaction) 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. The complete record will be displayed. Press <ENTER> to delete the record or <ESC> to cancel this selection. The individual's scrolling table of donations will reappear. 3. If all transactions for this member have been entered, press <ESC>. 5.4 MENU SELECTION: "B) Enter Donations By Envelope Number" ====================================================== Functional Description Choose this option to access members by envelope number when entering donations. Step-By-Step Instructions 1. Select "Enter Donations By Envelope Number" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all individuals will be displayed on the screen. Use the arrow keys to position the selector bar over the record of the person you wish to access. Enter all or part of the individual's envelope number to quickly position the selector bar. 3. If transactions already exist for this member, a table of transactions will be displayed. If there are no existing transactions, the donation data entry form will appear. (To return to the menu) 1. Anytime the table of individuals is present, press <ESC> to return to the menu. (To add a new donation) 1. Press <INSERT>. The donation data entry form will appear. 2. "Date" - Enter the date of the transaction. Only dates for the current year or the next year may be entered. "Next Year" transactions are kept in a "future transaction" holding area until after year end processing is completed. The system will remember the last date entered in this session. If this date is correct, simply press <ENTER>. 3. "Fund" - Enter the donation category or if unknown, leave the field blank. A table of valid funds will appear. Select the fund using the arrow keys. To zero out an existing value in this field, press the space bar. When presented with the lookup table, use the arrow keys to make your selection. Press <ENTER> to go to the next field. 5.5 4. "Amount" - Enter the amount of the donation. Press the space bar to clear any existing values in this field. 5. "Reference" - Enter any information about this transaction that should be noted. Press <ENTER> to return to the individual's scrolling table of donations. 6. If all donations for this member have been entered, press <ESC>. (To modify an existing donation for this member) 1. Use the arrow keys to position the selector bar over the transaction you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the display will return to the individual's scrolling table of donations. 3. If all transactions for this member have been entered, press <ESC>. (To delete a transaction) 1. Use the arrow keys to position the selector bar over the record you wish to delete. Press <DELETE> to select the record to delete. 2. The complete record will be displayed. Press <ENTER> to delete the record or <ESC> to cancel this selection. The individual's scrolling table of donations will reappear. 3. If all transactions for this member have been entered, press <ESC>. MENU SELECTION: "C) Detail Data Entry Edit Listing" ================================================== Functional Description The Detail Data Entry Edit Listing will list all transactions that have been entered since transactions were last finalized. This report should be run prior to finalizing to insure that all transaction amounts are correct and that the donations have been posted to the proper fund categories. If a data entry error it may still be corrected. 5.6 Step-By-Step Instructions 1. Select "Detail Data Entry Edit Listing" from the menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "D) Summary Data Entry Edit Listing" =================================================== Functional Description The Summary Data Entry Edit Listing will list total giving by fund category for all transactions that have been posted since transactions were last finalized. This report (or the Detail Data Entry Edit Listing) should be run prior to finalizing to insure that all transaction amounts are correct and that the donations have been posted to the proper fund categories. If a data entry error it may still be corrected. Step-By-Step Instructions 1. Select "Summary Data Entry Edit Listing" from the menu by touching the letter <D> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "E) Finalize Data Entry" ======================================= Functional Description This procedure will finalize all transactions that have been entered since it was last executed. This will create a permanent audit trail of transactions entered and update totals for both members and fund categories. Any errors discovered after running this option must be corrected by entering an adjustment. Be sure to back up all files prior to selecting this option. See the section in the manual on "Backing Up Data Files" 5.7 Step-By-Step Instructions 1. Select "Finalize Data Entry" from the menu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. MISCELLANEOUS ACTIVITIES ======================== MENU SELECTION: "F) Member Pledge/Giving Maintenance" ==================================================== Functional Description Select this option to enter and maintain the individual's donation related information. Information such as envelope number and the pledge amount for each fund may be entered here. This information is not accessible from the MEMBER module. This allows individuals that should not have access to giving information to use that module. Step-By-Step Instructions 1. To select "Member Pledge/Giving Maintenance" from the menu, touch the letter <F> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all members currently defined will appear. To return to the menu 1. To return to the DONATIONS menu from the scrolling table, press <ESC>. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. You may also enter all or part of the individual's last name to automatically position the selector bar. Press <ENTER> to select the record. 5.8 2. "Envelope Number" - Enter the individual's envelope number. Press <ENTER> to go to the next field. 3. "Combined Statement" - Values are <Y> and <N>. Enter <Y> to combine this person with other members of the same household for statement processing. A single statement will be printed for all members having this value set to <Y>. Enter <N> if this person should receive a separate statement. After all fields have been maintained, the program will return to the scrolling table. Active Function Keys F1 HELP - Always active 1. Press F1 at any time for a pop-up context sensitive help screen. F2 Enter Pledge Information By Fund 1. Press F2 at any time while maintaining the individual's pledge amounts by fund category. 2. A table of all funds to which this member has either pledged to or given to will appear. (To add a new record) 1. Press <INSERT>. 2. "Fund To Pledge" - Enter a valid fund number or press <ENTER> to view a lookup table of all funds. 3. "Annual Pledge Amount" - Enter the total annual pledge amount for this fund category. 4. "Fund Life Pledge" - If it is desired to maintain a "life of the fund pledge" for this fund, enter it here. This is especially useful for long term fund drives such as building fund drives. 5. "Next Year Pledge" - Enter the amount this member pledges to this fund for next year. This is especially useful since it permits next year's pledge amounts to be entered prior to ending the current year. 5.9 (To modify an existing record) 1. Use the arrow keys to position the selector bar over the record to be changed. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After each field has been maintained, The screen will return to this individual's scrolling table of funds. MENU SELECTION: "G) Year End Roll" ================================= Functional Description This option will move all quarter and year-to-date totals from the current year to prior year. Any next year pledge amounts will be moved to current year. Proceed with caution. All needed reports should be printed prior to executing this option. It is essential that a full backup is performed as well. Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is essential that you read and understand these sections prior to initiating this procedure! Step-By-Step Instructions 1. Select "Year End Roll" from the menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "H) Purge History (Date Range)" ============================================== Functional Description This option will purge old donation transactions for any year except the current year. Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is very important that you read and understand these section prior to initiating this procedure! 5.10 Step-By-Step Instructions 1. Select "Purge History (Date Range)" from the menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Year To Purge" - Enter the year for transactions to be purged. Press <ENTER> to continue. MENU SELECTION - "I) Export Donation Data" ========================================= Functional Description This option will export certain donation information into a comma delimited, ASCII text file. The file may then be accessed by spread sheets and custom programs written in other languages. The file "DONATE.ASC" will be created. The following fields of information will be exported: TRANS_TYPE 1=Unfinalized 2=finalized 3=history TRANS_DATE Transaction date as entered MEMBER_NO Member Number FUND_NO Fund Number AMOUNT Amount of donation REFERENCE Comment regarding transaction USERID Initials of user finalizing transaction POST_DATE Date stamp when transaction was finalized POST_TIME Time stamp when transaction was finalized The first record is a header record containing the field names. It may be necessary to remove this record prior to using this file with some spreadsheets. This can be easily done using any ASCII text editor or word processor. Step-By-Step Instructions 1. Select "Export Donation Data" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 5.11 3. "Starting Date" - Enter the starting date range for data to be exported. 4. "Ending Date" - Enter the ending date range for data to be exported. MENU SELECTION - "J) Statement Processing Options" ================================================= Functional Description This option will access a menu of statement processing options. This menu also replaces the confirmation screen that appears when reports are initiated elsewhere in the system. Step-By-Step Instructions 1. Select "Statement Processing Options" from the menu by touching the letter <J> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A statement processing menu will appear. Press <ESC> to return to the main menu. 3. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. This has no effect on the "Build Statement Work File" which processes to disk. MENU SELECTION - "A) Build Statement Work File" ============================================== Functional Description This option must be run to build a statement work file prior to processing statements. The work file will be created into a comma delimited, ASCII text file format. This will make it possible for the user to access this file in the same manner as other ASCII files that CMTS exports. The file "TEMP1.DAT" will be created. The following fields of information will exist: SORTKEY Statements sort by this value FAMILY_NO Family number of this member FUND NO Fund number FIRST_LINE Name on statement QUARTER1 Quarter 1 giving this fund QUARTER2 Quarter 2 giving this fund QUARTER3 Quarter 3 giving this fund QUARTER4 Quarter 4 giving this fund 5.12 YTD YTD giving this fund PLEDGE Pledge Amount this fund MEMBER_NO Member Number The first record is a header record containing the field names. It may be necessary to remove this record prior to using this file with some spreadsheets. This can be easily done using any ASCII text editor or word processor. Step-By-Step Instructions 1. Select "Build Statement Work File" from the statement processing menu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. When processing is complete the statement menu will automatically reappear. MENU SELECTION - "B) Print Statements" ===================================== Functional Description This option will print statements for the entire congregation. Statements will print in zip code order. In instances where the "Combined Statement Flag" is set to yes, the family name will appear on the statement and one statement will print combining all such family members. Step-By-Step Instructions 1. Insure the report direction is set as desired. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. 2. Select "Print Statements" from the statement menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. MENU SELECTION - "C) Print Mailing Labels" ========================================= Functional Description This option will print labels for all statements. Labels will print in the same order as the statements, in zip code order. In instances where the "Combined Statement Flag" is set to yes and one statement is printed for a family, one label will print. 5.13 Step-By-Step Instructions 1. Insure the report direction is set as desired. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. 2. Select "Print Mailing Labels" from the statement menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 3. Statements directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. MENU SELECTION - "D) Label Test Pattern" ======================================= Functional Description This option will print a label test pattern. Step-By-Step Instructions 1. Insure that the labels are positioned in the printer. 2. Select "Label Test Pattern" from the statement menu by touching the letter <D> and then pressing <ENTER>. The arrow keys may also be used to select this option. MENU SELECTION - "E) Single Statement - Summary Format" ====================================================== Functional Description This option will print a single statement for one member. The format used is the same as that used for printing statements in option B. It is not necessary to build the statement workfile prior to selecting this option. Combined statements cannot be printed with this option. Step-By-Step Instructions 1. Insure the report direction is set as desired. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. 2. Select "Single Statement - Summary Format" from the statement menu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to select this option. 5.14 3. "Enter Member Number" - Enter the number for the member whose statement is to be printed. Press <ESC> to cancel the report and return to the statement menu. 4. Statements directed to the screen may be scrolled by pressing <PageUp> and <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. MENU SELECTION - "F) Single Statement - Detail Format" ===================================================== Functional Description This option will print a single statement for one member. The statement will appear in a detailed format, showing all transactions for that member. Step-By-Step Instructions 1. Insure the report direction is set as desired. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. 2. Select "Single Statement - Detail Format" from the statement menu by touching the letter <F> and then pressing <ENTER>. The arrow keys may also be used to select this option. 3. "Enter Member Number" - Enter the number for the member whose statement is to be printed. Press <ESC> to cancel the report and return to the statement menu. 4. Statements directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. MENU SELECTION - "G) Print Statements In Detail Format" ====================================================== Functional Description This option will print statements for all individuals in a detailed format showing all transactions for that person. Step-By-Step Instructions 1. Insure the report direction is set as desired. Press <F2> to toggle the report direction between <SCREEN> and <PRINTER>. 5.15 2. Select "Print Statements in Detail Format" from the statement menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. INQUIRIES ========= MENU SELECTION - "K) Detail Inquiry By Individual" ================================================= Functional Description Select this option to view transaction details for any member. Step-By-Step Instructions 1. Select "Detail Inquiry By Individual" from the menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Select Transaction Type" - Enter the desired transaction type. Valid choices are: 1 Unfinalized 2 Current Year 3 History 4 Future 3. "Member Number" - Enter a valid member number or press <ENTER> to view a lookup table of all members. 4. A detailed display of all transactions for this person will appear. Scroll through these transactions by using the <UP> and <DOWN> arrow keys as well as the <PG UP> and <PG DOWN> keys. To select another member, press <ESC>. 5. To select another transaction type, press <ESC> again. MENU SELECTION: "L) Detail Inquiry By Donation Category" ======================================================= Functional Description Select this option to view transaction details for any fund. Step-By-Step Instructions 1. Select "Detail Inquiry By Donation Category" from the menu by touching the letter <L> and then pressing <ENTER>. The arrow keys may also be used to select this option. 5.16 2. "Select Transaction Type" - Enter the desired transaction type. Valid choices are: 1 Unfinalized 2 Current Year 3 History 4 Future 3. "Fund Number" - Enter a valid fund number or press <ENTER> to view a lookup table of all funds. 4. A detailed display of all transactions for this fund will appear. Scroll through these transactions by using the <UP> and <DOWN> arrow keys as well as the <PG UP> and <PG DOWN> keys. To select another fund, press <ESC>. 5. To select another transaction type, press <ESC> again. MENU SELECTION: "M) Quarterly Summary Donation Inquiry" ====================================================== Functional Description Select this option to view summary information by fund category for the current and prior year. Step-By-Step Instructions 1. Select "Quarterly Donation Summary Inquiry" from the menu by touching the letter <M> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A table of funds will be displayed. Use the arrow keys to position the highlight bar over the desired record. The <PageUp> and <PageDown> keys are also active. Press <ENTER> to view the selected record. Press <ESC> to return to the menu. 3. A display of current year and prior year totals for this fund will appear. To select another fund, press <ESC>. REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. 5.17 Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "N) Activity Report - Individual" ================================================ Functional Description This report will print a listing of all donations in the transaction file sorted by member for a given date range. Step-By-Step Instructions 1. Select "Activity Report - Individual" from the menu by touching the letter <N> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 4. "End Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to continue. MENU SELECTION: "O) Activity Report By Fund" =========================================== Functional Description This report will print a listing of all donations in the transaction file sorted by fund for a given date range. Step-By-Step Instructions 1. Select "Donation Activity By Fund" from the menu by touching the letter <O> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 5.18 3. "Start Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 4. "End Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to continue. MENU SELECTION: "P) Donation Summary By Individual" ================================================== Functional Description This report will print a summary listing of all donations with totals sorted by member and grouped by fund for a given date range. Step-By-Step Instructions 1. Select "Donation Summary By Individual" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 4. "End Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to continue. MENU SELECTION: "Q) Donation Summary By Fund-Date Range" ==================================================== Functional Description This report will print a summary listing of all donation totals sorted by fund for a given date range. Step-By-Step Instructions 1. Select "Donation Summary By Fund" from the menu by touching the letter <Q> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 5.19 3. "Start Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 4. "End Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to continue. MENU SELECTION: "R) Weekly Donation Summary" =========================================== Functional Description This report will print a weekly summary of all donation totals sorted by fund for a given date range. Each week ending date is a Sunday date and will reflect all transactions posted during the week ending on that day (Monday thru Sunday). Step-By-Step Instructions 1. Select "Weekly Donation Summary" from the menu by touching the letter <R> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 4. "End Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to go to the next field. 5. "Fund Category (0=All)" - Enter the desired fund category. For all categories, enter zero or leave the field blank. Press <ENTER> to continue. MENU SELECTION: "S) Call List By Last Donation Date" =================================================== Functional Description This report will print a convenient call list based on the last date of a individual's donations. People that have not given since the indicated date will appear on the report. Step-By-Step Instructions 1. Select "Call List By Last Donation Date" from the menu by touching the letter <S> and then pressing <ENTER>. The arrow keys may also be used to select this option. 5.20 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Last Donation Date" - Enter the last donation date in <MMDDYY> format. Press <ENTER> to continue. MENU SELECTION: "T) Quarterly Fund Summary" ========================================== Functional Description This report will print a summary of all fund totals by quarter. Current year and prior year totals are printed. Step-By-Step Instructions 1. Select "Quarterly Fund Summary" from the menu by touching the letter <T> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "U) Member List By Envelope Number" ================================================== Functional Description This report will print a list of all individuals in envelope number order. Step-By-Step Instructions 1. Select "Member List By Envelope Number" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 5.21 MENU SELECTION: "V) Alpha List with Envelope Number" =================================================== Functional Description This report will print an alphabetical list of all individuals showing the envelope number. Step-By-Step Instructions 1. Select "Alpha List with Envelope Number" from the menu by touching the letter <V> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 5.22 VI. FUND ACCOUNTING =============== PROGRAM: FUND.EXE ================= Functional Description FUND.EXE is the executable program for the fund accounting module. The fund accounting module is extremely powerful, yet incredibly easy to use. It is designed to allow individuals with limited accounting knowledge to manage all of the financial transactions of the church. Often, "fund accounting" packages are adapted from business systems. They are not always well suited to handle fund accounting. In many instances, funds must be set up as liability accounts. Sources of funds (income) and uses of funds (expenses) must be assigned to departments to track changes in fund equity. This approach usually requires "four- sided" bookkeeping. This system was designed and written specifically for churches and other non-profit organizations that use fund accounting. It differs from business general ledger systems in several important aspects. An account is created for each fund in the fund equity section of the balance sheet. When a source of funds (income) account or a use of funds (expense) account is created, the related fund equity account must be identified. Whenever a transaction effects an income or expense account, the appropriate fund equity account is updated as well. This is a double entry general ledger system. However, the system automatically generates the appropriate entries for deposits, checks, fund transfers and bank service charges. The software is furnished with sample data files. Use these files to get acquainted with the various functions prior to beginning the live installation. Become familiar with the various features of the software. Prior to implementing the system, thoroughly read the sections of this manual titled "Live Implementation" and "Special Considerations". 6.1 Step-By-Step Instructions 1. This module may be accessed by selecting FUND ACCOUNTING from the main menu or by executing DONATE from the DOS command line. To execute FUND from the DOS command line: Example: CD \CMTS33 <ENTER> FUND <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the password prompt will not appear. Instead, a prompt requesting your initials will appear. Press <ENTER> at this time. 3. To make a selection from the fund accounting menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The main menu and the sub menu choices are: MAINTAIN FILES A) General Ledger Accounts B) Budget Information C) Bank Information D) Vendors E) Auto Build Next Year's Budget F) Reset Next Year's Budget Back to Zero G) Chart of Accounts H) Monthly Budget Information I) Annual Budget Information J) Actual/Budgeted Variance Report K) Bank File Listing L) Vendor File Listing DATA ENTRY A) Enter Transactions B) Data Entry Edit Listing C) Finalize Transactions D) Check Reconciliation E) Check Register F) Outstanding Check List 6.2 INQUIRIES A) Transaction Detail Inquiry B) Account Inquiry C) Check Register PERIOD END PROCESSING A) Prepare For Monthly Financial Reports B) Monthly Financial Report C) Monthly Trial Balance D) Account Detail Report YEAR END PROCESSING E) Year End Processing F) Purge Old Transactions G) Purge Deleted Accounts REPORTS A) Chart of Accounts B) Revenue and Expenditure Statement C) Sources and Uses of Funds (Detail) D) Trial Balance E) Actual vs Budgeted Report F) Check Register G) Outstanding Check List H) Transaction Audit Trail I) Balance Sheet J) Changes in Fund Equity K) Fund Equity Account Analysis L) Monthly Budget Information M) Annual Budget Information N) Monthly Financial Report O) Monthly Trial Balance P) Account Detail Report Q) Actual/Budgeted Variance Report SUB MENU: A) Maintain Files =========================== Select this menu from the main fund accounting menu by touching the letter <A> and pressing <ENTER>. To return to the main fund accounting menu, press <ESC>. 6.3 File Maintenance Activities =========================== These selections are available to add and maintain general ledger accounts, banks, and vendors. Sample files are supplied with the system. However the section on live implementation must be read and understood thoroughly prior to proceeding. In the initial installation, these files should be built in the order described. MENU SELECTION: "A) General Ledger Accounts" =========================================== Functional Description Select this option to add or maintain general ledger accounts. Step-By-Step Instructions 1. To select "General Ledger Accounts" from the Maintain Files menu, touch the letter <A> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A menu of valid account types will appear. These account types are: A) Assets B) Liabilities C) Fund Equity Accounts D) Sources of Funds (Revenue) E) Uses of Funds (Expenditures) F) Optional Title Accounts Touch the letter corresponding to the account type to be referenced. Press <ENTER> to continue. 3. A scrolling table of all accounts for the selected account type will appear. At this point, new accounts may be added, or existing accounts may be maintained. To return to the menu 1. To return to the Maintain Files submenu from the account submenu, press <ESC>. 6.4 To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. If information does not need to be entered in all fields, write the record at any time by pressing <CTRL> <ENTER>. To completely cancel entry for this record, press <CTRL ESC>. 2. "Account" - Enter the account number to be assigned to this account. 3. "Description" - Enter up to 30 characters which names this account. (The next field applies to Revenue and Expense Accounts only) 4. "Associated Fund" - Enter the account number for the associated fund equity account. Press <ENTER> if this number is unknown. Select from a table of existing fund equity accounts. After entering or selecting the associated fund equity account press <ENTER> to go to the next field. 5. "Delete" - To delete an account, change this value from <N> to <Y>. Only accounts with zero balance and no activity will be deleted. Press <ENTER> to return to the scrolling table. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. You may also enter all or part of the account number to automatically position the selector bar. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. If it is not necessary to enter information in all fields, write the record at any time by pressing <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. After all fields have been maintained, the program will return to the scrolling table. To return to the account type menu 1. From any of the account tables, press <ESC> to return to the menu of account types. 6.5 MENU SELECTION: "B) Budget Information" ====================================== Functional Description Select this option to maintain current or next year budget information. Step-By-Step Instructions 1. To select "Budget Information" from the Maintain Files menu, touch the letter and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all income and expense accounts will appear. Position the highlight bar on the account to be maintained and press <ENTER>. For fast access, type the account number and press <ENTER>. 3. "Annual Budget For This Year" - Enter the annual budget for this account for this year. The monthly budget for each month will automatically be one twelfth of the total. If varying monthly budgets are desired, leave this field blank. 4. "Annual Budget For Next Year" - Enter the annual budget for this account for next year. The monthly budget for each month will automatically be one twelfth of the total. If varying monthly budgets are desired, leave this field blank. 5. "This Year Monthly Budget Amount 1 - 12" - Instead of entering an annual budget amount, enter the budget amounts for each month if they vary. 6. "Next Year Monthly Budget Amount 1 - 12" - Instead of entering an annual budget amount, enter the budget amounts for each month if they vary. To return to the menu 1. To return to the Maintain Files submenu from the account submenu, press <ESC>. MENU SELECTION: "C) Bank Information" ==================================== Functional Description Select this option to add or maintain bank checking accounts. 6.6 Step-By-Step Instructions 1. To select "Bank Information" from the Maintain Files submenu, touch the letter <C> and then press <ENTER>. The arrow keys may also be used to indicate the selection. 2. A scrolling table of all existing bank accounts will appear. At this point, new bank accounts may be added, or existing accounts may be maintained. To return to the menu 1. To return to the maintain files submenu from the bank information table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel entry for this record, press <CTRL ESC>. 2. "Bank Number" - Enter a number referencing this bank, checking the account number to be assigned to this account or accept the system generated number. 3. "Bank Name" - Enter up to thirty characters for the bank name. 4. "Description of Acct" - Enter up to 30 characters of extended description for this account. Press <ENTER> to go to the next field. 5. "Check Account Number" - Enter the bank check account number (the bank assigned account number as printed on checks). Press <ENTER> to go to the next field. 6. "Related GL Cash Acct" - Enter the related general ledger asset account. This account must already exist in the chart of accounts. Press <ENTER> if this number is unknown. Enter the account type and select from a table of accounts. After entering or selecting the associated cash account press <ENTER> to go to the next field. 6.7 7. "Related GL Expense Acct" - Enter the related general ledger expense account. This account must already exist in the chart of accounts. Press <ENTER> if this number is unknown. Enter the account type and select from a table of accounts. After entering or selecting the associated cash account press <ENTER> to go to the next field. 8. "Address" - Enter up to three lines for the bank address. Press <ENTER> to go to the next field. 9. "Telephone" - Enter the bank telephone number. Press <ENTER> to continue. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. After all fields have been maintained, the program will return to the scrolling table. MENU SELECTION: "D) Vendors" =========================== Functional Description Select this option to add or maintain vendors. This file will provide quick access to the "PAYEE" field when entering checks. The last check amount and date is updated in the vendor file whenever a vendor record is referenced in CHECK transactions. Step-By-Step Instructions 1. To select "Vendors" from the maintain files submenu, touch the letter <D> and then press <ENTER>. The arrow keys may also be used to indicate the selection. 2. A scrolling table of all existing vendors will appear. At this point, new vendors may be added, or existing records may be maintained. 6.8 To return to the menu 1. To return to the maintain files submenu from the vendor table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel entry for this record, press <CTRL ESC>. 2. "Name" - Enter the company name for this vendor. 3. "Address" - Enter up to three lines for the vendor address. 4. "Telephone" - Enter the vendor telephone number. 5. "Fax" - Enter the vendor fax number. 6. "Comments" - Enter up to a thirty-two character comment regarding this vendor. Press <ENTER> to continue. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. After all fields have been maintained, the program will return to the scrolling table. MENU SELECTION: E) Autobuild Next Year's Budget =============================================== Functional Description Select this option to automatically build next year's budget information as a percent of the current year's budget. Before running this option and any option that updates the data files, a backup of all data files is highly recommended. 6.9 Step-By-Step Instructions 1. To select "Autobuild Next Year's Budget" from the maintain files menu, touch the letter <E> and then press <ENTER>. The arrow keys may also be used to select this option. 2. "Next Years Budge Factor" - Enter next year's budget as a percent of the current year's budget. For instance, to increase the budget by 10%, enter 110.0 since next year's budget will be 110% of the current year's. The system will automatically build next year's budget and then return to the menu. At that point, individual account's may be maintained or changed as desired. MENU SELECTION: F) Reset Next Year's Budget Back to Zero" ======================================================== Functional Description Select this option to reset next year's budget figures back to zero. Please note this option will wipe out all of next year's budget and should be used with caution. Before running this option and any option that updates the data files, a backup of all data files is highly recommended. Step-By-Step Instructions 1. To select "Reset Next Year's Budget" from the Maintain Files menu, touch the letter <F> and then press <ENTER>. The arrow keys may also be used to select this option. 2. Press <ESC> to cancel this selection or any other key to proceed. REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. 6.10 Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "G) Chart of Accounts" ===================================== Functional Description This report will print a list of all accounts in the chart of accounts. Step-By-Step Instructions 1. Select "Chart of Accounts" from the maintain files menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "H) Monthly Budget Information" ============================================== Functional Description This report will print a list of budget information for all income and expense accounts at a monthly level. Step-By-Step Instructions 1. Select "Monthly Budget Information" from the maintain files menu by touching the letter <H> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 6.11 MENU SELECTION: "I) Annual Budget Information" ============================================== Functional Description This report will print a list of budget information for all income and expense accounts at a annual level. Step-By-Step Instructions 1. Select "Annual Budget Information" from the maintain files menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "J) Actual/Budgeted Variance Report" =================================================== Functional Description This report will show actual vs. budgeted amounts for the current year as well as the variance and next year's budget for all income and expense accounts at a annual level. It is a very useful report to run as part of budget preparation. Step-By-Step Instructions 1. Select "Actual/Budgeted Variance Report" from the maintain files menu by touching the letter <J> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "K) Bank File Listing" ====================================== Functional Description This report will show a listing of all banks that have been set up in the bank file. 6.12 Step-By-Step Instructions 1. Select "Bank File Listing" from the maintain files menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "L) Vendor File Listing" ====================================== Functional Description This report will show a listing of all vendor that have been set up in the vendor file. Step-By-Step Instructions 1. Select "Vendor File Listing" from the maintain files menu by touching the letter <L> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. SUBMENU: B) Data Entry ====================== Select this menu from the main fund accounting menu by touching the letter and pressing <ENTER>. To return to the main fund accounting menu, press <ESC>. Transaction Data Entry ====================== The data entry process consists of executing several procedures from the menu in a specific order. The relationship will be detailed here. This process consists of three steps. These steps are: Step 1. Enter Transactions Enter transactions using one of five transaction types. 6.13 Step 2. Print Data Entry Edit Listing Once a group of transactions have been entered, a transaction edit listing should be run. If the information on the edit listing is correct, the transactions may be finalized. If there are corrections to make or additional transactions to enter, return to step 1 and repeat the cycle. Step 3. Finalize Transactions Once the edit listing shows that the transactions have been posted properly, select "Finalize Transactions" to update the information. Data files should be backed up prior to running this procedure. See details on backup elsewhere in this manual. MENU SELECTION: "A) Enter Transactions" =================================== Functional Description Choose this option to enter financial transactions. Four different "automatic" transaction types are provided. There is also a transaction type to enter miscellaneous journal entries. Step-By-Step Instructions 1. Select "Enter Transactions" from the data entry menu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all transactions that have not been finalized will appear. At this point, press <INSERT> to add a new transaction or select an existing transaction to maintain and press <ENTER>. NOTE: When entering the first transaction, the data entry form will appear immediately without pressing <INSERT>. (To return to the menu) 1. To return to the data entry submenu from the Transactions Menu, press <ESC>. 6.14 (To add a new transaction) 1. Press <INSERT>. A pop-up menu of transaction types will appear. These choices are: A) Bank Deposits B) Checks (Cash Disbursements) C) Miscellaneous Bank Charges D) Fund Transfers E) Miscellaneous Journal Entries Touch the letter corresponding to the desired transaction type and press <ENTER>. (Bank Deposits - Transaction Header) When this transaction type is selected, the deposit amount and other header information must be entered. A distribution screen will then permit entry of all sources of funds and other accounts related to this deposit. The total distribution amount must equal the deposit amount. When the transaction is finalized, the bank asset account will automatically be debited and each distribution account will be credited. 1. "Journal Code" - Enter up to seven characters to indicate the journal code or type. The default value is "DEPOSIT". 2. "Deposit Date" - Enter a valid transaction date in <MMDDYY> format. This date should be the actual date of the transaction, not today's date. The system will automatically place the transaction in the proper period based on the date entered. Only valid dates for the current and next fiscal year will be accepted. The system will automatically recognize a future date and hold the information until after year ending processing. When entering several transactions in one session, the system will automatically use the date of the prior transaction as a default date. Press the space bar to clear this date. 6.15 3. "Bank Number" - Enter the bank number representing the bank account to which the deposit will be made. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all bank accounts. Select the bank and then press <ENTER> to go to the next field. 4. "Deposit Amount" - Enter the amount of the deposit. Press <ENTER> to go to the next field. 5. "Reference" - Enter up to thirty characters to reference this transaction. Press <ENTER> to continue. 6. Press <F2> to enter or edit distributions pertaining to this deposit. Press <ENTER> when the distribution records have been entered and the amount remaining to distribute is zero. If you attempt to leave this screen by pressing <ENTER> prior to entering the distribution records, you will receive the message "Distribution Must Balance - Press <F2> to edit detail". (Bank Deposits - Distribution) 1. A scrolling table of all distribution records will appear. At this point, press <INSERT> to add a new distribution or select a record to maintain and press <ENTER>. NOTE: When entering the first record, the data entry form will appear immediately without pressing <INSERT>. 2. "Acct #" - Enter the general ledger account number representing this distribution record. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all general ledger accounts. Enter an account type and press <ENTER> to view the accounts within this type. Select the account and then press <ENTER> to go to the next field. 3. "Distribution Amount" - Enter the distribution amount for this account. 4. "Description" - Enter up to thirty characters to reference this distribution. Press <ENTER> to continue. 6.16 5. The screen will show the deposit amount, amount distributed, and the amount remaining to be distributed. Press <INS> to add another distribution record or select an existing record and press <ENTER> to maintain the record. Press <ESC> to return to the deposit header screen. (Checks - Transaction Header) When this transaction type is selected, the check amount and other header information must be entered. A distribution screen will then permit entry of all uses of funds and other accounts related to the check. The total distribution amount must equal the check amount. When the transaction is finalized, the bank asset account will automatically be credited and each distribution account will be debited. 1. "Journal Code" - Enter up to seven characters to indicate the journal code or type. The default value is "CHECK". Press <ENTER> to go to the next field. 2. "Check Date" - Enter a valid transaction date in <MMDDYY> format. This date should be the actual check date, not today's date. The system will automatically place the transaction in the proper period based on the date entered. Only valid dates for the current and next fiscal year will be accepted. The system will automatically recognize a future date and hold the information until after year ending processing. When entering several transactions in one session, the system will automatically use the date of the prior transaction as a default date. Press the space bar to clear this date. After the date has been entered, press <ENTER> to go to the next field. 3. "Bank Number" - Enter the bank number representing the bank account from which this check will be drawn. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all bank accounts. Select the bank and then press <ENTER> to go to the next field. 4. "Check Number" - Enter the check number for this check. Press <ENTER> to go to the next field. 6.17 5. "Payee" - Enter the name of the payee for this check or press <F3> to select from the list of vendors in the vendor file. 6. "Check Amount" - Enter the amount of the check. Press <ENTER> to go to the next field. 5. "Reference" - Enter up to thirty characters to reference this transaction. Press <ENTER> to continue. 6. Press <F2> to enter or edit distributions pertaining to this deposit. Press <ENTER> when the distribution records have been entered and the amount remaining to distribute is zero. If you attempt to leave this screen by pressing <ENTER> prior to entering the distribution records, you will receive the message "Distribution Must Balance - Press <F2> to edit detail". (Checks - Distribution) 1. A scrolling table of all distribution records will appear. Press <INSERT> to add a new distribution or select an record to maintain and press <ENTER>. NOTE: When entering the first record, the data entry form will appear immediately without pressing <INSERT>. 2. "Acct #" - Enter the general ledger account number representing this distribution record. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all general ledger accounts. Enter an account type and press <ENTER> to view the accounts within this type. Select the account and then press <ENTER> to go to the next field. 3. "Distribution Amount" - Enter the distribution amount for this account. 4. "Description" - Enter up to thirty characters to reference this distribution. Press <ENTER> to continue. 5. The screen will show the check amount, amount distributed, and the amount remaining to be distributed. Press <INS> to add another distribution record or select an existing record and press <ENTER> to maintain the record. Press <ESC> to return to the check header screen. 6.18 (Miscellaneous Bank Charges) When this transaction type is selected, the service charge amount and related information must be entered. There is no distribution screen for this type transaction. When the transaction is finalized, the bank asset account will automatically be credited and the bank expense account will be debited. 1. "Journal Code" - Enter up to seven characters to indicate the journal code or type. The default value is "SCHARGE". Press <ENTER> to go to the next field. 2. "Trans Date" - Enter a valid transaction date in <MMDDYY> format. This date should be the actual service charge date, not today's date. The system will automatically place the transaction in the proper period based on the date entered. Only valid dates for the current and next fiscal year will be accepted. The system will automatically recognize a future date and hold the information until after year ending processing. When entering several transactions in one session, the system will automatically use the date of the prior transaction as a default date. Press the space bar to clear this date. 3. "Bank Number" - Enter the bank number representing the bank account from which this service charge will be credited. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all bank accounts. Select the desired bank by pressing <ENTER>. 4. "Credit Amount" - Enter the amount of the service charge. 5. "Reference" - Enter up to thirty characters to reference this transaction. Press <ENTER> to continue. The transaction header screen will appear. There is no distribution made for bank service charges. The transaction is made automatically. 6.19 (Fund Transfers - Transaction Header) When this transaction type is selected, the transfer amount and other header information must be entered. A distribution screen will then permit entry of all fund equity accounts to which funds are to be transferred. The total distribution amount must equal the transfer amount. When the transaction is finalized, the "from" fund equity account will automatically be debited and each account that funds are transferred to will be credited. 1. "Journal Code" - Enter up to seven character to indicate the journal code or type. The default value is "FUNDTRS". 2. "Transfer Date" - Enter a valid transaction date in <MMDDYY> format. This date should be the actual transaction date, not today's date. The system will automatically place the transaction in the proper period based on the date entered. Only valid dates for the current and next fiscal year will be accepted. The system will automatically recognize a future date and hold the information until after year ending processing. When entering several transactions in one session, the system will automatically use the date of the prior transaction as a default date. Press the space bar to clear this date. 3. "Transaction From Fund #" - Enter the fund account number for the fund the transfer is coming from. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all fund equity accounts. Select the desired account. 4. "Amount" - Enter the amount of the transfer. This is the amount being transferred from the referenced fund. 5. "Reference" - Enter up to thirty characters to reference this transaction. 6. Press <F2> to enter or edit distributions pertaining to this fund transfer. Press <ENTER> when the distribution records have been entered and the amount remaining to distribute is zero. If <ENTER> is pressed prior to entering the distribution records, the message "Distribution Must Balance - Press <F2> to edit detail" will appear. 6.20 (Fund Transfers - Distribution) 1. A scrolling table of all distribution records will appear. At this point, press <INSERT> to add a new distribution or select a record to maintain and press <ENTER>. NOTE: When entering the first record, the data entry form will appear immediately without pressing <INSERT>. 2. "Acct #" - Enter a fund equity account number representing all or part of the transfer. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all fund equity accounts. Select the account and then press <ENTER> to go to the next field. 3. "Distribution Amount" - Enter the distribution amount for this account. 4. "Description" - Enter up to thirty characters to reference this distribution. Press <ENTER> to continue. 5. The screen will show the transfer amount, amount distributed, and the amount remaining to be distributed. Press <INS> to add another distribution record or select an existing record and press <ENTER> to maintain the record. Press <ESC> to return to the transfer header screen. (Miscellaneous Journal Entries - Transaction Header) When this transaction type is selected, certain information related to the transaction must be entered. A distribution screen will then permit direct entry of debits and credits as required. Total debits must equal total credits. When the transaction is finalized, all appropriate accounts will be updated. 1. "Journal Code" - Enter up to seven characters to indicate the journal code or type. The default value is "JOURNAL". Press <ENTER> to go to the next field. 2. "Transaction Date" - Enter a valid transaction date in <MMDDYY> format. This date should be the actual transaction date, not today's date. The system will automatically place the transaction in the proper period based on the date entered. 6.21 Only valid dates for the current and next fiscal year will be accepted. The system will automatically recognize a future date and hold the information until after year ending processing. When entering several transactions in one session, the system will automatically use the date of the prior transaction as a default date. Press the space bar to clear this date. After the date has been entered, press <ENTER> to go to the next field. 3. "Description" - Enter up to thirty characters to reference this transaction. Press <ENTER> to continue. 4. Press <F2> to enter or edit journal entries. Press <ENTER> when all records have been entered and the proof amount is zero. If the transactions are out of balance, it is not possible to exit this screen. (Journal Distribution) 1. A scrolling table of all distribution records will appear. At this point, press <INSERT> to add a new distribution or select an record to maintain and press <ENTER>. NOTE: When entering the first record, the data entry form will appear immediately without pressing <INSERT>. 2. "Acct #" - Enter an account number. If the number is unknown, press <ENTER> and a scrolling table will pop up displaying all general ledger accounts. Enter an account type and press <ENTER> to view the accounts within this type. Select the account and then press <ENTER> to go to the next field. 3. "Debit Amount" - Enter the debit amount for this account or leave blank if this is a credit entry. 4. "Credit Amount" - This field may be accessed only if the debit amount field is left blank. Enter the credit amount for this account. 5. "Description" - Enter up to thirty characters to reference this distribution. Press <ENTER> to continue. 6.22 6. The screen will show the proof (difference between debits and credits) and debit and credit totals. Press <INS> to add another distribution record or select an existing record and press <ENTER> to maintain the record. Press <ESC> to return to the header screen. MENU SELECTION: "B) Data Entry Edit Listing" ============================================ Functional Description The Transaction Edit Listing will list all transactions that have been posted since transactions were last finalized. This report should be run prior to finalizing to insure that all transaction amounts are correct. If there is a data entry error it may still be corrected. Step-By-Step Instructions 1. Select "Data Entry Edit Listing" from the data entry submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "C) Finalize Transactions" ========================================== Functional Description This procedure will finalize all current year transactions that have been entered since it was last executed. This will create a permanent audit trail of transactions entered and update totals in the general ledger account file, bank file, and vendor file. Any errors discovered after running this option must be corrected by entering an adjustment. "Next year" transactions will be given a special "future" type transaction status until year ending processing occurs. Be sure to back up all files prior to selecting this option. See the section in the manual on "Backing Up Data Files" Step-By-Step Instructions 1. Select "Finalize Transactions" from the menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 6.23 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. When processing is complete the main menu will automatically reappear. Other Data Entry Activities =========================== MENU SELECTION: "D) Check Reconciliation" ======================================== Functional Description Select this option to indicate when checks, deposits, and other bank transactions have cleared the bank. Step-By-Step Instructions 1. To select "Check Reconciliation" from the menu, touch the letter <D> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table will appear. At this point, a bank may be selected. To return to the menu 1. To return to the data entry submenu from the scrolling table, press <ESC>. To maintain a record 1. "Enter Bank Number" - Enter the number associated with the desired bank or leave blank and press <ENTER> for a table of possible banks. After selecting a bank, press <ENTER>. 2. All transactions for the chosen bank will appear on the scrolling table. Quickly locate and access a specific transaction by entering a date. The arrow keys, <PAGEUP>, and <PAGEDN>, may also be used. Select the desired transaction and press <ENTER>. 3. "Cleared" - Indicate whether this transaction has cleared the bank. Choices are Cleared and Outstanding and Void. 4. The scrolling table will reappear. Another transaction may be selected. To terminate work on this bank, press <ESC>. The cursor will return to the "Bank No" prompt. 6.24 REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "E) Check Register" ================================== Functional Description This report will print a check register for a date range for all banks. Step-By-Step Instructions 1. Select "Check Register" from the maintain files submenu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Starting Date" - Enter in <MMDDYY> format the starting date range. 4. "Ending Date" - Enter in <MMDDYY> format the ending date range. 5. "Enter Bank Number" - Enter the bank number or leave blank if a report for all banks is desired. 6.25 MENU SELECTION: "F) Outstanding Check List" ========================================== Functional Description This report will print a list of outstanding checks for one or all banks. Step-By-Step Instructions 1. Select "Outstanding Check List" from the maintain files submenu by touching the letter <F> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Bank Number" - Enter the bank number or leave blank if a report for all banks is desired. SUBMENU: C) INQUIRIES ===================== Select this menu from the main fund accounting menu by touching the letter <C> and pressing <ENTER>. To return to the main fund accounting menu, press <ESC>. MENU SELECTION - "A) Transaction Detail Inquiry" =============================================== Functional Description Select this option to view transaction details. Step-By-Step Instructions 1. Select "Transaction Detail Inquiry" from the inquiries submenu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Select Trans Type" - Enter the desired transaction type. Valid choices are: 1 Unfinalized 2 Current Year 3 History 4 Future 6.26 3. "Transaction Number" - A scrolling table of the selected type of transactions will appear. Scroll through these transactions by using the <UP> and <DOWN> arrow keys as well as the <PG UP> and <PG DOWN> keys. To select another transaction type, press <ESC>. MENU SELECTION: "B) Account Inquiry" =================================== Functional Description Select this option to view account period totals for the current and prior year. Step-By-Step Instructions 1. Select "Account Inquiry" from the inquiries submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Account Category" - Enter the desired account type. Valid choices are: 1 Asset 2 Liability 3 Fund Equity 4 Sources of Funds (Income) 5 Uses of Funds (Expense) Press <ENTER> to continue. 3. A scrolling table of the selected type of transactions will appear. Scroll through these transactions by using the <UP> and <DOWN> arrow keys as well as the <PG UP> and <PG DOWN> keys. For fast access to a particular account, enter part or all of the description. To select another transaction type, press <ESC>. MENU SELECTION: "C) Check Register" ================================== Functional Description Select this option to view a check register for any bank. Step-By-Step Instructions 1. Select "Check Register" from the inquiry submenu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 6.27 2. "Bank" - Enter the bank number or press <ENTER> for a lookup table of valid banks. Select the bank and press <ENTER>. 3. "Start Date" - A table of transactions for the selected bank will appear on the screen. Use the arrow keys to browse the highlight table. The <PageUp> and <PageDown> keys are also active. To quickly locate a particular transaction, enter a transaction date. Press <ESC> to return to the bank prompt. Press <ESC> again to return to the menu. SUBMENU: D) PERIOD END PROCESSING ================================= Select this menu from the main fund accounting menu by touching the letter <D> and pressing <ENTER>. To return to the main fund accounting menu, press <ESC>. PERIOD END PROCESSING ===================== The options in this section are options that should be run after all transaction for a particular period. MENU SELECTION: "A) Prepare For Monthly Financial Reports" ========================================================= Functional Description Select this option to generate the necessary report data for running the monthly reports under options B and C. Step-By-Step Instructions 1. Select "Prepare for Monthly Financial Reports" from the period end processing submenu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Enter Fiscal Period" - Enter the 2 digit fiscal period for which reports are to be run. This can be any period of the current year, not necessarily the current period. Press <ENTER> to continue. 6.28 MENU SELECTION: "B) Monthly Financial Report" ============================================ Functional Description This report shows the MTD and YTD totals for all income and expense accounts as well as the annual budget and current percent of budget. Most churches will want to run this report at the end of each month. In instances where adjusting entries must be made in prior months, this report may be rerun. Always run option A prior to running this report. Step-By-Step Instructions 1. Select "B) Monthly Financial Report" from the period end processing submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "C) Monthly Trial Balance" ========================================= Functional Description This report shows the YTD balance in each account at the end of any accounting period. Always run option A prior to running this report to specify the accounting period. Step-By-Step Instructions 1. Select "C) Monthly Trial Balance" from the period end processing submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. YEAR END PROCESSING =================== The options in this section are options that should be run after all transaction for the year are complete. Once year end processing is completed, transactions may no longer be entered for the then current year. 6.29 MENU SELECTION: "E) Year End Roll" ================================= Functional Description This option will move all period amounts and budget amounts from the current year to the prior year. Current year transactions will be marked as history transactions. Any future transactions will be marked as current transactions and must then be finalized. This option should not be executed until after all adjusting entries for the current year have been entered. This system automatically places transactions in the proper period based on transaction date. Based on this philosophy, the system allows your adjusting entries to also effect the proper period. Since the system allows for the entry of future transactions, it is not necessary to end the year prior to entering transactions for next year. Be sure all transactions for the current year have been entered before proceeding.! Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is very important to read and understand these section prior to initiating this procedure! Step-By-Step Instructions 1. Select "Year End Roll" from the menu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to selects this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "F) Purge Old Transactions" ========================================== Functional Description This option will purge old transactions for any year except the current year. Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is very important that you read and understand these sections prior to initiating this procedure! 6.30 Step-By-Step Instructions 1. Select "Purge Old Transactions" from the menu by touching the letter <F> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Year To Purge" - Enter the year for transactions to be purged. Press <ENTER> to continue. MENU SELECTION: "G) Purge Deleted Accounts" ========================================== Functional Description This option will purge accounts that have been marked for deletion as long as there are no transactions associated with the accounts and the account balance is zero. Files should be backed up prior to executing this option. Step-By-Step Instructions 1. To select "Purge Deleted Accounts" from the menu, touch the letter <G> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. At this point, you may cancel the selection by pressing <ESC>. If you wish to proceed, press any other key. When the process is complete you will be returned to the menu. MENU SELECTION: "H) Export Transactions" ======================================= Functional Description This option will export accounting transactions into a comma delimited, ASCII text file. The file may then be accessed by spread sheets and custom programs written in other languages. The first record on the file is a header record containing the field names. It may be necessary to remove this record prior to using this file with some spreadsheets. This can be easily done using any ASCII text editor or word processor. 6.31 The file "GLTRAN.ASC" will be created. The following fields of information will be exported: TRANS Transaction number TYPE 1=Deposit 2=Check 3=Bank Charges ACC_NUM General ledger account number DATE Transaction date as entered DR_AMOUNT Amount of debit entry CR_AMOUNT Amount of credit entry REFERENCE Comment regarding transaction USERID Initials of user finalizing transaction POST_DATE Date stamp when transaction was finalized POST_TIME Time stamp when transaction was finalized Step-By-Step Instructions 1. Select "Export Transactions" from the menu by touching the letter <H> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Starting Date" - Enter the starting date range for data to be exported. Press <ENTER> to go to the next field. 4. "Ending Date" - Enter the ending date range for data to be exported. Press <ENTER> to begin exporting. 6.32 SUBMENU: E) REPORTS =================== Select this menu from the main fund accounting menu by touching the letter <E> and pressing <ENTER>. To return to the main fund accounting menu, press <ESC>. Some of the reports that appear on the reports submenu may also be found elsewhere in the system. They are repeated here for convenience. When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "A) Chart of Accounts" ===================================== See page 6.23 for information on this report. MENU SELECTION: "B) Revenue and Expenditure Statement" ===================================================== Functional Description This report will print a Revenue and Expenditure Statement with individual schedules for each fund equity account. Step-By-Step Instructions 1. Select "Revenue and Expenditure Statement" from the report menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 6.33 MENU SELECTION: "C) Sources and Uses of Funds (Detail)" ====================================================== Functional Description This report will print by fund equity account, a detail of all transactions affecting the account. A summary schedule of all adjustments to fund equity will also appear. Step-By-Step Instructions 1. Select "Sources and Uses of Funds (Detail)" from the reports menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "D) Trial Balance" ================================= Functional Description This report will print a list of all accounts with the account balances. Fund equity account balances will be the balance before adjustments from sources and uses of funds. This is necessary to insure that the trial balance is in balance. Step-By-Step Instructions 1. Select "Trial Balance" from the reports menu by touching the letter <D> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "E) Actual vs Budgeted" ====================================== Functional Description This report will print a list of all income and expense accounts with each actual period amount and budget amount for the current and prior year. 6.34 Step-By-Step Instructions 1. Select "Actual vs Budgeted" from the reports menu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "F) Check Register" ================================== See page 6.25 for information on this report. MENU SELECTION: "G) Outstanding Check List" ========================================== See page 6.26 for information on this report. MENU SELECTION: "H) Transaction Audit Trail" =========================================== Functional Description This report will print by journal type code a complete audit trail for all transactions for a date range. Step-By-Step Instructions 1. Select "Transaction Audit Trail" from the reports submenu by touching the letter <H> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter in <MMDDYY> format the starting date range. 4. "End Date" - Enter in <MMDDYY> format the ending date range. MENU SELECTION: "I) Balance Sheet" ================================= Functional Description This report will print a balance sheet showing all assets, liabilities and fund equity accounts. (Income and expense 6.35 accounts do not appear on a balance sheet). Fund equity accounts will reflect changes in sources and uses of funds, thus keeping the balance sheet in balance at all times. Step-By-Step Instructions 1. Select "Balance Sheet" from the reports submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "J) Changes in Fund Equity" ========================================== Functional Description This report prints a schedule for each fund equity account. It shows the beginning of year balance, changes due to transfers, increases from sources of funds, and decreases from uses of funds. Step-By-Step Instructions 1. Select "Changes in Fund Equity" from the reports submenu by touching the letter <J> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "K) Fund Equity Account Analysis" ================================================ Functional Description This report prints each fund equity account showing the actual month activity as well as the effect of revenue and expenditures on each account. Step-By-Step Instructions 1. Select "Fund Equity Acct Analysis" from the reports submenu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 6.36 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "L) Monthly Budget Information" ============================================== See page 6.11 for information on this report. MENU SELECTION: "M) Annual Budget Information" ============================================= See page 6.12 for information on this report. MENU SELECTION: "N) Monthly Financial Report" ============================================ See page 6.29 for information on this report. MENU SELECTION: "O) Monthly Trial Balance" ========================================= See page 6.29 for information on this report. MENU SELECTION: "P) Account Detail Report" ========================================= Functional Description This report prints all transactions associated with each accounts for any specified date range. Step-By-Step Instructions 1. Select "Account Detail Report" from the reports submenu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter starting date in <MMDDYY> format. 4. "End Date" - Enter ending date in <MMDDYY> format. MENU SELECTION: "Q) Actual/Budgeted Variance Report" =================================================== See page 6.12 for information on this report. 6.37 VII ATTENDANCE ========== PROGRAM: ATTEND.EXE =================== Functional Description ATTEND.EXE is the executable program for the attendance module. Attendance may be kept for up to three user definable events (morning worship, Sunday school, etc.) for the entire congregation. In addition, attendance may be kept for all organizations within the church. An "exception posting" method of tracking attendance is used. When building attendance records for a particular date, a default value ("P"resent or "A"bsent) must be given. Data entry is only necessary for members not matching the default value. For instance, an organization with 32 members had 27 members present for a particular date. By making "P"resent the default value, data entry is only necessary for the five exceptions. Step-By-Step Instructions 1. This module may be accessed by selecting ATTENDANCE from the main menu or by executing ATTEND from the DOS command line. To execute ATTEND from the DOS command line: Example: CD \CMTS33 <ENTER> Attend <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the main menu will appear. 3. To make a selection from the attendance menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: CONGREGATIONAL ATTENDANCE A) Build Attendance Records 7.1 B) Enter Attendance By Date C) Enter Attendance By Member D) Update Last Attendance Date E) Purge Old Records ORGANIZATIONAL ATTENDANCE F) Build Attendance Records G) Enter Attendance By Date H) Enter Attendance By Member I) Update Last Attendance Date J) Purge Old Records REPORTS K) Attendance Call List L) Congregational Summary By Date M) Organizational Summary By Date N) Congregational Detail By Member O) Organizational Detail By Member P) Date of Last Organizational Attendance Q) Congregational Attendance Worksheet R) Organizational Attendance Worksheet CONGREGATIONAL ATTENDANCE ========================= Attendance may be entered for the entire congregation for up to three user definable events. These events must be defined in the SETUP module. Attendance entry consists of three basic steps. These steps are as follows. 1. Create attendance records for the entire congregation for a selected date. Selection option A from the main menu. 2. Attendance information may be entered by member or by date. Select option B to enter attendance by date or option C to enter attendance by member. 3. Update the last attendance date information used for call list reporting. Select option D to do this. MENU SELECTION: "A) Build Attendance Records" ============================================ Functional Description Choose this option to initiate an attendance posting session and create attendance records for a specific date. 7.2 Step-By-Step Instructions 1. Select "Build Attendance Records" from the menu by touching the letter <A> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Attendance Date" - Enter the attendance date in <mmddyy> format. 3. "Event 1" - Enter either "P"resent or "A"bsent to indicate the default attendance value for this event. 4. "Event 2" - Enter either "P"resent or "A"bsent to indicate the default attendance value for this event. 5. "Event 3" - Enter either "P"resent or "A"bsent to indicate the default attendance value for this event. 6. Confirm that the values are correct. Press <ESC> to return to the previous field or press any other key to commence building the attendance records. After the process is complete, the menu will automatically reappear. MENU SELECTION: "Enter Attendance By Date" ========================================= Functional Description Choose this option to enter attendance data for a specific date for all members of the congregation. Step-By-Step Instructions 1. Select "Enter Attendance By Date" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Enter Attendance Date" - Enter the date for which attendance data will be entered. Press <ENTER> and a scrolling table of records built for that date will appear on the screen. If no data appears, attendance records have not been built for the selected date. 3. Select the record to be updated and press <ENTER>. 4. "Event 1" - Indicate whether this member was "P"resent or "A"bsent for this event. Press <ENTER> to go to the next field. 7.3 5. "Event 2" - Indicate whether this member was "P"resent or "A"bsent for this event. 6. "Event 3" - Indicate whether this member was "P"resent or "A"bsent for this event. (To select another date) 1. Press <ESC> while viewing the scrolling table to position the cursor on the "Enter Attendance Date" field. (To return to the menu) 1. Press <ESC> while positioned on the "Enter Attendance Date" field to return to the menu. MENU SELECTION: "C) Enter Attendance By Member" ============================================== Functional Description Choose this option to enter attendance data for a specific member for several different dates. Step-By-Step Instructions 1. Select "Enter Attendance By Member" from the menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Enter Member No" - Enter the member number for which attendance data will be entered. To select from a table of all member, press <ENTER>. 3. A table of all attendance records built for this member will appear. Select the record to maintain and press <ENTER>. 4. "Event 1" - Indicate whether this member was "P"resent or "A"bsent for this event. 5. "Event 2" - Indicate whether this member was "P"resent or "A"bsent for this event. 6. "Event 3" - Indicate whether this member was "P"resent or "A"bsent for this event. Press <ENTER> to return to the scrolling table. 7.4 (To select another member) 1. Press <ESC> while viewing the scrolling table to position the cursor on the "Enter Member No" field. (To return to the menu) 1. Press <ESC> while positioned on the "Enter Member No" field to return to the menu. MENU SELECTION: "D) Update Last Attendance Date" =============================================== Functional Description Choose this option to update the membership file with the last attendance date for each member. Step-By-Step Instructions 1. Select "Update Last Attendance Date" from the menu by touching the letter <D> and then pressing <ENTER>. 2. Press <ESC> to cancel the update. Press any other key to process. All member records will be updated to reflect the last date a congregational event was attended. When processing is complete, the menu will reappear. MENU SELECTION: "E) Purge Old Records" ===================================== Functional Description Choose this option to purge no longer needed congregational attendance records. Step-By-Step Instructions 1. Select "Purge Old Records" from the menu by touching the letter <E> and then pressing <ENTER>. 2. "From Date" - Enter the starting date in <MMDDYY> format. 3. "To Date" - Enter the ending date in <MMDDYY> format. 4. Press <ESC> to cancel the purge. Press any other key to process. Attendance records within the date range will be purged. When processing is complete, the menu will reappear. 7.5 ORGANIZATIONAL ATTENDANCE ========================= Attendance may be entered for any organization for any date. Organizational attendance entry consists of two basic steps. These steps are as follows. 1. Create attendance records for the entire organization for a selected date. Selection option F from the main menu. 2. Attendance information may be entered by member or by date. Select option B to enter attendance by date or option C to enter attendance by member. MENU SELECTION: "F) Build Attendance Records" ============================================ Functional Description Choose this option to initiate an attendance posting session and create attendance records for a specific date. Step-By-Step Instructions 1. Select "Build Attendance Records" from the menu by touching the letter <F> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Attendance Date" - Enter the attendance date in <mmddyy> format. 3. "Organization" - Select the organization by either entering the organization number or pressing <ENTER> for a table of valid organizations. 4. "Default Attendance Status" - Enter either "P"resent or "A"bsent to indicate the default attendance value. Press <ENTER> to continue. 5. Confirm that the values are correct. Press <ESC> to return to the previous field or press any other key to commence building the attendance records. After the process is complete, the menu will automatically reappear. 7.6 MENU SELECTION: "G) Enter Attendance By Date" ============================================ Functional Description Choose this option to enter attendance data for a specific date for all members of a specific organization. Step-By-Step Instructions 1. Select "Enter Attendance By Date" from the menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Enter Organization Number" - Select the organization by either entering the organization number or pressing <ENTER> for a table of valid organizations. 3. "Enter Attendance Date" - Enter the date for which attendance data will be entered. Press <ENTER> and a scrolling table of records built for that date will appear on the screen. If no data appears, attendance records have not been built for the selected date. 4. Select the record to be updated and press <ENTER>. 5. "Attendance Status" - Indicate whether this member was "P"resent or "A"bsent. Press <ENTER> to return to the table. (To select another date) 1. Press <ESC> while viewing the scrolling table to position the cursor on the "Enter Attendance Date" field. (To select another organization) 1. Press <ESC> while positioned on the date field to position the cursor on the "Enter Organization Number" field. (To return to the menu) 1. Press <ESC> while positioned on the "Enter Organization Number" field to return to the menu. 7.7 MENU SELECTION: "H) Enter Attendance By Member" ============================================== Functional Description Choose this option to enter attendance data for a specific member for several different dates. Step-By-Step Instructions 1. Select "Enter Attendance By Member" from the menu by touching the letter <H> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Enter Organization Number" - Select the organization by either entering the organization number or pressing <ENTER> for a table of valid organizations. 3. "Enter Member No" - Enter the member number for which attendance data will be entered. To select from a table of all member, press <ENTER>. After a member has been selected, press <ENTER> to go to the next field. 3. A table of all attendance records built for this member will appear. Select the record to maintain and press <ENTER>. 5. "Attendance Status" - Indicate whether this member was "P"resent or "A"bsent. Press <ENTER> to return to the table. (To select another member) 1. Press <ESC> while viewing the scrolling table to position the cursor on the "Member No" field. (To select another organization) 1. Press <ESC> while positioned on the member no field to position the cursor on the "Enter Organization Number" field. (To return to the menu) 1. Press <ESC> while positioned on the "Enter Organization Number" field to return to the menu. 7.8 MENU SELECTION: "I) Update Last Attendance Date" =============================================== Functional Description Choose this option to update the membership file with the last attendance date for each individual for attendance in any organization. Step-By-Step Instructions 1. Select "Update Last Attendance Date" from the menu by touching the letter and then pressing <ENTER>. 2. A scrolling table of all organizations will appear. Select the desired organization and press <ENTER>. 3. "Cutoff Date" - Enter a cutoff date in the form <MMDDYY>. Only individuals whose last attendance date is prior to the cutoff date will be included in the update. 3. Press <ENTER> to process the update or <ESC to cancel. All members of the selected organization that have not attended since prior to the cutoff date will be updated to reflect the last date of organizational attendance. MENU SELECTION: "J) Purge Old Records" ===================================== Functional Description Choose this option to purge no longer needed organizational attendance records. Step-By-Step Instructions 1. Select "Purge Old Records" from the menu by touching the letter <J> and then pressing <ENTER>. 2. "From Date" - Enter the starting date in <MMDDYY> format. Press <ENTER> to go to the next field. 3. "To Date" - Enter the ending date in <MMDDYY> format. Press <ENTER> to continue. 4. Press <ESC> to cancel the purge. Press any other key to process. Attendance records within the date range will be purged. When processing is complete, the menu will reappear. 7.9 REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "K) Attendance Call List" ======================================== Functional Description This report will print a list of all members not having attended since a user selected last attendance date. Step-By-Step Instructions 1. Select "Attendance Call List" from the menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Last Attendance Date" - Enter a valid date in the format <MMDDYY>. Members that have not attended since this date will be listed with their name and telephone number. MENU SELECTION: "L) Congregational Summary By Date" ================================================== Functional Description This report will print a summary for of the number of individuals present and absent for all congregational attendance events for a user definable date range. 7.10 Step-By-Step Instructions 1. Select "Congregational Summary By Date" from the menu by touching the letter <L> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Start Date" - Enter a valid date in the format <MMDDYY>. Press <ENTER> to go to the next field. 4. "Enter End Date" - Enter a valid date in the format <MMDDYY>. Press <ENTER> to continue. MENU SELECTION: "M) Organizational Summary By Date" ================================================== Functional Description This report will print a summary for of the number of individuals present and absent for any organization attendance for a user definable date range. Step-By-Step Instructions 1. Select "Organizational Summary By Date" from the menu by touching the letter <M> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "From Date" - Enter a valid date in the format <MMDDYY>. Press <ENTER> to go to the next field. 4. "To Date" - Enter a valid date in the format <MMDDYY>. Press <ENTER> to continue. 5. "Organization (0=All) - Enter a valid organization number or leave blank for all organizations. 7.11 MENU SELECTION: "N) Congregational Detail By Member" =================================================== Functional Description This report will print detailed information on all member's congregational attendance history. Step-By-Step Instructions 1. Select "Congregational Detail By Member" from the menu by touching the letter <N> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "O) Organizational Detail By Member" =================================================== Functional Description This report will print detailed information for all organizational attendance records for all members of a selected organization. Step-By-Step Instructions 1. Select "Organizational Detail By Member" from the menu by touching the letter <O> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Organization (0=All) - Enter a valid organization number or leave blank for all organizations. MENU SELECTION: "P) Date of Last Organizational Attendance" ========================================================== Functional Description This report will print a list of all members not having attended an organizational event since a specified cutoff date. The date of last attendance for that event will also be shown on the report. Prior to running this report, "Option I) Update Last Attendance Date" must be run. 7.12 Step-By-Step Instructions 1. Select "Date of Last Organizational Attendance" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "SubHeading" - Enter the name of the organization as you wish it to appear on the report. MENU SELECTION: "Q) Congregational Attendance Worksheet" ======================================================= Functional Description This report will print a list of all individuals and allow for attendance to be recorded for up to 16 weeks. Step-By-Step Instructions 1. Select "Congregational Attendance Worksheet" from the menu by touching the letter <Q> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "R) Organizational Attendance Worksheet" ======================================================= Functional Description This report will print a list of all individuals in a specified organization and allow for attendance to be recorded for up to 16 weeks. Step-By-Step Instructions 1. Select "Organizational Attendance Worksheet" from the menu by touching the letter <R> and then pressing <ENTER>. The arrow keys may also be used to select this option. 7.13 2. "Organization Number" - Enter the organization number for to report on or leave blank if worksheets for all organizations are desired. 3. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 7.14 VIII.VISITATION AND EVENT TRACKING ============================= PROGRAM: VISIT.EXE ================== Functional Description VISIT.EXE is the executable program for the visitation module. Visitation information may be maintained for all individuals and events may be recorded for statistical reporting and for detailed record keeping for each individual. A convenient appointment schedular is also included. Step-By-Step Instructions 1. This module may be accessed by selecting VISIT from the main menu or by executing VISIT from the DOS command line. To execute VISIT from the DOS command line: Example: CD \CMTS32 <ENTER> VISIT <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the main menu will appear. 3. To make a selection from the visitation menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: EVENT DATA ENTRY A) Enter Events B) Data Entry Edit Listing C) Finalize Transactions EVENT INQUIRY AND YEAR END ROLL D) View Event Detail By Category E) View Event Detail By Member F) Ten Year Event Summary G) Roll Event Year 8.1 VISITATION ACTIVITIES H) Members' Visitation Information I) Appointment Schedular REPORTS J) Event Detail By Date K) Event Detail By Category L) Event Summary-Date Range M) Five Year Event Summary N) Visitation Roster By Route O) Appointment Summary By Date OTHER P) Purge Event History DATA ENTRY ========== MENU SELECTION: "A) Enter Events" ================================ Functional Description Choose this option to enter events. Statistical totals will be kept on all events entered for ten years. The actual event details may be retained as long as desired. Step-By-Step Instructions 1. To select "Enter Events" from the menu, touch the letter <A> and then press <ENTER>. The arrow keys may also be used to select this option. 2. "Member No" - Enter the member number or press <ENTER> for a scrolling table of all members. Use the arrow keys to position the selector bar over the member to be accessed. Enter all or part of the person's last name to quickly position the selector bar. Press <ENTER> to continue. 3. "Event" - Enter the event number or press <ENTER> for a scrolling table of events. Select the desired event and press <ENTER> to continue. 4. "Date" - Enter the date this event occurred in <MMDDYY> format. Events may only be entered for the current event year. 8.2 5. "Comments" - Enter a comment up to 30 characters related to this event. MENU SELECTION: "B) Data Entry Edit Listing" ================================================== Functional Description The Data Entry Edit Listing will list all events that have been entered since events were last finalized. This report should be run prior to finalizing to insure that all data entered is accurate. Step-By-Step Instructions 1. Select "Data Entry Edit Listing" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "C) Finalize Events" =================================== Functional Description This procedure will finalize all events that have been entered since it was last executed. Once events have been finalized, they create a permanent audit. Be sure to back up all files prior to selecting this option. See the section in the manual on "Backing Up Data Files" Step-By-Step Instructions 1. Select "Finalize Events" from the menu by touching the letter <C> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 8.3 EVENT INQUIRIES AND YEAR END ROLL ================================= MENU SELECTION: "D) View Event Detail By Category" ================================================= Functional Description Select this option to view event details by event category. All events for the selected category will be displayed. Step-By-Step Instructions 1. Select "View Event Detail By Category" from the menu by touching the letter <D> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Select Category" - Enter the event category to be viewed or press <ENTER> for a table of all event categories. 3. A display table of all events for this category will appear. Use the <PAGE UP> and <PAGE DN> keys to scan the events or press <ESC> to quit. MENU SELECTION: "E) View Event Detail By Member" =============================================== Functional Description Select this option to view event details by member. All events for the selected person will be displayed. Step-By-Step Instructions 1. Select "View Event Detail By Member" from the menu by touching the letter <E> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. "Select Member" - Enter the member number to be viewed or press <ENTER> for a table of all members. Use the arrow keys to position the selector bar over the member to be accessed. Enter all or part of the person's last name to quickly position the selector bar. Press <ENTER> to continue. 3. A display table of all events for this individual will appear. Use the <PAGE UP> and <PAGE DN> keys to scan the events or press <ESC> to quit. 8.4 MENU SELECTION: "F) Ten Year Event Summary" ========================================== Functional Description Select this option to view a statistical summary for any event for the last ten years. Step-By-Step Instructions 1. Select "Ten Year Event Summary" from the menu by touching the letter <F> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A table of all events will appear with the last 3 year's totals for each event showing. To see a complete 10 year statistical total for any event, position the selector bar over that event and press <ENTER>. Press <ESC> to return to the menu. MENU SELECTION: "G) Roll Event Year" ==================================== Functional Description This option will move all yearly event totals back one year. Current year totals will be cleared and the event year will be incremented by one. Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is very important to read and understand these section prior to initiating this procedure! Step-By-Step Instructions 1. Select "Roll Event Year" from the menu by touching the letter <G> and then pressing <ENTER>. The arrow keys may also be used to selects this option. 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. VISITATION ACTIVITIES ===================== MENU SELECTION: "H) Members' Visitation Information" =================================================== Functional Description Choose this option to enter visitation information. 8.5 Step-By-Step Instructions 1. To select "Members' Visitation Information" from the menu, touch the letter <H> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all members will appear. Select the record to be edited or press <ESC> to return to the menu. To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. You may also enter all or part of the individual's last name to automatically position the selector bar. Press <ENTER> to select the record. 2. A data entry form will appear. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. 3. "Visitation Route" - Enter a two digit visitation route. Members will be sorted by visitation route on the visitation route listing. Press <ENTER> to go to the next field. 3. "Date Last Visit" - Enter the date of the last visit in <mmddyy> format. Press <ENTER> to go to the next field. 4. "Shut-In Code" - Indicate whether this member is a shut- in or not. To indicate that this member is a shut-in, use the arrow keys to select <Y>. Otherwise, select <N>. Press <ENTER> to go to the next field. 5. The remaining fields are user definable. The field titles may be maintained in the setup module. See page 4.9 of the manual for a definition of each field and its size. Active Function Keys F1 HELP - Always active 1. Press F1 at any time for a pop-up context sensitive help screen. 8.6 F2 Detailed Notes 1. Press F2 at any time while maintaining a member to access detailed visitation notes for this member. A table of visitation notes will appear. Press <INSERT> to add a new record or select an existing record to maintain. 2. "Date" - Enter the visitation date in <mmddyy> format. 3. "Time" - Enter the time of the visit in HHMM format using 24 hour time. 4. "Subject" - Enter up to 30 characters to indicate the subject of the note or memo. 3. "Notes" - Notes on this visit may be entered in a free form format. This is also a convenient place to store other membership related information. Press <CTL> <ENTER> from any line to return to a scrolling table of note records for this member. Press <ESC> to routine to the data entry form. F3 View Events 1. Press F3 at any time while maintaining a member to view all event details pertaining to this person. MENU SELECTION: "I) Appointment Schedular" ========================================= Functional Description Choose this option to access the calendar\appointment schedular. Step-By-Step Instructions 1. To select "Appointment Schedular" from the menu, touch the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A calendar will appear. The current month will be displayed and the current day will be highlighted. Use the arrow keys to select any day in the current month. Use <PAGEUP> and <PAGEDOWN> to access other months. Select the day to be edited and press <ENTER> or press <ESC> to return to the menu. 3. A table of all appointments for that day will appear. 8.7 (To add an appointment) 1. Press <INSERT>. A data entry form will appear on the screen. 2. "Time" - Enter the time of the appointment. 3. "Purpose" - Enter the purpose of the appointment. 4. "Where" - Enter the location of the appointment. 5. "With" - Enter who the appointment is with. 6. "Comments" - Enter any notes relating to the appointment. Notes may be entered in a word processing type of free format. (To return to the menu) 1. Press <ESC> whenever the calendar is displayed to return to the menu. REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "J) Event Detail By Date" ======================================== Functional Description This report will print all events for a specified date range in date order. 8.8 Step-By-Step Instructions 1. Select "Event Detail By Date" from the menu by touching the letter <J> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the start date in <MMDDYY> format. 4. "End Date" - Enter the ending date in <MMDDYY> format. MENU SELECTION: "K) Event Detail By Category" ============================================ Functional Description This report will print all events grouped by event category and within each group in date order for a specified date range.. Step-By-Step Instructions 1. Select "Event Detail By Category" from the menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the start date in <MMDDYY> format. 4. "End Date" - Enter the ending date in <MMDDYY> format. MENU SELECTION: "L) Event Summary By Date Range" ============================================ Functional Description This report will print a summary of the totals for all events by event category for a specified date range. 8.9 Step-By-Step Instructions 1. Select "Event Summary By Date Range" from the menu by touching the letter <L> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the start date in <MMDDYY> format. 4. "End Date" - Enter the ending date in <MMDDYY> format. MENU SELECTION: "M) Five Year Event Summary" ============================================ Functional Description This report will print the annual totals for all events for the last five years. Step-By-Step Instructions 1. Select "Five Year Event Summary" from the menu by touching the letter <M> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "N) Visitation Roster By Route" ============================================== Functional Description This report will print a list of members grouped by visitation route. The report may be printed for one visitation route or for all visitation routes. Step-By-Step Instructions 1. Select "Visitation Roster By Route" from the menu by touching the letter <N> and then pressing <ENTER>. The arrow keys may also be used to select this option. 8.10 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Visitation Route" - Enter the visitation route number to be reported on or leave blank for reports from all visitation routes. MENU SELECTION: "O) Appointment Summary By Date" =============================================== Functional Description This report will print all scheduled appointments for a certain date range. Step-By-Step Instructions 1. Select "Appointment Summary By Date" from the menu by touching the letter <O> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Start Date" - Enter the start date in <MMDDYY> format. 4. "End Date" - Enter the ending date in <MMDDYY> format. OTHER ===== MENU SELECTION: "P) Purge Event History" ======================================= Functional Description This option will purge old event history for any year except the current event year. Please read the sections of this manual on "Backing Up Data Files" and "Other Considerations". It is very important that you read and understand these sections prior to initiating this procedure! Step-By-Step Instructions 1. Select "Purge Event History" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 8.11 2. A confirmation screen will appear. Press <ESC> to cancel the selection. To proceed, press any other key. 3. "Enter Year To Purge" - Enter the year for events to be purged. Press <ENTER> to continue. 8.12 IX. CUSTOMIZE SETUP =============== PROGRAM: SETUP.EXE ================== Functional Description SETUP.EXE is the executable program for the setup module. Access setup to customize and tailor many parameters of this software to the unique requirements of your church. Set up user definable tables for fund categories, special dates, organizations, and talents. Step-By-Step Instructions 1. This module may be accessed by selecting SETUP from the main menu or by executing SETUP from the DOS command line. To execute SETUP from the DOS command line: Example: CD \CMTS33 <ENTER> SETUP <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the main menu will appear. 3. To make a selection from the setup menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: MAINTENANCE PARAMETERS A) Donation Categories B) Date Descriptions C) Organizations D) Talents E) Events F) Password Security G) Miscellaneous Parameters H) User Definable Field Descriptions 9.1 REPORTS G) List of Fund Categories H) List of Date Descriptions I) List of Organizations J) List of Talents K) List of Events MAINTENANCE PARAMETERS ====================== This section provides options to maintain user definable tables of all donation fund categories, dates, organizations and talents to be tracked for the members of the church. These tables are completely user definable. This provides enormous flexibility in customizing the software to the unique needs of a specific church. There is also an option to maintain a password security file for users. Finally, there are a number of additional miscellaneous parameters that may be maintained. MENU SELECTION: "A) Donation Categories" ======================================= Functional Description Select this option to define the donation categories from which members' donations will be tracked. Step-By-Step Instructions 1. To select "Donation Categories" from the menu, touch the letter <A> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all categories currently defined will appear. At this point, additional descriptions may be added or existing descriptions may be changed. To return to the menu 1. When you wish to return to the SETUP menu, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear on the screen. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel entry for this record, press <CTRL ESC>. 9.2 2. "Donation Category" - The system will automatically assign the next available number. If this number is acceptable, press <ENTER>. If not, enter up to four numeric digits to assign a unique number to this fund. 3. "Description" - Enter up to 40 alphanumeric characters to describe this fund. Press <ENTER> to continue. You will be returned to the scrolling table. (To modify an existing record) 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, you will be returned to the scrolling table. The "FUND NO" field should not be changed after transactions have been posted to that specific fund. (To delete a record) 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "B) Date Descriptions" ===================================== Functional Description Select this option to setup and describe the date categories to be tracked for each member of the church. These must be setup before specific dates can be entered for each member. Step-By-Step Instructions 1. To select "Date Descriptions" from the menu, touch the letter and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all date descriptions currently defined will appear. At this point, additional categories may be added or existing descriptions may be changed. 9.3 To return to the menu 1. When you wish to return to the SETUP menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. 2. "Date No" - The system will automatically assign the next available number. If this number is acceptable, press <ENTER>. If not, enter up to two numeric digits to assign a unique number to this date. 3. "Description" - Enter up to 25 alphanumeric characters to describe this date category. Press <ENTER> to continue. The scrolling table will return. To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, you will be returned to the scrolling table. The "DATE NO" field should not be changed after specific individual's dates have been entered. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "C) Organizations" ================================= Functional Description Select this option to setup and describe the organizations to be tracked for each member of the church. An organization must be defined here before an individuals can be associated with that organization. 9.4 Step-By-Step Instructions 1. To select "Organizations" from the menu, touch the letter <C> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all organizations currently defined will appear. At this point, additional organizations may be added or existing descriptions may be changed. To return to the menu 1. To return to the SETUP menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. 2. "Organization No" - The system will automatically assign the next available number. If this number is acceptable, press <ENTER>. If not, enter up to two numeric digits to assign a unique number to this organization. Press <ENTER> to go to the next field. 3. "Description" - Enter up to 25 alphanumeric characters to describe this organization. Press <ENTER> to continue. The scrolling table will return. To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the scrolling table will reappear. The "Organization No" field should not be changed after individuals have been assigned to that organization. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 9.5 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "D) Talents" =========================== Functional Description Select this option to setup and describe the talents and skills to be tracked for each member of the church. Each talent or skill must be defined before an individual can be associated with it. Step-By-Step Instructions 1. To select "Talents" from the menu, touch the letter <D> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all talents currently defined will appear. At this point, additional talents may be added or existing descriptions may be changed. To return to the menu 1. When you wish to return to the SETUP menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. 2. "Talent No" - The system will automatically assign the next available number. If this number is acceptable, press <ENTER>. If not, enter up to two numeric digits to assign a unique number to this talent or skill. Press <ENTER> to go to the next field. 3. "Description" - Enter up to 25 alphanumeric characters to describe this talent. Press <ENTER> to continue. The scrolling table will return. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. Press <ENTER> to select the record to maintain. 9.6 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the scrolling table will reappear. The "Talent No" field should not be changed after specific individual's talents have been entered. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "E) Events" ========================== Functional Description Select this option to setup and describe the events to be tracked statistically and for each individual within the church. Step-By-Step Instructions 1. To select "Events" from the menu, touch the letter <E> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all events currently defined will appear. At this point, additional talents may be added or existing descriptions may be changed. To return to the menu 1. When you wish to return to the SETUP menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. 2. "Event No" - The system will automatically assign the next available number. If this number is acceptable, press <ENTER>. If not, enter up to two numeric digits to assign a unique number to this event. 9.7 3. "Description" - Enter up to 25 alphanumeric characters to describe this event. Press <ENTER> to continue. The scrolling table will return. To modify an existing record 1. Use the arrow keys to position the selector bar over the record to be changed. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the scrolling table will reappear. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "F) Password Security" ===================================== Functional Description This option is used to determine what users may access the system and which modules they may access. If password security is not required, this option may be skipped. Step-By-Step Instructions 1. To select "Password Security" from the menu, touch the letter <F> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all users currently defined will appear. Additional users may be added or existing users may be maintained. To return to the menu 1. To return to the SETUP menu from the scrolling table, press <ESC>. 9.8 To add a new record 1. Press <INSERT>. A data entry form will appear. If you do not wish to enter information in all fields, you may write the record at any time by pressing <CTRL> <ENTER>. To completely cancel all changes to this record, press <CTRL ESC>. 2. "First Name" - Enter the first name of this user. Press <ENTER> to go to the next field. 3. "Last Name" - Enter the last name of this user. Press <ENTER> to go to the next field. 4. "Initials" - Enter the initials of this user. These initials will appear in the audit trail for all donation and financial transactions that are finalized by the user. Press <ENTER> to go to the next field. 5. "Password" - Enter the password assigned to this user. Press <ENTER> to go to the next field. 6. "Membership" - Enter "Y" or "N" to indicate if this user may access the membership module. Press <ENTER> to go to the next field. 7. "Donations" - Enter "Y" or "N" to indicate if this user may access the donation module. Press <ENTER> to go to the next field. 8. "Attendance" - Enter "Y" or "N" to indicate if this user may access the attendance module. Press <ENTER> to go to the next field. 9. "Visitation" - Enter "Y" or "N" to indicate if this user may access the visitation module. Press <ENTER> to go to the next field. 10. "Fund Accounting" - Enter "Y" or "N" to indicate if this user may access the fund accounting module. Press <ENTER> to go to the next field. 11. "Setup" - Enter "Y" or "N" to indicate if this user may access the setup module. Press <ENTER> to return to the scrolling table. 9.9 To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record. 2. Make the necessary changes to each field and press <ENTER>. After all fields have been maintained, the program will return to the scrolling table. MENU SELECTION: "G) Miscellaneous Parameters" ============================================ Functional Description Select this option to customize many miscellaneous parameters. Step-By-Step Instructions 1. To select "Miscellaneous Parameters" from the menu, touch the letter <G> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A screen will appear showing many parameters that may be changed. 3. "Address" - Enter up to 40 characters for each of the three address lines. 4. "Pastor" - Enter up to 40 alphanumeric characters to indicate the pastor's name. 5. "Event Year" - This field should not normally be maintained. The initial installation is the only normal exception. Running the roll event year procedure automatically updates this field. 6. "Donation Year" - This field should not normally be maintained. The initial installation is the only normal exception. Running the donation year end procedure automatically updates this field. 7. "Fund Accounting Year" - This field should not normally be maintained. The initial installation is the only normal exception. Running the fund accounting year end procedure automatically updates this field. 9.10 8. "Fiscal Year Start Month" - Enter the numeric representation of the first month of the churches fiscal year. If the church is on a calendar year, this value will be <1>. This field may be skipped if fund accounting is not being used. 9. "Require Password" - Enter "Y" or "N" to indicate whether password security is required. 10. "PRINT 0 Bal Stmts" - Enter "Y" or "N" to indicate whether statements should print for all members or only members with an active pledge amount or actual donations in current year giving. 11. "Attendance Events 1-3" - Enter a description for each of the congregational attendance events. The systems allows for up to three events for congregational attendance. 12. "Show Last City As Default" - Answer Yes if the last city entered should appear as the default when adding new household records. 13. "Show Last State As Default" - Answer Yes if the last state entered should appear as the default when adding new household records. 14. "Show Last Zip Code As Default" - Answer Yes if the last zipcode entered should appear as the default when adding new household records. MENU SELECTION: H) User Definable Field Descriptions" ==================================================== Functional Description Select this option to maintain the user definable field description in the household and individual files. Step-By-Step Instructions 1. To select "User Definable Field Parameters" from the menu, touch the letter <H> and then press <ENTER>. 2. A screen will appear showing the current value for each user definable field. 3. "Household User Definable Field 1 thru Field 6" - Enter up to 12 characters for each of the six user definable field descriptions at the household level. 9.11 4. "Individual User Definable Field 1 thru Field 20" - Enter up to 12 characters for each of the six user definable field descriptions at the family/household level. REPORTS ======= When any report option is chosen, a confirmation screen will appear. The report may be canceled by pressing the <ESC> key. The report direction may be toggled between SCREEN and PRINTER by pressing <F2>. Pressing any other key will initiate the report. The report may be halted while it is processing by pressing <ESC>. Reports directed to the screen may be scrolled by pressing <PageUp> or <PageDn>. When processing is complete, they may be redirected to a printer by pressing <CTRL> <L>. To return to the menu, press <ESC>. If the report was directed to a printer, the main menu will automatically reappear once printing is complete. MENU SELECTION: "I) Donation Category Listing" ============================================= Functional Description This report will list all fund categories that donations may be associated with. Step-By-Step Instructions 1. Select "Donation Category Listing" from the menu by touching the letter and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "J) List of Date Descriptions" ============================================= Functional Description This report will list the special date descriptions. Step-By-Step Instructions 1. Select "List of Date Descriptions" from the menu by touching the letter <J> and then pressing <ENTER>. The arrow keys may also be used to select this option. 9.12 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "K) List of Organizations" ========================================= Functional Description This report will list all organizations that have been defined. Step-By-Step Instructions 1. Select "List of Organizations" from the menu by touching the letter <K> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "L) List of Talents" =================================== Functional Description This report will list all talents that have been defined. Step-By-Step Instructions 1. Select "List of Talents" from the menu by touching the letter <L> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. MENU SELECTION: "M) List of Events" ================================== Functional Description This report will list all talents that have been defined. 9.13 Step-By-Step Instructions 1. Select "List of Events" from the menu by touching the letter <M> and then pressing <ENTER>. The arrow keys may also be used to select this option. 2. A report confirmation screen will appear. The report direction may be toggled to either a printer or the screen by pressing <F2>. Press <ESC> to cancel the selection. To proceed, press any other key. 9.14 X. ADDITIONAL REPORTS =============== PROGRAM: RPTINIT.EXE ===================== Functional Description RPTINIT.EXE is the executable program for the additional reports module. Access the additional reports modules to run reports contained in the "Special Report Packs" that will be available from Torbert Data Systems beginning with the Version 3.2 release. A sample report pack with several often requested reports has been included with this release. In addition, the Additional Reports menu is a "soft menu". This means that reports written by the user with the optional Clarion Report Writer may also be placed within this menu. Step-By-Step Instructions 1. This module may be accessed by selecting ADDITIONAL REPORTS from the main menu or by executing RPTINIT from the DOS command line. To execute RPTINIT from the DOS command line: Example: CD \CMTS32 <ENTER> RPTINIT <ENTER> 2. If the security option is active, a password prompt will appear. Input the appropriate password as required. If the security option is not set, the main menu will appear. 3. To make a selection from the additional reports menu, touch the letter on the keyboard corresponding to the menu selection. The <UP> or <DOWN> arrow keys may also be used to position the selector bar over the desired module. Press <ENTER> and the selection will be executed. The menu choices are: RUN REPORTS A) Reports By Category B) Reports By Name MAINTAIN FILES C) Categories D) Reports 10.1 RUN REPORTS =========== This section provides options to run any additional reports either by report name or by category, then by report. MENU SELECTION: "Reports By Category" ==================================== Functional Description Select this option to run any of the additional reports by fist choosing a report category. Step-By-Step Instructions 1. To select "Reports By Category" from the menu, touch the letter <A> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all categories currently defined will appear. 3. Use the cursor keys to position the highlight bar over the desired report category and press <ENTER>. 4. A scrolling table of all reports within that category will appear. Select the desired report and press <ENTER>. 5. "Enter Report Direction" - Select the report direction for the chosen report. Valid choices are: S- Screen P - Printer F-File When selecting "F" or File, you will be prompted for a file name. 6. At the confirmation prompt, press <ESC> to cancel the report execution, any other key to continue. To return to the menu 1. When you wish to return to the Additional Reports menu, press <ESC>. MENU SELECTION: "Reports By Name" ================================ Functional Description Select this option to run any of the additional reports by name. 10.2 Step-By-Step Instructions 1. To select "Reports By Name" from the menu, touch the letter and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all reports will appear. Select the desired report and press <ENTER>. 3. "Enter Report Direction" - Select the report direction for the chosen report. Valid choices are: S- Screen P - Printer F-File When selecting "F" or File, you will be prompted for a file name. 4. At the confirmation prompt, press <ESC> to cancel the report execution, any other key to continue. To return to the menu 1. When you wish to return to the Additional Reports menu, press <ESC>. MAINTAIN FILES ============== MENU SELECTION: "Categories" ================================== Functional Description Select this option to setup and describe the report categories within this module. These must be setup before specific reports can be assigned to each category.. Step-By-Step Instructions 1. To select "Categories" from the menu, touch the letter <C> and then press <ENTER>. The arrow keys may also be used to select this option. 2. A scrolling table of all report categories currently defined will appear. At this point, additional categories may be added or existing descriptions may be changed. 10.3 To return to the menu 1. When you wish to return to the ADDITIONAL REPORTS menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. A category number will be automatically assigned. 2. "Description" - Enter up to fifty characters for this report category description. Press <ENTER> to return to the scrolling table. To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to the description field and press <ENTER>. The scrolling table will reappear. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. A category should not be deleted that has reports assigned to it. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. MENU SELECTION: "Reports" ======================== Functional Description Select this option to setup and describe the actual reports that have been written or supplied by TDS or an independent consultant. These reports will become an integral part of your CMTS system. Step-By-Step Instructions 1. To select "Reports" from the menu, touch the letter <D> and then press <ENTER>. The arrow keys may also be used to select this option. 10.4 2. A scrolling table of all reports currently defined will appear. At this point, additional reports may be added or existing records may be changed. To return to the menu 1. When you wish to return to the ADDITIONAL REPORTS menu from the scrolling table, press <ESC>. To add a new record 1. Press <INSERT>. A data entry form will appear. 2. "Category" - Enter the category number for the desired report. If this number is unknown, press <ENTER> and a table of all existing categories will appear. Select the correct category. 3. "Title" - Enter a descriptive title for this report. The title may be up to fifty characters in length. 4. "Report Name" - Enter the eight character report name that the report was saved as in Report Writer. The "DEF" extension should not be entered. 5. "Database Name" - Enter the eight character database name that the database was saved as in Report Writer. The "DEF" extension should not be entered. Press <ENTER> to return to the scrolling table. To modify an existing record 1. Use the arrow keys to position the selector bar over the record you wish to change. Press <ENTER> to select the record to maintain. 2. Make the necessary changes to each field and press <ENTER>. The scrolling table will reappear. To delete a record 1. Use the arrow keys to position the selector bar over the record to be deleted. Press <DELETE> to select the record to delete. 2. A confirmation screen will show the complete record. Press <ENTER> to delete the record or <ESC> to cancel this selection. The scrolling table will reappear. 10.5 XI. LIVE IMPLEMENTATION =================== This section should be read thoroughly prior to the live implementation. Should information on a specific procedure be required, refer to the detailed step by step instructions for that procedure elsewhere in this manual. PROGRAM: FILECRE.EXE ==================== Functional Description FILECRE.EXE is the executable program to purge the sample data files and create the actual files. Step-By-Step Instructions 1. The first step in live implementation is to remove the sample data files that were supplied with this software. Be sure the CMTS directory is the active directory. From the DOS command line, execute FILECRE. This may be done as follows: Example: CD \CMTS32 <ENTER> FILECRE <ENTER> 2. "Type of Data" - Select Sample by pressing "S" to create sample data files for a quick evaluation or press "E" to create empty data files prior to live implementation. 3. "Create Membership and Donation Files" - Indicate "YES" to create data files for all modules except fund accounting. Enter "NO" if these files should not be recreated. 4. "Create Fund Accounting Files" - Indicate "YES" to create data files for the fund accounting module. Enter "NO" if these files should not be recreated. 5. Press <ESC> now to abort this program. Press any other key to begin processing. Instructions For Live Implementation ==================================== The following instructions will detail the steps involved in live implementation for each module. When installing all modules at the same time, follow these steps in the sequence given. These instructions assume the program FILECRE has been executed to create empty files. See the section above for details on creating the empty files. 11.1 MEMBERSHIP ========== 1. Execute the "SETUP.EXE" program either by selecting SETUP from the main menu or by entering "CUSTOMIZE SETUP" from the DOS command line. 2. Select the option "Date Descriptions" from the SETUP menu. Enter each date category that your church wishes to track. Additional date categories may be added in the future as required. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 3. Select the option "Organizations" from the SETUP menu. Enter the name of each organization within the church that your church wishes to track. You may add additional organizations in the future as required. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 4. Select the option "Talents" from the SETUP menu. Enter the name of each talent or skill that members of the church may possess that is of value to your church. Additional skill categories may be added in the future as required. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 5. Execute the MEMBER.EXE" program either from the main menu by selecting MEMBERSHIP or by entering "MEMBER" from the DOS command line. 6. Select the "Families" option from the menu and enter one record for each family or household. 7. Select the "Individual Members" option from the menu and enter one record for each individual. The individual's dates, talents, and organizations may also be entered using the appropriate hotkey. DONATIONS ========= 1. The MEMBERSHIP instructions described above must be completed prior to implementing DONATIONS. 2. Execute the "SETUP.EXE" program either by selecting SETUP from the main menu or by entering "CUSTOMIZE SETUP" from the DOS command line. 11.2 3. Select the option "Fund Categories" from the SETUP menu. Enter each fund category that your church wishes to track. Additional fund categories may be added in the future as required. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 4. Select the option "Miscellaneous Parameter" from the SETUP menu. Insure the "Donation Year" field is set correctly. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 5. Execute the DONATE.EXE" program either from the main menu by selecting DONATIONS or by entering "DONATE" from the DOS command line. 6. Select the option "Member Pledge\Giving Maintenance". Enter the envelope number and each fund pledge amount for each member of the church. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. FUND ACCOUNTING =============== 1. Execute the "SETUP.EXE" program either by selecting SETUP from the main menu or by entering "CUSTOMIZE SETUP" from the DOS command line. 2. Select the option "Miscellaneous Parameter" from the SETUP menu. Insure that the values for the "Fund Accounting Year" field and the "Fiscal Year Start Month" field are set correctly. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. 3. Execute the FUND.EXE" program either from the main menu by selecting FUND ACCOUNTING or by entering "FUND" from the DOS command line. 4. Select the option "General Ledger Accounts". Enter each account in the chart of accounts. 5. Select the option "Bank Information". Enter the required information for each bank checking account. 6. Select the option "Vendors". Enter the name for each vendor that checks are frequently written to. 11.3 7. Make one "balance forward" entry for each account. It is possible to go live during any period of the year, however it is easiest to begin live implementation at the start of a new fiscal year. The best way to do this is to set the accounting year to the prior year, and post the adjusted account balance on the last day of the year. By posting balances after all adjustments and year end processing, only balance sheet accounts will have to be posted as revenue and expense accounts start the new year with zero balances. ATTENDANCE ========== 1. The MEMBERSHIP instructions described above must be completed prior to implementing ATTENDANCE. 2. Execute the "SETUP.EXE" program either by selecting SETUP from the main menu or by entering "CUSTOMIZE SETUP" from the DOS command line. 3. Select the option "Miscellaneous Parameter" from the SETUP menu. Insure that the values for the "Attendance Event 1" field, the "Attendance Event 2" field and the "Attendance Event 3" field are set correctly. For further instructions on maintaining this file, refer to the step by step instructions for this procedure. VISITATION ========== 1. The MEMBERSHIP instructions described above must be completed prior to implementing VISITATION. 2. No additional preparation is necessary. 11.4 XII. SPECIAL CONSIDERATIONS ====================== FILES ===== This section documents all files used in the system and describes the functional purpose for each. An understanding of these files will help you better determine and plan the backup procedures for your installation. CTL_CMTS.DAT (The church control file) The control file stores certain parameters used to customize the software for your church. It is updated during the initial installation when you elect to modify one of its parameters and during quarter end when the quarter code is automatically updated. This file is accessed by choosing the "Miscellaneous Parameters" option in the SETUP module. FND_CMTS.DAT (The funds description file) This is where the fund descriptions are kept. This file is accessed by choosing the "Fund Categories" option in the SETUP module. Quarter-To-Date and Year-To-Date donation totals for each fund are also stored automatically in this file. DES_CMTS.DAT (The Special information file) This file contains the description for every special talent, date, and organization that is setup. This file must be setup before entering member specific talent, date, or organizational information This file is accessed whenever any of the following options in the SETUP module are selected: "Date Descriptions" "Organizations" "Talents" FAM_CMTS.DAT (The Family File) This file contains one record for every family in the church. It may be accessed by selecting "Families" in the MEMBERSHIP module. 12.1 MBR_CMTS.DAT (The individual member file) This file contains one record for every member in the church. It may be accessed by selecting "Individual Members" in the MEMBERSHIP module. This file is also updated with quarter-To-Date and year- To-Date donation totals whenever donations are posted. DATE_CMTS.DAT (The individual's date file) This file contains one record for every individual's special date defined in the system. It may be accessed by selecting "Special Dates" from the MEMBERSHIP menu. SKL_CMTS.DAT (The individual's skill file) This file contains one record for every individual's special skill defined in the system. It may be accessed by selecting "Special Talents" from the MEMBERSHIP menu. ORG_CMTS.DAT (The individual's organization file) This file contains one record for every member per organization that the member belongs to. It may be accessed by selecting "Organizations" from the MEMBERSHIP menu. MFD_CMTS.DAT (Individual's Fund File) This file contains a record for each fund a member has pledged or donated to. It is accessed by selecting "Member Pledge/Giving Maintenance" from the DONATION menu The file is also updated whenever transactions are finalized. TRN_CMTS.DAT (The donation transaction file) This file contains one record for every donation transaction. It is updated whenever donations are entered or finalized. APP_CMTS.DAT (The appointment\calendar file. This file contains the calendar\appointment schedular information. It is accessed by selecting "Appointment Schedular" from the VISITATION menu. 12.2 VIS_CMTS.DAT (The visitation memo file) This file contains the visitation information. It is accessed by selecting "Member's Visitation Information" from the VISITATION menu. ATC_CMTS.DAT (The congregational attendance file) This file contains the congregational attendance information. It is updated whenever attendance records are built or updated in the ATTENDANCE module. ATO_CMTS.DAT (The organizational attendance file) This file contains the organizational attendance information. It is updated whenever attendance records are built or updated in the ATTENDANCE module. ACCT_GL (The general ledger accounts file) This file contains a record for each general ledger account. It is accessed whenever "General Ledger Accounts" is selected from the Fund Accounting menu. It is also updated whenever accounting transactions are entered or finalized. FUND_GL (The general ledger fund accounts file) This file contains a record for each general ledger fund equity account. It is accessed whenever "General Ledger Accounts" is selected from the Fund Accounting menu. It is also updated whenever accounting transactions are entered or finalized. BANK_GL (The general ledger bank file) This file contains a record for each bank checking account. It is accessed whenever "Bank Information" is selected from the Fund Accounting menu. It is also updated whenever accounting transactions are entered or finalized. VEND_GL (The vendor file) This file contains a record for each vendor. It is accessed whenever "Vendors" is selected from the Fund Accounting menu. 12.3 It is also updated whenever accounting transactions are entered or finalized. TRAN_GL (The general ledger transaction file) This file contains one record for every accounting transaction. It is updated whenever transactions are entered or finalized. BACKUP PROCEDURES ================= General Considerations ====================== Good backup procedures are essential in all data processing environments. There is no one best approach for all environments. The guidelines documented here are general in nature. Torbert Data Systems offers consulting services to assist you in planning the backup requirements for your specific installation. When in doubt, BACK UP! A simple backup routine is included in the batch file BU.BAT. When the Backup option on the main menu is selected, this routine will be selected. It invokes the DOS Backup utility however, the batch file can easily be modified to use other backup programs you might have. All data files end in the extension "*.DAT". Memo files end in the extension "*.MEM". Therefore, the safest approach is to back up all files each time the software is used. Since there are numerous backup programs available and the size of your files and the nature of your backup media may be different from other installations, specific instructions can not be given. If all of your files will fit onto one floppy diskette, and your diskette drive is A:, the following command will backup your files (Assuming you are in the CMTS directory). "COPY *.DAT A:" "COPY *.MEM A:" Maintenance Backups =================== Whenever control file or table parameters are updated, the following files should be backed up. CTL_CMTS.DAT DES_CMTS.DAT FND_CMTS.DAT 12.4 Whenever new members or families are added to your system, or membership information is changed, the following files should be backed up. FAM_CMTS.DAT MBR_CMTS.DAT DAT_CMTS.DAT SKL_CMTS.DAT ORG_CMTS.DAT Whenever accounting files are maintained, the following files should be backed up. ACCT_GL.DAT BANK_GL.DAT VEND_GL.DAT Posting Backups - Donations =========================== The following backup procedures are recommended during the donation posting cycle. Insure that ALL files are backed up prior to beginning a posting cycle. (If the recommended procedures have been followed in the past, this backup has already been done). After entering but before finalizing donations, backup the following files: MBR_CMTS.DAT FND_CMTS.DAT TRN_CMTS.DAT MFD_CMTS.DAT These files should also be backed up before running either the "Year End Roll" or "Purge History" selections as well. Posting Backups - Fund Accounting ================================= The following backup procedures are recommended during the accounting posting cycle. Insure that ALL files are backed up prior to beginning a posting cycle. (If the recommended procedures have been followed in the past, this backup has already been done). 12.5 After entering but before finalizing transactions, backup the following files: TRAN_GL.DAT ACCT_GL.DAT BANK_GL.DAT VEND_GL.DAT FUND_GL.DAT These files should also be backed up before running either the "Year End Processing", "Purge Old Transactions" or "Purge Deleted Accounts" selections. RESTORING FROM A BACKUP ======================= When it is necessary to restore from a backup, it is essential to restore all data files and remove the old key files. Place the diskette or diskettes containing the backup in the floppy drive and copy the contents of each one to the CMTS directory. Example: COPY A:*.DAT <ENTER> COPY A:*.MEM <ENTER> DEL *.K* <ENTER> Please call Torbert Data Systems prior to restoring the files if there are any questions. In any instance where a partial restore is being considered (restoring some files but not all files) it is imperative that you contact Torbert Data Systems before proceeding. Improper restore could result in files being out of balance. PRODUCT SUPPORT =============== This product is extremely easy to use, however there will be instances where technical support may be required. Users receive free support for 90 days after purchase of this product in any of the following ways. CompuServe: All E-Mail addressed to User ID 73747,2336 will be answered promptly, usually within 24 hours. Support BBS: TDS BBS - 24 hours - 804-488-4146 US Mail: Support questions may be mailed to: Torbert Data Systems, Inc. P. O. Box 9218 Chesapeake, VA 23321 Telephone: (804) 488-5506 12.6 XIII.IN CASE OF DIFFICULTIES ======================= 1. Problem: The message "TOO MANY OPEN FILES" appears when an attempt is made to execute one of the programs. Solution: This problem is a result of the CONFIG.SYS file not being set up properly. The possible hardware configurations vary considerably, but if your boot drive is C, you may view the CONFIG.SYS file as follows. Example: TYPE C:\CONFIG.SYS <ENTER> Using either EDLIN or any ASCII text editor, insure that the following values are setup in the CONFIG.SYS file. FILES = 30 BUFFERS = 30 2. Problem: When accessing certain screens, a table appears and continues to "flicker". The system appears to be hung. Solution: You have executed a routine prior to having the appropriate records built in the proper and logical sequence. The sections of this manual on the Setup and Membership modules should be read thoroughly prior to attempting to build your actual files. 3. Problem: The message "FILE NOT FOUND" appears when an attempt is made to execute one of the programs. Solution: This problem is a result of the CTL_CMTS.DAT file not being present in the currently active directory. The software is written in such a way that all data files will automatically be created if they do not already exist. The one exception to this rule is CTL_CMTS.DAT. If this file is missing, copy it from the release disk. 4. Problem: The message "The program you are attempting to load is missing" appears when an option is selected from the main menu. Solution: When a module is selected from the main menu, one of six programs is executed. These programs are: MEMBER.EXE DONATE.EXE FUND.EXE ATTEND.EXE VISIT.EXE SETUP.EXE 13.1 The EXE file that has been selected can not be found. 5. Problem: The message "Not enough memory to load program" appears when an option is selected from any menu. Solution: The software requires a machine of at least 512K to run properly. Insure that there are no TSRs running in the background, and try again. If the problem is still present, bypass the main menu, CMTS, and execute the individual modules from the command line. 6. Problem: The message "Not enough memory to load report" appears when an option is selected from a module menu. Solution: The software requires a machine of at least 512K (640K highly recommended) to run properly. Insure that there are no TSRs running in the background, and try again. If the problem is still present, bypass the main menu, CMTS, and execute the individual modules from the command line. 7. Problem: The message "Not enough disk space to load report" appears when a report is selected from any menu. Solution: Whenever a report selection is made from any module menu, a memory image of the current program is written to disk prior to executing the program. The report may also require disk space to build keys or sort the data. At least one megabyte of disk space should be available at all times to properly run CMTS. If the amount of disk space is adequate, check to insure that the CONFIG.SYS file has the statement FILES=50. 8. Problem: The message "Error loading overlay area" appears when executing the program. Solution: Versions of DOS below 3.0 do not handle the overlays properly. This software should run with no problem on versions of DOS at least 3.X or higher. 13.2 REGISTRATION INFORMATION EFFECTIVE 10-01-93 =========================================== Thank you for evaluating CMTS. Torbert Data Systems is committed to offering one of the best church management systems available at any price, either through shareware or retail channels. Your comments and suggestions are encouraged and can help in developing future versions. The software is constantly being enhanced. If this product is more than six months old, it is very likely that a newer version of the product is available or will be shortly. When you register this product you will receive a registered copy of the latest version of the software, a subscription to our quarterly newsletter ("CMTS Journal"), ninety days free technical support, and an attractive printed manual. We now offer a free one year subscription to CHURCH BYTES magazine when your church registers the entire CMTS system. Torbert Data Systems is pleased to be able to make this fine christian publication available to our registered users. We do, however, reserve the right to discontinue this free subscription offer at any time. CHURCH BYTES is published by CHURCH BYTES, INC. in Durham, NC. Registered users also receive notices whenever a new release of this software is available. You will be entitled to order the upgraded software by paying only a small shipping/handling/upgrade fee and any price difference between the new software and your current payment amount. CMTS is marketed as shareware. This provides the user an opportunity to evaluate the product prior to purchasing it. If you use this product beyond a reasonable evaluation period, you are required to pay for it. Many of the enhancements that have become part of this package have been due to suggestions from our valued users. Your comments and suggestions regarding CMTS would be greatly appreciated. You may register the entire package or only selected modules. Choose the appropriate registration form from below. Technical support may be obtained in any of the following ways: Telephone (804) 488-5506 TDS BBS (804) 488-4146 Compuserve Mail 73747,2336 Feel free to call if you have any questions or experience any difficulty installing CMTS. In many instances the users of church management software are not full time church employees and must work with the program in the evenings and on weekends. It is for this reason, that we maintain our technical support lines until 11PM (Eastern Time) Monday thru Saturday. If someone is not immediately available to help you with your problem, your call will be returned as soon as possible. Torbert Data Systems, Inc. Phone: (804) 488-5506 P. O. Box 9218 BBS: (804) 488-4146 Chesapeake, VA 23321 FAX: (804) 488-8630 ******************************************************************************* * There are several registration options. CMTS is available as a * * complete integrated system. Optionally, you may purchase only * * those modules you wish to use. The basic package (Membership and Setup) * * must be purchased if you wish to buy visitation, attendance, or donations. * ******************************************************************************* CHURCH MEMBERSHIP TRACKING SYSTEM VERSION 3.3 REGISTRATION FORM WHERE ACQUIRED ___________________________________ DATE ______________ CHURCH NAME ____________________________________________________________ ADDRESS ____________________________________________________________ CITY _______________________________ STATE ______ ZIP _________ PHONE _______________________________ YOUR NAME _____________________________________________________________ ADDRESS _____________________________________________________________ _____________________________________________________________ CITY _______________________________ STATE ______ ZIP __________ PHONE _______________________________ ============================================================================= PAYMENT MAY BE MADE BY CHECK OR MONEY ORDER IN US DOLLARS OR BY CREDIT CARD! Church Membership Tracking System Complete System $389.00 ( ) - Or Register Only The Modules You Wish To Use At This Time! Basic Package ( Membership and Setup Modules) $ 99.00 ( ) * Add Donation Module 99.00 ( ) * Add Attendance Module 49.00 ( ) * Add Visitation Module 69.00 ( ) Fund Accounting General Ledger System-Stand Alone 129.00 ( ) =========================================================== - Additional Products You Can Order Report Writer (Enhance CMTS with your own reports) 99.00 ( ) Ultimate MailList Manager (Prospects, daycare, many uses) 49.00 ( ) 4 1/2 Sales Tax - (Virginina Residents Only) _______ TOTAL ENCLOSED: _______ * Donation, attendance and visitation modules require the basic package. =========================================================== SHIP TO (Check One): CHURCH ADDRESS ( ) or INDIVIDUAL ADDRESS ( ) INDICATE MEDIA TYPE (Check One): 5 1/4 HD 1.2M ( ) 5 1/4 DD 360K ( ) 3 1/2 HD 1.4M ( ) 3 1/2 DD 720K ( ) If Credit Card: Indicate Mastercard ( ) or Visa ( ) Signature _______________ Acct # _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Exp _ _ / _ _ If Check, make payable to: "Torbert Data Systems, Inc. and mail with registration form. P. O. Box 9218 Chesapeake, VA 23321