Sign On
  • KeyNavigator
    Sign On Form is Loading
  • CIS Online Brokerage CIS Login

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.