Home

WinTen - Tenmast Software

1. KENTUCKY UTILITIES CO 022156 12 14 2000 3 670 80 PB Cleared Auto LETTERMAN SIGNS INC 022157 12 14 2000 101 40 Cleared Auto LOGAN S 022158 12 14 2000 370 48 Cleared Auto WinTen Check Reconciliation 2 24 2003 Edition Purge Transactions Page 9 3 Purging Transactions CAUTION You should never purge transactions that you may need for audit purposes Tenmast recommends that you keep all transaction records for at least three years For this rea son the program will not allow you to purge transactions that are not at least six months old To purge all of the cleared transactions currently shown on the Purge Cleared Transactions screen click the Purge button A dialog box opens that asks if you are certain you want to purge the selected transactions Click Yes to continue or No to cancel If you click Yes the program purges every selected transaction from the database A progress dialog box opens showing how far the program is in this process When the purge process is complete a dialog box opens that tells you how many transaction records were closed Click OK to close all associated dialog boxes and the Purge Cleared Transactions screen and return to the Main Menu Tenmast Check Reconciliation 3 WinTen Check Reconciliation 2 24 2003 Edition Purge Transactions Page 9 4 REINDEX This function rebuilds the indexes that Check Rec onciliation uses to search fo
2. Journal Code Apply Search For Go ar Add WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 6 Clear Unclear Click the Clear button to mark the currently se lected transaction as cleared Click the Unclear button to mark the currently selected transaction as not cleared Clear Range Click the Clear Range button to clear a range of check numbers When you click this button the Enter Range of Check Numbers dialog box opens Select the type of checks you are clearing paper or direct deposit and enter the starting and ending check numbers then click OK The program marks all matching checks as cleared Reconcile Transactions Screen Data Fields Deposits Credits These three data fields show the current amount of deposits and credits that is recorded on the state ment the current total amount of deposits and credits that are marked as cleared in Check Rec onciliation and the difference between the two Checks Fees These three data fields show the current amount of checks and fees that is recorded on the statement the current total amount of deposits and credits that are marked as cleared in Check Reconciliation and the difference between the two Statement Balance This is the bank account balance on the current statement Outstanding Deposits Credits This is the total amount of all deposits and credits in Check Reconciliation s records that have not been ma
3. Name TENMAST CITY HOUSING AUTHORITY Address 132 VENTURE COURT SUITE 1 City State Zip LEXINGTON 40511 Phone Number 859 455 8061 Fax Number 859 367 7480 Export File Specificatio Export Format Comma Separated Export File Name imaster txt Post to Ledge IV Post to Ledger Version Date 02 24 2003 Setup Screen Data Fields Housing Authority Information Name This is your agency s name as it should appear on all official transaction reports Address This is your agency s street address City State Zip This is your agency s city state and zip code Phone Number This is your agency s phone number Fax Number This is your agency s fax number Export File Specifications Check Reconciliation is capable of creating export files of data for two purposes The first is for au thentication of Positive Pay accounts accounts in which your bank will only honor those checks that appear in export files you send them This serves as an anti counterfeiting security measure The second is for manual analysis of your check data bases in a spreadsheet or database program Export Format This drop down selection box enables you to spec ify the format in which the program creates export files Comma Separated for use in other spread sheet or database programs or Bank of America Confirmation for Positive Pay use Export File Name This is the name under which the program
4. LYNN IMAGING 025766 01 01 2003 130 00 Auto PDQ SUPPLY INC 025767 01 01 2003 27051 Auto PHILLIPS CLEANING 025768 01 01 2003 14000 PB Auto ENEDINA RODRIGEZ 025769 01 01 2003 67 64 Auto SCOTT S SAFETY amp JANITORIAL 50 025770 01 01 2003 29222 8 Auto TENMAST SOFTWARE 025771 01 01 2003 147 65 Auto THE LAFAYETTE LIFE INSURANCE 025772 01 01 2003 811 06 PB Auto UNITED HEALTHCARE OF KY LTD 025773 01 01 2003 1319802 Auto VISA 025774 01 01 2003 1 228335 Auto LUMBER COMPANY 025733 01 07 2003 67 04 Auto 84 BELLSOUTH 025800 01 07 2003 7990 Auto CONKLIN COMPANY INC 025801 01 07 2003 609 50 Auto a Add f Edit Hint Spoiled Source This status only applies to manual checks that were en tered in Check Reconciliation and later voided WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 5 MAINTAIN REGISTER CHECKS SCREEN The Maintain Register Checks screen contains the 9 Hint can t edit this transaction detailed information for a single check transaction Use the standard WinTen controls to edit the data You can only edit transactions that were manually entered on this screen and save or cancel your changes in Check Reconciliation O Maintain Register Checks 021541 BLUEGRASS TOWING WinTen Check Reconciliation 2 24 20
5. Who Entered Transaction kao Date Transaction Entered 02 11 2003 Posting to Ledger Status Post Posted to Ledger Fes FundiD 100 z Account 2111 Clearing Status Current Status Cleared Amount Who Cleared Transaction Date Transaction Cleared WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 8 MAINTAIN OTHER REGISTER TRANSACTIONS SCREEN The Maintain Other Register Transactions screen contains the detailed information for a single non check transaction Use the standard WinTen con trols to edit the data on this screen and save or cancel your changes 2 O Maintain Other Register Transactions ANONYMOUS CHARITABLE DONATION 10 000 00 12 25 2002 WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 9 Maintain Other Register Transactions Screen Controls Void Button Click the Void button to void the current transac tion This option is available only if the transaction has not yet been cleared or posted Maintain Other Register Transactions Screen Data Fields Transaction Source You cannot edit the Transaction Source fields The program fills them in automatically when the trans action is created Bank Account This is the number of the General Ledger account to which the transaction was posted or will be posted Transaction Kind This is the transaction
6. Transaction Listing Report is a list of all trans actions or a selected group of transactions that Check Reconciliation has recorded for the selected bank account You can choose to include transactions from all journals and with all statuses or from one or more specific journals and or with one or more specific statuses You can also include all transactions regardless of date or check number or only those transactions that occurred within a selected range of dates and or that had check numbers within a selected range You can sort the report by check number journal and date or date and journal Journal Report The Journal Report lists all transactions for the se lected bank account that are marked to be posted to the General Ledger but have not yet been posted You can include all transactions regardless of date or only those transactions that occurred within a selected range of dates You can print the report in debit credit format or one column format You can sort the report by date and reference number ac count number and date account number and refer ence number or reference number only What to Include All Transactions Payable Checks Payroll Checks Section 8 Checks Deposits Other Debits Credits NSF Charges Cleared Status All Voided Status All M Range of Dates Range of Check Numbers 0 0 Sort by Check C Joumal Date C Date Journal What Form
7. WinTen programs that produce checks add their checks to the check register database WinTen Check Reconciliation 2 24 2003 Edition Program Basics Page 2 1 CYCLICAL ACTIONS During the Month Enter deposits as you make them Enter cleared transactions from your bank state ments Enter NSF Not Sufficient Funds or bank charges from your bank statements Print bank reconciliation reports Print listing reports WinTen Check Reconciliation 2 24 2003 Edition Program Basics Page 22 PLANNING QUESTIONS Before you begin using the Check Reconciliation program there are a few questions that you should answer to ensure smooth and organized data man agement These questions address both program setup and agency procedures What are your ledger account numbers What programs do you use to print checks The Payroll Accounts Payable and Section 8 Ten ant and Landlord programs all have the capability to print checks The programs that your agency uses will determine the types of checks that Check Reconciliation will process When do you purge old transactions How long does your agency keep a transaction on the books once the check has cleared For audit purposes this must be at least six months Work Flow Who should have access to payroll data Who will enter deposit data in Check Reconcili ation Who will record handwritten checks in Check Reconciliation When does your agency usually receive
8. authority or individual names or identities in examples or screen images are for demonstration purposes only and are not intended to refer to any actual organization or person CONTENTS Introduction Program Overview Cyclical Actions Planning Questions Main Menu Setup Setup Screen Maintain Transactions Select Bank Account Dialog Box Maintain Transactions Screen Maintain Register Checks Screen Maintain Other Register Transactions Screen Reconcile a Bank Account Select Bank Account Dialog Box Reconcile Bank Account Screen Enter Statement Date and Balance Dialog Box Reconcile Transactions Screen Maintain Register Checks Screen Maintain Other Register Transactions Screen Bank Account Balance Select Bank Account Dialog Box Account Quick Balance Dialog Box Post Transactions to Ledger Select Bank Account Dialog Box Post Manual Transactions Wizard Reports Select Bank Account Dialog Box Reports Screen Purge Transactions Select Bank Account Dialog Box Purge Cleared Transactions Screen Reindex Thiis page intentionally left blank INTRODUCTION The WinTen Check Reconciliation program is a data management program designed for use on computers running the Windows 95 98 ME NT 2000 or XP operating system The interface is designed for use in a Windows environment and includes point and click mouse actions pull down menus and Windows based help functions This manual contains all of the information you need to us
9. click the Edit button To add a reconciliation record for a new statement click the Add button If a statement is marked as reconciled and you need to remove this status to edit it again select A that statement then select the Unmark as Recon ciled option from the Other Functions menu Reconcile Bank Account X Bit 1 Bank Account 1111 GENERAL FUNDS Statement Date Statement Balance Reconciled Balance Reconciled 08 30 2001 249 549 34 234 525 60 No 10 31 2001 200 183 62 198 821 04 No 11 30 2001 178 155 88 155 987 21 No H 12 31 2001 203 650 83 203 065 41 No E 01 31 2002 128 738 66 116 284 90 No 02 28 2002 155 967 60 148 955 02 No E 03 31 2002 165 700 15 158 849 40 No W 04 30 2002 153 066 34 124 216 18 No E 05 31 2002 95 377 38 93 274 11 No 06 30 2002 180 058 18 177 475 93 No E 07 31 2002 95 139 75 70 993 53 No 08 31 2002 170 443 20 208 780 55 No 09 30 2002 154 987 40 145 80972 No 10 31 2002 111 973 33 111 443 17 T 11 30 2002 144 254 88 5 27083 WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 3 Enter Statement Date and Balance Dialog Box When you select an existing statement or add a new statement the Enter Statement Date and Bal ance dialog box opens If you are editing an existing statement the state ment s identifying data is already in the data fields If you are adding a new state
10. its bank reports Who will reconcile the bank reports Who will clear checks Who will enter NSF checks Who will enter bank charges Who will purge transactions Who will void transactions Which program s will you use to void transac tions Who will be able to post to the General Led ger WinTen Check Reconciliation 2 24 2003 Edition Program Basics Page 2 3 Main MENU The Main Menu is the starting point for using each function of the Check Reconciliation program This manual details each of these functions in its re spective chapter e lzixi File Help E Software Local Accounting Documentation CATEN Maintain Transactions Reports E Reconcile Reconcile a Bank Account Purge Purge Transactions Reconci EA gt Pos Balance Bank Account Balance 8 Reindex Reindex Database wv Post Post Transactions to Ledger Setup Setup Exit WinTen Check Reconciliation 2 24 2003 Edition Program Basics Page 24 SETUP The first time you run Check Reconciliation the first option you should select from the Main Menu is Setup All WinTen programs have Setup func tions The settings in the Setup screen control the program environment and you can change many aspects of the program s operation through these settings Be careful to enter the proper information as inaccurate settings can cause Check Reconcili ation to function in an unexpected manner Th
11. saves export files Post to Ledger If the Post to Ledger check box is checked all new manual check and deposit records are marked for future posting to the General Ledger The Post but ton on the Main Menu is enabled for use If the Post to Ledger check box is not checked new manual check records are not marked for posting to the General Ledger and the Post function is disabled Version Date This is the version of Check Reconciliation that you are running You cannot edit this field WinTen Check Reconciliation 2 24 2003 Edition Setup Page 3 3 WinTen Check Reconciliation 2 24 2003 Edition Setup Page 3 4 MAINTAIN TRANSACTIONS Check Reconciliation s primary purpose is to main tain a database of your agency s financial transac tions checks and deposits The Maintain Trans actions area of the program is where you perform these tasks To enter this area of the program click the Maintain button or press lt M gt at the Main Menu Check Reconciliation Maintain Transactions ich Reports Reconcile a Bank Account Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger Setup WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 1 Select Bank Account Dialog Box When you first enter the Maintain Transactions area of the program the Select Bank Account dia log box opens You can only maintain the transac tions for one of
12. your agency s bank accounts at a time This dialog box allows you to select the bank account whose data you are managing Select the desired account and click OK Select Bank Account GENERAL FUNDS Money Market Account WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 42 MAINTAIN TRANSACTIONS SCREEN When you select a bank account whose transac tions you will maintain the Maintain Transactions screen opens This screen contains a table of every outstanding transaction in Check Reconcili ation s database for the selected account The top area of this screen contains a set of controls that enables you to search for a specific transaction or to filter the table of transactions amp Maintain Transactions 8 0 Account No f 111 ort B Check Number C Check Date GENERAL FUNDS sesh ga Date Range 01 01 2003 02 11 2003 Journal Code _ Apply _ ___Payee Deseription Check Date Amount Journal Cleared Voided Source 1 BROCK MCVEY CO 025765 01 01 2003 192 05 Auto LYNN IMAGING 025766 01 01 2003 130 00 PB Auto PDQ SUPPLY INC 025767 01 01 2003 27051 Auto PHILLIPS CLEANING 025768 01 01 2003 140 00 PB Auto n ENEDINA RODRIGEZ 025769 01 01 2003 67 64 PB Auto SCOTT S SAFETY amp JANITORIAL SU 025770 01 01 2003 298222 PB Auto TENMAST SOFTWARE 025771 01 01 2003 147 65 PB Auto THE LAFAYETTE LIFE INSURA
13. 03 Edition Maintain Transactions Page 4 6 Maintain Register Checks Screen Controls Void Button Click the Void button to void the current transac tion This option is available only if the transac tion is a manual transaction that has not yet been cleared or posted Maintain Register Checks Screen Data Fields Transaction Source You cannot edit the Transaction Source fields The program fills them in automatically when the trans action is created Bank Account This is the number of the General Ledger account to which the transaction was posted or will be posted Transaction Kind This is the transaction s source Auto if it was created during a check processing sequence in another WinTen program Manual if it was en tered manually or Spoiled if it is a check that was manually entered in Check Reconciliation and subsequently voided Transaction Details Check Number This is the check s number Name on Check This is the check s payee Amount of Transaction This is the amount for which the check was writ ten Date of Transaction This is the date on which the check was written Journal Code This is the journal in which the check was record ed PB Payables PR Payroll S8 Section 8 Who Entered Transaction This is the user ID or initials of the user who cre ated the check You cannot edit this field Date Transaction Entered This is the date on which the trans
14. 111 al Clearing Status Current Status Cleared Amount Who Cleared Transaction Date Transaction Cleared Maintain Transactions Page 4 10 Posting to Ledger Status Post If this box is checked the transaction will be posted to the General Ledger the next time you run the Post function from the Main Menu Posted to Ledger This field indicates whether or not the transaction has been posted to the General Ledger Fund ID This drop down selection box enables you to select the fund to which the transaction will be posted Account This is the number of the General Ledger account to which the transaction was posted or will be posted Clearing Status You cannot edit the Clearing Status fields The program fills them in automatically as they become relevant Current Status If the transaction has been marked as cleared a Cleared label appears in this field Cleared Amount This is the amount for which the transaction was cleared Who Cleared Transaction This is the user ID or initials of the user who cleared the transaction Date Transaction Cleared This is the date on which the transaction was cleared WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 11 WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 2 RECONCILE A BANK ACCOUNT Whenever you receive a bank statement you need to reconcile it
15. 132 Venture Court Suite 1 n m 8 st Lexington 40511 6 ft http www tenmast com 9 Wa re Support 877 359 5492 Because Software Should Be Simple support tenmast com Marketing 877 836 6278 info tenmast com Fax 859 367 7480 WINTEN Check RECONCILIATION User Manuat Version 2 24 2003 For Procram Version 2 24 2003 AND LATER 2003 Tenmast SOFTWARE 2003 Tenmast Software All rights reserved WinTen Check Reconciliation User Manual This manual as well as the software described in it is furnished under license and may be used and or copied only in accordance with the terms of such license The content of this manual is furnished for informational use only is subject to change without notice and should not be construed as a commit ment by Tenmast Software Tenmast Software as sumes no liability for any errors or inaccuracies that may appear in this manual Except as permitted by such license no part of this publication may be reproduced stored in a retrival system or transmitted in any form or by any means electronic mechanical recording or otherwise without the prior written permission of Tenmast Software Permission to produce copies for official use is expressly granted to organizations and individuals with a current Update and Support Agreement with Tenmast Software for the mainte nance and support of Tenmast Software s WinTen Check Reconciliation program Any references to company housing
16. Bank Account GENERAL FUNDS 1111 16 Mone Market Account WinTen Check Reconciliation 2 24 2003 Edition Reports Page 82 REPORTS SCREEN The left half of the Reports screen contains a set of radio buttons that correspond to the available reports The right side of the screen contains the formatting options for the currently selected report 9 Check Reconciliation Reports X HSD Selected Bank Account 1111 GENERAL FUNDS General Transaction Listing Report Transaction Listing Report C Account Reconciliation Report C Transaction Edit Register Report Cleared Transactions Voided Transactions C Joumal Report Range of Dates Range of Check Numbers 0 0 Sort by Check Joumal Date C Date Journal Producing a Report To produce a report select its radio button Set all of the formatting options for the report then click the Print or Print Preview icon If you click the Print icon a standard WinTen print control dialog box opens Select the printing op tions for the report and click OK If you click the Print Preview icon a print preview screen opens with the selected report Review the report from this screen and close it when you are finished WinTen Check Reconciliation 2 24 2003 Edition Reports Page 83 Available Reports Transaction Listing Report The Transaction Listing Report is a list of all trans actions or a selected group of transact
17. Cleared Auto TONY S PAINTING INC 025619 11 25 2002 3 501 00 PB Cleared Auto ini CARDINAL OFFICE SYSTEMS 025623 12 01 2002 1 4750 Cleared Auto DELTA DENTAL PLAN OF KENTUCK 025624 2 717 56 Cleared Auto HOCKENSMITH AGENCY 025625 12 01 2002 366 40 PB Cleared Auto LYNN IMAGING 12 01 2002 13000 Ceaed Add f Ed 98 Clear Unclear A Range close Hint When am done reconciling The bank account is reconciled when the Difference field is zero for both deposits credis and checks fee and all depos its and or checks on your bank statement have cleared Once the statement is balanced and you click the Close button the program starts the Mark as Reconciled wizard described at the end of this chapter This wizard closes out the bank statement and marks it as reconciled WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 7 MAINTAIN REGISTER CHECKS SCREEN The Maintain Register Checks screen contains the ke adi th anl detailed information for a single check transaction Hint can t edit this transaction Use the standard WinTen controls to edit the data on this screen and save or cancel your changes You can only edit transactions that were manually entered in Check Reconciliation O Maintain Register Checks WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account
18. E Check Reconciliation maintains a continuous re cord of the balance of each bank account from which your agency writes checks The Bank Ac count Balance function enables you to review this data To view an account s balance click the Bal ance button or press lt B gt at the Main Menu Check Reconciliation Maintain Transactions Reconcile a Bank Account Bank Account Balance Post Transactions to Ledger Reports Purge Transactions Reindex Database Setup WinTen Check Reconciliation 2 24 2003 Edition Bank Account Balance Page 6 1 Select Bank Account Dialog Box When you click the Balance button or press lt B gt the Select Bank Account dialog box opens You can only review one of your agency s bank ac counts at a time This dialog box allows you to select the bank account whose balance you are re viewing Select the desired account and click OK Select Bank Account GENERAL FUNDS 1111 16 Money Market Account WinTen Check Reconciliation 2 24 2003 Edition Bank Account Balance Page 6 2 Account Quick Balance Dialog Box This dialog box contains a summary of the cur rent status of the selected bank account including all outstanding transactions up to 30 days in the future Review this information then click OK to return to the Main Menu nmm Quick alance GENERAL FUNDS Bank Account 1111 Last Statement Date 12 51 2002 Last Statement Balance 99 458 05 Outsta
19. NCE 025772 01 01 2003 811 06 PB Auto UNITED HEALTHCARE OF LTD 025773 01 01 2003 1319802 PB Auto VISA 025774 01 01 2003 1 223335 Auto 84 LUMBER COMPANY 025799 01 07 2003 67 04 PB Auto ul BELLSOUTH 025800 01 07 2003 7330 PB Auto CONKLIN COMPANY INC 025801 01 07 2003 603 50 Auto sad afen WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 3 Maintain Transactions Screen Controls Checks Others The Checks and Others buttons enable you to switch between viewing all outstanding checks and viewing all outstanding non check transactions deposits NSF charges charge backs and other bank charges Sort By The Sort By set of radio buttons enables you to select the order in which the table of transactions is sorted Date Range The Date Range data fields enable you to filter the table of transactions to show only those transac tions that occurred within a specific range of dates If you leave these fields blank the table shows all outstanding transactions Change these fields then click the Apply button to apply your filtering selections Journal Code The Journal Code drop down selection box en ables you to filter the table of transactions to show only those transactions of a specific type If you are viewing checks you can view only Payables checks PB Payroll checks PR or Section 8 checks S8 If you are viewing other transactions you can
20. Page 5 8 Maintain Register Checks Screen Controls Void Button Click the Void button to void the current transac tion This option is available only if the transac tion is a manual transaction that has not yet been cleared or posted Maintain Register Checks Screen Data Fields Transaction Source You cannot edit the Transaction Source fields The program fills them in automatically when the trans action is created Bank Account This is the number of the General Ledger account to which the transaction was posted or will be posted Transaction Kind This is the transaction s source Auto if it was created during a check processing sequence in another WinTen program Manual if it was en tered manually or Spoiled if it is a check that was manually entered in Check Reconciliation and sub sequently voided Transaction Details Check Number This is the check s number Name on Check This is the check s payee Amount of Transaction This is the amount for which the check was writ ten Date of Transaction This is the date on which the check was written Journal Code This is the journal in which the check was record ed PB Payables PR Payroll S8 Section 8 Who Entered Transaction This is the user ID or initials of the user who cre ated the check You cannot edit this field Date Transaction Entered This is the date on which the transaction was en tered into the check re
21. action was en tered into the check register database You cannot edit this field WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 7 Posting to Ledger Status Post If this box is checked the transaction will be posted to the General Ledger the next time you run the Post function from the Main Menu Posted to Ledger This field indicates whether or not the transaction has been posted to the General Ledger Fund ID This drop down selection box enables you to select the fund to which the transaction will be posted Account This is the number of the General Ledger account to which the transaction was posted or will be posted Clearing Status You cannot edit the Clearing Status fields The program fills them in automatically as they become relevant Current Status If the check has been marked as cleared a Cleared label appears in this field Cleared Amount This is the amount for which the check was cleared Who Cleared Transaction This is the user ID or initials of the user who cleared the check Date Transaction Cleared This is the date on which the check was cleared D Maintain Register Checks Wi i Wol o Transaction Source Bank Account tt fi 111 Transaction Kind Manual Transaction Details Check Number Name on Check ButGRasSTOWNG Amount of Transaction 85 00 Date of Transaction 02 03 2003 g Joumal Code Pe s
22. as created during a check processing sequence in another WinTen program Manual if it was en tered manually or Spoiled if it is a check that was spoiled during printing and subsequently voided Transaction Details Description This is a brief 36 character description of the transaction Amount of Transaction This is the amount of the transaction Date of Transaction This is the date on which the transaction occurred Journal Code This is the journal code under which the transaction was recorded OD transaction is a deposit ON transaction is an NSF charge OC transaction is another bank charge Who Entered Transaction This is the user ID or initials of the user who cre ated the transaction You cannot edit this field Date Transaction Entered This is the date on which the transaction was en tered into the check register database You cannot edit this field Maintain Other Register Transactions Al LA gt gt Transaction Source Bank Account 1111 Transaction Kind Manual Transaction Details Description ANONYMOUS CHARITABLE DONATION Amount of Transaction 10 000 00 Date of Transaction 12 25 2002 Journal Code Joo s Who Entered Transaction Go Date Transaction Entered 83 M Posting to Ledger Status Post Posted to Ledger FundID 100 1 Account 1111 M Clearing Statu Current Status Cleared Amount Who Cleared Transact
23. at to Print C One Column Range of Dates tj Sort b Date and Reference Number Account and Date C Account and Reference Number C Reference Number Include Subtotals WinTen Check Reconciliation 2 24 2003 Edition Reports Page 8 5 WinTen Check Reconciliation 2 24 2003 Edition Reports Page 8 6 PURGE TRANSACTIONS Over several years of operation your Check Reconciliation database can become quite large Eventually this can slow down the program When this happens you may need to purge old transac tion records from the database to enhance perfor mance To purge click the Purge button or press lt P gt at the Main Menu Check Reconciliation m ast oftware Check Reconciliation Local Accounting Documentation CATEN Maintain Transactions 35 Reports Reconcile Bank Account 3 Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger Setup WinTen Check Reconciliation 2 24 2003 Edition Purge Transactions Page 9 1 Select Bank Account Dialog Box When you enter the Purge area of the program the Select Bank Account dialog box opens You can only purge data from one of your agency s bank accounts at a time This dialog box allows you to select the bank account whose data you are purg ing Select the desired account and click OK Select Bank Account GENERAL FUNDS 1111 16 Money Market Account WinTen Check Reconciliatio
24. ate Transaction Entered 02 11 2003 Posting to Ledger Status Post Posted to Ledger Fes FundiD 100 z Account 2111 Clearing Status Current Status Cleared Amount Who Cleared Transaction Date Transaction Cleared WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 10 MAINTAIN OTHER REGISTER TRANSACTIONS SCREEN The Maintain Other Register Transactions screen contains the detailed information for a single non check transaction Use the standard WinTen con trols to edit the data on this screen and save or cancel your changes __ _ O Maintain Other Register Transactions ANONYMOUS CHARITABLE DONATION 10 000 00 12 25 2002 WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 11 Maintain Other Register Transactions Screen Controls Void Button Click the Void button to void the current transac tion This option is available only if the transaction has not yet been cleared or posted Maintain Other Register Transactions Screen Data Fields Transaction Source You cannot edit the Transaction Source fields The program fills them in automatically when the trans action is created Bank Account This is the number of the General Ledger account to which the transaction was posted or will be posted Transaction Kind This is the transaction s source Auto if it w
25. e individual in charge of your WinTen programs should periodically review each program s Setup to ensure that it is still correct Access to the Setup screen should be restricted through the Tenmast Security program after the initial settings have been entered in order to prevent accidental changes to the settings To use the Setup functions click the Setup button or press lt S gt at the Main Menu Check Reconciliation Maintain Transactions 3 Reports Reconcile a Bank Account Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger Setup WinTen Check Reconciliation 2 24 2003 Edition Setup Page 3 1 SETUP SCREEN The Setup screen contains all of Check Recon ciliation s setup data Use the standard WinTen controls to edit the data on this screen and save or cancel your changes Setup Screen Controls Color Button The Color button opens the Color dialog box Click 8 to set the background color of the Check Reconciliation screens to that color Some parts of some screens may remain un changed so they remain readable Hint Color Settings A color setting like any other setting is only applied to the current data area Many agencies use this feature to color code their data areas so users can tell at a glance what data area they re currently using Check Reconciliation Setup LIU 1 Dive Housing Authority Informatio
26. e the WinTen Check Reconciliation program hereafter referred to as Check Reconciliation Version Information This manual is written for the 2 24 2003 release of Check Reconciliation It does not apply to previous versions of the program including MS DOS based ones and some sections may be inaccurate with regards to later versions Whenever Tenmast issues an update to this pro gram will notify your agency through email If you have a current Update amp Support Agreement for this program you may download and install the update through the Tenmast Update Manager program During the download and installation process Update Manager will notify you of the changes to the program We periodically update this manual to reflect signif icant changes to the program You may download this updated documentation from our Web site at no charge Getting Help Though we have made every effort to make this manual as comprehensive as possible no document can cover all contingencies If you encounter problems with Check Reconciliation call the Tenmast Training amp Support Depart ment toll free at 877 359 5492 or send email to support tenmast com Revisions To better serve our clients we constantly update our manuals just as we constantly make improvements in our programs If you find an error or omission in this documentation or have a suggestion for improv ing it call the Tenmast Marketing Communication Services Departme
27. ecks Edit 4 6 5 8 Color 3 2 D Deposits Edit 4 9 5 11 E Export File 4 5 Setup 3 3 Overview 2 1 P Posting 7 1 Setup 3 3 Purge 9 1 R Reconcile 5 1 Reindex 10 1 Reports 8 1 Available List of 8 4 Printing 8 3 S Setup 3 1 Color 3 2 Export File 3 3 Posting 3 3 Statement 5 4 5 T Transactions 4 1 Add 4 3 Edit 4 3 4 9 Purge Old 9 1 Reconcile 5 1 WinTen Check Reconciliation 2 24 2003 Edition Index Page i l
28. er Bank Account 1111 amp ENERALFUNDS 1 Confirm the information on the report Click finish to post transactions to the Ledger Instruction Confirm the information on the report and click Finish to past those transactions to the General Ledger WinTen Check Reconciliation 2 24 2003 Edition Post Transactions to Ledger Page 7 3 WinTen Check Reconciliation 2 24 2003 Edition Post Transactions to Ledger Page 4 REPORTS Information needs to be summarized and present ed in an easy to understand form so the reader can make informed decisions The Reports screen is where Check Reconciliation turns all of its data into meaningful reports To enter this screen click the Reports button or press lt R gt at the Main Menu e lzixi e Help 6 Maintain Maintain Transactions Reports Reconcile Reconcile a Bank Account amp Purge Purge Transactions 11 53 Balance Bank Account Balance 8 Reindex Reindex Database Post Post Transactions to Ledger Setup Setup Exit WinTen Check Reconciliation 2 24 2003 Edition Reports Page 8 1 Select Bank Account Dialog Box When you enter the Reports area of the program the Select Bank Account dialog box opens You can only produce reports on one of your agency s bank accounts at a time This dialog box allows you to select the bank account whose data you are examining Select the desired account and click OK Select
29. gister database You cannot edit this field WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 9 Posting to Ledger Status Post If this box is checked the transaction will be posted to the General Ledger the next time you run the Post function from the Main Menu Posted to Ledger This field indicates whether or not the transaction has been posted to the General Ledger Fund ID This drop down selection box enables you to select the fund to which the transaction will be posted Account This is the number of the General Ledger account to which the transaction was posted or will be posted Clearing Status You cannot edit the Clearing Status fields The program fills them in automatically as they become relevant Current Status If the check has been marked as cleared a Cleared label appears in this field Cleared Amount This is the amount for which the check was cleared Who Cleared Transaction This is the user ID or initials of the user who cleared the check Date Transaction Cleared This is the date on which the check was cleared D Maintain Register Checks Wi i Wol o Transaction Source Bank Account tt fi 111 Transaction Kind Manual Transaction Details Check Number Name on Check ButGRasSTOWNG Amount of Transaction 85 00 Date of Transaction 02 03 2003 g Joumal Code Pe s Who Entered Transaction kao D
30. hat informs you where the file was created and what it was named For more information on the types of export files available in Check Reconciliation see the Setup chapter Table of Transactions Data Fields Payee Description This is the name of the check s payee or a brief description of the transaction Check This is the check s number This field is not avail able if you are viewing other transactions Date This is the date the transaction was posted Amount This is the transaction s amount Journal This is the journal in which the transaction was recorded PB Payables PR Payroll S8 Section 8 OD transaction is a deposit ON transaction is an NSF charge OC transaction is another bank charge Cleared If the transaction has been marked as cleared a Cleared label appears in this field Voided If the transaction has been voided a Voided label appears in this field Source This is the transaction s source Auto if it was created during a check processing sequence in an other WinTen program Manual if it was entered manually or Spoiled if the check was voided in Check Reconciliation Esport Maintain Transactions 3 gt 8 Check Number th Checks Diners C Check Date Account No 1111 GENERAL FUNDS Date Range n 20122003 g 0271172003 a Joumal Code z _ Search For Go ee Descriptio gt BROCK MCVEY CO 01 01 2003
31. ion Date Transaction Cleared WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 12 Posting to Ledger Status Post If this box is checked the transaction will be posted to the General Ledger the next time you run the Post function from the Main Menu Posted to Ledger This field indicates whether or not the transaction has been posted to the General Ledger Fund ID This drop down selection box enables you to select the fund to which the transaction will be posted Account This is the number of the General Ledger account to which the transaction was posted or will be posted Clearing Status You cannot edit the Clearing Status fields The program fills them in automatically as they become relevant Current Status If the transaction has been marked as cleared a Cleared label appears in this field Cleared Amount This is the amount for which the transaction was cleared Who Cleared Transaction This is the user ID or initials of the user who cleared the transaction Date Transaction Cleared This is the date on which the transaction was cleared WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 13 Mark as Reconciled Wizard When you close the Reconcile Transactions screen on a bank statement that is completely balanced the Mark as Reconciled wizard automatically starts This wizard controls the process of closi
32. ions that Check Reconciliation has recorded for the selected bank account What ta Include Cleared Transactions You can choose to include outstanding cleared and or voided transactions on this report You can also include all transactions regardless of date or check number or only those transactions that oc curred within a selected range of dates and or that had check numbers within a selected range You can sort the report by check number journal and date or date and journal Yoided Transactions Range of Dates Hange of Check Numbers Sort by Check Journal Date Date Journal Account Reconciliation Report The Account Reconciliation Report is a summary of a selected statement and reconciliation for the selected bank account Select the desired state ment date from the table of statements There are Bank Statement Reconciliation to Prin Statement Date Bank Balance 11 30 2001 195 387 21 no sorting or filtering options for this report 12 31 2001 203 065 41 013122002 116 284 90 O2 26 2002 148 355 02 03431 2002 158 843 40 4 002 124 215 18 0573172002 33 274 11 0630 2002 177 475 33 OF 31 2002 70 933 53 087 3172002 208 780 55 0973072002 145 803 72 10 31 2002 111 443 17 11 30 2002 131 070 33 WinTen Check Reconciliation 2 24 2003 Edition Reports Page 4 1 2002 134 404 11 Transaction Edit Register Report The
33. ment the data fields are blank and you must enter this data before you can continue Change or enter the data in these fields if neces sary and click OK to continue Enter Statement Date and Balance Bank Account 111 GENERAL FUNDS Statement Dat Statement Starting Date 12 01 2002 tj Statement Ending Date 12731 2002 tj Statement B alanc Beginning Statement Balance 99 458 05 Deposits and other Credits 78 351 00 Checks and Other Fees 71 568 21 Ending Statement Balance 106 740 84 WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 4 RECONCILE TRANSACTIONS SCREEN The Reconcile Transactions screen contains a table of every transaction that is in your records for the selected statement This screen enables you to edit individual transactions add new manual transactions and mark transactions as cleared Reconcile Transactions 5 8 Account fi 111 ort B C Check Number Check Date GENERAL FUNDS secht go Deposits Credits Date Range 12 31 2001 12 31 2002 Checks Fees Statement 0 00 0 00 Cleared 36 333 63 167 411 91 Difference 96 393 63 167 411 91 Journal Code _ Apply Statement Balance Outstanding Deposits Credits 88 165 61 Outstanding Checks Fees 53 219 55 Balance to Compare with Ledger 134 404 11 __Paree Dese
34. n 2 24 2003 Edition Purge Transactions Page 9 2 PunGE CLEARED TRANSACTIONS SCREEN The Purge Cleared Transactions screen enables you to select old transactions to purge To change the set of transactions that are shown enter a start ing and ending date and click the Apply button Purge Cleared Transactions Account No FUNDS Date Renge 5 In VINCENT HUDSON 022073 12 01 2000 25 00 Cleared Voided Auto ARCH PAGING 022141 12 14 2000 68 62 PB Cleared Auto amp 022142 12 14 2000 71 04 PB Cleared Auto BELLSOUTH 022143 12 14 2000 431 28 Cleared Auto BLAINE 022144 12 14 2000 18513 Cleared Auto BLUEGRASS WASTE ALLIANCE 022145 12 14 2000 128 02 Cleared Auto CED CREDIT OFFICE 022146 12 14 2000 11343 Cleared Auto COLUMBIA GAS OF KENTUCKY INC 022147 12 14 2000 1351540 PB Cleared Auto COMMERCIAL LIGHTING COMPANY 022148 12 14 2000 201 37 PB Cleared Auto JJANE M COURTNEY 022143 12 14 2000 20 25 Cleared Auto DAVIS H ELLIOT COMPANY INC 022150 12 14 2000 21863 PB Cleared Auto FIRST NATIONAL BANK 022151 12 14 2000 353 PB Cleared Auto I GEORGETOWN COMMUNICATIONS 022152 12 14 2000 282 70 Cleared Auto HANCO SUPPLY 022153 12 14 2000 26 53 Cleared Auto HIGHBRIDGE SPRINGS WATER CO 022154 12 14 2000 57 50 PB Cleared Auto amp H BALLENGER COMPANEY 022155 12 14 2000 11388 Cleared Auto
35. nding Deposits 95 155 51 Outstanding Checks 63 219 55 Current 4ccount Balance 134 404 11 WinTen Check Reconciliation 2 24 2003 Edition Bank Account Balance Page 6 3 WinTen Check Reconciliation 2 24 2003 Edition Bank Account Balance Page 4 Post TRANSACTIONS TO LEDGER Whenever a transaction is created in a WinTen program the program in which it was created is responsible for posting it to the General Ledger All of the transactions that Check Reconciliation receives from other programs Accounts Payable Tenant Accounts Receivable and Section 8 Tenant and Landlord have been or will be posted to the General Ledger by their parent programs Howev er you must post any transactions that have been created manually in Check Reconciliation To start the posting process click the Post button or press lt O gt at the Main Menu Check Reconciliation Maintain Transactions S Reports Reconcile a Bank Account Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger Setup WinTen Check Reconciliation 2 24 2003 Edition Post Transactions to Ledger Page 7 1 Select Bank Account Dialog Box When you click the Post button or press lt O gt the Select Bank Account dialog box opens You can only post transactions from one of your agency s bank accounts at a time This dialog box allows you to select the bank account whose manual transactions you are
36. ng out a bank statement and marking it as completely reconciled Step One The wizard informs you that the statement whose record you just exited is completely balanced and ready to be marked as reconciled Click the Start button to proceed to Step Two When you click the Start button a standard print preview screen opens with the Bank Reconciliation report for the selected statement Print this report and review it When you close the print preview screen the wizard continues to Step Two Step Two The wizard reminds you to review all information on the Bank Reconciliation report Click the Finish button to close the wizard and mark the bank statement as reconciled Mark As Reconciled Wizard Step 1 of Print Bank Recociliation Report Bank Account un GENERAL FUNDS You have balanced your checks and deposits into your bank statement This wizard will allow you to print a bank reconciliation report and mark the statement as reconciled Click start to print out the report and continue the process Mark Statement As Reconciled Bank Account un GENERAL FUNDS Confirm the information on the report Click finish to mark bank statement as reconciled nstruction Confirm the Information on the Report and Click Finish to Mark the Statement as Reconciled WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 14 Bank Account BALANC
37. ng selections Journal Code The Journal Code drop down selection box en ables you to filter the table of transactions to show only those transactions of a specific type If you are viewing checks you can view only Payables checks PB Payroll checks PR or Section 8 checks S8 If you are viewing other transactions you can view only deposits OD NSF charges charge backs ON or other bank charges OC Change this field then click the Apply button to ap ply your filtering selections Search For This data field allows you to search for a specific transaction Enter the target of your search in this data field and click the Go button The program searches whichever set of fields you have selected with the Search By radio buttons and highlights the first record in the table that matches your search target Add Click the Add button to add a new transaction If you are currently viewing checks this opens the Maintain Register Checks screen If you are cur rently viewing other transactions this opens the Maintain Other Register Transactions screen Edit Click the Edit button to edit the currently selected transaction If you are currently viewing checks this opens the Maintain Register Checks screen If you are currently viewing other transactions this opens the Maintain Other Register Transactions screen Checks Others Check Number Check Date Date Range 12 31 2001 tj 12 31 2002 8 Apply
38. nt toll free at 877 836 6278 or send email to info tenmast com Hint Downloading Manuals You can find the current version of this manual in the Client Service Area of our Web site at http www tenmast com All manuals are available in PDF file format You must have version 4 0 or newer of Adobe Acrobat Reader to open and print manuals You can also order printed copies of the manual through our Marketing Communication Services Department WinTen Check Reconciliation 2 24 2003 Edition Introduction Page 1 1 WinTen Check Reconciliation 2 24 2003 Edition Introduction Page 12 PROGRAM OVERVIEW Check Reconciliation enables you to reconcile bal ance the transactions recorded in your financial re cords for a bank account against those cleared by financial institutions for that same bank account Program Integration General Ledger Check Reconciliation posts manual entries in the check register e g entries for hand entered de posits and bank deposits and handwritten checks as opposed to checks written in another WinTen program to General Ledger s Manual Transaction Journal Master Setup The Master Setup program maintains the identify ing data for your agency s bank accounts If a posting to the Manual Transaction Journal see above crosses funds Check Reconciliation uses Master Setup s Inter Fund Account data to balance this transaction Accounts Payable Payroll and Section 8 All three
39. on removes all blank or deleted entries from its database thereby reducing the size of the files Caution Tenmast does not recommend you perform packing un less specifically instructed to do so by Tenmast Training amp Support personnel Packing permanently removes deleted records Once you have packed data that the packing process erases will be irretrievably gone WinTen Check Reconciliation 2 24 2003 Edition Reindex Page 10 2 Reindexing When you begin the reindexing process the Re organize Check Reconciliation Data dialog box opens This dialog box has a pair of check boxes that allow you to select which activities you wish to perform with the database Select the check boxes that correspond to the func tions you want to perform then click the OK button The program begins the reindexing process which should take no longer than two or three minutes When the process is complete the dialog box clos es and the program returns to the Main Menu ppm Check Reconcilation Data This function requires exclusive use of the Database You must make sure that no one else is in the application Reorganization Option v Re tndex Pack WinTen Check Reconciliation 2 24 2003 Edition Reindex Page 10 3 WinTen Check Reconciliation 2 24 2003 Edition Reindex Page 10 4 INDEX A Account Balance 6 1 Account Statement See Statement B Balance 6 1 Bank Statement See Statement C Ch
40. posting Select the desired account and click OK This starts the Post Manual Transactions wizard Select Bank Account GENERAL FUNDS 1111 16 Mone Market Account WinTen Check Reconciliation 2 24 2003 Edition Post Transactions to Ledger Page 7 2 Post Manual Transactions Wizard Step One Select the order in which you want to sort the Pre Posting Listing report Click the Start button to proceed to Step Two When you click the Start button a print preview screen opens with the Pre Posting Listing report Review this report then click the Close button to continue Step Two Review the Pre Posting Listing report Confirm that all transactions are present and will be posted to the correct accounts If all of the information on the report is correct click the Finish button The program posts every transaction on the Pre Posting Listing report to the General Ledger When the process is complete the wizard closes and the program returns to the Main Menu If any information on the report is incorrect click the Cancel button Go to the Maintain Transactions area of the program and edit the incorrect transac tions Q Post Manual Transactions Wizard Step 1 Print List of Transactions to be Posted Bank Account nn GENERAL FUNDS Check Number C Joumal Code FundlD Account Post Manual Transactions Wizard Step 2 of 2 Post Register Transactions to General Ledg
41. r specific records within its databases Index files are similar to a library s card catalog they tell the computer the location of the data for which you are searching Indexing da tabases is safe to do at any time it does not need to be done at a specific time of the month or the year To initiate the reindexing process click the Reindex button or press I from the Main Menu 9 Check Reconciliation Maintain Transactions 5 Reports Reconcile Bank Account Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger e Setup WinTen Check Reconciliation 2 24 2003 Edition Reindex Page 10 1 When to Reindex Occasionally index files can become corrupted This means that such a file s data is no longer com plete and it may not be in a form that Check Rec onciliation can read The most common indicator of a corrupted index file comes when you search for an entry that you know is present and the pro gram does not find it Reindexing solves this prob lem by going through the database and rebuilding the index file for it Caution You must make sure that no one else is using Check Rec onciliation before using this feature Reindexing rewrites files and cannot do so if they are already open when Check Reconciliation attempts to index them When to Pack While you are reindexing you also have the op tion to pack the database Packing is a process by which Check Reconciliati
42. ription _ Check E Date _ _Amount__ Jownal Cleared Voided Source B QUILL CORPORATION 025615 11 25 2002 224 53 Cleared Auto SCOTT S SAFETY amp JANITORIAL SU 025616 11 25 2002 123 40 5 Cleared Auto SETH S LIGHTING amp ACCESSORIES 025618 11 25 2002 5333 PB Cleared Auto TONY S PAINTING INC 025619 11 25 2002 3 501 00 PB Cleared Auto CARDINAL OFFICE SYSTEMS 025623 12 01 2002 1 74750 PB Cleared Auto DELTA DENTAL PLAN OF KENTUCK 025624 12 01 2002 717 56 PB Cleared Auto HOCKENSMITH AGENCY 025625 12 01 2002 366 40 PB Cleared Auto LYNN IMAGING 12 01 2002 130 00 Cleared e sa afen WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 5 Reconcile Transactions Screen Controls Checks Others The Checks and Others buttons enable you to switch between viewing all checks on the current statement and viewing all non check transactions deposits NSF charges charge backs and other bank charges on the current statement Sort By The Sort By set of radio buttons enables you to select the order in which the table of transactions is sorted Date Range The Date Range data fields enable you to filter the table of transactions to show only those transac tions that occurred within a specific range of dates If you leave these fields blank the table shows all outstanding transactions Change these fields then click the Apply button to apply your filteri
43. rked as cleared Outstanding Checks Fees This is the total amount of all deposits and credits in Check Reconciliation s records that have not been marked as cleared Balance to Compare with Ledger This is the calculated ledger balance for the select ed bank account as determined by the three data fields above it Compare the calculated balance in this field with the actual account balance in General Ledger to determine if General Ledger balances to Check Reconciliation Clear E Unclear Clear Range Enter Range of Check Numbers _ Check Type Paper Check C Direct Deposit r Range of Check Numbers Starting Check Number o C Ending Check Number 500 Reconcile Transactions 3 gt 8 Check Number chests Qe C Check Date Account No un GENERAL FUNDS Date Range 12 31 2001 E 1273172002 Neural z _ Apply Search For Go Statement Balance 99 458 05 Outstanding Deposits Credits 88 165 61 Outstanding Checks Fees 53 219 55 Checks Fees Deposits 7 Credits Statement 0 00 0 00 Cleared 96 393 63 167 411 91 Difference 96 393 63 167 411 91 Balance to Compare with Ledger 134 404 11 QUILL CORPORATION 025615 11 25 2002 224 53 Cleared SCOTT S SAFETY amp JANITORIAL SU 025616 11 25 2002 12840 PB Cleared Auto SETH S LIGHTING amp ACCESSORIES 025618 11 25 2002 5993 PB
44. s source Auto if it was created during a check processing sequence in another WinTen program Manual if it was en tered manually or Spoiled if it is a check that was spoiled during printing and subsequently voided Transaction Details Description This is a brief 36 character description of the transaction Amount of Transaction This is the amount of the transaction Date of Transaction This is the date on which the transaction occurred Journal Code This is the journal code under which the transaction was recorded OD transaction is a deposit ON transaction is an NSF charge OC transaction is another bank charge Who Entered Transaction This is the user ID or initials of the user who cre ated the transaction You cannot edit this field Date Transaction Entered This is the date on which the transaction was en tered into the check register database You cannot edit this field WinTen Check Reconciliation 2 24 2003 Edition Maintain Other Register Transactions Al 80 8 gt gt Transaction Source Bank Account finn Transaction Kind Manual Transaction Details Description ANONYMOUS CHARITABLE DONATION Amount of Transaction 1000000 Date of Transaction 1272572002 gj Joumal Code Joo 4 Who Entered Transaction no Date Transaction Entered 122003 Posting to Ledger Status Post Posted to Ledger Fund D 100 z Account 1
45. view only deposits OD NSF charges charge backs ON or other bank charges OC Change this field then click the Apply button to ap ply your filtering selections Search For This data field allows you to search for a specific transaction Enter the target of your search in this data field and click the Go button The program searches whichever set of fields you have selected with the Search By radio buttons and highlights the first record in the table that matches your search target Add Click the Add button to add a new transaction If you are currently viewing checks this opens the Maintain Register Checks screen If you are cur rently viewing other transactions this opens the Maintain Other Register Transactions screen Edit Click the Edit button to edit the currently selected transaction If you are currently viewing checks this opens the Maintain Register Checks screen If you are currently viewing other transactions this opens the Maintain Other Register Transactions screen Checks Others t Check Number Check Date Date Range 01 01 2003 02 11 2003 Apply Journal Code Apply Search For Go er Add ee Edit WinTen Check Reconciliation 2 24 2003 Edition Maintain Transactions Page 4 4 Export Click the Export button to send the table of transac tions to an export file The program automatically creates the export file then opens a dialog box t
46. with your own records This process involves establishing a one for one match between the transactions in your agency s records and the transactions that the bank has recorded To begin the reconciliation process click the Reconcile but ton or press lt C gt at the Main Menu Check Reconciliation Maintain Transactions ich Reports Reconcile a Bank Account Purge Transactions Bank Account Balance Reindex Database Post Transactions to Ledger Setup WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 1 Select Bank Account Dialog Box When you first enter the Reconcile a Bank Account area of the program the Select Bank Account dia log box opens You can only maintain the transac tions for one of your agency s bank accounts at a time This dialog box allows you to select the bank account whose data you are managing Select the desired account and click OK Select Bank Account GENERAL FUNDS 1111 15 Mone Market Account WinTen Check Reconciliation 2 24 2003 Edition Reconcile a Bank Account Page 5 2 Reconcile BANK Account SCREEN When you select a bank account whose transac tions you will maintain the Reconcile Bank Account screen opens This screen contains a table of ev ery bank statement reconciliation in Check Rec onciliation s database for the selected account To continue working with an existing statement select that statement in the table and

WinTen - Tenmast Software

Contents

Download Pdf Manuals

Related Search

Related Contents