ARP Translator Tool Overview Tour
For QuickBooks®
The Translator Tool is available when you need assistance retrieving your check issuance information from QuickBooks®. Once created, the file is uploaded via KeyNavigator to be used with Account Reconciliation services (ARP) and with Positive Pay.
Installing Translator Tool
You must login as an Administrator (or user with Administrator rights). To access the translator tool, click on the 'gear' icon in the Quicklinks segment of the Dashboard.
Installing Translator Tool
On the Customize Your Quicklinks modal window, scroll down to the Specialized Services segment and select File Translator. Then select the Done button.
Installing Translator Tool
Now you will see File Translator appear under the Quicklinks segment on the Dashboard. Select the File Translator quicklink.
Installing Translator Tool
Select the Download button to launch the Save As or Run box. You can choose either.
Installing Translator Tool
The installation welcome screen appears. Select Next to continue.
Installing Translator Tool
Follow the instructions in the Automated Business Banking Setup Wizard and subsequent modal windows. For detailed instructions, please reference the Translator Tool User Guide.
Using Translator Tool
Double click on the Key File Translator shortcut on your desktop to launch the tool. Enter your User ID and Password.
Using Translator Tool
At the main page, select the arrow next to File Translator to expand the menu. Then select Register Setup to view the accounts setup in the ARP Translator Tool. You can assign starting and ending check numbers in your initial file.
Using Translator Tool
Select Retrieve Check Issue Data to import checks from the QuickBooks® Check Register. Choose the account to import data from, using the dropdown menu. Select Retrieve Check Issue Data at the bottom when ready.
Using Translator Tool
The Retrieval Validation Results page displays all data pulled from QuickBooks. At the top is a summary of valid and invalid checks, as well as a file total in dollars and number of checks. Selecting the Reject Checks button at the bottom will remove the records from the Translator Tool and you can import the data again when ready. This is helpful if you need to narrow down the check range. When ready, select Accept Checks and the number of checks that have been accepted will be displayed.
Using Translator Tool
The Create Bank File page displays the file that will be exported. Select Browse at the bottom to choose a location to save the file.
Using Translator Tool
Select Export at the bottom to create the file in Key's format. A window will be displayed with File Created followed by the name of the file. Select OK to go back to the ARP File Translator page. The exported file is ready to be sent to Key.
For Non-QuickBooks®
The Translator Tool is available when you need assistance retrieving your check issuance information from your accounting package. Once created, the file is uploaded via KeyNavigator to be used with Account Reconciliation (ARP) and Positive Pay.
Installing Translator Tool
Select the File Translator quicklink on the Dashboard.
Installing Translator Tool
Select the Download button to launch the Save As or Run box. You can choose either.
Installing Translator Tool
Follow the instructions in the Automated Business Banking Setup Wizard and subsequent modal windows. For detailed instructions, please reference the Translator Tool User Guide.
Setup & Preferences
You can establish set-up and preferences in the ARP File Translator Tool. Select on the Accounts tab, which allows you to add accounts to the tool. You must include an account number and account name.
Setup & Preferences
Select OK to add the desired accounts.
Setup & Preferences
Select the arrow next to File Translator to expand the menu. The Rule Wizard will display the available rules and allow you to create, export load, edit, test and view the different rules. A rule must be established for each account setup in the file translator tool. For detailed instructions, please see the Translator Tool User Guide.
Using Translator Tool
Once the rule is created, select Import Check Issue Data to import a file with a rule. Browse to find the file you wish to import into the tool. Click on the file once to select it. Next, select the Import Rule. Select Import.
Using Translator Tool
After the tool examines the file, the File Validation Results page will be displayed. This is the summary of everything that the file contained. The Valid / Error column should display valid for all items. If not, see the Error Column.
Using Translator Tool
Double clicking on any record will open a detail modal window, and any errors will be displayed next to the field that contains the error.
Using Translator Tool
Once you have reviewed the file, and are ready to accept the checks, select Accept File. If there are errors that need to be corrected, such as incorrect date format, select Reject File.
Using Translator Tool
After accepting the checks, a modal window will be displayed, letting you know how many checks were accepted. Selecting OK will take you to the Create Bank File page.
Using Translator Tool
The Create Bank File page exports a text file to a specific directory to be sent to Key. Select Browse and save the file to a location that is easily accessible. We recommend you name the file with the date in the file name.