Auto Reconciler 2013 - Encore Business Solutions Inc.
Contents
1. File Maintenance previously Table Conversion File gt gt Maintenance gt gt Encore Bank Reconciliation Table Conversion File Maintenance Encore Bank Reconciliation File Maintenance Auto Reconciler Import Setup previously Import File Layout Maintenance Tools Setup Encore Bank Reconciliation 22 Import File Layout Tools Setup Encore Bank Reconciliation Auto Reconciler Import Setup 34 AUTO RECONCILER Window 8 0 and before 9 0 new Auto Reconciler previously Bank Import Transactions 22 Financial Encore Electronic Bank Import Transactions Financial Encore Bank Reconciliation 22 Auto Reconciler Auto Reconciler Checkbook Setup previously Link to Chequebook Maintenance Tools Setup Encore Bank Reconciliation gt gt Link to Chequebook Tools gt gt Setup gt gt Financial gt gt Encore Bank Reconciliation gt gt Auto Reconciler Checkbook Setup Bank Statement Entry previously Bank Reconciliation Transactions gt gt Financial gt gt Encore Multicurrency Bank Reconciliation Tools gt gt Setup gt gt Financial gt gt Encore Bank Reconciliation gt gt Bank Statement Entry or Transactions gt gt Financial gt gt Encore Bank Reconciliation gt gt Bank Statement Entry Multicurrency Bank Reconciliation previously Bank Reconciliation Utility Transacti2. INTRODUCTION Symbols and conventions This manual uses the following symbols and conventions to make information stand out Symbol Convention Description The warning symbol indicates situations you should be especially aware of when completing tasks Typically this symbol includes cautions about performing steps in their proper order or important reminders about how other information in Microsoft Dynamics GP may be affected The light bulb symbol indicates helpful tips shortcuts and Q suggestions File gt gt Print The 22 symbol indicates selections to make from a menu In this example from the File menu choose Print AUTO RECONCILER INTRODUCTION Additional resources Documentation is provided in online or hard copy format as an Adobe Acrobat PDF file Online help is available for this version of Auto Reconciler To obtain product support services Please refer to this quick reference table when you need to use Encore s Technical Support services Service Contact General Calls 204 989 4330 Toll Free 888 898 4330 North America only Fax 204 235 2331 E mail support encorebusiness com Web www encorebusiness com Before You Call Support You should have the answers for all of the following questions to help your support specialist quickly narrow down the source of the problem you are experiencing e What is the exact error message e When did the error first occu
3. sss 14 Registering Auto Reconciler essere tnnt ttetente 14 File Maintenance nete tette E iere tere cte ee eret dede 17 Setting up Auto tette tentes 19 Chapter Using Auto 26 Setting up the bank statement information sssssssseertees 26 Importing the bank statement 26 Appendix A Data tables 1 sees 31 What s New in Auto Reconciler for 2013 sss 33 What s New in Auto Reconciler for 2010 sss 33 What s New in Auto Reconciler for 10 0 SP3 sees 33 What s New in Auto Reconciler for 10 0 SP2 sees 33 What s New in Auto Reconciler for 10 0 seen 34 What s New in Auto Reconciler for 9 0 sss 34 New Encore Products Known ISSUES About Encore Business Solutions AUTO RECONCILER iii ur TABLE OF CONTENTS AUTO RECONCILER INTRODUCTION 6 Introduction AUTO RECONCILER Welcome to Auto Reconciler a powerful companion product to Encore s Account Reconciler product and to the Bank Reconciliation module in Microsoft Dynamics GP 2013 Auto Reconciler provides the following features and benefits e Reads bank statement transactions e Allows flexibility in defining the type of file format to use in the matching process comma delimited
4. fixed length TD BAI CIBC OSC or BAI2 e Automatically matches payments and deposits greatly reduces the amount of time you will spend tediously matching entries against the bank statement Note Matching deposits is supported when using Encore s Account Reconciler module only e Provides detailed reports showing all transactions that are Cleared and Not Cleared Note Cleared with a difference is available only when using Auto Reconciler with Microsoft Dynamic GP 2013 Bank Reconciliation uis INTRODUCTION What s In This Manual This manual contains a detailed description of Encore s Auto Reconciler module step by step instructions to guide you through the installation and setup and instructions for how to reconcile your bank statement electronically This manual assumes that you are familiar with and know how to operate the Microsoft Dynamics GP accounting system It also assumes that Microsoft Dynamics GP 2013 has been installed and configured on your computer This manual contains the following chapters The ntroduction chapter lists the benefits and features of the Auto Reconciler The nstallation amp Setup chapter has step by step instructions that guide you through the installation and setup of your Auto Reconciler module The Using Auto Reconciler chapter describes how to set up bank statement information and how to import the bank statement when reconciling bank accounts AUTO RECONCILER 7 uus 8
5. Copy and paste or manually enter the product registration key provided by Encore for the product that you have purchased If manually entering the key ignore the sections Select OK 5 To view product specific information such as the version number click on the About zoom field to open the About window 6 Select OK to close the Encore Product Registration window To register your product using a drop file 1 Copyor save the drop file to the directory location for your Microsoft Dynamics GP For Example C Microsoft Dynamics GP 2 Login to Microsoft Dynamics GP as a system administrator 3 The system will notify you that it has found a registration file accept the prompt so the drop key gets applied 16 AUTO RECONCILER INSTALLATION amp SETUP 4 The system will notify you when the product has been registered 5 Openthe Encore Product Registration window and select your product to verify that it is registered Microsoft Dynamics GP Menu gt gt Tools gt gt Setup gt gt System gt gt Encore Product Registration File Maintenance The File Maintenance window is used to create and or update all the necessary components to use this product After you ve installed and registered the product you must run the file maintenance process to evaluate all resources and upgrade them to the latest version as necessary You must log in as System Administrator to run the file maintenance process To run file mai
6. this documentation including the warranties of merchantability and fitness for a particular purpose The content of this manual is furnished for informational use only is subject to change without notice and should not be construed as a commitment by Encore Business Solutions Inc Encore Business Solutions Inc assumes no responsibility or liability for any errors or inaccuracies that may appear in this manual Neither Encore Business Solutions Inc nor anyone else who has been involved in the creation production or delivery of this documentation shall be liable for any indirect incidental special exemplary or consequential damages including but not limited to any loss of anticipated profit or benefits resulting from the use of this documentation or sample code Use of this product is covered by a license agreement provided by Encore Business Solutions Inc If you have any questions please call our office at 204 989 4330 or toll free at 888 898 4330 North America only September 2012 us TABLE OF CONTENTS Table of Contents Introduction What s In This 8 Symbols and conventions treten tette nete Additional resources sse tette tette ttt tritt tette teretes 9 Chapter Installation Setup s 12 Installing Auto Reconciler essere tnter tenente 12 Upgrading from previous versions of Auto Reconciler
7. 4 Start Microsoft Dynamics GP You will receive the following message box Dexterity Runtime i New code must be included in the C GPSQL_10_F Dynamics set dictionary Do you wish to include new code now 5 Select Yes The Auto Reconciler and Encore Product Registration modules will be included in the Dynamics set file V For information on the data tables installed for Auto Reconciler refer to Appendix A Data tables AUTO RECONCILER 13 us 14 INSTALLATION amp SETUP Upgrading from previous versions of Auto Reconciler To upgrade to a new version you will need to obtain a new registration key Call Encore Business Solutions Inc toll free at 888 898 4330 North America only to obtain the new registration key To upgrade from any prior version you must update tables using the File Maintenance process as described in File Maintenance on page 17 Registering Auto Reconciler AUTO RECONCILER Before you can use Auto Reconciler with your company data you must register your software To register your software enter the product registration key or the drop file provided to you by Encore If you choose not to enter the registration keys you will only be able to create sample transactions using Fabrikam Inc the lesson company uus INSTALLATION amp SETUP To register your product using registration keys Open the Encore Product Registration window Microsoft Dynamics GP Menu gt gt Tools g
8. 7 20000 0 4 Mj AUTO RECONCILER 21 22 INSTALLATION amp SETUP AUTO RECONCILER Matching Field ID Required Description Deposit No Deposit amount field Description No Description of Transac tion Document Date Yes Date transaction cleared bank Document Number Yes Field containing cheque Deposit etc Payment Yes Payment amount field If you are using Fixed Length enter the Start position the starting position count the characters in the Sample at the bottom of the window to determine this of the various matching fields and the Length of each of the fields number of digits PM Auto Reconciler Import Setup File Edit Tools Help sa Dextordinary Inc 07 17 2008 bk Save Clea X Delete Import ID BANK IMPORT iol File Type Fixed Length vi Payments and Deposits Separated columns in Import file v Sample File iR Intemal Products B ank Reconciliation Auto Reconcile Account Reconciler Skip Rows Matching Field ID Sample Field Start Lenath Date Format Data Type Max Size i DEPOSIT 0 DESCRIPTION 0 N A DOCUMENT DATE 0 MMDDYY DOCUMENT NUMBER 0 N PAYMENT 0 Sample 020500 000027 20000 0 Mr mo v 8 Countthe number of header lines in your sample bank file Enter this number in the Skip 4 rows field ui 9 INSTALL
9. ATION amp SETUP If the correct number isn t entered your file will not import successfully Select Save to save the changes you made in the Auto Reconciler Import Setup window In order to reconcile deposits Account Reconciler looks for matching document numbers and deposit amounts If your bank file does not include document numbers for deposits you must enter ONE of the following two lines into the Dex ini file to change this criteria AR MatchBy DATE AR MatchByzAMOUNT After you add one of these two lines to the Dex ini file deposits will be matched by date or amount Link import layout to checkbook This procedure links the import layout you just defined to the checkbook that you want to reconcile To link import layout to checkbook 1 2 3 Open the Link to Checkbook window Microsoft Dynamics GP Menu gt gt Tools gt gt Setup gt gt Financial gt gt Encore Reconciler Auto Reconciler Checkbook Setup P Auto Reconciler Checkbook Setup File Edit Tools Help sa Dextordinary Inc 07 02 2008 Ll Save Cla X Delete Checkbook ID Import ID File Type Account Number Skip of Rows Default File I4 4 gt M Select the checkbook ID that you want to link to the import ID Enter or choose the import ID created in the Auto Reconciler Import Setup window AUTO RECONCILER 23 24 INSTALLATION amp SETUP AUTO RECONCILER 4 5 Enter the account number i
10. Auto Reconciler 2013 An application for Microsoft Dynamics GP 2013 Encore Business Solutions Furthering your success through innovative business solutions Copyright Trademarks Warranty disclaimer Limitation of liability License agreement Publication Date Manual copyright 2012 Encore Business Solutions Inc Printed in Canada All rights reserved Your right to copy this documentation is limited by copyright law and the terms of the software license agreement As the software licensee you may make a reasonable number of copies or printouts for your own use Making unauthorized copies adaptations compilations or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law Microsoft Microsoft Excel Microsoft Dynamics GP and Microsoft Dynamics GP are either registered trademarks or trademarks of Microsoft Corporation or its affiliates in the United States and or other countries The names of actual companies and products mentioned herein may be trademarks or registered marks in the United States and or other countries of their respective owners The names of companies products people and or data used in window illustrations and sample output are fictitious and are in no way intended to represent any real individual company product or event unless otherwise noted Encore Business Solutions Inc disclaims any warranty regarding the sample code contained in
11. e an import ID template for an import file which can be used to import your bank statement Once a file is created it allows you to match the fields in your bank statement to those in Auto Reconciler PA Auto Reconciler Import Setup File Edit Tools Help sa Dextordinary Inc 07 17 2008 Lb Save Cla X Delete Import ID File Type Payments and Deposits Sample File Skip Rows Matching Field ID Sample Field Date Format Data Type MaxSize Sample Mr mo v AUTO RECONCILER 19 20 INSTALLATION amp SETUP AUTO RECONCILER 2 To create an import layout 1 Open the Auto Reconciler Import Setup window Microsoft Dynamics GP Menu gt gt Tools gt gt Setup gt gt Financial gt gt Encore Reconciler Auto Reconciler Import Setup If Auto Reconciler Import Setup File Edit Tools Help bk Save Clea X Delete Eor sa Dextordinary Inc 07 17 2008 Import ID File Type EN Payments and Deposits Sample File Skip tt Rows Sample Field Matching Field ID Max Size Start Data Type Sample Length Date Format I4 4 gt Import ID Enter the import ID you will use to import your bank files each month You may define this ID tag as you wish an example would be Bank Import Or If the bank import file is a generic type file select a file type of either Comma Delimited or Fixed Len
12. electing Auto Reconciler for Microsoft Dynamics GP Bank Rec and expanding the window The About window link is located in the bottom left hand corner of the window INSTALLATION amp SETUP Installation Setup 12 This chapter describes how to install and set up Auto Reconciler Installing Auto Reconciler Upgrading from previous versions of Auto Reconciler File Maintenance Registering Auto Reconciler Setting up Auto Reconciler Installing Auto Reconciler AUTO RECONCILER You will use the installation program to install Auto Reconciler Before you begin installing do the following Make a note of the directory location of your Microsoft Dynamics GP 2013 installation This information will be required during the installation Verify that the AR12 00 01 xxx exe file has been loaded on to your computer The x s in the file name will be replaced with numbers Create a backup of your Microsoft Dynamics GP data before installing Auto Reconciler Exit all applications To install Auto Reconciler 1 Open Windows Explorer and locate the AR12 00 01 xxx exe file The location of this file will vary depending on how you acquired the application The x s in the file name will be replaced with numbers Launch the AR12 00 01 xxx exe file by double clicking it The installation program for Auto Reconciler will start uus INSTALLATION amp SETUP 3 Follow the instructions in each window
13. f BAI2 was selected as the file format type Enter the file location for the default file of your bank statement or use the file icon to locate it If Auto Reconciler Checkbook Setup File Edit Tools Help E Save Cea X Delete sa Dextordinary Inc 07 02 2008 Checkbook ID FIRST BANK Kl Import ID BANK IMPORT A File Type Fixed Length Skip of Rows a0 Defaut Fie Rilntemal Products Bank Reconciliation Auto Reconciler_ Account 5 i 6 Select Save to save your changes USING AUTO RECONCILER 26 Using Auto Reconciler This chapter describes how to use Auto Reconciler to reconcile your bank statement with your Microsoft Dynamics GP account information It includes the following sections Setting up the bank statement information Importing the bank statement Setting up the bank statement information Before you can begin to reconcile bank statements using Auto Reconciler with Microsoft Dynamics GP Bank Rec you must set up the bank statement information in the Microsoft Dynamics GP Reconcile Bank Statements window If you are using Auto Reconciler with Encore s Account Reconciler see the Account Reconciler user manual for setup instructions Importing the bank statement Once your bank statement information is set up you can import the bank statement AUTO RECONCILER USING AUTO RECONCILER To import the bank statement 1 Open the Auto Reconciler
14. gth Go to steps 6 and 7 To import bank statements for TD or CIBC select the bank file format type TD BAI CIBC OSC or BAI2 INSTALLATION amp SETUP If you are using TD BAI CIBC OSC or BAI2 see your bank representative for a sample file to provide you with information on setting up your bank import field If you are using Comma Delimited or Fixed Length file type select the payment and deposit option from the drop down list Enter the file location of the sample file of your bank statement or use the file icon to locate it If you are using Comma Delimited select the Sample Field that matches the one displayed in the Matching Field ID column until you have matched all required fields See the table below the illustration which provides a description of all matching field ID s Once you have completed matching the fields skip to step 8 PA Auto Reconciler Import Setup DER Fie Edit Tools Help sa Dextordinary Inc 07 17 2008 E Save Z Cea X Delete Import ID BANK IMPORT LY File Type Comma Delimited v Payments and Deposits Separated columns in Import file Sample File Ralntemal Products B ank Reconciliation Auto Reconcile_ Account Reconciler le Skip t Rows Matching Field ID Sample Field Stat Length Date Format Data Type Max Size DEPOSIT i a i T o DESCRIPTION DOCUMENT DATE MMDDYY DOCUMENT NUMBER PAYMENT Sample 020500 00002
15. le Name File Format 7 Select the report destination s you prefer to view a report 8 Adetailed matching report will be created listing all transactions that cleared or did not clear il Screen Output A Import Generic Exceptions amp Print SendTo Modify IM Completed 1 Page System 01 06 2004 12 07 27 PM Fabrikam Inc Page X User Date 12 04 2007 Bank Reconciliation Import User ID sa Chequebook ID FIRST BANK Type Number Date Description Trx Amount Cleared Amount Difference NOT CLEARED PMT 000026 01 02 2000 100 00 PMT 000027 05 02 2000 200 00 PMT 000028 12 02 2000 300 00 AUTO RECONCILER 29 I USING AUTO RECONCILER 30 AUTO RECONCILER Appendix A Display Name Data tables APPENDIX A DATA TABLES The following charts lists data tables created in Auto Reconciler and their descriptions Financial Series Technical Name Physical Name Description Auto Reconciler Import Banks A Import Banks BS3000 Import Banks amp reports Auto Reconciler Import Temp A Bankrec Import Temp BS2005 Import Banks amp reports Auto Reconciler Checkbooks A Import Checkbook MSTR 3 Import Checkbook Auto Reconciler Import Temp A Import Generic TEMP TEMP Temp file for import Auto Reconciler Import Field Match A Import Field Match TEMP TEMP Temp file for import Temp Auto Reconciler Import Exception
16. ntenance 1 Open the File Maintenance window Microsoft Dynamics GP Menu gt gt File gt gt Maintenance gt gt Encore Reconciler gt gt File Maintenance File Maintenance x File Edit Tools Help sa Fabrikam Inc 4 12 2017 Encore Reconciler Create Update Resources By Process o Cancel 2 Ensure the Create Update Tables box is marked 3 Select the Process button Tables will be created permissions and any existing data will be set The SQL Server components for Auto Reconciler will be created 4 The Synchronize Account Number option provides the ability to update the GL account information to reflect changes made to the Microsoft Dynamics GP GL account framework Use it when AUTO RECONCILER 17 INSTALLATION amp SETUP e Auto Reconciler has been upgraded from a version prior to version 9 0 e Changes have been made to the account framework such as adding or deleting segments to the account numbers or changing the existing account numbers Every time you install Auto Reconciler you must run the file maintenance process for each company 18 AUTO RECONCILER INSTALLATION SETUP Setting up Auto Reconciler Before you can begin to use Auto Reconciler to balance your bank account electronically you must e Create an import layout e Link import layout to checkbook Create an import layout The Auto Reconciler Import Setup window is used to creat
17. on the Auto Reconciler windows New Encore Products AUTO RECONCILER Investor Relationship Manage Investor Relationship Manager developed by Encore Business Solutions Inc seemlessly integates with Microsoft Dynamics GP Investor Relationship Manager allows users to coordinate monitor and manage various types of third party investments including shareholder investments and equities such as stock certificates and dividends Known Issues 1 Auto Reconciler only supports bank statements that are imported with amounts that are in the functional currency If a bank statement is imported that is in a currency other than the functional currency it will be translated into the functional currency which will cause discrepancies 2 The Auto Reconciler import file requires that each amount includes 2 decimal places in order to display imported amounts in the correct format A source file containing the value 50 1 will be imported as 5 01 50 will be imported as 0 50 The 2 implied decimal place format is always assumed regardless of the decimal point position Note If you are using the Tab delimited txt or Comma delimited csv file types the amounts shown on the import window may not be equal to the amounts in the source file To work around this issue To successfully import all amounts in the source file ensure that the 2 decimal requirement is met by adding 2 zeros and a decimal point at the end of every amount that does n
18. ons gt gt Financial gt gt Encore Multicurrency Bank Reconciliation gt gt Transaction button Transactions gt gt Financial gt gt Encore Bank Reconciliation gt gt Multicurrency Bank Reconciliation Account Adjustments previously Bank Reconciliation Adjusting Entries Transactions gt gt Financial gt gt Encore Multicurrency Bank Reconciliation gt gt Transaction button gt gt Adjustment expansion button Transactions gt gt Financial gt gt Encore Bank Reconciliation gt gt Multicurrency Bank Reconciliation gt gt Adjustment expansion button Improvements to Auto Reconciler Previously in the Auto Reconciler Bank Import window when a file was being imported additional blank lines were being included This functionality has been changed so there are no longer any additional blank lines being included in the import File Maintenance The File Maintenance window renamed from Table Conversion has received additional functionality It now has the ability to synchronize account numbers This functionality was added to allow the Bank AUTO RECONCILER 35 us 36 Reconciliation module to update its GL account information to reflect changes made to the Microsoft Dynamics GP GL account framework Microsoft Dynamics GP Calendar Feature For Auto Reconciler version 9 0 we have taken advantage of the Microsoft Dynamics GP calendar feature and included it for all editable date fields
19. or Relationship Manager e Inventory I O Control If you have questions regarding any Encore product or service feel free to contact us Toll Free 888 898 4330 North America only Phone 204 989 4330 Fax 204 235 2331 E mail encore encorebusiness com Internet www encorebusiness com Mail 467 Provencher Blvd Winnipeg MB Canada R2J 0B8 Microsoft Gold Certified Partner 2003 2012 Microsoft Business Solutions Inner Circle Member 2000 2002 2005 Microsoft Business Solutions President s Club Member 1996 2009 Microsoft Business Solutions Organizational Excellence 2002 Microsoft Business Solutions Partners Choice Developer Award 1999 amp 2000 Microsoft Partner Encore Gold Enterprise Resource Planning Independent Software Vendor ISV Business Solutions
20. ot have a decimal or does not have 2 figures after the decimal For example if your amount is equal to 50 change the source amount to 50 or 50 00 if your amount is equal to 50 1 change the source amount to 5 01 or 50 10 AUTO RECONCILER 37 uus 38 AUTO RECONCILER About Encore Business Solutions Encore Business Solutions Inc is part of a worldwide network of independent partner organizations that sell implement and support the award winning products of Microsoft Business Solutions Encore is also an authorized Solution Developer for Microsoft Business Solutions developing and marketing industry specific software worldwide that tightly integrates to core modules of Microsoft Dynamics GP We are 10096 dedicated to developing client focused reliable industry specific solutions and companion applications providing total end to end solutions that meet the operational and reporting needs of our customers The Encore Business Solutions Inc suite of products include Project Tracking Solutions e Project Tracking with Advanced Analytics e Project Tracking with Budgeting Project Tracking Importer e Project Tracking Lite Billing Solutions e Recurring Contract Billing e Recurring Contract Billing Importer Bank Reconciliation Solutions e Auto Reconciler Account Reconciler Bio fuel Solutions REAP e REAP Auto Delivery REAP Integration REAP eConnect Additional Encore Products e Advanced SmartList e Invest
21. r e What task were you attempting to perform at the time you received the error message e Has the task been completed successfully in the past e What is the name of the window you are working in e What have you done so far to attempt to fix the problem AUTO RECONCILER 9 us 10 INTRODUCTION AUTO RECONCILER e Have you performed any of the table maintenance procedures such as check links fhave performed table maintenance procedures and received error messages what kind of messages e Does the problem occur in another company Does the problem occur on another workstation e Does the problem occur for more than one user e Have you imported any data e What versions of software are you using Verify the version numbers for Microsoft Dynamics GP 2013 your database software Encore products and Windows Also note service packs To locate the version number for Auto Reconciler in version 2013 2010 and 10 0 go to Microsoft Dynamics GP Menu gt gt Tools gt gt Setup gt gt System gt gt Encore Product Registration The About window can be located by selecting Auto Reconciler for Microsoft Dynamics GP Bank Rec and expanding the window The About window link is located in the bottom left hand corner of the window To locate the version number for Auto Reconciler in version 9 0 and 8 0 go to Tools gt gt Setup gt gt System gt gt Encore Product Registration The About window can be located by s
22. s A Import Generic Exceptions TEMP For Report use only RPT Auto Reconciler Import Master A Import Generic HDR IMP1000 Import Checkbook File Layout Auto Reconciler Import Line A Import Generic LINE IMP1100 Import Checkbook File Layout Line Auto Reconciler Problem Report A Import Generic Problem RPT TEMP For reports use only AUTO RECONCILER 31 APPENDIX A DATA TABLES 32 AUTO RECONCILER What s New in Auto Reconciler for 2013 Auto Reconciler has been fully upgraded to be compatible with Microsoft Dynamics GP 2013 What s New in Auto Reconciler for 2010 Auto Reconciler has been fully upgraded to be compatible with Microsoft Dynamics GP 2010 and Windows 7 e Auto Reconciler has been enhanced to support non functional checkbooks e Anew Dex ini option has been added so that the system can be set to allow payment cheques to perform an additional search for matching transactions If there is no document number or it doesn t find a match based on the document number the system will try to find a match based on the amount It will do this for both functional and non functional amounts Dex ini option setting is MatchPaymentsByZAMOUNT What s New in Auto Reconciler for 10 0 SP3 Auto Reconciler now automatically saves the date the cheque or deposit cleared the bank so that you can run analysis on how long it takes for checks deposits to clear the bank Auto Reconciler now is able to perform a
23. smart matching to ignore the leading zeros on imported check deposit document numbers What s New in Auto Reconciler for 10 0 SP2 Auto Reconciler now supports a general implementation of the BAI2 file type If your BAI2 file contains transactions for different bank accounts you now have the ability to specify an account number in the Auto Reconciler AUTO RECONCILER 33 Checkbook Setup window so that only the transactions specific to the selected account number will be imported Additionally Auto Reconciler now supports comma delimited or fixed length files where the payment and deposit amount are in the same column A Payments and Deposits drop down list has been added to the Auto Reconciler Import Setup window which includes the following options e Separated Columns in Import file e Combined Column payments are negative e Combined Column deposits are negative What s New in Auto Reconciler for 10 0 Auto Reconciler has been upgraded to be compatible with Microsoft Dynamics GP version 10 0 What s New in Auto Reconciler for 9 0 For the version 9 0 release of Bank Reconciliation a new name has been established Bank Reconciliation will now be called Auto Reconciler The new name is a more defining name for this product To go along with the new product name there has been changes to the window naming and the menu naming The following chart provides details of the menu and window changes Window 8 0 and before 9 0 new
24. t gt Setup gt gt System gt gt Encore 1 Product Registration Highlight the product you wish to register Bal Encore Product Registration File Edit Tools Help ej m sa Fabrikam Inc 4 12 2017 289 Site PreviewKeys Users 3 Company Fabrikam Inc Database SOL Server Platform Microsoft Dynamics GP 12 00 Products Version Account Reconciler 1000 4 Account Tracker St Boniface College ONLY 0000 Advanced SmartList 5 000 Auto Reconciler for Encore Account Reconciler 1 001 7 Auto Reconciler for Microsoft Dynamics GP Bank Rec 1 001 Enhanced Customer Statement 1000 Es Inventory 1 0 Control 1000 Investor Relationship Manager 1000 Mass Biling for Invoicing 1 001 Mass Billing for SOP 1000 EPM 12 00 02 042 AUTO RECONCILER 15 INSTALLATION amp SETUP 3 Choosethe show details expansion button to display the detailed view of the registration window E Products m Encore Product Registration File Edit Tools Help Site PreviewKeys Users 3 Company Fabrikam Inc Database SOL Server Platform Microsoft Dynamics GP 12 00 wv View By All Products Version Auto Reconciler for Encore Account Reconciler 1 001 Product ID 323 Product Key RE Status Not Registered About Support Product Website Check for updates EPM 12 00 02 042 4
25. window Transactions 22 Financial Encore Reconciler Auto Reconciler PA Auto Reconciler File Edit Tools Help sa Fabrikam Inc 4 12 2017 Checkbook ID Q Import ID Import File a File Type Document Number Date Payment Deposit Description Total Cancel Import 2 Enter or choose the checkbook ID that you want to match transactions against 3 Ensure that the import file displayed is the import ID that you linked to the selected checkbook in the Auto Reconciler Checkbook Setup window AUTO RECONCILER 27 m 28 USING AUTO RECONCILER 4 Choose the Import button to import the bank statement file PA Auto Reconciler File Edit Tools Help Checkbook ID FIRST BANK Q Import ID BANK IMPORT Import File count Heconc mo File Type Comma Delimited Document Number Date Payment Deposit Description Total Cancel Import 5 Choose Match to start the reconciling process checks will be matched by document number and payment amount Cleared with a difference is available only when using Auto Reconciler with Microsoft Dynamics GP Bank Reconciliation AUTO RECONCILER USING AUTO RECONCILER 6 The report destination dialog box will appear when the match reconciliation process is finished Report Destination Report Information Name Import Generic Exceptions Option Destination Steen Printer File Fi
Download Pdf Manuals
Related Search